The URL can be used to link to this page

01-OCTOBER 2012 FINANCIAL STATEMENT OCTOBER 2012 Financial Report C I T Y OF S C H E R T Z Prepared By: The Finance Department February 19, 2013 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2012 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEAR FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUAL REVENUE SUMMARY Taxes 13,247,165671,995.061,896,827.98 Franchises1,665,7638,674.02116,294.19 Permits1,051,84075,192.0083,146.00 Licenses70,2004,957.502,380.00 Fees2,997,169266,009.61168,009.64 Fines25,0002,823.882,346.04 Inter-Jurisdictional640,16726,365.5726,484.21 Fund Transfers1,950,742142,678.25108,750.59 Miscellaneous455,54734,073.14114,584.57 TOTAL REVENUES22,103,5931,232,769.032,518,823.22 EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services22,6061,065.031,481.26 Supplies40057.30- City Support Services31,50048.00269.98 Operations Support500-- Staff Support20,8502,573.002,800.01 Operating Equipment700-- TOTAL CITY COUNCIL76,5563,743.334,551.25 CITY MANAGER Personnel Services924,28052,212.5845,733.92 Supplies4,100-147.88 Operations Support100-- Staff Support39,5504,587.621,098.75 Operating Equipment--- TOTAL CITY MANAGER968,03056,800.2046,980.55 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2012 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEAR FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUAL MUNICIPAL COURT Personnel Services281,30014,884.2415,391.29 Supplies3,000415.45164.83 City Support Services1,000-- Operations Support3,500-- Staff Support7,100-385.20 Court Support800-- Professional Services65,2504,405.254,882.50 Maintenance Services2,800-- Operating Equipment800-- TOTAL MUNICIPAL COURT365,55019,704.9420,823.82 CUSTOMER RELATIONS-311 Personnel Services107,8535,780.155,089.28 Supplies200-- Staff Support1,750-- Operating Equipment500-- TOTAL CUSTOMER RELATIONS-311110,3035,780.155,089.28 PLANNING & ZONING Personnel Services140,9737,887.198,169.56 Supplies2,850-161.45 Operations Support750-- Staff Support16,160(23.83)300.00 Professional Services25,150-- Operating Equipment--- TOTAL PLANNING & ZONING185,8837,863.368,631.01 LEGAL SERVICES Operations Support12,000-- Professional Services348,000-- TOTAL LEGAL SERVICES360,000-- C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2012 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEAR FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUAL FACILITIES MAINTENANCE Personnel Services563,70342,169.7531,290.44 Supplies65,8972,795.251,574.19 Utility Services106,448-1,707.16 Staff Support12,09924.00108.24 Maintenance Services64,4126,194.15673.05 Operating Equipment4,950-- Capital Outlay--- TOTAL FACILITIES MAINTENANCE817,50951,183.1535,353.08 BUILDING 6-8 MAINTENANCE Supplies28,400-- Utility Services91,7004.47- Maintenance Services67,700350.00- Operating Equipment9,600-- TOTAL FACILITIES MAINTENANCE197,400354.47- CITY SECRETARY Personnel Services168,5069,428.379,811.60 Supplies1,25023.8057.30 City Support Services7,500-- Staff Support7,85018.00- TOTAL CITY SECRETARY185,1069,470.179,868.90 NON-DEPARTMENTAL Supplies--- City Support Services450,000132,598.265,325.00 Operations Support154,5006,432.327,965.91 City Assistance699,43398,957.4296,046.91 Professional Services165,22022,269.882,410.57 Fund Chrgs/Transfrs-Spec Events Fnd55,000-- Capital Outlay--- TOTAL NON-DEPARTMENTAL1,524,153260,257.88111,748.39 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2012 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEAR FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUAL PUBLIC AFFAIRS Personnel Services286,25316,349.2612,939.87 Supplies3,500-57.81 Operations Support27,1001,868.79- Staff Support5,9009.24196.44 TOTAL PUBLIC AFFAIRS322,75318,227.2913,194.12 RECORDS MANAGEMENT Personnel Services48,1442,725.542,858.77 Supplies400-- Staff Support1,560-- Professional Services12,000191.00- TOTAL RECORDS MANAGEMENT62,1042,916.542,858.77 SCHERTZ TALES MAGAZINE Personnel Services130,5607,686.108,077.96 Supplies200-- Opperations Support200-- Staff Support2,005-- Professional Services300,700115,425.0012,569.94 Fund Charges/Transfers10,000-- TOTAL SCHERTZ TALES MAGAZINE443,665123,111.1020,647.90 ENGINEERING Personnel Services258,7096,967.186,031.69 Supplies1,100-28.65 Utility Services1,440-- Staff Support6,741-- Professional Services43,000-1,425.00 Maintenance Services--- Operating Equipment5,216-- Capital Outlay--- TOTAL ENGINEERING316,2066,967.187,485.34 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2012 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEAR FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUAL GIS Personnel Services128,3567,456.497,299.12 Supplies2,800-- Staff Support2,725-- Professional Services1,500-- TOTAL GIS135,3817,456.497,299.12 TOTAL GENERAL GOVERNMENT6,070,599573,836.25294,531.53 PUBLIC SAFETY POLICE Personnel Services4,677,560240,057.91266,138.82 Supplies41,59319.951,661.01 City Support Services25,80020,657.01- Utility Services133,735-- Operations Support1,750-90.00 Staff Support57,2011,054.502,515.60 City Assistance9,765-- Professional Services28,337200.00- Maintenance Services48,740690.00- Operating Equipment139,100-14,410.65 Capital Outlay147,831-- TOTAL POLICE 5,311,412262,679.37284,816.08 FIRE RESCUE Personnel Services2,593,286204,507.17149,147.62 Supplies16,200155.329,276.23 Utility Services51,500-7.64 Operations Support1,200-- Staff Support113,80011,644.7722,703.10 City Assistance16,200-2,758.50 Professional Services17,000-- Maintenance Services49,900169.753,565.81 Operating Equipment59,100-1,987.29 Capital Outlay--- TOTAL FIRE 2,918,186216,477.01189,446.19 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2012 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEAR FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUAL INSPECTIONS Personnel Services428,70024,512.6224,657.57 Supplies2,63891.54142.32 Utility Services6,500-- Operations Support1,500-- Staff Support6,600360.43551.76 Professional Services8,890-- Operating Equipment500-- TOTAL INSPECTIONS 455,32824,964.5925,351.65 MARSHAL SERVICE Personnel Services545,21932,944.0831,639.64 Supplies4,30033.69285.10 Utility Services16,000-- Operations Support4,000-- Staff Support11,60065.872,257.08 Maintenance Services16,500505.00- Operating Equipment21,000-4,602.17 Capital Outlay--- TOTAL MARSHAL SERVICE618,61933,548.6438,783.99 TOTAL PUBLIC SAFETY9,303,545537,669.61538,397.91 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2012 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEAR FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUAL PUBLIC ENVIRONMENT STREETS Personnel Services688,83452,709.6240,461.97 Supplies7,100118.3221.04 Utility Services121,900476.804,414.30 Staff Support10,265528.25172.17 Maintenance Services180,4002,091.98930.75 Rental/Lease200-- Operating Equipment3,500-- TOTAL STREETS 1,012,19955,924.9746,000.23 TOTAL PUBLIC ENVIRONMENT1,012,19955,924.9746,000.23 PARKS & RECREATION PARKS DEPARTMENT Personnel Services503,32732,306.0528,794.84 Supplies41,905878.25755.91 Utility Services143,800892.507,427.19 Operations Support350-- Staff Support8,823395.2360.93 Professional Services45,610-5,496.50 Maintenance Services19,500-44.99 Rental/Leasing44,000-- Operating Equipment3,000-- TOTAL PARKS DEPARTMENT810,31534,472.0342,580.36 SWIM POOL Supplies20,700194.50- Utility Services29,000101.802,289.15 Staff Support925-750.00 Maintenance Services203,3782,200.004,000.00 Rental/Lease500-- TOTAL SWIM POOL254,5032,496.307,039.15 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2012 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEAR FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUAL EVENT FACILITIES Personnel Services56,5352,948.283,027.36 Supplies27,00010.921,127.61 Utility Services48,200-359.61 Operations Support27,332-- Staff Support2,727-439.45 Professional Services1,600-150.00 Operating Equipment--- TOTAL COMMUNITY/CIVIC CNTR163,3942,959.205,104.03 TOTAL PARKS & RECREATION1,228,21239,927.5354,723.54 CULTURAL LIBRARY Personnel Services704,94036,194.3442,882.17 Supplies12,000828.71136.54 Utility Services51,000-1,342.36 Operations Support3,500-174.00 Staff Support4,040-104.32 Professional Services2,225-- Maintenance Services2,400-400.00 Operating Equipment75,00098.96188.08 TOTAL LIBRARY855,10537,122.0145,227.47 TOTAL CULTURAL855,10537,122.0145,227.47 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2012 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEAR FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUAL HEALTH ANIMAL SERVICES Personnel Services300,10816,128.3517,749.57 Supplies23,5002,087.50350.89 Utility Services11,200100.8587.26 Operations Support500-- Staff Support12,760-655.48 City Assistance13,500-- Professional Services13,500-- Maintenance Services7,280-2,340.00 Operating Equipment9,000-723.93 TOTAL ANIMAL SERVICES391,34818,316.7021,907.13 TOTAL HEALTH391,34818,316.7021,907.13 INTERNAL SERVICE INFORMATION TECHNOLOGY Personnel Services274,64016,310.7816,557.52 Supplies3,000-- City Support Services395,7626,840.00450.00 Utility Services167,866-3,866.12 Staff Support18,250254.311,957.64 Professional Services2,500-- Maintenance Services8,000-- Operating Equipment106,500-3,207.62 Capital Outlay--- TOTAL INFORMATION TECHNOLOGY976,51823,405.0926,038.90 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2012 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEAR FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUAL HUMAN RESOURCES Personnel Services311,71015,460.0212,923.08 Supplies1,329-122.30 Human Services55,1561,267.00654.00 Operations Support16,596-532.56 Staff Support14,897-550.72 City Assistance9,860-- Operating Equipment--390.03 TOTAL HUMAN RESOURCES409,54816,727.0215,172.69 FINANCE Personnel Services443,30624,990.3227,357.38 Supplies3,5004.1011.71 Operations Support300-- Staff Support16,06080.00- Rental/Leasing2,230-- Operating Equipment--266.47 TOTAL FINANCE465,39625,074.4227,635.56 PURCHASING & ASSET MGT Personnel Services247,93613,933.4614,494.09 Supplies95035.19- Utility Services600-- Operations Support100-- Staff Support7,875-65.00 Operating Equipment250-- TOTAL PURCHASING & ASSET MGT257,71113,968.6514,559.09 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2012 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEAR FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUAL FLEET SERVICE Personnel Services218,52811,120.4110,651.34 Supplies143,65018,773.532,972.15 City Support Services2,400-- Utility Services7,200-- Operations Support400-- Staff Support4,500-637.81 Maintenance Services65,7505,681.541,583.76 Rental/Lease200-- Operating Equipment5,000-- TOTAL FLEET SERVICE447,62835,575.4815,845.06 BUILDING MAINTENANCE Personnel Services75,142-- Supplies43-- Utility Services2,952-- Staff Support356-- Maintenance Services49,888-- Rental/Leasing1,400-- Capital Outlay60,000-- TOTAL PURCHASING & ASSET MGT189,781-- TOTAL INTERNAL SERVICE2,746,582114,750.6699,251.30 MISC & PROJECTS CITY ASSISTANCE Patient Assistance5,000-- Children's Advocacy Assistance5,000-- Senior Citizen's Hot Meals42,00010,500.00- TOTAL CITY ASSISTANCE52,00010,500.00- COURT - RESTRICTED FUNDS Operating Equipment51,053-- TOTAL CITY ASSISTANCE51,053-- C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2012 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEAR FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUAL TOTAL MISC & PROJECTS103,05310,500- TOTAL EXPENDITURES 21,710,643 1,388,047.731,100,039.11 REVENUE OVER(UNDER) EXPEND.392,950 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2012 ************************************************ 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEAR REVENUESBUDGETPERIODY-T-D ACTUAL Taxes 000-411100Advalorem Tax - Current7,481,207292,988.311,540,041.13 000-411200Advalorem Tax - Delinquent50,0004,336.845,571.51 000-411300Advalorem Tax - P&I50,0002,622.621,934.50 000-411500Sales Tax Revenue-Gen Fund5,637,958364,538.15342,250.77 000-411700Mixed Beverage Tax28,000.007,509.147,030.07 TOTAL Taxes 13,247,165671,995.061,896,827.98 Franchises 000-421200Center Point/Entex Energy58,763-4,420.56 000-421220City Public Service375,000-28,841.32 000-421240Guadalupe Valley Elec Co-op430,000-30,532.88 000-421250New Braunfels Utilities50,000-3,605.93 000-421300Time Warner-State Franchise350,000-28,882.83 000-421460AT&T Franchise Fee190,000-14,928.48 000-421480Other Telecom Franchise110,000-87.31 000-421500Solid Waste Franchise Fee102,0008,674.024,994.88 TOTAL Franchises1,665,7638,674.02116,294.19 Permits 000-431100Home Occupation Permit490105.0035.00 000-431205Building Permit - Residential408,61835,744.0042,558.00 000-431210Building Permit - Commercial203,149-- 000-431215Building Permit - General118,7148,949.006,100.00 000-431300Mobile Home Permit325-- 000-431400Signs Permit1,700630.00140.00 000-431500Food Establishmnt Permit33,0006,570.007,325.00 000-431600Garage Sale Permit8,1601,700.001,290.00 000-431700Plumbing Permit117,3247,484.0013,078.00 000-431750Electrical Permit45,0204,860.004,360.00 000-431800Mechanical Permit48,4404,320.004,860.00 000-431900Solicitor/Peddler Permit1,000240.00120.00 000-431950Animal/Pet Permit2,000190.00265.00 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2012 ************************************************ 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEAR REVENUESBUDGETPERIODY-T-D ACTUAL 000-432000Cert. of Occupancy Prmt10,900600.00250.00 000-432100Security Alarm Permit45,0002,675.002,090.00 000-435000Fire Permit8,0001,125.00675.00 TOTAL Permits1,051,84075,192.0083,146.00 Licenses 000-441000Alcohol Beverage License6,000627.5090.00 000-441300Mobile Home License200-- 000-442000Contractors License60,0003,965.001,990.00 000-444000Pet License4,000365.00300.00 TOTAL Licenses70,2004,957.502,380.00 Fees 000-451000Municipal Court Fines1,610,000127,940.4873,584.45 000-451100Arrest Fee52,7345,339.433,270.04 000-451110Expunction Fee120-- 000-451200Warrant Fees138,50013,243.458,608.00 000-451210Court - Claims & Judgements--1,842.23 000-451320Civil Justice Fee-Court828.374.96 000-451321Civil Justice Fee-State73775.2545.06 000-451340Judicial Fee - City7,022713.92433.95 000-451400Traffic Fine Costs TTL27,0112,710.101,668.67 000-451500Teen Court Admin Fee50040.00100.00 000-451510Juvenile Case Mgmt Fee58,5825,964.433,625.93 000-451600Technology Fund Fee47,1224,768.792,954.84 000-451700Security Fee34,3403,576.582,216.16 000-451800Time Payment Fee - City5,598386.41523.59 000-451850State Fines 10% Service Fee61,20425,205.8513,466.72 000-451900DPS Payment - Local10,9561,185.04734.14 000-452000Child Safety Fee23,0001,438.122,933.98 000-452050Indigent Defense Fee22,5242,351.771,393.53 000-452100Platting Fees77,0003,000.001,500.00 000-452200Site Plan Fee30,0003,000.00- 000-452300Plan Check Fee289,40120,922.5023,377.50 000-452310Miscellaneous Review Fee10,800-- 000-452320Tree Mitigation Admin Fee10,500-- 000-452400BOA/Zoning Fees6,500-- 000-452500Food Handler Class3,0002,800.00770.00 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2012 ************************************************ 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEAR REVENUESBUDGETPERIODY-T-D ACTUAL 000-452520Fire Training Classes1,000-- 000-452600Specific Use/Zone Chng Fee47,700-2,850.00 000-452710Zoning Ltr & Dev Rights2,100150.00150.00 000-453100Reinspection Fees39,5007,125.004,475.00 000-453110Swim Pool Inspection Fee1,000-- 000-453200Lot Abatement5,0003,377.79315.00 000-453211Admin Fee-Inspections7,480400.00400.00 000-453310Misc Inspection Fee250-19.49 000-453710Foster Care750150.00150.00 000-454100Swim Pool Reservation Fee--55.00 000-454200Pool Gate Admission Fee20,000-- 000-454300Seasonal Pool Pass Fee7,500-- 000-456500Haz Mat Fees1,500-- 000-456600Fire Re-inspection Fee750150.00150.00 000-458100Sale of Merchandise--- 000-458300Sale of Property/Auction25,000170.381,183.15 000-458400Civic Center Rental Fees132,20015,005.257,050.25 000-458401Capital Recovery Fee-Civic Cntr4,800722.00405.00 000-458450North Center Rental Fees23,0002,255.003,380.00 000-458500Community Center Rental Fees26,0002,712.40740.50 000-458550Pavilion Rental Fees18,0001,855.001,587.00 000-458560Chamber of Comm rent11,700-- 000-458570Non-Resident SYSA League19,000-- 000-458650NonResident User Fee-BVYA17,0003,340.00- 000-458660BVYA Utility Reimbursement5,000-- 000-458670SYSA Utility Reimbursement7,500-- 000-458675Lions Futbol Utility Reimbursement-1,172.00- 000-458680Tournament Fees-Soccer3,000-- 000-458700Vehicle Impoundment5,779-- 000-459200NSF Check Fee250-- 000-459300Notary Fee25024.006.00 000-459400Maps, Copies, UDC, & Misc F2505.00- 000-459600Animal Adoption Fee14,0001,045.00427.50 000-459700Pet Impoundment Fee14,0001,152.001,102.00 000-459800Police Reports Fee8,677528.30510.00 TOTAL Fees2,997,169266,009.61168,009.64 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2012 ************************************************ 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEAR REVENUESBUDGETPERIODY-T-D ACTUAL Fines 000-463000Library Fines25,0002,823.882,346.04 TOTAL Fines25,0002,823.882,346.04 Inter-Jurisdictional 000-473100Bexar Co - Fire21,0721,756.481,756.48 000-473200City of Seguin - Fire Contract31,4523,355.263,355.26 000-473300Guad Co - Library208,34315,901.3315,901.33 000-473400Randolph AFB-Animal Cntrl 1,000-- 000-474200Library Services - Cibolo20,000-- 000-474210Library Services-Selma18,393-- 000-474400Dispatch Service - Cibolo133,305-- 000-474600School Crossing Guard-Bexar27,0002,768.132,726.46 000-474610School Cross Guard-Guadalupe24,6022,584.372,744.68 000-474700School Officer Funding155,000-- TOTAL Inter-Jurisdictional640,16726,365.5726,484.21 Fund Transfers 000-480000Indirect Costs - EMS87,8407,320.007,320.00 000-480100Indirect Costs - Hotel/Motel157,51713,126.4211,885.50 000-481000Transfer From Reserves--- 000-485000Interfund Charge-Drainage49,7084,142.333,486.25 000-486000Interfund Chrges-Admin W&S1,060,96388,413.5873,435.17 000-486000Transfer In-W&S80,000-- 000-486322Transfer-In - Library Grants--- 000-487000Interfund Charges-Fleet112,7619,396.758,207.00 000-488000Interfund Charges-4B243,35020,279.174,416.67 000-489000Transfer In158,603-- 000-490020Transfer In-SEDC--- TOTAL Fund Transfers1,950,742142,678.25108,750.59 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2012 ************************************************ 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEAR REVENUESBUDGETPERIODY-T-D ACTUAL Miscellaneous 000-491000Interest Earned35030.4915.05 000-491200Investment Income45,0003,442.562,916.47 000-491800Gain/Loss--- 000-491900Unrealized Gain/Loss(26,000)(3,110.40)(1,533.90) 000-492100Proceeds-Sale of Land--57,867.85 000-493130Donations-Writing the Next Chap.2,00050.00114.00 000-493400Donation - Animal Control4,000329.0055.02 000-493401Donations-A/C Microchip2,000135.00100.00 000-493402Donations-Spay&Neuter12,000707.00606.00 000-493503Donations - Fire Rescue-150.00- 000-494481LawEnforcemtOfficersStnd&Ed--- 000-494482Grants - Police2,997-- 000-495040Friends of N. Schertz Park-685.00- 000-495100Mobile Stage Rental Fees2,000-- 000-497000Misc Income-Gen Fund50,0001,756.33(8,560.50) 000-497005Schertztales Advertising220,00017,741.0020,641.00 000-497100Misc Income-Police20,000474.50468.90 000-497150Misc Income-Fire Department-292.37- 000-497200Misc Income-Library4,000398.75426.30 000-497210Misc Income-Library Copier12,0001,542.201,005.26 000-497300Misc Income-Animal Control200-105.00 000-497400Misc Income-Streets Dept.15,0003,380.392,922.00 000-497500Misc Income-TML Insurance2,000-- 000-497550Misc Income-TML Reimbursemt15,0004,584.46- 000-497600Misc Income-Parks/Vending Mach.2,000165.09232.10 000-498000Reimbursmnt-Gen Fund50,0001,319.407,908.00 000-498100Reimbursmnt Fire - Training1,000-- 000-498105Reimburmnt Police - DEA--- 000-498110Reimbursmnt Fire - Emg. Acti-O20,000-29,296.02 TOTAL Miscellaneous455,54734,073.14114,584.57 TOTAL REVENUES 22,103,593 1,232,769.032,518,823.22 GENERAL FUND CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking$ 364,027.38 Cash in Investments LOGIC Investment-General Fund662,750.65 LOGIC Investment-Equip Replacement73,482.52 LOGIC Investment-Veh Replacement102,513.61 LOGIC Investment-Air Condi Replacment146,713.97 CAPITAL ONE Investment-General Fund1,341,312.31 Total Cash in Bank & Investments$ 2,837,382.28 ADVALOREM TAX OCTNOVDECJANFEBMARAPRMAYJUNJUL 2012-13 292,988 2011-12 1,540,041228,9242,439,1231,871,054635,71964,19027,87829,91918,03926,509 2010-11 1,406,160244,2552,331,4871,725,242735,329174,68737,34143,10815,12026,143 2009-10 1,277,0061,642,355702,8741,730,904562,689(32,792)59,54534,76219,83629,955 2008-09 703,3501,823,090757,6021,345,602699,462114,53710,51445,08736,65925,468 Sales Tax -General Fund $700,000 $600,000 $500,000 2% $400,000 $300,000 $200,000 $100,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJUL 2012-13 439,433 2011-12 428,995463,636339,192415,822461,400365,083347,395535,930398,080408,851 2010-11 339,709332,264347,605353,229470,399324,575283,300425,848408,664342,513 2009-10 300,384338,514281,259288,350477,063293,178273,874366,704350,314324,169 2008-09 332,597414,845371,763300,829434,646298,499282,410394,233317,296310,159 2007-08 336,749350,854312,547327,798421,873330,131287,316355,054336,094328,147 CITY PUBLIC SERVICE üïîðôððð üïððôððð üèðôððð üêðôððð üìðôððð üîðôððð üó ÑÝÌÒÑÊÜÛÝÖßÒÚÛÞÓßÎßÐÎÓßÇÖËÒÖËÔ îðïîóïí îðïïóïî çêôíçîéêôìïìééôíçè îðïðóïï èíôìííêîôêçîêéôëêï îððçóïð ééôíëìêïôìêèêíôîéê îððèóðç ééôíðèëíôðéïëéôëðê C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2012 ************************************************** 2 0 1 2 - 2 0 1 3 ************************************************** 106-SPECIAL EVENTS FUND CURRENTCURRENTPRIORCURRENTY-T-DBUDGET8.33% OF FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fund Transfers 75,150.00 - - - - 75,150.00 Wilenchik Walk for Life 31,000.00 - - - - 31,000.00 Hal Balwin Scholarship 24,000.00 18,085.00- - - 5,915.00 Miscellaneous18,093.437.758.43 1,150.00 - TOTAL REVENUES131,300.00 18,093.43 7.75 18,093.43 - 113,206.57 10.25% EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental5,150.00-- - - TOTAL GENERAL GOVERNMENT5,150.00 - - - - 5,150.00 0.00% CULTURAL Other Events4,750.00-- - - 4,750.00 Festival of Angels 14,750.00 - 595.97- 14,154.03 - Employee Appreciation Event 6,000.00 - - - - 6,000.00 National Night Out 150.00 - - - - 150.00 Wilenchik Walk for Life 31,000.00 - - - - 31,000.00 Schertz Sweetheart 37,500.00 500.00 35.29 500.00 36,713.44286.56 Jazzfest 20,000.00 - - - - 20,000.00 Hal Baldwin Scholarship6,235.40-6,235.401,210.554,554.05 12,000.00 TOTAL CULTURAL126,150.006,735.40 35.29 6,735.40 2,093.08 117,321.52 TOTAL EXPENDITURES131,300.00 6,735.40 35.29 6,735.40 2,093.08 122,471.52 6.72% REVENUE OVER(UNDER) EXPEND11,358.03 - SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking57,523.29$ Cash in Investments MBIA Special Events46,700.50 Total Cash in Bank & Investments$104,223.79 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2012 ************************************************** 2 0 1 2 - 2 0 1 3 ************************************************** 110-PEG FUND CURRENTCURRENTPRIORCURRENTY-T-DBUDGET8.33% OF FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Franchises 98,000.00 - - - - 98,000.00 Fund Transfers 33,000.00 - - - - 33,000.00 Miscellaneous12.49- - - - - TOTAL REVENUES131,000.00 - 12.49 - - 131,000.00 0.00% EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental131,000.00--7,500.00123,500.00 - TOTAL GENERAL GOVERNMENT131,000.00 - - - 7,500.00 123,500.00 0.00% TOTAL EXPENDITURES131,000.00 - - - 7,500.00 123,500.00 5.73% REVENUE OVER(UNDER) EXPEND- - C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2012 ************************************************** 2 0 1 2 - 2 0 1 3 ************************************************ 110-PEG FUND CURRENTCURRENTPRIOR YEARCURRENTY-T-DBUDGET8.33% OF REVENUESBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Franchises 000-421350Time Warner - PEG Fee - - 65,000 - -65,000.00 000-421465T&T PEG Fee-- A 33,000 - - 33,000.00 TOTAL Franchises - - 98,000 - -98,000.00 Fund Transfers 000-481000Transfer In - Reserves-- 33,000 - - 33,000.00 TOTAL Fund Transfers - - 33,000 - -33,000.00 Miscellaneous 000-491000Interest Earned12.49- - - - - TOTAL Miscellaneous 12.49 - - - - - 0.00% TOTAL REVENUES12.49- 131,000 - -131,000.00 PEG FUND CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2012 Cash in Bank Cash Balance386,582.22$ Total Cash in Bank & Investments$386,582.22 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2012 ******************************************************* 2 0 1 2 - 2 0 1 3 ***************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARY-T-DY-T-DBUDGET8.33% OF FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Franchises187,920 31,014.33-- 187,920.00- Fees14,655,3761,568,293.991,526,018.171,568,293.99 13,087,082.01- Fund Transfers1,419,2989,941.507,056.179,941.50 1,409,356.50- Miscellaneous31,501.52150,382.91 -31,501.52398,646.48 430,148 TOTAL REVENUES16,692,7421,609,737.011,714,471.58 -1,609,737.0115,083,004.99 EXPENDITURE SUMMARY BUSINESS OFFICE Personnel Services436,69418,719.3522,326.4718,719.35 417,974.65- Supplies4,600229.20418.33229.20177.94 Human Services100---- City Support Services1,000---- Operations Support110,0003,778.46(1,820.00)3,778.4623.04106,198.50 Staff Support7,150-94.26-43.30 Professional Services23,0001,816.052,459.811,816.05 21,183.95- Fund Charges/Transfers20,000--- 20,000.00- Maintenance Services11,000-420.00 9,040.00- Operating Equipmen500.00- t 2,300 - - TOTAL BUSINESS OFFICE24,543.0624,398.8724,543.069,284.28582,016.66 615,844 W & S ADMINISTRATION Personnel Services1,184,01362,954.6365,870.5062,954.63 1,121,058.37- Supplies199,0505,185.283,852.085,185.2823,491.30170,373.42 Human Services1,000---- City Support Services77,50032,459.83 32,459.83- 45,040.17- Utility Services2,727,313496.80266,736.26496.80 2,726,394.57421.27 Operations Support9,250256.01-256.01- Staff Support31,500381.56376.44381.561,242.03 City Assistance1,912---- Professional Services212,400840.0062,028.66840.00130.00211,430.00 Fund Charges/Transfers3,137,04792,709.25289,996.9492,709.25 3,044,337.75- Maintenance Services5,586,250166,380.98215,616.29166,380.9876,473.975,343,395.05 Other Costs40,000-- 1,250.00- C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2012 ******************************************************* 2 0 1 2 - 2 0 1 3 ***************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARY-T-DY-T-DBUDGET8.33% OF FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Debt Service1,353,891--- 1,353,890.52- Rental-Leasing6,070---- Operating Equipment6,000237.50-237.50520.00 Capital Outla--188,000.00 y 188,000 - - TOTAL PUBLIC WORKS14,761,195361,901.84904,477.17361,901.84103,528.5714,295,764.753.15% MISC & PROJECTS PROJECTS Maintenance Services--4,256.00897,744.00 902,000 - TOTAL PROJECTS- 4,256.00-897,744.00 902,000 - AVIATION HEIGHTS WTR IMPROVEMNTS City Support Services17,000--- 17,000.00- Operations Support500---- Professional Services48,000--- 48,000.00- Maintenance Services--334,500.00 334,500 - - -- TOTAL AVIATION HEIGHTS WTR IMP 400,000 - -400,000.00 TOTAL MISC & PROJECTS- 4,256.00-1,297,744.00 1,302,000 - TOTAL EXPENDITURES16,679,039386,445928,876 117,069386,44516,175,525 1,223,292.11 ** REVENUE OVER(UNDER)EXPENSES ** 13,703 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2012 ******************************************************* 2 0 1 2 - 2 0 1 3 *************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARY-T-DY-T-DBUDGET8.33% OF REVENUESBUDGETPERIODY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Franchises 31,014.33- 000-421490Tower Leasing187,920 - - TOTAL Franchises 187,920 31,014.33- - - 187,920.00 Fees 000-455200Garbage Collection Fee 3,600,000 329,570.74 321,926.50 329,570.74 - 3,270,429.26 000-455600Fire Line Fees 20,000 20,635.00 19,350.00 20,635.00 103.18% - 000-455700Recycle Fee Revenue 250,000 27,447.20 23,060.81 27,447.20 - 222,552.80 000-455800W&S Line Constructn Reimbursemnt30,000 1,864.82 4,171.08 1,864.82 - 28,135.18 000-457100Sale of Water 7,279,626 813,388.63 828,590.30 813,388.63 - 6,466,237.37 000-457110Edwards Water Lease 166,250 - 6,617.50 - - 166,250.00 000-457120Water Transfer Charge-Selma 20,000 13,929.28 1,376.83 13,929.28 - 000-457130Water Transfer Charge-U. C. 2,000 1,766.40 2,199.97 1,766.40 - 000-457140Water Transfer Charge-Converse 15,000 10,649.44 10,649.44- - 000-457200Sale of Meters 90,000 4,178.00 7,731.58 4,178.00 - 85,822.00 000-457400Sewer Charges 3,000,000 329,691.01 292,249.78 329,691.01 - 2,670,308.99 000-457500Water Penalties 180,000 15,033.47 18,513.82 15,033.47 - 164,966.53 000-459200NSF Check Fee-Water&Sewer2,500140.00230.00140.00 - TOTAL Fees14,655,3761,568,293.99 1,526,018.17 1,568,293.99 - 13,087,082.01 Fund Transfers 000-481000Transfer In- Reserve 1,300,000 - - - - 1,300,000.00 000-486100Transfer In - - - 0.00% - - 9,941.507,056.179,941.50 000-486204Interfnd Chrg-Drainage Bill119,298 - TOTAL Fund Transfers 1,419,298 9,941.50 7,056.17 9,941.50 - 1,409,356.50 Miscellaneous 000-490000Misc Charges 200 - - - - 000-491000Interest Earned 1,600 151.50 184.01 151.50 - 000-491200Investment Income 12,000 - 430.83 - - 12,000.00 000-493400Donations-Christmas Activities - - - 0.00% - - 000-496050SSLG - SAWS Reservation 269,000 134,500.00- - - 269,000.00 000-497000Misc Income-W&S 40,000 4,847.91 15,268.07 4,847.91 - 35,152.09 000-498100Reimbursement-EMS Loan - - - 0.00% - - 000-498110Reimbursement-SSLGC107,34826,502.11-26,502.11 - TOTAL Miscellaneous 430,148 31,501.52 150,382.91 31,501.52 - 398,646.48 TOTAL REVENUES16,692,7421,609,737.01 1,714,471.58 1,609,737.01 - 15,083,004.99 WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking151,298.19$ Cash in Investments Lone Star Investment-Water&Sewer 1,361,085.36 Lone Star Investment-W&S Customer Deposits294,407.26 Lone Star Investment-W&S Equip Replacement374,011.38 Lone Star Investment-W&S Veh Replacement 545,353.31 Lone Star Investment-Water/SSLGC SAWS 404,475.11 Schertz Bank & Trust-Certificate of Deposit1,055,908.62 $4,035,241.04 Total Cash in Bank & Investments4,186,539.23$ C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2012 *************************************************** 2 0 1 2 - 2 0 1 3 ************************************************* 203-EMS CURRENTCURRENTPRIOR YEARY-T-DY-T-DBUDGET8.33% OF FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fees4,149,402 354,103.75 255,491.98 354,103.75 3,795,598.25(300.00) Inter-Jurisdictional1,486,723 299,521.28 159,751.52 299,521.28 - 1,187,201.72 Miscellaneous8,832.634,236.93 -8,832.63227,667.37 236,500 TOTAL REVENUES 662,457.66 419,480.43 662,457.66 (300.00) 5,210,467.34 11.28% 5,872,625 EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services2,815,722185,668.08160,998.68185,668.08 - 2,630,053.94 Supplies 12,620.66 38,221.41 12,620.66 44,124.70 288,343.64 345,089 Human Services - - 800 - - City Support Services 14,035.29 14,035.29- 32,500 - 18,464.71 Utility Services 462.35 15.00- 107,585.00 107,600 - Operations Support 2,769.82 20,148.67 2,769.82 1,660.47 40,721.71 45,152 Staff Support 1,750.00 1,071.47 1,750.00 17,417.07 41,732.93 60,900 City Assistance - - 9,200 - - 9,200.00 Professional Services 29,604.43 19,792.76 29,604.43 7,519.12 129,812.45 166,936 Fund Charges/Transfers1,980,055 86,950.10 116,123.46 86,950.10 - 1,893,104.90 Maintenance Services 450.00 300.00 12,210.00450.00 41,040.00 53,700 Debt Service - - 110,545 - - 110,544.67 Rental-Leasing - - 12,000 - - 12,000.00 Operating Equipment 115,658.75- 1,341.25 117,000 -15,397.65 Capital Outlay-- - - - - TOTAL PUBLIC SAFETY 333,848.38 372,516.45 333,848.38 198,605.11 5,324,745.20 9.09% 5,857,199 TOTAL EXPENDITURE5,857,199333,848.38372,516.45 198,605.11333,848.385,324,745.20 S ** REVENUE OVER(UNDER) EXPENSES 328,609.28 * 15,426 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2012 *************************************************** 2 0 1 2 - 2 0 1 3 ************************************************* 203-EMS CURRENTCURRENTPRIOR YEARY-T-DY-T-DBUDGET8.33% OF REVENUESBUDGETPERIODY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fees 000-456100Ambulance/Mileage Transprt3,908,602 354,083.75 254,251.98 354,083.75 - 3,554,518.25 000-456110Subscription Program Fees 40,000 20.00 - - - 40,000.00 000-456120EMT Class - Fees 100,800 200.00 (300.00)- 101,100.00 - 000-459200Paramedic Class Fees 100,000 - - 100,000.00 - 000-456130Immunization Fees 1,020.00 - 0.00% - - - 000-459200NSF Check Fee20.00- -20.00(20.00) - TOTAL Fees4,149,402354,103.75 255,491.98 354,103.75 3,795,598.25(300.00) Inter-Jurisdictional 000-473500Seguin/Guadalupe Co Support286,126 - - 23,844.04 - 286,126.00 000-474300Cibolo Support 228,830 57,207.55 55,524.98 57,207.55 - 171,622.45 000-475100Comal Co ESD #6 20,726.4885,418 6,908.82 20,726.48 - 64,691.52 000-475200Live Oak Support 165,188 41,296.99 41,296.99- - 123,891.01 000-475300Universal City Support 233,107 58,276.85 56,562.83 58,276.85 - 174,830.15 000-475400Selma Support 17,423.3069,693 16,910.85 17,423.30 - 52,269.70 000-475500Schertz Support 395,830 98,957.42 98,957.42- - 296,872.58 000-475600Santa Clara Support 2,280.129,121 2,280.12- - 6,840.88 000-475800Marion Support3,352.57- -3,352.5710,057.43 13,410 TOTAL Inter-Jurisdictional1,486,723299,521.28 159,751.52 299,521.28 - 1,187,201.72 Miscellaneous 000-491200Investment Income50054.3934.8054.39445.61 - 000-493203Donations-EMS 4,000 106.00 25.00 106.00 - 3,894.00 000-493204Donations-Dilworth Fund 2,000 - - - - 2,000.00 000-493205Donations- Golf Tournament - - 0.00% - - - 000-497000Misc Income 130,000 7,287.24 4,177.13 7,287.24 - 122,712.76 000-497100Recovery of Bad Debt1,385.00- -1,385.0098,615.00 100,000 TOTAL Miscellaneous 236,500 8,832.63 4,236.93 8,832.63 - 227,667.37 TOTAL REVENUES5,872,625662,457.66419,480.43662,457.66 5,210,467.34(300.00) SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2012 Cash in Bank $ (233,509.32) Claim on Operating Cash Pool-Checking Cash in Investments MBIA Investment-EMS Note 2010301,469.13 Total Cash in Bank & Investments$67,959.81 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2012 ************************************************** 2 0 1 2 - 2 0 1 3 ************************************************* 204-DRAINAGE CURRENTCURRENTPRIOR YEARCURRENTY-T-DBUDGET8.33% OF FINANCIAL SUMMARBUDGEPERIODY-T-D ACTUAY-T-D ACTUAENCUMBBALANCEBUDGE YTLLR REVENUE SUMMARY Fees 998,15783,791.25 68,646.54 83,791.25 -914,365.75 Miscellaneous67.01 -94.20705.80 800 94.20 TOTAL REVENUES68,713.55 -83,885.45915,071.55 998,957 83,885.45 EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 447,40624,312.13 20,611.56 24,312.13 -423,093.87 Supplies 8,300 37.86 100.40 37.86 926.84 7,335.30 Human Services 325 - - - -325.00 City Support Services 28,855 1,482.13 - 1,482.13 -27,372.87 Utility Services 28,888 476.80 - 476.80 27,989.94421.26 Operations Support 2,460 - - - -2,460.00 Staff Support 7,875 50.00 279.98 50.00 887.57 6,937.43 City Assistance 840 - - - -840.00 Professional Services 65,800 - 2,100.00- 63,700.00 - Fund Charges/Transfers 189,13615,694.66 11,785.92 15,694.66 -173,441.34 Maintenance Services 22,000 - - - -22,000.00 Other costs 200 - - - -200.00 Debt Service 18,091 - - - -18,091.00 Rental/Leasing 500 - 16,724.80-(16,224.80) - Capital Outlay--128,400.00 139,900 - 11,500.00 TOTAL DRAINAGE32,777.86 32,560.4742,053.58885,961.95 960,576 42,053.58 TOTAL EXPENDITURE32,777.86 32,560.4742,053.58885,961.95 S 960,576 42,053.58 41,831.87 ** REVENUE OVER(UNDER) EXPEND 38,381 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2012 *********************************************** 2 0 1 2 - 2 0 1 3 ************************************************ 204-DRAINAGE CURRENTCURRENTPRIOR YEARY-T-DY-T-DBUDGET8.33% OF REVENUESBUDGETPERIODY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fees 000-457500Drainage Penalties 386.72 463.48 4,000 463.48 -3,536.52 000-457600Drainage Fee83,327.7768,259.82910,829.23 994,157 83,327.77 - TOTAL Fees83,791.2568,646.5483,791.25 998,157 -914,365.75 Miscellaneous 000-491000Interest Earned 4.71 7.21 92.79 100 7.21 - 000-491200Investment Interest 55.37 82.37 600 82.37 -517.63 000-497000Misc Income-Drainage6.934.62 -95.38 100 4.62 TOTAL Miscellaneous 67.01 94.20 800 94.20 -705.80 TOTAL REVENUES83,885.4568,713.5583,885.45 998,957 -915,071.55 DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2012 Cash in Ban k Claim on Operating Cash Pool-Checking 87,307.64 Cash in Investments Lone Star Investment-Drainage Maint Fund483,973.84 Total Cash in Bank & Investments$571,281.48 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2012 *************************************************** 2 0 1 2 - 2 0 1 3 ************************************************* 314-HOTEL TAX CURRENTCURRENTPRIOR YEARCURRENTY-T-DBUDGET8.33% OF FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes 492,417 - - (29,909.67) -492,417.00 Fund Transfers - - - - - -0.00% Miscellaneous52.5615.31 -52.56247.44 300 TOTAL REVENUES52.56(29,894.36) -52.56492,664.44 492,717 EXPENDITURE SUMMARY NONDEPARTMENTAL Supplies 2,000 231.08 - - -2,000.00 City Support Services 68,378 7,500.00 - 7,500.00 395.99 60,482.01 Operations Support 99,175 1,400.00 346.04 1,400.00 1,100.00 96,675.00 Professional Services 5,625 - - - -5,625.00 Fund Charges/Transfers 248,767 13,126.42 11,885.50 13,126.42 -235,640.58 Operating Equipment 50,000 398.88 2,693.89- 47,306.11 - Capital Outlay--8,000.00 8,000 - - TOTAL NONDEPARTMENTA12,861.50 4,189.8822,026.42455,728.70 L 481,945 22,026.42 TOTAL EXPENDITURE12,861.50 4,189.8822,026.42455,728.70 S 481,945 22,026.42 (21,973.86) REVENUE OVER(UNDER) EXPENDITURE 10,772 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2012 *************************************************** 2 0 1 2 - 2 0 1 3 ************************************************* 314-HOTEL TAX CURRENTCURRENTPRIOR YEARCURRENTY-T-DBUDGET8.33% OF REVENUESBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes (29,909.67)- -492,417.00 000-411800Hotel Occupancy Tax 492,417 - TOTAL Taxes 492,417 - - (29,909.67) - 492,417.00 Miscellaneous 000-491000Interest Earned 150 3.08 9.10 3.08 - 146.92 000-491200Investment Interest49.486.2149.48 -100.52 150 TOTAL Miscellaneous30052.5615.3152.56 - 247.44 TOTAL REVENUES 492,717 52.56 (29,894.36) 52.56 - 492,664.44 HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking64,049.15$ Cash in Investments MBIA - Hotel Tax220,229.05 Federated Investment-Hotel/Motel78,275.63 Total Cash in Bank & Investments$362,553.83 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2012 *************************************************** 2 0 1 2 - 2 0 1 3 ************************************************* 317-PAR KCURRENTCURRENTPRIOR YEARCURRENTY-T-DBUDGET8.33% OF FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Parkland Dedication Fees 150,000 - - 46,575.00 -150,000.00 Miscellaneous23.2938.3023.29 300 - TOTAL REVENUES23.2946,613.3023.29150,276.71 150,300 - EXPENDITURE SUMMARY PARKLAND DEDICATION Professional Services- 545.00- - - Fund Charges/Transfers - - - - - -0.00% Maintenance Services-Landscape - - - - - -0.00% Operating Equipment - - - - - -0.00% Capital Outlay --107,600.00 107,600 - - TOTAL PARKLAND DEDICATION--107,055.00 107,600 - 545.00 TOTAL EXPENDITURE--107,055.00 S 107,600 - 545.00 REVENUE OVER(UNDER) EXPEND23.29 42,700 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2012 ***************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 317-PAR KCURRENTCURRENTPRIOR YEARCURRENTY-T-DBUDGET8.33% OF REVENUESBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRANCEBALANCEBUDGET Fees 000-458800Parkland Dedication46,575.00--150,000.00 150,000 - TOTAL Fees150,000- 150,000.00- 0.00% -46,575.00 Miscellaneous 000-491000Interest Earned 2.48 2.82 2.48 - 0.00% - 000-491200Investment Interest35.4820.81- 300 20.81 279.19 TOTAL Miscellaneous 300 23.29 38.30 23.29 276.71- TOTAL REVENUES 150,300 23.29 46,613.30 23.29 150,276.71- 0.02% PARK FUND CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking$51,777.26 Cash in Investments Federated Investment-Park Fund167,411.05 Total in Investment Pool 167,411.05 Total Cash in Bank & Investments$219,188.31 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2012 *************************************************** 2 0 1 2 - 2 0 1 3 ************************************************* 317-PAR KCURRENTCURRENTPRIOR YEARCURRENTY-T-DBUDGET8.33% OF FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Tree Mitigation Fees 35,000 - - - -35,000.00 Miscellaneous18.91-18.9161,706.09 61,725 - TOTAL REVENUES18.91-18.9196,706.09 96,725 - EXPENDITURE SUMMARY TREE MITIGATION Fund Charges/Transfers-- - - - -0.00% Maintenance Services-Trees 73,299 390.00 13,350.00- 59,948.94 - Operating Equipment-- - - - -0.00% Capital Outlay19,900.00- 23,226 - 23,226.06 - TOTAL TREE MITIGATION20,290.00-59,948.94 96,525 - 36,576.06 TOTAL EXPENDITURE20,290.00-59,948.94 S 96,525 - 36,576.06 REVENUE OVER(UNDER) EXPEND18.91 200 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2012 ***************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 317-PAR KCURRENTCURRENTPRIOR YEARCURRENTY-T-DBUDGET8.33% OF REVENUESBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRANCEBALANCEBUDGET Fees 000-458900Tree Mitigation--- 35,000 - 35,000.00 TOTAL Fees35,000-- 35,000.00- - Miscellaneous 000-491200Investment Interest 200 18.91 - 18.91 181.09- 000-499000Transfer In Reserves--- 61,525 - 61,525.00 TOTAL Miscellaneous 61,725 18.91 - 18.91 61,706.09- TOTAL REVENUES 96,725 18.91 - 18.91 96,706.09- PARK FUND CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking$0.00 Cash in Investments Federated Investment-Tree Mitigation152,140.04 Total in Investment Pool 152,140.04 Total Cash in Bank & Investments$152,140.04 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2012 ***************************************************** 2 0 1 2 - 2 0 1 3 *************************************************** 411-CAPITAL RECOVER YCURRENTCURRENTPRIOR YEARCURRENTY-T-DBUDGET8.33% OF FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fees 1,924,200 97,032.00 143,048.00 97,032.00 -1,827,168.00 Fund Transfers 1,542,674 - - - -1,542,674.00 Miscellaneous298,750984.681,477.51984.68297,765.32 - TOTAL REVENUES98,016.68144,525.51 -98,016.683,667,607.32 3,765,624 EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies5,000-- -5,000.00 Operations Support 109 - - - - Professional Services 450,000 354.85 352.62 354.85 -449,645.15 Fund Charges/Transfers - - - 0.00% - - Maintenance Services 10,000 - - - -10,000.00 Debt Service206,515--206,515.00 - - TOTAL NON DEPARTMENTA671,624354.85352.62354.85671,269.15 L - MISC & PROJECTS Water Projects-- 0.00% 1,680,000 - -1,680,000.00 --1,414,000.00 Sewer Projects - - 1,414,000 TOTAL MISC & PROJECTS--3,094,000.00 3,094,000 - - TOTAL EXPENDITURE354.85352.62354.853,765,269.15 S 3,765,624 - 97,662 REVENUE OVER(UNDER) EXPENDITURES - C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2012 **************************************************** 2 0 1 2 - 2 0 1 3 *************************************************** 411-CAPITAL RECOVER YCURRENTCURRENTPRIOR YEARCURRENTY-T-DBUDGET8.33% OF REVENUESBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Fees 000-455900Capital Recovery - Water 1,173,600 64,548.00 98,640.00 64,548.00 -1,109,052.00 000-455910Capital Recovery - Waste Wtr667,200 21,684.00 44,408.00 21,684.00 -645,516.00 000-455913Cap Recovery-North Sewer Tr83,40010,800.00-10,800.00 - TOTAL Fees1,924,20097,032.00143,048.0097,032.00 -1,827,168.00 Fund Transfers 000-481000Transfer from Reserves1,542,674-- - -1,542,674.00 000-486202Transfer in-Water-- - - - TOTAL Fund Transfers 1,542,674 - - - -1,542,674.00 Miscellaneous 000-491000Interest Earned 250 26.38 14.13 26.38 - 000-491200Investment Income 40,000 4,759.70 3,343.66 4,759.70 -35,240.30 000-491800Gain/Loss - - 0.00% - - - 000-491900Unrealized Gain/Loss-Cap One(25,000) (3,801.40) (1,880.28) (3,801.40) -(21,198.60) 000-497000Misc Income - - 0.00% - - - -- 000-498200Re-imbursement-Water Meters 283,500 - - TOTAL Miscellaneous 298,750 984.68 1,477.51 984.68 -297,765.32 TOTAL REVENUES 3,765,624 98,016.68 144,525.51 98,016.68 -3,667,607.32 CAPITAL RECOVERY CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking621,622.60$ Cash in Investments Lone Star Investment-Capital Recovery Water2,110,977.48 Lone Star Investment-Capital Recovery Sewer866,470.47 Capital One-Investment1,718,900.96 Total Cash in Bank & Investments5,317,971.51$ C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2012 ***************************************************** 2 0 1 2 - 2 0 1 3 ************************************************** 505-TAX I&S CURRENTCURRENTPRIOR YEARCURRENTY-T-DBUDGET8.33% OF FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes 199,903.715,032,646 955,625.84 199,903.71 3.97% -4,832,742.29 Fund Transfers55,000 - - - 0.00% -55,000.00 2,960.651,640.91 -2,960.65378,664.35 Miscellaneous 381,625 TOTAL REVENUES202,864.36957,266.75 -202,864.365,266,406.64 5,469,271 EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services42,350 - - - 0.00% -42,350.00 Debt Service5,159,586 - - - -5,159,585.500.00% -- Other Financing Sources - - - - TOTAL GENERAL GOVERNMEN--5,201,935.50 T 5,201,936 - - TOTAL EXPENDITURE--5,201,935.50 S 5,201,936 - - 202,864.36 ** REVENUE OVER(UNDER) EXPEND 267,336 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2012 ***************************************************** 2 0 1 2 - 2 0 1 3 *************************************************** 505-TAX I & S CURRENTCURRENTPRIOR YEARCURRRENTY-T-DBUDGET8.33% OF REVENUESBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 199,903.71955,625.84199,903.71 -4,832,742.29 000-411900Property Tax Revenue 5,032,646 TOTAL Taxes5,032,646199,903.71955,625.84199,903.71 - 4,832,742.29 Fund Transfers 000-486401Transfer In Fund 401--55,000.00 55,000 - - TOTAL Fund Transfers 55,000 - - - - 55,000.00 Miscellaneous 000-491000Interest Earned502.718.322.71 - 000-491200Investment Earnings2,957.941,632.592,957.94 12,500 -9,542.06 000-495015Contribution from SED-- 369,075 - -369,075.00 000-497000Misc Income-- - - - - TOTAL Miscellaneous 381,625 2,960.65 1,640.91 2,960.65 - 378,664.35 TOTAL REVENUES5,469,271 202,864.36 957,266.75 202,864.36 - 5,266,406.64 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2012 505-TAX I & S**************************************************** 2 0 1 2 - 2 0 1 3 *************************************************** GENERAL GOVERNMENTCURRENTCURRENTPRIOR YEARCURRENTY-T-DBUDGET8.33% OF NON DEPARTMENTALBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Professional Services 101-541500Paying Agent-- 2,350 - -2,350.00 -- 101-541502Cost of Bond Issuance - - 40,000 TOTAL Professional Services42,350--- -42,350.00 Debt Service 101-555612Bond-GO Refunding 2010-Principal 250,000 -- - 0.00% -250,000.00 101-555612.1Bond-GO Refunding 2010 Interest77,125 - - - 0.00% -77,125.00 101-555622Schertz C O SR2003-Principal210,000 - - - 0.00% -210,000.00 101-555622.1Schertz C O SR2003-Interest3,833 - - - 0.00% -3,833.00 101-555624Comm Proj Bond-SR04-Principal325,000 - - - 0.00% -325,000.00 101-555624.1Comm Proj Bond SR04-Interest6,910 - - - 0.00% -6,910.00 101-555626LS&D SR2006-Principal200,000 - - - 0.00% -200,000.00 101-555626.1LS&D SR2006-Interest642,982 - - - 0.00% -642,982.00 101-555628CO Bond 2007-Principal109,534 - - - 0.00% -109,534.00 101-555628.1CO Bond 2007-Interest18,499 - - - 0.00% -18,499.00 101-555629GO Bond 2007-Principal235,000 - - - 0.00% -235,000.00 101-555629.1GO Bond 2007-Interest189,561 - - - 0.00% -189,561.00 101-555630GO Bond SR2008 Principal385,000 - - - 0.00% -385,000.00 101-555630.1GO Bond SR2008 Interest349,089 - - - 0.00% -349,089.00 101-555631GO Bond SR2009 Principal510,000 - - - 510,000.00 - 101-555631.1BO Bond SR2009 Interest-- 327,950 - -327,950.00 101-555633GO SR2011 Principal-- 200,000 - -200,000.00 101-555633.1GO SR2011 Interest-- 367,238 - -367,237.50 -- 101-555634GO SR2011A Refund Principal 70,000 - -70,000.00 -- 101-555634.1GO SR2011A Refund Interest 153,081 - -153,081.00 101-555635GO SR2012 Principal-- 295,000 - -295,000.00 -- 101-555635.1GO SR2012 Interest - - 233,784 TOTAL Debt Service5,159,586 - - - -5,159,585.50 Other Financing Sources 101-556300Payment to Refund Debt-- - - - - TOTAL Other Financing Sources - - - 0.00% - - TOTAL EXPENDITURES -5,201,936 - - 0.00% -5,201,935.50 TAX I&S CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking33,566.66$ Cash in Investments MBIA Investment- Tax I&S 192,674.27 Federated Investment-Tax I&S56.92 Total Cash in Bank & Investments$226,297.85 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2012 **************************************************** 2 0 1 2 - 2 0 1 3 *************************************************** 620-SED CORPORATION CURRENTCURRENTPRIOR YEARCURRENTY-T-DBUDGET8.33% OF FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes2,820,260181,000.15 171,125.39 181,000.15 - 2,639,259.85 Fund Transfers - - 0.00% - - - Miscellaneous(3,872.32) -495.7216,954.28 17,450 - TOTAL REVENUES181,000.15167,253.07 -181,495.872,656,214.13 2,837,710 EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies947.23- 0.00% - - - Utility Service 3,062.60 - 0.00% - - - Maintenance Services4,118.88- - - - TOTAL NONDEPARTMENTA8,128.71- L - - - ECONOMIC DEVELOPMEN T Personnel Services 294,593 15,651.06 19,803.91 15,651.06 - 278,941.94 Supplies 2,200 28.65 - 17.48 2,182.52 - Human Services 200 - - - - City Support Services 16,500 1,184.03 1,363.42 1,184.03 - 15,315.97 Utility Services 5,950 27.40 - - - 5,950.00 Operations Support 166,100 49,756.01 4,813.35 49,756.01 357.00 115,986.99 Staff Support 20,250 937.31 5,228.32- 15,021.68 - City Assistance1,025,000 - - - - 1,025,000.00 Professional Services 97,500 201.14 19,217.71- 78,282.29 - Fund Charges/Transfers 615,647 20,547.67 4,665.42 20,547.67 - 595,099.33 Debt Service 428,504 - - - - 428,504.00 Operating Equipment--2,000.00 2,000 - - TOTAL ECONO DEVELOPMEN87,138.7731,840.60 24,820.5187,138.772,562,484.72 T 2,674,444 TOTAL EXPENDITURE87,138.7739,969.31 24,820.5187,138.772,562,484.72 S 2,674,444 94,357.10 ** REVENUE OVER(UNDER) EXPEND 163,266 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2012 *************************************************** 2 0 1 2 - 2 0 1 3 *************************************************** 620-SED CORPORATION CURRENTCURRENTPRIOR YEARCURRENTY-T-D BUDGET8.33% OF REVENUESBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 181,000.15171,125.39 -181,000.152,639,259.85 000-411500Sales Tax Revenue (4B) 2,820,260 TOTAL Taxes2,820,260181,000.15 171,125.39 181,000.15 -2,639,259.85 Miscellaneous 000-491000Interest Earned 200 24.36 - - - 000-491200Investment Earnings 12,250 117.45 495.72 - -11,754.28 000-497000Misc Income(4,014.13)- 5,000 - - TOTAL Miscellaneous17,450495.72 - (3,872.32) - TOTAL REVENUES2,837,710181,000.15 167,253.07 181,495.87 -2,656,214.13 SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking116,113.15$ Cash in Investments MBIA Investment-Economic Development Corp2,827,591.72 Schertz Bank & Trust-Certificate of Deposit1,037,007.40 Total Cash in Bank & Investments3,980,712.27$ 4B SALES TAX $350,000 $300,000 $250,000 2% $200,000 $150,000 $100,000 $50,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 219,717 2012-13 214,497 231,818 169,596 207,911 230,700 182,541 173,698 267,965 199,040 204,426 287,707 220,125 2011-12 171,042 166,132 173,802 177,864 235,199 163,627 141,650 212,924 204,332 171,256 226,531 192,615 2010-11 150,192 169,257 140,629 144,175 238,531 146,589 136,939 184,582 175,160 163,328 210,780 201,402 2009-10 166,298 207,422 185,879 150,414 217,323 149,249 141,205 197,117 158,648 155,080 185,494 159,088 2008-09 C I T Y O F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING OCTOBER 31st, 2012 INVESTMENT POOLSPareginningeposits/ndingndingMaturity BDEE ValueBook ValueYieldPurchasesWithdrawalsBook ValueMkt Value OPERATIONS-BANK CASH Schertz Bank & Trust - Pooled Cash3,017,878.573,405,834.300.05004,220,987.164,608,942.893,017,878.57 N/A3,017,878.57 86,582.22.0500-86,582.2286,582.22 Schertz Bank & Trust - PEG Fund386,582.22 30-33 TOTAL OPERATIONS3,404,460.79,792,416.52,220,987.16,608,942.89,404,460.79,404,460.79 34433 LOGIC General Fund662,750.65862,606.240.1971144.41200,000.00662,750.65 N/A662,750.65 G/F-Equipment Replacement73,482.523,470.23.1971 -2.293,482.52 N/A3,482.52 70177 G/F-Vehicle Replacement102,513.61102,496.450.1971 -17.16102,513.61 N/A102,513.61 G/F-Air Conditioner Replacement146,713.9746,689.42.1971 -4.5546,713.97 N/A46,713.97 10211 SR2009 Bond-Street Projects(II)1,691,367.91,691,084.77.197183.14-,691,367.91,691,367.91 10211 TOTAL LOGIC2,676,828.662,876,347.11481.55200,000.002,676,828.662,676,828.66 LONESTAR Capital Recovery - Sewer866,470.4766,304.96.2300 -65.5166,470.47 N/A66,470.47 80188 Capital Recovery - Water2,110,977.482,110,574.250.2300 -403.232,110,977.48 N/A2,110,977.48 Drainage Fund483,973.8483,891.47.2300 -00,082.3783,973.84 N/A83,973.84 30144 GO SR2011 Animal Shelter2,066,491.592,066,096.860.2300 -394.732,066,491.59 N/A2,066,491.59 GO SR2011 Athletic Fields2,984,123.08,983,553.07.2300 -70.01,984,123.08 N/A,984,123.08 20522 GO SR2011 Soccer Fields2,785,204.882,784,672.870.2300 -532.012,785,204.88 N/A2,785,204.88 GO SR2011 Swimming Pool6,497,594.67,496,353.54.2300 -,241.13,497,594.67 N/A,497,594.67 60166 GO SR2012 Downtown Improvements1,000,307.191,000,116.120.2300 -191.071,000,307.19 N/A1,000,307.19 Water & Sewer Corp436,539.39.2300 -36,539.3936,539.39 N/A36,539.39 -0444 W/S-Customer Deposits294,407.26294,351.020.2300 -56.24294,407.26 N/A294,407.26 W/S-Equipment Repl/Cap.Imp374,011.3873,939.94.2300 -1.4474,011.38 N/A74,011.38 30733 Water&Sewer924,545.97924,369.370.2300 -176.60924,545.97 N/A924,545.97 W/S-Vehicle Replacement545,353.31 545,249.140.2300 -104.17545,353.31 N/A545,353.31 Water/SSLG - SAWS404,475.1104,397.85.23007.26-04,475.1104,475.11 40744 TOTAL LONESTAR21,774,475.6221,233,870.46 -540,605.1621,774,475.6221,774,475.62 MBIA Tax I&S192,674.2732,254.65.2100 -0,419.6292,674.27 N/A92,674.27 10611 Police Forfeiture338,180.29359,911.330.210062.0521,793.09338,180.29 N/A338,180.29 Economic Development Corporation2,827,591.72,677,096.00.2100 -50,495.72,827,591.72 N/A,827,591.72 20122 Hotel Tax220,229.05220,189.300.2100 -39.75220,229.05 N/A220,229.05 Special Events Fund46,700.506,692.07.2100 -.436,700.50 N/A6,700.50 40844 EMS Tax Notes 2010301,469.1301,414.74.21004.39-01,469.1301,469.13 30533 TOTAL MBIA3,926,844.963,737,558.09211,079.9621,793.093,926,844.963,926,844.96 FEDERATED SR2007a Bond-City Wide Projects869,379.5569,271.49.1500 -08.0669,379.55 N/A69,379.55 80188 Hotel Occupancy Tax78,275.6378,265.900.1500 -9.7378,275.63 N/A78,275.63 Park Fund (Developers Fee)167,431.8667,411.05.1500 -0.8167,431.86 N/A67,431.86 10211 Park Fund (Tree Mitigation)152,140.04152,121.130.1500 -18.91152,140.04 N/A152,140.04 Tax I&S56.926.91.1500 -.016.92 N/A6.92 50055 Library Board Fund44,766.164,760.60.1500.56-4,766.164,766.16 40544 TOTAL FEDERATED1,312,050.161,311,887.08 -163.081,312,050.161,312,050.16 INVESTMENT MANAGED ACCOUNT Capital One General Fund1,273,298.72,342,446.56.9000 277.85.09,342,168.80 N/A,341,312.31 12011 Capital One Capital Recovery Sewer1,621,739.38,743,284.01.8800,625.22354.85,747,554.38,718,900.96 12411 TOTAL CAPITAL ONE2,895,038.103,085,730.57 632.704,625.313,089,723.183,060,213.27 City Portfolio By Investment Type TOTAL CAPITAL ONE TOTAL C.D.s 8% 5% TOTAL OPERATIONS 9% TOTAL FEDERATED 3% TOTAL LOGIC 7% TOTAL MBIA 10% TOTAL LONESTAR 58% City Portfolio By Use Designated Funds, $1,929,417.84 Operations, Special Revenue $7,825,517.73 Funds, $10,001,178.74 Debt Service Fund, $192,731.19 Projects, $18,298,943.98 MONTHLY YIELDS 3.50 3.00 2.50 2.00 1.50 1.00 0.50 0.00 OCT-12NOV-12DEC-12JAN-13FEB-13MAR-13APR-13MAY-13JUN-13JUL-13AUG-13SEP-13 0.0900 1 Month T-Bill 0.1100 3 Month T-Bill 0.1600 6 Month T-Bill 0.4300 Schertz Portfolio 0.0500 Schertz Bank&Trust 0.4000 CD 365 Days 0.3000 CD 180 Days 0.1971 LOGIC 0.2300 LoneStar 0.2100 MBIA 0.1500 Federated 2.8800 Capital One C I T Y O F S C H E R T Z Investment Report Capital One Assets Date:10/31/2012 d General Fun Assets P Cash & EquivalentsDueMaturitySharesCostMrk Value Fidelity Inst Prime Mmkt Cl III #69113,298.7213,298.7213,298.72 Total Cash & Equivalent3,298.713,298.73,298.7 s12212 Fixed Income Federal Home Loan Bks Cons Bds8/13/2014651.00125,000.00141,987.30136,746.256,875.00 Federal Home Loan Bks Cons Bds6/21/2013233.0080,000.0082,004.4080,868.001,500.00 Federal Farm Cr Bks Cons Systemwide Bds12/16/20151141.00100,000.00116,185.00114,170.004,875.00 Federal Home Ln Mtg Corp Deb11/15/2013380.00170,000.00191,084.25178,333.408,287.00 Federal Natl Mtg Assn Meduim term Nts9/24/2013328.00250,000.00250,000.00259,362.5010,937.00 Federal Home Ln Mtg Corp Reference Nts11/25/2014755.00200,000.00200,609.40201,742.001,500.00 Federal Natl Mtg Assn 7/28/20151000.00125,000.00132,828.63131,747.502,968.00 US Treasury Note11/30/20151125.0060,000.0061,936.7261,786.20825.00 US Treasury Note5/31/20161308.0050,000.0052,476.5652,242.50875.00 US Treasury Note2/28/2014485.00100,000.0099,757.82100,028.00 Total Fixed Income1,260,000.001,328,870.081,317,026.353 Total Assets647.991,273,298.721,342,168.801,330,325.073 Cap Recovery Fund Assets P Cash & EquivalentsDueMaturitySharesCostMrk Value Fidelity Inst Prime Mmkt CL III #69131,739.3831,739.3831,739.383.000.01 Total Cash & Equivalent1,739.331,739.31,739.3 s38838 Fixed Income Federal Home Loan Bks Cons Bds8/13/2014651.00165,000.00187,423.24180,505.059,075.00 Federal Home Loan Bks Cons Bds6/21/2013233.00100,000.00102,505.50101,085.001,875.00 Federal Farm Cr Bks Cons Systemwide Bds12/16/20151141.00200,000.00230,779.00228,340.009,750.00 Federal Home Ln Mtg Corp Deb11/15/2013380.00250,000.00281,006.25262,255.0012,187.00 Federal Natl Mtg Assn Nts10/15/2013349.00200,000.00223,001.60208,474.009,250.00 Federal Home Ln Mtg Corp Reference Nts11/25/2014755.00220,000.00220,078.68221,916.201,650.00 Federal Natl Mtg Assn7/28/20151000.00135,000.00143,454.91142,287.303,206.00 US Treasury Note11/30/20151125.0050,000.0051,609.5751,488.50687.00 US Treasury Note5/31/20161308.00125,000.00131,191.41130,606.252,187.00 /28/201485.0045,000.00144,764.8445,040.60 US Treasury Not e2411 Total Fixed Incom,590,000.01,715,815.0,671,997.9 e100105 Total Assets688.571,621,739.381,747,554.381,703,737.285