Loading...
11-AUGUST 2014 FINANCIAL STATEMENT AUGUST 2014 Financial Report C I T Y OF S C H E R T Z Prepared By: The Finance Department October 6, 2014 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 14,838,672 483,539.88 13,350,945.76 14,431,168.39 - 407,503.61 97.25% Franchises 1,778,605 164,573.24 1,466,553.15 1,651,075.04 - 127,529.96 92.83% Permits 1,205,062 105,579.00 1,240,542.34 1,224,982.57 - (19,920.57) 101.65% Licenses 70,100 3,964.00 72,940.50 76,831.50 - (6,731.50) 109.60% Fees 2,890,298 210,434.82 2,831,301.14 2,631,720.46 (50.00) 258,627.54 91.05% Fines 30,000 3,004.74 27,796.53 29,318.97 - 681.03 97.73% Inter-Jurisdictional 685,780 21,874.87 781,405.98 511,678.03 - 174,101.97 74.61% Fund Transfers 1,976,365 146,096.83 1,569,460.75 1,607,065.13 - 369,299.87 81.31% Miscellaneous 468,200 35,382.54 366,428.76 435,540.87 (88.90) 32,748.03 93.01% TOTAL REVENUES 23,943,082 1,174,449.92 21,707,374.91 22,599,380.96 (138.90) 1,343,839.94 94.39% EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services 23,575 2,720.19 19,609.52 22,014.97 - 1,560.03 93.38% Supplies 500 - 620.29 476.41 - 23.59 95.28% City Support Services 42,100 (492.31) 39,876.86 40,100.32 - 1,999.68 95.25% Operations Support 300 6.75 482.76 286.13 - 13.87 95.38% Staff Support 20,700 365.00 19,645.99 13,149.78 1,185.00 6,365.22 69.25% Professional Services 1,200 - - - - 1,200.00 0.00% TOTAL CITY COUNCIL 88,375 2,599.63 80,235.42 76,027.61 1,185.00 11,162.39 87.37% CITY MANAGER Personnel Services 910,718 90,422.21 854,013.93 823,563.85 - 87,154.15 90.43% Supplies 3,000 - 987.06 2,722.05 197.87 80.08 97.33% City Support Services - - - 1,762.50 - (1,762.50) 0.00% Operations Support 100 - - - - 100.00 0.00% Staff Support 35,350 672.31 23,564.93 17,204.68 1,928.89 16,216.43 54.13% Professional Services 1,200 1,200.00 - 1,200.00 - - 100.00% TOTAL CITY MANAGER 950,368 92,294.52 878,565.92 846,453.08 2,126.76 101,788.16 89.29% *************************************************** 2 0 1 3 - 2 0 1 4 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2014 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 3 - 2 0 1 4 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2014 MUNICIPAL COURT Personnel Services 309,881 28,310.62 236,374.34 257,060.00 - 52,821.00 82.95% Supplies 2,000 340.91 1,987.56 1,497.26 117.27 385.47 80.73% City Support Services 1,000 - - - - 1,000.00 0.00% Operations Support 4,000 - 4,176.00 1,561.00 474.00 1,965.00 50.88% Staff Support 7,840 544.62 3,020.41 4,932.11 842.27 2,065.62 73.65% Court Support 700 - 120.00 - - 700.00 0.00% Professional Services 65,200 3,390.00 48,243.94 47,772.65 15,489.06 1,938.29 97.03% Maintenance Services 2,800 - 1,300.00 1,900.00 600.00 300.00 89.29% Operating Equipment 800 - - 37.27 - 762.73 4.66% TOTAL MUNICIPAL COURT 394,221 32,586.15 295,222.25 314,760.29 17,522.60 61,938.11 84.29% CUSTOMER RELATIONS-311 Personnel Services 110,340 12,332.88 93,862.26 100,833.65 - 9,506.35 91.38% Supplies 200 - 17.10 121.35 - 78.65 60.68% Staff Support 1,750 - 336.00 171.00 45.49 1,533.51 12.37% Operating Equipment 500 - - - - 500.00 0.00% TOTAL CUSTOMER RELATIONS-311 112,790 12,332.88 94,215.36 101,126.00 45.49 11,618.51 89.70% PLANNING & ZONING Personnel Services 133,060 14,382.46 96,745.97 115,078.06 - 17,981.94 86.49% Supplies 2,672 128.23 1,233.87 962.29 852.20 857.51 67.91% Operations Support 750 - 171.88 - - 750.00 0.00% Staff Support 18,532 1,246.50 2,086.42 1,961.68 6,512.05 10,058.27 45.72% Professional Services 150 - 40,602.97 21.00 - 129.00 14.00% Operating Equipment 318 - - - - 318.00 0.00% TOTAL PLANNING & ZONING 155,482 15,757.19 140,841.11 118,023.03 7,364.25 30,094.72 80.64% LEGAL SERVICES Operations Support 12,000 333.22 3,970.00 5,585.27 84.76 6,329.97 47.25% Professional Services 438,000 20,156.13 367,659.91 228,398.50 - 209,601.50 52.15% TOTAL LEGAL SERVICES 450,000 20,489.35 371,629.91 233,983.77 84.76 215,931.47 52.02% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 3 - 2 0 1 4 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2014 GENERAL SERVICES Personnel Services 567,475 56,629.43 507,975.71 494,463.32 - 73,011.68 87.13% Supplies 65,450 2,756.45 60,474.69 47,515.26 7,207.92 10,726.82 83.61% Utility Services 100,300 8,935.22 79,031.88 77,861.19 113.81 22,325.00 77.74% Staff Support 12,147 965.04 8,669.30 8,777.07 969.24 2,400.69 80.24% Maintenance Services 39,530 125.00 49,992.58 13,434.16 1,269.00 24,826.84 37.19% Rental/Leasing - - 458.25 - - - 0.00% Operating Equipment 21,480 6,692.20 - 16,499.44 - 4,980.56 76.81% Capital Outlay 5,290 5,289.35 - 5,289.35 - 0.65 99.99% TOTAL GENERAL SERVICES 811,672 81,392.69 706,602.41 663,839.79 9,559.97 138,272.24 82.96% BUILDING 6-8 MAINTENANCE Supplies 26,100 575.52 21,003.81 22,013.86 3,298.04 788.10 96.98% Utility Services 86,700 7,250.61 61,749.96 64,221.72 - 22,478.28 74.07% Maintenance Services 64,000 1,185.95 39,110.52 41,724.19 1,992.55 20,283.26 68.31% Operating Equipment 24,060 - 9,249.00 20,503.10 1,049.93 2,506.97 89.58% TOTAL BUILDING 6-8 MAINTENANCE 200,860 9,012.08 131,113.29 148,462.87 6,340.52 46,056.61 77.07% CITY SECRETARY Personnel Services 171,031 19,788.97 131,541.22 147,741.28 - 23,289.72 86.38% Supplies 1,200 27.50 587.88 559.27 - 640.73 46.61% City Support Services 9,600 - 7,087.78 9,576.38 - 23.62 99.75% Operations Support 150 - - 50.00 - 100.00 33.33% Staff Support 7,895 183.00 4,080.72 4,496.77 348.00 3,050.23 61.37% TOTAL CITY SECRETARY 189,876 19,999.47 143,297.60 162,423.70 348.00 27,104.30 85.73% NON-DEPARTMENTAL City Support Services 373,511 6,561.36 316,113.25 279,256.22 30,925.14 63,329.64 83.04% Operations Support 128,000 10,114.50 116,422.31 127,604.73 - 395.27 99.69% Staff Support 100 100.78 12.88 440.86 - (340.86) 440.86% City Assistance 993,666 - 671,153.77 899,821.37 - 93,844.63 90.56% Professional Services 231,350 3,900.73 91,674.20 41,098.35 - 190,251.65 17.76% Fund Chrgs/Transfrs-Spec Events Fnd 475,000 - 165,000.00 - - 475,000.00 0.00% Operating Equipment 2,300 - 269.00 1,955.00 - 345.00 85.00% TOTAL NON-DEPARTMENTAL 2,203,927 20,677.37 1,360,645.41 1,350,176.53 30,925.14 822,825.33 62.67% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 3 - 2 0 1 4 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2014 PUBLIC AFFAIRS Personnel Services 215,900 22,240.55 220,642.13 174,325.25 - 41,574.75 80.74% Supplies 3,400 91.25 2,627.39 2,304.19 275.86 819.95 75.88% Operations Support 27,050 450.00 15,262.35 10,615.03 - 16,434.97 39.24% Staff Support 5,240 242.08 3,049.40 2,942.41 127.02 2,170.57 58.58% Professional Services 15,000 - - 4,290.00 - 10,710.00 28.60% Operating Equipment 3,100 - - 99.99 - 3,000.01 3.23% TOTAL PUBLIC AFFAIRS 269,690 23,023.88 241,581.27 194,576.87 402.88 74,710.25 72.30% RECORDS MANAGEMENT Personnel Services 49,777 5,242.55 42,923.83 44,118.63 - 5,658.37 88.63% Supplies 400 13.56 5.28 141.32 61.57 197.11 50.72% Staff Support 1,860 - 1,230.65 1,064.14 - 795.86 57.21% Professional Services 17,000 190.00 11,088.26 3,329.50 1,003.50 12,667.00 25.49% Operating Equipment - - 360.22 - 83.77 (83.77) 0.00% TOTAL RECORDS MANAGEMENT 69,037 5,446.11 55,608.24 48,653.59 1,148.84 19,234.57 72.14% SCHERTZ MAGAZINE Personnel Services 133,179 14,847.60 118,226.94 120,379.45 - 12,799.55 90.39% Supplies 200 - 200.00 73.94 - 126.06 36.97% Opperations Support 200 - - - 10.81 189.19 5.41% Staff Support 2,005 - 770.82 826.06 216.73 962.21 52.01% Professional Services 260,500 750.00 248,265.54 175,212.29 51,511.62 33,776.09 87.03% Fund Charges/Transfers 10,000 - - - - 10,000.00 0.00% Operating Equipment 600 - - 455.00 - 145.00 75.83% TOTAL SCHERTZ MAGAZINE 406,684 15,597.60 367,463.30 296,946.74 51,739.16 57,998.10 85.74% ENGINEERING Personnel Services 231,566 12,977.50 113,151.02 139,384.74 - 92,181.26 60.19% Supplies 1,100 171.22 441.61 738.40 116.93 244.67 77.76% City Support Services 1,380 - - 262.80 - 1,117.20 19.04% Utility Services 1,400 - 591.45 523.76 - 876.24 37.41% Operations Support - - 195.00 - - - 0.00% Staff Support 8,580 - 1,376.25 1,426.29 495.00 6,658.71 22.39% Professional Services 43,000 - 67,303.02 11,671.25 - 31,328.75 27.14% Operating Equipment 8,000 - - 2,001.75 - 5,998.25 25.02% TOTAL ENGINEERING 295,026 13,148.72 183,058.35 156,008.99 611.93 138,405.08 53.09% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 3 - 2 0 1 4 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2014 GIS Personnel Services 131,043 14,463.72 114,229.84 118,065.93 - 12,977.07 90.10% Supplies 2,855 - 1,329.17 1,000.61 129.72 1,724.67 39.59% Staff Support 5,000 489.88 1,781.41 3,817.28 - 1,182.72 76.35% Professional Services - - 306.56 - - - 0.00% Rental/Leasing 3,805 - - - - 3,805.00 0.00% TOTAL GIS 142,703 14,953.60 117,646.98 122,883.82 129.72 19,689.46 86.20% TOTAL GENERAL GOVERNMENT 6,740,711 379,311.24 5,167,726.82 4,834,346.68 129,535.02 1,776,829.30 73.64% PUBLIC SAFETY POLICE Personnel Services 4,842,482 501,241.26 4,183,199.54 4,305,476.65 - 537,005.35 88.91% Supplies 31,969 2,103.04 36,875.56 27,870.79 2,605.75 1,492.46 95.33% City Support Services 23,800 - 20,657.01 26,721.66 - (2,921.66) 112.28% Utility Services 135,880 12,691.72 107,276.36 110,095.91 - 25,784.09 81.02% Operations Support 2,444 112.93 2,506.97 1,963.46 - 480.54 80.34% Staff Support 93,355 2,393.28 41,807.12 68,287.58 22,823.32 2,244.10 97.60% City Assistance 5,829 - 751.36 5,828.15 - 0.85 99.99% Professional Services 35,498 1,155.30 18,166.91 29,867.65 1,188.00 4,442.35 87.49% Fund Charges/Transfers 3,250 - - - - 3,250.00 0.00% Maintenance Services 47,658 4,445.21 33,978.21 40,032.36 1,259.70 6,365.94 86.64% Operating Equipment 120,579 9,348.40 136,372.28 101,935.82 18,500.65 142.53 99.88% Capital Outlay 128,506 - 164,584.50 128,505.24 - 0.76 100.00% TOTAL POLICE 5,471,250 533,491.14 4,746,175.82 4,846,585.27 46,377.42 578,287.31 89.43% FIRE RESCUE Personnel Services 2,706,130 302,965.99 2,385,384.10 2,431,254.84 - 274,875.16 89.84% Supplies 17,000 692.95 3,707.45 8,539.40 3,682.32 4,778.28 71.89% Utility Services 48,260 4,562.62 43,280.09 44,707.72 - 3,552.28 92.64% Operations Support 1,200 - 689.35 953.37 - 246.63 79.45% Staff Support 111,765 2,292.63 95,171.18 65,646.88 35,660.89 10,457.23 90.64% City Assistance 16,200 - 3,150.94 - 16,001.93 198.07 98.78% Professional Services 15,000 884.00 11,430.00 14,102.00 - 898.00 94.01% Maintenance Services 54,264 1,991.98 22,316.37 31,399.29 747.50 22,117.21 59.24% Operating Equipment 70,168 3,259.37 37,008.61 40,568.71 13,577.46 16,021.83 77.17% Capital Outlay 12,147 - - 12,146.15 - 0.85 99.99% TOTAL FIRE RESCUE 3,052,134 316,649.54 2,602,138.09 2,649,318.36 69,670.10 333,145.54 89.08% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 3 - 2 0 1 4 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2014 INSPECTIONS Personnel Services 478,959 41,331.26 382,190.29 400,044.11 - 78,914.89 83.52% Supplies 2,392 339.10 1,840.56 1,485.06 374.64 532.30 77.75% Utility Services 6,770 559.47 5,136.52 5,598.10 74.85 1,097.05 83.80% Operations Support 1,575 - 1,129.88 898.00 - 677.00 57.02% Staff Support 8,638 116.09 4,975.14 4,744.23 1,849.06 2,044.71 76.33% Professional Services 46 - - 45.59 - 0.41 99.11% Operating Equipment 3,430 - - 429.99 1,922.99 1,077.02 68.60% TOTAL INSPECTIONS 501,810 42,345.92 395,272.39 413,245.08 4,221.54 84,343.38 83.19% MARSHAL'S OFFICE Personnel Services 557,097 59,720.53 481,292.75 513,778.35 - 43,318.65 92.22% Supplies 4,840 8.74 924.48 1,379.85 79.05 3,381.10 30.14% Utility Services 16,000 1,034.05 13,289.68 8,937.63 - 7,062.37 55.86% Operations Support 3,500 76.00 706.96 995.00 217.56 2,287.44 34.64% Staff Support 10,550 1,354.86 3,785.82 5,174.01 46.80 5,329.19 49.49% City Assistance - - - - - - 0.00% Maintenance Services 16,000 180.00 9,026.00 5,391.14 - 10,608.86 33.69% Operating Equipment 8,000 147.90 2,840.51 7,502.37 1,991.71 (1,494.08) 118.68% Capital Outlay 35,000 - - 28,566.00 - 6,434.00 81.62% TOTAL MARSHAL'S OFFICE 650,987 62,522.08 511,866.20 571,724.35 2,335.12 76,927.53 88.18% TOTAL PUBLIC SAFETY 9,676,181 955,008.68 8,255,452.50 8,480,873.06 122,604.18 1,072,703.76 88.91% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 3 - 2 0 1 4 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2014 PUBLIC ENVIRONMENT STREETS Personnel Services 681,227 68,818.13 585,035.39 601,522.49 - 79,704.51 88.30% Supplies 7,200 787.61 5,248.01 5,863.94 75.97 1,260.09 82.50% Utility Services 124,000 5,365.67 120,868.37 93,665.67 - 30,334.33 75.54% Staff Support 9,080 167.78 5,598.84 7,149.23 378.47 1,552.30 82.90% City Assistance 500 - - - - 500.00 0.00% Professional Services 29,875 2,350.00 - 2,350.00 - 27,525.00 7.87% Maintenance Services 140,620 2,520.25 123,434.54 122,132.16 7,193.41 11,294.43 91.97% Rental/Lease 415 - - 414.72 - 0.28 99.93% Operating Equipment 42,588 - 5,444.13 43,926.34 - (1,338.34) 103.14% Capital Outlay 70,400 - - 63,762.50 6,232.00 405.50 99.42% TOTAL STREETS 1,105,905 80,009.44 845,629.28 940,787.05 13,879.85 151,238.10 86.32% TOTAL PUBLIC ENVIRONMENT 1,105,905 80,009.44 845,629.28 940,787.05 13,879.85 151,238.10 86.32% PARKS & RECREATION PARKS DEPARTMENT Personnel Services 499,070 42,060.04 448,478.32 415,502.99 - 83,567.01 83.26% Supplies 35,155 2,723.11 27,704.18 24,680.20 5,249.26 5,225.54 85.14% Utility Services 149,220 9,755.12 132,135.33 104,257.07 29,513.56 15,449.37 89.65% Operations Support 250 - - - - 250.00 0.00% Staff Support 8,473 (95.96) 5,022.10 5,330.20 533.17 2,609.63 69.20% Professional Services 38,250 6,152.50 34,493.50 24,952.71 4,922.00 8,375.29 78.10% Maintenance Services 24,230 6,808.10 13,146.98 14,423.15 1,986.74 7,820.11 67.73% Rental/Leasing 44,000 - 36,518.05 28,942.57 9,676.20 5,381.23 87.77% Operating Equipment 1,100 - 2,176.27 1,043.45 344.25 (287.70) 126.15% TOTAL PARKS DEPARTMENT 799,748 67,402.91 699,674.73 619,132.34 52,225.18 128,390.48 83.95% SWIM POOL Supplies 20,700 - 9,325.50 10,152.19 4,352.09 6,195.72 70.07% Utility Services 29,000 1,983.77 18,517.39 14,584.37 418.78 13,996.85 51.74% Staff Support 925 - - - - 925.00 0.00% Maintenance Services 203,378 119,936.55 187,045.65 181,504.46 44.94 21,828.60 89.27% Rental/Lease 500 - - - - 500.00 0.00% TOTAL SWIM POOL 254,503 121,920.32 214,888.54 206,241.02 4,815.81 43,446.17 82.93% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 3 - 2 0 1 4 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2014 EVENT FACILITIES Personnel Services 57,195 6,149.31 47,563.66 48,476.90 - 8,718.10 84.76% Supplies 17,000 401.97 13,834.94 10,386.84 1,819.63 4,793.53 71.80% Utility Services 51,200 3,974.35 36,090.81 36,838.20 - 14,361.80 71.95% Operations Support 12,800 - 15,628.99 9,994.39 - 2,805.61 78.08% Staff Support 2,727 188.00 1,497.61 2,066.47 7.00 653.53 76.03% Professional Services 1,600 - 150.00 618.45 - 981.55 38.65% TOTAL EVENT FACILITIES 142,522 10,713.63 114,766.01 108,381.25 1,826.63 32,314.12 77.33% SENIOR CITIZEN CENTER Supplies 7,759 806.67 - 5,852.89 191.65 1,714.46 77.90% Utility Services 4,240 - - 414.00 - 3,826.00 9.76% Operations Support 2,400 - - - - 2,400.00 0.00% City Assistence 25,286 2,270.50 - 17,390.88 2,208.70 5,686.42 77.51% Professional Services 11,530 3,789.79 - 11,053.28 - 476.72 95.87% Maintenance Services 2,400 - - 7,548.20 - (5,148.20) 314.51% TOTAL SENIOR CITIZEN CENTER 53,615 6,866.96 - 42,259.25 2,400.35 8,955.40 83.30% TOTAL PARKS & RECREATION 1,250,388 206,903.82 1,029,329.28 976,013.86 61,267.97 213,106.17 82.96% CULTURAL LIBRARY Personnel Services 678,656 66,250.95 608,320.94 585,308.39 - 93,347.61 86.25% Supplies 12,000 1,079.40 9,821.05 9,816.56 - 2,183.44 81.80% Utility Services 51,060 5,239.24 42,675.08 39,239.07 427.94 11,392.99 77.69% Operations Support 3,500 215.99 2,641.69 849.83 - 2,650.17 24.28% Staff Support 5,940 14.00 1,481.09 2,750.76 - 3,189.24 46.31% Professional Services 2,350 - 2,140.00 2,190.00 - 160.00 93.19% Maintenance Services 2,400 - 600.00 - - 2,400.00 0.00% Operating Equipment 80,570 2,109.26 64,322.61 70,106.14 5,804.31 4,659.55 94.22% TOTAL LIBRARY 836,476 74,908.84 732,002.46 710,260.75 6,232.25 119,983.00 85.66% TOTAL CULTURAL 836,476 74,908.84 732,002.46 710,260.75 6,232.25 119,983.00 85.66% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 3 - 2 0 1 4 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2014 HEALTH ANIMAL SERVICES Personnel Services 317,626 30,884.58 234,674.55 244,449.12 - 73,176.88 76.96% Supplies 30,700 4,826.73 17,863.55 29,297.27 4,154.09 (2,751.36) 108.96% Utility Services 20,530 2,318.44 9,870.95 18,124.37 - 2,405.63 88.28% Operations Support 1,000 - 346.95 678.00 120.00 202.00 79.80% Staff Support 10,450 - 4,962.35 4,572.90 75.00 5,802.10 44.48% City Assistance 17,550 2,087.00 10,294.85 8,584.70 745.90 8,219.40 53.17% Professional Services 21,500 3,332.60 9,203.01 23,674.38 2,765.45 (4,939.83) 122.98% Maintenance Services 20,285 216.20 3,673.84 3,498.60 89.94 16,696.46 17.69% Operating Equipment 14,495 - 3,121.49 2,659.44 2,635.23 9,200.33 36.53% TOTAL ANIMAL SERVICES 454,136 43,665.55 294,011.54 335,538.78 10,585.61 108,011.61 76.22% TOTAL HEALTH 454,136 43,665.55 294,011.54 335,538.78 10,585.61 108,011.61 76.22% INTERNAL SERVICE INFORMATION TECHNOLOGY Personnel Services 401,949 46,808.24 264,322.62 377,751.39 - 24,197.61 93.98% Supplies 2,000 139.96 470.47 1,826.55 56.61 116.84 94.16% City Support Services 444,823 14,035.45 289,677.69 321,151.34 4,934.51 118,737.15 73.31% Utility Services 195,372 9,582.08 173,814.55 148,187.57 757.99 46,426.44 76.24% Staff Support 22,275 690.91 16,389.06 21,944.63 - 330.37 98.52% Maintenance Services 12,500 39.99 6,997.14 8,082.47 146.47 4,271.06 65.83% Operating Equipment 373,483 7,375.39 94,826.23 274,382.77 43,075.53 56,024.70 85.00% TOTAL INFORMATION TECHNOLOGY 1,452,402 78,672.02 846,497.76 1,153,326.72 48,971.11 250,104.17 82.78% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 3 - 2 0 1 4 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2014 HUMAN RESOURCES Personnel Services 310,989 32,072.01 257,136.40 266,992.64 - 43,996.36 85.85% Supplies 1,300 71.20 493.01 1,028.67 - 271.33 79.13% Human Services 62,900 4,443.18 35,825.08 36,008.24 1,999.63 24,892.13 60.43% Operations Support 9,500 795.00 8,954.31 7,983.04 - 1,516.96 84.03% Staff Support 14,919 268.16 10,997.44 10,757.42 129.00 4,032.58 72.97% City Assistance 10,000 474.82 8,946.50 4,831.03 70.00 5,098.97 49.01% Professional Services 4,000 1,489.50 - 2,739.50 - 1,260.50 68.49% Operating Equipment 900 846.08 - 846.08 200.59 (146.67) 116.30% TOTAL HUMAN RESOURCES 414,508 40,459.95 322,352.74 331,186.62 2,399.22 80,922.16 80.48% FINANCE Personnel Services 454,996 50,175.77 394,860.27 406,057.16 - 48,938.84 89.24% Supplies 2,492 212.50 2,497.99 2,363.67 - 128.33 94.85% Operations Support 1,000 - 986.50 834.00 - 166.00 83.40% Staff Support 14,805 - 5,674.95 6,108.99 - 8,696.01 41.26% Maintenance Services 8 - - - 7.95 0.05 99.38% Operating Equipment - - 1,770.00 - - - 0.00% TOTAL FINANCE 473,301 50,388.27 405,789.71 415,363.82 7.95 57,929.23 87.76% PURCHASING & ASSET MGT Personnel Services 255,024 16,824.09 221,506.48 216,629.72 - 38,394.72 84.94% Supplies 1,200 17.99 520.36 389.17 58.96 751.87 37.34% Utility Services 600 73.78 378.03 286.41 - 313.59 47.74% Operations Support 300 - 13.19 - - 300.00 0.00% Staff Support 6,102 21.97 4,909.85 3,376.10 644.48 2,081.42 65.89% Operating Equipment 3,933 - - 1,840.63 - 2,092.37 46.80% TOTAL PURCHASING & ASSET MGT 267,159 16,937.83 227,327.91 222,522.03 703.44 43,933.97 83.56% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 3 - 2 0 1 4 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2014 FLEET SERVICE Personnel Services 222,091 18,853.60 160,461.70 187,563.31 - 34,527.69 84.45% Supplies 169,901 11,638.79 143,553.16 181,924.16 19,549.44 (31,572.60) 118.58% City Support Services 3,500 - 2,388.00 2,100.00 - 1,400.00 60.00% Utility Services 4,599 440.08 3,232.59 3,843.56 - 755.44 83.57% Operations Support 400 - 142.00 - 19.66 380.34 4.92% Staff Support 4,085 40.31 1,786.82 2,044.10 617.42 1,423.48 65.15% City Assistance 180 - - - - 180.00 0.00% Maintenance Services 70,690 1,041.80 87,880.99 86,478.07 8,927.60 (24,715.67) 134.96% Rental/Lease 200 - - - - 200.00 0.00% Operating Equipment 5,000 - 9,451.28 3,188.79 1,807.16 4.05 99.92% Capital Outlay 10,000 - - - 10,000.00 - 100.00% TOTAL FLEET SERVICE 490,646 32,014.58 408,896.54 467,141.99 40,921.28 (17,417.27) 103.55% BUILDING MAINTENANCE Personnel Services 92,966 10,109.31 61,660.15 87,566.45 - 5,399.55 94.19% Supplies 1,543 94.97 - 325.60 697.80 519.60 66.33% Utility Services 3,850 418.75 2,088.02 2,788.40 - 1,061.60 72.43% Staff Support 2,850 29.06 484.67 1,766.40 67.10 1,016.50 64.33% Professional Services 10,000 - 12,622.50 9,745.00 - 255.00 97.45% Maintenance Services 107,920 18,688.24 49,509.58 99,078.75 2,747.39 6,093.86 94.35% Rental/Leasing 1,400 - 375.00 - - 1,400.00 0.00% Operating Equipment - - 539.50 - - - 0.00% Capital Outlay 118,000 - - 3,712.50 8,415.00 105,872.50 10.28% TOTAL BUILDING MAINTENANCE 338,529 29,340.33 127,279.42 204,983.10 11,927.29 121,618.61 64.07% TOTAL INTERNAL SERVICE 3,436,545 247,812.98 2,338,144.08 2,794,524.28 104,930.29 537,090.87 84.37% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 3 - 2 0 1 4 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2014 MISC & PROJECTS CITY ASSISTANCE Patient Assistance 5,000 - 5,000.00 5,000.00 - - 100.00% Transportation Assistance 22,000 - - 22,020.00 - (20.00) 100.09% Children's Advocacy Assistance 5,000 - - - - 5,000.00 0.00% Senior Citizen's Hot Meals 42,000 - 42,000.00 55,628.00 - (13,628.00) 132.45% TOTAL CITY ASSISTANCE 74,000 - 47,000.00 82,648.00 - (8,648.00) 111.69% COURT - RESTRICTED FUNDS Operating Equipment 6,400 - 20,350.90 840.00 11,487.00 (5,927.00) 192.61% TOTAL CITY ASSISTANCE 6,400 - 20,350.90 840.00 11,487.00 (5,927.00) 192.61% TOTAL MISC & PROJECTS 80,400 - 67,351 83,488 11,487 (14,575.00) 118.13% TOTAL EXPENDITURES 23,580,742 1,987,620.55 18,729,646.86 19,155,832.46 460,522.17 3,964,387.81 83.19% REVENUE OVER(UNDER) EXPEND.362,340 3,443,548.50 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 91.67% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Taxes 000-411100 Advalorem Tax - Current 7,839,691 10,459.74 7,466,740.25 8,041,782.00 - (202,091.00) 102.58% 000-411200 Advalorem Tax - Delinquent 50,000 2,550.54 47,111.28 27,317.08 - 22,682.92 54.63% 000-411300 Advalorem Tax - P&I 50,000 2,272.32 40,433.14 39,372.09 - 10,627.91 78.74% 000-411500 Sales Tax Revenue-Gen Fund 6,870,981 468,257.28 5,766,240.32 6,293,017.63 - 577,963.37 91.59% 000-411600 Bingo Tax - - - 30.62 - (30.62) 0.00% 000-411700 Mixed Beverage Tax 28,000.00 - 30,420.77 29,648.97 - (1,648.97) 105.89% TOTAL Taxes 14,838,672 483,539.88 13,350,945.76 14,431,168.39 - 407,503.61 97.25% Franchises 000-421200 Center Point/Entex Energy 72,100 4,729.34 55,596.50 73,991.14 - (1,891.14) 102.62% 000-421220 City Public Service 460,837 42,927.66 372,563.86 581,073.79 - (120,236.79) 126.09% 000-421240 Guadalupe Valley Elec Co-op 400,000 42,256.81 367,839.12 288,369.72 - 111,630.28 72.09% 000-421250 New Braunfels Utilities 61,800 6,374.06 47,419.95 56,921.57 - 4,878.43 92.11% 000-421300 Time Warner-State Franchise 300,000 22,433.72 294,779.22 255,874.47 - 44,125.53 85.29% 000-421460 AT&T Franchise Fee 260,868 15,956.90 219,420.16 218,291.39 - 42,576.61 83.68% 000-421480 Other Telecom Franchise 115,000 29,894.75 8,801.41 82,919.01 - 32,080.99 72.10% 000-421500 Solid Waste Franchise Fee 108,000 - 100,132.93 93,633.95 - 14,366.05 86.70% TOTAL Franchises 1,778,605 164,573.24 1,466,553.15 1,651,075.04 - 127,529.96 92.83% Permits 000-431100 Home Occupation Permit 490 - 455.00 525.00 - (35.00) 107.14% 000-431205 Building Permit - Residential 404,420 39,222.00 428,198.00 350,675.00 - 53,745.00 86.71% 000-431210 Building Permit - Commercial 170,000 1,757.00 352,983.00 230,006.00 - (60,006.00) 135.30% 000-431215 Building Permit - General 283,296 37,818.00 128,036.00 334,629.00 - (51,333.00) 118.12% 000-431300 Mobile Home Permit 450 - 525.00 675.00 - (225.00) 150.00% 000-431400 Signs Permit 4,582 363.00 5,467.00 7,253.00 - (2,671.00) 158.29% 000-431500 Food Establishmnt Permit 45,000 250.00 14,445.00 28,815.00 - 16,185.00 64.03% 000-431600 Garage Sale Permit 12,000 1,213.00 11,255.00 11,730.00 - 270.00 97.75% 000-431700 Plumbing Permit 117,324 7,894.00 118,579.65 89,924.55 - 27,399.45 76.65% 000-431750 Electrical Permit 50,000 3,980.00 56,420.00 47,684.50 - 2,315.50 95.37% 000-431800 Mechanical Permit 50,000 5,200.00 53,360.00 48,600.00 - 1,400.00 97.20% 000-431900 Solicitor/Peddler Permit 1,000 120.00 1,670.00 1,280.00 - (280.00) 128.00% 000-431950 Animal/Pet Permit 2,000 100.00 1,800.00 1,615.00 - 385.00 80.75% 000-432000 Cert. of Occupancy Prmt 6,500 800.00 4,850.00 6,200.00 - 300.00 95.38% ************************************************ 2 0 1 3 - 2 0 1 4 **************************************************** C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2014 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 91.67% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET ************************************************ 2 0 1 3 - 2 0 1 4 **************************************************** C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2014 000-432100 Security Alarm Permit 45,000 3,320.00 43,789.00 36,490.00 - 8,510.00 81.09% 000-432300 Grading/Clearing Permit 3,000 550.00 2,482.69 4,382.52 - (1,382.52) 146.08% 000-435000 Fire Permit 10,000 2,992.00 16,227.00 24,498.00 - (14,498.00) 244.98% TOTAL Permits 1,205,062 105,579.00 1,240,542.34 1,224,982.57 - (19,920.57) 101.65% Licenses 000-441000 Alcohol Beverage License 5,500 235.00 6,329.50 6,737.50 - (1,237.50) 122.50% 000-441300 Mobile Home License 200 - 160.00 160.00 - 40.00 80.00% 000-442000 Contractors License 60,200 3,410.00 62,305.00 66,510.00 - (6,310.00) 110.48% 000-444000 Pet License 4,200 319.00 4,146.00 3,424.00 - 776.00 81.52% TOTAL Licenses 70,100 3,964.00 72,940.50 76,831.50 - (6,731.50) 109.60% Fees 000-451000 Municipal Court Fines 1,345,300 87,738.80 1,310,960.44 1,155,247.17 - 190,052.83 85.87% 000-451100 Arrest Fee 56,734 4,453.37 59,234.68 47,826.25 - 8,907.75 84.30% 000-451110 Expunction Fee 120 - 30.00 - - 120.00 0.00% 000-451200 Warrant Fees 148,500 7,616.31 152,209.52 125,000.72 - 23,499.28 84.18% 000-451210 Court - Claims & Judgements - - (388.00) (773.10) - 773.10 0.00% 000-451320 Civil Justice Fee-Court 97 - 92.09 18.40 - 78.60 18.97% 000-451321 Civil Justice Fee-State 885 - 829.78 165.94 - 719.06 18.75% 000-451340 Judicial Fee - City 8,562 571.90 7,915.08 6,376.15 - 2,185.85 74.47% 000-451400 Traffic Fine Costs TTL 32,246 2,270.90 30,282.90 23,825.78 - 8,420.22 73.89% 000-451500 Teen Court Admin Fee 200 - 220.00 40.00 - 160.00 20.00% 000-451510 Juvenile Case Mgmt Fee 64,384 4,770.80 66,019.10 53,154.46 - 11,229.54 82.56% 000-451520 Truancy Fee - 848.54 - 5,383.68 - (5,383.68) 0.00% 000-451600 Technology Fund Fee 59,500 3,803.07 52,971.80 42,810.62 - 16,689.38 71.95% 000-451700 Security Fee 42,655 2,852.33 39,728.85 32,107.95 - 10,547.05 75.27% 000-451800 Time Payment Fee - City 6,238 285.85 5,866.51 5,961.44 - 276.56 95.57% 000-451850 State Fines 10% Service Fee 92,278 - 88,442.58 68,504.06 - 23,773.94 74.24% 000-451900 DPS Payment - Local 13,981 560.15 12,015.88 9,704.18 - 4,276.82 69.41% 000-452000 Child Safety Fee 22,076 195.46 18,209.84 16,065.91 - 6,010.09 72.78% 000-452050 Indigent Defense Fee 31,076 - 26,020.59 5,099.02 - 25,976.98 16.41% 000-452100 Platting Fees 52,500 7,500.00 48,311.00 60,250.00 - (7,750.00) 114.76% 000-452200 Site Plan Fee 25,500 6,000.00 22,500.00 29,500.00 - (4,000.00) 115.69% 000-452300 Plan Check Fee 361,264 38,324.50 441,627.50 453,943.00 - (92,679.00) 125.65% 000-452310 Miscellaneous Review Fee 1,200 - 600.00 3,000.00 - (1,800.00) 250.00% 000-452320 Tree Mitigation Admin Fee 10,000 2,385.00 3,277.50 42,577.50 - (32,577.50) 425.78% 000-452400 BOA/Zoning Fees 3,500 1,500.00 4,000.00 5,500.00 - (2,000.00) 157.14% 000-452500 Food Handler Class 26,400 1,220.00 18,014.00 16,150.00 - 10,250.00 61.17% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 91.67% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET ************************************************ 2 0 1 3 - 2 0 1 4 **************************************************** C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2014 000-452600 Specific Use/Zone Chng Fee 25,800 - 22,000.00 13,450.00 - 12,350.00 52.13% 000-452710 Zoning Ltr & Dev Rights 1,050 150.00 1,350.00 600.00 - 450.00 57.14% 000-453100 Reinspection Fees 36,700 2,055.00 31,275.00 30,525.98 - 6,174.02 83.18% 000-453110 Swim Pool Inspection Fee 1,500 35.00 1,725.00 2,310.00 - (810.00) 154.00% 000-453200 Lot Abatement 7,000 757.33 9,320.71 7,038.75 - (38.75) 100.55% 000-453211 Admin Fee-Inspections 5,200 - 4,700.00 7,792.65 - (2,592.65) 149.86% 000-453310 Misc Inspection Fee - - - 3,050.00 - (3,050.00) 0.00% 000-453710 Foster Care 1,400 100.00 1,150.00 900.00 - 500.00 64.29% 000-454200 Pool Gate Admission Fee 22,400 7,463.10 23,163.75 26,877.15 - (4,477.15) 119.99% 000-454300 Seasonal Pool Pass Fee 5,100 - 5,665.00 5,933.15 - (833.15) 116.34% 000-456110 Senior Center Memberships 5,625 475.00 - 2,419.32 - 3,205.68 43.01% 000-456120 Senior Center Meal Fee 30,785 1,899.00 - 10,037.00 - 20,748.00 32.60% 000-456500 Haz Mat Fees 12,000 1,570.90 1,250.00 2,381.25 - 9,618.75 19.84% 000-456600 Fire Re-inspection Fee 750 100.00 1,100.00 900.00 - (150.00) 120.00% 000-458100 Sale of Merchandise - - - 210.00 - (210.00) 0.00% 000-458110 Sale of Merchandise-GovDeal 18,000 983.01 14,213.99 17,222.01 - 777.99 95.68% 000-458300 Sale of Property/Auction 2,000 1,200.00 2,756.70 1,216.82 - 783.18 60.84% 000-458400 Civic Center Rental Fees 140,916 10,187.00 155,457.75 154,238.25 (50.00) (13,272.25) 109.42% 000-458401 Capital Recovery Fee-Civic Cntr 5,000 825.00 4,825.00 7,715.00 - (2,715.00) 154.30% 000-458450 North Center Rental Fees 20,600 640.00 17,410.00 20,612.00 - (12.00) 100.06% 000-458460 Senior Center Rental 18,000 2,450.00 - 10,039.00 - 7,961.00 55.77% 000-458500 Community Center Rental Fees 27,026 2,618.00 25,355.06 21,187.07 - 5,838.93 78.40% 000-458550 Pavilion Rental Fees 18,500 922.50 16,958.50 15,530.00 - 2,970.00 83.95% 000-458560 Chamber of Comm rent 7,800 - 7,800.00 3,919.50 - 3,880.50 50.25% 000-458570 Non-Resident SYSA League - - 7,845.00 - - - 0.00% 000-458650 NonResident User Fee-BVYA 5,000 1,000.00 9,550.00 10,140.00 - (5,140.00) 202.80% 000-458660 BVYA Utility Reimbursement 8,400 - 2,952.98 8,587.32 - (187.32) 102.23% 000-458670 SYSA Utility Reimbursement - - 2,999.36 - - - 0.00% 000-458675 Lions Futbol Utility Reimbursement 14,000 - 9,288.00 2,700.00 - 11,300.00 19.29% 000-458680 Tournament Fees-Soccer - - 600.00 - - - 0.00% 000-458700 Vehicle Impoundment 6,000 - 6,440.00 7,680.00 - (1,680.00) 128.00% 000-459200 NSF Check Fee 650 25.00 490.00 220.00 - 430.00 33.85% 000-459300 Notary Fee 300 12.00 216.00 234.00 - 66.00 78.00% 000-459400 Maps, Copies, UDC, & Misc F 100 - 110.00 99.70 - 0.30 99.70% 000-459600 Animal Adoption Fee 17,500 860.00 15,184.05 11,121.00 - 6,379.00 63.55% 000-459700 Pet Impoundment Fee 14,000 706.00 13,320.55 12,437.01 - 1,562.99 88.84% 000-459800 Police Reports Fee 6,000 504.00 5,837.10 4,957.40 - 1,042.60 82.62% TOTAL Fees 2,890,298 210,434.82 2,831,301.14 2,631,720.46 (50.00) 258,627.54 91.05% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 91.67% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET ************************************************ 2 0 1 3 - 2 0 1 4 **************************************************** C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2014 Fines 000-463000 Library Fines 30,000 3,004.74 27,796.53 29,318.97 - 681.03 97.73% TOTAL Fines 30,000 3,004.74 27,796.53 29,318.97 - 681.03 97.73% Inter-Jurisdictional 000-473100 Bexar Co - Fire 21,072 12,295.36 19,321.28 19,321.28 - 1,750.72 91.69% 000-473200 City of Seguin - Fire Contract 30,000 2,435.90 36,907.86 26,794.90 - 3,205.10 89.32% 000-473300 Guad Co - Library 208,343 - 173,619.10 190,981.01 - 17,361.99 91.67% 000-473400 Randolph AFB-Animal Cntrl 1,500 - 1,400.00 1,100.00 - 400.00 73.33% 000-474200 Library Services - Cibolo 25,000 - - - - 25,000.00 0.00% 000-474210 Library Services-Selma 26,560 - 26,560.00 28,220.00 - (1,660.00) 106.25% 000-474400 Dispatch Service - Cibolo 133,305 - 99,978.75 66,652.50 - 66,652.50 50.00% 000-474600 School Crossing Guard-Bexar 40,000 3,509.11 33,799.60 34,170.79 - 5,829.21 85.43% 000-474610 School Cross Guard-Guadalupe 40,000 3,634.50 34,101.13 25,381.00 - 14,619.00 63.45% 000-474620 School Crossing Guard-Comal - - 1,388.00 1,456.55 - (1,456.55) 0.00% 000-474700 School Officer Funding 160,000 - 90,000.00 117,600.00 - 42,400.00 73.50% 000-474800 CPS CIED Funding - - 264,330.26 - - - 0.00% TOTAL Inter-Jurisdictional 685,780 21,874.87 781,405.98 511,678.03 - 174,101.97 74.61% Fund Transfers 000-480000 Indirect Costs - EMS 137,038 11,419.83 80,520.00 125,618.13 - 11,419.87 91.67% 000-480100 Indirect Costs - Hotel/Motel 145,385 12,115.42 144,390.62 133,269.62 - 12,115.38 91.67% 000-482100 Transfer From Reserves-Ct Tech 10,278 - - - - 10,278.00 0.00% 000-482150 Transfer From Court Security 42,569 - - - 42,569.00 0.00% 000-485000 Interfund Charge-Drainage 51,800 4,316.67 45,565.63 47,483.37 - 4,316.63 91.67% 000-486000 Interfund Chrges-Admin W&S 1,152,350 96,029.17 972,549.38 1,056,320.87 - 96,029.13 91.67% 000-486202 Transfer In-W&S 136,000 - - - - 136,000.00 0.00% 000-486203 Transfer In-EMS 1,356 - - - - 1,356.00 0.00% 000-486314 Transfer In Hotel/Motel 33,000 - - - - 33,000.00 0.00% 000-487000 Interfund Charges-Fleet 130,344 10,861.99 103,364.25 119,481.89 - 10,862.11 91.67% 000-488000 Interfund Charges-4B 136,245 11,353.75 223,070.87 124,891.25 - 11,353.75 91.67% TOTAL Fund Transfers 1,976,365 146,096.83 1,569,460.75 1,607,065.13 - 369,299.87 81.31% 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 91.67% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET ************************************************ 2 0 1 3 - 2 0 1 4 **************************************************** C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2014 Miscellaneous 000-491000 Interest Earned 500 - 426.37 306.80 - 193.20 61.36% 000-491200 Investment Income 45,000 1,986.80 39,224.44 24,327.45 - 20,672.55 54.06% 000-491800 Gain/Loss - - (16,588.08) (17,122.84) - 17,122.84 0.00% 000-491900 Unrealized Gain/Loss (26,000) 50.95 (17,085.40) 5,730.85 - (31,730.85) 0.00% 000-493120 Donations-Public Library 5,000 - 7,500.00 7,258.90 - (2,258.90) 145.18% 000-493130 Donations-Writing the Next Chap.- - 325.00 - - - 0.00% 000-493400 Donation - Animal Control 4,000 - 1,977.05 1,162.97 - 2,837.03 29.07% 000-493401 Donations-A/C Microchip 2,000 130.00 1,470.00 1,250.00 - 750.00 62.50% 000-493402 Donations-Spay&Neuter 14,000 859.00 11,767.88 9,672.95 - 4,327.05 69.09% 000-493403 Donations-Animal Adoption Trailer - - - 2,000.00 - (2,000.00) 0.00% 000-493465 Donations-Senior Center - 6,694.57 - 36,726.64 - (36,726.64) 0.00% 000-493502 Donations-PD - - - 2,400.00 - (2,400.00) 0.00% 000-493503 Donations - Fire Rescue - - 2,250.00 - - - 0.00% 000-494481 LawEnforcemtOfficersStnd&Ed - - - 3,931.29 - (3,931.29) 0.00% 000-494482 Grants - Police, Fire, Gen Fund - - - 5,499.84 - (5,499.84) 0.00% 000-495040 Friends of N. Schertz Park - - 885.00 - - - 0.00% 000-495060 Grant-Wellmed/Senior Center 3,500 - - - - 3,500.00 0.00% 000-495100 Mobile Stage Rental Fees 2,000 - 1,550.00 1,550.00 - 450.00 77.50% 000-497000 Misc Income-Gen Fund 20,000 3,984.87 7,947.90 37,067.22 (88.90) (16,978.32) 184.89% 000-497005 Schertz Magazine Advertising 220,000 16,325.00 208,980.26 206,275.00 - 13,725.00 93.76% 000-497007 Misc Income-Schertz Artz - - 10.00 - - - 0.00% 000-497100 Misc Income-Police 12,000 471.20 12,070.13 4,549.60 - 7,450.40 37.91% 000-497150 Misc Income-Fire Department - - 292.37 - - - 0.00% 000-497200 Misc Income-Library 4,000 499.45 3,932.80 4,317.59 - (317.59) 107.94% 000-497210 Misc Income-Library Copier 13,000 1,421.95 13,079.92 13,175.35 - (175.35) 101.35% 000-497300 Misc Income-Animal Control - - 190.00 - - - 0.00% 000-497400 Misc Income-Streets Dept.18,000 1,681.60 18,953.68 29,025.30 - (11,025.30) 161.25% 000-497500 Misc Income-TML Insurance 25,000 - 17,116.19 4,842.50 - 20,157.50 19.37% 000-497550 Misc Income-TML Reimbursemt 15,000 1,016.04 19,792.84 21,357.46 - (6,357.46) 142.38% 000-497600 Misc Income-Vending Mach.2,200 261.11 2,266.10 2,173.12 - 26.88 98.78% 000-498000 Reimbursmnt-Gen Fund 60,000 - 16,279.10 11,376.80 - 48,623.20 18.96% 000-498100 Reimbursmnt Fire - Training - - - 4,398.97 - (4,398.97) 0.00% 000-498105 Reimburmnt Police - DEA 9,000 - 6,075.89 4,655.49 - 4,344.51 51.73% 000-498107 Reimburmnt Police - Event - - - 3,500.00 - (3,500.00) 0.00% 000-498110 Reimbursmnt Fire - Emg. Acti-O 20,000 - 5,739.32 4,131.62 - 15,868.38 20.66% TOTAL Miscellaneous 468,200 35,382.54 366,428.76 435,540.87 (88.90) 32,748.03 93.01% TOTAL REVENUES 23,943,082 1,174,449.92 21,707,374.91 22,599,380.96 (138.90) 1,343,839.94 94.39% Cash in Bank Claim on Operating Cash Pool-Checking 1,114,221.18$ Cash in Investments LOGIC Investment-General Fund 5,639,320.25 LOGIC Investment-Equip Replacement 73,643.01 LOGIC Investment-Veh Replacement 211,239.83 LOGIC Investment-Air Condi Replacment 171,557.17 CAPITAL ONE Investment-General Fund 1,346,792.94 Total Cash in Bank & Investments 8,703,356.22$ CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31st, 2014 GENERAL FUND OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2013-14 363,589 538,568 3,641,091 2,726,044 585,058 72,116 16,554 48,791 18,572 20,939 10,460 2012-13 292,988 636,964 3,422,107 2,180,145 637,568 177,645 29,444 49,157 11,566 20,778 8,379 7,180 2011-12 1,540,041 228,924 2,439,123 1,871,054 635,719 64,190 27,878 29,919 18,039 26,509 6,127 6,915 2010-11 1,406,160 244,255 2,331,487 1,725,242 735,329 174,687 37,341 43,108 15,120 26,143 13,773 5,356 2009-10 1,277,006 1,642,355 702,874 1,730,904 562,689 (32,792)59,545 34,762 19,836 29,955 5,346 3,535 ADVALOREM TAX OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2013-14 481,247 657,271 554,578 416,261 728,443 487,933 541,476 781,057 692,446 448,577 680,332 2012-13 439,433 575,041 474,246 424,191 632,716 415,829 405,378 660,648 544,675 563,636 650,124 487,170 2011-12 428,995 463,636 339,192 415,822 461,400 365,083 347,395 535,930 398,080 408,851 575,414 440,250 2010-11 339,709 332,264 347,605 353,229 470,399 324,575 283,300 425,848 408,664 342,513 453,063 385,230 2009-10 300,384 338,514 281,259 288,350 477,063 293,178 273,874 366,704 350,314 324,169 419,127 402,804 2008-09 332,597 414,845 371,763 300,829 434,646 298,499 282,410 394,233 317,296 310,159 373,041 315,947 10% 14% 17% -2% 15% 17% 34% 18% 27% -20% 5% $- $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 $700,000 $800,000 $900,000 Sales Tax - General Fund OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2013-14 133,486 115,592 176,520 213,412 2012-13 101,440 94,054 96,303 123,044 2011-12 96,392 76,414 77,398 103,230 2010-11 83,433 62,692 67,561 95,887 2009-10 77,354 61,468 63,276 80,716 $- $50,000 $100,000 $150,000 $200,000 $250,000 CITY PUBLIC SERVICE 106-SPECIAL EVENTS FUND CURRENT CURRENT PRIOR CURRENT Y-T-D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fund Transfers 149,657.00 - - 118,222.00 - 31,435.00 79.16% Wilenchik Walk for Life 25,000.00 - 20,846.16 23,464.72 - 1,535.28 117.32% Hal Baldwin Scholarship 13,800.00 - 19,598.88 23,762.00 - (9,962.00) 0.00% Miscellaneous 11,500.00 1.29 10,417.87 7,035.68 - 4,464.32 97.72% TOTAL REVENUES 199,957.00 1.29 50,862.91 172,484.40 - 27,472.60 97.70% EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental 5,150.00 - - - - 5,150.00 0.00% TOTAL GENERAL GOVERNMENT 5,150.00 - - - - 5,150.00 0.00% CULTURAL Festival of Angels 15,000.00 - 16,017.55 10,283.94 - 4,716.06 68.56% Employee Appreciation Event 12,000.00 - 6,385.23 11,510.21 - 489.79 95.92% National Night Out 150.00 - - - - 150.00 0.00% Wilenchik Walk for Life 25,000.00 - 20,846.16 23,464.72 - 1,535.28 93.86% Schertz Sweetheart 37,000.00 4,448.00 29,538.47 33,502.64 - 3,497.36 90.55% Jazzfest 25,000.00 - 15,538.41 14,504.83 - 10,495.17 58.02% Hal Baldwin Scholarship 13,800.00 - 11,739.72 8,730.20 - 5,069.80 63.26% Other Events 66,857.00 - 2,337.13 52,877.26 781.25 13,198.49 80.26% TOTAL CULTURAL 194,807.00 4,448.00 102,402.67 154,873.80 781.25 39,151.95 79.90% TOTAL EXPENDITURES 199,957.00 4,448.00 102,402.67 154,873.80 781.25 44,301.95 77.84% REVENUE OVER(UNDER) EXPEND - 17,610.60 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2014 ************************************************** 2 0 1 3 - 2 0 1 4 ************************************************** Cash in Bank Claim on Operating Cash Pool-Checking 100,597.91$ Cash in Investments MBIA Special Events 16,782.64 Total Cash in Bank & Investments 117,380.55$ CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31st, 2014 SPECIAL EVENTS FUND 110-PEG FUND CURRENT CURRENT PRIOR CURRENT Y-T-D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 100,950.00 13,585.66 93,261.18 52,971.38 - 47,978.62 52.47% Fund Transfers 260,550.00 - - - - 260,550.00 0.00% TOTAL REVENUES 361,500.00 13,585.66 93,261.18 52,971.38 - 308,528.62 14.65% EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental 361,500.00 - 39,204.90 51,893.44 9,574.25 300,032.31 17.00% TOTAL GENERAL GOVERNMENT 361,500.00 - 39,204.90 51,893.44 9,574.25 300,032.31 17.00% TOTAL EXPENDITURES 361,500.00 - 39,204.90 51,893.44 9,574.25 300,032.31 17.00% REVENUE OVER(UNDER) EXPEND - 1,077.94 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2014 ************************************************** 2 0 1 3 - 2 0 1 4 ************************************************** 110-PEG FUND CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 91.67% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Franchises 000-421350 Time Warner - PEG Fee 66,950 13,585.66 57,717.57 52,971.38 - 13,978.62 79.12% 000-421465 AT&T PEG Fee 34,000 - 35,543.61 - - 34,000.00 0.00% TOTAL Franchises 100,950 13,586 93,261.18 52,971.38 - 47,978.62 52.47% Fund Transfers 000-481000 Transfer In - Reserves 260,550 - - - - 260,550.00 0.00% TOTAL Fund Transfers 260,550 - - - - 260,550.00 0.00% TOTAL REVENUES 361,500 13,585.66 93,261.18 52,971.38 - 308,528.62 14.65% C I T Y O F S C H E R T Z ************************************************** 2 0 1 3 - 2 0 1 4 ************************************************** REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2014 Cash in Bank Cash Balance 435,375.46$ Total Cash in Bank & Investments 435,375.46$ CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31st, 2014 PEG FUND 202-WATER & SEWER CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 195,710 3,863.06 157,517.14 170,080.88 - 25,629.12 86.90% Permits 12,000.00 - 38,793.75 56,903.86 - (44,903.86) 474.20% Fees 16,092,683 1,594,497.61 14,026,366.72 15,188,187.12 - 904,495.88 94.38% Fund Transfers 2,917,282 10,359.67 109,356.50 113,956.37 - 2,803,325.63 3.91% Miscellaneous 165,440 826.75 405,868.90 226,237.93 - (60,797.93) 136.75% TOTAL REVENUES 19,383,115 1,609,547.09 14,737,903.01 15,755,366.16 - 3,627,748.84 81.28% EXPENDITURE SUMMARY BUSINESS OFFICE Personnel Services 446,455 45,889.31 356,228.10 369,064.72 - 77,390.28 82.67% Supplies 4,600 233.03 2,512.62 3,829.53 231.24 539.23 88.28% Human Services 183 - 122.00 116.95 - 66.05 63.91% City Support Services 1,000 - - - - 1,000.00 0.00% Operations Support 122,375 7,296.48 96,728.78 104,022.00 - 18,353.00 85.00% Staff Support 7,100 53.20 2,571.17 2,657.11 97.85 4,345.04 38.80% Professional Services 24,000 3,245.34 20,352.53 25,036.52 - (1,036.52) 104.32% Maintenance Services 13,440 - 9,800.00 6,540.00 - 6,900.00 48.66% Operating Equipment 2,547 - 1,452.44 - - 2,547.00 0.00% TOTAL BUSINESS OFFICE 621,700 56,717.36 489,767.64 511,266.83 329.09 110,104.08 82.29% W & S ADMINISTRATION Personnel Services 1,202,040 129,173.69 948,024.27 1,031,778.38 - 170,261.62 85.84% Supplies 195,150 1,391.05 130,679.94 118,690.18 7,637.79 68,822.03 64.73% Human Services 1,000 - 398.00 389.95 - 610.05 39.00% City Support Services 91,300 1,000.00 47,615.04 62,051.99 - 29,248.01 67.96% Utility Services 3,342,400 406,403.23 2,869,010.95 2,932,981.91 493.49 408,924.60 87.77% Operations Support 9,250 256.01 3,215.10 2,470.70 97.90 6,681.40 27.77% Staff Support 29,700 1,765.38 17,985.12 23,551.92 1,770.11 4,377.97 85.26% City Assistance 1,900 - 453.00 708.25 - 1,191.75 37.28% Professional Services 249,113 10,027.69 211,176.08 141,128.65 3,425.00 104,559.35 58.03% Fund Charges/Transfers 3,336,760 135,277.34 2,428,966.70 2,618,513.53 - 718,246.47 78.47% Maintenance Services 5,924,250 376,300.73 5,015,914.16 5,323,727.53 268,576.68 331,945.79 94.40% Other Costs 35,000 - 29,541.85 27,650.20 - 7,349.80 79.00% ******************************************************* 2 0 1 3 - 2 0 1 4 ****************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2014 202-WATER & SEWER CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET ******************************************************* 2 0 1 3 - 2 0 1 4 ****************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2014 Debt Service 1,458,925 24,137.50 380,759.31 424,017.98 - 1,034,907.02 29.06% Rental-Leasing 6,070 - 3,570.91 2,684.95 105.00 3,280.05 45.96% Operating Equipment 11,164 - 1,840.76 15,345.80 399.98 (4,581.78) 141.04% Capital Outlay 544,316 - 84,450.00 431,787.10 - 112,528.90 79.33% TOTAL PUBLIC WORKS 16,438,338 1,085,732.62 12,173,601.19 13,157,479.02 282,505.95 2,998,353.03 81.76% MISC & PROJECTS PROJECTS Professional Services - - 64,275.30 - - - 0.00% Fund Charges/Transfers 2,185,086 - 367,519.00 - - 2,185,086.00 0.00% Maintenance Services - - 640,996.05 - - - 0.00% TOTAL PROJECTS 2,185,086 - 1,072,790.35 - - 2,185,086.00 0.00% TOTAL MISC & PROJECTS 2,185,086 - 1,072,790.35 - - 2,185,086.00 0.00% TOTAL EXPENDITURES 19,245,124 1,142,450 13,736,159 13,668,746 282,835 5,293,543 72.49% ** REVENUE OVER(UNDER)EXPENSES **137,991 2,086,620.31 202-WATER & SEWER CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 91.67% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Franchises 000-421490 Tower Leasing 195,710 3,863.06 157,517.14 170,080.88 - 25,629.12 86.90% TOTAL Franchises 195,710 3,863.06 157,517.14 170,080.88 - 25,629.12 86.90% Permits 000-432400 Development Permit 12,000 - 38,793.75 56,903.86 - (44,903.86) 474.20% TOTAL Permits 12,000 - 38,793.75 56,903.86 - (44,903.86) 474.20% Fees 000-455200 Garbage Collection Fee 3,600,000 362,619.34 3,285,472.11 3,648,447.26 - (48,447.26) 101.35% 000-455600 Fire Line Fees 22,000 - 20,635.00 23,985.00 - (1,985.00) 109.02% 000-455700 Recycle Fee Revenue 262,983 22,417.07 237,224.95 241,526.52 - 21,456.48 91.84% 000-455800 W&S Line Constructn Reimbursemnt 30,000 7,716.20 19,815.63 27,250.72 - 2,749.28 90.84% 000-457100 Sale of Water 8,043,200 826,356.84 7,072,060.98 7,076,524.47 - 966,675.53 87.98% 000-457110 Edwards Water Lease 127,000 - 96,942.09 310,930.58 - (183,930.58) 244.83% 000-457120 Water Transfer Charge-Selma 42,000 14,950.53 38,445.76 43,278.80 - (1,278.80) 103.04% 000-457130 Water Transfer Charge-U. C. 5,000 4,449.23 8,072.40 16,800.62 - (11,800.62) 336.01% 000-457140 Water Transfer Charge-Converse 30,000 8,593.53 32,351.04 31,564.68 - (1,564.68) 105.22% 000-457200 Sale of Meters 90,000 4,140.00 52,612.68 49,327.46 - 40,672.54 54.81% 000-457400 Sewer Charges 3,658,000 324,986.79 2,991,537.72 3,530,681.94 - 127,318.06 96.52% 000-457500 Water Penalties 180,000 17,993.08 166,856.36 185,034.07 - (5,034.07) 102.80% 000-458000 Sales of General Fixed Assets - - 2,000.00 (2,000.00) - 2,000.00 0.00% 000-458110 Sale of Merchandise - Gov Deals - - - 180.00 - (180.00) 0.00% 000-458400 Building rental Fee - - - 2,000.00 - (2,000.00) 0.00% 000-459200 NSF Check Fee-Water&Sewer 2,500 275.00 2,340.00 2,655.00 - (155.00) 106.20% TOTAL Fees 16,092,683 1,594,497.61 14,026,366.72 15,188,187.12 - 904,495.88 94.38% Fund Transfers 000-481000 Transfer In- Reserve 2,185,086 - - - - 2,185,086.00 0.00% 000-486102 Transfer In-Equipment Reserves 197,500 - - - - 197,500.00 0.00% 000-486103 Transfer In-Vehicle Reserves 290,380 - - - - 290,380.00 0.00% 000-486204 Interfnd Chrg-Drainage Bill 124,316 10,359.67 109,356.50 113,956.37 - 10,359.63 91.67% 000-486411 Transfer In-Capital Recovery 120,000 - - - - 120,000.00 0.00% TOTAL Fund Transfers 2,917,282 10,359.67 109,356.50 113,956.37 - 2,803,325.63 3.91% ******************************************************* 2 0 1 3 - 2 0 1 4 ****************************************************** AS OF: AUGUST 31st, 2014 REVENUE REPORT (UNAUDITED) C I T Y O F S C H E R T Z 202-WATER & SEWER CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 91.67% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET ******************************************************* 2 0 1 3 - 2 0 1 4 ****************************************************** AS OF: AUGUST 31st, 2014 REVENUE REPORT (UNAUDITED) C I T Y O F S C H E R T Z Miscellaneous 000-490000 Misc Charges 700 43.72 5,912.78 435.22 - 264.78 62.17% 000-491000 Interest Earned 2,000 66.16 1,437.96 1,137.94 - 862.06 56.90% 000-491200 Investment Income 12,000 243.15 6,724.73 4,164.75 - 7,835.25 34.71% 000-496050 SSLG - SAWS Reservation - - 269,000.00 134,500.00 - (134,500.00) 0.00% 000-497000 Misc Income-W&S 40,000 473.72 45,935.02 6,363.02 - 33,636.98 15.91% 000-498110 Reimbursement-SSLGC 110,740 - 76,858.41 79,637.00 - 31,103.00 71.91% TOTAL Miscellaneous 165,440 826.75 405,868.90 226,237.93 - (60,797.93) 136.75% TOTAL REVENUES 19,383,115 1,609,547.09 14,737,903.01 15,755,366.16 - 3,627,748.84 81.28% Cash in Bank Claim on Operating Cash Pool-Checking 538,555.40$ Cash in Investments Lone Star Investment-Water&Sewer 638,767.85 Lone Star Investment-W&S Customer Deposits 295,285.84 Lone Star Investment-W&S Equip Replacement 177,539.68 Lone Star Investment-W&S Veh Replacement 256,472.25 Lone Star Investment-Water/SSLGC SAWS 675,249.69 Schertz Bank & Trust-Certificate of Deposit 1,064,372.78 3,107,688.09$ Total Cash in Bank & Investments 3,646,243.49$ CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31st, 2014 WATER & SEWER 203-EMS CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 5,583,983 381,116.22 4,376,588.41 4,909,297.43 (250.00) 674,935.57 87.91% Inter-Jurisdictional 1,556,828 32,585.86 1,461,136.92 1,556,080.02 - 748.06 99.95% Miscellaneous 239,500 7,066.92 92,369.82 101,059.86 (330.00) 138,770.14 42.06% TOTAL REVENUES 7,380,311 420,769.00 5,930,095.15 6,566,437.31 (580.00) 814,453.77 88.96% EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services 2,863,992 331,759.49 2,482,695.15 2,664,236.50 - 199,755.50 93.03% Supplies 354,984 18,403.88 284,167.18 266,135.52 58,546.29 30,302.19 91.46% Human Services 800 81.00 193.00 424.00 - 376.00 53.00% City Support Services 32,500 - 15,571.98 17,826.32 - 14,673.68 54.85% Utility Services 125,744 12,556.60 120,896.28 118,027.91 450.68 7,265.41 94.22% Operations Support 62,755 2,989.67 51,263.11 51,645.47 1,872.85 9,236.68 85.28% Staff Support 81,500 2,582.79 56,045.21 63,899.73 12,234.80 5,365.47 93.42% City Assistance 14,400 - 12,285.17 11,547.30 116.25 2,736.45 81.00% Professional Services 127,566 3,416.57 128,340.05 117,141.94 6,811.52 3,612.54 97.17% Fund Charges/Transfers 2,663,429 366,600.49 1,430,576.27 1,876,451.76 - 786,977.24 70.45% Maintenance Services 57,820 855.00 29,297.20 15,344.05 7,355.38 35,120.57 39.26% Debt Service 152,772 74.80 68,933.00 6,406.71 - 146,365.29 4.19% Rental-Leasing 82,000 - - - - 82,000.00 0.00% Operating Equipment 193,600 1,046.00 102,838.50 82,222.04 23,398.94 87,979.02 54.56% Capital Outlay 80,000 - - - - 80,000.00 0.00% TOTAL PUBLIC SAFETY 6,893,862 740,366.29 4,783,102.10 5,291,309.25 110,786.71 1,491,766.04 78.36% TOTAL EXPENDITURES 6,893,862 740,366.29 4,783,102.10 5,291,309.25 110,786.71 1,491,766.04 78.36% ** REVENUE OVER(UNDER) EXPENSES **486,449 1,275,128.06 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2014 *************************************************** 2 0 1 3 - 2 0 1 4 *************************************************** 203-EMS CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 91.67% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Fees 000-456100 Ambulance/Mileage Transport 5,419,583 372,493.56 4,286,144.91 4,793,234.02 - 626,348.98 88.44% 000-456110 Subscription Program Fees 40,000 305.00 18,545.00 23,555.00 - 16,445.00 58.89% 000-456120 EMT Class - Fees 104,400 6,660.00 63,885.00 72,316.00 (250.00) 32,334.00 69.03% 000-456130 Immunization Fees - - 20.00 - - - 0.00% 000-456140 Billing Fees - Alamo Heights 20,000 1,657.66 7,328.50 17,372.41 - 2,627.59 86.86% 000-458110 Sales of Merchandise - GovDeal - - 645.00 2,770.00 - (2,770.00) 0.00% 000-459200 NSF Check Fee - - 20.00 50.00 - (50.00) 0.00% TOTAL Fees 5,583,983 381,116.22 4,376,588.41 4,909,297.43 (250.00) 674,935.57 87.91% Inter-Jurisdictional 000-473500 Seguin/Guadalupe Co Support 286,126 23,843.88 262,557.68 286,126.56 - (0.56) 100.00% 000-474300 Cibolo Support 253,757 - 228,830.20 253,756.80 - - 100.00% 000-475100 Comal Co ESD #6 90,694 7,590.70 86,752.61 83,497.70 - 7,196.38 92.07% 000-475200 Live Oak Support 170,178 - 165,187.96 174,376.80 - (4,199.04) 102.47% 000-475300 Universal City Support 240,149 - 233,107.40 241,548.80 - (1,400.00) 100.58% 000-475400 Selma Support 71,798 - 69,693.20 73,798.40 - (2,000.00) 102.79% 000-475500 Schertz Support 420,915 - 395,829.68 420,914.88 - - 100.00% 000-475600 Santa Clara Support 9,396 - 9,120.48 9,396.00 - - 100.00% 000-475800 Marion Support 13,815 1,151.28 10,057.71 12,664.08 - 1,151.28 91.67% TOTAL Inter-Jurisdictional 1,556,828 32,585.86 1,461,136.92 1,556,080.02 - 748.06 99.95% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2014 *************************************************** 2 0 1 3 - 2 0 1 4 *************************************************** 203-EMS CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 91.67% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2014 *************************************************** 2 0 1 3 - 2 0 1 4 *************************************************** Miscellaneous 000-491000 Interest Earned - - - 12.26 - (12.26) 0.00% 000-491200 Investment Income - - 344.08 - - - 0.00% 000-493203 Donations-EMS 2,000 - 852.00 80.00 - 1,920.00 4.00% 000-493204 Donations-Dilworth Fund 3,500 - - - - 3,500.00 0.00% 000-493205 Donations- Golf Tournament 4,000 - 14,162.00 15,525.00 - (11,525.00) 388.13% 000-497000 Misc Income 130,000 6,752.62 71,892.54 81,485.18 (330.00) 48,844.82 62.43% 000-497100 Recovery of Bad Debt 100,000 314.30 5,119.20 3,957.42 - 96,042.58 2.75% TOTAL Miscellaneous 239,500 7,066.92 92,369.82 101,059.86 (330.00) 138,770.14 42.06% TOTAL REVENUES 7,380,311 420,769.00 5,930,095.15 6,566,437.31 (580.00) 814,453.77 88.96% Cash in Bank Claim on Operating Cash Pool-Checking 405,978.77$ Total Cash in Bank & Investments 405,978.77$ CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31st, 2014 SCHERTZ EMS 204-DRAINAGE CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Permits - 300.00 - 3,340.00 - (3,340.00) 0.00% Fees 1,041,000 89,135.64 941,911.19 945,567.18 - 95,432.82 142.51% Miscellaneous 1,700 72.07 3,394.25 965.55 - 734.45 61.50% TOTAL REVENUES 1,042,700 89,507.71 945,305.44 949,872.73 - 92,827.27 142.82% EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 451,350 47,306.27 318,010.83 339,737.50 - 111,612.50 75.27% Supplies 8,300 228.51 4,226.75 4,758.06 37.71 3,504.23 57.78% Human Services 325 - - 61.00 - 264.00 18.77% City Support Services 24,239 - 3,233.63 2,166.61 - 22,072.39 8.94% Utility Services 29,500 2,563.14 23,338.87 22,193.57 960.10 6,346.33 78.49% Operations Support 2,460 - - - 19.66 2,440.34 0.80% Staff Support 7,625 210.25 4,122.10 4,325.82 782.23 2,516.95 66.99% City Assistance 840 - 80.56 - - 840.00 0.00% Professional Services 24,261 217.47 11,768.92 2,925.48 - 21,335.52 12.06% Fund Charges/Transfers 197,304 16,375.34 172,641.26 180,128.74 - 17,175.26 91.30% Maintenance Services 22,000 416.90 3,394.40 6,012.27 2,469.38 13,518.35 38.55% Other costs 200 - 100.00 200.00 - - 100.00% Debt Service 18,574 - 2,690.70 2,073.16 - 16,500.84 11.16% Rental/Leasing 500 - - - - 500.00 0.00% Operating Equipment 11,049 - 11,468.42 11,303.80 - (254.80) 102.31% Capital Outlay 25,083 - 142,480.60 24,322.00 - 761.00 96.97% TOTAL DRAINAGE 823,610 67,317.88 697,557.04 600,208.01 4,269.08 219,132.91 73.39% PROJECTS City Support Services 3,200 - - - - 3,200.00 0.00% Operations Support 1,000 - - - - 1,000.00 0.00% Professional Services 41,200 - - 22,240.00 8,000.00 10,960.00 73.40% Maintenance Services 169,998 - - 16,800.00 - 153,198.00 9.88% TOTAL PROJECTS 215,398 - - 39,040.00 8,000.00 168,358.00 21.84% TOTAL EXPENDITURES 1,039,008 67,317.88 697,557.04 639,248.01 12,269.08 387,490.91 62.71% ** REVENUE OVER(UNDER) EXPEND 3,692 310,624.72 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2014 **************************************************** 2 0 1 3 - 2 0 1 4 **************************************************** 204-DRAINAGE CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 91.67% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Permits 000-432400 Floodplain Permit - 300.00 - 3,340.00 - (3,340.00) 0.00% TOTAL Permits - 300.00 - 3,340.00 - (3,340.00) 0.00% Fees 000-457500 Drainage Penalties 5,000 761.62 6,987.79 7,813.75 - (2,813.75) 156.28% 000-457600 Drainage Fee 1,036,000 88,374.02 934,923.40 937,753.43 - 98,246.57 90.52% TOTAL Fees 1,041,000 89,135.64 941,911.19 945,567.18 - 95,432.82 90.83% Miscellaneous 000-491000 Interest Earned 100 - 77.99 101.88 - (1.88) 101.88% 000-491200 Investment Interest 600 72.07 882.40 797.67 - (197.67) 132.95% 000-497000 Misc Income-Drainage 1,000 - 2,433.86 66.00 - 934.00 6.60% TOTAL Miscellaneous 1,700 72.07 3,394.25 965.55 - 734.45 56.80% TOTAL REVENUES 1,042,700 89,507.71 945,305.44 949,872.73 - 92,827.27 91.10% C I T Y O F S C H E R T Z *********************************************** 2 0 1 3 - 2 0 1 4 ************************************************* REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2014 Cash in Bank Claim on Operating Cash Pool-Checking 470,990.24 Cash in Investments Lone Star Investment-Drainage Maint Fund 605,649.08 Total Cash in Bank & Investments 1,076,639.32$ DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31st, 2014 314-HOTEL TAX CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 485,000 115,449.61 401,330.02 457,078.17 - 27,921.83 94.24% Fund Transfers 173,810 - - - - 173,810 0.00% Miscellaneous 550 24.18 481.52 317.77 - 232.23 57.78% TOTAL REVENUES 659,360 115,473.79 401,811.54 457,395.94 - 201,964.06 69.37% EXPENDITURE SUMMARY NONDEPARTMENTAL Supplies 2,000 - - - - 2,000.00 0.00% City Support Services 66,787 7,658.10 71,759.56 66,786.10 - 0.90 100.00% Operations Support 47,841 4,871.82 37,869.48 25,652.48 500.00 21,688.52 54.67% Professional Services 5,625 - 11,685.00 2,800.00 - 2,825.00 49.78% Fund Charges/Transfers 435,107 12,115.42 144,390.62 274,991.62 - 160,115.38 63.20% Maintenance Services 26,632 - - 23,462.00 - 3,170.00 88.10% Operating Equipment 55,368 - 48,104.11 8,665.59 2,652.60 44,049.81 20.44% Capital Outlay 20,000 - - - - 20,000.00 0.00% TOTAL NONDEPARTMENTAL 659,360 24,645.34 313,808.77 402,357.79 3,152.60 253,849.61 61.50% TOTAL EXPENDITURES 659,360 24,645.34 313,808.77 402,357.79 3,152.60 253,849.61 61.50% REVENUE OVER(UNDER) EXPENDITURE - 55,038.15 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2014 **************************************************** 2 0 1 3 - 2 0 1 4 **************************************************** 314-HOTEL TAX CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 91.67% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Taxes 000-411800 Hotel Occupancy Tax 485,000 115,449.61 401,330.02 457,078.17 - 27,921.83 94.24% TOTAL Taxes 485,000 115,449.61 401,330.02 457,078.17 - 27,921.83 94.24% Fund Transfers 000-481000 Transfer From Reserve 173,810 - - - - 173,810.00 0.00% TOTAL Fund Transfers 173,810 - - - - 173,810.00 0.00% Miscellaneous 000-491000 Interest Earned 50 - 56.66 56.91 - (6.91) 113.82% 000-491200 Investment Interest 500 24.18 424.86 260.86 - 239.14 52.17% TOTAL Miscellaneous 550 24.18 481.52 317.77 - 232.23 57.78% TOTAL REVENUES 659,360 115,473.79 401,811.54 457,395.94 - 201,964.06 69.37% C I T Y O F S C H E R T Z *************************************************** 2 0 1 3 - 2 0 1 4 *************************************************** REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2014 Cash in Bank Claim on Operating Cash Pool-Checking 226,124.19$ Cash in Investments MBIA - Hotel Tax 299,163.43 Total Cash in Bank & Investments 525,287.62$ CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31st, 2014 HOTEL OCCUPANCY TAX FUND OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2013-14 40,023 40,709 33,342 29,778 36,680 56,699 48,081 49,579 54,858 67,329 2012-13 35,851 39,439 32,392 32,120 31,531 49,811 39,900 39,692 54,395 61,999 51,840 34,297 2011-12 33,128 32,675 32,143 35,829 36,215 45,071 36,518 40,335 48,397 53,622 46,551 29,807 2010-11 27,689 25,112 23,231 19,619 22,667 36,728 28,215 34,157 45,854 53,433 42,181 32,294 2009-10 23,625 22,026 20,768 19,924 23,169 33,638 26,531 32,368 36,676 46,069 36,697 26,655 $- $10,000 $20,000 $30,000 $40,000 $50,000 $60,000 $70,000 $80,000 HOTEL OCCUPANCY TAX 317-PARK CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Parkland Dedication Fees 150,000 12,000.00 192,000.00 132,150.00 - 17,850.00 88.10% Miscellaneous 300 2,781.25 212.16 2,792.77 - (2,492.77) 930.92% TOTAL REVENUES 150,300 14,781.25 192,212.16 134,942.77 - 15,357.23 89.78% EXPENDITURE SUMMARY PARKLAND DEDICATION Professional Services - - 545.00 - - - 0.00% Fund Charges/Transfers - - 138,884.00 - - - 0.00% Maintenance Services-Landscape 12,840 - - - 12,840.00 - 100.00% Operating Equipment - - 4,386.30 - - - 0.00% Capital Outlay 27,160 - - - - 27,160.00 0.00% TOTAL PARKLAND DEDICATION 40,000 - 143,815.30 - 12,840.00 27,160.00 32.10% TOTAL EXPENDITURES 40,000 - 143,815.30 - 12,840.00 27,160.00 32.10% REVENUE OVER(UNDER) EXPEND 110,300 134,942.77 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2014 *************************************************** 2 0 1 3 - 2 0 1 4 *************************************************** 317-PARK CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 91.67% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBRANCE BALANCE BUDGET Fees 000-458800 Parkland Dedication 150,000 12,000.00 192,000.00 132,150.00 - 17,850.00 88.10% TOTAL Fees 150,000 12,000.00 192,000.00 132,150.00 - 17,850.00 88.10% Miscellaneous 000-491000 Interest Earned - - 33.67 10.12 - (10.12) 0.00% 000-491200 Investment Interest 300 0.05 178.49 1.45 - 298.55 0.48% 000-497000 Misc Income - 2,781.20 - 2,781.20 - (2,781.20) 0.00% TOTAL Miscellaneous 300 2,781.25 212.16 2,792.77 - (2,492.77) 930.92% TOTAL REVENUES 150,300 14,781.25 192,212.16 134,942.77 - 15,357.23 89.78% C I T Y O F S C H E R T Z ******************************************************* 2 0 1 3 - 2 0 1 4 ******************************************************* REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2014 Cash in Bank Claim on Operating Cash Pool-Checking $137,611.26 Cash in Investments MBIA Investment-Park Fund 1,354.64 Total Cash in Bank & Investments $138,965.90 CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31st, 2014 PARK FUND 319-TREE MITIGATION CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Tree Mitigation Fees 35,000 13,515.00 19,172.50 241,272.50 - (206,272.50) 689.35% Miscellaneous 104,525 7.80 1,832.37 162.87 - 104,362.13 0.16% TOTAL REVENUES 139,525 13,522.80 21,004.87 241,435.37 - (101,910.37) 173.04% EXPENDITURE SUMMARY TREE MITIGATION Maintenance Services-Trees 139,525 - 57,730.00 39,956.30 24,300.00 75,268.70 46.05% Capital Outlay - - 23,226.06 - - - 0.00% TOTAL TREE MITIGATION 139,525 - 80,956.06 39,956.30 24,300.00 75,268.70 46.05% TOTAL EXPENDITURES 139,525 - 80,956.06 39,956.30 24,300.00 75,268.70 46.05% REVENUE OVER(UNDER) EXPEND - 201,479.07 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2014 *************************************************** 2 0 1 3 - 2 0 1 4 *************************************************** 319-TREE MITIGATION CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 91.67% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBRANCE BALANCE BUDGET Fees 000-458900 Tree Mitigation 35,000 13,515.00 19,172.50 241,272.50 - (206,272.50) 689.35% TOTAL Fees 35,000 13,515.00 19,172.50 241,272.50 - (206,272.50) 689.35% Miscellaneous 000-491000 Interest Earned 50 - 23.24 78.71 - (28.71) 157.42% 000-491200 Investment Interest 150 7.80 119.13 84.16 - 65.84 56.11% 000-497000 Misc Income - - 1,690.00 - - - 0.00% 000-499000 Transfer In Reserves 104,325 - - - - 104,325.00 0.00% TOTAL Miscellaneous 104,525 7.80 1,832.37 162.87 - 104,362.13 0.16% TOTAL REVENUES 139,525 13,522.80 21,004.87 241,435.37 - (101,910.37) 173.04% C I T Y O F S C H E R T Z ******************************************************* 2 0 1 3 - 2 0 1 4 ******************************************************* REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2014 Cash in Bank Claim on Operating Cash Pool-Checking $261,806.06 Cash in Investments MBIA Investment-Tree Mitigation 97,331.79 Total Cash in Bank & Investments $359,137.85 CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31st, 2014 TREE MITIGATION FUND 411-CAPITAL RECOVERY WATER CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 83.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 880,200 58,680.00 783,378.00 732,033.00 - 148,167.00 83.17% Fund Transfers 1,425,609 - - - - 1,425,609.00 0.00% Miscellaneous 20,300 439.42 31,540.60 5,055.83 - 15,244.17 24.91% TOTAL REVENUES 2,326,109 59,119.42 814,918.60 737,088.83 - 1,589,020.17 31.69% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies 5,000 - - - - 5,000.00 0.00% Operations Support 109 - - - - 109.00 0.00% Professional Services 446,000 - 4,047.50 2,000.00 - 444,000.00 0.45% Maintenance Services 1,000 - - - - 1,000.00 0.00% TOTAL NON DEPARTMENTAL 452,109 - 4,047.50 2,000.00 - 450,109.00 0.44% MISC & PROJECTS Water Projects 1,750,000 - 9,747.78 - 186,732.71 1,563,267.29 10.67% TOTAL MISC & PROJECTS 1,750,000 - 9,747.78 - 186,732.71 1,563,267.29 10.67% TOTAL EXPENDITURES 2,202,109 - 13,795.28 2,000.00 186,732.71 2,013,376.29 8.57% REVENUE OVER(UNDER) EXPENDITURES 124,000 735,089 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2014 ******************************************************* 2 0 1 3 - 2 0 1 4 ******************************************************* 411-CAPITAL RECOVERY WATER CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 83.33% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Fees 000-455900 Capital Recovery - Water 880,200 58,680.00 783,378.00 732,033.00 - 148,167.00 83.17% TOTAL Fees 880,200 58,680.00 783,378.00 732,033.00 - 148,167.00 83.17% Fund Transfers 000-481000 Transfer from Reserves 1,425,609 - - - - 1,425,609.00 0.00% TOTAL Fund Transfers 1,425,609 - - - - 1,425,609.00 0.00% Miscellaneous 000-491000 Interest Earned 300 - 24,112.20 192.44 - 107.56 64.15% 000-491200 Investment Income 45,000 439.42 50,368.67 4,863.39 - 40,136.61 10.81% 000-491800 Gain/Loss - - (19,943.83) - - - 0.00% 000-491900 Unrealized Gain/Loss-Cap One (25,000) - (22,996.44) - - (25,000.00) 0.00% TOTAL Miscellaneous 20,300 439.42 31,540.60 5,055.83 - 15,244.17 24.91% TOTAL REVENUES 2,326,109 59,119.42 814,918.60 737,088.83 - 1,589,020.17 31.69% C I T Y O F S C H E R T Z **************************************************** 2 0 1 3 - 2 0 1 4 ***************************************************** REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2014 Cash in Bank Claim on Operating Cash Pool-Checking 1,080,923.29$ Cash in Investments Lone Star Investment-Capital Recovery Water 3,692,606.62 Total Cash in Bank & Investments 4,773,529.91$ CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2014 CAPITAL RECOVERY WATER 421-CAPITAL RECOVERY SEWER CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 569,760 53,121.48 496,257.84 417,615.38 - 152,144.62 73.30% Fund Transfers - - - - - - 0.00% Miscellaneous - 1,923.33 - 11,838.60 - (11,838.60) 0.00% TOTAL REVENUES 569,760 55,044.81 496,257.84 429,453.98 - 140,306.02 75.37% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 4,000 358.97 5,603.65 3,932.26 - 67.74 98.31% Fund Charges/Transfers 120,000 - - - - 120,000.00 0.00% TOTAL NON DEPARTMENTAL 124,000 358.97 5,603.65 3,932.26 - 120,067.74 3.17% MISC & PROJECTS Sewer Projects - - 125,587.26 6,042.30 - (6,042.30) 0.00% TOTAL MISC & PROJECTS - - 125,587.26 6,042.30 - (6,042.30) 0.00% TOTAL EXPENDITURES 124,000 358.97 131,190.91 9,974.56 - 114,025.44 8.04% REVENUE OVER(UNDER) EXPENDITURES 445,760 419,479 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2014 ******************************************************* 2 0 1 3 - 2 0 1 4 ******************************************************* 421-CAPITAL RECOVERY SEWER CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 91.67% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Fees 000-455910 Capital Recovery - Waste Wtr 500,400 47,721.48 408,057.84 411,549.38 - 88,850.62 82.24% 000-455913 Cap Recovery-North Sewer Tr 69,360 5,400.00 88,200.00 6,066.00 - 63,294.00 8.75% TOTAL Fees 569,760 53,121.48 496,257.84 417,615.38 - 152,144.62 73.30% Miscellaneous 000-491000 Interest Earned - - - 104.59 - (104.59) 0.00% 000-491200 Investment Income - 2,303.18 - 28,782.63 - (28,782.63) 0.00% 000-491800 Gain/Loss - - - (40,015.93) - 40,015.93 0.00% 000-491900 Unrealized Gain/Loss-Cap One - (379.85) - 22,967.31 - (22,967.31) 0.00% TOTAL Miscellaneous - 1,923.33 - 11,838.60 - (11,838.60) 0.00% TOTAL REVENUES 569,760 55,044.81 496,257.84 429,453.98 - 140,306.02 75.37% C I T Y O F S C H E R T Z **************************************************** 2 0 1 3 - 2 0 1 4 ***************************************************** REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2014 Cash in Bank Claim on Operating Cash Pool-Checking 634,247.43$ Cash in Investments Lone Star Investment-Capital Recovery Sewer 1,451,515.45 Capital One-Investment 1,726,299.69 Total Cash in Bank & Investments 3,812,062.57$ CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31st, 2014 CAPITAL RECOVERY SEWER 505-TAX I&S CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 5,204,493 9,901.05 5,050,816.58 5,286,790.76 - (82,297.76) 101.58% Fund Transfers 1,069 - - - - 1,069.00 0.00% Miscellaneous 391,213 21,132.19 390,426.39 367,551.02 - 23,661.98 93.95% TOTAL REVENUES 5,596,775 31,033.24 5,441,242.97 5,654,341.78 - (57,566.78) 101.03% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 42,350 400.00 1,350.00 2,150.00 - 40,200.00 5.08% Debt Service 5,554,425 292,871.86 5,159,422.11 5,343,193.56 - 211,231.44 96.20% TOTAL GENERAL GOVERNMENT 5,596,775 293,271.86 5,160,772.11 5,345,343.56 - 251,431.44 95.51% TOTAL EXPENDITURES 5,596,775 293,271.86 5,160,772.11 5,345,343.56 - 251,431.44 95.51% ** REVENUE OVER(UNDER) EXPEND - 308,998.22 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2014 ****************************************************** 2 0 1 3 - 2 0 1 4 **************************************************** 505-TAX I & S CURRENT CURRENT PRIOR YEAR CURRRENT Y-T-D BUDGET 91.67% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Taxes 000-411900 Property Tax Revenue 5,204,493 9,901.05 5,050,816.58 5,286,790.76 - (82,297.76) 101.58% TOTAL Taxes 5,204,493 9,901.05 5,050,816.58 5,286,790.76 - (82,297.76) 101.58% Fund Transfers 000-486000 Transfer From Reserves 1,069 - - - - 1,069.00 0.00% TOTAL Fund Transfers 1,069 - - - - 1,069.00 0.00% Miscellaneous 000-491000 Interest Earned 75 - 56.26 48.77 - 26.23 65.03% 000-491200 Investment Earnings 25,000 63.44 27,718.66 1,364.75 - 23,635.25 5.46% 000-495015 Contribution from SED 366,138 21,068.75 369,075.00 366,137.50 - 0.50 100.00% 000-497000 Misc Income - - (6,423.53) - - - 0.00% TOTAL Miscellaneous 391,213 21,132.19 390,426.39 367,551.02 - 23,661.98 93.95% TOTAL REVENUES 5,596,775 31,033.24 5,441,242.97 5,654,341.78 - (57,566.78) 101.03% C I T Y O F S C H E R T Z ***************************************************** 2 0 1 3 - 2 0 1 4 ***************************************************** REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2014 505-TAX I & S GENERAL GOVERNMENT CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 91.67% OF NON DEPARTMENTAL BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Professional Services 101-541500 Paying Agent 2,350 400.00 800.00 2,150.00 - 200.00 91.49% 101-541502 Cost of Bond Issuance 40,000 - 550.00 - - 40,000.00 0.00% TOTAL Professional Services 42,350 400 1,350.00 2,150.00 - 40,200.00 5.08% Debt Service 101-555612 Bond-GO Refunding 2010-Principal 260,000 - 250,000.00 260,000.00 - - 100.00% 101-555612.1 Bond-GO Refunding 2010 Interest 70,750 33,750.00 77,125.00 70,750.00 - - 100.00% 101-555622 Schertz C O SR2003-Principal - - 210,000.00 - - - 0.00% 101-555622.1 Schertz C O SR2003-Interest - - 3,832.50 - - - 0.00% 101-555624 Comm Proj Bond-SR04-Principal - - 325,000.00 - - - 0.00% 101-555624.1 Comm Proj Bond SR04-Interest - - 6,906.25 - - - 0.00% 101-555626 LS&D SR2006-Principal 200,000 - 200,000.00 200,000.00 - - 100.00% 101-555626.1 LS&D SR2006-Interest 634,982 105,709.36 642,981.25 425,200.00 - 209,782.00 66.96% 101-555628 CO Bond 2007-Principal 112,834 - 109,533.33 112,833.33 - 0.67 100.00% 101-555628.1 CO Bond 2007-Interest 14,106 - 18,498.14 14,105.86 - 0.14 100.00% 101-555629 GO Bond 2007-Principal 245,000 - 235,000.00 245,000.00 - - 100.00% 101-555629.1 GO Bond 2007-Interest 179,792 - 189,418.72 179,321.52 - 470.48 99.74% 101-555630 GO Bond SR2008 Principal 430,000 - 385,000.00 430,000.00 - - 100.00% 101-555630.1 GO Bond SR2008 Interest 332,259 - 349,088.25 332,258.50 - 0.50 100.00% 101-555631 GO Bond SR2009 Principal 590,000 - 510,000.00 590,000.00 - - 100.00% 101-555631.1 BO Bond SR2009 Interest 314,201 153,412.50 327,950.00 314,200.00 - 1.00 100.00% 101-555633 GO SR2011 Principal 210,000 - 200,000.00 210,000.00 - - 100.00% 101-555633.1 GO SR2011 Interest 358,038 - 367,237.50 358,037.50 - 0.50 100.00% 101-555634 GO SR2011A Refund Principal 615,000 - 70,000.00 615,000.00 - - 100.00% 101-555634.1 GO SR2011A Refund Interest 145,916 - 153,067.41 144,941.53 - 974.47 99.33% 101-555635 GO SR2012 Principal 285,000 - 295,000.00 285,000.00 - - 100.00% 101-555635.1 GO SR2012 Interest 219,284 - 233,783.76 219,283.76 - 0.24 100.00% 101-555636 Tax Note - SR2013 - Principal 160,000 - - 160,000.00 - - 100.00% 101-555636.1 Tax Note - SR2013 - Interest 11,223 - - 11,222.38 - 0.62 99.99% 101-555637 Tax Note - SR 2013A - Principal 155,000 - - 155,000.00 - - 100.00% 101-555637.1 Tax Note - SR2013 - Interest 11,040 - - 11,039.18 - 0.82 99.99% TOTAL Debt Service 5,554,425 292,871.86 5,159,422.11 5,343,193.56 - 211,231.44 96.20% TOTAL EXPENDITURES 5,596,775 293,271.86 5,160,772.11 5,345,343.56 - 251,431.44 95.51% C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2014 ***************************************************** 2 0 1 3 - 2 0 1 4 ***************************************************** Cash in Bank Claim on Operating Cash Pool-Checking 620.45$ Cash in Investments MBIA Investment- Tax I&S 825,576.39 Total Cash in Bank & Investments 826,196.84$ CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31st, 2014 TAX I&S 620-SED CORPORATION CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 3,440,944 234,128.46 2,885,427.39 3,146,507.04 - 294,436.96 91.44% Miscellaneous 10,175 425.98 6,976.74 7,190.94 - 2,984.06 70.67% TOTAL REVENUES 3,451,119 234,554.44 2,892,404.13 3,153,697.98 - 297,421.02 91.38% EXPENDITURE SUMMARY ECONOMIC DEVELOPMENT Personnel Services 326,237 31,579.43 269,017.48 275,139.69 - 51,097.31 84.34% Supplies 1,250 6.76 481.88 470.89 - 779.11 37.67% Human Services 200 - - - - 200.00 0.00% City Support Services 16,545 - 1,212.05 1,174.29 - 15,370.71 7.10% Utility Services 2,795 214.16 1,040.13 1,736.59 - 1,058.41 62.13% Operations Support 148,200 745.57 100,012.70 95,383.53 4,427.20 48,389.27 67.35% Staff Support 18,050 906.88 4,398.43 6,092.31 2,421.51 9,536.18 47.17% City Assistance 1,325,000 - 587.95 501,524.63 - 823,475.37 37.85% Professional Services 102,500 1,306.50 152,844.04 17,438.91 - 85,061.09 17.01% Fund Charges/Transfers 503,605 32,524.33 595,099.37 492,148.88 - 11,456.12 97.73% Debt Service 427,672 - 428,503.50 427,671.25 - 0.75 100.00% Operating Equipment 2,500 - 362.23 38.99 - 2,461.01 1.56% TOTAL ECONO DEVELOPMENT 2,874,554 67,283.63 1,553,559.76 1,818,819.96 6,848.71 1,048,885.33 63.51% MISC & PROJECTS PROJECTS 200,000 - - - - 200,000.00 0.00% TOTAL MISC & PROJECTS 200,000 - - - 200,000.00 0.00% TOTAL EXPENDITURES 3,074,554 67,283.63 1,553,559.76 1,818,819.96 6,848.71 1,248,885.33 59.38% ** REVENUE OVER(UNDER) EXPEND 376,565 1,334,878.02 C I T Y O F S C H E R T Z ***************************************************** 2 0 1 3 - 2 0 1 4 ***************************************************** REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2014 620-SED CORPORATION CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 91.67% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Taxes 000-411500 Sales Tax Revenue (4B)3,440,944 234,128.46 2,885,427.39 3,146,507.04 - 294,436.96 91.44% TOTAL Taxes 3,440,944 234,128.46 2,885,427.39 3,146,507.04 - 294,436.96 91.44% Miscellaneous 000-491000 Interest Earned 175 - 111.53 227.78 - (52.78) 130.16% 000-491200 Investment Earnings 10,000 425.98 6,865.21 6,963.16 - 3,036.84 69.63% TOTAL Miscellaneous 10,175 425.98 6,976.74 7,190.94 - 2,984 70.67% TOTAL REVENUES 3,451,119 234,554.44 2,892,404.13 3,153,697.98 - 297,421.02 91.38% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) *************************************************** 2 0 1 3 - 2 0 1 4 *************************************************** AS OF: AUGUST 31st, 2014 Cash in Bank Claim on Operating Cash Pool-Checking 456,465.93$ Cash in Investments MBIA Investment-Economic Development Corp 5,516,426.00 Schertz Bank & Trust-Certificate of Deposit 1,044,185.44 Total Cash in Bank & Investments 7,017,077.37$ CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31st, 2014 SED CORPORATION OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2013-14 240,623 328,635 277,289 208,130 364,222 243,967 270,738 390,528 346,223 224,288 340,166 2012-13 219,717 287,520 237,123 212,096 316,358 207,915 202,689 330,324 272,337 281,818 325,062 243,585 2011-12 214,497 231,818 169,596 207,911 230,700 182,541 173,698 267,965 199,040 204,426 287,707 220,125 2010-11 171,042 166,132 173,802 177,864 235,199 163,627 141,650 212,924 204,332 171,256 226,531 192,615 2009-10 150,192 169,257 140,629 144,175 238,531 146,589 136,939 184,582 175,160 163,328 210,780 201,402 10% 14% 17% -2% 15% 17% 34% 18% 27% -20% 5% $- $50,000 $100,000 $150,000 $200,000 $250,000 $300,000 $350,000 $400,000 $450,000 4B SALES TAX INVESTMENT REPORT C I T Y O F S C H E R T Z FOR MONTH ENDING AUGUST 31st, 2014 INVESTMENT POOLS Beginning Deposits/Interest Ending Ending Par Maturity Weighted Book Value Yield Purchases Withdrawals Earned Book Value Mkt Value Value Date Avg Mat. OPERATIONS-BANK CASH Schertz Bank & Trust - Pooled Cash 7,341,035.33 0.0500 4,994,764.01 5,470,947.72 278.02 6,865,129.64 6,865,129.64 6,865,129.64 N/A Schertz Bank & Trust - PEG Fund 421,789.80 0.0000 13,585.66 - - 435,375.46 435,375.46 435,375.46 N/A TOTAL OPERATIONS 7,762,825.13 5,008,349.67 5,470,947.72 278.02 7,300,505.10 7,300,505.10 7,300,505.10 - LOGIC General Fund 5,638,876.31 0.0927 - - 443.94 5,639,320.25 5,639,320.25 5,639,320.25 N/A 56 Days G/F-Equipment Replacement 73,637.20 0.0927 - - 5.81 73,643.01 73,643.01 73,643.01 N/A 56 Days G/F-Vehicle Replacement 211,223.19 0.0927 - - 16.64 211,239.83 211,239.83 211,239.83 N/A 56 Days G/F-Air Conditioner Replacement 171,543.66 0.0927 - - 13.51 171,557.17 171,557.17 171,557.17 N/A 56 Days SR2009 Bond-Street Projects(II)1,030,001.93 0.0927 - - 81.09 1,030,083.02 1,030,083.02 1,030,083.02 N/A 56 Days TOTAL LOGIC 7,125,282.29 - - 560.99 7,125,843.28 7,125,843.28 7,125,843.28 - LONESTAR Capital Recovery - Sewer 1,451,342.72 0.1400 - - 172.73 1,451,515.45 1,451,515.45 1,451,515.45 N/A 67 Days Capital Recovery - Water 3,692,167.20 0.1400 - - 439.42 3,692,606.62 3,692,606.62 3,692,606.62 N/A 67 Days Drainage Fund 605,577.01 0.1400 - - 72.07 605,649.08 605,649.08 605,649.08 N/A 67 Days Facilities Master Plan 95,110.38 0.1400 - - 11.32 95,121.70 95,121.70 95,121.70 N/A 67 Days GO SR2011 Animal Shelter 35,904.44 0.1400 - 1,063.66 4.25 34,845.03 34,845.03 34,845.03 N/A 67 Days GO SR2011 Athletic Fields 877,534.43 0.1400 - - 104.44 877,638.87 877,638.87 877,638.87 N/A 67 Days GO SR2011 Soccer Fields 576,331.97 0.1400 - 492,284.99 57.52 84,104.50 84,104.50 84,104.50 N/A 67 Days GO SR2011 Swimming Pool 6,004,912.17 0.1400 - 6,878.72 714.51 5,998,747.96 5,998,747.96 5,998,747.96 N/A 67 Days GO SR2012 Downtown Improvements 1,003,056.70 0.1400 - - 119.38 1,003,176.08 1,003,176.08 1,003,176.08 N/A 67 Days Sewer/CCMA Project 2,058,243.76 0.1400 - - 244.96 2,058,488.72 2,058,488.72 2,058,488.72 N/A 67 Days W/S-Customer Deposits 295,250.70 0.1400 - - 35.14 295,285.84 295,285.84 295,285.84 N/A 67 Days W/S-Equipment Repl/Cap.Imp 177,518.55 0.1400 - - 21.13 177,539.68 177,539.68 177,539.68 N/A 67 Days Water&Sewer 638,691.84 0.1400 - - 76.01 638,767.85 638,767.85 638,767.85 N/A 67 Days W/S-Vehicle Replacement 256,441.73 0.1400 - - 30.52 256,472.25 256,472.25 256,472.25 N/A 67 Days Water/SSLG - SAWS 675,169.34 0.1400 - - 80.35 675,249.69 675,249.69 675,249.69 N/A 67 Days TOTAL LONESTAR 18,443,252.94 - 500,227.37 2,183.75 17,945,209.32 17,945,209.32 17,945,209.32 - TEXAS CLASS Tax I&S 776,565.59 0.1000 48,947.36 - 63.44 825,576.39 825,576.39 825,576.39 N/A 68 Days Police Forfeiture 338,935.64 0.1000 - - 27.33 338,962.97 338,962.97 338,962.97 N/A 68 Days Park Fund 1,354.59 0.1000 - - 0.05 1,354.64 1,354.64 1,354.64 N/A 68 Days Economic Development Corporation 5,216,000.92 0.1000 300,000.00 - 425.98 5,516,426.90 5,516,426.90 5,516,426.90 N/A 68 Days Library Board 44,847.71 0.1000 - - 3.67 44,851.38 44,851.38 44,851.38 N/A 68 Days Tree Mitigation 97,323.99 0.1000 - - 7.80 97,331.79 97,331.79 97,331.79 N/A 68 Days Tax Note 2013 Fire Truck 4,929.06 0.1000 - - 0.36 4,929.42 4,929.42 4,929.42 N/A 68 Days Hotel Tax 299,139.25 0.1000 - - 24.18 299,163.43 299,163.43 299,163.43 N/A 68 Days Special Events Fund 16,781.35 0.1000 - - 1.29 16,782.64 16,782.64 16,782.64 N/A 68 Days Citywide Projects SR2007 803,270.57 0.1000 - - 64.84 803,335.41 803,335.41 803,335.41 N/A 68 Days Tax Note 2013 A P25 24,209.39 0.1000 4,737.15 24,210.87 1.55 4,737.22 4,737.22 4,737.22 N/A 68 Days TOTAL TEXAS CLASS 7,623,358.06 353,684.51 24,210.87 620.49 7,953,452.19 7,953,452.19 7,953,452.19 - C I T Y O F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING AUGUST 31st, 2014 C I T Y O F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING AUGUST 31st, 2014 Beginning Interest Ending Par Maturity INVESTMENT MANAGED ACCOUNT Book Value Yield Purchases Withdrawals Earned Book Value Mkt Value Value Date Avg Mat. Capital One General Fund 1,359,253.69 1.3200 - 279.58 2.90 1,358,977.01 1,346,792.94 1,323,398.26 N/A 518 Days Capital One Capital Recovery Sewer 1,746,787.56 1.4500 - 358.56 1.47 1,746,430.47 1,726,299.69 1,694,489.35 N/A 528 Days TOTAL CAPITAL ONE 3,106,041.25 - 638.14 4.37 3,105,407.48 3,073,092.63 3,017,887.61 - C. D. CERTIFICATES OF DEPOSIT Term SB&T-Water&Sewer 1,064,372.78 0.4000 - - - 1,064,372.78 1,067,137.23 1,064,372.78 1/7/2015 365 Days Schertz Economic Development Corp.1,044,185.44 0.6000 - - - 1,044,185.44 1,045,558.62 1,044,185.44 12/10/2014 180 Days TOTAL C.D.s 2,108,558.22 - - - 2,108,558.22 2,112,695.85 2,108,558.22 TOTAL PORTFOLIO 0.24 3,647.62$ 45,538,975.59$ 45,510,798.37$ 45,451,455.72$ 105 Days City Manager/Executive Director Finance Director Assistant Finance Director Financial Analyst TOTAL OPERATIONS 16% TOTAL LOGIC 16% TOTAL LONESTAR 39% TOTAL TEXAS CLASS 17% TOTAL CAPITAL ONE 7% TOTAL C.D.s 5% City Portfolio By Investment Type Operations, $15,992,523.37 Projects, $12,660,790.98 Debt Service Fund, $825,576.39 Special Revenue Funds, $14,774,869.19 Designated Funds, $1,257,038.44 City Portfolio By Use OCT-13 NOV-13 DEC-13 JAN-14 FEB-14 MAR-14 APR-14 MAY-14 JUN-14 JUL-14 AUG-14 SEP-14 1 Month T-Bill 0.0300 0.0500 0.0100 0.0300 0.0400 0.0300 0.0200 0.0400 0.0200 0.0100 0.0200 3 Month T-Bill 0.0400 0.0600 0.0700 0.0200 0.0500 0.0500 0.0300 0.0400 0.0400 0.0300 0.0300 6 Month T-Bill 0.0800 0.1100 0.1000 0.0600 0.0800 0.0700 0.0500 0.0600 0.0700 0.0500 0.0500 Schertz Portfolio 0.2879 0.2857 0.2394 0.2315 0.2227 0.2324 0.2254 0.2303 0.2438 0.2457 0.2458 Schertz Bank&Trust 0.0500 0.0500 0.0500 0.0500 0.0500 0.0500 0.0500 0.0500 0.0500 0.0500 0.0500 CD 365 Days 0.4000 0.4000 0.4000 0.4000 0.4000 0.4000 0.4000 0.4000 0.4000 0.4000 0.4000 CD 180 Days 0.4000 0.4000 0.4000 0.4000 0.4000 0.4000 0.4000 0.4000 0.6000 0.6000 0.6000 LOGIC 0.1183 0.1085 0.0965 0.0884 0.0824 0.0874 0.0829 0.0989 0.1087 0.0989 0.0927 LoneStar 0.1500 0.1500 0.1600 0.1400 0.1200 0.1300 0.1400 0.1400 0.1500 0.1400 0.1400 MBIA 0.0900 0.1000 0.1000 0.1000 0.1000 0.1000 0.1000 0.1000 0.1000 0.1000 0.1000 Capital One 2.0347 1.9734 1.5376 1.5357 1.5356 1.5359 1.4012 1.4000 1.3944 1.3939 1.3939 0.00 0.50 1.00 1.50 2.00 2.50 MONTHLY YIELDS C I T Y O F S C H E R T Z Investment Report Capital One Assets Date:8/31/2014 General Fund Assets Cash & Equivalents Due Maturity Shares Cost Mrk Value Projected Annual Income Current Yield Fidelity Prime Mmkt Port Fd #690 58,398.26 58,398.26 58,398.26 31.00 0.05 Total Cash & Equivalents 58,398.26 58,398.26 58,398.26 31.00 0.05% Fixed Income Federal Farm Cr Bks Cons Systemwide Bds 12/16/2015 472.00 100,000.00 116,185.00 105,861.00 4,875.00 4.20 Federal Natl Mtg Assn 1/30/2017 883.00 100,000.00 102,366.80 101,089.00 1,250.00 1.22 Federal Home Ln Mtg Corp Reference Nts 11/25/2014 86.00 200,000.00 200,609.40 200,304.00 1,500.00 0.75 US Treasury Note 3/15/2017 927.00 100,000.00 99,835.94 100,012.00 750.00 0.75 US Treasury Note 11/30/2015 456.00 60,000.00 61,936.72 60,876.60 825.00 1.33 US Treasury Note 5/31/2016 639.00 325,000.00 337,135.74 332,536.75 5,687.00 1.69 US Treasury Note 8/31/2016 731.00 275,000.00 277,401.37 277,675.75 2,750.00 0.99 US Treasury Note 9/15/2014 15.00 105,000.00 105,107.78 105,008.40 262.00 0.25 Total Fixed Income 1,265,000.00 1,300,578.75 1,283,363.50 17,899.00 1.38% Total Assets 517.34 1,323,398.26 1,358,977.01 1,341,761.76 17,930.00 1.32% Capital Recovery Assets Cash & Equivalents Due Maturity Shares Cost Mrk Value Projected Annual Income Current Yield Fidelity Prime Mmkt Port Fd #690 29,489.35 29,489.35 29,489.35 15.00 0.05 Total Cash & Equivalents 29,489.35 29,489.35 29,489.35 15.00 0.05% Fixed Income Federal Farm Cr Bks Cons Systemwide Bds 12/16/2015 472.00 200,000.00 230,779.00 211,722.00 9,750.00 4.22 Federal Natl Mtg Assn 12/21/2015 477.00 100,000.00 99,989.10 100,128.00 375.00 0.38 Federal Home Ln Mtg Corp Reference Nts 11/25/2014 86.00 220,000.00 220,078.68 220,334.40 1,650.00 0.75 US Treasury Note 3/15/2017 927.00 150,000.00 149,753.91 150,018.00 1,125.00 0.75 US Treasury Note 11/30/2015 456.00 305,000.00 312,082.23 309,456.05 4,193.00 1.34 US Treasury Note 5/31/2016 639.00 350,000.00 364,567.38 358,116.50 6,125.00 1.68 US Treasury Note 7/15/2016 684.00 340,000.00 339,690.82 341,071.00 2,125.00 0.63 Total Fixed Income 1,665,000.00 1,716,941.12 1,690,845.95 25,343.00 1.48% Total Assets 527.93 1,694,489.35 1,746,430.47 1,720,335.30 25,358.00 1.45%