Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Ordinance 2020-26
STATE OF ILLINOIS COUNTY OF KE►NDALL FILED - APR 21 71,91k COUNTY CLERK .t,q j KEivU,ALL COUNTY UNITED CITY OF YORKVILLE KENDALL COUNTY, ILLINOIS ORDINANCE NO. 2020-26 ORDINANCE APPROVING THE 2020-2021 FISCAL BUDGET FOR THE UNITED CITY OF YORKVILLE Passed by the City Council of the United City of Yorkville,Kendall County, Illinois This 14'h day of April,2020 Published in pamphlet form by the authority of the Mayor and City Council of the United City of Yorkville,Kendall County,Illinois on April 20,2020. ORDINANCE NO.2020-26 ORDINANCE APPROVING THE 2020-2021 FISCAL BUDGET FOR THE UNITED CITY OF YORKVILLE WHEREAS,the Mayor and City Council of the UNITED CITY OF YORKVILLE have duly held all Public Hearings,allowed public input, and have duly considered formation of a budget for the 2020-2021 Fiscal Year; and WHEREAS, a tentative budget was duly announced and available for examination at the City offices of the UNITED CITY OF YORKVILLE; and WHEREAS,the Mayor and City Council of the UNITED CITY OF YORKVILLE deem it in the best interest of the City for the orderly operation thereof to pass and approve the 2020-2021 Fiscal Year Budget being submitted on April 14, 2020 at its regular City Council Meeting: NOW, THEREFORE,BE IT ORDAINED, by the Mayor and City Council of the United City of Yorkville,Kendall County, Illinois that the 2020-2021 Budget totaling $33,879,561 including the amounts of$16,898,632 General Fund, $1,117,462 Motor Fuel Tax Fund, $651,794 Vehicle&Equipment Fund, $2,286,552 Sewer Fund, $5,828,132 Water Fund, $1,628,147 City-Wide Capital Fund, $323,225 Debt Service Fund, $240,287 Land Cash Fund, $2,556,762 Parks& Recreation Fund, $1,664,378 Library Operations Fund, $75,500 Library Capital Fund, $222,486 Countryside TIF Fund, $306,052 Downtown TIF Fund, $22,500 Downtown TIF II Fund, $20,326 Sunflower SSA Fund, and$37,326 Fox Hill SSA Fund is hereby adopted for the 2020-2021 Fiscal Year, as presented. Passed by the City Council of the United City of Yorkville, Kendall County, Illinois this 14th day of April, 2020. OrxeL. ?x/6e/tt City Clerk Ordinance No.2020-26 Page 2 KEN KOCH AYE DAN TRANSIER AYE JACKIE MILSCHEWSKI AYE ARDEN JOE PLOCHER AYE CHRIS FUNKHOUSER AYE JOEL FRIEDERS AYE SEAVER TARULIS ABSENT JASON PETERSON AYE Approved by me, as Mayor of the United City of Yorkville,Kendall County, Illinois, this aOtb day of 74PR/1. , 2020. (. Mayor Ordinance No.2020-26 Page 3 GENERAL FUND(01) The General Fund is the City's primary operating fund. It accounts for major tax revenue used to support administrative and public safety functions. FY 2020 FY 2021 FY 2018 FY 2019 Adopted FY 2020 Adopted FY 2022 FY 2023 FY 2024 FY 2025 Actual Actual Budget Projected Budget Projected Projected Projected Projected Revenue Taxes 10,962,693 11,232,397 11,388,715 11,424,909 11,640,828 11,835,084 12,027,100 12,221,913 12,419,563 Intergovernmental 2,296,435 2,725,393 2,703,232 2,873,570 2,770,234 3,003,526 3,071,979 3,140,262 3,211,114 Licenses&Permits 364,499 552,416 413,500 500,000 474,500 424,500 424,500 424,500 424,500 Fines&Forfeits 123,617 100,726 125,400 80,250 113,000 113,000 113,000 113,000 113,000 Charges for Service 1,508,994 1,598,662 1,616,211 1,664,939 1,702,046 1,740,904 1,787,418 1,835,326 1,884,671 Investment Earnings 49,018 90,321 80,000 159,952 89,878 81,226 80,030 63,512 42,701 Reimbursements 85,579 66,824 75,000 85,035 88,000 52,000 52,000 52,000 52,000 Miscellaneous 19,243 25,667 20,000 21,200 20,000 20,000 20,000 20,000 20,000 Other Financing Sources 92,125 29,917 47,180 35,000 35,000 35,000 35,000 35,000 35,000 Total Revenue 15,502,203 16,422,323 16,469,238 16,844,855 16,933,486 17,305,240 17,611,027 17,905,513 18,202,549 Expenditures Salaries 4,522,164 4,726,744 5,206,755 5,255,703 5,457,149 5,730,958 5,893,722 6,091,669 6,264,344 Benefits 2,905,833 2,901,328 3,273,617 3,156,402 3,385,413 3,598,067 3,770,418 3,956,618 4,147,617 Contractual Services 4,780,199 5,038,155 5,270,379 5,093,110 5,604,652 5,503,468 5,520,997 5,496,606 5,565,951 Supplies 231,954 332,370 452,498 370,563 285,581 270,662 274,460 285,153 288,153 Contingency - - - - 80,000 50,000 50,000 50,000 50,000 Other Financing Uses 2,779,764 3,040,283 2,580,400 2,561,741 2,085,837 2,837,124 3,241,807 3,117,585 3,267,070 Total Expenditures 15,219,914 16,038,880 16,783,649 16,437,519 16,898,632 17,990,279 18,751,404 18,997,631 19,583,135 Surplus(Deficit) 282,289 383,443 (314,411) 407,336 34,854 (685,039) (1,140,377) (1,092,118) (1,380,586) Ending Fund Balance 6,496,373 6,879,823 5,468,778 7,287,159 7,322,013 6,636,974 5,496,597 4,404,479 3,023,893 42.68% 42.89% 32.58% 44.33% 43.33% 36.89% 29.31% 23.18% 15.44% Fund Balance N $8,000 2 $6,000 r $4,000 $2,000 - $0 - 1 FY 2018 FY 2019 FY 2020 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 Account Number Description Actual Actual Adopted Projected Adopted Projected Projected Projected Projected GENERAL FUND-01 01-000-40-00-4000 PROPERTY TAXES-CORPORATE LEVY 2,129,984 2,191,159 2,119,323 2,123,744 2,107,099 2,144,661 2,187,478 2,229,964 2,271,943 01-000-40-00-4010 PROPERTY TAXES-POLICE PENSION 963,908 958,476 1,105,927 1,108,182 1,230,604 1,268,042 1,300,225 1,332,739 1,365,760 01-000-40-00-4030 MUNICIPAL SALES TAX 3,002,133 3,070,663 3,151,800 3,220,000 3,284,400 3,350,088 3,417,090 3,485,432 3,555,141 01-000-40-00-4035 NON-HOME RULE SALES TAX 2,325,623 2,358,568 2,432,700 2,445,000 2,493,900 2,543,778 2,594,654 2,646,547 2,699,478 01-000-40.00-4040 ELECTRIC UTILITY TAX 702,111 730,949 710,000 715,000 715,000 715,000 715,000 715,000 715,000 01-000-40-00-4041 NATURAL GAS UTILITY TAX 251,555 277,380 250,000 265,000 265,000 265,000 265,000 265,000 265,000 01-000-40-00-4043 EXCISE TAX 334,595 329,742 313,625 255,000 246,075 237,462 229,151 221,131 213,391 01-000-40-00-4044 TELEPHONE UTILITY TAX 8,340 8,340 8,340 8,340 8,340 8,340 8,340 8,340 8,340 01-000-40-00-4045 CABLE FRANCHISE FEES 290,669 301,100 290,000 300,000 300,000 300,000 300,000 300,000 300,000 01-000-40-00-4050 HOTEL TAX 79,602 77,563 80,000 80,000 80,000 80,000 80,000 80,000 80,000 01-000-40-00-4055 VIDEO GAMING TAX 119,733 145,734 140,000 140,000 140,000 140,000 140,000 140,000 140,000 01-000-40-00-4060 AMUSEMENT TAX 199,974 208,315 205,000 205,000 205,000 205,000 205,000 205,000 205,000 01-000-40-00-4065 ADMISSIONS TAX 130,766 148,133 140,000 146,143 145,000 145,000 145,000 145,000 145,000 01-000-40-00-4070 BUSINESS DISTRICT TAX-KENDALL MRKT 374,631 362,874 382,500 358,000 365,160 372,463 379,912 387,510 395,260 01-000-40-00-4071 BUSINESS DISTRICT TAX-DOWNTOWN 24,663 37,075 35,000 30,000 30,000 35,000 35,000 35,000 35,000 01-000-40-00-4072 BUSINESS DISTRICT TAX-COUNTRYSIDE 9,865 10,436 10,000 10,000 10,000 10,000 10,000 10,000 10,000 01-000-40-00-4075 AUTO RENTAL TAX 14,541 15,890 14,500 15,500 15,250 15,250 15,250 15,250 15,250 01-000-41-00-4100 STATE INCOME TAX 1,640,291 1,966,699 1,916,366 2,040,110 1,897,310 2,064,786 2,106,082 2,148,203 2,191,167 01-000-41-00-4105 LOCAL USE TAX 474,797 578,328 602,966 640,090 675,281 740,185 762,391 785,263 808,820 01-000-41-00-4106 CANNABIS EXCISE TAX - - - 618 15,218 16,680 17,181 17,696 18,227 01-000-41-00-4110 ROAD&BRIDGE TAX 131,612 128,668 130,000 131,199 130,000 130,000 135,000 135,000 140,000 01-000-41-00-4120 PERSONAL PROPERTY TAX 14,932 16,154 17,000 16,500 16,500 16,500 16,500 16,500 16,500 01-000-41-00-4160 FEDERAL GRANTS 11,716 13,553 15,000 13,000 14,925 14,375 13,825 16,600 15,400 01-000-41-00-4168 STATE GRANTS-TRAFFIC SIGNAL MAINTENANCE 22,201 18,695 21,000 18,553 20,000 20,000 20,000 20,000 20,000 01-000-41-004170 STATE GRANTS - 2,413 - 11,639 - - - - - 01-000-41-00-4182 MISC INTERGOVERNMENTAL 886 883 900 1,861 1,000 1,000 1,000 1,000 1,000 01-000-42-00-4200 LIQUOR LICENSES 56,465 65,819 56,000 65,000 65,000 65,000 65,000 65,000 65,000 01-000-42-00-4205 OTHER LICENSES&PERMITS 9,472 10,395 7,500 10,000 9,500 9,500 9,500 9,500 9,500 O1-000-42-004210 BUILDING PERMITS 298,562 476,202 350,000 425,000 400,000 350,000 350,000 350,000 350,000 01-000-43-00-4310 CIRCUIT COURT FINES 44,597 37,822 45,000 35,000 40,000 40,000 40,000 40,000 40,000 01-000-43-00-4320 ADMINISTRATIVE ADJUDICATION 27,250 26,275 30,000 25,000 27,500 27,500 27,500 27,500 27,500 01-000-43-00-4323 OFFENDER REGISTRATION FEES 695 420 400 250 500 500 500 500 500 01-000-43-00-4325 POLICE TOWS 51,075 36,209 50,000 20,000 45,000 45,000 45,000 45,000 45,000 01-000-44-00-4400 GARBAGE SURCHARGE 1,135,035 1,203,851 1,224,875 1,266,000 1,297,650 1,330,091 1,369,994 1,411,094 1,453,427 01-000-44-00-4405 UB COLLECTION FEES 163,782 178,775 165,000 165,000 165,000 165,000 165,000 165,000 165,000 01-000-44-00-4407 LATE PENALTIES-GARBAGE 21,213 21,649 21,000 25,000 25,000 25,000 25,000 25,000 25,000 01-000-44-00-4415 ADMINISTRATIVECHARGEBACK 188,064 194,387 204,836 204,836 213,896 220,313 226,924 233,732 240,744 01-000-44-00-4474 POLICE SPECIAL DETAIL 900 - 500 4,103 500 500 500 500 500 01-000-45-00-4500 INVESTMENT EARNINGS 40,479 90,321 80,000 120,000 89,878 81,226 80,030 63,512 42,701 01-000-45-00-4550 GAIN ON INVESTMENT 8,539 - - 39,952 - - - - - 2 FY 2018 FY 2019 FY 2020 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 Account Number Description Actual Actual Adopted Projected Adopted Projected Projected Projected Projected 01-000-46-00-4604 REIMS-ENGINEERING EXPENSES 1,154 - 25,000 11,035 25,000 25,000 25,000 25,000 25,000 01-000-46-00-4680 REIMB-LIABILITY INSURANCE 11,582 2,809 10,000 15,000 15,000 15,000 15,000 15,000 15,000 01-000-46-00-4685 REIMB-CABLE CONSORTIUM 35,217 36,358 35,000 36,000 36,000 - - - - 01-000-46-00-4690 REIMS-MISCELLANEOUS 37,626 27,657 5,000 23,000 12,000 12,000 12,000 12,000 12,000 01-000-48-00-4820 RENTAL INCOME 7,100 7,435 7,000 7,000 7,000 7,000 7,000 7,000 7,000 01-000-48-00-4850 MISCELLANEOUS INCOME 12,143 18,232 13,000 14,200 13,000 13,000 13,000 13,000 13,000 01-000-49-00-4916 TRANSFER FROM CW MUNICIPAL BUILDING 92,125 29,917 47,180 35,000 35,000 35,000 35,000 35,000 35,000 Revenue 15,502,203 16,422,323 16,469,238 16,844,855 16,933,486 17,305,240 17,611,027 17,905,513 18,202,549 3 ADMINISTRATION DEPARTMENT The Administration Department includes both elected official and management expenditures. The executive and legislative branches consist of the Mayor and an eight member City Council. The city administrator is hired by the Mayor with the consent of the City Council. City staff report to the city administrator. It is the role of the city administrator to direct staff in the daily administration of City services. FY 2020 FY 2021 FY 2018 FY 2019 Adopted FY 2020 Adopted FY 2022 FY 2023 FY 2024 FY 2025 Actual Actual Budget Projected Budget Projected Projected Projected Projected Expenditures Salaries 518,618 573,048 600,095 592,100 611,747 628,254 645,257 693,070 711,108 Benefits 201,497 216,185 220,528 221,195 211,572 223,709 237,527 252,059 265,927 Contractual Services 131,910 135,229 134,061 143,032 150,031 157,938 165,036 159,234 165,875 Supplies 8,832 10,280 10,000 10,000 19,000 10,000 10,000 10,000 10,000 Total Administration 860,857 934,742 964,684 966,327 992,350 1,019,901 1,057,820 1,114,363 1,152,910 $1,400 lo $1,200 m $1,000 - 0 F $800 - $600 - $400 - $200 - $0 , I I i 1 1 I i 4 FY 2018 FY 2019 FY 2020 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 Account Number Description Actual Actual Adopted Projected Adopted Projected Projected Projected Projected Ad,ninistrat ion 01-I10-50-00-5001 SALARIES-MAYOR 9,970 9,570 11,000 10,000 10,500 10,500 10,500 18,000 18,000 01-110-50-00-5002 SALARIES-LIQUOR COMM 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 01.110-50-00.5003 SALARIES-CITY CLERK 7,035 7,087 - 600 - - - - - 01-110-50-00-5004 SALARIES-CITY TREASURER 1,000 1,000 - - - - _ _ _ 01-I 10-50-00-5005 SALARIES-ALDERMAN 48,225 46,825 50,000 49,000 50,000 50,000 50,000 72,800 72,800 01-I 10-50-00-5010 SALARIES-ADMINISTRATION 451,388 507,566 538,095 531,500 550,247 566,754 583,757 601,270 619,308 01-110-52-00-5212 RETIREMENT PLAN CONTRIBUTION 48,542 51,208 49,367 53,000 62,251 64,893 68,533 72,152 74,317 01-110-52-00-5214 FICA CONTRIBUTION 35,304 38,889 41,686 41,686 43,010 44,300 45,629 46,998 48,408 01-110.52-00-5216 GROUP HEALTH INSURANCE 109,134 116,611 120,064 117,098 97,664 105,477 113,915 123,028 132,870 01-110-52-00-5222 GROUP LIFE INSURANCE 543 494 428 428 428 432 436 440 444 01-110-52-00-5223 DENTAL INSURANCE 7,013 7,853 7,853 7,853 7,089 7,443 7,815 8,206 8,616 01-110-52-00-5224 VISION INSURANCE 961 1,130 1,130 1,130 1,130 1,164 1,199 1,235 1,272 01-110-54-00-5410 TUITION REIMBURSEMENT 5,110 12,864 - - - - - - - 01-110-54-00-5412 TRAINING&CONFERENCES 16,060 10,167 17,000 17,000 16,000 17,000 17,000 17,000 17,000 01-110-54-00-5415 TRAVEL&LODGING 11,408 6,952 10,000 10,000 10,000 10,000 10,000 10,000 10,000 01-110-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK - 2,081 3,767 3,767 - 3,634 8,334 - 3,970 01-I10-54-00-5426 PUBLISHING&ADVERTISING 2,547 2,269 5,000 5,000 4,000 5,000 5,000 5,000 5,000 01-110-54-00-5430 PRINTING&DUPLICATING 4,139 2,456 3,250 3,250 3,250 3,250 3,250 3,250 3,250 01-110-54-00-5440 TELECOMMUNICATIONS 17,634 17,788 19,000 19,000 22,300 22,300 22,300 22,300 22,300 01-110-54-00-5448 FILING FEES 51 183 500 500 500 500 500 500 500 01-110.54-00-5451 CODIFICATION 2,864 7,808 5,000 5,000 10,000 10,000 10,000 10,000 10,000 01-110-54-00-5452 POSTAGE&SHIPPING 1,802 1,518 3,000 3,000 3,000 3,000 3,000 3,000 3,000 01-110-54-00-5460 DUES&SUBSCRIPTIONS 19,620 21,775 20,000 20,000 22,000 22,000 22,000 22,000 22,000 01-110-54-00-5462 PROFESSIONAL SERVICES 10,451 6,791 12,000 12,000 12,000 12,000 12,000 12,000 12,000 01-110-54-00-5480 UTILITIES 26,800 29,317 20,787 30,000 31,800 33,708 35,730 37,874 40,146 01-110-54-00-5485 RENTAL&LEASE PURCHASE 2,102 1,844 3,000 3,000 3,000 3,000 3,000 3,000 3,000 01-110-54-00-5488 OFFICE CLEANING 11,322 11,416 11,757 11,515 12,181 12,546 12,922 13,310 13,709 01-110-56.00.5610 OFFICE SUPPLIES 8,832 10,280 10,000 10,000 19,000 10,000 10,000 10,000 10,000 860,857 934,742 964,684 966,327 992,350 1,019,901 1,057,820 1,114,363 1,152,910 5 FINANCE DEPARTMENT The Finance Department is responsible for the accounting,internal controls,external reporting and auditing of all financial transactions. The Finance Department is in charge of preparing for the annual audit,utility billing,receivables,payables,treasury management and payroll and works with administration in the preparation of the annual budget. Personnel are budgeted in the General and Water Funds. FY 2020 FY 2021 FY 2018 FY 2019 Adopted FY 2020 Adopted FY 2022 FY 2023 FY 2024 FY 2025 Actual Actual Budget Projected Budget Projected Projected Projected Projected Expenditures Salaries 251,587 271,575 301,372 293,000 324,856 334,602 344,640 354,979 365,628 Benefits 106,348 112,499 119,719 110,903 123,295 130,416 138,529 147,062 155,202 Contractual Services 84,202 88,505 110,150 105,900 111,857 116,416 120,576 120,638 120,703 Supplies 1,898 1,345 2,500 2,500 2,500 2,500 2,500 2,500 2,500 Total Finance 444,035 473,924 533,741 512,303 562,508 583,934 606,245 625,179 644,033 $700 $600 c $500 co o $400 ~ $300 $200 $100 - $0 6 FY 2018 FY 2019 FY 2020 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2029 Account Number Description Actual Actual Adopted Projected Adopted Projected Projected Projected Projected Finance 01-120-50-00-5010 SALARIES&WAGES 251,587 271,575 301,372 293,000 324,856 334,602 344,640 354,979 365,628 01-120-52-00-5212 RETIREMENT PLAN CONTRIBUTION 27,110 27,428 27,649 29,500 36,752 38,312 40,461 42,597 43,875 01-120-52-00-5214 FICA CONTRIBUTION 18,776 19,526 21,574 21,574 23,420 24,123 24,847 25,592 26,360 01-120-52-00-5216 GROUP HEALTH INSURANCE 54,102 59,400 64,351 53,684 57,566 62,171 67,145 72,517 78,318 01-120-52-00-5222 GROUP LIFE INSURANCE 334 246 246 246 246 248 250 253 256 01-120-52-00-5223 DENTAL INSURANCE 5,319 5,192 5,192 5,192 4,604 4,834 5,076 5,330 5,597 01-120-52-00-5224 VISION INSURANCE 707 707 707 707 707 728 750 773 796 01-120-54-00-5412 TRAINING&CONFERENCES 3,515 2,432 3,500 3,500 3,500 3,500 3,500 3,500 3,500 01-120-54-00-5414 AUDITING SERVICES 29,000 29,800 34,100 30,600 31,400 35,900 40,000 40,000 40,000 01-120-54-00-5415 TRAVEL&LODGING 446 160 1,000 500 600 600 600 600 600 01-120-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK - - 1,900 1,900 1,957 2,016 2,076 2,138 2,203 01-120-54-00-5430 PRINTING&DUPLICATING 2,989 2,804 3,500 3,500 3,500 3,500 3,500 3,500 3,500 01-120-54-00-5440 TELECOMMUNICATIONS 1,104 1,165 1,250 1,000 1,000 1,000 1,000 1,000 1,000 01-120-54-00-5452 POSTAGE&SHIPPING 897 991 1,200 1,200 1,200 1,200 1,200 1,200 1,200 01-120-54-00-5460 DUES&SUBSCRIPTIONS 985 1,165 1,500 1,500 1,500 1,500 1,500 1,500 1,500 01-120-54-00-5462 PROFESSIONAL SERVICES 43,325 48,322 60,000 60,000 65,000 65,000 65,000 65,000 65,000 01-120-54-00-5485 RENTAL&LEASE PURCHASE 1,941 1,666 2,200 2,200 2,200 2,200 2,200 2,200 2,200 01-120-56-00-5610 OFFICE SUPPLIES 1,898 1,345 2,500 2,500 2,500 2,500 2,500 2,500 2,500 444,035 473,924 533,741 512,303 562,508 583,934 606,245 625,179 644,033 7 POLICE DEPARTMENT The mission of the Yorkville Police Department is to work in partnership with the community to protect life and property,assist neighborhoods with solving their problems and enhance the quality of life in our City. FY 2020 FY 2021 FY 2018 FY 2019 Adopted FY 2020 Adopted FY 2022 FY 2023 FY 2024 FY 2025 Actual Actual Budget Projected Budget Projected Projected Projected Projected Expenditures Salaries 2,911,083 3,000,199 3,349,248 3,441,000 3,434,608 3,650,576 3,753,763 3,860,046 3,969,517 Benefits 1,915,338 1,878,152 2,175,164 2,069,887 2,205,107 2,351,573 2,454,464 2,562,755 2,676,529 Contractual Services 354,356 288,525 294,812 278,897 311,025 360,534 434,577 356,445 344,612 Supplies 102,776 184,259 116,000 114,750 113,480 115,537 117,751 126,781 128,035 Total Police 5,283,553 5,351,135 5,935,224 5,904,534 6,064,220 6,478,220 6,760,555 6,906,027 7,118,693 $8,000 - $7,000 c $6,000 o $5,000 L 1- $4,000 $3,000 $2,000 $1,000 $0 8 FY 2018 FY 2019 FY 2020 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 Account Number Description Actual Actual Adopted Projected Adopted Projected Projected Projected Projected Police 01-210-50-00-5008 SALARIES-POLICE OFFICERS 1,652,672 1,683,202 1,924,224 1,890,000 1,981,203 2,040,639 2,101,858 2,164,914 2,229,861 01-210-50-00-5011 SALARIES-COMMAND STAFF 365,716 445,280 396,159 474,500 394,401 525,493 541,258 557,496 574,221 01-210-50-00-5012 SALARIES-SERGEANTS 588,265 552,940 644,811 700,000 664,437 684,370 704,901 726,048 747,829 01-210-50-00-5013 SALARIES-POLICE CLERKS 141,996 162,466 175,554 170,000 183,567 189,074 194,746 200,588 206,606 01-210-50-00-5014 SALARIES-CROSSING GUARD 24,855 29,460 27,500 30,000 30,000 30,000 30,000 30,000 30,000 01-210-50-00-5015 PART-1'IME SALARIES 39,961 34,390 70,000 65,500 70,000 70,000 70,000 70,000 70,000 01-210-50-00-5020 OVERTIME 97,618 92,461 111,000 111,000 111,000 111,000 111,000 111,000 111,000 01-210-52-00-5212 RETIREMENT PLAN CONTRIBUTION 15,192 16,262 16,106 17,000 20,767 21,649 22,863 24,071 24,793 01-210-52-00-5213 EMPLOYER CONTRIBUTION-POLICE PENSION 966,211 963,361 1,111,484 1,111,484 1,230,604 1,268,042 1,300,225 1,332,739 1,365,760 01-210-52-00-5214 FICA CONTRIBUTION 215,493 219,536 245,951 258,000 253,963 270,705 278,826 287,191 295,807 01-210-52-00-5216 GROUP HEALTH INSURANCE 659,332 624,253 741,025 629,898 648,780 735,640 794,491 858,050 926,694 01-210-52-00-5222 GROUP LIFE INSURANCE 3,620 2,281 2,748 2,562 2,714 2,825 2,853 2,882 2,911 01-210-52-00-5223 DENTAL INSURANCE 48,896 46,051 50,770 44,632 41,677 45,669 47,952 50,350 52,868 01-210-52-00-5224 VISION INSURANCE 6,594 6,408 7,080 6,311 6,602 7,043 7,254 7,472 7,696 01-210-54-00-5410 TUITION REIMBURSEMENT 8,442 10,050 17,272 15,000 15,000 17,654 6,800 - - 01-210-54-00-5411 POLICE COMMISSION 13,844 9,846 4,000 4,000 17,250 4,000 6,000 17,250 6,000 01-210-54-00-5412 TRAINING&CONFERENCE 16,862 27,103 21,000 19,000 25,500 25,500 25,500 25,500 25,500 01-210-54-00-5415 TRAVEL&LODGING 7,541 1,713 10,000 5,000 10,000 10,000 10,000 10,000 10,000 01-210-54-00-5422 VEHICLE&EQUIPMENT CHARGEBACK 130,208 77,158 24,032 24,032 43,844 99,950 164,950 99,950 99,950 01-210-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK - 6,115 16,000 16,000 - 3,634 21,155 3,185 2,203 01-210-54-00-5430 PRINTING&DUPLICATING 5,713 3,402 4,500 4,750 5,000 5,000 5,000 5,000 5,000 01-210-54-00-5440 TELECOMMUNICATIONS 34,985 42,738 40,000 41,000 42,000 42,000 42,000 42,000 42,000 01-210-54-00-5452 POSTAGE&SHIPPING 944 1,187 1,600 1,100 1,200 1,200 1,200 1,200 1,200 01-210-54-00-5460 DUES&SUBSCRIPTIONS 5,985 10,490 9,000 13,000 10,700 10,700 10,700 10,700 10,700 01-210-54-00-5462 PROFESSIONAL SERVICES 41,679 21,328 42,500 42,500 36,750 36,750 36,750 36,750 36,750 01-210-54-00-5467 ADJUDICATION SERVICES 12,871 12,925 20,000 20,000 20,000 20,000 20,000 20,000 20,000 01-210-54-00-5469 NEW WORLD&LIVE SCAN 1,995 - 2,000 2,000 2,000 2,000 2,000 2,000 2,000 01-210-54-00-5472 KENDALL CO JOVE PROBATION 3,584 3,717 4,000 4,000 4,000 4,000 4,000 4,000 4,000 01-210-54-00-5484 MDT-ALERTS FEE 6,660 - - - - - - - - 01-210-54-00-5485 RENTAL&LEASE PURCHASE 5,362 5,702 7,150 6,000 5,600 5,600 5,600 5,600 5,600 01-210-54-00-5488 OFFICE CLEANING 11,323 11,416 11,758 11,515 12,181 12,546 12,922 13,310 13,709 01-210-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 46,358 43,635 60,000 50,000 60,000 60,000 60,000 60,000 60,000 01-210-56-00-5600 WEARING APPAREL 12,312 29,110 15,000 25,000 15,000 15,000 15,000 15,000 15,000 01-210-56-00-5610 OFFICE SUPPLIES 2,669 2,665 4,500 3,250 4,500 4,500 4,500 4,500 4,500 01-210.56-00-5620 OPERATING SUPPLIES 13,029 79,069 16,000 10,000 16,500 16,500 16,500 16,500 16,500 01-210-56-00-5650 COMMUNITY SERVICES 1,883 1,446 1,500 1,500 1,500 1,500 1,500 1,500 1,500 01-210-56-00-5690 BALLISTIC VESTS 4,149 7,350 6,000 6,000 3,850 2,750 1,650 7,200 4,800 01-210-56-00-5695 GASOLINE 58,739 54,704 63,000 59,000 63,130 66,287 69,601 73,081 76,735 01-210-56-00-5696 AMMUNITION 9,995 9,915 10,000 10,000 9,000 9,000 9,000 9,000 9,000 5,283,553 5,351,135 5,935,224 5,904,534 6,064,220 6,478,220 6,760,555 6,906,027 7,118,693 9 COMMUNITY DEVELOPMENT DEPARTMENT The primary focus of the Community Development Department is to ensure that all existing and new construction is consistent with the overall development goals of the City which entails short and long-range planning,administration of zoning regulations,building permits issuance and code enforcement.The department also provides staff support to the City Council,Plan Commission,Zoning Board of Appeals and Park Board and assists in the review of all development plans proposed within the United City of Yorkville. FY 2020 FY 2021 FY 2018 FY 2019 Adopted FY 2020 Adopted FY 2022 FY 2023 FY 2024 FY 2025 Actual Actual Budget Projected Budget Projected Projected Projected Projected Expenditures Salaries 427,777 467,435 520,619 510,000 535,995 552,075 568,637 585,696 603,267 Benefits 151,538 166,052 184,592 192,379 201,768 213,374 226,603 240,515 253,764 Contractual Services 44,147 227,722 220,320 170,320 194,700 112,700 121,606 115,972 114,700 Supplies 6,431 7,836 7,655 9,400 9,691 9,913 10,146 10,391 10,648 Total Community Development 629,893 869,045 933,186 882,099 942,154 888,062 926,992 952,574 982,379 $1,200 - U, c $1,000 - . • 0 $800 L I- $600 - $400 - $200 - $0 - 10 FY 2018 FY 2019 FY 2020 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 Account Number Description Actual Actual Adopted Projected Adopted Projected Projected Projected Projected Community Development 01-220-50-00-5010 SALARIES&WAGES 408,213 465,031 520,619 510,000 535,995 552,075 568,637 585,696 603,267 01-220-50-00-5015 PART-TIME SALARIES 19,564 2,404 - - - - - - - 01-220-52-00-5212 RETIREMENT PLAN CONTRIBUTION 43,851 46,722 47,763 51,000 60,639 63,213 66,758 70,284 72,392 01-220-52-00-5214 FICA CONTRIBUTION 31,813 34,486 38,317 38,317 39,552 40,739 41,961 43,220 44,517 01-220-52-00-5216 GROUP HEALTH INSURANCE 69,021 77,686 90,471 94,490 93,545 101,029 109,111 117,840 127,267 01-220-52-00-5222 GROUP LIFE INSURANCE 491 375 429 439 446 450 455 460 465 01-220-52-00-5223 DENTAL INSURANCE 5,590 5,893 6,603 7,052 6,505 6,830 7,172 7,531 7,908 01-220-52-00-5224 VISION INSURANCE 772 890 1,009 1,081 1,081 1,113 1,146 1,180 1,215 01-220-54-00-5412 TRAINING&CONFERENCES 4,876 4,645 7,300 7,300 7,300 7,300 7,300 7,300 7,300 01-220-54-00-5415 TRAVEL&LODGING 7,677 4,713 6,500 6,500 6,500 6,500 6,500 6,500 6,500 01-220-54-00-5422 VEHICLE&EQUIPMENT CHARGEBACK - 44,985 - - - - - - - 01-220-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK - - 4,120 4,120 - - 6,906 1,272 - 01-220-54-00-5426 PUBLISHING&ADVERTISING 2,169 3,433 2,500 2,500 2,500 2,500 2,500 2,500 2,500 01-220-54-00-5430 PRINTING&DUPLICATING 1,367 1,254 1,500 1,500 1,500 1,500 1,500 1,500 1,500 01-220-54-00-5440 TELECOMMUNICATIONS 4,098 3,914 4,000 4,000 4,000 4,000 4,000 4,000 4,000 01-220-54-00-5452 POSTAGE&SHIPPING 591 687 1,000 1,000 500 1,000 1,000 1,000 1,000 01-220-54-00-5459 INSPECTIONS 1,785 102,073 125,000 75,000 70,000 75,000 75,000 75,000 75,000 01-220-54-00-5460 DUES&SUBSCRIPTIONS 2,141 2,876 2,750 2,750 2,750 2,750 2,750 2,750 2,750 01-220-54-00-5462 PROFESSIONAL SERVICES 16,311 56,442 62,500 62,500 92,500 4,000 6,000 6,000 6,000 01-220-54-00-5485 RENTAL&LEASE PURCHASE 3,132 2,700 3,150 3,150 3,150 3,150 3,150 3,150 3,150 01-220-54-00-5490 VEHICLE MAINTENANCE SERVICES - - - - 4,000 5,000 5,000 5,000 5,000 01-220-56-00.5610 OFFICE SUPPLIES 1,707 1,132 1,500 1,500 1,500 1,500 1,500 1,500 1,500 01-220-56-00-5620 OPERATING SUPPLIES 2,699 4,411 3,750 3,750 3,750 3,750 3,750 3,750 3,750 01-220-56-00-5695 GASOLINE 2,025 2,293 2,405 4,150 4,441 4,663 4,896 5,141 5,398 629,893 869,045 933,186 882,099 942,154 888,062 926,992 952,574 982,379 11 PUBLIC WORKS DEPARTMENT - STREET OPERATIONS /HEALTH & SANITATION The Public Works Department is an integral part of the United City of Yorkville. We provide high quality drinking water,efficient disposal of sanitary waste and maintain a comprehensive road and storm sewer network to ensure the safety and quality of life for the citizens of Yorkville. FY 2020 FY 2021 FY 2018 FY 2019 Adopted FY 2020 Adopted FY 2022 FY 2023 FY 2024 FY 2025 Actual Actual Budget Projected Budget Projected Projected Projected Projected Expenditures Salaries 395,459 414,487 434,921 415,500 549,443 564,951 580,925 597,378 614,324 Benefits 196,203 192,711 193,915 190,730 245,418 260,333 277,132 294,894 312,302 Contractual Services 1,239,831 1,344,900 1,390,015 1,414,039 1,591,767 1,604,944 1,665,458 1,685,563 1,728,552 Supplies 97,088 125,841 301,343 218,913 125,910 117,712 119,063 120,481 121,970 Total Public Works 1,928,581 2,077,939 2,320,194 2,239,182 2,512,538 2,547,940 2,642,578 2,698,316 2,777,148 $3,000 - c $2,500 - co N r $2,000 - 1- $1,500 - $1,000 - $500 - $0 - 12 FY 2018 FY 2019 FY 2020 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 Account Number Description Actual Actual Adopted Projected Adopted Projected Projected Projected Projected Public Works-Street Operations 01-410-50-00-5010 SALARIES&WAGES 360,757 378,009 402,421 383,000 516,943 532,451 548,425 564,878 581,824 01-410-50-00-5015 PART-TIME SALARIES 8,550 13,430 12,500 12,500 12,500 12,500 12,500 12,500 12,500 01-410-50-00-5020 OVERTIME 26,152 23,048 20,000 20,000 20,000 20,000 20,000 20,000 20,000 01-410-52-00-5212 RETIREMENT PLAN CONTRIBUTION 41,337 40,023 38,754 40,000 60,746 63,256 66,733 70,185 72,219 01-410.52-00-5214 FICA CONTRIBUTION 29,271 30,330 31,902 31,902 40,268 41,476 42,720 44,002 45,322 01-410-52-00-5216 GROUP HEALTH INSURANCE 116,109 113,502 114,394 110,163 134,105 144,833 156,420 168,934 182,449 01-410-52-00-5222 GROUP LIFE INSURANCE 594 428 437 391 499 504 509 514 519 01-410-52-00-5223 DENTAL INSURANCE 7,827 7,363 7,363 7,256 8,474 8,898 9,343 9,810 10,301 01-410-52-00-5224 VISION INSURANCE 1,065 1,065 1,065 1,018 1,326 1,366 1,407 1,449 1,492 01-410-54-00-5412 TRAINING&CONFERENCES 2,603 1,476 3,000 3,000 4,500 4,500 4,500 4,500 4,500 01-410-54-00-5415 TRAVEL&LODGING 706 950 2,000 2,000 2,500 2,500 2,500 2,500 2,500 01-410-54-00-5422 VEHICLE&EQUIPMENT CHARGEBACK - - - - 142,551 119,646 133,646 119,646 119,646 01-410-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK - 316 6,733 6,733 - 1,618 7,624 - - 01-410-54-00-5435 TRAFFIC SIGNAL MAINTENANCE 8,795 6,201 30,000 30,000 20,000 20,000 20,000 20,000 20,000 01-410-54-00-5440 TELECOMMUNICATIONS 3,433 3,725 3,750 3,750 7,600 7,600 7,600 7,600 7,600 01-410-54-00-5455 MOSQUITO CONTROL 7,142 - 6,281 - 6,300 6,615 6,946 7,293 7,658 01-410-54-00-5458 TREE&STUMP MAINTENANCE 5,725 10,245 15,000 10,000 13,000 13,000 13,000 13,000 13,000 01-410-54-00-5462 PROFESSIONAL SERVICES 3,489 5,758 6,825 6,825 9,225 9,225 9,225 9,225 9,225 01-410-54-00-5483 JULIE SERVICES - 2,190 3,000 3,000 3,000 3,000 3,000 3,000 3,000 01-410-54-00-5485 RENTAL&LEASE PURCHASE 1,238 2,124 6,000 6,000 6,000 6,000 6,000 6,000 6,000 01-410-54-00-5488 OFFICE CLEANING 1,164 1,020 1,051 731 788 812 836 861 887 01-410-54-00-5490 VEHICLE MAINTENANCE SERVICES 64,919 105,158 65,000 65,000 65,000 65,000 65,000 65,000 65,000 01-410-56-00-5600 WEARING APPAREL 6,632 3,584 5,100 5,100 5,000 5,000 5,000 5,000 5,000 01-410-56-00-5618 SALT&CALCIUM CHLORIDE - - 157,500 57,070 - - - - - 01-410-56-00-5620 OPERATING SUPPLIES 18,832 37,460 40,000 58,000 19,450 22,000 22,000 22,000 22,000 01-410-56-00-5628 VEHICLE MAINTENANCE SUPPLIES 27,125 32,735 30,000 30,000 42,000 30,000 30,000 30,000 30,000 O1-410-56-00-5630 SMALL TOOLS&EQUIPMENT 3,288 1,613 18,500 18,500 7,500 7,500 7,500 7,500 7,500 O1-410-56-00-5640 REPAIR&MAINTENANCE 19,339 29,897 25,000 25,000 24,000 25,000 25,000 25,000 25,000 01-410-56-00-5665 JULIE SUPPLIES - 380 1,200 1,200 2,234 1,200 1,200 1,200 1,200 01-410-56-00-5695 GASOLINE 21,872 20,172 24,043 24,043 25,726 27,012 28,363 29,781 31,270 787,964 872,202 1,078,819 962,182 1,201,235 1,202,512 1,256,997 1,271,378 1,307,612 Public Works-Health&Sanitation O1-540-54-00-5441 GARBAGE SERVICES-SENIOR SUBSIDY 31,147 32,799 34,081 35,000 35,875 36,772 37,875 39,011 40,181 O1-540-54-00-5442 GARBAGE SERVICES 1,105,630 1,166,218 1,200,294 1,236,000 1,268,428 1,301,656 1,340,706 1,380,927 1,422,355 01-540-54-00-5443 LEAF PICKUP 3,840 6,720 7,000 6,000 7,000 7,000 7,000 7,000 7,000 1,140,617 1,205,737 1,241,375 1,277,000 1,311,303 1,345,428 1,385,581 1,426,938 1,469,536 Total Public Works 1,928,581 2,077,939 2,320,194 2,239,182 2,512,538 2,547,940 2,642,578 2,698,316 2,777,148 13 ADMINISTRATIVE SERVICES DEPARTMENT The Administrative Services Department accounts for General Fund expenditures that are shared by all departments and cannot be easily classified in one department or the other. These expenditures include such items as tax rebates,shared services,information technology,bad debt,engineering services,legal expenditures and interfund transfers. FY 2020 FY 2021 FY 2018 FY 2019 Adopted FY 2020 Adopted FY 2022 FY 2023 FY 2024 FY 2025 Actual Actual Budget Projected Budget Projected Projected Projected Projected Expenditures Salaries 17,640 - 500 4,103 500 500 500 500 500 Benefits 334,909 335,729 379,699 371,308 398,253 418,662 436,163 459,333 483,893 Contractual Services 2,925,753 2,953,274 3,121,021 2,980,922 3,245,272 3,150,936 3,013,744 3,058,754 3,091,509 Supplies 14,929 2,809 15,000 15,000 15,000 15,000 15,000 15,000 15,000 Contingency - - - - 80,000 50,000 50,000 50,000 50,000 Other Financing Uses 2,779,764 3,040,283 2,580,400 2.561,741 2,085,837 2,837,124 3,241,807 3,117,585 3,267,070 Total Admin Services&Transfers 6,072,995 6,332,095 6,096,620 5,933,074 5,824,862 6,472,222 6,757,214 6,701,172 6,907,972 $7,000 - t, $6,800 - $6,600 - co o $6,400 - L � $6,20 - $6,000 - $5,800 - $5,600 - $5,400 $5,200 14 FY 2018 FY 2019 FY 2020 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 Account Number Description Actual Actual Adopted Projected Adopted Projected Projected Projected Projected Administrative Services 01-640-50-00-5016 SALARIES-SPECIAL CENSUS 16,740 - - - - - - - - 01-640-50-00-5092 POLICE SPECIAL DETAIL WAGES 900 - 500 4,103 500 500 500 500 500 01-640-52-00-5214 FICA CONTRIBUTION-SPECIAL CENSUS 1,281 - - - - - - - - 01-640-52-00-5230 UNEMPLOYMENT INSURANCE 6,402 16,317 15,000 15,000 15,000 15,000 15,000 15,000 15,000 01-640-52-00-5231 LIABILITY INSURANCE 294,582 298,408 316,374 312,440 343,684 364,305 386,163 409,333 433,893 01-640-52-00-5240 RETIREES-GROUP HEALTH INSURANCE 31,857 20,877 47,796 42,356 39,066 38,962 35,000 35,000 35,000 01-640-52-00-5241 RETIREES-DENTAL INSURANCE 554 86 449 1,314 423 333 - - - 01-640-52-00-5242 RETIREES-VISION INSURANCE 233 41 80 198 80 62 - - - 01-640-54-00-5418 PURCHASING SERVICES 54,535 42,953 50,465 53,750 59,664 64,187 65,349 66,207 71,330 01-640-54-00-5423 IDOR ADMINISTRATION FEE 51,945 45,372 44,689 46,220 47,047 47,998 48,869 49,759 50,669 01-640-54-00-5427 GC HOUSING RENTAL ASSISTANCE 1,034 6,555 7,800 8,148 9,843 10,827 11,910 13,101 14,411 01-640-54-00-5428 UTILITY TAX REBATE 14,375 3,305 14,375 14,375 14,375 14,375 - - - 01-640-54-00-5432 FACILITY MANAGEMENT SERVICES 1,072 53,471 57,425 57,425 64,443 65,510 68,686 74,158 75,521 01-640-54-00-5439 AMUSEMENT TAX REBATE 47,723 44,548 60,000 46,000 46,000 37,500 25,000 20,833 - 01-640-54-00-5449 KENCOM 119,698 106,287 126,109 105,858 154,350 145,928 161,021 175,423 193,465 01-640-54-00.5450 INFORMATION TECHNOLOGY SERVICES 203,809 203,631 255,000 240,033 392,681 382,500 225,000 225,000 225,000 01-640-54-00-5456 CORPORATE COUNSEL 99,701 134,248 115,000 85,000 110,000 110,000 110,000 110,000 110,000 01-640-54-00-5461 LITIGATION COUNSEL 188,411 78,469 120,000 60,000 110,000 110,000 110,000 110,000 110,000 01-640-54-00-5462 PROFESSIONAL SERVICES - 21,042 38,670 38,670 8,250 8,250 8,250 8,250 8,250 01-640-54-00-5463 SPECIAL COUNSEL 9,511 55,901 25,000 50,000 25,000 25,000 25,000 25,000 25,000 01-640.54-00-5465 ENGINEERING SERVICES 379,663 385,933 390,000 390,000 390,000 390,000 390,000 390,000 390,000 01-640.54-00-5473 KENDALL AREA TRANSIT 23,550 23,550 25,000 23,550 25,000 25,000 25,000 25,000 25,000 01-640-54-00-5475 CABLE CONSORTIUM FEE 96,010 101,403 96,000 104,000 105,000 - - - - 01-640-54-00-5478 SPECIAL CENSUS 3,349 - - - - - - - - 01-640-54-00-5481 HOTEL TAX REBATE 71,642 69,807 72,000 72,000 72,000 72,000 72,000 72,000 72,000 01-640-54-00-5486 ECONOMIC DEVELOPMENT 145,989 161,950 146,000 157,970 160,000 160,000 160,000 160,000 160,000 01-640-54-00-5491 CITY PROPERTY TAX REBATE 1,233 1,233 1,500 1,258 1,300 1,350 1,350 1,400 1,400 01-640-54-00-5492 SALES TAX REBATE 879,122 862,920 912,900 888,982 906,762 924,897 943,395 962,263 981,508 01-640-54-00-5493 BUSINESS DISTRICT REBATE 401,611 402,177 421,088 390,040 397,057 409,114 416,414 423,860 431,455 01-640-54-00-5494 ADMISSIONS TAX REBATE 130,766 148,133 140,000 146,143 145,000 145,000 145,000 145,000 145,000 01-640-54-00-5499 BAD DEBT 1,004 386 2,000 1,500 1,500 1,500 1,500 1,500 1,500 01-640-56-00-5625 REIMBURSABLE REPAIRS 14,929 2,809 15,000 15,000 15,000 15,000 15,000 15,000 15,000 01-640-70-00-7799 CONTINGENCY - - - - 80,000 50,000 50,000 50,000 50,000 01-640-99-00-9915 TRANSFER TO MOTOR FUEL TAX 268 - - - - - - - - 01-640-99-00-9923 TRANSFER TO CITY-WIDE CAPITAL - 569,725 250,000 235,663 260,000 185,436 100,000 100,000 178,400 01-640-99-00-9942 TRANSFER TO DEBT SERVICE 309,972 315,781 319,379 315,825 315,225 321,375 322,075 - - 01-640-99-00-9952 TRANSFER TO SEWER 1,137,166 856,583 575,030 575,030 174,744 586,749 994,479 1,134,606 1,136,806 15 FY 2018 FY 2019 FY 2020 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 Account Number Description Actual Actual Adopted Projected Adopted Projected Projected Projected Projected 01-640-99-00-9979 TRANSFER TO PARKS&RECREATION 1,308,583 1,274,699 1,410,988 1,410,988 1,309,284 1,715,430 1,795,476 1,851,460 1,918,499 01.640-99-00-9982 TRANSFER TO LIBRARY OPERATIONS 23,775 23,495 25,003 24,235 26,584 28,134 29,777 31,519 33,365 6,072,995 6,332,095 6,096,620 5,933,074 5,824,862 6,472,222 6,757,214 6,701,172 6,907,972 Expenditures 15,219,914 16,038,880 16,783,649 16,437,519 16,898,632 17,990,279 18,751,404 18,997,631 19,583,135 Surplus(Deficit) 282,289 383,443 (314,411) 407,336 34,854 (685,039) (1,140,377) (1,092,118) (1,380,586) Fund Balance 6,496,373 6,879,823 5,468,778 7,287,159 7,322,013 6,636,974 5,496,597 4,404,479 3,023,893 42.68% 42.89% 32.58% 44.33% 43.33% 3689% 29.31% 23.18% 15.44% 16 Fox Hill SSA Fund (11) This fund was created for the purpose of maintaining the common areas of the Fox Hill Estates(SSA 2004-201)subdivision. All money for the fund is derived from property taxes levied on homeowners in the subdivision. FY 2020 FY 2021 FY 2018 FY 2019 Adopted FY 2020 Adopted FY 2022 FY 2023 FY 2024 FY 2025 Actual Actual Budget Projected Budget Projected Projected Projected Projected Revenue Taxes 9,366 13,381 13,381 13,382 16,034 20,012 24,432 28,852 33,272 Total Revenue 9,366 13,381 13,381 13,382 16,034 20,012 24,432 28,852 33,272 Expenditures Contractual Services 17,552 9,453 30,977 18,189 37,326 40,482 15,646 17,258 17,439 Total Expenditures 17,552 9,453 30,977 18,189 37,326 40,482 15,646 17,258 17,439 Surplus(Deficit) (8,186) 3,928 (17,596) (4,807) (21,292) (20,470) 8,786 11,594 15,833 Ending Fund Balance 6,556 10,485 9,954 5,678 (15,614) (36,084) (27,298) (15,704) 129 37.35% 110.92% 32.13% 31.22% -41.83% -89.14% -174.47% -91.00% 0.74% N $20 Fund Balance • • $0 3 o I- ($20) ($40) 17 FY 2018 FY 2019 FY 2020 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 Account Number Description Actual Actual Adopted Projected Adopted Projected Projected Projected Projected Fox Hill SSA-11 11-000-40-00-4000 PROPERTY TAXES 9,366 13,381 13,381 13,382 16,034 20,012 24,432 28,852 33,272 Revenue 9,366 13,381 13,381 13,382 16,034 20,012 24,432 28,852 33,272 11-111-54-00-5462 PROFESSIONAL SERVICES 2,138 2,835 2,977 3,275 3,126 3,282 3,446 3,618 3,799 11-111-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 15,414 6,618 28,000 14,914 34,200 37,200 12,200 13,640 13,640 Expenditure 17,552 9,453 30,977 18,189 37,326 40,482 15,646 17,258 17,439 Surplus(Deficit) (8,186) 3,928 (17,596) (4,807) (21,292) (20,470) 8,786 11,594 15,833 Fund Balance 6,556 10,485 9,954 5,678 (15,614) (36,084) (27,298) (15,704) 129 37.35% 110.92% 32.13% 31.22% -41.83% -89.14% -174.47% -91.00% 0.74% 18 Sunflower SSA Fund (12) This fund was created for the purpose of maintaining the common areas of the Sunflower Estates(SSA 2006-119)subdivision. All money for the fund is derived from property taxes levied on homeowners in the subdivision. FY 2020 FY 2021 FY 2018 FY 2019 Adopted FY 2020 Adopted FY 2022 FY 2023 FY 2024 FY 2025 Actual Actual Budget Projected Budget Projected Projected Projected Projected Revenue Taxes 13,480 15,639 18,140 18,140 20,363 22,586 24,926 27,266 29,606 Total Revenue 13,480 15,639 18,140 18,140 20,363 22,586 24,926 27,266 29,606 Expenditures Contractual Services 18,957 17,013 13,977 14,181 20,326 20,482 20,646 22,258 22,439 Total Expenditures 18,957 17,013 13,977 14,181 20,326 20,482 20,646 22,258 22,439 Surplus(Deficit) (5,477) (1,374) 4,163 3,959 37 2,104 4,280 5,008 7,167 Ending Fund Balance (21,251) (22,626) (28,236) (18,667) (18,630) (16,526) (12,246) (7,238) (71) % -112.10% -132.99% -202.02% -131.63% -91.66% -80.69% -59.31% -32.52% -0.32% so Fund Balance N c 0 ($30) - 19 FY 2018 FY 2019 FY 2020 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 Account Number Description Actual Actual Adopted Projected Adopted Projected Projected Projected Projected Sunflower SSA-12 12-000-40-00-4000 PROPERTY TAXES 13,480 15,639 18,140 18,140 20,363 22,586 24,926 27,266 29,606 Revenue 13,480 15,639 18,140 18,140 20,363 22,586 24,926 27,266 29,606 12-112-54-00-5416 POND MAINTENANCE 5,095 1,525 5,000 5,000 5,000 5,000 5,000 5,000 5,000 12-112-54-00-5462 PROFESSIONAL SERVICES 2,138 2,835 2,977 3,181 3,126 3,282 3,446 3,618 3,799 12-112-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 11,724 12,653 6,000 6,000 12,200 12,200 12,200 13,640 13,640 Expenditures 18,957 17,013 13,977 14,181 20,326 20,482 20,646 22,258 22,439 Surplus(Deficit) (5,477) (1,374) 4,163 3,959 37 2,104 4,280 5,008 7,167 Fund Balance (21,251) (22,626) (28,236) (18,667) (18,630) (16,526) (12,246) (7,238) (71) -112.10% -132.99% -202.02% -131,63% -91.66% -80.69% -59.31% -32.52% -0.32% 20 Motor Fuel Tax Fund (15) The Motor Fuel Tax Fund is used to maintain existing and construct new City owned roadways,alleys and parking lots. The fund also purchases materials used in the maintenance and operation of those facilities. FY 2020 FY 2021 FY 2018 FY 2019 Adopted FY 2020 Adopted FY 2022 FY 2023 FY 2024 FY 2025 Actual Actual Budget Projected Budget Projected Projected Projected Projected Revenue Intergovernmental 495,510 530,471 525,084 691,862 809,598 901,959 918,378 935,126 952,208 Investment Earnings 8,475 15,511 9,820 10,250 4,263 1,969 747 - - Reimbursements - 100 - 26,717 - - - - - Other Financing Sources 268 - - - - - - - - Total Revenue 504,253 546,082 534,904 728,829 813,861 903,928 919,125 935,126 952,208 Expenditures Contractual Services 98,120 95,684 - - - - - - - Supplies 126,075 84,453 97,930 97,930 175,000 175,000 175,000 175,000 175,000 Capital Outlay 373,787 429,058 718,788 617,357 942,462 914,788 853,045 816,000 816,000 Total Expenditures 597,982 609,195 816,718 715,287 1,117,462 1,089,788 1,028,045 991,000 991,000 Surplus(Deficit) (93,729) (63,113) (281,814) 13,542 (303,601) (185,860) (108,920) (55,874) (38,792) Ending Fund Balance 698,493 635,382 428,536 648,924 345,323 159,463 50,543 (5,331) (44,123) $800 - Fund Balance $600 ___. o $400 - $200 - $0 ($200) - 21 FY 2018 FY 2019 FY 2020 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 Account Number Description Actual Actual Adopted Projected Adopted Projected Projected Projected Projected Motor Fuel Tax -15 15-000-41-00-4112 MOTOR FUEL TAX 454,449 482,866 484,084 680,037 793,598 820,959 837,378 854,126 871,208 15-000-41-00-4113 MFI'HIGH GROWTH 41,061 47,605 41,000 11,825 11,000 11,000 11,000 11,000 11,000 15-000-41-00-4115 REBUILD ILLINOIS - - - - 5,000 70,000 70,000 70,000 70,000 15-000-45.00-4500 INVESTMENT EARNINGS 8,475 15,511 9,820 10,250 4,263 1,969 747 - - 15-000-46-00-4690 REIMB-MISCELLANEOUS - 100 - 26,717 - - - - - 15-000-49-00-4901 TRANSFER FROM GENERAL 268 - - - - - - - - Revenue 504,253 546,082 534,904 728,829 813,861 903,928 919,125 935,126 952,208 15-155-54-00-5438 SALT STORAGE 7,750 - - - - - - - - 15-155-54-00-5482 STREET LIGHTING 90,370 95,684 - - - - - - - 15-155-56-00-5618 SALT 84,015 84,453 97,930 97,930 175,000 175,000 175,000 175,000 175,000 15-155-56-00-5619 SIGNS 9,171 - - - - - - - - 15-155-56-00-5632 ASPHALT PATCHING 21,653 - - - - - - - - 15-155-56-00-5642 STREET LIGHTING SUPPLIES 11,236 - - - - - - - - 15-155-60-00-6004 BASELINE ROAD BRIDGE REPAIRS - - 25,000 - 25,000 25,000 - - - 15-155-60-00-6025 ROAD TO BETTER ROADS PROGRAM 300,000 355,271 620,000 543,569 781,674 754,000 754,000 754,000 754,000 15-550-60-00-6028 PAVEMENT STRIPING PROGRAM - - - - 62,000 62,000 62,000 62,000 62,000 15-155-60-00-6079 ROUTE 47 EXPANSION 73,787 73,787 73,788 73,788 73,788 73,788 37,045 - - Expenditures 597,982 609,195 816,718 715,287 1,117,462 1,089,788 1,028,045 991,000 991,000 Surplus(Deficit) (93,729) (63,113) (281,814) 13,542 (303,601) (185,860) (108,920) (55,874) (38,792) Fund Balance 698,493 635,382 428,536 648,924 345,323 159,463 50,543 (5,331) (44,123) 22 City-Wide Capital Fund (23) The City-Wide Capital Fund is used to maintain existing and construct new public and municipal infrastructure,and to fund other improvements that benefit the public. FY 2020 FY 2021 FY 2018 FY 2019 Adopted FY 2020 Adopted FY 2022 FY 2023 FY 2024 FY 2025 Actual Actual Budget Projected Budget Projected Projected Projected Projected Revenue Intergovernmental 206,028 32,878 - - - - - - - Licenses&Permits 448,616 300,743 152,180 151,000 141,000 141,000 141,000 141,000 141,000 Charges for Service 731,535 752,262 746,500 772,000 780,000 785,000 790,000 795,000 800,000 Investment Earnings 21,033 34,012 7,500 63,351 1,098 - 712 379 - Reimbursements 373,768 1,169,174 3,013,849 319,086 151,572 2,964,928 - - 171,600 Miscellaneous - - 2,000 - 2,000 2,000 2,000 2,000 2,000 Other Financing Sources 1,018,308 569,725 250,000 235,663 260,000 185,436 100,000 100,000 178,400 Total Revenue 2,799,288 2,858,794 4,172,029 1,541,100 1,335,670 4,078,364 1,033,712 1,038,379 1,293,000 Expenditures Contractual Services 339,391 135,926 334,795 229,795 260,964 197,503 204,435 211,783 219,571 Supplies 18,945 56,337 82,000 58,427 127,000 127,000 127,000 127,000 127,000 Capital Outlay 2,846,631 1,923,491 3,907,339 1,048,776 779,950 3,425,476 158,000 269,467 519,467 Debt Service 403,588 407,563 322,188 322,188 321,338 315,338 319,338 313,038 316,738 Other Financing Uses 157,366 94,947 152,086 139,906 138,895 139,558 139,209 139,627 139,034 Total Expenditures 3,765,921 2,618,264 4,798,408 1,799,092 1,628,147 4,204,875 947,982 1,060,915 1,321,810 Surplus(Deficit) (966,633) 240,530 (626,379) (257,992) (292,477) (126,511) 85,730 (22,536) (28,810) Ending Fund Balance 388,897 629,429 (30,817) 371,437 78,960 (47,551) 38,179 15,643 (13,167) Fund Balance N $800 - v $600 - N c $400 - r ~ $200 - $0 -- ($200) -($200) - 23 FY 2018 FY 2019 FY 2020 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 Account Number Description Actual Actual Adopted Projected Adopted Projected Projected Projected Projected City-Wide Capital-23 23-000-41-00-4161 FEDERAL GRANTS-ITEP DOWNTOWN 540 - - - - - - - - 23-000-41-00-4169 FEDERAL GRANTS-MILL STREET LAFO (1,306) - - - - - - - - 23-000-41-00-4178 FEDERAL GRANTS-ITEP KENNEDY RD TRAIL 223,344 - - - - - - - - 23-000.41-00-4188 STATE GRANTS-EDP WRIGLEY(RTE 47) (16,550) 32,878 - - - - - - - 23-000-42-00-4210 BUILDING PERMITS 139,758 1,499 - - - - - - - 23-000-42-00-4214 DEVELOPMENT FEES-CW CAPITAL 6,929 5,512 5,000 6,000 6,000 6,000 6,000 6,000 6,000 23-000-42-00-4216 BUILD PROGRAM PERMITS 95,804 1,815 - - - - . - - 23-000-42-00-4218 DEVELOPMENT FEES-MUNICIPAL BLDG 92,125 29,917 47,180 35,000 35,000 35,000 35,000 35,000 35,000 23-000-42-00-4222 ROAD CONTRIBUTION FEE 114,000 262,000 100,000 110,000 100,000 100,000 100,000 100,000 100,000 23-000-44-00-4440 ROAD INFRASTRUCTURE FEE 731,535 752,262 746,500 772,000 780,000 785,000 790,000 795,000 800,000 23-000-45-00-4500 INVESTMENT EARNINGS 10,271 34,012 7,500 13,000 1,098 - 712 379 - 23-000-45-00-4550 GAIN ON INVESTMENT 10,762 - - 50,351 - - - - - 23-000-46-00-4607 REIMS-BLACKBERRY WOODS 7,797 4,125 7,549 7,549 10,973 - - - - 23-000-46-00-4608 REIMB-KENNEDY ROAD IMPROVEMENTS 160,000 - - - - - - - - 23-000-46-00-4612 REIMB-MILL ROAD IMPROVEMENTS - 195,781 2,926,300 19,306 - 2,926,330 - - - 23-000-46-00-4618 REIMB-BRISTOL BAY ANNEX - - - - - - - - 171,600 23-000-46-00-4621 REIMB-FOUNTAIN VILLAGE 19,346 99,284 - 82,231 38,599 38,598 - - - 23-000-46-00-4624 REIMB-WHISPERING MEADOWS 2,762 797,238 - - - - - - - 23-000-46-00-4636 REIMB-RAINTREE VILLAGE - - - 210,000 70,000 - - - - 23-000-46-00-4660 REIMB-PUSH FOR THE PATH 182,033 - - - 26,523 - - - - 23-000-46-00-4690 REIMB-MISCELLANEOUS 1,830 72,746 80,000 - 5,477 - - - - 23-000-48-00-4845 DONATIONS - - 2,000 - 2,000 2,000 2,000 2,000 2,000 23-000-49-00-4923 TRANSFER FROM GENERAL - 569,725 250,000 235,663 260,000 185,436 100,000 100,000 178,400 23-000-49-00-4951 TRANSFER FROM WATER 1,018,308 - - - - - - - - Revenue 2,799,288 2,858,794 4,172,029 1,541,100 1,335,670 4,078,364 1,033,712 1,038,379 1,293,000 City-Wide-Building&Grounds Expenditures 23-216-54-00-5405 BUILD PROGRAM 9,956 - - - - - - - - 23-216-54-00-5446 PROPERTY&BLDG MAINT SERVICES 193,257 71,157 225,000 120,000 135,000 75,000 75,000 75,000 75,000 23-216-56-00-5626 HANGING BASKETS - 1,496 2,000 427 2,000 2,000 2,000 2,000 2,000 23-216-56-00-5656 PROPERTY&BLDG MAINT SUPPLIES 17,997 36,642 25,000 18,000 25,000 25,000 25,000 25,000 25,000 23-216-60-00-6003 MATERIALS STORAGE BUILDING - - 250,000 235,663 - - - - - 23-216-60-00-6013 BEECHER CENTER - 320,386 - - - - - - - BUILDINGS&STRUCTURES - - 41,250 - - - - - - 23-216-99-00-9901 TRANSFER TO GENERAL 92,125 29,917 47,180 35,000 35,000 35,000 35,000 35,000 35,000 313,335 459,598 590,430 409,090 197,000 137,000 137,000 137,000 137,000 24 FY 2018 FY 2019 FY 2020 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 Account Number Description Actual Actual Adopted Projected Adopted Projected Projected Projected Projected City-Wide Capital Expenditures 23-230-54-00-5405 BUILD PROGRAM 85,848 1,815 - - - _ _ _ 23-230-54-00-5462 PROFESSIONAL SERVICES 5,318 2,360 5,000 5,000 5,000 5,000 5,000 5,000 5,000 23-230-54-00-5465 ENGINEERING SERVICES 35,063 58,195 - - 10,000 23-230-54-00-5482 STREET LIGHTING - - 102,820 102,820 108,989 115,528 122,460 129,808 137,596 23-230-54-00-5497 PROPERTY TAX PAYMENT 8,054 1,239 - - - - _ _ _ 23-230-54-00-5498 PAYING AGENT FEES 475 475 475 475 475 475 475 475 475 23-230-54-00-5499 BAD DEBT 1,420 685 1,500 1,500 1,500 1,500 1,500 1,500 1,500 23-230-56-00-5619 SIGNS - - 15,000 15,000 15,000 15,000 15,000 15,000 15,000 23-230-56-00-5632 ASPHALT PATCHING - - 35,000 20,000 35,000 35,000 35,000 35,000 35,000 23-230-56-00-5637 SIDEWALK CONSTRUCTION SUPPLIES 948 18,199 5,000 5,000 5,000 5,000 5,000 5,000 5,000 23-230-56-00-5642 STREET LIGHTING&OTHER SUPPLIES - - - - 45,000 45,000 45,000 45,000 45,000 23-230-60-00-6009 WRIGLEY(RTE 47)EXPANSION - 32,878 - - - _ _ - _ 23-230-60-00-6012 MILL ROAD IMPROVEMENTS - 195,781 3,105,000 200,000 - 3,175,000 - - - 23-230-60-00-6014 BLACKBERRY WOODS 7,797 4,125 7,549 7,549 10,973 - - - - 23-230-60-00-6016 US 34(CENTER/ELDAMAIN RD)PROJECT 19,500 127,534 110,226 100,000 110,000 - - - - 23-230-60-00-6019 BRISTOL BAY ACCESS ROAD 40,754 - - - _ - - - - 23-230-60-00-6021 PAVILLION ROAD STREAMBANK STABILIZATION - 260 137,500 - - - - _ - 23-230-60-00-6023 FOUNTAIN VILLAGE SUBDIVISION 19,346 99,284 - 82,231 38,599 38,598 - - - 23-230-60-00-6025 ROAD TO BETTER ROADS PROGRAM 761,759 69,633 80,000 98,000 312,500 96,000 96,000 96,000 96,000 23-230-60-00-6034 WHISPERING MEADOWS SUBDIVISION 2,762 974,071 22,500 8,000 - - - _ - 23-230-60-00-6036 RAINTREE VILLAGE IMPROVEMENTS - - - 210,000 70,000 - 23-230-60-00.6041 SIDEWALK REPLACEMENT PROGRAM - - - - 125,000 62,000 62,000 62,000 62,000 23-230-60-00-6048 DOWNTOWN STREETSCAPE IMPROVEMENT 675 - - - - - - - - 23-230-60-00-6058 ROUTE 71(RTE 47/RTE 126)PROJECT - 8,351 30,333 30,333 53,878 53,878 - - - 23-230-60-00-6059 US 34(IL 47/ORCHARD RD)PROJECT 78,682 84,854 90,981 77,000 27,000 - - - - 23-230-60-00-6063 ROUTE 47(RTE 30/WATER PARK WAY) - - - - - - - 111,467 111,467 23-230-60-00-6073 GAME FARM ROAD PROJECT 328,913 - - - - - _ _ - 23-230-60-00-6082 COUNTRYSIDE PKY IMPROVEMENTS 561,550 - - - - - - - - 23-230-60-00-6084 CENTER&COUNTRYSIDE IMPROVEMENTS 227,760 - - - - - - - - 23-230-60-00-6086 KENNEDY ROAD IMPROVEMENTS 391,763 404 - - - - - - - 23.230-60-00.6094 KENNEDY ROAD BIKE TRAIL 405,370 5,930 32,000 - 32,000 - - - - 23-230-60-00-6098 BRISTOL BAY SUBDIVISION - - - - - - - - 250,000 2014A Bond 23-230-78-00-8000 PRINCIPAL PAYMENT 190,000 190,000 195,000 195,000 200,000 200,000 210,000 210,000 220,000 23-230-78-00-8050 INTEREST PAYMENT 138,588 132,888 127,188 127,188 121,338 115,338 109,338 103,038 96,738 25 FY 2018 FY 2019 FY 2020 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 Account Number Description Actual Actual Adopted Projected Adopted Projected Projected Projected Projected Kendall County Loan-River Road Bridge 23-230-97-00-8000 PRINCIPAL PAYMENT 75,000 84,675 - - - - - - - 23-230-99-00-9951 TRANSFER TO WATER 65,241 65,030 104,906 104,906 103,895 104,558 104,209 104,627 104,034 3,452,586 2,158,666 4,207,978 1,390,002 1,431,147 4,067,875 810,982 923,915 1,184,810 Expenditures 3,765,921 2,618,264 4,798,408 1,799,092 1,628,147 4,204,875 947,982 1,060,915 1,321,810 Surplus(Deficit) (966,633) 240,530 (626,379) (257,992) (292,477) (126,511) 85,730 (22,536) (28,810) Fund Balance 388,897 629,429 (30,817) 371,437 78,960 (47,551) 38,179 15,643 (13,167) 26 Vehicle and Equipment Fund(25) This fund was created in Fiscal Year 2014,consolidating the Police Capital,Public Works Capital and Park&Recreation Capital funds. The General Government function was added in Fiscal Year 2019 to account for administrative vehicle and City-wide computer purchases.This fund primarily derives its revenue from monies collected from building permits and development fees,in addition to functional chargebacks. The revenue is primarily used to purchase vehicles and equipment for use in the operations of the Police,Public Works and Parks&Recreation Departments. FY 2020 FY 2021 FY 2018 FY 2019 Adopted FY 2020 Adopted FY 2022 FY 2023 FY 2024 FY 2025 Actual Actual Budget Projected Budget Projected Projected Projected Projected Revenue Licenses&Permits 229,575 243,142 109,500 361,911 109,500 109,500 109,500 109,500 109,500 Fines&Forfeits 8,730 8,640 8,650 8,325 8,800 8,800 8,800 8,800 8,800 Charges for Service 201,102 232,472 86,368 91,530 269,059 286,131 433,814 284,156 283,855 Investment Earnings 596 862 850 2,199 1,000 1,000 1,000 1,000 1,000 Reimbursements - - - 33,536 59,464 50,000 - - - Miscellaneous 1,975 511 2,000 - 1,000 1,000 1,000 1,000 1,000 Other Financing Sources - 6,068 - 552,161 - - - - - Total Revenue 441,978 491,695 207,368 1,049,662 448,823 456,431 554,114 404,456 404,155 Police Capital Expenditures Contractual Services 18,485 5,013 8,750 8,750 8,750 8,750 8,750 8,750 8,750 Capital Outlay 182,317 150,707 69,000 64,000 130,000 130,000 195,000 130,000 130,000 Sub-Total Expenditures 200,802 155,720 77,750 72,750 138,750 138,750 203,750 138,750 138,750 General Government Capital Expenditures Supplies - 18,162 60,336 65,283 5,664 14,535 83,218 12,560 12,259 Capital Outlay - 44,985 - - - - - - - Sub-Total Expenditures - 63,147 60,336 65,283 5,664 14,535 83,218 12,560 12,259 Public Works Capital Expenditures Contractual Services 34,464 3,504 750 750 750 750 750 750 750 Supplies - - 2,000 - 1,000 1,000 1,000 1,000 1,000 Capital Outlay 20,821 41,932 208,000 208,000 230,000 126,000 140,000 126,000 126,000 Debt Service 70,815 72,778 75,524 66,677 69,396 69,396 69,396 69,396 69,396 Other Financing Uses - - - 531,617 - - - - - Sub-Total Expenditures 126,100 118,214 286,274 807,044 301,146 197,146 211,146 197,146 197,146 Parks&Rec Capital Expenditures Contractual Services 850 - 5,000 5,000 1,600 1,600 1,600 1,600 1,600 Capital Outlay 25,167 13,539 140,000 108,898 202,460 105,400 55,400 55,400 55,400 Debt Service 2,219 2,280 2,366 2,089 2,174 2,174 2,174 2,174 2,174 Other Financing Uses - - - 16,656 - - - - - Sub-Total Expenditures 28,236 15,819 147,366 132,643 206,234 109,174 59,174 59,174 59,174 Total Expenditures 355,138 352,900 571,726 1,077,720 651,794 459,605 557,288 407,630 407,329 Surplus(Deficit) 86,840 138,795 (364,358) (28,058) (202,971) (3,174) (3,174) (3,174) (3,174) Police Capital Fund Balance - - - 56,106 - - - - - General Government Fund Balance - - - 450 450 450 450 450 450 Public Works Capital Fund Balance 37,930 91,907 6,435 81,095 - - - - - Parks&RecCapitalFundBalance 319,316 404,135 257,366 330,333 264,563 261,389 258,215 255,041 251,867 Ending Fund Balance 357,246 496,042 263,801 467,984 265,013 261,839 258,665 255,491 252,317 N $600 - Fund Balance 12 S $400 - 8 0 - $200 $o , , 27 FY 2018 FY 2019 FY 2020 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 Account Number Description Actual Actual Adopted Projected Adopted Projected Projected Projected Projected Vehicle&Equipment-25 25-000-42-00-4215 DEVELOPMENT FEES-POLICE CAPITAL 51,511 63,225 30,000 92,500 30,000 30,000 30,000 30,000 30,000 25-000-42-004216 BUILD PROGRAM PERMITS 44,935 2,720 - - - - - _ 25-000-42-00-4217 WEATHER WARNING SIREN FEES 224 217 - 1,411 - - - _ - 25-000-42-00-4218 ENGINEERING CAPITAL FEE 11,000 19,550 10,000 12,000 10,000 10,000 10,000 10,000 10,000 25-000-42-00-4219 DEVELOPMENT FEES-PW CAPITAL 116,205 147,655 64,500 250,000 64,500 64,500 64,500 64,500 64,500 25-000-42-00-4220 DEVELOPMENT FEES-PARK CAPITAL 5,700 9,775 5,000 6,000 5,000 5,000 5,000 5,000 5,000 25-000-43-00-4315 DUI FINES 8,130 7,994 8,000 7,500 8,000 8,000 8,000 8,000 8,000 25-000-43-004316 ELECTRONIC CITATION FEES 600 646 650 825 800 800 800 800 800 25-000-44-00-4418 MOWING INCOME 894 2,167 2,000 2,215 2,000 2,000 2,000 2,000 2,000 25-000-44-00-4419 COMMUNITY DEVELOPMENT CHARGEBACK - 44,985 - - _ - _ _ - 25-000-44-00-4420 POLICE CHARGEBACK 130,208 77,158 24,032 24,032 43,844 99,950 164,950 99,950 99,950 25-000-44-00-4421 PUBLIC WORKS CHARGEBACK - - - - 142,551 119,646 133,646 119,646 119,646 25-000-44-00-4427 PARKS&RECREATION CHARGEBACK 70,000 90,000 - - 75,000 50,000 50,000 50,000 50,000 25-000-44-00-4428 COMPUTER REPLACEMENT CHARGEBACK - 18,162 60,336 65,283 5,664 14,535 83,218 12,560 12,259 25-000-45-00-4522 INVESTMENT EARNINGS-PARK CAPITAL 350 862 850 1,050 1,000 1,000 1,000 1,000 1,000 25-000-45-00-4550 GAIN ON INVESTMENT 246 - - 1,149 - _ - - - 25-000-46-00-4692 MISCELLANEOUS REIMB-PARK CAPITAL - - - 33,536 59,464 50,000 - - - MISCELLANEOUS INCOME-POLICE CAPITAL 214 412 - - 25-000-48-00-4854 MISCELLANEOUS INCOME-PW CAPITAL 1,761 99 2,000 - 1,000 1,000 1,000 1,000 1,000 25-000-48-00-4855 MISCELLANEOUS INCOME-PARK CAPITAL - - - - - - - - _ 25-000-49-00-4906 LOAN ISSUANCE - - - 548,273 - _ - - - 25-000-49-00-4910 SALE OF CAPITAL ASSETS-GEN GOV - - - 450 - - _ - - 25-000-49-00-4920 SALE OF CAPITAL ASSETS-POLICE CAPITAL - 6,068 - 2,588 - - _ _ _ 25-000-49-004921 SALE OF CAPITAL ASSETS-PW CAPITAL - - - 400 - - - _ _ 25-000-49-00-4922 SALE OF CAPITAL ASSETS-PARK CAPITAL - - - 450 - _ _ - - Revenue 441,978 491,695 207,368 1,049,662 448,823 456,431 554,114 404,456 404,155 Police Capital 25-205-54-00-5405 BUILD PROGRAM 9,915 - - - - - _ 25-205-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 8,570 5,013 8,750 8,750 8,750 8,750 8,750 8,750 8,750 25-205-60-00-6060 EQUIPMENT 28,278 - 5,000 - - _ - - - 25-205-60-00-6070 VEHICLES 154,039 150,707 64,000 64,000 130,000 130,000 195,000 130,000 130,000 200,802 155,720 77,750 72,750 138,750 138,750 203,750 138,750 138,750 General Government Capital 25-212-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - 18,162 60,336 65,283 5,664 14,535 83,218 12,560 12,259 25-212-60-00-6070 VEHICLES - 44,985 - - - - - - - 63,147 60,336 65,283 5,664 14,535 83,218 12,560 12,259 28 FY 2018 FY 2019 FY 2020 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 Account Number Description Actual Actual Adopted Projected Adopted Projected Projected Projected Projected Public Works Capital 25-215-54-00-5405 BUILD PROGRAM 34,170 2,720 - - - - - - - 25-215-54-00.5448 FILING FEES 294 784 750 750 750 750 750 750 750 25-215-56-00-5620 OPERATING SUPPLIES - - 2,000 - 1,000 1,000 1,000 1,000 1,000 25-215-60-00-6060 EQUIPMENT - 8,435 7,000 7,000 130,000 6,000 20,000 6,000 6,000 25-215-60-00-6070 VEHICLES 20,821 33,497 201,000 201,000 100,000 120,000 120,000 120,000 120,000 185 Wolf Street Building 25-215-92-00-8000 PRINCIPAL PAYMENT 43,303 43,922 44,429 42,853 51,612 53,527 53,527 55,514 57,544 25-215-92-00-8050 INTEREST PAYMENT 27,512 28,856 31,095 23,824 17,784 15,869 15,869 13,882 11,852 25-215-99-00-9960 PAYMENT TO ESCROW AGENT - - - 531,617 - - - - - 126,100 118,214 286,274 807,044 301,146 197,146 211,146 197,146 197,146 Parks&Recreation Capital 25-225-54-00-5405 BUILD PROGRAM 850 - - - - - - - - 25-225-54-00-5495 OUTSIDE REPAIR&MAINTENANCE - - 5,000 5,000 1,600 1,600 1,600 1,600 1,600 25-225-60-00-6010 PARK IMPROVEMENTS - - - 33,536 59,464 50,000 - - 25-225-60-00-6013 BEECHER CENTER PARK - - - - 50,000 - - - - 25-225-60-00-6020 BUILDING&STRUCTURES - - 20,000 7,404 12,596 - - -25-225-60-00-6060 EQUIPMENT 5,264 13,539 50,000 - 10,400 5,400 5,400 5,400 5,400 25-225-60-00-6070 VEHICLES 19,903 - 70,000 67,958 70,000 50,000 50,000 50,000 50,000 185 Wolf Sired Building 25-225-92-00-8000 PRINCIPAL PAYMENT 1,357 1,376 1,392 1,343 1,617 1,677 1,677 1,739 1,803 25-225-92-00-8050 INTEREST PAYMENT 862 904 974 746 557 497 497 435 371 25-225-99-00-9960 PAYMENT TO ESCROW AGENT - - - 16,656 - - - - - 28,236 15,819 147,366 132,643 206,234 109,174 59,174 59,174 59,174 Expenditures 355,138 352,900 571,726 1,077,720 651,794 459,605 557,288 407,630 407,329 Surplus(Deficit) 86,840 138,795 (364,358) (28,058) (202,971) (3,174) (3,174) (3,174) (3,174) Fund Balance-Police Capital - - - 56,106 - - - - - Fund Balance-General Government - - - 430 450 450 450 450 450 Fund Balance-Public Works Capital 37,930 01,907 6,435 81,095 - - - - - Fund Balance-Parks&Rec Capital 319,316 404,135 257,366 330,333 264,563 261,389 258,215 255,041 251,867 Fond Balance 357,246 496,042 263,801 467,984 265,013 261,839 258,665 255,491 252,317 29 Debt Service Fund (42) The Debt Service Fund accumulates monies for payment of the 2014B bonds,which refinanced the 2005A bonds. The 2005A bonds were originally issued to finance road improvement projects. FY 2020 FY 2021 FY 2018 FY 2019 Adopted FY 2020 Adopted FY 2022 FY 2023 FY 2024 FY 2025 Actual Actual Budget Projected Budget Projected Projected Projected Projected Revenue Licenses&Permits 11,303 8,944 4,646 8,200 8,000 8,000 8,000 - - Other Financing Sources 309,972 315,781 319,379 315,825 315,225 321,375 322,075 - - Total Revenue 321,275 324,725 324,025 324,025 323,225 329,375 330,075 - - Expenditures Contractual Services 1,525 475 475 475 475 475 475 - - Debt Service 319,750 324,250 323,550 323,550 322,750 328,900 329,600 - - Total Expenditures 321,275 324,725 324,025 324,025 323,225 329,375 330,075 - - Surplus(Deficit) - - - - - - - - - Ending Fund Balance - - - - - - - - - N $o Fund Balance o so L F 50 7 30 FY 2018 FY 2019 FY 2020 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 Account Number Description Actual Actual Adopted Projected Adopted Projected Projected Projected Projected Debt Service-42 42-000-42-00-4208 RECAPTURE FEES-WATER&SEWER 10,253 8,944 4,646 8,200 8,000 8,000 8,000 - - 42-000-42-00-4216 BUILD PROGRAM PERMITS 1,050 - - - - - - - - 42-000-49-00-4901 TRANSFER FROM GENERAL 309,972 315,781 319,379 315,825 315,225 321,375 322,075 - - Revenue 321,275 324,725 324,025 324,025 323,225 329,375 330,075 - - 42-420-54-00-5405 BUILD PROGRAM 1,050 - - - - - - - - 42-420-54-00-5498 PAYING AGENT FEES 475 475 475 475 475 475 475 - - 2014B Refunding Bond 42-420-79-00-8000 PRINCIPAL PAYMENT 275,000 285,000 290,000 290,000 295,000 310,000 320,000 - - 42-420-79-00-8050 INTEREST PAYMENT 44,750 39,250 33,550 33,550 27,750 18,900 9,600 - - Expenditures 321,275 324,725 324,025 324,025 323,225 329,375 330,075 - - Surplus(Deficit) - - - - - - - - - Fund Balance - - - - - - - - - 31 Water Fund (51) The Water Fund is an enterprise fund which is comprised of both a capital and operational budget.The capital portion is used for the improvement and expansion of water infrastructure,while the operational side is used to service and maintain City water systems. FY 2020 FY 2021 FY 2018 FY 2019 Adopted FY 2020 Adopted FY 2022 FY 2023 FY 2024 FY 2025 Actual Actual Budget Projected Budget Projected Projected Projected Projected Revenue Licenses&Permits 165,755 27,465 - - - - - - - Charges for Service 4,489,995 4,529,887 4,401,300 4,337,650 4,350,250 4,518,263 4,694,427 4,879,148 5,072,855 Investment Earnings 11,727 19,100 23,851 31,193 22,557 16,125 14,255 32,108 52,693 Reimbursements 388 15,659 - 3,000 - - - - - Miscellaneous 61,221 62,943 95,999 97,881 100,260 101,000 102,457 104,129 105,845 Other Financing Sources 139,116 142,707 178,781 179,681 179,020 180,233 177,859 178,752 173,559 Total Revenue 4,868,202 4,797,761 4,699,931 4,649,405 4,652,087 4,815,621 4,988,998 5,194,137 5,404,952 Expenses Salaries 412,773 392,273 519,935 418,000 509,530 513,256 527,394 541,956 556,955 Benefits 246,029 202,514 263,064 212,184 241,168 254,232 270,127 286,918 303,453 Contractual Services 872,119 805,723 813,799 871,820 1,078,983 988,055 969,150 984,724 1,000,941 Supplies 327,921 332,310 393,281 370,300 359,273 363,342 373,949 385,087 396,782 Capital Outlay 889,684 583,333 1,428,146 945,470 1,333,243 1,399,243 1,532,905 1,070,000 1,048,000 Debt Service 1,343,250 1,532,844 2,361,500 2,361,500 2,305,935 1,815,830 1,654,108 714,373 702,673 Other Financing Uses 1,018,308 - - - - - - - - Total Expenses 5,110,084 3,848,997 5,779,725 5,179,274 5,828,132 5,333,958 5,327,633 3,983,058 4,008,804 Surplus(Deficit) (241,882) 948,764 (1,079,794) (529,869) (1,176,045) (518,337) (338,635) 1,211,079 1,396,148 Ending Fund Balance Equivalent 2,584,259 3,533,027 1,952,155 3,003,158 1,827,113 1,308,776 970,141 2,181,220 3,577,368 50.57% 91.79% 33.78% 57.98% 31.35% 24.54% 18.21% 54.76% 89.24% ,,, $4,000 Fund Balance Equivalent _ N o $2,000 L F $0 32 FY 2018 FY 2019 FY 2020 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 Account Number Description Actual Actual Adopted Projected Adopted Projected Projected Projected Projected Water-51 51-000-42-00-4216 BUILD PROGRAM PERMITS 165,755 27,465 - - - - - - - 51-000-44-00.4424 WATER SALES 3,094,564 3,117,978 3,228,300 2,980,000 3,129,000 3,285,450 3,449,723 3,622,209 3,803,319 51-000-44-00-4425 BULK WATER SALES 4,250 550 5,000 12,650 5,000 5,000 5,000 5,000 5,000 51-000-44-00-4426 LATE PENALTIES-WATER 116,805 111,720 110,000 125,000 131,250 137,813 144,704 151,939 159,536 51-000-44-00-4430 WATER METER SALES 127,345 157,475 60,000 125,000 60,000 60,000 60,000 60,000 60,000 51-000-44-00-4440 WATER INFRASTRUCTURE FEE 749,613 775,984 768,000 795,000 795,000 800,000 805,000 810,000 815,000 51-000-44-00-4450 WATER CONNECTION FEES 397,418 366,180 230,000 300,000 230,000 230,000 230,000 230,000 230,000 51-000-45-00-4500 INVESTMENT EARNINGS 10,296 19,100 23,851 24,500 22,557 16,125 14,255 32,108 52,693 51-000-45-00-4550 GAIN ON INVESTMENT 1,431 - - 6,693 - - - - - 51-000-46-00-4690 REIMB-MISCELLANEOUS 388 15,659 - 3,000 - - - - - 51-000-48-00-4820 RENTAL INCOME 61,082 61,798 95,749 97,500 100,010 100,750 102,207 103,879 105,595 51-000-48-00-4850 MISCELLANEOUS INCOME 139 1,145 250 381 250 250 250 250 250 51-000-49-00-4910 SALE OF CAPITAL ASSETS - - - 900 - - - - - 51-000-49-00-4923 TRANSFER FROM CITY-WIDE CAPITAL 65,241 65,032 104,906 104,906 103,895 104,558 104,209 104,627 104,034 51-000-49-00-4952 TRANSFER FROM SEWER 73,875 77,675 73,875 73,875 75,125 75,675 73,650 74,125 69,525 Revenue 4,868,202 4,797,761 4,699,931 4,649,405 4,652,087 4,815,621 4,988,998 5,194,137 5,404,952 Water Operations 51-510-50-00-5010 SALARIES&WAGES 394,263 375,615 477,935 395,000 457,530 471,256 485,394 499,956 514,955 51-510-50-00-5015 PART-TIME SALARIES 11,532 5,328 30,000 11,000 30,000 30,000 30,000 30,000 30,000 51-510-50-00-5020 OVERTIME 6,978 11,330 12,000 12,000 22,000 12,000 12,000 12,000 12,000 51-510-52-00-5212 RETIREMENT PLAN CONTRIBUTION 42,915 39,059 44,948 45,000 54,251 55,333 58,394 61,435 63,235 51-510-52-00-5214 FICA CONTRIBUTION 30,192 28,530 37,702 32,000 37,576 38,703 39,864 41,060 42,292 51-510.52-00-5216 GROUP HEALTH INSURANCE 134,779 97,544 137,566 96,530 107,430 116,024 125,306 135,330 146,156 51-510-52-00-5222 GROUP LIFE INSURANCE 705 458 560 489 543 548 553 559 565 51-510-52-00-5223 DENTAL INSURANCE 8,808 7,033 9,354 6,985 7,278 7,642 8,024 8,425 8,846 51-510-52-00-5224 VISION INSURANCE 1,218 1,034 1,344 1,034 1,129 1,163 1,198 1,234 1,271 51-510-52-00-5230 UNEMPLOYMENT INSURANCE 671 1,559 2,000 2,000 2,000 2,000 2,000 2,000 2,000 51-510.52-00-5231 LIABILITY INSURANCE 26,741 27,297 29,590 28,146 30,961 32,819 34,788 36,875 39,088 51-510-54-00-5401 ADMINISTRATIVE CHARGEBACK 108,154 111,629 118,631 118,631 124,225 127,952 131,791 135,745 139,817 51-510-54-00-5405 BUILD PROGRAM 165,755 27,465 - - - - - - - 51-510-54-00-5412 TRAINING&CONFERENCES 2,515 2,251 6,500 6,500 9,200 8,200 8,200 8,200 8,200 51-510-54-00-5415 TRAVEL&LODGING 732 1,278 2,000 2,000 4,000 3,000 3,000 3,000 3,000 51-510-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK - 316 10,408 10,408 - - 11,797 - - PUBLISHING&ADVERTISING 932 1,359 500 500 500 500 500 500 500 51-510-54-00-5429 WATER SAMPLES 5,894 5,192 8,000 8,000 8,000 8,000 10,000 8,000 8,000 51-510-54-00-5430 PRINTING&DUPLICATING 2,814 2,698 3,250 3,250 3,250 3,250 3,250 3,250 3,250 51-510-54-00-5440 TELECOMMUNICATIONS 33,832 32,084 35,000 40,000 40,000 40,000 40,000 40,000 40,000 51-510-54-00-5445 TREATMENT FACILITY SERVICES 136,286 179,222 145,000 200,000 255,000 230,000 230,000 210,000 200,000 51-510-54-00-5448 FILING FEES 1,901 2,696 3,000 3,000 3,000 3,000 3,000 3,000 3,000 33 FY 2018 FY 2019 FY 2020 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 Account Number Description Actual Actual Adopted Projected Adopted Projected Projected Projected Projected 51-510-54-00-5452 POSTAGE&SHIPPING 17,723 15,815 19,000 19,000 19,000 19,000 19,000 19,000 19,000 51-510-54-00-5460 DUES&SUBSCRIPTIONS 1,169 478 1,800 1,800 2,500 2,500 2,500 2,500 2,500 51-510-54-00-5462 PROFESSIONAL SERVICES 36,863 96,790 65,000 85,000 155,000 148,750 92,500 92,500 92,500 51-510-54-00-5465 ENGINEERING SERVICES 39,975 17,271 37,500 28,000 85,000 5,000 5,000 30,000 30,000 51-510-54-00-5480 UTILITIES 279,411 284,677 303,709 292,000 309,520 328,091 347,776 368,643 390,762 51-510-54-00-5483 JULIE SERVICES 5,954 2,190 3,000 3,000 3,000 3,000 3,000 3,000 3,000 51-510-54-00-5485 RENTAL&LEASE PURCHASE 929 1,040 1,700 1,700 1,700 1,700 1,700 1,700 1,700 51-510-54-00-5488 OFFICE CLEANING 1,164 1,020 1,051 731 788 812 836 861 887 51-510-54-00-5490 VEHICLE MAINTENANCE SERVICES 5,930 12,403 12,000 12,000 12,000 12,000 12,000 12,000 12,000 51-510-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 15,023 2,421 25,000 25,000 32,000 32,000 32,000 32,000 32,000 51-510-54-00-5498 PAYING AGENT FEES 1,888 1,888 1,750 1,300 1,300 1,300 1,300 825 825 51-510-54-00-5499 BAD DEBT 7,275 3,540 10,000 10,000 10,000 10,000 10,000 10,000 10,000 51-510-56-00-5600 WEARING APPAREL 6,837 2,026 5,100 5,100 5,000 5,000 5,000 5,000 5,000 51-510-56-00-5620 OPERATING SUPPLIES 3,366 5,793 10,500 10,500 16,000 11,000 11,000 11,000 11,000 51-510-56-00-5628 VEHICLE MAINTENANCE SUPPLIES 2,416 1,547 2,500 2,500 2,500 2,500 2,500 2,500 2,500 51-510-56-00-5630 SMALL TOOLS&EQUIPMENT 1,365 583 4,000 4,000 4,000 4,000 4,000 4,000 4,000 51-510.56-00-5638 TREATMENT FACILITY SUPPLIES 159,093 158,763 218,438 170,000 178,500 187,425 196,796 206,636 216,968 51-510-56-00-5640 REPAIR&MAINTENANCE 15,183 5,942 27,500 27,500 27,500 27,500 27,500 27,500 27,500 51-510-56-00-5664 METERS&PARTS 117,151 136,571 100,000 127,500 100,000 100,000 100,000 100,000 100,000 51-510-56-00-5665 JULIE SUPPLIES 693 380 1,200 1,200 2,233 1,200 1,200 1,200 1,200 51-510-56-00-5695 GASOLINE 21,817 20,705 24,043 22,000 23,540 24,717 25,953 27,251 28,614 51-510-60-00-6011 PROPERTY ACQUISITION - - - - - - - 200,000 200,000 51-510-60-00-6015 WATER TOWER PAINTING - - - - 18,000 495,000 477,000 - - 51-510-60-00-6022 WELL REHABILITATIONS 264,985 119,204 165,000 7,796 - 176,000 187,000 - - 51-510-60-00-6025 ROAD TO BETTER ROADS PROGRAM 272,423 15,564 569,000 635,000 634,000 483,000 548,000 863,000 841,000 51-510-60-00-6034 WHISPERING MEADOWS SUBDIVISION 115 42,560 - 750 - - - - - 51-510-60-00-6059 US 34(IL 47/ORCHARD RD)PROJECT 26,676 14,939 21,608 17,000 7,700 - - -51-510-60-00-6060 EQUIPMENT 8,825 - 400,000 77,386 500,300 7,000 7,000 7,000 7,000 51-510-60-00-6066 RTE71 WATERMAIN REPLACEMENT 44,904 288,136 42,166 42,166 12,871 12,871 - - - 51-510-60-00-6070 VEHICLES - 44,877 - - 90,000 - 100,000 - - 51-510-60-00-6079 ROUTE 47 EXPANSION 197,544 58,053 45,372 45,372 45,372 45,372 18,905 - - 51-510-60.00-6081 CATION EXCHANGE MEDIA REPLACEMENT - - 185,000 120,000 25,000 180,000 195,000 - - 51-510-60-00-6082 COUNTRYSIDE PKY IMPROVEMENTS 74,212 - - - - - - - - 2015A Bond 51-510-77-00-8000 PRINCIPAL PAYMENT 113,991 117,668 290,483 290,483 297,837 312,545 323,576 338,284 349,315 51-510-77-00-8050 INTEREST PAYMENT 161,055 156,496 151,787 151,787 140,167 128,254 115,752 102,809 89,278 Debt Service-2016 Refunding Bond 51-510-85-00-8000 PRINCIPAL PAYMENT 430,000 470,000 1,470,000 1,470,000 1,475,000 1,040,000 915,000 - - 51-510.85-00-8050 INTEREST PAYMENT 248,124 195,250 176,450 176,450 117,650 58,650 27,450 - - 34 FY 2018 FY 2019 FY 2020 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 Account Number Description Actual Actual Adopted Projected Adopted Projected Projected Projected Projected Debt Service-2003 Debt Certificates 51-510-86-00-8000 PRINCIPAL PAYMENT 100,000 300,000 - - - - - - - 51-510-86-00-8050 INTEREST EXPENSE 17,300 13,050 - - - - - - - Debt Service-IEPA Loan L17-156300 51-510-89-00-8000 PRINCIPAL PAYMENT 99,361 101,860 104,423 104,423 107,050 109,743 112,503 115,333 118,235 51-510-89-00-8050 INTEREST EXPENSE 25,669 23,170 20,607 20,607 17,981 15,288 12,527 9,697 6,795 Debt Service-2014C Refunding Bond 51-510-94-00-8000 PRINCIPAL PAYMENT 120,000 130,000 125,000 125,000 130,000 135,000 135,000 140,000 135,000 51-510-94-00-8050 INTEREST PAYMENT 27,750 25,350 22,750 22,750 20,250 16,350 12,300 8,250 4,050 51-510-99-00-9923 TRANSFER TO CITY-WIDE CAPITAL 1,018,308 - - - - - - - - Expenses 5,110,084 3,848,997 5,779,725 5,179,274 5,828,132 5,333,958 5,327,633 3,983,058 4,008,804 Surplus(Deficit) (241,882) 948,764 (1,079,794) (529,869) (1,176,045) (518,337) (338,635) 1,211,079 1,396,148 Fund Balance Equiv 2,584,259 3,533,027 1,952,155 3,003,158 1,827,113 1,308,776 970,141 2,181,220 3,577,368 50.57% 91.79% 33.78% 57.98% 31.35% 24.54% 18.21% 54.76% 89.24% 35 Sewer Fund(52) The Sewer Fund is an enterprise fund which is comprised of both a capital and operational budget. The capital portion is used for improvement and expansion of the sanitary sewer infrastructure while the operational side allows the City to service and maintain sanitary sewer systems. FY 2020 FY 2021 FY 2018 FY 2019 Adopted FY 2020 Adopted FY 2022 FY 2023 FY 2024 FY 2025 Actual Actual Budget Projected Budget Projected Projected Projected Projected Revenue Licenses&Permits 93,000 18,000 - - - - - - - Charges for Service 1,595,338 1,534,159 1,567,500 1,615,600 1,635,650 1,671,396 1,708,064 1,745,682 1,784,278 Investment Earnings 24,274 9,679 7,149 39,959 7,473 7,419 11,872 19,659 24,853 Reimbursements 54 4,885 - 3,961 - - - - - Other Financing Sources 1,137,166 856,583 575,030 575,030 174,744 586,749 994,479 1,134,606 1,136,806 Total Revenue 2,849,832 2,423,306 2,149,679 2,234,550 1,817,867 2,265,564 2,714,415 2,899,947 2,945,937 Expenses Salaries 224,215 192,724 270,946 205,940 256,061 263,578 271,320 279,295 287,509 Benefits 111,531 96,011 164,060 122,580 147,784 157,043 167,348 178,276 189,225 Contractual Services 221,111 145,994 240,935 182,007 234,167 181,611 182,299 176,336 179,530 Supplies 45,902 60,342 62,650 62,650 68,256 65,925 67,187 68,512 69,904 Capital Outlay 228,179 235,161 350,861 238,438 204,361 223,711 449,370 460,000 660,000 Developer Commitments 34,888 35,938 30,721 31,500 - - - - - Debt Service 1,877,110 1,880,265 1,352,307 1,352,307 1,300,798 1,300,780 1,299,024 1,134,606 1,136,806 Other Financing Uses 73,875 77,675 73,875 73,875 75,125 75,675 73,650 74,125 69,525 Total Expenses 2,816,811 2,724,110 2,546,355 2,269,297 2,286,552 2,268,323 2,510,198 2,371,150 2,592,499 Surplus(Deficit) 33,021 (300,804) (396,676) (34,747) (468,685) (2,759) 204,217 528,797 353,438 Ending Fund Balance Equivalent 1,411,053 1,110,251 705,765 1,075,504 606,819 604,060 808,277 1,337,074 1,690,512 50.09% 40.76% 27.72% 47.39% 26.54% 26.63% 32.20% 56.39% 65.21% $2,000 Fund Balance Equivalent N $1,500 t $1,000 r $500 - $0 36 FY 2018 FY 2019 FY 2020 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 Account Number Description Actual Actual Adopted Projected Adopted Projected Projected Projected Projected Sewer-52 52-000-42-00-4216 BUILD PROGRAM PERMITS 93,000 18,000 - - - - - - - 52-000-44-00-4435 SEWER MAINTENANCE FEES 910,828 970,506 979,200 995,000 1,024,850 1,055,596 1,087,264 1,119,882 1,153,478 52-000-44-00-4440 SEWER INFRASTRUCTURE FEE 363,038 375,560 370,000 385,000 390,000 395,000 400,000 405,000 410,000 52-000-44-00-4455 SW CONNECTION FEES-OPERATIONS 105,005 89,378 23,300 72,500 23,300 23,300 23,300 23,300 23,300 52-000-44-00-4456 SW CONNECTION FEES-CAPITAL 198,700 82,800 180,000 145,000 180,000 180,000 180,000 180,000 180,000 52-000-44-00-4462 LATE PENALTIES-SEWER 15,057 15,537 15,000 17,500 17,500 17,500 17,500 17,500 17,500 52-000-44-00-4465 RIVER CROSSING FEES 2,710 378 - 600 - - - - - 52-000-45-00-4500 INVESTMENT EARNINGS 17,550 9,679 7,149 8,500 7,473 7,419 11,872 19,659 24,853 52-000-45-00-4550 GAIN ON INVESTMENT 6,724 - - 31,459 - - - - - 52-000-46-00-4690 REIMB-MISCELLANEOUS 54 4,885 - 3,961 - - - - - 52-000-49-00-4901 TRANSFER FROM GENERAL 1,137,166 856,583 575,030 575,030 174,744 586,749 994,479 1,134,606 1,136,806 Revenue 2,849,832 2,423,306 2,149,679 2,234,550 1,817,867 2,265,564 2,714,415 2,899,947 2,945,937 Sewer Operations 52-520-50-00-5010 SALARIES&WAGES 223,926 192,436 265,446 200,000 250,561 258,078 265,820 273,795 282,009 52-520-50-00-5015 PART-11ME SALARIES - 112 5,000 5,440 5,000 5,000 5,000 5,000 5,000 52-520-50-00-5020 OVERTIME 289 176 500 500 500 500 500 500 500 52-520-52-00-5212 RETIREMENT PLAN CONTRIBUTION 24,177 19,737 24,399 21,000 28,403 29,607 31,266 32,915 33,901 52-520-52-00-5214 FICA CONTRIBUTION 16,847 14,273 19,031 16,000 18,509 19,064 19,636 20,225 20,832 52-520-52-00-5216 GROUP HEALTH INSURANCE 51,511 43,862 98,202 65,544 79,026 85,348 92,176 99,550 107,514 52-520-52-00-5222 GROUP LIFE INSURANCE 371 212 314 336 314 317 320 323 326 52-520-52-00-5223 DENTAL INSURANCE 4,239 3,367 6,433 4,644 5,021 5,272 5,536 5,813 6,104 52-520-52-00-5224 VISION INSURANCE 594 493 879 647 736 758 781 804 828 52-520-52-00-5230 UNEMPLOYMENT INSURANCE 353 820 750 750 750 750 750 750 750 52-520-52-00-5231 LIABILITY INSURANCE 13,439 13,247 14,052 13,659 15,025 15,927 16,883 17,896 18,970 52-520-54-00-5401 ADMINISTRATIVE CHARGEBACK 38,925 40,176 42,696 42,696 44,709 46,050 47,432 48,855 50,321 52-520-54-00-5405 BUILD PROGRAM 93,000 18,000 - - - - - - - 52-520-54-00-5412 TRAINING&CONFERENCES 1,180 277 2,500 2,500 3,500 3,400 3,400 3,400 3,400 52-520-54-00-5415 TRAVEL&LODGING 344 1,308 2,000 2,000 3,000 3,000 3,000 3,000 3,000 52-520-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK - 316 8,258 8,258 - - 9,017 - - 52-520.54-00-5430 PRINTING&DUPLICATING 1,307 1,286 1,500 1,500 1,500 1,500 1,500 1,500 1,500 52-520-54-00-5440 TELECOMMUNICATIONS 8,667 8,307 9,000 9,000 13,500 13,500 13,500 13,500 13,500 52-520-54-00-5444 LIFT STATION SERVICES 20,727 14,783 75,000 26,000 64,000 20,000 20,000 20,000 20,000 52-520-54-00-5462 PROFESSIONAL SERVICES 14,638 18,260 43,000 33,000 45,500 34,250 23,000 23,000 23,000 52-520-54-00-5480 UTILITIES 20,081 13,748 22,472 22,472 23,820 25,249 26,764 28,370 30,072 52-520-54-00-5483 JULIE SERVICES - 2,190 3,000 3,000 3,000 3,000 3,000 3,000 3,000 52-520-54-00-5485 RENTAL&LEASE PURCHASE 662 1,031 1,000 1,100 1,100 1,100 1,100 1,100 1,100 52-520-54-00-5488 OFFICE CLEANING 729 737 759 731 788 812 836 861 887 52-520-54-00-5490 VEHICLE MAINTENANCE SERVICES 1,643 12,605 10,000 10,000 10,000 10,000 10,000 10,000 10,000 52-520-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 15,072 11,030 16,000 16,000 16,000 16,000 16,000 16,000 16,000 37 FY 2018 FY 2019 FY 2020 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2020 Account Number Description Actual Actual Adopted Projected Adopted Projected Projected Projected Projected 52-520-54-00-5498 PAYING AGENT FEES 1,277 689 750 750 750 750 750 750 750 52-520-54-00-5499 BAD DEBT 2,859 1,251 3,000 3,000 3,000 3,000 3,000 3,000 3,000 52-520-56-00-5600 WEARING APPAREL 3,965 2,289 3,980 3,980 3,980 3,980 3,980 3,980 3,980 52-520-56-00-5610 OFFICE SUPPLIES 1,029 870 1,000 1,000 1,000 1,000 I,000 1,000 1,000 52-520-56-00-5613 LIFT STATION MAINTENANCE 8,006 19,361 8,000 8,000 8,000 8,000 8,000 8,000 8,000 52-520-56-00-5620 OPERATING SUPPLIES 4,516 5,332 9,000 9,000 12,000 9,500 9,500 9,500 9,500 52-520-56-00-5628 VEHICLE MAINTENANCE SUPPLIES 5,356 8,968 10,000 10,000 10,000 10,000 10,000 10,000 10,000 52-520-56-00-5630 SMALL TOOLS&EQUIPMENT 711 775 2,000 2,000 2,000 2,000 2,000 2,000 2,000 52-520-56-00-5640 REPAIR&MAINTENANCE 2,243 2,497 5,000 5,000 5,000 5,000 5,000 5,000 5,000 52-520-56-00-5665 JULIE SUPPLIES - 380 1,200 1,200 2,233 1,200 1,200 1,200 1,200 52-520-56-00-5695 GASOLINE 20,076 19,870 22,470 22,470 24,043 25,245 26,507 27,832 29,224 52-520-60-00-6001 SCADA SYSTEM - - 67,000 45,000 67,000 67,000 - - - 52-520-60-00.6025 ROAD TO BETTER ROADS PROGRAM 160,219 134,529 137,000 62,000 - - 440,000 460,000 660,000 52-520-60-00-6034 WHISPERING MEADOWS SUBDIVISION 172 73,554 - 300 - _ _ _ - 52-520-60-00-6059 US 34(IL 47/ORCHARD RD)PROJECT 4,213 978 11,373 650 650 - _ - - 52-520-60-00-6060 EQUIPMENT - - - - 80,000 - _ - _ 52-520-60-00-6066 RTE 71 SANITARY SEWER REPLACEMENT 4,560 574 63,000 63,000 34,223 34,223 - - - 52-520-60.00.6070 VEHICLES - - 50,000 45,000 - 100,000 _ _ - 52-520-60-00-6079 ROUTE 47 EXPANSION 59,015 25,526 22,488 22,488 22,488 22,488 9,370 - - 52-520-75-00-7500 LENNAR-RAINTREE SEWER RECAPTURE 34,888 35,938 30,721 31,500 - _ _ - _ Debt Service-2004B Bond 52-520-84-00-8000 PRINCIPAL PAYMENT 435,000 455,000 - - - _ _ - _ 52-520-84-00-8050 INTEREST EXPENSE 35,600 18,200 - - - _ _ - - Debt Service-2003A IRBB Debt Certificates 52-520-90-00-8000 PRINCIPAL PAYMENT 120,000 130,000 135,000 135,000 140,000 150,000 155,000 - - 52-520-90-00-8050 INTEREST EXPENSE 42,293 36,233 29,668 29,668 22,850 15,710 8,060 - - Debt Service-2011 Refunding Bond 52-520-92-00-8000 PRINCIPAL PAYMENT 780,000 810,000 845,000 845,000 885,000 920,000 960,000 1,000,000 1,045,000 52-520-92-00-8050 INTEREST EXPENSE 357,166 323,782 289,114 289,114 252,948 215,070 175,964 134,606 91,806 Debt Service-IEPA Loan L17-115300 52-520-96-00-8000 PRINCIPAL PAYMENT 100,952 103,619 52,832 52,832 - _ - - - 52-520-96-00-8050 INTEREST EXPENSE 6,099 3,431 693 693 - _ - - - 52-520-99-00-9951 TRANSFER TO WATER 73,875 77,675 73,875 73,875 75,125 75,675 73,650 74,125 69,525 Expenses 2,816,811 2,724,110 2,546,355 2,269,297 2,286,552 2,268,323 2,510,198 2,371,150 2,592,499 Surplus(Deficit) 33,021 (300,804) (396,676) (34,747) (468,685) (2,759) 204,217 528,797 353,438 Fund Balance Fquiv 1,411,053 1,110,251 705,765 1,075,504 606,819 604,060 808,277 1,337,074 1,690,512 50.09% 40.76% 27.72% 47.39% 26.54% 26.63% 32.20% 56.39% 65.21% 38 Land Cash Fund (72) Land-Cash funds are dedicated by developers through the contribution ordinance to serve the immediate and future needs of park and recreation of residents in new subdivisions.Land for park development and cash spent on recreational facilities is often matched through grant funding to meet the community's recreation needs at a lower cost to the City. FY 2020 FY 2021 FY 2018 FY 2019 Adopted FY 2020 Adopted FY 2022 FY 2023 FY 2024 FY 2025 Actual Actual Budget Projected Budget Projected Projected Projected Projected Revenue Intergovernmental - 702,474 - - - - - - - Licenses&Permits 1,505 - - - - - - - - Reimbursements 5,701 - - - - - - - - Land Cash Contributions 125,491 161,691 58,435 38,876 33,858 25,760 24,354 5,454 5,454 Miscellaneous - 3,426 - - - - - - - Other Financing Sources 2,503 - - - - - - - - Total Revenue 135,200 867,591 58,435 38,876 33,858 25,760 24,354 5,454 5,454 Expenditures Contractual Services 1,505 4,795 4,850 5,035 5,287 5,551 5,829 6,120 6,426 Capital Outlay 662,215 372,760 100,000 - 235,000 74,000 - - - Total Expenditures 663,720 377,555 104,850 5,035 240,287 79,551 5,829 6,120 6,426 Surplus(Deficit) (528,520) 490,036 (46,415) 33,841 (206,429) (53,791) 18,525 (666) (972) Ending Fund Balance (278,204) 211,832 62,362 245,673 39,244 (14,547) 3,978 3,312 2,340 Fund Balance N $400 S $200 3 ($200) - ($400) - i 39 FY 2018 FY 2019 FY 2020 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 Account Number Description Actual Actual Adopted Projected Adopted Projected Projected Projected Projected band('ash-72 72-000-41-00-4175 OSLAD GRANT-RIVERFRONT PARK - 312,671 - - - - - - - 72-000.41-00-4186 OSLAD GRANT-BRISTOL BAY - 389,803 - - - - - - - 72-000-42-00-4216 BUILD PROGRAM PERMITS 1,505 - - - - - - - - 72-000-46-00-4655 REIMB-GRANDE RESERVE PARK 5,701 - - - - - - - - 72-000-47-00-4701 WHITE OAK - - - 1,406 1,406 1,406 - - - 72-000-47-00-4702 WHISPERING MEADOWS - - - - 4,699 4,699 4,699 - - 72-000-47-00-4703 AUTUMN CREEK - 3,003 6,606 6,006 - - - - - 72-000-47-00-4704 BLACKBERRY WOODS 17,614 10,795 15,909 568 1,932 1,932 1,932 1,932 1,932 72-000-47-00-4706 CALEDONIA 39,261 32,214 16,341 16,341 4,698 4,698 4,698 - - 72-000-47-00-4707 RIVER'S EDGE 671 - - - 671 - - - - 72-000.47-00-4708 COUNTRY HILLS 6,152 769 8,000 4,000 4,358 4,358 4,358 - - 72-000-47-00-4709 SALEK 3,213 - - - - - - - - 72-000-47-00-4711 FOX HIGHLANDS - - - - 3,298 - - - - 72-000-47-00-4722 GC HOUSING(ANTHONY'S PLACE) - 97,162 - - - - - - - 72-000-47-00-4723 WINDETT RIDGE 50,000 10,000 - - - - - - - 72-000-47-00-4724 KENDALL MARKETPLACE 162 1,133 2,024 1,000 2,752 - - - - 72-000-47-00-4725 HEARTLAND MEADOWS - - - - 3,522 3,522 3,522 3,522 3,522 72-000-47-00-4726 KENDALLWOOD ESTATES - - - - - - - - - 72-000-47-00-4727 CIMARRON RIDGE - - - - 1,377 - - - - 72-000-47-00-4736 BRIARWOOD 8,418 6,615 9,555 9,555 5,145 5,145 5,145 - - 72-000-48-00-4850 MISCELLANEOUS INCOME - 3,426 - - - - - - - 72-000-49-00-4910 SALE OF CAPITAL ASSETS 2,503 - - - - - - - - Revenue 135,200 867,591 58,435 38,876 33,858 25,760 24,354 5,454 5,454 72-720-54-00-5405 BUILD PROGRAM 1,505 - - - - - - - - 72-720-54-00-5485 RENTAL&LEASE PURCHASE - 4,795 4,850 5,035 5,287 5,551 5,829 6,120 6,426 72-720-60-00-6010 PARK IMPROVEMENTS - 267,479 - - - - - - - 72-720-60-00-6013 BEECHER CENTER PARK - - - - 95,000 - - - - 72-720-60-00-6014 BLACKBERRY WOODS - - - - - - - - - 72-720-60-00-6029 CALEDONIA PARK - - - - 85,000 - - - - 72-720-60-00-6040 PRESTWICK - - - - - 74,000 - - - 72-720-60-00-6043 BRISTOL BAY REGIONAL PARK 384,922 6,483 - - - - - - - 72-720-60-00-6045 RIVERFRONT PARK 276,616 41,228 - - - - - - - 72-720-60-00-6046 GRANDE RESERVE PARK 677 - 25,000 - - - - - - 72-720-60-00-6047 AUTUMN CREEK - - 50,000 - 50,000 - - - - 72-720-60-00-6049 RAINTREE PARK C - - 25,000 - - - - - - 40 FY 2018 FY 2019 FY 2020 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2020 Account Number Description Actual Actual Adopted Projected Adopted Projected Projected Projected Projected 72-720-60-00-6067 BLACKBERRY CREEK NATURE PRESERVE - - - - 5,000 - - - - 72-720-60-00-6069 WINDETT RIDGE PARK - 57,570 - - - - - _ Expenditures 663,720 377,555 104,800 0,030 240,287 79,551 5,829 6,120 6,426 Surplus(Deficit) (528,520) 490,036 (46,415) 33,841 (206,429) (53,791) 18,525 (666) (972) Fund Balance (278,204) 211,832 62,362 245,673 39,244 (14,547) 3,978 3,312 2,340 41 Parks and Recreation Fund(79) This fund accounts for the daily operations of the Parks and Recreation Department. Programs,classes,special events and maintenance of City wide park land and public facilities make up the day to day operations. Programs and classes consist of a wide variety of options serving children through senior citizens. Special events range from Music Under the Stars to Home Town Days. City wide maintenance consists of over two hundred acres at more than fifty sites including buildings,boulevards,parks,utility locations and natural areas. FY 2020 FY 2021 FY 2018 FY 2019 Adopted FY 2020 Adopted FY 2022 FY 2023 FY 2024 FY 2025 Actual Actual Budget Projected Budget Projected Projected Projected Projected Revenue Intergovernmental - 81,815 - - - - - - - Charges for Service 453,466 579,155 632,000 640,000 650,000 650,000 650,000 650,000 650,000 Investment Earnings 800 1,534 1,500 1,300 1,300 1,300 1,300 1,300 1,300 Reimbursements 174 23,137 - 14,000 - - - - - Miscellaneous 234,784 208,720 200,500 227,178 226,716 228,709 230,781 232,936 235,178 Other Financing Sources 1,308,583 1,274,699 1,410,988 1,410,988 1,309,284 1,715,430 1,795,476 1,851,460 1,918,499 Total Revenue 1,997,807 2,169,060 2,244,988 2,293,466 2,187,300 2,595,439 2,677,557 2,735,696 2,804,977 Expenditures Salaries 868,189 972,011 1,103,861 1,100,859 1,172,012 1,203,697 1,236,273 1,269,766 1,304,204 Benefits 390,010 393,482 448,232 445,759 485,000 506,380 538,887 573,269 607,079 Contractual Services 320,383 355,673 309,358 320,973 392,565 375,032 390,612 379,347 378,775 Supplies 391,250 468,833 487,630 509,327 507,185 510,330 511,785 513,314 514,919 Total Expenditures 1,969,832 2,189,999 2,349,081 2,376,918 2,556,762 2,595,439 2,677,557 2,735,696 2,804,977 Surplus(Deficit) 27,975 (20,939) (104,093) (83,452) (369,462) - - - - Ending Fund Balance 473,852 452,914 312,946 369,462 - - - - - 24.06% 20.68% 13.32% /5.54% 0.00% 0.00% 0.00% 0.00% 0.00% v, $600 Fund Balance Fg $400 - F $200 $0 ♦ -, 42 FY 2018 FY 2019 FY 2020 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 Account Number Description Actual Actual Adopted Projected Adopted Projected Projected Projected Projected Parks and Recreation-79 79-000-41-00-4175 OSLAD GRANT-RIVERFRONT PARK - 81,815 - - - - - - - 79-000-44-00-4402 SPECIAL EVENTS 87,666 88,828 90,000 90,000 90,000 90,000 90,000 90,000 90,000 79-000-44-00-4403 CHILD DEVELOPMENT 141,046 143,949 145,000 135,000 145,000 145,000 145,000 145,000 145,000 79-000-44-00-4404 ATHLETICS&FITNESS 187,611 318,981 365,000 370,000 370,000 370,000 370,000 370,000 370,000 79-000-44-00-4441 CONCESSION REVENUE 37,143 27,397 32,000 45,000 45,000 45,000 45,000 45,000 45,000 79-000-45-00-4500 INVESTMENT EARNINGS 800 1,534 1,500 1,300 1,300 1,300 1,300 1,300 1,300 79-000-46-00-4690 REIMB-MISCELLANEOUS 174 23,137 - 14,000 - - - - - 79-000-48-00-4820 RENTAL INCOME 54,701 53,208 54,500 59,900 64,216 66,209 68,281 70,436 72,678 79-000-48-00-4825 PARK RENTALS 20,200 15,714 15,000 20,000 17,500 17,500 17,500 17,500 17,500 79-000-48-00-4843 HOMETOWN DAYS 128,156 118,141 108,000 124,278 120,000 120,000 120,000 120,000 120,000 79-000-48-00-4846 SPONSORSHIPS&DONATIONS 19,753 14,577 20,000 18,000 20,000 20,000 20,000 20,000 20,000 79-000-48-00-4850 MISCELLANEOUS INCOME 11,974 7,080 3,000 5,000 5,000 5,000 5,000 5,000 5,000 79-000-49-00-4901 TRANSFER FROM GENERAL 1,308,583 1,274,699 1,410,988 1,410,988 1,309,284 1,715,430 1,795,476 1,851,460 1,918,499 Revenue 1,997,807 2,169,060 2,244,988 2,293,466 2,187,300 2,595,439 2,677,557 2,735,696 2,804,977 Parks Department 79-790-50-00-5010 SALARIES&WAGES 459,025 485,017 552,859 552,859 601,936 619,994 638,594 657,752 677,485 79-790-50-00-5015 PART-TIME SALARIES 37,282 49,603 51,000 58,000 59,000 60,000 61,000 62,000 63,000 79-790-50-00-5020 OVERTIME 2,533 4,283 5,000 5,000 5,000 5,000 5,000 5,000 5,000 79-790-52-00-5212 RETIREMENT PLAN CONTRIBUTION 51,254 51,004 52,725 56,500 70,570 71,562 75,558 79,530 81,898 79-790-52-00-5214 FICA CONTRIBUTION 36,883 39,628 44,715 45,500 48,830 50,295 51,804 53,358 54,959 79-790-52-00-5216 GROUP HEALTH INSURANCE 131,162 130,395 153,747 157,370 155,338 167,765 181,186 195,681 211,335 79-790-52-00-5222 GROUP LIFE INSURANCE 896 570 645 624 645 651 658 665 672 79-790-52-00-5223 DENTAL INSURANCE 9,726 9,509 10,866 10,892 9,708 10,193 10,703 11,238 11,800 79-790-52-00-5224 VISION INSURANCE 1,313 1,354 1,537 1,529 1,537 1,583 1,630 1,679 1,729 79-790-54-00-5412 TRAINING&CONFERENCES 4,186 725 7,000 4,000 7,000 7,000 7,000 7,000 7,000 79-790-54-00-5415 TRAVEL&LODGING 248 1 3,000 - 3,000 3,000 3,000 3,000 3,000 79-790-54-00-5422 VEHICLE&EQUIPMENT CHARGEBACK 70,000 90,000 - - 75,000 50,000 50,000 50,000 50,000 79-790-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK - 5,218 3,262 8,209 875 - 8,209 957 985 79-790-54-00-5440 TELECOMMUNICATIONS 6,348 6,786 6,500 8,000 8,100 8,100 8,100 8,100 8,100 79-790-54-00-5462 PROFESSIONAL SERVICES 3,940 10,105 11,400 7,000 11,400 11,400 11,400 11,400 11,400 79-790-54-00-5466 LEGAL SERVICES 2,634 645 3,000 750 2,000 2,000 2,000 2,000 2,000 79-790-54-00-5485 RENTAL&LEASE PURCHASE 5,818 2,770 2,500 2,500 2,500 2,500 2,500 2,500 2,500 79-790-54-00-5488 OFFICE CLEANING 2,719 2,435 2,876 2,917 3,078 3,170 3,265 3,363 3,464 79-790-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 17,640 42,578 50,000 40,000 33,759 40,000 40,000 40,000 40,000 79-790-56-00-5600 WEARING APPAREL 8,647 4,905 6,220 6,220 6,220 6,220 6,220 6,220 6,220 79-790-56-00-5620 OPERATING SUPPLIES 31,213 40,658 25,000 25,000 25,000 25,000 25,000 25,000 25,000 79-790-56-00-5630 SMALL TOOLS&EQUIPMENT 5,965 5,801 6,000 6,000 6,000 6,000 6,000 6,000 6,000 79-790-56-00-5640 REPAIR&MAINTENANCE 60,544 58,771 71,000 70,000 71,000 71,000 71,000 71,000 71,000 79-790-56-00-5646 ATHLETIC FIELDS&EQUIPMENT 7,803 51,163 55,000 55,000 55,000 55,000 55,000 55,000 55,000 43 FY 2018 FY 2019 FY 2020 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 Account Number Description Actual Actual Adopted Projected Adopted Projected Projected Projected Projected 79-790-56-00-5695 GASOLINE 15,686 21,977 25,410 25,410 27,189 28,548 29,975 31,474 33,048 973,465 1,115,901 1,151,262 1,149,280 1,289,685 1,305,981 1,354,802 1,389,917 1,432,595 Recreation Department 79-795-50-00-5010 SALARIES&WAGES 290,580 338,230 359,002 368,000 387,576 399,203 411,179 423,514 436,219 79-795-50-00-5015 PART-TIME SALARIES 16,602 18,784 41,000 25,000 23,500 24,500 25,500 26,500 27,500 79-795-50-00-5045 CONCESSION WAGES 8,344 8,023 15,000 15,000 15,000 15,000 15,000 15,000 15,000 79-795-50-00-5046 PRE-SCHOOL WAGES 34,468 34,324 40,000 40,000 40,000 40,000 40,000 40,000 40,000 79-795-50-00-5052 INSTRUCTORS WAGES 19,355 33,747 40,000 37,000 40,000 40,000 40,000 40,000 40,000 79-795-52-00-5212 RETIREMENT PLAN CONTRIBUTION 31,208 34,687 37,514 37,514 49,493 45,709 48,272 50,822 52,346 79-795-52-00-5214 FICA CONTRIBUTION 27,561 32,343 36,761 34,000 37,543 38,669 39,829 41,024 42,255 79-795-52-00-5216 GROUP HEALTH INSURANCE 92,497 86,065 101,795 93,832 103,025 111,267 120,168 129,781 140,163 79-795-52-00-5222 GROUP LIFE INSURANCE 407 440 440 475 475 480 485 490 495 79-795-52-00-5223 DENTAL INSURANCE 6,235 6,539 6,539 6,539 6,744 7,081 7,435 7,807 8,197 79-795-52-00-5224 VISION INSURANCE 868 948 948 984 1,092 1,125 1,159 1,194 1,230 79-795-54-00-5410 TUITION REIMBURSEMENT - - 9,648 - - - - - - 79-795-54-00-5412 TRAINING&CONFERENCES 3,295 4,074 5,000 3,750 5,000 5,000 5,000 5,000 5,000 79-795-54-00-5415 TRAVEL&LODGING 542 35 3,000 2,000 3,000 3,000 3,000 3,000 3,000 79-795-54-00-5422 VEHICLE&EQUIPMENT CHARGEBACK - - - - - - - - - 79-795-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK - 3,799 5,888 5,888 875 1,883 8,100 2,870 985 79-795-54-00-5426 PUBLISHING&ADVERTISING 52,825 55,361 55,000 56,000 55,000 55,000 55,000 55,000 55,000 79-795-54-00-5440 TELECOMMUNICATIONS 7,734 9,034 8,000 8,000 8,750 8,750 8,750 8,750 8,750 79-795-54-00-5447 SCHOLARSHIPS - - 2,500 500 2,500 2,500 2,500 2,500 2,500 79-795-54-00-5452 POSTAGE&SHIPPING 3,198 6,322 3,500 5,000 3,500 3,500 3,500 3,500 3,500 79-795-54-00-5460 DUES&SUBSCRIPTIONS 4,113 3,139 3,000 3,250 3,000 3,000 3,000 3,000 3,000 79-795-54-00-5462 PROFESSIONAL SERVICES 116,287 91,593 100,000 140,000 140,000 140,000 140,000 140,000 140,000 79-795-54-00-5480 UTILITIES 11,515 13,205 14,292 14,292 15,150 16,059 17,023 18,044 19,127 79-795-54-00-5485 RENTAL&LEASE PURCHASE 1,874 1,711 3,000 3,000 3,000 3,000 3,000 3,000 3,000 79-795-54-00-5488 OFFICE CLEANING 4,194 3,876 3,992 2,917 3,078 3,170 3,265 3,363 3,464 79-795-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 1,273 2,261 3,000 3,000 3,000 3,000 3,000 3,000 3,000 79-795-56-00-5602 HOMETOWN DAYS SUPPLIES 108,177 110,986 100,000 124,197 120,000 120,000 120,000 120,000 120,000 79-795-56-00-5606 PROGRAM SUPPLIES 119,317 139,495 160,000 160,000 158,241 160,000 160,000 160,000 160,000 79-795-56-00-5607 CONCESSION SUPPLIES 15,796 14,482 18,000 18,000 18,000 18,000 18,000 18,000 18,000 79-795-56-00-5610 OFFICE SUPPLIES 2,809 1,968 3,000 2,500 3,000 3,000 3,000 3,000 3,000 79-795-56-00-5620 OPERATING SUPPLIES 12,115 16,407 15,000 15,000 15,000 15,000 15,000 15,000 15,000 44 FY 2018 FY 2019 FY 2020 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 Account Number Description Actual Actual Adopted Projected Adopted Projected Projected Projected Projected 79-795-56-00-5640 REPAIR&MAINTENANCE 2,279 966 2,000 1,500 2,000 2,000 2,000 2,000 2,000 79-795-56-00-5695 GASOLINE 899 1,254 1,000 500 535 562 590 620 651 996,367 1,074,098 1,197,819 1,227,638 1,267,077 1,289,458 1,322,755 1,345,779 1,372,382 Expenditures 1,969,832 2,189,999 2,349,081 2,376,918 2,556,762 2,595,439 2,677,557 2,735,696 2,804,977 Surphts(Deficit) 27,975 (20,939) (104,093) (83,452) (369,462) - - - - Fund Balance 473,852 452,914 312,946 369,462 - - - - 24.06% 20.68% 13.32% 15.54% 0.00% 0.00% 0.00% 0.00% 0.00% 45 Library Operations Fund (82) The Yorkville Public Library provides the people of the community,from pre-school through maturity,with access to a collection of books and other materials which will serve their educational, cultural and recreational needs. The Library board and staff strive to provide the community an environment that promotes the love of reading. FY 2020 FY 2021 FY 2018 FY 2019 Adopted FY 2020 Adopted FY 2022 FY 2023 FY 2024 FY 2025 Actual Actual Budget Projected Budget Projected Projected Projected Projected Revenue Taxes 1,402,659 1,457,087 1,492,248 1,497,431 1,562,000 1,597,242 1,627,131 1,669,993 1,691,484 Intergovernmental 18,086 30,564 25,250 26,401 25,250 25,250 25,250 25,250 25,250 Fines&Forfeits 9,922 9,234 8,500 8,500 8,500 8,500 8,500 8,500 8,500 Charges for Service 12,750 13,466 11,750 12,164 12,300 12,400 12,400 12,400 12,400 Investment Earnings 5,423 11,463 10,000 17,382 8,959 8,272 7,518 6,688 5,788 Reimbursements 691 - - - - - - - - Miscellaneous 6,488 3,463 4,000 4,000 3,750 3,750 3,750 3,750 3,750 Other Financing Sources 23,775 23,495 25,003 24,235 26,584 28,134 29,777 31,519 33,365 Total Revenue 1,479,794 1,548,772 1,576,751 1,590,113 1,647,343 1,683,548 1,714,326 1,758,100 1,780,537 Expenditures Salaries 403,032 426,855 474,394 445,894 479,742 504,163 528,938 554,019 579,412 Benefits 148,184 158,810 175,658 167,570 179,800 191,849 204,303 217,417 230,485 Contractual Services 131,797 104,354 149,080 135,019 152,448 153,006 153,756 154,551 155,394 Supplies 15,088 22,737 24,200 24,200 25,300 25,300 25,300 25,300 25,300 Debt Service 760,396 792,101 797,013 797,013 827,088 840,225 847,313 866,750 864,000 Total Expenditures 1,458,497 1,504,857 1,620,345 1,569,696 1,664,378 1,714,543 1,759,610 1,818,037 1,854,591 Surplus(Deficit) 21,297 43,915 (43,594) 20,417 (17,035) (30,995) (45,284) (59,937) (74,054) Ending Fund Balance 510,355 554,271 474,039 574,688 557,653 526,658 481,374 421,437 347,383 34.99% 36.83% 29.26% 36.61% 33.51% 30.72% 27.36% 23.18% 18.73% Operational Fund Balance% 73.11% 77.76% 57.58% 74.38% 66.60% 60.24% 52.77% 44.30% 35.07% Fund Balance N $800 - n $600 - N 3 $400 - 0 1- i $200 - $0 , , I 46 FY 2018 F'1 2019 FY 2020 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 Account Number Description Actual Actual Adopted Projected Adopted Projected Projected Projected Projected Library Operations 82-000-40-00-4000 PROPERTY TAXES-LIBRARY OPS 644,025 669,065 699,220 702,716 739,047 761,218 784,055 807,577 831,804 82-000-40-00-4083 PROPERTY TAXES-DEBT SERVICE 758,634 788,022 793,028 794,715 822,953 836,024 843,076 862,416 859,680 82-000-41-00-4120 PERSONAL PROPERTY TAX 4,948 5,353 5,250 5,250 5,250 5,250 5,250 5,250 5,250 82-000-41-00-4170 STATE GRANTS 13,138 25,211 20,000 21,151 20,000 20,000 20,000 20,000 20,000 82-000-43-00-4330 LIBRARY FINES 9,922 9,234 8,500 8,500 8,500 8,500 8,500 8,500 8,500 82-000-44-00-4401 LIBRARY SUBSCRIPTION CARDS 8,040 9,185 8,000 8,300 8,500 8,500 8,500 8,500 8,500 82-000-44-00-4422 COPY FEES 3,853 3,980 3,750 3,800 3,800 3,900 3,900 3,900 3,900 82-000-44-00-4439 PROGRAM FEES 857 301 - 64 - - - - - 82-000-45-00-4500 INVESTMENT EARNINGS 4,593 11,463 10,000 13,500 8,959 8,272 7,518 6,688 5,788 82-000-45-00-4550 GAIN ON INVESTMENT 830 - - 3,882 - - - - - 82-000-46-00-4690 REIMS-MISCELLANEOUS 691 - - - - - - - - 82-000-48-00-4820 RENTAL INCOME 1,806 1,405 2,000 1,500 1,750 1,750 1,750 1,750 1,750 82-000-48-00-4824 DVD RENTAL INCOME 2,842 1,228 - - - - - _ - 82-000-48-00-4850 MISCELLANEOUS INCOME 1,840 830 2,000 2,500 2,000 2,000 2,000 2,000 2,000 82-000.49-00-4901 TRANSFER FROM GENERAL 23,775 23,495 25,003 24,235 26,584 28,134 29,777 31,519 33,365 Revenue 1,479,794 1,548,772 1,576,751 1,590,113 1,647,343 1,683,548 1,714,326 1,758,100 1,780,537 82-820-50-00-5010 SALARIES&WAGES 213,880 261,231 278,394 278,394 289,742 298,434 307,387 316,609 326,107 82-820-50-00-5015 PART-TINE SALARIES 189,152 165,624 196,000 167,500 190,000 205,729 221,551 237,410 253,305 82-820-52-00-5212 RETIREMENT PLAN CONTRIBUTION 22,885 26,614 25,541 29,000 32,779 34,171 36,087 37,993 39,133 82-820-52-00-5214 FICA CONTRIBUTION 30,169 31,983 35,544 33,500 35,952 38,568 40,464 42,382 44,325 82-820-52-00-5216 GROUP HEALTH INSURANCE 65,658 68,695 81,184 72,474 76,764 82,905 89,537 96,700 104,436 82-820-52-00-5222 GROUP LIFE INSURANCE 388 351 387 362 387 391 395 399 403 82-820-52-00-5223 DENTAL INSURANCE 4,672 6,699 6,987 6,987 6,322 6,638 6,970 7,319 7,685 82-820-52-00-5224 VISION INSURANCE 637 973 1,012 1,012 1,012 1,042 1,073 1,105 1,138 82-820-52-00-5230 UNEMPLOYMENT INSURANCE 747 604 750 750 750 750 750 750 750 82-820-52-00-5231 LIABILITY INSURANCE 23,028 22,891 24,253 23,485 25,834 27,384 29,027 30,769 32,615 82-820-54-00-5412 TRAINING&CONFERENCES 308 1,374 2,000 1,200 3,000 3,000 3,000 3,000 3,000 82-820-54-00-5415 TRAVEL&LODGING 348 1,557 1,500 500 1,500 1,500 1,500 1,500 1,500 82-820-54-00-5426 PUBLISHING&ADVERTISING 100 3,019 2,000 1,000 2,500 2,500 2,500 2,500 2,500 82-820-54-00-5440 TELECOMMUNICATIONS 4,513 5,313 6,000 5,750 7,200 7,200 7,200 7,200 7,200 82-820-54-00-5452 POSTAGE&SHIPPING 582 655 750 750 750 600 600 600 600 82-820-54-00-5460 DUES&SUBSCRIPTIONS 8,911 9,602 11,000 11,000 11,000 11,000 11,000 11,000 11,000 82-820-54-00-5462 PROFESSIONAL SERVICES 24,151 24,213 40,000 35,000 40,000 40,000 40,000 40,000 40,000 82-820-54-00-5466 LEGAL SERVICES 2,100 2,205 3,000 2,000 3,000 3,000 3,000 3,000 3,000 82-820-54-00-5468 AUTOMATION 13,466 13,854 20,000 15,000 20,000 20,000 20,000 20,000 20,000 82-820-54-00-5480 UTILITIES 9,852 11,973 11,130 11,130 11,798 12,506 13,256 14,051 14,894 82-820-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 65,777 28,900 50,000 50,000 50,000 50,000 50,000 50,000 50,000 82-820-54-00-5498 PAYING AGENT FEES 1,689 1,689 1,700 L689 1,700 1,700 1,700 1,700 1,700 82-820-56-00-5610 OFFICE SUPPLIES 5,518 7,147 8,000 8,000 8,000 8,000 8,000 8,000 8,000 47 FY 2018 FY 2019 FY 2020 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 Account Number Description Actual Actual Adopted Projected Adopted Projected Projected Projected Projected 82-820-56-00-5620 LIBRARY OPERATING SUPPLIES 6,733 3,821 3,000 3,000 4,000 4,000 4,000 4,000 4,000 82-820-56-00-5621 CUSTODIAL SUPPLIES - 4,215 8,000 8,000 7,000 7,000 7,000 7,000 7,000 82-820-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - 1,199 2,000 1,000 2,000 2,000 2,000 2,000 2,000 82-820-56-00-5671 LIBRARY PROGRAMMING 820 1,737 1,000 2,000 2,000 2,000 2,000 2,000 2,000 82-820-56-00-5676 EMPLOYEE RECOGNITION 151 247 200 200 300 300 300 300 300 82-820-56-00-5684 COMPACT DISCS&OTHER MUSIC - - - - - - - - - 82-820-56-00-5685 DVD'S 499 56 500 500 500 500 500 500 500 82-820-56-00-5686 BOOKS 1,367 4,315 1,500 1,500 1,500 1,500 1,500 1,500 1,500 Debt Service-2006 Bond 82-820-84-00-8000 PRINCIPAL PAYMENT 50,000 50,000 50,000 50,000 75,000 75,000 75,000 100,000 100,000 82-820-84-00-8050 INTEREST PAYMENT 27,363 24,988 22,613 22,613 20,238 16,675 13,113 9,550 4,800 Debt Service-2013 Refunding Bond 82-820-99-00-8000 PRINCIPAL PAYMENT 520,000 565,000 585,000 585,000 610,000 645,000 675,000 700,000 730,000 82-820-99-00-8050 INTEREST PAYMENT 163,033 152,113 139,400 139,400 121,850 103,550 84,200 57,200 29,200 Expenditures 1,458,497 1,504,857 1,620,345 1,569,696 1,664,378 1,714,543 1,759,610 1,818,037 1,854,591 Surplus(Deficit) 21,297 43,915 (43,594) 20,417 (17,035) (30,995) (45,284) (59,937) (74,054) Fund Balance 510,355 554,271 474,039 574,688 557,653 526,658 481,374 421,437 347,383 34.99% 36.83% 29.26% 36 61% 33.51% 30.72% 27.36% 23.18% 18.73% Operational Fund Balance z 73.11% 77.76% 57.58% 74.38% 6660% 6624% 52.77% 44.30% 35.07% 48 Library Capital Fund (84) The Library Capital Fund derives its revenue from monies collected from building permits. The revenue is used for Library building maintenance and associated capital,contractual and supply purchases. FY 2020 FY 2021 FY 2018 FY 2019 Adopted FY 2020 Adopted FY 2022 FY 2023 FY 2024 FY 2025 Actual Actual Budget Projected Budget Projected Projected Projected Projected Revenue Licenses&Permits 100,484 103,100 50,000 113,000 50,000 50,000 50,000 50,000 50,000 Investment Eamings 16 257 100 725 500 250 250 250 250 Miscellaneous 37 1,835 - - - - - - - Total Revenue 100,537 105,192 50,100 113,725 50,500 50,250 50,250 50,250 50,250 Expenditures Contractual Services 3,425 3,213 3,500 3,000 3,500 3,500 3,500 3,500 3,500 Supplies 54,604 77,162 72,000 64,500 72,000 72,000 72,000 72,000 58,360 Capital Outlay 3,970 - - - - - - - - Total Expenditures 61,999 80,375 75,500 67,500 75,500 75,500 75,500 75,500 61,860 Surplus(Deficit) 38,538 24.817 (25,400) 46,225 (25,000) (25,250) (25,250) (25,250) (11,610) Ending Fund Balance 58,443 83,260 31,274 129,485 104,485 79,235 53,985 28,735 17,125 $150 Fund Balance v.c 114 $100 0 1- $50 $0 49 FY 2018 FY 2019 FY 2020 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 Account Number Description Actual Actual Adopted Projected Adopted Projected Projected Projected Projected Library Capital 84-000-42-00-4214 DEVELOPMENT FEES 100,484 103,100 50,000 113,000 50,000 50,000 50,000 50,000 50,000 84-000-45-00-4500 INVESTMENT EARNINGS 16 257 100 725 500 250 250 250 250 84-000-48-00-4850 MISCELLANEOUS INCOME 37 1,835 - - - - - - - Revenue 100,537 105,192 50,100 113,725 50,500 50,250 50,250 50,250 50,250 84-840-54-00-5460 E-BOOKS SUBSCRIPTION 3,425 3,213 3,500 3,000 3,500 3,500 3,500 3,500 3,500 84-840-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 7,367 14,897 15,000 7,500 15,000 15,000 15,000 15,000 15,000 84-840-56-00-5683 AUDIO BOOKS 3,531 3,877 3,500 3,500 3,500 3,500 3,500 3,500 3,500 84-840-56-00-5684 COMPACT DISCS&OTHER MUSIC 699 290 500 500 500 500 500 500 500 84-840-56-00-5685 DVD'S 1,903 3,425 3,000 3,000 3,000 3,000 3,000 3,000 3,000 84-840-56-00-5686 BOOKS 41,104 54,673 50,000 50,000 50,000 50,000 50,000 50,000 36,360 84-840-60-00-6020 BUILDINGS&STRUCTURES 3,970 - - - - - - - - Expenditures 61,999 80,375 75,500 67,500 75,500 75,500 75,500 75,500 61,860 Surplus(Deficit) 38,538 24,817 (25,400) 46,225 (25,000) (25,250) (25,250) (25,250) (11,610) Fund Balance 58,443 83,260 31,274 129,485 104,485 79,235 53,985 28,735 17,125 50 Countryside TIF Fund(87) The Countryside TIF was created in February of 2005,with the intent of constructing a future retail development at Countryside Center. This TIF is located at the northwest corner of US Route 34 and IL Route 47. FY 2020 FY 2021 FY 2018 FY 2019 Adopted FY 2020 Adopted FY 2022 FY 2023 FY 2024 FY 2025 Actual Actual Budget Projected Budget Projected Projected Projected Projected Revenue Taxes 198,294 198,918 232,318 203,884 153,965 286,900 365,501 374,639 384,005 Total Revenue 198,294 198,918 232,318 203,884 153,965 286,900 365,501 374,639 384,005 Expenditures Contractual Services 12,691 12,208 713,963 712,924 14,175 14,519 14,874 15,239 15,615 Debt Service 149,669 149,351 209,845 209,845 208,311 209,316 208,787 209,422 208,522 Total Expenditures 162,360 161,559 923,808 922,769 222,486 223,835 223,661 224,661 224,137 Surplus(Deficit) 35,934 37,359 (691,490) (718,885) (68,521) 63,065 141,840 149,978 159,868 Ending Fund Balance (459,819) (422,459) (1,077,343) (1,141,344) (1,209,865) (1,146,800) (1,004,960) (854,982) (695,114) $o Fund Balance , ($500) 3 O IE ($1,000) ($1,500) - 51 FY 2018 FY 2019 FY 2020 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 Account Number Description Actual Actual Adopted Projected Adopted Projected Projected Projected Projected Countryside TIF 87-000-40-00-4000 PROPERTY TAXES 198,294 198,918 232,318 203,884 153,965 286,900 365,501 374,639 384,005 Revenue 198,294 198,918 232,318 203,884 153,965 286,900 365,501 374,639 384,005 87-870-54-00-5401 ADMINISTRATIVE CHARGEBACK 10,701 11,049 11,263 11,263 11,475 11,819 12,174 12,539 12,915 87-870-54-00-5425 TIF INCENTIVE PAYOUT - - 700,000 700,000 - - - - - 87-870-54-00-5462 PROFESSIONAL SERVICES 1,329 498 2,000 1,000 2,000 2,000 2,000 2,000 2,000 87-870-54-00-5498 PAYING AGENT FEES 661 661 700 661 700 700 700 700 700 2015A Bond 87-870-77-00-8000 PRINCIPAL PAYMENT 41,009 42,332 104,517 104,517 107,163 112,455 116,424 121,716 125,685 87-870-77-00-8050 INTEREST PAYMENT 57,945 56,304 54,613 54,613 50,433 46,146 41,648 36,991 32,122 Debt Service-2014 Refunding Bond 87-870-93-00-8000 PRINCIPAL PAYMENT - - - - - - - - 87-870-93-00-8050 INTEREST PAYMENT 50,715 50,715 50,715 50,715 50,715 50,715 50,715 50,715 50,715 Expenditures 162,360 161,559 923,808 922,769 222,486 223,835 223,661 224,661 224,137 Surplus(Deficit) 35,934 37,359 (691,490) (718,885) (68,521) 63,065 141,840 149,978 159,868 Fund Balance (459,819) (422,459) (1,077,343) (1,141,344) (1,209,865) (1,146,800) (1,004,960) (854,982) (695,114) 52 Downtown TIF Fund (88) The Downtown TIF was created in 2006,in order to finance a mixed use development in the downtown area. FY 2020 FY 2021 FY 2018 FY 2019 Adopted FY 2020 Adopted FY 2022 FY 2023 FY 2024 FY 2025 Actual Actual Budget Projected Budget Projected Projected Projected Projected Revenue Taxes 76,186 78,417 80,000 75,759 76,000 78,000 80,000 80,000 80,000 Miscellaneous - 17 - - - - - - - Other Financing Sources 800,000 - - - - - - - - Total Revenue 876,186 78,434 80,000 75,759 76,000 78,000 80,000 80,000 80,000 Expenditures Contractual Services 80,349 57,380 93,246 63,343 76,364 75,713 78,009 80,399 82,887 Capital Outlay 1,574,697 138,466 114,988 12,488 17,488 17,488 13,120 10,000 10,000 Debt Service - 225,800 218,250 218,250 212,200 206,084 - - - Total Expenditures 1,655,046 421,646 426,484 294,081 306,052 299,285 91,129 90,399 92,887 Surplus(Deficit) (778,860) (343,212) (346,484) (218,322) (230,052) (221,285) (11,129) (10,399) (12,887) Ending Fund Balance (681,305) (1,024,518) (1,194,280) (1,242,840) (1,472,892) (1,694,177) (1,705,306) (1,715,705) (1,728,592) $0 , Fund Balance o ($1,000) t • • ($2,000) 53 FY 2018 FY 2019 FY 2020 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 Account Number Description Actual Actual Adopted Projected Adopted Projected Projected Projected Projected Downtown TIF 88-000-40-00-4000 PROPERTY TAXES 76,186 78,417 80,000 75,759 76,000 78,000 80,000 80,000 80,000 88-000-48-00-4850 MISCELLANEOUS INCOME • 17 - - - - - - - 88-000-49-00-4905 LOAN PROCEEDS 800,000 - - - - - - - - Revenue 876,186 78,434 80,000 75,759 76,000 78,000 80,000 80,000 80,000 88-880-54-00-5401 ADMINISTRATIVE CHARGEBACK 30,284 31,533 32,246 32,246 33,487 34,492 35,527 36,593 37,691 88-880-54-00-5425 TIF INCENTIVE PAYOUT 22,727 22,108 20,000 25,597 26,877 25,221 26,482 27,806 29,196 88-880-54-00-5462 PROFESSIONAL SERVICES 4,485 294 1,000 500 1,000 1,000 1,000 1,000 1,000 88-880-54-00-5466 LEGAL SERVICES 22,853 3,445 15,000 5,000 15,000 15,000 15,000 15,000 15,000 88-880-54-00-5470 FACADE REHAB PROGRAM - - 25,000 - - - - - - 88-880-60-00-6000 PROJECT COSTS 73,334 105,516 27,500 5,000 10,000 10,000 10,000 10,000 10,000 88-880-60-00-6011 PROPERTY ACQUISITION 1,164,449 - - - - - - - - 88-880-60-00-6015 DOWNTOWN HILL - - 50,000 - - - - - - 88-880-60-00-6045 RIVERFRONT PARK 329,494 - - - - - - - - 88-880-60-00-6048 DOWNTOWN STREETSCAPE IMPROVEMENT - 25,468 30,000 - - - - - - 88-880-60-00-6079 ROUTE 47 EXPANSION 7,420 7,482 7,488 7,488 7,488 7,488 3,120 - - FNBO Loan-102 E Van Emmon Building 88-880-81-00-8000 PRINCIPAL PAYMENT - 200,000 200,000 200,000 200,000 200,000 - - - 88-880-81-00-8050 INTEREST PAYMENT - 25,800 18,250 18,250 12,200 6,084 - - - Expenditures 1,655,046 421,646 426,484 294,081 306,052 299,285 91,129 90,399 92,887 Surplus(Deficit) (778,860) (343,212) (346,484) (218,322) (230,052) (221,285) (11,129) (10,399) (12,887) Fund Balance (681,305) (1,024,518) (1,194,280) (1,242,840) (1,472,892) (1,694,177) (1,705,306) (1,715,705) (1,728,592) 54 Downtown TIF Fund II(89) The Downtown TIF 11 was created in 2018,in order to help promote downtown redevelopment and support the existing Downtown TIF. FY 2020 FY 2021 FY 2018 FY 2019 Adopted FY 2020 Adopted FY 2022 FY 2023 FY 2024 FY 2025 Actual Actual Budget Projected Budget Projected Projected Projected Projected Revenue Taxes - - - 24,171 25,000 33,000 33,000 39,000 39,560 Total Revenue - - - 24,171 25,000 33,000 33,000 39,000 39,560 Expenditures Contractual Services - 2,736 35,000 90,000 22,500 30,500 13,000 19,000 18,104 Total Expenditures - 2,736 35,000 90,000 22,500 30,500 13,000 19,000 18,104 Surplus(Deficit) - (2,736) (35,000) (65,829) 2,500 2,500 20,000 20,000 21,456 Ending Fund Balance - (2,736) (10,000) (68,565) (66,065) (63,565) (43,565) (23,565) (2,109) $0 -• Fund Balance o ($50) -c I- ($100)($100) 55 FY 2018 FY 2019 FY 2020 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2029 Account Number Description Actual Actual Adopted Projected Adopted Projected Projected Projected Projected Downtown THF II 89-000-40-00-4000 PROPERTY TAXES - - - 24,171 25,000 33,000 33,000 39,000 39,560 Revenue - - - 24,171 25,000 33,000 33,000 39,000 39,560 89-890-54-00-5425 TIF INCENTIVE PAYOUT - - - 80,000 17,500 25,500 8,000 14,000 13,104 89-890-54-00-5462 PROFESSIONAL SERVICES - 2,736 10,000 10,000 5,000 5,000 5,000 5,000 5,000 89-890-54-00-5470 FACADE REHAB PROGRAM - - 25,000 - - - - - - Expenditures - 2,736 35,000 90,000 22,500 30,500 13,000 19,000 18,104 Surplus(Deficit) - (2,736) (35,000) (65,829) 2,500 2,900 20,000 20,000 21,456 Fund Balance - (2,736) (10,000) (68,569) (66,065) (63,969) (43,565) (23,565) (2,109) 56