Loading...
Ordinance 2016-30 STATE OF 1L111011; CUM OF KID FILED - APR 272016 UNITED CITY OF YORKVILLE KENDALL COUNTY, ILLINOIS ORDINANCE NO. 2016-30 ORDINANCE APPROVING THE 2016-2017 FISCAL BUDGET FOR THE UNITED CITY OF YORKVILLE Passed by the City Council of the United City of Yorkville, Kendall County, Illinois This 12`x'day of April, 2016 Published in pamphlet form by the authority of the Mayor and City Council of the United City of Yorkville,Kendall County, Illinois on April 27, 2016. ORDINANCE NO. 2016- ORDINANCE APPROVING THE 2016-2017 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 2016-2017 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 2016-2017 Fiscal Year Budget being submitted on April 12, 2016 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 2016-2017 Budget totaling $33,275,572 including the amounts of$14,803,097 General Fund, $740,580 Motor Fuel Tax Fund, $193,617 Vehicle & Equipment Fund, $2,965,298 Sewer Fund, $6,445,269 Water Fund, $3,796,671 City-Wide Capital Fund, $320,675 Debt Service Fund, $453,855 Land Cash Fund, $1,796,995 Parks & Recreation Fund, $756,943 Library Operations Fund, $752,771 Library Debt Service Fund, $11,895 Library Capital Fund, $162,759 Countryside TIF Fund, $52,780 Downtown TIF Fund, $17,534 Sunflower SSA Fund, and $4,833 Fox Hill SSA Fund is hereby adopted for the 2016-2017 Fiscal Year, as presented. Passed by the City Council of the United City of Yorkville, Kendall County, Illinois this 12th day of April, A.D. 2016. CITY CLERK_ Ordinance No. 2016- 30 Page 2 CARLO COLOSIMO KEN KOCH _ JACKIE MILSCHEWSKI �— LARRY KOT CHRIS FUNKHOUSER JOEL FRIEDERS SEAVER TARULIS DIANE TEELING Approved by me, as Mayor of the United City of Yorkville, Kendall County, Illinois, this 12th day of April, A.D. 2016. AA4 MAYOR Ordinance No. 2016- 30 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 2016 FY 2014 FY 2015 Adopted FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes 9,607,999 10,052,792 10,229,937 10,229,475 10,384,836 10,585,524 10,789,227 10,996,003 11,205,915 Intergovernmental 2,120,327 2,295,134 2,178,100 2,386,728 2,313,586 2,361,058 2,409,379 2,458,566 2,508,638 Licenses&Permits 168,119 173,126 198,000 173,000 178,000 223,000 223,000 223,000 223,000 Fines&Forfeits 173,954 137,252 160,250 130,225 130,225 135,225 135,225 135,225 135,225 Charges for Service 1,175,166 1,290,493 1,319,950 1,388,948 1,423,175 1,460,725 1,499,402 1,539,239 1,580,271 Investment Earnings 8,792 8,909 4,000 5,000 5,000 3,000 2,000 2,000 2,000 Reimbursements 168,974 168,182 80,000 86,000 55,000 55,000 55,000 55,000 55,000 Miscellaneous 19,335 22,813 22,500 22,000 24,000 24,000 24,000 24,000 24,000 Other Financing Sources 2,479 2,209 7,900 5,000 3,000 3,000 3,000 3,000 3,000 Total Revenue 13,445,145 14,150,910 14,200,637 14,426,376 14,516,822 14,850,532 15,140,233 15,436,033 15,737,049 Expenditures Salaries 3,437,661 3,721,840 4,113,253 4,110,082 4,315,553 4,477,044 4,599,713 4,726,061 4,856,200 Benefits 2 052 895 2 334 546 2 545 610 2 477 220 2 798 284 2 981 592 3 170 576 3 369 578 3 579 176 Contractual Services 4,267,482 4,387,516 4,807,155 4,910,053 4,731,040 4,791,526 4,811,157 4,906,895 4,995,683 Supplies 247,990 254,650 284,861 284,861 326,761 279,547 288,503 298,070 308,289 Contingencies 11,676 - - - - - - - - Other Financing Uses 3,790,688 2,486,885 2,439,756 2,456,533 2,631,459 2,854,307 2,910,946 2,968,458 3,032,557 Total Expenditures 13,808,392 13,185,437 14,190,635 14,238,749 14,803,097 15,384,016 15,780,895 16,269,062 16,771,905 Surplus(Deficit) (363,247) 965,473 10,002 187,627 (286,275) (533,484) (640,662) (833,029) (1,034,856) Ending Fund Balance 3,860,581 4,826,059 4,110,607 5,013,686 4,727,411 4,193,927 3,553,265 2,720,236 1,685,380 27.96% 36.60% 28.97% 35.21% 31.94% 27.26% 22.52% 16.72% 10.05% Fund Balance v $6,000 c $4,000 Z $2,000 _ $0 2 FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected GENERAL FUND-01 01-000-40-00-4000 PROPERTY TAXES-CORPORATE LEVY 2,201,759 2,277,087 2,258,200 2,278,321 2,219,203 2,263,587 2,308,859 2,355,036 2,402,137 01-000-40-004010 PROPERTY TAXES-POLICE PENSION 524,120 624,168 728477 703,105 825,413 875,413 925,413 975,413 1,025,413 01-000-40-00-4030 MUNICIPAL SALES TAX 2,586,460 2,704,651 2,751,960 2,746,000 2,800,920 2,856,938 2,914,077 2,972,359 3,031,806 01-000-40-00-4035 NON-HOME RULE SALES TAX 1,986,566 2,078,061 2,142,000 2,115,000 2,157,300 2,200,446 2,244,455 2,289,344 2,335,131 01-000-40-00-4040 ELECTRIC UTILITY TAX 615,878 635,478 605,000 635,000 625,000 625,000 625,000 625,000 625,000 01-000-40-004041 NATURAL GAS UTILITY TAX 310,979 277,969 265,000 265,000 265,000 265,000 265,000 .265,000 265,000 01-000-40-00-4043 EXCISE TAX 461,554 418,509 415,000 390,000 390,000 390,000 390,000 390,000 390,000 01-D00-40-00-4044 TELEPHONE UTILITY TAX 12,625 10,222 11,500 8,250 8,000 8,000 8,000 8,000 8,000 01-000-40-00-4045 CABLE FRANCHISE FEES 232,206 258,118 230,000 270,000 270,000 270,000 270,000. 270,000 270,000 01-000-40-00-4050 HOTELTAX 65,605 72,708 70,000 76,000 76,000 76,000 76,000 76,000 76;000 01-000-40-00-4055 VIDEO GAMING TAX 26,047 50,855 45,000 65,000 65,000 65,000 65,000 65,000 65,000 01-000-40-00-4060 AMUSEMENT TAX 144,118 172,461 175,000 180,000 180,000 180,000 180,000 180,000 180,000 01-000-40-00-4065 ADMISSIONS TAX 103,720 104,066 105,000 121,799 120,000 120,000 120,000 120,000 120,000 01-000-40-00-4070 BUSINESS DISTRICT TAX-KENDALL MRKT 325,724 336,830 346,800 350,000 357,000 364,140 371,423 378,851 386,428 01-000-40-00-4071 BUSINESS DISTRICT TAX-DOWNTOWN 11,192 20,000 4,000 4,000 4,000 4,000 4,000 4,000 01-000-40-00-4072 BUSINESS DISTRICT TAX-COUNTRYSIDE - 9,054 20,000 11,000 11,000 11,000 11,000 11,000 11,000 01-000-40-00-4075 AUTO RENTAL TAX 10,638 11,363 11,000 11,000 11,000 11,000 11,000 11,000 11,000 01.000-41-00-41.00 STATE INCOME TAX L613,102 1,735,422 1,610,000 1,800,000 1,725,942 1,760,461 1,795,670 1,831,583 1,868,215 01-00041-00-4105 LOCAL USE TAX 296,298 341,880 346,800 395,000 397,644 405,597 413,709 421,983 430,423 01-000-41-00-4110 ROAD&BRIDGE TAX 164,398 171,756 175,000 148,223 150,000 155,000 160,000 165,000 170,000 01-000-41-00-4120 PERSONAL PROPERTY TAX 16,672 17,450 16,000 17,000 17,000 17,000 17,000 17,000 17,000 01-000-41-00-4160 FEDERAL GRANTS 8,880 10,341 10,000 114,000 10,000 10,000 10,000 10,000 10,000 01-000-41-00-4168 STATE GRANTS-TRAFFIC SIGNAL MAINTENANCE 19,284 17,290 14;04.10 13,505 12,000 12,000 12,000 12,000 12;000 01-000-41-00-4170 STATE GRANTS 266 - 2,000 - - - - - 01-000-41-00-4182 MISC INTERGOVERNMENTAL 1.427 995 1,300 1,000 1,000 1,000 1,000 1,000 1,000 01-000-42-00-4200 LIQUOR LICENSES 47,781 46,887 45,000 45,000 45,000 45,000 45,000 45,000 45,000 01-000-42-00-4205 OTHER LICENSES&PERMITS 4,156 2,537 3,000 3,000 3,000 3,000 3,000 3,000 3,000 01-000-42-00-4210 BUILDING PERMITS 116,182 123,702 150,000 125,000 130,000 175,000 175,000 175,000 175,000 01-000-43-00-4310 CIRCUIT COURT FINES 45,653 49,859 45,000 45,000 45,000 45,000 45,000 45,000 45,000 01-000-43-00-4320 ADMINISTRATIVE ADJUDICATION 42,430 31,507 35,000 30,000 30,000 30,000 30,000 30,000 30,000 01-000-43-00-4323 OFFENDER REGISTRATION FEES 215 230 250 225 225 225 225 225 225 01-000-43-00-4325 POLICE TOWS 85,656 55,656 80000 55,000 55,000 60,000 60,000 60,000 60,000 01-000-44-00-4400 GARBAGE SURCHARGE 1,003,263 1,117,947 1,148,450 1,215,119 1,251,675 1,289,225 1,327,902 1,367,739 1,408,771 01-000-44-00-4405 COLLECTION FEES-YBSD 150,249 151,241 150,000 150,000 150,000 150,000 150,000 150,000 150,000 2 3 FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected 01-000-44-00-4407 LATE PENALTIES-GARBAGE 21,054 21,305 21,000 21,000 21,000 21,000 21,000 21,000 21,000 01-000-44-00-4474 POLICE SPECIAL DETAIL 600 - 500 2,829 500 500 500 500 500 O1-000-45-00-4500 INVESTMENT EARNINGS 8,792 5,458 4.000 5.000 5,000 3,000 2,000 2,000 2,000 O1-00045-004550 GAIN ON INVESTMENT - 3,451 - - - - - - _ 01-000-46-00-4601 REIMB-LEGAL EXPENSES 2,629 6,099 _ - - - - - - O1-000-46-00.4604 REIMB-ENGINEERING EXPENSES 107,193 81,686 50,000 50,000 25,000 25,000 25,000 25,000 25,000 O1-000-46-004680 REIMB-LIABILITY INSURANCE 4,764 4,280 5,000 5,000 5,000 5,000 5,000 5,000 5,000 01-000-46-00-4681 REIMB-WORKERS COMP 30,788 (224) - - - - - - - 01-000-46-00-4685 REIMB-CABLE CONSORTIUM 18,932 69,693 20,000 20,000 20,000 20,000 20,000 20,000 20,000 O1-000-46-00-4690 REIMB-MISCELLANEOUS 4,668 6,648 5,000 11,000 5,000 5,000 5,000 5,000 5,000 01-000-48-00-4820 RENTAL INCOME 7,495 6,715 7,500 7,000 7,000 7,000 7,000 7,000 7,000 O1-00048-00.4845 DONATIONS - 900 - - 2,000 2,000 2,000 2,000 2,000 O1-000-48-00-4850 MISCELLANEOUS INCOME 11,840 15,198 15,000 15,400 15,000 15,000 15,000 15,000 15,000 O1-000-49.00-4910 , SALE OF CAPITAL ASSETS - - 5,400 - - O1-00049-00-4916 TRANSFER FROM CW MUNICIPAL BUILDING 2,479 2,209 2,500 5,000 3,000 3,000 3,000 3,000 3,000 Revenue 13,445,145 14,150,910 14,200,637 14,426,376 14,516,822 14,850,532 15,140,233 15,436,033 15,737,049 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 it the daily administration of City services. $1,000 $900 N $800 'o $700 $600 $500 $400 $300 $200 $100 $0 4 FY 2016 FY 2014 FY 2015 Adopted FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Expenditures Salaries 364,083 364,718 420,487 414,987 425,839 459,582 470,009 480,749 491,811 Benefits 219,042 242,710 166,566 162,858 165,333 180,572 192,704 205,726 219,663 Contractual Services 136,733 126,845 151,039 151,039 183,921 164,786 156,339 157,985 159,730 Supplies 8,287 7,198 11,850 11,850 10,850 10,850 10,850 10,850 10,850 Total Administration 728,145 741,471 749,942 740,734 785,943 815,790 829,902 855,310 882,054 $1,000 $900 N $800 'o $700 $600 $500 $400 $300 $200 $100 $0 4 Account Number Description Administration FY 2015 01-110-50-00-5001 SALARIES-MAYOR 01-110-50-00-5002 SALARIES-LIQUOR COMM 01-110-50-00-5003 SALARIES-CITY CLERK 01-110-50-00-5004 SALARIES-CITY TREASURER 01-110-50-00-5005 SALARIES-ALDERMAN 01-110-50A0-5010 SALARIES-ADMINISTRATION 01-110-50-00-5015 PART-TIME SALARIES 01-110-50-00-5020 OVERTIME 01-110-52-00-5212 RETIREMENT PLAN CONTRIBUTION 01-110-52-00-5214 FICA CONTRIBUTION 01-110-52-00-5216 GROUP HEALTH INSURANCE 01-110-52-ON5222 GROUP LIFE INSURANCE 01-110-52-00.5223 DENTAL INSURANCE 01-110-52-00-5224 VISION INSURANCE 01-110-52-00-5235 ELECTED OFFICIAL-GROUP HEALTH INSURANCE 01-110-52-00-5236 ELECTED OFFICIAL-GROUP LIFE INSURANCE 01-110-52-00-5237 ELECTED OFFICIAL-DENTAL INSURANCE 01-110-52-00-5238 ELECTED OFFICIAL-VISION INSURANCE 01-110-54-00-5410 TUITION REIMBURSEMENT 01-110-54-00-5412 TRAINING&CONFERENCES 01-110-54-00-5415 TRAVEL&LODGING 01-110-54-00-5426 PUBLISHING&ADVERTISING 01-110-54-00-5430 PRINTING&DUPLICATING 01-110-54-00-5436 4TH OF JULY CONTRIBUTION O1-110-54-00-5440 TELECOMMUNICATIONS 01-110-54-00-5448 FILING FEES 01-110-54-00-5451 CODIFICATION 01-110-54-00-5452 POSTAGE&SHIPPING 01-110-54-00-5460 DUES&SUBSCRIPTIONS 01-110-54-00-5462 PROFESSIONAL SERVICES 01-110-54-00-5473 KENDALL AREA TRANSIT 01-110-54-00-5480 UTILITIES 01-110-54-00.5485 RENTAL&LEASE PURCHASE 01-110-54-00-5488 OFFICE CLEANING FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 FY 2018 FV 2019 FY 2020 FY 2021 Actual Actual Budget Projected Adopted Projected Projected Projected Projected 9,535 9,570 11,000 11,000 11,000 11,000 11,000 11,000 11,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 7,268 6,905 11,000 11,000 11,000 11,000 11,000 11,000 11,000 1,031 968 6,500 1,000 6,500 6,500 6,500 6,500 6,500 47,190 47,960 52,000 52,000 52,000 52,000 52,000 52,000 52,000 275,169 294,157 308,487 308,487 336,039 347,582 358,009 368,749 379,811 22,646 4,158 30,000 30,000 7,800 30,000 30,000 30,000 30,000 244 - 500 500 500 500 500 500 500 36,794 37,723 42,886 42,886 37,405 42,289 45,203 48,328 51,636 25,473 24,296 31,014 31,014 28,931 31,623 32,572 33,549 34,555 69,776 85,215 85,972 79,773 91,653 98,985 106,904 115,456 124,692 403 443 447 527 445 445 449 453 458 4,252 5,387 5,139 5,629 6,178 6,487 6,811 7,152 7,510 550 576 549 721 721 743 765 788 812 76,151 82,691 - 2,232 - - - - 643 633 559 14 4,432 5,205 - 1 - 568 541 61 _ - - - - 15,000 10,000 - - _ 4,624 10,636 5,100 5,100 12,000 12,000 12,000 12,000 12,000 7,843 3,356 11.000 11,000 9,000 9,000 9,000 9,000 9,000 765 740 1,000 1,000 1,000 1,000 1,000 1,000 1,000 3,503 4,094 5,500 5,500 5,500 5,500 5,500 5,500 5,500 11,033 - - _ _ - _ _ - 13,143 13,097 20,000 10,000 16,000 16,000 16,000 16,000 16,000 181 70 500 500 500 500 500 500 500 2,468 3,003 5,000 5,000 5,000 5,000 5,000 5,000 5,000 2,225 2,932 4,000 4,000 4,000 4,000 4,000 4,000 4,000 14,004 15,981 17,000 17,000 17,000 17,000 17,000 17,000 17,000 8,355 9,112 14,000 14,000 29,600 14,000 14,000 14,000 14,000 23,550 23,550 25,000 25,000 25,000 25,000 25,000 25,000 25,000 27,883 23,131 23,039 23,039 24,421 25,886 27,439 29,085 30,830 2,508 2,347 2,400 2,400 2,400 2,400 2,400 2,400 2,400 14,648 14,796 17,500 17,500 17,500 17,500 17,500 17,500 1.7,500 5 5^r S t ,t; a 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 2016 FY 2014 FY 2015 Adopted FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Expenditures Salaries 193,692 206,925 217,491 217,491 233,718 241,746 248,998 256,468 264,162 Benefits 70,446 72,251 80,365 75,685 83,961 89,445 95,204 101,376 107,960 Contractual Services 60,214 73,736 87,050 83,750 92,700 95,300 95,300 95,300 95,300 Supplies 3,336 2,691 3,600 3,600 3,450 3,450 3,450 3,450 3,450 Total Finance 327,688 355,603 388,506 380,526 413,829 429,941 442,952 456,594 470,872 $500 $400 M 'o $300 L F $200 $100 $0 7 Account Number Description Finance FY 2015 01-120-50-00-5010 SALARIES&WAGES 01-120-52-00-5212 RETIREMENT PLAN CONTRIBUTION 01-120-52-00-5214 FICA CONTRIBUTION 01-120-52-00-5216 GROUP HEALTH INSURANCE 01-120-52-00-5222 GROUP LIFE INSURANCE 01-120-52-00-5223 DENTAL INSURANCE 01-120-52-00-5224 VISION INSURANCE 01-120-54-00-5412 TRAINING&CONFERENCES 01-120-54-00-5414 AUDITING SERVICES 01-120-54-00-5415 TRAVEL&LODGING 01-120-54-00-5430 PRINTING&DUPLICATING 01-120-54-00-5440 TELECOMMUNICATIONS 01-120-54-00-5452 POSTAGE&SHIPPING 01-120-54-00-5460 DUES&SUBSCRIPTIONS 01-120-54-00-5462 PROFESSIONAL SERVICES 01-120-54-00-5485 RENTAL&LEASE PURCHASE 01-120-56-00-5610 OFFICE SUPPLIES 01-120-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 Actual Actual Budget Projected Adopted 193,692 206,925 217,491 217,491 233,718 21,792 23,900 24,196 24,196 25,242 14,483 15,790 16,462 16,462 17,694 30,766 26,965 33,854 28,507 34,003 332 332 336 368 334 2,749 4,778 5 017 5,495 6,031 324 486 500 657 657 1,462 3,392 2,500 2,500 3,000 31,000 32,000 36,300 33,000 37,400 72 146 1,500 1,500 1,500 1,123 1,365 4,300 4,300 5,000 1,082 1,061 1,200 1,200 1,200 509 1,141 1,200 1,200 1,300 500 545 800 800 800 22,340 31,984 37 000 37,000 40,000 2,126 2,102 2,250 2,250 2,500 2,626 2,633 2,600 2,600 2,700 710 58 1,000 1,000 750 327,688 355,603 388,506 380,526 413,829 FY 2018 FY 2019 FY 2020 FY 2021 Projected Projected Projected Projected 241,746 248,998 256,468 264,162 27,076 29,008 31,084 33,284 18,302 18,851 19,417 20,000 36,723 39,661 42,834 46,261 334 337 340 343 6,333 6,650 6,983 7,332 677 697 718 740 3,000 3,000 3,000 3,000 40,000 40,000 40,000 40,000 1,500 1,500 1,500 1,500 5,000 5,000 5,000 5,000 1,200 1,200 1,200 1,200 1,300 1,300 1,300 1,300 800 800 800 800 40,000 40,000 40,000 40,000 2,500 2,500 2,500 2,500 2,700 2,700 2,700 2,700 750 750 750 750 429,941 442,952 456,594 470,872 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 2016 FY 2014 FY 2015 Adopted FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Expenditures Salaries 2,321,323 2,511,201 2,758,349 2,758,349 2,906,541 2,999,477 3,083,432 3,169,905 3,258,973 Benefits 1,208,317 1,411,567 1,641,285 1,581,936 1,833,415 1,951,748 2,074,147 2,201,891 2,335,378 Contractual Services 149,909 237,729 420,597 417,108 311,379 294,131 268,083 268,083 279,083 Supplies 132,585 154,654 158,200 158,200 203,450 154,068 160,079 166,511 173,393 Total Police 3,812,134 4,315,151 4,978,431 4,915,593 5,254,785 5,399,424 5,585,741 5,806,390 6,046,827 $7,000 $6,000 v $5,000 3 0 r $4,000 $3,000 $2,000 $1,000 $0 �i Account Number Description Police FY 2015 01-210-50-00-5008 SALARIES-POLICE OFFICERS 01-210-50-00-5011 SALARIES-POLICE CHIEF&DEPUTIES 01-210-50-00-5012 SALARIES-SERGEANTS 01-210.50-00-5013 SALARIES-POLICE CLERKS 01-210-50-00-5014 SALARIES-CROSSING GUARD 01-210-50-00-5015 PART-TIME SALARIES 01-210-50-00-5020 OVERTIME 01-210-52-00-5212 RETIREMENT PLAN CONTRIBUTION 01-210-52-00-5213 EMPLOYER CONTRIBUTION-POLICE PENSION 01-210-52-00-5214 FICA CONTRIBUTION 01-210-52-00-5216 GROUP HEALTH INSURANCE 01-210-52-00-5222 GROUP LIFE INSURANCE 01-210-52-00-5223 DENTAL INSURANCE 01-210-52-00-5224 VISION INSURANCE 01-210-54-00-5410 TUITION REIMBURSEMENT 01-210-54-00-5411 POLICE COMMISSION 01-210-54-00-5412 TRAINING&CONFERENCE 01-210-54-00-5415 TRAVEL&LODGING 01-210-54-00-5422 VEHICLE&EQUIPMENT CHARGEBACK 01-210-54-00-5426 PUBLISHING&ADVERTISING 01-210-54-00-5430 PRINTING&DUPLICATING 01-210-54-00-5440 TELECOMMUNICATIONS 01-210-54-00-5452 POSTAGE&SHIPPING 01-210-54-00-5460 DUES&SUBSCRIPTIONS 01-210-54-00-5462 PROFESSIONAL SERVICES 01-210-54-00-5466 LEGAL SERVICES 01-210-54-00-5467 ADJUDICATION SERVICES 01-210-54-00-5469 NEW WORLD&LIVE SCAN 01-210-54-00-5472 KENDALL CO JUVE PROBATION 01-210-54-00-5484 MDT-ALERTS FEE 01-210-54-00-5485 RENTAL&LEASE PURCHASE 01-210-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 01-210-56-00-5600 WEARINGAPPAREL 01-210-56-00-5610 OFFICE SUPPLIES 01-210-56-00-5620 OPERATING SUPPLIES FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 FY 2018 FV 2019. FY 2020 FY 2021 Actual Actual Budget Projected Adopted Projected Projected Projected Projected 1,307.670 1,478,093 1,614.448 1,614.448 1,730,357 1.789,795 1,843,489 1,898,794 1,955,758 193,668 322,269 346,100 346,106 358,1[19 370,410 1.81,522 392,968 404,757 426,8541 433,191 466386 466,386 479,680 492,020 506,781 521,984 537,644 115.872 121,384 130,409 130,404 141,315 146,252 150,640 155,159 159,814 21}959 21,429 20,000 .36,000 20,00(1 20,000 20,000 20,000 20,000 57,252 57,235 70,000 70,000 70,000 70,000 70,000 70,000 70,000 95,061 77,600 111,000 111,000 111,000 111,000 111,000 111,000 111,000 Ik,938 13,778 14,508 14,508 15,271 16,380 17,550 18,805 20,137 524.120 624,168 728,477 722,940 825,413 875,413 925,413 975,413 1,025,413 171,085 184,653 206,817 206,817 216,838 224,286 231,015 237,945 245,083 462.711 541,667 639,914 577,313 709,489 766,248 827,548 893,752 965,252 3;050 3,338 3,556 4,291 3,541 3,541 3,576 3,612 3,648 30,626 39,727 43,519 49,816 56,584 59,413 62,384 65,503 68,778 3,787 4,236 4,494 6.251 6,279 6,467 6,661 6,861 7,067 - - 2,800 2,800 31,096 17,848 2,800 2,800 2,800 4,590 12,633 4,000 4,000 4,000 15,000 4,000 4,000 15,000 12,935 11,184 18,000 18,000 18,000 18,000 18,000 18,000 18,000 3,963 2,400 10,000 10,000 10,000 10,000 10,000 10,000 10,000 - 63,777 203,647 200,158 53,633 44,633 44,633 44,633 44,633 517 - 200 200 200 200 200 200 200 2,370 3,222 4,500 4,500 4,500 4,500 4,500 4,500 4,500 24,048 25,663 36,500 36,500 36,500 36,500 36,500 36,500 36,500 1,218 987 1,600 1,600 1,600 1,600 1,600 1,600 1,600 4,315 2,175 1,350 1,350 1,350 1,350 1,350 1,350 1,350 11,249 15,288 20,000 20,000 35,000 29,000 29,000 29,000 29,000 - - 10,000 10,000 5,000 5,000 5,000 5,000 5;000 16,132 17,215 20,000 20,000 20,000 20,000 20,000 20,000 20,000 12,434 13,269 15,000 15,000 17,500 17,500 17,500 17,500 17,500 3,118 2,609 4,000 4,000 4,000 4,000 4,000 4,000 4,000 6,660 6,660 7,000 7,000 7,000 7,000 7,000 7,000 7,000 6,384 6,344 7,000 7,000 7,000 7,000 7,000 7,000 7,000 39,976 54,303 55,000 55,000 55,000 55,000 55,000 55,000 55,000 18,424 9,775 20,000 20,000 20,000 20,000 20,000 20,000 20,000 2,495 2,676 4,500 4,500 4,500 4,500 4,500 4,500 4,500 5,168 43,711 10,000 10,000 65,000 10,000 10,000 10,000 10,000 ius a FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY2021 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected 01-210-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 7,792 12,959 12,000 12,000 12,000 12,000 12,000 12,000 12,000 01-210-56-00-5640 REPAIR&MAINTENANCE 1,479 242 6,500 6,500 6,500 6,500 6,500 6,500 6,500 01-210-56-00-5650 COMMUNITY SERVICES 7,311 - 3,000 3,000 3,000 3,000 3,000 3,000 3,000 01-210-56-00-5690 BALISTIC VESTS 8,009 3,035 4,200 4,200 4,200 4,200 4,200 4,200 4,200 01-210-56-00-5695 GASOLINE 78,917 65,888 90,000 90,000 80,250 85,868 91,879 98,311 105,193 01-210-56-00-5696 AMMUNITION 2,990 16,368 8,000 8,000 8,000 8,000 8,000 8,000 8,000 3,812,134 4,315,151 4,978,431 4,915,593 5,254,785 5,399,424 5,585,741 5,806,390 6,046,827 a 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 2016 FY 2014 FY 2015 Adopted FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Expenditures Salaries 229,837 310,422 357,873 357,873 381,980 393,452 403,816 414,490 425,485 Benefits 104,751 139,045 150,555 151,132 163,247 174,468 186,337 199,082 212,730 Contractual Services 64,908 136,654 164,900 164,900 184,600 158,600 158,600 165,500 165,500 Supplies 8,042 6,467 11,900 11,900 11,175 10,762 10,962 11,176 11,405 Total Community Development 407,538 592,588 685,228 685,805 741,002 737,282 759,715 790,248 815,120 $1,000 r $800 ! 0 0 $600 $400 $200 $0 J 12 13 FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Community Development 01-220-50-00-5010 SALARIES&WAGES 218,262 292,601 309,873 309,873 333,980 345,452 355,816 366,490 377,485 01-220-50-00-5015 PART-TIME SALARIES 11,575 17,821 48.000 48,000 48,000 48,000 48,000 48,000 48,000 01-220-52-00-5212 RETIREMENT PLAN CONTRIBUTION 24,323 33,222 34,474 34,474 36,070 38,691 41,453 44,419 47,563 01-220-52-00-5214 FICA CONTRIBUTION 16,823 22,825 26,784 26,784 28,597 29,579 30,466 31,380 32,321 01-220-52-00-5216 GROUP HEALTH INSURANCE 59,831 76,809 82,828 82,665 90,833 98,100 105,948 114,424 123,578 01-220-52-00-5222 GROUP LIFE INSURANCE 359 443 447 491 445 445 449 453 458 01-220-52-00-5223 DENTAL INSURANCE 3,036 5,205 5,465 5,986 6,570 6,899 7,244 7,606 7,986 01-220-52-00-5224 VISION INSURANCE 379 541 557 732 732 754 777 800 824 01-220-54-00-5412 TRAINING&CONFERENCES 1,213 2666 5,500 5,500 6,500 6,500 6,500 6,500 6,500 01-220-54-00-5415 TRAVEL&LODGING 281 1,670 4,000 4,000 4,000 4,000 4,000 4,000 4,000 01-220-54-00-5426 PUBLISHING&ADVERTISING 1,371 218 1,000 1,000 1,000 1,000 1,000 1,000 1,000 01-220-54-00-5430 PRINTING&DUPLICATING 1,400 1,609 2,500 2,500 2,500 2,500 2,500 2,500 2,500 01-220-54-00-5440 TELECOMMUNICATIONS 2,198 2,533 3,000 3,000 3,000 3,000 3,000 3,000 3,000 01-220-54-00-5452 POSTAGE&SHIPPING 906 265 1,000 1,000 1,000 1,000 1,000 1,000 1,000 01-220-54-00-5459 INSPECTIONS 680 1,840 5,000 5,000 5,000 5,000 5,000 5,000 5,000 01-220-54-00-5460 DUES&SUBSCRIPTIONS 1,943 1,701 2,000 200. 2,000 2,000 2,000 2,000 2,000 01-220-54-00-5462 PROFESSIONAL SERVICES 5,030 73,607 61,000 61,000 41,000 15,000 15,000 15,000 15,000 01-220-54-00-5466 LEGAL SERVICES 485 277 2,000 2,000 2,500 2,500 2,500 2,500 2,500 01-220-54-00-5485 RENTAL&LEASE PURCHASE 2,601 3,468 2900 2.900 3,000 3,000 3,000 3,000 3,000 01-220-54-00-5486 ECONOMIC DEVELOPMENT 46,800 46,800 75,000 75,000 113,100 113,100 113,100 120,000 120,000 01-220-56-00-5610 OFFICE SUPPLIES 440 455 900 900 1,500 900 900 900 900 01-220-56-00-5620 OPERATING SUPPLIES 3,031 3,842 3,000 3,000 3,00.0 3,000 3,000 3,000 3,000 01-220-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 1,321 - 3,500 3,500 3,500 3,500 3,500 3,500 3,500 01-220-56-00-5645 BOOKS&PUBLICATIONS 366 - 500 500 500 500 500 500 500 01-220-56-00-5695 GASOLINE 2,884 2,170 4,000 2,675 2,862 3,062 3,276 3,505 407,538 592,588 685,228 685,805 741,002 737,282 759,715 790,248 815,120 13 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 2016 FY 2014 FY 2015 Adopted FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Expenditures Salaries 328,126 328,574 358,553 358,553 366,975 382,287 392,958 403,949 415,269 Benefits 162,447 169,806 183,177 179,628 202,031 214,538 229,550 245,686 262,989 Contractual Services 1,460,448 1,395,672 1,448,866 1,580,689 1,458,377 1,535,360 1,574,423 1,614,665 1,656,123 Supplies 94,029 83,640 94,311 94,311 92,836 95,417 98,162 101,083 104,191 Total Public Works 2,045,050 1,977,692 2,084,907 2,213,181 2,120,219 2,227,602 2,295,093 2,365,383 2,438,572 $3,000 N a $2,500 0 t $2,000 $1,500 $1,000 $500 $0 14 Account Number Description Public Works-Street Operations 01-410-50-00-5010 SALARIES&WAGES 01-410-50-00-5015 PART-TIME SALARIES 01-410-50-00-5020 OVERTIME 01-410-52-00-5212 RETIREMENT PLAN CONTRIBUTION 01410-52-00-5214 FICA CONTRIBUTION 01-410-52-00-5216 GROUP HEALTH INSURANCE 01-410-52-00-5222 GROUP LIFE INSURANCE 01-410-52-00-5223 DENTAL INSURANCE 01410-52-00.5224 VISION INSURANCE 01-410-54-00-5412 TRAINING&CONFERENCES 01.410-54-00-5415 TRAVEL&LODGING 01-010-54-00-5422 VEHICLE&EQUIPMENT CHARGEBACK 01-410-54-00-5435 TRAFFIC SIGNAL MAINTENANCE 01-410-54-00-5440 TELECOMMUNICATIONS 01-410-54-00-5446 PROPERTY&BLDG MAINT SERVICES 01-410-54-00-5455 MOSQUITO CONTROL 01-410-54-00-5458 TREE&STUMP MAINTENANCE 01410-54-00-5462 PROFESSIONAL SERVICES 01.410-54-00-5482 STREET LIGHTING 01-410-54-00-5485 RENTAL&LEASE PURCHASE 01-4]0-54-00-5490 VEHICLE MAINTENANCE SERVICES 01-410-56-00-5600 WEARING APPAREL 01-410-56-00-5620 OPERATING SUPPLIES 01-410-56-00-5626 HANGING BASKETS 01-410-56-00-5628 VEHICLE MAINTENANCE SUPPLIES 01-410-56-00-5630 SMALL TOOLS&EQUIPMENT 01410-56-00-5640 REPAIR&MAINTENANCE 01-410-56-00-5656 PROPERTY&BLDG MAINT SUPPLIES 01-410-56-00-5695 GASOLINE FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Budget I'rojcctrd Adopted Projected Projected Projected Projected 305,901 315,540 335,453 335,453 343,875 355,687 366,358 377,349 388,669 - 3,456 8,100 8,100 8,100 11,600 11,600 11,600 11,600 22,225 9,578 15,000 15,000 15,000 15,000 15,000 15,000 15,000 36,445 36,867 38,989 35,989 38,759 39,837 42,681 45,735 48,972 24,235 24,184 26,703 26,703 27,245 28,181 29,026 29,897 30,794 94,536 100,266 108,608 103,972 124,755 134,735 145,514 157,155 169,727 543 564 570 700 594 594 600 606 612 5,949 7,186 7,546 8,264 9,611 10,092 10,597 11,127 11,683 739 739 761 1,000 1,067 1,099 1,132 1,166 1,201 - 1,236 8,100 8,100 3,000 3,000 3,000 3,000 3,000 - 240 - - 2,000 2,000 2,000 2,000 2,000 144,650 125,000 163,416 240,337 45,000 84,065 84,065 84,065 84,065 8,390 16,824 17,000 19,000 25,000 25,000 25,000 25,000. 25,000 2,520 2,073 3,000 3,000 3,000 3,000 3,000 3,000 3,000 23,836 - - - _ - - - _ 6,865 6,865 8,400 7,002 7,352 7,720 8,106 8,511 8,937 20,000 - 20,000 20,000 20,000 20,000 20,000 20,000 20,000 2,052 3,740 6,400 6,400 3,S00 3,500 3,500 3,500 3,500 67,815 - - 4,750 4,750 4,750 4,750 4,750 4,750 984 512 1,100 1,100 1,100 1,100 1,100 1,100 1,100 53,541 57,838 30,000 30,000 50,000 50,000 50,000 50,000 50,000 3,263 4,132 4,410 4,410 4,631 4,863 5,106 5,361 5,629 10,378 10,846 10.500 10,500 11,025 11,576 12,155 12,763 13,401 - - - - 2,000 2,000 2,000 2,000 2,000 20,578 17,035 25,000 25,000 27,S00 27,500 27,500 27,500 27,500 1,006 2,105 5,000 5,000 2,000 2,000 2,000 2,000 2,000 21,235 26,791 20,000 20,000 20,000 20,000 20,000 20,000 20,000 5,877 - - _ _ - - 31,692 22,731 29,401 29,401 25,680 27,478 29,401 31,459 33,661 915,255 796,348 895,457 972,181 826,544 896,377 925,191 955,644 987,801 15 Account Number Description Public Works-Health&Sanitation 01-540-54-00-5441 GARBAGE SERVICES-SENIOR SUBSIDY O1-540-54-00-5442 GARBAGE SERVICES O1-540-54-00-5443 LEAP PICKUP Total Public Works FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Budget Projected Adopted Projected Projected Projected Projected 142,762 76,958 35,000 35,000 36,000 36,000 36,000 36,000 36,000 981,513 1,100,546 1,148,450 1,200,000 1,251,675 1,289,225 1,327,902 1,367,739 1,408,771 5,520 3,840 6,000 6,000 6,000 6,000 6,000 6,000 6,000 1,129,795 1,181,344 1,189,450 1,241,000 1,293,675 1,331,225 1,369,902 1,409,739 1,450,771 2,045,050 1,977,692 2,084,907 2,213,181 2,120,219 2,227,602 2,295,093 2,365,383 2,438,572 16 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,bad debt,engineering services,corporate legal expenditures and interfund transfers. FY 2016 FY 2014 FY 2015 Adopted FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Expenditures Salaries 600 - 500 2,829 500 500 500 500 500 Benefits 287,892 299,167 323,662 325,981 350,297 370,821 392,634 415,817 440,456 Contractual Services 2,395,270 2,416,880 2,534,703 2,512,567 2,500,063 2,543,349 2,558,412 2,605,362 2,639,947 Supplies 1,711 - 5,000 5,000 5,000 5,000 5,000 5,000 5,000 Contingencies 11,676 - - - - - - - - Other Financing Uses 3,790,688 2,486,885 2,439,756 2,456,533 2,631,459 2,854,307 2,910,946 2,968,458 3,032,557 Total Admin Services&Transfers 6,487,837 5,202,932 5,303,621 5,302,910 5,487,319 5,773,977 5,867,492 5,995,137 6,118,460 $7,000 $6,000 c $5,000 r ~ $4,000 $3,000 $2,000 $1,000 $0 17 Account Number Description Administrative Services FY 2015 01-640-50-00-5092 POLICE SPECIAL DETAIL WAGES 01-640-52-00-5230 UNEMPLOYMENT INSURANCE 01-640-52-00-5231 LIABILITY INSURANCE 01-640-52-00-5240 RETIREES-GROUP HEALTH INSURANCE 01-640-52-00-5241 RETIREES-DENTAL INSURANCE 01-640-52-00-5242 RETIREES-VISION INSURANCE 01-640-54-00-5418 PURCHASING SERVICES 01.640-54-00-5428 UTILITY TAX REBATE 01-640-54-00-5434 EXCISE TAX REBATE 01-640-54-00-5439 AMUSEMENT TAX REBATE 01-640-54-00-5449 KENCOM 01-640-54-00-5450 INFORMATION TECHNOLOGY SERVICES 01-640-54-00-5456 CORPORATE COUNSEL 01-640-54-00-5461 LITIGATION COUNSEL 01-640-54-00-5462 PROFESSIONAL SERVICES 01-640-54-00-5463 SPECIAL COUNSEL 01-640-54-00-5465 ENGINEERING SERVICES 01-640-54-00-5475 CABLE CONSORTIUM FEE 01-640-54-00-5481 HOTEL TAX REBATE 01-640-54-00-5489 LOSS ON INVESTMENT 01-640-54-00-5491 CITY PROPERTY TAX REBATE 01-640-54-00-5492 SALES TAX REBATE 01-640-54-00-5493 BUSINESS DISTRICT REBATE 01-640-54-00-5494 ADMISSIONS TAX REBATE 01-640-54-00-5499 BAD DEBT 01-640-56-00-5625 REIMBURSABLE REPAIRS 01-640-70-00-7799 CONTINGENCIES 01-640-99-00-9914 TRANSFER TO MUNICIPAL BUILDING 01.640-99-00-9915 TRANSFER TO MOTOR FUEL TAX 01-640-99-00-9916 TRANSFER TO CW BUILDINGS&GROUNDS 01-640-99-00-9923 TRANSFER TO CITY-WIDE CAPITAL 01-640-99-00-9942 TRANSFER TO DEBT SERVICE 01-640-99-00.9952 TRANSFER TO SEWER FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Budget Projected Adopted Projected Projected Projected Projected 600 - 500 2,829 500 500 500 500 500 5,241 7,950 20,000 10,000 20,000 20,000 20,000 20,000 20,000 246,339 249,686 265,000 277,319 293,958 311,595 330,291 350,108 371,114 35,091 40,078 37.570 37,570 35,725 38,583 41,670 45,004 48,604 1,061 1,293 972 972 539 566 594 624 655 160 160 120 120 75 77 79 81 83 - - - 50,000 50,000 50,000 50,000 50,000 - - 14,375 14,375 14,375 14,375 14,375 14375 - 42,787 - - - 22,130 48,513 50,000 55,000 55,000 55,000 25,000 25,000 25,000 25,295 72,999 100,000 72,679 75,000 82,500 90,750 99,825 109,808 38,867 51,066 99,225 99.225 80,000 84,000 88,200 92,610 97,241 89,253 129,599 121,275 121,275 127,339 133,706 140,391 147,411 154,782 147,253 56,874 120,000 120,000 120,000 120,000 120,000 120,000 120,000 2,872 26,020 25,000 25,000 25,000 25,000 25,000 25,000 25,000 597,697 503,943 •765,000 465,000 390,000 390,000 390,000 390,000 390,000 76,508 80,204 85,000 85,000 85,000 85,000 85,000 85,000 85,000 59,045 65,438 63,000 68,400 68,400 68,400 68,400 68,400 68,400 - 69,382 - - - _ _ 1,369 1,293 1,500 1,286 1,500 1,500 1,500 1,500 1,500 861,234 848,634 896,028 896,028 913,949 932,228 950,873 969,890 989;288 325,724 357,076 386,800 365,000 372,000 379,140 386,423 393,851 401,428 103,720 104,066 105,000 121,799 120,000 120,000 120,000 120,000 120,000 1,516 1,773 2,500 2,500 2,500 2,500 2,500 2,500 2,500 1,711 - 5,000 5,000 5,000 5,000 5,000 5,000 5,000 11,676 - - - - _ _ 571,615 - - - - • 323 - 20,000 25,023 - - _ • 49,795 62,000 62,000 49,500 54,500 54,500 54,500 54,500 270,401 - - - - - - - _ • - 132,103 131,380 268,178 313,275 317,775 317,075 316,275 1,137,220 1,133,972 1,134,654 1,134,654 1,134,052 1,137,166 1,133,782 1,134,114 1,137,948 18 19 FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected 01-640-99-00-9979 TRANSFER TO PARKS&RECREATION 1,765,504 1,277,606 1,076,831 1,076,831 1,118,638 1,311,784 1,365,172 1,420,789 1,479,455 01-640-99-00-9982 TRANSFER TO LIBRARY OPERATIONS 45,948 25,189 34,168 31,668 36,068 37,582 39,717 41,980 44,379 6,487,837 5,202,932 5,303,621 5,302,910 5,487,319 5,773,977 5,867,492 5,995,137 6,118,460 Expenditures 13,808,392 13,185,437 14,190,635 14,238,749 14,803,097 15,384,016 15,780,895 16,269,062 16,771,905 Surplus(Deficit) (363,247) 965,473 10,002 187,627 (286,275) (533,484) (640,662) (833,029) (1,034,856) Fund Balance 3,860,581 4,826,059 4,110,607 5,013,686 4,727,411 4,193,927 3,553,265 2,720,236 1,685,380 27.96% 3660% 28.97% 3521% 31.94% 27.26% 22.52% 16.72% 10.05% 19 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 2016 FY 2014 FY 2015 Adopted FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes 3,786 8,536 7,073 7,072 7,073 7,073 7,073 7,073 7,073 Investment Earnings 1 - - - - - - - - Total Revenue 3,787 8,536 7,073 7,072 7,073 7,073 7,073 7,073 7,073 Expenditures Contractual Services 7,776 4,208 29,833 34,674 4,833 5,800 5,800 5,800 5,800 Total Expenditures 7,776 4,208 29,833 34,674 4,833 5,800 5,800 5,800 5,800 Surplus(Deficit) (3,989) 4,328 (22,760) (27,602) 2,240 1,273 1,273 1,273 1,273 Ending Fund Balance 11,134 15,462 (7,693) (12,140) (9,900) (8,627) (7,354) (6,081) (4,808) 143.18% 367.44% -25.79% -35.01% -204.84% -148.74% -12679% -104.84% -82.90% W $20 M N $10 3 r $0 ($10) ($20) Fund Balance 20 Account Number Description Fox Hill SSA-11 FY 2016 11-000-40-004000 PROPERTY TAXES 11-000-45-00-4500 INVESTMENT EARNINGS Revenue 11-111-54-00-5417 TRAIL MAINTENANCE 11-111-54-00-5466 LEGAL SERVICES 11-111-54-00-5495 OUTSIDE REPAIR&MAINTENANCE Expenditures Surplus(Deficit) Fund Balance FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Budget Projected Adopted Projected Projected Projected Projected 3,786 1 8,536 7,073 7,072 7,073 7,073 7,073 7,073 7,073 3,787 8,536 7,073 7,072 7,073 7,073 7,073 7,073 7,073 - - 15.:nro 19.841 - - - - - 190 - - _ - _ _ _ - 7,586 4,208 14,833 14,833 4,833 5,800 5,800 5,800 5,800 7,776 4,208 29,833 34,674 4,833 5,800 5,800 5,800 5,800 (3,989) 4,328 (22,760) (27,602) 2,240 1,273 1,273 1,273 1,273 11,134 15,462 (7,693) (12,140) (9,900) (8,627) (7,354) (6,081) (4,808) 143.18% 367.44% -2579% -35.01% -204.84% -148.74% -126.79% -104,84% -82.901% 21 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 2016 FY 2014 FY 2015 Adopted FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes 7,467 17,417 18,608 18,608 20,392 20,392 20,392 20,392 20,392 Investment Earnings 2 - - - - - - - - Total Revenue 7,469 17,417 18,608 18,608 20,392 20,392 20,392 20,392 20,392 Expenditures Contractual Services 12,635 40,098 37,594 37,857 17,534 19,841 13,841 13,841 13,841 Total Expenditures 12,635 40,098 37,594 37,857 17,534 19,841 13,841 13,841 13,841 Surplus(Deficit) (5,166) (22,681) (18,986) (19,249) 2,858 551 6,551 6,551 6,551 Ending Fund Balance 2,574 (20,108) (49,980) (39,357) (36,499) (35,948) (29,397) (22,846) (16,295) 20.37% -50.15% -132.95% -103.96% -208.16% -181.18% -212.39% -165.06% -117.73% $20 Fund Balance 0 ($20) 22 23 FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Sunflower SSA-12 12-00040-004000 PROPERTY TAXES 7,467 17,417 18,608 18,608 20,392 20,392 20,392 20,392 20,392 12-00045-00-4500 INVESTMENT EARNINGS 2 - Revenue 7,469 17,417 18,608 18,608 20,392 20,392 20,392 20,392 20,392 12-112-54-00-5416 POND MAINTENANCE - 34,897 26,060 26,323 6,000 6,000 - - 12-112-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 12,635 5,201 11,534 11,534 11,534 13,841 13,841 13,841 13,841 Expenditures 12,635 40,098 37,594 37,857 17,534 19,841 13,841 13,841 13,841 Surplus(Deficit) (5,166) (22,681) (18,986) (19,249) 2,858 551 6,551 6,551 6,551 Fund Balance 2,574 (20,108) (49,980) (39,357) (36,499) (35,948) (29,397) (22,846) (16,295) 20.37% -50.1591 -132.95% -103.96% -208.16% -]81.18% -212.39% -165.06% -117.7391 23 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. Total Revenue 815,699 852,055 FY 2016 493,650 512,577 474,300 474,300 474,300 474,300 Expenditures Contractual Services Supplies Capital Outlay FY 2014 FY 2015 Adopted FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Total Expenditures Actual Actual Budget Projected Adopted Projected Projected Projected Projected Surplus(Deficit) (132,052) (110,173) (387,497) (208,200) (228,003) (223,258) (180,654) (130,167) - Revenue 1,030,456 920,282 589,656 712,082 484,079 260,821 80,167 (50,000) (50,000) Intergovernmental 812,172 837,536 483,500 473,350 487,254 474,000 474,000 474,000 474,000 Investment Earnings 3,417 3,307 500 300 300 300 300 300 300 Reimbursements 110 4,064 - - - - - - - Other Financing Sources - 7,148 - 20,000 25,023 - - - - Total Revenue 815,699 852,055 484,000 493,650 512,577 474,300 474,300 474,300 474,300 Expenditures Contractual Services Supplies Capital Outlay 7,750 107,617 832,384 116,902 190,820 654,506 117,210 203,000 551,287 117,210 203,000 381,640 123,793 193,000 423,787 130,771 193,000 373,787 138,167 193,000 323,787 138,507 193,000 272,960 146,817 193,000 134,483 Total Expenditures 947,751 962,228 871,497 701,850 740,580 697,558 654,954 604,467 474,300 Surplus(Deficit) (132,052) (110,173) (387,497) (208,200) (228,003) (223,258) (180,654) (130,167) - Ending Fund Balance 1,030,456 920,282 589,656 712,082 484,079 260,821 80,167 (50,000) (50,000) $1,200 $1,000 $800 r $600 ~ $400 $200 $0 ($200) Fund Balance 24 FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Motor Fuel Tax -15 15-000-41-00-4112 MOTOR FUEL TAX 15-000-41-00-4113 MITT HIGH GROWTH 15-00041-00-4168 STATE GRANTS-TRAFFIC SIGNAL MAINTENANCE 15-000-41-00-4172 ILLINOIS JOBS NOW PROCEEDS 15-000-41-00-4183 FEDERAL GRANTS-GAME FARM RD ROW 15-000-41-00-4184 STATE GRANTS-DOWNTOWN PARKING LOT 15-000-41-00-4185 STATE GRANTS-MATERIALS STORAGE FACILITY 15-000-41-00-4187 FEDERAL GRANTS-CANNONBALL LAFO 15-000-45-00-4500 INVESTMENT EARNINGS 15-000-45-00-4550 GAIN ON INVESTMENT 15-000-46-00-4690 REIMB-MISCELLANEOUS 15-000-49-00-4901 TRANSFER FROM GENERAL 15-000-49-00-4923 TRANSFER FROM CITY-WIDE CAPITAL 15-155-60-00-6089 Revenue 15-155-54-00-5438 SALT STORAGE 15-155-54-00-5482 STREET LIGHTING 15-155-54-00-5489 LOSS ON INVESTMENT 15-155-56-00-5618 SALT 15-155-56-00-5619 SIGNS 15-155-56-00-5633 COLD PATCH 15-155-56-00-5634 HOT PATCH 15-155-60-00-6003 MATERIAL STORAGE BLDG CONSTRUCTION 15-155-60-00-6004 BASELINE ROAD BRIDGE REPAIRS 15-155-60-00-6025 ROAD TO BETTER ROADS PROGRAM 15-155-60-00-6072 DOWNTOWN PARKING LOT 15-155-60-00-6073 GAME FARM ROAD PROJECT 15-155-60-00-6079 ROUTE 47 EXPANSION 15-155-60-00-6089 CANNONBALL LAFO PROJECT - Expenditures - Surplus(Deficit) 3,417 Fund Balance 417,742 414,685 412,500 420,000 41,814 41,892 41,000 41,912 8,000 8,000 - 7,837 73,122 146,244 - - 75,195 36,200 - - 204,299 177,949 - - - - 30,000 19,000 - 20,566 - 3,601 3,417 1,997 500 300 73,787 1,310 - 73,787 110 4,064 - - - 323 - 20,000 484,079 6,825 80,167 (50,000) 815,699 852,055 484,000 493,650 7,750 7,500 7,500 7,500 83,069 109;710 109,710 - 26,333 - - 74,070 152,585 150,000 150,000 5,708 8,153 15,000 1::000 12,088 12,413 19,000 19,000 15,751 17,669 19,000 19,000 - - 127,500 - - 830 50,000 2,019 193,042 269,813 300,000 300.000 312,552 148.100 - 6,577 169,890 73,450 - - 121,900 73,787 73,787 68,243 35,000 88,526 4,801 947,751 962,228 871,497 701,850 (132,052) (110,173) (387,497) (208,200) 1,030,456 920,282 589,656 712,082 25 438,254 425,000 425,000 425,000 41,000 41.,000 41,000 41,000 8,000 8,000 8,000 8,000 300 300 300 300 25,023 512,577 474,300 474,300 474,300 7,500 7,500 7,500 - 116,293 123,271 130,667 138,507 140,000 140,000 140,000 140,000 15,000 15,000 15,000 15,000 19,000 19,000 19,000 19,000 19,000 19,000 19,000 19,000 50,000 - - - 300,000 300,000 250,000 199,173 73,787 73,787 73,787 73,787 740,580 697,558 654,954 604,467 (228,003) (223,258) (180,654) (130,167) 484,079 260,821 80,167 (50,000) 425,000 41,000 8,000 300 474,300 146,817 140,000 15,000 19,000 19,000 60,696 73,787 474,300 (50,000) 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 2016 FY 2014 FY 2015 Adopted FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Intergovernmental 230,839 62,761 776,938 102,876 773,222 12,720 - - - Licenses&Permits 83,542 105,266 17,500 37,000 24,000 24,000 24,000 24,000 24,000 Charges for Service 684,319 693,467 680,000 681,600 681,600 681,600 681,600 681,600 681,600 Investment Earnings 204 10,424 1,000 1,200 600 - - - - Reimbursements 89,356 1,261,619 67,700 393,118 294,740 32,780 - - - Other Financing Sources 464,364 4,408,084 214,184 214,184 49,500 54,500 54,500 54,500 54,500 Total Revenue 1,552,624 6,541,621 1,757,322 1,429,978 1,823,662 805,600 760,100 760,100 760,100 Expenditures Contractual Services 94,194 295,580 86,025 61,125 61,225 61,225 61,225 61,225 61,225 Supplies - 5,971 27,500 27,500 15,000 20,000 20,000 20,000 20,000 Capital Outlay 1,033,122 2,147,884 5,375,823 2,992,904 3,313,308 766,146 463,900 353,687 354,537 Debt Service 75.000 75,000 408,356 405,937 404,138 403,588 407,563 322,188 321,338 Other Financing Uses 2,479 9,034 2,500 5,000 3,000 3,000 3,000 3,000 3,000 Total Expenditures 1,204,795 2,533,469 5,900,204 3,492,466 3,796,671 1,253,959 955,688 760,100 760,100 Surplus(Deficit) 347,829 4,008,152 (4,142,882) (2,062,488) (1,973,009) (448,359) (195,588) - - CW Municipal Building Fund Balance - - - - - - City-Wide Capital Fund Balance 676,555 4,684,706 831,196 2,622,218 649,209 200,850 5,262 5,262 5,261 Ending Fund Balance 676,555 4,684,706 831,196 2,622,218 649,209 200,850 5,262 5,262 5,262 Fund Balance $5,000 r m $4,000 3 °� $3,000 r $2,000 $1,000 $0 26 27 FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Account Num ber Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected City-Wide Capital-23 23-000-41-00-4161 FEDERAL GRANTS-ITEP DOWNTOWN - 42,461 40,000 28,000 4,000 - - - - 23-000-41-00.4162 FEDERAL GRANTS-RIVER RD BRIDGE 110,317 (9,411) - - - 23-000-41-00-4176 FEDERAL GRANTS-SAFE ROUTE TO SCHOOL 34,798 - - - - - 23-000-41-00-4178 FEDERAL GRANTS-ITEP KENNEDY RD TRAIL 85,724 29,711 29,800 22,800 114,160 12,720 - - - 23-000-41-004188 STATE GRANTS-EDP WRIGLEY(RTE 47) - 707,138 52,076 655,062 - 23-000-42-00 4210 BUILDING PERMITS - - - - - - - - - 23-000-42-00-4214 DEVELOPMENT FEES-CW CAPITAL 7,429 6,900 5.000 6,000 6,000 6,000 6,000 6,000 6,000 23-000-42-00-4216 BUILD PROGRAM PERMITS 71.,634 78,157 - - - - - - - 23-000-42-00-4218 DEVELOPMENT FEES-MUNICIPAL BLDG 2,479 2,209 2,500 5,006 3,000 3,000 3,000 3.,000 3,000 23-000-42-00-4222 ROAD CONTRIBUTION FEE 2,000 18,000 10,000 26,000 15,000 15,000 15,000 15,000 15,000 23-000-44-00-4440 ROAD INFRASTRUCTURE FEE 684,319 693,467 680,000 681,600 681,600 681,600 681,600 681,600 681,600 23-000-45-004500 INVESTMENT EARNINGS 204 4,423 1,000 1,200 600 - - - 23-000-45-004550 GAIN ON INVESTMENT - 6,001 - - - 23-000-46-00-4606 REIMB-COM ED - 93,095 - 316,905 - 23-000-46-00-4620 REIMB-PULTE(AUTUMN CREEK) 87,932 1,148,170 55 000 55,000 - - - - - 23-000-46-00-4660 REIMB-PUSH FOR THE PATH 1;424 7,727 12,700 19,700 294,740 32,780 - - - 23-000-46-00-4690 REIMB-MISCELLANEOUS - 12,627 - 1,513 - - - - - 23-000-49-00-4900 BOND PROCEEDS - 4,295,000 - - - - - 23-000-49-00-4903 PREMIUM ON BOND ISSUANCE - 49,789 - - - - - - - 23-000-49-00-4905 LOAN PROCEEDS-RIVER ROAD BRIDGE 193,963 - 152,184 152,184 - - - _ - 23-000-49-00-4916 TRANSFER FROM GENERAL-CW B&G - 49,795 62,000 62,000 49,500 54,500 54,500 54.,500 54,500 23.000-49-00-4923 TRANSFER FROM GENERAL-CW CAPITAL 270,401 - - - - - - - - 23-000-49-DO-4988 TRANSFER FROM DOWNTOWN TIF 13,500 Revenue 1,552,624 6,541,621 1,757,322 1,429,978 1,823,662 805,600 760,100 760,100 760,100 City-Wide-Building&Grounds Expenditures 23-216-54-00-5405 BUILD PROGRAM 2,400 6,000 - - - - - - 23-216.54-00-5446 PROPERTY&BLDG MAINT SERVICES - 37,824 34.500 34,500 34,500 34,500 34,500 34,500 34,500 23-216-56-00-5656 PROPERTY&BLDG MAINT SUPPLIES 5,971 277500 27,500 15,000 20,000 20,000 20,000 20,000 23-216-99-00-9901 TRANSFER TO GENERAL 2,479 2,209 2,500 5,000 3,000 3,000 3,000 3,000 3,000 4,879 52,004 64,500 67,000 52,500 57,500 57,500 57,500. 57,500 27 Account Number Description City-Wide Capital Expenditures 23-230-54-00-5402 BOND ISSUANCE COSTS 23-230-54-00-5405 BUILD PROGRAM 23-230-54-00-5465 ENGINEERING SERVICES 23-230-54-00-5489 LOSS ON INVESTMENT 23-230-54-00-5498 PAYING AGENT FEES 23-230-54-00-5499 BAD DEBT 23-230-60-00-6007 KENNEDY RD-AUTUMN CREEK 23-230-60-00-6008 BEECHER&CORNEHS ROAD 23-230-60-00-6009 WRIGLEY(RTE 47)EXPANSION 23-230-60-00-6016 US 34(CENTER/ELDAMAIN RD)PROJECT 23-230-60-00-6018 GREENBRIAR POND NATURALIZATION 23-230-60-00-6025 ROAD TO BETTER ROADS PROGRAM 23-230-60-00-6041 SIDEWALK CONSTRUCTION 23-230-60-00-6048 DOWNTOWN STREETSCAPE IMPROVEMENT 23-230-60-00-6058 ROUTE 71(RTE 471 ORCHARD RD)PROJECT 23-230-60-00-6059 US 34(11.47/ORCHARD RD)PROJECT 23-230-60-00-6073 GAME FARM ROAD PROJECT 23-230-60-00-6075 RIVER ROAD BRIDGE PROJECT 23-230-60-00-6082 COUNTRYSIDE PKY IMPROVEMENTS 23-230-60-00-6092 SAFE ROUTE TO SCHOOL PROJECT 23-230-60-00-6094 KENNEDY RD BIKE TRAIL 23-230-60-00-6095 SUNFLOWER ESTATES-DRAINAGEIMPROVEMENf 2014A Bond - 23-230-78-00-8000 PRINCIPAL PAYMENT 23-230-78-00-8050 INTEREST PAYMENT FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Budget Projected Adopted Projected Projected Projected Projected - 52,025 69,234 72,157 - - 21,792 5,856 50,000 25,000 25,000 25,000 25,000 25,000 25,000 - 120,631 - - - - - - - - - 525 525 525 525 525 525 525 768 1,087 1,000 1,100 1,200 1,200 1,200 1,200 1,200 88,105 1,067,717 55,000 55,000 - - - - - - 93,095 385,000 318,507 - - 707,138 52,076 655,062 - - - - - - - - 151,300 151,300 151,300 - - 18,769 14,000 12,524 4,000 4,000 - - - 605,242 405,718 500.000 500,000 950,000 250,000 96,854 189,887 342;037 2,916 8,065 12,500 12,500 12,500 12,500 12,500 12,500 12,500 - 53,077 45,000 5,000 - - - - - - - - - 110,400 - - - - - - 92,846 92,846 92,846 - 5,125 354,220 2,048,501 1,381,997 415,000 - - - - 221,880 - 152,184 152-184 - - - - 1,400,000 420,000 770,000 210,000 - - - 22,707 - - - - - - - 87,147 37,438 42,500 42,500 408,900 45,500 - - - - 109,785 9,000 616 - - - - - - - 135,000 135,000 185,000 190,000 190,000 195,000 200,000 - - 195,937 195,937 144,138 138,588 132,888 127,188 121,338 28 RE FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Kendall County Loan- River Road Bridge 23-230-97-00-8000 PRINCIPAL PAYMENT 75,000 75,000 77,419 75,000 75,000 75,000 84,675 - - 23-230-99-00-9915 TRANSFER TO MOTOR FUEL TAX 6,825 1,199,916 2,481,465 5,835,704 3,425,466 3,744,171 1,196,459 898,188 702,600 702,600 Expenditures 1,204,795 2,533,469 5,900,204 3,492,466 3,796,671 1,253,959 955,688 760,100 760,100 Surplus(Deficit) 347,829 4,008,152 (4,142,882) (2,062,488) (1,973,009) (448,359) (195,588) - - Fund Balance-CWMunicipal Building - - - - - - - - Fund Balance-Ch)yWsdeCapital 676,555 4,684,706 831,196 2,622,218 649,209 200,850 5,262 5,262 5,261 Fund Balance 676,555 4,684,706 831,196 2,622,218 649,209 200,850 5,262 5,262 5,262 RE W O � � � �-] '�v� � y � � n = 0 a o C n � m � �n � v � � y o m � �• '<° � y � a C, 8 o Pp $ g °o° y rnq v� fD C • cn R ?� A m w y C y C cr ZL Thousands W A a a 00. w l�n in Vii O M O O N O O O O O O per' p A a° N �n 10 A W V W W q to J 37, C A W O1 N �O ti N 1O IJ A p W O owo A O O` V N N v -1 N a N N W �O O O A A A �D v� O �' W N 2. UO1 o N 4 N A q O W `Otio N v� N y b y CD N R VI Q i -4 J A �n N w W O O .p A O oo cn N W O 1'i •r W P N J O to N O� N J A N Qi w �D Q• O N 'D O C C rn At � ,O „A v .- S W +w N J � � Q. T OE O O C)O w CD O In .,y O tPJ CL in O U �.n 00 N �..l W J vi N O N A A N A b �n w �A 3a �D to W in oo �O U W O W N v� 'D 8 O oo O O y Oil ro x• o r�D � �n v J K` �D tgii Z7, O p O O W O O W OC W C O S O W O O O � ro ivy ti 'O V Vi ... A n p 1 o °a a rn J b °o S o w w w S S o oho S v a O. N W N N b O A Vvi vii oAo n 0 " p, r O r - N O Q S O S LA W O w w N O S O S 10 O J N N J O O W W O w O to O �y V +. J A V to .-• \0 .-. A m' tj ro rn �. IW+ C C i .W-. O� N Oe �1 O rn p ?c < �C' y OD oo a J b �O '-n vi O O O W O W W S S O oo O v� G O � W Iv N b O vi N d A as i •- 0\ Q C O �1 Op O oo w N CC CO\ tJ �1 N ° Pi O w A A 3 10 �O H S S O W S W O S O oho S VJi Account Number Description Vehicle&Eauioment-25 25-00042-004215 DEVELOPMENT FEES-POLICE CAPITAL 25-000-42-00-4216 BUILD PROGRAM PERMITS 25-000-42-00-4217 WEATHER WARNING SIREN FEES 25-000.42-00-4218 ENGINEERING CAPITAL FEE 25-000-42-00-4219 DEVELOPMENT FEES-PW CAPITAL 25-000.42-00-4220 DEVELOPMENT FEES-PARK CAPITAL 25-000-43-00-4315 DUI FINES 25-00043-00-4316 ELECTRONIC CITATION FEES 25-000-03-00-4340 SEIZED VEHICLE PROCEEDS 25-000-44-00-4418 MOWING INCOME 25-000-44.00-4420 POLICE CHARGEBACK 25-000-44-00-0421 PUBLIC WORKS CHARGEBACK 25-000-44-00-4427 PARKS&RECREATION CHARGEBACK 25-000-45-00-4522 INVESTMENT EARNINGS-PARK CAPITAL 25-000-45-00-4550 GAIN ON INVESTMENT 25-000-46-00-4692 REIMB-MISCELLANEOUS-PARK CAPITAL 25-000-08-004852 MISCELLANEOUS INCOME-POLICE.CAPITAL 25-000-48-00-4854 MISCELLANEOUS INCOME-PW CAPITAL 25-000-49-00-4920 SALE OF CAPITAL ASSETS-POLICE CAPITAL 25-000-49-00-4921 SALE OF CAPITAL ASSETS-PW CAPITAL 25.00049-00-4922 SALE OF CAPITAL ASSETS-PARK CAPITAL 24,500 Revenue Police Capital 5,175 25-205-54-00-5405 BUILD PROGRAM 25-205.54-00.5462 PROFESSIONAL SERVICES 25-205-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 25-205-60-00-6060 EQUIPMENT 25-205-60-00-6070 VEHICLES FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Budget Projected Adopted Projected Projected Projected Projected 11,750 5,175 16,000 7,000 7,000 16,000 16,000 16,000 16,000 30,960 42,920 - - - - - _ - 12,264 - - - - - 3,400 1,300 6,500 3,000 3,000 6,000 6,000 6,000 6,000 16,390 9,655 24,500 15,000 15,000 24,500 24,500 24,500 24,500 1,650 650 2.275 1,000 1,000 2,275 2,275 2,275 2,275 7,569 5,545 7,000 7,000 7,000 7,000 7,000 7,000 7,000 684 720 750 700 700 700 700 700 700 - 2,916 5,000 2,500 2,500 2,500 2,500 2,500 2,500 12,845 3,288 6,000 2,983 3,000 3,000 3,000 3,000 3,000 - 63,777 203,647 200.158 53,633 44,633 44,633 44,633 44,633 144,650 125,000 163,416 240,337 45,000 84,065 84,065 84,065 84,065 - 109,650 - - - - _ _ _ 446 312 250 50 50 50 50 50 50 - 137 - - - - _ .. 50,000 97,771 - 4,064 191 - - - - - - _ 930 2,002 1,000 3,929 2,000 2,000 2,000 2,000 2,000 7,825 - 1,000 3,475 1,000 1,000 1,000 1,000 1,000 - 35,000 41,000 - - 800 305,427 471,009 472,338 528,932 140,883 193,723 193,723 193,723 193,723 4,800 10,350 - - - - - _ 95 1,166 1,667 833 833 833 833 833 833 17,626 4,287 16,000 16,000 16,000 16,000 16,000 16,000 16,000 - 32,865 35,000 35,000 - - - - - 93,750 79,377 169,000 169,000 55,000 55,000 55,000 55,000 55,000 116,271 128,045 221,667 220,833 71,833 71,833 71,833 71,833 71,833 31 Account Number Description Public Works Capital 25-225-54-00-5405 25-215-54-00-5405 BUILD PROGRAM 25-215-54-00-5448 FILING FEES 25-215-54-00-5485 RENTAL&LEASE PURCHASE 25-215-56-00-5620 OPERATING SUPPLIES 25-215-60-00-6060 EQUIPMENT 25-215-60-00-6070 VEHICLES 185 WoljStreet Building 25-225-60-00-6070 25-215-92-00-8000 PRINCIPAL PAYMENT 25-215-92-00-8050 INTEREST PAYMENT Parks&Recreation Capital 25-225-54-00-5405 BUILD PROGRAM 25-225-54-00-5489 LOSS ON INVESTMENT 25-225-60-00-6010 PARK IMPROVEMENTS 25-225-60-00-6030 BUILDING IMPROVEMENTS 25-225-60-00-6060 EQUIPMENT 25-225-60-00-6065 BRIDGE PARK 25-225-60-00-6068 TRAIL IMPROVEMENTS 25-225-60-00-6070 VEHICLES 185 Wolfftreet Building 25,360 25-225-92-00-8000 PRINCIPAL PAYMENT 25-225-92-00-8050 INTEREST PAYMENT 25-225-99-00-9972 TRANSFER TO LAND CASH Expenditures Surplus(Deficit) Fund Balance-Police Capital Fund Balance-Public Works Capital Fund Balance-Parks&Rec Capital Fund Balance FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Budget Projected Adopted Projected Projected Projected Projected 25,360 31,020 - - - - - - - 1,569 588 2,000 1,176 1,750 1,750 1,750 1,750 1,750 - - 4.500 - - - - - - - 499 2,000 3,929 2,000 2,000 2,000 2,000 2,000 48,689 163,750 - 15,084 - - - - - - - 185,000 143,574 45,000 45,000 45,000 45,000 45,000 33,184 37,924 39,638 39,638 41,430 43,303 45,261 47,307 49,446 42,870 32,892 31,177 31,177 29,385 27,512 25,554 23,508 21,369 151,672 266,673 264,315 234,578 119,565 119,565 119,565 119,565 119,565 800 1,550 - - - 2,753 862 801 12,143 33,731 78.000 74,216 - 78,206 - - - - 24,929 24,929 - - 25,000 25,000 1,040 1,188 1,242 1,242 1,343 1,031 977 977 50,000 318 424 65,326 118,459 130.1.1114 126.364 333,269 513,177 616,130 581,775 (27,842) (42,168) (143,792) (52,843) 39,371 74,301 (10,106) 51,565 34,073 125,683 (11 224) 1,169 147,746 105,577 (1,224) 52,734 32 1,298 1,357 1,418 1,482 1,549 921 862 801 737 670 2,219 2,219 2,219 2,219 2,219 193,617 193,617 193,617 193,617 193,617 (52,734) 106 106 106 106 106 111 318 414 - 106 212 318 424 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 2016 FY 2014 FY 2015 Adopted FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes 315,790 327,984 165,527 164,852 47,497 - - - - Licenses&Permits 6,358 7,418 4,500 6,640 5,000 7,000 7,000 7,000 7,000 Investment Earnings 78 5 - 11 - - - - - Other Financing Sources - 2,369,891 132,103 131,380 268,178 313,275 317,775 317,075 316,275 Total Revenue 322,226 2,705,298 302,130 302,883 320,675 320,275 324,775 324,075 323,275 Expenditures Contractual Services 775 39,617 525 475 525 525 525 525 525 Debt Service 328,179 304,042 310,250 310,250 320,150 319,750 324,250 323,550 322,750 Other Financing Uses - 2,359,115 - - - - - - - Total Expenditures 328,954 2,702,774 310,775 310,725 320,675 320,275 324,775 324,075 323,275 Surplus(Deficit) (6,728) 2,524 (8,645) (7,842) - - - - - Ending Fund Balance 5,319 7,842 33 Account Number Description Debt Service-42 42-00040-004000 PROPERTY TAXES-2014B BOND 42-00042-00-4208 RECAPTURE FEES-WATER&SEWER 42-00042-00-4216 BUILD PROGRAM PERMITS 42-000-45-00-4500 INVESTMENT EARNINGS 42-000-49-00-4901 TRANSFER FROM GENERAL 42-000-49-00-4902 BOND ISSUANCE 42-000-49-00.4903 PREMIUM ON BOND ISSUANCE Projected Revenue 42-420-54-00-5402 BOND ISSUANCE COSTS 42-420-54-00-5405 BUILD PROGRAM 42420-54-00-5498 PAYING AGENT FEES 2014B Refunding Bond - 42420-79-00-8000 PRINCIPAL PAYMENT 42-420-79-00-8050 INTEREST PAYMENT 2005A Bond 4,500 42-420-82-00-8000 PRINCIPAL PAYMENT 42-420-82-00-8050 INTEREST PAYMENT 42-420-99-00-9960 PAYMENT TO ESCROW AGENT Expenditures Surplus(Deficit) Fund Balance FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Budget Projected Adopted Projected Projected Projected Projected 315,790 327,984 165,527 164,852 47,497 - - - - 5,958 1,696 4,500 6,640 5,000 7,000 7,000 7,000 7,000 400 5,722 - - - - 78 5 11 - - 132,103 131,380 268,178 313,275 317,775 317,075 316,275 - 2,300,000 - - • - - _ 69,891 322,226 2,705,298 302,130 302,883 320,675 320,275 324,775 324,075 323,275 - 33,306 - - - - _ _ - 400 5,722 - - _ _ 375 589 525 475 525 525 525 525 525 - - 255.000 255;000 270,000 275,000 285,000 290,000 295,000 22,253 55,250 55,250 50,150 44,750 39,250 33,550 27,750 215,000 225,000 - 113,179 56,789 2,359,115 328,954 2,702,774 310,775 310,725 320,675 320,275 324,775 324,075 323,275 (6,728) 2,524 (8,645) (7,842) - - - - _ 5,319 7,842 34 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 2016 FY 2014 FY 2015 Adopted FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes 41,403 5,210 Licenses&Permits 84,544 112,323 - - - - - - - Charges for Service 2,309,950 2,513,791 3,240,437 3,278,400 301,400 3,761,400 3,761,400 4,178,850 4,658,918 Investment Earnings 2,231 2,034 500 3,100 1,000 500 500 500 500 Reimbursements 14,844 3,970 - - - - - - _ Miscellaneous 51,917 57,775 56,307 56,307 57,433 58,582 59,754 60,949 62,168 Other Financing Sources 82,988 1,373,687 4,376,275 4,369,998 75,075 73,875 77,675 73,875 75,125 Total Revenue 2,587,877 4,068,790 7,673,519 7,707,805 3,794,908 3,894,357 3,899,329 4,314,174 4,796,711 Expenses Salaries 338,959 354,098 411,332 411,332 416,844 429,727 441,365 453,352 465,699 Benefits 185,769 211,030 240,029 230,101 252,493 268,489 286,857 306,578 327,707 Contractual Services 540,175 609,139 816,370 789,626 544,927 561,735 579,551 598,436 617,864 Supplies 243,529 245,704 302,995 302,995 297,660 308,417 319,749 331,686 344,263 Capital Outlay 282,399 474,916 4,948,544 1,515,544 3,482,668 1,060,668 1,079,918 1,081,794 452,544 Debt Service 1,172,802 1,168,385 1,230,445 1,147,429 1,450,677 1,412,451 1,615,281 2,462,306 2,410,941 Other Financing Uses - 1,256,453 - - - - - - Total Expenses 2,763,633 4,319,725 7,949,715 4,397,027 6,445,269 4,041,487 4,322,721 5,234,152 4,619,018 Surplus(Deficit) (175,756) (250,935) (276,196) 3,310,778 (2,650,361) (147,130) (423,392) (919,978) 177,693 Ending Fund Balance Equivalent 1,350,923 1,099,988 558,007 4,410,766 1,760,405 1,613,275 1,189,883 269,905 447,598 48.88% 25.46% 7.02% 100.31% 27.31% 39.92% 27.53% 5.16% 9.69% y $5,000 Fund Balance Equivalent r $4,000 c $3,000 $2,000 $1,000 $0 Account Number Description Water-51 51-00040-00-4000 PROPERTY TAXES-2007A BOND 51-000-42-00-4216 BUILD PROGRAM PERMITS 51-000-44-00-4424 WATER SALES 51-000.44-00-4425 BULK WATER SALES 51-00044-004426 LATE PENALTIES-WATER 51-000-44-00-4430 WATER METER SALES 51-000-44-00-0440 WATER INFRASTRUCTURE FEE 51-000-44-00-4450 WATER CONNECTION FEES 51-000-45-00-4500 INVESTMENT EARNINGS 51-000-45-00-4550 GAIN ON INVESTMENT 51-000-46-00-4690 REIMB-MISCELLANEOUS 51-000-45-00-4820 RENTAL INCOME 51-00048-004850 MISCELLANEOUS INCOME 51-000-49-00-4900 BOND PROCEEDS 51-00049-00-4902 BOND ISSUANCE 51-000-49-00-4903 PREMIUM ON BOND ISSUANCE 51-00049-00-4952 TRANSFER FROM SEWER Revenue Water Operations 5,210 5.1-510.50-00-5010 SALARIES&WAGES 51-510-50-00-5015 PART-TIME SALARIES 51-510.50-00-5020 OVERTIME 51-510-52-00-5212 RETIREMENT PLAN CONTRIBUTION 51-510-52-00-5214 FICA CONTRIBUTION 51-510-52-00-5216 GROUP HEALTH INSURANCE 51-510-S2-00-5222 GROUP LIFE INSURANCE 51-510-52-00-5223 DENTAL INSURANCE 51-510-5Z-00-5224 VISION INSURANCE 51-510-52-00-5230 UNEMPLOYMENT INSURANCE 51-510-52-00-5231 LIABILITY INSURANCE 51-510-54-00-5402 BOND ISSUANCE COSTS 51-510-54-00-5405 BUILD PROGRAM 51-510-54-00-5412 TRAINING&CONFERENCES 51-510-54-00-5415 TRAVEL&LODGING FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Budget Projected Adopted Projected Projected Projected Projected 41,403 5,210 - - - - - 84,544 112,323 - - - - - - - 1,789,296 2,019,810 2,316,937 2,420,000 2,783,000 2,783,000 2,783,000 3,200,450 3,680,518 4,750 29,590 500 500 500 500 500 500 500 92,386 91,488 90,000 90,000 90,000 90,000 90,000 90,000 90,000 47,785 15,782 35,000 35,000 35,000 35,000 35,000 35,000 35,000 341,083 343,961 693,000 702,900 702,900 702,900 702,900 702,900 702,900 34,650 13,160 105,000 30,000 50,000 150,000 150,000 150,000 150,000 2,231 1,236 500 3,100 1,000. 500 500 500 500 - 798 - - -. - - 14,844 3,970 - - - - - - - 51,917 55,560 56,307 56.307 57,433 58,582 59,754 60,949 62,168 - 2,215 - - - - - - - - - 4,300,000 4,100,000 - - - - - - 1,263,500 - - 26,599 - 193,723 - - - - - 82,988 83,588 76,275 76,275 75,075 73,875 77,675 73,875 75,125 2,587,877 4,068,790 7,673,519 7,707,805 3,794,908 3,894,357 3,899,329 4,314,174 4,796,711 325,817 343,733 369,532 369,532 375,044 387,927 399,565 411,552 423,899 - 2,808 29,800 29,800 29,800 29,800 29,800 29,800 29,800 13,142 7,557 12,000 12,000 12,000 12,000 12,000 12,000 12,000 37,447 39,878 42,446 42,446 41,801 43,448 46,549 49,880 53,411 24,787 25,689 30,514 30,514 30,854 31,914 32,871 33,857 34,873 92,981 113,371 131.003 120-207 139,623 150,793 162,956 175,884 189,955 675 701 708 798 705 705 712 719 726 5,516 7,130 8,117 8,890 9,757 10,245 10,757 11,295 11,860 729 793 861 1,131 1,131 1,165 1,200 1,236 1,273 574 716 2,000 1,000 2,000 2,000 2,000 2,000 2,000 23,060 22,752 24,380 25,115 26,622 28,219 29,912 31,707 33,609 24,378 50,000 40,456 - - - - 84,544 112,323 - - - - - - 3,044 2,305 5,800 5,800 6,500 6,500 6,500 6,500 6,500 528 942 1,600 1.600 1,600 1,600 1,600 1,600 1,600 Account Number Description 51-510-54-00-5426 PUBLISHING&ADVERTISING 51-510-54-00-5429 WATER SAMPLES 51-510-54-00-5430 PRINTTNG&DUPLICATING 51-510-54-00-5440 TELECOMMUNICATIONS 51-510-54-00-5445 TREATMENT FACILITY SERVICES 51-510-54-00-5448 FILING FEES 51-510-54-00-5452 POSTAGE&SHIPPING 51-510-54-00-5460 DUES&SUBSCRIPTIONS 51-510.54-00-5462 PROFESSIONAL SERVICES 51-510-54-00-5465 ENGINEERING SERVICES 51-510-54-00-5466 LEGAL SERVICES 51-510-54-00-5480 UTILITIES 51-510-54-00-5483 JULIE SERVICES 51-510-54-00-5485 RENTAL&LEASE PURCHASE 51-510-54-00-5489 LOSS ON INVESTMENT 51-510-54-00-5490 VEHICLE MAINTENANCE SERVICES 51-510-54-00-5495 OUTSIDE REPAIR&MAINTENCE 51-510-54-00-5498 PAYING AGENT FEES 51-510-54-00-5499 BAD DEBT 51-510-56-00-5600 WEARING APPAREL 51-510-56-00-5620 OPERATING SUPPLIES 51-510-56-00-5628 VEHICLE MAINTENANCE SUPPLIES 51-510-56-00-5630 SMALL TOOLS&EQUIPMENT 51-510-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 51-510-56-00-5638 TREATMENT FACILITY SUPPLIES 51-510-56-00-5640 REPAIR&MAINTENANCE 51-510-56-00-5664 METERS&PARTS 51-510-56-00-5665 JULIE SUPPLIES 51-510-56-00-5695 GASOLINE 51-510-60-00-6022 WELL REHABILITATIONS 51-510-60-00-6025 ROAD TO BETTER ROADS PROGRAM 51-510-60-00-6059 US 34(II.47/ORCHARD RD)PROJECT 51-510-60-00-6060 EQUIPMENT 51-510-60-00-6066 RTE 71 WATERMAIN RELOCATION 51-510-60-00-6070 VEHICLES 51-510-60-00-6079 ROUTE 47 EXPANSION 51-510-60-00-6082 COUNTRYSIDE PKY IMPROVEMENTS FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Budget Projected Adopted Projected Projected Projected Projected 787 148 1,000 1,000 1,000 1.000 1,000 1,000 1,000 11,340 9,823 14,000 14,000 14,000 14,000 14,000 14,000 14,000 61 112 3,300 3,300 3,300 3,300 3,300 3,300 3,300 20,065 20,221 24,500 24,500 24,500 24,500 24,500 24,500 24,500 119,912 108,905 112,000 112,000 112,000 112,000 112,000 112,000 112,000 5,831 4,253 6,500 6,500 6,500 6,500 6,500 6,500 6,500 16,276 17,953 19,000 19,000 19,000 19,000 19,000 19,000 19,000 1,568 978 1,600 1,600 1,600 1,600 1,600 1,600 1,600 21,047 20,343 21,500 21,500 21,500 21,500 21,500 21,500 21,500 - - 250,000 234,800 - - - - - - - 2,000 2,000 2;000 2,000 2,000 2,000 2,000 218,.196 245,641 264,275 264,275 280,132 296,940 314,756 333,641 353,659 4,520 4,570 4,500 4,500 5,000 5,000 5,000 5,000 5,000 504 504 1,000 1;000 1,000 1,000 1,000 1,000 1,000 - 16,036 - - - - - - - 3,181 7,077 7,500 7,500 15,000 15,000 15,000 15,000 15,000 19,460 3,380 14,000 14,000 19,000 19,000 19,000 19,000 19,000 1,338 2,354 2,295 2,295 2,295 2,295 2,295 2,295 1,705 7,973 6,893 10,000 8,000 9,000 9,000 9,000 9,000 .9,000 3,340 3,434 4200 4,200 4,410 4,631 4,863 5,106 5,361 8,167 12,352 15,000 15,000 16,750 16,750 16,750 16,750 16,750 1,092 2,314 10,000 10,000 10,000 10,000 10,000 10,000 10,000 1,429 1,921 2,000 2.000 2,000 2,000 2,000 2,000 2,000 876 1,616 2,000 2,000 2,000 2;000 2,000 2,000 2,000 125,445 146,540 165,000 165,000 1.73,250 181,913 191,009 200,559 210,587 20,785 20,263 10,500 10,500 15,000 15,000 15,000 15,000 15,000 51,805 32,520 46,000 46,000 46,000 46,000 46,000 46,000 46,000 968 1,788 1,500 1,500 1,500 1,500 1,500 1,500 1,500 29,622 22,956 46,795 46,795 26,750 28,623 30,627 32,771 35,065 - - 143,000 143,000 - 166,000 124,000 148,000 - 153,305 277,372 300,000 300,000 250,000 250,000 250,000 250,000 250,000 - - - - 22,124 22,124 22,124 - - - - 5,000 5,000 5,000 5,000 5,000 5,000 5,000 - - 35,000 30,000 5,000 481,250 481,250 - - - 18,000 - 63,000 - - - - 129,094 197,544 P'T'.571 197,544 197,544 197,544 197,544 197,544 197,544 - - 4,250,000 840,000 2,940,000 420,000 - - - 37 Account Number Description 2015A Bond FY 2015 51-510-77-00-8000 PRINCIPAL PAYMENT 51-510-77-00-8050 INTEREST PAYMENT Debt Service-2007A Bond 51-510-83-00-8000 PRINCIPAL PAYMENT 51-510-83-00-8050 INTEREST PAYMENT Debt Service-2003 Debt Certificates 51-510-86-00-8000 PRINCIPAL PAYMENT 51-510-86-00-8050 INTEREST EXPENSE Debt Service-2006A Refunding Debt Certificates 51-510-87-00-8000 PRINCIPAL PAYMENT 51-510-87-00-8050 INTEREST EXPENSE Debt Service-2005C Bond 51-510-88-00-8000 PRINCIPAL PAYMENT 51-510-88-00-8050 INTEREST EXPENSE Debt Service-IEPA Loan L17-156300 51-510-89-00-8000 PRINCIPAL PAYMENT 51-510-89-00-8050 INTEREST EXPENSE Debt Service-2014C Refunding Bond 51-510-94-00-8000 PRINCIPAL PAYMENT 51-510-94-00-8050 INTEREST PAYMENT 51-510-99-00-9960 PAYMENT TO ESCROW AGENT Expenses Surplus(Deficit) Fund Balance Equiv FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Budget Projected Adopted Projected Projected Projected Projected - - - - 73,540 113,987 117,664 290,483 297,837 - - 83,016 - 229,137 161,053 156,493 151,787 140,167 15,000 15,000 15,000 15,000 15,000 15,000 15,000 680,000 695,000 123,041 122,423 121,793 121,793 121,163 120,525 119,888 119,250 90,350 100,000 100,000 100,000 100,000 100,000 100,000 300,000 - - 33,150 29,350 25,450 25,450 21,450 17,300 13,050 - - 405,000 420,000 435,000 435,000 460,000 475,000 495;000 850,000 850,000 205,606 189,406 172,606 172,606 155,206 136,806 117,806 98,006 62,306 95,000 100,000 - - - - - - - 70,975 54,065 - - - - - - 89,961 92;224 94,544 94,544 96,923 99,361 101,860 104,423 107,050 35,069 32,806 30,486 30,486 28,108 25,669 23,170 20,607 17,981 - - 120,000 120,000 120,000 120,000 130,000 125,000 130,000 - 13,111 32,550 32,550 30,150 27,750 25,350 22,750 20,250 1,256,453 2,763,633 4,319,725 7,949,715 4,397,027 6,445,269 4,041,487 4,322,721 5,234,152 4,619,018 (175,756) (250,935) (276,196) 3,310,778 (2,650,361) (147,130) (423,392) (919,978) 177,693 1,350,923 1,099,988 558,007 4,410,766 1,760,405 1,613,275 1,189,883 269,905 447,598 48.88% 25.46% -tr:': 100.3191, 27.31% 39.92% 27.53% 5.16% 9.69% 38 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. Expenses FY 2016 Salaries FY 2014 FY 2015 Adopted FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Benefits Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue 75,530 164,251 82,845 102,377 119,463 123,243 127,230 131,438 135,287 Taxes 110,601 - - - - - - - 93,116 Licenses&Permits 16,800 35,000 - - - - - - - Charges for Service 1,114,432 1,151,713 1,180,200 1,173,334 1,199,942 1,246,076 1,272,062 1,298,734 1,326,206 Investment Earnings 9,260 9,176 1,500 1,100 1,000 500 500 500 500 Reimbursements 1,300 2,360 200,000 201,175 200,000 200,000 200,000 200,000 200,000 Other Financing Sources 1,137,220 1,243,972 1,134,654 1,134,654 1,134,052 1,137,166 1,133,782 1,134,114 1,137,948 Total Revenue 2,389,613 2,442,221 2,516,354 2,510,263 2,534,994 2,583,742 2,606,344 2,633,348 2,664,654 Expenses Salaries 164,273 187,301 205,003 205,003 216,289 223,650 230,300 237,149 244,203 Benefits 80,030 92,443 127,049 98,969 110,254 117,398 125,184 133,531 142,457 Contractual Services 75,530 164,251 82,845 102,377 119,463 123,243 127,230 131,438 135,287 Supplies 66,064 38,300 92,610 92,610 84,206 86,217 88,366 90,662 93,116 Capital Outlay 66,773 808,520 459,015 459,015 460,282 460,282 460,282 459,015 459,015 Developer Commitments - 62,922 32,891 32,891 33,872 34,888 35,939 28,204 - Debt Service 1,968,119 2,054,461 1,865,399 1,865,399 1,865,857 1,877,110 1,880,265 1,352,307 1,300,798 Other Financing Uses 82,988 83,588 76,275 76,275 75,075 73,875 77,675 73,875 75,125 Total Expenses 2,503,777 3,491,786 2,941,087 2,932,539 2,965,298 2,996,663 3,025,241 2,506,181 2,450,001 Surplus(Deficit) (114,164) (1,049,565) (424,733) (422,276) (430,304) (412,921) (418,897) 127,167 214,653 Ending Fund Balance Equivalent 2,879,170 1,829,603 1,368,893 1,407,327 977,023 564,102 145,205 272,372 487,025 114.99% 52.40% 46.54% 47.99% 32.95% 18.82% 4.80% 10.87% 19.88% $4,000 N $3,000 0 0 r $2,000 $1,000 $0 Fund Balance Equivalent 39 Account Number Description Sewer-52 52-00040-00-4000 PROPERTY TAXES-2004B BOND 52-00042-00-4216 BUILD PROGRAM PERMITS 52-00044-00-4435 SEWER MAINTENANCE FEES 52-000-44-004440 SEWER INFRASTRUCTURE FEE 52-000-44-00-4455 SW CONNECTION FEES-OPERATIONS 52-000-44-00-4456 SW CONNECTION FEES-CAPITAL 52-000-44-00-4462 LATE PENALTIES-SEWER 52-000-44-00-4465 RIVER CROSSING FEES 52-000-45-00-4500 INVESTMENT EARNINGS 52-000-45-00-4550 GAIN ON INVESTMENT 52-000-46-00-4625 REIMB-I&I REDUCTIONS 52-000-46-00-4690 REIMB-MISCELLANEOUS 52-000-49-00-4901 TRANSFER FROM GENERAL 52-000-49-00-4910 SALE OF CAPITAL ASSETS 52-520-54-00-5430 Revenue Sewer Operations FY 2015 52-520-50-00-5010 SALARIES&WAGES 52-520-50-00-5020 OVERTIME 52-520-52-00-5212 RETIREMENT PLAN CONTRIBUTION 52-520-52-00-5214 FICA CONTRIBUTION 52-520-52-00-5216 GROUP HEALTH INSURANCE 52-520-52-00-5222 GROUP LIFE INSURANCE 52-520-52-00-5223 DENTAL INSURANCE 52-520-52-00-5224 VISION INSURANCE 52-520-52-00-5230 UNEMPLOYMENT INSURANCE 52-.520-52-00-5231 LIABILITY INSURANCE 52-520-54-00-5405 BUILD PROGRAM 52-520-54-00-5412 TRAINING&CONFERENCES 52-520-54-00-5415 TRAVEL&LODGING 52-520-54-00-5430 PRINTING&DUPLICATING 52-520-54-00-5440 TELECOMMUNICATIONS 52-520-54-00-5444 LIFT STATION SERVICES 52-520-54-00-5462 PROFESSIONAL SERVICES FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 FY 2018 FY 2019 F V 2020 FY 2021 Actual Actual Budget Projected Adopted Projected Projected Projected Projected 110,601 - 16,800 35,000 - - - - - _ _ 756,746 790,556 802,200 813,660 837,942 863,076 889,062 915,734 943,206 333,587 341,199 340,000 340,000 340,000 340,000 340,000 340,000 340,000 800 600 5,000 750 2,000 5,000 5,000 5,000 5,000 9,200 5,400 20,000 5,000 7,000 25,000 25,000 25,000 25,000 13,821 13,634 13,000 13,000 13,000 13,000 13,000 13,000 13,000 278 324 - 924 - - - - _ 9,260 5,427 1,500 1,100 1,000 500 500 500 500 - 3,749 - - - - _ _ _ - - 200,000 200,000 200,000 200,000 200,000 200,000 200,000 1,300 2,360 - 1,175 - - - _ - 1,137,220 1,133,972 1,134,654 1,134,654 1,134,052 1,137,166 1,133,782 1,134,114 1,137,948 110,000 2,389,613 2,442,221 2,516,354 2,510,263 2,534,994 2,583,742 2,606,344 2,633,348 2,664,654 164,160 187,220 203,003 203,003 214,289 221,650 228,300 235,149 242,203 113 81 1000 2,000. 2,000 2,000 2,000 2,000 2,000 18,268 21,410 22,901 22,807 23,359 24;825 26,597 28,500 30,518 12,371 14;093 15,177 15,177 16,195 16,731 17,233 17,750 18,283 32,305 40,589 70,903 43,021 51,144 55,236 59,655 64,427 69,581 265 328 373 409 371 371 375 379 383 2,006 3,215 4,650 4,244 4,658 4,891 5,136 5,393 5,663 277 407 479 552 552 569 586 604 622 302 376 1,000 500 1,000 1,000 1,000 1,000 1,000 14,236 12,025 11,660 12,259 12,995 13,775 14,602 15,478 16,407 16,800 35,000 - - - - _ _ _ - 1,504 2,300 2,300 3,300 3,300 3,300 3,300 3,300 - 240 500 500 500 500 500 500 500 28 30 1,700 1.700 1,700 1,700 1,700 1,700 1,700 1,848 1,895 2,500 2,500 2,500 2,500 2,500 2,500 2,500 18,582 8,589 21,365 21,365 37,433 39,305 41,270 43,334 45,501 4,917 6,861 8,000 8,000 8,000 8,000 8,000 8,000 8,000 40 41 FY 2014 FV 2015 FY 2016 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected 52-520-54-00-5480 UTILITIES 24,674 20,258 30,000 30,000 31,800 33,708 35,730 37,874 40,146 52-520-54-00-5485 RENTAL&LEASE PURCHASE 504 504 1,500 1,500 1,000 1,000 1,000 1,000 1,000 52-520-54-00-5489 LOSS ON INVESTMENT - 75,369 - - - - - - 52-520-54-00-5490 VEHICLE MAINTENANCE SERVICES 1,663 4,447 5,000 5,000 12,000 12,000 12,000 12,000 12,000 52-520-54-00-5495 OUTSIDE REPAIR&MAINTENCE 2,100 6,512 4,000 24,532 16,000 16,000 16,000 16,000 16,000 52-520-54-00-5498 PAYING AGENT FEES 2,920 1,277 2,980 2,980 2,980 2,980 2,980 2,980 2,390 52-520-54-00-5499 BAD DEBT 1,494 1,765 3,000 2000, 2,250 2,250 2,250 2,250 2,250 52-520-56-00-5600 WEARING APPAREL 2,930 2,585 2,625 2,625 2,756 2,894 3,039 3,191 3,351 52-520-56-00-5610 OFFICE SUPPLIES 2,342 517 2,000 2,000 2,000 2,000 2,000 2,000 2,000 52-520-56-00-5613 LIFT STATION MAINTENANCE 2,682 5,012 12,000 12,000 12,000 12,000 12,000 12,000 12,000 52-520-56-00-5620 OPERATING SUPPLIES 3,959 4,828 4,500 4,500 5,000 5,000 5,000 5,000 5,000 52-520-56-00-5628 VEHICLE MAINTENANCE SUPPLIES 3,557 1,315 2,000 2,000 2,000 2,000 2,000 2,000 2,000 52-520-56-00-5630 SMALL TOOLS&EQUIPMENT 7,867 1,109 2,500 2,500 2,500 2,500 2,500 2,500 2,500 52-520-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 225 259 1,200 1,200 1,200 1;200 1,200 1,200 1,200 52-520-56-00-5640 REPAIR&MAINTENANCE 12,777 1,301 30,000 30,000 30,000 30,000 30,000 30,000 30,000 52-520-56-00-5695 GASOLINE 29,725 21,374 35..785 35,785 26,750 28,623 30,627 32,771 35,065 52-520-60-00-6025 ROAD TO BETTER ROADS PROGRAM - 251,677 200,000 200,000 200,000 200,000 200,000 200,000 200,000 52-520-60-00-6028 SANITARY SEWER LINING - 98,029 200,000 200,000 200,000 200,000 200,000 200,000 200,000 52-520-60-00-6059 US 34(IL 471 ORCHARD RD)PROJECT - - - - 1,267 1,267 1,267 - - 52-520-60-00-6070 VEHICLES - 379,986 - - - - - - - 52-520-60-00-6079 ROUTE 47 EXPANSION 66,773 78,828 59,015 59,015 59,015 59,015 59,015 59,015 59,015 52-520-75-00-7500 LENNAR-RAINTREE SEWER RECPATURE - 62,922 32,891 32,891 33,872 34,888 35,939 28,204 - Debt Service-2004B Bond 52-520-84-00-8000 PRINCIPAL PAYMENT 280,000 375,000 395,000 395,000 410,000 435,000 455,000 - - 52-520-84-00-8050 INTEREST EXPENSE 88;750 78,950 65,825 65,825 52,000 35,600 18,200 - - Debt Service-2003A IRBB Debt Certificates 52-520-90-00-8000 PRINCIPAL PAYMENT 100,000 105,000 110,000 110,000 115,000 120,000 130,000 135,000 140,000 52-520-90-00-8050 INTEREST EXPENSE 62,048 57,648 52,870 52,870 47,755 42,293 36,233 29,668 22,850 Debt Service-2004A Debt Certificates 52-520-91-00-8000 PRINCIPAL PAYMENT 180,000 190,000 - - - - 52-520-91-00-8050 INTEREST EXPENSE 13,050 6,840 - - - - - - - Debt Service-2011 Refunding Bond 52-520-92-00-8000 PRINCIPAL PAYMENT 660,000 685,000 715,000 715,000 745,000 780,000 810,000 845,000 885,000 52-520-92-00-8050 INTEREST EXPENSE 477,220 448,972 419,654 419,654 389,052 357,166 323,782 289,114 252,948 41 42 FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Debt Service-IEPA Loan L17-115300 52-520-96-00-8000 PRINCIPAL PAYMENT 90,952 93,355 95,821 95,821 98,353 100,952 103,619 52,832 - 52-520-96-00-8050 INTEREST EXPENSE 16,099 13,696 11,229 11,229 8,697 6,099 3,431 693 - 52-520-99-00-9951 TRANSFER TO WATER 82,988 83,588 76'75 76,275 75,075 73,875 77,675 73,875 75,125 Expenses 2,503,777 3,491,786 2,941,087 2,932,539 2,965,298 2,996,663 3,025,241 2,506,181 2,450,001 Surplus(Deficit) (114,164) (1,049,565) (424,733) (422,276) (430,304) (412,921) (418,897) 127,167 214,653 Fund Balance Equiv 2,879,170 1,829,603 1,368,893 1,407,327 977,023 564,102 145,205 272,372 487,025 114.99% 52.40% 4654% 47.99% 31.95% 18.81% 4.80% 10.87% 19.88% 42 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. Expenditures Contractual Services 1,733 8,407 - - - - - -Capital Outlay 69,304 235,021 580,832 45,512 453,855 330,832 72,734 - - Total Expenditures 71,037 243,428 580,832 45,512 453,855 330,832 72,734 - - Surplus(Deficit) 66,565 (70,555) (150,332) 67,745 35,145 (293,832) 364,266 35,000 35,000 Ending Fund Balance 187,984 117,430 (185,167) 185,175 220,320 (73,512) 290,754 325,754 360,754 $400 M N $200 3 r $0 ($200) ($400) 43 Fund Balance FY 2016 FY 2014 FY 2015 Adopted FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Intergovernmental 31,286 40,144 400,000 - 400,000 - 400,000 - - Licenses&Permits 1,733 8,407 - - - - - - - Investment Earnings 4 - - - - - - - - Land Cash Contributions 54,579 40,997 30,500 113,257 39,000 37,000 37,000 35,000 35,000 Reimbursements - 83,311 - - 50,000 - - - - Miscellaneous - 14 - - - - - - - Other Financing Sources 50,000 - - - - - - - - Total Revenue 137,602 172,873 430,500 113,257 489,000 37,000 437,000 35,000 35,000 Expenditures Contractual Services 1,733 8,407 - - - - - -Capital Outlay 69,304 235,021 580,832 45,512 453,855 330,832 72,734 - - Total Expenditures 71,037 243,428 580,832 45,512 453,855 330,832 72,734 - - Surplus(Deficit) 66,565 (70,555) (150,332) 67,745 35,145 (293,832) 364,266 35,000 35,000 Ending Fund Balance 187,984 117,430 (185,167) 185,175 220,320 (73,512) 290,754 325,754 360,754 $400 M N $200 3 r $0 ($200) ($400) 43 Fund Balance FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Land Cash-72 72-00041-004174 RTP GRANT-CLARK PARK 31,286 40,144 - - 72-000-41-00-4175 OSLAD GRANT-RIVERFRONT PARK - - 400,000 - 72-000-41-00-4186 OSLAD GRANT-BRISTOL BAY - - - 30,000 72-000-42-00-4216 BUILD PROGRAM PERMITS 1,733 8,407 - - 72-000-45-00-4500 INVESTMENT EARNINGS 4 - _ _ 72-000-46-00-4655 REIMB-GRANDE RESERVE PARK - 83,311 - - 72-000-47-004701 WHITE OAK - 1,406 - - 72-00047-004703 AUTUMN CREEK 42,367 30,320 30,000 30,000 72-000-47-00-4704 BLACKBERRY WOODS 2,841 7,386 500 7,386 72-000-47-00-4708 COUNTRY HILLS - - - 3,076 72-000-47-00-4711 FOX HIGHLANDS DETENTION - - - 1,406 72-00047-00-4713 PRESTWICK - - - 67.600 72-000-47-00-4736 BRIARWOOD 9,371 1,885 - 3,789 72-000-48-00-4850 MISCELLANEOUS INCOME 14 - 72-000.49-00-4925 TRANSFER FROM VEHICLE&EQUIPMENT 50,000 Revenue 137,602 172,873 430,500 113,257 72-720-54-00-5405 BUILD PROGRAM 1,733 8,407 - - 72-720-60-00-6028 CANNONBALL PARK 16,897 - - - 72-720-60-00-6032 MOSER HOLDING COSTS 12,000 - 13,000 13,000 72-720-60-00-6043 BRISTOL BAY REGIONAL PARK 3,406 32,434 292,832 2,000 72-720-60-00-6044 CLARK PARK 31,613 20,661 - _ 72-720-60-00-6045 RIVERFRONT PARK 4,650 29,495 200,000 5,362 72-720-60-00-6046 GRANDE RESERVE PARK A - 380 50,000 25,000 72-720-60-00-6047 GRANDE RESERVE PARK B 738 146,021 150 72-720-60-00-6067 BLACKBERRY CREEK NATURE PRESERVE 6,030 25,000 Expenditures 71,037 243,428 580,832 45,512 Surplus(Deficit) 66,565 (70,555) (150,332) 67,745 Fund Balance 187,984 117,430 (185,167) 185,175 44 400,000 - - - - 400,000 - - 50,000 30,000 30,000 30,000 30,000 30,000 5,000 5,000 5,000 5,000 5,000 2,000 - - _ _ 2,000 2,000 2,000 - - 489,000 37,000 437,000 35,000 35,000 13,000 13,000 - 292,832 72,734 - - 365,855 » 75,000 25,000 453,855 330,832 72,734 - - 35,145 (293,832) 364,266 35,000 35,000 220,320 (73,512) 290,754 325,754 360,754 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. $600 Fund Balance $400 $200 $0 FY 2016 FY 2014 FY 2015 Adopted FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Charges for Service 299,478 352,714 325,000 351,000 355,000 355,000 355,000 355,000 355,000 Investment Earnings 382 698 400 375 350 350 350 350 350 Reimbursements 35,728 7,502 - - - - - - - Miscellaneous 188,824 177,755 181,000 191,000 181,000 181,000 181,000 181,000 181,000 Other Financing Sources 1,765,504 1,277,606 1,076,831 1,076,831 1,118,638 1,311,784 1,365,172 1,420,789 1,479,455 Total Revenue 2,289,916 1,816,275 1,583,231 1,619,206 1,654,988 1,848,134 1,901,522 1,957,139 2,015,805 Expenditures Salaries 708,142 775,138 863,462 863,462 816,544 839,601 860,416 881,852 903,926 Benefits 312,171 338,380 382,912 342,752 385,075 408,580 436,702 466,914 499,292 Contractual Services 217,004 374,840 234,780 239,780 260,710 261,982 263,330 264,759 266,274 Supplies 337,444 316,864 314,486 319,486 334,666 331,513 333,484 335,588 337,833 Other Financing Uses 489,043 - - - - - - - - Total Expenditures 2,063,804 1,805,222 1,795,640 1,765,480 1,796,995 1,841,676 1,893,932 1,949,113 2,007,325 Surplus(Deficit) 226,112 11,053 (212,409) (146,274) (142,007) 6,458 7,590 8,026 8,480 Ending Fund Balance 546,485 557,536 269,391 411,262 269,255 275,713 283,303 291,329 299,809 2648% 30.88% 15.00% 23.29% 14.98% 14.97% 14.96% 14.95% 14.94% $600 Fund Balance $400 $200 $0 FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Parks and Recreation-79 79-000-44-00-4402 SPECIAL EVENTS 47,745 72,025 60,000 80,000 80,000 80,000 80,000 80,000 80,000 79-000-44-00-4403 CHILD DEVELOPMENT 81,114 103,683 90,000 100,000 100,000 100,000 100,000 100,000 100,000 79-00044-00-4404 ATHLETICS&FITNESS 139,158 147,481 145,000 145,000 145,000 145,000 145,000 145,000 145,000 79-000-44-00-4441 CONCESSION REVENUE 31,461 29,525 30,000 26,000 30,000 30,000 30,000 30,000 30,000 79-000-45-004500 INVESTMENT EARNINGS 382 698 400 375 350 350 350 350 350 79-000-46-004690 REIMB-MISCELLANEOUS 35,728 7,502 - - - - - - - 79-000-48-00.4820 RENTAL INCOME 52,859 44,860 40,000 50,000 50,000 50,000 50,000 50,000 50,000 79-000-48-00-4825 PARK.RENTALS 34,559 28;928 25,000 20,000 5,000 5,000 5,000 5,000 5,000 79-000-48-00-4843 HOMETOWN DAYS 90,597 88,475 108,000 108,000 108,000 108,000 108,000 108,000 108,000 79-000-48-00-4846 SPONSORSHIPS&DONATIONS 4,582 Q317 5,000 10,000 15,000 15,000 15,000 15,000 15,000 79-000-48-00-4850 MISCELLANEOUS INCOME 6,227 6,175 3 000 3,000 3,000 3,000 3.,000 3,000 3,000 79-000-49-00-4901 TRANSFER FROM GENERAL 1,765,504 1,277,606 1,076,831 1,076,831 1,118,638 1,311,784 1,365,172 1,420,789 1,479,455 Revenue 2,289,916 1,816,275 1,583,231 1,619,206 1,654,988 1,848,134 1,901,522 1,957,139 2,015,805 Parks Department 79-790-50-00-5010 SALARIES&WAGES 410,777 448,491 477,325 477,325 405,322 419,245 431,822 444,777 458,120 79-790-50-00-5015 PART-TIME SALARIES 17,207 32,644 30,000 30,000 40,178 39,996 39,826 39,650 39,466 79-790-50-00-5020 OVERTIME 514 932 3,000 3,000 3,000 3,000 3,000 3,000 3,000 79-790-52-00-5212 RETIREMENT PLAN CONTRIBUTION 46,293 51,195 53,437 53,437 44,098 46,955 50,307 53,907 57,723 79-790-52-00-5214 FICA CONTRIBUTION 31,909 36,172 38,169 38,169 33,797 34,958 36,007 37,087 38,200 79-790-52-00-5216 GROUP HEALTH INSURANCE 109,505 109,775 131,148 102,000 126,121 136,211 147,108 158,877 171,587 79-790-52-00-5222 GROUP LIFE INSURANCE 878 942 951 790 724 724 731 738 745 79-790-52-00-5223 DENTAL INSURANCE 6,873 8,959 9,706 7,519 9,119 9,575 10,054 10,557 11,085 79-790-52-00-5224 VISION INSURANCE 957 940 1,002 947 1,023 1,054 1,086 1,119 1,153 79-790-54-00-5412 TRAINING&CONFERENCES 1,663 3,045 10,000 10,000 7,000 7,000 7,000 7,000 7,000 79-790-54-00-5415 TRAVEL&LODGING 114 453 3.000 3,000 3;000 3,000 3,000 3,000 3,000 79-790-54-00-5422 VEHICLE&EQUIPMENT CHARGEBACK - 109,650 - - - - - - 79-790-54-00-5440 TELECOMMUNICATIONS 3,913 3,776 4,780 4,780 3,510 3,510 3,510 3,510 3,510 79-790-54-00-5462 PROFESSIONAL SERVICES 1,786 4,229 3,000 3,000 3,000 3,000 3,000 3,000 3,000 79-790-54-00-5466 LEGAL SERVICES 5,216 12,084 6,000 6,000 6,000 6,000 6,000 6,000 6,000 79-790-54-00-5485 RENTAL&LEASE PURCHASE 2,600 1,192 2,500 2,500 2,500 2,500 2,500 2,500 2,500 79-790-54-00-5495 OUTSIDE REPAIR.&MAINTENANCE 37,059 41,995 32,500 32,500 47,500 47,500 47,500 47,500 47,500 79-790-56-00-5600 WEARING APPAREL 4,806 4,643 4,935 4,935 5,182 5,441 5,713 5,999 6,299 79-790-56-00-5610 OFFICE SUPPLIES 71 85 300 300 300 300 300 300 300 79-790-56-00-5620 OPERATING SUPPLIES 32,327 18,295 22,500 22,500 22,500 22,500 22,500 22,500 22,500 46 FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected 79-790-56-00-5630 SMALL TOOLS&EQUIPMENT 4,288 9,081 2,250 2,250 4,500 4,500 4,500 4,500 4,500 79-790-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - 2,000 500 500 500 500 500 500 500 79-790-56-00-5640 REPAIR&MAINTENANCE 79,678 60,514 507500 50,500 56,000 56,000 56,000 56,000 56,000 79-790-56-00-5695 GASOLINE 20,202 17,283 24,501 24,501 21,400 22,898 24,501 26,216 28,051 818,636 978,375 012,004 880,453 846,274 876,367 906,465 938,237 971,739 Recreation Department 79-795-50-00-5010 SALARIES&WAGES 225,784 240,199 263,137 263,137 280,333 289,962 298,661 307,621 316,850 79-795-50-00-5015 PART-TIME SALARIES 13,524 11,439 25.Opn 25,000 22,711 22,398 22,107 21,804 21,490 79-795-50-00-5045 CONCESSION WAGES 10,707 8,625 15,000 15,000 15,000 15,000 15,000 15,000 15,000 79-795-50-00-5046 PRE-SCHOOL WAGES 13,691 24,223 25,000 25,000 25,000 25,000 25,000 25,000 25,000 79-795-50-00-5052 INSTRUCTORS WAGES 15,938 8,585 25,000 25,000 25,000 25,000 25,000 25,000 25,000 79-795-52-00-5212 RETIREMENT PLAN CONTRIBUTION 28,294 28;192 32,089 32,089 32,976 32,476 34,794 37,284 39,923 79-795-52-00-5214 FICA CONTRIBUTION 20,639 21.,830 'c-?b7 26,362 28,068 29,032 29;903 30,800 31,724 79-795-52-00-5216 GROUP HEALTH INSURANCE 62,448 74,560 83,769 74,739 101,075 109,161 117,894 127,326 137,512 79-795-52-00-5222 GROUP LIFE INSURANCE 524 551 588 627 559 559 565 571 577 79-795-52-00-5223 DENTALINSURANCE 3,360 4,731 5,139 5382 6,716 7,052 7,405 7,775 8364 79-795-52.00-5224 VISION INSURANCE 491 533 552 691 799 823 848 873 899 79-795-54-00-5412 TRAINING&CONFERENCES 1,191 3,543 5,000 5,000 5,000 5,000 5,000 5,000 5,000 79-795-54-00-5415 TRAVEL&LODGING 114 217 3,000 3,000 3,000 3,000 3,000 3,000 3,000 79-795-54-00-5426 PUBLISHING&ADVERTISING 28,259 42,314 40,000 40,000 45,000 45,000 45,000 45,000 45,000 79-795-54-00-5440 TELECOMMUNICATIONS 6,573 6,603 7,000 7,000 8,000 8,000 8,000 8,000 8,000 79-795-54-00-5447 SCHOLARSHIPS 585 420 2,500 ',`00 2,500 2,500 2,500 2,500 2,500 79-795-54-00-5452 POSTAGE&SHIPPING 1,694 2,964 3,500 3,500 3,500 3,500 3,500 3,500 3,500 79-795-54-00-5460 DUES&SUBSCRIPTIONS 1,688 1,917 2,500 2,500 2,500 2,500 2,500 2,500 2,500 79-795-54-00-5462 PROFESSIONAL SERVICES 75,999 81,047 75,000 80,000 80,000 80,000 80,000 80,000 80,000 79-795-54-00-5480 UTILITIES 12,224 15,413 20,000 20,000 21,200 22,472 23,820 25,249 26,764 79-795-54-00-5485 RENTAL&LEASE PURCHASE 4,035 3,602 4,500 4,500 4,500 4,500 4,500 4,500 4,500 79-795-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 23,816 8,580 31000 3,000 3,000 3,000 3,000 3,000 3,000 79-795-54-00-5496 PROGRAM REFUNDS 8,475 9,819 7,000 7,000 10,000 10,000 10,000 10,000 10,000 79-795-54-00-5497 PROPERTY TAX PAYMENT - 21,977 - - - - - - - 79-795-56-00-5602 HOMETOWN DAYS.SUPPLIES 91,422 85,480 100,000 100,000 100,000 100,000 100,000 100,000 100,000 79-795-56-00-5606 PROGRAM SUPPLIES 62,594 89,074 75,000 80,000 86,000 86,000 86,000 86,000 86,000 79-795-56-00-5607 CONCESSION SUPPLIES 16,472 15,812 18,000 18,000 18,000 18,000 18,000 18,000 18,000 79-795-56-00-5610 OFFICE SUPPLIES 1,993 3,406 3.000 3,000 3,000 3,000 3,000 3,000 3,000 79-795-56-00-5620 OPERATING SUPPLIES 21,325 8,086 7,500 7,500 12,500 7,500 7,500 7,500 7,500 79.795-56-00-5630 SMALL TOOLS&EQUIPMENT - - 1,000 1,000 1,000 1,000 1,000 1,000 1,000 79-795-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - - 500 500 500 500 500 500 500 47 48 FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected 79-795-56-00-5640 REPAIR&MAINTENANCE 1,527 2,101 2,000 2,000 2,000 2,000 2,000 2,000 2,000 79-795-56-00-5695 GASOLINE 739 1,004 2,000 2,000 1,284 1,374 1,470 1,573 1,683 79-795-99-00-9980 TRANSFER TO RECREATION CENTER 489,043 1,245,168 826,847 883,636 8851027 950,721 965,309 987,467 1,010,876 1,035,586 Expenditures 2,063,804 1,805,222 1,795,640 1,765,480 1,796,995 1,841,676 1,893,932 1,949,113 2,007,325 Surplus(Deficit) 226,112 11,053 (212,409) (146,274) (142,007) 6,458 7,590 8,026 8,480 Fund Balance 546,485 557,536 269,391 411,262 269,255 275,713 283,303 291,329 299,809 26.48% 30.88% 1500% 23.2966 14.98% 14.97% 14.96%. 14.9591 14.94% 48 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 2016 FY 2014 FY 2015 Adopted FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes 642,838 626,950 635,000 622,529 644,719 657,613 670,765 684,180 697,864 Intergovernmental 22,914 26,934 22,450 22,450 22,450 22,450 22,450 22,450 22,450 Fines&Forfeits 9,680 8,356 9,300 9,300 9,300 9,300 9,300 9,300 9,300 Charges for Service 10,707 10,841 11,500 11,500 11,500 11,500 11,500 11,500 11,500 Investment Earnings 1,313 1,279 1,500 350 350 350 350 350 350 Reimbursements - 13,174 - - - - - - - Miscellaneous 7,992 6,762 7,500 7,500 7,500 7,500 7,500 7,500 7,500 Other Financing Sources 45,948 25,189 34,168 31,668 36,068 37,582 39,717 41,980 44,379 Total Revenue 741,392 719,485 721,418 705,297 731,887 746,295 761,582 777,260 793,343 Expenditures Salaries 414,525 400,069 397,860 397,860 419,134 433,532 446,538 459,935 473,733 Benefits 170,118 157,525 171,013 162,874 181,638 192,956 204,396 216,612 229,659 Contractual Services 94,739 145,651 128,249 128,249 129,171 130,148 131,183 132,281 133,444 Supplies 15,885 17,144 19,000 19,000 24,000 24,000 24,000 24,000 24,000 Other Financing Uses 21,185 3,487 - 3,215 3,000 3,000 3,000 3,000 3,000 Total Expenditures 716,452 723,876 716,122 711,198 756,943 783,636 809,117 835,828 863,836 Surplus(Deficit) 24,940 (4,391) 5,296 (5,901) (25,056) (37,341) (47,535) (58,568) (70,493) Ending Fund Balance 471,076 466,683 392,989 460,782 435,726 398,385 350,850 292,282 221,789 65.75% 64.47% 54.88% 64.79% 57.56% 50.84% 43.36% 34.97% 25.67% Fund Balance N $500 $400 - c $300 r $200 $100 $0 Account Number Description Library Operations 82-000-40-00-4000 PROPERTY TAXES 82-00041-00-4120 PERSONAL PROPERTY TAX 82-000-41-00-4170 STATE GRANTS 82-000-43-00-4330 LIBRARY FINES 82-000-44-004401 LIBRARY SUBSCRIPTION CARDS 82-00044-00-4422 COPY FEES 82-000-44-00-4439 PROGRAM FEES 82-000-45-00-4500 INVESTMENT EARNINGS 82-000-45-00-4550 GAIN ON INVESTMENT 82-000-46-00-4690 REIMB-MISCELLANEOUS 82-000-48-00-4820 RENTAL INCOME 82-000-48-00-4824 DVD RENTAL INCOME 82-000-48-00-4850 MISCELLANEOUS INCOME 82-000-49-00-4901 TRANSFER FROM GENERAL Revenue 82-820-50-00-5010 SALARIES&WAGES 82-820-50-00-5015 PART-TIME SALARIES 82-820-52-00-5212 RETIREMENT PLAN CONTRIBUTION 82-820-52-00-5214 FICA CONTRIBUTION 82-820-52-00-5216 GROUP HEALTH INSURANCE 82-820-52-00-5222 GROUP LIFE INSURANCE 82-820-52-00-5223 DENTAL INSURANCE 82-820-52-00-5224 VISION INSURANCE 82-820-52-00-5230 UNEMPLOYMENT INSURANCE 82-820-52-00-5231 LIABILITY INSURANCE 82-820-54-00-5412 TRAINING&CONFERENCES 82-820-54.00-5415 TRAVEL&LODGING 82-820-54-00-5426 PUBLISHING&ADVERTISING 82-820-54-00-5440 TELECOMMUNICATIONS 82-820-54-00-5452 POSTAGE&SHIPPING 82-820-54-00-5460 DUES&SUBSCRIPTIONS 82-820-54-00-5462 PROFESSIONAL SERVICES 82-820-54-00-5466 LEGAL SERVICES 82-820-54-00-5468 AUTOMATION FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Budget Projected Adopted Projected Projected Projected Projected 642,838 626,950 6? Pno 622,529 644,719 657,613 670,765 684,180 697,864 5,525 5,783 5,250 5,250 5,250 5,250 5,250 5,250 5,250 17,389 21,151 17,200 17,200 17,200 17,200 17,200 17,200. 17,200 9,680 8,356 9,300 9,300 9,300 9,300 9,300 9300 9,300 7,194 6,647 7,500 7,500 7,500 7,500 7,500 7,500 7,500 2,628. 3,095 3,000 3,000 3,000 3,000 3,000 3,000 3,000 885 1,099 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,313 816 1,500 350 350 350 350 350 350 - 463 - - - - - - - 13,174 - - - - - - 2,098 1,851 2,000 2,000 2,000 2,000 2,000 2,000 2,000 4,550 3,923 5,000 5,000 5,000 5,000 5,000 5,000 5,000 1,344 988 500 500 500 500 500 500 500 45,948 25,189 34,168 31,668 36,068 37,582 39,717 41,980 44,379 741,392 719,485 721,418 705,297 731,887 746,295 761,582 777,260 793,343 245,323 210,198 202,860 202.8601 217,309 224,774 231,517 238,463 245,617 169,202 189,871 195,000 195,000 201,825 208,758 215,021 221,472 228,116 27,138 23,897 22,569 22,569 23,470 25,175 25,930 26,708 27,509 30,993 29,991 29,849 29,849 31,448 32,528 33,504 34,509 35,544 81,269 72,838. 78,823 72,557 83,960 90,677 97,931 105,765 114,226 525 427 418 443 403 403 407 411 415 5,092 4,728 4,690 5,137 5,638 5,920 6,216 6,527 6,853 643 455 496 651 651 671 691 712 733 681 - 2,500 - 2,500 2,000 2,000 2,000 2,000 23,777 25,189 31,668 31,668 33,568 35,582 37,717 39,980 42,379 232 133 500 500 500 500 500 500 500 541 514 600 600 600 600 600 600 600 46 47 100 100 100 100 100 100 100 11,941 11,468 11,000 11,000 6,000 6,000 6,000 6,000 6;000 509 455 500 500 500 500 500 500 500 8;515 9,934 12,000 12,000 12,000 12,000 12,000 12,000 12,000 35,891 28,610 29,000 29,000 29,000 29,000 29,000 29,000 29,000 - 975 2,000 2,000 2,000 2,000 2,000 2,000 2,000 14,283 24,923 35,000 35,000 35,000 35,000 35,000 35,000 35,000 50 51 FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected 82-820-54-00-5480 UTILITIES 17,260 11,518 15,359 15,359 16,281 17,258 18,293 19,391 20,554 82-820-54-00-5489 LOSS ON INVESTMENT 9,300 - 82-820-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 4,959 46,085 20,000 20,000 25,000 25,000 25,000 25,000 25,000 82-820-54-00-5498 PAYING AGENT FEES 562 1,689 2,190 2,190 2,190 2,190 2,190 2,190 2,190 82-820-56-00-5610 OFFICE SUPPLIES 5,807 5,257 8.000 8,000 8,000 8,000 8,000 8,000 8,000 82-820-56-00-5620 OPERATING SUPPLIES 6,772 9,338 8,000 8,000 8,000 8,000 8,000 8,000 8,000 82-820-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - - - - - - - - 82-820-56-00-5671 LIBRARY PROGRAMMING 731 1,209 1,000 1,000 1,000 1,000 1,000 1,000 1,000 82-820-56-00-5676 EMPLOYEE RECOGNITION - - - - - - - - 82-820-56-00-5686 BOOKS - - - - 5,000 5,000 5,000 5,000 5,000 82-820-56-00-5684 COMPACT DISCS&OTHER MUSIC - - - - - - - - - 82-820-56-00-5685 DVD'S 2,575 1,340 2.000 2,000 2,000 2,000 2,000 2,000 2,000 82-820-99-00-9983 TRANSFER TO LIBRARY DEBT SERVICE 21,185 3,487 3,215 3,000 3,000 3,000 3,000 3,000 Expenditures 716,452 723,876 716,122 711,198 756,943 783,636 809,117 835,828 863,836 Surplus(Deficit) 24,940 (4,391) 5,296 (5,901) (25,056) (37,341) (47,535) (58,568) (70,493) Fund Balance 471,076 466,683 392,989 460,782 435,726 398,385 350,850 292,282 221,789 65.75% 64.47% 5488% 6479% 5256% 50.84% 43.36% 34.97% 25.67% 51 Library Debt Service Fund(83) The Library Debt Service Fund accumulates monies for payment of the 2006 and 2013 refinancing bonds,which were issued to finance construction of the Library building. FY 2016 FY 2014 FY 2015 Adopted FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes 746,464 727,762 749,846 746,621 749,771 757,396 789,101 794,013 824,088 Investment Earnings 71 72 30 10 - - - - - Other Financing Sources 21,185 3,487 - 3,215 3,000 3,000 3,000 3,000 3,000 Total Revenue 767,720 731,321 749,876 749,846 752,771 760,396 792,101 797,013 827,088 Expenditures Debt Service 767,720 731,321 749,846 749,846 752,771 760,396 792,101 797,013 827,088 Total Expenditures 767,720 731,321 749,846 749,846 752,771 760,396 792,101 797,013 827,088 Surplus(Deficit) 30 - - - - - - Ending Fund Balance - - 30 - - - - - 52 Account Number Description Library Debt Service 83-830-83-00-8050 83-000-40-00-4000 PROPERTY TAXES 83-000-45-00-4500 INVESTMENT EARNINGS 83-00049-00-4982 TRANSFER FROM LIBRARY OPS INTEREST PAYMENT Revenue Debt Service-20056 Bond 83-830-83-00-8000 PRINCIPAL PAYMENT 83-830-83-00-8050 INTEREST PAYMENT Debt Service-2006 Bond 789,101 83-830-84-00.8000 PRINCIPAL PAYMENT 83-830-84-00-8050 INTEREST PAYMENT Debt Service-2013 Refunding Bond 83-830-99-00-8000 PRINCIPAL PAYMENT 83-830-99-00-8050 INTEREST PAYMENT Expenditures Surplus(Deficit) Fund Balance FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Budget Projected. Adopted Projected Projected Projected Projected 746,464 727,762 749,846 746.621 749,771 757,396 789,101 794,013 824,088 71 72 30 10 - - - - 21,185 3,487 3,215 3,000 3,000 3,000 3,000 3,000 767,720 731,321 749,876 749,846 752,771 760,396 792,101 797,013 827,088 335,000 - - - - - - - - 13,400 - - - - - - - 100,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 75,000 39,238 34,488 32,113 32,113 29,738 27,363 24,988 22,613 20,238 155,000 455,000 485,000 x85.000 500,000 520,000 565,000 585,000 610,000 125,082 191,833 182,733 182,733 173,033 163,033 152,113 139,400 121,850 767,720 731,321 749,846 749,846 752,771 760,396 792,101 797,013 827,088 - - 30 - - - - - - 30 - 53 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 2016 FY 2014 FY 2015 Adopted FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Licenses&Permits 53,650 25,325 20,000 20,000 20,000 20,000 20,000 20,000 20,000 Investment Earnings 16 11 20 10 10 10 10 10 10 Miscellaneous - 13 - - - - - - - Total Revenue 53,666 25,349 20,020 20,010 20,010 20,010 20,010 20,010 20,010 Expenditures Contractual Services 3,000 3,093 3,500 3,500 3,500 3,500 3,500 3,500 3,500 Supplies 39,484 36,412 8,395 8,395 8,395 16,500 16,510 16,510 16,510 Total Expenditures 42,484 39,505 11,895 11,895 11,895 20,000 20,010 20,010 20,010 Surplus(Deficit) 11,182 (14,156) 8,125 8,115 8,115 10 - - - Ending Fund Balance 26,870 12,714 (10) 20,829 28,944 28,954 28,954 28,954 28,954 N $40 $30 M c $20 $10 $0 ($10} Fund Balance 54 55 FY 2014 FY 2015 F V 2016 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Library Capital 84-000-42-00-4214 DEVELOPMENT FEES 53,650 25,325 20,000 20,000 20,000 20,000 20,000 20,000 20,000 84-000-45-004500 INVESTMENT EARNINGS 16 11 20 10 10 10 l0 10 10 84-000-48-00-4850 MISCELLANEOUS INCOME 13 - Revenue 53,666 25,349 20,020 20,010 20,010 20,010 20,010 20,010 20,010 84-840-54-00-5460 E-BOOKS SUBSCRIPTION 3,000 3,093 3,500 3,500 3,500 3,500 3,500 3,500 3,500 84-840-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 7,074 16,428 - - - - - 84-840-56-00-5683 AUDIO BOOKS 1,482 2,467 84-840-56-00-5684 COMPACT DISCS&OTHER MUSIC 666 - 84-840-56-00-5685 DVD'S 2,062 1,250 - - - - - _ - 84-840-56-00-5686 BOOKS 28,200 16,267 8,395 8,395 8,395 16,500 16,510 16,510 16,510 Expenditures 42,484 39,505 11,895 11,895 11,895 20,000 20,010 20,010 20,010 Surplus(Deficit) 11,182 (14,156) 8,125 8,115 8,115 10 - - - Fund Balance 26,870 12,714 (10) 20,829 28,944 28,954 28,954 28,954 28,954 55 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 2016 FY 2014 FY 2015 Adopted FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes 2,043 9,295 100,000 143,784 200,000 200,000 200,000 200,000 200,000 Investment Earnings 106 - - - - - - - - Other Financing Sources 1,235,000 - - 1,597,288 - - - - Total Revenue 1,237,149 9,295 100,000 1,741,072 200,000 200,000 200,000 200,000 200,000 Expenditures Contractual Services 1,843,149 4,953 3,140 18,629 3,140 3,140 3,140 3,140 3,140 Debt Service 302,738 68,073 176,447 93,431 159,619 149,675 149,358 209,845 208,311 Capital Outlay - 7,004 - - - - - - - Other Financing Uses 1,197,685 - - 1,581,984 Total Expenditures 3,343,572 80,030 179,587 1,694,044 162,759 152,815 152,498 212,985 211,451 Surplus(Deficit) (2,106,423) (70,735) (79,587) 47,028 37,241 47,185 47,502 (12,985) (11,451) Ending Fund Balance (534,087) (604,820) (594,959) (557,792) (520,551) (473,366) (425,864) (438,849) (450,300) N $0 M ($zoo) Fund Balance r ($400) ($600) ($800) J 56 Account Number Description Countryside TIF 87-000-40-00-4000 PROPERTY TAXES 87-000-40-00-4070 BUSINESS DISTRICT TAX 87-000-45-00-4500 INVESTMENT EARNINGS 87-000-49-00-4902 BOND ISSUANCE 87-D00-49-00-4903 PREMIUM ON BOND ISSUANCE - Revenue 87-870-54-00-5402 BOND ISSUANCE COSTS 87-870-54-00-5425 TIF INCENTIVE PAYOUT 87-870-54-00-5462 PROFESSIONAL SERVICES 87-870-54-00-5493 BUSINESS DISTRICT REBATE 87-870-54-00-5498 PAYING AGENT FEES 87-870-60-00-6000 PROJECT COSTS 2015A Bond - 51-510-77-00-8000 PRINCIPAL PAYMENT 51-510-77-00-8050 INTEREST PAYMENT Debt Service-2005 Bond - 87-870-80-00-8000 PRINCIPAL PAYMENT 87-870-80-00-8050 INTEREST PAYMENT Debt Service-2014 Refunding Bond 87-870-93-00-8000 PRINCIPAL PAYMENT 87-870-93-00-8050 INTEREST PAYMENT 87-870-99-00-9902 BOND DISCOUNT 87-870-99-00-9960 PAYMENT TO ESCROW AGENT Expenditures Surplus(Deficit) Fund Balance FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Budget Projected Adopted Projected Projected Projected Projected - 9,295 100,000 143,784 200,000 200,000 200,000 200,000 200,000 2,043 - - - - - - - - 106 - - - - - 1,235,000 - - 1,475,000 - - - - 122,288 1,237,149 9,295 100,001] 1,741,072 200,000 200,000 200,000 200,000 200,000 37,315 - - 15,304 - - - - - 1,800,000 - - - - - 3,416 3,829 2,000 2.000 2,000 2,000 2,000 2;000 2,000 2,043 - - - - - - - - 375 1,124 1,140 1,325 1,140 1,140 1,140 1,140 1,140 - 7,004 - - - - - - - - - - 26,460 41,013 42,336 104,517 107,163 83,016 82,444 57,947 56,307 54,613 50,433 185,000 - - - - - - - - 117,738 68,073 s.i7T 68,073 - - 25,358 25,358 50,715 50,715 50,715 50,715 50,715 9,773 - - - - - - 1,187,912 1,581,984 3,343,572 80,030 179,587 1,694,044 162,759 152,815 152,498 212,985 211,451 (2,106,423) (70,735) (79,587) 47,028 37,241 47,185 47,502 (12,985) (11,451) (534,087) (604,820) (594,959) (557,792) (520,551) (473,366) (425,864) (438,849) (450,300) 57 Downtown TIF Fund(88) The Downtown TIF was created in 2006,in order to finance a mixed use development in the downtown area. Expenditures FY 2016 FY 2014 FY 2015 Adopted FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 35,375 Actual Actual Budget Projected Adopted Projected Projected Projected Projected 17,420 17,420 17,420 Other Financing Uses - 13,500 - - - Revenue - - - Total Expenditures 56,411 52,651 406,030 413,530 Taxes 62,269 60,027 65,000 68,868 70,000 70,000 75,000 75,000 80,000 Investment Earnings 53 1 50 50 50 50 50 50 50 Miscellaneous 184 187 - - - - - - - Other Financing Sources 8,500 - - - - - - - - Total Revenue 71,006 60,215 65,050 68,918 70,050 70,050 75,050 75,050 80,050 Expenditures Contractual Services 26,843 20,045 27,860 35,360 35,360 35,365 35,375 35,375 35,375 Capital Outlay 29,568 19,106 378,170 378,170 17,420 17,420 17,420 17,420 17,420 Other Financing Uses - 13,500 - - - - - - - Total Expenditures 56,411 52,651 406,030 413,530 52,780 52,785 52,795 52,795 52,795 Surplus(Deficit) 14,595 7,564 (340,980) (344,612) 17,270 17,265 22,255 22,255 27,255 Ending Fund Balance 231,529 239,096 (58,049) (105,516) (88,246) (70,981) (48,726 (26,471) 784 $300 Fund Balance $200 M c $100 $0 ($100) ($200) 58 Account Number Description Downtown TIF 88-000-40-00-4000 PROPERTY TAXES 88-000-40-004070 BUSINESS DISTRICT TAX 88-00045-00-4500 INVESTMENT EARNINGS 88-000-48-00-4850 MISCELLANEOUS INCOME 88-00049-00-4910 SALE OF CAPITAL ASSETS - Revenue 88-880-54-00-5425 TIE INCENTIVE PAYOUT 88-880-54-00-5462 PROFESSIONAL SERVICES 88-880-54-00-5466 LEGAL SERVICES 88-880-54-00-5493 BUSINESS DISTRICT REBATE 88-880-60-00-6000 PROJECT COSTS 88-880-60-00-6048 DOWNTOWN STREETSCAPE IMPROVEMENT 88-880-60-00-6079 ROUTE 47 EXPANSION 88-880-99-00-9923 TRANSFER TO CITY-WIDE CAPITAL 8,500 Expenditures Surplus(Deficit) Fund Balance FY 2014 FY 2015 FY 2016 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Actual Actual Budget Projected Adopted Projected Projected Projected Projected 52,811 60,027 65,000 68,868 70,000 70,000 75,000 9,458 - - - - - - 53 1 50 50 50 50 50 184 187 - - - - - 8,500 71,006 60,215 65,050 68,918 70,050 70,050 75,050 12,315 16,196 12,500 20,000 20,000 20,000 20,000 258 276 360 360 360 365 375 4,812 3,573 15.000 15,000 15,000 15,000 15,000 9,458 - - - - - 9,568 11,686 60,000 60,000 10,000 10,000 10,000 - 310,750 310,750 • - 20,000 7,420 7,420 7,420 7,420 7,420 7,420 13,500 56,411 52,651 406,030 413,530 52,780 52,785 52,795 14,595 7,564 (340,980) (344,612) 17,270 17,265 22,255 231,529 239,096 (58,049) (105,516) (88,246) (70,981) (48,726) 59 75,000 50 75,050 20,000 375 15,000 10,000 7,420 52,795 22,255 (26,471) 80,000 50 80,050 20,000 375 15,000 10,000 7.420 52,795 27,255 784