The URL can be used to link to this page

Home My WebLink About7.1 2nd reading of AN ORDINANCE ADOPTING AN ANNUAL BUDGET FOR THE VILLAGE OF MOUNT PROSPECT, ILLINOIS FOR FISCAL YEAR COMMENCING JANUARY 1, 2020 AND ENDING DECEMBER 31, 2020 IN LIEU OF PASSAGE OF AN APPROPRIATION ORDINANCE4/15/2020 BoardDocs® Pro Agenda Item Details Meeting Nov 19, 2019 - REGULAR MEETING OF THE MOUNT PROSPECT VILLAGE BOARD - 7:00 p.m. Category 7. OLD BUSINESS Subject 7.1 2nd reading of AN ORDINANCE ADOPTING AN ANNUAL BUDGET FOR THE VILLAGE OF MOUNT PROSPECT, ILLINOIS FOR FISCAL YEAR COMMENCING JANUARY 1, 2020 AND ENDING DECEMBER 31, 2020 IN LIEU OF PASSAGE OF AN APPROPRIATION ORDINANCE Access Public Type Action Preferred Date Nov 19, 2019 Absolute Date Nov 19, 2019 Fiscal Impact Yes Budgeted Yes Recommended Action Approve the accompanying ordinance adopting the 2020 annual budget. Public Content Information The Village Manager's Office released the Proposed 2020 Budget on September 27, 2019. During October, the Village Board, and Finance Commission met separately and as a joint Committee of the Whole, held three public meetings to review the budget and to provide residents an opportunity to participate in the budget process. Departmental presentations were made with various staff on hand to facilitate discussion. The 2020 Budget totals $147,986,173 a reduction of $22.4M or 13.1 percent of the 2019 spending plan. The reduction in expenses is due to completion of significant capital projects. The following link will take you to the Village's proposed budget document, or visit www.mountprospect.org/budget. Proposed 2020 Budget The Public Hearing for the Budget is scheduled on November 19, 2019, at 7:00 PM and the Notice of Public Hearing was published on November 8, 2019, in Daily Herald. The ordinance and summary schedules included with this memo will officially adopt the budget for the Village of Mount Prospect. Once the ordinance is passed, the Finance Department will begin work on the final budget document. The approved budget document is scheduled to be assembled for distribution no later than December 31, 2019. Alternatives 1. Village Board approval of the Proposed 2020 Budget. 2. Action at the discretion of Village Board. Staff Recommendation https://go.boarddocs.com/il/vomp/Board.nsf/Private?open&login 1/2 4/15/2020 BoardDocs® Pro It is recommended the Village Board pass the accompanying ordinance adopting the 2020 annual budget. Administrative Content Executive Content Motion & Voting Approve the accompanying ordinance adopting the 2020 annual budget. Motion by Paul Hoefert, second by Colleen Saccotelli. Final Resolution: Motion Carries Yea: William Grossi, Eleni Hatzis, Paul Hoefert, Richard Rogers, Colleen Saccotelli, Michael Zadel https://go.boarddocs.com/il/vomp/Board.nsf/Private?open&login 2/2 ORDINANCE NO. AN ORDINANCE ADOPTING AN ANNUAL BUDGET FOR THE VILLAGE OF MOUNT PROSPECT FOR THE FISCAL YEAR COMMENCING JANUARY 1, 2020 AND ENDING DECEMBER 31, 2020 IN LIEU OF PASSAGE OF AN APPROPRIATION ORDINANCE PASSED AND APPROVED BY THE PRESIDENT AND BOARD OF TRUSTEES this day of , 2019 Published in pamphlet form by authority of the corporate authorities of the Village of Mount Prospect, Illinois this day of , 2019. ORDINANCE NO. AN ORDINANCE ADOPTING AN ANNUAL BUDGET FOR THE VILLAGE OF MOUNT PROSPECT FOR THE FISCAL YEAR COMMENCING JANUARY 1, 2020 AND ENDING DECEMBER 31, 2020 IN LIEU OF PASSAGE OF AN APPROPRIATION ORDINANCE WHEREAS, the President and Board of Trustees of the Village of Mount Prospect in accordance with State Statutes, have provided for the preparation and adoption of an Annual Budget in lieu of passage of an Appropriation Ordinance; and WHEREAS, the proposed Annual Budget for the Village of Mount Prospect for the fiscal year beginning January 1, 2020 and ending December 31, 2020, as prepared by the Budget Officer for the Village and submitted to the President and Board of Trustees, was placed on file in the Office of the Village Clerk on September 27, 2019 for public inspection, as provided by Statute; and WHEREAS, pursuant to notice duly published on November 8, 2019, a public hearing was held by the President and Board of Trustees on said tentative annual budget on November 19, 2019, as provided by Statute; and WHEREAS, following said public hearing, said proposed Annual Budget was reviewed by the President and Board of Trustees and a copy of said proposed Annual Budget is attached hereto and hereby made a part hereof. NOW, THEREFORE, BE IT ORDAINED BY THE PRESIDENT AND BOARD OF TRUSTEES OF THE VILLAGE OF MOUNT PROSPECT, COOK COUNTY, ILLINOIS: SECTION ONE: The Annual Budget for the Village of Mount Prospect for the fiscal year beginning January 1, 2020 and ending December 31, 2020, a copy of which is attached hereto and made a part hereof, is hereby approved and adopted as the Annual Budget for the Village of Mount Prospect for said fiscal year. SECTION TWO: Within thirty (30) days following the adoption of this Ordinance there shall be filed with the County Clerk of Cook County a copy thereof duly certified by the Village Clerk and Estimate of Revenues by source anticipated to be received by the Village in the fiscal year beginning January 1, 2020 and ending December 31, 2020, duly certified by the Chief Fiscal Office SECTION THREE: This Ordinance shall be in full force and effect from and after its passage, approval and publication in pamphlet form in the manner provided by law. AYES: NAYS: ABSENT: ABSTAIN: PASSED AND APPROVED this day of November, 2019. Arlene A. Juracek, Mayor ATTEST: Karen Agoranos, Village Clerk (a) Internal Services Budget includes Vehicle Maintenance Fund and Risk Management Fund. The Motor Equipment Replacement Fund and Computer Replacement Funds are included in the Village Capital Budget. (b) Pension Systems Budget includes payments made to members and beneficiaries of the Fire and Police Pension plans (defined benefit plans). Village contributions made to the Police and Fire Pension Funds are accounted for within the General Fund of the Operating Budget. (c) Pension Fund Balances are reserved for pension benefits and not available for appropriation. 2018 2019 2019 2020 2021 Actual Budget Estimate Forecast .'NX. .E E AND D III'I".'NN.....'NN. .'NN. . S .'NN. CEI 'M 1 �REVENUES .'NN..,� Property Taxes 19,223,535 19,406,000 19,253,100 19,,955y359 20,621,735 Other Taxes 1410841956 1410181000 1315311028 13p591,p375 1318111394 Licenses, Permits & Fees 3,2981693 310321000 311641180 3.,112y3OO 311781400 Intergovernmental Revenue 3314811944 3316281395 3417661709 36,p723,800 4219441390 Charges for Services 30,8201500 3310661772 3215531465 34,p304,445 3514911473 Fines & Forfeits 5911472 6161000 5611625 558..550 564,100 Investment Income (4,366,416) 8,178,400 1913541940 81539y950 818141,870 Reimbursements 3731622 2281500 4911112 391y937 391,937 Other Revenue 1113501707 1019961246 1019561765 11P142.375 1113371010 Other Financing Sources 50,313,549 21,815,000 20,936,760 4,p768..000 81250,000 Total Revenues & Other Sources IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII 15911721562 14419851313 15515691684 133,p088y091 14514051309 B1NN: N' .'NN. Ili• I. '. X] ,A IIP E Village Operating Budget 7118711048 7412671628 7411101853 76p907,462 7814101251 Village Capital Budget 1011321179 5818691932 5517551162 30p786,pOO9 3112331544 Debt Services Budget 101680,605 71P8421226 716631986 8p521,p927 819361734 Internal Services Budget (a) 1013921248 1112431120 1115641346 Ilp931,p836 1212351253 Business District Fund 115711930 11,5251000 115211600 1,p554,p095 11588,940 Prospect/Main TIF Dist Non-Op Exp 1017171521 21,8861500 213761650 605J36 208,994 Interfund Transfers 23541391 1,5401000 119661000 4p768,000 750,000 Pension Systems Budget (b) 1116441043 1211791045 1214951577 12p911,p708 1311351356 Total Expenditures IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII 12913631965 17013531451 16714541174 147p986,173 146,4991072 Excess (Deficiency) of Revenues & Other Sources Over Expenditures 2918081597 (25,368,138) (11,884,490) , , (11093,763) Start of Budget Year 190,519,804 220,328,401 220,328,401 208p44%911 193,545,829 End of Budget Year 220,328,401 194,960,263 208,443,911 19%545,829 1921452,066 Less: Pension Fund Balances ( c) 1281772,638 132,694,893 142,906,351 146p827p268 151,0891332 Available Fund Balance 91,555,763 621265,370 65,537,560 46p7l8p561 41,362,734 (a) Internal Services Budget includes Vehicle Maintenance Fund and Risk Management Fund. The Motor Equipment Replacement Fund and Computer Replacement Funds are included in the Village Capital Budget. (b) Pension Systems Budget includes payments made to members and beneficiaries of the Fire and Police Pension plans (defined benefit plans). Village contributions made to the Police and Fire Pension Funds are accounted for within the General Fund of the Operating Budget. (c) Pension Fund Balances are reserved for pension benefits and not available for appropriation. Property Taxes Other Taxes Licenses, Permits & Fees Intergovernmental Revenue Charges For Services Fines & Forfeits Investment Income Reimbursements Other Revenue Total Revenues "SIV:"I,... .Ell. IINANCING SOURCES Interfund Transfers Bond Proceeds Other Total Other Financing Sources TOTAL REVENUES AND OTHER SOURCES 2018 2019 2019 2020 2021 Actual Budget Estimate Budget Forecast 19,223,535 19,4061000 19,253,100 l9p955p359 20,621,735 1410841956 1410181000 1315311028 13o591,?375 1318111394 3,2981,693 310321000 311641180 %112o300 311781,400 3314811944 3316281395 3417661709 36,723,800 4219441390 3018201500 3310661772 3215531465 34..304..445 3514911473 591,472 616,000 561,625 558..550 564,100 (4,366,416) 8,178,400 1913541940 %539,950 8,814,870 3731622 228,500 4911112 391..937 391,937 113501707 10,996,246 1019561765 110142,?375 11337,010 10818591013 123,1701313 134,6321924 , , 137,155,309 21354,391 1,540,000 119661000 4,768,000 750,000 471283,506 1912001000 1710161000 - 715001000 6751652 1,075,000 1,954,760 - - 503131549 21,815,000 20,936,760 4p768pOOO 81250,000 159,172,562 144,985,313 155,569,684 133,088p091 145,405,309 Total Revenues and Other Sources 15911721562 14419851313 15515691684 133pO88,091 145,4051309 Total Expenditures 129136311965 17013531451 16714541174 147p986,173 146,4991072 Additions to(Use of) Fund Balance 2918081597 (25,368,138) (1118841490) (14p898,082) (11093,763) Additions to(Use of) Pension Fund Balances (81561,764) 31922,255 141133,713 3p920,917 41262,064 Additions to(Use of) Other Fund Balances 38,370,361 (29,290,393) (26,018,203) (18,r8181999) (51355,827) Additions to(Use of) Fund Balance 29,808,597 (25,368,138) (11,884,490) (14,r898,082) (11093,763) Revennditures,VIII uIII t Assets (exd�Wlhrig PensliuIIIi Fwrids) IIII IIII II II 1.J1..G 14A' "'I" A ;u I. 111,1,.1 � ,� AND.[. .. ....� u 180,000,000 160,000,000 140,000,000 120,000,000 100,000,000 80,000,000 60,000,000 40,000,000 20,000,000 2018 Actual 2019 Budget 2020 Budget 2021 Forecast kid Transfers W Bus Dist TIF Dist W Internal Services Ld Pension System W Debt CIP * Operating Budget (a) Internal Services Budget includes Vehicle Maintenance Fund and Risk Management Fund. The Motor Equipment Replacement Fund and Computer Replacement Funds are included in the Village Capital Budget. (b) Pension Systems Budget includes payments made to members and beneficiaries of the Fire and Police Pension plans (defined benefit plans). Village contributions made to the Police and Fire Pension Funds are accounted for within the General Fund of the Operating Budget. 2018 2019 2019 2020 2021 Actual Budget Estimate Budget Forecast OPERATING BUDGET PUBLIC IIw EI II1E ENT ""'I iii N 7311776 653,883 694,100 711p623 626,953 VILLAGE DII IINIISTI° TIIII II 3,719,903 31983,704 3,841,891 4J15,378 41209,863 FINANCE ILII I° ""'rEN"r 3,0721857 2,8721269 219521929 2,0033p953 21080,249 COMMUNITY DE EL. 1I) TIENT DEPAR"'ruIENT 2,9041191 31,2411391 310551350 %582p414 315881279 HUMAN SE11VICES DIIEIP II°""'rI ENT 1,1651270 1,1691936 111321082 1,198p882 112361277 PUBII IC SAFETY AND i:)iio"'FECTI N Police Department 1816951536 1910901636 1910171340 19p877..439 2013501244 Fire Department 1516011285 1614281947 1613781928 17pO62p566 1714711088 Total Public Safet and Protection 34 296 821 35 519 583 35 396 268 36 940 005 37 821 332 P U 13 1 IC WORKSDIIEI: I rm TEN""'F 2519801230 2618261862 2710381233 28,0325p2O7 2818471298 TOTAL OPERATING BUDGET 711871,048 74,267,628 74,110,853 76,?907p462 78,410,251 COMMUNrry INVES""'I"" MENT I)ROGRAM 10,13 2,179 5818691932 5517551162 , , 3112331544 DEBT IVIANAGEMEN""'r 1016801605 7,8421226 716631986 8p52lp927 819361734 IN rERINAL SERVICES BUDGE r a) 1013921248 1112431120 1115641346 11p931,836 1212351253 I)E I L Rllilll; ENtJE IFtJNDS Prospect/Main TIF Dist Non- Op Expense 10,7171521 2118861500 213761650 605J36 2081994 Business District Fund 11571,930 1115251000 115211600 1,?554pO95 11588,940 Total S ecial Revenue Funds 12 289 451 4 411 500 3 898 250 2159231 1 797 934 IN""'IIE FUND TRANSFERS 213541391 1,5401000 119661000 4p768pOOO 7501000 F ENS I '° N SYSTEMS BUDGET I) 1116441043 1211791045 1214951577 12p911p708 1311351356 TOTAL EXPENDITURES 129,363,965 170,353,451 167,454,174 147p986pl73 146,499,072 180,000,000 160,000,000 140,000,000 120,000,000 100,000,000 80,000,000 60,000,000 40,000,000 20,000,000 2018 Actual 2019 Budget 2020 Budget 2021 Forecast kid Transfers W Bus Dist TIF Dist W Internal Services Ld Pension System W Debt CIP * Operating Budget (a) Internal Services Budget includes Vehicle Maintenance Fund and Risk Management Fund. The Motor Equipment Replacement Fund and Computer Replacement Funds are included in the Village Capital Budget. (b) Pension Systems Budget includes payments made to members and beneficiaries of the Fire and Police Pension plans (defined benefit plans). Village contributions made to the Police and Fire Pension Funds are accounted for within the General Fund of the Operating Budget. REVENUES 2018 2019 2019 2020 2021 Actual Budget Estimate Budget Forecast I,;;;;;;; N I,;;;;;;;1„ I,,,,,,, .J D 58,,966;726 56,118,900 57, 748, 040 58,p666,426 59, 364, 612 I;;u 11;;;;,,, II;;; lF SI........ [IV I C E F U N I",;;u 13;137,709 51827,228 51888,228 5,F1090150 51314,846 I„ I ""I,,,,,, Al 1!! I! ,o, J 1;;;;;;;;Cm,,,I,,,,,,S I,!!!!� U N D Capital Improvement Fund 21192,544 21142,000 21119,500 2,p705,v900 11851,136 Street Improvement Construc Fund 31976,676 31771,000 31660,600 4,v714,v000 91867,736 Flood Control Construction Fund 391,415 21417,422 11813,9504..818,p3OO 622,800 675,536 Police & Fire Building Const. 33,688,743 88,000 527,000 36,v5OO - Total Capital Projects Funds 40,249,378 81418,422 81121,050 12,v274,v700 12,394,408 I,) E I I....... IR 1;;;,,,,. E I LJ E F!! L.J I" D Refuse Disposal Fund 41407,105 41371,720 41392,750 4,p374,p950 41369,950 Motor Fuel Tax Fund 11,4291563 11435,000 114451,310 l..934y350 114931,350 CDBG 3871#846 4661#971 3141219 622,800 5401800 Asset Seizure Fund 11,284 121#000 18,480 14,v500 14,500 Federal Equitable Share Funds 114 21200 2,100 2y100 2,100 DUI Fine Fund 21,978 25,500 22,015 24y3OO 25300 Foreign Fire Tax Board Fund 821027 94,000 88,650 78,p2OO 78,200 Business District Fund 11571,930 115251000 11521,600 1,p554y095 111588,940 Prospect and Main TIF District 81,0361335 101484,000 918071,260 753y5OO 886,400 Total Special Revenue Funds 1519481182 181416,391 17,612,384 9..358,p795 914437,540 N""F ,; R I R I I,;;;;;;; F L„J I' DS Water and Sewer Fund 141493,771 25,940,700 25,536,080 16p396,940 27,030,570 Village Parking System Fund 189,759 192,600 198,950 197,600 195,160 Parking System Revenue Fund 158,153 158,200 161,560 160,350 161,350 Total Enterprise Funds 14,841,683 26,291,500 25,896,590 16,p754..89 27,387,080 I ,,,,,III,,,,,, E 11 IIS E 11V I C E Ilf,,,,,, LJ IS D . Vehicle Maintenance Fund 21048,933 21052,358 21052,358 2p526,0488 21383,977 Vehicle Replacement Fund 11841,672 21337,100 21320,100 1p942y560 11942,560 Computer Replacement Fund 211,865 166,897 162,897 159..979 163,978 Risk Management Fund 81844,135 91255,217 91138,747 9,462,478 91618,888 Total Internal Service Funds 12,946,605 13,811,572 13,674,102 14..091..50 141109,403 1`IDUCIA1„IY F1, JNDS Police Pension Fund 8771259 81419,500 13,677,930 8p828,375 91017,350 Fire Pension Fund 21205,020 71681,800 12,951,360 8pOO4..250 81380,070 Total Fiduciary Funds 31082,279 16,101,300 26,629,290 16,832,625 17,397,420 TOTAL REVENUES & OTHER SOURCES 159,172,562 144,985,313 155,569,684 133,088y091 145,405,309 2018 2019 2019 2020 2021 Actual Budget Estimate Budget Forecast 1,;;;;;;; I' 1,;;;;;;;1„ 1,,,,,,, J N D 55, 308,129 58,034, 709 58,322,540 62J10,p625 581925,922 1I'.. 11;;;;;;; II;;; "F S 1;;;;; [IV I C 1;;;;;;; F U ID 91171,399 6726407 6 646 717 6,p565,p732 61694,902 CAI!!) I "I,,,,,, Al....... 1„m[I OJ 1;;;;;;; Cm'FS U N D Capital Improvement Fund 11477,194 31463,440 21729,706 3,p369,p272 21426,146 Street Improvement Construc Fund 21616,298 41677,000 41677,000 4..090,pOOO 91952,000 Flood Control Construction Fund 4681596 41221,500 3,921,683 4,v513,v701 61760,711 Police & Fire Building Const. 11968,563 24,936,982 23,7661662 8,J02,p400 - Total Capital Projects Funds 61530,651 37,298,922 35,0951051 20,v075,p373 19,138,857 I,,,° E I 1....... IR 1;;,,,,. V 1;;,,,,, N L.J 1;;;,;, I.... , 1' D Refuse Disposal Fund 41528,996 41557,185 41727,988 41782..743 41920,958 Motor Fuel Tax Fund 11742,901 210851173 1119671,173 2,v226,376 114870,402 CDBG 387,848 4661#971 3141219 622,p8OO 540,800 Asset Seizure Fund 42,936 34,000 23,500 7;,000 7,000 Federal Equitable Share Funds - 21000 114000 11,000 1,000 DUI Fine Fund 251531 21,500 - 2,v000 - Foreign Fire Tax Board Fund 361220 68,000 68,000 68,000 68,000 Business District Fund 11,5711930 11525,000 111521,600 l..554..095 1115881P940 Prospect and Main TIF District 111282,431 1110341238 101#859,113 2,v518,r573 114460,245 Total Special Revenue Funds iiiiiiiiiiiiiiiiiiiiiillillillillillillilliillillilillillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillillillillillillillillillillillillillilliillillillillillillilliilillilI 19,618,793 191794,067 191482,593 11y782,p587 10,457345 EN""FERPRISE F L„J 11, Water and Sewer Fund 15,4141518 22,323,072 21,567,390 20,0776j,566 221297,500 Village Parking System Fund 133,295 186,101 213,503 277p458 172,692 Parking System Revenue Fund 178,443 155,108 156,556 162y310 165,267 Total Enterprise Funds 15,726,256 22,664,281 21,937,449 21,216,334 22,635,459 1 IIIA,,,,,111,,,,,,EII N A IL S E 11V 1E III,,,, L.J IIIA D Vehicle Maintenance Fund 21240,781 21034,247 21059,657 2..326y536 21383,977 Vehicle Replacement Fund 8121112 11925,000 11434,901 1p202y000 31076,000 Computer Replacement Fund 160,334 487,900 475,000 189y978 199,978 Risk Management Fund 81151,467 91208,873 91504,689 9..605y3OO 91851,276 Total Internal Service Funds 11,364,694 13,656,020 13,474,247 13.323,814 15,511,231 1,,,, IDLJCIAFIY H,,,J JNDS Police Pension Fund 51572,210 51985,209 61016,054 6,302y574 61367,739 Fire Pension Fund 61071,833 61193,836 61479,523 6,609y134 61767,617 Total Fiduciary Funds 11,644,043 121179,045 121495,577 12,911p708 13,135,356 TOTAL EXPENDITURES 129,363,965 170,353,451 167,454,174 147,p986,173 146,499,072 � � � ,;„ ;FUND::�Ex..1,1, ,� � . 11A. 10 R FUND) 2018 2019 2019 2,02O 2021 % Change Actual Budget Estimate Budget Forecast 19 to 20 00.1 nei°aIIII Fun Revenues 26,7071033 2716631,030 27,6791687 28,9951539 2919591084 4.8% Property Taxes 1613681959 16,498,000 16,386,100 1 6..66911 09 161999,789 1.0% Other Taxes 8,1861048 8,0331000 7,7111700 7..630,780 716751236 -5.0% Licenses, Permits & Fees 116761703 113621000 15411730 1,4751800 115251400 8.4% Intergovernmental Revenue 2915911851 27,872,000 29,677,280 3013,50;,250 3016161950 8.9% Charges For Services 1,1541134 1,2091000 1,2181000 1382,500 11387500 14.4% Fines & Forfeits 4081247 432,000 361,060 362.550 372,100 -16.1% Investment Income 3181490 266,100 345,700 2,66..000 264500 0.0% Reimbursements 2241467 190500 2321612 287.J 287,137 50.7% Other Revenue 4701465 256300 273,858 2421300 2361000 -5.5% Other Financing Sources 5671362 - - 52,855 - +++ Revenues Total 58,966,726 56,118,900 57,748,040 58,0666,426 59,3641612 4.5% Expenses Personal Services, Salaries & Wages 26,7071033 2716631,030 27,6791687 28,9951539 2919591084 4.8% Employee Benefits 14,933,169 141484,814 1415201338 11 5133 71489 1516801647 5.7% Other Employee Costs 402,395 5801876 5561536 595,?092 6051255 2.4% Pension Benefits 51819 51819 5,819 6,' ,m" 4' 61174 6.1% Contractual Services 713831175 8118511768 811666,919 911,02,463 911041630 2.8% Utilities 228,650 3261724 3221982 341,203 3461313 4.4% Insurance 469,053 5491118 5491118 ,535 6281535 14.5% Commodities & Supplies 673,255 8421905 8341883 888,931,2 9051946 5.5% Other Expenditures 112881775 11038,741 1,142,841 31,'1, 01537 101747 -89.4% Building Improvements 392 81,250 121000 11,2 1 121000 45.5% Office Equipment 26,688 50,430 431530 52,855 501792 4.8% Other Equipment 243,850 3151934 2451587 280,910 2931573 -11.1% Infrastructure 5911,484 1147761300 111776,300 3 101 0,9205721226 -43.1% Interfund Transfers 2,354,391 11540,000 1,966,000 All%p768,000 750,000 209.6% Expenses Total 55,308,129 58,034,709 58,322,540 62, , '° 5 58,925,922 7.0% Excess (Deficiency) of Revenues & Other Sources Over Expenditures Fund Balance, Beginning of Year Fund Balance, End of Year Fund Balance % of Subsequent Year Expenditures Recommended Fund Balance From To 3,658,597 (1,915,809) (574,500) (31444, 99) 438,690 79.8% 19,178,905 22,837,502 22,837,502 22,263,002 18,818,803 22,837,502 20,921,693 22,263,002 18,818,803 19,257,493 39% 34% 36% 32�% 32% 11, 664, 508 12, 422,125 12, 422,125 .1 .1,. 785, 1 1Z138,740 17, 496, 762 18, 633,188 18, 633,188 .1, 7,.677,.777' 18, 208,110 B DE urr „1 M1„ mo G " E OM1. .. . „. 1' D (MAJOI? FV. �; I I I"ry liND PE:: GENEIZA.1 FIND Summary of Revenues, Expenditures, and Fund Balance 2018 - 2021 70,000,000 60,000,000 50,000,000 40,000,000 30,000,000 20,000,000 10,000,000 2018 2019 Est 2020 2021 Revenues 111xpenses Fund B Il in c e EXPENDITURES BY FUNCTION AND ACCOUNT CLASSIFICATION The preceding schedule and graphic summarized the fund revenues and expenses by account type/classification. The Budget Summaries section of this document classifies the Village's revenue identically. The expenses in the Budget Summaries section, however, are split between operating and non-operating expenses. The operating expenses are presented at a departmental level. The non-operating expenses are categorized as CIP (Community Investment Program), Debt Service, Other Expenditures, and Pensions. The matrix at the end of the Budget Summaries section serves as a bridge between the two ways of viewing the budget. For the two major funds, both the General Fund and the Water and Sewer Fund, expenditures in this section will be presented both ways so the reader can view the fund's expenditures by account type/classification at the fund level and also at the function/department level. The schedule on the following page breaks down the operating expenditures on a departmental basis by account classification. The non-operating are summarized by CIP, Debt, and Other Expenditures. BUI 'J'N )G1.411111 q m GN E 11 A 11, FU' N D VIMm ... . . : GIF ND 1 1 1 J'N 1) 1111 . ...... . .... (1111AJOR FUND) E`xpenditures , Function and Account Classification 2018 2019 2019 202 2021 % Change Actual Budget Estimate Budget Forecast 19 to 20 1,,, . . e line iiira ll 11:°°u n 1,361,391 11433,488 11435,832 3,,,,53 , 1,,,3 11593,392 7.4% 001- General Fund 807,984 693,393 681,827 747,609 765,618 7.8% Operating 66,621 108,962 97,162 3 3 3,?386 114,400 4.1% Public Representation 1,413,552 11656,135 11537,295 .1,,.1 8.,407 11640,197 -2.3% Personal Services, Salaries & Wages 196,836 26,850 26,850 2.6, 5 26,915 0.0% Employee Benefits 55,076 2,059 21059 2,?059 21065 0.0% Other Employee Costs 2,964 8,000 71500 " ,?000 71000 -12.5% Contractual Services 413,260 437,526 478,303 494,?848 508,602 13.1% Utilities 787 458 458 458 458 0.0% Commodities & Supplies 59,109 72,990 72,930 74,0288 75,671 1.8% Other Expenditures 3,744 106,000 106,000 3,,, 6,,,,2 61242 0.1% Public Representation Total 731,776 653,883 694,100 '73 ,,,1..., 2.3 626,953 8.8% Village Administration Personal Services, Salaries & Wages 1,361,391 11433,488 11435,832 3,,,,53 , 1,,,3 11593,392 7.4% Employee Benefits 807,984 693,393 681,827 747,609 765,618 7.8% Other Employee Costs 66,621 108,962 97,162 3 3 3,?386 114,400 4.1% Contractual Services 1,413,552 11656,135 11537,295 .1,,.1 8.,407 11640,197 -2.3% Utilities 11,359 12,835 12,535 1 3,9668 13,684 6.5% Insurance 17,018 20,050 20,050 22,?961 22,961 14.5% Commodities & Supplies 12,650 17,611 16,960 3 8,?19918,371 38,465 3.3% Office Equipment 15,472 16,230 16,230 1,6,235 16,240 0.0% Other Equipment 13,856 25,000 24,000 25,?000 25,000 0.0% Village Administration Total 31F719,903 31983,704 3,841,891 4j 3 5,?378 4,209,863 3.3% Finance Personal Services, Salaries & Wages 810,703 851,913 851,913.1 6j54 947,864 7.5% Employee Benefits 3041610 2891883 300,045 33m"",m"" m"" m"" 3471843 16.5% Other Employee Costs 15,945 33,872 33,853 33,?965 34,160 0.3% Contractual Services 255,409 326,434 293,041 289,?209 281,580 -11.4% Utilities 3,352 5,400 41400 ,5 0 4,500 -16.7% Insurance 33,304 35,725 35,725 40,595 40,595 13.6% Commodities & Supplies 26,745 47,689 47,517 45,727 48,139 -4.1% Other Expenditures 1,285,031 928,411 1,032,511 - -100.0% Finance Total 21P735,099 2,519,327 2,599,005 .11667,927 1,704,681 -33.8% Community Development Personal Services, Salaries & Wages 11497,377 116311,127 1,631,127 3 173 9),947 11778,759 5.4% Employee Benefits 669,972 6441174 623,162 722,v733 746,110 12.2% Other Employee Costs 19,192 29,420 30,620 30191 6 311708 5.1% Contractual Services 272,988 377,309 363,303 389,296 ,2. 393,200 3.2% Utilities 12,589 30,611 30,911 30,684 311298 0.2% Insurance 20,707 24,397 24,397 27,p939 27,939 14.5% Commodities & Supplies 23,518 37,382 37,611 3,81099 38,465 1.9% Community Development Total 2,516,343 2,774,420 2,741,131 2, 5 °,6,,,4 3,047,479 6.7% B1.JDGx.E,""1' BY'J"UN'll: GIENIERA]1'.... A I "UND 1...1 .4 " P A 1) "11, Y 1, " .4 "U" D G 1.71a N E R A I[ F N (MAJOR FUND) E"xpenditi,'ires by, Function and Account Classification 2018 2019 2019 2020 2021 % Change Actual Budget Estimate Budget Forecast 19 to 20 Human Services Personal Services,, Salaries & Wages 726.,081 713,751 713,751 743,0405 769,107 4.2% Employee Benefits 299,,711 267.,124 249,077 268p5O6 277,114 0.5% Other Employee Costs 3,.627 10,.495 8,949 3 1,895 12,131 13.3% Contractual Services 108,.806 138,,933 126,400 3 33,?782 136,064 -3.7% Utilities 7,175 12,,935 11,393 3 2,?949 13,208 0.1% Insurance 9,,574 111280 111280 3 2,?93 8 12,918 14.5% Commodities & Supplies 9,,884 13,,882 10,196 3 4.370 14,657 3.5% Office Equipment 412 1,036 536 547 558 -47.2% Other Equipment - 500 500 53 0 520 2.0% Human Services Total 11165.,270 11169..936 1.,132,082 1.j 98,p882 1,236,277 2.5% Police Personal Services, Salaries & Wages 10,,421,.651 101566,.921 10,,567,,714 3 1,003,p277 11,362,,033 4.1% Employee Benefits 6,,112,.077 51877,,416 5,,942,083 6,p239,p775 61338,,526 6.2% Other Employee Costs 140,774 181,.460 170,185 3 85,p985 189,705 2.5% Contractual Services 1.1532,,761 11937,,802 11882,108 1,952,p606 11964,,677 0.8% Utilities 36,779 49,143 47,943 50,p307 51,314 2.4% Insurance 126,383 148,902 148,902 3 70,0524 170,524 14.5% Commodities & Supplies 173,384 196,,642 192,955 207,9465 215,010 5.5% Office Equipment 7,398 30,950 24,550 31,9070 31,695 0.4% Other Equipment 13,002 17,,700 16,400 26.,430 18,760 49.3% Police Total 18,,564.,209 19.,006..936 18,992,840 .1 9,9867.,439 20,342,244 4.5% Fire Personal Services, Salaries & Wages 8,,629,,504 91001,,343 9.1003,743 ,37 ",2 91686,,545 4.2% Employee Benefits 5,,231,,067 51374,,179 51404,707 5,?529,p388 51691,,013 2.9% Other Employee Costs 111,496 164,328 164,328 3 67,p] 27 170,438 1.7% Pension Benefits 5,819 5,819 5,819 6,93 74 6,174 6.1% Contractual Services 1.1171,604 11248,,774 11247,082 1,376,9289 11336,603 10.2% Utilities 39,282 67,858 67,858 67,p858 67,858 0.0% Insurance 156,840 184.1787 184,787 23,1,, 3 9 211,619 14.5% Commodities & Supplies 48,341 84,.620 84,420 83 13 30 77,831 -4.1% Building Improvements 392 8,250 12,000 3 2,v000 12,000 45.5% Office Equipment 170 250 250 3j,000 255 1100.0% Other Equipment 170,550 193,839 135,934 3 63j,733 142,752 -15.5% Fire Total 15.,565.,065 16,334..047 16.310,928 3 6j,994,566 17.,403..088 4.0% Public Works Personal Services, Salaries & Wages 3,063,490 3,437,637 3,448,757 31669,p745 3,794,469 6.8% Employee Benefits 111452,672 1,336,586 1,317,378 .11 , 4 2 1,512,358 10.0% Other Employee Costs 41,776 44,339 43,939 44p8l 8 45,713 1.1% Contractual Services 21138,828 2,653,855 2,664,387 21848,024 2,843,707 7.3% Utilities 117,327 147,484 147,1484 3 60,p777 163,993 9.0% Insurance 105,227 123,,977 123,977 3 4 3 1979 141,979 14.5% Commodities & Supplies 319,624 372.,089 372,294 4091634 417,802 10.1% Other Expenditures - 4,,330 4,330 4141 7 4,505 2.0% Office Equipment 529 1,964 1,964 2,9003 2,044 2.0% Other Equipment 46,442 78,,895 68,753 65,0237 66,541 -17.3% Public Works Total 7..285..915 81201,f 156 8..193.,263 %83 6.,276 8,993,111 7.5% Operating Total 52,,283.,580 54,643,409 54.,505..240 561333 p705 57..563.,696 3.1% r-4 0 .4 4 1 :: G1 Al JR.A.] IN U N D E �, 1"'UNI'.) ][Tj J11111 .4 .4 . "UND a . J..j . . .... j G I N E"' R A 11 1..� (MAJOR FUND) Expenditures by, Function and Account Classification 2018 2019 2019 2020 2021 % Change Actual Budget Estimate Budget Forecast 19 to 20 Non -Operating CIP Contractual Services 75,,967 75,,000 75,000 -100.0% Office Equipment 2,,707 - - +++ Other Equipment - - - m, 40,000 +++ Infrastructure 591,484 11776,300 11776,300 I,,01,0.,920 572,226 -43.1% CIP Total 670.,158 11851.300 1,851.300 1,03 0,?920 612,226 -45.4% Non -Operating Total 670.,158 1,851,300 1.,851,300 1,03 %920 612,226 -45.4% Other Financing Uses Interfund Transfers Interfund Transfers 2,,354,,391 11540,,000 11966,000 4.,768,p000 750,000 209.6% Interfund Transfers Total 2,354,391 1IP540..000 1p966,000 4.,768pOOO 750,p000 209.6% Other Financing Uses Total 2,354,391 11540,p000 11966,000 4,?768,pOOO 750,p000 209.6% 001- General Fund Total 55,,308.,129 58,p034,p709 58,3221540 62pl 1 0.,625 58,925,922 7.0% BD G E' BYFUND:: Dum E 1 ,' a 1 " 1,11 0 ,j" 4UND I q I I"ry 'UND PE: DEB"'I" SERVICE 2018 2019 2019 2,02O 2021 % Change Actual Budget Estimate Budget Forecast 19 to 20 .��, Debt Service i`�� u iiia �' melt Other Sources Over Expenditures 3,966,310 (899,179) Revenues ,1456582) (1,380,056) 62.0% Fund Balance, Beginning of Year 184,196 4,1501#506 4,150,506 3,392,031 7 Property Taxes 213901000 2,4341000 2,4341000 2,54,812,50 217481046 4.7% Other Taxes 1,0621104 110241578 1,024,578 9251000 9351000 -9.7% Intergovernmental Revenue 11619577 15731650 1,593,650 1,6001900 116061800 1.7% Investment Income 24,243 5,000 46,000 3l5 251000 600.0% Other Revenue 450 - - - +++ Other Financing Sources 8,041,335 790,000 790,000 - -100.0% Revenues Total 13,137,709 5,827,228 5,888,228 15..'„ ..„°5 " 5,314,846 -12.3% Expenses Contractual Services 1381800 - - - +++ Bond Principal 71825,687 3,8121499 3,787,499 4,F01 5,FOOO 412701000 5.3% Interest Expense 1,202,447 2,9101408 2,855,718 2,F5471732 214211902 -12.5% m Bank & Fiscal Fees 4,465 3,500 3,500 3.. 3,000 -14.3% Expenses Total 9,171,399 6,726,407 6,646,717 6j,5651732 6,694,902 -2.4% Excess (Deficiency) of Revenues & Other Sources Over Expenditures 3,966,310 (899,179) (758,489) ,1456582) (1,380,056) 62.0% Fund Balance, Beginning of Year 184,196 4,1501#506 4,150,506 3,392,031 7 11935,435 Fund Balance, End of Year 411501506 3,251,327 iiiiiiiiiiiiiiiiiiiiiillillillillillillilliillillilliillillillillillillilliillillillillillillillilliillillillillillillilliillillillillillillillillillilliillillillillillillillilliillillillillillillilliillillillillillillillillillilliillillillillillillillilliillillillillillillilliillillillillillillillillillilliillillillillillillillilliillillillillillillilliillillillillillillillillillilliillillillillillillillilliillillillillillillilliillillillillillillillillillilliillillillillillillillilliillillillillillillilliillillillillillillillillillilliillillillillillillillilliillillillillillillilliillillillillillillillillillilliillillillillillillillilliillillillillillillilliillillillillillillillillillilliillillillillillillillilliillillillillillillilliillillillillillillillillillilliillillillillillillillilliillillillillillillilliillillillillillillI 3113921017 1I,., 3°5143'u5 555379 Recommended Fund Balance 2,298,160 2,298,160 2..4 3.5,1711 2,423,181 Summary of Revenues, Expenditures, and Fund Balance 2018-...,2021 .1 4,,000;000 iz,oao,000 io,000,oao 81000,000 6000000 4.000,000 ,,oao,oao VIII 2018 2019 Est =ozo 2021 Revenues no Expenses iii Fund Balance 2018 2019 2019 0 2021 % Change Actual Budget Estimate Budget Forecast 19 to 20 20 .Ca pita IIII i riii prove me int i u rid 715,350 (1,321,440) (610,206) (663,372) (575,010) -49.8% Fund Balance, Beginning of Year 1,6991444 2,414,794 Revenues J.,804,1588 1,141,216 Fund Balance, End of Year 21414,794 1,093,354 1,8041588 11,1'11,43 121 6 Other Taxes 113631690 13701000 13421600 1.389,000 114381236 1.4% Intergovernmental Revenue - - - 900,000 - +++ Investment Income 221818 201000 26,900 1 61900121900 -15.5% Other Revenue 56,036 21000 - ., - -100.0% Other Financing Sources 7501000 750,000 7501000 4001000 4001000 -46.7% Revenues Total 2,192,544 2,142,000 2,119,500 2170,51900 1,851,136 26.3% Expenses Contractual Services 1291745 94,590 94590 1 3J....1 82, 82,806 38.7% Other Expenditures - 495,000 295,000 2,00,000 1701000 -59.6% Land Improvements 151500 400,000 400,000 1„00,000 - -75.0% Building Improvements 339,283 464500 404500 678,FOOO 113201000 46.0% Office Equipment - - - J11 4,800 70,000 +++ Other Equipment 289,922 673,600 481500 4221600 229,000 -37.3% Motor Equipment - 82,000 - - -100.0% m Infrastructure 702,744 1,253,750 110541116 1I,1822,690 554340 45.4% m Expenses Total 1,477,194 3,463,440 2,729,706 313 m'° m""' 2,426,146 -2.7% Excess (Deficiency) of Revenues & Other Sources Over Expenditures 715,350 (1,321,440) (610,206) (663,372) (575,010) -49.8% Fund Balance, Beginning of Year 1,6991444 2,414,794 2114141794 J.,804,1588 1,141,216 Fund Balance, End of Year 21414,794 1,093,354 1,8041588 11,1'11,43 121 6 566,206 Recommended Fund Balance From 660,425 660,425 660,425 660,425 To 1,000,000 1,000,000 1 1,000,000 Summary r f f e n us, Expenditll-es, and Fund l in ce 201,,,, -.- 2021,,,, 4,000,000 3.50(],000 1,004 000 uNNNN 21500,000 0tlllllllll 21000,000 1,500,000 1,000,000 PiPiIIIIIIi 500goo 2018 2019 [it 2020 Revenues in Expenses iii Fund Balance 2018 2019 2019 2,02,0 2021 % Change Actual Budget Estimate Budget Forecast 19 to 20 23 ., Street hinprovemeint Construc Fi,jnd 1,360,378 (906,000) (1,016,400) 624,000 (84,264) -168.9% Fund Balance, Beginning of Year 61,231 1,4211609 11421,609 Revenues Fund Balance, End of Year 114211609 515,609 iiiiiiiiiiiiiiiiiiiiiillillillillillillilliillillillillillillillillillillillilillillillillillillilliillillillillillillilliillillilillillillillillillillillilillillillillillillilliillillillillillillilliillillilillillillillillillillillilillillillillillillilliillillillillillillilliillillilillillillillillillillillilillillillillillillilliillillillillillillilliillillilillillillillillillillillilillillillillillillilliillillillillillillilliillillilillillillillillillillillilillillillillillillilliillillillillillillilliillillilillillillillillillillillilillillillillillillilliillillillillillillilliillillilillillillillillillillillilillillillillillillilliillillillillillillilliillillilillillillillillillillillilillillillillillillilliillillillillillillilliillillilillillillillillillillillilillillillillillillilliillillillillillillilliillillilillilillilI 405,209 11.,0291209 944,945 Recommended Fund Balance 1.'000"000 Other Taxes 2,0651406 2,0851000 2,014,600 2,074,1000 211331236 -0.5% Licenses, Permits & Fees 116001690 116501000 1,600,500 1,0616,p500 116331000 -2.0% Intergovernmental Revenue 50,100 - - ., 517001000 +++ Investment Income 10,715 6,000 121500 8,0500 81500 41.7% Reimbursements 71,877 - 121000 1 5..000 181000 +++ Other Revenue 177,888 30,000 211000 25� 251000 -16.7% Other Financing Sources - - - 975..000 3501000 +++ Revenues Total 3,976,676 3,771,000 3,660,600 4,171 „ .. 9,867,736 25.0% Expenses Contractual Services 18,631 401000 401000 40,p000 401000 0.0% Infrastructure 215971667 41637,000 4,6371000 4,p0,50,p000 -12.7% m Expenses Total 2,616,298 4,677,000 4,677,000 4,0901000 9,952,000 -12.6% Excess (Deficiency) of Revenues & Other Sources Over Expenditures 1,360,378 (906,000) (1,016,400) 624,000 (84,264) -168.9% Fund Balance, Beginning of Year 61,231 1,4211609 11421,609 4,05,209 11029,209 Fund Balance, End of Year 114211609 515,609 iiiiiiiiiiiiiiiiiiiiiillillillillillillilliillillillillillillillillillillillilillillillillillillilliillillillillillillilliillillilillillillillillillillillilillillillillillillilliillillillillillillilliillillilillillillillillillillillilillillillillillillilliillillillillillillilliillillilillillillillillillillillilillillillillillillilliillillillillillillilliillillilillillillillillillillillilillillillillillillilliillillillillillillilliillillilillillillillillillillillilillillillillillillilliillillillillillillilliillillilillillillillillillillillilillillillillillillilliillillillillillillilliillillilillillillillillillillillilillillillillillillilliillillillillillillilliillillilillillillillillillillillilillillillillillillilliillillillillillillilliillillilillillillillillillillillilillillillillillillilliillillillillillillilliillillilillilillilI 405,209 11.,0291209 944,945 Recommended Fund Balance 1.'000"000 1.'0001000 1, 000, 000 1"000"000 Summary of Revenues, Expenditures, and Fund Balance 2018 - 2021 i2,000,000 io,000,000 8,000,000 6,000,000 4,000,000 2,000,000 2018 2019 Est 2020 2021 uuuuu Revenues im Expenses iiiiiii Fund Balance ND BUDGE'r BY FUND:: FLOOD CONTROL I VNI 2018 2019 2019 0 2021 % Change Actual Budget Estimate Budget Forecast 19 to 20 II" IF -ll m Inti III Coinstruction un (2,107,733) 304,599 (6,085,175) -116.9% 118181539 11741,358 1,7411358 (366,375) Revenues 111741,358 (62,720) iiiiiiiiiiiiiiiiiiiiiillillillillillillilliillillillillillillillilillillillillillillillillillillilliillillillillillillilliillillilillillillillilillillillillillillillillillillilliillillillillillillilliillillilillillillillilillillillillillillillillillillilliillillillillillillilliillillilillillillillilillillillillillillillillillillilliillillillillillillilliillillilillillillillilillillillillillillillillillillilliillillillillillillilliillillilillillillillilillillillillillillillillillillilliillillillillillillilliillillilillillillillilillillillillillillillillillillilliillillillillillillilliillillilillillillillilillillillillillillillillillillilliillillillillillillilliillillilillillillillilillillillillillillillillillillilliillillillillillillilliillillilillillillillilillillillillillillililI (366,375) 1I,1"""' 177 6) (61146,951) 614,332 614,332 Other Taxes 3021104 3451422 3351650 4,64,000 5031236 34.3% Intergovernmental Revenue - 2,0001000 1,394,000 888,000 1001000 -55.6% Charges For Services 50,595 401000 45,000 401000 451000 0.0% Investment Income 18,716 121000 191500 1 61,500 131500 37.5% Reimbursements 20,000 20,000 191800 1 61800 131800 -16.0% Other Financing Sources - - - 3,39 31 - +++ Revenues Total 391,415 2,417,422 1,813,950 4,81 81300675,536 99.3% Expenses Contractual Services 871854 1201000 1201000 1 22,4001241848 2.0% Utilities 21132 311500 3,500 3157'0 31641 2.0% Commodities & Supplies 41351 51000 5,000 1511 51202 2.0% Other Expenditures 11000 21000 21000 5j,000 51000 150.0% Other Equipment - - - 280,000 - +++ Distribution Systems 45,108 801,000 801000 7881000 - 885.0% m Infrastructure 328,151 41011,000 317111183 31309,633 3' , 616221020 -17.5% m Expenses Total 468,596 4,221,500 3,921,683 151 3..703 6,760,711 6.9% Excess (Deficiency) of Revenues & Other Sources Over Expenditures Fund Balance, Beginning of Year Fund Balance, End of Year Recommended Fund Balance From To (77,181) (1,804,078) (2,107,733) 304,599 (6,085,175) -116.9% 118181539 11741,358 1,7411358 (366,375) (61,776) 111741,358 (62,720) iiiiiiiiiiiiiiiiiiiiiillillillillillillilliillillillillillillillilillillillillillillillillillillilliillillillillillillilliillillilillillillillilillillillillillillillillillillilliillillillillillillilliillillilillillillillilillillillillillillillillillillilliillillillillillillilliillillilillillillillilillillillillillillillillillillilliillillillillillillilliillillilillillillillilillillillillillillillillillillilliillillillillillillilliillillilillillillillilillillillillillillillillillillilliillillillillillillilliillillilillillillillilillillillillillillillillillillilliillillillillillillilliillillilillillillillilillillillillillillillillillillilliillillillillillillilliillillilillillillillilillillillillillillillillillillilliillillillillillillilliillillilillillillillilillillillillillillililI (366,375) 1I,1"""' 177 6) (61146,951) 614,332 614,332 614,1332 614,332 1,000,000 1,000,000 1 1,000,000 Swi-ni-nary of Revenues, Een itur , lg�,, i�� Balance , 2 2 8,000,000 5,000,000 4000,000 2,000,000 °°�. uuuuuuuuuuuuuuuuuuuuuu (2,000,000) 2018 2019 IEt 2020 2021 (4,0001000) (61000,000) ,000,000) IIIIIIIIII Revenues II1I1I1II Expen yes IIIIIIIIIIIIII I:::::uind Ballance "rAl' PROJEC I'S FUND 2018 2019 2019 2,02,0 2021 % Change Actual Budget Estimate Budget Forecast 19 to 20 25 ., Pollice & i it e I LAIdin, Const. Revenues Investment Income 1401508 881000 5271000 361500 -58.5% Other Revenue 201552 - - - +++ Other Financing Sources 3315271683 - - - +++ Revenues Total 33,688,743 88,000 527,000 36.,500- -58.5% Expenses Contractual Services 119031463 23161174 1,616,439 372,61 „ ' „ - -83.9% Building Improvements 651100 22,620,808 22,150,223 7.. 1' - -65.8% Expenses Total 1,968,563 24,936,982 23,766,662 8..1 021400 -67.5% Excess (Deficiency) of Revenues & Other Sources Over Expenditures Fund Balance, Beginning of Year Fund Balance, End of Year Recommended Fund Balance From To 40,0 0,000 35,000,000 30,000000 251000;000 2.00001000 150001000 101000"000 5,000,000 31,720,180 (24,848,982) (23,239,662) (8,065,900) ') - -67.5% - 31,7201180 31,720,180 8,480,51 8 414,618 31;7201,180 6;871,4198 8;480;518 43 4,611 8 414;618 405,120 405,120 40.5,f. 405,120 810,240 810,240 810f240 810,240 Summary Revenues, , ......m ndit u res,. and Fn Ana m Balance 203 8-, 2023 �� 2018 2019 Est 2020 IIIIIIIIII Revenues IIII Expenses IIIIIIII Fund Balance ulu III .� ..' mo„� .� .�. .� .. ..„q .. mo REFUSE ..,� ..,�q ..� .. ..,,q .. � � ....� .. ..,, . u � . � . � ...� � .,. .. .. .� mo SPECIAL � � ,.� ...� ....� .,. 2018 2019 2019 0 2021 % Change Actual Budget Estimate Budget Forecast 19 to 20 40 Refuse Disllll osalll IFtxiir'id I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I 22% I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I 19% 1 0 -1% I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I Recommended Fund Balance Revenues From 472,799 478,274 478,274 492,.096 506,859 To 1,181, 997 Charges For Services 41205,786 4,194,500 4,210,000 4,'5.. 41195,000 0.0% Fines & Forfeits 361629 37,000 38,400 381,500 331500 4.1% Investment Income 101139 51000 11,600 101950 101950 119.0% Reimbursements 27,372 11000 650 1 1000 11000 0.0% Other Revenue 1271179 134,220 132,100 1 2,9;,5001291500 2018201...9 1.."000,00 -3.5% Revenues Total 4,407,105 4,371,720 4,392,750 4;J74..9,50 4,369,950 0.1% Expenses Personal Services, Salaries & Wages 2671842 254,632 2831822 3' „9.. m'° 330,885 25.6% Employee Benefits 123,513 112,676 116,076 x„33,5 m""' 137,599 18.5% Other Employee Costs 349 1,350 1,350 1137'7 11405 2.0% Contractual Services 4,0951524 4,1391523 4,2771736 4.27711„7 7 413991359 3.3% Utilities 153 483 483 493 503 2.1% Insurance 51892 6,942 6,942 7,0950 7,950 14.5% m Commodities & Supplies 351723 41,579 41,579 4,2143 0 43,257 2.0% m Expenses Total 4,528,996 4,557,185 4,727,988 4,"7 ,"""" 3 4,920,958 4.9% Excess (Deficiency) of Revenues & Other Sources Over Expenditures (121,891) (185,465) (335,238) (407,793) (551,008) 119.9% Fund Balance, Beginning of Year 113681550 112461659 1112461P659 911,423 5031628 Fund Balance, End of Year 112461659 110611,194 9111421 503,628 (47,380) Fund Balance % of Subsequent Year Expenditures I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I 22% I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I 19% 1 0 -1% I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I Recommended Fund Balance From 472,799 478,274 478,274 492,.096 506,859 To 1,181, 997 1,195, 686 1,195, 686 112301240 1, 267,147 Summary of flevent.jes, Expenditures, a n, F'und Balance 2,01 2 ,,. 2 6�000�000 �� 000 4-,,000000 1 1 31000000 2,000,000 I...1000�000 � 2018201...9 1.."000,00 Est 2020 2021 Revenues Il1l1l1Expenses IU,,,: u n Ballance BUDGE"'r BY FUND:: MOTOR I'M AL TAX 1"'UND 041 I forIllF-uellll Tax Fuiind Revenues Intergovernmental Revenue Investment Income Reimbursements Revenues Total Expenses Contractual Services Utilities Commodities & Supplies Infrastructure Expenses Total Excess (Deficiency) of Revenues & Other Sources Over Expenditures Fund Balance, Beginning of Year Fund Balance, End of Year Recommended Fund Balance From To 2018 2019 2019 2,02O 2021 % Change Actual Budget Estimate Budget Forecast 19 to 20 113861441 1,400,000 1,4171260 1„, ' ' 7, 5 ' 119071850 36.3 321553 201000 21,950 1 61,500 131500 -17.5% 10,569 151000 61100 1 01000 101000 -33.3% 1,429,563 1,435,000 1,445,310 11934,350 1,931,350 34.8% 3281194 3601173 3601173 3 7..3m""' 6 3741722 2.0% 1671487 2001000 2001000 204,000 2081080 2.0% 3351020 3571000 3571000 380,000 3871600 6.4% 9121200 111681000 1,050,000 1,2751000 9001000 9.2% 1,742,901 2,085,173 1,967,173 2,226,376 1,870,402 6.8% (313,338) (650,173) (521,863) (292 , 60,948 -55.1% 21744,473 2,431,135 2,431,135 J...909,272 11617,246 214311135 11780,962 111909,272 J.,631,7,246116781194 196,717 95,138 95,138 97f 040 491,793 237,844 237,844 242,1601 St..irrimary of F e n m,j e , ExpenditAires, and Balance ,,,, , 8 .,,,,, 3,000,000 2,500.000 ],000,000 1,500,000 1.,000,000 500,000 2018 2013 Est 2020 Revenues in Expenses uu Fund Balance. 99j951 249j879 rYPE: SPECIA.1'.... R'l VENUI I 'UND BUDGE'r BY FUND:: CDBG I U' N 1.) A a 2018 2019 2019 2,02,0 2021 % Change Actual Budget Estimate Budget Forecast 19 to 20 042 . . .... CUBG Revenues Intergovernmental Revenue 302,577 342,745 188,619 "'° 1800 480,800 64.2% Other Revenue 85.1269 124,226 125,600 60,000 60,000 -51.7% Revenues Total 387..846 466,971 314,219 622,800 540..800 33.4% Expenses Personal Services, Salaries & Wages 27,1440 +++ Employee Benefits 5.0052 +++ Other Employee Costs 1,114 636 - - - -100.0% Contractual Services 354,232 466,335 314,219 1800 540,800 33.6% Commodities & Supplies 10 - - +++ Expenses Total 387..848 466,971 314,219 622,800 540..800 33.4% Excess (Deficiency) of Revenues & Other Sources Over Expenditures Fund Balance, Beginning of Year Fund Balance, End of Year Recommended Fund Balance 700,000 600,000 500,000 400,000 300,000 200,000 100,000 (2) 2 St.immary of li event.jes, Expenditures, and Balance 2. 1,,, 2021 2018 2019 Est 2020 IRevenues Illl Expenses III I:::::und Balance BUDGm,.., m u° m Z. mU'Rw ., SPECIA1 ..." E F ND 2018 2019 2019 2,02O 2021 % Change Actual Budget Estimate Budget Forecast 19 to 20 .,Asset Seizure i allied (22,000) (5,020) 7p5OO 7,500 -134.1% 172,907 1411255 Revenues X1,3 .. 3"5 1431735 141,255 iiiiiiiiiiiiiiiiiiiiiillillillillillillilliillillillillillillillillilillillillillillillillillillilliillillillillillillilliillillilillillillillillilillillillillillillillillillilliillillillillillillilliillillilillillillillillilillillillillillillillillillilliillillillillillillilliillillilillillillillillilillillillillillillillillillilliillillillillillillilliillillilillillillillillilillillillillillillillillillilliillillillillillillilliillillilillillillillillilillillillillillillillillillilliillillillillillillilliillillilillillillillillilillillillillillillillillillilliillillillillillillilliillillilillillillillillilillillillillillillillillillilliillillillillillillilliillillilillillillillillilillillillillillillillillillilliillillillillillillilliillillilillillillilillilI 1191255 1361235 11,43p 35 Fines & Forfeits 91644 10,000 16,500 1,500121500 7,000 25.0% Investment Income 11640 21000 1,980 1000 21000 0.0% Revenues Total 11,284 12,000 18,480 1 4,p,500 14,500 20.8% Expenses Other Employee Costs - 1,000 11000 1....000 11000 0.0% Contractual Services 10,349 3,000 2,500 3..00031000 0.0% Commodities & Supplies 151365 - - ., - +++ Other Equipment 171222 30,000 20,000 31000 31000 -90.0% Expenses Total 42,936 34,000 23,500 7'1000 7,000 -79.4% Excess (Deficiency) of Revenues & Other Sources Over Expenditures Fund Balance, Beginning of Year Fund Balance, End of Year Recommended Fund Balance (31,652) (22,000) (5,020) 7p5OO 7,500 -134.1% 172,907 1411255 1411255 X1,3 .. 3"5 1431735 141,255 iiiiiiiiiiiiiiiiiiiiiillillillillillillilliillillillillillillillillilillillillillillillillillillilliillillillillillillilliillillilillillillillillilillillillillillillillillillilliillillillillillillilliillillilillillillillillilillillillillillillillillillilliillillillillillillilliillillilillillillillillilillillillillillillillillillilliillillillillillillilliillillilillillillillillilillillillillillillillillillilliillillillillillillilliillillilillillillillillilillillillillillillillillillilliillillillillillillilliillillilillillillillillilillillillillillillillillillilliillillillillillillilliillillilillillillillillilillillillillillillillillillilliillillillillillillilliillillilillillillillillilillillillillillillillillillilliillillillillillillilliillillilillillillilillilI 1191255 1361235 11,43p 35 1511235 34,000 7,000 71000 T000 7,000 Summary of Revenues, Expenditures, and Fund Balance 2018 - 2021 160,000 140,000 120,000 100,000 sa,000 60,000 40,000 20,000 2018 2019 Est 2020 2021 uuuuu Revenues mi Expenses uiiiiii Fund Balance 2018 2019 2019 2,02,0 2021 % Change Actual Budget Estimate Budget et Forecast 19 to 20 I IF l r'aIll illlll uitalll llle Share i urlds Revenues Fines & Forfeits - 21000 21000 1000 21000 0.0% Investment Income 114 200 100 1 00 100 -50.0% Revenues Total 114 2,200 2,100 2,1„ 2,100 -4.5% Expenses Contractual Services - 1,000 - - 0.0% Other Equipment - 1,000 1,000 , 11000 -100.0% Expenses Total - 2,000 1,000 1 1000 1,000 -50.0% Excess (Deficiency) of Revenues & Other Sources Over Expenditures 114 200 1,100 „'„00 1,100 450.0% Fund Balance, Beginning of Year 201194 20,308 201308 21,408 221508 Fund Balance, End of Year 201308 201508 211408 22,508 231608 Recommended Fund Balance 25,000 20,000 1,,.5,000 100000 5,000 Z000 1.'000 1.'000 1,f 000 1.'000 Surrirriary of Its e efiriues, E Il einditures, and (Fund Balance 201 8 202.1 2018 2019 Est 2020 IIIIIIIIII Revenues II1I1I1II Expenses IIIIIIIIIIIIII I::::�und BaIIaince 2021 rYPE: SPECIA.I... R'lVENUI BUDGE'r BY FUND:: DUI I IN] I UND I U' N I.) A a 2018 2019 2019 2,02,0 2021 % Change Actual Budget Estimate Budget Forecast 19 to 20 04115 DUI Fine !1ffid 4..000 22..015 22.300 25.300 457.5% 1401,926 137,373 Revenues 137.1373 141,373 159,388 31 81,688 206,988 21,500 Fines & Forfeits 21,665 25,000 21.1665 241000 25,000 -4.0% Investment Income 313 500 350 300 300 -40.0% Revenues Total 21.,978 25,,500 22..015 24;,300 25.,300 -4.7% Expenses Other Employee Costs 550 3;000 1....000 -66.7% Contractual Services - 1,000 1....000 0.0% Other Equipment 24,981 17/500 -100.0% Expenses Total 25.531 21,p500 - 1000 -90.7% Excess (Deficiency) of Revenues& Other Sources Over Expenditures Fund Balance, Beginning of Year Fund Balance, End of Year Recommended Fund Balance (3.,553) 4..000 22..015 22.300 25.300 457.5% 1401,926 137,373 137,373 3 59,388 181,688 137.1373 141,373 159,388 31 81,688 206,988 21,500 Z000 Z000 Summary of III3tevenues, Expend itt.,i res, an( -J Fund Balance 201 8 2021 2,50,000 200,000 1_150;000 1 00,000 50,000 2018 ............................. 2019 Est 2020 Revenues 11n Expenses iii fund Balance 2018 2019 2019 2,02O 2021 % Change Actual Budget Estimate Budget Forecast 19 to 20 ., I rei nIllF-ire Ta 13oard i And 26,000 20,650 10,200 10,200 -60.8% 3521,416 3981223 Revenues 41, 8,873 4291073 398,223 4241223 4181873 429,073 Other Taxes 781234 90,000 85,000 7,51000 751000 -16.7% Investment Income 31793 41000 3,650 31 00 31200 -20.0% Revenues Total 82,027 94,000 88,650 7'8,p 78,200 -16.8% Expenses Other Employee Costs 3,731 15,000 151000 1„!51 151000 0.0% Contractual Services 10,729 10500 101500 1 0,500101500 0.0% Insurance - 500 500 °5 500 0.0% Commodities & Supplies 13,000 13,000 13,000 1 3..000 13,000 0.0% Building Improvements - 5,000 5,000 51 51000 0.0% Other Equipment 81760 241000 24,000 241000 241000 0.0% Expenses Total 36,220 68,000 68,000 68,pOOO 68,000 0.0% Excess (Deficiency) of Revenues & Other Sources Over Expenditures Fund Balance, Beginning of Year Fund Balance, End of Year Recommended Fund Balance From To 45,807 26,000 20,650 10,200 10,200 -60.8% 3521,416 3981223 3981223 41, 8,873 4291073 398,223 4241223 4181873 429,073 4391273 6,800 6.'800 61800 6 1800 7j004 17,000 17,000 17,000 17f 000 17j510 St.jr-rimary of neve n t,,,j es, Expenditures, and i n d Balarice 201,,,.8 2021 500,000 400,000 300,000 200,000 100,000 2018 ANAMMIUMMEN 11111111 F/0011, Il��llpl� 1 2019 Est nolo Revenues un Expenses iii fund Balance 11111,111 I'll 2018 2019 2019 2,02,0 2021 % Change Actual Budget Estimate Budget et Forecast 19 to 20 0411,8 Business District IF-und Revenues Other Taxes 1,0271370 110701000 1,016,900 1....0331595 5 110511450 -3.4% Intergovernmental Revenue 531,398 4401000 4951900 51 4,p000 5311990 16.8% Investment Income 13,162 15,000 81800 61500 51500 -56.7% Revenues Total 1,571,930 1,525,000 1,521,600 1„15'5 "'I 1,588,940 1.9% Expenses Interest Expense 115711930 15251000 1,521,600 1.05,5 4,095 9"'° 115881940 1.9% Expenses Total 1,571,930 1,525,000 1,521,600 1,554,1095 1,588,940 1.9% Excess (Deficiency) of Revenues & Other Sources Over Expenditures Fund Balance, Beginning of Year Fund Balance, End of Year Recommended Fund Balance Surrimary of Re einaes, Expenditures, aind IFund Balance. ,,, .1 8 202.1 1,800,000 1,600,000 1,400,000 1,200,000 1,000,000 800,000 600,000 400,000 200,000 ��u�aa� nnau�� nnauu� 2018 2019 Est 2020 2021 IIIIIIIIII I eve n u es II1I1I1II Expenses IIIIIIIIIIIIII I::::�und Ba II a iri ce BtJ DC i I ""'Tu B ' U .. PROS P- �.. 1- .� , of d IIF AND FUNDu..�� ...� w..,��...,��,,,.m . . ..., II I.... ... 1""U N IIIIII U.. 2018 2019 2019 2021 % Change Actual Budget Estimate Budget Forecast 19 to 20 049 Prospect and Mafii�"i,nlDistrict Revenues Property Taxes 4691613 4741000 4331000 738..000 8731900 55.7% Investment Income 781498 10,000 18,500 1„515 121500 55.0% Other Revenue 1691345 - - - +++ Other Financing Sources 713181879 1010001000 9,355,760 - -100.0% Revenues Total 8,036,335 10,484,000 9,807,260 7,53;,500 886,400 -92.8% Expenses Other Employee Costs 11200 2,700 750 1....500 11500 -44.4% Contractual Services 351,826 283300 2001300 2,33..636 1451509 -17.5% Commodities & Supplies 161 1500 600 „..5 11000 0.0% Other Expenditures 1015771843 2,7941500 2,225,000 41,581500 1501985 -83.6% Land Improvements 401053 7091500 7091500 - -100.0% Building Improvements - 610001000 71030,000 - -100.0% Infrastructure 700 8101000 2601000 1,?03599 ' 1101000 27.9% Bond Principal - - - ., 3201000 +++ Interest Expense 310,423 4321738 432,738 78614,47 7301251 81.7 Bank & Fiscal Fees 225 - 225 1 1000 11000 +++ m Expenses Total mr 11,282,431 11,034,238 10,859,113 2151,8.573 1,460,245 -77.2% Excess (Deficiency) of Revenues & Other Sources Over Expenditures (3,246,096) (550,238) (1,051,853) (1 7'65� 73) (573,845) 220.8% Fund Balance, Beginning of Year 319441426 6981330 6981330 (3535 3) (211181596) Fund Balance, End of Year 6981330 1481092 (353,523)(211 1 �59) (21692,441) Recommended Fund Balance From To 20000;000 0, x...0,000,000 ,000,000 0,000,000 4,000,000 2.,000,000 (21000,000) (4,000,000) 26,000 60,514 65,000 1511284 60,514 20,899 1511284 52,.2 49 Summary of Revenues, Expenditures, an [,:und Balance 201... Inlllllppll �� i�VMUVpI zoic 2019 Ear zazo I eve h u e s 111Expenses IF u n B a II a n c e 21,526 53,816 B G. 1` 4 T' BY FUND:: INA"'FER ANDSEWER. FUND F N RISE FUND (MAJOI? FUND) 2018 2019 2019 2,02O 2021 % Change Actual Budget Estimate Budget Forecast 19 to 20 50 latei° and Seweir i i d 7,917,405 11,535,033 11,886,095 7..5061469 121239,539 Recommended Balance 31360,705 Revenues 3,440,480 3,543,694 Property Taxes (5,037) - - - +++ Licenses, Permits & Fees 211300 201000 21,950 201000 201000 0.0% Intergovernmental Revenue - - - ., 210001000 +++ Charges For Services 1411191533 151509,600 15,1291630 1„ '�' „40;,840 1713011470 4.1% Fines & Forfeits 1041500 1001000 1031000 1„ 1001000 0.0% Investment Income 1911467 51,100 1931600 °'6..] 00 391100 29.4% Reimbursements - - 101000 1 0..000101000 +++ Other Revenue 621069 60,000 61,900 60..000601000 0.0% Other Financing Sources (61) 10,200,000 10,016,000 - 715001000 -100.0% Revenues Total 14,493,771 25,940,700 25,536,080 1 6.3961941.027,030,570 -36.8% Expenses Personal Services, Salaries & Wages 2,2971086 211991835 2,224,972 21349..752 214301567 6.8% Employee Benefits 1,061,118 8711240 8881909 31.,0201929 110491906 17.2% Other Employee Costs 43,352 46,589 441114 4,51347 451896 -2.7% Contractual Services 81553,153 912291862 911071635 91233..01,3 914311065 0.0% Utilities 1161606 1621710 1621710 3 6613 74 1691496 2.1% Insurance 991975 1171789 1171789 1 34,892 1341892 14.5 Commodities & Supplies 2601650 3361045 3351803 334,688 3401676 -0.4% Other Expenditures 6961009 - - ., - +++ Building Improvements 671562 2851000 2851000 385,000 - 35.1% Office Equipment 11060 1,081 11081 11,1'11, 3 11125 2.0% Other Equipment 225,455 2121429 2121429 11 78,778 m""' 1351154 -15.8% Distribution Systems 11703,973 812771411 716021642 517,58,14.2 713681142 -30.4% Bond Principal - 2401000 2401000 325,000 5251000 35.4% Interest Expense 2951242 3431081 3431081 841,248 6631081 145.2% Bank & Fiscal Fees 225 - 111225 2..500 21500 +++ Long Term Debt (61948) - - - +++ Expenses Total 15,414,518 22,323,072 21,567,390 20,?776..566 22,297,500 -6.9% Excess (Deficiency) of Revenues & Other Sources Over Expenditures (920,747) 3,617,628 3,968,690 (4,379,626) 6) 4,733,070 -221.1% Unrestricted Net Assets, Beginning of Year 8,838,152 71917,405 7,9171405 11,886,095 71506,469 Unrestricted Net Assets, End of Year 7,917,405 11,535,033 11,886,095 7..5061469 121239,539 Recommended Balance 31360,705 3,360,705 3,440,480 3,543,694 F ND FUN , •. gym: w , w „ ••� " (MAJOI? UND) Surnmary of Revenues, Ependitares, and Net Assets •its 8 .•••• 2021,,,. 30,000,000 25,000,000 20,000,000 ,000,000 ,1••. oo;000 5,0001000 IulUuuU� IulUuuU� IulUuuU� 2018 2019 Est 2020 2021••. IIIIIIIIII Revenues II1I1I1II Expenses se,s IIIIIIIIIIIIII Net Assets EXPENDITURES BY FUNCTION AND ACCOUNT CLASSIFICATION The preceding schedule and graphic summarized the fund revenues and expenses by account type/classification. The Budget Summaries section of this document classifies the Village's revenue identically. The expenses in the Budget Summaries section, however, are split between operating and non-operating expenses. The operating expenses are presented at a departmental level. The non-operating expenses are categorized as CIP (Community Investment Program), Debt Service, Other Expenditures, and Pensions. The matrix at the end of the Budget Summaries section serves as a bridge between the two ways of viewing the budget. For the two major funds, both the General Fund and the Water and Sewer Fund, expenditures in this section will be presented both ways so the reader can view the fund's expenditures by account type/classification at the fund level and also at the function/department level. The schedule on the following page breaks down the operating expenditures on a departmental basis by account classification. The non-operating are summarized by CIP, Debt, and Other Expenditures. BUI )G,E BY44"UN'll: W'A"]'T'1�1, &,S141A1'14.R, !'UMD I" N I P ..... . ..... . .... U' 11'Y ][41 , 'E IV 11"ERI[IRISE 14' "U" N D (MAJOR FUND) &penditures by, Function and Account Classification 2018 2019 2019 2020 2021 % Change Actual Budget Estimate Budget Forecast 19 to 20 G50 ateir and Sewer i::::,Ljnd 050 - Water and Sewer Fund Operating Finance Personal Services, Salaries & Wages 112,,893 117,,633 118,184 1 22j 77 126,415 3.9% Employee Benefits 51,,319 45,,859 46,679 50,?l 52 51,751 9.4% Other Employee Costs - 350 - 350 - 0.0% Contractual Services 139,316 151,300 149,958 3 53,?] 23 156,026 1.2% Commodities & Supplies - 1,300 1,800 1,800 1,800 0.0% Finance Total 303.,528 316..942 316,621 327,0602 335,,992 3.4% Public Works Personal Services, Salaries & Wages 21184,,193 21082.1202 2,106,788 2,?227,?575 21304,,152 7.0% Employee Benefits 1,,009,,799 825,,381 842,230 970,?777 998,155 17.6% Other Employee Costs 43,,352 46,,239 44,114 44.,997 45,896 -2.7% Contractual Services 8.1332;325 81928,,562 81907,677 9,?079,?890 91275.,039 1.7% Utilities 116,606 162,,710 162,710 3 66,J 74 169,496 2.1% Insurance 99,,975 117,789 117,789 3,3 , 134,892 14.5% Commodities & Supplies 260,,650 334,,245 334,003 3,32.,888 338,876 -0.4% Other Expenditures 696,,009 - - m, - +++ Office Equipment 1,060 1,.081 1,081 1,103 1,125 2.0% Other Equipment 105,364 67,.429 67,429 68,?778 70,154 2.0% Distribution Systems 2,400 80,,911 88,142 88,J 42 88,142 8.9% Public Works Total 12,p851.,733 12,646..549 12..671,963 3 3j 1 51,23 6 13.,425..927 3.7% Operating Total 13,155,261 121963.,491 12.,988,584 1,3, 4 , 13..761..919 3.7% Non -Operating CIP Contractual Services - 50,.000 50,,000 -100.0% Building Improvements 67,562 285,000 285,000 385,?000 - 35.1% Other Equipment 120,091 145,000 145,000 3,3,0, 65,000 -24.1% Distribution Systems 1.1701,573 8,196,500 7,514,500 51670,000 71280,000 -30.8% CIP Total 1.,889,?226 8,676,.500 7,?994,500 613 65,000 7..345..000 -28.9% Debt Contractual Services 81,512 100,000 - - -100.0% Bond Principal - 240,000 240,000 325,?000 525,000 35.4% Interest Expense 295,242 343,081 343,081 841,248 663,081 145.2% Bank & Fiscal Fees 225 - 1,225 2,?500 2,500 +++ Long Term Debt (6,948) - +++ Debt Total 370,031 683,,081 584,3063 131116817"48 1..190..581 71.1% Non -Operating Total 2,.259,?257 9,359,.581 8,578,806 71333,p748 8..535..581 -21.6% 050 - Water and Sewer Fund Total 15.,414,?518 22y323,?072 21,?567,.390 20,776j,566 221?297,?500 -6.9% 051 Village Parllldni„ S stem m [`° jnd Revenues Charges For Services Investment Income Other Revenue Revenues Total Expenses Personal Services, Salaries & Wages Employee Benefits Contractual Services Insurance Commodities & Supplies Building Improvements Infrastructure Expenses Total Excess (Deficiency) of Revenues & Other Sources Over Expenditures Unrestricted Net Assets, Beginning of Year 2018 Actual 2019 2019 2,02O 2021 % Change Budget Estimate Budget Forecast 19 to 20 1831066 1861600 1921700 1 91„1 00 1881600 2.4% 31649 31000 41F250 3,50 31500 16.7% 31044 31000 21000 31 31060 0.0% 189,759 192,600 198,950 1 97,600195,160 2019 2.6% 39,187 16,916 161916 1 8,933 191594 11.9 17,509 6,825 6,844 m""',713 71949 13.0% 401775 681506 1311389 1 99,91„2 691238 191.8 242 285 285 3 326 14.4 552 563 563 574 585 2.0% - 71506 71506 ., - -100.0% 35,030 85,500 501000 50,000 751000 -41.5% 133,295 186,101 213,503 27714,58 172,692 49.1 56,464 6,499 311,519 3671983 (14,553) (79,858) 22,468 -1328.8% 3671983 353,430 2731572 Unrestricted Net Assets, End of Year 367,983 3741482 353,430 273,572 2961040 iiiiiiiiiiiiiiiiiiiiiillillillillillillilliillillillillillilliillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillilI Recommended Balance 56,865 56,865 24,423 25,156 St iu nim rn a it of' Re e n u es, Expenditures, and Net Assets 201 8 -.- 2,0 2. 1... 400,000 350,000 300,000 250,000 oa ,000 11000 iilllll 100,000 NNNNNNI �i 50,000 +IIIIII�I�II IOGU9U uuuuuu wN„„�� 1��I11� uuuuw IIIIII�III 19 uuuuw IIIIIOUu� zois 2019 Esc zozo 2021 Revenue; un Expenses iii Net Assets . . AV'] „ ; U I : E ' 200,000 1,,.50,000 1,,.00,000 50,000 20.1 8 201 ,,.9 Est 2020 2021 IIIIIIIIII Re eiYiues Il1l1l1peinses et Assets 2018 2019 2019 2,02O 2021 % Change Actual Budget Estimate Budget Forecast 19 to 20 52 ., Parldng S st rn Reveint,je Fi,jnd Revenues Charges For Services 1551249 1561000 1571500 1561500 1571500 0.3% Investment Income 11703 11000 1,860 116,50 11650 65.0% Other Revenue 11201 11200 21200 � 21200 83.3 Revenues Total 158,153 158,200 161,560 1 60;,3,50161,350 1.4% Expenses Personal Services, Salaries & Wages 28,703 15,576 151576 1 8..838191496 20.9% Employee Benefits 12,763 6,562 6,582 m""'.. m m""' 71903 16.8% Contractual Services 941768 1121083 1131511 „' „4,46".1.11161104 2.1% Utilities 51975 911799 9,799 91998 101198 2.0% Insurance 248 292 292 335 335 14.7 Commodities & Supplies 61865 101796 101796 1„' „P „' „ 111231 2.0% Building Improvements 29,121 - - - +++ m m Expenses Total 178,443 155,108 156,556 3I,62,311,0 165,267 4.6% Excess (Deficiency) of Revenues & Other Sources Over Expenditures (20,290) 3,092 5,004 ,, (3,917) -163.4% Unrestricted Net Assets, Beginning of Year 145,906 1251616 1251616 J11 30,620 1281660 Unrestricted Net Assets, End of Year iiiiiiiiiiiiiiiiiiiiiillillillillillillilliillillilillillillillillillillillillillillillillillillilliillillillillillillilliillillillillillilliillillillillillillillillillillillilliillillillillillillilliillillillillillilliillillillillillillillillillillillilliillillillillillillilliillillillillillilliillillillillillillillillillillillilliillillillillillillilliillillillillillilliillillillillillillillillillillillilliillillillillillillilliillillillillillilliillillillillillillillillillillillilliillillillillillillilliillillillillillilliillillillillillillillillillillillilliillillillillillillilliillillillillillilliillillillillillillillillillillillilliillillillillillillilliillillillillillilliillillillillillillillillillillillilliillillillillillillilliillillillillillilliillillillillillillillillillillillilliillillillillillillilliillillillillillillI 125,616 1281708 130,620 1 28,6601241743 Recommended Balance 40,578 40,578 41,317 42,556 Summary of Revenues, Expenditures, and Net Assets 201,,, , 1,,. 200,000 1,,.50,000 1,,.00,000 50,000 20.1 8 201 ,,.9 Est 2020 2021 IIIIIIIIII Re eiYiues Il1l1l1peinses et Assets BDE urfBY FUND:: E I , . 1 E 1, m '% ,..m .C� .,, , FUND m " E I m E RNLSERVICE RIE I, V I.M 2018 2019 2019 0 2021 % Change Actual Budget Estimate Budget Forecast 19 to 20 60 Velikle a i nt riva iiir°ice IF -u Iliad Revenues Charges For Services 210401827 2,0461358 2,0461358 2..520.A88 213771977 23.2% Investment Income 61569 611000 6,000 61000 61000 0.0% Other Financing Sources 11537 - - - +++ Revenues Total 2,048,933 21052,358 21052,358 2,F5261488 2,3831977 23.1% Expenses Personal Services, Salaries & Wages 110491507 947,587 947,587 1,F'„22X41„7 11161,192 18.5% Employee Benefits 4571011 357,549 366,838 4,33.251„ 446,252 21.2% Other Employee Costs 31984 4,167 4,167 4.. 250 4335 2.0% Contractual Services 1131401 111,883 111,883 11".13,954 1161253 1.9% Utilities 51071 311392 5,113 51431„ 51450 60.1% Insurance 91935 111706 11,706 131405 131405 14.5 Commodities & Supplies 5981070 593,408 607,808 62911„ 3 6321351 6.0% Office Equipment 298 614 614 626 639 2.0% m Other Equipment 31504 3,941 3,941 41011,9 4,100 2.0% m Expenses Total 2,240,781 2,034,247 2,059,657 2,0326,536 2,383,977 14.4% Excess (Deficiency) of Revenues & Other Sources Over Expenditures (191,848) 18,111 (7,299) 1 99,F952- 1004.0% Unrestricted Net Assets, Beginning of Year 588,571 396,723 396,723 389,424. 589376 Unrestricted Net Assets, End of Year 3961723 414,834 389,424 589,376 ,3m""' 589376 Unrestricted Net Assets % of Subsequent Year Expenditures 19% 18% 17% 5 25% Recommended Balance From 205,966 23Z654 23Z654 2381398 239,633 To 514,914 581,634 581,634 595,.994599,083 Surnmary of Revenues, Expenditures, and Net Assets 2 .1 ,202.1 3,000,000 2.,500,000 2,000,000 1...,500,000 ,1...,000,00 500,000 2018 20'..1...9 Est 2020 202„.1... Revenues Il1l1l1i E x 1p eases iiiiii� Netss(.;its .. � .�.� � „� III" .� � � � � ,.�. � . � � � .�. VIII � ... ...� �� . � �, � � "� .. ..�� ..,� � "� � � � � III"�..� � '� � � .. � � ...w FUND .,� � � .. � � �.� III,.. ..v�, ' �' ' .� VIII � ,. � � IIIA .,�. � � � � � ,. SERVICE .,� � "�� ,. � ..� ..�,� � , � . � � .�.� �M.. �I� �M� EM.... ..,, FUNU: mo � OM1. �1�. ,,,.� ..� ....N . ..... ..,�Y wm ...�tt . . E . 1 .,,SID' .,,SID' . mo OM1. � OM1. �. � ]"... �M...�f OM1. ,��w �M....� OM1. I.M 2018 2019 2019 2,02O 2021 % Change Actual Budget Estimate Budget Forecast 19 to 20 061 Ilik le R I IIIIaceiiiaeiiia IF-und 81F9791916 91392,016 9118651115 11,, 5, 75 914721235 Recommended Balance Revenues 91392,016 91865,115 10, 60.5,f 67.5 9,472,235 Charges For Services 1,6111300 2,1321100 2,132,100 1....7791560 117791560 -16.5% Fines & Forfeits 101787 101000 19,000 1 91000191000 90.0% Investment Income 112,771 1201000 1441000 1 44,p000 1441000 20.0% Other Financing Sources 106,814 75,000 251000 - -100.0% Revenues Total 1,841,672 2,337,100 2,320,100 1 1942..560 1,942,560 -16.9% Expenses Other Expenditures 806,514 - - - +++ Motor Equipment 51598 1,9251000 1,434,901 „, 1000 310761000 -37.6% Expenses Total 812,112 1,925,000 1,434,901 I..,..2021000 3,076,000 -37.6% Excess (Deficiency) of Revenues & Other Sources Over Expenditures 1,029,560 412,100 885,199 7401560 (1,133,440) 79.7% Unrestricted Net Assets, Beginning of Year 719501356 8149791916 811979,916 , °"'5,1,1,5 1016051675 Unrestricted Net Assets, End of Year IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII 81F9791916 91392,016 9118651115 11,, 5, 75 914721235 Recommended Balance 8,979,916 91392,016 91865,115 10, 60.5,f 67.5 9,472,235 Summary of Revenues, Expenditures, and Net Assets 2018 - 2021 iz,oao,000 io,000,oao 8,0001000 6,000,000 4,000,000 2,000,000 mmuui �� IIV�I1114 V`�l9 mis 2019 esu zozo zozi Revenues in Expenses ilii Net Assets 2018 Actual 2019 2019 2,02,0 2021 % Change Budget Estimate Budget et Forecast 19 to 20 2 ., Corniputer IIIR pull, ceiiia nt i And 4181653 3881654. 3521654 Recommended Balance 730, 756 409, 753 418,653 388,654 35Z654 Revenues ,,,� ,,,,� Summary f Revenues, Expenditures., seats 201,,. and Net ,,,,,,202.1,,. 800,00 Charges For Services 2051097 1621897 1621897 1591979 1631978 -1.8% Investment Income 61768 41000 - - -100.0% Revenues Total 211,865 166,897 162,897 1 59;,979 163,978 -4.1% Expenses 100,000 Other Expenditures 13,709 - - 2021 - +++ Building Improvements - 2501000 2501000 , - -100.0% Office Equipment 1461625 2371900 2251000 1 891978 1991978 -20.1% Expenses Total 160,334 487,900 475,000 1 89,978199,978 -61.1% Excess (Deficiency) of Revenues & Other Sources Over Expenditures 51,531 (321,003) (312,103) m (36,000) -90.7% Unrestricted Net Assets, Beginning of Year 6791,225 7301756 7301756 41, � 53 3881654 Unrestricted Net Assets, End of Year 730,756 4091753 4181653 3881654. 3521654 Recommended Balance 730, 756 409, 753 418,653 388,654 35Z654 ,,,� ,,,,� Summary f Revenues, Expenditures., seats 201,,. and Net ,,,,,,202.1,,. 800,00 700,000 600,000 5 0, 000 400,000 3 0,0 2 0, 000 100,000 2018 2019 Est 2020 2021 IIIIIIIIII I:r evenues Il1l1l1Expenses IIIIIIIIIIIIII Net Assets ...,.,G. 1` 4 urf J" Y .,. a MANAGEM.1"u' i..ND 063 11isIIIA Managerneint 1° uund Revenues Charges For Services Investment Income Reimbursements Other Revenue Revenues Total Expenses Contractual Services Insurance Commodities & Supplies Other Equipment Expenses Total Excess (Deficiency) of Revenues & Other Sources Over Expenditures Unrestricted Net Assets, Beginning of Yea r Unrestricted Net Assets, End of Year Recommended Balance .. ,. 1""1." . � I. m" E ° .. L a I..'4 31VI ,�� ...� F . 2018 2019 2019 0 2021 % Change Actual Budget Estimate Budget Forecast 19 to 20 71,0941,913 7,429,717 7,2591280 7,73814,78 718941888 4.2% 20,944 20,000 15,430 1 61000 161000 -20.0% 19,337 21000 2091950 l21000 521000 2500.0% 117081941 11803,500 1,654,087 1„16,56,000 116561000 -8.2% 8,844,135 9,255,217 9,138,747 9,462,478 9,618,888 2.2% 161200 40,000 25,000 40,000 40,000 0.0% 811251486 9,1461373 9,4611689 9,542,800 917931276 4.3% 81668 22,500 18,000 1,500 181000 0.0% 11113 - - - +++ 8,151,467 91208,873 91504,689 9,60,51300 9,851,276 4.3% 692,668 46,344 (365,942) ) (232,388) -408.2% 219851464 316781132 311678,132 3,331, ,1,9' 311691368 316781132 317241476 3113121190 3,'1I,69,368 219361980 1,305,500 1,3051500 1,f305,1500 11305,500 Summary of Revenues, Expenditures, and Fund Balance 2018 - 2021 12,000,000 10,000,000 8,000,000 6,000,000 4,000,000 2,000,000 2018 2019 Est 2020 2021 IIIIIIIIII Revenues uu Expenses IIIIIII Fund Balance BUDGE'r BY FUND:: P0110E PENSION FUND FUND I 'IDUCIARY" F UND 2018 2019 2019 2,02,0 2021 % Change Actual Budget Estimate Budget Forecast 19 to 20 7'0 Pollice IPension i ,mind Other Sources Over Expenditures Revenues 2,434,291 7,661,876 2p525..801 2,649,611 3.8% Net Position, Beginning of Year 711,0691059 Investment Income (3,570,236) 3,9331500 9,171,260 4., 771 50 411911950 3.7% Other Revenue 414471495 414861000 4,506,670 4,07,51 1225 418251400 5.9% Revenues Total 877,259 81419,500 13,677,930 8,08281375 9,017,350 4.9% Expenses Pension Benefits 51407,696 5,790,809 5,829,273 6..' 06.A34. 611681469 5.5% Contractual Services 151,074 1671300 1641781 1 69.J 40 1721270 1.1% Insurance 51250 15,000 10,000 1 51000 151000 0.0% Commodities & Supplies - 100 - ., - -100.0% Other Expenditures 81190 121000 121000 1 21000 121000 0.0% Expenses Total 5,572,210 5,985,209 6,016,054 ',03 ,57 6,367,739 5.3% Excess (Deficiency) of Revenues & Other Sources Over Expenditures (4,694,951) 2,434,291 7,661,876 2p525..801 2,649,611 3.8% Net Position, Beginning of Year 711,0691059 6613741108 66,374,108 7 4,035 4 7615611785 Net Position, End of Year 66,3741108 6818081399 7410351984 76,?561,785 7912111396 Recommended Balance by Year 2040 per Illinois statute 119,641,111 126,819,578 126,819,578 134,F428,753 142,494,478 Summary o.... Reve n t„j es, Expenditures, a n 1: n 1:3aa n ce 2,01 . 2 21... 90,000,000 80,000,000 70,000,000 60,000,000 50,000,000 40,000,000 30,000,000 20,000,000 10,000,000 2018 2019 Est 2020 IIIIIIIIII Revenues uu Expenses IIIIIII Fund Balance miuuuu� zou BUDGE"'r BY FUND:: FIRE PENSION 1"'i"UND FUND I 'IDUCIARY" I UND 2018 2019 2019 2,02O 2021 % Change Actual Budget Estimate Budget Forecast 19 to 20 07'1., IF -ire P ,,,, rasion IFund Other Sources Over Expenditures Revenues 1,487,964 6,471,837 1p395..J "5,1 6 1,612,453 -6.2% Net Position, Beginning of Year 661,2651343 Investment Income (1,815,753) 3,5861000 8,774,010 3.,791„11 00 410401220 5.7% Other Revenue 410201773 410951800 4,177,350 4,021 311 50 413391850 2.9% Revenues Total 2,205,020 71681,800 12,951,360 8,00041,12,,50 8,380,070 4.2% Expenses Pension Benefits 51909,910 6,032,036 6,314,288 6,439.454. 615961247 6.8% Contractual Services 148,273 1361700 1411235 144..280 1461370 5.5% Insurance 51650 15,000 15,000 15,000 151000 0.0% Commodities & Supplies - 100 - ., - -100.0% Other Expenditures 81000 101000 9,000 1 01000101000 0.0% Expenses Total 6,071,833 61193,836 6,479,523 6,060911„3 6,767,617 6.7% Excess (Deficiency) of Revenues & Other Sources Over Expenditures (3,866,813) 1,487,964 6,471,837 1p395..J "5,1 6 1,612,453 -6.2% Net Position, Beginning of Year 661,2651343 6213981530 621398,530 68,870,367 7012651483 Net Position, End of Year 62,3981530 6318861494 6818701367 70,265p4,83 7118771936 Recommended Balance by Year 2040 per Illinois statute 106,704,272 113,106,528 113,106,528 1191892,1920 127,086,495 Summary of Revenues, Expenditures, enditures, and 1,,:t„jnd 1: mance1... ,.1 801000,000 70,000,000 60,000,000 '30,0 0 40,000,000 30,000,000 20, 0,000 10,000,000 201...8 2.0.1.9 Est 2020 IIIIIIIIII Revenues Il1l1l1Expenses IIIIIIIIIIIIII 1:::::und balance The purpose of this multi-year financial forecast is to provide insight into the condition and financial direction of the Village beyond the two-year period provided with the annual budget. The forecast is one of the tools used by Village leaders to assist in the strategic and capital planning process. The schedules that follow show revenues and other sources of financing, budgeted expenditures, and available fund balances for the period 2018 through 2024. The information included in the schedules is actual amounts for 2018, estimated amounts for 2019, budget amounts for 2020, and forecast amounts for 2021 through 2024. ASSUIMPTIONS The basic revenue and expenditure assumptions used in developing the multi-year financial forecast are provided below. These assumptions are applied consistently across all Village Funds with few exceptions. Projections for capital items, debt service payments, and other financing sources and uses are pulled from the various supporting schedules. Sources for preparing other assumptions include historical trend data, professional association estimates, impacts from changes in the economy, and development efforts within the Village. Revenues: Property Taxes — projected growth 3 percent annually • Pension allocation projected to increase 6 percent annually • TIF incremental revenues projected based on the planned developments in the TIF area. • Road and Bridge projected to increase 3 percent annually • Changes for Debt Service are per ordinance Other Taxes — projected growth ranging from 0-3 percent annually • Food and Beverage tax projected increase 2 percent annually • Cable franchise fee (Comcast) and real estate transfer tax projected to increase 1.75 percent annually • Home rule sales taxes are projected to increase 3 percent and other utility franchise fees projected to increase 2 percent annually License, Permits, and Fees — projected growth of 1 percent annually Intergovernmental Revenues — projected growth of 3 percent annually • Sales taxes projected to increase by 3.0 percent annually • State Motor Fuel tax projected to increase 35 percent for 2020 due to new MFT tax, and 2 percent thereafter. • Use taxes projected to increase 2 percent annually • Other intergovernmental revenues projected to increase 0-3 percent Charges for Service — projected growth of 1-2 percent annually • Water and sewer charges projected to increase 8 percent and 5 percent respectively Fines and Forfeits — projected growth of 1 percent annually Investment Income — projected growth ranging from 0-5 percent annually • Pension Fund portfolio projected earnings of 3-5 percent • General Village projected earnings on surplus funds of 1 percent Reimbursements and Other Revenue — projected growth of 0-1 percent annually Expenditures: • Personal Services and Pensions — projected growth 3 percent • Employee Benefits — projected growth 3 percent annually • All other expenditures except the capital, and debt - projected growth 2 percent • Capital and Debt — per supporting schedules (CIP/bond ordinance) NOTEWORTHY IITEMS (;AnArni Fi inrl The General Fund is expected to have an operating deficit in 2022. The year 2021, 2023 and 2024 are expected to have an operating surplus. The one-time or planned use of current revenues and surplus reserves are projected for 2020 and 2022 resulting in the annual deficits for those years. The impact to fund balance is an increase of $1.1 million between January 2021 and December 2024. A one-time transfer to support debt service is forecasted in the year 2022. Transfers to support the small-scale capital projects are in the forecasts for $750,000 each year from 2022 to 2024. Capital Project Funds The forecast for the Capital Improvement and Flood Control Funds are all projecting deficits beginning in 2020. These capital funds support expenditures related to various construction projects listed in the Village's five-year Community Investment Program. The five-year projection has identified shortfalls in the out years that will need to be addressed through project deferrals or support from additional existing or new revenue sources. Although deficits are projected during the forecast period, annual spending in these funds will not exceed available resources. Water and Sewer Fund The five-year span covered in this financial forecast includes a series of larger than normal water and sewer rate increases intended to support the long-term operation and maintenance of this utility system on a pay-as-you-go basis. The average annual water and sewer rate increase during this period is 8.0 percent. Due to the recent bond issue of $10.0 million during 2019 will result in 2019 ending balance to $11.8 million. The fund balance will be drawn down to $7.5 million by the end of 2020 from an expanded capital program. Additional bonds totaling $8.3 million will be issued in 2021 followed by expanded capital programs again in 2022, 2023 and continuing into 2024 reduce available fund balance to $3.0 million. Revenue generated from user fees alone will be sufficient to support annual operations and maintenance of this utility system beginning in 2024. Risk Management FundFund A slight deficit is projected for the Risk Management Fund for both 2020 and 2021. For the year 2022 and onwards, there are annual deficits that will be addressed through adjustments in employer and employee contributions. This Fund is supported by employer contributions in the form of chargebacks to the various operating departments as well as employee and retiree contributions in the form of payroll withholdings for life and health insurance. Fund balance to start 2020 is $3.3 million or 34.4 percent of subsequent year's operating budget. The fund balance is projected to fall to $2.9 million by the end of 2024 if no adjustments are made to funding. �M�.� YEAR . . ,.M'�� ,.II III I� �M� �, . ' � F ��I � .4 m D IIIIIIII II IIM1M.f � IIIIII� �/I�II�III� 1.59% 1.19% 1 � � 1 VIII M�„ VIII �� „ �M.��„� V �„ 2.64% 2.64% Expenses % Change from Prior Year 5.45% 6.50% -5.13% (MAJORFUND) 1.48% 2018 2019 2020 2021 2022 2023 2024 Actual Estimate Budget Forecast Forecast Forecast Forecast 1011„ - Geriieiral Fund Revenues Property Taxes 16,368,959 16,386,100 16,669,109 16,999,789 17,509,783 18,035,077 18,576,130 Other Taxes 8,186,048 7,711,700 7,630,780 7,675,236 7,810,671 7,951,246 8,097,074 Licenses, Permits & Fees 1,676,703 1,541,730 1,475,800 1,525,400 1,540,654 1,556,062 1,571,623 Intergovernmental Revenue 29,591,851 29,677,280 30,350,250 30,616,950 31,457,144 32,321,076 33,209,428 Charges For Services 11154,134 11218,000 1,382,500 1,387,500 1,421,285 1,455,906 1,491,382 Fines & Forfeits 408,247 361,060 362,550 372,100 379,542 387,132 3941875 Investment Income 318,490 345,700 266,000 264,500 270,452 276,538 282,760 Reimbursements 224,467 232,612 287,137 287,137 295,394 303,937 312,774 Other Revenue 4701465 2731858 2421300 2361000 2391540 2431133 2461781 Other Financing Sources 567,362 - - - - - - Revenues Total IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII 58,966,726 57,748,040 58,666,426 59,3640612 60,924,465 621530,107 64,182,827 Expenses Personal Services, Salaries & Wages 26,707,033 27,679,687 28,995,539 29,959,084 30,857,863 31,783,620 32,737,130 Employee Benefits 14,9331169 1415201338 1513171489 1516801647 1611081871 161548,852 171000,934 Other Employee Costs 4021395 5561536 5951092 6051255 6151854 6261634 637,603 Pension Benefits 51819 51819 61174 61174 61359 61550 61747 Contractual Services 7,3831175 816661919 911021461 911041630 91286,725 914721477 916611934 Utilities 2281650 3221982 3411201 3461313 354,107 3621079 3701229 Insurance 4691053 5491118 6281535 6281535 641,733 6551209 6681969 Commodities & Supplies 6731255 8341883 8881912 9051946 8851493 901,004 9161784 Other Expenditures 1,2881775 111421841 1101537 101747 101854 10,963 111073 Building Improvements 392 121000 121000 121000 121270 12,546 121828 Office Equipment 261688 431530 521855 501792 501792 501792 50,792 Other Equipment 2431850 2451587 2801910 2931573 253,573 2531573 2531573 Infrastructure 5911484 117761300 110101920 5721226 598,621 6251205 6511881 Interfund Transfers 2,3541391 119661000 417681000 7501000 1,472,125 7501000 7501000 Expenses Total 55,308,129 58,322,540 62,110,625 58,925,922 61,155,240 62,059,504 63,730,477 Excess (Deficiency) of Revenues & Other Sources Over Expenditures 3,6581597 (574,500) (3,444,199) 438,690 (230,775) 470,603 452,350 Fund Balance, Beginning of Year I I I I I I I I 1911781905 I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I 2218371502 I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I 22,2631002 I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I 1818181803 I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I 191257,493 I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I 1910261718 I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I 1914971321 I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I Fund Balance, End of Year 22,8371502 2212631002 18,8181803 1912571493 1910261718 1914971321 1919491671 Revenues % Change from Prior Year -2.07% 1.59% 1.19% 2.63% 2.64% 2.64% Expenses % Change from Prior Year 5.45% 6.50% -5.13% 3.78% 1.48% 2.69% FIVE YEAR FI M"' M . F R1 . AC, . .S 111111 nnim 2 P mnni 2 2 .m Revenues % Change from Prior Year 2018 2019 2020 2021 2022 2023 2024 -27.53% Actual Estimate Budget Forecast Forecast Forecast Forecast 2 m,,, Debt Seiiir° ice 1-,,,, a find Revenues Property Taxes 2,390,000 2,434,000 2,548,250 2,748,046 2,828,686 3,652,500 3,649,100 Other Taxes 1,062,104 1,024,578 925,000 935,000 963,050 991,942 1,021,700 Intergovernmental Revenue 1,619,577 1,593,650 1,600,900 1,606,800 1,611,600 31,212 31,836 Investment Income 24,243 46,000 35,000 25,000 25,563 26,138 26,726 Other Revenue 450 - - - - - - Other Financing Sources 8,041,335 790,000 - - 722,125 - - Revenues Total 13,137,709 5,888,228 5,109,150 5,3140846 6,151,024 4,701,792 4,729,362 Expenses Contractual Services 138,800 - - - - - - Bond Principal 7,825,687 3,787,499 4,015,000 4,270,000 4,145,000 2,385,000 2,455,000 Interest Expense 11202,447 2,855,718 2,547,732 2,421,902 2,300,892 21191,156 2,119,606 Bank & Fiscal Fees 4,465 3,500 3,000 3,000 3,000 3,000 3,000 Expenses Total 9,171,399 6,646,717 6,5650732 60694,902 6,448,892 4,579,156 4,577,606 Excess (Deficiency) of Revenues & Other Sources Over Expenditures 31966,310 (758,489) (1,456,582) (1,380,056) (297,868) 122,636 151,756 Fund Balance, Beginning of Year 1841196 411501506 313921017 119351435 5551379 257,511 3801147 Fund Balance, End of Year 411501506 313921017 119351435 5551379 257511 3801147 5311903 Revenues % Change from Prior Year -55.18% -13.23% 4.03% 15.73% -23.56% 0.59% Expenses % Change from Prior Year -27.53% -1.22% 1.97% -3.67% -28.99% -0.03% FIVE YEAR FI . �"' M . F R1 .. AC, . . S 111111 nnim nn 0 mnni 2 2 .m FU . . "Ui'i C, ... . II 'I'M I . PR°.. ,.1�111� � I NI""r Revenues % Change from Prior Year 2018 2019 2020 2021 2022 2023 2024 -185.30% Actual Estimate Budget Forecast Forecast Forecast Forecast 02 - CaIjpIIItol Impr „ veIIIr eIint I1VIIP'md Revenues Other Taxes 1,363,690 1,342,600 1,389,000 1,438,236 1,481,383 1,525,825 1,571,600 Intergovernmental Revenue 0 - 900,000 - - - - Investment Income 22,818 26,900 16,900 12,900 13,190 13,487 13,791 Other Revenue 56,036 - - - - - - Other Financing Sources 750,000 750,000 4001000 400,000 750,000 750,000 7501000 Revenues Total 2,192,544 2,119,500 2,705,900 1,851,136 2,244,573 2,289,312 2,335,391 Expenses Contractual Services 129,745 94,590 131,182 82,806 84,462 86,151 87,874 Other Expenditures 0 295,000 200,000 170,000 110,000 80,000 - Land Improvements 15,500 400,000 100,000 - 400,000 400,000 400,000 Building Improvements 339,283 404,500 678,000 1,320,000 645,000 415,000 780,000 Office Equipment 0 - 14,800 70,000 - - - Other Equipment 289,922 481,500 422,600 229,000 - 750,000 - m Infrastructure 7021744 110541116 118221690 5541340 1,423,560 500,331 116731160 m Expenses Total 11477,194 2,729,706 31369,272 2,426,146 2,663,022 2,231,482 2,941,034 Excess (Deficiency) of Revenues & Other Sources Over Expenditures 715,350 (610,206) (663,372) (575,010) (418,449) 57,830 (605,643) Fund Balance, Beginning of Year 116991444 214141794 118041588 1,141,216 5661206 147,757 2051587 Fund Balance, End of Year 214141794 118041588 1,141,216 5661206 1471757 2051587 (400,056) Revenues % Change from Prior Year -3.33% 27.67% -31.59% 21.25% 1.99% 2.01% Expenses % Change from Prior Year -185.30% 8.71% -13.32% -27.23% -113.82% -1147.28% FIVE YEAR FI "." .I . FR,E .S 111111 2 2 P mnni 2 2 .m 23 -... Street hirnpir'oveirneint C ° iinstii'uc I,,,, u nd Revenues Other Taxes Licenses, Permits & Fees Intergovernmental Revenue Investment Income Reimbursements Other Revenue Other Financing Sources Revenues Total Expenses Contractual Services Infrastructure Expenses Total Excess (Deficiency) of Revenues & Other Sources Over Expenditures Fund Balance, Beginning of Year Fund Balance, End of Year Revenues % Change from Prior Year FU N'I� ' !:I"I ta 111 M, 1117 M 1 IIP. ."� 2018 2019 2020 2021 2022 2023 2024 Actual Estimate Budget Forecast Forecast Forecast Forecast 2,065,406 2,014,600 2,074,000 21133,236 2,193,758 2,256,009 2,320,039 1,600,690 1,600,500 1,616,500 1,633,000 1,649,330 1,665,823 1,682,481 50,100 - - 5,700,000 - - - 10,715 12,500 8,500 8,500 8,691 8,887 9,087 71,877 12,000 15,000 18,000 18,000 18,000 18,000 177,888 21,000 25,000 25,000 25,375 25,756 26,142 - - 975,000 350,000 - - - 31976,676 3,660,600 4,714,000 9,867,736 3,8951154 3,974,475 4,055,749 18,631 40,000 40,000 40,000 40,800 41,616 42,448 2,597,667 4,637,000 4,050,000 9,912,000 3,222,000 3,252,000 3,282,000 21616,298 41677,000 4,090,000 91952,000 3,262,800 3,293,616 3,324,448 11360,378 (1,0161400) 624,000 (84,264) 632,354 680,859 731,301 611231 114211609 4051209 110291209 9441945 1,577,299 21258,158 114211609 4051209 110291209 9441945 11577,299 212581158 219891459 -7.95% 28.78% 109.33% -60.53% 2.04% 2.04% Expenses % Change from Prior Year 78.76% -12.55% 143.33% -67.21% 0.94% 0.94% FIVE YEAR k ..I M..I M . F R1 ... C, . .S 111111 nnim nn P mnni 2 24 . " ., VIII FLOOD C IIPm... c III r R. Revenues % Change from Prior Year 2018 2019 2020 2021 2022 2023 2024 736.90% Actual Estimate Budget Forecast Forecast Forecast Forecast 124 - Flood C ntiurol Coiinstiiiructiiioiin II,,,,, find Revenues Other Taxes 3021104 335,650 464,000 503,236 518,333 533,883 549,900 Intergovernmental Revenue 0 1,394,000 888,000 100,000 - - - Charges For Services 50,595 45,000 40,000 45,000 45,000 45,000 45,000 Investment Income 18,716 19,500 16,500 13,500 13,804 14,115 14,433 Reimbursements 20,000 19,800 16,800 13,800 13,800 13,800 13,800 Other Financing Sources 0 - 3,393,000 - - - - Revenues Total 391,415 1,813,950 4,818,300 6750536 590,937 606,798 6231133 Expenses Contractual Services 87,854 120,000 122,400 124,848 127,344 129,891 132,489 Utilities 21132 3,500 3,570 3,641 3,723 3,807 3,893 Commodities & Supplies 4,351 5,000 5,100 5,202 5,293 5,386 5,480 Other Expenditures 1,000 2,000 5,000 5,000 5,050 5,101 5,152 Other Equipment 0 - 280,000 - - - 280,000 Distribution Systems 451108 801000 7881000 - - - - m Infrastructure 3281151 317111183 313091631 616221020 5231060 1741122 5751204 m Expenses Total 468,596 3,921,683 41513,701 6,7600711 664,470 318,307 1,002,218 Excess (Deficiency) of Revenues & Other Sources Over Expenditures -77,181 (2,107,733) 304,599 (6,085,175) (73,533) 288,491 (379,085) Fund Balance, Beginning of Year 118181539 117411358 (366,375) (61,776) (6,146,951) (6,220,484) (5,931,993) Fund Balance, End of Year 117411358 (366,375) (61,776) (6,146,951) (6,220,484) (5,931,993) (6,311,078) Revenues % Change from Prior Year 363.43% 165.62% -85.98% -12.52% 2.68% 2.69% Expenses % Change from Prior Year 736.90% 15.10% 49.78% -90.17% -52.10% 214.86% FIVEYEAR RF I '.",' . . l . F E . S Ill.°1 m 2mnni m .. . , ' 11'4R...� BU1.1,111.,, 2018 2019 2020 2021 2022 2023 2024 Actual Estimate Budget Forecast Forecast Forecast Forecast 25 -... [Vice & II,,,,iiiahire B ildiiiiiig Const. -98.44% -93.07% -100.00% +++ +++ +++ Revenues 1107.31% -65.91% -100.00% +++ +++ +++ Investment Income 140,508 527,000 36,500 Other Revenue 20,552 - - Other Financing Sources 33,527,683 - - Revenues Total 33,688,743 527,000 36500 Expenses Contractual Services 1,903,463 1,616,439 372,610 Building Improvements 65,100 22,150,223 7,729,790 Expenses Total 1,968,563 23,766,662 8,102,400 Excess (Deficiency) of Revenues & Other Sources Over Expenditures 31,720,180 (23,239,662) (81065,900) Fund Balance, Beginning of Year - 3117201180 814801518 4141618 4141618 4141618 4141618 Fund Balance, End of Year 3117201180 814801518 4141618 4141618 4141618 4141618 414,618 Revenues % Change from Prior Year -98.44% -93.07% -100.00% +++ +++ +++ Expenses % Change from Prior Year 1107.31% -65.91% -100.00% +++ +++ +++ FIVE YEAR FI . �"'I M . F R1 .. AC, . . S 111111 nnim nn P mnni 2 2 .m 2018 2019 2020 2021 2022 2023 2024 Actual Estimate Budget Forecast Forecast Forecast Forecast I,,, - Ille"fuse Disposal If,,,uiind -0.33% 2.00% 2.03% 1.78% 1.75% 1.79% Expenses % Change from Prior Year Revenues 1.16% 2.89% 2.09% 2.09% 2.09% Charges For Services 4,205,786 4,210,000 4,195,000 4,195,000 4,572,550 4,984,080 5,432,647 Fines & Forfeits 36,629 38,400 381-500 33,500 34,170 34,853 35,550 Investment Income 10,139 11,600 10,950 10,950 11,196 11,448 11,706 Reimbursements 27,372 650 1,000 1,000 1,000 1,000 1,000 Other Revenue 127,179 1321100 129,500 129,500 131,443 133,415 135,417 Revenues Total 4,407,105 4,392,750 4,374,950 4,369,950 4,750,359 5,164,796 5,616,320 Expenses Personal Services, Salaries & Wages 267,842 283,822 319,769 330,885 340,814 351,039 3611571 Employee Benefits 123,513 116,076 133,567 137,599 141,383 145,271 1491267 Other Employee Costs 349 1,350 1,377 1,405 1,430 1,455 1,481 Contractual Services 4,095,524 4,277,736 4,277,177 4,399,359 4,487,344 4,577,091 4,668,634 Utilities 153 483 493 503 514 526 538 Insurance 5,892 6,942 7,950 7,950 8,117 8,288 8,462 Commodities & Supplies 351723 411579 421410 431257 441014 441784 451569 Expenses Total 41528,996 4,727,988 41782,743 4,920,958 5,023,616 5,128,454 5,235,522 Excess (Deficiency) of Revenues & Other Sources Over Expenditures -121,891 (335,238) (407,793) (551,008) (273,257) 36,342 380,798 Fund Balance, Beginning of Year 113681550 112461659 9111421 503,628 (47,380) (320,637) (284,295) Fund Balance, End of Year 112461659 9111421 5031628 (47,380) (320,637) (284,295) 96503 Revenues % Change from Prior Year -0.33% 2.00% 2.03% 1.78% 1.75% 1.79% Expenses % Change from Prior Year 4.39% 1.16% 2.89% 2.09% 2.09% 2.09% FIVE YEAR FI M"' M . F R1 . AC, . .S 111111 nnim 2 P mnn1 2 2 .m 1„ .,,, I of ii� I,,,, tj e l "1111 ax 1::: tj iin d Revenues Intergovernmental Revenue Investment Income Reimbursements Revenues Total Expenses Contractual Services Utilities Commodities & Supplies Infrastructure Expenses Total Excess (Deficiency) of Revenues & Other Sources Over Expenditures Fund Balance, Beginning of Year Fund Balance, End of Year Revenues % Change from Prior Year VIII III!". X ..� .. ,�M i I'�.. ..�a PV,A�1." . 1 '4UNI.��.AN" 2018 2019 2020 2021 2022 2023 2024 Actual Estimate Budget Forecast Forecast Forecast Forecast 1,386,441 1,417,260 1,907,850 1,907,850 1,946,007 1,984,927 2,024,626 32,553 21,950 16,500 13,500 13,804 14,115 14,433 10,569 6,100 10,000 10,000 10,000 10,000 10,000 11429,563 1,445,310 1,934,350 1,931,350 1,969,811 2,009,042 2,049,059 328,194 360,173 367,376 374,722 3821216 389,861 397,659 167,487 200,000 204,000 208,080 212,762 217,549 222,444 335,020 357,000 380,000 387,600 394,383 401,285 408,308 9121200 1,050,000 1,275,000 900,000 1,500,000 1,500,000 1,500,000 11742,901 11967,173 2,226,376 11870,402 2,489,361 2,508,695 2,528,411 -313,338 (521,863) (292,026) 60,948 (519,550) (499,653) (479,352) 2,744,473 214311135 1,9091272 116171246 1,678,194 111581644 6581991 214311135 119091272 116171246 116781194 111581644 6581991 1791639 1.10% 13.18% -15.99% 33.09% 0.78% 0.79% Expenses % Change from Prior Year 12.87% 13.18% -15.99% 33.09% 0.78% 0.79% FIVE YEAR FI "." .I . F R, E .S 111111 2 2 P mnni 2 2 ,m 2018 2019 2020 2021 2022 2023 2024 Actual Estimate Budget Forecast Forecast Forecast Forecast 042 .,,, C i° Bow Revenues Intergovernmental Revenue 302,577 188,619 562,800 480,800 490,716 500,835 5111160 Other Revenue 85,269 125,600 60,000 60,000 60,900 61,814 62,741 Revenues Total 387,846 3140219 622,800 540,800 5510616 562,649 573,901 Expenses Personal Services, Salaries & Wages 27,440 - - - - - - Employee Benefits 5,052 - - - - - - Other Employee Costs 11,114 - - - - - - Contractual Services 3541232 3141219 6221800 5401800 5511616 5621649 5731901 Commodities & Supplies 10 - - - - - - Expenses Total 387,848 314,219 622,800 5400800 551,616 562,649 573,901 Excess (Deficiency) of Revenues & Other Sources Over Expenditures -2 - - - - - - Fund Balance, Beginning of Year 2 - - - - - - Fund Balance, End of Year - - - - - - - Revenues % Change from Prior Year Expenses % Change from Prior Year -18.98% 98.21% -13.17% 2.00% 2.00% 2.00% -18.98% 98.21% -13.17% 2.00% 2.00% 2.00% FIVE YEAR FI "." .I . FR,E .S 113111 2 2 P mnni 2 2 .m , N.. 1 'I� ' ai'i ASS] N III,ANN. 7 ,�M',�.� IIW.....� 111 1 1 m�., . �N•,• 2018 2019 2020 2021 2022 2023 2024 Actual Estimate Budget Forecast Forecast Forecast Forecast 043 -... Asset Seiiii uiiire II,, wriid Revenues Fines & Forfeits 9,644 16,500 12,500 12,500 12,750 13,005 13,265 Investment Income 1,640 1,980 2,000 2,000 2,045 2,091 21138 Revenues Total 11,284 180480 14,500 14,500 140795 15,096 15,403 Expenses Other Employee Costs 0 1,000 1,000 1,000 1,018 1,036 1,054 Contractual Services 10,349 2,500 3,000 3,000 3,060 3,121 3,184 Commodities & Supplies 15,365 - - - - - - Other Equipment 17,222 20,000 3,000 3,000 3,000 3,000 3,000 Expenses Total 42,936 23,500 7,000 70000 7,078 7,157 7,238 Excess (Deficiency) of Revenues & Other Sources Over Expenditures -31,652 (50020) 7,500 7,500 70717 7,939 8,165 Fund Balance, Beginning of Year Fund Balance, End of Year Revenues % Change from Prior Year 1721907 1411255 1361235 1431735 1411255 1361235 1431735 1511235 1511235 1581952 1661891 1581952 1661891 1751056 63.77% -21.54% 0.00% 2.03% 2.03% 2.03% Expenses % Change from Prior Year -45.27% -70.21% 0.00% 1.11% 1.12% 1.13% FIVE YEAR FI . I . E .I 2020,11,11,12024 1 ,,, -... II°° edeiiir l Equitable Sllha hire F finds Revenues Fines & Forfeits Investment Income Revenues Total Expenses Contractual Services Other Equipment Expenses Total Excess (Deficiency) of Revenues & Other Sources Over Expenditures Fund Balance, Beginning of Year Fund Balance, End of Year �ta.m 1. mil " �N'..�M 1�'I,�nm" ..� 1�.� . � .I... IIW�.� �N'... L E I � 1�.IARE 1�.,.� 2018 2019 2020 2021 2022 2023 2024 Actual Estimate Budget Forecast Forecast Forecast Forecast 0 2,000 2,000 2,000 2,040 2,081 21123 114 100 100 100 102 104 106 114 2,100 2,100 21100 2,142 2,185 2,229 0 - 1,000 - - - - 0 1,000 - 1,000 1,000 1,000 1,000 0 10000 1,000 11000 10000 1,000 1,000 114 11100 1,100 1,100 11142 1,185 1,229 201194 201308 211408 221508 23,608 241750 251935 201308 211408 221508 231608 241750 25,935 271164 Revenues % Change from Prior Year 1742.11% 0.00% 0.00% 2.00% 2.01% 2.01% Expenses % Change from Prior Year +++ 0.00% 0.00% 0.00% 0.00% 0.00% F,I E ulllln'. VE, .,RF ,I i. w1% ,MM.. i...., .,MIM'..i. FR,EC, . . I IP'All"" 20202024 IIIIIII SII -... DUI 1:::kii e !:::, a rig d Revenues Fines & Forfeits Investment Income Revenues Total Expenses Other Employee Costs Contractual Services Other Equipment Expenses Total Excess (Deficiency) of Revenues & Other Sources Over Expenditures Fund Balance, Beginning of Year Fund Balance, End of Year ' 1 "UNI.,11,11H111 D FUND 2018 2019 2020 2021 2022 2023 2024 Actual Estimate Budget Forecast Forecast Forecast Forecast 21,665 21,665 241000 25,000 25,500 26,010 26,530 313 350 300 300 307 314 321 21,978 22,015 24,300 25,300 25,807 26,324 26,851 550 - 1,000 - - - - 0 - 1,000 - - - - 24,981 - - - 12,000 14,000 16,000 25,531 - 2,000 - 12,000 14,000 16,000 -3,553 22,015 22,300 25,300 13,807 12,324 10,851 1401926 1371373 1591388 1811688 2061988 2201795 2331119 1371373 1591388 1811688 2061988 2201795 2331119 2431970 Revenues % Change from Prior Year 0.17% 10.38% 4.12% 2.00% 2.00% 2.00% Expenses % Change from Prior Year -100.00% +++ -100.00% +++ 16.67% 14.29% EAR F,OM1.. Eulllln'• V F w1%,I ."', .,MIM'. d�.� .,1 �.. m�, . .I " 2020 ullllll �IIIIII�' u i. i IIIIII�4.'IGN „WW.� .�� VIIIF 0 R „WM'...4 IFI "' III° •9 �� 2018 2019 2020 2021 2022 2023 2024 Actual Estimate Budget Forecast Forecast Forecast Forecast m,,, :: ii,,ei iiia I1:::: i hire 1 a Bowird uir I,,,, u uil 046 1 8.07% -11.79% 0.00% 2.49% 2.49% 2.49% Expenses % Change from Prior Year Revenues 2.44% 2.38% 2.58% 2.77% 2.95% Other Taxes 78,234 85,000 75,000 75,000 76,875 78,797 80,767 Investment Income 3,793 3,650 3,200 3,200 3,272 3,346 3,421 Revenues Total 82,027 880650 78,200 78,200 80,147 82,143 84,188 Expenses Other Employee Costs 3,731 15,000 15,000 15,000 15,262 15,529 15,800 Contractual Services 10,729 10,500 10,500 10,500 10,710 10,924 111143 Insurance 0 500 500 500 511 522 533 Commodities & Supplies 13,000 13,000 13,000 13,000 13,228 13,460 13,696 Building Improvements 0 5,000 5,000 5,000 5,113 5,228 5,346 Other Equipment 8,760 24,000 24,000 24,000 24,000 24,000 24,000 Expenses Total 36,220 68,000 68,000 680000 68,824 69,663 70,518 Excess (Deficiency) of Revenues & Other Sources Over Expenditures 45,807 20,650 101#200 10,200 11,323 12,480 13,670 Fund Balance, Beginning of Year 3521416 3981223 4181873 4291073 4391273 450,596 4631076 Fund Balance, End of Year 3981223 4181873 4291073 4391273 4501596 4631076 476,746 Revenues % Change from Prior Year 8.07% -11.79% 0.00% 2.49% 2.49% 2.49% Expenses % Change from Prior Year 5.19% 2.44% 2.38% 2.58% 2.77% 2.95% FIVE YEAR FI "." .I . F R, E .S 111111 I nnim 2 P mnni 2 2 ,m FUN UIII BUSINESS D. I IIIr A III°' I'4UD 2018 Actual 2019 Estimate 2020 Budget 2021 Forecast 2022 Forecast 2023 Forecast 2024 Forecast ,, .,,, Business Distiiirict II,,,,, u iiiryii d Revenues Other Taxes 1,027,370 1,016,900 1,033,595 1,051,450 1,075,398 1,099,904 11124,980 Intergovernmental Revenue 531,398 495,900 5141000 531,990 538,823 545,755 552,789 Investment Income 13,162 8,800 6,500 5,500 5,624 5,751 5,880 Revenues Total 1,571,930 1,521,600 1,554,095 1,5880940 11619,845 11651,410 11683,649 Expenses Interest Expense 1,571,930 1,521,600 1,554,095 1,588,940 1,619,845 1,651,410 1,683,649 Expenses Total 1,571,930 1,5210600 1,554,095 10588,940 1,6190845 1,651,410 1,683,649 Excess (Deficiency) of Revenues & Other Sources Over Expenditures - - - - - - - Fund Balance, Beginning of Year - - - - - - - Fund Balance, End of Year I I I I I I I I I I I - I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I - I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I - I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I - I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I - I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I - I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I - I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I Revenues % Change from Prior Year -3.20% 2.14% 2.24% 1.95% 1.95% 1.95% Expenses % Change from Prior Year -3.20% 2.14% 2.24% 1.95% 1.95% 1.95% FIVE YEAR FI . �"' M . F R1 .. AC, . . S 111111 nnim nn 0 mnni 2 2 .m FU . . "Ui'i ANDMAIN "I' .NIII'll Revenues % Change from Prior Year 2018 2019 2020 2021 2022 2023 2024 -3.75% Actual Estimate Budget Forecast Forecast Forecast Forecast 049 mm, 1)irospect and Ma[in iiia °°111f 11::: i', istiiirict Revenues Property Taxes 469,613 433,000 738,000 873,900 1,315,322 2,299,855 2,677,205 Investment Income 78,498 18,500 15,500 12,500 12,781 13,069 13,363 Other Revenue 169,345 - - - - - - Other Financing Sources 7,318,879 9,355,760 - - - - - Revenues Total 81036,335 918070260 753,500 886,400 1,328,103 2,312,924 2,690,568 Expenses Other Employee Costs 11200 750 1,500 1,500 1,526 1,553 1,580 Contractual Services 351,826 200,300 233,636 145,509 148,419 151,387 154,414 Commodities & Supplies 161 600 1,500 1,000 1,018 1,036 1,054 Other Expenditures 10,577,843 21225,000 458,500 150,985 151,495 152,010 152,530 Land Improvements 401053 7091500 - - - - - Building Improvements 0 7,030,000 - - - - - Infrastructure 700 260,000 1,035,990 110,000 110,200 110,404 110,612 Bond Principal 0 - - 3201000 3601000 5951000 6601000 Interest Expense 3101423 4321738 7861447 7301251 7151651 699,201 6711151 m Bank & Fiscal Fees 225 225 11000 11000 500 500 500 m Expenses Total 11,282,431 10,859,113 2,518,573 1,460,245 1,488,809 1,711,091 1,751,841 Excess (Deficiency) of Revenues & Other Sources Over Expenditures -31246,096 (1,051,853) (1,765,073) (573,845) (160,706) 601,833 938,727 Fund Balance, Beginning of Year 3,9441426 6981330 (353,523) (2,1181596) (2,692,441) (2,853,147) (2,251,314) Fund Balance, End of Year 6981330 (353,523) (2,1181596) (2,692,441) (2,853,147) (2,251,314) (1,312,587) Revenues % Change from Prior Year 22.04% -92.32% 17.64% 49.83% 74.15% 16.33% Expenses % Change from Prior Year -3.75% -76.81% -42.02% 1.96% 14.93% 2.38% um IV .FORECAST m 2024 , m,v oN -10.10% -17.02% 7.28% Expenses % Change from Prior Year 39.92% -3.67% (MAJOR ......... . .M 29.95% 2018 2019 2020 2021 2022 2023 2024 Actual Estimate Budget Forecast Forecast Forecast Forecast 50 - Water and Se e iiir II,,,,, u iiia Revenues Property Taxes -5,037 - - - - - - Licenses, Permits & Fees 21,300 21,950 201#000 20,000 20,200 20,402 20,606 Intergovernmental Revenue 0 - - 2,000,000 - - - Charges For Services 14,119,533 15,129,630 16,140,840 17,301,470 18,566,372 19,926,506 21,389,191 Fines & Forfeits 104,500 103,000 1001000 100,000 102,000 104,040 106,121 Investment Income 191,467 193,600 66,100 39,100 39,980 40,879 41,799 Reimbursements 0 10,000 10,000 10,000 10,300 10,609 10,927 Other Revenue 62,069 61,900 60,000 60,000 60,900 61,814 62,741 Other Financing Sources -61 10,016,000 - 7,500,000 5,500,000 - - Revenues Total 14,493,771 25,536,080 161396,940 27,030,570 24,299,752 200164,250 21,631,385 Expenses Personal Services, Salaries & Wages 2,297,086 2,224,972 2,349,752 2,430,567 2,503,488 2,578,596 2,655,956 Employee Benefits 1,061,118 888,909 1,020,929 1,049,906 1,078,785 1,108,453 111138,938 Other Employee Costs 431352 441114 451347 451896 461698 47,516 481348 Contractual Services 85531153 911071635 912331013 914311065 911`6191688 91812,086 101008330 Utilities 1161606 1621710 1661174 1691496 1731310 177,210 181,197 Insurance 991975 1171789 1341892 134,892 137,725 1401617 1431570 Commodities & Supplies 2601650 3351803 3341688 3401676 346,637 3521704 3581878 Other Expenditures 6961009 - - - - - - Building Improvements 671562 2851000 3851000 - - - - Office Equipment 11060 11081 11103 11125 11125 1,125 11125 Other Equipment 2251455 2121429 1781778 1351154 1351154 135,154 2301154 Distribution Systems 1,7031973 716021642 517581142 713681142 1317191023 71419,914 71290,813 Bond Principal 0 2401000 3251000 5251000 5751000 625,000 680,000 Interest Expense 2951242 3431081 8411248 663,081 638,331 6111181 5811681 Bank & Fiscal Fees 225 11225 21500 21500 11500 11500 11500 Long Term Debt -61948 - - - - - - Expenses Total 15,414,518 21,567,390 20,776,566 22,2971500 281F976,464 23,011,056 23,320,490 Excess (Deficiency) of Revenues & Other Sources Over Expenditures -920,747 3,9681690 (4,379,626) 41733,070 (4,676,712) (2,846,806) (1,689,105) Fund Balance, Beginning of Year 818381152 719171405 1118861095 715061469 121239,539 715621827 417161021 Fund Balance, End of Year 719171405 1118861095 7,506,469 1212391539 7,5621827 417161021 310261916 Revenues % Change from Prior Year 76.19% -35.79% 64.85% -10.10% -17.02% 7.28% Expenses % Change from Prior Year 39.92% -3.67% 7.32% 29.95% -20.59% 1.34% FIVE YEAR FI M"' M . F R1 . AC, . .S 111111 nnim nn P mnni 2 2 .m 51 m,,,Village Pairkfing S ste iiirn I,,,,, and Revenues Charges For Services Investment Income Other Revenue Revenues Total Expenses Personal Services, Salaries & Wages Employee Benefits Contractual Services Insurance Commodities & Supplies Building Improvements Infrastructure Expenses Total Excess (Deficiency) of Revenues & Other Sources Over Expenditures Fund Balance, Beginning of Year Fund Balance, End of Year Revenues % Change from Prior Year Expenses % Change from Prior Year ,WN. �. ' ..� ' aill ... 1�..... ... .d�� 1 11 PARKING �' AII1"rE M 2018 2019 2020 2021 2022 2023 2024 Actual Estimate Budget Forecast Forecast Forecast Forecast 183,066 192,700 191,100 188,600 191,715 194,892 198,133 3,649 4,250 3,500 3,500 3,579 3,660 3,742 3,044 2,000 3,000 3,060 3,106 3,153 3,200 189,759 198,950 197,600 195,160 198,400 201,705 2050075 39,187 16,916 18,933 19,594 20,182 20,788 21,412 17,509 6,844 7,713 7,949 8,169 8,394 8,625 40,775 131,389 199,912 69,238 70,623 72,036 73,477 242 285 326 326 333 340 347 552 563 574 585 595 605 616 0 7,506 - - - - - 35,030 50,000 50,000 75,000 75,000 130,000 75,000 133,295 213,503 277,458 172,692 174,902 232,163 179,477 56,464 (14,553) (79,858) 22,468 23,498 (30,458) 25,598 3111519 3671983 3531430 2731572 2961040 319,538 2891080 3671983 3531430 2731572 2961040 319,538 2891080 3141678 4.84% -0.68% -1.23% 1.66% 1.67% 1.67% 60.17% 29.96% -37.76% 1.28% 32.74% -22.69% FIVE YEAR FI M"' M . F R1 . AC, . .S 111111 nnim nn P mnni 22.mEVEN PARKING IP R. 2018 2019 2020 2021 2022 2023 2024 Actual Estimate Budget Forecast Forecast Forecast Forecast 52 m,,, Pariking S steiiirn Re eiiiaa I,,,,,u nd 2.15% -0.75% 0.62% 1.04% 1.05% 1.06% Expenses % Change from Prior Year Revenues 3.68% 1.82% 2.15% 2.16% 2.15% Charges For Services 155,249 157,500 156,500 157,500 159,100 160,732 162,397 Investment Income 1,703 1,860 1,650 1,650 1,687 1,725 1,764 Other Revenue 11201 21200 2,200 2,200 2,233 2,267 2,301 Revenues Total 158,153 1610560 160,350 161,350 1630020 1640724 1660462 Expenses Personal Services, Salaries & Wages 28,703 15,576 18,838 19,496 20,081 20,684 21,305 Employee Benefits 12,763 6,582 7,667 7,903 8,122 8,345 8,574 Contractual Services 94,768 113,511 114,461 116,104 118,425 120,795 123,211 Utilities 5,975 9,799 9,998 10,198 10,427 10,662 10,901 Insurance 248 292 335 335 342 349 356 Commodities & Supplies 6,865 10,796 11,011 11,231 11,427 11,628 11,831 Building Improvements 29,121 - - - - - - Expenses Total 178,443 156,556 1620310 165,267 168,824 1720463 1760178 Excess (Deficiency) of Revenues & Other Sources Over Expenditures -20,290 5,004 (1,960) (3,917) (5,804) (7,739) (9,716) Fund Balance, Beginning of Year 1451906 1251616 1301620 1281660 1241743 118,939 1111200 Fund Balance, End of Year 1251616 1301620 1281660 1241743 118,939 111,200 1011484 Revenues % Change from Prior Year 2.15% -0.75% 0.62% 1.04% 1.05% 1.06% Expenses % Change from Prior Year -12.27% 3.68% 1.82% 2.15% 2.16% 2.15% FIVE YEAR FI „'I M . F R1 , AC, . .S 111111 nnim nn P mnni 2 2 ,m FU . . VIII ... MIX OM1. . I IIP E N C E 2018 2019 2020 2021 2022 2023 2024 Actual Estimate Budget Forecast Forecast Forecast Forecast 060 - Vehicle I a i iinteliin a since II,,,°u find 0.17% 23.10% -5.64% 2.56% 2.56% 2.56% Expenses % Change from Prior Year Revenues 12.96% 2.47% 2.56% 2.56% 2.56% Charges For Services 2,040,827 2,046,358 2,520,488 2,377,977 2,425,535 2,474,048 2,523,530 Investment Income 6,569 6,000 6,000 6,000 6,135 6,273 6,414 Other Revenue 0 - - - 13,290 27,253 41,920 Other Financing Sources 1,537 - - - - - - Revenues Total 21048,933 2,0520358 21526,488 20383,977 2,4440960 2,507,574 205710864 Expenses Personal Services, Salaries & Wages 1,049,507 947,587 1,122,417 1,161,192 1,196,028 11231,910 111268,867 Employee Benefits 457,011 366,838 4331-251 446,252 458,526 4711137 4841094 Other Employee Costs 3,984 4,167 4,250 4,335 4,411 4,488 4,567 Contractual Services 113,401 111,883 113,954 116,253 118,579 120,950 123,370 Utilities 5,071 5,113 5,431 5,450 5,572 5,698 5,826 Insurance 9,935 11,706 13,405 13,405 13,687 13,974 14,268 Commodities & Supplies 598,070 607,808 629,183 632,351 643,418 654,678 666,133 Office Equipment 298 614 626 639 639 639 639 Other Equipment 31504 31941 41019 41100 41100 4,100 41100 Expenses Total 21240,781 2,059,657 21326,536 2,383,977 2,444,960 2,507,574 2,571,864 Excess (Deficiency) of Revenues & Other Sources Over Expenditures -191,848 (7,299) 199,952 - - - - Fund Balance, Beginning of Year 5881571 3961723 3891424 5891376 5891376 589376 5891376 Fund Balance, End of Year 3961723 3891424 5891376 5891376 5891376 5891376 589376 Revenues % Change from Prior Year 0.17% 23.10% -5.64% 2.56% 2.56% 2.56% Expenses % Change from Prior Year -8.08% 12.96% 2.47% 2.56% 2.56% 2.56% FIVE , FINAM"'AlA.1. FE, Sl.°1 2020,11,11,12024 1111.1 � . . . " � I mi'i 111 l" . i� X �M,'��fif ... C �N'1 � �N'111� . 2018 2019 2020 2021 2022 2023 2024 Actual Estimate Budget Forecast Forecast Forecast Forecast 1 Vehicle 11e, llace iiirneiint Fuiind 25.98% -16.27% 0.00% 0.19% 0.19% 0.19% Expenses % Change from Prior Year Revenues -16.23% 155.91% -56.40% -20.88% 212.82% Charges For Services 1,611,300 211321100 1,779,560 1,779,560 1,779,560 1,779,560 1,779,560 Fines & Forfeits 10,787 19,000 19,000 19,000 19,380 19,768 20,163 Investment Income 112,771 144,000 144,000 144,000 147,240 150,553 153,940 Other Financing Sources 1061814 251000 - - - - - Revenues Total 1,841,672 2,320,100 1,942,560 1,9420560 1,946,180 11949,881 1,953,663 Expenses Other Expenditures 806,514 - - - - - - Motor Equipment 5,598 1,434,901 1,202,000 3,076,000 1,341,000 1,061,000 3,319,000 Expenses Total 812,112 1,434,901 1,202,000 3,076,000 1,341,000 11061,000 3,319,000 Excess (Deficiency) of Revenues & Other Sources Over Expenditures 11029,560 8850199 740,560 (10133,440) 605,180 888,881 (11365,337) Fund Balance, Beginning of Year 7,9501356 819791916 918651115 1016051675 9,4721235 101077,415 1019661296 Fund Balance, End of Year 819791916 918651115 1016051675 914721235 1010771415 10,9661296 916001959 Revenues % Change from Prior Year 25.98% -16.27% 0.00% 0.19% 0.19% 0.19% Expenses % Change from Prior Year 76.69% -16.23% 155.91% -56.40% -20.88% 212.82% FIVE YEAR FI "." .I . F R, E .S 111111 2 2 P mnni 2 2 ,m 62 .,,, Coiirn II uter le'IIl laceiiirneiint F u find Revenues Charges For Services Investment Income Revenues Total Expenses Other Expenditures Building Improvements Office Equipment Expenses Total Excess (Deficiency) of Revenues & Other Sources Over Expenditures Fund Balance, Beginning of Year Fund Balance, End of Year Revenues % Change from Prior Year Expenses % Change from Prior Year �V.�`U ,�� ' uili �� ' M. �'. IIP" �F:� REPIACI �N� I „��, � �M1'::j �. �F': A IN"I" IIP ." 2018 2019 2020 2021 2022 2023 2024 Actual Estimate Budget Forecast Forecast Forecast Forecast 205,097 162,897 159,979 163,978 167,274 170,635 174,065 6,768 - - - - - - 211,865 162,897 159,979 163,978 167,274 170,635 1741F065 13,709 - - - - - - 0 250,000 - - - - - 146,625 225,000 189,978 199,978 159,978 159,978 199,978 160,334 475,000 189,978 199,978 159,978 159,978 199,978 51,531 (312,103) (29,999) (36,000) 7,296 10,657 (25,913) 6791225 7301756 4181653 3881654 3521654 3591950 3701607 7301756 4181653 3881654 3521654 3591950 3701607 3441694 -23.11% -1.79% 2.50% 2.01% 2.01% 2.01% 196.26% -60.00% 5.26% -20.00% 0.00% 25.00% AR FIVE YE F w1%,I ."', .,MIM'. Fd�.� .,1��..� m�, . .I IN .' 2020 ullllll �IIIIII�' u i. i IIIIII�4 I " . ' � .�� VIII RISK N 2018 2019 2020 2021 2022 2023 2024 Actual Estimate Budget Forecast Forecast Forecast Forecast 63 m,,, RUsk Managerneint II,,,, a uirnd 3.33% 3.54% 1.65% 4.57% 2.10% 2.10% Expenses % Change from Prior Year Revenues 1.06% 2.56% 2.10% 2.10% 2.10% Charges For Services 7,094,913 7,259,280 7,738,478 7,894,888 8,307,811 8,492,284 8,680,779 Investment Income 20,944 15,430 16,000 16,000 16,360 16,728 17,104 Reimbursements 19,337 209,950 52,000 52,000 53,040 54,101 55,183 Other Revenue 1,708,941 1,654,087 1,656,000 1,656,000 1,680,840 1,706,053 1,731,645 Revenues Total 8,844,135 9,138,747 9,462,478 9,618,888 10,058,051 101269,166 10,484,711 Expenses Contractual Services 16,200 25,000 40,000 40,000 40,800 41,616 42,448 Insurance 8,125,486 9,461,689 9,542,800 9,793,276 9,998,936 10,208,914 10,423,301 Commodities & Supplies 8,668 18,000 22,500 18,000 18,315 18,636 18,962 Other Equipment 11113 - - - - - - Expenses Total 8,151,467 9,504,689 9,605,300 9,8510276 10,058,051 101269,166 10,484,711 Excess (Deficiency) of Revenues & Other Sources Over Expenditures 692,668 (365,942) (142,822) (232,388) - - - Fund Balance, Beginning of Year 2,9851464 316781132 313121190 311691368 2,9361980 21936,980 219361980 Fund Balance, End of Year 3,6781132 313121190 311691368 219361980 219361980 219361980 219361980 Revenues % Change from Prior Year 3.33% 3.54% 1.65% 4.57% 2.10% 2.10% Expenses % Change from Prior Year 16.60% 1.06% 2.56% 2.10% 2.10% 2.10% FIVE YEAR FI "." .I . FR,E .S 111111 2 2 P mnni 2 2 .m ,'"UN ..., .. 2018 2019 2020 2021 2022 2023 2024 Actual Estimate Budget Forecast Forecast Forecast Forecast 070 -... Police 1 eiirii cion Il,,,, a iiiii d 1459.17% -35.46% 2.14% 1.85% 1.85% 1.85% Expenses % Change from Prior Year Revenues 4.76% 1.03% 2.97% 2.97% 2.97% Investment Income -3,570,236 9,171,260 4,077,150 4,191,950 4,286,270 4,382,711 4,481,321 Other Revenue 4,447,495 4,506,670 4,751,225 4,825,400 4,897,782 4,971,250 5,045,819 Revenues Total 877,259 13,6770930 80828,375 9,017,350 9,1840052 9,353,961 905270140 Expenses Pension Benefits 5,407,696 5,829,273 6,106,434 6,168,469 6,353,523 6,544,129 6,740,453 Contractual Services 151,074 164,781 169,140 172,270 175,716 179,229 182,814 Insurance 5,250 10,000 15,000 15,000 15,315 15,637 15,965 Other Expenditures 8,190 12,000 12,000 12,000 121120 121241 12,364 Expenses Total 5,572,210 61016,054 60302,574 6,3670739 60556,674 607510236 61951,596 Excess (Deficiency) of Revenues & Other Sources Over Expenditures -41694,951 716610876 21525,801 2,649,611 2,6270378 2,602,725 205750544 Fund Balance, Beginning of Year 71,0691059 6613741108 7410351984 7615611785 79,211,396 8118381774 8414410499 Fund Balance, End of Year 663741108 7410351984 7615611785 7912111396 8118381774 8414411499 8700170043 Revenues % Change from Prior Year 1459.17% -35.46% 2.14% 1.85% 1.85% 1.85% Expenses % Change from Prior Year 7.97% 4.76% 1.03% 2.97% 2.97% 2.97% FIVE YEAR F '� . F E S Ill.°1 2020,11,11,12024 2018 2019 2020 2021 2022 2023 2024 Actual Estimate Budget Forecast Forecast Forecast Forecast 3„ .,,, Fire 1)e iirii siii n II,,,, a rig d 487.36% -38.20% 4.70% 1.86% 1.86% 1.86% Expenses % Change from Prior Year Revenues 2.00% 2.40% 2.97% 2.97% 2.97% Investment Income -1,815,753 8,774,010 3,791,100 4,040,220 4,131,129 4,224,082 4,319,126 Other Revenue 4,020,773 4,177,350 4,213,150 4,339,850 4,404,949 4,471,023 4,538,089 Revenues Total 21205,020 12,9510360 80004,250 8,380,070 8,5360078 8,695,105 808570215 Expenses Pension Benefits 5,909,910 6,314,288 6,439,854 6,596,247 6,794,135 6,997,959 7,207,898 Contractual Services 148,273 1411235 144,280 146,370 149,298 152,284 155,330 Insurance 5,650 15,000 15,000 15,000 15,315 15,637 15,965 Other Expenditures 8,000 9,000 10,000 10,000 10,100 10,201 10,303 Expenses Total 6,071,833 61479,523 60609,134 617670617 60968,848 701760081 7,389,496 Excess (Deficiency) of Revenues & Other Sources Over Expenditures -31866,813 614710837 11395,116 1,612,453 1,5670230 1,519,024 104670719 Fund Balance, Beginning of Year 66,2651343 6213981530 6818701367 7012651483 71,877,936 7314451166 7419640190 Fund Balance, End of Year 62,3981530 6818701367 7012651483 7118771936 7314451166 7419641190 7604310909 Revenues % Change from Prior Year 487.36% -38.20% 4.70% 1.86% 1.86% 1.86% Expenses % Change from Prior Year 6.71% 2.00% 2.40% 2.97% 2.97% 2.97%