Loading...
HomeMy WebLinkAbout7.1 First reading of an ordinance adopting an annual budget for the VOMP - January 2020 - December 2020 11/8/2019 BoardDocs®Pro IL Agenda Item Details Meeting v 05,, 2019 - REGULAR MEETINGLL - . *REVISED 11-02-2019 Category 7. NEW BUSINESS Subject 7.1 1st reading I VILLAGE PROSPECT,MOUNT ILLINOIS FOR FISCALI JANUARY 1, 2020 AND ENDING DECEMBER 1, 2020 IN LIEU OF PASSAGE OF AN APPROPRIATION Access Public Type cin Preferred to Nov 19,, 2019 Absolute Date Nov 19, 2019 Fiscal Impact Yes Budgeted Yes Recommended cin Approve the accompanying ordinance adopting the 2020 annual budget. Public Content Information The Village Manager's Office released the Proposedget on September 27, 2019. DuringOctober, the Village Board, i nce Commission, meeting separately and as a joint Committee of the Whole, held three public meetings to review the budget and to provideresidents n opportunity to participate in the budget process. Departmental presentations were made with various staff on hand to facilitatediscussion. The following link will take you to the ill proposed cm , or visit www.mountprospect.org/budget. Proposed 2020 Budget The proposed spendingI is a responsible and tr rent financial plan that incorporates key policies and priorities established y the Mayor, Board of Trustees and Finance Commission. The total budget for 2020 is $147,,986,,173, decrease .1 ercent from the amended 2019 budget. The General Fund, as presented, totals $62,,110.,625. This is an increase 7.0 percent from rir year, mainly due to transfer pertaining to the major flood control project. public hearing on the proposed budget has been scheduled for November 19,, 2019. Noticethe public hearing will be published in the Daily Herald on November 8, 2019. 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 assembled for distribution no later than December 31, 2019. Alternatives 1. Village r ry I of the Proposed 2020 2. Action at discretionill r . Staff Recommendation https://go.boarddocs.com/il/vomp/Board.nsf/Private?open&login 1/2 11/8/2019 BoardDocs®Pro It is recommended the Village Boardass the accompanying r i ce adopting the 2020 annual budget. 2020 Budget i i (4,736 KB) Administrative Content Executive Content 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 2018 2019 2019 2020 2021 Actual Budget Estimate Budget Forecast REVENUES D III"IYM.'NN.... I-.S .'NN.CEI'M 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 11J42,375 1113371010 Other Financing Sources 50,313,549 21,815,000 20,936,760 4,p768..000 81250,000 Total Revenues&Other Sources 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 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. EVI NUES AND 01. .... SOURCESBY REVI quN'IJE 11"'1.,YPE1 2018 2019 2019 2020 2021 Actual Budget Estimate Budget Forecast IIEV'ENUES Byr"'I"Y11E Property Taxes 19,223,535 19,,4061000 19,253,100 19p955p359 20,621,735 Other Taxes 14,084,956 14,018,000 13,531,028 130591,375 13,811,394 Licenses, Permits&Fees 3;2981,693 3,032,000 3,164,180 3p1120300 311781,400 Intergovernmental Revenue 33,481,944 33,628,395 34,766,709 36,p723,800 42,944,390 Charges For Services 30,820,500 33,066,772 32,553,465 34,304,445 35,491,473 Fines&Forfeits 591;472 616;000 561/625 558,p550 564;100 Investment Income (4;366;416) 8;178;400 19,354,940 80539,p950 8;814;870 Reimbursements 373,622 228;500 491,112 391..937 391;937 Other Revenue 11,350,707 10;996;246 10,956,765 110142,375 11337.1010 Total Revenues 108,859,013 123;1701313 134;6321924 1280320,091 137;155IF309 01"'I"I I.Ell.IINANCING SOURCES Interfund Transfers 21354;391 1;540;000 1,966,000 4,p768..000 750;000 Bond Proceeds 471283.0506 19,200,000 17,016,000 7,500,000 Other 675,652 1;075;000 1;954;760 - Total Other Financing Sources 50,313,549 21;815;000 20;936;760 4p768pOOO 81250;000 TOTAL REVENUES AND OTHER SOURCES 159.,172..562 144,985,p313 155.,569,684 133,088p091 145,405,309 Ct--IA.N'GES IN IIJND BA.1..A.NCE/NE1`-'1."A S"isSi-ElTS Total Revenues and Other Sources 159;172;562 144;985;313 155;569;684 133p088p091 145;405;309 Total Expenditures 129;363;965 170;353;451 167;454;174 147p986pl73 146;499;072 Additions to(Use of) Fund Balance 29;8081597 (25;368;138) (11;884;490) (14p8980082) (11093,763) ANALYSIS OF C11ANGES IN FUND BALANCE/NE"17 ASSE"I.."S Additions to(Use of) Pension Fund Balances (8;561;764) 3;922;255 141133;713 3p920p917 4;262;064 Additions to(Use of)Other Fund Balances 38;370;361 (29;290;393) (26,018;203) (18,818p999) (5;355,827) Additions to(Use of) Fund Balance 29;808;597 (25;368;138) (11;884;490) (14,8981082) (1;093;763) �Revennditures, aVIrid Furid Balance/Net Assets (exd�Wlhig PeInd sliuVIII iids) 200,000,000 150;000,0 R Ad Ld�Ievewes 1 00,000,000 III W ExIpei idiLwres 50)000000 MIII ii,'id B,44i'icdttlYe 20''18Activa�I 2019 Est 2020 Btid t 2 0'?''I I:ares a'st, , :1M G]4A'"'I" .A ;u .111,1,.1 � ,� AND.[.. . .:....�u 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 4J151378 41209,863 FINANCE ILII I°""'rEN"r 3,0721857 2,8721269 219521929 2,0033p953 21080,249 COMINAUNITY DE EL. II)I TIENT DEIPAR"'ruIENT 2,9041191 31,2411391 310551350 %582p414 315881279 HUMAN SE11VICES DIIEIP II°""'rI ENT 1,1651270 1,1691936 111321082 1,198p882 112361277 P U B II IC SAFETY AN D II:)Ili "'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 IEN""'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 RIIIIII; 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 FENS I N SYSTEMS BUDGET b) 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 kid Transfers 140 000 000 W Bus Dist 120,000,000 ��� � � W TIF Dist 100,000,000 W Internal Services 800001000 m m w. 1 Ld Pension System 60,0001000 40 000 000 ���� �� �� ���� . . Debt 20 000 000 CIP O eratin Budget p g g 2018 Actual 2019 Budget 2020 Budget 2021 Forecast (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 AND 0 I'l MR.SOUIR.C]["'S I 3Y]" 2018 2019 2019 2020 2021 Actual Budget Estimate Budget Forecast G 1,;;;;;;;1" 1,;;;;;;;1, L.J D 58,,966;726 56,118,900 571748,040 58,p666,426 591364,612 D F S [IV I C E F U N D 13;137,709 51827,228 51888,228 5,?109,F150 51314,846 CAI!!)I""I Al 1!!)I!10JEC""I S F!!!!�U 1' D S 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,950 4..818,p3OO 675,536 Police& Fire Building Const. 33,.688;743 88,000 527,000 36,v500 - Total Capital Projects Funds 40,249,378 81418,422 81121,050 12,p274,700 12,394,408 SF)ECIAI REVENLJE F!!!!L.JNDS Refuse Disposal Fund 41407,105 41371,720 41392,750 4,p374,p950 41369,950 Motor Fuel Tax Fund 11,4291563 11435,1000 114451,310 l..934y350 114931.4350 CDBG 3871#846 4661#971 314,219 622,800 540.#800 Asset Seizure Fund 11.1284 121#000 18.1480 14,v500 14,500 Federal Equitable Share Funds 114 2/200 2.1100 2y100 2,100 DUI Fine Fund 21.9978 25.1500 22,4015 24,300 25,300 Foreign Fire Tax Board Fund 82,027 94.1000 88,4650 78,p2OO 78,200 Business District Fund 11571,1930 1,525,000 11521,1600 1,p554y095 111588,4940 Prospect and Main TIF District 81,0361335 101484,1000 918071,260 753y5OO 886.4400 Total Special Revenue Funds 151948.#182 181416,1391 17,612,384 9..358y795 9,437,540 iiiiiiiiiiiiiiiiiiiiiillillillillillillilliillillillillillillillillillillillilillillillillillillilliillillillillillillilliillillilillillillillillillillillilillillillillillillilliillillillillillillilliillillilillillillillillillillillilillillillillillillilliillillillillillillilliillillilillillillillillillillillilillillillillillillilliillillillillillillilliillillilillillillillillillillillilillillillillillillilliillillillillillillilliillillilillillillillillillillillilillillillillillillilliillillillillillillilliillillilillillillillillillillillilillillillillillillilliillillillillillillilliillillilillillillillillillillillilillillillillillillilliillillillillillillilliillillilillillillillillillillillilillillillillillillilliillillillillillillilliillillilillillillillillillillillilillillillillillillilliillillillillillillilliillillilillillillillillillillillilillillillillillillilliillillillillillillilliillillilillillillillillillillillilillillillillillillilliillillillillillillilliillillilillillillillillillillillilillillillillillillilliillillillillillillilliillillilillillillillillillillillilillillillillillillilliillillillillillillilliillillilillillillillillillillillilillillillillillillilliillillillillillillilliillillilillillillillillillillillilillillillillillillilliillillillillillillilliillillilillillillillillillillillilillillillillillillilliillillillillillillilliillillilillillillillillillilliIII EN""FERPRISE FL..JNDS Water and Sewer Fund 141493,771 25,940,700 25,5361080 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..890 27,387,080 IN I E 11 N E 11V I C E w IIS D S Vehicle Maintenance Fund 21048,933 21052,358 21052,358 2y526,0488 21383,977 Vehicle Replacement Fund 11841,672 21337,100 21320,100 1p942,p560 11942,560 Computer Replacement Fund 211,865 166,897 162,897 15 9..979 163,978 Risk Management Fund 81844,135 91255,217 91138,747 9,p462,p478 91618,888 Total Internal Service Funds 12,,946.,605 13,811,572 13,674,102 14pNly505 141109,403 F!!!,III DUCIII A1!1Y F1 JNDS Police Pension Fund 877,259 81419,500 13,677,930 8p828,0375 91017,350 Fire Pension Fund 21205,020 71681,800 12,951,360 %004..250 81380,070 Total Fiduciary Funds 31082,279 16,101,300 26,629,290 16,p832,p625 17,397,420 TOTAL REVENUES&OTHER SOURCES 159..172.,562 144,,985.,313 155.,569,1684 133,p088y091 145,405,309 E,.X1.1'E.'.ND1",rUR.ES BY F"UNI) 2018 2019 2019 2020 2021 Actual Budget Estimate Budget Forecast G E1' E1„ LJ N D 55,3081129 58,034,709 58,322,540 62J10,p625 581925,922 ""F S E[IV I C E F U IN ID 91171,399 61726,407 6�6461717 6,p565,p732 61694,902 CA 1!! 1"'1 Al f!"[I OJ E C"'FS F U N D S 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 468,596 41221,500 3?921,683 4,v513,v701 61760,711 Police& Fire Building Const. 11968,563 24,936,982 23,7661662 8J02,p400 - Total Capital Projects Funds 61530,651 37,298,922 35,0951051 20,v075y373 19,138,857 SF)EGAI �R E V E N L.J E 1'�D S Refuse Disposal Fund 41528,996 41557,185 41727,988 41782..743 41920,958 Motor Fuel Tax Fund 11742.1901 2,085,173 1119671,173 2,p226,r376 1,870,402 CDBG 387,848 4661#971 314,219 622,p8OO 540,800 Asset Seizure Fund 42.9936 34,4000 23.1500 7j,000 7,000 Federal Equitable Share Funds - 2,000 1,000 iV000 1,000 DUI Fine Fund 25,531 21.1500 - 2,v000 - Foreign Fire Tax Board Fund 36,220 68.1000 68,4000 68,pOOO 68Y000 Business District Fund 11,5711930 11525,1000 111521,1600 l..554..095 1,588,940 Prospect and Main TIF District 111282.1431 11,034,238 10,859,113 2,v518,r573 1,460,245 Total Special Revenue Funds 19,1618.1793 191794,1067 191482.1593 11y782,p587 10,457,345 iiiiiiiiiiiiiiiiiiiiiillillillillillillilliillillilillillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillillillillilI EN"FERPRISE FL..JNDS 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,1256 22,664,281 21,937,449 21,p216,334 22,635,459 1 IN� 1 E II N A IL S E1I C E III,,,,,,,L. IIIA D S Vehicle Maintenance Fund 21240,781 21034,247 21059,657 2..326y536 21383,977 Vehicle Replacement Fund 812,112 11925,000 11434,901 1p202y000 31076,000 Computer Replacement Fund 160,334 487,900 475,000 189j,978 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 F!!!�III DUCIII A11Y H JNDS Police Pension Fund 51572,210 51985,209 61016,054 6,0302j,574 61367,739 Fire Pension Fund 61071,833 61193,836 61479,523 6,p609J34 61767,617 Total Fiduciary Funds 11;644,043 121179,045 121495,577 12,p911p708 13,135,356 TOTAL EXPENDITURES 129,363,965 170,,353,,451 167,454,174 147,p986y173 146,v499,p072 � � � , ;„ ; FUND:: �Ex . .1,1, ,� � .f 11A.10 R FUND) 2018 2019 2019 2,02O 2021 %Change Actual Budget Estimate Budget Forecast 19 to 20 001 nei°aIIII Fun Revenues 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.. 3',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 - - - +++ 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 27,663,030 27,679,687 28,9951539 29,959,084 4.8% Employee Benefits 141933,169 14,484,814 14520338 11 5133 71489 15,680,647 5.7% Other Employee Costs 4021395 580,876 5561536 " °"5 605,255 2.4% Pension Benefits 5,819 5,819 5,819 6,',m"4' 61174 6.1% Contractual Services 713831175 8,8511768 8,666,919 911,02,463 911041630 2.8% Utilities 228,650 326,724 322,982 341,203 346313 4.4% Insurance 469,053 549,118 549,118 ,535 628535 14.5% Commodities&Supplies 673,255 842,905 834,883 888,0931,2 905,946 5.5% Other Expenditures 112881775 1,038,741 1,142,841 31,'1,01537 10,747 -89.4% Building Improvements 392 8,250 12,000 11,2 1 12,000 45.5% Office Equipment 261688 50,430 43530 52..855 50,792 4.8% Other Equipment 243,850 315,934 2451587 280..910 293573 -11.1% Infrastructure 5911484 1,7761300 1,776,300 X 101 0,9205721226 -43.1% Interfund Transfers 21354,391 1,540,000 1,966,000 All,,?768,000 750,000 209.6% Expenses Total 55,308,129 58,034,709 58,322,540 62,110,625 58,925,922 7.0% Excess(Deficiency)of Revenues& Other Sources Over Expenditures 3,658,597 (1,915,809) (574,500) 31444, 99 438,690 79.8% Fund Balance, Beginning of Year 19,178,905 22,837,502 22,837,502 22,263,002 18,818,803 Fund Balance, End of Year 22,837,502 20,921,693 22,263,002 18,818,803 19,257,493 Fund Balance%of Subsequent Year Expenditures 39% 34% 36% 32�% 32% Recommended Fund Balance From 11,664,508 12,422,125 12,422,125 .1.1,.785,1 12,138,740 To 171 496,762 18,633,188 18,633,188 .1,7,.677,.777' 18,208,110 (MAJOI?FVM)) Summary of Revenues, Expenditures,and I,,,und Balance 2018 701000,660 fi , B 50,000100 40�0001000 30,000,000 20,0001000 fi � 000 2018 2019 Est 2020 2021 Revenues 111Expenses se, Illllllllllllf(Fund Ballaince 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. GN E 11 A 11, FU'N D BUI ... . . .. .....VIM . . .... 'J'N ]�;.U'. .4 .3)G1.411111 q :: GIF ND 1 1 1 J'N 1) 1111 qY1 I (1111AJOR FUND) E`xpenditures by,Function and Account Classification 2018 2019 2019 2,02,0 2021 %Change Actual Budget Estimate Budget Forecast 19 to 20 001 Geline iral 11:::°und 001-General Fund Operating Public Representation Personal Services,Salaries&Wages 196,,836 26,,850 26,850 26,?850 26,915 0.0% Employee Benefits 55,,076 2,,059 2,059 2,?059 2,065 0.0% Other Employee Costs 2,,964 8,,000 7,500 " ,?000 7,000 -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 06,3 20 6,242 0.1% Public Representation Total 731,776 653..883 694.,100 '73 1...,?623 626,,953 8.8% Village Administration Personal Services,Salaries&Wages 1,.361,,391 11433,,488 1.,435,832 3...,?539,991 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,3 114,400 4.1% Contractual Services 1.4413,.552 11656,,135 11537,295 .1.,?6.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,?199 18,371 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 3,719,903 31983.,704 3..841,891 4j 3 51,378 4..209..863 3.3% Finance Personal Services,Salaries&Wages 810,703 851,,913 851,913 91 6.j 54 947,864 7.5% Employee Benefits 304,610 289,883 300)045 3,37.,777 347,843 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 4,400 4,?500 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.1285,031 928,411 11032,511 - -100.0% Finance Total 21P735,?099 2,519,?327 2,599,005 1, m"", 2'm"" 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 644,174 623,162 722,? 33 746,110 12.2% Other Employee Costs 19,192 29,420 30,620 30193 6 31,708 5.1% Contractual Services 272,988 377,309 363,303 389,296 393,200 3.2% Utilities 12,589 30,611 30,911 30,684 31,298 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,?959j,63 4 3..047.,479 6.7% 1...1 .4 "U" D A .4 " P " I"UND A 1) "11,Y 1, G 1.71a N E R A I[ F N B1.JDGx.E,""1' BY'J"UN'll: GIENIERA]1'.... (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 , 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% (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% 4 Q I I"ry BUDGE'r BY FUND:: DE1.3"I'IS11.1"R1,110 da"I"'UND FUND PE: DEB"'I"SERVICE 2018 2019 2019 2,020 2021 %Change Actual Budget Estimate Budget Forecast 19 to 20 002......Debt Service[`!!Vind Revenues Property Taxes 2,390,000 2;4341000 2;4341000 2,54,812,50 2,748,046 4.7% Other Taxes 1/0621104 1,024,578 1;024;578 9251000 935,000 -9.7% Intergovernmental Revenue 1,619,577 1,573,650 1;593;650 1,6001900 1,606,800 1.7% Investment Income 24;243 5;000 46;000 3,5;,000 25,000 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 5..]09..]°50 5..314..846 -12.3% ....................................................... Expenses Contractual Services 138,800 - - +++ Bond Principal 71825;687 3;8121499 3;787;499 4,01 5,FOOO 4,270,000 5.3% Interest Expense 1/202;447 2;9101408 2;855;718 2,F5471732 2,421,902 -12.5% Bank&Fiscal Fees 4;465 3;500 3;500 3..000 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) (1 1456j,582) (1.380,056) 62.0% Fund Balance, Beginning of Year 184;196 4,150,506 4;150;506 3,?392,?OJII 7 11935;435 Fund Balance, End of Year 4;150;506 3;251;327 3,392,017 11.,9351435 555,379 iiiiiiiiiiiiiiiiiiiiiillillillillillillilliillillilliillillillillillillilliillillillillillillillilliillillillillillillilliillillillillillillillillillilliillillillillillillillilliillillillillillillilliillillillillillillillillillilliillillillillillillillilliillillillillillillilliillillillillillillillillillilliillillillillillillillilliillillillillillillilliillillillillillillillillillilliillillillillillillillilliillillillillillillilliillillillillillillillillillilliillillillillillillillilliillillillillillillilliillillillillillillillillillilliillillillillillillillilliillillillillillillilliillillillillillillillillillilliillillillillillillillilliillillillillillillilliillillillillillillillillillilliillillillillillillillilliillillillillillillilliillillillillillillillillillilliillillillillillillillilliillillillillillillilliillillillillillillI Recommended Fund Balance 2,298,360 2,298,360 2..43.5,f 711 2,423.,181 S u rri m lry of R e v e n t ies, Expenditures,and Fund Balance 201 8-...,2021 .1 4;000;000 ,,;x,,.21000"000 „1,,.01000;000 8;000;000 6;000;000 4;000;000 2;000;000 2018 2019 Est 2020 2021 IIIIIIIIII even e Il1l1ll1l Expense IIIIIIIIIIIIII I::::'und Ballance ¶¶IIIII 'mII�IIII 'mII�IIII �ilp, .,� ¶ mo m 'I� .�I.. .I u�"... .. ui�..,.v mo ..,� 'I� 'I�.u��.. M 'I� ¶.. I� w m ew 'I� ¶ �I`�I"' M'.. � M.1 M III'"N ..1" M. uoi CAP. .1..., OM1. .1� W.. N'1.. .,11.. N.. 1.4 A '..� 1 '....�um , . �M1�� OM1.1�.� 1�...,' OM1. VIII '.... ���M a �M1'.� 1�°��N'Iw 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 Revenues Other Taxes 113631690 13701000 13421600 1..,..3 89..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 13J....1„ 2 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,000 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 11 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,699,444 2,414,794 21414,794 J11 804,1588 1,141,216 Fund Balance, End of Year 2,414,794 1,093,354 118041588 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 e n u e s, Ep e n i t l It-e , and Fund B l In c e 201,8 2021,,,, 4,000,090 3500,00 3000,00 2;500;000 2.,000,000 1,5000000 1...,000,000 000000 2018 2019 Est 2020 2021... IIIIIIIIII IReveinues 1l1l1Expenses IIIIIIIIIIIIII IFun Ballance ""1."Y"PE:!! (AP11"TAI 1311.0JEC"I'S 'U BUDGE'r BY FUND:: S"I'll.]4`14"'T IMPROVEMEN . I VNI F ND 2018 2019 2019 2,02,0 2021 %Change Actual Budget Estimate Budget Forecast 19 to 20 02,3 Street hinprovemeint Construc Fi,jnd Revenues Other Taxes 2/0651406 2.10851000 2;014.1600 2,0741000 2,133,236 -0.5% Licenses, Permits&Fees 1,600,690 1,650,000 1.1600.4500 1,061 6,p5OO 1,633,000 -2.0% Intergovernmental Revenue 50.1100 - - .11, 5,700,000 +++ Investment Income 10.1715 6.1000 12,500 8,0500 8,500 41.7% Reimbursements 71,1877 - 12,000 1 5..000 18,000 +++ Other Revenue 177,1888 30;000 21,000 25,f000 25,000 -16.7% Other Financing Sources - - - 975,p000 350,000 +++ ....................................................... Revenues Total 3,,976.,676 3.,771,,000 3..660..600 4,171 4..000 9,867,736 25.0% Expenses Contractual Services 18.1631 40,000 40,000 40,p000 40,000 0.0% Infrastructure 2,597,667 41637/000 4.16371000 ,05 9,912,000 919121000 -12.7% Expenses Total 2..616..298 4..677,p000 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.1231 1,421,609 1IP421.1609 4,05,209 1,029,209 Fund Balance, End of Year 1,421,609 515,609 405,209 11.,029,209 944,945 iiiiiiiiiiiiiiiiiiiiiillillillillillillilliillillilillillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillillillillillillillillillillillillillilliillillillillillillilliillillilliillillilI Recommended Fund Balance 1.'000"000 1.'0001000 ij 000,000 1"000"000 SUrni"nary uf Flevenues, Expenditures, and [!!!!!'t..jnd Balance 2,01 8 202,1 121000fiOOO .1 0�000"000 000 000 6,000,000 4POOO,POOO 2�0001000 2018 2019 Est 2020 2021 Revenues 111Expenses I:::::und Ballance ND BUDGE'r BY FUND:: FLOOD CONTROL I VNI 2018 2019 2019 0 2021 %Change Actual Budget Estimate Budget Forecast 19 to 20 24 IF-Illoo d Controll Coinstruction IFund Revenues 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 (77,181) (1,804,078) (2,107,733) 30 ,?599 (6,085,175) -116.9% Fund Balance, Beginning of Year 1,818,539 11741,358 1117411358 (366,375) (61,776) Fund Balance, End of Year 11741,358 (62,720) (366,375) 1I,1"""'177 6) (61146,951) Recommended Fund Balance From 614,332 614,332 614,1332 614,332 To 1,000,000 1,000,000 1 1,000,000 Swinimary of Revenues, Een itur , lg �,, i��� Balance , 22 8�000�000 6�000�000 4000,000 l 2,,0001000 u»��iaaaaaaaaa uuCuuuuCuuu� �� � % U111�����������D °°. uuuuuuuuuuuuuuuuuuuuuu (2,000,000) 2018 2019 IEt 2020 2021 (40001000) (61000,000) ,000,000) IIIIIIIIII Reverwes ililill Exp e n yes IIIIIIIIIIIIII I::::�uind Ballance "rAl' PROJEC I'S FUND `1`Y"PE:!! (AP1 BUDGE'r BY FUND:: P01.10 I IRE BUHMING, I VNI 2018 2019 2019 2,02,0 2021 %Change Actual Budget Estimate Budget Forecast 19 to 20 02,5 Pollice&!!!!1re BLAIding Const. Revenues Investment Income 140,508 88,000 527,000 361500 -58.5% Other Revenue 20,552 - - +++ Other Financing Sources 33,527,683 +++ Revenues Total 33.,688..743 88,000 527,000 36.,500 -58.5% Expenses Contractual Services 1,903,463 2,316,174 1.1616.1439 372,61 0 -83.9% Building Improvements 65,100 22;620/808 22.1150.1223 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 31..720..180 (24..848..982) (23..239..662) (8,065,0900) - -67.5% Fund Balance, Beginning of Year 31,720,180 31,720,180 8,480151 8 414,618 Fund Balance, End of Year 31,720,180 6,871,198 811480.1518 43 4,631 8 414,618 Recommended Fund Balance From 405,,120 405,120 40.5,f 120 405.,120 TO 810.,240 810,240 810,240 810J240 Summary of Revenues, Expenditures,.and F���und Balance 203 8 -,,,, 2023 40,000,000 351000,,000 30,,000000 251000;000 200001000 150001000 101000"000 5,000,000 201..... 2019 Est 2020 2021 IIIIIIIIII Revenues Ilulllulllulll Ilf;;;;:Xjpeinses IIIIIIIIIIIIII Fund 11[allance Ul H", A i i I I . ..4 NUE 1D B )G,1"4.7.. BY FUND:: REFUSE DISPOSA.1'.'... I 'UND 1D 11,rYPE: SPECIAL RI..."XI N 2018 2019 2019 O 2021 %Change Actual Budget Estimate Budget Forecast 19 to 20 040 Refuse Disljjposal Ftxiir'id Revenues Charges For Services 41205,786 4,194,500 4;210;000 4,1 95..000 41195,000 0.0% Fines&Forfeits 36,629 37/000 38;400 381,500 33,500 4.1% Investment Income 10,139 5,000 11;600 1 01950 10,950 119.0% Reimbursements 27/372 1,000 650 1 1000 1,000 0.0% Other Revenue 127,179 134;220 132;100 1 2,9;,500 129,500 -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 267,842 254;632 283,822 31 9..769 330;885 25.6% Employee Benefits 123,513 112;676 116;076 133..567 137,599 18.5% Other Employee Costs 349 1/350 1;350 1 137'7 1,405 2.0% Contractual Services 4/0951524 4;1391523 4;2771736 4.27711 77 4,399,359 3.3% Utilities 153 483 483 493 503 2.1% Insurance 5,892 6;942 6;942 7,0950 7;950 14.5% Commodities&Supplies 35,723 41;579 41;579 4,2143 0 43;257 2.0% ..................................................... Expenses Total 4..528..996 4..557..185 4..727..988 4,?"7821743 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 1,368,550 1,246,659 1;246;659 911,423 503,628 Fund Balance, End of Year 1,246,659 1;0611194 911;421 503,628 (47;380) IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII Fund Balance%of Subsequent Year Expenditures 22% 19% 1 0% -1% Recommended Fund Balance From 472,799 478,274 478,274 492,.096 506,859 TO 11,181,997 110195,686 11195,686 112301240 1.1267,147 Summary of flevent.jes, Expenditures, and F'und Balance 2,01 2,02,1 6;000;000 5;000;000 4.,,()00;000 3;000;000 2,000;000 1;000;000 (1.."000,000) 2018 201...9 Est 2020 2021 Revenues Ilulllulll1l Expenses I:::::und Ballance rYPE: SPECIA.1'....R' l VENUI' I'UND BUDGE"'r BY FUND:: MOTOR I'M AL TAX 1"'UND I U'N I) . ....A a . 2018 2019 2019 2,020 2021 %Change Actual Budget Estimate Budget Forecast 19 to 20 041 Motor 11F-uell Ta IFuiind Revenues Intergovernmental Revenue 1,386,441 1;400/000 1;4171260 1..,..9071850 1,907,850 36.3% Investment Income 32,553 20,000 21;950 1 61,500 13,500 -17.5% Reimbursements 10/569 15,000 6,100 1 01000 10,000 -33.3% Revenues Total 1.,429.,563 1..435,?000 1,445.310 1 1934,350 1..931.,350 34.8% Expenses Contractual Services 328,194 360,173 360,173 367..376 374,722 2.0% Utilities 167,487 200,000 200,000 204,000 208,080 2.0% Commodities&Supplies 335,020 357,000 357,000 380,000 387,600 6.4% Infrastructure 912,200 1,168,000 1;050;000 1.2751000 900,000 9.2% Expenses Total 1.,742..901 2..085,,173 1..967.,173 2,0226,376 1..870,402 6.8% Excess(Deficiency)of Revenues& Other Sources Over Expenditures (313..338) (650..173) (521..863) (292,026) 60..948 -55.1% Fund Balance, Beginning of Year 21744;473 2;431,135 2;431;135 J...909,272 1;617;246 Fund Balance, End of Year 21431;135 1,780,962 1;909;272 1,,61,"',2 4 11678;194 Recommended Fund Balance From 196,717 95.,138 95,138 97 f 040 99J951 TO 491.,793 237,844 237,844 242,1601 249J879 St..irrimary of Flevent..jes, Expen ditAires, and Balance 2,01,,, 3P0001000 2,,500YO00 20001000 1500;000 1000000 500000 2018 2019 Est 2020 2021 Revenues Ilulllulllil Expenses I:::::und Ballarice 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 (2) +++ Fund Balance, Beginning of Year 2 Fund Balance, End of Year Recommended Fund Balance St.immary of Il event.jes, Expenditures, and Balance 2. 1,,, 2021 700,000 600,000 500,000 400,000 300,000 200,000 100,000 2018 2019 Est 2020 2021 IIIIIIIIII IRevenues II1I1I1II Expenses IIIIIIIIIIIIII I:::::und Balance ""u, ,rYPE: SPE .. ...... I..."UNUE It ND BUDGE,r BY FUNU: ASSE T S E3III. U'R.E FUND 11 ND CIAI Rj! 2018 2019 2019 2,020 2021 %Change Actual Budget Estimate Budget Forecast 19 to 20 043 Asset Seizure[allied Revenues Fines&Forfeits 9,644 10/000 16.1500 1500 12,500 25.0% Investment Income 1,640 2,000 1IP980 1000 2,000 0.0% Revenues Total 11..284 12,p000 18.,480 1 4,p500 14.500 20.8% Expenses Other Employee Costs - 1.1000 1,000 1....000 1,000 0.0% Contractual Services 10.1349 3;000 2.1500 3..000 3,000 0.0% Commodities&Supplies 15,365 - - .11 - +++ Other Equipment 17,222 30/000 20.1000 31000 3,000 -90.0% Expenses Total 42,936 34,000 23.500 7'1000 7..000 -79.4% Excess(Deficiency)of Revenues& Other Sources Over Expenditures (31,652) (22..000) (5..020) 71500 7.500 -134.1% Fund Balance, Beginning of Year 172.4907 141,255 141,255 X1,3 , 3"5 1431735 Fund Balance, End of Year 141.1255 119,255 136,235 11 43,p735 151,235 iiiiiiiiiiiiiiiiiiiiiillillillillillillilliillillilillillillillillillillillillillillillillillillilliillillillillillillilliillillillillilliillillillillillillillillillillillillilliillillillillillillilliillillillillilliillillillillillillillillillillillillilliillillillillillillilliillillillillilliillillillillillillillillillillillillilliillillillillillillilliillillillillilliillillillillillillillillillillillillilliillillillillillillilliillillillillilliillillillillillillillillillillillillilliillillillillillillilliillillillillilliillillillillillillillillillillillillilliillillillillillillilliillillillillilliillillillillillillillillillillillillilliillillillillillillilliillillillillilliillillillillillillillillillillillillilliillillillillillillilliillillillillilliillillillillillillillillillillillillilliillillillillillillilliillillillillilliilI Recommended Fund Balance 34.,000 7,000 7,000 7 fOOO 7,000 Summary of Revenues, Expenditures.,and [,,,Llnd Balance 201 8 2021 .1 60,,000 140,,000 120,000 100"000 80YO00 60,000 40,,000 20,000 2018 2019 Est 2020 2021 Revenues iii�Expenses I:::::und Ballair-ice ' IES 1A 1 .4 rYPE: SPECIA.1'....R' l VENUI I'UND BUDGE'r BY FUND:: 'I AL EQUIl."'A.13 a I IE I UNI A 2018 2019 2019 2,02,0 2021 %Change Actual Budget Estimate Budget Forecast 19 to 20 044lr-eder'all Equitalble Shai,'e 1!!!!1j11-1ds Revenues Fines&Forfeits - 2,000 2,000 1000 2,000 0.0% Investment Income 114 200 100 1 00 100 -50.0% Revenues Total 114 2.,200 2..100 2,1 00 2.,100 -4.5% Expenses Contractual Services 1;000 - 1....000 - 0.0% Other Equipment 1;000 1;000 1,000 -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 20,194 20.1308 20,308 21,408 22,508 Fund Balance, End of Year 20,308 20,508 21,408 22,508 23,608 iiiiiiiiiiiiiiiiiiiiiillillillillillillilliillillillillillilliillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillI Recommended Fund Balance 2,000 1.'000 1.'000 1,f 000 1.'000 Surrirriary of Reveriues, Experiditures, and Fund Balance 201 8 202.1 2,51000 20,000 x,,.5,000 100000 5,000 2018 2019 Est 2020 2021 Revenues 111Expenses I:::::und Ballaince 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 IFine 1!!!!1And Revenues 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 (3.,553) 4..000 22..015 22.300 25..300 457.5% Fund Balance, Beginning of Year 140,926 137,373 137,373 3 591388 181,688 Fund Balance, End of Year 137,373 141,373 159,388 31 81,688 206,988 Recommended Fund Balance 21,,500 2,000 2,000 Summary of III3tevenues, Expend itt..i res,an(-J IFund Balance 201 8 2021 2,50,000 200,000 1_150;000 1 00,000 50100 /.0 FIX ............................11, 2018 2019 Est 2020 2021 Revenues iiilExpenses 1:::::und Balance .4 BUDGE'r BY FUND:: FOREIGN I 1R.1 1''.."AX,BOARD I U'N 1.) A A 2018 2019 2019 2,020 2021 %Change Actual Budget Estimate Budget Forecast 19 to 20 046 F-oreg gn 11F-ire'rax 13oard 1`!!1,And Revenues Other Taxes 78,234 90/000 85.1000 7,51000 75,000 -16.7% Investment Income 3,793 4,000 3.1650 3100 3,200 -20.0% Revenues Total 82..027 94,p000 88.,650 7'8,p78..200 -16.8% Expenses Other Employee Costs 3.0731 15.1000 15,000 1 51000 15,000 0.0% Contractual Services 10,1729 10,500 10,500 1 0,500 10,500 0.0% Insurance - 500 500 °500 500 0.0% Commodities&Supplies 13,000 13,000 13;000 1 3..000 13,000 0.0% Building Improvements - 5/000 5.1000 51000 5,000 0.0% Other Equipment 8,760 24,000 24.1000 241000 24,000 0.0% Expenses Total 36..220 68,p000 68.,000 68,pOOO 68..000 0.0% Excess(Deficiency)of Revenues& Other Sources Over Expenditures 45..807 26..000 20..650 10..200 10,.200 -60.8% Fund Balance, Beginning of Year 3521,416 398,223 398,223 41,8,873 429,073 Fund Balance, End of Year 398.1223 424,223 418,873 9,?073 439,273 Recommended Fund Balance From 6,800 6.'800 61800 6 1800 7,004 TO 17,000 17,000 17,000 17f 000 17J510 St.jr-rimary of Revent jes, Expenditures,and i n d Balariccs 201 82021 500,000 400,,000 300,000 200,000 100,000 2018 2019 Est 2020 202.1 IIIIIIIIII Revenues Ilulllulll1l Expenses IIIIIIIIIIIIII I::::�und Ballaince "rYPE: SPECIA.1'....R' l VENUI I'U'N'D BUDGE"'r BY FUND:: RUSINESS I.M.5a, 1.1c,"r FUND I U N 1.) A a . 2018 2019 2019 2,02,0 2021 %Change Actual Budget Estimate Budget Forecast 19 to 20 0411,8 Business District IF-und Revenues Other Taxes 1/0271370 1,070,000 1;016.1900 1....0331595 1,051,450 -3.4% Intergovernmental Revenue 531.0398 440,000 495,900 51 4,000 531,990 16.8% Investment Income 13.1162 15.1000 8,800 61500 5,500 -56.7% Revenues Total 1p571..930 1,525,000 1p521..600 1„15'5 "'I 1..588..940 1.9% Expenses Interest Expense 1,571,930 1,525,000 1.1521,1600 1.05,54,095 1,588,940 1.9% Expenses Total 1,?571,?930 1.,525,p000 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 Reveinues, Expenditures,arid IFund Balance20.1 8 202.1 .1 8001000 11600,,000 11400,000 1,200,,000 1,0001000 800/000 600,000 400,000 200,000 2018 2019 Est 2020 2021 IIIIIIIIII IRevenues Ilulllulllil Expenses IIIIIIIIIIIIII I::::�und Ballarice 9 BtJ DC i I""'T' BY 1"'UNR: PROS P-1-(A F AND MAINof FUND WE: SPECIA.I...., III 2018 2019 2019 2021 %Change Actual Budget Estimate Budget Forecast 19 to 20 049 Prospect and Mafii�,,iTil District Revenues Property Taxes 469,613 474,000 433,000 73 8..000 873,900 55.7% Investment Income 78,498 10/000 18.1500 1 51500 12,500 55.0% Other Revenue 169,345 - - +++ Other Financing Sources 7,318,879 10,000,000 9.1355.4760 -100.0% Revenues Total 8,036?335 10..484.,000 9.,807..260 7,53;,500 886..400 -92.8% Expenses Other Employee Costs 1,200 2;700 750 1....500 1,500 -44.4% Contractual Services 351.1826 283,300 200,300 2,33..636 145,509 -17.5% Commodities&Supplies 161 1,500 600 1....500 1,000 0.0% Other Expenditures 10,577,843 2;7941500 2.1225.1000 41,581500 150,985 -83.6% Land Improvements 40,053 709,500 709,500 -100.0% Building Improvements - 6,000,000 71030.4000 -100.0% Infrastructure 700 810,000 260,000 11.,035,?990 110,000 27.9% Bond Principal - - - .11, 320,000 +++ Interest Expense 310,1423 432,738 432,738 78614,47 730,251 81.7% Bank&Fiscal Fees 225 - 225 1 1000 1,000 +++ ..........................................................................I Expenses Total 11,282,431 11,034,238 10..859.,113 2151 8.573 1..460,.245 -77.2% ....................................................I r Excess(Deficiency)of Revenues& Other Sources Over Expenditures (3..246..096) (550.,238) (1..051..853) (1 7'65�073) (573.,845) 220.8% Fund Balance, Beginning of Year 3,944,426 698,330 698,330 (353,523) (211181596) Fund Balance, End of Year 698,1330 148,092 (353,523) (2, ,F596) (21692,441) Recommended Fund Balance From 26,000 60,514 60,514 20,899 21,526 TO 65,000 151,1284 1511,284 52,.249 53,816 Summary of Revenues, Expenditures,and [,:und Balance 201 8 2,02,1 .1 20000;000 1 0"0001000 8,000,000 5,000,000 4,,0001000 2,,0001000 (2, 00,000) 2018 2019 Est 2020 202.1 (4,000,000) IReve inues Expenses IFuind Ballaince 'I J D TYPE:: EN""'I"ERP B )G.14 1.."BY FUND:: INA"'FER ANDSEWER.FUND F N RISE FUND (MAJOI?FUND) 2018 2019 2019 2,020 2021 %Change Actual Budget Estimate Budget Forecast 19 to 20 050 %Alatei°and Seweir[`!!Vind Revenues Property Taxes (5,.037) - - +++ Licenses, Permits&Fees 21,300 20,000 21.1950 201000 20,000 0.0% Intergovernmental Revenue - - - .11, 2,000,000 +++ Charges For Services 14,119,533 151509.0600 15.11291630 1 611 40;,840 17,301,470 4.1% Fines&Forfeits 104,500 100,000 103,000 1 00,?000 100,000 0.0% Investment Income 191,467 51.1100 193,600 °' w..'„00 39,100 29.4% Reimbursements - - 10,000 1 0..0 00 10,000 +++ Other Revenue 62,069 60;000 61;900 60..000 60,000 0.0% Other Financing Sources (61) 10;200.,000 10;016;000 - 7,500,000 -100.0% Revenues Total 14.,493.,771 25.,940,?700 25.,536.,080 1 .3 I. 27.,030.,570 -36.8% Expenses Personal Services,,Salaries&Wages 2/2971086 2,199,835 2,224,972 21349..752 2,430,567 6.8% Employee Benefits 1,061,118 871,240 888,909 31.,0201929 1,049,906 17.2% Other Employee Costs 43,1352 46.1589 44,114 4,51347 45,896 -2.7% Contractual Services 81553.1153 9,229,862 9,107,635 91233..01 3 9,431,065 0.0% Utilities 116,606 162,710 162,710 3 6613 74 169,496 2.1% Insurance 99,975 117,789 117,789 X1,3 , 134,892 14.5% Commodities&Supplies 260,650 336,045 335,803 334,688 340,676 -0.4% Other Expenditures 696,009 - - .11, - +++ Building Improvements 67,562 285,000 285,000 385,000 - 35.1% Office Equipment 1,060 1.1081 1,081 11,1'11,03 1,125 2.0% Other Equipment 225,1455 212,429 212,429 11 78,778 135,154 -15.8% Distribution Systems 11703.1973 8,277,411 7,602,642 517,58,14.2 7,368,142 -30.4% 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 (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) 4.,733.,070 -221.1% Unrestricted Net Assets, Beginning of Year 8,8381152 71917,.405 7;9171405 1 1,886,095 71506,469 Unrestricted Net Assets, End of Year 71917,405 11,535,.033 11,886,095 715061469 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, Epeindi ures, and Net Assets s 8.••••2021,,,. 30,000,000 25,000,000 20,,000,,000 ,000,000 ,1••. oo;000 000 000 2018 2019 Est 2020 2021••. IIIIIIIIII Revenues II1I1I1II Expenses 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. U' 11'Y ][41, 'E IV 11"ERI[IRISE 14' BUI)G,E BY44"UN'll: W'A"]'T'1�1,&,S141A1'14.R,!' UMD I" N I P ........... ..... "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, , 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,p581 -21.6% 050-Water and Sewer Fund Total 15.,414,?518 22y323,?072 21,?567,.390 20,776j,566 221?297,?500 -6.9% �IIIIII ��II � FUND:: � SYSTEM. W II! '� '"A ry�"„�, � II!kM�Y'P1�'��ulll 1���� "III�r������ �,� �,� .. M„ M,1M IIP° M, M,,, ,,, ,,,, .�,W.I. IIII � .,,, .II ,gym ,,, 2018 2019 2019 2,02O 2021 %Change Actual Budget Estimate Budget Forecast 19 to 20 051 Village Parllldni„ S stem m 1`!jnd Revenues Charges For Services 1831066 1861600 1921700 1 91„1 00 1881600 2.4% Investment Income 31649 31000 4,250 3150 31500 16.7% Other Revenue 31044 31000 2,000 31 31060 0.0% Revenues Total 189,759 192,600 198,950 1 97,600195,160 2.6% Expenses Personal Services,Salaries&Wages 39,187 16,916 161916 1 8,933 191594 11.9% Employee Benefits 17,509 6,825 6,844 m""'..713 71949 13.0% Contractual Services 401775 681506 1311389 1 99..91„2 691238 191.8% Insurance 242 285 285 3 326 14.4 Commodities&Supplies 552 563 563 574. 585 2.0% Building Improvements - 71506 71506 ., - -100.0% m Infrastructure 35,030 85,500 501000 50,?000 751000 -41.5% m Expenses Total 133,295 186,101 213,503 27714,58 172,692 49.1% Excess(Deficiency)of Revenues& Other Sources Over Expenditures 56,464 6,499 (14,553) (79,858) 22,468 -1328.8% Unrestricted Net Assets, Beginning of Year 311,519 3671983 3671983 353,430 2731572 Unrestricted Net Assets, End of Year 367,983 3741482 353,430 273,572 2961040 IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII Recommended Balance 56,865 56,865 24,423 25,156 St iu nim rn a rof'Re e n a es, Expenditures,and Net Assets 201 8 2,0 2 1,,, 400,000 350,000 300,000 2,50,000 200,000 1501000 1,,.00 000 50,000 PER 2018 2019 East 2020 2021,,. IIIIIIIIII Revenues IIiIiIiII E I einses Illllllllllllf I et Assets 11 .. '...A ..4 4 "'I"ERPRISE F ND BUDGE"'r BY FUNI")�,�� PARKING II II . V']J'NUE F U N D Ill Y'P 1.. N" U' 2018 2019 2019 2,020 2021 %Change Actual Budget Estimate Budget Forecast 19 to 20 052......Parldng Systern IReveint,je Fi,jrld Revenues Charges For Services 155,249 156,000 157,500 1 561500 157,500 0.3% Investment Income 1,703 1,000 1.1860 1 16,50 1,650 65.0% Other Revenue 1,201 1,200 2,200 ,p2,200 83.3% Revenues Total 158,153 158,200 161,560 1 60;,3,50 161..350 1.4% Expenses Personal Services,Salaries&Wages 28,1703 15;576 15,576 1 8..838 19,496 20.9% Employee Benefits 12.1763 6;562 6;582 7..667 7,903 16.8% Contractual Services 94,768 112,083 113,511 11".1 4,46".1.1 116,104 2.1% Utilities 5,975 9,799 9.1799 91998 10,198 2.0% Insurance 248 292 292 335 335 14.7% Commodities&Supplies 6,865 10,796 10,796 1 i..P01'.1 11,231 2.0% Building Improvements 29.1121 - - +++ ............................................................................ 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,p004 (1.,960) (3,917) -163.4% Unrestricted Net Assets, Beginning of Year 145.1906 125,616 125,616 J11 30,620 128,660 Unrestricted Net Assets, End of Year 125,1616 128,708 130)620 1 28,660 124,743 iiiiiiiiiiiiiiiiiiiiiillillillillillillilliillillilillillillillillillillillillillillillillillillilliillillillillillillilliillillillillillilliillillillillillillillillillillillilliillillillillillillilliillillillillillilliillillillillillillillillillillillilliillillillillillillilliillillillillillilliillillillillillillillillillillillilliillillillillillillilliillillillillillilliillillillillillillillillillillillilliillillillillillillilliillillillillillilliillillillillillillillillillillillilliillillillillillillilliillillillillillilliillillillillillillillillillillillilliillillillillillillilliillillillillillilliillillillillillillillillillillillilliillillillillillillilliillillillillillilliillillillillillillillillillillillilliillillillillillillilliillillillillillilliillillillillillillillillillillillilliillillillillillillilliillillillillillillI Recommended Balance 40,578 40,578 41,317 42,556 Summary of Revenues, Expenditures, and Net Assets 201 ,1. 200,000 .15 , 00 1...00 000 50,000 .......... PAMMMMMM/M MUMMMMMM/M HIIIIM 201 8 201...9 Est 2020 2021 IIIIIIIIII Reveiriues iiiIEeinses IIIIIIIIIIIIII lNet Assets BUDGE"'r BY FUND:: VEI 11CLE MA.1'.N"11"..'%]'-..-'..".N'A.NCE 1"UNI.."), FUND "'I"Y"PE:!! IN""rERNAL SERVICE I VNI".) 2018 2019 2019 O 2021 %Change Actual Budget Estimate Budget Forecast 19 to 20 060 VeIlli kle Mainteriiziir',ice IF-wirld Revenues Charges For Services 2,040,827 2;0461358 2;0461358 2..520.488 2,377,977 23.2% Investment Income 6,569 6,000 6;000 61000 6,000 0.0% Other Financing Sources 1,537 - - +++ Revenues Total 2.,048..933 21052,?358 21052.358 2,F5261488 2.3831977 23.1% Expenses Personal Services,Salaries&Wages 1,049,507 947;587 947;587 1,F]22,41 7 11161;192 18.5% Employee Benefits 457,011 357;549 366;838 4,33.251 446;252 21.2% Other Employee Costs 3,984 4,167 4,167 4..250 4,335 2.0% Contractual Services 113,401 111;883 111;883 11".13,954 116,253 1.9% Utilities 5,071 3,392 5;113 51431 5,450 60.1% Insurance 9,935 11,706 11;706 1 31405 13,405 14.5% Commodities&Supplies 598,070 593;408 607;808 62911 83 632,351 6.0% Office Equipment 298 614 614 626 639 2.0% Other Equipment 3,504 3;941 3;941 41011 9 4,100 2.0% ..................................................... 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. 589,376 Unrestricted Net Assets, End of Year 396,723 414;834 389;424 589,376 589,376 Unrestricted Net Assets%of Subsequent Year Expenditures 19% 18% 17% 25% 25% Recommended Balance From 205,966 23Z654 23Z654 2381398 239,633 TO 514,914 581,634 581,634 595,.994 599,083 Surnmary of Revenues, Expenditures,and Net Assets 2,0.1 ,202.1 31000,,000 2;500,000 2;000;000 '1...,500,000 .1;000,000 500,000 2018 20'..]9 Est 2020 202'...1 IIIIIIIIII Revenues Ilulllulllil Expenses IIIIIIIIIIIIII Net Ass(.::..,,ts 11 111 11 U I BUDGE""I BY FUNU: VEI 110.1.�." 1.11...�..PIACEMEN` 14 ND FUND 1"1"Y"PE:!! IN1111"ERNA]"...SERVICE 1T'NI".) 2018 2019 2019 2,020 2021 %Change Actual Budget Estimate Budget Forecast 19 to 20 061 Velikle,Rlaceimeint IF-und Revenues Charges For Services 1/6111300 2.11321100 2.1132.1100 1....7791560 1,779,560 -16.5% Fines&Forfeits 10,787 10,000 19.1000 1 91000 19,000 90.0% Investment Income 112.0771 120,000 144,000 41,1000 144,000 20.0% Other Financing Sources 106.0814 75.0000 25,000 -100.0% Revenues Total 1.,841..672 2..337,?100 2.,320..100 1;, ..5 ' 1..942..560 -16.9% Expenses Other Expenditures 806.1514 - - +++ Motor Equipment 5,598 1;9251000 1.1434.1901 I..,.. 1000 3,076,000 -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 7,950,356 8,979,916 811979,1916 9,?86511 5 10,605,675 Unrestricted Net Assets, End of Year 8,979,916 91392.0016 9,865,115 31 0,605,675 9,472,235 IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII 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 201 8 2021 .1 21000"000 10fi000"000 8,000,,000 6,000,000 4,0 ,000 2,000,000 2018 2019 Est 2020 2021 IReveinues Ilulllulllil Ex1penses Net Assets ..4 111"I'M I 71:11 ACEMI N FUND "'I'TPE: IN""rERNAL SERVICE I UM BUDGE"'r BY FUND:: COMPU ITI-1.R.1 a a a . 2018 2019 2019 2,02,0 2021 %Change Actual Budget Estimate Budget Forecast 19 to 20 062 CoBiu puter IIIR pilace iiia ent[t,jnd Revenues Charges For Services 205,097 162,897 162,897 1,591979 163,978 -1.8% Investment income 6,768 4,000 - -100.0% Revenues Total 211,865 166,897 162,897 1,59;,979 163..978 -4.1% Expenses Other Expenditures 13.1709 - - +++ Building Improvements - 250,000 250,000 -100.0% Office Equipment 146,625 237,900 225,000 1 891978 199,978 -20.1% Expenses Total 160,334 487,?900 475.,000 1 89,978 199..978 -61.1% Excess(Deficiency)of Revenues& Other Sources Over Expenditures 51.,531 (321.,003) (312,.103) (29..999) (36..000) -90.7% Unrestricted Net Assets, Beginning of Year 6791,225 730,756 730,756 41,8,?653 388,654 Unrestricted Net Assets, End of Year 730,756 409,753 418,653 3881654. 352,654 Recommended Balance 730,,756 409.,753 418,653 388,654 35Z654 Summary of Revenues, Expenditures.,and Net Assets 201 202.1 800,000 700,,000 600,000 500,,000 400,000 3 1' 00P000 200,,000 100,000 2018 2.019 Est 2020 2021 I::Ievenues iii�Expenses Net Assets U1.1. J 1""1."Y"PE:!! IN111.7 ERNA[.SI..'4 31VI(T FUND 111'r i"u .-4 B )G. "1"BY FUND:: RISK MANAGEM.1"N ND FUND a. . J 2018 2019 2019 O 2021 %Change Actual Budget Estimate Budget Forecast 19 to 20 063 11isik Managerneint 1!!!!Vind Revenues Charges For Services 7,094,913 7;4291717 7;2591280 7..7381478 7,894,888 4.2% Investment Income 20,944 20,000 15;430 1 61000 16,000 -20.0% Reimbursements 19/337 2,000 209,950 l21000 52,000 2500.0% Other Revenue 1,708,941 11803/500 1;654;087 1 16,56;,000 1,656,000 -8.2% Revenues Total 8.,844.,135 9..255,,217 9.,138..747 14°'2..47 9..618..888 2.2% Expenses Contractual Services 16,200 40;000 25;000 40..000 40;000 0.0% Insurance 8,125,486 9;1461373 9;4611689 9,542,800 9,793,276 4.3% Commodities&Supplies 8,668 22,1500 18;000 1,500 18,000 0.0% Other Equipment 1,113 - - +++ Expenses Total 8,151..467 91208,873 91504..689 9,605,300 9..851,276 4.3% Excess(Deficiency)of Revenues& Other Sources Over Expenditures 692,668 46,344 (365..942) (142,822) (232.,388) -408.2% Unrestricted Net Assets, Beginning of Year 2,985,464 3;6781132 3;678;132 3,331, ,1,9' 31169;368 Unrestricted Net Assets, End of Year 3,678,132 3;7241476 3,312,190 3,'31,69,368 2;936;980 Recommended Balance 1,,305.,500 1,3051500 11305,1500 11305,,500 St immary of Revenues, Expenditures, and [,:und [3a�ance 2,01... .1 .1 21000"000 1...0,000, 0 0 8;000;000 6,000,000 4;0001000 2fiOOO;000 FRI NOR= 2018 2019 Est 2020 2021 Reve inues iii�Expeirises Fund Ballaince 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 07'0 P IIIIis IIPension 1!!!!Vind Revenues Investment Income (3,,570,,236) 3.19331500 9;171.1260 4.,07711 50 4,191,950 3.7% Other Revenue 4,447,495 4,486,000 4.1506.4670 4,07,51225 4,825,400 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.1809 5,829,273 6..]06.A34. 6,168,469 5.5% Contractual Services 151.1074 167,300 164,781 1 69.J 40 172,270 1.1% Insurance 5,250 15/000 10.1000 1 51000 15,000 0.0% Commodities&Supplies - 100 - .11, - -100.0% Other Expenditures 8,190 12,000 12,000 1 21000 12,000 0.0% Expenses Total 5,v572?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 21525..803 2..649.,611 3.8% Net Position, Beginning of Year 711,0691059 66,374,108 66;374.1108 74,035,?984. 76,561,785 Net Position, End of Year 66.03741108 68,808,399 74,035,984 76,?561,785 79,211,396 Recommended Balance by Year 2040 per Illinois statute 119,,641,111 126,819.,578 126,819,578 134,F428,753 142,494,,478 Summary of Revent.jes, Expenditures,and [:und 1:3alance 2,01 8. 2021 900000y000 80,000,000 701000,,000 %0001000 50�0001000 40,000,000 301000;000 20,000,000 10,0000000 2018 2019 Est 2020 2021 Reveinues Ilulllulllil Expenses Fund Ballairice BUDGE"'r BY FUND:: FIRE PENSION 1"'i"UND FUND I'IDUCIARY"I UND 2018 2019 2019 2,020 2021 %Change Actual Budget Estimate Budget Forecast 19 to 20 07'1 IF-ire Perision IFund Revenues Investment Income (1,,815,,753) 3.15861000 8;774.1010 3.,791 11 00 4,040,220 5.7% Other Revenue 4,020,773 4,095,800 4.1177.4350 4,021 3,F1 50 4,339,850 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.1036 6,314,288 6..439.454. 6,596,247 6.8% Contractual Services 148.1273 136,700 141,235 1 44..280 146,370 5.5% Insurance 5,650 15/000 15,1000 15,000 15,000 0.0% Commodities&Supplies - 100 - .11, - -100.0% Other Expenditures 8,000 10,000 9.1000 1 01000 10,000 0.0% Expenses Total 6,071,833 61193,836 6.,479,?523 6,060911 34. 6..767..617 6.7% Excess(Deficiency)of Revenues& Other Sources Over Expenditures (3..866.,813) 1..487.,964 6..471..837 113°"5 1 1 6 1.,612.,453 -6.2% Net Position, Beginning of Year 661,2651343 62,398,530 621398.1530 68,870,367 70,265,483 Net Position, End of Year 62.03981530 63,886,494 68,870,367 70,265,483 71,877,936 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,and [,:t..jnd 13mance2,01... ,.1 801000,000 70,000,000 50,000,000 :11r)010001000 40,000,000 30,000,000 20,000,000 100000,000 201 8 2.019 Est 2020 2.021 IIIIIIIIII Revenues Ilulllulll1l Expenses IIIIIIIIIIIIII 1:::::und Balance T,- 2020-2024 . .. . . . i. PUIRIPOSE 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 0 Capital and Debt—per supporting schedules(CIP/bond ordinance) T,- 2020-2024 . .. . . . i. NOTEWORTHY IITEMS General Fund 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 Fund 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��,. ' � F ��I� .4 m D � IIIIII��/I�II�III� 1� � 1 VIII . M'�� ,.II III I� IIIIIIII II IIM1M.fM�„ VIII ��� V �� �„ �M.��„� V �„ FUND)(MAJOR 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 58,966,726 57,748,040 58,666,426 59,3640612 60,924,465 621530,107 64,182,827 IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII 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 1911781905 2218371502 22,2631002 1818181803 191257,493 1910261718 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 I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I 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 I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I 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 -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% II¶¶IIIIIIIII IIryIIIIryIIII� {�"IIryIIIImIIII'^ YE yIIIImIIII IIryIIIImIIII'^yIIIImIIII, M. �N'..� 1 ��, ,u nniim/...I�IIIII�.m IIryIIIImIIII'^� IIryIIIImIIII'^Imo yIIIImIIII ImImIIl yIIII�II yIIIImIIIII.. �II^��• � pIIIIpIIII^� IIryIIIImIIII'^� �M'.�,mm.. IY,mm11�m ,mm,�.�, .1�'� 1�.�1� 1M 'MN W ul�9m i nnim �nn� anon nniim � u � Wm »Nm.�'�. 1�'I� mo 1�.��n�"'d���N u�",mm'm I �I'....�,mm. �1 ��N'....�1�.�m. D 2018 2019 2020 2021 2022 2023 2024 Actual Estimate Budget Forecast Forecast Forecast Forecast 2 mn,Debt Seiiir° ice 1-,,,,aiind 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% .!�'�M!�.I .i. '. "' .MIM'..i�!�.� d� l�.f..� m�, . u�lllll�' iM' IIIIII��^1{.�j��.m �"� �"W��µfI VIII �"IIIµ1 W.�.."� � m �m'�m�,..'�M��,I v.. p•�"�� I�� III FIVE MM�.m� � � � I�"� I IIIIII� �IIIII� ullllll IIIM MM.. �MM'firm✓VIII iw�,...,.d�.�✓�' !�. .MIM...i�,N�, MNA'. MIA.'WIM, d�11..A�'AN IIIM...m� 2018 2019 2020 2021 2022 2023 2024 Actual Estimate Budget Forecast Forecast Forecast Forecast 12 -Ca Ill iiita l I mpr„veliiirm eiint II°°Viirmd 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 IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII Revenues Total 2,192,544 2,119,500 2,705,900 1,851,136 2,244,573 2,289,312 2,335,391 IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII 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 - Infrastructure 7021744 110541116 118221690 5541340 1,423,560 500,331 116731160 mlllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll............11lllllllllllllllll Expenses Total 11477,194 2,729,706 31369,272 2,426,146 2,663,022 2,231,482 2,941,034 mlllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll........................... 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 IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII Fund Balance,End of Year 214141794 118041588 1,141,216 5661206 1471757 2051587 (400,056) I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I 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.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% 2018 2019 2020 2021 2022 2023 2024 Actual Estimate Budget Forecast Forecast Forecast Forecast 23-...Street hirnpir'oveirneint C°iinstii'uc I,,,,u nd Revenues Other Taxes 2,065,406 2,014,600 2,074,000 21133,236 2,193,758 2,256,009 2,320,039 Licenses,Permits&Fees 1,600,690 1,600,500 1,616,500 1,633,000 1,649,330 1,665,823 1,682,481 Intergovernmental Revenue 50,100 - - 5,700,000 - - - Investment Income 10,715 12,500 8,500 8,500 8,691 8,887 9,087 Reimbursements 71,877 12,000 15,000 18,000 18,000 18,000 18,000 Other Revenue 177,888 21,000 25,000 25,000 25,375 25,756 26,142 Other Financing Sources - - 975,000 350,000 - - - Revenues Total 31976,676 3,660,600 4,714,000 90867,736 3,8951154 3,974,475 4,055,749 Expenses Contractual Services 18,631 40,000 40,000 40,000 40,800 41,616 42,448 Infrastructure 2,597,667 4,637,000 4,050,000 9,912,000 3,222,000 3,252,000 3,282,000 Expenses Total 21616,298 41677,000 4,090,000 91952,000 3,262,800 3,293,616 3,324,448 Excess(Deficiency)of Revenues& Other Sources Over Expenditures 11360,378 (1,016,400) 624,000 (84,264) 632,354 680,859 731,301 Fund Balance,Beginning of Year 611231 114211609 4051209 110291209 9441945 11#577,299 21258,158 Fund Balance,End of Year 114211609 4051209 110291209 9441945 11577,299 212581158 219891459 iiiiiiiiiiiiiiiiiiiiiillillillillillillilliillillillillillillillilillillillillillillillillillillilliillillillillillillilliillillilillillillillilillillillillillillillillillillilliillillillillillillilliillillilillillillillilillillillillillillillillillillilliillillillillillillilliillillilillillillillilillillillillillillillillillillilliillillillillillillilliillillilillillillillilillillillillillillillillillillilliillillillillillillilliillillilillillillillilillillillillillillillillillillilliillillillillillillilliillillilillillillillilillillillillillillillillillillilliillillillillillillilliillillilillillillillilillillillillillillillillillillilliillillillillillillilliillillilillillillillilillillillillillillillillillillilliillillillillillillilliillillilillillillillilillillillillillillillillillillilliillillillillillillilliillillilillillillillilillillillillillillillillillillilliillillillillillillilliillillilillillillillilillillillillillillillillillillilliillillillillillillilliillillilillillillillilillillillillillilI Revenues%Change from Prior Year -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 FINA.M."IM FORECAS111111 2020,11,11,12024 F Uo FLOOD II 2018 2019 2020 2021 2022 2023 2024 Actual Estimate Budget Forecast Forecast Forecast Forecast 124-Flood C ntiurol Coiinstiiiructiiiioiin II,,,,, mind 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% 11 FIVE�YEAR FINAM"."AJAI FDRECAS'111 2020,11,11,12024 FUNU: P0110E&1'4'IRE ; U1.1,111;;; 2018 2019 2020 2021 2022 2023 2024 Actual Estimate Budget Forecast Forecast Forecast Forecast 025-...[Vice&Fiii ir,e Buildfiiiig Const. Revenues Investment Income 140,508 527,000 36,500 Other Revenue 20,552 - - Other Financing Sources 33,527,683 Revenues Total 33fi88.,743 527fi000 36,500 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 31p720..180 (23p239,662) (81065p900) - - - Fund Balance,Beginning of Year - 31,720,180 8,480,518 414,618 414,618 414,618 414,618 ........................................................... Fund Balance,End of Year 31,720,180 8,480,518 414,618 414,618 414,618 414,618 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 FOR 1111 FUN S11 ND I . "' ,,, 1,„C,. ,u nnm nnm nnim nnim,,,,,m mo ry A'.0 . 2018 2019 2020 2021 2022 2023 2024 Actual Estimate Budget Forecast Forecast Forecast Forecast 040-Illefuse Disposal If,,,uiind Revenues 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 m Commodities&Supplies 351723 411579 421410 431257 441014 441784 451569 m 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 iiiiiiiiiiiiiiiiiiiiiillillillillillillilliillillillillillillillillilillillillillillillillillillilliillillillillillillilliillillilillillillillillilillillillillillillillillillilliillillillillillillilliillillilillillillillillilillillillillillillillillillilliillillillillillillilliillillilillillillillillilillillillillillillillillillilliillillillillillillilliillillilillillillillillilillillillillillillillillillilliillillillillillillilliillillilillillillillillilillillillillillillillillillilliillillillillillillilliillillilillillillillillilillillillillillillillillillilliillillillillillillilliillillilillillillillillilillillillillillillillillillilliillillillillillillilliillillilillillillillillilillillillillillillillillillilliillillillillillillilliillillilillillillillillilillillillillillillillillillilliillillillillillillilliillillilillillillillillilillillillillillillillillillilliillillillillillillilliillillilillillillillillilillillillillillillillillillilliillillillillillillilliillillilillillillillillilillillillillilI 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% AR ot., . k,.k„ N'„� k,. 1 1',,,A .II .4 nnim nnl� nnni nnil� IIA„ .. ,,,, IP°,,,, AX 1'4 UNI FIV,,, ,„ M1% "� nno�,,,,,m F ,UU VIII I ,J,a 2018 2019 2020 2021 2022 2023 2024 Actual Estimate Budget Forecast Forecast Forecast Forecast 1„.,,,I of ii,�I,,,,tj e l`1111 ax If,,,tj iin d Revenues Intergovernmental Revenue 1,386,441 1,417,260 1,907,850 1,907,850 1,946,007 1,984,927 2,024,626 Investment Income 32,553 21,950 16,500 13,500 13,804 14,115 14,433 Reimbursements 10,569 6,100 10,000 10,000 10,000 10,000 10,000 Revenues Total 11429,563 10445,310 1,934,350 11931,350 1,9690811 2,009,042 2,049,059 Expenses Contractual Services 328,194 360,173 367,376 374,722 3821216 389,861 397,659 Utilities 167,487 200,000 204,000 208,080 212,762 217,549 222,444 Commodities&Supplies 335,020 357,000 380,000 387,600 394,383 401,285 408,308 Infrastructure 9121200 1,050,000 1,275,000 900,000 1,500,000 1,500,000 1,500,000 Expenses Total 11742,901 11967,173 202260376 11870,402 20489,361 205080695 2,5280411 Excess(Deficiency)of Revenues& Other Sources Over Expenditures -313,338 (521,863) (292,026) 60,948 (519,550) (499,653) (479,352) Fund Balance,Beginning of Year 2,7441473 214311135 119091272 116171246 1,678,194 111581644 6581991 Fund Balance,End of Year 2,4311135 119091272 116171246 116781194 111581644 6581991 179,639 I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I 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 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% 11 1 1 4 G FIVE YEAR FINAM"."AJAI FDRECAS'111 2020,11,11,12024 1"'UNU: 2018 2019 2020 2021 2022 2023 2024 Actual Estimate Budget Forecast Forecast Forecast Forecast 042-...CDBG Revenues Intergovernmental Revenue 302,577 188,619 562.1800 480,800 490,716 500,835 511,160 Other Revenue 85,269 125,600 60,000 60,000 60,900 61,814 62,741 Revenues Total 387..846 314,219 622p800 540p800 551,616 562,649 573,901 Expenses Personal Services,Salaries&Wages 27,440 Employee Benefits 5,052 Other Employee Costs 11,114 - - - - - - Contractual Services 354,232 314,219 622,800 540,800 551,616 562,649 573,901 Commodities&Supplies 10 - - - - - - Expenses Total 387..848 314,219 622p800 540,800 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 -18.98% 98.21% -13.17% 2.00% 2.00% 2.00% Expenses%Change from Prior Year -18.98% 98.21% -13.17% 2.00% 2.00% 2.00% A ..4 .A J1111S I UU111 1'UND FIVE YEAR FINAM""JAI FORECAS1111 202 0,11,11,12024 FUNU: ASS] " 2018 2019 2020 2021 2022 2023 2024 Actual Estimate Budget Forecast Forecast Forecast Forecast 043-...Asset Seizuire II,,,wriid Revenues Fines&Forfeits 9,644 16,500 12.1500 12,500 12,750 13,005 13,265 Investment Income 1,640 1,980 2,000 2,000 2,045 2,091 2,138 Revenues Total 11.,284 18,480 14p500 14p500 14,795 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 7y000 7,000 7,078 7,157 7.,238 Excess(Deficiency)of Revenues& Other Sources Over Expenditures -31..652 (50020) 7p500 7p500 7,717 7,939 8,165 Fund Balance,Beginning of Year 172,907 141,255 136,235 143,735 151,235 158,952 166,891 ........................................................... Fund Balance,End of Year 141,255 136,235 143,735 151,235 158,952 166,891 175,056 iiiiiiiiiiiiiiiiiiiiiillillillillillillilliillillillillillilliillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillilI Revenues%Change from Prior Year 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% �� � vu vuu1.4� .....m �....m P ,11,11,1 . M.� .1� 1 .., ",1.. wr, nniim nniim 1'.� 1.� , mo .�N'�. I m .1..., "'I" �M�... L � 1�.IARE 1� 1�., �IIIIII 1 2018 2019 2020 2021 2022 2023 2024 Actual Estimate Budget Forecast Forecast Forecast Forecast 044-...Il,,,,edeiiir l Equitable Sllha hire F finds Revenues Fines&Forfeits 0 2,000 2,000 2,000 2,040 2,081 21123 Investment Income 114 100 100 100 102 104 106 Revenues Total 114 20100 21F100 21100 20142 2,185 2,229 Expenses Contractual Services 0 - 1,000 - - - - Other Equipment 0 1,000 - 1,000 1,000 1,000 1,000 Expenses Total 0 10000 1,000 11000 10000 1,000 1,000 Excess(Deficiency)of Revenues& Other Sources Over Expenditures 114 11100 1,100 10100 1,142 1,185 1,229 Fund Balance,Beginning of Year 201194 201308 211408 22,508 23,608 241750 251935 Fund Balance,End of Year 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% FIVE�YEAR FINANCIM FORECAS""I"2020 2024 1"UNI.,11,11H111 DUI FINE FUND 2018 2019 2020 2021 2022 2023 2024 Actual Estimate Budget Forecast Forecast Forecast Forecast 045-...DUI;:::�iriie!:::urig d Revenues Fines&Forfeits 21,665 21,665 24,000 25,000 25,500 26,010 26,530 Investment Income 313 350 300 300 307 314 321 Revenues Total 21..978 22,015 24,300 25p300 25,807 26,324 26,851 Expenses Other Employee Costs 550 1,000 Contractual Services 0 1,000 - - - Other Equipment 24,981 - 12,000 14,000 16,000 Expenses Total 25,531 2..000 12,000 14..000 16),000 Excess(Deficiency)of Revenues& Other Sources Over Expenditures -3..553 22,015 22,300 25p300 13p807 12,324 10,851 Fund Balance,Beginning of Year 140,926 137,373 159,388 181,688 206,988 220,795 233,119 ........................................................... Fund Balance,End of Year 137,373 159,388 181,688 206,988 220,795 233,119 243,970 iiiiiiiiiiiiiiiiiiiiiillillillillillillilliillillillillillilliillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillilI 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% 11111U 11"TAX,BOARD 4 A FIVE�YEAR FINAM"AIA.1 FORECAS"I"2020 2024 N I.,) F 0 R I.'IGN IFIRE 2018 2019 2020 2021 2022 2023 2024 Actual Estimate Budget Forecast Forecast Forecast Forecast 04 6 mn,11::::oi,,ekni I1::::1iire 1 ax Boair d[:::uild Revenues 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,f027 88,650 78,200 78p200 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 11,143 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,f220 68p000 6%000 68,000 68,824 6%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 352,416 398,223 418,873 429,073 439,273 450;596 463,076 ........................................................... Fund Balance,End of Year 398,223 418,873 429,073 439,273 450,596 463,076 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,A�1111� YEAR, 1�.�I .. "."A,�N�� .WN'„��F 1��"�,E .I�u1�9�N i nnim 2 P ,11,11,12nmi24 ,.WM.,. "U: BUSINESS DI I mr R,I A uT I'4UD 2018 2019 2020 2021 2022 2023 2024 Actual Estimate Budget Forecast Forecast Forecast Forecast ,, .,,,Business D i st iiir i ct II,,,,, 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 - - - - - - - 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, iwIF N E , 11 2020,11,11,12024 X . NI , "I'll 2018 2019 2020 2021 2022 2023 2024 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 Bank&Fiscal Fees 225 225 11000 11000 500 500 500 m M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M Expenses Total 11,282,431 10,859,113 2,518,573 1,460,245 1,488,809 1,711,091 1,751,841 m M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M M ............................................. 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% IV N'11 u a uu,°, 2024 ulll �. �. . ]'.'v m„ !� E � ` 'YEAR „� �� ���� .� .� � � VIII (MAJOR .. P 2018 2019 2020 2021 2022 2023 2024 Actual Estimate Budget Forecast Forecast Forecast Forecast S;I-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 IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII 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% 11 111p, 1111 I . "' ,,, 1 ,�, ,u nnm nnm nnim nnim 4444,m 1m1 W „� PARKING SYS rEM 2018 2019 2020 2021 2022 2023 2024 Actual Estimate Budget Forecast Forecast Forecast Forecast 51 m,,,Village Pairkfing S ste iiirn!:::, nd Revenues Charges For Services 183,066 192,700 191,100 188,600 191,715 194,892 198,133 Investment Income 3,649 4,250 3,500 3,500 3,579 3,660 3,742 Other Revenue 3,044 2,000 3,000 3,060 3,106 3,153 3,200 Revenues Total 189,759 1980950 197,600 195,160 1980400 2010705 2050075 Expenses Personal Services,Salaries&Wages 39,187 16,916 18,933 19,594 20,182 20,788 21,412 Employee Benefits 17,509 6,844 7,713 7,949 8,169 8,394 8,625 Contractual Services 40,775 131,389 199,912 69,238 70,623 72,036 73,477 Insurance 242 285 326 326 333 340 347 Commodities&Supplies 552 563 574 585 595 605 616 Building Improvements 0 7,506 - - - - - Infrastructure 35,030 50,000 50,000 75,000 75,000 130,000 75,000 Expenses Total 133,295 213,503 2770458 172,692 174,902 2320163 1790477 Excess(Deficiency)of Revenues& Other Sources Over Expenditures 56,464 (14,553) (79,858) 220468 23,498 (30,458) 25,598 Fund Balance,Beginning of Year 3111519 3671983 3531430 273,572 2961040 319,538 2890080 Fund Balance,End of Year 3671983 3531430 2731572 2961040 319,538 2891080 3141678 Revenues%Change from Prior Year 4.84% -0.68% -1.23% 1.66% 1.67% 1.67% Expenses%Change from Prior Year 60.17% 29.96% -37.76% 1.28% 32.74% -22.69% EM REVENM FIVE YEAR I F E . 2020,11,11,12024 MR2018 2019 2020 2021 2022 2023 2024 Actual Estimate Budget Forecast Forecast Forecast Forecast 52 m,,,Pariking S steiiirn Re eiiia I,,,,,u nd Revenues 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 1110200 Fund Balance,End of Year 1251616 1301620 1281660 1241743 118,939 111,200 1011484 I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I 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 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% 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 Revenues 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 m Other Equipment 31504 31941 41019 41100 41100 4,100 41100 m 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 iiiiiiiiiiiiiiiiiiiiiillillillillillillilliillillillillillilliillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillilI 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% 1 , , �F E YEAR � A ... w „Cuu m � m m F ° �l C . �P � � 2018 2019 2020 2021 2022 2023 2024 Actual Estimate Budget Forecast Forecast Forecast Forecast 1 Vehicle 11e,1p lace iiirneiint F find Revenues 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 1,029,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 101966,296 Fund Balance,End of Year 819791916 918651115 1016051675 914721235 10,0771415 10,9661296 9,600,959 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% 3U"'rl R,REPIACI IM.1 IN"I" FIVE YEAR FINAM"."AJAI FDRECAS'111 2020,11,11,12024 1`U C 0 M. . .......A j. A . 2018 2019 2020 2021 2022 2023 2024 Actual Estimate Budget Forecast Forecast Forecast Forecast 062-...Coi,nputer lleIjjplaceirneint Fuind Revenues Charges For Services 205,097 162,897 159,979 163,978 167,274 170,635 174,065 Investment Income 6,768 - - - - - - Revenues Total 211,865 162,897 159979 163,978 167,274 170..635 174,065 Expenses Other Expenditures 13,709 - Building Improvements 0 250,000 - - - - - Office Equipment 146,625 225,000 189,978 199,978 159,978 159,978 199,978 Expenses Total 160.334 475..000 189,978 199,978 159,978 159,978 199.,978 Excess(Deficiency)of Revenues& Other Sources Over Expenditures 51..531 (312p103) (29p999) (36y000) 7,296 10,657 (25p913) Fund Balance,Beginning of Year 679,225 730,756 418,653 388,654 352,654 359,950 370,607 ........................................................... Fund Balance,End of Year 730,756 418,653 388,654 352,654 359,950 370,607 344,694 Revenues%Change from Prior Year -23.11% -1.79% 2.50% 2.01% 2.01% 2.01% Expenses%Change from Prior Year 196.26% -60.00% 5.26% -20.00% 0.00% 25.00% FIVE YEAR FI "'A,I 1 FREC, ,u I 2020 anon 2024 I". �., �U: RISK N EE � 2018 2019 2020 2021 2022 2023 2024 Actual Estimate Budget Forecast Forecast Forecast Forecast 063 mn,RUs renagemeiint II,,,, uirnd Revenues 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 10,269,166 10,484,711 n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n n r 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 21936,980 Fund Balance,End of Year 3,6781132 313121190 311691368 219361980 21F9361980 21F9361980 2,936,980 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 FINAM"."AJAI FORECAS1111 2020,11,11,12024 FUNR: POLICE PENSION I'UND 2018 2019 2020 2021 2022 2023 2024 Actual Estimate Budget Forecast Forecast Forecast Forecast 070.,,,Police 1 eirii cion II,,,,u iiiii d Revenues 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 613670739 60556,674 607510236 61951,596 Excess(Deficiency)of Revenues& Other Sources Over Expenditures -41694,951 716610876 20525,801 2,649,611 2,6270378 2,602,725 205750544 Fund Balance,Beginning of Year 7110691059 6613741108 7410351984 7615611785 79,211,396 8118381774 8414410499 Fund Balance,End of Year 6613741108 7410351984 7615611785 7912111396 8118381774 8414411499 8700170043 iiiiiiiiiiiiiiiiiiiiiillillillillillillilliillillillilliillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillillillillillillilliillillillillillillilliillillillillillillillillillillilliillilI 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% "7111E PENSION I 4"UND FIVE YEAR F F E S Ill. 22P mnni um" 2018 2019 2020 2021 2022 2023 2024 Actual Estimate Budget Forecast Forecast Forecast Forecast 3„.,,,Fire 1)e irii s iii n II,,,, rii d Revenues 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 10395,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 I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I 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 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%