Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Q2- March- 2017 Financials
2 "d Quarter Financial Report CITY OF SCHERTZ Prepared By: The Finance Department March 31 ". 2017 2 "d Quarter Financial Summary Quarter) Statement Quarterly Schertz, Texas CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2017 - - - -- <,.<. < ----------- --------- <, 2016 - 2017 <. �,�,.<..<- - -- - -- CURRENT BUDGET CURRENT PERIOD PRIOR YEAR Y -T -D ACTUAL CURRENT Y -T -D ACTUAL Y -T -D ENCUMBR BUDGET BALANCE 50% OF BUDGET General Fund, 101 Total Revenues $29,601,195.00 $1,585,477.04 $18,108,276.76 $19,690,882.44 $0.00 $9,910,312.56 66.52% Total General Government $7,491,948.00 $781,632.63 $2,529,522.44 $2,749,934.08 $420,510.63 $4,321,948.00 42.32% Total Public Safety $12,209,393.49 $922,986.59 $5,511,242.39 $5,732,436.56 $478,190.32 $5,998,766.61 50.87% Total Public Environment $1,227,407.00 $82,728.81 $434,317.46 $486,550.19 $159,129.96 $581,726.85 52.61% Total Parks & Recreation $1,814,217.00 $152,880.84 $432,963.15 $621,064.48 $82,082.83 $1,111,577.83 38.76% Total Cultural $868,161.00 $67,498.43 $408,437.43 $418,431.88 $7,248.09 $442,481.03 49.03% Total Health $787,854.00 $80,727.86 $181,260.85 $379,572.87 $62,291.93 $345,989.20 56.08% Total Internal Services $4,929,355.00 $449,223.78 $2,116,552.27 $2,278,352.84 $172,294.74 $2,478,707.42 47.72% Total Misc & Projects $264,708.00 $32,903.53 $86,997.28 $123,375.85 $2,025.40 $139,306.75 47.37% General Fund, 101 Total Cash in Bank & Investments $17,031,622.89 Special Events Fund, 106 Total Revenues $130,350.00 $7,379.35 $31,158.78 $38,866.84 $0.00 $91,483.16 17.22% Total Expenditures $130,350.00 $5,462.48 $35,973.20 $43,039.45 $3,701.93 $83,608.62 35.86% Special Events Fund, 106 Total Cash in Bank & Investmeni $65,618.77 Peg Fund, 110 Total Revenues $113,300.00 $22,839.24 $51,090.80 $45,772.60 $0.00 $67,527.40 40.40% Total Expenditures $108,600.00 $0.00 $26,620.70 $449.00 $2,762.70 $105,388.30 2.96% Peg Fund, 110 Total Cash in Bank & Investments $599,980.64 Water & Sewer, 202 Total Revenues $21,293,219.00 $1,746,946.38 $10,589,601.44 $10,929,679.94 $0.00 $10,363,539.06 51.33% Total Expenditures $21,273,817.00 $1,419,991.82 $9,225,625.65 $9,477,743.18 $55,761.23 $11,740,312.59 44.81% Water & Sewer, 202 Total Cash in Bank & Investments $5,8175898.38 EMS, 203 Total Revenues $9,044,267.00 $1,040,221.60 $3,777,678.10 $4,404,125.46 $0.00 $4,640,141.71 48.70% Total Expenditures $8,928,351.00 $448,480.13 $3,939,125.97 $2,682,524.60 $193,490.00 $6,052,336.21 32.21% EMS, 203 Total Cash in Bank & Investments $270,925.19 Drainage, 204 Total Revenues Total Expenditures Drainage, 204 Total Cash in Bank & Investments $1,148,200.00 $97,223.91 $560,771.25 $577,982.78 $0.00 $570,217.22 50.34% $1,122,764.00 $71,913.14 $396,123.06 $463,557.68 $11,464.19 $647,742.13 42.31% $1,043,911.79 SS CH1]E1Rff7/ SERV CT ITY OPPORTUNITY 2 2 "d Quarter Financial Summary SS CH1]E1Rff7/ SERV CT ITY OPPORTUNITY 3 REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2017 .....«.>...<... .,...«..<........ >«...«....«. >< .., 2016 - 2017 .«...«..<. >.«......., «. >«. >.<. ..«..«..., >.<, ... CURRENT BUDGET CURRENT PERIOD PRIORYEAR Y -T -D ACTUAL CURRENT Y -T -D ACTUAL Y -T -D ENCUMBR BUDGET BALANCE 50% OF BUDGET Hotel Tax, 314 Total Revenues $611,452.00 $34,612.42 $234,169.45 $201,977.53 $0.00 $409,474.47 33.03% Total Expenditures $260,995.00 $19,754.63 $45,523.53 $120,143.56 $28,585.57 $112,265.87 56.99% Hotel Tax, 314 Total Cash in Bank & Investments $1,188,837.46 Park, 317 Total Revenues $185,000.00 $281.82 $94,028.02 $98,509.04 $0.00 $86,490.96 53.25% Total Expenditures $185,000.00 $0.00 $6,150.00 $4,005.00 $10,557.49 $170,437.51 7.87% Park, 317 Total Cash in Bank & Investments $439,225.70 Tree Mitigation, 319 Total Revenues $142,000.00 $4,491.77 $38,280.76 $59,188.86 $0.00 $82,811.14 41.68% Total Expenditures $142,000.00 $58.50 $140.00 $45,723.50 $36,000.00 $60,276.50 57.55% Tree Mitigation, 319 Total Cash in Bank & Investments $353,851.82 Capital Recovery Water, 411 Total Revenues $1,040,600.00 $108,435.47 $470,671.06 $643,417.34 $0.00 $397,182.66 61.83% Total Expenditures $156,000.00 $0.00 $366,594.84 $1,000.00 $186,732.71 ($31,732.71) 120.34% Capital Recovery Water, 411 Total Cash in Bank & Investm $4,016,932.95 Capital Recovery Sewer, 421 Total Revenues $625,500.00 $73,669.11 $244,794.44 $275,885.32 $0.00 $349,614.68 44.11% Total Expenditures $235,500.00 $1,361.85 $1,077.08 $2,089.27 $0.00 $233,410.73 0.89% Capital Recovery Sewer, 421 Total Cash in Bank & Investi $5,102,832.47 I &S, 505 Total Revenues $6,614,581.00 $73,456.43 $10,236,089.41 $6,129,488.15 $0.00 $485,092.85 92.67% Total Expenditures $6,614,581.00 $0.00 $8,716,064.80 $5,331,133.69 $0.00 $1,283,447.31 80.60% I &S, 505 Total Cash in Bank & Investments $2,109,931.34 SED Corporation, 620 Total Revenues $3,738,260.00 $345,471.75 $1,769,769.86 $1,805,962.14 $0.00 $1,932,297.86 48.31% Total Expenditures $2,062,617.00 $38,144.63 $745,469.32 $247,348.26 $236.61 $1,815,032.13 12.00% SED Corporation, 620 Total Cash in Bank & Investments $12,219,604.44 SS CH1]E1Rff7/ SERV CT ITY OPPORTUNITY 3 2 "d Quarter Investment Report QUARTERLY STATEMENT CHER ,,TEX- CITY OF sCHERTZ Investment Report For the Month Ending March 31st, 2017 .«+:.*.«.«.«+«.«+«*«»«+***+****« s * * * * :a +: «,.s * *.s *e. *. «. «. « + « :* 2016-2017 Beginning Book Value Deposits/ Purchases Withdrawals Interest Earned Ending Book Value Ending Mkt Value Par Value Operations - Bank Cash Total Operations $11,293,377.10 $7,406,317.91 $8,945,121.28 $449.78 $9,755,023.51 $9,755,023.51 $9,755,023.51 Total Logic $12,640,699.88 $2,000,000.00 $0.00 $10,889.14 $14,651,589.02 $14,651,589.02 $14,651,589.02 Total Lonestar $20,487,594.85 $550,000.00 $2,405,017.63 $16,301.82 $18,648,879.04 $18,648,879.04 $18,648,879.04 Total Texas Class $20,554,677.10 $1,380,000.00 $430,230.26 $17,375.04 $21,521,821.88 $21,521,821.88 $21,521,821.88 Total Capital One $3,109,351.89 $0.00 ($79.73) $2,265.78 $3,135,575.40 $3,110,067.15 $3,070,281.71 Total C.D.s 1 $3,150,379.80 $0.00 $0.00 $0.00 $3,150,379.80 $3,178,296.89 $3,150,379.80 Totals 1 $71,236,080.62 $11,336,317.91 $11,780,289.44 $47,281.56 $70,863,268.65 $70,865,677.49 $70,797,974.96 SCHHEIRUF7Z � COMMUNITY SERVICE OPPORTUNITY rd CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31st, 2017 xxx 2 0 1 6 - 2 0 1 7 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 18,720,400.00 806,433.51 13,792,026.80 14,470,014.51 4,250,385.49 77.30% Franchises 2,306,600.00 149,925.66 991,458.51 1,060,937.86 1,245,662.14 46.00% Permits 1,232,500.00 113,538.00 570,471.51 927,395.50 305,104.50 75.25% Licenses 51,160.00 6,652.50 26,119.50 34,207.50 - 16,952.50 66.86% Fees 2,251,582.00 227,589.61 1,232,727.65 1,274,431.49 977,150.51 56.60% Fines 28,000.00 2,350.56 12,154.77 11,279.78 16,720.22 40.28% Inter - Jurisdictional 879,508.00 32,103.43 396,001.67 431,152.43 448,355.57 49.02% Fund Transfers 3,642,745.00 201,312.92 806,898.26 1,207,877.48 2,434,867.52 33.16% Miscellaneous 488,700.00 45,570.85 280,418.09 273,585.89 215,114.11 55.98% TOTAL REVENUES 29,601,195 1,585,477.04 18,108,276.76 19,690,882.44 - 9,910,312.56 66.52% EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services 32,132 2,646.86 11,306.65 14,884.99 17,247.01 46.32% Supplies 1,300 (141.88) 60.24 136.78 1,163.22 10.52% City Support Services 53,500 79.48 66,883.04 33,581.20 19,918.80 62.77% Operations Support 500 - 94.85 336.04 - 163.96 67.21% Staff Support 28,910 484.70 11,412.06 18,653.89 611.21 9,644.90 66.64% Operating Equipment 640 - - 723.00 - (83.00) 112.97% TOTAL CITY COUNCIL 116,982 3,069.16 89,756.84 68,315.90 611.21 48,054.89 58.92% CITY MANAGER Personnel Services 1,076,365 90,039.00 413,742.78 485,861.80 - 590,503.20 45.14% Supplies 2,750 74.99 940.33 572.92 179.90 1,997.18 27.38% City Support Services 7,535 - - 4,989.85 - 2,545.15 66.22% Utility Services - - 114.82 65.99 - (65.99) 0.00% Staff Support 35,745 924.39 8,029.49 8,622.18 1,434.73 25,688.09 28.14% TOTAL CITY MANAGER 1,122,395 91,038.38 422,827.42 500,112.74 1,614.63 620,667.63 44.70% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31st, 2017 xxx 2 0 1 6 - 2 0 1 7 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET MUNICIPAL COURT Personnel Services 287,455 20,612.34 134,332.43 140,101.02 - 147,353.98 48.74% Supplies 2,000 - 523.32 442.35 314.85 1,242.80 37.86% City Support Services 1,000 - - 37.78 - 962.22 3.78% Operations Support 3,250 - 941.00 - - 3,250.00 0.00% Staff Support 7,310 263.81 2,323.70 978.13 1,193.34 5,138.53 29.71% Court Support 700 186.00 - 186.00 - 514.00 26.57% Professional Services 67,200 4,450.00 22,473.88 28,150.00 32,290.00 6,950.00 89.94% Maintenance Services 2,000 50.00 950.00 1,470.00 380.00 150.00 92.50% Operating Equipment - - 3,137.21 39.02 - (39.02) 0.00% TOTAL MUNICIPAL COURT 370,915 25,562.15 164,681.54 171,404.30 34,178.19 165,522.51 55.43% CUSTOMER RELATIONS -311 Personnel Services 113,744 8,556.10 53,181.64 56,626.11 - 57,117.89 49.78% Supplies 150 - 47.43 40.30 109.70 26.87% Staff Support 475 99.00 133.32 99.00 376.00 20.84% TOTAL CUSTOMER RELATIONS -311 114,369 8,655.10 53,362.39 56,765.41 - 57,603.59 49.63% PLANNING & ZONING Personnel Services 190,445 14,532.40 50,332.78 92,057.68 - 98,387.32 48.34% Supplies 3,060 31.43 388.16 270.49 115.95 2,928.07 12.63% Operations Support 150 - - 13.50 48.99 87.51 41.66% Staff Support 24,299 102.05 1,791.87 3,553.79 211.19 20,534.02 15.49% Professional Services 170 19 34 89 - 81 52.35% Operating Equipment - - - - 3,400.40 (3,400.40) 0.00% TOTAL PLANNING & ZONING 218,124 14,684.88 52,546.81 95,984.46 3,776.53 118,617.52 45.74% LEGAL SERVICES Operations Support 10,000 - 950.66 559.66 770.66 8,669.68 13.30% Professional Services 230,000 11,521.78 39,510.59 28,715.18 201,284.82 12.48% TOTAL LEGAL SERVICES 240,000 11,521.78 40,461.25 29,274.84 770.66 209,954.50 12.52% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31st, 2017 xxx 2 0 1 6 - 2 0 1 7 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET CITY SECRETARY Personnel Services 175,687 13,718.42 82,505.47 86,123.44 - 89,563.56 49.02% Supplies 1,350 153.83 (177.07) 786.71 299.00 264.29 80.42% City Support Services 12,500 - 3,914.02 2,025.03 - 10,474.97 16.20% Staff Support 6,225 404.00 2,359.93 2,430.44 306.22 3,488.34 43.96% TOTAL CITY SECRETARY 195,762 14,276.25 88,602.35 91,365.62 605.22 103,791.16 46.98% NON - DEPARTMENTAL City Support Services 658,860 40,031.25 243,001.96 276,441.94 83,549.50 298,868.56 54.64% Operations Support 141,500 (29,145.11) 75,253.56 11,395.15 5,437.32 124,667.53 11.90% Staff Support 200 - 10,000.00 165.50 - 34.50 82.75% City Assistance 1,732,157 487,775.84 756,778.19 739,817.78 252,041.94 740,297.28 57.26% Professional Services 71,135 4,149.31 39,257.76 27,559.93 29,450.00 14,125.07 80.14% Fund Chrgs /Transfrs -Spec Events Fnd 1,011,700 - - - - 1,011,700.00 0.00% Operating Equipment - - 1,874.00 - 0.00% TOTAL NON - DEPARTMENTAL 3,615,552 502,811.29 1,126,165.47 1,055,380.30 370,478.76 2,189,692.94 39.44% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31st, 2017 xxx 2 0 1 6 - 2 0 1 7 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET PUBLIC AFFAIRS Personnel Services 271,039 20,698.94 127,207.26 132,316.23 - 138,722.77 48.82% Supplies 2,300 153.47 357.46 579.74 66.15 1,654.11 28.08% Operations Support 22,450 337.28 9,292.15 5,219.90 35.98 17,194.12 23.41% Staff Support 4,000 343.00 783.44 699.00 - 3,301.00 17.48% Professional Services 24,000 4,330.00 - 22,900.00 - 1,100.00 95.42% Operating Equipment 1,000 - - - - 1,000.00 0.00% TOTAL PUBLIC AFFAIRS 324,789 25,862.69 137,640.31 161,714.87 102.13 162,972.00 49.82% RECORDS MANAGEMENT Personnel Services 52,832 1,782.06 25,455.36 22,253.71 - 30,578.29 42.12% Supplies 250 31.22 66.37 31.22 218.78 12.49% Staff Support 350 - 44.44 - - 350.00 0.00% Professional Services 12,000 1,375.90 4,368.00 4,712.55 233.28 7,054.17 41.22% Operating Equipment 250 - - - - 250.00 0.00% TOTAL RECORDS MANAGEMENT 65,682 3,189.18 29,934.17 26,997.48 233.28 38,451.24 41.46% SCHERTZ MAGAZINE Personnel Services 133,608 5,166.23 50,159.62 66,025.60 - 67,582.40 49.42% Supplies 200 - 27.50 29.49 - 170.51 14.75% Opperations Support 1,120 - - - 46.98 1,073.02 4.19% Staff Support 1,860 310.00 158.10 496.00 175.00 1,189.00 36.08% Professional Services 245,754 15,845.48 110,189.54 127,436.55 35.00 118,282.45 51.87% Fund Charges /Transfers 10,000 - - - - 10,000.00 0.00% Operating Equipment 126 - - - 125.98 0.02 99.98% TOTAL SCHERTZ MAGAZINE 392,668 21,321.71 160,534.76 193,987.64 382.96 198,297.40 49.50% ENGINEERING Personnel Services 462,286 30,608.39 90,595.64 190,333.69 - 271,952.31 41.17% Supplies 1,620 - 549.80 124.96 14.99 1,480.05 8.64% City Support Services 295 - 590.40 - - 295.20 0.00% Utility Services 3,500 126.10 180.76 282.14 3,217.86 8.06% Operations Support 2,550 35.98 - 35.98 - 2,514.02 1.41% Staff Support 9,475 99.00 1,051.48 772.79 111.00 8,591.21 9.33% Professional Services 70,800 14,205.00 495.00 27,986.40 5,795.00 37,018.60 47.71% Maintenance Services - - - - - - 0.00% Rental /Leasing 2,825 2,824.48 2,824.47 - 0.53 99.98% Operating Equipment 400 - - - - 400.00 0.00% TOTAL ENGINEERING 553,751 47,898.95 93,463.08 222,360.43 5,920.99 325,469.78 41.22% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31st, 2017 xxx 2 0 1 6 - 2 0 1 7 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET GIS 6,038,924 449,913.65 2,740,980.25 2,892,026.12 - 3,146,897.88 47.89% Personnel Services 151,979 11,567.46 68,504.15 74,470.04 - 77,508.96 49.00% Supplies 2,295 - - - 620.52 1,674.48 27.04% Staff Support 4,600 - - 931.80 - 3,668.20 20.26% Rental /Leasing 2,085 173.65 1,041.90 868.25 1,215.55 1.20 0.00% TOTAL GIS 160,959 11,741.11 69,546.05 76,270.09 1,836.07 82,852.84 48.53% TOTAL GENERAL GOVERNMENT 7,491,948 781,632.63 2,529,522.44 2,749,934.08 420,510.63 4,321,948.00 42.32% PUBLIC SAFETY POLICE Personnel Services 6,038,924 449,913.65 2,740,980.25 2,892,026.12 - 3,146,897.88 47.89% Supplies 83,973 2,840.96 18,579.22 19,710.25 54,952.34 9,310.79 88.91% City Support Services 19,081 - 19,081.45 21,294.42 - (2,213.42) 111.60% Utility Services 96,587 5,541.67 25,450.41 30,114.51 66,472.89 31.18% Operations Support 3,065 633.00 1,566.87 1,443.75 - 1,621.25 47.10% Staff Support 136,580 6,937.31 20,395.52 26,783.05 35,717.52 74,079.73 45.76% City Assistance 9,587 177.98 3,057.88 6,462.67 - 3,124.33 67.41% Professional Services 40,408 6,898.71 20,008.34 27,518.37 304.37 12,585.26 68.85% Maintenance Services 56,033 7,579.48 35,350.59 20,905.48 - 35,127.47 37.31% Rental /Leasing 46,000 44,219.48 - 44,219.48 - 1,780.52 96.13% Operating Equipment 80,676 966.26 100,315.15 20,684.46 11,684.59 48,307.00 40.12% Capital Outlay 470,652 - 199,126.25 64,535.02 351,745.30 54,372.09 88.45% TOTAL POLICE 7,081,567.49 525,708.50 3,183,911.93 3,175,697.58 454,404.12 3,451,465.79 51.26% FIRE RESCUE Personnel Services 3,541,745 273,388.93 1,547,747.90 1,731,932.61 - 1,809,812.39 48.90% Supplies 14,800 544.49 8,330.52 2,779.66 500.62 11,519.72 22.16% Utility Services 44,200 3,783.34 18,230.64 19,492.56 316.20 24,391.24 44.82% Operations Support 550 - 669.69 - - 550.00 0.00% Staff Support 138,150 8,986.13 57,502.52 84,007.78 8,715.51 45,426.71 67.12% City Assistance 18,700 1,170.54 101.49 2,557.85 - 16,142.15 13.68% Professional Services 35,200 - 275.00 - 35,200.00 0.00% Maintenance Services 48,500 6,529.32 16,512.05 12,287.94 - 36,212.06 25.34% Rental /Leasing 16,890 1,316.94 8,014.01 8,014.01 7,901.64 974.35 94.23% Operating Equipment 81,825 2,211.67 42,440.70 30,076.32 4,017.63 47,731.05 41.67% Capital Outlay 44,500 7,093.00 44,300.23 - 199.77 99.55% TOTAL FIRE RESCUE 3,985,060 305,024.36 1,699,824.52 1,935,448.96 21,451.60 2,028,159.44 49.11% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31st, 2017 MARSHAL'S OFFICE xxx 2 0 1 6 - 2 0 1 7 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET 290,339.92 230,005.87 - 218,764.13 INSPECTIONS Supplies 3,350 110.00 2,089.67 Personnel Services 541,414 41,869.55 222,564.89 271,857.72 - 269,556.28 50.21% Supplies 3,835 11.99 1,062.31 1,622.72 133.10 2,079.18 45.78% Utility Services 5,000 298.28 1,349.19 1,231.27 - 3,768.73 24.63% Operations Support 2,000 298.00 294.00 968.51 48.98 982.51 50.87% Staff Support 26,680 2,684.26 3,256.96 6,820.89 838.77 19,020.34 28.71% Professional Services 60,000 12,025.00 24,897.00 85,750.00 - (25,750.00) 142.92% TOTAL INSPECTIONS 638,929 57,187.08 253,424.35 368,251.11 1,020.85 269,657.04 57.80% MARSHAL'S OFFICE Personnel Services 448,770 33,929.24 290,339.92 230,005.87 - 218,764.13 51.25% Supplies 3,350 110.00 2,089.67 1,219.59 215.78 1,914.63 42.85% Utility Services 10,000 552.50 2,489.14 2,381.55 - 7,618.45 23.82% Operations Support 1,000 - 271.48 - 177.00 823.00 17.70% Staff Support 12,540 74.91 3,551.32 1,148.11 920.97 10,470.92 16.50% City Assistance 1,250 - - - - 1,250.00 0.00% Maintenance Services 4,700 400.00 2,531.00 800.00 - 3,900.00 17.02% Operating Equipment 4,227 - 2,697.06 2,080.74 - 2,146.26 49.22% Capital Outlay 18,000 - 70,112.00 15,403.05 - 2,596.95 85.57% TOTAL MARSHAL'S OFFICE 503,837 35,066.65 374,081.59 253,038.91 1,313.75 249,484.34 50.48% TOTAL PUBLIC SAFETY 12,209,393.49 922,986.59 5,511,242.39 5,732,436.56 478,190.32 5,998,766.61 50.87% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31st, 2017 xxx 2 0 1 6 - 2 0 1 7 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET PUBLIC ENVIRONMENT STREETS Personnel Services Supplies Utility Services Staff Support Professional Services Maintenance Services Rental /Lease Operating Equipment Capital Outlay TOTAL STREETS 741,825 95,650 149,200 9,950 31,950 42,000 2,000 12,201 142,631 1,227,407 55,595.28 2,237.40 13,546.63 1,273.00 5,037.50 3,523.01 - - 1,515.99 82,728.81 326,116.76 2,951.06 60,009.89 4,335.74 10,837.15 30,066.86 - - 434,317.46 367,092.83 16,304.74 65,541.72 4,465.47 5,037.50 21,032.94 259.00 - 6,815.99 486,550.19 - 2,881.71 - 289.97 66,667.00 390.00 483.53 227.68 88,190.07 159,129.96 374,732.17 76,463.55 83,658.28 5,194.56 (39,754.50) 20,577.06 1,257.47 11,973.32 47,624.94 581,726.85 49.49% 20.06% 43.93% 47.79% 224.43% 51.01% 37.13% 1.87% 66.61% 52.61% TOTAL PUBLIC ENVIRONMENT 1,227,407 82,728.81 434,317.46 486,550.19 159,129.96 581,726.85 52.61% PARKS & RECREATION PARKS DEPARTMENT Personnel Services 531,943 36,680.38 219,680.89 245,066.57 - 286,876.43 46.07% Supplies 34,955 1,988.04 22,337.77 10,107.09 3,728.61 21,119.30 39.58% City Support Services 6,500 1,512.36 989.00 5,575.93 647.31 276.76 95.74% Utility Services 171,200 30,378.19 64,044.89 101,933.37 57.58 69,209.05 59.57% Operations Support 700 - 606.04 551.40 - 148.60 78.77% Staff Support 10,625 752.93 2,274.23 5,327.31 1,059.41 4,746.42 60.11% Professional Services 82,500 21,867.13 31,660.42 39,439.95 3,691.50 39,368.55 52.28% Maintenance Services 26,000 4,501.70 5,766.76 15,133.44 1,928.81 8,937.75 65.62% Rental /Leasing 41,600 3,019.16 18,114.96 19,023.40 18,114.96 4,461.64 89.27% Operating Equipment 16,000 (10.47) 1,581.09 4,924.13 675.80 10,400.07 35.00% Capital Outlay 10,000 - - - - 10,000.00 0.00% TOTAL PARKS DEPARTMENT 932,023 100,689.42 367,056.05 447,082.59 29,903.98 455,544.57 51.18% SWIM POOL Supplies 21,100 1,250.93 441.98 7,823.77 1,025.10 12,251.13 41.94% Utility Services 21,000 2,135.58 4,649.59 11,633.67 - 9,366.33 55.40% Maintenance Services 675,878 40,219.20 106,500.17 44,542.82 524,835.01 22.35% TOTAL SWIM POOL 717,978 43,605.71 5,091.57 125,957.61 45,567.92 546,452.47 23.89% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31st, 2017 xxx 2 0 1 6 - 2 0 1 7 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET EVENT FACILITIES Personnel Services 59,006 4,582.57 24,892.42 28,808.40 - 30,197.60 48.82% Supplies 15,000 324.45 5,913.35 1,544.64 60.93 13,394.43 10.70% Utility Services 51,750 3,553.69 19,760.40 17,113.84 - 34,636.16 33.07% Operations Support 10,900 - 4,654.99 1,102.53 3,800.00 5,997.47 44.98% Staff Support 2,180 125.00 565.00 1,305.48 - 874.52 59.88% Operating Equipment 25,380 - 5,029.37 (1,850.61) 2,750.00 24,480.61 3.54% TOTAL EVENT FACILITIES 164,216 8,585.71 60,815.53 48,024.28 6,610.93 109,580.79 33.27% TOTAL PARKS & RECREATION 1,814,217 152,880.84 432,963.15 621,064.48 82,082.83 1,111,577.83 38.76% CULTURAL LIBRARY Personnel Services 677,981 54,914.73 327,308.40 341,447.14 - 336,533.86 50.36% Supplies 15,000 386.51 7,226.79 5,645.78 1,641.50 7,712.72 48.58% Utility Services 55,600 3,105.47 19,534.51 12,856.93 - 42,743.07 23.12% Operations Support 3,150 215.99 489.66 879.95 215.99 2,054.06 34.79% Staff Support 6,615 - 2,378.07 1,705.73 - 4,909.27 25.79% Professional Services 2,315 - 2,247.00 2,252.00 - 63.00 97.28% Operating Equipment 107,500 8,875.73 49,253.00 53,644.35 5,390.60 48,465.05 54.92% TOTAL LIBRARY 868,161 67,498.43 408,437.43 418,431.88 7,248.09 442,481.03 49.03% TOTAL CULTURAL 868,161 67,498.43 408,437.43 418,431.88 7,248.09 442,481.03 49.03% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31st, 2017 xxx 2 0 1 6 - 2 0 1 7 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET HEALTH ANIMAL SERVICES Personnel Services 320,519 24,324.95 138,944.26 157,236.40 431.70 162,850.90 49.19% Supplies 33,380 1,664.23 8,790.12 13,049.89 317.83 20,012.28 40.05% City Support Services 3,500 - - 2,052.13 - 1,447.87 58.63% Utility Services 37,500 5,274.05 13,608.00 19,739.35 - 17,760.65 52.64% Operations Support 1,000 - - 690.00 - 310.00 69.00% Staff Support 10,750 - 3,466.21 1,983.61 - 8,766.39 18.45% City Assistance 18,550 769.92 4,253.18 5,886.43 - 12,663.57 31.73% Professional Services 25,000 1,900.00 4,648.65 7,021.26 - 17,978.74 28.09% Maintenance Services 17,010 4,445.54 5,751.09 50,971.72 572.40 (34,534.12) 303.02% Operating Equipment 38,000 - 1,799.34 1,510.66 - 36,489.34 3.98% Capital Outlay 63,000 27,870.00 - 27,870.00 60,745.00 (25,615.00) 140.66% TOTAL ANIMAL SERVICES 568,209 66,248.69 181,260.85 288,011.45 62,066.93 218,130.62 61.61% ENVIRONMENTAL HEALTH Personnel Services 190,240 14,157.26 - 85,556.17 - 104,683.83 44.97% Supplies 3,505 145.91 312.56 100.00 3,092.44 11.77% Operations Support 1,800 - 43.29 - 1,756.71 2.41% Staff Support 6,550 - 2,353.49 - 4,196.51 35.93% City Assistance 1,000 - 201.47 - 798.53 20.15% Professional Services 500 176.00 176.00 - 324.00 35.20% Maintenance Services 10,600 - 2,485.00 125.00 7,990.00 24.62% Operating Equipment 5,450 - 433.44 - 5,016.56 7.95% TOTAL ANIMAL SERVICES 219,645 14,479.17 - 91,561.42 225.00 127,858.58 41.79% TOTAL HEALTH 787,854 80,727.86 181,260.85 379,572.87 62,291.93 345,989.20 56.08% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31st, 2017 xxx 2 0 1 6 - 2 0 1 7 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET INTERNAL SERVICE INFORMATION TECHNOLOGY Personnel Services 524,491 36,981.47 200,617.69 215,791.95 - 308,699.05 41.14% Supplies 7,000 531.21 573.94 1,625.50 1,837.56 3,536.94 49.47% City Support Services 519,162 75,696.15 239,627.14 235,706.88 74,548.64 208,906.48 59.76% Utility Services 227,646 16,597.20 97,988.99 91,135.76 7,199.69 129,310.55 43.20% Staff Support 34,100 5,071.99 24,867.81 15,589.70 2,303.97 16,206.33 52.47% Maintenance Services 17,580 1,366.48 6,869.88 4,772.38 3,837.23 8,970.39 48.97% Rental /Leasing 38,047 3,170.49 25,363.92 22,193.43 3,170.49 12,683.08 Operating Equipment 227,123 21,595.47 84,230.91 115,438.86 13,917.44 97,766.70 56.95% Capital Outlay 13,000 - - - - 13,000.00 0.00% TOTAL INFORMATION TECHNOLOGY 1,608,149 161,010.46 680,140.28 702,254.46 106,815.02 799,079.52 50.31% HUMAN RESOURCES Personnel Services 350,331 22,432.06 120,000.05 151,214.95 - 199,116.05 43.16% Supplies 1,000 - 716.36 188.08 - 811.92 18.81% Human Services 74,500 4,257.66 23,918.09 24,303.45 183.86 50,012.69 32.87% Operations Support 10,000 - 3,215.96 1,946.60 - 8,053.40 19.47% Staff Support 14,100 169.50 10,324.74 3,468.28 547.91 10,083.81 28.48% City Assistance 10,000 232.50 7,222.50 2,862.00 - 7,138.00 28.62% Professional Services 9,600 1,489.50 4,518.50 4,968.50 4,631.50 51.76% Operating Equipment 1,000 - 1,362.96 67.80 - 932.20 6.78% TOTAL HUMAN RESOURCES 470,531 28,581.22 171,279.16 189,019.66 731.77 280,779.57 40.33% FINANCE Personnel Services 586,957 36,853.42 244,634.52 276,703.92 - 310,253.08 47.14% Supplies 4,550 27.41 1,842.09 2,803.48 1,746.52 61.61% Operations Support 2,000 - 1,976.65 1,880.66 - 119.34 94.03% Staff Support 8,525 - 5,199.78 1,015.00 1,700.00 5,810.00 31.85% Operating Equipment - - - 59.99 - (59.99) 0.00% TOTAL FINANCE 602,032 36,880.83 253,653.04 282,463.05 1,700.00 317,868.95 47.20% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31st, 2017 xxx 2 0 1 6 - 2 0 1 7 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET PURCHASING & ASSET MGT Personnel Services 190,620 15,619.37 70,994.61 69,491.75 121,128.25 36.46% Supplies 1,050 - 255.31 104.82 945.18 9.98% Utility Services 250 - 63.66 61.50 188.50 24.60% Operations Support 100 - - 26.35 - 73.65 26.35% Staff Support 6,600 478.78 2,565.14 1,370.52 112.17 5,117.31 22.47% City Assistance 3,000 344.00 1,884.46 765.00 40.00 2,195.00 26.83% TOTAL PURCHASING & ASSET MGT 201,620 16,442.15 75,763.18 71,819.94 152.17 129,647.89 35.70% FLEET SERVICE Personnel Services 347,327 25,862.12 137,298.82 164,654.76 - 182,672.24 47.41% Supplies 157,200 24,990.12 70,996.22 88,794.21 9,584.00 58,821.79 62.58% City Support Services 6,150 - 2,244.72 2,354.40 - 3,795.60 38.28% Utility Services 6,200 640.94 1,895.51 3,255.73 2,944.27 52.51% Operations Support 200 59.69 - 59.69 - 140.31 29.85% Staff Support 10,900 1,131.13 3,603.72 3,570.70 770.28 6,559.02 39.83% Maintenance Services 120,750 14,717.58 69,825.70 85,410.20 9,238.99 26,100.81 78.38% Operating Equipment 8,200 2,097.44 7,941.49 3,122.74 108.96 4,968.30 39.41% Capital Outlay 89,000 - 88,461.00 89,000.00 0.00% TOTAL FLEET SERVICE 745,927 69,499.02 382,267.18 351,222.43 19,702.23 375,002.34 49.73% BUILDING MAINTENANCE Personnel Services 781,125 62,773.02 335,989.68 379,692.43 1,236.06 400,196.51 48.77% Supplies 68,550 14,569.53 38,971.18 55,072.39 4,834.48 8,643.13 87.39% Utility Services 189,515 14,025.90 73,008.26 57,771.67 - 131,743.33 30.48% Staff Support 14,194 952.06 5,643.68 7,440.52 403.00 6,350.48 55.26% Professional Services 48,000 - 43,784.99 - - 48,000.00 0.00% Maintenance Services 161,512 44,489.59 54,788.37 179,385.60 10,894.31 (28,767.91) 117.81% Rental /Leasing 2,250 - 1,263.27 2,210.69 - 39.31 98.25% Operating Equipment 2,700 - - - - 2,700.00 0.00% Capital Outlay 33,250 - - 25,825.70 7,424.30 77.67% TOTAL BUILDING MAINTENANCE 1,301,096 136,810.10 553,449.43 681,573.30 43,193.55 576,329.15 55.70% TOTAL INTERNAL SERVICE 4,929,355 449,223.78 2,116,552.27 2,278,352.84 172,294.74 2,478,707.42 49.72% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31st, 2017 xxx 2 0 1 6 - 2 0 1 7 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET MISC & PROJECTS CITY ASSISTANCE City's Assistance to Agencies 245,260 32,903.53 83,073.03 123,018.85 185.40 122,055.75 50.23% TOTAL CITY ASSISTANCE 245,260 32,903.53 83,073.03 123,018.85 185.40 122,055.75 50.23% COURT - RESTRICTED FUNDS Operating Equipment 19,448 - 3,924.25 357.00 1,840.00 17,251.00 11.30% TOTAL CITY ASSISTANCE 19,448 - 3,924.25 357.00 1,840.00 17,251.00 11.30% TOTAL MISC & PROJECTS 264,708 32,903.53 86,997.28 123,375.85 2,025.40 139,306.75 47.37% TOTAL EXPENDITURES 29,593,043.69 2,570,582.47 11,701,293.27 12,789,718.75 1,383,773.90 15,420,503.69 47.89% REVENUE OVER(UNDER) EXPEND. 8,151 6,901,163.69 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: MARCH 31st, 2017 xxxx 2 0 1 6 - 2 0 1 7 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Taxes 000-411100 Advalorem Tax - Current 11,203,881 120,850.12 10,226,918.93 10,938,496.60 - 265,384.40 97.63% 000 - 411200 Advalorem Tax - Delinquent 40,000 1,620.62 9,865.80 (15,187.90) - 55,187.90 - 37.97% 000 - 411300 Advalorem Tax - P &I 45,000 10,885.46 28,307.38 25,957.14 - 19,042.86 57.68% 000 - 411500 Sales Tax Revenue -Gen Fund 7,385,419 673,077.31 3,505,101.95 3,498,360.30 - 3,887,058.70 47.37% 000 - 411600 Bingo Tax 100 - 0.62 31.25 - 68.75 31.25% 000 - 411700 Mixed Beverage Tax 46,000.00 - 21,832.12 22,357.12 - 23,642.88 48.60% TOTAL Taxes 18,720,400 806,433.51 13,792,026.80 14,470,014.51 - 4,250,385.49 77.30% Franchises 000 - 421200 Center Point /Entex Energy 74,000 9,326.38 39,531.57 42,450.08 - 31,549.92 57.36% 000 - 421220 City Public Service 873,600 59,800.91 334,784.31 390,254.51 - 483,345.49 44.67% 000 - 421240 Guadalupe Valley Elec Co -op 513,000 40,988.22 211,351.55 222,092.46 - 290,907.54 43.29% 000 - 421250 New Braunfels Utilities 70,000 5,083.96 30,652.99 31,346.38 - 38,653.62 44.78% 000 - 421300 Time Warner -State Franchise 238,000 19,825.87 128,008.78 127,267.05 - 110,732.95 53.47% 000 - 421460 AT &T Franchise Fee 300,000 26,001.10 129,548.75 124,721.11 - 175,278.89 41.57% 000 - 421480 Other Telecom Franchise 100,000 (22,490.01) 49,979.19 52,345.65 - 47,654.35 52.35% 000 - 421500 Solid Waste Franchise Fee 138,000 11,389.23 67,601.37 70,460.62 - 67,539.38 51.06% TOTAL Franchises 2,306,600 149,925.66 991,458.51 1,060,937.86 - 1,245,662.14 46.00% Permits 000 - 431100 Home Occupation Permit 500 - 420.00 420.00 - 80.00 84.00% 000 - 431205 Building Permit - Residential 483,000 61,834.00 206,529.00 267,083.00 - 215,917.00 55.30% 000 - 431210 Building Permit - Commercial 170,000 2,037.00 91,217.00 357,333.00 - (187,333.00) 210.20% 000 - 431215 Building Permit - General 120,000 15,346.00 65,833.00 81,353.00 - 38,647.00 67.79% 000 - 431300 Mobile Home Permit 300 - 200.00 100.00 - 200.00 33.33% 000 - 431400 Signs Permit 7,000 220.00 3,474.00 2,072.00 - 4,928.00 29.60% 000 - 431500 Food Establishmnt Permit 60,000 1,275.00 58,365.00 54,530.00 - 5,470.00 90.88% 000 - 431600 Garage Sale Permit 10,500 1,182.00 5,235.00 4,076.00 - 6,424.00 38.82% 000 - 431700 Plumbing Permit 117,000 13,085.00 54,255.00 61,535.00 - 55,465.00 52.59% 000 - 431750 Electrical Permit 58,800 6,860.00 28,860.00 30,940.00 - 27,860.00 52.62% 000 - 431800 Mechanical Permit 59,520 6,920.00 24,980.00 29,600.00 - 29,920.00 49.73% 000 - 431900 Solicitor /Peddler Permit 1,500 60.00 80.00 64.50 - 1,435.50 4.30% 000 - 431950 Animal /Pet Permit 1,500 - - 15.00 - 1,485.00 1.00% 000 - 432000 Cert. of Occupancy Prmt 7,000 150.00 3,550.00 3,000.00 - 4,000.00 42.86% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: MARCH 31st, 2017 xxxx 2 0 1 6 - 2 0 1 7 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET 000 - 432100 Security Alarm Permit 35,000 3,100.00 16,307.00 19,206.00 - 15,794.00 54.87% 000 - 432300 Grading /Clearing Permit 4,000 100.00 3,708.51 3,323.00 - 677.00 83.08% 000 - 432400 Development Permit 81,880 - - - 000- 435000 Fire Permit 15,000 1,369.00 7,458.00 12,745.00 - 2,255.00 84.97% TOTAL Permits 1,232,500 113,538.00 570,471.51 927,395.50 - 223,224.50 75.25% Licenses 000 - 441000 Alcohol Beverage License 8,000 117.50 3,997.50 3,277.50 - 4,722.50 40.97% 000 - 441300 Mobile Home License 160 - 160.00 160.00 - - 100.00% 000 - 442000 Contractors License 40,000 6,250.00 20,460.00 29,150.00 - 10,850.00 72.88% 000 - 444000 Pet License 3,000 285.00 1,502.00 1,620.00 - 1,380.00 54.00% TOTAL Licenses 51,160 6,652.50 26,119.50 34,207.50 - 16,952.50 66.86% Fees 000 - 451000 Municipal Court Fines 884,000 91,835.45 521,569.50 418,673.47 - 465,326.53 47.36% 000 - 451100 Arrest Fee 28,053 3,097.62 18,488.67 14,495.39 - 13,557.61 51.67% 000 - 451110 Expunction Fee 60 - 30.00 90.00 - (30.00) 150.00% 000 - 451200 Warrant Fees 130,000 13,445.10 68,687.60 61,086.70 - 68,913.30 46.99% 000 - 451210 Court - Claims & Judgements - - (228.00) (291.40) - 291.40 0.00% 000 - 451340 Judicial Fee - City 3,796 437.70 2,540.13 2,023.40 - 1,772.60 53.30% 000 - 451400 Traffic Fine Costs TTL 13,492 1,446.88 8,875.87 6,925.79 - 6,566.21 51.33% 000 - 451510 Juvenile Case Mgmt Fee 31,616 3,652.62 21,167.44 16,872.02 - 14,743.98 53.37% 000 - 451520 Truancy Fee 5,342 632.75 3,675.26 2,937.17 2,404.83 54.98% 000 - 451600 Technology Fund Fee 22,932 2,945.78 17,225.89 13,625.48 - 9,306.52 59.42% 000 - 451700 Security Fee 19,448 2,209.32 12,919.41 10,219.12 - 9,228.88 52.55% 000 - 451800 Time Payment Fee - City 5,616 688.89 3,065.79 3,727.73 - 1,888.27 66.38% 000 - 451850 State Fines 10% Service Fee 40,838 - 24,449.29 18,612.49 - 22,225.51 45.58% 000 - 451900 DIPS Payment - Local 47,665 978.94 5,048.20 4,523.33 - 43,141.67 9.49% 000 - 452000 Child Safety Fee 13,522 418.11 9,336.00 2,005.71 - 11,516.29 14.83% 000 - 452100 Platting Fees 57,000 8,000.00 28,500.00 37,500.00 - 19,500.00 65.79% 000 - 452200 Site Plan Fee 30,000 5,000.00 15,500.00 16,000.00 - 14,000.00 53.33% 000 - 452300 Plan Check Fee 432,000 38,637.50 180,876.50 351,399.50 - 80,600.50 81.34% 000 - 452310 Miscellaneous Review Fee 600 - 300.00 - - 600.00 0.00% 000 - 452320 Tree Mitigation Admin Fee 12,000 746.10 6,645.00 10,187.70 - 1,812.30 84.90% 000 - 452400 BOA/Zoning Fees 2,000 1,500.00 1,000.00 2,000.00 - - 100.00% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: MARCH 31st, 2017 101 GENERAL FUND REVENUES xxxx 2 0 1 6 - 2 0 1 7 CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET 000 - 452600 Specific Use /Zone Chng Fee 12,600 - 7,300.00 13,000.00 - (400.00) 103.17% 000 - 452710 Zoning Ltr & Dev Rights 1,500 - 1,050.00 900.00 - 600.00 60.00% 000 - 453100 Reinspection Fees 45,000 8,050.00 45,530.00 55,075.00 - (10,075.00) 122.39% 000 - 453110 Swim Pool Inspection Fee 2,600 - - - - 2,600.00 0.00% 000 - 453200 Lot Abatement 5,000 - 670.84 1,325.50 - 3,674.50 26.51% 000 - 453211 Admin Fee - Inspections 6,600 800.00 5,400.00 6,200.00 - 400.00 93.94% 000 - 453310 Misc Inspection Fee 150 100.00 - - 150.00 0.00% 000 - 453710 Foster Care 1,000 200.00 550.00 550.00 - 450.00 55.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,988.00 - - - 0.00% 000 - 456120 Senior Center Meal Fee - - 864.00 401.00 - (401.00) 0.00% 000 - 456500 Haz Mat Fees 6,000 - 1,630.75 - - 6,000.00 0.00% 000 - 456600 Fire Re- inspection Fee 1,000 200.00 550.00 550.00 - 450.00 55.00% 000 - 458110 Sale of Merchandise- GovDeal 20,000 3,060.01 23,826.65 21,439.30 - (1,439.30) 107.20% 000 - 458300 Sale of Property /Auction 4,000 - 2,194.00 - - 4,000.00 0.00% 000 - 458400 Civic Center Rental Fees 175,000 21,270.00 91,548.75 85,119.00 - 89,881.00 48.64% 000 - 458401 Capital Recovery Fee -Civic Cntr 10,000 1,375.00 5,525.00 6,560.00 - 3,440.00 65.60% 000 - 458450 North Center Rental Fees 18,500 2,787.50 10,525.00 11,862.50 - 6,637.50 64.12% 000 - 458460 Senior Center Rental - 700.00 10,312.00 6,700.00 - (6,700.00) 0.00% 000 - 458500 Community Center Rental Fees 25,000 3,062.00 19,596.50 15,078.00 - 9,922.00 60.31% 000 - 458550 Pavilion Rental Fees 17,000 2,942.50 8,803.50 6,782.50 - 10,217.50 39.90% 000 - 458560 Chamber of Comm rent 7,800 - 4,100.00 3,900.00 - 3,900.00 50.00% 000 - 458650 NonResident User Fee -BVYA 15,000 - 10,120.00 1,500.00 - 13,500.00 10.00% 000 - 458660 BVYA Utility Reimbursement 13,000 3,792.84 10,092.81 17,985.79 - (4,985.79) 138.35% 000 - 458670 SYSA Utility Reimbursement 7,000 - - - - 7,000.00 0.00% 000 - 458675 Lions Futbol Utility Reimbursement 14,052 1,172.00 2,344.00 5,860.00 - 8,192.00 41.70% 000 - 458700 Vehicle Impoundment 8,000 - 2,590.00 4,880.00 - 3,120.00 61.00% 000 - 459200 NSF Check Fee 250 50.00 25.00 50.00 - 200.00 20.00% 000 - 459300 Notary Fee 250 12.00 114.00 90.00 - 160.00 36.00% 000 - 459400 Maps, Copies, UDC, & Misc F 250 - 35.00 5.00 - 245.00 2.00% 000 - 459600 Animal Adoption Fee 10,000 1,395.00 5,925.00 9,749.00 - 251.00 97.49% 000 - 459700 Pet Impoundment Fee 10,000 580.00 6,144.30 3,109.00 - 6,891.00 31.09% 000 - 459800 Police Reports Fee 5,400 468.00 2,600.00 3,146.30 - 2,253.70 58.26% TOTAL Fees 2,251,582 227,589.61 1,232,727.65 1,274,431.49 - 977,150.51 56.60% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: MARCH 31st, 2017 xxxx 2 0 1 6 - 2 0 1 7 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Fines 000 - 463000 Library Fines 28,000 2,350.56 12,154.77 11,279.78 - 16,720.22 40.28% TOTAL Fines 28,000 2,350.56 12,154.77 11,279.78 - 16,720.22 40.28% Inter - Jurisdictional 000 - 473100 Bexar Co - Fire 21,077 5,269.44 10,258.29 21,077.76 - (0.76) 100.00% 000 - 473200 City of Seguin - Fire Contract 29,231 2,435.90 14,615.40 14,615.40 - 14,615.60 50.00% 000 - 473300 Guad Co - Library 212,000 18,096.00 123,639.81 126,672.00 - 85,328.00 59.75% 000 - 473400 Randolph AFB - Animal Cntrl 1,200 - 500.00 500.00 - 700.00 41.67% 000 - 474200 Library Services - Cibolo 35,000 - 35,000.00 - - 35,000.00 0.00% 000 - 474210 Library Services -Selma 32,000 - - - - 32,000.00 0.00% 000 - 474400 Dispatch Service - Cibolo 166,000 - 80,026.00 80,000.00 - 86,000.00 48.19% 000 - 474600 School Crossing Guard - Bexar 38,500 3,185.29 16,174.78 18,085.31 - 20,414.69 46.97% 000 - 474610 School Cross Guard - Guadalupe 38,000 3,116.80 18,287.39 17,701.96 - 20,298.04 46.58% 000 - 474620 School Crossing Guard -Coma) 1,500 - - - - 1,500.00 0.00% 000 - 474700 School Officer Funding 255,000 - 85,000.00 127,500.00 - 127,500.00 50.00% 000 - 474750 Crime Victim Liaison Agreement 50,000 - 12,500.00 25,000.00 - 25,000.00 50.00% TOTAL Inter - Jurisdictional 879,508 32,103.43 396,001.67 431,152.43 - 448,355.57 49.02% Fund Transfers 000 - 480000 Indirect Costs - EMS 150,087 12,507.25 75,153.78 75,043.50 - 75,043.50 50.00% 000 - 480100 Indirect Costs - Hotel /Motel 66,405 5,533.75 - 33,202.50 - 33,202.50 50.00% 000 - 481000 Transfer In Reserves 950,000 - - - 950,000.00 0.00% 000 - 482200 Transfer - Vehicle Replcemt 43,278 - - - 43,278.00 0.00% 000 - 482300 Transfer IN -Resry Child Saf 126,345 - - - - 126,345.00 0.00% 000 - 485000 Interfund Charge- Drainage 184,425 15,368.75 27,075.00 92,212.50 - 92,212.50 50.00% 000 - 486000 Interfund Chrges -Admin W &S 1,186,812 98,901.00 576,174.98 593,406.00 - 593,406.00 50.00% 000 - 487000 Interfund Charges -Fleet 397,581 33,131.75 103,482.52 198,790.50 - 198,790.50 50.00% 000 - 488000 Interfund Charges -413 430,445 35,870.42 25,011.98 215,222.48 - 215,222.52 50.00% 000 - 489000 Transfer In 107,367 - - - - 107,367.00 0.00% TOTAL Fund Transfers 3,642,745 201,312.92 806,898.26 1,207,877.48 - 2,434,867.52 33.16% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: MARCH 31st, 2017 xxxx 2 0 1 6 - 2 0 1 7 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Miscellaneous 000 - 491000 Interest Earned 800 179.65 466.93 641.12 - 158.88 80.14% 000 - 491200 Investment Income 60,000 12,361.84 33,335.78 57,853.69 - 2,146.31 96.42% 000 - 491800 Gain /Loss - (366.21) (19,421.45) (6,337.61) - 6,337.61 0.00% 000 - 491900 Unrealized Gain /Loss - (1,321.94) 9,240.28 (11,297.74) - 11,297.74 0.00% 000 - 493120 Donations - Public Library 2,500 10.60 1,452.35 190.65 - 2,309.35 7.63% 000 - 493400 Donation - Animal Control 10,000 1,776.50 80.00 9,494.00 - 506.00 94.94% 000 - 493401 Donations -A/C Microchip 5,000 - 770.00 130.00 - 4,870.00 2.60% 000 - 493402 Donations - Spay &Neuter 15,000 92.50 6,680.50 806.50 14,193.50 5.38% 000 - 493403 Donations - Animal Adoption Trailer - - 1,639.00 102.00 - (102.00) 0.00% 000 - 493404 Donations -TNR Program 1,000 - 600.00 - - 1,000.00 0.00% 000 - 493460 Donations -Parks 4,000 - - - - 4,000.00 0.00% 000 - 493465 Donations - Senior Center - 868.30 2,970.62 5,100.36 - (5,100.36) 0.00% 000 - 493502 Donations -PD - - - 3,600.00 - (3,600.00) 0.00% 000 - 493618 Donations - Veteran's Memorial 6,000 - 5,350.67 - - 6,000.00 0.00% 000 - 494481 LawEnforcemtOfficersStnd &Ed 3,900 3,850.98 3,679.47 - 220.53 94.35% 000 - 494482 Grants - Police, Fire, Gen Fund - - 2,133.00 4,892.03 - (4,892.03) 0.00% 000 - 497000 Misc Income -Gen Fund 40,000 248.75 26,439.31 11,437.49 - 28,562.51 28.59% 000 - 497005 Schertz Magazine Advertising 190,000 17,925.00 96,450.00 104,150.00 - 85,850.00 54.82% 000 - 497100 Misc Income - Police 7,500 1,692.90 7,473.04 13,285.70 - (5,785.70) 177.14% 000 - 497150 Misc Income -Fire Department - - - 1,750.00 - (1,750.00) 0.00% 000 - 497200 Misc Income - Library 5,000 571.00 2,427.86 2,414.35 - 2,585.65 48.29% 000 - 497210 Misc Income - Library Copier 19,500 1,431.85 10,147.05 8,600.85 - 10,899.15 44.11% 000 - 497300 Misc Income - Animal Control - 45.00 295.00 390.00 - (390.00) 0.00% 000 - 497400 Misc Income - Streets Dept. 30,000 1,975.00 20,280.23 38,522.55 - (8,522.55) 128.41% 000 - 497500 Misc Income -TML Insurance 5,000 4,220.49 873.33 5,587.95 - (587.95) 111.76% 000 - 497550 Misc Income -TML Reimbursemt 20,000 2,104.17 11,610.09 3,852.43 - 16,147.57 19.26% 000 - 497600 Misc Income - Vending Mach. 2,500 146.87 1,019.14 889.84 - 1,610.16 35.59% 000 - 498000 Reimbursmnt -Gen Fund 35,000 1,608.58 15,924.99 1,944.08 - 33,055.92 5.55% 000 - 498100 Reimbursmnt Fire - Training 3,500 - 4,360.00 7.00 - 3,493.00 0.20% 000 - 498105 Reimburmnt Police - DEA - - 4,212.11 3,958.75 - (3,958.75) 0.00% 000 - 498107 Reimburmnt Police - Event - - 3,500.00 - - 0.00% 000 - 498110 Reimbursmnt Fire - Emg. Acti -O 20,000 - 26,257.28 3,267.16 - 16,732.84 16.34% 000 - 498150 Reimbursemnt - Library 2,500 - - 4,673.27 - (2,173.27) 186.93% TOTAL Miscellaneous 488,700 45,570.85 280,418.09 273,585.89 - 215,114.11 55.98% TOTAL REVENUES 29,601,195 1,585,477.04 18,108,276.76 19,690,882.44 - 9,828,432.56 66.52% GENERALFUND CASH IN BANK AND INVESTMENTS AS OF: MARCH 31st, 2017 Cash in Bank Claim on Operating Cash Pool- Checking $ 1,747,739.25 Cash in Investments LOGIC Investment - General Fund 12,925,771.12 LOGIC Investment -Equip Replacement 74,405.81 LOGIC Investment -Veh Replacement 501,701.12 LOGIC Investment -Air Condi Replacment 273,029.72 CAPITAL ONE Investment - General Fund 1,362,394.03 Total Cash in Bank & Investments $17,031,622.89 ADVALOREM TAX OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP ■2016 -17 419,931 328,521 5,447,189 2,515,077 2,106,927 120,850 ■2015 -16 360,300 303,202 4,754,503 3,709,486 888,174 211,253 50,559 54,867 27,116 21,347 10,866 8,696 ■2014 -15 357,436 356,940 4,463,962 2,741,991 1,198,153 85,775 44,720 25,398 30,488 49,777 14,839 3,787 M2013 -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 M2012 -13 292,988 636,964 3,422,107 2,180,145 637,568 177,645 29,444 49,157 11,566 20,778 8,379 7,180 Sales Tax - General Fund $800,000 $700,000 -4.6% 1.90/0 $600,000 19.9 o � 9.5 °/fl 3.2 o $500,000 -8.2° $400,000 $300,000 $200,000 $100,000 $ OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2016 -17 574,470 758,598 580,171 560,431 747,281 486,739 -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 -0-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 12013 -14 481,247 657,271 554,578 416,261 728,443 487,933 541,476 781,057 692,446 448,577 680,332 547,431 12012 -13 659,150 575,041 474,246 424,191 632,716 415,829 405,378 660,648 544,675 563,636 650,124 487,170 CITY PUBLIC SERVICE $300,000 $250,000 $200,000 $150,000 $100,000 $50,000 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP ■ 2016 -17 252,947 191,140 ■ 2015 -16 237,314 183,530 173,336 178,081 ■ 2014 -15 215,257 172,814 172,628 227,438 ■ 2013 -14 133,486 115,592 176,520 213,412 ■ 2012 -13 101,440 94,054 96,303 123,044 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31, 2017 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 106 - SPECIAL EVENTS FUND CURRENT CURRENT PRIOR CURRENT Y -T -D BUDGET 50% 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 7,379.35 31,158.78 38,866.84 - 10,033.16 79.48% TOTAL REVENUES 130,350.00 7,379.35 31,158.78 38,866.84 - 91,483.16 17.22% 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 - 11,346.18 10,912.90 - 2,087.10 83.95% Employee Appreciation Event 13,000.00 - 2,919.95 8,685.83 - 4,314.17 66.81% National Night Out 300.00 - - - - 300.00 0.00% Wilenchik Walk for Life 25,000.00 3,103.71 2,842.92 3,503.68 - 21,496.32 14.01% Schertz Sweetheart 34,250.00 1,740.93 7,770.60 3,322.35 2,956.00 27,971.65 18.33% Hal Baldwin Scholarship 20,050.00 - 9,247.75 9,047.17 - 11,002.83 45.12% Other Events 14,000.00 617.84 1,845.80 7,567.52 745.93 5,686.55 59.38% TOTAL CULTURAL 119,600.00 5,462.48 35,973.20 43,039.45 3,701.93 72,858.62 39.08% TOTAL EXPENDITURES 130,350.00 5,462.48 35,973.20 43,039.45 3,701.93 83,608.62 35.86% REVENUE OVER(UNDER) EXPEND - 1,916.87 (4,814.42) (4,172.61) (3,701.93) 7,874.54 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: MARCH 31, 2017 TOTAL REVENUES 130,350 7,379.35 31,158.78 38,866.84 - 91,483.16 29.82% ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 106 - SPECIAL EVENTS FUND CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 50 % 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 - 14.35 30.78 76.84 - (76.84) 0.00% 000 - 492200 Wilenchik Walk for Life 25,000 7,365.00 13,798.00 11,410.00 - 13,590.00 45.64% 000 - 493256 Donations - Police Events 3,000 - - - - 3,000.00 0.00% 000 - 493455 Proceeds - Festival of Angels - - 720.00 615.00 - (615.00) 0.00% 000 - 493460 Schertz Sweetheart 850 - - - - 850.00 0.00% 000 - 493621 Hal Baldwin Scholarship 20,050 - 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 7,379.35 31,158.78 38,866.84 - 10,033.16 79.48% TOTAL REVENUES 130,350 7,379.35 31,158.78 38,866.84 - 91,483.16 29.82% SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: MARCH 31, 2017 Cash in Bank Claim on Operating Cash Pool- Checking $ 48,650.84 Cash in Investments Texas Class- Special Events 16,967.93 Total Cash in Bank & Investments $ 65,618.77 110 -PEG FUND FINANCIAL SUMMARY REVENUE SUMMARY Franchises TOTAL REVENUES EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental TOTAL GENERAL GOVERNMENT MISC & PROJECTS Projects TOTAL MISC & PROJECTS TOTAL EXPENDITURES REVENUE OVER(UNDER) EXPEND CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31st, 2016 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** CURRENT CURRENT PRIOR CURRENT Y -T -D BUDGET 50% OF BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET 113,300.00 22,839.24 51,090.80 45,772.60 - 67,527.40 40.40% 113,300.00 22,839.24 51,090.80 45,772.60 - 67,527.40 40.40% - - 864.99 - 2,762.70 (2,762.70) 0.00% - - 864.99 - 2,762.70 (2,762.70) 0.00% 108,600.00 - 25,755.71 449.00 - 108,151.00 0.41% 108,600.00 - 25,755.71 449.00 - 108,151.00 0.41% 108,600.00 - 26,620.70 449.00 2,762.70 105,388.30 2.96% 4,700.00 22,839.24 24,470.10 45,323.60 (2,762.70) (37,860.90) CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: MARCH 31st, 2016 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 110 -PEG FUND CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 50 % OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Franchises 000 - 421350 Time Warner - PEG Fee 50,000 13,495.68 37,490.66 26,556.36 - 23,443.64 53.11% 000 - 421465 AT &T PEG Fee 63,300 9,343.56 13,600.14 19,216.24 - 44,083.76 30.36% TOTAL Franchises 113,300 22,839.24 51,090.80 45,772.60 - 67,527.40 40.40% TOTAL REVENUES 113,300 22,839.24 51,090.80 45,772.60 - 67,527.40 40.40% PEG FUND CASH IN BANK AND INVESTMENTS AS OF: MARCH 31st, 2016 Cash in Bank Cash Balance $ 599.980.64 Total Cash in Bank & Investments $ 599,980.64 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31, 2017 202 -WATER & SEWER CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 229,096 66,227.24 1,266,870.87 68,477 - 160,618.76 29.89% Permits - 3,118.47 45,625.33 49,563.52 - (49,563.52) 0.00% Fees 19,219,995 1,630,461.55 9,162,844.64 10,363,267 - 8,856,728.13 53.92% Fund Transfers 1,681,081 11,410.00 64,980.00 68,460 - 1,612,621.00 4.07% Miscellaneous 163,047 35,729.12 49,280.60 379,912 - (216,865.31) 233.01% TOTAL REVENUES 21,293,219 1,746,946.38 10,589,601.44 10,929,679.94 - 10,363,539.06 51.33% EXPENDITURE SUMMARY NON DEPARTMENTAL Transfer to Public Improvements 699,161 TOTAL NON DEPARTMENTAL 699,161 699,161.00 0.00% 699,161.00 0.00% BUSINESS OFFICE Personnel Services 472,754 30,772.40 216,635.63 218,702.74 - 254,051.26 46.26% Supplies 4,300 - 2,250.73 - 351.84 3,948.16 8.18% Human Services - 203.00 - 203.00 - (203.00) 0.00% City Support Services 7,375 - - 27.50 - 7,347.50 0.37% Utility Services 700 35.80 296.65 165.01 35.80 499.19 28.69% Operations Support 140,500 16,305.67 63,730.15 57,759.14 - 82,740.86 41.11% Staff Support 6,800 98.67 1,991.64 1,233.87 893.30 4,672.83 31.28% Professional Services 85,000 9,187.94 47,762.79 57,928.20 - 27,071.80 68.15% Maintenance Services 8,000 - 4,020.00 3,600.00 3,040.00 1,360.00 83.00% Operating Equipment 600 - - - 3,400.40 (2,800.40) 566.73% TOTAL BUSINESS OFFICE 726,029 56,603.48 336,687.59 339,619.46 7,721.34 378,688.20 47.84% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31, 2017 202 -WATER & SEWER CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET W & S ADMINISTRATION Maintenance Services 85,000 - - - - 85,000.00 0.00% Personnel Services 1,161,362 68,140.29 604,484.86 447,518.22 - 713,843.78 38.53% Supplies 157,500 8,353.47 112,234.58 59,249.53 23,351.60 74,898.87 52.45% Human Services - - - 337.00 - (337.00) 0.00% City Support Services 184,000 - 44,282.81 43,422.05 88.30 140,489.65 23.65% Utility Services 3,504,060 208,532.93 1,590,164.42 1,417,793.92 132.99 2,086,133.09 40.47% Operations Support 11,500 1,327.71 3,809.81 2,687.38 7.50 8,805.12 23.43% Staff Support 27,350 2,565.75 15,424.86 6,466.52 526.11 20,357.37 25.57% City Assistance 1,500 168.00 464.00 797.00 - 703.00 53.13% Professional Services 169,729 51,889.63 76,180.02 103,189.86 1,530.00 65,009.14 61.70% Fund Charges /Transfers 4,467,025 377,212.52 2,442,263.97 2,814,750.89 - 1,652,274.11 63.01% Maintenance Services 7,558,090 645,198.04 3,324,474.64 3,437,871.04 22,003.41 4,098,215.55 45.78% Other Costs 35,000 - 27,150.20 36,605.45 - (1,605.45) 104.59% Debt Service 1,578,511 - 614,139.02 743,932.97 - 834,578.03 47.13% Rental- Leasing 144,500 - 960.74 23,501.89 - 120,998.11 16.26% 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,363,388.34 8,888,938.06 9,138,123.72 48,039.89 9,817,463.39 48.34% 811RISY-11=1031x00 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 21,273,817 1,419,991.82 9,225,625.65 9,477,743.18 55,761.23 11,740,312.59 44.81% — REVENUE OVER(UNDER)EXPENSES 19,402 326,954.56 1,363,975.79 1,451,936.76 (55,761.23) (1,376,773.53) CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: MARCH 31, 2017 Permits 000 - 432400 Development Permit TOTAL Permits 3,118.47 3,118.47 45,625.33 49,563.52 - 45,625.33 49,563.52 - (49,563.52) 0.00% (49,563.52) 0.00% Fees ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6- 2 0 1 7*********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *� 202 -WATER & SEWER CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET 27,025.00 29,540.00 - (1,840.00) 106.64% 000 - 455700 Recycle Fee Revenue 284,000 24,606.51 Franchises 146,752.49 - 137,247.51 51.67% 000 - 455800 W &S Line Constructn Reimbursemnt - 2,884.00 000 - 421490 Tower Leasing 229,096 66,227.24 1,266,870.87 68,477.24 - 160,618.76 29.89% TOTAL Franchises 229,096 66,227.24 1,266,870.87 68,477.24 - 160,618.76 29.89% Permits 000 - 432400 Development Permit TOTAL Permits 3,118.47 3,118.47 45,625.33 49,563.52 - 45,625.33 49,563.52 - (49,563.52) 0.00% (49,563.52) 0.00% Fees 000 - 455200 Garbage Collection Fee 4,270,000 368,068.13 2,191,562.16 2,279,880.86 - 1,990,119.14 53.39% 000 - 455600 Fire Line Fees 27,700 - 27,025.00 29,540.00 - (1,840.00) 106.64% 000 - 455700 Recycle Fee Revenue 284,000 24,606.51 140,440.95 146,752.49 - 137,247.51 51.67% 000 - 455800 W &S Line Constructn Reimbursemnt - 2,884.00 11,360.06 14,339.90 - (14,339.90) 0.00% 000 - 457100 Sale of Water 9,306,795 676,492.15 3,975,185.16 4,393,308.90 - 4,913,486.10 47.21% 000 - 457110 Edwards Water Lease 97,000 - 81,975.30 125,531.25 - (28,531.25) 129.41% 000 - 457120 Water Transfer Charge -Selma 42,000 - 30,288.66 18,080.31 - 23,919.69 43.05% 000 - 457130 Water Transfer Charge -U. C. - - 203.11 - - - 0.00% 000 - 457140 Water Transfer Charge- Converse - - 13,527.69 - - - 0.00% 000 - 457200 Sale of Meters 90,000 10,637.00 32,167.75 46,406.00 - 43,594.00 51.56% 000 - 457400 Sewer Charges 4,900,000 526,380.02 2,541,713.77 3,184,041.92 - 1,715,958.08 64.98% 000 - 457500 Water Penalties 200,000 21,243.74 116,345.03 124,160.24 - 75,839.76 62.08% 000 - 459200 NSF Check Fee -Water &Sewer 2,500 150.00 1,050.00 1,225.00 - 1,275.00 49.00% TOTAL Fees 19,219,995 1,630,461.55 9,162,844.64 10,363,266.87 - 8,856,728.13 53.92% Fund Transfers 000 - 481000 Transfer In- Reserve 1,544,161 - - - - 1,544,161.00 0.00% 000 - 486204 Interfnd Chrg- Drainage Bill 136,920 11,410.00 64,980.00 68,460.00 - 68,460.00 50.00% TOTAL Fund Transfers 1,681,081 11,410.00 64,980.00 68,460.00 - 1,612,621.00 4.07% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: MARCH 31, 2017 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6- 2 0 1 7*********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *� 202 -WATER & SEWER CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Miscellaneous 000 - 490000 Misc Charges 500 - 398.00 279,951.71 - (279,451.71) 55990.34% 000 - 491000 Interest Earned 800 96.67 313.28 639.33 - 160.67 79.92% 000 - 491200 Investment Income 20,000 3,695.18 11,605.56 26,869.58 - (6,869.58) 134.35% 000 - 497000 Misc Income -W &S 15,000 311.66 7,584.92 9,282.12 - 5,717.88 61.88% 000 - 498110 Reimbursement -SSLGC 126,747 31,625.61 29,378.84 63,169.57 - 63,577.43 49.84% TOTAL Miscellaneous 163,047 35,729.12 49,280.60 379,912.31 - (216,865.31) 233.01% TOTAL REVENUES 21,293,219 1,746,946.38 10,589,601.44 10,929,679.94 - 10,363,539.06 51.33% WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: MARCH 31, 2017 Cash in Bank Claim on Operating Cash Pool- Checking $ 400,341.08 Cash in Investments Lone Star I nvestment-W ate r&Sewer 3,595,553.67 Lone Star Investment -W &S Customer Deposits 298,349.09 Lone Star Investment -W &S Equip Replacement 179,381.49 Lone Star Investment -W &S Veh Replacement 259,132.88 Schertz Bank & Trust - Certificate of Deposit 1,085,140.17 $ 5,417,557.30 Total Cash in Bank & Investments $ 5,817,898.38 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31, 2017 EXPENDITURE SUMMARY PUBLIC SAFETY ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 203 -EMS CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET 283,907.62 1,611,108.40 1,827,759.33 - 2,039,990.67 47.26% Supplies REVENUE SUMMARY 44,968.26 188,469.36 211,200.08 66,429.24 127,229.68 68.57% Fees 6,504,790 534,946.07 2,804,615.74 2,946,078 - 3,558,711.92 45.29% Inter - Jurisdictional 2,412,627 409,324 925,672 1,314,597 - 1,098,030.67 54.49% Miscellaneous 126,850 95,951 47,390 143,451 - (16,600.88) 113.09% TOTAL REVENUES 9,044,267 1,040,221.60 3,777,678.10 4,404,125.46 - 4,640,141.71 48.70% EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services 3,867,750 283,907.62 1,611,108.40 1,827,759.33 - 2,039,990.67 47.26% Supplies 404,859 44,968.26 188,469.36 211,200.08 66,429.24 127,229.68 68.57% Human Services - - - 238.00 - (238.00) 0.00% City Support Services 91,450 15,000.00 16,599.03 51,375.20 - 40,074.80 56.18% Utility Services 113,600 8,517.70 39,683.55 45,824.59 1,240.18 66,535.23 41.43% Operations Support 78,800 6,883.70 35,895.08 32,454.32 1,399.17 44,946.51 42.96% Staff Support 75,250 4,321.63 28,067.72 21,298.04 3,861.64 50,090.32 33.43% City Assistance 568,867 45,872.90 3,294.95 184,291.60 45,972.90 338,602.31 40.48% Professional Services 130,000 6,091.30 42,176.85 55,654.40 16,500.00 57,845.60 55.50% Fund Charges /Transfers 2,983,039 24,415.75 1,094,417.11 155,008.46 - 2,828,030.54 5.20% Maintenance Services 56,320 1,720.00 17,619.25 14,290.04 - 42,029.96 25.37% Debt Service 271,375 - 7,722.61 5,648.72 - 265,726.28 2.08% Rental- Leasing 81,541 5,795.07 34,770.42 35,349.93 34,770.42 11,420.65 85.99% Operating Equipment 125,500 986.20 24,557.64 7,621.89 15,001.45 102,876.66 18.03% Capital Outlay 80,000 - 794,744.00 34,510.00 8,315.00 37,175.00 53.53% TOTAL PUBLIC SAFETY 8,928,351 448,480.13 3,939,125.97 2,682,524.60 193,490.00 6,052,336.21 32.21% TOTAL EXPENDITURES 8,928,351 448,480.13 3,939,125.97 2,682,524.60 193,490.00 6,052,336.21 32.21% ** REVENUE OVER(UNDER) EXPENSES 115,916 591,741 (161,448) 1,721,601 (193,490) (1,412,195) CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: MARCH 31, 2017 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 203 -EMS CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Fees 000 - 456100 Ambulance /Mileage Transport 6,272,100 496,300.21 2,673,961.67 2,781,501.77 - 3,490,598.23 44.35% 000 - 456110 Subscription Program Fees 30,000 485.00 27,415.00 23,915.00 - 6,085.00 79.72% 000 - 456120 EMT Class - Fees 90,000 13,650.00 81,822.97 41,348.00 - 48,652.00 45.94% 000 - 456122 CE Class - Fees 22,000 - - - - 22,000.00 0.00% 000 - 456130 Immunization Fees 7,000 - 8,364.00 1,128.00 - 5,872.00 16.11% 000 - 456140 Billing Fees - External 25,000 2,800.36 9,089.60 10,574.36 - 14,425.64 42.30% 000 - 456150 Standby Fees 25,000 - - 19,835.45 5,164.55 79.34% 000 - 456155 Community Services Support 33,690 21,710.50 - 67,725.50 (34,035.50) 201.03% 000 - 458110 Sales of Merchandise - GovDeal - - 3,937.50 - - - 0.00% 000 - 459200 NSF Check Fee - - 25.00 50.00 - (50.00) 0.00% TOTAL Fees 6,504,790 534,946.07 2,804,615.74 2,946,078.08 - 3,558,711.92 45.29% Inter - Jurisdictional 000 - 473500 Seguin /Guadalupe Co Support 843,577 25,891.47 224,716.84 492,087.19 - 351,489.98 58.33% 000 - 474300 Cibolo Support 319,098 79,774.58 134,612.50 159,549.16 - 159,548.84 50.00% 000 - 475100 Comal Co ESD #6 100,076 27,316.41 47,425.00 71,378.91 - 28,697.09 71.32% 000 - 475200 Live Oak Support 206,956 51,739.13 101,302.72 103,478.26 - 103,477.74 50.00% 000 - 475300 Universal City Support 268,871 65,590.25 127,393.76 131,180.50 - 137,690.50 48.79% 000 - 475400 Selma Support 106,656 26,664.02 38,087.50 53,328.04 - 53,327.96 50.00% 000 - 475500 Schertz Support 504,083 126,020.97 239,820.62 252,041.94 - 252,041.06 50.00% 000 - 475600 Santa Clara Support 10,354 2,588.54 4,984.38 5,177.08 - 5,176.92 50.00% 000 - 475800 Marion Support 14,956 3,739.00 7,328.76 7,478.00 - 7,478.00 50.00% 000 - 475910 TASPP Program 38,000.00 - - 38,897.42 - (897.42) 102.36% TOTAL Inter - Jurisdictional 2,412,627 409,324.37 925,672.08 1,314,596.50 - 1,098,031 54.49% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: MARCH 31, 2017 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 203 -EMS CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Miscellaneous 000 - 491000 Interest Earned 100 9.58 25.04 51.13 - 48.87 51.13% 000 - 491200 Investment Income 750 75.53 426.11 405.37 - 344.63 54.05% 000 - 493203 Donations -EMS 2,000 - 427.00 150.00 - 1,850.00 7.50% 000 - 493205 Donations- Golf Tournament 9,000 - 940.00 - - 9,000.00 0.00% 000 - 495100 UH Grant Program 90,000 - - - - 90,000.00 0.00% 000 - 497000 Misc Income 15,000 63,786.13 39,643.56 88,133.91 - (73,133.91) 587.56% 000 - 497100 Recovery of Bad Debt 10,000 32,079.92 5,928.57 54,710.47 - (44,710.47) 547.10% TOTAL Miscellaneous 126,850 95,951.16 47,390.28 143,450.88 - (16,600.88) 113.09% TOTAL REVENUES 9,044,267 1,040,221.60 3,777,678.10 4,404,125.46 - 4,640,141.71 48.70% SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: MARCH 31, 2017 Cash in Bank Claim on Operating Cash Pool- Checking $ 181,416.41 Cash in Investments Texas Class- Tax Note 2015 Ambulances 89,508.78 Total Cash in Bank & Investments $ 270,925.19 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31, 2017 * * « * * * * * * * « * * * « * * « * * * * «* 2 0 1 6 - 2 0 1 7 * * * * * * * * * * * * * * * * * * * * * * * ** 204 - DRAINAGE CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY 301,780 33,641.34 207,885.93 225,932.54 Permits 3,000 260.00 1,400.00 1,280 1,720.00 42.67% Fees 1,141,000 95,724.43 556,721.02 569,369 571,630.81 49.90% Miscellaneous 4,200 1,239.48 2,650.23 7,334 (3,133.59) 174.61% TOTAL REVENUES 1,148,200 97,223.91 560,771.25 577,982.78 570,217.22 50.34% PUBLIC WORKS DRAINAGE Personnel Services 301,780 33,641.34 207,885.93 225,932.54 75,847.46 74.87% Supplies 3,700 76.61 1,737.58 1,438.53 52.62 2,208.85 40.30% City Support Services 8,180 - 2,703.95 4,576.16 - 3,603.84 55.94% Utility Services 13,200 1,379.44 4,874.01 6,604.90 88.70 6,506.40 50.71% Operations Support 1,000 - - - - 1,000.00 0.00% Staff Support 6,700 474.29 1,730.75 2,777.97 239.94 3,682.09 45.04% City Assistance 400 - 120.00 - - 400.00 0.00% Professional Services 52,320 - 13,000.00 1,500.00 50,820.00 2.87% Fund Charges/Transfers 428,134 35,594.50 107,286.52 213,567.00 - 214,567.00 49.88% Maintenance Services 10,000 746.96 1,108.23 1,66018 75.00 8,264.82 17.35% Other costs 200 - 100.00 100.00 - 100.00 50.00% Debt Service 120,150 - 6,327.18 5,040.40 - 115,109.60 4.20% Operating Equipment 7,000 - - 360.00 3,007.93 3,632.07 48.11% Capital Outlay - - 15,535.32 - - - 0.00% TOTAL DRAINAGE 952,764 71,913.14 362,409.47 463,557.68 3,464.19 485,742.13 49.02% 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,713.59 - 8,000.00 162,000.00 4.71% TOTAL EXPENDITURES 1,122,764 71,913.14 396,123.06 463,557.68 11,464.19 647,742.13 42.31% -- REVENUE OVER(UNDER) EXPEND 25,436 114,425.10 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: MARCH 31, 2017 k******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6- 2 0 1 7**«*********«*****«* * * * * * * * * « * * * * * * * * * * * * * * * « * * * * *; 204 - DRAINAGE CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Permits 000 - 432400 Floodplain Permit TOTAL Permits Fees 000 - 457500 Drainage Penalties 000 - 457600 Drainage Fee TOTAL Fees Miscellaneous 000 - 491000 Interest Earned 000 - 491200 Investment Interest 000 - 497000 Misc Income - Drainage TOTAL Miscellaneous 3,000 260.00 1,400.00 1,280.00 3,000 260.00 1,400.00 1,280.00 10,000 898.35 5,011.93 4,942.10 1,131,000 94,826.08 551,709.09 564,427.09 1,141,000 95,724.43 556,721.02 569,369.19 100 9.68 29.10 53.51 4,000 1,229.80 2,621.13 6,425.08 100 - - 855.00 4,200 1,239.48 2,650.23 7,333.59 -_ 1,720.00 42.67% 1,720.00 42.67% 5,057.90 49.42% -_ 566,572.91 49.91% 571,630.81 49.90% - 46.49 53.51% - (2,425.08) 160.63% -_ (755.00) 855.00% (3,133.59) 174.61% TOTAL REVENUES 1,148,200 97,223.91 560,771.25 577,982.78 - 570,217.22 50.34% DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: MARCH 31, 2017 Cash in Bank Claim on Operating Cash Pool- Checking 180,034.94 Cash in Investments Lone Star Investment - Drainage Maint Fund 863,876.85 Total Cash in Bank & Investments $ 1,043,911.79 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31, 2017 2 0 1 6 - 2 0 1 7 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 314 -HOTEL TAX CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 609,302 33,710.23 232,988.03 197,143.14 - 412,158.86 32.36% Miscellaneous 2,150 902.19 1,181.42 4,834.39 - (2,684.39) 224.86% TOTAL REVENUES 611,452 34,612.42 234,169.45 201,977.53 - 409,474.47 33.03% EXPENDITURE SUMMARY NONDEPARTMENTAL City Support Services 67,165 13,286.88 26,856.53 58,457.22 - 8,707.78 87.04% Operations Support 66,425 934.00 13,112.00 25,483.84 - 40,941.16 38.36% Professional Services 3,000 - - 3,000.00 - - 100.00% Fund Charges /Transfers 114,405 5,533.75 - 33,202.50 - 81,202.50 29.02% Maintenance Services 10,000 - 5,555.00 - 29,761.97 (19,761.97) 297.62% Operating Equipment - - - - (1,176.40) 1,176.40 0.00% TOTAL NONDEPARTMENTAL 260,995 19,754.63 45,523.53 120,143.56 28,585.57 112,265.87 56.99% TOTAL EXPENDITURES 260,995 19,754.63 45,523.53 120,143.56 28,585.57 112,265.87 56.99% REVENUE OVER(UNDER) EXPENDITURE 350,457 81,833.97 HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: MARCH 31, 2017 Cash in Bank Claim on Operating Cash Pool- Checking $ 50,562.25 Cash in Investments Texas Class - Hotel Tax 1.138.275.21 Total Cash in Bank & Investments $ 1,188,837.46 HOTEL OCCUPANCY TAX ,pou,uuu $70,000 $60,000 $50,000 $40,000 mw $30,000 $20,000 $10,000 $ OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 12016 -17 33,916.87 33,203.43 30,940.43 32,131.12 33,710.23 51,467.38 ♦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 12014 -15 44,724 42,229 35,309 33,055 46,037 58,530 43,715 43,525 53,346 72,297 51,772 39,195 12013 -14 40,023 40,709 33,342 29,778 36,680 56,699 48,081 49,579 54,858 67,329 57,399 34,297 12012 -13 35,851 39,439 32,392 32,120 31,531 49,811 39,900 39,692 54,395 61,999 51,840 34,297 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31, 2017 317 -PARK CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Parkland Dedication Fees 145,000 - 93,000.00 97,000 - 48,000.00 66.90% Miscellaneous 40,000 281.82 1,028.02 1,509 - 38,490.96 3.77% TOTAL REVENUES 185,000 281.82 94,028.02 98,509.04 - 86,490.96 53.25% EXPENDITURE SUMMARY PARKLAND DEDICATION Operating Equipment 15,000 - - 930.00 3,373.00 10,697.00 28.69% Capital Outlay 170,000 - 6,150.00 3,075.00 7,184.49 159,740.51 6.03% TOTAL PARKLAND DEDICATION 185,000 - 6,150.00 4,005.00 10,557.49 170,437.51 7.87% TOTAL EXPENDITURES 185,000 - 6,150.00 4,005.00 10,557.49 170,437.51 7.87% REVENUE OVER(UNDER) EXPEND - 94,504.04 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: MARCH 31, 2017 317 -PARK CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 50% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBRANCE BALANCE BUDGET Fees 97,000.00 000 - 458800 Parkland Dedication 145,000 TOTAL Fees 145,000 Miscellaneous 66.90% 000 - 491000 Interest Earned 250 000 - 491200 Investment Interest 1,000 000 - 497000 Misc Income - 000- 499100 Transfer From Parks Reserve 38,750 TOTAL Miscellaneous 40,000 - 93,000.00 97,000.00 - 48,000.00 66.90% - 93,000.00 97,000.00 - 48,000.00 66.90% 4.63 63.19 21.49 - 228.51 8.60% 277.19 94.71 1,487.55 - (487.55) 148.76% - 870.12 - - - 0.00% - - - - 38,750.00 0.00% 281.82 1,028.02 1,509.04 - 38,490.96 3.77% TOTAL REVENUES 185,000 281.82 94,028.02 98,509.04 - 86,490.96 53.25% PARK FUND CASH IN BANK AND INVESTMENTS AS OF: MARCH 31, 2017 Cash in Bank Claim on Operating Cash Pool- Checking $110,767.36 Cash in Investments Texas Class- Park Fund 328,458.34 Total Cash in Bank & Investments $439,225.70 319 -TREE MITIGATION FINANCIAL SUMMARY REVENUE SUMMARY Tree Mitigation Fees Fund Transfers Miscellaneous TOTALREVENUES EXPENDITURE SUMMARY TREE MITIGATION Maintenance Services -Trees TOTAL TREE MITIGATION TOTAL EXPENDITURES REVENUE OVER(UNDER) EXPEND CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31,2017 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7 CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 50% OF BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET 85,300 4,227.90 37,655.00 57,730 54,950 - - - 1,750 263.87 625.76 1,459 142,000 4,491.77 38,280.76 59,188.86 - 27,569.70 67.68% - 54,950.00 0.00% - 291.44 83.35% - 82,811.14 41.68% 142,000 58.50 140.00 45,723.50 36,000.00 60,276.50 57.55% 142,000 58.50 140.00 45,723.50 36,000.00 60,276.50 57.55% 142,000 58.50 140.00 45,723.50 36,000.00 60,276.50 57.55% - 4,433.27 38,140.76 13,465.36 (36,000.00) 22,534.64 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: MARCH 31,2017 319 -TREE MITIGATION REVENUES ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** CURRENT CURRENT PRIOR YEAR BUDGET PERIOD Y -T -D ACTUAL 2 0 1 6 - 2 0 1 7 CURRENT Y -T -D ACTUAL ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Y -T -D BUDGET 50% OF ENCUMBRANCE BALANCE BUDGET Fees 000 - 458900 Tree Mitigation 85,300 4,227.90 37,655.00 57,730.30 - 27,569.70 67.68% TOTAL Fees 85,300 4,227.90 37,655.00 57,730.30 - 27,569.70 67.68% 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 1.77 20.51 7.48 - 242.52 2.99% 000 - 491200 Investment Interest 1,500 262.10 605.25 1,451.08 - 48.92 96.74% TOTAL Miscellaneous 1,750 263.87 625.76 1,458.56 - 291.44 83.35% TOTAL REVENUES 142,000 4,491.77 38,280.76 59,188.86 - 82,811.14 41.68% TREE MITIGATION FUND CASH IN BANK AND INVESTMENTS AS OF: MARCH 31,2017 Cash in Bank Claim on Operating Cash Pool- Checking $43,255.82 Cash in Investments MBIA Investment -Tree Mitigation 310,596.00 Total Cash in Bank & Investments $353,851.82 411 - CAPITAL RECOVERY WATER FINANCIAL SUMMARY REVENUE SUMMARY Fees Fund Transfers Miscellaneous TOTALREVENUES EXPENDITURE SUMMARY CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31, 2017 ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7 ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 50% OF BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET 1,020,000 105,624.00 462,105.00 629,343 20,600 2,811.47 8,566.06 14,074 1,040,600 108,435.47 470,671.06 643,417.34 GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 156,000 TOTAL NON DEPARTMENTAL 156,000 1,000.00 1,000.00 - 390,657.00 61.70% - - 0.00% - 6,525.66 68.32% - 397,182.66 61.83% - 155,000.00 0.64% - 155,000.00 0.64% MISC & PROJECTS PROJECTS Professional Services - - - - 186,732.71 (186,732.71) 0.00% Fund Charges /Transfers - - 366,594.84 - - - 0.00% TOTAL MISC & PROJECTS - - 366,594.84 - 186,732.71 (186,732.71) 0.00% TOTAL EXPENDITURES 156,000 - 366,594.84 1,000.00 186,732.71 (31,732.71) 120.34% REVENUE OVER(UNDER) EXPENDITURES 884,600 108,435.47 104,076.22 642,417.34 (186,732.71) 428,915.37 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: MARCH 31, 2017 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7 411 - CAPITAL RECOVERY WATER CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 50% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Fees 000 - 455900 Capital Recovery - Water 1,020,000 105,624.00 462,105.00 629,343.00 - 390,657.00 61.70% TOTAL Fees 1,020,000 105,624.00 462,105.00 629,343.00 - 390,657.00 61.70% Miscellaneous 000 - 491000 Interest Earned 600 19.31 316.80 100.06 - 499.94 16.68% 000 - 491200 Investment Income 20,000 2,792.16 8,249.26 13,974.28 - 6,025.72 69.87% TOTAL Miscellaneous 20,600 2,811.47 8,566.06 14,074.34 - 6,525.66 68.32% TOTAL REVENUES 1,040,600 108,435.47 470,671.06 643,417.34 - 397,182.66 61.83% CAPITAL RECOVERY WATER CASH IN BANK AND INVESTMENTS AS OF: MARCH 31, 2017 Cash in Bank Claim on Operating Cash Pool- Checking $ 129,488.14 Cash in Investments Lone Star Investment - Capital Recovery Water 3,887,444.81 Total Cash in Bank & Investments $ 4,016,932.95 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31, 2017 2 0 1 6 - 2 0 1 7 421 - CAPITAL RECOVERY SEWER CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 600,000 70,452.00 230,001.36 268,089 - 331,911.00 44.68% Fund Transfers - - - - - - 0.00% Miscellaneous 25,500 3,217.11 14,793.08 7,796 - 17,703.68 30.57% TOTAL REVENUES 625,500 73,669.11 244,794.44 275,885.32 - 349,614.68 44.11% 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% 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% REVENUE OVER(UNDER) EXPENDITURES 390,000 72,307.26 243,717.36 273,796.05 - 421 - CAPITAL RECOVERY SEWER REVENUES Fees 000 - 455910 Capital Recovery -Waste Wtr 000 - 455913 Cap Recovery -North Sewer Tr TOTAL Fees Miscellaneous 000 - 491000 Interest Earned 000 - 491200 Investment Income 000 - 491800 Gain /Loss 000 - 491900 Unrealized Gain /Loss -Cap One TOTAL Miscellaneous CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: MARCH 31, 2017 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7 CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 50% OF BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET 600,000 65,052.00 210,201.36 257,289.00 - 5,400.00 19,800.00 10,800.00 600,000 70,452.00 230,001.36 268,089.00 500 14.02 206.37 62.15 25,000 5,183.27 22,937.41 28,598.43 - 335.94 (29,620.02) (3,532.18) - (2,316.12) 21,269.32 (17,332.08) 25,500 3,217.11 14,793.08 7,796.32 - 342,711.00 42.88% - (10,800.00) 0.00% - 331,911.00 44.68% - 437.85 12.43% - (3,598.43) 114.39% - 3,532.18 0.00% - 17,332.08 0.00% - 17,703.68 30.57% TOTAL REVENUES 625,500 73,669.11 244,794.44 275,885.32 - 349,614.68 44.11% CAPITAL RECOVERY SEWER CASH IN BANK AND INVESTMENTS AS OF: MARCH 31, 2017 Cash in Bank Claim on Operating Cash Pool- Checking $ 274,890.62 Cash in Investments Lone Star Investment - Capital Recovery Sewer 3,077,952.35 Capital One - Investment 1,749,989.50 Total Cash in Bank & Investments $ 5,102,832.47 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31, 2017 *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 505 -TAX I &S CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 6,102,433 72,477.77 5,692,365.09 6,021,413 - 81,020.41 98.67% Fund Transfers 40,860 - - - - 40,860.00 0.00% Miscellaneous 471,288 978.66 4,543,724.32 108,076 - 363,212.44 22.93% TOTAL REVENUES 6,614,581 73,456.43 10,236,089.41 6,129,488.15 - 485,092.85 92.67% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 102,500 - 83,574.23 1,550 - 100,950.00 1.51% Debt Service 6,512,081 - 4,411,781.19 5,329,584 - 1,182,497.31 81.84% Other Financing Sources - - 4,220,709.38 - - - 0.00% TOTAL GENERAL GOVERNMENT 6,614,581 - 8,716,064.80 5,331,133.69 - 1,283,447.31 80.60% TOTAL EXPENDITURES 6,614,581 - 8,716,064.80 5,331,133.69 - 1,283,447.31 80.60% '- REVENUE OVER(UNDER) EXPEND - 798,354.46 505 -TAX I & S REVENUES Taxes 000 - 411900 Property Tax Revenue TOTAL Taxes 000 - 486000 Transfer From Reserves TOTAL Fund Transfers Miscellaneous 000 - 491000 Interest Earned 000 - 491200 Investment Earnings 000 - 495015 Contribution from SED 000 - 495020 Contribution from YMCA 000 - 498000 Proceeds From Refunding Debt TOTAL Miscellaneous TOTALREVENUES CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: MARCH 31, 2017 *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** CURRENT CURRENT PRIOR YEAR CURRRENT Y -T -D BUDGET 50% OF BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET 6,102,433 72,477.77 5,692,365.09 6,021,412.59 - 81,020.41 98.67% 6,102,433 72,477.77 5,692,365.09 6,021,412.59 - 81,020.41 98.67% 40,860 - - - - 40,860.00 0.00% 40,860 - - - - 40,860.00 0.00% 500 39.90 233.58 129.35 - 370.65 25.87% 4,000 938.76 2,371.99 7,946.21 - (3,946.21) 198.66% 366,788 - 356,118.75 - - 366,788.00 0.00% 100,000 - - 100,000.00 - - 100.00% - - 4,185,000.00 - - - 0.00% 471,288 978.66 4,543,724.32 108,075.56 - 363,212.44 22.93% 6,614,581 73,456.43 10,236,089.41 6,129,488.15 - 485,092.85 92.67% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31, 2017 505 -TAX I& S *********«************* * * « * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7 ************«******** * * * * * * * « * * * * * * * * * * * * * * * * * * * * * ** GENERAL GOVERNMENT CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 50% OF NON DEPARTMENTAL BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Professional Services 101 - 541500 Paying Agent 2,500 - 1,350.00 1,550.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 - 83,574.23 1,550.00 - 100,950.00 1.51% Debt Service 101 - 555612 Bond -GO Refunding 2010 - Principal 285,000 - 275,000.00 285,000.00 - - 100.00% 101 - 555612.1 Bond -GO Refunding 2010 Interest 47,025 - 29,775.00 25,650.00 - 21,375.00 54.55% 101 - 555626 LS &D SR2006- Principal - - 394,772.50 - - - 0.00% 101 - 555626.1 LS &D SR2006- Interest - - 0.01 - - - 0.00% 101 - 555628 CO Bond 2007 - Principal - - - - - - 0.00% 101 - 555628.1 CO Bond 2007 - Interest - - 2,461.75 - - - 0.00% 101 - 555629 GO Bond 2007 - Principal 280,000 - 264,944.60 280,000.00 - - 100.00% 101 - 555629.1 GO Bond 2007 - Interest 147,945 - 82,214.00 76,821.25 - 71,123.75 51.93% 101 - 555630 GO Bond SR2008 Principal 460,000 - 440,000.00 460,000.00 - - 100.00% 101 - 555630.1 GO Bond SR2008 Interest 278,362 - 153,016.50 143,930.50 - 134,431.50 51.71% 101 - 555631 GO Bond SR2009 Principal 550,000 - 540,000.00 550,000.00 - - 100.00% 101 - 555631.1 BO Bond SR2009 Interest 266,325 - 145,387.50 137,287.50 - 129,037.50 51.55% 101 - 555633 GO SR2011 Principal 235,000 - 225,000.00 235,000.00 - - 100.00% 101 - 555633.1 GO SR2011 Interest 334,763 - 172,518.75 169,143.75 - 165,619.25 50.53% 101 - 555634 GO SR2011A Refund Principal 620,000 - 605,000.00 620,000.00 - - 100.00% 101 - 555634.1 GO SR2011A Refund Interest 102,404 - 61,861.50 54,813.25 - 47,590.75 53.53% 101 - 555635 GO SR2012 Principal 320,000 - 310,000.00 320,000.00 - - 100.00% 101 - 555635.1 GO SR2012 Interest 181,755 - 100,363.75 94,357.50 - 87,397.50 51.91% 101 - 555636 Tax Note - SR2013 - Principal 170,000 - 170,000.00 170,000.00 - - 100.00% 101 - 555636.1 Tax Note - SR2013 - Interest 3,995 - 3,400.00 2,550.00 - 1,445.00 63.83% 101 - 555637 Tax Note - SR 2013A - Principal 160,000 - 160,000.00 160,000.00 - - 100.00% 101 - 555637.1 Tax Note - SR2013 - Interest 3,185 - 3,152.51 2,112.50 - 1,072.50 66.33% 101 - 555638 Bond -GO 2014 Refund - Principal 100,000 - 100,000.00 100,000.00 - - 100.00% 101 - 555638.1 Bond -GO 2014 Refund - Interest 292,275 - 147,637.50 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 1,875.17 1,564.26 - 1,585.74 49.66% 101 - 555640 Bond -Ref 2015 Bond- Principal 450,000 - 80,000.00 450,000.00 - - 100.00% 101 - 555640.1 Bond -GO Ref 2015- Interest 102,125 - 27,056.25 53,312.50 - 48,812.50 52.20% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31, 2017 505 -TAX I& S *********«************* * * « * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7 ************«******** * * * * * * * « * * * * * * * * * * * * * * * * * * * * * ** GENERAL GOVERNMENT CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 50% 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 - - 6,859.42 - 6,923.58 49.77% 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 - 4,411,781.19 5,329,583.69 - 1,182,497.31 81.84% 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 - 8,716,064.80 5,331,133.69 - 1,283,447.31 80.60% TAX I &S CASH IN BANK AND INVESTMENTS AS OF: MARCH 31, 2017 Cash in Bank Claim on Operating Cash Pool- Checking $ 30,669.09 Cash in Investments MBIA Investment- Tax I &S 2,079,262.25 Total Cash in Bank & Investments $ 2,109,931.34 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31, 2017 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 6 - 2 0 1 7 620 -SED CORPORATION CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 50 % OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes Miscellaneous TOTAL REVENUES EXPENDITURE SUMMARY ECONOMIC DEVELOPMENT Personnel Services Supplies Human Services City Support Services Utility Services Operations Support Staff Support City Assistance Professional Services Fund Charges /Transfers Debt Service Operating Equipment TOTAL ECONO DEVELOPMENT MISC & PROJECTS PROJECTS TOTAL MISC & PROJECTS TOTAL EXPENDITURES 3,692,710 336,538.88 1,752,551.47 1,749,181.47 - 1,943,528.53 47.37% 45,550 8,932.87 17,218.39 56,780.67 - (11,230.67) 124.66% 3,738,260 345,471.75 1,769,769.86 1,805,962.14 - 1,932,297.86 48.31% - - 127,166.15 - - - 750 69.17 53.60 355.12 - 394.88 1,000 - 44.44 345.20 - 654.80 7,700 85.00 1,643.91 2,763.33 - 4,936.67 4,820 163.12 1,043.44 1,035.34 99.72 3,684.94 131,000 1,722.06 62,432.46 17,082.34 139.49 113,778.17 22,300 183.69 2,837.21 5,667.12 (2.60) 16,635.48 1,005,000 - 161.70 94.59 - 1,004,905.41 87,500 - 7,165.90 4,175.77 - 83,324.23 797,847 35,921.59 381,630.75 215,529.46 - 582,317.54 - - 3,107.25 - - - 4,700 - - 299.99 - 4,400.01 2,062,617 38,144.63 587,286.81 247,348.26 236.61 1,815,032.13 158,182.51 158,182.51 2,062,617 38,144.63 745,469.32 247,348.26 236.61 1,815,032.13 — REVENUE OVER(UNDER) EXPEND 1,675,643 307,327.12 1,024,300.54 1,558,613.88 (236.61) 117,265.73 0.00% 47.35% 34.52% 35.89% 23.55% 13.15% 25.40% 0.01% 4.77% 27.01% 0.00% 6.38% 12.00% 0.00% 0.00% 12.00% SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: MARCH 31, 2017 Cash in Bank Claim on Operating Cash Pool- Checking $ 314,508.74 Cash in Investments Texas Class Investment - Economic Development Corl 10,847,974.06 Schertz Bank & Trust - Certificate of Deposit 1,057,121.64 Total Cash in Bank & Investments $ 12,219,604.44 4B SALES TAX By Collection Month m . a�YJV,VVV $400,000 - 4.61° 1.9% Ak Jk $350,000 - 19.9 ° / LN 9 -5°/° 13.6% -8.2% - ZA $300,000 $250,000 $200,000 $150,000 $100,000 $50,000 $ OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP X2016 -17 287,235 379,299 290,086 280,216 373,641 243,369 12015 -16 239,534 372,334 264,843 246,568 391,510 265,249 265,854 307,920 284,254 261,570 12014 -15 247,750 319,452 252,513 210,669 397,691 225,482 247,025 361,702 232,983 248,121 379,939 254,153 ♦2013 -14 240,623 328,635 277,289 208,130 364,222 243,967 270,738 390,528 346,223 224,288 340,166 273,715 12012 -13 219,717 287,520 237,123 212,096 316,358 207,915 202,689 330,324 272,337 281,818 325,062 243,585 "CITY_ 1� �d * N Or"pORAT ''9 C I T Y O F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING March 31st, 2017 C I T Y O F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING March 31st, 2017 INVESTMENT POOLS Beginning Deposits/ Interest Ending Ending Par Maturity Weighted Book Value Yield Purchases Withdrawals Earned Book Value Mkt Value Value Date Avg Mat. OPERATIONS -BANK CASH Schertz Bank & Trust - Pooled Cash 10,716,235.70 0.0500 7,383,478.67 8,945,121.28 449.78 9,155,042.87 9,155,042.87 9,155,042.87 N/A Schertz Bank & Trust - PEG Fund 577,141.40 0.0000 22,839.24 - - 599,980.64 599,980.64 599,980.64 N/A TOTAL OPERATIONS 11,293,377.10 7,406,317.91 8,945,121.28 449.78 9,755,023.51 9,755,023.51 9,755,023.51 - LOGIC General Fund 10,916,359.53 1.0089 2,000,000.00 - 9,411.59 12,925,771.12 12,925,771.12 12,925,771.12 N/A 35 days G /F- Equipment Replacement 74,342.10 1.0089 - - 63.71 74,405.81 74,405.81 74,405.81 N/A 35 days G /F- Vehicle Replacement 501,271.58 1.0089 - - 429.54 501,701.12 501,701.12 501,701.12 N/A 35 days G/F -Air Conditioner Replacement 272,795.97 1.0089 - - 233.75 273,029.72 273,029.72 273,029.72 N/A 35 days SR2009 Bond- Street Projects(II) 875,930.70 1.0089 - - 750.55 876,681.25 876,681.25 876,681.25 N/A 35 days TOTAL LOGIC 12,640,699.88 2,000,000.00 - 10,889.14 14,651,589.02 14,651,589.02 14,651,589.02 - LONESTAR Capital Recovery - Sewer 2,975,574.67 0.9400 100,000.00 - 2,377.68 3,077,952.35 3,077,952.35 3,077,952.35 N/A 48 Capital Recovery - Water 3,484,652.65 0.9400 400,000.00 - 2,792.16 3,887,444.81 3,887,444.81 3,887,444.81 N/A 48 Drainage Fund 813,226.41 0.9400 50,000.00 - 650.44 863,876.85 863,876.85 863,876.85 N/A 48 Facilities Master Plan 26,118.34 0.9400 - - 20.85 26,139.19 26,139.19 26,139.19 N/A 48 GO SR2011 Animal Shelter 8,656.34 0.9400 - - 6.91 8,663.25 8,663.25 8,663.25 N/A 48 GO SR2011 Soccer Fields 163,073.22 0.9400 - - 130.16 163,203.38 163,203.38 163,203.38 N/A 48 GO SR2011 Swimming Pool 2,405,017.63 0.9400 - 2,405,017.63 1,854.20 1,854.20 1,854.20 1,854.20 N/A 48 GO SR2012 Downtown Improvements 986,452.65 0.9400 - - 787.34 987,239.99 987,239.99 987,239.99 N/A 48 SE Elevated Water Tank 2,433,690.89 0.9400 - - 1,942.46 2,435,633.35 2,435,633.35 2,435,633.35 N/A 48 Sewer /CCMA Project 2,862,170.09 0.9400 - - 2,284.45 2,864,454.54 2,864,454.54 2,864,454.54 N/A 48 W /S- Customer Deposits 298,111.15 0.9400 - - 237.94 298,349.09 298,349.09 298,349.09 N/A 48 W /S- Equipment Repl /Cap.Imp 179,238.43 0.9400 - - 143.06 179,381.49 179,381.49 179,381.49 N/A 48 Water &Sewer 3,592,686.16 0.9400 - - 2,867.51 3,595,553.67 3,595,553.67 3,595,553.67 N/A 48 W /S- Vehicle Replacement 258 926.22 0.9400 - - 206.66 259,132.88 259,132.88 259,132.88 N/A 4B- TOTAL LONESTAR 20,487,594.85 550,000.00 2,405,017.63 16,301.82 18,648,879.04 18,648,879.04 18,648,879.04 - TEXAS CLASS Tax I &S 1,078,323.49 1.0000 1,000,000.00 - 938.76 2,079,262.25 2,079,262.25 2,079,262.25 N/A 71 Days Justice Forfeiture 246,506.20 1.0000 - - 208.19 246,714.39 246,714.39 246,714.39 N/A 71 Days Park Fund 328,181.15 1.0000 - - 277.19 328,458.34 328,458.34 328,458.34 N/A 71 Days Economic Development Corporation 10,539,064.40 1.0000 300,000.00 - 8,909.66 10,847,974.06 10,847,974.06 10,847,974.06 N/A 71 Days Library Board 45,309.37 1.0000 - - 38.25 45,347.62 45,347.62 45,347.62 N/A 71 Days Tree Mitigation 310,333.90 1.0000 - - 262.10 310,596.00 310,596.00 310,596.00 N/A 71 Days Tax Note 2013 Fire Truck 4,979.62 1.0000 - - 4.19 4,983.81 4,983.81 4,983.81 N/A 71 Days Hotel Tax 1,057,379.90 1.0000 80,000.00 - 895.31 1,138,275.21 1,138,275.21 1,138,275.21 N/A 71 Days Special Events Fund 16,953.58 1.0000 - - 14.35 16,967.93 16,967.93 16,967.93 N/A 71 Days Tax Notes 2015 EMS Ambulances 89,433.25 1.0000 - - 75.53 89,508.78 89,508.78 89,508.78 N/A 71 Days Tax Notes 2015 Drainage Equipment 685,946.39 1.0000 - - 579..36 686,525.75 686,525.75 686,525.75 N/A 71 Days Tax Notes 2015 Water Equipment 284,159.21 1.0000 - - 240.01 284,399.22 284,399.22 284,399.22 N/A 71 Days Tax Notes 2015 General Fund Equipm 242,521.93 1.0000 - - 204.83 242,726.76 242,726.76 242,726.76 N/A 71 Days Tax Notes 2015A Fire Trucks & Equi 629.97 1.0000 - - 0.58 630.55 630.55 630.55 N/A 71 Days 2016 CO Roads 1,004,314.08 1.0000 - - 848.24 1,005,162.32 1,005,162.32 1,005,162.32 N/A 71 Days 2016 CO Building Repairs 173,481.21 1.0000 - - 146.52 173,627.73 173,627.73 173,627.73 N/A 71 Days 2016 CO Rea Center Windows 429,903.31 1.0000 - 430,230.26 339.00 12.05 12.05 12.05 N/A 71 Days 2016 GO Fire Station 3 4,017,256.14 1.0000 - - 3,392.97 4,020,649.11 4,020,649.11 4,020,649.11 N/A 71 Days TOTAL TEXAS CLASS 20,554,677.10 1,.380.,000.00 430,230.26 17,375.04 21,.521.,821.88 21,521,821.88 21,521,821.88 - C I T Y O F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING March 31st, 2017 Beginning INVESTMENT MANAGED ACCOUNT Book Value Yield Purchases Capital One General Fund 1,362,141.56 2.0000 - Capital One Capital Recovery Sewer 1,747,210.33 1.9500 - TOTAL CAPITAL ONE 3,109,351.89 - CERTIFICATES OF DEPOSIT SB &T- Water &Sewer 1,085,258.16 1.0000 - Schertz Economic Development Corp. 1,057,121.64 0.6000 - Schertz Economic Development Corp. 1,008,000.00 1.0000 - TOTAL C.D.s 3,150,379.80 TOTAL PORTFOLIO 1.03 Finance Director This investment portfolio represents a liquid and diverse holding by the City of Schertz. The investment strategy is to hold the monthly operating funds in the bank while investing other funds. By looking at the purpose of the funds being invested, it can be determined that it is in best interest of the City to invest in securities over 1 year to maximize yield while still maintaining all collateral and other safety requirements. This portfolio is in compliance with the City's Investment Policy and with the Public Funds Investment Act. Interest Ending Par Maturity Withdrawals Earned Book Value Mkt Value Value Date Avg Mat. 282.63 246.68 1,375,183.49 1,362,394.03 1,345,110.37 N/A 685 Days (362.36) 2,019.10 1,760,391.91 1,747,673.12 1,725,171.34 N/A 676 Days (79.73) 2,265.78 3,135,575.40 3,110,067.15 3,070,281.71 - C. D. - - 1,085,258.16 1,098,638.06 1,085,258.16 1/6/2017 Term 365 Days - - 1,057,121.64 1,059,259.05 1,057,121.64 5/28/2017 180 Days - - 1,008,000.00 1,020,399.78 1,008,000.00 1/7/2017 365 Days - - 3,150,379.80 3,178,296.89 3,150,379.80 $ 47,281.56 $70,863,268.65 $ 70, 865, 677.49 $ 70,797,974.96 86 Days Finance Director This investment portfolio represents a liquid and diverse holding by the City of Schertz. The investment strategy is to hold the monthly operating funds in the bank while investing other funds. By looking at the purpose of the funds being invested, it can be determined that it is in best interest of the City to invest in securities over 1 year to maximize yield while still maintaining all collateral and other safety requirements. This portfolio is in compliance with the City's Investment Policy and with the Public Funds Investment Act. TOTAL TEXAS CLASS 300 City Portfolio By Investment Type TOTAT. C _ n _ 260 TOTAL LOGIC 210 []Special Revenue Funds, $24,528,623 96 ❑ Debt Servi $2,079, City Portfolio By Use ■ Designated Funds, $1,653,299.47 $13,867,111.42 ® Operations, $28,737,380.39 2.50 2.00 1.50 1.00 0.50 0.00 MONTHLY YIELDS 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 ■l Month T -Bill 0.1800 0.3700 0.4300 0.4900 0.3900 0.7300 p3 Month T -Bill 0.3400 0.4800 0.5100 0.5200 0.5400 0.7500 06 Month T -Bill 0.5100 0.6100 0.6100 0.6300 0.6800 0.8900 13Schertz Portfolio 0.8000 0.8000 1.0000 1.0000 0.9551 1.0267 ■Schertz Bank &Trust 0.0500 0.0500 0.0500 0.0500 0.0500 0.0500 BCD 365 Days 0.8000 0.8000 1.0000 1.0000 1.0000 1.0000 ■CD 180 Days 0.6000 0.6000 0.6000 0.6000 0.6000 0.6000 ■LOGIC 0.8112 0.8364 1.0089 1.0089 0.9716 1.0089 13LoneStar 0.6900 0.7087 0.9400 0.9400 0.8362 0.9400 EMBIA 0.8300 0.9000 1.0000 1.0000 0.9700 1.0000 ■ Capital One 1.6900 1.6900 2.0000 2.0000 1.6900 1.9460 Capital Recovery Assets C I T Y OF S C H E R T Z Projected Investment Report Current Cash & Equivalents Due Maturity Shares Cost Mrk Value Capital One Assets Fidelity Imm Government Fund #2642 Date: 3/31/2017 15,171.34 93.00 0.61 Total Cash & Equivalents 15,171.34 General Fund 15,171.34 93.00 0.610 Federal Natl Mtg Assn 10/26/2017 209.00 125,000.00 Assets 124,917.50 1,093.00 0.87 Federal Natl Mtg Assn 1/27/2020 1032.00 50,000.00 49,963.60 50,016.50 850.00 1.70 Federal Home Ln Mtg Corp Reference Nts 11/17/2017 231.00 Projected 109,860.00 102,565.00 5,125.00 5.00 Federal Home Mtg Corp Refrnce 8 6/13/2018 439.00 100,000.00 Annual Current Cash & Equivalents Due Maturity Shares Cost Mrk Value Income Yield 3.58 Fidelity Imm Government Fund #2642 10/31/2019 944.00 40.110.37 40.110.37 40.110.37 245.00 0.61 Total Cash & Equivalents 1005.00 100,000.00 40,110.37 40,110.37 40,110.37 245.00 0.610 Fixed Income 100,000.00 103,394.53 103,233.00 2,625.00 2.54 US Treasury Note 12/15/2018 624.00 Federal Natl Mtg Assn 1/27/2020 1032.00 25,000.00 24,981.80 25,008.25 425.00 1.70 100,000.00 Federal Home IN Mtg Corp Reference 11/17/2017 231.00 100,000.00 109,860.00 102,565.00 5,125.00 5.00 99,890.63 Federal Home IN Mtg Corp Refrnce 8 6/13/2018 439.00 100,000.00 110,756.94 104,305.00 4,875.00 4.67 99,621.00 US Treasury Note 10/15/2017 198.00 40,000.00 39,913.84 39,986.00 350.00 0.88 2,000.00 US Treasury Note 10/31/2019 944.00 100,000.00 101,875.00 100,217.00 1,500.00 1.50 1.38 US Treasury Note 12/31/2019 1005.00 50,000.00 50,208.98 50,237.50 812.00 1.62 US Treasury Note US Treasury Note 8/15/2020 1233.00 100,000.00 103,394.53 103,233.00 2,625.00 2.54 3/15/2020 US Treasury Note 12/15/2018 624.00 125,000.00 126,181.64 125,086.25 1,562.00 1.25 123.00 US Treasury Note 2/28/2019 699.00 50,000.00 49,996.09 50,125.00 687.00 1.37 1, 710, 000. 00 US Treasury Note 4/30/2019 760.00 50,000.00 49,945.31 49,974.00 625.00 1.25 1,760,391.91 US Treasury Note 10/31/2019 944.00 100,000.00 99,601.56 99,621.00 1,250.00 1.25 US Treasury Note 11/30/2019 974.00 100,000.00 99,554.69 98,922.00 1,000.00 1.01 US Treasury Note 1/31/2020 1036.00 100,000.00 101,312.50 99,746.00 1,375.00 1.38 US Treasury Note 7/31/2018 487.00 75,000.00 75,791.99 75,227.25 1,031.00 1.37 US Treasury Note 10/31/2018 579.00 100,000.00 101,101.56 100,092.00 1,250.00 1.25 US Treasury Note 3/15/2020 1080.00 75,000.00 75,225.59 75,276.75 1,218.00 1.62 Upper Trinity Regl Wtr Dist Te Rev 8/1/2017 123.00 15.000.00 15,371..10 15.154.05 600.00 3.96 Total Fixed Income 1,305,000.00 1,335,073.12 1,314,776.05 26,310.00 2.000 Total Assets 732.98 1,345,110.37 1,375,183.49 1,354,886.42 26,555.00 1.968 Capital Recovery Assets Projected Annual Current Cash & Equivalents Due Maturity Shares Cost Mrk Value Income Yield Fidelity Imm Government Fund #2642 15,171.34 15.171.34 15,171.34 93.00 0.61 Total Cash & Equivalents 15,171.34 15,171.34 15,171.34 93.00 0.610 Federal Natl Mtg Assn 10/26/2017 209.00 125,000.00 124,588.38 124,917.50 1,093.00 0.87 Federal Natl Mtg Assn 1/27/2020 1032.00 50,000.00 49,963.60 50,016.50 850.00 1.70 Federal Home Ln Mtg Corp Reference Nts 11/17/2017 231.00 100,000.00 109,860.00 102,565.00 5,125.00 5.00 Federal Home Mtg Corp Refrnce 8 6/13/2018 439.00 100,000.00 110,753.60 104,305.00 4,875.00 4.67 Federal Home IN Mtg Corp 3/27/2019 726.00 100,000.00 108,297.40 104,727.00 3,750.00 3.58 US Treasury Note 10/31/2019 944.00 100,000.00 100,065.85 100,217.00 1,500.00 1.50 US Treasury Note 12/3112019 1005.00 100,000.00 100,417.97 100,475.00 1,625.00 1.62 US Treasury Note 8/15/2020 1233.00 100,000.00 103,394.53 103,233.00 2,625.00 2.54 US Treasury Note 12/15/2018 624.00 100,000.00 100,945.31 100,069.00 1,250.00 1.25 US Treasury Note 2/28/2019 699.00 100,000.00 99,992.19 100,250.00 1,375.00 1.37 US Treasury Note 4/30/2019 760.00 100,000.00 99,890.63 99,948.00 1,250.00 1.25 US Treasury Note 10/31/2019 944.00 100,000.00 99,601.57 99,621.00 1,250.00 1.25 US Treasury Note 11/30/2019 974.00 200,000.00 199,226.56 197,844.00 2,000.00 1.01 US Treasury Note 1/31/2020 1036.00 50,000.00 50,656.25 49,873.00 687.00 1.38 US Treasury Note 6/30/2018 456.00 75,000.00 75,916.99 75,225.75 1,031.00 1.37 US Treasury Note 10/31/2018 579.00 100,000.00 101,101.56 100,092.00 1,250.00 1.25 US Treasury Note 3/15/2020 1080.00 100,000.00 100,300.78 100,369.00 1,625.00 1.62 Upper Trinity Regl Wtr Dist Te Rev 8/1/2017 123.00 10.000.00 10.247.40 10.102.70 400.00 3.96 Total Fixed Income 1, 710, 000. 00 1,745,220.57 1,723,850.45 33,561.00 1.950 Total Assets 741.42 1,725,171.34 1,760,391.91 1,739,021.79 33,654.00 1.94%