Loading...
Q1-December-2016 FinancialsCITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2016 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 18,720,400.00 6,207,426.55 7,249,860.10 8,086,841.12 - 10,633,558.88 43.20% Franchises 2,306,600.00 165,011.56 475,477.40 518,497.95 - 1,788,102.05 22.48% Permits 1,232,500.00 61,231.00 322,516.51 518,305.00 - 714,195.00 42.05% Licenses 51,160.00 7,052.50 12,224.50 15,165.00 - 35,995.00 29.64% Fees 2,251,582.00 143,349.17 573,907.12 603,701.00 - 1,647,881.00 26.81% Fines 28,000.00 1,502.23 5,945.24 5,190.42 - 22,809.58 18.54% Inter - Jurisdictional 879,508.00 83,974.55 195,662.34 229,330.04 - 650,177.96 26.07% Fund Transfers 3,642,745.00 201,313.00 403,449.11 603,938.72 - 3,038,806.28 16.58% Miscellaneous 488,700.00 47,258.60 139,090.72 116,349.98 - 372,350.02 23.81% TOTAL REVENUES 29,601,195 6,918,119.16 9,378,133.04 10,697,319.23 - 18,903,875.77 36.14 %i EXPENDITURE SUMMARY ;e3�17_1�Ki1�17►1�1�►ki1 C�iii���I�P►L�I1 Personnel Services 32,132 3,867.84 5,777.63 7,004.49 - 25,127.51 21.80% Supplies 1,300 - 39.30 46.81 - 1,253.19 3.60% City Support Services 53,500 65.00 42,770.48 33,174.91 146.31 20,178.78 62.28% Operations Support 500 172.69 - 195.64 140.40 163.96 67.21% Staff Support 28,910 11,274.46 10,661.52 13,616.30 433.78 14,859.92 48.60% Operating Equipment 640 723.00 - 723.00 - (83.00) 112.97% TOTAL CITY COUNCIL 116,982 16,102.99 59,248.93 54,761.15 720.49 61,500.36 47.43% CITY MANAGER Personnel Services 1,076,365 122,354.54 221,366.19 239,139.43 - 837,225.57 22.22% Supplies 3,000 15.05 671.89 29.07 133.58 2,837.35 5.42% City Support Services 7,535 4,989.85 - 4,989.85 - 2,545.15 66.22% Utility Services - - 114.82 17.99 - (17.99) 0.00% Staff Support 35,495 2,026.11 1,565.16 3,909.32 561.40 31,024.28 12.60% TOTAL CITY MANAGER 1,122,395 129,385.55 223,718.06 248,085.66 694.98 873,614.36 22.17 % > CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2016 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET MUNICIPAL COURT Personnel Services 287,455 30,979.80 71,764.22 76,887.67 - 210,567.33 26.75% Supplies 2,000 23.97 138.60 228.92 142.36 1,628.72 18.56% City Support Services 1,000 37.78 - 37.78 - 962.22 3.78% Operations Support 3,250 - - - - 3,250.00 0.00% Staff Support 7,310 213.81 1,033.71 439.56 260.00 6,610.44 9.57% Court Support 700 - - - - 700.00 0.00% Professional Services 67,200 4,650.00 10,480.50 12,700.00 47,550.00 6,950.00 89.66% Maintenance Services 2,000 150.00 350.00 500.00 1,350.00 150.00 92.50% Operating Equipment - - - 39.02 (39.02) 0.00% TOTAL MUNICIPAL COURT 370,915 36,055.36 83,767.03 90,832.95 49,30236 230,779.69 37.78 % CUSTOMER RELATIONS -311 Personnel Services 113,744 12,470.76 29,724.87 31,042.20 - 82,701.80 27.29% Supplies 150 23.99 - 23.99 16.31 109.70 26.87% Staff Support 475 - - - - 475.00 0.00% TOTAL CUSTOMER RELATIONS -311 114,369? 12,494.75 29,724.87 31,066.19 16.31 83,286.50 27.18 % ` PLANNING & ZONING Personnel Services 190,445 21,144.08 34,851.91 48,022.07 - 142,422.93 25.22% Supplies 3,130 - 181.94 - 201.93 2,928.07 6.45% City Support Services - - - - - - 0.00% Operations Support 150 - - - 13.50 136.50 9.00% Staff Support 24,299 850.98 1,035.46 978.98 155.00 23,165.02 4.67% Professional Services 100 70 - 70 - 30 70.00% Operating Equipment - - - - 3,400.40 (3,400.40) 0.00% TOTAL PLANNING &ZONING 218,124 22,065.06 36,069.31 49,071.05 3,770.83 165,282.12 24.23 %% LEGAL SERVICES Operations Support 10,000 323.56 - 559.66 84.76 9,355.58 6.44% Professional Services 230,000 4,238.79 8,615.40 4,238.79 - 225,761.21 1.84% TOTAL LEGAL SERVICES 240,000' 4,562.35 8,615.40 4,798.45 8416 235,116.79 2.03 % CITY O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDUED) AS OF: DECEMBER 31a\2O1O 2U1V-2V17 101GENERALqJmo CURRENT CURRENT PRIOR YEAR v�o Y�o BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y�-DACTUAL ACTUAL ENCUMBR BALANCE BUDGET GENERAL SERVICES Personnel Services ' 104.57 132.97214 8.254.50 (8.254.50) 0.00Y6 Supplies 8.380.93 0.00% Utility Services 0 TOTAL GENERAL SERVICES - 16457 148,802.20 8,254.56 (8,254.56) 0.00% CITY SECRETARY Personnel Services 175.007 19.06914 42.889.35 45.08477 - 130.00223 25.06% Supplies 1.350 (30.30) 84.80 409.95 5420 88578 34.39% City Support Services 12.500 1.805.83 1.814.02 1.805.93 - 10.034.17 14.93% Staff Support ------_6,225 -----_-16L1.86 ----__902.00 _---_1,596.06 _-----_--- ---_4,628.94 25.6£% TOTAL CITY SECRETARY 195,762 21,666.47 47,790.03 48,956.61 54.26 146,751.13 25.04% NON-DEPARTMENTAL City Support Services 678.800 1.426.00 182.225.80 165,434.17 0.479.00 506.840.83 25.32% Operations Support 141.500 29.844.55 17.48078 35.583.06 30.31 105.880.03 25.17% Staff Support 200 80.00 120.00 40.00Y6 City Assistance 1.732.157 - 119.91031 128.020.97 378.002.91 1.228.07312 2810'& Professional Services 71.135 3.083.80 13.94028 11.953.38 34.074.00 25.107.02 04.70Y6 Fund Chrga/Tmnaha-Spon Events Fnd 1.011.700 - - - - 1.011.700.00 0.00'& Operating Equipment -_ -_ 1,874/00) -_ -_ 0.00'& TOTAL NON-DEPARTMENTAL 3,635,552 34,354.41 335,437A7 339,072.18 418,652.22 2,877,827.60 20.84% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2016 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET PUBLIC AFFAIRS Personnel Services 271,039 30,181.30 67,026.27 70,457.99 - 200,581.01 26.00% Supplies 2,300 7.47 29.36 94.06 - 2,205.94 4.09% Operations Support 22,450 18.00 1,123.00 718.00 638.00 21,094.00 6.04% Staff Support 3,000 301.00 180.00 301.00 - 2,699.00 10.03% Professional Services 25,000 - - 10,800.00 6,520.00 7,680.00 69.28% Operating Equipment 1,000 - - - - 1,000.00 0.00% TOTAL PUBLIC AFFAIRS 324,789 30,507.77 68,35 &.63 82,371.05 7,158.00 235,259.95 27.57 %` RECORDS MANAGEMENT Personnel Services 52,832 5,604.55 13,950.93 14,739.89 - 38,092.11 27.90% Supplies 250 - 25.69 - - 250.00 0.00% Staff Support 350 - - - - 350.00 0.00% Professional Services 12,000 366.05 2,090.00 2,056.05 - 9,943.95 17.13% Operating Equipment 250 - - - - 250.00 0.00% TOTAL RECORDS MANAGEMENT 65,682 5,970.60 16,066.62 16,795.94 - 48,886.06 25.57 %s SCHERTZ MAGAZINE Personnel Services 133,608 15,125.06 19,635.70 35,769.64 - 97,838.36 26.77% Supplies 200 - - - - 200.00 0.00% Opperations Support 1,000 - - 6,794.09 - (5,794.09) 679.41% Staff Support 1,860 - - 18.00 - 1,842.00 0.97% Professional Services 246,000 7,771.85 39,103.81 41,662.50 15,455.48 188,882.02 23.22% Fund Charges /Transfers 10,000 - - - - 10,000.00 0.00% TOTAL SCHERTZ MAGAZINE 392,668x! 22,896.91 58,739.51 84,244.23 15,455.48 292,968.29 25.39 % ENGINEERING Personnel Services 485,111 44,270.29 46,500.33 98,911.32 - 386,199.68 20.39% Supplies 1,620 54.64 50.70 54.64 - 1,565.36 3.37% City Support Services 295 - 590.40 - - 295.20 0.00% Utility Services 3,500 4.73 124.40 4.73 - 3,495.27 0.14% Operations Support 2,550 - - - - 2,550.00 0.00% Staff Support 9,475 - - 198.00 106.00 9,171.00 3.21% Professional Services 50,800 - 495.00 - 15,000.00 35,800.00 29.53% Operating Equipment 400 - - - - 400.00 0.00% TOTAL ENGINEERING 553,751 44,329.66 47,760.83 99,168.69 15,106.00 439,476.51 20.64 % CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2016 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET GIS Personnel Services 151,979 16,788.48 36,326.39 39,768.54 - 112,210.46 26.17% Supplies 2,295 - - - - 2,295.00 0.00% Staff Support 4,600 - - - - 4,600.00 0.00% Rental /Leasing 2,085 174 521 521 1,563 1.20 0.00% TOTAL GIS 160,959 16,962.13 36,847.34 40,289.49 1,562.85 119,106.66 26.00 %° TOTAL GENERAL GOVERNMENT 7,511,948 397,518.58 1;200,945`.93 1,197,768.20 512,578.54 5,801,601.46 22.77 %' PUBLIC SAFETY POLICE Personnel Services 6,038,924 636,572.65 1,467,332.16 1,566,003.82 - 4,472,920.18 25.93% Supplies 83,973 11,716.03 13,324.01 12,388.13 3,483.56 68,101.69 18.90% City Support Services 19,081 - 19,081.45 21,294.42 - (2,213.42) 111.60% Utility Services 96,587 5,454.08 11,989.61 11,986.53 - 84,600.87 12.41% Operations Support 3,065 284.90 695.95 379.84 2,685.16 12.39% Staff Support 136,580 3,302.14 8,530.35 11,318.84 1,042.81 124,218.65 9.05% City Assistance 9,587 - 1,357.88 935.18 1,188.16 7,463.66 22.15% Professional Services 40,408 3,361.99 15,998.80 14,863.09 1,406.20 24,138.71 40.26% Maintenance Services 56,033 9,040.00 15,865.00 9,785.00 326.00 45,921.95 18.04% Rental /Leasing 46,000 - - - - 46,000.00 0.00% Operating Equipment 80,676 2,498.76 57,427.41 18,761.22 547.98 61,366.85 23.93% Capital Outlay 470,652 2,546.80 199,126.25 29,741.80 358,754.52 82,156.09 82.54% TOTAL POLICE 7,081,567.49 674,777.35 1,810,728.87 1,697,457.87 366,749.23 5,017,360.39 29.15 %I FIRE RESCUE Personnel Services 3,541,745 389,190.67 840,580.16 939,367.73 - 2,602,377.27 26.52% Supplies 14,800 632.78 1,124.61 1,325.63 488.91 12,985.46 12.26% Utility Services 44,200 4,208.52 8,006.33 8,554.35 - 35,645.65 19.35% Operations Support 550 - 68.97 - - 550.00 0.00% Staff Support 138,150 14,934.08 23,242.88 37,931.13 22,641.98 77,576.89 43.85% City Assistance 18,700 130.32 95.34 1,281.94 - 17,418.06 6.86% Professional Services 15,200 - - - - 15,200.00 0.00% Maintenance Services 48,500 2,320.79 5,975.18 3,089.03 - 45,410.97 6.37% Rental /Leasing 16,890 1,316.94 4,063.19 4,063.19 11,852.46 974.35 94.23% Operating Equipment 81,825 1,718.98 15,631.57 20,174.46 7,541.93 54,108.61 33.87% Capital Outlay 44,500 - - 6,800.23 30,407.00 7,292.77 83.61% TOTAL FIRE RESCUE 3965,060> 414,453.08 898,78823 1,022,587.69 72,932.28 2,869,540.03 27.63 % CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2016 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET INSPECTIONS Personnel Services 541,414 63,654.75 114,038.34 145,593.13 - 395,820.87 26.89% Supplies 3,835 94.98 422.60 477.40 635.45 2,722.15 29.02% Utility Services 5,000 189.64 668.21 505.04 - 4,494.96 10.10% Operations Support 2,000 34.53 294.00 354.51 316.00 1,329.49 33.53% Staff Support 26,680 866.43 1,908.09 2,095.87 739.32 23,844.81 10.63% Professional Services 60,000 21,125.00 17,872.00 46,100.00 - 13,900.00 76.83% TOTAL INSPECTIONS 638,929> 85,965.33 135,203124 195,125.95 1,69037 442,112.28 30.80 % MARSHAL'S OFFICE Personnel Services 448,770 49,264.06 152,620.58 128,668.31 - 320,101.69 28.67% Supplies 3,350 89.46 622.03 102.43 1,007.16 2,240.41 33.12% Utility Services 10,000 376.80 1,157.33 896.57 - 9,103.43 8.97% Operations Support 1,000 - - - 177.00 823.00 17.70% Staff Support 12,540 150.00 1,053.42 567.01 107.19 11,865.80 5.38% City Assistance 1,250 - - - - 1,250.00 0.00% Maintenance Services 4,700 200.00 800.00 200.00 - 4,500.00 4.26% Operating Equipment 4,227 - 421.25 - - 4,227.00 0.00% Capital Outlay 18,000 14,503.05 62,950.00 14,503.05 - 3,496.95 80.57% TOTAL MARSHAL'S OFFICE 503,837! 64,58337 219,624.61 144,937.37 1,291.35 357,608.28 29.02 % TOTAL PUBLIC SAFETY 12,189,393.491! 1,239,779.13 3,064,344'.95 3,060,108.88 442,663.63 8,686,620.98 28.74 % CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2016 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET PUBLIC ENVIRONMENT 21,100 4,340.00 441.98 4,667.58 1,204.28 15,228.14 27.83% Utility Services 21,000 STREETS 2,238.64 2,957.71 - 18,042.29 14.08% Maintenance Services 675,878 591.47 - 591.47 Personnel Services 741,825 76,840.78 183,298.69 204,925.48 - 536,899.52 27.62% Supplies 95,650 1,310.39 1,592.34 6,698.86 4,160.86 84,790.28 11.35% Utility Services 149,200 13,274.80 24,804.87 26,256.66 255.00 122,688.34 17.77% Staff Support 9,950 914.52 2,605.32 1,860.31 251.45 7,838.24 21.22% Professional Services 31,950 - - - 66,667.00 (34,717.00) 208.66% Maintenance Services 42,000 9,061.43 15,004.41 11,215.36 4,945.11 25,839.53 38.48% Rental /Lease 2,000 - - 259.00 - 1,741.00 12.95% Operating Equipment 12,201 - - - - 12,201.00 0.00% Capital Outlay 142,631 - - - - 142,631.00 0.00% TOTAL STREETS 1,227,407 101,401.92 227,305163 251,215.67 76,279.42 899,911.91 26.68 %0 TOTAL PUBLIC ENVIRONMENT 1,227,407 101,401.92 227,305.63 251,215.67 76,279.42 899,911.91 26.68 % f PARKS & RECREATION 21,100 4,340.00 441.98 4,667.58 1,204.28 15,228.14 27.83% Utility Services 21,000 PARKS DEPARTMENT 2,238.64 2,957.71 - 18,042.29 14.08% Maintenance Services 675,878 591.47 - 591.47 Personnel Services 545,943 51,785.16 121,345.01 142,000.35 - 403,942.65 26.01% Supplies 34,955 1,455.07 4,584.70 4,692.99 1,707.04 28,554.97 18.31% City Support Services 6,500 2,102.00 989.00 3,426.35 535.33 2,538.32 60.95% Utility Services 171,200 22,414.83 28,832.29 43,290.39 46.13 127,863.48 25.31% Operations Support 700 551.40 - 551.40 - 148.60 78.77% Staff Support 7,625 1,421.65 1,126.03 2,580.92 297.66 4,746.42 37.75% Professional Services 82,500 5,352.87 21,483.71 10,810.82 3,691.50 67,997.68 17.58% Maintenance Services 26,000 - 3,344.23 2,822.80 5,426.11 17,751.09 31.73% Rental /Leasing 41,600 3,663.64 9,057.48 9,701.96 27,172.44 4,725.60 88.64% Operating Equipment 5,000 2,995.00 784.04 2,995.00 1,587.77 417.23 91.66% Capital Outlay 10,000 - - - - 10,000.00 0.00% TOTAL PARKS DEPARTMENT 932,023 ;91,741.62 191,546:49 222,872.98 40,46198 668,686.04 2$25 %a< SWIM POOL Supplies 21,100 4,340.00 441.98 4,667.58 1,204.28 15,228.14 27.83% Utility Services 21,000 1,262.46 2,238.64 2,957.71 - 18,042.29 14.08% Maintenance Services 675,878 591.47 - 591.47 754.50 674,532.03 0.20% TOTAL SWIM POOL ` 717,978s 6,193.93 2,680.62 8,216.76 1,958.78 707,80246 1.42 % ` CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2016 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET EVENT FACILITIES 677,981 78,034.29 174,087.26 178,730.91 - 499,250.09 26.36% Supplies 15,000 Personnel Services 59,006 6,591.63 373.56 12,740.98 31.01% 14,738.59 - 44,267.41 24.98% Supplies 15,000 50,919.91 - 1,487.32 3,150 765.66 64.05 14,170.29 5.53% Utility Services 51,750 3,976.91 6,615 8,047.26 1,597.32 7,964.95 - 43,785.05 15.39% Operations Support 11,500 - - 850.00 - - 905.00 10,595.00 7.87% Staff Support 2,180 301.00 3,672.87 550.00 29.47% 981.88 26.50 1,171.62 46.26% Operating Equipment 24,780 644,661.21 - - 868,161 (1,850.61) - 26,630.61 -7.47% TOTAL EVENT FACILITIES 164,216: 10,869.54 23,675.56 22,600.47 995.55 140,619.98 14.37 % ' SENIOR CITIZEN CENTER Supplies - - 1,846.93 - - - 0.00% City Assistence - - 13,381.96 - - - 0.00% Professional Services - - 936.27 - - - 0.00% Maintenance Services - - 138.50 - - - 0.00% TOTAL SENIOR CITIZEN CENTER - - 16,303.66 - - - 0.00 % + TOTAL PARKS &'RECREATION 1,814,217; 108,805.09 234,206.33 253,690.21 43,418.31 1,517,108.48 16.38 % l CULTURAL LIBRARY Personnel Services 677,981 78,034.29 174,087.26 178,730.91 - 499,250.09 26.36% Supplies 15,000 3,336.14 3,710.48 4,277.49 373.56 10,348.95 31.01% Utility Services 55,600 3,140.23 10,924.79 4,680.09 - 50,919.91 8.42% Operations Support 3,150 15.99 241.69 231.98 215.99 2,702.03 14.22% Staff Support 6,615 434.00 1,597.32 957.10 101.40 5,556.50 16.00% Professional Services 2,315 - 2,247.00 2,252.00 - 63.00 97.28% Operating Equipment 107,500 10,964.76 25,682.66 28,006.40 3,672.87 75,820.73 29.47% TOTAL LIBRARY 868,161- 95,925.41 218,491.20 219,135.97 4,363.82 644,661.21 25.74 % TOTAL CULTURAL 868,161 95,925.41 218,491.20 219,135.97 4,363.82 644,661.21 25.74 %' - CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2016 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET HEALTH ANIMAL SERVICES Personnel Services 320,519 34,302.08 73,282.47 81,864.62 - 238,654.38 25.54% Supplies 33,380 3,401.33 4,796.33 8,045.59 901.04 24,433.37 26.80% City Support Services 3,500 636.26 - 1,149.76 - 2,350.24 32.85% Utility Services 37,500 4,700.18 3,866.03 7,516.90 - 29,983.10 20.05% Operations Support 1,000 690.00 - 690.00 - 310.00 69.00% Staff Support 10,750 617.95 1,480.83 1,601.61 110.00 9,038.39 15.92% City Assistance 18,550 1,182.86 2,513.85 2,106.69 - 16,443.31 11.36% Professional Services 25,000 1,290.00 1,497.50 2,034.76 - 22,965.24 8.14% Maintenance Services 17,010 24,107.70 5,050.00 24,107.70 987.55 (8,085.25) 147.53% Operating Equipment 38,000 - 1,404.30 - 750.00 37,250.00 1.97% Capital Outlay 63,000 - - - 27,870.00 35,130.00 44.24% TOTAL ANIMAL SERVICES 568,209 70,928.36 93,891 +.31 129,117.63 30,618.59 408,472.78 28.11 % i ENVIRONMENTAL HEALTH Personnel Services 190,240 20,557.53 - 42,811.45 - 147,428.55 22.50% Supplies 3,505 68.70 - 68.70 - 3,436.30 1.96% Operations Support 1,800 - - 12.95 30.34 1,756.71 2.41% Staff Support 6,550 158.00 - 2,112.49 - 4,437.51 32.25% City Assistance 1,000 - - 201.47 - 798.53 20.15% Professional Services 500 - - - - 500.00 0.00% Maintenance Services 10,600 550.00 - 1,810.00 - 8,790.00 17.08% Operating Equipment 5,450 - - - - 5,450.00 0.00% TOTAL ANIMAL SERVICES 219,645' 21,334.23 - 47,017.06 30.34 172,597.60 21.42% TOTAL HEALTH 787,854 92,262.59 93,891 31 176,134.69 30,648.93 581,070.38 26.25 %< CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2016 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET INTERNAL SERVICE INFORMATION TECHNOLOGY Personnel Services 524,491 48,224.57 107,130.33 106,622.71 - 417,868.29 20.33% Supplies 7,000 103.72 163.53 919.42 109.13 5,971.45 14.69% City Support Services 534,866 30,462.75 78,855.81 78,867.99 42,770.26 413,227.75 22.74% Utility Services 227,646 16,115.53 39,746.22 47,992.21 371.58 179,282.21 21.25% Staff Support 34,100 5,079.09 6,261.50 6,487.49 (336.88) 27,949.39 18.04% Maintenance Services 17,580 189.45 3,324.45 1,322.40 82.40 16,175.20 7.99% Rental /Leasing 38,047 3,170.49 12,681.96 12,681.96 3,170.49 22,194.55 Operating Equipment 211,419 12,578.00 26,271.99 48,877.19 55,762.46 106,779.35 49.49% Capital Outlay 13,000 - - - - 13,000.00 0.00% TOTAL INFORMATION TECHNOLOGY 1,608,149? 115,923.60 274,435`39 303,771.37 101,929.44 1,202,448.19 25.23 % ' HUMAN RESOURCES Personnel Services 350,331 32,711.01 55,415.55 82,211.99 - 268,119.01 23.47% Supplies 1,000 - - 28.55 - 971.45 2.86% Human Services 74,500 3,963.01 13,184.91 10,457.33 769.50 63,273.17 15.07% Operations Support 10,000 368.00 2,667.91 1,367.00 310.60 8,322.40 16.78% Staff Support 14,100 460.00 1,762.66 1,497.21 - 12,602.79 10.62% City Assistance 10,000 - 4,798.00 708.00 408.00 8,884.00 11.16% Professional Services 9,600 - 2,259.25 1,489.50 - 8,110.50 15.52% Operating Equipment 1,000 - - - - 1,000.00 0.00% TOTAL HUMAN RESOURCES 470,531 37,502.02 80,088.28 97,759.58 1,488.10 371,283.32 21.09% FINANCE Personnel Services 586,957 67,385.88 129,630.82 163,499.22 - 423,457.78 27.86% Supplies 4,550 1,118.37 685.89 1,830.93 - 2,719.07 40.24% Operations Support 2,000 (3.01) - 55.97 1,824.69 119.34 94.03% Staff Support 8,525 105.00 1,672.50 865.00 - 7,660.00 10.15% Operating Equipment - - - 59.99 - (59.99) 0.00% TOTAL FINANCE 602,032 68,606.24 131,989.21 166,311.11 1,824.69 433,896.20 27.93 %6 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2016 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET PURCHASING & ASSET MGT Personnel Services 190,620 12,579.30 44,468.73 26,506.71 - 164,113.29 13.91% Supplies 1,050 52.71 51.33 52.71 52.11 945.18 9.98% Utility Services 250 16.10 - 16.10 - 233.90 6.44% Operations Support 100 6.47 - (9.63) - 109.63 -9.63% Staff Support 6,600 30.00 817.63 30.00 - 6,570.00 0.45% City Assistance 3,000 66.00 1,113.80 171.00 - 2,829.00 5.70% TOTAL PURCHASING & ASSET MGT 201,620? 12,750.58 46,451.49 26,766.89 52.11 174,801.00 13.30% FLEET SERVICE Personnel Services 347,327 37,990.84 77,815.14 87,247.01 - 260,079.99 25.12% Supplies 187,200 12,901.09 26,810.56 37,063.17 8,495.83 141,641.00 24.34% City Support Services 6,150 96.95 2,244.72 2,354.40 - 3,795.60 38.28% Utility Services 6,200 936.80 837.95 1,677.17 - 4,522.83 27.05% Operations Support 200 - - - - 200.00 0.00% Staff Support 10,900 1,215.99 1,160.43 1,552.19 103.08 9,244.73 15.19% Maintenance Services 90,750 36,363.03 46,105.01 53,869.08 8,937.99 27,942.93 69.21% Operating Equipment 8,200 - 3,077.99 - - 8,200.00 0.00% Capital Outlay 89,000 - - - - 89,000.00 0.00% TOTAL FLEET SERVICE 745,927 89,504.70 158,051.80 183,76102 17,536.90 544,627.08 26.99% BUILDING MAINTENANCE Personnel Services 781,125 79,478.61 35,765.87 192,389.48 5,340.17 583,395.35 25.31% Supplies 68,550 8,741.01 159.55 20,664.73 7,822.12 40,063.15 41.56% Utility Services 189,515 12,837.56 446.81 23,308.92 - 166,206.08 12.30% Staff Support 14,194 1,783.91 1,019.76 4,993.95 805.12 8,394.93 40.86% Professional Services 48,000 - 20,393.74 - - 48,000.00 0.00% Maintenance Services 161,512 30,330.97 5,491.50 73,616.92 21,041.37 66,853.71 58.61% Rental /Leasing 2,250 2,060.69 978.02 2,060.69 - 189.31 91.59% Operating Equipment 2,700 - - - - 2,700.00 0.00% Capital Outlay 33,250 - - - - 33,250.00 0.00% TOTAL BUILDING MAINTENANCE 1,301,0961 1135,232,75 64,255:25 317,034.69 35,00818 949,052.53 27.06% TOTAL INTERNAL SERVICE 4,929,355 459,519.89 755,271.82 1, 095, 406.66 157,840.02 3,676,108.32 25.42% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2016 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET MISC & PROJECTS CITY ASSISTANCE City's Assistance to Agencies 245,260 19,839.49 5,000.00 54,153.89 12,312.80 178,793.31 27.10% TOTAL CITY' ASSISTANCE 245,260< 19,839.49 5,000.00 54,153.89 12,312.80 178,793.31 2710 %' COURT - RESTRICTED FUNDS Operating Equipment 19,448 - 3,924.25 - 1,840.00 17,608.00 9.46% TOTAL CITY ASSISTANCE 19,448 - 3,924.25 - 1,840.00 17,608.00 9.46 %% TOTAL MISC & PROJECTS 264,708 19,839.49 8,924.25 54,153.89 14,152.80 196,401.31 25.80 %S TOTAL EXPENDITURES ? 29,593,043.69 2,515,052.10 5,803,381.42 6,307,614.17 1,281,945.47 22,003,484.05 25.65% REVENUE'OVER(UNDER) EXPEND. 8,151' 4,389,705.06 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2016 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6- 2 0 1 7********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Taxes 000-411100 Advalorem Tax - Current 11,203,881 5,447,188.51 5,418,005.65 6,195,642.10 - 5,008,238.90 55.30% 000 - 411200 Advalorem Tax - Delinquent 40,000 5,597.40 2,323.37 (26,431.35) - 66,431.35 - 66.08% 000 - 411300 Advalorem Tax - P &I 45,000 3,715.90 1,969.63 6,525.81 - 38,474.19 14.50% 000 - 411500 Sales Tax Revenue -Gen Fund 7,385,419 750,924.74 1,816,171.33 1,898,834.48 - 5,486,584.52 25.71% 000 - 411600 Bingo Tax 100 - - - - 100.00 0.00% 000 - 411700 Mixed Beverage Tax 46,000.00 - 11,390.12 12,270.08 - 33,729.92 26.67% TOTAL Taxes 18,720,400 6,207,426.55 7,249,860.10 8,086,841.12 - 10,633,558.88 43.20% Franchises 000 - 421200 Center Point/Entex Energy 74,000 4,823.64 14,424.08 14,470.92 - 59,529.08 19.56% 000 - 421220 City Public Service 873,600 62,926.39 151,354.89 210,168.32 - 663,431.68 24.06% 000 - 421240 Guadalupe Valley Elec Co -op 513,000 33,042.60 106,598.87 99,127.80 - 413,872.20 19.32% 000 - 421250 New Braunfels Utilities 70,000 5,422.18 15,220.23 16,866.96 - 53,133.04 24.10% 000 - 421300 Time Warner -State Franchise 238,000 22,123.66 63,431.78 67,789.44 - 170,210.56 28.48% 000 - 421460 AT &T Franchise Fee 300,000 15,572.60 68,000.71 46,717.80 - 253,282.20 15.57% 000 - 421480 Other Telecom Franchise 100,000 9,181.09 24,380.56 27,543.27 - 72,456.73 27.54% 000 - 421500 Solid Waste Franchise Fee 138,000 11,919.40 32,066.28 35,813.44 - 102,186.56 25.95% TOTAL Franchises 2,306,600 165,011.56 475,477.40 518,497.95 - 1,788,102:05 22.48 %!' Permits 000 - 431100 Home Occupation Permit 500 225.00 385.00 260.00 - 240.00 52.00% 000 - 431205 Building Permit - Residential 483,000 30,792.00 117,859.00 109,959.00 - 373,041.00 22.77% 000 - 431210 Building Permit - Commercial 170,000 - 50,506.00 255,907.00 - (85,907.00) 150.53% 000 - 431215 Building Permit - General 120,000 8,151.00 28,097.00 31,515.00 - 88,485.00 26.26% 000 - 431300 Mobile Home Permit 300 - 125.00 50.00 - 250.00 16.67% 000 - 431400 Signs Permit 7,000 182.00 1,268.00 798.00 - 6,202.00 11.40% 000 - 431500 Food Establishmnt Permit 60,000 100.00 51,500.00 48,435.00 - 11,565.00 80.73% 000 - 431600 Garage Sale Permit 10,500 110.00 2,935.00 2,158.00 - 8,342.00 20.55% 000 - 431700 Plumbing Permit 117,000 7,736.00 28,096.00 25,159.00 - 91,841.00 21.50% 000 - 431750 Electrical Permit 58,800 3,460.00 14,940.00 13,260.00 - 45,540.00 22.55% 000 - 431800 Mechanical Permit 59,520 3,400.00 12,500.00 12,960.00 - 46,560.00 21.77% 000 - 431900 Solicitor /Peddler Permit 1,500 - 60.00 - - 1,500.00 0.00% 000 - 431950 Animal /Pet Permit 1,500 15.00 - 15.00 - 1,485.00 1.00% 000 - 432000 Cert. of Occupancy Prmt 7,000 550.00 2,100.00 1,000.00 - 6,000.00 14.29% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2016 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6- 2 0 1 7********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET 000 - 432100 Security Alarm Permit 35,000 3,775.00 8,056.00 9,800.00 - 25,200.00 28.00% 000 - 432300 Grading /Clearing Permit 4,000 1,000.00 1,718.51 2,414.00 - 1,586.00 60.35% 000 - 432400 Development Permit 81,880 - - - 000- 435000 Fire Permit 15,000 1,735.00 2,371.00 4,615.00 - 10,385.00 30.77% TOTAL Permits 1,232,500 61,231.00 322,516.51 518,305.00 - 632,315.00 42.05% Licenses 000 - 441000 Alcohol Beverage License 8,000 1,612.50 3,147.50 2,995.00 - 5,005.00 37.44% 000 - 441300 Mobile Home License 160 120.00 120.00 120.00 - 40.00 75.00% 000 - 442000 Contractors License 40,000 5,150.00 8,260.00 11,450.00 - 28,550.00 28.63% 000 - 444000 Pet License 3,000 170.00 697.00 600.00 - 2,400.00 20.00% TOTAL Licenses 51,160 7,052.50 12,224.50 15,165:00 - 35,995.00 29.64% Fees 000 - 451000 Municipal Court Fines 884,000 48,849.90 234,900.90 171,542.82 - 712,457.18 19.41% 000 - 451100 Arrest Fee 28,053 1,931.51 8,632.39 6,498.02 - 21,554.98 23.16% 000 - 451110 Expunction Fee 60 60.00 30.00 60.00 - - 100.00% 000 - 451200 Warrant Fees 130,000 6,092.90 27,306.95 21,548.86 - 108,451.14 16.58% 000 - 451210 Court - Claims & Judgements - - (219.00) (291.40) - 291.40 0.00% 000 - 451340 Judicial Fee - City 3,796 262.31 1,173.18 882.27 - 2,913.73 23.24% 000 - 451400 Traffic Fine Costs TTL 13,492 967.67 4,241.67 3,231.24 - 10,260.76 23.95% 000 - 451510 Juvenile Case Mgmt Fee 31,616 2,186.04 9,761.21 7,357.40 - 24,258.60 23.27% 000 - 451520 Truancy Fee 5,342 406.35 1,777.93 1,347.36 3,994.64 25.22% 000 - 451600 Technology Fund Fee 22,932 1,731.51 7,857.66 5,911.20 - 17,020.80 25.78% 000 - 451700 Security Fee 19,448 1,298.64 5,893.24 4,433.40 - 15,014.60 22.80% 000 - 451800 Time Payment Fee - City 5,616 441.98 1,403.66 1,600.69 - 4,015.31 28.50% 000 - 451850 State Fines 10% Service Fee 40,838 - 13,270.02 10,245.75 - 30,592.25 25.09% 000 - 451900 DPS Payment - Local 47,665 457.33 2,091.61 1,635.21 - 46,029.79 3.43% 000 - 452000 Child Safety Fee 13,522 283.15 4,808.02 790.21 - 12,731.79 5.84% 000 - 452100 Platting Fees 57,000 8,500.00 10,500.00 22,500.00 - 34,500.00 39.47% 000 - 452200 Site Plan Fee 30,000 500.00 7,000.00 6,000.00 - 24,000.00 20.00% 000 - 452300 Plan Check Fee 432,000 19,451.50 97,068.00 197,971.00 - 234,029.00 45.83% 000 - 452310 Miscellaneous Review Fee 600 - 300.00 - - 600.00 0.00% 000 - 452320 Tree Mitigation Admin Fee 12,000 - 6,645.00 9,441.60 - 2,558.40 78.68% 000 - 452400 BOA/Zoning Fees 2,000 - 500.00 - - 2,000.00 0.00% 000 - 452500 Food Handler Class - - - - - - 0.00% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2016 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6- 2 0 1 7********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET 000 - 452520 Fire Training Classes - - - - - - 0.00% 000 - 452600 Specific Use /Zone Chng Fee 12,600 6,000.00 2,300.00 13,000.00 - (400.00) 103.17% 000 - 452710 Zoning Ltr & Dev Rights 1,500 300.00 750.00 600.00 - 900.00 40.00% 000 - 453100 Reinspection Fees 45,000 11,875.00 17,125.00 28,000.00 - 17,000.00 62.22% 000 - 453110 Swim Pool Inspection Fee 2,600 - - - - 2,600.00 0.00% 000 - 453200 Lot Abatement 5,000 1,325.50 - 1,325.50 - 3,674.50 26.51% 000 - 453211 Admin Fee - Inspections 6,600 800.00 2,600.00 3,800.00 - 2,800.00 57.58% 000 - 453310 Misc Inspection Fee 150 - 100.00 - - 150.00 0.00% 000 - 453710 Foster Care 1,000 - 300.00 150.00 - 850.00 15.00% 000 - 454200 Pool Gate Admission Fee 24,750 - - - - 24,750.00 0.00% 000 - 454300 Seasonal Pool Pass Fee 4,900 - - - - 4,900.00 0.00% 000 - 456110 Senior Center Memberships - - 2,638.00 - - - 0.00% 000 - 456120 Senior Center Meal Fee - - 401.00 401.00 - (401.00) 0.00% 000 - 456500 Haz Mat Fees 6,000 - 1,202.50 - - 6,000.00 0.00% 000 - 456600 Fire Re- inspection Fee 1,000 - 300.00 150.00 - 850.00 15.00% 000 - 458110 Sale of Merchandise- GovDeal 20,000 492.41 13,152.06 2,328.15 - 17,671.85 11.64% 000 - 458300 Sale of Property /Auction 4,000 - 2,194.00 - - 4,000.00 0.00% 000 - 458400 Civic Center Rental Fees 175,000 10,716.25 34,706.00 38,229.00 - 136,771.00 21.85% 000 - 458401 Capital Recovery Fee -Civic Cntr 10,000 700.00 1,800.00 2,885.00 - 7,115.00 28.85% 000 - 458450 North Center Rental Fees 18,500 1,325.00 4,850.00 4,800.00 - 13,700.00 25.95% 000 - 458460 Senior Center Rental - - 5,150.00 4,600.00 - (4,600.00) 0.00% 000 - 458500 Community Center Rental Fees 25,000 3,169.00 11,490.00 5,928.00 - 19,072.00 23.71% 000 - 458550 Pavilion Rental Fees 17,000 165.00 2,038.50 1,885.00 - 15,115.00 11.09% 000 - 458560 Chamber of Comm rent 7,800 - 1,950.00 - - 7,800.00 0.00% 000 - 458570 Non - Resident SYSA League - - - - - - 0.00% 000 - 458650 NonResident User Fee -BVYA 15,000 - 10,000.00 - - 15,000.00 0.00% 000 - 458660 BVYA Utility Reimbursement 13,000 9,242.22 5,000.82 9,242.22 - 3,757.78 71.09% 000 - 458670 SYSA Utility Reimbursement 7,000 - - - - 7,000.00 0.00% 000 - 458675 Lions Futbol Utility Reimbursement 14,052 1,172.00 1,172.00 3,516.00 - 10,536.00 25.02% 000 - 458700 Vehicle Impoundment 8,000 - - 2,070.00 - 5,930.00 25.88% 000 - 459200 NSF Check Fee 250 - 25.00 - - 250.00 0.00% 000 - 459300 Notary Fee 250 18.00 48.00 66.00 - 184.00 26.40% 000 - 459400 Maps, Copies, UDC, & Misc F 250 - 25.00 - - 250.00 0.00% 000 - 459600 Animal Adoption Fee 10,000 1,225.00 3,075.00 4,746.50 - 5,253.50 47.47% 000 - 459700 Pet Impoundment Fee 10,000 835.00 3,341.00 1,664.00 - 8,336.00 16.64% 000 - 459800 Police Reports Fee 5,400 568.00 1,230.80 1,609.00 - 3,791.00 29.80% TOTAL Fees 2,251,582 143,349.17- 573,907.12 603,701.00 - 1,647,881.00 26.81% CITY O F S C H E R T Z REVENUE REPORT (UNAUDnED) AG OF: DECEMBER 31a\201O 2V1V-2V17 101GENERALqJmo CURRENT CURRENT PRIOR YEAR v-T-D v-T-D BUDGET 25% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Fines 000403000 Library Fines 28,000 150223 594524 519042 2280958 18J54%� TOTAL Fines ������ ����82qz00D 1,502.23 4 5,1 - 22,809.58 000473100 BnxarCo - Fim 21.077 - 0.501.01 15.008.32 - 5.200.08 75.00% 000473200 CitynfGoguin - FimConUnrt 29.231 2.435.90 7.307J0 7.30770 - 21.923.30 25.00% 000473300 GuodCn'Library 212.000 30.192.00 35.825.00 72.384.00 - 139.610.00 3414% 000473400 Randolph AFB-Animal Cntd 1.200 - - - - 1.200.00 0.00% 000474200 Libna,yGorviuos - Qbn|o 35.000 - 35.000.00 - - 35.000.00 0.00% 000474210 Library Services-Selma 32.000 - - - - 32.000.00 0.00% 000474400 DispatchGomioo - Cibo|o 100.000 40.000.00 40.000.00 40.000.00 - 126.000.00 24.10% 000474000 School Crossing Guand'Baxar 38.500 2.743.37 5.889.23 8.805.67 - 28.534.33 2329% 000474010 School Cross Guard-Guadalupe 38.000 2.597.28 8.037.94 8.01435 29.385.05 22.67% 000474620 School Crossing Guand-Como| 1.500 - - - - 1.500.00 0.00% 000474700 School Officer Funding 255.000 - 42.500.00 03.750.00 - 191.250.00 25.00Y6 000-474750 Crime Victim Liaison Agreement --_-50V000� -------_--_ ----12�00.00 ---_12,500.00 -----_--- ---_37,500.00 25.00% TOTAL Inter-Jurisdictional O 83 S330. - | 050,177,96 26.07% � Fund Transfers 000480000 |ndivectCoots - EMS 150.087 12.507.25 37.576.89 37.52175 - 112.50525 25.00'& 000480100 |ndimotCnnm- HmeNNote| 06^405 5,533.75 10.00125 - 49.80375 25.00Y6 000481000 Transfer |nReserves 950.008 - - - - 950.000.00 0.00'& 000482200 TrunnfopVohio|oRop|n*mt 43^278 - - - - 43.278D0 0.00Y6 000482300 Transfer |N-Renry Child Saf 120.345 - ' - - 120.345.00 0.00'& 000485000 |noadundChangn-Dminago 184.425 15.308J5 13.537.50 40.10025 - 138.31075 25.0096 000486000 |noedundChrgno`AdminVY&G 1.100.812 98.901.00 200.007.47 290.703.00 - 890.108.00 25.00Y6 000487000 |noodundChangnn'F|eet 397.581 33,131.79 51.74128 99.38525 - 298.105J5 25.0096 000488000 |noadundChungou4B 430.445 35.070.48 12.505.97 107.01122 - 322.83370 25.00Y6 000408000 Tranofor|n __107,367 ______-_ ______-_ -_ _____-_ __107,367.00 0.00% TOTAL Fund Transfers 3,642,745 201,313.00 403,449.11 603,938.72 - 3,038,806.28 16.58% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2016 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6- 2 0 1 7********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Miscellaneous 000 - 491000 Interest Earned 800 93.38 131.95 184.28 - 615.72 23.04% 000 - 491200 Investment Income 60,000 8,165.75 12,197.41 22,841.43 - 37,158.57 38.07% 000 - 491800 Gain /Loss - (3,292.98) (20,768.72) (5,416.78) - 5,416.78 0.00% 000 - 491900 Unrealized Gain /Loss - 1,550.75 5,496.61 (9,491.91) - 9,491.91 0.00% 000 - 493120 Donations - Public Library 2,500 26.55 114.75 46.15 - 2,453.85 1.85% 000 - 493130 Donations - Writing the Next Chap. - - - - - - 0.00% 000 - 493400 Donation - Animal Control 10,000 2,237.00 50.00 3,220.50 - 6,779.50 32.21% 000 - 493401 Donations -A/C Microchip 5,000 - 290.00 130.00 - 4,870.00 2.60% 000 - 493402 Donations - Spay &Neuter 15,000 - 3,248.25 643.50 14,356.50 4.29% 000 - 493403 Donations - Animal Adoption Trailer - 102.00 1,525.00 102.00 - (102.00) 0.00% 000 - 493404 Donations -TNR Program 1,000 - - - - 1,000.00 0.00% 000 - 493460 Donations -Parks 4,000 - - - - 4,000.00 0.00% 000 - 493465 Donations - Senior Center - 855.45 2,145.85 2,289.13 - (2,289.13) 0.00% 000 - 493502 Donations -PD - - - 3,500.00 - (3,500.00) 0.00% 000 - 493618 Donations - Veteran's Memorial 6,000 - 450.00 - - 6,000.00 0.00% 000 - 494481 LawEnforcemtOfficersStnd &Ed 3,900 - - - 3,900.00 0.00% 000 - 494482 Grants - Police, Fire, Gen Fund - - - 4,892.03 - (4,892.03) 0.00% 000 - 497000 Misc Income -Gen Fund 40,000 10,406.62 23,914.63 10,044.74 - 29,955.26 25.11% 000 - 497005 Schertz Magazine Advertising 190,000 18,875.00 52,425.00 52,925.00 - 137,075.00 27.86% 000 - 497100 Misc Income - Police 7,500 4,055.57 1,765.51 7,317.40 - 182.60 97.57% 000 - 497150 Misc Income -Fire Department - - - 1,750.00 - (1,750.00) 0.00% 000 - 497200 Misc Income - Library 5,000 356.75 1,215.55 1,037.75 - 3,962.25 20.76% 000 - 497210 Misc Income - Library Copier 19,500 1,445.75 5,154.05 4,270.00 - 15,230.00 21.90% 000 - 497300 Misc Income - Animal Control - 75.00 30.00 180.00 - (180.00) 0.00% 000 - 497400 Misc Income - Streets Dept. 30,000 1,425.00 3,178.90 6,141.70 - 23,858.30 20.47% 000 - 497500 Misc Income -TML Insurance 5,000 - - 367.46 - 4,632.54 7.35% 000 - 497550 Misc Income -TML Reimbursemt 20,000 388.50 1,081.40 1,748.26 - 18,251.74 8.74% 000 - 497600 Misc Income - Vending Mach. 2,500 157.01 644.39 496.68 - 2,003.32 19.87% 000 - 498000 Reimbursmnt -Gen Fund 35,000 335.50 9,122.68 335.50 - 34,664.50 0.96% 000 - 498100 Reimbursmnt Fire - Training 3,500 - 3,735.00 - - 3,500.00 0.00% 000 - 498105 Reimburmnt Police - DEA - - 2,185.23 2,121.89 - (2,121.89) 0.00% 000 - 498107 Reimburmnt Police - Event - - 3,500.00 - - 0.00% 000 - 498110 Reimbursmnt Fire - Emg. Acti -O 20,000 - 26,257.28 - 20,000.00 0.00% 000 - 498150 Reimbursemnt - Library 2,500 - - 4,673.27 - (2,173.27) 186.93% TOTAL Miscellaneous 488,700 47,258.60 139,090.72 116,349.98 - 372,350.02 23.81% TOTALREVENUES 29,601,195 '' 6,918',119.16? 9,378,133.04 10,697,319.23 18,821,995.77 36.14% GENERALFUND CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2016 Cash in Bank Claim on Operating Cash Pool- Checking $ 1,417,766.76 Cash in Investments LOGIC Investment - General Fund 10,649,535.32 LOGIC Investment -Equip Replacement 74,225.93 LOGIC Investment -Veh Replacement 500,488.40 LOGIC Investment -Air Condi Replacment 272,369.76 CAPITAL ONE Investment - General Fund 1,372,162.01 Total Cash in Bank & Investments $14,433,130.02 1 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL L_AUG SEP 2016-171 419,931 328,521 5,447,189 2015-16 1 2014-151 360,300 -- 357,436 ----3-03-,202 356,940 4,754,503 ------ 4,463,962 ------ 3,709,486 2,741,991 888,174 1,198,153 211,253 -------- 85,775 ---------- 50,559 ---------- 44,720 ----------- 54,867 25,398 27,116 30,488 21,347 --------- 49,777 ----------- 10,866------8,696- 14,839 3,787 @2013-14 363,589 538,568 3,641,091 2,726,044 585,058 72,116 16,554 48,791 18,572 20,939 10,460 7,446 W2012-131 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 --- ---- ---------------------------------------------- ---------------------- ---------------------- $800,000 Yco - - - ------ $700,000 000 199 9.5% $600,000 $500,000 $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 ---------------- -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 --o-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 me-2013-1 4 481,247 657,271 554,578 416,261 487-,933---- 541,476 781,057 692,4464481577 680,332 547,431 - - 2012-13 ----------------- 659,150 575,041 474,246 424,191 -----728,443 - ---------------- 632,716 415,829 405,378 - ----------------- 660,648 544,675 563,636 650,124 ---------- 487,170 $300,000 $2 $2 $1 $1 CITY PUBLIC SERVICE 50,000 00,000 50,000 00,000 M 50,000 OCT NOV D EC JAN FEB MAR APR MAY JUN JULl AUG ---- - -- ------------- vy 7 2016-1 -- - --- -------------- - ------- -------------- 252,947 ------------- -------------- - - -------- ---------- - -------- ------------- ------------- __ -- ------------- - -- - ---------- ----------- ... ........ - - -------- - ___SEP ----------- ------------ W2015-16 - - - - -------------------------------------- 237,314 -- - --- - - 183,530 - - - - - 173,336 - -- - - - - - - -------------------------------------- 178,081 -------------------------------------- -- - - - - - ------ --- 02014-15 215,257 172,814 172,628 227,438 E32013-14 ---------------------------------------- --- - - - - - 133,486 -----------l-15,592------176-,5-20 - - - - -- ---------------------------------------------------------------------------- 213,412 M2012-13 101,440 94,054 96,303 123,044 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2016 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 106 - SPECIAL EVENTS FUND CURRENT CURRENT PRIOR CURRENT Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fund Transfers 81,450.00 - - - - 81,450.00 0.00% Miscellaneous 48,900.00 512.69 17,340.59 27,386.10 - 21,513.90 56.00% TOTAL REVENUES 130,350.00 512.69 17,340.59 27,386.10 - 102,963.90 12.14% EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental 10,750.00 - - - - 10,750.00 0.00% TOTAL GENERAL GOVERNMENT 10,750.00 - - - - 10,750.00 0.00% CULTURAL Festival of Angels 13,000.00 213.90 5,873.36 10,327.90 585.00 2,087.10 83.95% Employee Appreciation Event 13,000.00 5,803.30 - 7,739.80 - 5,260.20 59.54% National Night Out 300.00 - - - - 300.00 0.00% Wilenchik Walk for Life 25,000.00 - - - - 25,000.00 0.00% Schertz Sweetheart 34,250.00 30.00 307.46 30.00 83.70 34,136.30 0.33% Hal Baldwin Scholarship 20,050.00 283.75 8,662.75 9,047.17 - 11,002.83 45.12% Other Events 14,000.00 129.00 1,253.77 6,017.01 470.00 7,512.99 46.34% TOTAL CULTURAL!' 119,600.00 6,459.95 16,097.34 33,161 88 1,138.70 85,299.42 28.68 %' TOTAL EXPENDITURES 130,350.00 6,459.95 16,097.34` 33,161.88 1,138.70 96,049.42 26.31% REVENUE OVER(UNDER) EXPEND - (5,947.26) 1;243.25' (5,775:78} (1,138.70} 6,914.48 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2016 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 106 - SPECIAL EVENTS FUND CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Fund Transfers 000 - 481000 Transfer from Reserves 10,750 - - - - 10,750.00 0.00% 000 - 481314 Transfer from Hotel /Motel - - - - - - 0.00% 000 - 486100 Transfer In 9,000 - - - - 9,000.00 0.00% 000 - 486101 Transfer In - General Fund 61,700 - - - - 61,700.00 0.00% TOTAL Fund Transfers 81,450' - - - - 81,450.00 0.00% Miscellaneous 000 - 491200 Investment Income - 12.69 10.59 36.10 - (36.10) 0.00% 000 - 492200 Wilenchik Walk for Life 25,000 - - - - 25,000.00 0.00% 000 - 493256 Donations - Police Events 3,000 - - - - 3,000.00 0.00% 000 - 493455 Proceeds - Festival of Angels - 300.00 720.00 585.00 - (585.00) 0.00% 000 - 493460 Schertz Sweetheart 850 - - - - 850.00 0.00% 000 - 493621 Hal Baldwin Scholarship 20,050 200.00 16,360.00 25,765.00 - (5,715.00) 128.50% 000 - 497000 Misc Income - - 250.00 1,000.00 - (1,000.00) 0.00% TOTAL Miscellaneous 48,900 512.69 17,340.59 27,386.10 -' 21,513.90 56.00 %1 TOTAL REVENUES 130,350 512.69 17,340.59 27,386.10 - 102,963.90 21.01 %' SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31, 2016 Cash in Bank Claim on Operating Cash Pool-Checking $ 47,088.41 Cash in Investments Texas Class- Special Events 16,836.33 Total Cash in Bank & Investments $ 63,924.74 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2016 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 110 -PEG FUND CURRENT CURRENT PRIOR CURRENT Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 113,300.00 - 24,804.30 22,93336 - 90,366.64 20.24% TOTAL:.REVENUES 113,300.00 - 24,804.30 22,933.36 90,366.64 20.24 %' EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental - - - - 2,762.70 (2,762.70} 0.00% TOTAL GENERAL GOVERNMENT - - - - 2,762.70 (21762.70} 0.00 %> MISC & PROJECTS Projects 108,600.00 - - 449.00 449.00 107,702.00 0.83% TOTAL <MISC & PROJECTS 108,600,00 - - 449.00 449.00 107,702.00 0.83% TOTAL EXPENDITURES 108,600.00 - - 449.00 3,211.70 104,939.30 137% REVENUE OVER(UNDER) EXPEND 4,700.00 - 24,804.30 22,484'.36 (3,211.70) (14,572.66 }; CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2016 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 110 -PEG FUND CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Franchises 000 - 421350 Time Warner - PEG Fee 50,000 - 24,80430 13,060.68 - 36,939.32 26.12% 000 - 421465 AT &T PEG Fee 63,300 - - 9,872.68 - 53,427.32 15.60% TOTAL Franchises 113,300' - 24,804.30 22,933.36 - 90,366.64 20.24 %' TOTAL REVENUES 113,300' - 24,804.30 22,933.36 90,366:64 20.24 %' PEG FUND CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2016 Cash in Bank Cash Balance $ 577,141.40 Total Cash in Bank & Investments $ 577,141.40 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2016 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6- 2 0 1 7 * * * * * * * * * * * * * * * * * * * * * * * * * ** 202 -WATER & SEWER CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 229,096 - 2,500.00 - - 229,096.00 0.00% Permits - 1,844.29 45,625.33 46,445.05 - (46,445.05) 0.00% Fees 19,219,995 1,798,711.40 4,573,318.34 5,310,416 - 13,909,579.38 27.63% Fund Transfers 981,920 11,410.00 32,490.00 34,230 - 947,690.00 3.49% Miscellaneous 163,047 314,021.63 7,119.39 327,223 - (164,175.70) 200.69% TOTAL REVENUES 20,594,058 2,125,987.32 4,661,053.06; 5,718,313.37 - 14,875,744.63 27.77% BUSINESS OFFICE Personnel Services 472,754 52,314.95 121,874.24 129,259.61 - 343,494.39 27.34% Supplies 4,300 - 1,077.97 - 25.00 4,275.00 0.58% City Support Services 7,375 - - - - 7,375.00 0.00% Utility Services 700 35.83 90.75 93.41 - 606.59 13.34% Operations Support 140,500 16,983.69 29,259.62 21,344.63 - 119,155.37 15.19% Staff Support 6,800 632.76 123.20 704.52 402.22 5,693.26 16.28% Professional Services 85,000 7,646.95 18,478.20 23,995.63 - 61,004.37 28.23% Maintenance Services 8,000 1,920.00 740.00 2,760.00 3,880.00 1,360.00 83.00% Operating Equipment 600 - - - 3,400.40 (2,800.40) 566.73% TOTAL BUSINESS OFFICE 726,029 79,534.18 171,643.98 178,157.80 7,707.62 540,163.58 25.60% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2016 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6- 2 0 1 7 * * * * * * * * * * * * * * * * * * * * * * * * * ** 202 -WATER & SEWER CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET W & S ADMINISTRATION Personnel Services 1,161,362 96,538.09 332,328.94 240,773.76 - - - - 85,000.00 920,588.24 20.73% Supplies 157,500 7,301.76 71,683.16 33,323.09 8,382.51 115,794.40 26.48% Human Services - 266.00 - 266.00 - TOTAL SEWER PROJECTS- (266.00) 0.00% City Support Services 184,000 76.26 38,500.16 42,702.31 679.00 20,574,656 1,484,116.21 140,618.69 23.58% Utility Services 3,504,060 195,146.73 765,592.20 675,320.96 269.62 2,828,469.42 19.28% Operations Support 11,500 1,300.59 1,187.97 1,317.02 - 10,182.98 11.45% Staff Support 27,350 1,204.05 6,841.50 2,396.13 350.82 24,603.05 10.04% City Assistance 1,500 102.00 243.00 102.00 102.00 1,296.00 13.60% Professional Services 169,729 18,456.50 6,692.60 22,296.50 1,575.40 145,857.10 14.06% Fund Charges /Transfers 4,467,025 377,212.52 1,440,371.44 1,651,288.33 - 2,815,736.67 36.97% Maintenance Services 7,558,090 670,372.08 1,373,188.94 1,487,874.07 4,867.42 6,065,348.51 19.75% Other Costs 35,000 36,605.45 27,150.20 36,605.45 - (1,605.45) 104.59% Debt Service 1,578,511 - - - 446,081.25 1,132,429.75 28.26% Rental- Leasing 144,500 - - 497.68 - 144,002.32 0.34% Operating Equipment 3,500 - - - 399.98 3,100.02 11.43% Capital Outlay - - 32,904.13 - - - 0.00% TOTAL PUBLIC WORKS 19,003,627 1,404,582.03 4,096,684.24 4,194,763.30 462,708.00 14,346,155.70 24.51% 8I6Y01? 1=00111xia PROJECTS Maintenance Services 85,000 - - - - 85,000.00 0.00% TOTAL PROJECTS 85,000 - - - - 85,000.00 0.00% SEWER PROJECT Professional Services 360,000 - - - - 360,000.00 0.00% Maintenance Services 400,000 - - - - 400,000.00 0.00% TOTAL SEWER PROJECTS- 760,000 - - - - 760,000.00 0.00% TOTAL MISC & PROJECTS 845,000 - - 845,000 0.00% TOTAL EXPENDITURES 20,574,656 1,484,116.21 4,268,328.22 4,372,921.10 470,415.62 15,731,319.28 23.54 %' ** REVENUE OVER(UNDER)EXPENSES ** 19,402 641,871.11 392,724.84 1,345,392.27 (470,415:62) (855,574.65)' 202 -WATER & SEWER REVENUES CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2016 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6- 2 0 1 7********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Franchises 000 - 421490 Tower Leasing 229,096 - 2,500.00 - - 229,096.00 0.00% TOTAL Franchises 229,096 - 2,500.00 - - 229,096.00 0.00% Permits 000 - 432400 Development Permit - 1,844.29 45,625.33 46,445.05 - (46,445.05) 0.00% TOTAL Permits - 1,844.291 45,625.33 46,445.05 - (46,445.05) 0.00% Fees 000 - 455200 Garbage Collection Fee 4,270,000 386,156.99 1,062,926.32 1,159,205.90 - 3,110,794.10 27.15% 000 - 455600 Fire Line Fees 27,700 3,620.00 - 3,620.00 - 24,080.00 13.07% 000 - 455700 Recycle Fee Revenue 284,000 24,431.89 69,055.28 73,122.66 - 210,877.34 25.75% 000 - 455800 W &S Line Constructn Reimbursemnt - 3,720.90 5,278.00 7,140.90 - (7,140.90) 0.00% 000 - 457100 Sale of Water 9,306,795 710,588.33 2,133,216.15 2,307,317.11 - 6,999,477.89 24.79% 000 - 457110 Edwards Water Lease 97,000 97,360.00 - 97,360.00 - (360.00) 100.37% 000 - 457120 Water Transfer Charge -Selma 42,000 - 17,740.68 - - 42,000.00 0.00% 000 - 457130 Water Transfer Charge -U. C. - - 22.42 - - - 0.00% 000 - 457140 Water Transfer Charge- Converse - - 8,368.38 - - - 0.00% 000 - 457200 Sale of Meters 90,000 7,976.00 18,318.00 18,998.00 - 71,002.00 21.11% 000 - 457400 Sewer Charges 4,900,000 540,448.88 1,199,094.53 1,580,935.20 - 3,319,064.80 32.26% 000 - 457500 Water Penalties 200,000 24,183.41 58,673.58 61,965.85 - 138,034.15 30.98% 000 - 459200 NSF Check Fee -Water &Sewer 2,500 225.00 625.00 750.00 - 1,750.00 30.00% TOTAL Fees 19,219,995 1,798,711.40 4,573,318.34 5,310,415.62 -' 13!,909,579.38 27.63% Fund Transfers 000 - 481000 Transfer In- Reserve 845,000 - - - - 845,000.00 0.00% 000 - 486204 Interfnd Chrg- Drainage Bill 136,920 11,410.00 32,490.00 34,230.00 - 102,690.00 25.00% TOTAL Fund Transfers 981,920: 11;,410.00 32,490.00 34,230.00 - 947,690.00 3.49 %' 202 -WATER & SEWER REVENUES Miscellaneous CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2016 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6- 2 0 1 7********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET 000 - 490000 Misc Charges 500 279,476.71 273.00 279,676.71 - (279,176.71) 55935.34% 000 - 491000 Interest Earned 800 86.79 165.59 382.82 - 417.18 47.85% 000 - 491200 Investment Income 20,000 3,424.24 1,216.16 7,727.02 - 12,272.98 38.64% 000 - 497000 Misc Income -W &S 15,000 (510.07) 5,464.64 7,892.19 - 7,107.81 52.61% 000 - 498110 Reimbursement -SSLGC 126,747 31,543.96 - 31,543.96 - 95,203.04 24.89% TOTAL Miscellaneous 163,047 314,021.631 7,11939 327,222.70 - (164,175.70) 200.69% TOTAL REVENUES 20,594,058 2,125;987.32 4,661,053.06 5,718,313.37 - 14,875,744.63 2717% WATER & SEWER Cash in Investments Lone Star Investment -Water &Sewer 4,087,329.65 Lone Star Investment -W &S Customer Deposits 297,692.09 Lone Star Investment -W &S Equip Replacement 178,986.47 Lone Star Investment -W &S Veh Replacement 258,562.24 Schertz Bank & Trust - Certificate of Deposit 1,085,140.17 $ 5,907,710.62 Total Cash in Bank & Investments $ 5,432,815.37 CITY O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31.2O10 2D1G'2O17 2034EK8S CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBIR BALANCE BUDGET REVENUE SUMMARY F000 8,504,700 535,900.50 1.414,67757 1.532.127 - 4,972,662.88 23.55% Inter-Jurisdictional 2.412.027 70.298 424.288 700.269 - 1.712.358.08 28.03% Miscellaneous 126,850 6,802 25,129 16,282 - 110,567.87 12.84% TOTALREVENUES 9,044,267 613,00990 1,864,095.17 2,248,678.34 - 6,795,588.83 24.86% EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services 3.867.750 410.027.86 808.31017 978.234�91 - 2.888.515�08 25.29% Supplies 404.859 43.03445 107.04749 132.241.57 30.17112 230.44031 41.60% Human Services - - - 238.00 - (238.00) 0.00% City Support Services 91,450 - 15.534.84 25.95175 - 65.496.25 28.38% Utility Services 113.000 9.220.94 15.003.31 19.518.75 540.85 83.540.30 17.66% Operations Support 78.800 8/45914 15.954.91 14.880.28 1.87417 02.039.55 21.27% Staff Support 75.250 1.77740 13.209.20 9.054.33 3.742.83 02.452.84 17.01% City Assistance 508.807 45.738.90 1.539.00 138.087J0 - 430.779.11 24.27% Professional Services 130.000 7.102.50 32.18219 37.003.84 - 92.996.10 28.46% FundChangeo/Transfem 2.983.038 29.542.03 679.348.93 81.70121 - 2.901.277J9 2.74% Maintenance Services 50.320 800.00 12.21048 860.00 11.025.00 43.835.00 22.17% Debt Service 271.375 - - - - 271.375.00 0.00% Rental-Leasing 81.541 5.795.07 17.385.21 17.90472 52.155.63 11.420.05 85.99% Operating Equipment 125.500 588.80 420.50 3.508.56 3.353.08 118.638.30 5.47% Capital Outlay -__8{,0}0 -----__-_' 79474400 ---____-_ --�42,825.0X0 -_-37,175.{00} 53.536 TOTAL PUBLIC SAFETY 8,928,351 568,753.09 2,573,762.23 1,459,313.62 152,287.78 7,316,749.41 18.05% TOTAL 8,928,351 568,753.09 2,573,762.23 1,459,313.62 152,28778 7,316,749.41 18.05% -' REVENUE OVER(UNDER) EXPENSES - 115,916 44,257 (7Q%6�67 789,365 (152,288) (521,161) CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2016 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 203 -EMS CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Fees 000 - 456100 Ambulance /Mileage Transport 6,272,100 507,784.32 1,341,610.37 1,445,693.87 - 4,826,406.13 23.05% 000 - 456110 Subscription Program Fees 30,000 13,560.00 21,595.00 17,030.00 - 12,970.00 56.77% 000 - 456120 EMT Class - Fees 90,000 9,700.00 35,094.47 9,800.00 - 80,200.00 10.89% 000 - 456122 CE Class - Fees 22,000 - - - - 22,000.00 0.00% 000 - 456130 Immunization Fees 7,000 300.00 8,266.00 1,108.00 - 5,892.00 15.83% 000 - 456140 Billing Fees - External 25,000 1,585.38 4,174.23 4,364.80 - 20,635.20 17.46% 000 - 456150 Standby Fees 25,000 2,264.80 - 19,835.45 5,164.55 79.34% 000 - 456155 Community Services Support 33,690 715.00 - 34,295.00 (605.00) 101.80% 000 - 458110 Sales of Merchandise - GovDeal - - 3,937.50 - - - 0.00% TOTAL Fees 6,504,790 535,909.50 1,414,677.57 1,532,12712 - 4,972,662.88 23.55% Inter - Jurisdictional 000 - 473500 Seguin /Guadalupe Co Support 843,577 70,298.17 75,999.70 281,192.68 - 562,384.49 33.33% 000 - 474300 Cibolo Support 319,098 - 67,306.25 79,774.58 - 239,323.42 25.00% 000 - 475100 Comal Co ESD #6 100,076 - 23,362.50 24,062.50 - 76,013.50 24.04% 000 - 475200 Live Oak Support 206,956 - 48,812.50 51,739.13 - 155,216.87 25.00% 000 - 475300 Universal City Support 268,871 - 63,696.88 65,590.25 - 203,280.75 24.39% 000 - 475400 Selma Support 106,656 - 19,043.75 26,664.02 - 79,991.98 25.00% 000 - 475500 Schertz Support 504,083 - 119,910.31 126,020.97 - 378,062.03 25.00% 000 - 475600 Santa Clara Support 10,354 - 2,492.19 2,588.54 - 7,765.46 25.00% 000 - 475800 Marion Support 14,956 - 3,664.38 3,739.00 - 11,217.00 25.00% 000 - 475910 TASPP Program 38,000.00 - - 38,897.42 - (897.42) 102.36% TOTAL Inter - Jurisdictional 2,412,627 70,298.17 424,288.46 700,269.09 - 1,712,358 29.03% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2016 2 0 1 6 - 2 0 1 7 203-EMS CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Miscellaneous 000-491000 Interest Earned 100 9.42 2.87 26.75 - 73.25 26.75% 000-491200 Investment Income 750 66.94 319.58 190.53 - 559.47 25.40% 000-493203 Donations-EMS 2,000 50.00 150.00 150.00 - 1,850.00 7.50% 000-493205 Donations- Golf Tournament 9,000 - - - - 9,000.00 0.00% 000-495100 UH Grant Program 90,000 - - - - 90,000.00 0.00% 000-497000 Misc Income 15,000 252.79 22,687.89 6,024.98 - 8,975.02 40.17% 000-497100 Recovery of Bad Debt 10,000 6,423.08 1,968.80 9,889.87 - 110.13 98.90% TOTAL Miscellaneous 126,850 6,802.23 25,129.14 16,282.13 - 110,567.87 12.84% TOTAL REVENUES 9,044,267 613,009.90 1,864,095.17 2,248,678.34 - 6,795,588.83 24.86% SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31, 2016 Cash in Bank Claim on Operating Cash Pool-Checking $ 98,058.09 Cash in Investments Texas Class- Tax Note 2015 Ambulances 89,293.94 Total Cash in Bank & Investments $ 187,352.03 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2016 204 - DRAINAGE CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY 301,780 48,010.83 117,654.17 124,687.50 177,092.50 Permits 3,000 120.00 680.00 500 2,500.00 16.67% Fees 1,141,000 94,831.17 277,026.40 283,585 - 857,415.29 24.85% Miscellaneous 4,200 1,075.25 903.61 3,011 - 1,189.41 71.68% TOTAL REVENUES 1,148,200 96,026.42 `' 278,610.01; 287,095.30 - 861,104.70 25.00% EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 301,780 48,010.83 117,654.17 124,687.50 177,092.50 41.32% Supplies 3,700 298.79 1,171.39 730.34 530.20 2,439.46 34.07% City Support Services 8,180 1,215.69 2,556.92 4,576.16 - 3,603.84 55.94% Utility Services 13,200 913.89 2,712.21 2,877.58 345.00 9,977.42 24.41% Operations Support 1,000 - - - - 1,000.00 0.00% Staff Support 6,700 533.74 1,146.81 998.11 730.40 4,971.49 25.80% City Assistance 400 - 120.00 - - 400.00 0.00% Professional Services 42,320 1,500.00 13,000.00 1,500.00 - 40,820.00 3.54% Fund Charges/Transfers 428,134 35,594.50 53,643.28 106,783.50 - 321,350.50 24.94% Maintenance Services 20,000 200.70 729.03 352.44 160.00 19,487.56 2.56% Other costs 200 - - - - 200.00 0.00% Debt Service 120,150 - - - 120,150.00 0.00% Rental /Leasing - - - - 0.00% Operating Equipment 7,000 - - - 7,000.00 0.00% TOTAL DRAINAGE 952,764 88;268.14 1`92,733.81 `: 242,505 63 1;765.60 708;492.77 25.64% PROJECTS Professional Services - - - - 8,000.00 (8,000.00) 0.00% Maintenance Services 170,000 - 13.59 - - 170,000.00 0.00% Capital Outlay - 33,700.00 - - - 0.00% TOTAL PROJECTS 170,000 - 33,71159 - 8;000.00 162;000.00 4.71% TOTAL EXPENDITURES 1,122,764 88,268,14 226,447.40 242,505.63 9,765.60 870,492.77 22.47% -- REVENUE OVER(UNDER) EXPEND` 25,436 > 44,589.67 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31, 2016 k******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6- 2 0 1 7******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *, 204 - DRAINAGE CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Permits 000 - 432400 Floodplain Permit 3,000 120.00 680.00 500.00 - 2,500.00 16.67% TOTAL Permits '` 3,000 120.00 680.00 500.00 - 2,500.00 16.67 %'! Fees 000 - 457500 Drainage Penalties 10,000 1,014.60 2,537.65 2,413.14 - 7,586.86 24.13% 000 - 457600 Drainage Fee 1,131,000 93,816.57 274,488.75 281,171.57 - 849,828.43 24.86% TOTAL Fees 1,141,000 94,831.17 277,026.40 283,584.71 - 857,415.29 24.85 %`' Miscellaneous 000 - 491000 Interest Earned 100 10.81 11.03 27.12 - 72.88 27.12% 000 - 491200 Investment Interest 4,000 1,064.44 892.58 2,983.47 - 1,016.53 74.59% 000 - 497000 Misc Income - Drainage 100 - - - - 100.00 0.00% TOTAL Miscellaneous 4,200 ' 1,075.25 903.61 3,010.59 - 1,189.4`1 71.68 %' TOTAL REVENUES 1,148,200 96,026.42 - 278,610.01 287,095.30 - 861,104.70 25.00% DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31, 2016 Cash in Bank Claim on Operating Cash Pool- Checking 171,230.61 Cash in Investments Lone Star Investment - Drainage Maint Fund 812,083.23 Total Cash in Bank & Investments $ 983,313.84 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31ST, 2016 2 0 1 6- 2 0 1 7********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *•. 314 -HOTEL TAX CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET I: ajok,l1J�al�J�i►� /e1:�'1 Taxes 609,302 33,203.43 120,345.40 100,36136 - 472,361.60 16.47% Miscellaneous 2,150 797.73 362.59 2,272.49 - 207.41 105.70% TOTAL REVENUES 611,452 34,001.16 120,707.99 102,633.85 - 472,569.01 16.79 %'' EXPENDITURE SUMMARY NONDEPARTMENTAL City Support Services 67,165 16,946.40 21,191.77 19,469.40 - 47,695.60 28.99% Operations Support 66,425 505.50 9,290.00 20,377.84 - 46,047.16 30.68% Professional Services 3,000 3,000.00 - 3,000.00 - - 100.00% Fund Charges /Transfers 114,405 5,533.75 - 16,601.25 - 97,803.75 14.51% Maintenance Services 10,000 - - - - 10,000.00 0.00% Operating Equipment - - - - (1,176.40) 1,176.40 0.00% TOTAL NONDEPARTMENTAL 260,995' 25,985.65 30,481.77 59,448.49 (1,176.40) 202,722.91 22.33% TOTAL EXPENDITURES 260,995 ` 25,985.65 30,481.77 59,448.49 (1,176.40) 202,722.91 22.33 %'' REVENUE OVER(UNDER)`EXPENDITURE 350,457 ! 43,185.36 HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31ST, 2016 Cash in Bank Claim on Operating Cash Pool-Checking $ 141,756.21 Cash in Investments Texas Class - Hotel Tax 1,055,732.64 Total Cash in Bank & Investments $ 1,197,488.85 $80,000 $70,000 $60,000 $50,000 - - - ", hY1 uuArt %a6SIJl$ '% rJ�s - - - - $40,000 - - - - - - - - $30,000 - - -- -� - - - - - - - - - $20,000 - - - - - - - - - - - - - - - - - - $10,000 - - - - - - -- - -- - - - $ OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2016 -17 33,916.87 33,203.43 -. 30,940.43 2015 -16 40,800 40,351 38,394 34,516 39,732 54,142 49,741 45,524 51,636 68,491 48,302 33,241 --0-2014-151 44,724 42,229 35,309 33,055 46,037 58,530 43,715 43,525 53,346 72,297 51,772 39,195 201314 40,023 40,709 33,342 29,778 36,680 56,699 48,081 49,579 54,858 67,329 57,399 34,297 2012-131 35,851 39,439 32,392 32,120 31,531 49,811 39,900 39,692 54,395 61,999 51,840 34,297 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2016 **************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7 **************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 317 -PARK CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Parkland Dedication Fees 145,000 20,000.00 - 96,000 - 49,000.00 66.21% Miscellaneous 40,000 249.79 905.26 707 - 39,293.04 1.77% TOTAL REVENUES 185,000 20,249.79 905.26 96,706.96 - 88,293.04 52.27 %? EXPENDITURE SUMMARY PARKLAND DEDICATION Operating Equipment 15,000 930.00 - 930.00 - 14,070.00 6.20% Capital Outlay 170,000 3,075.00 - 3,075.00 7,184.49 159,740.51 6.03% TOTAL PARKLAND DEDICATION 185,000 4,005.00 4,005.00 7,184.49 173,810.51 6.05% TOTAL EXPENDITURES 185,000 4,005.00 - 4,005.00 7,184.49 173,810.51 6.05% REVENUE OVER(UNDER) EXPEND - 92,701.96 CITY O F S C H E RTZ REVENUE REPORT (UNAUDITED) AS OF: DECEMBER31st.2O10 2U1G'2O17 317-PARK CURRENT CURRENT PRIOR YEAR CURRENT Y�-D BUDGET 25% OF REVENUES BUDGET PERIOD Y'T-DACTUAL Y�-DACTUAL ENCUMBRANCE BALANCE BUDGET Fees 000458800 Parkland Dedication 145,000 _2{\000.0X} ' 9600000 ' _49,000]}0 86C21% TOTAL Fees 145,000 20,000.00 96,000.00 - 49,000.00 66,21% [Nisoo|ksnoouo 000'491000 Interest Earned 250 418 3212 7.87 24213 315% 000'491200 Investment Interest 1`000 245.61 3.02 099.00 300.01 60.01% 000-497000 Mioc|ncomm 87012 ' 0.00% 000-499100 Transfer From Parks Reserve ___38,750 _____-_ - - - _38,750]00 0.00% TOTAL Miscellaneous 40,000 249.79 905.26 706.96 - 39,293.04 1.77% TOTAL REVENUES 185,000 20,24979 90526 96,706.96 - 88,29104 52.27% PARK FUND CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2016 Cash in Bank Claim on Operating Cash Pool- Checking $109,753.74 Cash in Investments Texas Class- Park Fund 327,669.88 Total Cash in Bank & Investments $437,423.62 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2016 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7 319 -TREE MITIGATION CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Tree Mitigation Fees 85,300 - 37,655.00 53,502 - 31,797.60 62.72% Fund Transfers 54,950 - - - - 54,950.00 0.00% Miscellaneous 1,750 262.21 235.15 683 - 1,066.80 39.04% TOTAL REVENUES 142,000 262.21 37,890.15 54,185.60 - 87,814.40 38.16% EXPENDITURE SUMMARY TREE MITIGATION Maintenance Services -Trees 142,000 36,500.00 140.00 36,500.00 9,165.00 96,335.00 32.16% TOTAL TREE MITIGATION 142,000 36,500.00 140.00 36,500.00 9,165.00 96,335.00 32.16 %' TOTAL EXPENDITURES 142,000 36,500.00 140.00 ? 36,500.00 9,165.00 96,335.00 32.16 %' REVENUE OVER(UNDER) EXPEND - (36,237.79} 37,750.15 17,685.60 (9,165.00) (8,520.60) CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2016 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6- 2 0 1 7******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 319 -TREE MITIGATION CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBRANCE BALANCE BUDGET Fees 000 - 458900 Tree Mitigation 85,300 - 37,655.00 53,502.40 - 31,797.60 62.72% TOTAL Fees 85,300 - 37,655.00 53,502.40 31,797.60 62.72% Fund Transfers 000 - 481000 Transfer In -Reserves 54,950 - - - - 54,950.00 0.00% TOTAL Fund Transfers 54,950 - - - - 54,950.00 0.00 %` Miscellaneous 000 - 491000 Interest Earned 250 - 11.56 3.81 - 246.19 1.52% 000 - 491200 Investment Interest 1,500 262.21 223.59 67939 - 820.61 45.29% TOTAL Miscellaneous 1,750 262.21 235.15 683.20 - 1,066`.80 39.04 %s TOTAL REVENUES 142,000 262.21 37,890,15 54,1185.60 < - 87,814.40 38.16 %s' TREE MITIGATION FUND CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2016 Cash in Bank Claim on Operating Cash Pool- Checking $8,247.75 Cash in Investments MBIA Investment -Tree Mitigation 349,824.31 Total Cash in Bank & Investments $358,072.06 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2016 ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7 ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 411 - CAPITAL RECOVERY WATER CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 1,020,000 115,893.00 246,456.00 266,994 - 753,006.00 26.18% Fund Transfers - - - - - - 0.00% Miscellaneous 20,600 2,420.13 2,793.37 6,043 - 14,557.22 29.33% TOTAL REVENUES 1,040,600 118,313.13 249;249.37 273,036.78 - 767,563.22 26.24% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 156,000 1,000.00 - 1,000.00 - 155,000.00 0.64% TOTAL NON DEPARTMENTAL 156,000 1,000.00 1,000.00 - 155,000.00 0.64% MISC & PROJECTS PROJECTS Professional Services Fund Charges /Transfers 366,594.84 186,732.71 (186,732.71) 0.00% - - 0.00% TOTAL MISC & PROJECTS - - 366;594.84 - 186,732.71 (186,732.71) 0.00% TOTAL EXPENDITURES 156,000 1,000.00 366,594.84 1,000.00 186,732.71 (31,732.71) 120.34 % ' REVENUE OVER(UNDER) EXPENDITURES 884,600 117,313.13 (117,345.47) 272,036.78 (186,732.71) 799,295.93 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2016 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7 411 - CAPITAL RECOVERY WATER CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Fees 000 - 455900 Capital Recovery - Water 1,020,000 115,893.00 246,456.00 266,994.00 - 753,006.00 26.18% TOTAL Fees 1,020,000 115,893.00 246,456.00 266,994.00 - 753,006.00 26.18 % i Miscellaneous 000 - 491000 Interest Earned 600 24.42 199.47 6531 - 534.69 10.89% 000 - 491200 Investment Income 20,000 2,395.71 2,593.90 5,977.47 - 14,022.53 29.89% TOTAL Miscellaneous 20,600 2,420.13 2,793.37 6,042.78 - 14,557.22 29.33 %p TOTAL REVENUES 1,040,600 118,313.13 249,249.37 273,036.78 - 767,563.22 26.24% CAPITAL RECOVERY WATER CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2016 Cash in Bank Claim on Operating Cash Pool-Checking $ (332,895.61) Cash in Investments Lone Star Investment-Capital Recovery Water 3,979,488.00 Total Cash in Bank & Investments $ 3,646,592.39 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2016 2 0 1 6 - 2 0 1 7 421 - CAPITAL RECOVERY SEWER CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 600,000 30,024.00 110,616.00 102,165 - 497,835.00 17.03% Fund Transfers - - - - - - 0.00% Miscellaneous 25,500 2,822.03 (5,683.15) (4,529) - 30,029.29 - 17.76% TOTAL REVENUES 625,500 32,846.03 104,932.85 97,63511 - 527,864.29 15.61% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 85,500 1,361.85 1,077.08 2,089.27 - 83,410.73 2.44% TOTAL NON DEPARTMENTAL 85,500 1,361.85 1,077.08; 2,089.27 - 83,410.73 2.44 %d MISC & PROJECTS Professional Services 150,000 - - - - 150,000.00 0.00% TOTAL MISC & PROJECTS 150,000 - - - - 150,000.00 0.00 %!' TOTAL EXPENDITURES 235,500 1,361.85 1,077.08 2,089.27 - 233,410.73 0.89 %6 REVENUE OVER(UNDER) EXPENDITURES 390,000 31,484.18 103,855.77 95,546.44 - CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2016 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7 421 - CAPITAL RECOVERY SEWER CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Fees 000 - 455910 Capital Recovery -Waste Wtr 600,000 30,024.00 103,416.00 102,165.00 - 497,835.00 17.03% 000 - 455913 Cap Recovery -North Sewer Tr - - 7,200.00 - - - 0.00% TOTAL Fees 600,000 30,024.00 110,616.00 102,165.00 - 497,835.00 17.03% Miscellaneous 000 - 491000 Interest Earned 500 8.18 111.57 26.88 - 47112 5.38% 000 - 491200 Investment Income 25,000 4,795.50 11,616.17 13,668.64 - 11,331.36 54.67% 000 - 491800 Gain /Loss - (3,513.67) (30,460.28) (3,091.80) - 3,091.80 0.00% 000 - 491900 Unrealized Gain /Loss -Cap One - 1,532.02 13,049.39 (15,133.01) - 15,133.01 0.00% TOTAL Miscellaneous 25,500 2,822.03 (5,683.15) (4,529`29) - : 30,029.29 - 17.76% TOTAL REVENUES 625,500 32,846.03 104,932.85 97,635.71 - 527,864.29 15.61 % r CAPITAL RECOVERY SEWER CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2016 Cash in Bank Claim on Operating Cash Pool-Checking $ 208,931.35 Cash in Investments Lone Star Investment-Capital Recovery Sewer 2,971,391.82 Capital One-investment 1,743,547.90 Total Cash in Bank & Investments $ 4,923,871.07 505 -TAX I &S FINANCIAL SUMMARY REVENUE SUMMARY CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2016 *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Taxes 6,102,433 3,001,874.97 3,007,482.96 3,397,469 - 2,704,964.44 55.67% Fund Transfers 40,860 - - - - 40,860.00 0.00% Miscellaneous 471,288 1,485.38 4,185,598.94 3,288 - 467,999.74 0.70% TOTAL REVENUES 6,614,581+ 3,003,360.35 7,193,081.90 3,400,756.82 - 3;213,824.18 51.41 % ` EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 102,500 - 82,774.23 550 1,000.00 100,950.00 1.51% Debt Service 6,512,081 - (96,883.60) - 2,525,545.01 3,986,535.99 38.78% Other Financing Sources - - 4,220,709.38 - - - 0.00% TOTAL GENERAL GOVERNMENT 6,614,581!' - 4,206,600:01 550.00 2,526,545.01 4,087,485.99 38.20% TOTAL EXPENDITURES 6,614,581? - 4,206,600.01 550.00 2,526,545.01 4,087,485.99 38.20 %! ** REVENUE OVER(UNDER) EXPEND - 3,400,206.82 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2016 *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 505 -TAX I & S CURRENT CURRENT PRIOR YEAR CURRRENT Y -T -D BUDGET 25% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Taxes 000 - 411900 Property Tax Revenue 6,102,433 3,001,874.97 3,007,482.96 3,397,468.56 - 2,704,964.44 55.67% TOTAL Taxes 6,102,433 3,001,874.97 3,007,482.96 3,397,468.56 - 2,704,964.44 55.67 %i 000 - 486000 Transfer From Reserves 40,860 - - - - 40,860.00 0.00% TOTAL Fund Transfers 40,860 - - - - 40,860.00 0.00 %,, Miscellaneous 000 - 491000 Interest Earned 500 41.79 62.95 61.77 - 438.23 12.35% 000 - 491200 Investment Earnings 4,000 1,443.59 535.99 3,226.49 - 773.51 80.66% 000 - 495015 Contribution from SED 366,788 - - - - 366,788.00 0.00% 000 - 495020 Contribution from YMCA 100,000 - - - - 100,000.00 0.00% 000 - 498000 Proceeds From Refunding Debt - - 4,185,000.00 - - - 0.00% TOTAL Miscellaneous 471,288 1,485.38 4,185,598.94 3,288.26 - 467,999.74 0.70 %! TOTAL REVENUES 6,614,581 3,003,360.35 7,193,081.90 3,400,756.82 - 3,213,824.18 51.41% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2016 505 -TAX I& S *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** GENERAL GOVERNMENT CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF NON DEPARTMENTAL BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Professional Services 101 - 541500 Paying Agent 2,500 - 550.00 550.00 1,000.00 950.00 62.00% 101 - 541502 Cost of Bond Issuance 100,000 - 82,224.23 - - 100,000.00 0.00% TOTAL Professional Services 102,500 - 82,774.23 550.00 1;000 100,950.00 1,51% Debt Service 101 - 555612 Bond -GO Refunding 2010 - Principal 285,000 - - - - 285,000.00 0.00% 101 - 555612.1 Bond -GO Refunding 2010 Interest 47,025 - - - - 47,025.00 0.00% 101 - 555626 LS &D SR2006- Principal - - (5,227.50) - - - 0.00% 101 - 555626.1 LS &D SR2006- Interest - - (8,000.00) - - - 0.00% 101 - 555628 CO Bond 2007 - Principal - - - - - - 0.00% 101 - 555628.1 CO Bond 2007 - Interest - - - - - - 0.00% 101 - 555629 GO Bond 2007 - Principal 280,000 - - - - 280,000.00 0.00% 101 - 555629.1 GO Bond 2007 - Interest 147,945 - - - - 147,945.00 0.00% 101 - 555630 GO Bond SR2008 Principal 460,000 - - - - 460,000.00 0.00% 101 - 555630.1 GO Bond SR2008 Interest 278,362 - - - - 278,362.00 0.00% 101 - 555631 GO Bond SR2009 Principal 550,000 - - - - 550,000.00 0.00% 101 - 555631.1 BO Bond SR2009 Interest 266,325 - - - - 266,325.00 0.00% 101 - 555633 GO SR2011 Principal 235,000 - - - 235,000.00 - 100.00% 101 - 555633.1 GO SR2011 Interest 334,763 - - - 169,143.75 165,619.25 50.53% 101 - 555634 GO SR2011A Refund Principal 620,000 - - - - 620,000.00 0.00% 101 - 555634.1 GO SR2011A Refund Interest 102,404 - - - - 102,404.00 0.00% 101 - 555635 GO SR2012 Principal 320,000 - - - 320,000.00 - 100.00% 101 - 555635.1 GO SR2012 Interest 181,755 - - - 94,357.50 87,397.50 51.91% 101 - 555636 Tax Note - SR2013 - Principal 170,000 - - - 170,000.00 - 100.00% 101 - 555636.1 Tax Note - SR2013 - Interest 3,995 - - - 2,550.00 1,445.00 63.83% 101 - 555637 Tax Note - SR 2013A - Principal 160,000 - - - - 160,000.00 0.00% 101 - 555637.1 Tax Note - SR2013 - Interest 3,185 - - - - 3,185.00 0.00% 101 - 555638 Bond -GO 2014 Refund - Principal 100,000 - - - 100,000.00 - 100.00% 101 - 555638.1 Bond -GO 2014 Refund - Interest 292,275 - - - 146,637.50 145,637.50 50.17% 101 - 555639 Tax Note - SR2015 - Principal 35,000 - - - - 35,000.00 0.00% 101 - 555639.1 Tax Note - SR2015 - Interest 3,150 - - - 3,150.00 0.00% 101 - 555640 Bond -Ref 2015 Bond- Principal 450,000 - - - 450,000.00 - 100.00% 101 - 555640.1 Bond -GO Ref 2015- Interest 102,125 - - - 53,312.50 48,812.50 52.20% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2016 505 -TAX I& S *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** GENERAL GOVERNMENT CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF NON DEPARTMENTAL BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET 101 - 555641 Tax Note - SR2015A - Principal 145,000 - - - - 145,000.00 0.00% 101 - 555641.1 Tax Note - SR2015A - Interest 13,783 - - - - 13,783.00 0.00% 101 - 555642 GO Bond SR2016 Principal - - - - 405,000.00 (405,000.00) 0.00% 101 - 555642.1 GO Bond SR2016 Interest - - - - 89,903.13 (89,903.13) 0.00% 101 - 555643 CO Bond Tax SR2016 Principal - - - - 55,000.00 (55,000.00) 0.00% 101 - 555643.1 CO Bond Tax SR2016 Interest - - - - 24,856.25 (24,856.25) 0.00% 101 - 555644 CO Bond nonTax SR2016 Principal - - - - 170,000.00 (170,000.00) 0.00% 101 - 555644 CO Bond nonTax SR2016 Interest - - - - 39,784.38 (39,784.38) 0.00% 101 - 555900 Debt Service 924,989 - - - - 924,989.00 0.00% 101 - 555800 Bond Premium - - (83,656.10) - - - 0.00% TOTAL Debt Service 6,512,081 - (96,883.60) - 2,525,545.01 3,986,535.99 38.78 %, Other Financing Sources 101 - 556300 Payment to Refund Debt - - 4,220,709.38 - - - 0.00% TOTAL Other Financing Sources 4,220,709.38 - - 0.00 %' TOTAL EXPENDITURES 6,614,581 - 4,206,600.01 550'.00 2,526,545 4,087,485.99 38.20 %i TAX I&S CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2016 Cash in Bank Claim on Operating Cash Pool-Checking $ 84,697.17 Cash in Investments IVIBIA Investment- Tax I&S 4,627,086.53 Total Cash in Bank & Investments $ 4,711,783.70 620 -SED CORPORATION FINANCIAL SUMMARY CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2016 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6- 2 0 1 7********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *� CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BUDGET 25% OF BALANCE BUDGET REVENUE SUMMARY Taxes 3,692,710 375,462.58 908,085.45 949,418.01 - 2,743,291.99 25.71% Miscellaneous 45,550 7,404.11 8,019.47 23,270.42 - 22,279.58 51.09% TOTAL'REVENUES 3,738,260 382,866.69 916,1`04.92 972,688.43 - 2,765,571.57 26.02% EXPENDITURE SUMMARY ECONOMIC DEVELOPMENT Personnel Services - - 65,184.68 13,200.53 - (13,200.53) 0.00% Supplies 750 12.22 49.27 186.69 89.80 473.51 36.87% Human Services 1,000 345.20 - 345.20 - 654.80 34.52% City Support Services 7,700 418.50 1,135.05 2,151.99 - 5,548.01 27.95% Utility Services 4,820 208.29 443.48 595.32 - 4,224.68 12.35% Operations Support 131,000 12,419.82 1,446.63 13,474.20 780.17 116,745.63 10.88% Staff Support 22,300 3,897.95 1,408.45 4,188.88 496.21 17,614.91 21.01% City Assistance 1,005,000 47.50 50.70 47.50 - 1,004,952.50 0.00% Professional Services 87,500 4,059.00 - 4,104.00 26.77 83,369.23 4.72% Fund Charges/Transfers 797,847 35,921.67 12,756.00 107,764.69 - 690,082.31 13.51% Operating Equipment 4,700 - - - 299.99 4,400.01 6.38% TOTAL!ECONO DEVELOPMENT 2,062,617 57,330.15 82,474.26 146,059.00 1,692.94 1,914,865.06 7.16% MISC & PROJECTS PROJECTS - - 1,057.50 - - - 0.00% TOTAL MISC & PROJECTS - 1,057.50 - - 0.00% TOTAL EXPENDITURES 2,062,617 57,330.15 83,531.76 146,059.00 1,692.94 1,914,865.06 7.16% " REVENUE OVER(UNDER) EXPEND 1,675,643 325,536.54 832,573.16 826,629.43 (1;692.94) 850,706.51 SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2016 Cash in Bank Claim on Operating Cash Pool-Checking $ 748,339.20 Cash in Investments Texas Class Investment-Economic Development Corl 8,212,119.96 Schertz Bank & Trust-Certificate of Deposit 1,054,002.95 Total Cash iin Bank & Investments $ 10,014,462.11 4B SALES TAX By Collection Month 41 $400,000 1.9% $350,000 - - -- - - - - ------------ - - - - - - - - - - 19.90 9.5% $300,000 - - - - - $250,000 $200,000 $150,000 $100,000 $50,000 - - - - - - - - - - - - - - $ OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 62016 -17 287,235 379,299 290,086 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 L_3 ,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 1 237,123 212,096 316,358 207,915 202,689 330,324 272,337 281,818 325,062 243,585 FOR MONTH ENDING December 31st, 2016 C I T Y O F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING December 31st, 2016 INVESTMENT POOLS Beginning Deposits/ Interest Ending Ending. Par Maturity Weighted Book Value Yield Purchases. T ^.., t7, r7 - = *a1s Bamled Book Value Mkt..Value Value Date &v9__Mat.. OPERATIONS -BANK. CASH Schertz Bank & Trust - Pooled Cash 7,307,874.10 0.0500 14.,009,638.10 15,479,125,74 347.57 5,838,734.03 5,838,734..03 5,838,734.03 N /A. Schertz Bank .& Trust - PEG Fund 577,590..40 0.0000 - 449.00 - 577,141,40 577,141.40 577.,141..40 N/A TOTAL OPERATIONS 7,885,464.50 14,009,638.10 15'.,479,574:874 .347.57 6,415,875.43 6,415,875.43; 6,415,875.43 LOGZC General Fund 6,644,277.57 0.8790 4,000,000.00 5,257.75 10,649,535:32 10,649,535.32 10,649,535.32 N/A 31 days G /F- Equipment Replacement 74,.170.54 .0:8790 - - 55;39 74,225.93 74,225..93 74,225.93 N/A 31 days G /F- Vehicle Replacement 500,115:04 0..8790 - - 373.36 500,488.40. 500,488..40 500,488..40 N/A 31. days G/F -Air Conditioner Replacement .272,166.56 0.8790 - - 203,20 272.,369.76 272,369.76 272,369.76 N/A 31 days SR2009 Bond- Street Projects(II) 873,.909.73 0,.8790 - - 652...43 874,562.16 874- 562.16 874,562.16 N/A 31 days TOTAL LOGIC 8,364,639.44 4,000,000.00 6,542.13 12,371.,181.57 12,371,181.57 12,371,181.57 LO =1118 Capital Recovery - Sewer 2,969,375.28 0.7739 0..20 - 2,016.34 2,971,391.82 2,971,391.82 2;971,391.82 N/A 45 Capital Recovery - Water 3,.477.,052.29 0.7739 500,000.00 - 2,395,71 3,979,448.00 3,979,448.00 3;979,.448.00 N/A 45 Drainage Fund 811.,532.16 0,7739 - - 551.07 812,083.23 812,083:23 812,083.23 N/A 45 Facilities Master Plan 26,063.93 0..7739 - 17.70 26,081..63 26,081.63 26,081.63 N/A 45 GO SR2011 Animal Shelter 8,638.30 0.7739 - - 5..87 8,644.17 8,644..17 8,644.17 NIA 45 GO SR2011 Soccer Fields 162,733.48 0.7739 - - 110.50 162,.843.98 162,843.98 162,843.98 N/A 45 GO SR2011 Swimming Pool 3;399,397.7.9 0:7739 - 1,000,000.00 2,239:07 2,401,636.86 2.,401,636.86 2,401,636.86 N/A 45 CA SR2012 Downtown Improvements 984,397.52 0.7739 - - 668.45 985,065,97 985,065.97 985,065:97 N/A 45 BE Elevated Water Tank :2,428,620.64 0.7739 - - 1,649.14 2,430,269.78 2,430,269.78 2,430,269.78 N/A 45 Sewer /CCMA Project 2,856,207.17 0.7739 - - 1,939,49 2;858.;146.66. 2,858,146.66 2,858,146.66 N/A 45 W /S- Customer. Deposits 297,490.98 0.7739 - - 202,01 297,692.09 297.,69209 297,692 09 N/A 45 W/8-Equipment Repl /Cap,Imp 178,865,91 0.7739 `. - - 121.46 178,986,47 178,.986.47 178,986..47 N/A 45 Water &Sewer 3,984,.616.99 :0.7739 100,000.00. - 2,712.66 4,087,329.65 4,087,329.65 .4,087.,329.65 N/A 45 W /S- Vehicle Replacement 258.386:78 '0,7739 - - 175.46 258:562.:24 258,562.24 258.562.24 N/A 455 TOTAL LONESTAR ::21,843,377°42 600,000.20 1,000,000:00 14,804.93 21,455,182 55 21,458,182.55.: 21,458,182.55 Tax I &S. 1,625,642.94 0.8900 3,000,000.00 -.- 1,443.59 4,627,086.53 4,627,086.53 .4,627,086..53 N/A 71 Days Justice Forfeiture 245,937.72 0.8900 - - 184.48 246,122.20 246,122.20 246,122.20 N/A 71 Days Park Fund 327,424..27 0:8900 - - 245.61 327,669.88 327,669.88 327,669.88 N/A 71 Days Economic Development Corporation 9,740,117.62 0.8900 1,000,000.00 - 7,381.16 10,747,498.78 10,747,498.78 10,747,498.78 NIA 71 Days Library Board 45,204..92 0.8900 - - :33:89 45,238.81 45,238.81 45,238.81 N/A 71 Days Tree Mitigation 349,56210 0.8900 - - - 262.21 349,824:31 .349,824.31 349.,824.31 N/A 71 Days Tax. Note. 2013 Fire Truck 4,968.19 0..8900 - - 3.74 4,971.93 4,971..93 4,971:33 N/A 71 Days Hotel Tax 1,054,941..28 0..8900 -- - 791.36 1,055,732.64. 1,055,732.64 1,055,732,64 N/A 71 Days Special Events Fund 16,914.50 0.8900 - °- 12.69 16,927.19 16,927.19 16,927.19 N/A 71 Days Tax Notes 2015 EMS Ambulances 89,227.,00 0.8900 - - 66.94. 89,293.94. 89,293.94 89,293.94 N/A 71 Days Tax Notes 2015. Drainage 'Equipment 684,364,39 0.8900 - - 513.37 ' 684,877.76 684,877:76 684,877.76 N /A. 71 Days Tax Notes 2015 Water Equipment 283,503.85 0,8900 - - 212.65: 283,716.50 283,716:50 283,716.50 N/A 71 Days Tax. Notes 2015 General Fund Equipme. 241,962,64 0.8900 - - : 181:49. 242.,144,13 242,144.13 242,144.13 N/A 71. .Days Tax. Notes 2015A Fire Trucks & Equip 628.40 0.8900 - - 0.48'- 628.86 628.88 628.88 N/A 71 Days 2016 CO Roads 1,001,.997.79 0.8900 - - - 751.65 1,002,749.44 1,002,749,44 1,002,749.44 N/A 71 Days 2016 CO Building Repairs 173,081.13 0.8900 - - - 129.84 173,210.97 173,210.97 173,210.97 NIA 71 Days 2016 CO Rec Center Windows 728,.716..88 0.8900 - 300,000.00 516..70 429,233.58 429,233.58 429,233.58 NIA 71 Days 2016 GO Fire Station 3 4,007,991.24 0,8900 - - .3,006.53 4,.010,997.77 4,010,997.77 .4,010,997.77 N /A. 71 Days TOTAL TEXAS CLASS 20,622,186.86 :4,000,000.00 300,000:.00 15:,738.38 : 24,337,925.24 24,337,925.24; 24,337,925.24 C I T Y O F S C H E R T Z INVESTN%ENT REPORT FOR MONTH ENDING December 31st, 2016 Cit Manager Executiv hector r Executive Finance Director. This. investment portfolio .represents a liquid and diverse holding by the City of Sehertz. 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.. Cox Beginning Interest Ending Book value Mki value Par value Maturity Date. ayg-k at. 11NBM$TMENT MANAGED ACCQE1U Capital One General Fund Book value 1,368,004.18 field 1.6900 Eamled - 283.18 4,441.01 1,372,162.01 1,359,243.65 1.,340,981.87 N/A 685 Days Capital One Capital Recovery Sewer. 1,751.,343.59 1.6300 - 363.53 4,940.57. 1,755,920.63 1,743,547.90 1.,721,563.14 N/A 676 Days TOTAL CAPITAL ONE 3,119,347 „77 - 646.71 9,381.58 3,128.;082.64 3,102,791.55 3,062,545.01: - C. D. CERTIFICATES OF DEPOSIT Term SB &T- Water &Sewer 1,076,645.00 :0.8000 - - - 1,076,645.00 1,085,140.17 1,076,645.00 1/6/2017 .365 Days Sehertz Economic Development Corp. 1,057.,121.64 016000 - - - 1.,057,121..64 1,057,695_09. 1,057,121..64 5/28/2017 180 Days Sehertz Economic Development Corp. 1,000,000.00 0.8000 - - - 1,000,.000.00 1,007;868.49 1,000,000.00 1/7/2017 365 Days TOTAL C.D.s 3,133,766.64 - 3,133.;766.64 3,150,703.76;. 3,133,766.64.: TOTAL PORTFOLIO 0:.88 $46,814.59 L70,845,014.07 L 70,836.,660.10 $ 70,779,47.6.44 91 Days Cit Manager Executiv hector r Executive Finance Director. This. investment portfolio .represents a liquid and diverse holding by the City of Sehertz. 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.. Cox City Portfolio By Investment Type TOTAL C.D.s TOTAL OPERATIONS 9% TOTAL LOGIC 18% \-TOTAL LONESTAR 30% 3�M= 1.80 1. 60 IAO 1.20 1.00 0.80 0.60 0.40 0.20 0.00 afflRy'(41, "I I I 'b'' Oct-16 Nov-16 Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-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 Ml Month T-Bill 0.1800 0.3700 0A300 ❑3 Month T-Bill 0.3400 0.4800 0.5100 C36 Month T-Bill 0.5100 0.6100 0.6100 E3Schortz Portfolio 0.8000 0.8000 0.8000 MSchertz Bank&Trust 0.0500 0.0500 0.0500 0 C 365 Days 0.8000 0.8000 0.8000 MCD 180 Days 0.6000 0.6000 0.6000 OLOGIC 0.8112 0.8364 0.8790 ❑LoneStar 0.6900 0.7087 0.7739 MI,MIA 0.8300 0.9000 0.8900 MCapital One 1.6900 1.5900 1.6900 Capital Recovery Assets C I T Y OF S C H E R T Z 'Projected Investment Report Annual Capital One Assets Cash & Equivalents Due Maturity Date: 12/31/2016 Cost Mrk Value Income Yield :Fidelity Imm Government Fund *2642 General Fund 11,563;14 11.563,14 11.563.14 49.00 0.42 Total Cash & Equivalents Assets 11.,563.14 11,5.63.14 11,563.14 49.00 0.42.% Fixed Income Projected Conroe Tex Indpt Sch Dist Sch .Bldg 2/15/2020 1141.00 50,000.00 50,831.00 Annual Current Cash & Equivalents Due Maturity Shares Cost Mrk. Value Income Yield Fidelity Imm Government Fund #2642 0.87 60, 981.87 60,981..87 60,981.87 253.00 0.43 Total Cash & Equivalents 5,125.00 4..95 60,981.87 60,981.87 60,981.87 263.00 0.4.3°. Fixed Income 105.,438.00 4,875.00 4..62 Federal Home LN Mtg Corp 3/27/2019 816.00 Conroe Tex Indpt Sch Dist Sch Bldg 2/15/2020 1141.00 50,000.00 50,831.00 50,247.00 2,:625.00 5_.22. Federal Home LN Mtg Corp Reference Nts 11/17/2017 321.00 100,000:00 109,860.00 103,633.00 5,125.00 4.95 Federal Home LN Mtg Corp Refrnce 8 6/13/2018 529.00 100,000.00 110,756..94 105,.438.00 4,875.00 4.62 US Treasury Note 10/15/2017 288..00 40,000.00 39,913.84 40,011.20 .350.00 0,87 US Treasury Note 10/31/2019 1034.00 100,000.00 101,875.00 100;258.00 1,500.00 1.50 US Treasury Note 11./15/2.017 319,00 100,000.00 99,521.48 100,018.00 875.00 0..87 US Treasury Note. 8/15/2020 1323.00 100,000.00 103,394.53 103,416.00 2,625.00 2..54 US Treasury Note. 12/15/2018 714.00 125,D00.00 126;181.64 125,156:25 1.,562.00 1.25 US Treasury Note. 10/31/2019 1034.00 100,000.00 99,601..56 99,590.00 1,250.00 1.26 US Treasury Note 11/30/2019 1064.00 100,000..00 99.,559.69 98,811.00 1,000.00 1_.01 US Treasury Note 1/31/2020 1126.00 100,000.0 0 101,312..50 99,:641.00 1,375,00. 1.38 US Treasury Note 7/31/2018 577.00 100,000.00 101,359.38 100,461.00 1,375,00 1.37 US Treasury Note 9/30/2020 1369.00 50,000.00 50,544.92 50,575.50 1,000.00 1..98 US Treasury Note 10/31/2018 669.00 100,000.00 101,101.56 100,176.00 1,250.00 1.25 Upper Trinity Regl Wtr Dist Te. Rev 8/1/2017 213:00 15 000..00 15 371.10 15,256.95 600.00 393 Total Fixed Income 3.93 Total 1,280,000.00 1,311,180.14 1,292,688.90 27,387.00 2.12.' Total Assets 33,648.00 764.42 1,3.40,981.87 1,372,162.01 1,353,670.77 :.27,650.00 2.04 %rr Capital Recovery Assets 'Projected Annual Current Cash & Equivalents Due Maturity Shares Cost Mrk Value Income Yield :Fidelity Imm Government Fund *2642 11,563;14 11.563,14 11.563.14 49.00 0.42 Total Cash & Equivalents 11.,563.14 11,5.63.14 11,563.14 49.00 0.42.% Fixed Income Conroe Tex Indpt Sch Dist Sch .Bldg 2/15/2020 1141.00 50,000.00 50,831.00 50,247.00 2,625.00 5.22 Federal Natl Mtg Assn 1.0/26/2017 299.00 125,000.00 124,588.38 125,027. -50 1,093.00 0.87 Federal Home Ln Mtg Corp Reference Nts: 11/17/2017 321.00 100 ,000..00 109,860,00 103,633.00 5,125.00 4..95 Federal Home Mtg Corp Refrnce 8 6/13/2018 529.00 100,000.00 110,753,60 105.,438.00 4,875.00 4..62 Federal Home LN Mtg Corp 3/27/2019 816.00 100,000 00 108,297..4.0 105,.378,00 3,7.50_00 3.56 US. Treasury Note 10/31/2019 1034,.00 100,000.00 .1.00,065.85 100;258.00 1,500.00 1.50 US Treasury Note 11/15/2017 319.00 200,000.00 1.99,042..97 200,036.00 1,750.00 0.87 US Treasury Note 8/15/2020 1323,00 100,000.00 103,394.53 103,416,00 2,625.00 2_54 US Treasury Note 12/15/2 018 714..00 100,000.00 100,945.31 100,125.00 1,250.00 1.25 US Treasury Note 4/30/2021 1581.00 50,000.00 50,107.42 49,056.00 687,00 1.40 US Treasury Note 10/31/2019 1034.00 100,000.00 99,601.57 99,590.00 1,250.00 1..26 US Treasury Note 11/30/2019 1064. -00 200,000..00 199,226.56 197,622.00 2;000:00 1.01 US Treasury Note 1/31/2020 1126..00 50,000.00 50,656.25 49,820.50 687.00 1.38 US Treasury Note 2/28/2018 424.00 100,000.00 99,175..78 99,774.00 750.00 0.7.5 US Treasury Note 6/30/2018 546.00 75,000.00 75,916.99 75,360.75 1.,031.00 1..37 US Treasury Note 9/30/2020 1369.00 50,000.00 50,544.92 50,575.50 1,250.00 2.47 US Treasury Note 10/31/2018 669.00 100,000.00 101.,101..56 100.,176.00 1,000.00 1.00 Upper TrinityRegl. Wtr Dist To Rev 8/.1./2017 213.00 10,000.00 10.247.40 10,171.30 400.00 3.93 Total Fixed Income 1,710,000.00 1,744,357.19 1.,725,704.55 33,648.00 1.95°. Total Assets 755.75 1,721,563.14 1,755.,920.63 1,737;267.69 :: 33,697.:00 1.9416