Loading...
Ordinance 2015-19 PATE OF ILLINOIS COUNTY OF KENDALL PILED - APR 3 0 2015 comy am MOau courmr UNITED CITY OF YORKVILLE KENDALL COUNTY, ILLINOIS ORDINANCE NO. 2015-19 ORDINANCE APPROVING THE 2015-2016 FISCAL BUDGET FOR THE UNITED CITY OF YORKVILLE Passed by the City Council of the United City of Yorkville,Kendall County, Illinois This 28`x'day of April, 2015 Published in pamphlet form by the authority of the Mayor and City Council of the United City of Yorkville,Kendall County, Illinois on April 29, 2015. ORDINANCE NO. 2015-�--l- ORDINANCE APPROVING THE 2015-2016 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 2015-2016 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 2015-2016 Fiscal Year Budget being submitted on April 28, 2015 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 2015-2016 Budget totaling $37,154,706 including the amounts of$14,190,635 General Fund, $871,497 Motor Fuel Tax Fund, $616,130 Vehicle&Equipment Fund, $2,941,087 Sewer Fund, $7,949,715 Water Fund, $5,900,204 City-Wide Capital Fund, $310,775 Debt Service Fund, $580,832 Land Cash Fund, $1,795,940 Parks&Recreation Fund, $716,122 Library Operations Fund, $749,846 Library Debt Service Fund, $11,895 Library Capital Fund, $96,571 Countryside TIF Fund, $356,030 Downtown TIF Fund, $37,594 Sunflower SSA Fund, and$29,833 Fox Hill SSA Fund is hereby adopted for the 2015-2016 Fiscal Year, as presented. Passed by the City Council of the United City of Yorkville, Kendall County, Illinois this 28th day of April, A.D. 2015. - CITY CLERK---- Ordinance No.2015-11 Page 2 CARLO COLOSIMO KEN KOCH JACKIE MILSCHEWSKI LARRY KOT CHRIS FUNKHOUSER JOEL FRIEDERS ROSE ANN SPEARS DIANE TEELING Approved by me, as Mayor of the United City of Yorkville, Kendall County, Illinois,this 286 day of April, A.D. 2015. MAYOR Ordinance No.2015- /q 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 2015 FY 2013 FY 2014 Adopted FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes 9,319,683 9,607,999 9,891,724 10,015,821 10,229,937 10,302,037 10,392,928 10,506,767 10,578,834 Intergovernmental 2,078,457 2,120,327 2,157,200 2,166,246 2,178,100 2,185,036 2,192,111 2,204,327 2,211,688 Licenses&Permits 168,831 168,119 193,000 178,000 198,000 198,000 223,000 223,000 223,000 Fines&Forfeits 169,144 173,954 175,250 160,250 160,250 160,250 160,250 160,250 160,250 Charges for Service 1,199,908 1,175,166 1,203,201 1,286,500 1,319,950 1,354,404 1,389,891 1,426,443 1,464,091 Investment Earnings 7,287 8,792 8,000 5,250 4,000 4,000 4,000 4,000 4,000 Reimbursements 238,535 168,974 80,000 80,000 80,000 80,000 80,000 80,000 80,000 Miscellaneous 132,965 19,335 13,000 22,500 22,500 24,500 24,500 24,500 24,500 Other Financing Sources - 2,479 5,250 2,500 7,900 2,500 2,500 2,500 2,500 Total Revenue 13,314,810 13,445,145 13,726,625 13,917,067 14,200,637 14,310,727 14,469,180 14,631,787 14,748,863 Expenditures Salaries 3,170,404 3,437,661 3,967,218 3,961,718 4,113,253 4,247,257 4,382,328 4,522,125 4,666,817 Benefits 1,909,160 2,052,895 2,470,227 2,441,200 2,545,610 2,716,600 2,992,136 3,194,879 3,409,508 Contractual Services 3,520,085 4,267,482 4,283,415 4,426,649 4,807,155 4,702,712 4,744,573 4,836,391 4,914,578 Supplies 260,466 247,990 300,199 298,199 284,861 294,845 304,871 315,583 327,028 Contingencies - 11,676 - - - - - - - Other Financing Uses 1,501,502 3,790,688 2,548,953 2,549,277 2,439,756 2,871,215 2,950,116 3,018,795 3,090,103 Total Expenditures 10,361,617 13,808,392 13,570,012 13,677,043 14,190,635 14,8329629 15,374,024 15,887,773 16,408,034 Surplus(Deficit) 2,953,193 (363,247) 156,613 240,024 10,002 (521,902) (904,844) (1,255,986) (1,659,171) Ending Fund Balance 4,223,820 3,860,581 3,8749053 49100,605 4,110,607 3,588,705 2,683,861 1,427,875 (231,296) 40.76% 27.96% 28.55% 29.98% 28.97% 24.19% 17.46% 8.99% -1.41% Fund Balance $5,000 $4,000 o $3,000 $2,000 $1,000 $0 ($1,000) 1 FY 2013 FY 2014 FY 2015 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected GENERALFUND-01 01-000-40-00-4000 PROPERTY TAXES-CORPORATE LEVY 2,276,807 2,201,759 2,334,190 2,277,087 2,288,200 2,333,964 2,250,643 2,207,656 2,251,809 01-000-40-00-4010 PROPERTY TAXES-POLICE PENSION 438,711 524,120 614,005 624,168 728,477 778,477 828,477 878,477 928,477 01-000-40-004030 MUNICIPAL SALES TAX 2,490,503 2,586,460 2,626,000 2,698,000 2,751,960 2,678,520 2,751,960 2,806,999 2,732,090 01-000-40-004035 NON-HOME RULE SALES TAX 1,919,423 1,986,566 2,020,000 2,100,000 2,142,000 2,184,840 2,228,537 2,273,108 2,318,570 01-000-40-00-4040 ELECTRIC UTILITY TAX 600,182 615,878 605,000 605,000 605,000 605,000 605,000 605,000 605,000 01-000-40-00-4041 NATURAL GAS UTILITY TAX 235,790 310,979 255,000 265,000 265,000 265,000 265,000 265,000 265,000 01-00040-004043 EXCISE TAX 484,365 461,554 490,000 420,000 415,000 415,000 415,000 415,000 415,000 01-000-40-004044 TELEPHONE UTILITY TAX 15,265 12,625 15,000 11,500 11,500 11,500 11,500 11,500 11,500 01-000-40-00-4045 CABLE FRANCHISE FEES 218,091 232,206 225,000 230,000 230,000 230,000 230,000 230,000 230,000 01-000-40-00-4050 HOTEL TAX 53,859 65,605 60,000 70,000 70,000 70,000 70,000 70,000 70,000 01-000-40-00-4055 VIDEO GAMING TAX 2,300 26,047 20,000 45,000 45,000 45,000 45,000 45,000 45,000 01-000-40-00-4060 AMUSEMENT TAX 140,856 144,118 195,000 175.000 175,000 175,000 175,000 175,000 175,000 01-000-40-00-4065 ADMISSIONS TAX 119,199 103,720 105,000 104,066 105,000 105,000 105,000 105,000 105,000 01-00040-00-4070 BUSINESS DISTRICT TAX-KENDALL MRKT 314,385 325,724 317,529 340.000 346,800 353,736 360,811 368,027 375,388 01-00040-00-4071 BUSINESS DISTRICT TAX-DOWNTOWN - - 20,000 20,000 20,000 20,000 20,000 20,000 01-00040-00-4072 BUSINESS DISTRICT TAX-COUNTRYSIDE - - - 20,000 20,000 20,000 20,000 20,000 20,000 01-000-40-00-4075 AUTO RENTAL TAX 9,633 10,638 10,000 11,000 11,000 11,000 11,000 11,000 11,000 01-000-40-00-4080 PARA-MUTUEL TAX 314 - - - - - - - - 01-000-41-00-4100 STATE INCOME TAX 1,587,324 1,613,102 1,650,000 1,610,000 1,610,000 1,610,000 1,610,000 1,610,000 1,610,000 01-000-41-004105 LOCAL USE TAX 268,285 296,298 280,000 340,000 346,800 353,736 360,811 368,027 375,388 01-000-41-00-4110 ROAD&BRIDGE TAX 168,477 164,398 175,000 171,756 175,000 175,000 175,000 180,000 180,000 01-000-41-00-4120 PERSONAL PROPERTY TAX 15,908 16,672 16,000 16.000 16,000 16,000 16,000 16,000 16,000 01-000-41-004160 FEDERAL GRANTS 17,131 8,880 15,000 10,000 10,000 10,000 10,000 10,000 10,000 01-000-41-00-4168 STATE GRANTS-TRAFFIC SIGNAL MAINTENANCE 20,019 19,284 20,000 - 17,290 19,000 19,000 19,000 19,000 19,000 01-000-41-00-4170 STATE GRANTS - 266 - - - - - - 01-000-41-00-4182 MISC INTERGOVERNMENTAL 1,313 1,427 1,200 1,200 1,300 1,300 1,300 1,300 1,300 01-000-42-00-4200 LIQUOR LICENSES 39,895 47,781 40,000 45,000 45,000 45,000 45,000 45,000 45,000 01-000-42-00-4205 OTHER LICENSES&PERMITS 2,336 4,156 3,000 3,000 3,000 3,000 3,000 3,000 3,000 01-000-42-00-4210 BUILDING PERMITS 126,600 116,182 150,000 130,000 150,000 150,000 175,000 175,000 175,000 01-000-43-004310 CIRCUIT COURT FINES 59,121 45,653 60,000 45,000 45,000 45,000 45,000 45,000 45,000 01-000-43-004320 ADMINISTRATIVE ADJUDICATION 36,328 42,430 35,000 35,000 35,000 35,000 35,000 35,000 35,000 01-00043-004323 OFFENDER REGISTRATION FEES 320 215 250 250 250 250 250 250 250 2 FY 2013 FY 2014 FY 2015 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected 01-000-43-00-4325 POLICE TOWS 73,375 85,656 80,000 80,000 80,000 80,000 80,000 80,000 80,000 01-000-44-00-4400 GARBAGE SURCHARGE 1,028,304 1,003,263 1,031,701 1,115,000 1,148,450 1,182,904 1,218,391 1,254,943 1,292,591 01-000-44-00-4405 COLLECTION FEES-YBSD 150,423 150,249 150,000 150,000 150,000 150,000 150,000 150,000 150,000 01-000-44-00-4407 LATE PENALTIES-GARBAGE 21,081 21,054 21,000 21,000 21,000 21,000 21,000 21,000 21,000 01-000-44-00-4474 POLICE SPECIAL DETAIL 100 600 500 500 500 500 500 500 500 01-000-45-00-4500 INVESTMENT EARNINGS 7,287 8,792 8,000 5,250 4,000 4,000 4,000 4,000 4,000 01-000-46-00-4601 REIMB-LEGAL EXPENSES 12,492 2,629 - - - - - - - 01-000-46-00-4604 REIMS-ENGINEERING EXPENSES 30,004 107,193 50,000 50,000 50,000 50,000 50,000 50,000 50,000 01-000-46-00-4669 REIMB-RETIREE INS CONTRIBUTIONS 57,824 -! 01-000-46-00-4670 REIMB-EMPLOYEE INS CONTRIBUTIONS 67,166 rr- 01-000-46-00-4671 REIMB-LIFE INSURANCE 2,229 - 01-000-46-00-4680 REIMB-LIABILITY INSURANCE 27,670 4,764 5,000 5,000 5,000 5,000 5,000 5,000 5,000 01-000-46-00-4681 REIMB-WORKERS COMP 15,098 30,788 - - - - - - - 01-000-46-00-4685 REIMB-CABLE CONSORTIUM 17,243 18,932 20,000 20,000 20,000 20,000 20,000 20,000 20,000 01-000-46-004690 REIMB-MISCELLANEOUS 8,809 4,668 5,000 5,000 5,000 5,000 5,000 5,000 5,000 01-000-48-004820 RENTAL INCOME 7,615 7,495 8,000 7,500 7,500 7,500 7,500 7,500 7,500 01-000-48-00-4845 DONATIONS - - 2,000 - - 2,000 2,000 2,000 2,000 01-000-48-00-4850 MISCELLANEOUS INCOME 125,350 11,840 3,000 15,000 15,000 15,000 15,000 15,000 15,000 01-000-49-004910 SALE OF CAPITAL ASSETS - - - - 5,400 - - - - 01-000-49-00-4916 TRANSFER FROM CW MUNICIPAL BUILDING 2,479 5,250 2,500 2,500 2,500 2,500 2,500 2,500 Revenue 13,314,810 13,445,145 13,726,625 13,917,067 14,200,637 14,310,727 14,469,180 14,631,787 14,748,863 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. FY 2015 FY 2013 FY 2014 Adopted FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Expenditures Salaries 340,543 364,083 433,153 427,653 420,487 431,284 442,459 454,025 465,996 Benefits 238,180 219,042 289,190 288,134 166,566 184,740 198,185 212,721 228,426 Contractual Services 122,314 136,733 167,735 167,735 151,039 152,421 153,886 155,439 157,085 Supplies 9,162 8,287 12,850 12,850 11,850 11,850 11,850 11,850 11,850 Total Administration 710,199 728,145 902,928 896,372 749,942 780,295 806,380 834,035 863,357 $1,000 M $900 N $800 o $700 $600 $500 $400 $300 $200 $100 $0 4 FY 2013 FY 2014 FY 2015 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Administration 01-110-50-00-5001 SALARIES-MAYOR 9,605 9,535 11,000 11,000 11,000 11,000 11,000 11,000 11,000 01-110-50-00-5002 SALARIES-LIQUOR COMM 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 01-110-50-00-5003 SALARIES-CITY CLERK 10,137 7,268 11,000 11,000 11,000 11,000 11,000 11,000 11,000 01-110-50-00-5004 SALARIES-CITY TREASURER 4,267 1,031 6,500 1,000 6,500 6,500 6,500 6,500 6,500 01-110-50-00-5005 SALARIES-ALDERMAN 47,205 47,190 52,000 52,000 52,000 52,000 52,000 52,000 52,000 01-110-50-00-5010 SALARIES-ADMINISTRATION 268,329 275,169 351,153 351,153 308,487 319,284 330,459 342,025 353,996 01-110-50-00-5015 PART-TIME SALARIES - 22,646 - - 30,000 30,000 30,000 30,000 30,000 01-110-50-00-5020 OVERTIME - 244 500 500 500 500 500 500 500 01-110-52-00-5212 RETIREMENT PLAN CONTRIBUTION 32,561 36,794 47,482 47,482 42,886 52,814 57,410 62,450 67,962 01-110-52-00-5214 FICA CONTRIBUTION 23,994 25,473 31,887 31,887 31,014 32,099 33,222 34,385 35,588 01-110-52-00-5216 GROUP HEALTH INSURANCE 69,719 69,776 114,769 114,769 85,972 92,850 100,278 108,300 116,964 01-110-52-00-5222 GROUP LIFE INSURANCE 580 403 559 444 447 451 456 461 466 01-110-52-00-5223 DENTAL INSURANCE 5,202 4,252 6,376 5,637 5,139 5,396 5,666 5,949 6,246 01-110-52-00-5224 VISION INSURANCE 562 550 775 589 549 565 582 599 617 01-110-52-00-5235 ELECTED OFFICIAL-GROUP HEALTH INSURANCE 96,881 76,151 81,548 81,548 - - - - - 01-110-52-00-5236 ELECTED OFFICIAL-GROUP LIFE INSURANCE 682 643 644 644 559 565 571 577 583 01-110-52-00-5237 ELECTED OFFICIAL-DENTAL INSURANCE 7,202 4,432 4,593 4,593 - - - - - 01-110-52-00-5238 ELECTED OFFICIAL-VISION INSURANCE 797 568 557 541 - - - - - 01-110-54-00-5412 TRAINING&CONFERENCES 3,510 4,624 5,100 5,100 5,100 5,100 5,100 5,100 5,100 01-110-54-00-5415 TRAVEL&LODGING 6,310 7,843 11,000 11,000 11,000 11,000 11,000 11,000 11,000 01-110-54-00-5426 PUBLISHING&ADVERTISING 716 765 1,000 1,000 1,000 1,000 1,000 1,000 1,000 01-110-54-00-5430 PRINTING&DUPLICATING 5,356 3,503 5,500 5,500 5,500 5,500 5,500 5,500 5,500 01-110-54-00-5436 4TH OF JULY CONTRIBUTION - 11,033 - - - - - - - 01-110-54-00-5440 TELECOMMUNICATIONS 19,659 13,143 20,000 20,000 20,000 20,000 20,000 20,000 20,000 01-110-54-00-5448 FILING FEES 154 181 500 500 500 500 500 500 500 01-110-54-00-5451 CODIFICATION 4,904 2,468 -8,000 8,000 5,000 5,000 5,000 5,000 5,000 01-110-54-00-5452 POSTAGE&SHIPPING (335) 2,225 8,000 8,000 4,000 4,000 4,000 4,000 4,000 01-110-54-00-5460 DUES&SUBSCRIPTIONS 16,701 14,004 17,000 17,000 17,000 17,000 17,000 17,000 17,000 01-110-54-00-5462 PROFESSIONAL SERVICES 8,722 8,355 20,000 20,000 14,000 14,000 14,000 14,000 14,000 01-110-54-00-5473 KENDALL AREA TRANSIT 23,550 23,550 30,000 30,000 25,000 25,000 25,000 25,000 25,000 01-110-54-00-5480 UTILITIES 16,636 27,883 21,735 21,735 23,039 24,421 25,886 27,439 29,085 01-110-54-00-5485 RENTAL&LEASE PURCHASE 2,079 2,508 2,400 2,400 2,400 2,400 2,400 2,400 2,400 5 FY 2013 FY 2014 FY 2015 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected O1-110-54-00-5488 OFFICE CLEANING 14,352 14,648 17,500 17,500 17,500 17,500 17,500 17,500 17,500 O1-110-56-00-5610 OFFICE SUPPLIES 9,162 8,287 12,000 12,000 11,000 11,000 11,000 11,000 11,000 O1-110-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - - 850 850 850 850 850 850 850 710,199 728,145 902,928 896,372 749,942 780,295 806,380 834,035 863,357 6 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 2015 FY 2013 FY 2014 Adopted FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Expenditures Salaries 176,887 193,692 207,142 207,142 217,491 225,103 232,982 241,136 249,576 Benefits 60,326 70,446 73,202 73,768 80,365 87,320 93,788 100,800 108,394 Contractual Services 58,584 60,214 95,450 90,750 87,050 88,650 91,250 91,250 91,250 Supplies 2,105 3,336 5,100 5,100 3,600 4,600 4,600 4,600 4,600 Total Finance 297,902 327,688 380,894 376,760 388,506 405,673 422,620 437,786 453,820 $500 $400 c N o $300 t F- $200 $100 $0 7 FY 2013 FY 2014 FY 2015 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Finance 01-120-50-00-5010 SALARIES&WAGES 176,887 193,692 207,142 207,142 217,491 225,103 232,982 241,136 249,576 01-120-52-00-5212 RETIREMENT PLAN CONTRIBUTION 19,266 21,792 24,703 24,703 24,196 27,598 30,264 33,204 36,438 01-120-52-00-5214 FICA CONTRIBUTION 13,410 14,483 15,674 15,674 16,462 17,038 17,634 18,251 18,890 01-120-52-00-5216 GROUP HEALTH INSURANCE 23,908 30,766 27,773 27,773 33,854 36,562 39,487 42,646 46,058 01-120-52-00-5222 GROUP LIFE INSURANCE 357 332 336 334 336 339 342 345 348 01-120-52-00-5223 DENTAL INSURANCE 3,061 2,749 4,216 4,784 5,017 5,268 5,531 5,808 6,098 01-120-52-00-5224 VISION INSURANCE 324 324 500 500 500 515 530 546 562 01-120-54-00-5412 TRAINING&CONFERENCES 1,850 1,462 2,500 2,500 2,500 2,500 2,500 2,500 2,500 01-120-54-00-5414 AUDITING SERVICES 31,000 31,000 35,200 32,000 36,300 37,400 40,000 40,000 40,000 01-120-54-00-5415 TRAVEL&LODGING 197 72 2,000 500 1,500 2,000 2,000 2,000 2,000 01-120-54-00-5430 PRINTING&DUPLICATING 848 1,123 2,500 2,500 4,300 4,300 4,300 4,300 4,300 01-120-54-00-5440 TELECOMMUNICATIONS 989 1,082 1,200 1,200 1,200 1,200 1,200 1,200 1,200 01-120-54-00-5452 POSTAGE&SHIPPING 920 509 4,000 4,000 1,200 1,200 1,200 1,200 1,200 01-120-54-00-5460 DUES&SUBSCRIPTIONS 535 500 800 800 800 800 800 800 800 01-120-54-00-5462 PROFESSIONAL SERVICES 20,410 22,340 45,000 45,000 37,000 37,000 37,000 37,000 37,000 01-120-54-00-5485 RENTAL&LEASE PURCHASE 1,835 2,126 2,250 2,250 2,250 2,250 2,250 2,250 2,250 01-120-56-00-5610 OFFICE SUPPLIES 2,105 2,626 2,600 2,600 2,600 2,600 2,600 2,600 2,600 01-120-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 710 2,500 2,500 1,000 2,000 2,000 2,000 2,000 297,902 327,688 380,894 376,760 388,506 405,673 422,620 437,786 453,820 8 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 2015 FY 2013 FY 2014 Adopted FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Expenditures Salaries 2,185,748 2,321,323 2,659,683 2,659,683 2,758,349 2,847,857 2,940,497 3,036,379 3,135,618 Benefits 1,071,102 1,208,317 1,464,454 1,474,617 1,641,285 1,754,104 1,870,944 1,992,750 2,119,907 Contractual Services 157,048 149,909 284,908 284,568 420,597 373,867 374,867 373,867 363,867 Supplies 137,058 132,585 172,637 172,637 158,200 164,500 171,241 178,454 186,172 Total Police 3,550,956 3,812,134 4,581,682 4,591,505 4,978,431 5,140,328 5,357,549 5,581,450 5,805,564 $7,000 $6,000 M $5,000 3 0 $4,000 $3,000 $2,000 $1,000 $0 9 FY 2013 FY 2014 FY 2015 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Police 01-210-50-00-5008 SALARIES-POLICE OFFICERS 1,227,993 1,307,670 1,563,667 1,563,667 1,614,448 1,670,954 1,729,437 1,789,967 1,852,616 01-210-50-00-5011 SALARIES-POLICE CHIEF&DEPUTIES 274,717 295,668 326,464 326,464 346,106 358,220 370,758 383,735 397,166 01-210-50-00-5012 SALARIES-SERGEANTS 392,598 426,850 448,639 448,639 466,386 482,710 499,605 517,091 535,189 01-210-50-00-5013 SALARIES-POLICE CLERKS 115,152 116,872 124,913 124,913 130,409 134,973 139,697 144,586 149,647 01-210-50-00-5014 SALARIES-CROSSING GUARD 19,192 21,950 20,000 20,000 20,000 20,000 20,000 20,000 20,000 01-210-50-00-5015 PART-TIME SALARIES 54,735 57,252 65,000 65,000 70,000 70,000 70,000 70,000 70,000 01-210-50-00-5020 OVERTIME 101,361 95,061 111,000 111,000 111,000 111,000 111,000 111,000 111,000 01-210-52-00-5212 RETIREMENT PLAN CONTRIBUTION 12,297 12,938 14,897 14,897 14,508 16,548 18,147 19,909 21,848 01-210-52-00-5213 EMPLOYER CONTRIBUTION-POLICE PENSION 438,711 524,120 614,005 624,168 728,477 778,477 828,477 878,477 928,477 01-210-52-00-5214 FICA CONTRIBUTION 161,039 171,085 199,604 199,604 206,817 214,056 221,548 229,302 237,328 01-210-52-00-5216 GROUP HEALTH INSURANCE 417,204 462,711 592,440 592,440 639,914 691,107 746,396 806,108 870,597 01-210-52-00-5222 GROUP LIFE INSURANCE 4,666 3,050 3,448 3,448 3,556 3,592 3,628 3,664 3,701 01-210-52-00-5223 DENTAL INSURANCE 33,562 30,626 35,713 35,713 43,519 45,695 47,980 50,379 52,898 01-210-52-00-5224 VISION INSURANCE 3,623 3,787 4,347 4,347 4,494 4,629 4,768 4,911 5,058 01-210-54-00-5410 TUITION REIMBURSEMENT - - 2,800 2,800 2,800 2,800 2,800 2,800 2,800 01-210-54-00-5411 POLICE COMMISSION 8,788 4,590 15,000 15,000 4,000 4,000 15,000 4,000 4,000 01-210-54-00-5412 TRAINING&CONFERENCE 9,183 12,935 15,000 15,000 18,000 18,000 18,000 18,000 18,000 01-210-54-00-5415 TRAVEL&LODGING 2,579 3,963 10,000 10,000 10,000 10,000 10,000 10,000 10,000 01-210-54-00-5422 VEHICLE&EQUIPMENT CHARGEBACK - - 49,058 49,058 203,647 146,917 146,917 146,917 146,917 01-210-54-00-5426 PUBLISHING&ADVERTISING 359 517 200 200 200 200 200 200 200 01-210-54-00-5430 PRINTING&DUPLICATING 3,550 2,370 4,500 4,500 4,500 4,500 4,500 4,500 4,500 01-210-54-00-5440 TELECOMMUNICATIONS 26,938 24,048 36,500 36,500 36,500 36,500 36,500 36,500 36,500 01-210-54-00-5452 POSTAGE&SHIPPING 1,210 1,218 3,000 3,000 1,600 1,600 1,600 1,600 1,600 01-210-54-00-5460 DUES&SUBSCRIPTIONS 898 4,315 1,350 1,350 1,350 1,350 1,350 1,350 1,350 01-210-54-00-5462 PROFESSIONAL SERVICES 8,092 11,249 15,000 15,000 20,000 20,000 20,000 20,000 20,000 01-210-54-00-5466 LEGAL SERVICES - - 20,000: 20,000 10,000 20,000 10,000 20,000 10,000 01-210-54-00-5467 ADJUDICATION SERVICES 16,811 16,132 20,000 20,000 20,000 20,000 20,000 20,000 20,000 01-210-54-00-5469 NEW WORLD LIVE SCAN 11,660 12,434 15,000 15,000 15,000 15,000 15,000 15,000 15,000 01-210-54-00-5472 KENDALL CO.JUVE PROBATION 3,406 3,118 4,000 4,000 4,000 4,000 4,000 4,000 4,000 01-210-54-00-5484 MDT-ALERTS FEE 6,660 6,660 7,000 6,660 7,000 7,000 7,000 7,000 7,000 01-210-54-00-5485 RENTAL&LEASE PURCHASE 5,761 6,384 6,500 6,500 7,000 7,000 7,000 7,000 7,000 01-210-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 51,153 39,976 60,000 60,000 55,000 55,000 55,000 55,000 55,000 10 FY 2013 FY 2014 FY 2015 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected 01-210-56-00-5600 WEARING APPAREL 18,710 18,424 20,000 20,000 20,000 20,000 20,000 20,000 20,000 O1-210-56-00-5610 OFFICE SUPPLIES 4,646 2,495 4,500 4,500 4,500 4,500 4,500 4,500 4,500 O1-210-56-00-5620 OPERATING SUPPLIES 18,356 5,168 10,000 10,000 10,000 10,000 10,000 10,000 10,000 O1-210-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 3,227 7,792 12,000 12,000 12,000 12,000 12,000 12,000 12,000 O1-210-56-00-5640 REPAIR&MAINTENANCE 5,767 1,479 12,250 12,250 6,500 6,500 6,500 6,500 6,500 01-210-56-00-5650 COMMUNITY SERVICES - 7,311 7,370 7,370 3,000 3,000 3,000 3,000 3,000 O1-210-56-00-5690 BALISTIC VESTS 3,025 8,009 4,200 4,200 4,200 4,200 4,200 4,200 4,200 O1-210-56-00-5695 GASOLINE 81,459 78,917 97,317 97,317 90,000 96,300 103,041 110,254 117,972 01-210-56-00-5696 AMMUNITION 1,868 2,990 5,000 5,000 8,000 8,000 8,000 8,000 8,000 3,550,956 3,812,134 4,581,682 4,591,505 4,978,431 5,140,328 5,357,549 5,581,450 5,805,564 11 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 2015 FY 2013 FY 2014 Adopted FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Expenditures Salaries 199,396 229,837 327,457 327,457 357,873 368,719 379,944 391,562 403,587 Benefits 84,415 104,751 122,541 122,541 150,555 163,258 175,493 188,738 203,071 Contractual Services 65,944 64,908 139,622 138,750 164,900 148,650 126,588 130,722 135,063 Supplies 15,434 8,042 13,934 13,934 11,900 12,780 13,080 13,401 13,744 Total Community_ Development 365,189 407,538 603,554 602,682 685,228 693,407 695,105 724,423 755,465 $800 $700 3 $600 $500 $400 $300 $200 $100 $0 12 FY 2013 FY 2014 FY 2015 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Community Development 01-220-50-00-5010 SALARIES&WAGES 183,615 218,262 297,457 297,457 309,873 320,719 331,944 343,562 355,587 01-220-50-00-5015 PART-TIME SALARIES 15,781 11,575 30,000 30,000 48,000 48,000 48,000 48,000 48,000 01-220-52-00-5212 RETIREMENT PLAN CONTRIBUTION 19,592 24,323 35,474 35,474 34,474 39,320 43,120 47,308 51,916 01-220-52-00-5214 FICA CONTRIBUTION 14,716 16,823 24,681 24,681 26,784 27,721 28,691 29,695 30,734 01-220-52-00-5216 GROUP HEALTH INSURANCE 45,833 59,831 58,362 58,362 82,828 89,454 96,610 104,339 112,686 01-220-52-00-5222 GROUP LIFE INSURANCE 511 359 447 447 447 451 456 461 466 01-220-52-00-5223 DENTAL INSURANCE 3,393 3,036 3,187 3,187 5,465 5,738 6,025 6,326 6,642 01-220-52-00-5224 VISION INSURANCE 370 379 390 390 557 574 591 609 627 01-220-54-00-5412 TRAINING&CONFERENCES 1,863 1,213 3,000 3,000 5,500 5,500 5,500 5,500 5,500 01-220-54-00-5415 TRAVEL&LODGING 631 281 2,000 2,000 4,000 4,000 4,000 4,000 4,000 01-220-54-00-5426 PUBLISHING&ADVERTISING 291 1,371 1,000 1,000 1,000 1,000 1,000 1,000 1,000 01-220-54-00-5430 PRINTING&DUPLICATING 1,368 1,400 4,250 4,250 2,500 2,500 2,500 2,500 2,500 01-220-54-00-5440 TELECOMMUNICATIONS 2,410 2,198 3,000 3,000 3,000 3,000 3,000 3,000 3,000 01-220-54-00-5452 POSTAGE&SHIPPING 862 906 1,000 1,000 1,000 1,000 1,000 1,000 1,000 01-220-54-00-5459 INSPECTIONS - 680 10,000 10,000 5,000 5,000 5,000 5,000 5,000 01-220-54-00-5460 DUES&SUBSCRIPTIONS 2,803 1,943 2,000 2,000 2,000 2,000 2,000 2,000 2,000 01-220-54-00-5462 PROFESSIONAL SERVICES 5,692 5,030 60,000 61,000 61,000 41,000 15,000 15,000 15,000 01-220-54-00-5466 LEGAL SERVICES 1,869 485 2,000 2,000 2,000 2,000 2,000 2,000 2,000 01-220-54-00-5485 RENTAL&LEASE PURCHASE 3,155 2,601 2,700 2,700 2,900 2,900 2,900 2,900 2,900 01-220-54-00-5486 ECONOMIC DEVELOPMENT 45,000 46,800 48,672 46,800 75,000 78,750 82,688 86,822 91,163 01-220-56-00-5610 OFFICE SUPPLIES 520 440 750 750 900 1,500 1,500 1,500 1,500 01-220-56-00-5620 OPERATING SUPPLIES 2,249 2,991 5,000 5,000 3,000 3,000 3,000 3,000 3,000 01-220-56-00-5630 SMALL TOOLS&EQUIPMENT 61 40 - - - - - - - 01-220-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 9,153 1,321 3,500 3,500` 3,500 3,500 3,500 3,500 3,500 01-220-56-00-5645 BOOKS&PUBLICATIONS 382 366 500 500 500 500 500 500 500 01-220-56-00-5695 GASOLINE 3,069 2,884 4,184 4,184 4,000 4,280 4,580 4,901 5,244 365,189 407,538 603,554 602,682 685,228 693,407 695,105 724,423 755,465 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 2015 FY 2013 FY 2014 Adopted FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Expenditures Salaries 267,730 328,126 339,283 339,283 358,553 373,794 385,946 398,523 411,540 Benefits 139,666 162,447 177,193 177,193 183,177 196,784 304,135 329,884 358,056 Contractual Services 1,169,135 1,460,448 1,304,171 1,374,970 1,448,866 1,358,539 1,394,467 1,431,482 1,469,616 Supplies 71,058 94,029 90,678 88,678 94,311 96,115 99,100 102,278 105,662 Total Public Works 1,647,589 2,045,050 1,911,325 1,980,124 2,084,907 2,025,232 2,183,648 2,262,167 2,344,874 $2,500 v c $2,000 3 0 s ~ $1,500 $1,000 $500 $0 14 FY 2013 FY 2014 FY 2015 FY 2015 FY 2016 FV 2017 FY 2018 FY 2019 FY 2020 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Public Works-Street Operations 01410-50-00-5010 SALARIES&WAGES 263,824 305,901 318,483 318,483 335,453 347,194 359,346 371,923 384,940 01410-50-00-5015 PART-TRAE SALARIES - - 5,800 5,800 8,100 11,600 11,600 11,600 11,600 01-410-50-00-5020 OVERTIME 3,906 22,225 15,000 15,000 15,000 15,000 15,000 15,000 15,000 01410-52-00-5212 RETIREMENT PLAN CONTRIBUTION 28,590 36,445 39,770 39,770 38,989 42,566 139,140 153,308 169,031 01-410-52-00-5214 FICA CONTRIBUTION 19,795 24,235 25,253 25,253 26,703 27,638 28,605 29,606 30,642 01-410-52-00-5216 GROUP HEALTH INSURANCE 82,763 94,536 104,498 104,498 108,608 117,297 126,681 136,815 147,760 01-410-52-00-5222 GROUP LIFE INSURANCE 1,251 543 570 570 570 576 582 588 594 01-410-52-00-5223 DENTAL INSURANCE 6,564 5,949 6,341 6,341 7,546 7,923 8,319 8,735 9,172 01-410-52-00-5224 VISION INSURANCE 703 739 761 761 761 784 808 832 857 01410-54-00-5412 TRAINING&CONFERENCES 834 - 4,000 4,000 8,100 4,000 4,000 4,000 4,000 01410-54-00-5422 VEHICLE&EQUIPMENT CHARGEBACK - 144,650 97,370 97,370 163,416 41,315 41,315 41,315 41,315 01.410-54-00-5435 TRAFFIC SIGNAL MAINTENANCE - 8,390 20,000 20,000 19,000 19,000 19,000 19,000 19,000 01410-54-00-5440 TELECOMMUNICATIONS 2,395 2,520 3,000 3,000 3,000 3,000 3,000 3,000 3,000 01-410-54-00-5446 PROPERTY&BLDG MAINT SERVICES 13,984 23,836 - - - - - - 01-410-54-00-5454 SIDEWALK PROGRAM 110 - - - - - - 01-410-54-00-5455 MOSQUITO CONTROL 6,730 6,865 8,000 8,000 8,400 8,820 9,261 9,724 10,210 01-410-54-00-5458 TREE&STUMP MAINTENANCE 17,080 20,000 30,000 30,000 20,000 20,000 20,000 20,000 20,000 01-410-54-00-5462 PROFESSIONAL SERVICES 773 727 1,000 1,000 4,900 4,900 4,900 4,900 4,900 01-410-54-00-5480 UTILITIES 53,803 67,815 - - - - - - - 01-410-54-00-5485 RENTAL&LEASE PURCHASE 1,181 984 1,100 1,100 1,100 1,100 1,100 1,100 1,100 01-410-54-00-5490 VEHICLE MAINTENANCE SERVICES 28,769 53,541 25,000" 25,000 30,000 30,000 30,000 30,000 30,000 01-410-54-00-5495 OUTSIDE REPAIR&MAINTENANCE - 1,325 2,000 2,000 1,500 1,500 1,500 1,500 1,500 01-410-56-00-5600 WEARING APPAREL 2,921 3,263 4,200 4,200 4,410 4,631 4,863 5,106 5,361 01410-56-00-5620 OPERATING SUPPLIES 7,364 10,378 10,000 10,000 10,500 11,025 11,576 12,155 12,763 01410-56-00-5626 HANGING BASKETS - - 2,000 - - 2,000 2,000 2,000 2,000 01-410-56-00-5628 VEHICLE MAINTENANCE SUPPLIES - 20,578 25,000 25,000 25,000 25,000 25,000 25,000 25,000 01410-56-00-5630 SMALL TOOLS&EQUIPMENT 2,691 1,006 2,000 2,000 5,000 2,000 2,000 2,000 2,000 01410-56-00-5640 REPAIR&MAINTENANCE 30,984 21,235 20,000 20,000 20,000 20,000 20,000 20,000 20,000 01410-56-00-5656 PROPERTY&BLDG MAINT SUPPLIES 3,894 5,877 01410-56-00-5695 GASOLINE 23,204 31,692 27,478 27,478 29,401 31,459 33,661 36,017 38,538 604,113 915,255 798,624 796,624 895,457 800,328 923,257 965,224 1,010,283 15 FY 2013 FY 2014 FY 2015 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Public Works-Health&Sanitation O1-540-54-00-5441 GARBAGE SERVICES-SENIOR SUBSIDY 136,335 142,762 75,000 77,500 35,000 36,000 36,000 36,000 36,000 O1-540-54-00-5442 GARBAGE SERVICES 903,061 981,513 1,031,701 1,100,000 1,148,450 1,182,904 1,218,391 1,254,943 1,292,591 O1-540-54-00-5443 LEAF PICKUP 4,080 5,520 6,000 6,000 6,000 6,000 6,000 6,000 6,000 1,043,476 1,129,795 1,112,701 1,183,500 1,189,450 1,224,904 1,260,391 1,296,943 1,334,591 Total Public Works 1,647,589 2,045,050 1,911,325 1,980,124 2,084,907 2,025,232 2,1839648 2,262,167 2,344,874 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 2015 FY 2013 FY 2014 Adopted FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Expenditures Salaries 100 600 500 500 500 500 500 500 500 Benefits 315,471 287,892 343,647 304,947 323,662 330,394 349,591 369,986 391,654 Contractual Services 1,947,060 2,395,270 2,291,529 2,369,876 2,534,703 2,580,585 2,603,515 2,653,631 2,697,697 Supplies 25,649 1,711 5,000 5,000 5,000 5,000 5,000 5,000 5,000 Contingencies - 11,676 - - - - - - - Other Financing Uses 1,501,502 3,790,688 2,548,953 2,549,277 2,439,756 2,871,215 2,950,116 3,018,795 3,090,103 Total Admin Services&Transfers 3,789,782 6,487,837 5,189,629 5,229,600 5,303,621 5,787,694 5,908,722 6,047,912 6,184,954 $7,000 $6,000 o $5,000 t $4,000 $3,000 $2,000 $1,000 $0 17 FY 2013 FY 2014 FY 2015 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Administrative Services 01-640-50-00-5092 POLICE SPECIAL DETAIL WAGES 100 600 500 500 500 500 500 500 500 01-640-52-00-5230 UNEMPLOYMENT INSURANCE 7,024 5,241 30,000 6,300 20,000 20,000 20,000 20,000 20,000 O1-640-52-00-5231 LIABILITY INSURANCE 213,976 246,339 265,000 250,000 265,000 280,900 297,754 315,619 334,556 O1-640-52-00-5240 RETIREES-GROUP HEALTH INSURANCE 88,868 35,091 47,149 47,149 37,570 28,965 31,282 33,785 36,488 O1-640-52-00-5241 RETIREES-DENTAL INSURANCE 5,025 1,061 1,333 1,333 972 470 494 519 545 O1-640-52-00-5242 RETIREES-VISION INSURANCE 578 160 165 165 120 59 61 63 65 01-640-54-00-5428 UTILITY TAX REBATE - - - 8,385 14,375 14,375 14,375 14,375 5,990 O1-640-54-00-5434 EXCISE TAX REBATE 42,787 - - - - - - O1-640-54-00-5439 AMUSEMENT TAX REBATE - 22,130 50,000 50,000 50,000 50,000 25,000 25,000 25,000 O1-640-54-00-5449 KENCOM 22,000 25,295 150,000 73,000 100,000 110,000 121,000 133,100 146,410 O1-640-54-00-5450 INFORMATION TECHNOLOGY SERVICES 86,654 38,867 174,500 174,500 99,225 104,186 109,395 114,865 120,608 O1-640-54-00-5456 CORPORATE COUNSEL 81,042 89,253 115,500 115,500 121,275 127,339 133,706 140,391 147,411 01-640-54-00-5461 LITIGATION COUNSEL 44,826 147,253 60,000 60,000 120,000 120,000 120,000 120,000 120,000 O1-640-54-00-5462 PROFESSIONAL SERVICES 451 - - - - - - 01-640-54-00-5463 SPECIAL COUNSEL 2,771 2,872 25,000 25,000 25,000 25,000 25,000 25,000 25,000 01-640-54-00-5465 ENGINEERING SERVICES 406,630 597,697 290,000 290,000 465,000 465,000 465,000 465,000 465,000 O1-640-54-00-5475 CABLE CONSORTIUM FEE 70,613 76,508 85,000 85,000 85,000 85,000 85,000 85,000 85,000 O1-640-54-00-5481 HOTEL TAX REBATE 48,473 59,045 54,000 54,000 63,000 63,000 63,000 63,000 63,000 O1-640-54-00-5489 LOSS ON INVESTMENT - - - 68,173 - - - - - 01-640-54-00-5491 CITY PROPERTY TAX REBATE 1,196 1,369 1,500 1,293 1,500 1,500 1,500 1,500 1,500 O1-640-54-00-5492 SALES TAX REBATE 745,572 861,234 858,500 878,459 896,028 913,949 932,228 950,873 969,890 01-640-54-00-5493 BUSINESS DISTRICT REBATE 314,385 325,724 317,529 380,000 386,800 393,736 400,811 408,027 415,388 01-640-54-00-5494 ADMISSIONS TAX REBATE 119,199 103,720 105,000 104,066 105,000 105,000 105,000 105,000 105,000 01-640-54-00-5499 BAD DEBT 3,248 1,516 5,000 2,500 2,500 2,500 2,500 2,500 2,500 O1-640-56-00-5625 REIMBURSABLE REPAIRS 25,649 1,711 5,000 5,000 5,000 5,000 5,000 5,000 5,000 01-640-70-00-7799 CONTINGENCIES - 11,676 - - - - - - - 01-640-99-00-9914 TRANSFER TO MUNICIPAL BUILDING 571,615 O1-640-99-00-9915 TRANSFER TO MOTOR FUEL TAX 324 - - - - - 01-640-99-00-9916 TRANSFER TO CW BUILDINGS&GROUNDS x.03 Qoo 105,000 62,000 64,500 64,500 64,500 64,500 a„ O1-640-99-00-9923 TRANSFER TO CITY-WIDE CAPITAL 419,332 270,401 01-640-99-00-9942 TRANSFER TO DEBT SERVICE 99,465 - 132,103 294,411 315,775 320,275 319,575 O1-640-99-00-9952 TRANSFER TO SEWER 1,137,220 1,133 I972 1 1,134,654 1,134,052 1,137,166 1,133,782 1,134,114 18 FY 2013 FY 2014 FY 2015 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected O1-640-99-00-9979 TRANSFER TO PARKS&RECREATION 955,886 1,765,504 1,277,606 1,277,606 1,076,831 1,342,684 1,395,093 1,460,521 1,529,934 O1-640-99-00-9982 TRANSFER TO LIBRARY OPERATIONS 26,819 45,948 32,375 32,375 34,168 35,568 37,582 39,717 41,980 3,789,782 6,487,837 59189,629 5,229,600 5,303,621 5,787,694 5,908,722 6,047,912 6,184,954 Expenditures 10,361,617 13,8089392 13,570,012 13,677,043 14,190,635 14,832,629 15,374,024 15,887,773 169408,034 Surplus(Deficit) 2,953,193 (363,247) 156,613 240,024 10,002 (521,902) (904,844) (1,255,986) (1,659,171) Fund Balance 4,223,820 3,860,581 3,874,053 4,100,605 4,110,607 3,588,705 2,683,861 1,427,875 (231,296) 40.76% 27.96% 28.55% 2298% 28.97% 24.19% 17.46% 8.99% -1.41% 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 2015 FY 2013 FY 2014 Adopted FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes 3,786 3,786 8,536 8,536 7,073 7,073 7,073 7,073 7,073 Investment Earnings 10 1 - - - - - - - Total Revenue 3,796 3,787 8,536 8,536 7,073 7,073 7,073 7,073 7,073 Expenditures Contractual Services 5,743 7,776 19,603 4,603 29,833 5,075 5,329 5,595 5,875 Total Expenditures 5,743 7,776 19,603 4,603 29,833 5,075 5,329 5,595 5,875 Surplus(Deficit) (1,947) (3,989) (11,067) 3,933 (22,760) 1,998 1,744 1,478 1,198 Ending Fund Balance 15,124 11,134 154 15,067 (7,693) (5,695) (3,951) (2,473) (1,275) 263.35% 143.18% 0.79% 327.33% -25.79% -112.22% -74.14% -44.20% -21.70% M $20 Fund Balance 3 $10 0 L ~ $0 ($10) 20 FY 2013 FY 2014 FY 2015 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Fox Hill SSA-11 11-000-40-00-4000 PROPERTY TAXES 3,786 3,786 8,536 8,536 7,073 7,073 7,073 7,073 7,073 11-000-45-00-4500 INVESTMENT EARNINGS 10 1 Revenue 3,7% 3,787 8,536 8,536 7,073 7,073 7,073 7,073 7,073 I1-111-54-00-5417 TRAIL MAINTENANCE - - 15,000 - 15,000 - - - _ 11-111-54-00-5466 LEGAL SERVICES - 190 - - - - - _ 11-111-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 5,743 7,586 4,603 4,603 14,833 5,075 5,329 5,595 5,875 Expenditures 5,743 7,776 19,603 4,603 29,833 5,075 5,329 5,595 5,875 Surplus(Deficit) (1,947) (3,989) (11,067) 3,933 (22,760) 1,998 1,744 1,478 1,198 Fund Balance 15,124 11,134 154 15,067 (7,693) (5,695) (3,951) (2,473) (1,275) 263.35% 143.18% 0.79% 327.33/ -25.79% -112.22% -74.14010 -44.20% -21.70% 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 2015 FY 2013 FY 2014 Adopted FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes 7,530 7,467 17,416 17,417 18,608 20,392 20,392 20,392 20,392 Investment Earnings 14 2 - - - - - - - Total Revenue 7,544 7,469 17,416 17,417 18,608 20,392 20,392 20,392 20,392 Expenditures Contractual Services 11,992 12,635 35,985 50,985 37,594 12,111 12,717 13,353 14,021 Total Expenditures 11,992 12,635 35,985 50,985 37,594 12,111 12,717 13,353 14,021 Surplus(Deficit) (4,448) (5,166) (18,569) (33,568) (18,986) 8,281 7,675 7,039 6,371 Ending Fund Balance 7,740 2,574 (18,345) (30,994) (49,980) (41,699) (34,024) (26,985) (20,614) 64.54% 20.37% -50.98% -60.79% -132.95% -344.31% -267.55% -202.09% -147.02% $20 Fund Balance N $o 3 ~ ($20) ($40) ($60) 22 FY 2013 FY 2014 FY 2015 FY 2015 FY 2016 FV 2017 FY 2018 FY 2019 FY 2020 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Sunflower SSA-12 12-000-40-00-4000 PROPERTY TAXES 7,530 7,467 17,416 17,417 18,608 20,392 20,392 20,392 20,392 12-000-45-00-4500 INVESTMENT EARNINGS 14 2 Revenue 7,544 7,469 17,416 17,417 18,608 20,392 20,392 20,392 20,392 12-112-54-00-5416 POND MAINTENANCE - - 25,000 40,000 26,060 - - - - 12-112-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 11,992 12,635 10,985 10,985 11,534 12,111 12,717 13,353 14,021 Expenditures 11,992 12,635 35,985 50,985 37,594 12,111 12,717 13,353 14,021 Surplus(Deficit) (4,448) (5,166) (18,569) (33,568) (18,986) 8,281 7,675 7,039 6,371 Fund Balance 7,740 2,574 (18,345) (30,994) (49,980) (41,699) (34,024) (26,985) (20,614) 64.54% 20.37% 5098% -60.79% -132.95% -344.31% -267.55% -202.09% -147.02% 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. FY 2015 FY 2013 FY 2014 Adopted FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Intergovernmental 515,218 812,172 480,000 938,512 483,500 453,500 453,500 453,500 453,500 Investment Earnings 3,368 3,417 3,000 2,050 500 500 500 500 500 Reimbursements 257 110 - - - - - - - Other Financing Sources - - - 7,149 - - - - - Total Revenue 518,843 815,699 483,000 947,711 484,000 454,000 454,000 454,000 454,000 Expenditures Contractual Services 7,500 7,750 1 1 1,000 136,874 117,210 123,793 130,771 130,667 138,507 Supplies 142,773 107,617 178,712 178,712 203,000 203,000 203,000 203,000 203,000 Capital Outlay 130,923 832,384 573,787 685,428 551,287 373,787 273,787 273,787 148,557 Total Expenditures 281,196 947,751 863,499 1,001,014 871,497 700,580 607,558 607,454 490,064 Surplus(Deficit) 237,647 (132,052) (380,499) (53,303) (387,497) (246,580) (153,558) (153,454) (36,064) Ending Fund Balance 1,162,506 1,030,456 620,347 977,153 589,656 343,076 189,518 36,064 - r $1,500 Fund Balance 0 $1,000 ~ $500 $0 24 E NOS ,. :• . FY 2013 FY 2014 FY 2015 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Motor Fuel Tax -15 - 15-000-41-00-4112 MOTOR FUEL TAX 402,932 417,742 400,000 420,000 412,500 412,500 412,500 412,500 412,500 15-000-41-00-4113 WT HIGH GROWTH 39,164 41,814 40,000 41,892 41,000 41,000 41,000 41,000 41,000 15-000-41-00-4172 ILLINOIS JOBS NOW PROCEEDS 73,122 73,122 - 146,244 - - - - - 15-000-41-00-4183 FEDERAL GRANTS-GAME FARM RD ROW - 75,195 36,725 15-000-41-00-4184 STATE GRANTS-DOWNTOWN PARKING LOT 204,299 - 266,077 - 15-000-41-00-4185 STATE GRANTS-MATERIALS STORAGE FACILITY - 40,000 10,000 30,000 15-000-41-00-4187 FEDERAL GRANTS-CANNONBALL LAFO - - - 17,574 - - - - - 15-000-45-00-4500 INVESTMENT EARNINGS 3,368 3,417 3,000 2,050 500 500 500 500 500 15-000-46-004690 REIMB-MISCELLANEOUS 257 110 - - - - - - - 15-000-49-00-4901 TRANSFER FROM GENERAL - - 324 15-000-49-004923 TRANSFER FROM CITY-WIDE CAPITAL - - 6,825 Revenue 518,843 815,699 483,000 947,711 484,000 454,000 454,000 454,000 454,000 15-155-54-00-5438 SALT STORAGE 7,500 7,750 7,500 7,500 7,500 7,500 7,500 - - 15-155-54-00-5482 STREET LIGHTING 103,500 103,500 109,710 116,293 123,271 130,667 138,507 15-155-54-00-5489 LOSS ON INVESTMENT - - - 25,874 - - - - - 15-155-56-00-5618 SALT 58,875 74,070 132300 132,300 150,000 150,000 150,000 150,000 150,000 15-155-56-00-5619 SIGNS 15,943 5,708 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15-155-56-00-5632 PATCHING 47,007 - - - - - - - - 15-155-56-00-5633 COLD PATCH 10,621 12,088 14,109 14,109 19,000 19,000 19,000 19,000 19,000 15-155-56-00-5634 HOT PATCH 10,327 15,751 17,303 17,303 19,000 19,000 19,000 19,000 19,000 15-155-60-00-6003 MATERIAL STORAGE BLDG CONSTRUCTION 75,000 22,500 127,500 15-155-60-00-6004 BASELINE ROAD BRIDGE REPAIRS 50,000 - 50,000 - - - 15-155-60-00-6025 ROAD TO BETTER ROADS PROGRAM - 193,042 275,000 275,000 300,000 300,000 200,000 200,000 74,770 15-155-60-00-6072 DOWNTOWN PARKING LOT 24,271 312,552 - 145,259 - - - - - 15-155-60-00-6073 GAME FARM ROAD PROJECT 30,000 169,890 73,450 25 FY 2013 FY 2014 FY 2015 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected 15-155-60-00-6079 ROUTE 47 EXPANSION 76,652 121,900 73,787 73,787 73,787 73,787 73,787 73,787 73,787 15-155-60-00-6089 CANNONBALL LAFO PROJECT 35,000 100,000 95,432 Expenditures 281,196 947,751 863,499 1,001,014 871,497 700,580 607,558 607,454 490,064 Surplus(Deficit) 237,647 (132,052) (380,499) (53,303) (387,497) (246,580) (153,558) (153,454) (36,064) Fund Balance 1,162,506 1,030,456 620,347 977,153 589,656 343,076 189,518 36,064 26 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 benefitthe public. FY 2015 FY 2013 FY 2014 Adopted FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Intergovernmental 61,635 230,839 105,960 89,200 776,938 114,160 12,720 - - Licenses&Permits 94,675 83,542 20,250 17,500 17,500 17,500 17,500 17,500 17,500 Charges for Service - 684,319 680,000 680,000 680,000 680,000 680,000 680,000 680,000 Investment Earnings 243 204 3,000 4,500 1,000 - - - - Reimbursements 20,007 89,356 885,630 1,567,018 67,700 294,740 32,780 - - Other Financing Sources 457,182 464,364 4,855,000 4,463,289 214,184 64,500 64,500 64,500 64,500 Total Revenue 633,742 1,552,624 6,549,840 6,821,507 1,757,322 1,170,900 807,500 762,000 762,000 Expenditures Contractual Services 175,608 94,194 130,000 301,554 86,025 86,025 86,025 86,025 86,025 Supplies - - 25,000 25,000 27,500 30,000 30,000 30,000 30,000 Capital Outlay 210,605 1,033,122 2,334,022 2,113,105 5,375,823 936,400 823,582 243,168 321,287 Debt Service - 75,000 85,000 75,000 408,356 406,557 406,007 400,307 322,188 Other Financing Uses - 2,479 5,250 9,325 2,500 2,500 2,500 2,500 2,500 Total Expenditures 386,213 1,204,795 2,579,272 2,523,984 5,900,204 1,461,482 1,3489114 762,000 762,000 Surplus(Deficit) 247,529 347,829 3,970,568 4,297,523 (4,142,882) (290,582) (540,614) - - CW Municipal Building Fund Balance - - - - - - - - City-Wide Capital Fund Balance 328,726 676,555 4,662,971 4,974,078 831,196 540,614 - Ending Fund Balance 328,726 676,555 4,662,971 4,974,078 831,196 540,614 - - - Fund Balance N $6,000 v � $5,000 N c $4,000 $3,000 $2,000 $1,000 $0 27 FY 2013 FY 2014 FY 2015 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Account Number Description Actual Actual Budget Projected_ Adopted Projected Projected Projected Projected City-Wide Capital-23 23-000-41-00-4161 FEDERAL GRANTS-ITEP DOWNTOWN 32,000_ 24,000 40,000 23-000-41-00-4162 FEDERAL GRANTS-RIVER RD BRIDGE 61,635 110,317 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 73,960 X00 29,800 114,160 12,720 23-000-41-00-4188 STATE GRANTS-EDP WRIGLEY(RTE 47) - 707,138 23-000-42-00-4210 BUILDING PERMITS 10,660 - 23-000-42-00-4214 DEVELOPMENT FEES-CW CAPITAL 3,135 7,429 5,000 5,000 5,000 5,000 5,000 5,000 5,000 23-000-42-00-4216 BUILD PROGRAM PERMITS 80,880 71,634 - - - - _ _ _ 23-000-42-00-4218 DEVELOPMENT FEES-MUNICIPAL BLDG - 2,479 5,250 2,500 2,500 2,500 2,500 2,500 2,500 23-000-42-00-4222 ROAD CONTRIBUTION FEE 2,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 23-000-44-00-4440 ROAD INFRASTRUCTURE FEE - 684,319 680,000 680,000 680,000 680,000 680,000 680,000 680,000 23-000-45-00-4500 INVESTMENT EARNINGS 243 204 3,000 4.500 1,000 - - - - 23-000-46-00-4606 REIMB-COM ED - - - 41 0,000 - 23-000 46-004620 REIMB-PULTE(AUTUMN CREEK) - 87,932 861,890 1 129,606 55,000 - - 23-000-46-00-4660 REIMB-PUSH FOR THE PATH 20,007 1,424 23,740 16,300 12,700 294,740 32,780 23-000-46-00-4690 REIMB-MISCELLANEOUS - - - 1 1,1 l2 - - - 23-000-49-00-4900 BOND PROCEEDS 4,750,000 4,295,000 23-00049-00-4903 PREMIUM ON BOND ISSUANCE - 49,789 23-00049-004905 LOAN PROCEEDS-RIVER ROAD BRIDGE 37,850 193,963 - - 152,184 - - - - 23-000-49-00-4916 TRANSFER FROM GENERAL-CW B&G - - 105,000 105,000 62,000 64,500 64,500 64,500 64,500 23-000-49-00-4923 TRANSFER FROM GENERAL-CW CAPITAL 419,332 270,401 - - - - - - - 23-000-49-00-4988 TRANSFER FROM DOWNTOWN TIF - - 13,500 Revenue 633,742 1,552,624 6,549,840 6,821,507 1,757,322 1,170,900 807,500 762,000 762,000 City-Wide-Building&Grounds Expenditures 23-216-54-00-5405 BUILD PROGRAM - 2,400 - - _ _ _ _ _ 23-216-54-00-5446 PROPERTY&BLDG MAINT SERVICES - 80,000 80,000 34,500 34,500 34,500 34,500 34,500 23-216-56-00-5656 PROPERTY&BLDG MAINT SUPPLIES - 25,000 25,000 27,500 30,000 30,000 30,000 30,000 23-216-99-00-9901 TRANSFER TO GENERAL 2,479 5,250 2,500 2,500 2,500 2,500 2,500 2,500 4,879 110,250 107,500 64,500 67,000 67,000 67,000 67,000 28 FY 2013 FY 2014 FY 2015 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected City-Wide Capital Expenditures 23-230-54-00-5402 BOND ISSUANCE COSTS - - 52,025 23-230-54-00-5405 BUILD PROGRAM 80,880 69,234 23-230-54-00-5462 PROFESSIONAL SERVICES 94,728 - - - - _ _ 23-230-54-00-5465 ENGINEERING SERVICES - 21,792 50,000 50,000 50,000 50,000 50,000 50,000 50,000 23-230-54-00-5489 LOSS ON INVESTMENT - - 118,529 - - - _ _ 23-230-54-00-5498 PAYING AGENT FEES - - 525 525 525 525 525 23-230-54-00-5499 BAD DEBT 768 - 1,000 1,000 1,000 1,000 1,000 1,000 23-230-60-00-6007 KENNEDY RD-AUTUMN CREEK 88,105 1,139,622 1,129,606 55,000 - - - _ 23-230-60-00-6008 BEECHER&CORNEILS ROAD - - 25,000 385,000 23-230-60-00-6009 WRIGLEY(RTE 47)EXPANSION - - 707,138 23-230-60-00-6018 GREENBRIAR POND NATURALIZATION - 31,000 17,000 14,000 - - - _ 23-230-60-00-6025 ROAD TO BETTER ROADS PROGRAM 605,242 390,000 390,000 500,000 500,000 386,040 230,668 308,787 23-230-60-00-6041 SIDEWALK CONSTRUCTION 2,916 12,500 12,500 12,500 12,500 12,500 12,500 12,500 23-230-60-00-6048 DOWNTOWN STREETSCAPE IMPROVEMENT - 40,000 30,000 50,000 - - - _ 23-230-60-00-6058 ROUTE 71(RTE 47/ORCHARD RD)PROJECT - - 110,400 23-230-60-00-6059 US 34(IL 47/ORCHARD RD)PROJECT - 230,200 - 15,000 269,142 23-230-60-00-6073 GAME FARM ROAD PROJECT - 5,125 258,000 301,499- 2,048,501 - - 23-230-60-00-6075 RIVER ROAD BRIDGE PROJECT 152,707 221,880 - 152,184 23-230-60-00-6082 COUNTRYSIDE PKY IMPROVEMENTS - - 1,400,000 23-230-60-00-6092 SAFE ROUTE TO SCHOOL PROJECT 37,891 22,707 - - - 23-230-60-00-6094 KENNEDY RD BIKE TRAIL 20,007 87,147 97,700 81,500 42,500 408,900 45,500 23-230-60-00-6095 SUNFLOWER ESTATES-DRAINAGE IMPROVEMENT - - 135,000 126,000 9,000 - - 2014A Bond 23-230-78-00-8000 PRINCIPAL PAYMENT 135,000 185,000 190,000 190,000 195,000 23-230-78-00-8050 INTEREST PAYMENT 195,937 144,138 138,588 132,888 127,188 29 FY 2013 FY 2014 FY 2015 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 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 85,000 75,000 77,419 77,419 77,419 77,419 23-230-99-00-9915 TRANSFER TO MOTOR FUEL TAX - 6,825 386,213 1,199,916 2,469,022 2,416,484 5,835,704 1,394,482 1,281,114 695,000 695,000 Expenditures 386,213 1,204,795 2,579,272 2,523,984 5,900,204 1,461,482 1,348,114 762,000 762,000 Surplus(Deficit) 247,529 347,829 3,970,568 4,297,523 (4,142,882) (290,582) (540,614) - - Fund Balance-CW Municipal Building - - - Fund Balance-City-Vide Capital 328,726 676,555 4,662,971 4,974,078 831,196 540,614 Fund Balance 328,726 676,555 4,662,971 4,974,078 831,196 540,614 30 Vehicle and Equipment Fund(25) This fund was created in Fiscal Year 2014,consolidating the Police Capital,Public Works Capital and Park&Recreation Capital funds. This fund primarily derives its revenue from monies collected from building permits and development fees. The revenue is used to purchase vehicles and equipment for use in the operations of the Police,Public Works and Parks &Recreation Departments. FY 2015 FY 2013 FY 2014 Adopted FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Licenses&Permits 84,459 76,414 49,275 49,275 49,275 49,275 49,275 49,275 49,275 Fines&Forfeits 16,739 8,253 10,750 12,750 12,750 12,750 12,750 12,750 12,750 Charges for Service 6,725 157,495 262,078 257,439 373,063 194,232 194,232 194,232 194,232 Investment Earnings 567 446 450 275 250 250 250 250 250 Reimbursements - 50,000 50,000 99,000 - - - - - Miscellaneous 966 4,994 1,000 1,721 1,000 1,000 1,000 1,000 1,000 Other Financing Sources 2,700 7,825 61,000 61,000 36,000 1,000 1,000 1,000 1,000 Total Revenue 112,156 305,427 434,553 481,460 472,338 258,507 258,507 258,507 258,507 Police Capital Expenditures Contractual Services 17,710 22,521 17,667 17,667 17,667 17,667 17,667 17,667 17,667 Capital Outlay 145,176 93,750 110,000 112,242 204,000 159,000 159,000 159,000 159,000 Sub-Total Expenditures 162,886 116,271 127,667 129,909 221,667 176,667 176,667 176,667 176,667 Public Works Capital Expenditures Contractual Services 26,198 26,929 6,500 5,039 6,500 6,500 6,500 6,500 6,500 Supplies - - 2,000 2,000 2,000 2,000 2,000 2,000 2,000 Capital Outlay - 48,689 160,000 160,000 185,000 - - - - Debt Service 82,295 76,054 70,816 70,816 70,815 70,815 70,815 70,815 70,815 Sub-Total Expenditures 108,493 151,672 239,316 237,855 264,315 79,315 79,315 79,315 79,315 Parks&Rec Capital Expenditures Contractual Services - 800 - 2,705 - - - - - Capital Outlay 17,284 12,143 140,000 113,950 127,929 - - - - Debt Service - 2,383 2,219 2,219 2,219 2,219 2,219 2,219 2,219 Other Financing Uses 2,500 50,000 50,000 - - - - - - Sub-Total Expenditures 19,784 65,326 192,219 118,874 130,148 2,219 2,219 2,219 2,219 Total Expenditures 291,163 333,269 559,202 486,638 616,130 258,201 258,201 258,201 258,201 Surplus(Deficit) (179,007) (27,842) (124,649) (5,178) (143,792) 306 306 306 306 Police Capital Fund Balance 106,687 39,371 (11,730) - - - - Public Works Capital Fund Balance 22,399 74,302 27,899 - - - Parks&Rec Capital Fund Balance 46,502 34,073 126,399 (1,224) (918) (612) (306) Ending Fund Balance 175,588 147,746 142,568 (1,224) (918) (612) (306) $200 Fund Balance a $150 'o $100 r F $50 $0 40 ($50) 31 FY 2013 FY 2014 FY 2015 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Vehicle&Equipment-25 25-000-42-00-4215 DEVELOPMENT FEES-POLICE CAPITAL 23,359 11,750 16,000 16,000 c 16,000 16,000 16,000 16,000 16,000 25-000-42-00-4216 BUILD PROGRAM PERMITS 24,140 30,960 - - - - _ 25-000-42-00-4217 WEATHER WARNING SIREN FEES - 12,264 - - - - - _ 25-000-42-00-4218 ENGINEERING CAPITAL FEE 6,600 3,400 6,500 6,500 6,500 6,500 6,500 6,500 6,500 25-000-42-00-4219 DEVELOPMENT FEES-PW CAPITAL 27,060 16,390 24,500 24,500 24,500 24,500 24,500 24,500 24,500 25-000-42-00-4220 DEVELOPMENT FEES-PARK CAPITAL 3,300 1,650 2,275 2,275 2,275 2,275 2,275 2,275 2,275 25-000-43-00-4315 DUI FINES 6,949 7,569 5,000 7,000 7,000 7,000 7,000 7,000 7,000 25-000-43-004316 ELECTRONIC CITATION FEES 790 684 750 750 750 750 750 750 750 25-00043-004340 SEIZED VEHICLE PROCEEDS 9,000 - 5,000 5,000 5,000 5,000 5,000 5,000 5,000 25-00044-00-4418 MOWING INCOME 6,725 12,845 6,000 1,361 6,000 6,000 6,000 6,000 6,000 25-000-44-004420 POLICE CHARGEBACK - - 49,058 49,058 203,647 146,917 146,917 146,917 146,917 25-00044-00-4421 PUBLIC WORKS CHARGEBACK 144,650 97,370 97,370 163,416 41,315 41,315 41,315 41,315 25-00044-00-4427 PARKS&RECREATION CHARGEBACK - 109,650 109,650 - - - _ _ 25-00045-00-4520 INVESTMENT EARNINGS-POLICE CAPITAL 37 25-000-45-00-4521 INVESTMENT EARNINGS-PW CAPITAL 17 - 25-000-45-00-4522 INVESTMENT EARNINGS-PARK CAPITAL 513 446 450 275 250 250 250 250 250 25-000-46-00-4692 REIMB-MISCELLANEOUS-PARK CAPITAL - 50,000 50,000 99,000 - - - - _ 25-00048-00-4852 MISCELLANEOUS INCOME-POLICE CAPITAL - 4,064 - - - - - _ _ 25-000-48-00-4854 MISCELLANEOUS INCOME-PW CAPITAL 966 930 1,000 1,721 1,000 1,000 1,000 1,000 1,000 25-000-49-00-4920 SALE OF CAPITAL ASSETS-POLICE CAPITAL 200 7,825 1,000 1,000 1,000 1,000 1,000 1,000 1,000 25-000-49-00-4921 SALE OF CAPITAL ASSETS-PW CAPITAL - - 60,000 60,000 35,000 - - - - 25-000-49-00-4924 TRANSFER FROM PARK&REC CAPITAL 2,500 Revenue 112,156 305,427 434,553 481,460 472,338 258,507 258,507 258,507 258,507 Police Capital 25-205-54-00-5405 BUILD PROGRAM - 4,800 25-205-54-00-5462 PROFESSIONAL SERVICES 3,982 95 1,667 1,667 1,667 1,667 1,667 1,667 1,667 25-205-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 13,728 17,626 16,000 16,000 16,000 16,000 16,000 16,000 16,000 25-205-60-00-6060 EQUIPMENT 105,725 - 30,000 32,865 35,000 - - - _ 25-205-60-00-6070 VEHICLES 39,451 93,750 80,000 79,377 169,000 159,000 159,000 159,000 159,000 162,886 116,271 127,667 129,909, 221,667 176,667 176,667 176,667 176,667 32 FY 2013 FY 2014 FY 2015 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Public Works Capital 25-215-54-00-5405 BUILD PROGRAM 24,140 25,360 25-215-54-00-5448 FILING FEES 2,058 1,569 2000 539 2,000 2,000 2,000 2,000 2,000 25-215-54-00-5485 RENTAL&LEASE PURCHASE - - 4,500 4,500 4,500 4,500 4,500 4,500 4,500 25-215-56-00-5620 OPERATING SUPPLIES - 2,000 2,000 2,000 2,000 2,000 2,000 2,000 25-215-60-00-6060 EQUIPMENT 48,689 60,000 60,000 - - - _ - 25-215-60-00-6070 VEHICLES - - 100,()00 100,000 185,000 - - - - 185 Wo f Street Building 25-215-92-00-8000 PRINCIPAL PAYMENT 30,074 33,184 37,924 37,924 39,638 41,430 43,303 45,261 47,307 25-215-92-00-8050 INTEREST PAYMENT 52,221 42,870 32,892 32,892 31,177 29,385 27,512 25,554 23,508 108,493 151,672 239,316 237,855 264,315 79,315 79,315 79,315 79,315 Parks&Recreation Capital 25-225-54-00-5405 BUILD PROGRAM - 800 - - - - - - - 25-225-54-00-5489 LOSS ON INVESTMENT - 2,705 25-225-60-00-6060 EQUIPMENT 17,284 12,143 32,000 - 78,000 25-225-60-00-6065 BRIDGE PARK - - 108,000 81,950 - 25-225-60-00-6068 TRAIL IMPROVEMENTS - - 24,929 25-225-60-00-6070 VEHICLES - - 32,000 25,000 - - - - 185 Wolf Street Building 25-225-92-00-8000 PRINCIPAL PAYMENT 1,040 1,188 1,188 1,242 1,298 1,357 1,418 1,482 25-225-92-00-8050 INTEREST PAYMENT 1,343 1,031 1,031 977 921 862 801 737 33 FY 2013 FY 2014 FY 2015 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected 25-225-99-00-9921 TRANSFER TO PUBLIC WORKS CAPITAL 2,500 - - 25-225-99-00-9972 TRANSFER TO LAND CASH 50,000 50,000 19,784 65,326 192,219 118,874 130,148 2,219 2,219 2,219 2,219 Expenditures 291,163 333,269 559,202 486,638 616,130 258,201 258,201 258,201 258,201 Surplus(Deficit) (179,007) (27,842) (124,649) (5,178) (143,792) 306 306 306 306 Find Balance-Police Capital 106,687 39,371 (11,730) - - - - - Fnnd Balance-Public Works Capital 22,399 74,302 27,899 - - Fund Balance-Parks&Rec Capital 46,501 34,073 126,399 (1,224) (918) (612) (306) Fund Balance 175,588 147,746 142,568 (1,224) (918) (612) (306) - 34 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 2015 FY 2013 FY 2014 Adopted FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes 324,762 315,790 329,579 327,984 165,527 21,764 - - - Licenses&Permits 4,694 6,358 2,500 2,500 4,500 4,500 4,500 4,500 4,500 Investment Earnings 610 78 100 5 - - - - - Other Financing Sources 99,465 - - 2,369,891 132,103 294,411 315,775 320,275 319,575 Total Revenue 429,531 322,226 332,179 2,700,380 302,130 320,675 320,275 324,77.5 324,075 Expenditures Contractual Services 589 775 775 33,895 525 525 525 525 525 Debt Service 504,407 328,179 329,579 304,044 310,250 320,150 319,750 324,250 323,550 Other Financing Uses - - - 2,359,115 - - - - - Total Expenditures 504,996 328,954 330,354 2,697,054 310,775 320,675 320,275 324,775 324,075 Surplus(Deficit) (75,465) (6,728) 1,825 3,326 (8,645) - - - - Ending Fund Balance 12,046 5,319 6,207 8,645 - - - - - N $15 Fund Balance v c $10 0 ®� $0 35 FY 2013 FY 2014 FY 2015 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Debt Service-42 42-000-40-004000 PROPERTY TAXES-2014B BOND 324,762 315,790 329,579 327,984 165,527 21,764 - - 42-000-42-00-4208 RECAPTURE FEES-WATER&SEWER 4,694 5,958 2,500 2,500 4,500 4,500 4,500 4,500 4,500 42-000-42-00-4216 BUILD PROGRAM PERMITS - 400 - - - - - - 42-000-45-00-4500 INVESTMENT EARNINGS 610 78 100 5 - - - - - 42-000-49-00-4901 TRANSFER FROM GENERAL 99,465 - - - 132,103 294,411 315,775 320,275 319,575 42-000-49-00-4902 BOND ISSUANCE - 2,300,000 - - - 42-000-49-004903 PREMIUM ON BOND ISSUANCE 69,891 Revenue 429,531 322,226 332,179 2,700,380 302,130 320,675 320,275 324,775 324,075 42420-54-00-5402 BOND ISSUANCE COSTS - - - 33,306 - - - - - 42420-54-00-5405 BUILD PROGRAM - 400 - - - - - - - 42420-54-00-5498 PAYING AGENT FEES 589 375 775 589 525 525 525 525 525 2014B Refunding Bond 42420-79-00-8000 PRINCIPAL PAYMENT 255,000 270,000 275,000 285,000 290,000 42420-79-00-8050 INTEREST PAYMENT 35d 55,250 50,150 44,750 39,250 33,550 2004C Bond 42420-81-004000 PRINCIPAL PAYMENT 95,000 �s 42420-81-004050 INTEREST PAYMENT 4,465 _Fr 2005A Bond 42-420-82-00-8000 PRINCIPAL PAYMENT 205,000 215,000 225,000 225,000 42420-82-004050 INTEREST PAYMENT 121,379 113,179 104,579 56,790 2002 Fox Industrial TIF Bond 42420-98-00-8000 PRINCIPAL PAYMENT 75,000 42-420-98-00-8050 INTEREST PAYMENT 3,563 42-420-99-00-9960 PAYMENT TO ESCROW AGENT - 2,359,115 Expenditures 504,996 328,954 330,354 2,697,054 310,775 320,675 320,275 324,775 324,075 Surplus(Deficit) (75,465) (6,728) 1,825 3,326 (8,645) - - - - Fund Balance 12,046 5,319 6,207 8,645 - - 36 - 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 2015 FY 2013 FY 2014 Adopted FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes 132,793 41,403 5,235 5,210 - - - - - Licenses&Permits 80,880 84,544 - - - - - - - Charges for Service 2,742,476 2,309,950 2,693,000 2,443,361 3,240,437 3,653,207 3,653,207 3,653,207 3,786,192 Investment Earnings 2,203 2,231 2,200 1,250 500 500 500 500 500 Reimbursements 10,476 14,844 - 500 - - - - - Miscellaneous 53,223 51,917 55,203 57,003 56,307 57,433 58,582 59,754 60,949 Other Financing Sources 82,288 82,988 83,588 83,588 4,376,275 75.075 73,875 77,675 73,875 Total Revenue 3,104,339 2,587,877 2,839,226 2,590,912 7,673,519 3,786,215 3,786,164 3,791,136 3,921,516 Expenses Salaries 337,375 338,959 351,860 351,860 411,332 424,266 437,652 451,507 465,847 Benefits 175,472 185,769 215,055 209,774 240,029 257,923 276,889 297,378 319,505 Contractual Services 490,186 540,175 485,700 520,835 816,370 529,427 546,235 564,051 582,346 Supplies 243,224 243,529 301,234 301,234 302,995 306,481 310,207 314,189 318,445 Capital Outlay 75,305 282,399 571,548 555,544 4,948,544 537,544 949,794 906,794 452,544 Developer Commitments 160,921 - - - - - - - - Debt Service 1,396,016 1,172,802 1,168,384 1,168,385 1,230,445 1,448,688 1,436,579 1,638,392 2,319,929 Total Expenses 2,878,499 2,763,633 3,093,781 3,107,632 7,949,715 3,504,329 3,957,356 4,172,311 4,458,616 Surplus(Deficit) 225,840 (175,756) (254,555) (516,720) (276,196) 281,886 (171,192) (381,175) (537,100) Ending Fund Balance Equivalent 1,526,679 1,350,923 976,762 834,203 558,007 839,893 668,701 287,526 (249,574) 53.04% 48.88% 31.57% 26.84% 7.02% 23.97% 16.90% 6.89% -5.60% $2,000 Fund Balance Equivalent a $1,500 'o $1,000 $500 $0 ($500) FY 2013 FY 2014 FY 2015 FV 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Water-51 51-000-40-00-4000 PROPERTY TAXES-2007A BOND 132,793 41,40-1 5,235 5,210 51-00042-00-4216 BUILD PROGRAM PERMITS 80,880 84,544 - - - - - - 51-000-44-00-4424 WATER SALES 1,843,103 1,789,296 2,127,500 1,952,841 2,316,937 2,659,707 2,659,707 2,659,707 2,792,692 51-000-44-00-4425 BULK WATER SALES 10,796 4,750 500 15,520 500 500 500 500 500 51-00044-00-4426 LATE PENALTIES-WATER 97,601 92,386 90,000 90,000 90,000 90,000 90,000 90,000 90,000 51-000-44-00-4430 WATER METER SALES 36,725 47,785 30,000 20,000 35,000 35,000 35,000 35,000 35,000 51-000-44-004440 WATER INFRASTRUCTURE FEE 691,321 341,083 340,000 340,000 693,000 693,000 693,000 693,000 693,000 51-000-44-00-4450 WATER CONNECTION FEES 62,930 34,650 105.000 25.000 105,000 175,000 175,000 175,000 175,000 51-000-45-004500 INVESTMENT EARNINGS 2,203 2,231 2,200 1,250 500 500 500 500 500 51-000-46-00-4670 REIMB-EMPLOYEE INS CONTRIBUTIONS 8,294 - - - - - - - - 51-000-46-00-4671 REIMB-LIFE INSURANCE 164 - - 51-000-46-00-4690 REIMB-MISCELLANEOUS 2,018 14,844 - 500 - - - - - 51-000-48-00-4820 RENTAL INCOME 53,073 51,917 55,203 55,203 56,307 57,433 58,582 59,754 60,949 51-00048-00-4850 MISCELLANEOUS INCOME 150 - - 1,800 - - - - - 51-000-49-00-4900 BOND PROCEEDS - - - - 4,300,000 - - - - 51-00049-00-4952 TRANSFER FROM SEWER 82,288 82,988 83,588 83,588: 76,275 75,075 73,875 77,675 73,875 Revenue 3,104,339 2,587,877 2,839,226 2,590,912 7,673,519 3,786,215 3,786,164 3,791,136 3,921,516 Water Operations 51-510-50-00-5010 SALARIES&WAGES 331,616 325,817 334,060 334,060 369,532 382,466 395,852 409,707 424,047 51-510-50-00-5015 PART-THAE SALARIES - - 5,800 5,800 29,800 29,800 29,800 29,800 29,800 51-510-50-00-5020 OVERTIME 5,759 13,142 12,000 12,000 12,000 12,000 12,000 12,000 12,000 51-510-52-00-5212 RETIREMENT PLAN CONTRIBUTION 35,140 37,447 41,270 41,270 42,446 46,890 51,421 56,417 61,911 51-510-52-00-5214 FICA CONTRIBUTION 24,639 24,787 25,687 25,687 30,514 31,582 32,687 33,831 35,015 51-510-52-00-5216 GROUP HEALTH INSURANCE 85,844 92,981 111,893 111,893 131,003 141,483 152,802 165,026 178,228 51-510-52-00-5222 GROUP LIFE INSURANCE 883 675 681 681 708 715 722 729 736 51-510-52-00-5223 DENTAL INSURANCE 6,461 5,516 5,792 5,792 8,117 8,523 8,949 9,396 9,866 51-510-52-00-5224 VISION INSURANCE 713 729 751 751 861 887 914 941 969 51-510-52-00-5230 UNEMPLOYMENT INSURANCE 1,025 574 3,000 700 2,000 2,000 2,000 2,000 2,000 51-510-52-00-5231 LIABILITY INSURANCE 20,767 23,060 25,981 23,000 24,380 25,843 27,394 29,038 30,780 51-510-54-00-5402 BOND ISSUANCE COSTS - - - 24,378 50,000 - - - - 38 FY 2013 FY 2014 FY 2015 . FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected 51-510-54-00-5405 BUILD PROGRAM 80,880 84,544 - - - - - 51-510-54-00-5412 TRAINING&CONFERENCES 600 3,044 3,000 3,000 5,800 3,000 3,000 3,000 3,000 51-510-54-00-5415 TRAVEL&LODGING 293 528 1,600 1,600 1,600 1,600 1,600 1,600 1,600 51-510-54-00-5426 PUBLISHING&ADVERTISING 1,117 787 1,000 1,000 1,000 1,000 1,000 1,000 1,000 51-510-54-00-5429 WATER SAMPLES 7,170 11,340 14,000 14,000 14,000 14,000 14,000 14,000 14,000 51-510-54-00-5430 PRINTING&DUPLICATING 42 61 2,500 2,500 3,300 3,300 3,300 3,300 3,300 51-510-54-00-5440 TELECOMMUNICATIONS 22,942 20,065 24,500 24,500 24,500 24,500 24,500 24,500 24,500 51-510-54-00-5445 TREATMENT FACILITY SERVICES 89,598 119,912 100,000 100,000 112,000 112,000 112,000 112,000 112,000 51-510-54-00-5448 FILINGFEES 6,399 5,831 6,500 6,500 6,500 6,500 6,500 6,500 6,500 51-510-54-00-5452 POSTAGE&SHIPPING 17,609 16,276 22,000 22,000 19,000 19,000 19,000 19,000 19,000 51-510-54-00-5460 DUES&SUBSCRIPTIONS 858 1,568 1,250 1,250 1,600 1,600 1,600 1,600 1,600 51-510-54-00-5462 PROFESSIONAL SERVICES 13,585 21,047 15,000 15,000 21,500 21,500 21,500 21,500 21,500 51-510-54-00-5465 ENGINEERING SERVICES - - - - 250,000 - - - - 51-510-54-00-5466 LEGAL SERVICES - - 2,000 2,000 2,000 2,000 2,000 2,000 2,000 51-510-54-00-5480 UTILITIES 208,439 218,196 258,750 258,750 264,275 280,132 296,940 314,756 333,641 51-510-54-00-5483 JULIE SERVICES 6,534 4,520 4,500 4,500 4,500 4,500 4,500 4,500 4,500 51-510-54-00-5485 RENTAL&LEASE PURCHASE 492 504 1,000 1,000 1,000 1,000 1,000 1,000 1,000 51-510-54-00-5489 LOSS ON INVESTMENT - - - 15,757 - - - - - 51-510-54-00-5490 VEHICLE MAINTENANCE SERVICES 9,790 3,181 6,000 6,000 7,500 7,500 7,500 7,500 7,500 51-510-54-00-5495 OUTSIDE REPAIR&MAINTENCE 4,961 19,460 4,000 4,000 14,000 14,000 14,000 14,000 14,000 51-510-54-00-5498 PAYING AGENT FEES 1,338 1,338 3,100 3,100 2,295 2,295 2,295 2,295 1,705 51-510-54-00-5499 BAD DEBT 17,539 7,973 15,000 10,000 10,000 10,000 10,000 10,000 10,000 51-510-56-00-5600 WEARING APPAREL 3,067 3,340 4,000 4,000 4,200 4,410 4,631 4,863 5,106 51-510-56-00-5620 OPERATING SUPPLIES 14,601 8,167 25,000 25,000 15,000 15,000 15,000 15,000 15,000 51-510-56-00-5628 VEHICLE MAINTENANCE SUPPLIES - 1,092 8,500 8,500 10,000 10,000 10,000 10,000 10,000 51-510-56-00-5630 SMALL TOOLS&EQUIPMENT 3,548 1,429 2,000 2,000 2,000 2,000 2,000 2,000 2,000 51-510-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 104 876 6,000 6,000 2,000 2,000 2,000 2,000 2,000 51-510-56-00-5638 TREATMENT FACILITY SUPPLIES 155,048 125,445 155,000 155,000 165,000 165,000 165,000 165,000 165,000 51-510-56-00-5640 REPAIR&MAINTENANCE 9,892 20,785 9,500 9,500 10,500 10,500 10,500 10,500 10,500 51-510-56-00-5664 METERS&PARTS 32,809 51,805 46,000 46,000 46,000 46,000 46,000 46,000 46,000 51-510-56-00-5665 JULIE SUPPLIES - 968 1,500 1,500 1,500 1,500 1,500 1,500 1,500 51-510-56-00-5695 GASOLINE 24,155 29,622 43,734 43,734 46,795 50,071 53,576 57,326 61,339 51-510-60-00-6022 WELL REHABILITATIONS - - - - 143,000 - 166,000 123,000 150,000 39 FY 2013 FY 2014 FY 2015 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected 51-510-60-00-6025 ROAD TO BETTER ROADS PROGRAM 153,305 353,000 353,000 300,000 300,000 100,000 100,000 100,000 51-510-60-00-6060 EQUIPMENT - 5,000 5,000 5,000 5,000 5,000 5,000 5,000 51-510-60-00-6066 RTE 71 WATERMAIN RELOCATION - - 35,000 35,000 481,250 481,250 - 51-510-60-00-6070 VEHICLES - - 18,000 18,000 - - - - 51-510-60-00-6079 ROUTE 47 EXPANSION 75,305 129,094 195,548 197,544'- 197,544 197,544 197,544 197,544 197,544 51=510-60-00-6082 COUNTRYSIDE PKY IMPROVEMENTS - - - - 4,250,000 - - - - 51-510-75-00-7502 GRANDE RESERVE COURT ORDER 160,921 - - - - - 2015 Bond 51-510-77-00-8000 PRINCIPAL PAYMENT - 190,000 190,000 190,000 195,000 51-510-77-00-8050 INTEREST PAYMENT - - - - 83,016 110,688 109,168 107,268 104,893 Debt Service-2007A Bond 51-510-83-00-8000 PRINCIPAL PAYMENT 10,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 680,000 51-510-83-00-8050 INTEREST PAYMENT 123,454 123,041 122,423 122,423 121,793 121,163 120,525 119,888 119,250 Debt Service-2002 Capital Appreciation Debt Certificates 51-510-85-00-8000 PRINCIPAL PAYMENT 365,000 Debt Service-2003 Debt Certificates 51-510-86-00-8000 PRINCIPAL PAYMENT - 100,000 100,000 100,000 100,000 100,000 100,000 300,000 51-510-86-00-8050 INTEREST EXPENSE 33,150 33,150 29,350 29,350 25,450 21,450 17,300 13,050 - Debt Service-2006A Refunding Debt Certificates 51-510-87-00-8000 PRINCIPAL PAYMENT 355,000 405,000 420,000 420,000 435,000 460,000 475,000 495,000 850,000 51-510-87-00-8050 INTEREST EXPENSE 219,806 205,606 189,406 189,406 172,606 155,206 136,806 117,806 98,006 Debt Service-2005C Bond 51-510-88-00-8000 PRINCIPAL PAYMENT 90,000 95,000 100,000 100,000 51-510-88-00-8050 INTEREST EXPENSE 74,575 70,975 67,175 54,065 - - - - - Debt Service-IEPA Loan L17-156300 51-510-89-00-8000 PRINCIPAL PAYMENT 87,754 89,961 92,224 92,224 94,544 96,923 99,361 101,860 104,423 51-510-89-00-8050 INTEREST EXPENSE 37,277 35,069 32,806 32;806 30,486 28,108 25,669 23,170 20,607 40 FY 2013 FY 2014 FY 2015 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Debt Service-2014C Refunding Bond 51-510-94-00-8000 PRINCIPAL PAYMENT 120,000 120,000 120,000 130,000 125,000 51-510-94-00-8050 INTEREST PAYMENT 13,1 32,550 30,150 27,750 25,350 22,750 Expenses 2,878,499 2,763,633 3,093,781 3,107,632 7,949,715 3,504,329 3,957,356 4,172,311 4,458,616 Surplus(Deficit) 225,840 (175,756) (254,555) (516,720) (276,196) 281,886 (171,192) (381,175) (537,100) Fund Balance Equiv 1,526,679 1,350,923 976,762 834,203 558,007 839,893 668,701 287,526 (249,574) 53.04% 48.88% 31.57% 26.84% 7.02% 23.97% 16.90% 689% -5.60% 41 Sewer Fund(52) The Sewer Fund is an enterprise fund which is comprised of both a capital and operational budget. The capital portion is used for improvement and expansion of the sanitary sewer infrastructure while the operational side allows the City to service and maintain sanitary sewer systems. FY 2015 FY 2013 FY 2014 Adopted FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes 262,543 110,601 - - - - - - - Licenses&Permits 24,000 16,800 - - - - - - - Charges for Service 1,348,205 1,114,432 1,140,500 1,143,004 1,180,200 1,204,140 1,228,920 1,254,540 1,280,836 Investment Earnings 7,339 9,260 6,000 5,500 1,500 1,500 1,500 1,500 1,500 Reimbursements 7,908 1,300 - 1,100 200,000 200,000 200,000 200,000 200,000 Other Financing Sources - 1,137,220 1,238,972 1,243,972 1,134,654 1,134,052 1,137,166 1,133,782 1,134,114 Total Revenue 1,649,995 2,389,613 2,385,472 2,393,576 2,516,354 2,539,692 2,567,586 2,589,822 2,616,450 Expenses Salaries 190,452 164,273 195,304 195,304 205,003 212,108 219,462 227,073 234,951 Benefits 95,946 80,030 105,056 97,492 127,049 137,155 147,325 158,316 170,190 Contractual Services 89,177 75,530 95,578 169,634 82,845 83,913 86,943 90,143 92,934 Supplies 44,378 66,064 90,144 90,144 92,610 95,246 98,064 101,077 104,298 Capital Outlay 38,951 66,773 593,095 725,575 459,015 459,015 459,015 459,015 459,015 Developer Commitments 30,996 - - 62,922 32,891 33,872 34,888 35,939 28,204- Debt Service 1,088,012 1,968,119 2,054,461 2,054,461 1,865,399 1,865,857 1,877,110 1,880,265 1,352,307 Other Financing Uses 82,288 82,988 83,588 83,588 76,275 75,075 73,875 77,675 73,875 Total Expenses 1,660,200 2,503,777 3,217,226 3,479,120 2,941,087 2,962,241 2,996,682 3,029,503 2,515,774 Surplus(Deficit) (10,205) (114,164) (831,754) (1,085,544) (424,733) (422,549) (429,096) (439,681) 100,676 Ending Fund Balance Equivalent 2,993,332 2,879,170 1,959,540 1,793,626 1,368,893 946,344 517,248 77,567 178,243 180.30% 114.99% 60.91% 51.55% 46.54% 31.95% 17.26% 2.56% 7.09% $4,000 Fund Balance Equivalent $3,000 3 < O F $2,000 $1,000 $0 42 FY 2013 FY 2014 FY 2015 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Sewer-52 52-000-40-00-4000 PROPERTY TAXES-2004B BOND 262,543 110,601 52-000-42-00-4216 BUILD PROGRAM PERMITS 24,000 16,800 - - - - - 52-000-44-00-4435 SEWER MAINTENANCE FEES 744,820 756,746 772,500 778,680 802,200 826,140 850,920 876,540 902,836 52-000-44-00-4440 SEWER INFRASTRUCTURE FEE - 333,587 330,000 340,000 340,000 340,000 340,000 340,000 340,000 52-000-44-00-4455 SW CONNECTION FEES-OPERATIONS 200 800 5,000 1,000 5,000 5,000 5,000 5,000 5,000 52-000-44-00-4456 SW CONNECTION FEES-CAPITAL 3,400 9,200 20,000 10,000 20,000 20,000 20,000 20,000 20,000 52-000-44-00-4457 SW CONNECTION FEES-ROB ROY 586,000 - - - - - - - - 52-000-44-00-4462 LATE PENALTIES-SEWER 13,271 13,821 13,000 13,000 13,000 13,000 13,000 13,000 13,000 52-00044-00-4465 RIVER CROSSING FEES 514 278 - 324 - - - - 52-000-45-00-4500 INVESTMENT EARNINGS 7,339 9,260 6,000 5,500 1,500 1,500 1,500 1,500 1,500 52-000-46-00-4625 REIMS-I&I REDUCTIONS - - - - 200,000 200,000 200,000 200,000 200,000 52-000-46-00-4670 REIMS-EMPLOYEE INS CONTRIBUTIONS 4,240 - - - - - - - 52-000-46-00-4690 REIMS-MISCELLANEOUS 3,668 1,300 - 1,100 - - - - - 52-000-49-00-4901 TRANSFER FROM GENERAL - 1,137,220 1,133,972 1,133,972 1,134,654 1,134,052 1,137,166 1,133,782 1,134,114 52-000-49-00-4910 SALE OF CAPITAL ASSETS - 105,000 110,000 Revenue 1,649,995 2,389,613 2,385,472 2,393,576- 2,516,354 2,539,692 2,567,586 2,589,822 2,616,450 Sewer Operations 52-520-50-00-5010 SALARIES&WAGES 189,733 164,160 193,304 193,304 203,003 210,108 217,462 225,073 232,951 52-520-50-00-5020 OVERTIME 719 113 2,000 2,000 2,000 2,000 2,000 2,000 2,000 52-520-52-00-5212 RETIREMENT PLAN CONTRIBUTION 20,244 18,268 23,291 23,291 22,807 25,759 28,248 30,993 34,011 52-520-52-00-5214 FICA CONTRIBUTION 14,245 12,371 14,661 14,661 15,177 15,708 16,258 16,827 17,416 52-520-52-00-5216 GROUP HEALTH INSURANCE 42,818 32,305 44,546 44,546 70,903 76,575 82,701 89,317 96,462 52-520-52-00-5222 GROUP LIFE INSURANCE 377 265 346 346 373 377 381 385 389 52-520-52-00-5223 DENTALINSURANCE 3,521 2,006 2,879 2,879 4,650 4,883 5,127 5,383 5,652 52-520-52-00-5224 VISION INSURANCE 378 277 369 369 479 493 508 523 539 52-520-52-00-5230 UNEMPLOYMENT INSURANCE 552 302 2,000 400 1,000 1,000 1,000 1,000 1,000 52-520-52-00-5231 LIABILITY INSURANCE 13,811 14,236 16,964 11,000 11,660 12,360 13,102 13,888 14,721 52-520-54-00-5405 BUILD PROGRAM 24,000 16,800 - - - - - - 52-520-54-00-5412 TRAINING&CONFERENCES - _ 500 500 2,300 500 500 500 500 52-520-54-00-5415 TRAVEL&LODGING 43 500 500 500 500 500 500 500 43 FY 2013 FY 2014 FY 2015 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Account Number Description Actual Actual 'Budget Projected" Adapted Projected Projected Projected Projected 52-520-54-00-5430 PRINTING&DUPLICATING 29 28 100 100 1,700 1,700 1,700 1,700 1,700 52-520-54-00-5440 TELECOMMUNICATIONS 1,521 1,848 2,500 2,500 2,500 2,500 2,500 2,500 2,500 52-520-54-00-5444 LIFT STATION SERVICES 9,695 18,582 16,538 16,538 21,365 22,433 23,555 24,733 25,970 52-520-54-00-5462 PROFESSIONAL SERVICES 2,893 4,917 7,500 7,500 8,000 8,000 8,000 8,000 8,000 52-520-54-00-5480 UTILITIES 36,672 24,674 50,715 50,715 30,000 31,800 33,708 35,730 37,874 52-520-54-00-5485 RENTAL&LEASE PURCHASE 492 504 1,500 1,500 1,500 1,500 1,500 1,500 1,500 52-520-54-00-5489 LOSS ON INVESTMENT - - 74,056 - - - - - 52-520-54-00-5490 VEHICLE MAINTENANCE SERVICES 8,388 1,663 5,000 5,000 5,000 5,000 5,000 5,000 5,000 52-520-54-00-5495 OUTSIDE REPAIR&MAINTENCE - 2,100 4,000 4,000 4,000 4,000 4,000 4,000 4,000 52-520-54-00-5498 PAYING AGENT FEES 2,812 2,920 3,725 3,725 2,980 2,980 2,980 2,980 2,390 52-520-54-00-5499 BAD DEBT 2,632 1,494 3,000 3,000 3,000 3,000 3,000 3,000 3,000 52-520-56-00-5600 WEARING APPAREL 3,194 2,930 2,500 2,500 2,625 2,756 2,894 3,039 3,191 52-520-56-00-5610 OFFICE SUPPLIES 1,264 2,342 2,000 2,000 2,000 2,000 2,000 2,000 2,000 52-520-56-00-5613 LIFT STATION MAINTENANCE 3,071 2,682 12,000 12,000 12,000 12,000 12,000 12,000 12,000 52-520-56-00-5620 OPERATING SUPPLIES 4,413 3,959 4,500 4,500 4,500 4,500 4,500 4,500 4,500 52-520-56-00-5628 VEHICLE MAINTENANCE SUPPLIES - 3,557 2,000 2,000 2,000 2,000 2,000 2,000 2,000 52-520-56-00-5630 SMALL TOOLS&EQUIPMENT 2,481 7,867 2,500 2,500 2,500 2,500 2,500 2,500 2,500 52-520-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - 225 1,200 1,200 1,200 1,200 1,200 1,200 1,200 52-520-56-00-5640 REPAIR&MAINTENANCE 7,547 12,777 30,000 30,000 30,000 30,000 30,000 30,000 30,000 52-520-56-00-5695 GASOLINE 22,408 29,725 3,A44 33,444 35,785 38,290 40,970 43,838 46,907 52-520-60-00-6025 ROAD TO BETTER ROADS PROGRAM - - 200,000 200,000 200,000 200,000 200,000 200,000 200,000 52-520-60-00-6028 SANITARY SEWER LINING - 86,574 200,000 200,000 200,000 200,000 200,000 52-520-60-00-6070 VEHICLES - - 333,997 379,986 - - - - - 52-520-60-00-6079 ROUTE 47 EXPANSION 38,951 66,773 59,098 59,015 59,015 59,015 59,015 59,015 59,015 52-520-75-00-7500 LENNAR-RAINTREE SEWER RECPATURE 30,996 62,922 32,891 33,872 34,888 35,939 28,204 Debt Service-2004B Bond 52-520-84-00-8000 PRINCIPAL PAYMENT 170,000 280,000 375,000 375,000 395,000 410,000 435,000 455,000 52-520-84-00-8050 INTEREST EXPENSE 93,850 88,750 78,950 78,950 65,825 52,000 35,600 18,200 - Debt Service-2003A IRBB Debt Certificates 52-520-90-00-8000 PRINCIPAL PAYMENT 100,000 100,000 105,000 105,000 110,000 115,000 120,000 130,000 135,000 52-520-90-00-8050 INTEREST EXPENSE 66,248 62,048 57,648 57,648 52,870 47,755 42,293 36,233 29,668 44 FY 2013 FY 2014 FY 2015 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Debt Service-2004A Debt Certificates 52-520-91-00-8000 PRINCIPAL PAYMENT 175,000 180,000 190,000 190,000 52-520-91-00-8050 INTEREST EXPENSE 18,738 13,050 6,840 6,840 - _ _ _ Debt Service-2011 Refunding Bond 52-520-92-00-8000 PRINCIPAL PAYMENT - 660,000 685,000 685,000 715,000 745,000 780,000 810,000 845,000 52-520-92-00-8050 INTEREST EXPENSE 318,147 477,220 448,972 448,972 419,654 389,052 357,166 323,782 289,114 Debt Service-IEPA Loan L17-013000 52-520-95-00-8000 PRINCIPAL PAYMENT 37,958 - - - - - 52-520-95-00-8050 INTEREST EXPENSE 1,021 Debt Service-IEPA Loan L17-115300 52-520-96-00-8000 PRINCIPAL PAYMENT 88,610 90,952 93,355 93,355 95,821 98,353 100,952 103,619 52,832 52-520-96-00-8050 INTEREST EXPENSE 18,440 16,099 13,696 13,696 11,229 8,697 6,099 3,431 693 52-520-99-00-9951 TRANSFER TO WATER 82,288 82,988 83,588 83,588 76,275 75,075 73,875 77,675 73,875 Expenses 1,660,200 2,503,777 3,217,226 3,479,120 2,941,087 2,962,241 2,996,682 3,029,503 2,515,774 Surplus(Deficit) (10,205) (114,164)- (831,754) (1,085,544) (424,733) (422,549) (429,096) (439,681) 100,676 Fund Balance Equiv 2,993,332 2,879,170 1,959,540 1,793,626 1,368,893 946,344 517,248 77,567 178,243 180.30% 114.99% 60.91% 51.55% 46.54% 31.950% 17.26% 2.56% 7.09% 45 Land Cash Fund(72) Land-Cash funds are dedicated by developers through the contribution ordinance to serve the immediate and future needs of park and recreation of residents in new subdivisions.Land for park development and cash spent on recreational facilities is often matched through grant funding to meet the community's recreation needs at a lower cost to the City. FY 2015 FY 2013 FY 2014 Adopted FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Intergovernmental 400,000 31,286 - 40,144 400,000 400,000 - - - Licenses&Permits - 1,733 - - - - - - - Investment Earnings - 4 - - - - - - - Land Cash Contributions 68,768 54,579 23,000 38,405 30,500 30,500 30,500 30,500 30,500 Reimbursements - - - 83,311 - - - - - Other Financing Sources - 50,000 50,000 - - - - - - Total Revenue 468,768 137,602 73,000 161,860 430,500 430,500 30,500 30,500 30,500 Expenditures Contractual Services - 1,733 - - - - - - - Capital Outlay 52,570 69,304 406,850 384,679 580,832 100,000 - - - Total Expenditures 52,570 71,037 406,850 384,679 580,832 100,000 - - - Surplus(Deficit) 416,198 66,565 (333,850) (222,819) (150,332) 330,500 30,500 30,500 30,500 Ending Fund Balance 121,420 187,984 (145,213) (34,835) (185,167) 145,333 175,833 206,333 236,833 Fund Balance N $300 $200 3 $100 r $0 ($100) ($200) ($300) 46 FY 2013 FY 2014 FY 2015 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Land Cash-72 72-00041-004173 OSLAD GRANT-RAINTREE 400,000 72-000-41-00-4174 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 - - 400,000 72-000-42-00-4216 BUILD PROGRAM PERMITS 1,733 - 72-000-45-00-4500 INVESTMENT EARNINGS 4 - 72-000-46-00-4655 REIMB-GRANDE RESERVE PARK B - 83,311 72-000-47-004701 WHITE OAK - - - 1,406 - - - - 72-000-47-00-4703 AUTUMN CREEK 66,662 42,367 20,000 30,000 30,000 30,000 30,000 30,000 30,000 72-000-47-00-4704 BLACKBERRY WOODS 568 2,841 500 5,114- 500 500 500 500 500 72-000-47-00-4706 CALEDONIA - - 2,500 - - - - - - 72-000-47-00-4708 COUNTRY HILLS 1,538 - - 72-000-47-00-4736 BRIARWOOD - 9,371 1,885 72-000-49-00-4925 TRANSFER FROM VEHICLE&EQUIPMENT 50,000 50,000 - Revenue 468,768 137,602 73,000" 161,860 430,500 430,500 30,500 30,500 30,500 72-720-54-00-5405 BUILD PROGRAM 1,733 72-720-60-00-6028 CANNONBALL PARK - 16,897 72-720-60-00-6032 MOSER HOLDING COSTS 12,000 12,000 13,000 ;13,000 13,000 72-720-60-00-6036 RAINTREE VILLAGE 40,570 - - - - - 72-720-60-00-6043 BRISTOL BAY REGIONAL PARK - 3,406 7,168 292,832 100,000 72-720-60-00-6044 CLARK PARK 31,613 - 20,661 - - 72-720-60-00-6045 RIVERFRONT PARK 4,650 200,000 200,000 200,000 72-720-60-00-6046 GRANDE RESERVE PARK A - - - 50,000 72-720-60-00-6047 GRANDE RESERVE PARK B 738 143,850 143,850 - 72-720-60-00-6049 RAINTREE PARK C 50,000 72-720-60-00-6067 BLACKBERRY CREEK NATURE PRESERVE 25,000 Expenditures 52,570 71,037 406,850 384,679 580,832 100,000 - - - Surplus(Deficit) 416,198 66,565 (333,850) (222,819) (150,332) 330,500 30,500 30,500 30,500 Fund Balance 121,420 187,984 (145,213) (34,835) (185,167) 145,333 175,833 206,333 236,833 47 Parks and Recreation Fund(79) This fund accounts for the daily operations of the Parks and Recreation Department. Programs,classes,special events and maintenance of City wide park land and public facilities make up the day to day operations. Programs and classes consist of a wide variety of options serving children through senior citizens. Special events range from Music Under the Stars to Home Town Days. City wide maintenance consists of over two hundred acres at more than fifty sites including buildings,boulevards,parks,utility locations and natural areas. FY 2015 FY 2013 FY 2014 Adopted FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Charges for Service 265,614 299,478 280,000 339,000 325,000 325,000 325,000 325,000 325,000 Investment Earnings 244 382 250 650 400 400 400 400 400 Reimbursements 20,947 35,728 - - - - - - - Miscellaneous 195,868 188,824 208,000 167,000 181,000 191,000 200,700 200,700 200,700 Other Financing Sources 955,886 1,765,504 1,277,606 1,277,606 1,076,831 1,342,684 1,395,093 1,460,521 1,529,934 Total Revenue 1,438,559 2,289,916 1,765,856 1,784,256 1,583,231 1,859,084 1,921,193 1,986,621 2,056,034 Expenditures Salaries 671,149 708,142 840,647 793,864 863,762 889,678 916,501 944,263 972,997 Benefits 283,568 312,171 397,762 397,762 382,912 411,602 442,432 475,799 511,898 Contractual Services 159,624 217,004 374,430 368,407 234,780 232,980 234,252 235,600 237,029 Supplies 283,915 337,444 298,608 288,608 314,486 316,588 318,832 321,228 323,787 Other Financing Uses - 489,043 - - - - - - - Total Expenditures 1,398,256 2,063,804 1,911,447 1,848,641 1,795,940 1,850,848 1,912,017 1,976,890 2,045,711 Surplus(Deficit) 40,303 226,112 (145,591) (64,385) (212,709) 8,236 9,176 9,731 10,323 Ending Fund Balance 320,370 546,485 286,717 482,100 269,391 277,627 286,803 296,534 306,857 22.91% 2648% 15.00% 2608% 15.00% 15.00% 15.00% 15.00% 15.00% $600 Fund Balance $400 0 r ~ $200 $0 48 FY 2013 FY 2014 FY 2015 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Parks and Recreation-79 79-000-44-00-4402 SPECIAL EVENTS 35,120 47,745 35,000 70,000 60,000 60,000 60,000 60,000 60,000 79-000-44-00-4403 CHILD DEVELOPMENT 59,559 81,114 -- 75,000 100,000 90,000 90,000 90,000 90,000 90,000 79-000-44-00-4404 ATHLETICS&FITNESS 138,466 139,158 140,000 140,000 145,000 145,000 145,000 145,000 145,000 79-000-44-00-4441 CONCESSION REVENUE 32,469 31,461 30,000 29,000 30,000 30,000 30,000 30,000 30,000 79-000-45-00-4500 INVESTMENT EARNINGS 244 382 250 650 400 400 400 400 400 79-000-46-00-4670 REIMB-EMPLOYEE INS CONTRIBUTIONS 12,521 - - - - - - - 79-000-46-00-4690 REIMB-MISCELLANEOUS 8,426 35,728 - - - - - - - 79-000-48-00-4820 RENTAL INCOME 54,758 52,859 50,000 40;000 40,000 50,000 50,000 50,000 50,000 79-000-48-00-4825 PARK RENTALS 12,552 34,559 25,000 28,000 25,000 25,000 25,000 25,000 25,000 79-000-48-00-4843 HOMETOWN DAYS 119,235 90,597 125,000 88,000 108,000 108,000 108,000 108,000 108,000 79-000-48-00-4846 SPONSORSHIPS&DONATIONS 5,569 4,582 5,000 8,000 5,000 5,000 14,700 14,700 14,700 79-000-48-00-4850 MISCELLANEOUS INCOME 3,754 6,227 3,000 3,000 3,000 3,000 3,000 3,000 3,000 79-000-49-00-4901 TRANSFER FROM GENERAL 955,886 1,765,504 1,277 606 1,277,606 1,076,831 1,342,684 1,395,093 1,460,521 1,529,934 Revenue 1,438,559 2,289,916 1,765,856 1,784,256 1,583,231 1,859,084 1,921,193 1,986,621 2,056,034 Parks Department 79-790-50-00-5010 SALARIES&WAGES 400,384 410,777 447,564 447,564 477,325 494,031 511,322 529,218 547,741 79-790-50-00-5015 PART-TIME SALARIES 17,932 17,207 34,000 34,000 30,000 30,000 30,000 30,000 30,000 79-790-50-00-5020 OVERTIME 1,431 514 3,000 3,000 3,000 3,000 3,000 3,000 3,000 79-790-52-00-5212 RETIREMENT PLAN CONTRIBUTION 43,342 46,293 53,733 53,733 53,437 60,568 66,421 72,873 79,970 79-790-52-00-5214 FICA CONTRIBUTION 31,109 31,909 36,183 36,183 38,169 39,505 40,888 42,319 43,800 79-790-52-00-5216 GROUP HEALTH INSURANCE 110,141 109,505 132,108 132,108 131,148 141,640 152,971 165,209 178,426 79-790-52-00-5222 GROUP LIFE INSURANCE 936 878 924 924 951 961 971 981 991 79-790-52-00-5223 DENTAL INSURANCE 7,954 6,873 7,728 7,728 9,706 10,191 10,701 11,236 11,798 79-790-52-00-5224 VISION INSURANCE 932 957 1,032 1032 1,002 1,032 1,063 1,095 1,128 79-790-54-00-5412 TRAINING&CONFERENCES 1,333 1,663 7,000 7,000 10,000 7,000 7,000 7,000 7,000 79-790-54-00-5415 TRAVEL&LODGING 329 114 ` 3,000 3,000 3,000 3,000 3,000 3,000 3,000 79-790-54-00-5422 VEHICLE&EQUIPMENT CHARGEBACK - - 109,650 109,650 - - - - - 79-790-54-00-5440 TELECOMMUNICATIONS 3,863 3,913 4,780'- 4,780 4,780 4,780 4,780 4,780 4,780 79-790-54-00-5462 PROFESSIONAL SERVICES 2,280 1,786 4,500 4,500 3,000 3,000 3,000 3,000 3,000 79-790-54-00-5466 LEGAL SERVICES 5,938 5,216 4,000 6,000 6,000 6,000 6,000 6,000 6,000 49 FY 2013 FY 2014 FY 2015 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected 79-790-54-00-5485 RENTAL&LEASE PURCHASE 620 2,600 2,500 2,500 2,500 2,500 2,500 2,500 2,500 79-790-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 26,194 37,059 32,500 32,500 32,500 32,500 32,500 32,500 32,500 79-790-56-00-5600 WEARING APPAREL 4,603 4,806 4,700 4,700 4,935 5,182 5,441 5,713 5,999 79-790-56-00-5610 OFFICE SUPPLIES 167 71 300 300 300 300 300 300 300 79-790-56-00-5620 OPERATING SUPPLIES 17,900 32,327 22,500 22,500 22,500 22,500 22,500 22,500 22,500 79-790-56-00-5630 SMALL TOOLS&EQUIPMENT 3,093 4,288 7,000 7,000 2,250 2,250 2,250 2,250 2,250 79-790-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - - 500 500 500 500 500 500 500 79-790-56-00-5640 REPAIR&MAINTENANCE 54,036 79,678 50,500 50,500 50,500 50,500 50,500 50,500 50,500 79-790-56-00-5695 GASOLINE 19,973 20,202 22,898 22,898 24,501 26,216 28,051 30,015 32,116 754,490 818,636 992,600 994,600 912,004 947,156 985,659 1,026,489 1,069,799 Recreation Department 79-795-50-00-5010 SALARIES&WAGES 202,126 225,784 273,783 248,000 263,137 272,347 281,879 291,745 301,956 79-795-50-00-5015 PART-TRv1E SALARIES 11,457 13,524 23,000 15,000 25,000 25,000 25,000 25,000 25,000 79-795-50-00-5020 OVERTIME - - 300 300 300 300 300 300 300 79-795-50-00-5045 CONCESSION WAGES 8,341 10,707 14,000 11,000 15,000 15,000 15,000 15,000 15,000 79-795-50-00-5046 PRE-SCHOOL WAGES 18,431 13,691 20,000 23,000 25,000 25,000 25,000 25,000 25,000 79-795-50-00-5052 INSTRUCTORS WAGES 11,047 15,938 25,000 12,000 25,000 25,000 25,000 25,000 25,000 79-795-52-00-5212 RETIREMENT PLAN CONTRIBUTION 24,704 28,294 32,686 32,686 32,089 33,390 36,616 40,173 44,086 79-795-52-00-5214 FICA CONTRIBUTION 18,637 20,639 26,576 26,576 26,362 27,285 28,240 29,228 30,251 79-795-52-00-5216 GROUP HEALTH INSURANCE 42,511 62,448 100,027 100,027 83,769 90,471 97,709 105,526 113,968 79-795-52-00-5222 GROUP LIFE INSURANCE 440 524 673 673 588 594 600 606 612 79-795-52-00-5223 DENTAL INSURANCE 2,566 3,360 5,397 5,397 5,139 5,396 5,666 5,949 6,246 79-795-52-00-5224 VISION INSURANCE 296 491 695 695 552 569 586 604 622 79-795-54-00-5412 TRAINING&CONFERENCES 1,144 1,191 5,000 5,000 5,000 5,000 5,000 5,000 5,000 79-795-54-00-5415 TRAVEL&LODGING 453 114 3,000 3,000 3,000 3,000 3,000 3,000 3,000 79-795-54-00-5426 PUBLISHING&ADVERTISING 24,745 28,259 40,000 40,000 40,000 40,000 40,000 40,000 40,000 79-795-54-00-5440 TELECOMMUNICATIONS 2,922 6,573 7,000 7,000 7,000 7,000 7,000 7,000 7,000 79-795-54-00-5447 SCHOLARSHIPS 803 585 2,500 2,500 2,500 2,500 2,500 2,500 2,500 79-795-54-00-5452 POSTAGE&SHIPPING 2,188 1,694 4,000 4,000 3,500 3,500 3,500 3,500 3,500 79-795-54-00-5460 DUES&SUBSCRIPTIONS 1,454 1,688 2,500 2,500 2,500 2,500 2,500 2,500 2,500 79-795-54-00-5462 PROFESSIONAL SERVICES 60,998 75,999 75,000 75,000 75,000 75,000 75,000 75,000 75,000 79-795-54-00-5480 UTILITIES 12,869 12,224 23,000 23,000 20,000 21,200 22,472 23,820 25,249 79-795-54-00-5485 RENTAL&LEASE PURCHASE 2,408 4,035 4,500 4,500 4,500 4,500 4,500 4,500 4,500 50 FY 2013 FY 2014 FY 2015 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected 79-795-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 50 23,816 3,000 3,000 3,000 3,000 3,000 3,000 3,000 79-795-54-00-5496 PROGRAM REFUNDS 9,033 8,475 7,000 7,000 7,000 7,000 7,000 7,000 7,000 79-795-54-00-5497 PROPERTY TAX PAYMENT - - 30,000 21,977 - - - - - 79-795-56-00-5602 HOMETOWN DAYS SUPPLIES 91,712 91,422 100,000 90,000 100,000 100,000 100,000 100,000 100,000 79-795-56-00-5606 PROGRAM SUPPLIES 50,603 62,594 55,000 55,000 75,000 75,000 75,000 75,000 75,000 79-795-56-00-5607 CONCESSION SUPPLIES 17,714 16,472 18,000 18,000 18,000 18,000 18,000 18,000 18,000 79-795-56-00-5610 OFFICE SUPPLIES 2,503 1,993 3,000 3,000 3,000 3,000 3,000 3,000 3,000 79-795-56-00-5620 OPERATING SUPPLIES 19,426 21,325 7,500 7,500 7,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 616 - 500 500 500 500 500 500 500 79-795-56-00-5640 REPAIR&MAINTENANCE 132 1,527 2,000 2,000 2,000 2,000 2,000 2,000 2,000 79-795-56-00-5695 GASOLINE 1,437 739 3,210 3,210 2,000 2,140 2,290 2,450 2,622 79-795-99-00-9980 TRANSFER TO RECREATION CENTER 489,043 643,766 1,245,168 918,847 854,0.11 883,936 903,692 926,358 950,401 975,912 Expenditures 1,398,256 2,063,804 1,911,447 1,848,641 1,795,940 1,850,848 1,912,017 1,976,890 2,045,711 Surplus(Deficit) 40,303 226,112 (145,591) (64,385) (212,709) 8,236 9,176 9,731 10,323 Fund Balance 320,370 546,485 286,717 482,100 269,391 277,627 286,803 296,534 306,857 22.91% 2648% 15.00% 26,08% 15.00% 15.00% 15.00% 15.00% 15.00% 51 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 2015 FY 2013 FY 2014 Adopted FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes 691,905 642,838 646,010 626,950 635,000 635,000 640,000 640,000 645,000 Intergovernmental 24,124 22,914 22,200 26,401 22,450 22,450 22,450 22,450 22,450 Fines&Forfeits 9,404 9,680 9,300 9,300 9,300 9,300 9,300 9,300 9,300 Charges for Service 14,190 10,707 14,000 11,500 11,500 11,500 11,500 11,500 11,500 Investment Earnings 1,257 1,313 1,300 750 1,500 400 400 400 400 Reimbursements 9,396 - - - - - - - - Miscellaneous 12,489 7,992 7,500 7,500 7,500 7,500 7,500 7,500 7.500 Other Financing Sources 26,819 45,948 32,375 32,375 34,168 35,568 37,582 39,717 41,980 Total Revenue 789,584 741,392 732,685 714,776 721,418 721,718 728,732 730,867 738,130 Expenditures Salaries 420,283 414,525 447,540 447,540 397,860 397,860 397,860 397,860 397,860 Benefits 177,713 170,118 204,448 198,123 171,013 181,275 191,845 203,196 215,379 Contractual Services 104,651 94,739 112,465 129,938 128,249 114,171 115,148 116,183 117,281 Supplies 24,163 15,885 19,000 19,000 19,000 19,000 19,000 19,000 19,000 Other Financing Uses 5,469 21,185 - 3,558 - - - - - Total Expenditures 732,279 716,452 783,453 798,159 716,122 712,306 723,853 736,239 749,520 Surplus(Deficit) 57,305 24,940 (50,768) (83,383) 5,296 9,412 4,879 (5,372) (11,390) Ending Fund Balance 446,136 471,076 354,783 387,693 392,989 402,401 407,280 401,908 390,518 60.92% 65.75% 45.28% 48.57% 54.88% 56.49% 56.27% 54.59% 52.10% Fund Balance $500 $400 N 'o $300 r $200 $100 $0 FY 2013 FY 2014 FY 2015 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Library Operations 82-000-40-00-4000 PROPERTY TAXES 691,905 642,838 646,010 626,950-' 635,000 635,000 640,000 640,000 645,000 82-000-41-00-4120 PERSONAL PROPERTY TAX 5,272 5,525 5,000 5,250 5,250 5,250 5,250 5,250 5,250 82-000-41-00-4170 STATE GRANTS 18,852 17,389 17,200 21,151 17,200 17,200 17,200 17,200 17,200 82-000-43-00-4330 LIBRARY FINES 9,404 9,680 9,300 9,300 9,300 9,300 9,300 9,300 9,300 82-000-44-00-4401 LIBRARY SUBSCRIPTION CARDS 10,434 7,194 10,000 7,500 7,500 7,500 7,500 7,500 7,500 82-000-44-00-4422 COPY FEES 2,748 2,628 3,000 3,000 3,000 3,000 3,000 3,000 3,000 82-000-44-00-4439 PROGRAM FEES 1,008 885 1,000' 1,000 1,000 1,000 1,000 1,000 1,000 82-000-45-00-4500 INVESTMENT EARNINGS 1,257 1,313 1,300 750 1,500 400 400 400 400 82-000-46-00-4670 REIMB-EMPLOYEE INS CONTRIBUTIONS 8,685 - - - - - 82-000-46-00-4671 REIMB-LIFE INSURANCE 711 - - - - - - 82-000-48-00-4820 RENTAL INCOME 1,556 2,098 ' 2,000 2,000 2,000 2,000 2,000 2,000 2,000 82-000-48-00-4824 DVD RENTAL INCOME 4,884 4,550 5,000- 5,000 5,000 5,000 5,000 5,000 5,000 82-000-48-00-4832 MEMORIALS&GIFTS 5,201 - - - _ _ - _ _ 82-000-48-004850 MISCELLANEOUS INCOME 848 1,344 500 500 500 500 500 500 500 82-000-49-00-4901 TRANSFER FROM GENERAL 26,819 45,948 32,375 32,375' 34,168 35,568 37,582 39,717 41,980 Revenue 789,584 741,392 732,685 714,776' 721,418 721,718 728,732 730,867 738,130 82-820-50-00-5010 SALARIES&WAGES 244,847 245,323 252,540 252,540 202,860 202,860 202,860 202,860 202,860 82-820-50-00-5015 PART-TIME SALARIES 175,436 169,202 195,000 195,000 195,000 195,000 195,000 195,000 195,000 82-820-52-00-5212 RETIREMENT PLAN CONTRIBUTION 26,152 27,138 30,117 30,117 22,569 24,871 26,352 27,934 29,618 82-820-52-00-5214 FICA CONTRIBUTION 31,483 30,993 33,484 33,484 29,849 29,849 29,849 29,849 29,849 82-820-52-00-5216 GROUP HEALTH INSURANCE 85,076 81,269 101,904 101,904 78,823 85,129 91,939 99,294 107,238 82-820-52-00-5222 GROUP LIFE INSURANCE 1,027 525 559 559 418 422 426 430 434 82-820-52-00-5223 DENTAL INSURANCE 5,950 5,092 5,347 5,347 4,690 4,925 5,171 5,430 5,702 82-820-52-00-5224 VISION INSURANCE 643 643 662 662 496 511 526 542 558 82-820-52-00-5230 UNEMPLOYMENT INSURANCE 2,435 681 2,500 550 2,500 2,000 2,000 2,000 2,000 82-820-52-00-5231 LIABILITY INSURANCE 24,947 23,777 29,875 25,500 31,668 33,568 35,582 37,717 39,980 82-820-54-00-5412 TRAINING&CONFERENCES - 232 500 500 500 500 500 500 500 82-820-54-00-5415 TRAVEL&LODGING 798 541 600 600 600 600 600 600 600 82-820-54-00-5426 PUBLISHING&ADVERTISING 22 46 100 100 100 100 100 100 100 82-820-54-00-5440 TELECOMMUNICATIONS 10,982 11,941 11,000 11,000 11,000 11,000 11,000 11,000 11,000 53 FY 2013 FY 2014 FY 2015 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected 82-820-54-00-5452 POSTAGE&SHIPPING 244 509 500 500 500 500 500 500 500 82-820-54-00-5460 DUES&SUBSCRIPTIONS 8,379 8,515 12,000 12,000 12,000 12,000 12,000 12,000 12,000 82-820-54-00-5462 PROFESSIONAL SERVICES 38,778 35,891 29,000 29,000 29,000 29,000 29,000 29,000 29,000 82-820-54-00-5466 LEGAL SERVICES 360 - 2,000 2,000 2,000 2,000 2,000 2,000 2,000 82-820-54-00-5468 AUTOMATION 30,199 14,283 35,000 35,000 35,000 35,000 35,000 35,000 35,000 82-820-54-00-5480 UTILITIES 10,508 17,260 14,490 14,490 15,359 16,281 17,258 18,293 19,391 82-820-54-00-5489 LOSS ON INVESTMENT - - - 9,138 - - _ _ _ 82-820-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 3,632 4,959 5,000 13,335 20,000 5,000 5,000 5,000 5,000 82-820-54-00-5498 PAYING AGENT FEES 749 562 2,275 2,275 2,190 2,190 2,190 2,190 2,190 82-820-56-00-5610 OFFICE SUPPLIES 5,497 5,807 8,000 8,000 8,000 8,000 8,000 8,000 8,000 82-820-56-00-5620 OPERATING SUPPLIES 7,738 6,772 8,000 8,000 8,000 8,000 8,000 8,000 8,000 82-820-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 1,550 - - - _ _ _ _ _ 82-820-56-00-5640 REPAIR&MAINTENANCE 881 - _ _ _ 82-820-56-00-5671 LIBRARY PROGRAMMING 875 731 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-5680 ADULT BOOKS 82-820-56-00-5681 JUVENILE BOOKS y 82-820-56-00-5682 REFERENCE BOOKS 82-820-56-00-5683 AUDIO BOOKS 82-820-56-00-5684 COMPACT DISCS&OTHER MUSIC - - - 82-820-56-00-5685 DVD'S 2,421 2,575 2,000 2,000 2,000 2,000 2,000 2,000 2,000 82-820-56-00-5698 MEMORIALS&GIFTS 5,201 - 82-820-99-00-9983 TRANSFER TO LIBRARY DEBT SERVICE 5,469 21,185 3,558 Expenditures 732,279 716,452 783,453 798,159 716,122 712,306 723,853 736,239 749,520 Surplus(Deficit) 57,305 24,940 (50,768) (83,383) 5,296 9,412 4,879 (5,372 (11,390) Fund Balance 446,136 471,076 354,783 387,693 392,989 402,401 407,280 401,908 390,518 60.92% 65.75% 4528% 18.37% 54.88% 5649% 56.27% 54.59% 52.10% 54 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 2015 FY 2013 FY 2014 Adopted FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes 791,640 746,464 731,321 727,762 749,846 752,771 760,396 792,101 797,013 Investment Earnings 200 71 30 1 30 - - - - Other Financing Sources 5,469 21,185 - 3,558 - - - - - Total Revenue 797,309 767,720 731,351 731,321 749,876 752,771 760,396 792,101 797,013 Expenditures Debt Service 795,488 767,720 731,321 731,321 749,846 752,771 760,396 792,101 797,013 Total Expenditures 795,488 767,720 731,321 731,321 749,846 752,771 760,396 792,101 797,013 Surplus(Deficit) 1,821 - 30 - 30 - - - - Ending Fund Balance - - 30 - 30 30 30 30 30 $40 Fund Balance $30 $20 $10 $0 55 FY 2013 FY 2014 FY 2015 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Library Debt Service 83-00040-00-4000 PROPERTY TAXES 791,640 746,464 731,321 727,762 749,846 752,771 760,396 792,101 797,013 83-000-45-00-4500 INVESTMENT EARNINGS 200 71 30 1 30 - - - _ 83-00049-00-4982 TRANSFER FROM LIBRARY OPS 5,469 21,185 3,558 Revenue 797,309 767,720 731,351 731,321 749,876 752,771 760,396 792,101 797,013 Debt Service-2005B Bond 83-830-83-00-8000 PRINCIPAL PAYMENT 290,000 335,000 83-830-83-00-8050 INTEREST PAYMENT 309,125 13,400 Debt Service-2006 Bond 83-830-84-00-8000 PRINCIPAL PAYMENT 150,000 100,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 83-830-84-00-8050 INTEREST PAYMENT 46,363 39,238 34,488 34,488 32,113 29,738 27,363 24,988 22,613 Debt Service-2013 Refunding Bond 83-830-99-00-8000 PRINCIPAL PAYMENT 155,000 455,000 455,000 485,000 500,000 520,000 565,000 585,000 83-830-99-00-8050 INTEREST PAYMENT - 125,082 191,833 191,833 182,733 173,033 163,033 152,113 139,400 Expenditures 795,488 767,720 731,321 731,321 749,846 752,771 760,396 792,101 797,013 Surplus(Deficit) 1,821 - 30 - 30 - - - - Fund Balance - 30 30 30 30 30 30 56 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 2015 FY 2013 FY 2014 Adopted FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Licenses&Permits 35,200 53,650 20,000 20,000 20,000 20,000 20,000 20,000 20,000 Investment Earnings 8 16 20 10 20 10 10 10 10 Total Revenue 35,208 53,666 20,020 20,010 20,020 20,010 20,010 20,010 20,010 Expenditures Contractual Services - 3,000 3,500 3,500 3,500 3,500 3,500 3,500 3,500 Supplies 26,312 39,484 51,515 51,515 8,395 16,500 16,510 16,510 16,510 Total Expenditures 26,312 42,484 55,015 55,015 11,895 20,000 20,010 20,010 20,010 Surplus(Deficit) 8,896 11,182 (34,995) (35,005) 8,125 10 - - - Ending Fund Balance 15,689 26,870 - (8,135) (10) - - - - Fund Balance N $30 v M $20 3 ° $10 r $0 ($10) 57 FY 2013 FY 2014 FV 2015 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Library Capital 84-000-42-00-4214 DEVELOPMENT FEES 35,200 53,650 20,000 20,000 20,000 20,000 20,000 20,000 20,000 84-000-45-00-4500 INVESTMENT EARNINGS 8 16 20 10 20 10 10 10 10 Revenue 35,208 53,666 20,020 20,010 20,020 20,010 20,010 20,010 20,010 84-840-54-00-5460 E-BOOKS SUBSCRIPTION 3,000 T C 3,SiZ0 3,500 3,500 3,500 3,500 3,500 84-840-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 3,153 7,074 84-840-56-00-5683 AUDIO BOOKS 1,482 84-840-56-00-5684 COMPACT DISCS&OTHER MUSIC 666 84-840-56-00-5685 DVD'S 1,768 2,062 84-840-56-00-5686 BOOKS 21,391 28,200 51,515 51,515 8,395 16,500 16,510 16,510 16,510 Expenditures 26,312 429484 55,015 55,015 11,895 20,000 20,010 20,010 20,010 Surplus(Deficit) 8,896 11,182 (34,995) (35,005) 8,125 10 - - - Fund Balance 15,689 26,870 (8,135) (10) - - 58 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 2015 FY 2013 FY 2014 Adopted FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes - 2,043 20,000 9,295 100,000 100,000 100,000 100,000 100,000 Investment Earnings 2,132 106 - - - - - - - Other Financing Sources - 1,235,000 - - - - - - - Total Revenue 2,132 1,237,149 20,000 9,295 100,000 100,000 100,000 100,000 100,000 Expenditures Contractual Services 3,002 1,843,149 23,325 3,325 3,140 3,140 3,140 3,140 3,140 Debt Service 304,668 302,738 68,073 68,073 93,431 118,788 118,788 118,788 353,788 Capital Outlay - - - 2,198 - - - - - Other Financing Uses - 1,197,685 - - - - - - - Total Expenditures 307,670 3,343,572 91,398 73,596 96,571 121,928 121,928 121,928 356,928 Surplus(Deficit) (305,538) (2,106,423) (71,398) (64,301) 3,429 (21,928) (21,928) (21,928) (256,928) Ending Fund Balance 1,572,335 (534,087) (604,070) (598,388) (594,959) (616,887) (638,815) (660,743) (917,671) $2,000 Fund Balance 3 $1,000 O $0 H ($1,000) ($2,000) 59 FY 2013 FY 2014 FY 2015 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Countryside TIF 87-000-40-00-4000 PROPERTY TAXES 9 100,000 100,000 100,000 100,000 100,000 87-000-40-00-4070 BUSINESS DISTRICT TAX 2,043 U 87-000-45-00-4500 INVESTMENT EARNINGS 2,132 106 87-000-49-00-4902 BOND ISSUANCE 1,235,000 Revenue 2,132 1,237,149 20,000 9,295 100,000 100,000 100,000 100,000 100,000 87-870-54-00-5402 BOND ISSUANCE COSTS - 37,315 - - - - - - - 87-870-54-00-5425 TIF INCENTIVE PAYOUT - 1,800,000 - - - - - - 87-870-54-00-5462 PROFESSIONAL SERVICES 2,627 3,416 2,000 2,000 2,000 2,000 2,000 2,000 2,000 87-870-54-00-5493 BUSINESS DISTRICT REBATE - 2,043 20,000 - - - - - - 87-870-54-00-5498 PAYING AGENT FEES 375 375 1,325 1,325 1,140 1,140 1,140 1,140 1,140 87-870-60-00-6000 PROJECT COSTS - - 2,198 - - - - - Debt Service-2005 Bond 87-870-80-00-8000 PRINCIPAL PAYMENT 180,000 185,000 - - - - - - 235,000 87-870-80-00-8050 INTEREST PAYMENT 124,668 117,738 68,073 68,073 68,073 68,073 68,073 68,073 68,073 Debt Service-2014 Refunding Bond 87-870-93-00-8000 PRINCIPAL PAYMENT - - - - - 87-870-93-00-8050 INTEREST PAYMENT - 25,358 50,715 50,715 50,715 50,715 87-870-99-00-9902 BOND DISCOUNT 9,773 - - - - - 87-870-99-00-9960 PAYMENT TO ESCROW AGENT 1,187,912 Expenditures 307,670 3,343,572 91,398 73,596 96,571 121,928 121,928 121,928 356,928 Surplus(Deficit) (305,538) (2,106,423) (71,398) (64,301) 3,429 (21,928) (21,928) (21,928) (256,928) Fund Balance 1,572,335 (534,087) (604,070) (598,388) (594,959) (616,887) (638,815) (660,743) (917,671) 60 Downtown TIF Fund(88) The Downtown TIF was created in 2006,in order to finance a mixed use development in the downtown area. FY 2015 FY 2013 FY 2014 Adopted FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes 39,980 62,269 85,000 60,027 65,000 70,000 70,000 75,000 75,000 Investment Earnings 428 53 75 50 50 50 50 50 50 Miscellaneous - 184 - - - - - - - Other Financing Sources 5,000 8,500 - - - - - - - Total Revenue 45,408 71,006 85,075 60,077 65,050 70,050 70,050 75,050 75,050 Expenditures Contractual Services 18,391 26,843 35,355 27,755 27,860 27,865 27,975 27,975 28,075 Capital Outlay 68,034 29,568 17,433 17,420 328,170 17,420 17,420 17,420 17,420 Other Financing Uses - - - 13,500 - - - - - Total Expenditures 86,425 56,411 52,788 58,675 356,030 45,285 45,395 45,395 45,495 Surplus(Deficit) (41,017) 14,595 32,287 1,402 (290,980) 24,765 24,655 29,655 29,555 Ending Fund Balance 216,937 231,529 265,260 232,931 (58,049) (33,284) (8,629) 21,026 50,581 $300 Fund Balance $200 N _ $100 $0 ($100) 61 FY 2013 FY 2014 FY 2015 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Downtown TIF 88-000-40-004000 PROPERTY TAXES 39,980 52,811 65,000 60,027 65,000 70,000 70,000 75,000 75,000 88-000-40-004070 BUSINESS DISTRICT TAX - 9,458 20,000 - - - - - - 88-000-45-00-4500 INVESTMENT EARNINGS 428 53 75 50 50 50 50 50 50 88-000-48-00-4850 MISCELLANEOUS INCOME - 184 - - - - - - 88-000-49-00-4910 SALE OF CAPITAL ASSETS 5,000 8,500 - - Revenue 45,408 71,006 85,075 60,077 65,050 70,050 70,050 75,050 75,050 88-880-54-00-5425 TIF INCENTIVE PAYOUT - 12,315 - 12,400 12,500 12,500 12,600 12,600 12,700 88-880-54-00-5462 PROFESSIONAL SERVICES 3,951 258 355 355 360 365 375 375 375 88-880-54-00-5466 LEGAL SERVICES 14,440 4,812 15,000 15,000 15,000 15,000 15,000 15,000 15,000 88-880-54-00-5493 BUSINESS DISTRICT REBATE - 9,458 20.000 - - - - - - 88-880-60-00-6000 PROJECT COSTS 56,367 9,568 10,000 10,000 10,000 10,000 10,000 10,000 10,000 88-880-60-00-6048 DOWNTOWN STREETSCAPE IMPROVEMENT - - - - 310,750 - - - - 88-880-60-00-6079 ROUTE 47 EXPANSION 11,667 20,000 7,433 7,420 7,420 7,420 7,420 7,420 7,420 88-880-99-00-9923 TRANSFER TO CITY-WIDE CAPITAL - - 13,500 Expenditures 86,425 56,411 52,788 58,675 356,030 45,285 45,395 45,395 45,495 Surplus(Deficit) (41,017) 14,595 32,287 1,402 (290,980) 24,765 24,655 29,655 29,555 Fund Balance 216,937 231,529 265,260 232,931 (58,049) (33,284) (8,629) 21,026 50,581 62