Loading...
Q4- September 2017 FinancialsQuarterly t t t C' Texas ffY OF S HERT REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF.. S P A EMBER 0 H 2 i t 2111 6 " 201'-' 196,350.00 CURRENT CURRENT Y -T -D BUDGET BUDGET ` -T-D ACTUAL ENCUMBR BALANCE 100% OF BUDGET General Fund, 101 Total Expenditures 186,350.00 133,284.14 818.40 52,247.46 Total Revenues 29,833,195.00 29,574,297.58 - 198,897.42 99.33% Total General Government 7,130,310.20 5,961,559.07 41,601.07 1,127,150.06 84.19% Total Public Safety 12,499,293.49 12,240,994.19 28,228.99 230,070.31 98.16% Total Public Environment 1,267,162.00 1,264,786.64 - 2,375.36 99.81% Total Parks & Recreation 1,811,726.00 1,716,692.53 13,050.87 81,982.60 95.47% Total Cultural 907,161.00 904,485.14 232.16 2,443.70 99.73% Total Health 822,479.00 760,539.74 1,302.88 60,636.38 92.63% Total Internal Services 5,054,919.00 4,870,907.69 4,479.25 179,532.06 96.45% Total Misc & Projects 331,993.00 298,521.28 2,535.00 30,936.72 90.68% Total Expenditures 29,825,043.69 28,018,486.28 91,430.22 1,715,127.19 94.25% Revenue Over(Under) Expenditures 8,151.31 1,555,811.30 21,273,817.00 20,454,252.37 40,724.26 778,840.37 General Fund, 101 Total Cash in Bank & Investments Revenue Over(Under) Expenditures 11,651,681.70 19,402.00 2,077,898.38 Total Revenues 196,350.00 148,018.87 - 48,331.13 75.39% Total Expenditures 186,350.00 133,284.14 818.40 52,247.46 71.96% Revenue Over(Under) Expenditures 10,000.00 14,734.73 Special Events Fund, 106 Total Cash in Bank & Investments 86,106.70 Peg Fund, 110 Total Revenues 113,300.00 88,044.66 - 25,255.34 77.71% Total Expenditures 108,600.00 27,129.00 - 81,471.00 2.96% Revenue Over(Under) Expenditures 4,700.00 60,915.66 Peg Fund, 110 Total Cash in Bank & Investments 617,075.10 Water & Sewer, 202 Total Revenues 21,293,219.00 22,532,150.75 - (1,238,931.75) 105.82% Total Expenditures 21,273,817.00 20,454,252.37 40,724.26 778,840.37 96.34% Revenue Over(Under) Expenditures 19,402.00 2,077,898.38 Water & Sewer, 202 Total Cash in Bank & Investments 7,792,857.78 Total Revenues 190,700.00 101,715.52 - 88,984.48 0.53 Total Expenditures 190,700.00 78,625.99 109,829.69 2,244.32 REVENUE AND EXPENSE REPORT(U?',IAUDITIED) Revenue Over(Under) Expenditures 0.00 Quarterly Statement Schertz, Texas AS OF SEPTEMBER 0TH 017 pg 2016-2017 Park, 317 Total Cash in Bank & Investments CURRENT CURRENT Y -T -D BUDGET " 100% OF Tree Mitigation, 319 BUDGET Y -T -D ACTUAL ENCUMBR BALANCE ANCE BUDGET EMS, 203 77,427.01 - 64,572.99 0.55 Total Expenditures 142,000.00 85,901.00 Total Revenues 0.60 9,159,812.17 9,142,412.81 - 567,399.36 99.81% Total Expenditures 9,043,895.81 8,068,478.19 504,017.15 472,576.21 94.79% Revenue Over(Under) Expenditures 115,916.36 1,073,934.62 EMS, 203 Total Cash in Bank & Investments Total Revenues 1,040,600.00 (87,550.40) 0.00 (431,246.80) 1.41 Total Expenditures 156,000.00 1,000.00 0.00 155,000.00 0.01 Revenue Over(Under) Expenditures 884,600.00 1,470,846.80 Drainage, 204 Capital Recovery Water, 411 Total Cash in Bank & Investments 4,845,362.41 Total Revenues 1,632,200.00 1,166,568.39 - 465,631.61 71.47% Total Expenditures 1,606,764.00 1,066,235.27 8,120.00 532,408.73 66.86% Revenue Over(Under) Expenditures 25,436.00 100,333.12 Drainage, 204 Total Cash in Bank & Investments 1,073,264.01 Hotel Tax, 314 Total Revenues 611,452.00 511,760.70 - 99,691.30 0.84 Total Expenditures 260,995.00 193,949.78 - 67,045.22 0.74 Revenue Over(Under) Expenditures 1 350.457.00 317.810.92 Total Revenues 190,700.00 101,715.52 - 88,984.48 0.53 Total Expenditures 190,700.00 78,625.99 109,829.69 2,244.32 0.99 Revenue Over(Under) Expenditures 0.00 23,089.53 Park, 317 Total Cash in Bank & Investments 426,950.25 Tree Mitigation, 319 Total Revenues 142,000.00 77,427.01 - 64,572.99 0.55 Total Expenditures 142,000.00 85,901.00 - 56,099.00 0.60 Revenue Over(Under) Expenditures 0.00 (8,473.99) Tree Mitigation, 319 Total Cash in Bank & Investments 331,912.47 Capital Recovery Water, 411 Total Revenues 1,040,600.00 1,471,846.80 0.00 (431,246.80) 1.41 Total Expenditures 156,000.00 1,000.00 0.00 155,000.00 0.01 Revenue Over(Under) Expenditures 884,600.00 1,470,846.80 Capital Recovery Water, 411 Total Cash in Bank & Investments 4,845,362.41 Quarterly Statement Schertz, Texas REVENUE AND EXPENSE REPORT(WIMUDITMD) AS OF SEPTEMBER 0TH 017 pg 2016-2017 6,614,581.00 CURRENT CURRENT Y -T -D BUDGET " BUDGET Y -T -D ACTUAL ENCUMBR BALANCE ANCE 100% OF BUDGET Capital Recovery Sewer, 421 1.01 1 6,614,581.00 6,520,115.55 Total Revenues 625,500.00 781,092.05 0.00 (155,592.05) 125 Total Expenditures 235,500.00 5,355.94 0.00 80,144.06 0.06 Revenue Over(Under) Expenditures 390,000.00 775,736.11 SED Corporation, 620 Capital Recovery Sewer, 421 Total Cash in Bank & Investments 5,614,148.30 Total Revenues 6,614,581.00 6,658,620.80 0.00 (44,039.80) 1.01 Total Expenditures 6,614,581.00 6,520,115.55 0.00 94,465.45 0.99 Revenue Over(Under) Expenditures 0.00 138,505.25 1 &S, 505 Total Cash in Bank & Investments 1,450,082.13 SED Corporation, 620 Total Revenues 3,738,260.00 3,746,611.80 0.00 (8,351.80) 1.00 Total Expenditures 2,062,617.00 903,836.16 139.49 1,158,641.12 0.44 Revenue Over(Under) Expenditures 1,675,643.00 2,842,775.64 SED Corporation, 620 Total Cash in Bank & Investments 13,392,435.87 Total Cash in Bank & Investments 48,673,091.52 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30th, 2017 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 16 - 2 0 17 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET 7w9ggl III ;&III TAILGI I Taxes 18,720,400.00 1,979,711.38 17,781,461.91 18,449,209.63 - 271,190.37 98.55% Franchises 2,306,600.00 684,688.31 2,151,790.71 2,213,196.75 - 93,403.25 95.95% Permits 1,404,500.00 735,139.00 1,178,391.14 2,304,765.35 - (900,265.35) 164.10% Licenses 51,160.00 11,909.00 55,657.00 63,164.00 - (12,004.00) 123.46% Fees 2,251,582.00 685,454.51 2,474,120.72 2,654,513.51 - (402,931.51) 117.90% Fines 28,000.00 5,732.73 25,738.67 23,339.27 - 4,660.73 83.35% Inter - Jurisdictional 879,508.00 326,015.96 791,548.63 876,885.08 - 2,622.92 99.70% Fund Transfers 3,642,745.00 672,323.84 1,680,201.56 2,484,140.08 - 1,158,604.92 68.19% Miscellaneous 548,700.00 61,193.26 581,844.62 505,083.91 - 43,616.09 92.05% TOTAL REVENUES 29,833,195.00 5,162,167.99 26,720,754.96 29,574,297.58 - 258,897.42 99.13% EXPENDITURE SUMMARY GENERAL GOVERNMENT [r "e*lwluo l Personnel Services 32,132.00 9,135.23 24,366.25 33,360.97 - (1,228.97) 103.82% Supplies 1,300.00 240.15 455.75 630.11 - 669.89 48.47% City Support Services 43,500.00 - 67,018.33 34,368.74 - 9,131.26 79.01% Operations Support 500.00 - 221.56 336.04 - 163.96 67.21% Staff Support 28,910.00 3,909.03 15,028.68 23,993.44 - 4,916.56 82.99% Operating Equipment 640.00 - - 723.00 - (83.00) 112.97% TOTAL CITY COUNCIL 106,982.00 13,284.41 107,090.57 93,412.30 - 13,569.70 87.32 %` CITY MANAGER Personnel Services 1,066,365.00 179,786.24 807,431.06 1,048,108.48 - 18,256.52 98.29% Supplies 2,750.00 1,015.09 1,826.80 2,285.76 - 464.24 83.12% City Support Services 7,535.00 103.64 1,071.22 5,093.49 - 2,441.51 67.60% Utility Services - 114.38 114.82 232.87 - (232.87) 0.00% Operations Support - - - 23.98 - (23.98) 0.00% Staff Support 35,745.00 7,758.58 21,310.14 22,977.32 212.75 12,554.93 64.88% TOTAL CITY MANAGER 1,1;12,395.00 188,777.93 831,754.04 1,078,721.90 212.75 33,460.35 96.99% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30th, 2017 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 16 - 2 0 17 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET MUNICIPAL COURT Personnel Services 287,455.00 70,084.98 278,965.72 274,744.48 - 12,710.52 95.58% Supplies 2,000.00 901.36 1,566.70 1,622.95 - 377.05 81.15% City Support Services 1,000.00 392.98 - 430.76 - 569.24 43.08% Operations Support 2,058.00 869.45 3,125.00 869.45 - 1,188.55 42.25% Staff Support 7,310.00 2,206.23 5,585.58 4,963.62 250.00 2,096.38 71.32% Court Support 520.00 - 192.00 186.00 - 334.00 35.77% Professional Services 67,380.00 15,390.00 46,290.88 56,230.00 - 11,150.00 83.45% Maintenance Services 3,192.00 1,222.00 1,800.00 3,142.00 - 50.00 98.43% Operating Equipment - - 3,835.13 39.02 - (39.02) 0.00% TOTAL MUNICIPAL COURT 370,915.00 91,067.00 341,361.01 342,228.28 250.00 28,436.72 92.33 %' CUSTOMER RELATIONS -311 Personnel Services 118,644.00 30,085.98 108,939.63 117,567.12 - 1,076.88 99.09% Supplies 104.00 - 175.89 40.30 - 63.70 38.75% Staff Support 521.00 - 348.82 170.00 - 351.00 32.63% TOTAL CUSTOMER RELATIONS -311 119,269.00 30,085.98 109,464.34 117,777.42 1,491.58 98.75% PLANNING & ZONING Personnel Services 196,345.00 50,435.05 145,345.71 193,914.63 - 2,430.37 98.76% Supplies 3,060.00 755.56 2,568.35 1,450.79 - 1,609.21 47.41% City Support Services - - 295.20 - - - 0.00% Operations Support 150.00 - 264.09 70.29 - 79.71 46.86% Staff Support 24,299.00 1,339.14 9,684.59 18,912.92 520.00 4,866.08 79.97% Professional Services 170.00 5.00 39 105 65.00 61.76% Operating Equipment - - 129.98 - 3,400.40 (3,400.40) 0.00% TOTAL PLANNING '& ZONING 224,024.00 52,534.75 158,326.92 214,453:63 3,920:40 5,649.97 97.48 %li LEGAL SERVICES Operations Support 11,229.00 10,613.32 5,432.28 12,036.11 - (807.11) 107.19% Professional Services 160,771.00 68,737.09 124,931.49 138,661.71 - 22,109.29 86.25% TOTAL LEGAL SERVICES 172,000.00 79,350.41 1130,363.77 150,697 82 -` 21,302.18 87.62°% CITY O F S C H E R TZ REVENUE AND EXPENSE REPORT (UNAUDUED) AS OF: September 30th, 2017 2V1V-2V17 101GENERALFUmn CURRENT CURRENT PRIOR YEAR v-T-D v-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER Y�-DACTUAL ACTUAL ENCUMBR BALANCE BUDGET GENERAL SERVICES 300,422.00 50,426.59 329,418.50 Personnel Services - - 540.830.22 ' ' - 0.00Y4 Supplies 101,64443 88.328.43 145.725.02 0.00% Utility Services - - 178.715.08 - - - 0.00% Staff Support - 11,842.50 165.50 0.00% Maintenance Services ' ' 28.182.58 - - - 0,00% Rental/Leasing 1,661.886.84 59325 1.711.328.61 0.00% Operating Equipment - - 769.97 - - - 0.00% Capital ovuav -_ -_ 23,087.90 -_ p0.289.41> 0J00Y% 142.58% Fund EvontsFnd 1,011700.00 37,446.70 CITY SECRETARY 37,446.70 974.253.30 3.70% Personnel Services 175,687.00 40.707.28 173.572.08 180.387.02 - (4.700.02) 102�68% Supplies 1,350.00 118.04 372.33 1,318.55 - 31.45 97.67% City Support Services 12.500.00 - 9.971.37 4.875.48 - 7.524.54 39.80% Operations Support - - 42.50 ' - - 0.00% Staff Support 6,225.00 1,095.45 4,741.11 3,890.11 - 2,334.89 62.49% TOTAL CITY SECRETARY 195,762.00 47,978.77 188,6W99 190,571.14 - 5,190.86 97.35% City Support Services 300,422.00 50,426.59 329,418.50 378.332.58 - U1.810.59 10325% Operations Support 141,500.00 101,64443 145.725.02 153.00116 (12.10110) 108.55% Staff Support 200.00 - 10,16521 165.50 - 34.50 8275% City Assistance 1.732.157.00 126.020.97 1,661.886.84 1.711.328.61 20.820.39 98.80% Professional Services 71.135.08 7.807.44 03.778.24 71.97441 29,450.00 p0.289.41> 142.58% Fund EvontsFnd 1,011700.00 37,446.70 99.073.05 37,446.70 974.253.30 3.70% TOTAL NON-DEPARTMENTAL 3,323,114.00 323,446.13 2,312,517.16 2,352,84&97 29,450.00 940,815.03 71.69% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30th, 2017 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 16 - 2 0 17 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET PUBLIC AFFAIRS Personnel Services 278,039.00 72,046.79 265,910.00 276,770.59 - 1,268.41 99.54% Supplies 2,300.00 478.22 1,942.28 1,295.51 - 1,004.49 56.33% Operations Support 22,450.00 4,035.04 19,617.91 15,165.16 - 7,284.84 67.55% Staff Support 4,000.00 1,391.00 3,649.23 2,670.00 - 1,330.00 66.75% Professional Services 24,000.00 - - 22,900.00 - 1,100.00 95.42% Operating Equipment 1,000.00 229.00 3,378.83 229.00 - 771.00 22.90% TOTAL PUBLIC AFFAIRS 331,789:00 78,180.05 294,498:25 319,030.26 - 12,758.74 96.15% RECORDS MANAGEMENT Personnel Services 42,832.00 8,394.85 51,517.55 37,907.53 - 4,924.47 88.50% Supplies 250.00 - 74.37 31.22 - 218.78 12.49% Staff Support 350.00 - 87.63 - - 350.00 0.00% Professional Services 12,000.00 2,739.97 8,492.50 9,740.85 - 2,259.15 81.17% Operating Equipment 250.00 - - - - 250.00 0.00% TOTAL RECORDS MANAGEMENT i 55,682.00 111,134.82 60,172.05 47,679.60 -' 8,002`40 85.63% SCHERTZ MAGAZINE Personnel Services 133,608.00 32,243.77 119,363.15 128,997.01 - 4,610.99 96.55% Supplies 200.00 - 127.50 180.85 - 19.15 90.43% Opperations Support 1,120.00 - - 985.25 - 134.75 87.97% Staff Support 1,860.00 255.72 1,297.90 1,500.72 - 359.28 80.68% Professional Services 245,754.00 47,808.47 235,083.81 218,160.44 7,767.92 19,825.64 91.93% Fund Charges /Transfers 10,000.00 - 9,825 - - 10,000.00 0.00% Operating Equipment 126.00 - 999.98 125.98 - 0.02 99.98% TOTAL SCHERTZ MAGAZINE 392,668.00 80,307.96 366,697.34 349,950.25 7,767.92 34,949.83 91.10 %' ENGINEERING Personnel Services 469,086.00 152,022.10 193,599.98 464,056.07 - 5,029.93 98.93% Supplies 1,620.00 1,206.73 785.89 1,615.50 - 4.50 99.72% City Support Services 295.20 - 885.60 295.20 - - 100.00% Utility Services 3,500.00 514.67 397.86 1,190.43 - 2,309.57 34.01% Operations Support 2,550.00 29.98 221.71 101.94 - 2,448.06 4.00% Staff Support 9,475.00 4,612.82 3,250.57 6,431.20 - 3,043.80 67.88% Professional Services 70,800.00 35,592.50 9,510.84 63,578.90 - 7,221.10 89.80% Rental/Leasing 2,825.00 - - 2,824.47 - 0.53 99.98% Operating Equipment 400.00 358.93 - 358.93 - 41.07 89.73% TOTAL ENGINEERING 560,551.20 194,337.73 208,652.45 540,452 64 -' 20,098.56 96.41% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30th, 2017 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 16 - 2 0 17 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET GIS Personnel Services 156,179.00 40,205.67 143,556.99 155,410.11 - 768.89 99.51% Supplies 2,295.00 650.98 1,454.13 2,226.05 - 68.95 97.00% Staff Support 4,600.00 3,083.10 4,515.32 4,014.90 - 585.10 87.28% Rental /Leasing 2,085.00 520.95 2,083.80 2,083.80 - 1.20 0.00% TOTAL GIS 165,159.00 44,460.70 151,610.24 163,734 86 - 1,424.14 9914% TOTAL GENERAL GOVERNMENT 7,130,31020 1,234,946.64 6,148,576.12 5,961,559.07 41,601.07 1,127,150`i06 84.19 %d PUBLIC SAFETY POLICE Personnel Services 6,022,924.00 1,489,018.91 5,633,876.16 5,921,588.71 - 101,335.29 98.32% Supplies 84,323.38 12,588.60 35,440.64 82,014.67 - 2,308.71 97.26% City Support Services 19,081.00 - 19,081.45 21,294.42 - (2,213.42) 111.60% Utility Services 86,637.40 27,196.05 70,333.35 78,640.89 - 7,996.51 90.77% Operations Support 3,065.00 321.94 2,657.73 2,074.64 - 990.36 67.69% Staff Support 125,450.31 55,798.60 97,223.19 119,986.61 1,981.21 3,482.49 97.22% City Assistance 17,347.00 6,325.32 14,173.72 16,259.49 311.40 776.11 95.53% Professional Services 47,528.00 16,176.36 40,492.07 48,012.49 - (484.49) 101.02% Maintenance Services 57,562.95 17,055.15 56,961.38 45,219.68 - 12,343.27 78.56% Rental /Leasing 44,470.00 - - 44,158.64 - 311.36 99.30% Operating Equipment 83,982.05 38,623.55 146,722.23 133,713.79 20,075.00 (69,806.74) 183.12% Capital Outlay 473,196.40 6,257.98 180,183.50 357,603.28 524.70 115,068.42 75.68% TOTAL POLICE 7,065,567.49 1,669,362.46 6,297,145.42 6;870,567.31 22,892.31 172,107.87 97.56% FIRE RESCUE Personnel Services 3,636,545.00 1,041,313.12 3,244,317.12 3,647,597.31 - (11,052.31) 100.30% Supplies 7,607.00 1,391.97 15,820.31 4,961.48 316.00 2,329.52 69.38% Utility Services 47,700.00 17,307.02 39,832.91 49,079.35 - (1,379.35) 102.89% Operations Support 550.00 - 918.30 - - 550.00 0.00% Staff Support 139,450.00 22,279.11 119,383.28 136,416.38 2,061.15 972.47 99.30% City Assistance 22,593.00 18,685.37 16,082.46 22,489.59 - 103.41 99.54% Professional Services 35,200.00 - 13,680.00 32,696.00 - 2,504.00 92.89% Fund Charges /Transfers - - 152,267.99 - - - 0.00% Maintenance Services 41,650.00 16,334.85 45,561.56 40,402.71 - 1,247.29 97.01% Other Costs - 611.01 - 611.01 102.05 (713.06) 0.00% Rental /Leasing 16,890.00 3,950.82 15,915.65 15,915.65 - 974.35 94.23% Operating Equipment 89,675.00 42,230.71 76,827.31 89,154.10 1,210.00 (689.10) 100.77% Capital Outlay 44,500.00 - - 37,207.23 - 7,292.77 83.61% TOTAL FIRE RESCUE 4,082,360.00 1,164,103.98 3,740,606.89 4,076,530.81 3,689.20 2,139.99 99.95% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30th, 2017 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 16 - 2 0 17 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET INSPECTIONS Personnel Services 583,014.00 151,790.58 470,221.05 578,865.84 - 4,148.16 99.29% Supplies 3,835.00 573.04 5,639.91 2,836.28 - 998.72 73.96% Utility Services 5,000.00 1,520.17 3,790.87 3,747.36 - 1,252.64 74.95% Operations Support 2,000.00 329.00 1,266.97 1,845.47 - 154.53 92.27% Staff Support 26,680.00 5,917.21 15,052.00 18,063.38 85.00 8,531.62 68.02% Professional Services 227,000.00 59,382.50 141,369.00 206,557.50 975.00 19,467.50 91.42% Operating Equipment - - 2,188.25 - - - 0.00% TOTAL INSPECTIONS 847,529.00 219,512.50 639,528.05 811,915.83 1,060.00 34,553.17 95.92% MARSHAL'S OFFICE Personnel Services 448,770.00 105,898.37 612,059.94 446,313.01 - 2,456.99 99.45% Supplies 3,350.00 719.97 4,547.90 2,312.65 - 1,037.35 69.03% Utility Services 10,000.00 2,044.67 6,946.47 6,173.23 - 3,826.77 61.73% Operations Support 1,000.00 - 1,504.46 274.85 177.00 548.15 45.19% Staff Support 12,540.00 800.00 10,817.12 5,507.88 373.93 6,658.19 46.90% City Assistance 1,250.00 - 1,422.76 - - 1,250.00 0.00% Maintenance Services 4,700.00 2,500.00 17,184.28 3,700.00 - 1,000.00 78.72% Operating Equipment 4,227.00 214.83 13,732.63 17,698.62 36.55 (13,508.17) 419.57% Capital Outlay 18,000.00 - 62,950.00 - - 18,000.00 0.00% TOTAL MARSHAL'S OFFICE 503,837.00 112,177.84 731,165.56 481,980.24 58748 21,269:28 95.78 %' TOTAL PUBLIC SAFETY 12,499,29149 3,165,156.78 11,408,445.92 12,240,994.19 28,228.99 230,070.31 98.16% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30th, 2017 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 16 - 2 0 17 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET PUBLIC ENVIRONMENT STREETS PARKS DEPARTMENT Personnel Services 741,825.00 182,344.54 666,992.66 730,407.51 - 11,417.49 98.46% Supplies 89,650.00 44,196.96 6,060.08 92,867.79 - (3,217.79) 103.59% Utility Services 151,200.00 77,862.51 151,241.18 167,422.73 - (16,222.73) 110.73% Staff Support 12,750.00 2,211.07 10,265.31 11,586.25 - 1,163.75 90.87% Professional Services 71,705.00 66,667.00 39,416.81 71,704.50 - 0.50 100.00% Maintenance Services 40,000.00 1,592.85 95,089.36 40,093.97 - (93.97) 100.23% Rental /Lease 5,200.00 1,006.75 - 2,763.23 - 2,436.77 53.14% Operating Equipment 12,201.00 7,446.05 38,261.09 12,132.62 - 68.38 99.44% Capital Outlay 142,631.00 - 65,625.40 135,808.04 - 6,822.96 95.22% TOTAL STREETS 1,267,162.00 383,327.73 1,072,951.89 1,264,786.64 - 2,375936 99.81% TOTAL PUBLIC' ENVIRONMENT,' 1,267,162.00 383,327.73 1,072,951:89 1,264,786.64 2,375.36 99.81% PARKS & RECREATION PARKS DEPARTMENT Personnel Services 509,343.00 125,912.31 471,271.32 496,445.54 - 12,897.46 97.47% Supplies 41,315.00 12,042.19 39,258.91 38,934.20 553.37 1,827.43 95.58% City Support Services 11,500.00 3,552.64 5,199.50 12,005.27 - (505.27) 104.39% Utility Services 238,815.74 99,049.35 209,641.81 247,033.27 - (8,217.53) 103.44% Operations Support 2,646.20 - 643.02 1,673.20 - 973.00 63.23% Staff Support 10,625.00 1,480.41 6,136.18 10,351.13 - 273.87 97.42% Professional Services 93,670.00 29,938.35 68,768.77 90,230.14 5,570.32 (2,130.46) 102.27% Maintenance Services 24,717.06 1,291.44 14,722.41 17,352.00 500.00 6,865.06 72.23% Rental /Leasing 40,700.00 9,218.18 36,319.97 37,299.06 - 3,400.94 91.64% Operating Equipment 16,000.00 6,468.64 4,629.32 19,023.71 188.68 (3,212.39) 120.08% Capital Outlay 10,900.00 - 27,840.60 - 6,178.54 4,721.46 56.68% TOTAL PARKS DEPARTMENT 1,000,232.00 288,953.51 884,431.81 970,347.52 12,990.91 16,893.57 98.31 %!' SWIM POOL Supplies 26,700.00 11,231.85 19,928.06 25,814.10 59.96 825.94 96.91% Utility Services 29,000.00 9,692.77 14,978.57 24,900.34 - 4,099.66 85.86% Professional Services 3,800.00 - - 3,632.56 - 167.44 95.59% Maintenance Services 597,778.00 343,394.28 184,104.77 574,709.38 - 23,068.62 96.14% Operating Equipment - 212.21 - - - 0.00% TOTAL SWIM POOL 657,278.00 364,318.90 219,223.61 629,056.38 59.96 28,161.66 95.72 %; CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30th, 2017 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 16 - 2 0 17 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET EVENT FACILITIES Personnel Services 59,006.00 7,623.52 54,522.51 52,855.02 - 6,150.98 89.58% Supplies 12,500.00 777.23 9,298.79 3,351.80 - 9,148.20 26.81% Utility Services 51,750.00 19,565.40 49,864.67 47,116.43 - 4,633.57 91.05% Operations Support 10,900.00 46.52 3,964.47 4,949.05 - 5,950.95 45.40% Staff Support 2,180.00 45.87 893.00 1,351.35 - 828.65 61.99% Operating Equipment 17,880.00 3,993.59 14,941.47 7,664.98 - 10,215.02 42.87% TOTAL EVENT FACILITIES 154,216.00 32,052.13 133,484.91 117,288.63 - 36,927.37 76.05% TOTAL PARKS `& RECREATION 1,811,726.00 685,324.54 1,237,140.33 1,716,692.53 13,050.87 81,982.60 95.47% CULTURAL LIBRARY Personnel Services 716,981.00 191,545.60 669,870.51 728,194.90 - (11,213.90) 101.56% Supplies 15,000.00 4,010.90 14,507.31 13,241.43 - 1,758.57 88.28% Utility Services 55,600.00 25,088.47 50,901.37 46,976.90 - 8,623.10 84.49% Operations Support 3,150.00 371.96 2,924.03 1,499.88 - 1,650.12 47.62% Staff Support 6,615.00 1,093.21 4,195.74 5,519.67 - 1,095.33 83.44% Professional Services 2,315.00 - 2,247.00 2,252.00 - 63.00 97.28% Maintenance Services - - (160.00) - - - 0.00% Operating Equipment 107,500.00 31,313.80 99,156.83 106,800.36 232.16 467.48 99.57% TOTAL LIBRARY 907,161.00 253,423.94 843,642.79 904,485.14 232.16 2,443.70 99.73% TOTAL CULTURAL 907,161.00 253,423.94 843,642.79 904,485.14 232:16 2,443.70 99.73 %> CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30th, 2017 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 16 - 2 0 17 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET HEALTH ANIMAL SERVICES Personnel Services 320,519.00 61,529.07 302,214.91 304,804.24 - 15,714.76 95.10% Supplies 35,132.00 10,663.30 33,048.17 35,015.92 - 116.08 99.67% City Support Services 2,112.00 59.70 367.91 2,111.83 - 0.17 99.99% Utility Services 72,125.00 31,715.62 37,015.72 60,217.39 - 11,907.61 83.49% Operations Support 1,000.00 - 158.50 711.98 - 288.02 71.20% Staff Support 10,386.00 3,441.55 7,938.56 6,864.12 312.88 3,209.00 69.10% City Assistance 18,550.00 7,650.67 15,045.44 15,637.54 - 2,912.46 84.30% Professional Services 26,484.00 9,339.82 21,413.00 21,606.46 - 4,877.54 81.58% Maintenance Services 15,526.00 3,860.00 51,283.59 12,163.92 - 3,362.08 78.35% Operating Equipment 38,000.00 3,264.71 11,689.34 8,922.13 990.00 28,087.87 26.08% Capital Outlay 63,000.00 59,735.30 56,060.00 87,605.30 - (24,605.30) 139.06% TOTAL ANIMAL SERVICES < 602,834.00 191,259.74 536,235.14 555,660.83 1,302.88 45,870.29 92.39 % ENVIRONMENTAL HEALTH Personnel Services 190,240.00 49,231.67 - 185,962.66 - 4,277.34 97.75% Supplies 3,505.00 74.73 - 695.33 - 2,809.67 19.84% Operations Support 1,800.00 - - 702.61 - 1,097.39 39.03% Staff Support 6,550.00 1,425.00 - 4,240.76 - 2,309.24 64.74% City Assistance 1,000.00 - - 900.81 - 99.19 90.08% Professional Services 500.00 305.00 - 481.00 - 19.00 96.20% Maintenance Services 10,600.00 3,240.00 - 8,225.00 - 2,375.00 77.59% Operating Equipment 5,450.00 2,385.86 - 3,670.74 - 1,779.26 67.35% TOTAL ANIMAL SERVICES 219,645.00 56,662,26 - 204,878.91 -' 14,766:09 93.28% TOTAL HEALTH 822,479.00 247,922.00 536,235.14 760,539;74 1,302:88 60,636`.38 92.63% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30th, 2017 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 16 - 2 0 17 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET INTERNAL SERVICE INFORMATION TECHNOLOGY Personnel Services 524,491.00 132,614.72 418,565.16 483,227.08 - 41,263.92 92.13% Supplies 7,000.00 1,831.63 1,361.03 6,681.44 - 318.56 95.45% City Support Services 519,162.00 211,830.75 432,054.73 555,608.79 - (36,446.79) 107.02% Utility Services 227,646.00 59,099.61 202,871.35 199,888.52 - 27,757.48 87.81% Staff Support 34,100.00 5,702.86 36,968.40 29,832.25 - 4,267.75 87.48% Maintenance Services 17,580.00 5,395.77 14,260.25 16,313.54 - 1,266.46 92.80% Rental /Leasing 38,047.00 3,059.40 35,159.07 33,457.32 - 4,589.68 Operating Equipment 227,123.00 61,290.53 169,236.16 219,734.41 - 7,388.59 96.75% Capital Outlay 13,000.00 - - - - 13,000.00 0.00% TOTAL INFORMATION TECHNOLOGY 1,608,149.00 480,825,27 1,310,476.15 1,544,743.35 - 63,405..65 96.06% HUMAN RESOURCES Personnel Services 337,369.00 111,731.16 274,662.51 332,663.07 - 4,705.93 98.61% Supplies 1,000.00 528.06 990.24 925.81 - 74.19 92.58% Human Services 69,570.00 14,780.78 50,953.21 52,824.51 1,370.26 15,375.23 77.90% City Support Services 320.00 - 311.40 8.60 97.31% Operations Support 10,060.00 3,759.36 7,920.23 6,940.80 - 3,119.20 68.99% Staff Support 17,780.00 7,322.00 17,702.57 14,672.23 - 3,107.77 82.52% City Assistance 10,650.00 5,151.50 16,150.00 9,729.50 510.00 410.50 96.15% Professional Services 9,600.00 2,234.25 10,316.00 9,437.00 - 163.00 98.30% Operating Equipment 1,220.00 619.98 1,775.00 1,234.92 - (14.92) 101.22% TOTAL HUMAN RESOURCES 457,569.00 146,127.09 380,469.76 428,739.24 1,880.26 26,949.50 94.11 %' FINANCE Personnel Services 584,190.00 145,424.31 525,090.47 564,954.66 - 19,235.34 96.71% Supplies 4,981.77 1,149.27 3,724.03 4,893.64 - 88.13 98.23% Operations Support 1,917.00 - 3,439.69 1,916.64 - 0.36 99.98% Staff Support 7,973.00 1,644.77 11,138.64 5,468.50 - 2,504.50 68.59% Professional Sevices 12,064.00 - 505.00 24,255.00 - (12,191.00) 201.05% Operating Equipment 2,970.23 2,857.29 - 2,969.52 - 0.71 99.98% TOTAL FINANCE 614,096.00 151,075.64 543,897.83 604,457'.96 -' 9,638.04 98.43% CITY O F S C H E R TZ REVENUE AND EXPENSE REPORT (UNAUDUED) AS OF: September 30th, 2017 2V1V-2V17 101GENERALFUmn CURRENT CURRENT PRIOR YEAR v-T-D v-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER Y�-DACTUAL ACTUAL ENCUMBR BALANCE BUDGET PURCHASING & ASSET MGT 794,625.00 197.714.22 150.923.23 777.294.47 17,330.53 Personnel Services 180,620.00 53.824.81 130,455.53 181,478.80 103.73713 (858.80) 10048% Supplies 1,050.00 3,85539 4`178.37 4,45535 - (3,405.35) 424.32% Utility Services 250.00 115.03 252.50 222.78 1.856.00 27.22 89.11% Operations Support 100.00 - 2910 20.35 - 73.05 20,35% Staff Support 6,148.00 1,687.62 6,12427 3,513.31 Maintenance Services 2.035.68 5714% City Assistance 3.000.00 675.00 3.11140 1.711.00 07.00 1.222.00 59.27% Operating Equipment _--__451.00} 450J0 166.72 _---_-450.76 -----__-_ ----_---0.24� 100.00% 99.95% TOTAL PURCHASING & ASSET MGT 191,620.00 60,608.71 144,31&01 191,858.35 67.00 (305.35) 100A6% FLEET SERVICE ___25,872.68 _____-�_ ______�_ ___2�825.7V _____--_ _____46.98 Personnel Services 343.327.00 87.70318 288.892.07 340.12814 - 3.197.80 88.07% Supplies 109.100.00 38.388.04 130.213.50 105.709.30 012,79 2.777.81 88.30% City Support Services 6.150.00 1,295.00 2^244.72 3.049.40 - 2.500.00 58.34% Utility Services 0,200.00 3.094.34 0.158.05 0.392.90 - (2.192.90) 135.37% Operations Support 200.00 - 32.95 58.69 - 140.31 29.85% Staff Support 10.850.62 4.090.07 5.791.92 8.340.06 1.509.90 80.08% Maintenance Services 105.783.38 38.827.08 169.777.84 100.800.02 907.23 3.92013 87.04% Operating Equipment 7.700.00 3.039.06 17.787.92 7.758.36 (58.30) 100.70% Capital Outlay 36,6x00L00 -_ 80�61.00 -_ -_ 36,600.00 0.00% TOTAL FLEET SERVICE 745,927.00 176,518.58 707,160.03 695,951.47 1,58002 48,395.51 9151 % Personnel Services 794,625.00 197.714.22 150.923.23 777.294.47 17,330.53 97.82% Supplies 103.087.09 28.341.82 4.51310 103.73713 431.87 (1.081.41) 101.05% Utility Services 148.543.82 61,685.81 2.308.05 149.296.25 247.37 99.83% Staff Support 10.536.08 1.856.00 3.388.51 18.380.80 - 155.74 90.52% Professional Services 9.000.00 43.784.89 ' 9.000.00 0.00% Maintenance Services 339.881.72 60.118.02 180.114.25 333.348.00 520.00 5.512.84 98.30% Rental/Leasing 2,210.69 1.263.27 2.210.09 100.00% Operating Equipment 2J00.08 35543 - 2,40334 - 230.66 9123% Capital Outlay ___25,872.68 _____-�_ ______�_ ___2�825.7V _____--_ _____46.98 99.82% TOTAL BUILDING MAINTENANCE 1,437,558,00 358,071.93 402,276.40 1,405,157.32 951.97 31,448.71 97.81% TOTAL INTERNAL SERVICE 5,054,919.00 1,373,227.22 3,488,598.18 4,870,907.69 4,479.25 179,532.06 96.45% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30th, 2017 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 16 - 2 0 17 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET MISC & PROJECTS CITY ASSISTANCE City's Assistance to Agencies 312,545.00 96,252.19 237,815.70 298,164.28 - 14,380.72 95.40% TOTAL CITY ASSISTANCE 312,545.00 96,252.19 237,815.70 298,164.28 -' 14,380.72 95.40% COURT - RESTRICTED FUNDS Operating Equipment 19,448.00 - 5,324.25 357.00 2,535.00 16,556.00 14.87% TOTAL CITY ASSISTANCE 19,448.00 5,324.25 357.00 2,535.00 16,556x00 14.87% TOTAL MISC & PROJECTS 331,993.00 96,252.19 243,139.95 298,521.28 2,535:00 30,936.72 90.68 %' TOTAL EXPENDITURES: 29,825,043.69 7,439,581.04 24,978,730.32 28,018,486.28 91,430.22 1,715,127.19 94.25% REVENUE OVER(UNDER) EXPEND. 8,151.31 1,555,81130 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: September 30th, 2017 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6- 2 0 1 7********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Taxes 000-411100 Advalorem Tax - Current 11,203,881.00 54,554.96 10,400,371.05 11,128,370.29 - 75,510.71 99.33% 000 - 411200 Advalorem Tax - Delinquent 40,000.00 10,349.29 26,530.54 (192.28) - 40,192.28 -0.48% 000 - 411300 Advalorem Tax - P &I 45,000.00 6,876.06 50,098.94 54,758.65 - (9,758.65) 121.69% 000 - 411500 Sales Tax Revenue -Gen Fund 7,385,419.00 1,897,341.43 7,261,388.28 7,223,573.55 - 161,845.45 97.81% 000 - 411600 Bingo Tax 100.00 - 0.62 31.25 - 68.75 31.25% 000 - 411700 Mixed Beverage Tax 46,000.00 10,589.64 43,072.48 42,668.17 - 3,331.83 92.76% TOTAL Taxes 18,720,400.00 1,979,711.38 17,781,461.91 18,449,209.63 - 271,190.37 98.55% Franchises 000 - 421200 Center Point /Entex Energy 74,000.00 13,721.19 66,404.93 68,524.38 - 5,475.62 92.60% 000 - 421220 City Public Service 873,600.00 272,073.29 842,999.91 910,770.55 - (37,170.55) 104.25% 000 - 421240 Guadalupe Valley Elec Co -op 513,000.00 134,533.81 437,020.92 423,897.53 - 89,102.47 82.63% 000 - 421250 New Braunfels Utilities 70,000.00 20,203.64 70,398.74 69,790.28 - 209.72 99.70% 000 - 421300 Time Warner -State Franchise 238,000.00 70,053.21 258,405.26 273,988.62 - (35,988.62) 115.12% 000 - 421460 AT &T Franchise Fee 300,000.00 70,534.40 236,715.80 200,597.11 - 99,402.89 66.87% 000 - 421480 Other Telecom Franchise 100,000.00 80,304.84 103,485.13 135,723.62 - (35,723.62) 135.72% 000 - 421500 Solid Waste Franchise Fee 138,000.00 23,263.93 136,360.02 129,904.66 - 8,095.34 94.13% TOTAL Franchises 2,306,600.00 684,688.31 2,151,790.71 2,213,196.75 - 93,403.25 95.95 %` -. Permits 000 - 431100 Home Occupation Permit 500.00 - 595.00 490.00 - 10.00 98.00% 000 - 431205 Building Permit - Residential 483,000.00 161,921.00 441,467.00 630,838.50 - (147,838.50) 130.61% 000 - 431210 Building Permit - Commercial 170,000.00 34,805.00 150,272.00 630,642.00 - (460,642.00) 370.97% 000 - 431215 Building Permit - General 292,000.00 386,617.00 197,374.00 534,711.00 - (242,711.00) 183.12% 000 - 431300 Mobile Home Permit 300.00 75.00 275.00 300.00 - - 100.00% 000 - 431400 Signs Permit 7,000.00 1,552.00 6,001.00 5,482.00 - 1,518.00 78.31% 000 - 431500 Food Establishmnt Permit 60,000.00 4,825.00 63,475.00 62,715.00 - (2,715.00) 104.53% 000 - 431600 Garage Sale Permit 10,500.00 2,466.00 11,617.00 9,490.00 - 1,010.00 90.38% 000 - 431700 Plumbing Permit 117,000.00 35,778.30 115,876.25 139,490.30 - (22,490.30) 119.22% 000 - 431750 Electrical Permit 58,800.00 18,180.00 59,080.00 71,500.00 - (12,700.00) 121.60% 000 - 431800 Mechanical Permit 59,520.00 20,560.00 56,120.00 71,800.00 - (12,280.00) 120.63% 000 - 431900 Solicitor /Peddler Permit 1,500.00 480.00 1,170.00 1,484.50 - 15.50 98.97% 000 - 431950 Animal/Pet Permit 1,500.00 150.00 1,015.00 365.00 - 1,135.00 24.33% 000 - 432000 Cert. of Occupancy Prmt 7,000.00 400.00 6,800.00 5,650.00 - 1,350.00 80.71% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: September 30th, 2017 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6- 2 0 1 7********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET 000 - 432100 Security Alarm Permit 35,000.00 9,759.66 40,046.87 40,355.66 - (5,355.66) 115.30% 000 - 432300 Grading /Clearing Permit 4,000.00 3,146.00 7,887.02 9,046.00 - (5,046.00) 226.15% 000 - 432400 Development Permit 81,880.00 46,581.04 - 61,037.39 20,842.61 74.54% 000 - 435000 Fire Permit 15,000.00 7,843.00 19,320.00 29,368.00 - (14,368.00) 195.79% TOTAL Permits 1,404,500.00 735,139.00 1,178,39114 2,304,765 35 - (900,265.35) 164.10 %< Licenses 000 - 441000 Alcohol Beverage License 8,000.00 965.00 7,505.00 7,075.00 - 925.00 88.44% 000 - 441300 Mobile Home License 160.00 - 160.00 160.00 - - 100.00% 000 - 442000 Contractors License 40,000.00 10,150.00 44,410.00 52,600.00 - (12,600.00) 131.50% 000 - 444000 Pet License 3,000.00 794.00 3,582.00 3,329.00 - (329.00) 110.97% TOTAL Licenses 51,160.00 11,909.00 55,657.00 63,164.00 - (12,004.00) 123.46% Fees 000 - 451000 Municipal Court Fines 884,000.00 135,563.54 989,430.14 742,592.36 - 141,407.64 84.00% 000 - 451100 Arrest Fee 28,053.00 6,713.66 36,255.84 28,080.08 - (27.08) 100.10% 000 - 451110 Expunction Fee 60.00 - 90.00 90.00 - (30.00) 150.00% 000 - 451200 Warrant Fees 130,000.00 18,392.45 124,364.15 102,156.33 - 27,843.67 78.58% 000 - 451210 Court- Claims & Judgements - (1,394.10) 72.40 (1,855.50) - 1,855.50 0.00% 000 - 451340 Judicial Fee - City 3,796.00 895.83 4,937.54 3,853.63 - (57.63) 101.52% 000 - 451400 Traffic Fine Costs TTL 13,492.00 3,251.19 17,435.23 13,403.10 - 88.90 99.34% 000 - 451510 Juvenile Case Mgmt Fee 31,616.00 7,465.35 41,136.10 32,149.30 - (533.30) 101.69% 000 - 451520 Truancy Fee 5,342.00 1,364.88 7,277.75 5,705.64 (363.64) 106.81% 000 - 451600 Technology Fund Fee 22,932.00 5,069.41 32,507.45 24,918.03 - (1,986.03) 108.66% 000 - 451700 Security Fee 19,448.00 4,468.85 25,057.05 19,355.33 - 92.67 99.52% 000 - 451800 Time Payment Fee - City 5,616.00 924.36 5,218.85 5,936.41 - (320.41) 105.71% 000 - 451850 State Fines 10% Service Fee 40,838.00 8,771.18 50,200.64 37,999.60 - 2,838.40 93.05% 000 - 451900 DPS Payment - Local 47,665.00 1,382.64 9,252.75 7,580.78 - 40,084.22 15.90% 000 - 452000 Child Safety Fee 13,522.00 296.80 13,637.20 3,210.28 - 10,311.72 23.74% 000 - 452100 Platting Fees 57,000.00 14,000.00 60,500.00 66,500.00 - (9,500.00) 116.67% 000 - 452200 Site Plan Fee 30,000.00 3,500.00 40,150.00 28,000.00 - 2,000.00 93.33% 000 - 452300 Plan Check Fee 432,000.00 292,144.50 391,659.00 894,727.50 - (462,727.50) 207.11% 000 - 452310 Miscellaneous Review Fee 600.00 - 300.00 - - 600.00 0.00% 000 - 452320 Tree Mitigation Admin Fee 12,000.00 1,447.20 22,462.50 11,799.90 - 200.10 98.33% 000 - 452400 BOA/Zoning Fees 2,000.00 500.00 3,500.00 3,110.51 - (1,110.51) 155.53% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: September 30th, 2017 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6- 2 0 1 7********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET 000 - 452600 Specific Use /Zone Chng Fee 12,600.00 5,500.00 15,300.00 20,500.00 - (7,900.00) 162.70% 000 - 452710 Zoning Ltr & Dev Rights 1,500.00 150.00 1,500.00 2,400.00 - (900.00) 160.00% 000 - 453100 Reinspection Fees 45,000.00 24,302.00 95,650.00 108,427.00 - (63,427.00) 240.95% 000 - 453110 Swim Pool Inspection Fee 2,600.00 770.00 2,530.00 2,530.00 - 70.00 97.31% 000 - 453200 Lot Abatement 5,000.00 917.71 3,125.17 2,243.21 - 2,756.79 44.86% 000 - 453211 Admin Fee - Inspections 6,600.00 5,000.00 15,600.00 15,800.00 - (9,200.00) 239.39% 000 - 453310 Misc Inspection Fee 150.00 - 100.00 - - 150.00 0.00% 000 - 453710 Foster Care 1,000.00 300.00 1,100.00 1,200.00 - (200.00) 120.00% 000 - 454200 Pool Gate Admission Fee 24,750.00 16,444.90 21,733.85 25,464.90 - (714.90) 102.89% 000 - 454300 Seasonal Pool Pass Fee 4,900.00 750.00 5,280.00 5,894.00 - (994.00) 120.29% 000 - 456110 Senior Center Memberships - - 2,988.00 - - - 0.00% 000 - 456120 Senior Center Meal Fee - 401.00 1,265.00 802.00 - (802.00) 0.00% 000 - 456500 Haz Mat Fees 6,000.00 - 2,941.00 400.00 - 5,600.00 6.67% 000 - 456600 Fire Re- inspection Fee 1,000.00 300.00 1,100.00 1,200.00 - (200.00) 120.00% 000 - 458110 Sale of Merchandise- GovDeal 20,000.00 26,356.28 40,069.21 52,261.05 - (32,261.05) 261.31% 000 - 458300 Sale of Property /Auction 4,000.00 - 2,194.00 - - 4,000.00 0.00% 000 - 458400 Civic Center Rental Fees 175,000.00 43,013.75 184,530.59 190,142.75 - (15,142.75) 108.65% 000 - 458401 Capital Recovery Fee -Civic Cntr 10,000.00 2,325.00 11,650.00 14,660.00 - (4,660.00) 146.60% 000 - 458450 North Center Rental Fees 18,500.00 7,331.25 22,630.72 25,743.75 - (7,243.75) 139.16% 000 - 458460 Senior Center Rental - - 22,012.00 8,100.00 - (8,100.00) 0.00% 000 - 458500 Community Center Rental Fees 25,000.00 7,851.50 36,529.19 31,187.00 - (6,187.00) 124.75% 000 - 458550 Pavilion Rental Fees 17,000.00 4,865.00 21,256.00 19,015.50 - (2,015.50) 111.86% 000 - 458560 Chamber of Comm rent 7,800.00 1,950.00 6,050.00 7,800.00 - - 100.00% 000 - 458570 Non - Resident SYSA League - - 11,870.00 - - - 0.00% 000 - 458650 NonResident User Fee -BVYA 15,000.00 6,945.00 10,120.00 8,451.00 - 6,549.00 56.34% 000 - 458660 BVYA Utility Reimbursement 13,000.00 8,174.18 10,092.81 26,159.97 - (13,159.97) 201.23% 000 - 458670 SYSA Utility Reimbursement 7,000.00 - - - - 7,000.00 0.00% 000 - 458675 Lions Futbol Utility Reimbursement 14,052.00 3,516.00 9,704.00 9,376.00 - 4,676.00 66.72% 000 - 458700 Vehicle Impoundment 8,000.00 2,530.00 10,245.90 9,860.00 - (1,860.00) 123.25% 000 - 459200 NSF Check Fee 250.00 - 75.00 50.00 - 200.00 20.00% 000 - 459300 Notary Fee 250.00 18.00 186.00 126.00 - 124.00 50.40% 000 - 459400 Maps, Copies, UDC, & Misc F 250.00 35.00 60.00 40.00 - 210.00 16.00% 000 - 459600 Animal Adoption Fee 10,000.00 3,616.00 12,482.89 18,581.00 - (8,581.00) 185.81% 000 - 459700 Pet Impoundment Fee 10,000.00 1,339.00 11,127.80 6,266.50 - 3,733.50 62.67% 000 - 459800 Police Reports Fee 5,400.00 1,495.20 5,577.00 6,018.60 - (618.60) 111.46% 000 -45990 Fire - False Alarm Fee - 4,500.00 - 4,500.00 - (4,500.00) 0.00% TOTAL Fees 2,251,582.00 685,454.51 2,474,120.72 2;654,51151 - (402,931.51) 117.90% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: September 30th, 2017 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6- 2 0 1 7********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Fines 000 - 463000 Library Fines 28,000.00 5,732.73 25,738.67 23,339.27 - 4,660.73 83.35% TOTAL Fines 28,000.00 5,732.73 25,738.67 23,33927 - 4,660.73 83.35% Inter - Jurisdictional 000 - 473100 Bexar Co - Fire 21,077.00 - 10,258.29 21,077.76 - (0.76) 100.00% 000 - 473200 City of Seguin - Fire Contract 29,231.00 7,307.70 28,110.28 29,230.80 - 0.20 100.00% 000 - 473300 Guad Co - Library 212,000.00 54,288.00 211,954.00 217,152.00 - (5,152.00) 102.43% 000 - 473400 Randolph AFB - Animal Cntrl 1,200.00 700.00 2,100.00 1,200.00 - - 100.00% 000 - 474200 Library Services - Cibolo 35,000.00 35,000.00 35,000.00 35,000.00 - - 100.00% 000 - 474210 Library Services -Selma 32,000.00 31,540.00 31,540.00 31,540.00 - 460.00 98.56% 000 - 474400 Dispatch Service - Cibolo 166,000.00 40,000.00 160,026.00 160,000.00 - 6,000.00 96.39% 000 - 474600 School Crossing Guard - Bexar 38,500.00 6,863.07 37,487.82 37,805.72 - 694.28 98.20% 000 - 474610 School Cross Guard - Guadalupe 38,000.00 10,317.19 39,339.59 38,878.80 - (878.80) 102.31% 000 - 474620 School Crossing Guard -Coma) 1,500.00 - 1,565.98 - - 1,500.00 0.00% 000 - 474700 School Officer Funding 255,000.00 127,500.00 184,166.67 255,000.00 - - 100.00% 000 - 474750 Crime Victim Liaison Agreement 50,000.00 12,500.00 50,000.00 50,000.00 - - 100.00% TOTAL Inter - Jurisdictional 879,508.00 326,015.96 791,548.63 876,885.08 - 2,622.92 99.70% Fund Transfers 000 - 480000 Indirect Costs - EMS 150,087.00 37,521.75 150,307.56 150,087.00 - - 100.00% 000 - 480100 Indirect Costs - Hotel /Motel 66,405.00 16,601.25 66,405.00 66,405.00 - - 100.00% 000 - 481000 Transfer In Reserves 950,000.00 - - - - 950,000.00 0.00% 000 - 482200 Transfer - Vehicle Replcemt 43,278.00 - - - - 43,278.00 0.00% 000 - 482300 Transfer IN -Resry Child Saf 126,345.00 - - - - 126,345.00 0.00% 000 - 485000 Interfund Charge- Drainage 184,425.00 46,106.25 54,150.00 184,425.00 - - 100.00% 000 - 486000 Interfund Chrges -Admin W &S 1,186,812.00 296,703.00 1,152,350.00 1,186,812.00 - - 100.00% 000 - 487000 Interfund Charges -Fleet 397,581.00 99,395.25 206,965.00 397,581.00 - - 100.00% 000 - 488000 Interfund Charges -413 430,445.00 107,611.26 50,024.00 430,445.00 - - 100.00% 000 - 489000 Transfer In 107,367.00 68,385.08 - 68,385.08 - 38,981.92 63.69% TOTAL Fund Transfers 3,642,745.00 672,32184 1,680,201.56 2,484,140.08 - 1,158,604.92 68.19% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: September 30th, 2017 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6- 2 0 1 7********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Miscellaneous 000 - 491000 Interest Earned 800.00 3,989.83 787.35 4,706.59 - (3,906.59) 588.32% 000 - 491200 Investment Income 60,000.00 35,037.18 74,649.53 136,000.70 - (76,000.70) 226.67% 000 - 491800 Gain /Loss - (371.10) (27,797.77) (1,420.63) - 1,420.63 0.00% 000 - 491900 Unrealized Gain /Loss - (2,084.40) 11,003.24 (11,305.39) - 11,305.39 0.00% 000 - 493120 Donations - Public Library 2,500.00 47.70 2,248.63 4,044.35 - (1,544.35) 161.77% 000 - 493400 Donation - Animal Control 10,000.00 4,903.51 211.40 18,190.78 - (8,190.78) 181.91% 000 - 493401 Donations -A /C Microchip 5,000.00 390.00 1,980.00 640.00 - 4,360.00 12.80% 000 - 493402 Donations - Spay &Neuter 15,000.00 - 13,654.00 810.00 14,190.00 5.40% 000 - 493403 Donations - Animal Adoption Trailer - - 2,222.00 552.29 - (552.29) 0.00% 000 - 493404 Donations -TNR Program 1,000.00 - 600.00 - - 1,000.00 0.00% 000 - 493460 Donations -Parks 4,000.00 - - 13,741.09 - (9,741.09) 343.53% 000 - 493465 Donations - Senior Center - 2,504.87 9,643.57 10,571.59 - (10,571.59) 0.00% 000 - 493502 Donations -PD - (1,012.00) 5,299.68 4,222.25 - (4,222.25) 0.00% 000 - 493503 Donations -Fire Rescue - 9,520.00 - 9,541.00 (9,541.00) 0.00% 000 - 493618 Donations - Veteran's Memorial 6,000.00 - 5,500.67 - - 6,000.00 0.00% 000 - 494481 LawEnforcemtOfficersStnd &Ed 3,900.00 - 3,850.98 3,679.47 - 220.53 94.35% 000 - 494482 Grants - Police, Fire, Gen Fund - - 5,131.63 4,892.03 - (4,892.03) 0.00% 000 - 495100 Mobile Stage Rental Fees - - 2,100.00 1,550.00 - (1,550.00) 0.00% 000 - 497000 Misc Income -Gen Fund 40,000.00 (46,059.88) 55,367.24 (33,323.50) - 73,323.50 - 83.31% 000 - 497005 Schertz Magazine Advertising 190,000.00 40,475.00 196,500.00 186,000.00 - 4,000.00 97.89% 000 - 497100 Misc Income - Police 7,500.00 1,187.90 18,494.04 17,865.86 - (10,365.86) 238.21% 000 - 497150 Misc Income -Fire Department - - - 1,750.00 - (1,750.00) 0.00% 000 - 497200 Misc Income - Library 5,000.00 1,303.50 4,949.91 4,965.10 - 34.90 99.30% 000 - 497210 Misc Income - Library Copier 19,500.00 4,934.06 20,193.99 18,187.16 - 1,312.84 93.27% 000 - 497300 Misc Income - Animal Control - - 400.00 390.00 - (390.00) 0.00% 000 - 497400 Misc Income - Streets Dept. 30,000.00 4,138.20 44,730.45 51,734.50 - (21,734.50) 172.45% 000 - 497500 Misc Income -TML Insurance 5,000.00 - 4,088.25 9,252.06 - (4,252.06) 185.04% 000 - 497550 Misc Income -TML Reimbursemt 20,000.00 1,090.18 11,828.59 11,956.51 - 8,043.49 59.78% 000 - 497600 Misc Income - Vending Mach. 2,500.00 761.65 2,317.43 2,257.04 - 242.96 90.28% 000 - 498000 Reimbursmnt -Gen Fund 35,000.00 437.06 44,867.09 19,921.69 - 15,078.31 56.92% 000 - 498100 Reimbursmnt Fire - Training 3,500.00 - 6,017.31 7.00 - 3,493.00 0.20% 000 - 498105 Reimburmnt Police - DEA - - 5,637.26 5,763.94 - (5,763.94) 0.00% 000 - 498107 Reimburmnt Police - Event - - 3,500.00 - - - 0.00% 000 - 498110 Reimbursmnt Fire - Emg. Acti -O 80,000.00 - 51,868.15 3,267.16 - 76,732.84 4.08% 000 - 498150 Reimbursemnt - Library 2,500.00 - - 4,673.27 - (2,173.27) 186.93% TOTAL Miscellaneous 548,700.00 61,193.26 581,844.62 505,083.91 - 43,616.09 92.05 % >> TOTAL REVENUES 29,833,195.00 5,162,167.99 26,720,754.96 29,574,297.58 - 258,897.42 99.13% GENERALFUND CASH IN BANK AND INVESTMENTS AS OF: September 30th, 2017 Cash in Bank Claim on Operating Cash Pool- Checking $ 2,047,017.31 Cash in Investments LOGIC Investment - General Fund 7,236,058.16 LOGIC Investment -Equip Replacement 74,846.70 LOGIC Investment -Veh Replacement 504,674.11 LOGIC Investment -Air Condi Replacment 274,647.66 CAPITAL ONE Investment - General Fund 1,367,855.92 Total Cash in Bank & Investments $11,651,681.70 ` --- - - - --------- OCT NOV DEC JAN FEB MAR APR MAY LJUN JUL AUG SEP 2016-17 419,931 328,521 5,447,189 2,515,077 2,106,927 120,850 42,362 34,666 58,291 24,344 16,511 13,700 2015-16 2014-15 360,300 357,436 303,202 356,940 4,754,503 ------4,463,962 -2,74-1,9_91-1-J98,153 3,709,486 888,174 ------ 211,253 --------- 85,775--------44,720 50,559 54,867 ----25,-398 --------- 27,116 ---------- 30,488 -------- 21,347 --------- 49,777 10,866 ----14,839 --- - 8,696 - ---- 3,787 ---------- 02013-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 7,446 02012-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 Sales Tax - General Fund $900,000 - ....... ® 8.7% .08% $800,000 - - 1.9'70 - - - - - - - - -- 19.9% $700,000 o4 % 8.3% ft $600,000 ��� 3,207 12, $500,000�k �ac $400,000 - - -- - - - - - - - $300,000 - - - - -- - - - - - - -- - - $200,000 -- -- - - - - - - -- -- - -- $100,000 - -- - - - - - - - - - - -- - - - $ OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP -2016-17 574,470 758,598 580,171 560,431 747,281 486,739 432,444 669,542 553,540 566,565 696,536 573,973 - - - - -- - 2015 -16 - - - - 479,069 - 744,668 - 529,686 - 493,136 -- -- - 783,019 - - 530,498 -- - -- 531,707 - __ _ 615,841 _ - 568,508 523,141 - 691,061 - - 678,167 2014 -15 495,499 638,904 505,026 421,339 795,382 450,965 494,050 723,404 465,966 496,241 759,879 508,305 2013 -14 481,247 657,271 554,578 416,261 728,443 487,933 541,476 781,057 692,446 448,577 680,332 547,431 2012-13 659,150 575,041 474,246 424,191 632,716 415,829 405,378 660,648 544,675 563,636 650,124 487,170 CITY PUBLIC SERVICE I?- OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP - ---- - ---- ------------- - ---------------- — ----- - ------------ - ------------ — -------------- as, 2016-17 � 252,947 ------------- ---- — ----------- 191,140 ----------- — -------------- ----- ------ --- - - - --------- -- ---- — ------------- ----------- ---- ---- ------------- - - - - -------- ---- - -- 213,951 259,517 -m- 2015-16 -------------------------------------- -- ----237,314------------183,530 173,336 - -------------------------------------- -------------------------------------- -- - - 178,081 --------- 02014-15 215,257 172,814 172,628 227,438 13 2013-14 133,486 --- ---- - -- - -- -------------------------------------- --- - - - - -- - 115,592 — — 176,520 213,412 — - - - ---- - - - - - - - - -- -------------------------------- - - - - -- --------------------------------- - - - - -- ---------------------------- M 2012-13 101,440 94,054 96,303 123,044 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30th, 2017 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 106 - SPECIAL EVENTS FUND CURRENT CURRENT PRIOR CURRENT Y -T -D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fund Transfers 81,450.00 43,058.37 42,669.48 43,058.37 - 38,391.63 52.86% Miscellaneous 114,900.00 31,567.47 33,168.54 104,960.50 - 9,939.50 91.35% TOTAL REVENUES 196,350.00 74,625.84 75,838.02 ! 148,018.87 - 48,331.13 ` 75.39% EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental 10,750.00 2,909.10 3,835.78 2,909.10 - 7,840.90 27.06% TOTAL GENERAL GOVERNMENT ` 10,750.00 2,909.10 3,835.78 2,909.10 - 7,840.90 0.00 %` CULTURAL Festival of Angels 13,000.00 - 11,871.69 10,912.90 - 2,087.10 83.95% Employee Appreciation Event 13,000.00 1,282.16 4,327.31 11,620.88 - 1,379.12 89.39% 4th of July Jubilee 26,000.00 19,320.81 - 23,533.31 - 2,466.69 90.51% National Night Out 300.00 270.00 223.73 270.00 - 30.00 90.00% Wilenchik Walk for Life 25,000.00 - 14,513.00 12,620.00 - 12,380.00 50.48% Schertz Fest 30,000.00 23,744.28 - 23,779.28 825.00 5,395.72 82.01% Schertz Sweetheart 34,250.00 9,775.45 18,642.74 23,207.09 (6.60) 11,049.51 67.74% Hal Baldwin Scholarship 20,050.00 7.60 14,255.35 14,054.77 - 5,995.23 70.10% Other Events 14,000.00 2,610.95 5,978.23 10,376.81 - 3,623.19 74.12% TOTAL CULTURAL 175,600.00 57,011.25 69,812.05 ? 130,375.04 818.40 ! 44,406.56 74.71% TOTAL EXPENDITURES 186,350.00 59,92035 73,647.83 133,284.14 818.40 52,247.46 71.96 %+ REVENUE OVER(UNDER) EXPEND 10,000.00 14,705.49 2,190.19 14,734.73 (818.40) {3;916.33 }, CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: September 30th, 2017 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 16 - 2 0 1 7 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 106 - SPECIAL EVENTS FUND CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Fund Transfers Investment Income - 52.22 000 - 481000 Transfer from Reserves 10,750.00 - - - - 10,750.00 0.00% 000 - 486100 Transfer In 9,000.00 5,611.67 2,995.83 5,611.67 - 3,388.33 62.35% 000 - 486101 Transfer In - General Fund 61,700.00 37,446.70 39,673.65 37,446.70 - 24,253.30 60.69% TOTAL Fund Transfers 81,450.00 43,058.37 ' 42,669.48 = 43,058.37 - 38,391 ♦63 52.86% Miscellaneous 000 - 491200 Investment Income - 52.22 85.54 175.25 - (175.25) 0.00% 000 - 492200 Wilenchik Walk for Life 25,000.00 - 14,513.00 12,620.00 - 12,380.00 50.48% 000 - 493256 Donations - Police Events 3,000.00 821.25 - - - 3,000.00 0.00% 000 - 493000 July 4th Activities 31,000.00 16,925.00 - 27,386.25 - 3,613.75 88.34% 000 - 493150 SchertzQ 35,000.00 10,069.00 - 26,994.00 - 8,006.00 77.13% 000 - 493455 Proceeds - Festival of Angels - - 720.00 5,615.00 - (5,615.00) 0.00% 000 - 493460 Schertz Sweetheart 850.00 - 1,240.00 1,705.00 - (855.00) 200.59% 000 - 493621 Hal Baldwin Scholarship 20,050.00 2,700.00 16,360.00 28,465.00 - (8,415.00) 141.97% 000 - 497000 Misc Income - 1,000.00 250.00 2,000.00 - (2,000.00) 0.00% TOTAL Miscellaneous 114,900.00 31,567.47 33,168.54 104,960.50 - 9,939.50 91.35 %' TOTAL REVENUES 196,350.00 74,625.84 75,838.02 148,018.87 - 48,331.13 75.39 %' SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: September 30th, 2017 Cash in Bank Claim on Operating Cash Pool-Checking $ 69,040.36 Cash in Investments Texas Class- Special Events 17,066.34 Total Cash in Bank & Investments $ 86,106.70 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30th, 2017 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6- 2 0 1 7******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 110 -PEG FUND CURRENT CURRENT PRIOR CURRENT Y -T -D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 113,300.00 20,273.35 99,024.23 88,044.66 - 25,255.34 77.71% TOTAL REVENUES 113,300.00 20,27135 99`,024.23 88,044 66 25,255.34 77.71% EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental - - 864.99 - - - 0.00% TOTAL GENERAL GOVERNMENT 864.99= - - 0.00% MISC & PROJECTS Projects 108,600.00 26,680.00 30,103.49 27,129.00 - 81,471.00 24.98% TOTAL >MISC & PROJECTS 108,600.00 26,680.00 30,103.49 27,129.00 - 81,471.00 24.98 %i TOTAL EXPENDITURES 108,600.00 26,680.00 30,968.48` 27,129 00 - 81,471.00 24.98 %> REVENUE OVER(UNDER) EXPEND 4,700.00 (6,406.65} 68 ",055.75' 60,915 66 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: September 30th, 2017 k****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 16 - 2 0 1 7 110 -PEG FUND CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 100% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Franchises 000 - 421350 Time Warner- PEG Fee 50,000.00 14,724.71 51,681.06 54,611.80 - (4,611.80) 109.22% 000 - 421465 AT &T PEG Fee 63,300.00 5,548.64 47,343.17 33,432.86 - 29,867.14 52.82% TOTAL Franchises 113,300.00 20 273.35 99,024.23 88,044.66 - 25,255.34 77.71% TOTAL REVENUES 113,300.00 20,273.35 99,024.23 88,044.66 - 25,255.34 77.71% PEG FUND CASH IN BANK AND INVESTMENTS AS OF: September 30th, 2017 Cash in Bank Cash Balance $ 617,075.10 Total Cash in Bank & Investments $> 617,075.10' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30th, 2017 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6- 2 0 1 7 * * * * * * * * * * * * * * * * * * * * * * * * * ** 202 -WATER & SEWER CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 229,096.00 35,531.90 231,042.29 232,754 - (3,657.70) 101.60% Permits - - 142,025.93 49,563.52 - (49,563.52) 0.00% Fees 19,219,995.00 6,025,501.29 19,167,625.13 21,617,933 - (2,397,937.68) 112.48% Fund Transfers 1,681,081.00 34,230.00 303,056.40 136,920 - 1,544,161.00 8.14% Miscellaneous 163,047.00 73,878.77 3,026,107.73 494,981 - (331,933.85) 303.58% TOTAL REVENUES 21,293,219.00 ;6,169,141.96 22,869,857.48 22,532,150.75 - (1,238,931.75) - 105.82% y/=041�7)��1:� .�91�11�1_1WA NON DEPARTMENTAL Transfer to Public Improvements 699,161.00 - 500,000.00 - - 699,161.00 0.00% TOTAL NON DEPARTMENTAL 699,161.00 - 500,000.00 - - 699,161.00 = 0.00 %! BUSINESS OFFICE Personnel Services 472,754.00 97,674.10 461,310.72 415,998.16 - 56,755.84 87.99% Supplies 4,300.00 1,212.18 3,735.77 1,680.14 245.00 2,374.86 44.77% Human Services - - 201.00 203.00 - (203.00) 0.00% City Support Services 7,125.00 - - 27.50 - 7,097.50 0.39% Utility Services 700.00 360.41 605.71 752.05 - (52.05) 107.44% Operations Support 140,500.00 41,802.05 132,036.06 125,801.72 - 14,698.28 89.54% Staff Support 7,050.00 541.99 4,198.81 3,040.33 43.30 3,966.37 43.74% Professional Services 85,000.00 39,269.41 114,080.19 137,193.85 520.00 (52,713.85) 162.02% Maintenance Services 8,000.00 1,260.00 8,040.00 6,120.00 520.00 1,360.00 83.00% Operating Equipment 600.00 - - - 3,400.40 (2,800.40) 566.73% TOTAL BUSINESS OFFICE 726,029.00 182,120.14 724,208.26 690,816.75 4,728.70 30,483.55 95.80 %' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30th, 2017 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6- 2 0 1 7 * * * * * * * * * * * * * * * * * * * * * * * * * ** 202 -WATER & SEWER CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET W & S ADMINISTRATION Personnel Services 1,161,362.00 321,77120 1,206,287.10 1,107,430.73 - 53,931.27 95.36% Supplies 191,500.00 64,099.50 142,878.54 196,682.73 287.50 (5,470.23) 102.86% Human Services - - 362.00 539.00 - (539.00) 0.00% City Support Services 99,500.00 432.09 47,470.33 64,703.96 - 34,796.04 65.03% Utility Services 3,504,060.00 1,025,751.10 3,221,941.26 3,237,941.89 - 266,118.11 92.41% Operations Support 11,500.00 4,225.80 7,209.01 8,227.86 - 3,272.14 71.55% Staff Support 27,350.00 8,371.11 28,234.23 22,363.85 - 4,986.15 81.77% City Assistance 2,000.00 301.00 1,598.00 1,638.00 - 362.00 81.90% Professional Services 179,729.00 147,988.17 192,497.53 358,882.53 1,920.00 (181,073.53) 200.75% Fund Charges /Transfers 4,467,025.00 2,892,154.95 6,112,334.19 6,421,343.68 - (1,954,318.68) 143.75% Maintenance Services 7,598,090.00 2,488,177.26 7,563,245.56 7,922,688.88 25,330.56 (349,929.44) 104.61% Other Costs 35,000.00 - 27,260.20 36,605.45 - (1,605.45) 104.59% Debt Service 1,578,511.00 (386,137.73) 389,333.17 357,795.24 - 1,220,715.76 22.67% Rental- Leasing 144,500.00 - 2,623.19 23,501.89 - 120,998.11 16.26% Operating Equipment 3,500.00 2,574.93 6,954.43 3,089.93 - 410.07 88.28% TOTAL PUBLIC WORKS 19,003,627.00 6,569,709.38 18,950,228.74 19,763,435.62 27,538.06 (787,346.68); 104.14% 8I6Y01? 1=00111x00 PROJECTS Professional Services - (24,480.00) - 8,457.50 (8,457.50) 0.00% Maintenance Services 85,000.00 - - - - 85,000.00 0.00% TOTAL PROJECTS 85,000.00 (24;480.00) - - 8,457.50 76,542.50 9.95 %s SEWER PROJECT Professional Services 360,000.00 - - - - 360,000.00 0.00% Maintenance Services 400,000.00 - - - - 400,000.00 0.00% TOTAL SEWER PROJECTS 760,000.00 - - - - 760,000.00 ` 0.00% TOTAL MISC & PROJECTS 845,000.00 (24,480) - 8,458 836,543 1.00 %' TOTAL EXPENDITURES 21,273,817.00 6,727,349.52 20,174,437.00 20,454,252.37 40,724.26 778,840.37 96.34 %' " REVENUE OVER(UNDER)EXPENSES ** 19,402.00 (558,207.56) 2,695,420.48 2,077,898.38 (40,724.26) (2,017,772.12): 202 -WATER & SEWER REVENUES CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: September 30th, 2017 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6- 2 0 1 7*********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 100% OF BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Franchises Transfer In- Reserve 1,544,161.00 - - - - 1,544,161.00 0.00% 000 - 486100 Transfer In - 33,784.40 - 000 - 421490 Tower Leasing 229,096.00 35,531.90 231,042.29 232,753.70 - (3,657.70) 101.60% TOTAL Franchises 229,096.00 35,531.90 231,042.29 232,75170 - (3,657.70) 101.60 %' Permits 000 - 432400 Development Permit - - 142,025.93 49,563.52 - (49,563.52) 0.00% TOTAL Permits - - 142,025.93 49,563.52 - (49,563.52) 0.00 %' Fees 000 - 455200 Garbage Collection Fee 4,270,000.00 1,167,909.65 4,433,299.14 4,617,935.61 - (347,935.61) 108.15% 000 - 455600 Fire Line Fees 27,700.00 - 27,025.00 29,540.00 - (1,840.00) 106.64% 000 - 455700 Recycle Fee Revenue 284,000.00 74,943.39 286,555.55 295,773.10 - (11,773.10) 104.15% 000 - 455800 W &S Line Constructn Reimbursemnt - 9,126.44 34,456.87 35,302.04 - (35,302.04) 0.00% 000 - 457100 Sale of Water 9,306,795.00 3,007,319.71 8,543,050.14 9,741,286.37 - (434,491.37) 104.67% 000 - 457110 Edwards Water Lease 97,000.00 - 81,975.30 125,531.25 - (28,531.25) 129.41% 000 - 457120 Water Transfer Charge -Selma 42,000.00 - 59,050.34 24,641.14 - 17,358.86 58.67% 000 - 457130 Water Transfer Charge -U. C. - - 203.11 - - - 0.00% 000 - 457140 Water Transfer Charge- Converse - - 13,527.69 - - - 0.00% 000 - 457200 Sale of Meters 90,000.00 28,264.64 71,157.35 111,839.26 - (21,839.26) 124.27% 000 - 457400 Sewer Charges 4,900,000.00 1,669,133.85 5,394,426.63 6,385,093.91 - (1,485,093.91) 130.31% 000 - 457500 Water Penalties 200,000.00 68,203.61 220,198.01 248,540.00 - (48,540.00) 124.27% 000 - 459200 NSF Check Fee -Water &Sewer 2,500.00 600.00 2,700.00 2,450.00 - 50.00 98.00% TOTAL Fees 19,219,995.00 6,025,501.29 19;167,625.13 21,617,932.68 - (2,397,937.68) 112.48 %' Fund Transfers 000 - 481000 Transfer In- Reserve 1,544,161.00 - - - - 1,544,161.00 0.00% 000 - 486100 Transfer In - 33,784.40 - - - 0.00% 000 - 486204 Interfnd Chrg- Drainage Bill 136,920.00 34,230.00 129,960.00 136,920.00 - - 100.00% 000 - 486411 Transfer In- Capital Recovery - 139,312.00 - - - 0.00% TOTAL Fund Transfers 1,681,081.00 34,230.00 303,056.40 136,920.00 - 1,544,161.00 8.14% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: September 30th, 2017 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6- 2 0 1 7*********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 202 -WATER & SEWER CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 100% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Miscellaneous 000 - 490000 Misc Charges 500.00 2,330.00 663.00 282,281.71 - (281,781.71) 5645634% 000 - 491000 Interest Earned 800.00 2,770.48 1,012.72 3,666.23 - (2,86613) 458.28% 000 - 491200 Investment Income 20,000.00 18,782.23 19,468.01 58,375.64 - (38,375.64) 291.88% 000 - 495013 Capital Contribution - W &S - - 2,831,126.27 - - - 0.00% 000 - 497000 Misc Income -W &S 15,000.00 17,866.93 54,831.11 28,284.12 - (13,284.12) 188.56% 000 - 498110 Reimbursement -SSLGC 126,747.00 32,129.13 115,136.87 122,373.15 - 4,373.85 96.55% 000 - 498200 Reimbursement- W &S Project - - 3,869.75 - - - 0.00% TOTAL Miscellaneous 163,047.00 73,878.77 3,026,107.73 494,980.85 - (331,933.85) 30158 %s TOTAL REVENUES! 21,293,219.00 6,169,141.96 22,869,857.48 22,532,1(50.75 - (1,238,931.75) 105:82 %:' WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: September 30th, 2017 Cash in Bank Claim on Operating Cash Pool- Checking $ 1,141,094.44 Cash in Investments Lone Star Investment -Water &Sewer 4,821,148.66 Lone Star Investment -W &S Customer Deposits 300,030.21 Lone Star Investment -W &S Equip Replacement 180,392.26 Lone Star Investment -W &S Veh Replacement 260,593.02 Schertz Bank & Trust - Certificate of Deposit 1,089,599.19 $ 6,651,763.34 Total Cash in Bank & Investments $ 7,792,857.78 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30th, 2017 203 -EMS CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 6,580,335.00 1,569,511.74 5,569,980.30 5,955,625.72 - 624,709.28 90.51% Inter - Jurisdictional 2,412,627.17 593,513.92 1,713,419.38 2,412,953.11 - (325.94) 100.01% Fund Transfers - - - 550,000.00 - - 0.00% Miscellaneous 166,850.00 28,981.25 169,045.28 223,833.98 - (56,983.98) 134.15% TOTAL REVENUES! 9,159,812.17 2,192,006.91 7,452,444.96 9,142,412.81 567,399.36 99.81% EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services 3,907,750.00 1,033,976.65 3,575,257.99 3,837,205.27 - 70,54473 9819% Supplies 472,404.00 59,657.57 422,423.71 378,68181 1,960.81 91,759.38 80.58% Human Services - 648.00 362.50 1,299.00 - (1,299.00) 0.00% City Support Services 75,850.00 5,680.86 17,854.03 57,156.06 18,693.94 75.35% Utility Services 128,600.00 38,857.45 92,081.75 114,478.11 - 14,121.89 89.02% Operations Support 87,400.00 15,700.66 67,940.79 61,530.78 7.92 25,861.30 70.41% Staff Support 75,250.00 13,204.19 63,604.06 52,858.50 1,340.70 21,050.80 72.03% City Assistance 568,866.81 151,515.00 7,873.72 527,022.47 200.00 41,644.34 92.68% Professional Services 130,000.00 49,026.33 96,314.95 126,267.22 - 3,732.78 97.13% Fund Charges /Transfers 2,983,039.00 793,261.62 1,969,400.69 2,735,917.79 247,121.21 91.72% Maintenance Services 56,320.00 4,600.00 27,759.37 20,610.04 - 35,709.96 36.59% Other Cost - 1,130.44 - 1,130.44 45.30 Debt Service 271,375.00 5,220.84 14,782.11 10,869.56 - 260,505.44 4.01% Rental- Leasing 81,541.00 17,385.21 - 70,120.35 - 11,420.65 85.99% Operating Equipment 125,500.00 26,958.09 68,024.86 38,818.79 1,206.42 85,474.79 31.89% Capital Outlay 80,000.00 - - 34,510.00 499,256.00 (453,766.00) 667.21% TOTAL PUBLIC SAFETY 9,043,895.81 2,216,822.91 6,423,680.53 8,068,478.19 504,017.15 472,576.21 94.79°1%` TOTAL EXPENDITURES 9,043,895.81 2,216,822.91 6,423;680.53 8,068,478.19 504;017.15 472,576.21 94.79 %' ** REVENUE OVER(UNDER) EXPENSES 115,916.36 (24;816.00) 1,028,764.43 1,073,934.62 (504017.15} 94,823.15 CITY OF SCHERTZ REVENUE REPORT (owxomTEo) AS OF: September 30th, 2017 uo1a-uo1r 203-EMS CURRENT CURRENT PRIOR YEAR �T-D �T-D BUDGET 100% OF nevewuea auoesT QuxnrsR Yq-oxcruxL xoTuxL emouwsn BxLxwcs euomeT Fees 000-456100 mnuu|annemxneamoTmnopmx 6.272.100.00 1.508.892.47 5.366.05875 5.666.325a7 605.774.33 oo.o*% 000-456110 Subscription Program Fees 30,000.00 375.00 28.340.00 25.115u0 - *.ano.nn 83.72% 000-*56120 EMT Class poeo 90,000.00 29.750u0 1*2.924.47 94,873.00 (4.873o0) 105.41m 000-456122 oec|uno - p000 22.000.00 2.750.00 - 16.975u0 - 5,025.00 77.16m 000-*56130 Immunization Fees 7.000.00 e.448.00 9.138o0 (2.138.00) 130o4% 000-456140 Billing Fees 'External 25.000o0 4.218.27 20.1e6.58 18.153.05 - 6,846.95 72a1m 000-*56150 Standby Fees 25,000.00 2,635.00 2*.483.50 516.50 oroom 000-456155 Community Services Support 109.235.00 20,866.00 - 100.487.50 - o.r^r.nu 91.99m 000458110 ea|oommercxanuioe - mvvoea| - - 3,937.50 - - - 0.00m 000'459200 NSF Check Fee 8.00% TOTAL Fees 6,580,335.00 1,569,511.74 5,569,980.30 5,955625.72 !e0.51Y6 000-473500 Seguin/Guadalupe ovSupport e43.577.17 210.894.50 310.698.50 843.578.00 - (0.83) 100.00m 000-*74300 ciun|oouppou 319.098o0 79.774.*8 269,225.00 319.0e8.32 (0o2) 100.00m 000-*75100 ooma|coEao*w 100.076.00 26.502.93 95,550.00 106.011.73 ' (n.000.ro) 105.93m 000'475200 Live Oak Support ons.00*ou 51.739.13 202.715.e4 206,956.52 (n.oz) 100.00m ono-*rn000 Universal City Support 268.871.00 65,590.25 un*.ror.no 262.361.00 ' 6.510.00 97.58% 000'475400 Selma Support 106.656o0 26.664.02 76.175o0 106.656u8 (n.on) 100.00m 000-175500 ao»ertzoupport 504,08100 126.020.97 479.6*1.2* 504.083.88 - (o.aa) 100.00m 000'475600 Santa Clara Support 10.354o0 2.588.54 9,968.76 10.354.16 (0.16) 100o0m 000'475800 Marion Support 14.95*o0 3,739.00 14.*57.52 14.e56o0 100o0m 000-*75910 TxappPmomm —_38,000�00 -_ ---____-_ --38,897.42� -------- ---_(897.42 ) 102.36m TOTAL Inter-Jurisdictional 2,412'627.27 593,513.92 1,713,41e38 2,412,953.11 - (gu§) 100.01m� Fund Transfers ono'*uomn Transfer In ------_�-- ------�-_ -------_�-- --550J000�00 -------- ---------- 2.00m TOTAL Fund Transfers 550,000.00 - 0.00% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: September 30th, 2017 203 -EMS CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 100% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Miscellaneous 000 - 491000 Interest Earned 100.00 807.63 98.65 898.59 (798.59) 898.59% 000 - 491200 Investment Income 750.00 2,028.59 715.24 2,750.18 (2,000.18) 366.69% 000 - 493203 Donations -EMS 2,000.00 201.00 559.15 351.00 1,649.00 17.55% 000 - 493205 Donations- Golf Tournament 9,000.00 - 11,485.00 10,060.00 (1,060.00) 111.78% 000 - 495100 UH Grant Program 90,000.00 - - 99,579.03 (9,579.03) 110.64% 000 - 497000 Misc Income 55,000.00 8,336.03 146,007.25 48,902.91 6,097.09 88.91% 000 - 497100 Recovery of Bad Debt 10,000.00 17,608.00 10,179.99 61,292.27 (51,292.27) 612.92% TOTAL Miscellaneous 166,850.00 28,981.25 169,045.28 223,833.98 (56,983.98) 134.15 %' TOTAL REVENUES- 9,159,812.17 2,192,006.91' 7,452,444.96 9,142,412.81 567,399.36 99.81% SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: September 30th, 2017 Cash in Bank Claim on Operating Cash Pool-Checking $ (177,578.45) Cash in Investments Texas Class- Tax Note 2015 Ambulances 90,028.05 Total Cash in Bank & Investments $� AffTi�1�49) -------- -- - ------- - -------- CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30th, 2017 204 - DRAINAGE CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY 301,780.00 26,544.80 430,543.68 293,187.34 - 8,592.66 Permits 3,000.00 880.00 2,820.00 2,960 - 40.00 98.67% Fees 1,141,000.00 289,795.63 1,123,418.25 1,146,946 - (5,945.61) 100.52% Fund Transfers 484,000.00 - - - - 484,000.00 0.00% Miscellaneous 4,200.00 5,149.04 7,298.06 16,663 - (12,462.78) 396.73% TOTAL'REVENUES 1,632,200 00 295,824.67 1,133,536.31 1,166,568.39 - 465,631.61 71.47 % »�t7i��1:��.YlJhi1�5F_131 alL:L�[*] "T701=0 DRAINAGE Personnel Services 301,780.00 26,544.80 430,543.68 293,187.34 - 8,592.66 97.15% Supplies 4,200.00 1,260.32 5,406.75 3,722.56 - 477.44 88.63% Human Services - - 167.00 - - - 0.00% City Support Services 5,180.00 - 9,366.91 4,576.16 - 603.84 88.34% Utility Services 16,200.00 4,386.01 13,886.51 16,299.29 - (99.29) 100.61% Operations Support 700.00 - - - - 700.00 0.00% Staff Support 7,000.00 1,646.47 6,439.71 6,004.24 - 995.76 85.77% City Assistance 400.00 - 120.00 287.00 - 113.00 71.75% Professional Services 48,720.00 13,383.00 43,920.00 46,733.00 - 1,987.00 95.92% Fund Charges/Transfers 428,134.00 235,720.91 354,821.31 556,071.41 - (127,937.41) 129.88% Maintenance Services 13,600.00 8,364.33 24,902.02 13,720.54 - (120.54) 100.89% Other costs 200.00 - 100.00 100.00 - 100.00 50.00% Debt Service 120,150.00 114,754.16 12,249.94 119,794.56 - 355.44 99.70% Operating Equipment 6,500.00 1,079.94 11,491.70 5,739.17 - 760.83 88.29% TOTAL DRAINAGE 952,764:00 407,139.94 913,415.53 1,066,235.27 - (113,471.27) 111.91 %` PROJECTS City Support Services 43,389.00 - - - - 43,389.00 0.00% Operations Support 611.00 - - - - 611.00 0.00% Professional Services 71,640.00 (44,420.00) - - 8,120.00 63,520.00 11.33% Maintenance Services 538,360.00 538,360.00 0.00% TOTAL PROJECTS 654,000.00 (44,420.00) - - 8,120.00 645,880.00 1.24 %`, TOTAL EXPENDITURES 1,606,764.00 362,719.94 913,415.53 1;066,235:27 8,120.00 532,408.73 66.86% *- REVENUE OVER(UNDER) EXPEND 25,436.00 (66,895.27);, 100,333.12 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: September 30th, 2017 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6- 2 0 1 7********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 204 - DRAINAGE CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 100% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Permits 000 - 432400 Floodplain Permit 3,000.00 880.00 2,820.00 2,960.00 - 40.00 98.67% TOTAL Permits 3;000.00 ` 880.00 2,820.00 2,960.00 - 40.00 98.67% Fees 000 - 457500 Drainage Penalties 10,000.00 2,716.09 9,288.93 10,015.62 - (15.62) 100.16% 000 - 457600 Drainage Fee 1,131,000.00 287,079.54 1,114,129.32 1,136,929.99 - (5,929.99) 100.52% TOTAL Fees 1,141,000.00 289,795.63 1,123,418.25 1,146,945.61 - (5,945.61) 100.52% Fund Transfers 000 - 481000 Transfer In 484,000.00 - - - - 484,000.00 0.00% 000 - 486202 Transfer In -Water - - 202,033.35 - - - 0.00% TOTAL Funds Transfers 484,000.00 - 202,033.35 - - 484,000 0.00 %` Miscellaneous 000 - 491000 Interest Earned 100.00 206.50 81.65 295.39 - (195.39) 295.39% 000 - 491200 Investment Interest 4,000.00 4,942.54 7,216.41 15,50039 - (11,500.39) 387.51% 000 - 497000 Misc Income - Drainage 100.00 - - 867.00 - (767.00) 867.00% TOTAL Miscellaneous 4,200.00 5,149.04 7,298.06 16,662.78 - (12,462.78) 396.73% TOTAL REVENUES 1,632,200.00 295,824.67 1,335,569.66 1,166,568.39 - 465,631.61 71.47 %' DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: September 30th, 2017 Cash in Bank Claim on Operating Cash Pool- Checking 144,294.45 Cash in Investments Lone Star Investment - Drainage Maint Fund 928,969.56 Total Cash in Bank & Investments $ 1,073,264.01 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30th, 2017 k******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7 314 -HOTEL TAX CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 609,302.00 159,678.24 544,870.68 499,466.20 - 109,835.80 81.97% Miscellaneous 2,150.00 4,305.11 3,954.40 12,294.50 - (10,144.50) 571.84% TOTAL REVENUES 611,452.00' 163,983.35 548,825.08 511,760.70 - 99,691.30 83.70% EXPENDITURE SUMMARY NONDEPARTMENTAL City Support Services 67,165.00 18,098.85 66,218.66 84,605.07 - (17,440.07) 125.97% Operations Support 66,425.00 6,258.00 36,552.76 36,427.77 - 29,997.23 54.84% Professional Services 3,000.00 - 3,000.00 3,000.00 - - 100.00% Fund Charges /Transfers 114,405.00 16,601.25 114,405.00 66,405.00 - 48,000.00 58.04% Maintenance Services 10,000.00 - 5,555.00 3,511.94 - 6,488.06 35.12% Operating Equipment - - 2,000.00 - - - 0.00% TOTAL NONDEPARTMENTAL 260' - ,995.00 40;958.10 227,731.42 193,949.78 67,045.22 74.31% TOTAL EXPENDITURES 260;995.00 40,958.10 227,731.42 193,949.78 - 67,045.22 74.31 %' REVENUE OVER(UNDER)'EXPENDITURE 350;457.00 317,810.92 HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: September 30th, 2017 Cash in Bank Claim on Operating Cash Pool-Checking $ 183,537.36 Cash in Investments Texas Class - Hotel Tax 1,295,227.84 Total Cash in Bank & Investments $ 1,478,765.20 HOTEL OCCUPANCY TAX $80,000 $70,000 = - - - - - - - - - - - - -- - $60,000 $50,000 $40,000 MERE= - - - - - - v $30,000 $20,000 - - - - - - - - - - - -- - $10,000 $ OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP - - - -- � 2016 -17 -- - - - - -- - - -- - - -- 33,917 - - - - - -- - 33,203 -------- ----- - - - -- 30,940 --- - - - - -- -- - - - - -- 32,131 --- - - - - -- - - - - - -- 33,710 - - - - -- - - - - -- - 51,467 - - - - - -- - - -- - -------------- 47,698 - - --------------- 43,479 - - - - -- -- - - - - -- 55,151 --- - - - - -- -- - - - - -- 57,536 --- - - - - -- -- - - - - -- 46,685 - ---- - - - - -) 33,548 201516 40,800 40,351 38,394 34,516 392732 54,142 49,741 45,524 51,636 68,491 48,302 33,241 2014 -15 44,724 42,229 35,309 33,055 46,037 58,530 43,715 43,525 53,346 72,297 51,772 39,195 2013 -14 40,023 40,709 33,342 29,778 36,680 562699 48,081 49,579 54,858 67,329 57,399 34,297 2012 -13 35,851 39,439 32,392 32,120 31,531 49,811 1 39,900 39,692 54,395 61,999 51,840 34,297 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30th, 2017 317 -PARK CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 145,000.00 - 132,000.00 98,000 - 47,000.00 67.59% Miscellaneous 45,700.00 1,296.10 1,598.06 3,716 - 41,984.48 8.13% TOTAL REVENUES 190,700.00 1,296.10 133,598.06 101,715.52 - 88,984.48 53.34% EXPENDITURE SUMMARY PARKLAND DEDICATION Operating Equipment 22,700.00 5,310.93 146.50 19,486.93 - 3,213.07 85.85% Capital Outlay 168,000.00 59,139.06 22,857.00 59,139.06 109,829.69 (968.75) 100.58% TOTAL PARKLAND DEDICATION 190,700.00 64,449.99 23,00150 ' 78,625.99 109,829.69 2,244.32 98.82% TOTAL EXPENDITURES 190,700.00 64,449.99 23,003.50 78,625.99 109,829.69 2,244.32 98.82% REVENUE OVER(UNDER) EXPEND - 23,089.53 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: September 30th, 2017 317 -PARK CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 100% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBRANCE BALANCE BUDGET Fees 000 - 458800 Parkland Dedication 145,000.00 - 132,000.00 98,000.00 - 47,000.00 67.59% TOTAL Fees 145,000.00 - 132,000.00 98,000.00 ` - 47,000.00 67.59 %< Miscellaneous 000 - 491000 Interest Earned 250.00 284.65 113.74 322.57 - (72.57) 129.03% 000 - 491200 Investment Interest 1,000.00 1,011.45 614.20 3,392.95 - (2,392.95) 339.30% 000 - 497000 Misc Income - - 870.12 - - - 0.00% 000 - 499100 Transfer From Parks Reserve 44,450.00 - - - - 44,450.00 0.00% TOTAL Miscellaneous 45,700.00 1,296.10 1,598.06 3,715.52 - 41,984.48 8.13% TOTAL REVENUES 190,700':00 1,296.1!0 133,598.06 101,715.52 - 88,984.48 53.34 %` PARK FUND CASH IN BANK AND INVESTMENTS AS OF: September 30th, 2017 Cash in Bank Claim on Operating Cash Pool- Checking $96,586.51 Cash in Investments Texas Class- Park Fund 330,363.74 Total Cash in Bank & Investments $426,950.25 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30th, 2017 t******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7 319 -TREE MITIGATION CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Tree Mitigation Fees 85,300.00 13,450.80 127,287.50 74,116 - 11,183.90 86.89% Fund Transfers 54,950.00 - - - - 54,950.00 0.00% Miscellaneous 1,750.00 1,002.60 1,514.97 3,311 - (1,560.91) 189.19% TOTAL REVENUES 142,000.00 14,453.40 128;802.47 < 77,427.01 - 64,572.99 54.53 %I EXPENDITURE SUMMARY TREE MITIGATION Maintenance Services -Trees 142,000.00 - 119,564.00 85,901.00 - 56,099.00 60.49% TOTAL TREE MITIGATION 142,000.00 119;564.00 ' 85,901.00 - 56,099.00 60.49 %` TOTAL EXPENDITURES 142,000.00 - 119,564.00 ! 85,901.00 - 56,099.00 60.49% REVENUE OVER(UNDER) EXPEND - 14,453.40 9,238.47 ;(8,473.99) - 8,473.99 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: September 30th, 2017 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 319 -TREE MITIGATION CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 100% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBRANCE BALANCE BUDGET Fees 000 - 458900 Tree Mitigation 85,300.00 13,450.80 127,287.50 74,116.10 - 11,183.90 86.89% TOTAL Fees 85,300.00 13,450.80 127,287.50 74,1!16.10 11,183.90 86.89% Fund Transfers 000 - 481000 Transfer In -Reserves 54,950.00 - - - - 54,950.00 0.00% TOTAL Fund Transfers 54,950.00 - - - 54,950.00 0.00 %` Miscellaneous 000 - 491000 Interest Earned 250.00 46.16 25.61 58.02 - 191.98 23.21% 000 - 491200 Investment Interest 1,500.00 956.44 1,489.36 3,252.89 - (1,752.89) 216.86% TOTAL Miscellaneous 1,750.00 1,002.60 1,514.97 3,310.91 - (1,560.91) 189.19% TOTAL REVENUES 142,000.00 14,453.40 128,802.47 77,427.01 - 64,572.99 54.53 %' TREE MITIGATION FUND CASH IN BANK AND INVESTMENTS AS OF: September 30th, 2017 Cash in Bank Claim on Operating Cash Pool- Checking $19,514.66 Cash in Investments MBIA Investment -Tree Mitigation 312,397.81 Total Cash in Bank & Investments $331,912.47 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30th, 2017 *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6- 2 0 1 7*********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 411 - CAPITAL RECOVERY WATER CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 1,020,000.00 369,734.40 952,083.00 1,433,309.40 - (413,309.40) 140.52% Miscellaneous 20,600.00 14,304.86 24,96739 38,537.40 - (17,937.40) 187.07% TOTAL REVENUES 1,040,600.00 384,039.26 977,050.39 1,471,846:80 - (431,246.80) 141.44 %i EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 156,000.00 - 1,000.00 1,000.00 - 155,000.00 0.64% TOTAL NON DEPARTMENTAL 156,000.00 - 1,000.00 1,000.00 - 155,000.00 0.64% MISC & PROJECTS PROJECTS Fund Charges/Transfers 3,416,094.84 0.00% TOTAL MISC & PROJECTS - - 3,41,6,094.84 = - - 0.00% TOTAL EXPENDITURES': 156,000.00 - 3,417,094.84 1,000.00 - 155,000.00 0.64 %! REVENUE OVER(UNDER) EXPENDITURES 884,600.00 384,039.26 (2,440,044.45) 1,470,846.80 - ;(586,246.80) CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: September 30th, 2017 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 411 - CAPITAL RECOVERY WATER CURRENT 3rd CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 100% OF REVENUES BUDGET MONTH QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Fees 000 - 455900 Capital Recovery - Water 1,020,000.00 145,233.00 369,734.40 952,083.00 1,433,309.40 - (413,309.40) 140.52% TOTAL Fees 1,020;000.00 145,233.00 369,734.40 952,083.00 1,433,309.40 - (413,309.40) 140.52% Miscellaneous 000 - 491000 Interest Earned 600.00 68.99 710.63 501.80 862.78 - (262.78) 143.80% 000 - 491200 Investment Income 20,000.00 4,718.13 13,594.23 24,465.59 37,674.62 - (17,674.62) 188.37% TOTAL Miscellaneous ` 20,600.00; 4,787.12 14,304.86 24,967.39 38,537.40 (17,937.40) 187.07% TOTAL REVENUES 1,040;,600.00 150,020.12 384,039.26 977,050.39 1,471,846.80 - (431,246.80) 141.44 %j CAPITAL RECOVERY WATER CASH IN BANK AND INVESTMENTS AS OF: September 30th, 2017 Cash in Bank Claim on Operating Cash Pool-Checking $ 234,217.26 Cash in Investments Lone Star Investment-Capital Recovery Water 4,611,145.15 Total Cash in Bank & Investments $ 4,845,362.41 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30th, 2017 ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7 ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 421 - CAPITAL RECOVERY SEWER CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 100% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 600,000.00 176,238.00 508,336.65 744,574 - (144,573.60) 124.10% Miscellaneous 25,500.00 16,388.05 31,238.95 36,518 - (11,018.45) 143.21% TOTAL REVENUES 625,500.00 192,626.05 539,575.60 781,092.05 - (155,592.05) 124.87 %i EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 85,500.00 1,092.22 5,339.50 5,355.94 - 80,144.06 6.26% Fund Charges /Transfers - 139,312.00 - - - 0.00% TOTAL NON DEPARTMENTAL 85,500.00 1,092.22 144,651.50 5,355.94 80,144.06 6.26% MISC & PROJECTS Professional Services 150,000.00 - - - - 150,000.00 0.00% TOTAL MISC & PROJECTS 150,000.00 - - - - 150,000.00 0.00 % ' TOTAL EXPENDITURES 235,500.00 1,092.22 144,651.50 5,355.94 - 230,144.06 2.27 % REVENUE OVER(UNDER) EXPENDITURES 390,000.00 191,533.83 ` 394,924.10 775,736.11 - CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: September 30th, 2017 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7 421 - CAPITAL RECOVERY SEWER CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 100% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Fees 000 - 455910 Capital Recovery -Waste Wtr 600,000.00 172,638.00 466,936.65 717,573.60 - (117,573.60) 119.60% 000 - 455913 Cap Recovery -North Sewer Tr - 3,600.00 41,400.00 27,000.00 - (27,000.00) 0.00% TOTAL Fees 600,000.00 176,23800 508,336.65 744,57160 (144,573.60) 124.10 %' Miscellaneous 000 - 491000 Interest Earned 500.00 606.22 341.42 729.64 - (229.64) 145.93% 000 - 491200 Investment Income 25,000.00 18,531.13 45,367.81 63,424.39 - (38,424.39) 253.70% 000 - 491800 Gain /Loss - (247.40) (35,245.19) (13,176.07) - 13,176.07 0.00% 000 - 491900 Unrealized Gain /Loss -Cap One - (2,501.90) 20,774.91 (14,459.51) - 14,459.51 0.00% TOTAL Miscellaneous 25,500.00 16,388.05 31,238.95 36,518.45 - (11,018.45) 143.21 % TOTAL REVENUES 625,500.00 192,626.05 539,575.60 781,092':05 - (155,592.05) 124.87 % CAPITAL RECOVERY SEWER CASH IN BANK AND INVESTMENTS AS OF: September 30th, 2017 Cash in Bank Claim on Operating Cash Pool- Checking $ 152,042.51 Cash in Investments Lone Star Investment - Capital Recovery Sewer 3,696,292.09 Capital One - Investment 1,765,813.70 Total Cash in Bank & Investments $ '5,614,148.30 505 - TAX I &S FINANCIAL SUMMARY REVENUE SUMMARY CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30th, 2017 *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 100% OF BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Taxes 6,102,433.00 41,220.52 5,810,724.11 6,149,843.74 - (47,410.74) 100.78% Fund Transfers 40,860.00 - - - - 40,860.00 0.00% Miscellaneous 471,288.00 5,764.17 4,575,557.32 508,777.06 - (37,489.06) 107.95% TOTAL REVENUES 6,614,581.00 46,984.69 10,386,281.43 6,658,620.80 - (44,039.80) 100.67% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services Debt Service 102,500.00 1,400.00 84,774.23 2,950.00 6,512,081.00 1,187,581.92 5,621,625.70 6,517,165.55 99,550.00 2.88% (5,084.55) 100.08% Other Financing Sources - - 4,215,481.88 - - - 0.00% TOTAL GENERAL' GOVERNMENT 6,614;581.00` 1,188,981.92 9,921,881.81 6,520,115.55 - 94,465.45 9&57% TOTAL EXPENDITURES 6,614,581.00 1,1?88,981.92 9,921,881.81 6,520,115.55 94,465.45 98.57% " REVENUE OVER(UNDER) EXPEND - 138,505.25 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: September 30th, 2017 *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6- 2 0 1 7********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 505 -TAX I & S CURRENT CURRENT PRIOR YEAR CURRRENT Y -T -D BUDGET 100% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Taxes 000 - 411900 Property Tax Revenue 6,102,433.00 41,220.52 5,810,724.11 6,149,843.74 - (47,410.74) 100.78% TOTAL Taxes 6,102,433.00 41,220.52 5,810,724.11 6,149,843.74 (47,410.74) 100.78 %? 000- 486000 Transfer From Reserves 40,860.00 - - - - 40,860.00 0.00% TOTAL Fund Transfers 40,860.00 - - 40;860.00 0.00% Miscellaneous 000 - 491000 Interest Earned 500.00 38.24 257.99 208.46 - 291.54 41.69% 000 - 491200 Investment Earnings 4,000.00 5,725.93 34,180.58 47,549.85 - (43,549.85) 1188.75% 000 - 495015 Contribution from SED 366,788.00 - 356,118.75 361,018.75 - 5,769.25 98.43% 000 - 495020 Contribution from YMCA 100,000.00 - - 100,000.00 - - 100.00% 000 - 498000 Proceeds From Refunding Debt - - 4,185,000.00 - - - 0.00% TOTAL Miscellaneous 471,288.00 5,764.17 4,575,557.32 508,777.06 - (37,489.06) 107.95% TOTAL REVENUES 6,614,581.00 46,984.69 10,386,281.43 6,658,620.80 - (44;039.80) 100.67 %` CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30th, 2017 505 -TAX I& S *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** GENERAL GOVERNMENT CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 100% OF NON DEPARTMENTAL BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Professional Services 101 - 541500 Paying Agent 2,500.00 1,400.00 2,550.00 2,950.00 - (450.00) 118.00% 101 - 541502 Cost of Bond Issuance 100,000.00 - 82,22423 - - 100,000.00 0.00% TOTAL Professional Services 102,500.00 1,400.00 84,774.23 2,950.00 - 99,550.00 2.88% Debt Service 101 - 555612 Bond -GO Refunding 2010 - Principal 285,000.00 - 275,000.00 285,000.00 - - 100.00% 101 - 555612.1 Bond -GO Refunding 2010 Interest 47,025.00 21,375.00 55,425.00 47,025.00 - - 100.00% 101 - 555626 LS &D SR2006- Principal - - 400,000.00 - - - 0.00% 101 - 555626.1 LS &D SR2006- Interest - - 0.01 - - - 0.00% 101 - 555628 CO Bond 2007 - Principal - - 122,800.00 - - - 0.00% 101 - 555628.1 CO Bond 2007 - Interest - - 4,923.89 - - - 0.00% 101 - 555629 GO Bond 2007 - Principal 280,000.00 - 265,000.00 280,000.00 - - 100.00% 101 - 555629.1 GO Bond 2007 - Interest 147,945.00 70,870.07 158,919.93 147,691.26 - 253.74 99.83% 101 - 555630 GO Bond SR2008 Principal 460,000.00 - 440,000.00 460,000.00 - - 100.00% 101 - 555630.1 GO Bond SR2008 Interest 278,362.00 134,431.50 296,947.00 278,362.00 - - 100.00% 101 - 555631 GO Bond SR2009 Principal 550,000.00 - 540,000.00 550,000.00 - - 100.00% 101 - 555631.1 BO Bond SR2009 Interest 266,325.00 129,037.50 282,675.00 266,325.00 - - 100.00% 101 - 555633 GO SR2011 Principal 235,000.00 - 225,000.00 235,000.00 - - 100.00% 101 - 555633.1 GO SR2011 Interest 334,763.00 165,618.75 341,662.50 334,762.50 - 0.50 100.00% 101 - 555634 GO SR2011A Refund Principal 620,000.00 - 605,000.00 620,000.00 - - 100.00% 101 - 555634.1 GO SR2011A Refund Interest 102,404.00 47,148.84 116,596.44 101,962.09 - 441.91 99.57% 101 - 555635 GO SR2012 Principal 320,000.00 - 310,000.00 320,000.00 - - 100.00% 101 - 555635.1 GO SR2012 Interest 181,755.00 87,397.50 194,721.25 181,755.00 - - 100.00% 101 - 555636 Tax Note - SR2013 - Principal 170,000.00 - 170,000.00 170,000.00 - - 100.00% 101 - 555636.1 Tax Note - SR2013 - Interest 3,995.00 1,445.00 5,950.00 3,995.00 - - 100.00% 101 - 555637 Tax Note - SR 2013A - Principal 160,000.00 - 160,000.00 160,000.00 - - 100.00% 101 - 555637.1 Tax Note - SR2013 - Interest 3,185.00 1,072.50 5,265.01 3,185.00 - - 100.00% 101 - 555638 Bond -GO 2014 Refund - Principal 100,000.00 - 100,000.00 100,000.00 - - 100.00% 101 - 555638.1 Bond -GO 2014 Refund - Interest 292,275.00 145,637.50 294,275.00 292,275.00 - - 100.00% 101 - 555639 Tax Note - SR2015 - Principal 35,000.00 35,000.00 35,000.00 35,000.00 - - 100.00% 101 - 555639.1 Tax Note - SR2015 - Interest 3,150.00 1,575.00 3,756.42 3,139.26 - 10.74 99.66% 101 - 555640 Bond -Ref 2015 Bond- Principal 450,000.00 - 80,000.00 450,000.00 - - 100.00% 101 - 555640.1 Bond -GO Ref 2015- Interest 102,125.00 48,812.50 80,368.75 102,125.00 - - 100.00% CITY O F S C H E RTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30th, 2017 505'T&X|&8 GENERAL GOVERNMENT NON DEPARTMENTAL CURRENT CURRENT PRIOR YEAR BUDGET QUARTER Y-T-D ACTUAL 30 16 '20 17 CURRENT Y-T-D ACTUAL Y�-D BUDGET 100% OF ENCUMBR BALANCE BUDGET 145,000l0 ' ' 100.00% 101~555641.1 Tax Note -SR2O15A- Interest 101-555841 Tax Note -SR2O15A' Principal 145,000I0 145,000I0 125,000.00 145,000l0 ' ' 100.00% 101~555641.1 Tax Note -SR2O15A- Interest 13.783.00 0.891.50 10.995.60 13.750.82 - 32.08 9977% 101~555642 GD Bond SR2O1OPrincipal - - - 405.000.00 - (405.000.00) 0.00% 101-555642.1 G0 Bond SR2O10 Interest - 85.853.13 - 175.756.20 - (175.756.26) 0.00% 101-555043 CO Bond Tax SR2O1OPrincipal - - - 55.000.00 - (55.000.00) 0.00% 101-555043.1 C0 Bond Tax SR2O10Interest - 24.031.25 - 48.887.50 - (48.887.50) 0.00% 101-555044 CO Bond nonTaxSR2O10Principal - - - 170.000.00 - (170.000.00) 0.00% 101-555044 C0 Bond nonTaxSR2010Interest - 30.384.38 - 76.168.70 - (76.168.76) 0.00% 101-555900 Debt Service 924.989.00 - - - - 924.888.00 0.00% 101-555800 Bond Premium -_ - �_ - (.l0% TOTAL Debt Service 6,512,081.00 1,187,581.92 5,621,625.70 6,517,165.55 (5,084.55) 1 0008% Other Financing Sources 101-556300 Payment toRefund Debt - _ 4215481 88 - �_ - I.}0% -- Other Financing Sources 15p481 TOTAL EXPENDITURES 6,614,581.00 1,188,981.92 9,921,881 81 6,520,115.55 94,465.45 98.57% TAX I &S CASH IN BANK AND INVESTMENTS AS OF: September 30th, 2017 Cash in Bank Claim on Operating Cash Pool- Checking $ 59,148.19 Cash in Investments MBIA Investment -Tax I &S 1,390,933.94 Total Cash in Bank & Investments $ ;1,450,082.13 620 -SED CORPORATION FINANCIAL SUMMARY CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30th, 2017 ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6- 2 0 1 7********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** CURRENT PRIOR YEAR CURRENT Y -T -D QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BUDGET 100% OF BALANCE BUDGET REVENUE SUMMARY Taxes 3,692,710.00 957,811.56 3,660,101.11 3,620,929.57 - 71,780.43 98.06% Miscellaneous 45,550.00 35,970.76 52,546.54 125,682.23 - (80,132.23) 275.92% TOTAL REVENUES 3,738,260.00 993,78232 3,712,647.65 3,746,611.80 - (8,351.80) 100.22 %' EXPENDITURE SUMMARY ECONOMIC DEVELOPMENT Personnel Services - - 253,099.89 417.36 - (417.36) 0.00% Supplies 750.00 1339 122.83 415.47 - 334.53 55.40% Human Services 1,000.00 - 44.44 389.64 - 610.36 38.96% City Support Services 7,700.00 807.09 2,225.71 4,701.93 - 2,998.07 61.06% Utility Services 4,820.00 785.78 2,631.20 2,386.78 - 2,433.22 49.52% Operations Support 131,000.00 22,086.08 98,153.04 63,855.37 139.49 67,005.14 48.85% Staff Support 22,300.00 3,435.83 6,326.32 14,846.49 - 7,453.51 66.58% City Assistance 1,005,000.00 71.50 100,331.27 1,050.52 - 1,003,949.48 0.10% Professional Services 87,500.00 13,232.48 23,762.69 20,353.85 - 67,146.15 23.26% Fund Charges/Transfers 797,847.00 107,764.77 407,142.75 792,077.75 - 5,769.25 99.28% Debt Service - - 161,215.00 - - - 0.00% Operating Equipment 4,700.00 3,041.01 1,953.54 3,341.00 - 1,359.00 71.09% Capital Outlay - 28,533.00 - - - 0.00% TOTAL'ECONO DEVELOPMENT 2,062,617.00 151,237.93 1,085,541.68 ` 903,836.16 139.49 1,158,641.35 43.83% MISC & PROJECTS PROJECTS - - 221,673.35 - - - 0.00% TOTAL MISC & PROJECTS - - 221,673.35 ` - - - 0.00% TOTAL EXPENDITURES 2,062,617.00 151,237.93 1,307,215.03 ' 903,836.116 139.49 1,158,641.35 43.83% *- REVENUE OVER(UNDER) EXPEND 1,675,643.00 842,544.39 2,405,432.62 2,842,775.64 (139.49) (1,166,993.15) SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: September 30th, 2017 Cash in Bank Claim on Operating Cash Pool- Checking $ 894,192.94 Cash in Investments Texas Class Investment- Economic Development Corl 11,437,906.23 Schertz Bank & Trust - Certificate of Deposit 1,060,336.70 Total Cash in Bank & Investments $ 13,392,435.87 4B SALES TAX By Collection Month $450,000 -4.6% 8.7% .8% $400,000 1.9% % $350,000 - - - - - - - 19.9% 9.5% o 13.6% .. % -18.7% 8.3% / $300,000 - - `_ _ _ $250,000 $200,000 - - - - - - - - - --- - - - - -- - $150,000 $100,000 $50,000 - - - - - - - - - - - - - $ OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2016 -17 287,235 379,299 290,086 280,216 373,641 243,369 216,222 334,771 276,770 283,282 348,268 286,986 2015 -16 239,534 372,334 264,843 246,568 391,510 265,249 265,854 307,920 284,254 261,570 2014 -15 247,750 319,452 252,513 210,669 397,691 225,482 247,025 361,702 232,983 248,121 379,939 254,153 2013 -14 240,623 328,635 277,289 208,130 364,222 243,967 270,738 390,528 346,223 224,288 340,166 273,715 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 C I T Y 0 F S C H E R T Z INVEST14ENT REPORT FOR MONTH ENDING September 31th, 2017 INVESTMENT POOLS Beginning Deposits/ Interest Ending Ending Par Maturity Weighted Rock Value Yield Purchases Withdrawals Earned Book Value Mkt Value Value Date Avg Met. OPERATIONS -BANK CASH Schertz Bank & Trust - Pooled Cast 10,532,642.45 0.0500 4,468,596.89 4,356,526.79 7,515.11 10,652,227.66 10,652,227.66 10,652,227.66 N/A Sohertz Bank & Trust - PEG Fund 621,979.35 0.0000 21,775.75 26,680,00 617,075.10 617,075,10 617,075.10 N/A TOTAL OPERATIONS 11,154,621,80 4,490,372.64 4,383,206.79 7,515.11 11,269,302.76 11,269,302.76 11,269,302.76 LOGIC General. Fund 7,228,437.48 1.2827 - - 7,620.68 7,236,058.16 7,236,058.16 7,236,058.16 N/A 40 days G/F-Equipment Replacement 74,767.89 1.2827 - - 78.81 74,846:70 74,846.70 74,846.70 N/A 40 days G/P-Vehi.l. Replacement: 504,142.64 1.2827 - - 531.47 504,674.11 504,674.11 504,674.11 N/A 40 day. G/F-Air Conditioner Replacement 274,358.43 1.2827 - - 289.23 274,647.66 274,647,66 274,647.66 N/A 40 day. SR2009 Bond-Street Projects(II) 880,947.64 1,2827 - - 928.74 881,876.38 881,876.38 881,876.38 N/A 40 day. 602017 FIRE STATION 3 4,009,049.92 1:2827 - - 4,226.58 4,013,276.50 4,013,276.50 4,013,276.50 N/A 40 day. 002017 AMBULANCES 551,244.39 1.2827 - - 581.15 551,825.54 551,825:54 551,825.54 N/A 40 day. CO2017 BUILDING REPAIRS 250,565.63 1.2827 - - 264.16 250,829.79 250,829.79 250,829.79 N/A 40 days CO2017 FIRE APPARATUS 141,192.70 1.2827 - - 148.86 141,341.56 141,341.56 141,341.56 N/A 40 day. 002017 PARK MAINT 50,113,11 1.2827 - - 52.84 50,165.95 50,165.95 50,165.95 N/A 40 day. 002017 PARK TRAIL 250,565.63 1.2827 - - 264.16 250,829.79 250,829.79 250,829.79 N/A 40 days CO2017 SCHERTZ DEWY 701,583.73 1.2827 - - 739.65 702,323.38 702,323.38 702,323.38 N/A 40 days CO2017 STATION2 REPAIR 400,905.03 1.2827 - - 422.66 401,327.69 401,327.69 401,327.69 N/A 40 days 002017 STREETS 2,204,977.43 1.2827 - - 2,324.62 2;207,302.05 2,207,302.05 2 207302.05 N/A _40-day. TOTAL LOGIC 18,402,745.0 - - 18,473.61 18,421,219.48 18,421,219.48 18,421,219:48 L..ESTAR Capital Recovery - Sewer 3,693,146.35 1.2465 - - 3,782.70 3,696,929.09 3,696,929,09 3,696,929.09 N/A 47 day. Capital Recovery - Water 4,606,427.02 1.2465 - - 4,718.13 4,611,145.15 4,611,145,15 4,611,145.15 N/A 47 day. Drainage Fund 928,019.04 1.2465 - - 950,52 928,969.56 928,969.56 928,969.56 N/A 47 day. Facilities Master Plan 26,259.58 1,2465 - - 26.90 26,286.48 26,286.48 26,286:48 N/A 47 days GO SR2011 Animal Shelter 8,703.15 1.2465 - - 8.91 8,712.06 8,712.06 8,712.06 N/A 47 day. GO SR2011 Soccer Fields 163,955.06 1.2465 - - 167,93 164,122.99 164,122.99 164,122.99 N/A 47 day. GO SR2011 Swimming Pool 1,862,64 1.2465 - - 1.91 1,864.55 1,864,55 1,864.55 N/A 47 day. GO SR2012 Downtown Improvements 991,786,99 1.2465 - - 1,015.84 992,802:83 992,802.83 992,802.83 N/A 47 day. BE Elevated Water Tank 2,446,851.32 1.2465 - - 2,506.18 2,449,357.50 2,449,357.50 2,449,357.50 N/A 47 days Sewer/CCMA Project 2,877,647.57 1.2465 - - 2,947.43 2,880,595.00 2,880,595.00 2,880,595.00 N/A 47 day. W/S-Customer Deposits 299,723,22 1.2465 - - 306.99 300,030.21 300,030.21 300,030.21 N/A 47 days W/S-Equipment Repl/Cap.Imp 180,207.68 1.2465 - - 184.58 180,392.26 180,392.26 180,392.26 N/A 47 day. Water&Sewer 4,816,215.66 1.2465 - - 4,933.00 4,821,148.66 4,821,148.66 4,821,148.66 N/A 47 day. H/S-Vehicle Replacement 260:326,38 1,2465 266.64 260,593.02 260,593.02 260,593.02 N/A 47 day. TOTAL LONESTAR 21,301,131.70 - - 21,817.66 21,322,949.36 21,322,949.36 21,322,949:36 TEXAS CLASS Tax I&S 1,389,512.28 1.2300 - - 1,421.66 1,390,933.94 1,390,933.94 1,390,933,94 N/A 79 Days ,Tustice Forfeiture 247,891.91 1.2300 - - 253.61 248,145.52 248,145.52 248,145,52 N/A 79 Days Park Fund 330,026.09 1.2300 - - 337.65 330,363.74 330,363.74 330,363.74 N/A 79 Days Economic Development Corporation 11,426,215.77 1.2300 - - 11,690.46 11,437,906.23 11,437,90623 11,437,906,23 N/A 79 Days Library Board 45,564.09 1.2300 - - 46.61 45,610.70 45,610.70 45,610,70 N/A 79 Days Tree Mitigation 312,078.51 1,2300 - - 319.30 312,397.81 312,397.81 312,397.81 N/A 79 Days I- Not. 2013 Fire Truck 5,007.65 1:2300 - - 5.11 5,012.76 5,012.76 5,012.76 N/A 79 Days Hotel 1- 1,293,904.01 1,2300 - - 1,323.83 1,295,227.84 1,295,227.84 1,295,227.84 N/A 79 Days Special Events Fund 17,048.91 1.2300 - - 17.43 17,066.34 17,066,34 17,066.34 N/A 79 Days Tax Notes 2015 EMS Ambulances 89,936.02 1.2300 - - 92.03 90,028.05 90,028,05 90,028.05 N/A 79 Day. Tax Notes 2015 Drainage Equipment 689,802.58 1.2300 - - 705.77 690,508,35 690,508.35 690,508.35 N/A 79 Day. Tax Not.. 2015 Water Equipment 265,756,62 1,2300 - - 292.36 286,048.98 286,048,98 286,048.98 N/A 79 Days Tax Notes 2015 General Fund Equipu 243,885.35 1.2300 - - 249.53 244,134.88 244,134.88 244,134.88 N/A 79 Day. Tax Notes 2015A Fire Trucks & Equi 633.60 1,2300 - - 0,62 634.22 634.22 634.22 N/A 79 Days 2016 CO Roads 1,009,960.05 1,2300 - - 1,033.30 1,010,993.35 1,010,993.35 1,010,993.35 N/A 79 Day. 2016 CO Building Repairs 174,456.49 1.2300 - - 178.49 174,634.98 174,634.98 174,634.98 N/A 79 Day. 2016 CO Rec Center Windows 12.05 1.2300 - - - 12.05 12.05 12.05 N/A 79 Day. 2016 GO Fire Station 3 4,039,840.04 1.2300 4,133.28 4,043,973.32 4,043,973.32 4,043,973.32 N/A 79 Day. TOTAL TEXAS CLASS 21,601,532.02 22,101.04 21,623,633.06 21,623,633.06 21,623,633.06 C I T Y O F S C H R T; INVESTMENT REPORT FOR MONTH ENDING September '31th, 2017 Finance Director This investment portfolio represents a liquid and diverse holding by the City of Schertz.: The investment . strategy is to hold the monthly operating funds in the bank while investing other funds. By looking at the purpose of the funds being invested,: it can be determined that it is in best interest of the :City to :invest . in securities over 1 year to maximize. yield while still maintaining all collateral and other safety. requirements. This portfolio is in compliance with the City's Investment Policy and with the Public Funds Investment Act. 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,370,096.18 2.0000 1,377.51 4,279.31 661.54 1,381,383.54 1,367,855.92 1,357,765.82 N/A 685 Days Capital One Capital Recovery Sewer 1,757,438.48 1.9500 5,585.26 .2,717.61 1,765,813.70 1,754,570.83 1,741,872.40 N/A 676 Days TOTAL CAPITAL ONE 3,127,534.66 1,377,51 91864.57 3,379.15 3,147,197.24 3,122,426x75 3,099,.638.22 - C. D. CERTIFICATES OF DEPOSIT Term SBST- WatersSewer 1,089,599.19 1 -.0000 - - - 1,089;599.19 1,097,599.54 1,089,599.19 1/6/2018 365 Days Schertz Economic Development Corp:. 1,060,336.70 0.6000 - - - 1,060,336.70 1,062,550.34 1,060,336:70 11/23/2017 180 Days Schertz Economic Development Corp. 1,012,004.38 1.0000 - - - 1,012,004.38 1,019,407.26 1,012,004.38 1/7/2018 365 Days TOTAL C.D.s 3,161,940,28 - - 3,161,940.28 ': 3,179,557.14 3,161,940.28 .TOTAL PORTFOLIO 1.27 e $ 73,286.57 $ 78,946,242; 18 $ 78,939,088.55 $ 78,898,.683.16 83 .w. Days Finance Director This investment portfolio represents a liquid and diverse holding by the City of Schertz.: The investment . strategy is to hold the monthly operating funds in the bank while investing other funds. By looking at the purpose of the funds being invested,: it can be determined that it is in best interest of the :City to :invest . in securities over 1 year to maximize. yield while still maintaining all collateral and other safety. requirements. This portfolio is in compliance with the City's Investment Policy and with the Public Funds Investment Act. TOTAL TEXAS CLASS 28% City Portfolio By Investment Type Mftffiwiw�-V� TOTAL LONESTAR 27% TOTAL LOGIC 23% City Portfolio Designated Funds, $1,662,873.76 4.50 *'on 3.50 3.00 2�oo 2.00 1�5m 1.00 0.50 Dot-16 Nov-I6 Dec-16 Jan-17 Feb-17 Mar_17 Apr-17 May-17 Jon-17 Jul-17 Aug-17 3ep-17 Oct-16 NOV-16 Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 MI Month T-Bill 0.1800 0.3700 0.4300 0.4900 0.3900 0.7300 0.6800 0.8500 0.8200 0.9800 0.9300 0.9400 03 Month T-Bill 0.3400 0.4800 05100 0.5200 0.5400 0.7500 0.8800 0.9600 10100 1.0500 0.9900 1.0400 [36 Month T-Bill 0.5100 0.6100 0.6100 0.6300 0.6800 0.8900 0.9900 1.0600 1.1200 1.1100 1.0600 1.1800 OSchertz Portfolio 0.8000 0.8000 1.0000 1.0000 0.9551 1.0267 1.0774 1.0935 1,1202 1.2232 1.2548 1.2672 MSchertz Bank&Trust 0.0500 0.0500 1 0.0500 0.0500 0.0500 0,0500 0.0500 0.0500 0.0500 0.0500 010500 0.0500 UCD 365 Days 0.8000 0.8000 1.0000 1.0000 1.0000 1.0000 1.0000 1.0000 1.0000 1.0000 1.0000 1.0000 MCD 180 Days O6000 0.6000 0.6000 0.6000 0.6000 0.6000 0.6000 0.6000 0.6000 0.6000 0.6000 0.6000 MLOGIC 0.8112 0.8364 1.2827 1.2827 0.9716 1.2827 1.0739 1.0761 1.1333 1.2408 1.2660 1.2827 CLoneStar 0.6900 0.7087 1.2465 1.2465 0.8362 1.2465 0.9848 1.0006 1.0006 1.1941 1.2222 1.2465 MMBIA 0.8300 0.9000 1.2300 1.2300 0.9700 1.2300 1.0600 1,0900 11300 11800 1.2300 4.2300 MCapital One 1.6900 1.6900 2.0000 2.0000 1.6900 1.9460 1.9463 1.9432 1.7902 1.7895 1.7895 1.7686 C I T Y . OF S C H E R T Z Investment Report Capital One Assets Date: 9/30/2017 General Fund Assets Projected Annual Current Cash &: Equivalents Due Maturity Shares Cost Mrk Value Income. Yield Fidelity Imm Government. Fund 42642 67.765.82 67,765.82 67,765.82 644 00 0.95 Total Cash & Equivalents 67,765.82 67,765.82 67,765.82 644.00 0.950 Fixed Income Federal Natl Mtg Assn. 1/27/2020 849.00 2 5,000.00 24,981.80 24;977.25 425.00 1.70 Federal Home LN Mtg Corp Reference 11/17/2017 48.00 50,000.00 54,930.00 50,253.50 2,562_00 5.10 Federal Home LN Mtg Corp Refrnce 8 6/13/2018 256.00 100,000.00 110,756.94 102,459.00 4,875.00 4.76 US Treasury Note 10/15/2017 15.00 40,.000.00 39,913 .84 39,998.00 350.00 0.88 US Treasury Note 1.0/31/2019 761;00 100,000.00 101,875.00 100,016. 00 1,500.00 1.50 US Treasury Note 12/31/2019 822.00 50,000.00 50,208.98 50,119:50 812,00 1.62 US Treasury Note 8715/2020 1050,00 100,000.00 103,894.53 102,858.00 2,625.00 2.55 US Treasury Note 12/15/2018 441.00 125,000.00 126,181.64 124,795.00 1,562.00 1.25 US Treasury Note 2/28/2019 516.00 50,000.00 49,996.09 49,974.00 687,00 1.37 US Treasury Note 4/30 ✓2019 577.00 50,000.00 49,945.31 49,862.50 625,00 1.25 US Treasury Note 10/31/2019 761.00 100,000.00 99,601.56 99,522.00 1,250.00 1.26 U5 Treasury Note 11/30/2019 791.00 100,000.00 99,554.69 98,957.00 1,000.00 1.01 US Treasury Note 1/31/2020 853.00 100,000.00 101,312.50 99,651.00 1,375.00 1.38 US Treasury Note 7/31/2018 304.00 75,000.00 75,791.99 75,030.75 1,031.00 1.37 US Treasury Note 3/15/2020 897.00 75,000.00 75,225.59 75,130.50 1,218.00 1.62 US Treasury Note 5/31/2020 974.00 75,000..00 74,991.21 74,.847.75 1,125 -.00 1.50 US Treasury Note 5/15/2020 958.00 75,000.00 74,956.05 74,861.25 1,125.00 1.50 Total Fixed Income 1,290,000.00 1,313, 617. 72 1,293,313.00 24,147.00 1.87- Total Assets 627.45 1,357,765.82 1,381,383.54 1,361,078.82 24,781.00 1.82% Capital Recovery Assets Projected Annual Current Cash &Equivalents. Due Maturity Shares: Cost Mrk Value Income Yield. Fidelity Imm Government Fund #2642 41,872.40 41.872.40 41,872.40 398.00 0.95 Total Cash & Equivalents 41,872.40 41,872.40 41,872.40 398.00 0.95- Federal Natl Mtg Assn 10/26/2017 26.00 125,000.00 124,588.38 124,,987.50 1,093.00 0.87 Federal Natl Mtg Assn 1/27/2020 849.00 50,000.00 49,963.60 49,,954.50 850.00 1.70 Federal Home Mtg Corp Refrnce 8 6/13/2018 256.00 100,000.00 110,753.60 102,459.00 4,875.00 4.76 Federal Home LN Mtg Corp 3/27/2019 543.00 100,000.00 108,297,40 103,323,00 3,750.00 3.63 US Treasury Note 10/31/2019 761.00 100,000.00 100,065.85 100,016.00 1,500.00 1.50 US Treasury Note 12/31/2019 822:00 100,000.00 100,417.97 100,239.00 1,625.00 1.62 US Treasury Note 8/15/2020 1050.00 100,000.00 103,394.53 102;858. -00 2,625.00 2.55 US Treasury Note 12/15/2018 441.00 100,000.00 100,945.31 99,836.00 1,250.00 1.25 US Treasury Note 2/28/2019 516.00 100,.000.00 99.,992.19 99,.948.00 1,375.00 1.38 US Treasury Note 4/30/2019 577.00 100,000.00 99,890.63 99,725.00 1,250,00 1.25 US Treasury Note 10/31/2019 761.00 100,000,00 99,601.57 99,522.00 1,250,00 1.26 US Treasury Note 11/30/2019 791.00 200,000.00 199,226.56 197,914_00 2,000.00 1.01 US Treasury Note 1/31/2020 853.00 50,000.00 50,656.25 49,825.50 687.00 1.38 US Treasury Note 6/30/2018 273.00 75,000.00 75,916.99 75,050.25 1,031.00 1.37 US Treasury Note 3/15/2020 897.00 100,000.00 100,300.78 100,174.00 1,625.00 1.62 US Treasury Note 5/31/2020 974.00 100,000.00 99,988.28 99,797.00 1,500_00 1.50 US Treasury Note 5/15/2020 958.00 100,000.00 99,941.41 99:815.00 1.500.00 1.50 Total Fixed -Income 1,700,000.00 1,723,941.30 1,.705,443..75 29,786.00 1. 75-' Total Assets 640.50 1,741 ,872.40. :1,765,813.70 ',1,747,316.15 30,184.00 1.73 %: 3,523.00