Loading...
City Council Packet 2021 10-12-21 AGENDA CITY COUNCIL MEETING Tuesday, October 12, 2021 7:00 p.m. City Hall Council Chambers 800 Game Farm Road, Yorkville, IL Call to Order: Pledge of Allegiance: Roll Call by Clerk: WARD I WARD II WARD III WARD IV Ken Koch Arden Joe Plocher Chris Funkhouser Seaver Tarulis Dan Transier Matt Marek Jason Peterson Establishment of Quorum: Amendments to Agenda: Presentations: Public Hearings: Citizen Comments on Agenda Items: Consent Agenda: 1. Bill Payments for Approval $ 607,654.24 (vendors) $ 130,229.40 (ach/wire payments) $ 337,928.73 (payroll period ending 9/17/21) $ 1,075,812.37 (total) Mayor’s Report: Public Works Committee Report: Economic Development Committee Report Public Safety Committee Report: Administration Committee Report: 1. CC 2021-44 Copier RFP Results 2. ADM 2021-37 Tax Levy Estimate Park Board: Planning and Zoning Commission: City Council Report: United City of Yorkville 800 Game Farm Road Yorkville, Illinois 60560 Telephone: 630-553-4350 www.yorkville.il.us City Council Agenda October 12, 2021 Page 2 City Clerk’s Report: Community and Liaison Report: Staff Report: Mayor’s Report (cont’d): 1. CC 2021-51 Bond Refinancing Discussion 2. CC 2021-04 City Buildings Updates 3. CC 2021-38 Water Study Update Additional Business: Citizen Comments: Executive Session: Adjournment: COMMITTEES, MEMBERS AND RESPONSIBILITIES ADMINISTRATION: October 20, 2021 – 6:00 p.m. – City Hall Conference Room Committee Departments Liaisons Chairman: Finance Library Vice-Chairman: Alderman Funkhouser Administration Committee: Alderman Transier Committee: Alderman Tarulis ECONOMIC DEVELOPMENT: November 2, 2021 – 6:00 p.m. – City Hall Conference Room Committee Departments Liaisons Chairman: Alderman Peterson Community Development Planning & Zoning Commission Vice-Chairman: Alderman Koch Building Safety & Zoning Kendall Co. Plan Commission Committee: Alderman Plocher Committee: Alderman Funkhouser PUBLIC SAFETY: November 4, 2021 – 6:00 p.m. – City Hall Conference Room Committee Departments Liaisons Chairman: Alderman Transier Police School District Vice-Chairman: Alderman Tarulis Committee: Committee: Alderman Marek City Council Agenda October 12, 2021 Page 3 COMMITTEES, MEMBERS AND RESPONSIBILITIES cont’d: PUBLIC WORKS: October 19, 2021 – 6:00 p.m. – City Hall Conference Room Committee Departments Liaisons Chairman: Alderman Marek Public Works Park Board Vice-Chairman: Alderman Plocher Engineering YBSD Committee: Alderman Koch Parks and Recreation Committee: Alderman Peterson UNITED CITY OF YORKVILLE WORKSHEET CITY COUNCIL Tuesday, October 12, 2021 7:00 PM CITY COUNCIL CHAMBERS ---------------------------------------------------------------------------------------------------------------------------------------- AMENDMENTS TO AGENDA: ---------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------------------------------- CITIZEN COMMENTS ON AGENDA ITEMS: ----------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------- CONSENT AGENDA: ----------------------------------------------------------------------------------------------------------------------------------------- 1. Bill Payments for Approval □ Approved ________ □ As presented □ As amended □ Notes _____________________________________________________________________________ _____________________________________________________________________________________ _____________________________________________________________________________________ ----------------------------------------------------------------------------------------------------------------------------------------- ADMINISTRATION COMMITTEE REPORT: ----------------------------------------------------------------------------------------------------------------------------------------- 1. CC 2021-44 Copier RFP Results □ Approved: Y ______ N ______ □ Subject to __________________________________________ □ Removed ________________________________________________________________________ □ Notes _____________________________________________________________________________ _____________________________________________________________________________________ _____________________________________________________________________________________ ----------------------------------------------------------------------------------------------------------------------------------------- 2. ADM 2021-37 Tax Levy Estimate □ Approved: Y ______ N ______ □ Subject to __________________________________________ □ Removed ________________________________________________________________________ □ Notes _____________________________________________________________________________ _____________________________________________________________________________________ _____________________________________________________________________________________ ----------------------------------------------------------------------------------------------------------------------------------------- MAYOR’S REPORT (CONT’D): ----------------------------------------------------------------------------------------------------------------------------------------- 1. CC 2021-51 Bond Refinancing Discussion □ Approved: Y ______ N ______ □ Subject to __________________________________________ □ Removed ________________________________________________________________________ □ Notes _____________________________________________________________________________ _____________________________________________________________________________________ _____________________________________________________________________________________ ----------------------------------------------------------------------------------------------------------------------------------------- 2. CC 2021-04 City Buildings Updates □ Approved: Y ______ N ______ □ Subject to __________________________________________ □ Removed ________________________________________________________________________ □ Notes _____________________________________________________________________________ _____________________________________________________________________________________ _____________________________________________________________________________________ ----------------------------------------------------------------------------------------------------------------------------------------- 3. CC 2021-38 Water Study Update □ Approved: Y ______ N ______ □ Subject to __________________________________________ □ Removed ________________________________________________________________________ □ Notes _____________________________________________________________________________ _____________________________________________________________________________________ _____________________________________________________________________________________ ----------------------------------------------------------------------------------------------------------------------------------------- ADDITIONAL BUSINESS: ----------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------------------------------- CITIZEN COMMENTS: ----------------------------------------------------------------------------------------------------------------------------------------- Have a question or comment about this agenda item? Call us Monday-Friday, 8:00am to 4:30pm at 630-553-4350, email us at agendas@yorkville.il.us, post at www.facebook.com/CityofYorkville, tweet us at @CityofYorkville, and/or contact any of your elected officials at http://www.yorkville.il.us/320/City-Council Agenda Item Summary Memo Title: Meeting and Date: Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Agenda Item Notes: Reviewed By: Legal Finance Engineer City Administrator Community Development Purchasing Police Public Works Parks and Recreation Agenda Item Number Consent Agenda #1 Tracking Number Bills for Payment City Council – October 12, 2021 Majority Approval Amy Simmons Finance Name Department               01-110 ADMINISTRATION01-120 FINANCE01-210 POLICE01-220 COMMUNITY DEVELOPMENT01-410 STREETS OPERATION01-640 ADMINISTRATIVE SERVICES01-111 FOX HILL SSA             01-112 SUNFLOWER ESTATES 15-155 MOTOR FUEL TAX 23-216 MUNICIPAL BUILDING23-230 CITY-WIDE CAPITAL 24-216 BUILDING & GROUNDS25-205 POLICE CAPITAL25-215 PUBLIC WORKS CAPITAL   25-225 PARK & REC CAPITAL 42-420 DEBT SERVICE51-510 WATER OPERATIONS 52-520 SEWER OPERATIONS 72-720 LAND CASH79-790 PARKS DEPARTMENT 79-795 RECREATION DEPARTMENT   82-820 LIBRARY OPERATIONS84-840 LIBRARAY CAPITAL 87-870 COUNTRYSIDE TIF88-880 DOWNTOWN TIF89-890 DOWNTOWN TIF II 90-XXX DEVELOPER ESCROW950-XXX ESCROW DEPOSITDATE: 10/07/21TIME: 09:12:18UNITED CITY OF YORKVILLE CHECK REGISTERID: AP211001.W0WINVOICES DUE ON/BEFORE 10/12/2021CHECK # VENDOR #INVOICE ITEMINVOICE #DATE # DESCRIPTION ACCOUNT # PROJECT CODE ITEM AMT------------------------------------------------------------------------------------------------------------------------------------535443 AACVB AURORA AREA CONVENTION08/21-HAMPTON09/22/21 01 AUG 2021 HAMPTON HOTEL TAX 01-640-54-00-54814,916.89INVOICE TOTAL:4,916.89 *09/21-SUNSET09/17/21 01 SUNSET AUG 2021 HOTEL TAX 01-640-54-00-548137.80INVOICE TOTAL:37.80 *8/21-ALL09/10/21 01 ALL SEASON AUG 2021 HOTEL TAX 01-640-54-00-548148.79INVOICE TOTAL:48.79 *8/21-SUPER09/23/21 01 AUG 2021 SUPER 8 HOTEL TAX 01-640-54-00-54811,911.57INVOICE TOTAL:1,911.57 *CHECK TOTAL:6,915.05535444 ALLENB BENNETT ALLENSEPT 15-SEPT 2709/27/21 01 UMPIRE79-795-54-00-546240.00INVOICE TOTAL:40.00 *CHECK TOTAL:40.00535445 AMPERAGE AMPERAGE ELECTRICAL SUPPLY INC1206711-CM08/26/21 01 RETURNED LOAD CENTER CREDIT 25-225-60-00-6010-112.40INVOICE TOTAL:-112.40 *1207331-IN08/27/21 01 HOLE GAVIN COVER25-225-60-00-60101.64INVOICE TOTAL:1.64 *1207929-IN08/24/21 01 UNDERGROUND SPLICE25-225-60-00-601080.61INVOICE TOTAL:80.61 *1208303-CM08/31/21 01 RETURNED LOAD CENTER CREDIT 25-225-60-00-6010-112.40INVOICE TOTAL:-112.40 *Page 1 of 36                                                 01-110 ADMINISTRATION 01-120 FINANCE 01-210 POLICE 01-220 COMMUNITY DEVELOPMENT 01-410 STREETS OPERATION 01-640 ADMINISTRATIVE SERVICES 01-111 FOX HILL SSA                                               01-112 SUNFLOWER ESTATES 15-155 MOTOR FUEL TAX 23-216 MUNICIPAL BUILDING 23-230 CITY-WIDE CAPITAL 24-216 BUILDING & GROUNDS 25-205 POLICE CAPITAL 25-215 PUBLIC WORKS CAPITAL                                               25-225 PARK & REC CAPITAL 42-420 DEBT SERVICE 51-510 WATER OPERATIONS 52-520 SEWER OPERATIONS 72-720 LAND CASH 79-790 PARKS DEPARTMENT 79-795 RECREATION DEPARTMENT                                               82-820 LIBRARY OPERATIONS 84-840 LIBRARAY CAPITAL 87-870 COUNTRYSIDE TIF 88-880 DOWNTOWN TIF 89-890 DOWNTOWN TIF II 90-XXX DEVELOPER ESCROW 950-XXX ESCROW DEPOSIT DATE: 10/07/21 UNITED CITY OF YORKVILLE TIME: 09:12:18 PRE-CHECK RUN EDITID: AP211001.W0WINVOICES DUE ON/BEFORE 10/12/2021CHECK # VENDOR # INVOICE ITEMINVOICE # DATE # DESCRIPTION ACCOUNT # PROJECT CODE ITEM AMT------------------------------------------------------------------------------------------------------------------------------------535445 AMPERAGE AMPERAGE ELECTRICAL SUPPLY INC1211970-IN 09/13/21 01 PHOTO CONTROLS, LAMPS 23-230-56-00-5642 297.96INVOICE TOTAL: 297.96 *CHECK TOTAL: 155.41D002216 ANTPLACE ANTHONY PLACE YORKVILLE LPOCT 2021 09/01/21 01 CITY OF YORKVILLE HOUSING 01-640-54-00-5427 829.0002 ASSISTANCE PROGRAM ** COMMENT **03 REIMBURSEMENT FOR THE MONTH OF ** COMMENT **04 OCT 2021 ** COMMENT **INVOICE TOTAL: 829.00 *DIRECT DEPOSIT TOTAL: 829.00535446 AQUAFIX AQUAFIX, INC.36715 06/18/21 01 VITASTIM GREASE 52-520-56-00-5613 1,029.06INVOICE TOTAL: 1,029.06 *37965 09/15/21 01 VITASTIM GREASE 52-520-56-00-5613 1,029.50INVOICE TOTAL: 1,029.50 *CHECK TOTAL: 2,058.56535447 BEEBED DAVID BEEBESEPT 15-SEPT 27 09/27/21 01 UMPIRE 79-795-54-00-5462 110.00INVOICE TOTAL: 110.00 *CHECK TOTAL: 110.00535448 BLAKEW WILLIAM BLAKESEPT 15-SEPT 27 09/27/21 01 SEPT 15-SEPT 27 79-795-54-00-5462 275.00INVOICE TOTAL: 275.00 *CHECK TOTAL: 275.00Page 2 of 36            01-110 ADMINISTRATION01-120 FINANCE01-210 POLICE01-220 COMMUNITY DEVELOPMENT01-410 STREETS OPERATION01-640 ADMINISTRATIVE SERVICES01-111 FOX HILL SSA         01-112 SUNFLOWER ESTATES 15-155 MOTOR FUEL TAX 23-216 MUNICIPAL BUILDING23-230 CITY-WIDE CAPITAL 24-216 BUILDING & GROUNDS25-205 POLICE CAPITAL25-215 PUBLIC WORKS CAPITAL  25-225 PARK & REC CAPITAL 42-420 DEBT SERVICE51-510 WATER OPERATIONS 52-520 SEWER OPERATIONS 72-720 LAND CASH79-790 PARKS DEPARTMENT 79-795 RECREATION DEPARTMENT  82-820 LIBRARY OPERATIONS84-840 LIBRARAY CAPITAL 87-870 COUNTRYSIDE TIF88-880 DOWNTOWN TIF89-890 DOWNTOWN TIF II 90-XXX DEVELOPER ESCROW950-XXX ESCROW DEPOSITDATE: 10/07/21TIME: 09:12:18UNITED CITY OF YORKVILLE CHECK REGISTERID: AP211001.W0WINVOICES DUE ON/BEFORE 10/12/2021CHECK # VENDOR #INVOICE ITEMINVOICE #DATE # DESCRIPTION ACCOUNT # PROJECT CODE ITEM AMT------------------------------------------------------------------------------------------------------------------------------------535449 BOOMBAH BOOMBAH073121-STREBATE09/22/21 01 MAY 2021-JUL 2021 SALES TAX 01-640-54-00-54922,493.1502 REBATE** COMMENT **INVOICE TOTAL:2,493.15 *CHECK TOTAL:2,493.15535450 BOWMANT TERENCE BOWMAN09232109/23/21 01 UMPIRE79-795-54-00-5462160.00INVOICE TOTAL:160.00 *CHECK TOTAL:160.00D002217 BROWND DAVID BROWN10012110/01/21 01 SEPT 2021 MOBILE EMAIL51-510-54-00-544045.0002 REIMBURSEMENT** COMMENT **INVOICE TOTAL:45.00 *DIRECT DEPOSIT TOTAL:45.00535451 BULLINJA JACKSON BULLINGTONSEPT 15-SEPT 2709/27/21 01 UMPIRE79-795-54-00-5462165.00INVOICE TOTAL:165.00 *CHECK TOTAL:165.00D002218 CALCAGNC CHRISTINA CALCAGNO10012110/01/21 01 SEPT 2021 MOBILE EMAIL79-795-54-00-544045.0002 REIMBURSEMENT** COMMENT **INVOICE TOTAL:45.00 *DIRECT DEPOSIT TOTAL:45.00Page 3 of 36        01-110 ADMINISTRATION01-120 FINANCE01-210 POLICE01-220 COMMUNITY DEVELOPMENT01-410 STREETS OPERATION01-640 ADMINISTRATIVE SERVICES01-111 FOX HILL SSA                         01-112 SUNFLOWER ESTATES 15-155 MOTOR FUEL TAX 23-216 MUNICIPAL BUILDING23-230 CITY-WIDE CAPITAL 24-216 BUILDING & GROUNDS25-205 POLICE CAPITAL25-215 PUBLIC WORKS CAPITAL   25-225 PARK & REC CAPITAL 42-420 DEBT SERVICE51-510 WATER OPERATIONS 52-520 SEWER OPERATIONS 72-720 LAND CASH79-790 PARKS DEPARTMENT 79-795 RECREATION DEPARTMENT  82-820 LIBRARY OPERATIONS84-840 LIBRARAY CAPITAL 87-870 COUNTRYSIDE TIF88-880 DOWNTOWN TIF89-890 DOWNTOWN TIF II 90-XXX DEVELOPER ESCROW950-XXX ESCROW DEPOSITDATE: 10/07/21TIME: 09:12:18UNITED CITY OF YORKVILLE CHECK REGISTERID: AP211001.W0WINVOICES DUE ON/BEFORE 10/12/2021CHECK # VENDOR #INVOICE ITEMINVOICE #DATE # DESCRIPTION ACCOUNT # PROJECT CODE ITEM AMT------------------------------------------------------------------------------------------------------------------------------------535452 CALLONE UNITED COMMUNICATION SYSTEMS44725209/15/21 01 SEPT 2021 ADMIN LINES01-110-54-00-5440833.1502 SEPT 2021 CITY HALL NORTEL 01-110-54-00-5440192.2703 SEPT 2021 CITY HALL NORTEL 01-210-54-00-5440192.2704 SEPT 2021 CITY HALL NORTEL 51-510-54-00-5440192.2705 SEPT 2021 POLICE LINES01-210-54-00-5440461.4506 SEPT 2021 CITY HALL FIRE01-210-54-00-5440904.8607 SEPT 2021 CITY HALL FIRE01-110-54-00-5440904.8608 SEPT 2021 PW LINES51-510-54-00-54402,880.3309 SEPT 2021 SEWER DEPT LINES 52-520-54-00-5440436.6510 SEPT 2021 RECREATION LINES 79-790-54-00-5440454.8311 SEPT 2021 TRAFFIC SIGNAL01-410-54-00-543565.7212 MAINTENANCE** COMMENT **INVOICE TOTAL:7,518.66 *CHECK TOTAL:7,518.66535453 CAMBRIA CAMBRIA SALES COMPANY INC.4266209/27/21 01 PAPER TOWEL, TOILET TISSUE, 01-110-56-00-5610121.3702 GARBAGE BAGS** COMMENT **03 PAPER TOWEL, TOILET TISSUE, 01-120-56-00-5610121.3504 GARBAGE BAGS** COMMENT **05 PAPER TOWEL, TOILET TISSUE, 01-210-56-00-5610121.3506 GARBAGE BAGS** COMMENT **07 PAPER TOWEL, TOILET TISSUE, 01-220-56-00-5610121.3508 GARBAGE BAGS** COMMENT **INVOICE TOTAL:485.42 *CHECK TOTAL:485.42535454 COMED COMMONWEALTH EDISON0435057364-092109/23/21 01 08/24-09/23 RT126 & STAGECOACH 23-230-54-00-548276.96INVOICE TOTAL:76.96 *CHECK TOTAL:76.96Page 4 of 36           01-110 ADMINISTRATION01-120 FINANCE01-210 POLICE01-220 COMMUNITY DEVELOPMENT01-410 STREETS OPERATION01-640 ADMINISTRATIVE SERVICES01-111 FOX HILL SSA                 01-112 SUNFLOWER ESTATES 15-155 MOTOR FUEL TAX 23-216 MUNICIPAL BUILDING23-230 CITY-WIDE CAPITAL 24-216 BUILDING & GROUNDS25-205 POLICE CAPITAL25-215 PUBLIC WORKS CAPITAL  25-225 PARK & REC CAPITAL 42-420 DEBT SERVICE51-510 WATER OPERATIONS 52-520 SEWER OPERATIONS 72-720 LAND CASH79-790 PARKS DEPARTMENT 79-795 RECREATION DEPARTMENT  82-820 LIBRARY OPERATIONS84-840 LIBRARAY CAPITAL 87-870 COUNTRYSIDE TIF88-880 DOWNTOWN TIF89-890 DOWNTOWN TIF II 90-XXX DEVELOPER ESCROW950-XXX ESCROW DEPOSITDATE: 10/07/21TIME: 09:12:18UNITED CITY OF YORKVILLE CHECK REGISTERID: AP211001.W0WINVOICES DUE ON/BEFORE 10/12/2021CHECK # VENDOR #INVOICE ITEMINVOICE #DATE # DESCRIPTION ACCOUNT # PROJECT CODE ITEM AMT------------------------------------------------------------------------------------------------------------------------------------D002219 CONARDR RYAN CONARD10012110/01/21 01 SEPT 2021 MOBILE EMAIL51-510-54-00-544045.0002 REIMBURSEMENT** COMMENT **INVOICE TOTAL:45.00 *DIRECT DEPOSIT TOTAL:45.00535455 COREMAIN CORE & MAIN LPP55168409/10/21 01 100CF WIRED METERS51-510-56-00-566410,020.00INVOICE TOTAL:10,020.00 *CHECK TOTAL:10,020.00535456 DAHME DAHME MECHANICAL INDUSTRIES2021027509/10/21 01 COMPLETE GRANDE RESERVE51-510-54-00-54459,430.0002 TREATMENT PLANT PUMP REPIPING ** COMMENT **INVOICE TOTAL:9,430.00 *CHECK TOTAL:9,430.00535457 DELAGE DLL FINANCIAL SERVICES INC7383654309/17/21 01 NOV 2021 COPIER LEASE82-820-54-00-5462185.00INVOICE TOTAL:185.00 *7383699209/17/21 01 OCT 2021 COPIER LEASE01-110-54-00-5485113.4602 OCT 2021 COPIER LEASE01-120-54-00-548575.6403 OCT 2021 COPIER LEASE01-220-54-00-5485189.1004 OCT 2021 COPIER LEASE01-210-54-00-5485299.1005 OCT 2021 COPIER LEASE01-410-54-00-548544.6706 OCT 2021 COPIER LEASE51-510-54-00-548544.6707 OCT 2021 COPIER LEASE52-520-54-00-548544.6708 OCT 2021 COPIER LEASE79-790-54-00-548594.55Page 5 of 36           01-110 ADMINISTRATION01-120 FINANCE01-210 POLICE01-220 COMMUNITY DEVELOPMENT01-410 STREETS OPERATION01-640 ADMINISTRATIVE SERVICES01-111 FOX HILL SSA                   01-112 SUNFLOWER ESTATES 15-155 MOTOR FUEL TAX 23-216 MUNICIPAL BUILDING23-230 CITY-WIDE CAPITAL 24-216 BUILDING & GROUNDS25-205 POLICE CAPITAL25-215 PUBLIC WORKS CAPITAL  25-225 PARK & REC CAPITAL 42-420 DEBT SERVICE51-510 WATER OPERATIONS 52-520 SEWER OPERATIONS 72-720 LAND CASH79-790 PARKS DEPARTMENT 79-795 RECREATION DEPARTMENT  82-820 LIBRARY OPERATIONS84-840 LIBRARAY CAPITAL 87-870 COUNTRYSIDE TIF88-880 DOWNTOWN TIF89-890 DOWNTOWN TIF II 90-XXX DEVELOPER ESCROW950-XXX ESCROW DEPOSITDATE: 10/07/21TIME: 09:12:18UNITED CITY OF YORKVILLE CHECK REGISTERID: AP211001.W0WINVOICES DUE ON/BEFORE 10/12/2021CHECK # VENDOR #INVOICE ITEMINVOICE #DATE # DESCRIPTION ACCOUNT # PROJECT CODE ITEM AMT------------------------------------------------------------------------------------------------------------------------------------535457 DELAGE DLL FINANCIAL SERVICES INC7383699209/17/21 09 OCT 2021 COPIER LEASE79-795-54-00-548594.54INVOICE TOTAL:1,000.40 *7383720909/17/21 01 NOV 2021 MANAGED PRINT SRVS 01-110-54-00-5485112.3302 NOV 2021 MANAGED PRINT SRVS 01-120-54-00-548537.4403 NOV 2021 MANAGED PRINT SRVS 01-210-54-00-5485112.3304 NOV 2021 MANAGED PRINT SRVS 51-510-54-00-548550.1805 NOV 2021 MANAGED PRINT SRVS 52-520-54-00-548512.3606 NOV 2021 MANAGED PRINT SRVS 01-410-54-00-548512.36INVOICE TOTAL:337.00 *CHECK TOTAL:1,522.40D002220 DHUSEE DHUSE, ERIC10012110/01/21 01 SEPT 2021 MOBILE EMAIL51-510-54-00-544015.0002 REIMBURSEMENT** COMMENT **03 SEPT 2021 MOBILE EMAIL52-520-54-00-544015.0004 REIMBURSEMENT** COMMENT **05 SEPT 2021 MOBILE EMAIL01-410-54-00-544015.0006 REIMBURSEMENT** COMMENT **INVOICE TOTAL:45.00 *DIRECT DEPOSIT TOTAL:45.00535458 DIRENRGY DIRECT ENERGY BUSINESS1704707-212630046851 09/20/21 01 08/16-09/15 RT47 & KENNEDY 23-230-54-00-54821,026.77INVOICE TOTAL:1,026.77 *1704713-212640046860 09/21/21 01 08/18-09/17 FOX & PAVILLION 23-230-54-00-548262.26INVOICE TOTAL:62.26 *1704718-212510046738 09/08/21 01 08/04-09/02 RT34 & CANNONBALL 23-230-54-00-548216.37INVOICE TOTAL:16.37 *CHECK TOTAL:1,105.40Page 6 of 36          01-110 ADMINISTRATION01-120 FINANCE01-210 POLICE01-220 COMMUNITY DEVELOPMENT01-410 STREETS OPERATION01-640 ADMINISTRATIVE SERVICES01-111 FOX HILL SSA             01-112 SUNFLOWER ESTATES 15-155 MOTOR FUEL TAX 23-216 MUNICIPAL BUILDING23-230 CITY-WIDE CAPITAL 24-216 BUILDING & GROUNDS25-205 POLICE CAPITAL25-215 PUBLIC WORKS CAPITAL   25-225 PARK & REC CAPITAL 42-420 DEBT SERVICE51-510 WATER OPERATIONS 52-520 SEWER OPERATIONS 72-720 LAND CASH79-790 PARKS DEPARTMENT 79-795 RECREATION DEPARTMENT  82-820 LIBRARY OPERATIONS84-840 LIBRARAY CAPITAL 87-870 COUNTRYSIDE TIF88-880 DOWNTOWN TIF89-890 DOWNTOWN TIF II 90-XXX DEVELOPER ESCROW950-XXX ESCROW DEPOSITDATE: 10/07/21TIME: 09:12:18UNITED CITY OF YORKVILLE CHECK REGISTERID: AP211001.W0WINVOICES DUE ON/BEFORE 10/12/2021CHECK # VENDOR #INVOICE ITEMINVOICE #DATE # DESCRIPTION ACCOUNT # PROJECT CODE ITEM AMT------------------------------------------------------------------------------------------------------------------------------------D002221 DLK DLK, LLC23309/27/21 01 SEPT 2021 MONTHLY ECONOMIC 01-640-54-00-54869,425.0002 DEVELOPMENT HOURS** COMMENT **INVOICE TOTAL:9,425.00 *23909/27/21 01 JUL - SEPT 2021 BANKED01-640-54-00-548615,225.0002 ECONOMIC DEVELOPMENT HOURS** COMMENT **INVOICE TOTAL:15,225.00 *DIRECT DEPOSIT TOTAL:24,650.00535459 DRYDON DRYDON EQUIPMENT, INC.27291.2F07/20/21 01 BLACOH MODEL51-510-56-00-56381,614.00INVOICE TOTAL:1,614.00 *27921.106/01/21 01 GASKETS, QUAD RINGS51-510-56-00-5638202.60INVOICE TOTAL:202.60 *3852108/13/21 01 RINGS, DRAIN PLUGS, GASKETS, 51-510-56-00-56384,776.3602 HOSE CLAMPS, LUBE, PVC** COMMENT **03 INSERTS, PUMP HOSES, BREDEL ** COMMENT **04 COMPLETE KIT** COMMENT **INVOICE TOTAL:4,776.36 *CHECK TOTAL:6,592.96535460 EJEQUIP EJ EQUIPMENTP3163109/16/21 01 FLOAT BALL, FLOAT ARM, BUSHING 52-520-56-00-5613678.79INVOICE TOTAL:678.79 *CHECK TOTAL:678.79535461 EVINST W. THOMAS EVINSPage 7 of 36            01-110 ADMINISTRATION01-120 FINANCE01-210 POLICE01-220 COMMUNITY DEVELOPMENT01-410 STREETS OPERATION01-640 ADMINISTRATIVE SERVICES01-111 FOX HILL SSA         01-112 SUNFLOWER ESTATES 15-155 MOTOR FUEL TAX 23-216 MUNICIPAL BUILDING23-230 CITY-WIDE CAPITAL 24-216 BUILDING & GROUNDS25-205 POLICE CAPITAL25-215 PUBLIC WORKS CAPITAL  25-225 PARK & REC CAPITAL 42-420 DEBT SERVICE51-510 WATER OPERATIONS 52-520 SEWER OPERATIONS 72-720 LAND CASH79-790 PARKS DEPARTMENT 79-795 RECREATION DEPARTMENT  82-820 LIBRARY OPERATIONS84-840 LIBRARAY CAPITAL 87-870 COUNTRYSIDE TIF88-880 DOWNTOWN TIF89-890 DOWNTOWN TIF II 90-XXX DEVELOPER ESCROW950-XXX ESCROW DEPOSITDATE: 10/07/21TIME: 09:12:18UNITED CITY OF YORKVILLE CHECK REGISTERID: AP211001.W0WINVOICES DUE ON/BEFORE 10/12/2021CHECK # VENDOR #INVOICE ITEMINVOICE #DATE # DESCRIPTION ACCOUNT # PROJECT CODE ITEM AMT------------------------------------------------------------------------------------------------------------------------------------535461 EVINST W. THOMAS EVINS09252109/25/21 01 UMPIRE79-795-54-00-546270.00INVOICE TOTAL:70.00 *CHECK TOTAL:70.00535462 FERGUSTR ROBERT FERGUSTONSEPT 15-SEPT 2709/27/21 01 UMPIRE79-795-54-00-546255.00INVOICE TOTAL:55.00 *CHECK TOTAL:55.00535463 FIRST FIRST PLACE RENTAL32522909/22/21 01 SCARIFIER RENTAL01-410-54-00-5485195.51INVOICE TOTAL:195.51 *CHECK TOTAL:195.51D002222 FREDRICR ROB FREDRICKSON10012110/01/21 01 SEPT 2021 MOBILE EMAIL01-120-54-00-544045.0002 REIMBURSEMENT** COMMENT **INVOICE TOTAL:45.00 *DIRECT DEPOSIT TOTAL:45.00D002223 GALAUNEJ JAKE GALAUNER10012110/01/21 01 SEPT 2021 MOBILE EMAIL79-795-54-00-544045.0002 REIMBURSEMENT** COMMENT **INVOICE TOTAL:45.00 *DIRECT DEPOSIT TOTAL:45.00Page 8 of 36           01-110 ADMINISTRATION01-120 FINANCE01-210 POLICE01-220 COMMUNITY DEVELOPMENT01-410 STREETS OPERATION01-640 ADMINISTRATIVE SERVICES01-111 FOX HILL SSA              01-112 SUNFLOWER ESTATES 15-155 MOTOR FUEL TAX 23-216 MUNICIPAL BUILDING23-230 CITY-WIDE CAPITAL 24-216 BUILDING & GROUNDS25-205 POLICE CAPITAL25-215 PUBLIC WORKS CAPITAL  25-225 PARK & REC CAPITAL 42-420 DEBT SERVICE51-510 WATER OPERATIONS 52-520 SEWER OPERATIONS 72-720 LAND CASH79-790 PARKS DEPARTMENT 79-795 RECREATION DEPARTMENT  82-820 LIBRARY OPERATIONS84-840 LIBRARAY CAPITAL 87-870 COUNTRYSIDE TIF88-880 DOWNTOWN TIF89-890 DOWNTOWN TIF II 90-XXX DEVELOPER ESCROW950-XXX ESCROW DEPOSITDATE: 10/07/21TIME: 09:12:18UNITED CITY OF YORKVILLE CHECK REGISTERID: AP211001.W0WINVOICES DUE ON/BEFORE 10/12/2021CHECK # VENDOR #INVOICE ITEMINVOICE #DATE # DESCRIPTION ACCOUNT # PROJECT CODE ITEM AMT------------------------------------------------------------------------------------------------------------------------------------D002224 GARCIAL LUIS GARCIA10012110/01/21 01 SEPT 2021 MOBILE EMAIL51-510-54-00-544045.0002 REIMBURSEMENT** COMMENT **INVOICE TOTAL:45.00 *DIRECT DEPOSIT TOTAL:45.00535464 GLATFELT GLATFELTER UNDERWRITING SRVS.188058121-1008/31/21 01 LIABILITY INS INSTALL #10 01-640-52-00-523111,162.4102 LIABILITY INS INSTALL #10-PR 01-640-52-00-52312,270.7003 LIABILITY INS INSTALL #10 51-510-52-00-52311,058.5204 LIABILITY INS INSTALL #10 52-520-52-00-5231478.1405 LIABILITY INS INSTALL #10 82-820-52-00-5231902.23INVOICE TOTAL:15,872.00 *CHECK TOTAL:15,872.00535465 GOLDMEDA GOLD MEDAL CHICAGO ML3038186109/20/21 01 BEECHER PARK CONSECESSION 79-795-56-00-5607298.9902 SUPPLIES** COMMENT **INVOICE TOTAL:298.99 *38186209/20/21 01 BRIDGE PARK CONCESSION79-795-56-00-5607298.9902 SUPPLIES** COMMENT **INVOICE TOTAL:298.99 *CHECK TOTAL:597.98535466 GOSSA ALLEN R. GOSSSEPT 15-SEPT 2709/27/21 01 UMPIRE79-795-54-00-5462110.00INVOICE TOTAL:110.00 *CHECK TOTAL:110.00Page 9 of 36             01-110 ADMINISTRATION01-120 FINANCE01-210 POLICE01-220 COMMUNITY DEVELOPMENT01-410 STREETS OPERATION01-640 ADMINISTRATIVE SERVICES01-111 FOX HILL SSA             01-112 SUNFLOWER ESTATES 15-155 MOTOR FUEL TAX 23-216 MUNICIPAL BUILDING23-230 CITY-WIDE CAPITAL 24-216 BUILDING & GROUNDS25-205 POLICE CAPITAL25-215 PUBLIC WORKS CAPITAL  25-225 PARK & REC CAPITAL 42-420 DEBT SERVICE51-510 WATER OPERATIONS 52-520 SEWER OPERATIONS 72-720 LAND CASH79-790 PARKS DEPARTMENT 79-795 RECREATION DEPARTMENT  82-820 LIBRARY OPERATIONS84-840 LIBRARAY CAPITAL 87-870 COUNTRYSIDE TIF88-880 DOWNTOWN TIF89-890 DOWNTOWN TIF II 90-XXX DEVELOPER ESCROW950-XXX ESCROW DEPOSITDATE: 10/07/21TIME: 09:12:18UNITED CITY OF YORKVILLE CHECK REGISTERID: AP211001.W0WINVOICES DUE ON/BEFORE 10/12/2021CHECK # VENDOR #INVOICE ITEMINVOICE #DATE # DESCRIPTION ACCOUNT # PROJECT CODE ITEM AMT------------------------------------------------------------------------------------------------------------------------------------535467 GOVIT GOVERNMENT IT CONSORTIUM2021-002409/15/21 01 CYBERHAWK SECURITY TOOL01-640-54-00-54502,500.0002 GOVITC DOMAIN RENEWAL01-640-54-00-545034.18INVOICE TOTAL:2,534.18 *2021-00702/12/21 01 FINANCE/ACCOUNTING SERVICES 01-640-54-00-5450779.0002 AND BANK CHARGES** COMMENT **INVOICE TOTAL:779.00 *CHECK TOTAL:3,313.18535468 GRANDREN GRAND RENTAL STATION3416709/02/21 01 FOLDING CHAIR RENTAL79-795-56-00-5602610.50INVOICE TOTAL:610.50 *CHECK TOTAL:610.50535469 GROUND GROUND EFFECTS INC.448929-00004/06/21 01 CONTRACTOR SEED01-410-56-00-5640216.28INVOICE TOTAL:216.28 *453571-00005/25/21 01 DRAIN TILE, TEES, ELBOWS, END 01-410-56-00-5640320.6402 CAPS** COMMENT **INVOICE TOTAL:320.64 *461661-00009/16/21 01 GRASS SEED01-410-56-00-5640180.66INVOICE TOTAL:180.66 *461807-00009/20/21 01 MULCH51-510-60-00-6025312.50INVOICE TOTAL:312.50 *CHECK TOTAL:1,030.08535470 GSLSPORT BIG DAWG ATHLETICS LLCPage 10 of 36           01-110 ADMINISTRATION01-120 FINANCE01-210 POLICE01-220 COMMUNITY DEVELOPMENT01-410 STREETS OPERATION01-640 ADMINISTRATIVE SERVICES01-111 FOX HILL SSA          01-112 SUNFLOWER ESTATES 15-155 MOTOR FUEL TAX 23-216 MUNICIPAL BUILDING23-230 CITY-WIDE CAPITAL 24-216 BUILDING & GROUNDS25-205 POLICE CAPITAL25-215 PUBLIC WORKS CAPITAL   25-225 PARK & REC CAPITAL 42-420 DEBT SERVICE51-510 WATER OPERATIONS 52-520 SEWER OPERATIONS 72-720 LAND CASH79-790 PARKS DEPARTMENT 79-795 RECREATION DEPARTMENT  82-820 LIBRARY OPERATIONS84-840 LIBRARAY CAPITAL 87-870 COUNTRYSIDE TIF88-880 DOWNTOWN TIF89-890 DOWNTOWN TIF II 90-XXX DEVELOPER ESCROW950-XXX ESCROW DEPOSITDATE: 10/07/21TIME: 09:12:18UNITED CITY OF YORKVILLE CHECK REGISTERID: AP211001.W0WINVOICES DUE ON/BEFORE 10/12/2021CHECK # VENDOR #INVOICE ITEMINVOICE #DATE # DESCRIPTION ACCOUNT # PROJECT CODE ITEM AMT------------------------------------------------------------------------------------------------------------------------------------535470 GSLSPORT BIG DAWG ATHLETICS LLC1504/27/21 01 FALL ADULT SOFTBALL LEAGUE FEE 79-795-54-00-5462240.00INVOICE TOTAL:240.00 *CHECK TOTAL:240.00535471 HAWKINSJ JACKSON HAWKINSONSEPT 15-SEPT 2709/27/21 01 UMPIRE79-795-54-00-5462110.00INVOICE TOTAL:110.00 *CHECK TOTAL:110.00D002225 HENNED DURK HENNE10012110/01/21 01 SEPT 2021 MOBILE EMAIL01-410-54-00-544045.0002 REIMBURSEMENT** COMMENT **INVOICE TOTAL:45.00 *DIRECT DEPOSIT TOTAL:45.00D002226 HERNANDA ADAM HERNANDEZ10012110/01/21 01 SEPT 2021 MOBILE EMAIL79-790-54-00-544045.0002 REIMBURSEMENT** COMMENT **INVOICE TOTAL:45.00 *DIRECT DEPOSIT TOTAL:45.00535472 HERNANDN NOAH HERNANDEZ10012110/01/21 01 SEPT 2021 MOBILE EMAIL79-790-54-00-544045.0002 REIMBURSEMENT** COMMENT **INVOICE TOTAL:45.00 *CHECK TOTAL:45.00Page 11 of 36            01-110 ADMINISTRATION01-120 FINANCE01-210 POLICE01-220 COMMUNITY DEVELOPMENT01-410 STREETS OPERATION01-640 ADMINISTRATIVE SERVICES01-111 FOX HILL SSA             01-112 SUNFLOWER ESTATES 15-155 MOTOR FUEL TAX 23-216 MUNICIPAL BUILDING23-230 CITY-WIDE CAPITAL 24-216 BUILDING & GROUNDS25-205 POLICE CAPITAL25-215 PUBLIC WORKS CAPITAL  25-225 PARK & REC CAPITAL 42-420 DEBT SERVICE51-510 WATER OPERATIONS 52-520 SEWER OPERATIONS 72-720 LAND CASH79-790 PARKS DEPARTMENT 79-795 RECREATION DEPARTMENT  82-820 LIBRARY OPERATIONS84-840 LIBRARAY CAPITAL 87-870 COUNTRYSIDE TIF88-880 DOWNTOWN TIF89-890 DOWNTOWN TIF II 90-XXX DEVELOPER ESCROW950-XXX ESCROW DEPOSITDATE: 10/07/21TIME: 09:12:18UNITED CITY OF YORKVILLE CHECK REGISTERID: AP211001.W0WINVOICES DUE ON/BEFORE 10/12/2021CHECK # VENDOR #INVOICE ITEMINVOICE #DATE # DESCRIPTION ACCOUNT # PROJECT CODE ITEM AMT------------------------------------------------------------------------------------------------------------------------------------535473 HOMETREE HOMER TREE CARE, INC4634709/20/21 01 REMOVE 2 PARKWAY TREES AND 01-410-54-00-54581,400.0002 GRIND STUMPS** COMMENT **INVOICE TOTAL:1,400.00 *4634809/20/21 01 REMOVAL OF ASH TREES24-216-54-00-54463,200.0002 CRANE ASSISTED REMOVAL OF 01-410-54-00-54584,000.0003 DEAD WALNUT TREE** COMMENT **INVOICE TOTAL:7,200.00 *CHECK TOTAL:8,600.00D002227 HORNERR RYAN HORNER10012110/01/21 01 SEPT 2021 MOBILE EMAIL79-790-54-00-544045.0002 REIMBURSEMENT** COMMENT **INVOICE TOTAL:45.00 *DIRECT DEPOSIT TOTAL:45.00D002228 HOULEA ANTHONY HOULE10012110/01/21 01 SEPT 2021 MOBILE EMAIL79-790-54-00-544045.0002 REIMBURSEMENT** COMMENT **INVOICE TOTAL:45.00 *DIRECT DEPOSIT TOTAL:45.00535474 HOUSEAL HOUSEAL LAVIGNE ASSOCIATES524709/20/21 01 AUG 2021 CONSULTING SERVICES 01-220-54-00-54622,838.75INVOICE TOTAL:2,838.75 *CHECK TOTAL:2,838.75535475 HRHTOP HRH TOPSOIL LLCPage 12 of 36            01-110 ADMINISTRATION01-120 FINANCE01-210 POLICE01-220 COMMUNITY DEVELOPMENT01-410 STREETS OPERATION01-640 ADMINISTRATIVE SERVICES01-111 FOX HILL SSA             01-112 SUNFLOWER ESTATES 15-155 MOTOR FUEL TAX 23-216 MUNICIPAL BUILDING23-230 CITY-WIDE CAPITAL 24-216 BUILDING & GROUNDS25-205 POLICE CAPITAL25-215 PUBLIC WORKS CAPITAL  25-225 PARK & REC CAPITAL 42-420 DEBT SERVICE51-510 WATER OPERATIONS 52-520 SEWER OPERATIONS 72-720 LAND CASH79-790 PARKS DEPARTMENT 79-795 RECREATION DEPARTMENT  82-820 LIBRARY OPERATIONS84-840 LIBRARAY CAPITAL 87-870 COUNTRYSIDE TIF88-880 DOWNTOWN TIF89-890 DOWNTOWN TIF II 90-XXX DEVELOPER ESCROW950-XXX ESCROW DEPOSITDATE: 10/07/21TIME: 09:12:18UNITED CITY OF YORKVILLE CHECK REGISTERID: AP211001.W0WINVOICES DUE ON/BEFORE 10/12/2021CHECK # VENDOR #INVOICE ITEMINVOICE #DATE # DESCRIPTION ACCOUNT # PROJECT CODE ITEM AMT------------------------------------------------------------------------------------------------------------------------------------535475 HRHTOP HRH TOPSOIL LLC109709/20/21 01 DIRT01-410-56-00-5640480.00INVOICE TOTAL:480.00 *CHECK TOTAL:480.00535476 ILPD4778 ILLINOIS STATE POLICE08312108/31/21 01 LIQUOR LICENSE BACKGROUND 01-110-54-00-546228.2502 CHECK** COMMENT **INVOICE TOTAL:28.25 *CHECK TOTAL:28.25535477 ILPD4811 ILLINOIS STATE POLICE08312108/31/21 01 MASSAGE LICENSE BACKGROUND 01-110-54-00-546228.2502 CHECK** COMMENT **03 EMPLOYMENT BACK GROUND CHECK 01-110-54-00-546228.2504 BACKGROUND CHECKS79-795-54-00-5462423.75INVOICE TOTAL:480.25 *CHECK TOTAL:480.25535478 IMPACT IMPACT NETWORKING, LLC226138009/10/21 01 COPIER STAPLES79-795-56-00-561062.00INVOICE TOTAL:62.00 *CHECK TOTAL:62.00535479 IPRFILLINOIS PUBLIC RISK FUND6599609/14/21 01 NOV 2021 WORKER COMP INS01-640-52-00-523110,791.0802 NOV 2021 WORKER COMP INS-PR 01-640-52-00-52312,195.16Page 13 of 36             01-110 ADMINISTRATION01-120 FINANCE01-210 POLICE01-220 COMMUNITY DEVELOPMENT01-410 STREETS OPERATION01-640 ADMINISTRATIVE SERVICES01-111 FOX HILL SSA              01-112 SUNFLOWER ESTATES 15-155 MOTOR FUEL TAX 23-216 MUNICIPAL BUILDING23-230 CITY-WIDE CAPITAL 24-216 BUILDING & GROUNDS25-205 POLICE CAPITAL25-215 PUBLIC WORKS CAPITAL  25-225 PARK & REC CAPITAL 42-420 DEBT SERVICE51-510 WATER OPERATIONS 52-520 SEWER OPERATIONS 72-720 LAND CASH79-790 PARKS DEPARTMENT 79-795 RECREATION DEPARTMENT  82-820 LIBRARY OPERATIONS84-840 LIBRARAY CAPITAL 87-870 COUNTRYSIDE TIF88-880 DOWNTOWN TIF89-890 DOWNTOWN TIF II 90-XXX DEVELOPER ESCROW950-XXX ESCROW DEPOSITDATE: 10/07/21TIME: 09:12:18UNITED CITY OF YORKVILLE CHECK REGISTERID: AP211001.W0WINVOICES DUE ON/BEFORE 10/12/2021CHECK # VENDOR #INVOICE ITEMINVOICE #DATE # DESCRIPTION ACCOUNT # PROJECT CODE ITEM AMT------------------------------------------------------------------------------------------------------------------------------------535479 IPRFILLINOIS PUBLIC RISK FUND6599609/14/21 03 NOV 2021 WORKER COMP INS51-510-52-00-52311,023.3104 NOV 2021 WORKER COMP INS52-520-52-00-5231462.2405 NOV 2021 WORKER COMP INS82-820-52-00-5231872.21INVOICE TOTAL:15,344.00 *CHECK TOTAL:15,344.00535480 IRVINGS STEPHEN IRVING09162109/21/21 01 UMPIRE79-795-54-00-5462160.00INVOICE TOTAL:160.00 *09232109/23/21 01 UMPIRE79-795-54-00-5462160.00INVOICE TOTAL:160.00 *CHECK TOTAL:320.00535481 JIMSTRCK JIM'S TRUCK INSPECTION LLC18682706/22/21 01 TRUCK INSPECTION01-410-54-00-549037.00INVOICE TOTAL:37.00 *18686406/23/21 01 TRUCK INSPECTION01-410-54-00-549035.00INVOICE TOTAL:35.00 *18691706/28/21 01 TRUCK INSPECTION01-410-54-00-549056.00INVOICE TOTAL:56.00 *18691906/28/21 01 TRUCK INSPECTION01-410-54-00-549037.00INVOICE TOTAL:37.00 *18694306/29/21 01 TRUCK INSPECTION01-410-54-00-549037.00INVOICE TOTAL:37.00 *CHECK TOTAL:202.00Page 14 of 36           01-110 ADMINISTRATION01-120 FINANCE01-210 POLICE01-220 COMMUNITY DEVELOPMENT01-410 STREETS OPERATION01-640 ADMINISTRATIVE SERVICES01-111 FOX HILL SSA              01-112 SUNFLOWER ESTATES 15-155 MOTOR FUEL TAX 23-216 MUNICIPAL BUILDING23-230 CITY-WIDE CAPITAL 24-216 BUILDING & GROUNDS25-205 POLICE CAPITAL25-215 PUBLIC WORKS CAPITAL  25-225 PARK & REC CAPITAL 42-420 DEBT SERVICE51-510 WATER OPERATIONS 52-520 SEWER OPERATIONS 72-720 LAND CASH79-790 PARKS DEPARTMENT 79-795 RECREATION DEPARTMENT  82-820 LIBRARY OPERATIONS84-840 LIBRARAY CAPITAL 87-870 COUNTRYSIDE TIF88-880 DOWNTOWN TIF89-890 DOWNTOWN TIF II 90-XXX DEVELOPER ESCROW950-XXX ESCROW DEPOSITDATE: 10/07/21TIME: 09:12:18UNITED CITY OF YORKVILLE CHECK REGISTERID: AP211001.W0WINVOICES DUE ON/BEFORE 10/12/2021CHECK # VENDOR #INVOICE ITEMINVOICE #DATE # DESCRIPTION ACCOUNT # PROJECT CODE ITEM AMT------------------------------------------------------------------------------------------------------------------------------------D002229 JOHNGEOR GEORGE JOHNSON10012110/01/21 01 SEPT 2021 MOBILE EMAIL51-510-54-00-544022.5002 REIMBURSEMENT** COMMENT **03 SEPT 2021 MOBILE EMAIL52-520-54-00-544022.5004 REIMBURSEMENT** COMMENT **INVOICE TOTAL:45.00 *DIRECT DEPOSIT TOTAL:45.00535482 JOHNSONG GREGORY JOHNSONSEPT 15-SEPT 2709/27/21 01 UMPIRE79-795-54-00-546255.00INVOICE TOTAL:55.00 *CHECK TOTAL:55.00535483 KCACP KENDALL COUNTY ASSOCIATION OF81709/21/21 01 MONTHLY MEETING FEE FOR01-210-54-00-541248.0002 3 STAFF** COMMENT **INVOICE TOTAL:48.00 *CHECK TOTAL:48.00535484 KCSHERIF KENDALL CO. SHERIFF'S OFFICESEPT 2021-KANE09/24/21 01 KANE CO FTA BOND FEE01-000-24-00-241270.0002 REIMBURSEMENT** COMMENT **INVOICE TOTAL:70.00 *CHECK TOTAL:70.00535485 KENDCROS KENDALL CROSSING, LLCAMU REBATE 08-21 09/21/21 01 AUG 2021 AMUSEMENT TAX REBATE 01-640-54-00-54391,539.54INVOICE TOTAL:1,539.54 *CHECK TOTAL:1,539.54Page 15 of 36            01-110 ADMINISTRATION01-120 FINANCE01-210 POLICE01-220 COMMUNITY DEVELOPMENT01-410 STREETS OPERATION01-640 ADMINISTRATIVE SERVICES01-111 FOX HILL SSA         01-112 SUNFLOWER ESTATES 15-155 MOTOR FUEL TAX 23-216 MUNICIPAL BUILDING23-230 CITY-WIDE CAPITAL 24-216 BUILDING & GROUNDS25-205 POLICE CAPITAL25-215 PUBLIC WORKS CAPITAL  25-225 PARK & REC CAPITAL 42-420 DEBT SERVICE51-510 WATER OPERATIONS 52-520 SEWER OPERATIONS 72-720 LAND CASH79-790 PARKS DEPARTMENT 79-795 RECREATION DEPARTMENT  82-820 LIBRARY OPERATIONS84-840 LIBRARAY CAPITAL 87-870 COUNTRYSIDE TIF88-880 DOWNTOWN TIF89-890 DOWNTOWN TIF II 90-XXX DEVELOPER ESCROW950-XXX ESCROW DEPOSITDATE: 10/07/21TIME: 09:12:18UNITED CITY OF YORKVILLE CHECK REGISTERID: AP211001.W0WINVOICES DUE ON/BEFORE 10/12/2021CHECK # VENDOR #INVOICE ITEMINVOICE #DATE # DESCRIPTION ACCOUNT # PROJECT CODE ITEM AMT------------------------------------------------------------------------------------------------------------------------------------535486 KENPRINT ANNETTE M. POWELL21-0924209/24/21 01 500 PROPERTY CRASH REPORTS 01-210-54-00-5430180.35INVOICE TOTAL:180.35 *CHECK TOTAL:180.35D002230 KLEEFISG GLENN KLEEFISCH10012110/01/21 01 SEPT 2021 MOBILE EMAIL79-790-54-00-544045.0002 REIMBURSEMENT** COMMENT **INVOICE TOTAL:45.00 *DIRECT DEPOSIT TOTAL:45.00535487 KOZIALB BENJAMIN KOZIALSEPT 15-SEPT 2709/27/21 01 UMPIRE79-795-54-00-546240.00INVOICE TOTAL:40.00 *CHECK TOTAL:40.00535488 KWIATKOJ JOESEPH KWIATKOWSKISEPT 15-SEPT 2709/27/21 01 UMPIRE79-795-54-00-5462275.00INVOICE TOTAL:275.00 *CHECK TOTAL:275.00535489 LANEMUCH LANER, MUCHIN, LTD60874409/01/21 01 2021 GENERAL COUNSEL THROUGH 01-640-54-00-5463900.0002 AUG 20,2021** COMMENT **INVOICE TOTAL:900.00 *CHECK TOTAL:900.00Page 16 of 36             01-110 ADMINISTRATION01-120 FINANCE01-210 POLICE01-220 COMMUNITY DEVELOPMENT01-410 STREETS OPERATION01-640 ADMINISTRATIVE SERVICES01-111 FOX HILL SSA          01-112 SUNFLOWER ESTATES 15-155 MOTOR FUEL TAX 23-216 MUNICIPAL BUILDING23-230 CITY-WIDE CAPITAL 24-216 BUILDING & GROUNDS25-205 POLICE CAPITAL25-215 PUBLIC WORKS CAPITAL  25-225 PARK & REC CAPITAL 42-420 DEBT SERVICE51-510 WATER OPERATIONS 52-520 SEWER OPERATIONS 72-720 LAND CASH79-790 PARKS DEPARTMENT 79-795 RECREATION DEPARTMENT  82-820 LIBRARY OPERATIONS84-840 LIBRARAY CAPITAL 87-870 COUNTRYSIDE TIF88-880 DOWNTOWN TIF89-890 DOWNTOWN TIF II 90-XXX DEVELOPER ESCROW950-XXX ESCROW DEPOSITDATE: 10/07/21TIME: 09:12:18UNITED CITY OF YORKVILLE CHECK REGISTERID: AP211001.W0WINVOICES DUE ON/BEFORE 10/12/2021CHECK # VENDOR #INVOICE ITEMINVOICE #DATE # DESCRIPTION ACCOUNT # PROJECT CODE ITEM AMT------------------------------------------------------------------------------------------------------------------------------------535490 LIPSCOJA JACOB LIPSCOMBSEPT 15-SEPT 2709/27/21 01 UMPIRE79-795-54-00-5462110.00INVOICE TOTAL:110.00 *CHECK TOTAL:110.00535491 MADBOMB MAD BOMBER FIREWORK PRODUCTIONHOLIDAY 202109/27/21 01 HOLIDAY CELEBRATION FIREWORKS 79-795-56-00-56067,400.00INVOICE TOTAL:7,400.00 *CHECK TOTAL:7,400.00535492 MARKER MARKER INC801 FREEMONT09/23/21 01 SECURITY GUARANTEE REFUND 01-000-24-00-24155,000.00INVOICE TOTAL:5,000.00 *CHECK TOTAL:5,000.00535493 MARTENSO MARTENSON TURF PRODUCTS8284808/27/21 01 LINE MARKING CHALK, MARKING 79-790-56-00-56461,727.2802 PAINT** COMMENT **INVOICE TOTAL:1,727.28 *8324609/21/21 01 ALL MINERAL79-790-56-00-56465,125.00INVOICE TOTAL:5,125.00 *CHECK TOTAL:6,852.28535494 MCCURDYK KYLE DEAN MCCURDYSEPT 15-SEPT 2709/27/21 01 UMPIRE79-795-54-00-5462150.00INVOICE TOTAL:150.00 *CHECK TOTAL:150.00Page 17 of 36            01-110 ADMINISTRATION01-120 FINANCE01-210 POLICE01-220 COMMUNITY DEVELOPMENT01-410 STREETS OPERATION01-640 ADMINISTRATIVE SERVICES01-111 FOX HILL SSA             01-112 SUNFLOWER ESTATES 15-155 MOTOR FUEL TAX 23-216 MUNICIPAL BUILDING23-230 CITY-WIDE CAPITAL 24-216 BUILDING & GROUNDS25-205 POLICE CAPITAL25-215 PUBLIC WORKS CAPITAL  25-225 PARK & REC CAPITAL 42-420 DEBT SERVICE51-510 WATER OPERATIONS 52-520 SEWER OPERATIONS 72-720 LAND CASH79-790 PARKS DEPARTMENT 79-795 RECREATION DEPARTMENT  82-820 LIBRARY OPERATIONS84-840 LIBRARAY CAPITAL 87-870 COUNTRYSIDE TIF88-880 DOWNTOWN TIF89-890 DOWNTOWN TIF II 90-XXX DEVELOPER ESCROW950-XXX ESCROW DEPOSITDATE: 10/07/21TIME: 09:12:18UNITED CITY OF YORKVILLE CHECK REGISTERID: AP211001.W0WINVOICES DUE ON/BEFORE 10/12/2021CHECK # VENDOR #INVOICE ITEMINVOICE #DATE # DESCRIPTION ACCOUNT # PROJECT CODE ITEM AMT------------------------------------------------------------------------------------------------------------------------------------535495 MEHOCHKR RYAN MEHOCHKOSEPT 15-SEPT 2709/27/21 01 UMPIRE79-795-54-00-546250.00INVOICE TOTAL:50.00 *CHECK TOTAL:50.00535496 MENINC MENARDS INC073121-STREBATE09/22/21 01 MAY 2021-JUL 2021 SALES TAX 01-640-54-00-549287,588.2102 REBATE** COMMENT **INVOICE TOTAL:87,588.21 *CHECK TOTAL:87,588.21535497 MENLAND MENARDS - YORKVILLE2324408/26/21 01 OUTLETS, POLE BREAKERS,25-225-60-00-601051.3002 LOCKNUTS, NIPPLES, BUSHING, ** COMMENT **03 COVERS** COMMENT **INVOICE TOTAL:51.30 *2377709/02/21 01 POLE BREAKER25-225-60-00-601046.99INVOICE TOTAL:46.99 *2415209/07/21 01 VENT BRUSH, EPOX, WRENCH, 01-410-56-00-562096.6202 SOCKET SET** COMMENT **INVOICE TOTAL:96.62 *2416109/07/21 01 CAULK GUN, EPOX, ADHESIVE 01-410-56-00-5620128.24INVOICE TOTAL:128.24 *2421109/08/21 01 TRASH CAN24-216-56-00-5656134.91INVOICE TOTAL:134.91 *CHECK TOTAL:458.06Page 18 of 36             01-110 ADMINISTRATION01-120 FINANCE01-210 POLICE01-220 COMMUNITY DEVELOPMENT01-410 STREETS OPERATION01-640 ADMINISTRATIVE SERVICES01-111 FOX HILL SSA             01-112 SUNFLOWER ESTATES 15-155 MOTOR FUEL TAX 23-216 MUNICIPAL BUILDING23-230 CITY-WIDE CAPITAL 24-216 BUILDING & GROUNDS25-205 POLICE CAPITAL25-215 PUBLIC WORKS CAPITAL  25-225 PARK & REC CAPITAL 42-420 DEBT SERVICE51-510 WATER OPERATIONS 52-520 SEWER OPERATIONS 72-720 LAND CASH79-790 PARKS DEPARTMENT 79-795 RECREATION DEPARTMENT  82-820 LIBRARY OPERATIONS84-840 LIBRARAY CAPITAL 87-870 COUNTRYSIDE TIF88-880 DOWNTOWN TIF89-890 DOWNTOWN TIF II 90-XXX DEVELOPER ESCROW950-XXX ESCROW DEPOSITDATE: 10/07/21TIME: 09:12:18UNITED CITY OF YORKVILLE CHECK REGISTERID: AP211001.W0WINVOICES DUE ON/BEFORE 10/12/2021CHECK # VENDOR #INVOICE ITEMINVOICE #DATE # DESCRIPTION ACCOUNT # PROJECT CODE ITEM AMT------------------------------------------------------------------------------------------------------------------------------------535498 METIND METROPOLITAN INDUSTRIES, INC.INV03169809/15/21 01 LIFT STATION MONTHLY METRO 52-520-54-00-5444270.0002 CLOUD DATA SERVICE** COMMENT **INVOICE TOTAL:270.00 *INV03177709/21/21 01 FUSED DISCONNECT, PISTOL52-520-54-00-5444245.0002 HANDLES, SHAFT** COMMENT **INVOICE TOTAL:245.00 *CHECK TOTAL:515.00535499 METROMAY METROPOLITAN MAYOR'S CAUCUS2021-05508/27/21 01 CAUCUS DUES RENEWAL01-110-54-00-5460761.45INVOICE TOTAL:761.45 *CHECK TOTAL:761.45535500 MIDWASH NATIONAL WASH AUTHORITY567909/20/21 01 BRISTOL BAY WATER TOWER51-510-54-00-54456,800.0002 CLEANING** COMMENT **INVOICE TOTAL:6,800.00 *CHECK TOTAL:6,800.00535501 MIDWSALT MIDWEST SALTP4910709/15/21 01 BULK ROCK SALT51-510-56-00-56382,627.52INVOICE TOTAL:2,627.52 *CHECK TOTAL:2,627.52535502 MIKOLASR RAY MIKOLASEK08302108/30/21 01 08/23-08/27 FBI LEEDA01-210-54-00-541570.00Page 19 of 36             01-110 ADMINISTRATION01-120 FINANCE01-210 POLICE01-220 COMMUNITY DEVELOPMENT01-410 STREETS OPERATION01-640 ADMINISTRATIVE SERVICES01-111 FOX HILL SSA           01-112 SUNFLOWER ESTATES 15-155 MOTOR FUEL TAX 23-216 MUNICIPAL BUILDING23-230 CITY-WIDE CAPITAL 24-216 BUILDING & GROUNDS25-205 POLICE CAPITAL25-215 PUBLIC WORKS CAPITAL  25-225 PARK & REC CAPITAL 42-420 DEBT SERVICE51-510 WATER OPERATIONS 52-520 SEWER OPERATIONS 72-720 LAND CASH79-790 PARKS DEPARTMENT 79-795 RECREATION DEPARTMENT  82-820 LIBRARY OPERATIONS84-840 LIBRARAY CAPITAL 87-870 COUNTRYSIDE TIF88-880 DOWNTOWN TIF89-890 DOWNTOWN TIF II 90-XXX DEVELOPER ESCROW950-XXX ESCROW DEPOSITDATE: 10/07/21TIME: 09:12:18UNITED CITY OF YORKVILLE CHECK REGISTERID: AP211001.W0WINVOICES DUE ON/BEFORE 10/12/2021CHECK # VENDOR #INVOICE ITEMINVOICE #DATE # DESCRIPTION ACCOUNT # PROJECT CODE ITEM AMT------------------------------------------------------------------------------------------------------------------------------------535502 MIKOLASR RAY MIKOLASEK08302108/30/21 02 TRAINING MEAL PER DIEMS** COMMENT **INVOICE TOTAL:70.00 *CHECK TOTAL:70.00535503 NEMRT NORTH EAST MULTI-REGIONAL29099209/17/21 01 PROACTIVE PATROL TACTIC01-210-54-00-5412150.0002 TRAINING-JORDAN** COMMENT **INVOICE TOTAL:150.00 *CHECK TOTAL:150.00535504 NEOPOST QUADIENT FINANCE USA, INC092021-PR09/20/21 01 POSTAGE METER REFILL79-000-14-00-1410200.00INVOICE TOTAL:200.00 *CHECK TOTAL:200.00535505 NICOR NICOR GAS45-12-25-4081 3-0821 09/13/21 01 08/10-09/10 201 W HYDRAULIC 01-110-54-00-548048.31INVOICE TOTAL:48.31 *CHECK TOTAL:48.31535506 NWECHEFC CLIFFORD NWECHEFOM09252109/25/21 01 UMPIRE79-795-54-00-5462105.00INVOICE TOTAL:105.00 *CHECK TOTAL:105.00D002231 ORRKKATHLEEN FIELD ORR & ASSOC.Page 20 of 36      01-110 ADMINISTRATION01-120 FINANCE01-210 POLICE01-220 COMMUNITY DEVELOPMENT01-410 STREETS OPERATION01-640 ADMINISTRATIVE SERVICES01-111 FOX HILL SSA                               01-112 SUNFLOWER ESTATES 15-155 MOTOR FUEL TAX 23-216 MUNICIPAL BUILDING23-230 CITY-WIDE CAPITAL 24-216 BUILDING & GROUNDS25-205 POLICE CAPITAL25-215 PUBLIC WORKS CAPITAL  25-225 PARK & REC CAPITAL 42-420 DEBT SERVICE51-510 WATER OPERATIONS 52-520 SEWER OPERATIONS 72-720 LAND CASH79-790 PARKS DEPARTMENT 79-795 RECREATION DEPARTMENT  82-820 LIBRARY OPERATIONS84-840 LIBRARAY CAPITAL 87-870 COUNTRYSIDE TIF88-880 DOWNTOWN TIF89-890 DOWNTOWN TIF II 90-XXX DEVELOPER ESCROW950-XXX ESCROW DEPOSITDATE: 10/07/21TIME: 09:12:18UNITED CITY OF YORKVILLE CHECK REGISTERID: AP211001.W0WINVOICES DUE ON/BEFORE 10/12/2021CHECK # VENDOR #INVOICE ITEMINVOICE #DATE # DESCRIPTION ACCOUNT # PROJECT CODE ITEM AMT------------------------------------------------------------------------------------------------------------------------------------D002231 ORRKKATHLEEN FIELD ORR & ASSOC.1667010/04/21 01 MISC CITY ADMIN LEGAL MATTERS 01-640-54-00-54563,542.0002 DOWNTOWN TIF II MATTERS89-890-54-00-5462110.0003 HEARTLAND MATTERS01-640-54-00-5456308.0004 KENDALL MARKETPLACE MATTERS 01-640-54-00-5456572.0005 MEETINGS01-640-54-00-5456720.00INVOICE TOTAL:5,252.00 *DIRECT DEPOSIT TOTAL:5,252.00535507 OSWEGO VILLAGE OF OSWEGO133209/15/21 01 SALARY REIMBURSEMENT FOR01-640-54-00-54184,025.2302 PURCHASING MANAGER** COMMENT **03 05/01/21-07/30/21-PARKER** COMMENT **04 SALARY REIMBURSEMENT FOR01-640-54-00-543214,360.4805 FACILITIES MANAGER** COMMENT **06 05/01/21-07/30/21-RAASCH** COMMENT **07 STATE LOBBYIST CHARGES01-640-54-00-54623,500.0008 JUN-AUG 2021** COMMENT **09 STATE LOBBYIST CHARGES51-510-54-00-54623,500.0010 JUN-AUG 2021** COMMENT **11 FEDERAL LOBBYIST CHARGES01-640-54-00-54624,687.5012 JUN-AUG 2021** COMMENT **13 FEDERAL LOBBYIST CHARGES51-510-54-00-54624,687.5014 JUN-AUG 2021** COMMENT **15 SEPT 2019-APR 2021 MILEAGE 01-640-54-00-5432695.0016 REIMBURSEMENT-RAASCH** COMMENT **17 FEDERAL LOBBYIST CHARGES01-640-54-00-543256.3018 MAR-APR 2021** COMMENT **19 FEDERAL LOBBYIST CHARGES MAY 01-640-54-00-543219.9920 2021** COMMENT **21 FEDERAL LOBBYIST CHARGES JUN 01-640-54-00-543269.8822 2021** COMMENT **23 FEDERAL LOBBYIST CHARGES JUL 01-640-54-00-543259.62Page 21 of 36            01-110 ADMINISTRATION01-120 FINANCE01-210 POLICE01-220 COMMUNITY DEVELOPMENT01-410 STREETS OPERATION01-640 ADMINISTRATIVE SERVICES01-111 FOX HILL SSA         01-112 SUNFLOWER ESTATES 15-155 MOTOR FUEL TAX 23-216 MUNICIPAL BUILDING23-230 CITY-WIDE CAPITAL 24-216 BUILDING & GROUNDS25-205 POLICE CAPITAL25-215 PUBLIC WORKS CAPITAL  25-225 PARK & REC CAPITAL 42-420 DEBT SERVICE51-510 WATER OPERATIONS 52-520 SEWER OPERATIONS 72-720 LAND CASH79-790 PARKS DEPARTMENT 79-795 RECREATION DEPARTMENT  82-820 LIBRARY OPERATIONS84-840 LIBRARAY CAPITAL 87-870 COUNTRYSIDE TIF88-880 DOWNTOWN TIF89-890 DOWNTOWN TIF II 90-XXX DEVELOPER ESCROW950-XXX ESCROW DEPOSITDATE: 10/07/21TIME: 09:12:18UNITED CITY OF YORKVILLE CHECK REGISTERID: AP211001.W0WINVOICES DUE ON/BEFORE 10/12/2021CHECK # VENDOR #INVOICE ITEMINVOICE #DATE # DESCRIPTION ACCOUNT # PROJECT CODE ITEM AMT------------------------------------------------------------------------------------------------------------------------------------535507 OSWEGO VILLAGE OF OSWEGO133209/15/21 24 2021** COMMENT **INVOICE TOTAL:35,661.50 *CHECK TOTAL:35,661.50535508 OTTOSEN OTTOSEN DINOLFO13886608/31/21 01 LEGAL RESEARCH REGUARDING 01-640-54-00-545666.0002 SITE OF COUNCIL** COMMENT **INVOICE TOTAL:66.00 *CHECK TOTAL:66.00535509 PARADISE PARADISE CAR WASH22437109/07/21 01 AUG 2021 CAR WASHES01-210-54-00-549574.00INVOICE TOTAL:74.00 *CHECK TOTAL:74.00535510 PEARSONS STEVE PEARSONSEPT 15-SEPT 2709/27/21 01 UMPIRE79-795-54-00-5462110.00INVOICE TOTAL:110.00 *CHECK TOTAL:110.00535511 PFIZENMB BEHR PFIZENMAIERSUMMER 2021 TUITION 10/06/21 01 TUITION REIMBURSEMENT- SUMMER 01-210-54-00-54103,216.0002 2021 - SPANISH 8 CREDIT HOURS ** COMMENT **INVOICE TOTAL:3,216.00 *CHECK TOTAL:3,216.00Page 22 of 36           01-110 ADMINISTRATION01-120 FINANCE01-210 POLICE01-220 COMMUNITY DEVELOPMENT01-410 STREETS OPERATION01-640 ADMINISTRATIVE SERVICES01-111 FOX HILL SSA                  01-112 SUNFLOWER ESTATES 15-155 MOTOR FUEL TAX 23-216 MUNICIPAL BUILDING23-230 CITY-WIDE CAPITAL 24-216 BUILDING & GROUNDS25-205 POLICE CAPITAL25-215 PUBLIC WORKS CAPITAL  25-225 PARK & REC CAPITAL 42-420 DEBT SERVICE51-510 WATER OPERATIONS 52-520 SEWER OPERATIONS 72-720 LAND CASH79-790 PARKS DEPARTMENT 79-795 RECREATION DEPARTMENT  82-820 LIBRARY OPERATIONS84-840 LIBRARAY CAPITAL 87-870 COUNTRYSIDE TIF88-880 DOWNTOWN TIF89-890 DOWNTOWN TIF II 90-XXX DEVELOPER ESCROW950-XXX ESCROW DEPOSITDATE: 10/07/21TIME: 09:12:18UNITED CITY OF YORKVILLE CHECK REGISTERID: AP211001.W0WINVOICES DUE ON/BEFORE 10/12/2021CHECK # VENDOR #INVOICE ITEMINVOICE #DATE # DESCRIPTION ACCOUNT # PROJECT CODE ITEM AMT------------------------------------------------------------------------------------------------------------------------------------535512 PHENEYL LIAM PHENEYSEPT 15-SEPT 2709/27/21 01 UMPIRE79-795-54-00-5462125.00INVOICE TOTAL:125.00 *CHECK TOTAL:125.00535513 PITSTOP PIT STOPPS09/28/21 01 08/27-09/13 PORTOLET79-795-56-00-5620137.1402 UPKEEP-BRISTOL STATION PARK ** COMMENT **INVOICE TOTAL:137.14 *PS40341009/23/21 01 08/27-09/13 PORTOLET79-795-56-00-5620182.0002 UPKEEP-TOWN SQUARE** COMMENT **INVOICE TOTAL:182.00 *PS40341109/23/21 01 08/27-09/13 PORTOLET79-795-56-00-5620262.0002 UPKEEP-RIVERFRONT PARK** COMMENT **INVOICE TOTAL:262.00 *PS40341209/23/21 01 08/27-09/13 PORTOLET79-795-56-00-562080.0002 UPKEEP-VAN EMMON PARK** COMMENT **INVOICE TOTAL:80.00 *PS40341309/23/21 01 08/27-09/13 PORTOLET79-795-56-00-562080.0002 UPKEEP-FOX HILL PARK** COMMENT **INVOICE TOTAL:80.00 *PS40341409/23/21 01 08/27-09/13 PORTOLET79-795-56-00-562080.0002 UPKEEP-FOX HILL PARK EAST** COMMENT **INVOICE TOTAL:80.00 *PS40341509/23/21 01 08/27-09/13 PORTOLET79-795-56-00-5620282.0002 UPKEEP-BEECHER PARK BASEBALL ** COMMENT **03 FIELDS** COMMENT **INVOICE TOTAL:282.00 *Page 23 of 36            01-110 ADMINISTRATION01-120 FINANCE01-210 POLICE01-220 COMMUNITY DEVELOPMENT01-410 STREETS OPERATION01-640 ADMINISTRATIVE SERVICES01-111 FOX HILL SSA                    01-112 SUNFLOWER ESTATES 15-155 MOTOR FUEL TAX 23-216 MUNICIPAL BUILDING23-230 CITY-WIDE CAPITAL 24-216 BUILDING & GROUNDS25-205 POLICE CAPITAL25-215 PUBLIC WORKS CAPITAL   25-225 PARK & REC CAPITAL 42-420 DEBT SERVICE51-510 WATER OPERATIONS 52-520 SEWER OPERATIONS 72-720 LAND CASH79-790 PARKS DEPARTMENT 79-795 RECREATION DEPARTMENT  82-820 LIBRARY OPERATIONS84-840 LIBRARAY CAPITAL 87-870 COUNTRYSIDE TIF88-880 DOWNTOWN TIF89-890 DOWNTOWN TIF II 90-XXX DEVELOPER ESCROW950-XXX ESCROW DEPOSITDATE: 10/07/21TIME: 09:12:18UNITED CITY OF YORKVILLE CHECK REGISTERID: AP211001.W0WINVOICES DUE ON/BEFORE 10/12/2021CHECK # VENDOR #INVOICE ITEMINVOICE #DATE # DESCRIPTION ACCOUNT # PROJECT CODE ITEM AMT------------------------------------------------------------------------------------------------------------------------------------535513 PITSTOP PIT STOPPS40341609/23/21 01 08/27-09/13 PORTOLET79-795-56-00-5620160.0002 UPKEEP-ROTARY PARK** COMMENT **INVOICE TOTAL:160.00 *PS40341709/23/21 01 08/27-09/13 PORTOLET79-795-56-00-562091.0802 UPKEEP-SPLASH PAD** COMMENT **INVOICE TOTAL:91.08 *PS40341809/23/21 01 08/27-09/13 PORTOLET79-795-56-00-562080.0002 UPKEEP-STEVEN BRIDGE PARK** COMMENT **INVOICE TOTAL:80.00 *PS40341909/23/21 01 08/27-09/13 PORTOLET79-795-56-00-5620160.0002 UPKEEP-YORKVILLE MIDDLE SCHOOL ** COMMENT **INVOICE TOTAL:160.00 *PS40342009/23/21 01 08/27-09/13 PORTOLET79-795-56-00-562080.0002 UPKEEP-GREEN PARK BASEBALL** COMMENT **03 FIELD** COMMENT **INVOICE TOTAL:80.00 *PS40342209/23/21 01 08/27-09/13 PORTOLET79-795-56-00-5620160.0002 UPKEEP-RIEMENSCHNEIDER PARK ** COMMENT **INVOICE TOTAL:160.00 *PS40342309/23/21 01 08/27-09/13 PORTOLET79-795-56-00-5620469.0002 UPKEEP-SOCCER EQUIPMENT SHED ** COMMENT **INVOICE TOTAL:469.00 *PS40342409/23/21 01 08/27-09/13 PORTOLET79-795-56-00-562051.4302 UPKEEP-STEPPING STONES PARK ** COMMENT **INVOICE TOTAL:51.43 *PS40342509/23/21 01 08/27-09/13 PORTOLET79-795-56-00-5620392.00Page 24 of 36            01-110 ADMINISTRATION01-120 FINANCE01-210 POLICE01-220 COMMUNITY DEVELOPMENT01-410 STREETS OPERATION01-640 ADMINISTRATIVE SERVICES01-111 FOX HILL SSA            01-112 SUNFLOWER ESTATES 15-155 MOTOR FUEL TAX 23-216 MUNICIPAL BUILDING23-230 CITY-WIDE CAPITAL 24-216 BUILDING & GROUNDS25-205 POLICE CAPITAL25-215 PUBLIC WORKS CAPITAL  25-225 PARK & REC CAPITAL 42-420 DEBT SERVICE51-510 WATER OPERATIONS 52-520 SEWER OPERATIONS 72-720 LAND CASH79-790 PARKS DEPARTMENT 79-795 RECREATION DEPARTMENT  82-820 LIBRARY OPERATIONS84-840 LIBRARAY CAPITAL 87-870 COUNTRYSIDE TIF88-880 DOWNTOWN TIF89-890 DOWNTOWN TIF II 90-XXX DEVELOPER ESCROW950-XXX ESCROW DEPOSITDATE: 10/07/21TIME: 09:12:18UNITED CITY OF YORKVILLE CHECK REGISTERID: AP211001.W0WINVOICES DUE ON/BEFORE 10/12/2021CHECK # VENDOR #INVOICE ITEMINVOICE #DATE # DESCRIPTION ACCOUNT # PROJECT CODE ITEM AMT------------------------------------------------------------------------------------------------------------------------------------535513 PITSTOP PIT STOPPS40342509/23/21 02 UPKEEP-210 S BRIDGE** COMMENT **INVOICE TOTAL:392.00 *PS40342609/23/21 01 08/27-09/13 PORTOLET79-795-56-00-562060.00 02 UPKEEP-HIDING SPOT PARK** COMMENT **INVOICE TOTAL:60.00 *CHECK TOTAL:2,806.65535514 PURCELLJ JOHN PURCELL10012110/01/21 01 SEPT 2021 MOBILE EMAIL01-110-54-00-544045.0002 REIMBURSEMENT** COMMENT **INVOICE TOTAL:45.00 *CHECK TOTAL:45.00535515 R0001975 RYAN HOMES4807 MILLBROOK09/20/21 01 SECURITY GUARANTEE REFUND 01-000-24-00-2415375.00INVOICE TOTAL:375.00 *4854 W MILLBROOK 09/20/21 01 SECURITY GUARANTEE REFUND 01-000-24-00-24151,350.00INVOICE TOTAL:1,350.00 *CHECK TOTAL:1,725.00535516 R0002208 HARI DEVELOPMENT YORKVILLE LLC073121-STREBATE09/22/21 01 MAY 2021-JUL 2021 SALES TAX 01-640-54-00-54921,332.0102 REBATE** COMMENT **INVOICE TOTAL:1,332.01 *CHECK TOTAL:1,332.01Page 25 of 36             01-110 ADMINISTRATION01-120 FINANCE01-210 POLICE01-220 COMMUNITY DEVELOPMENT01-410 STREETS OPERATION01-640 ADMINISTRATIVE SERVICES01-111 FOX HILL SSA          01-112 SUNFLOWER ESTATES 15-155 MOTOR FUEL TAX 23-216 MUNICIPAL BUILDING23-230 CITY-WIDE CAPITAL 24-216 BUILDING & GROUNDS25-205 POLICE CAPITAL25-215 PUBLIC WORKS CAPITAL  25-225 PARK & REC CAPITAL 42-420 DEBT SERVICE51-510 WATER OPERATIONS 52-520 SEWER OPERATIONS 72-720 LAND CASH79-790 PARKS DEPARTMENT 79-795 RECREATION DEPARTMENT  82-820 LIBRARY OPERATIONS84-840 LIBRARAY CAPITAL 87-870 COUNTRYSIDE TIF88-880 DOWNTOWN TIF89-890 DOWNTOWN TIF II 90-XXX DEVELOPER ESCROW950-XXX ESCROW DEPOSITDATE: 10/07/21TIME: 09:12:18UNITED CITY OF YORKVILLE CHECK REGISTERID: AP211001.W0WINVOICES DUE ON/BEFORE 10/12/2021CHECK # VENDOR #INVOICE ITEMINVOICE #DATE # DESCRIPTION ACCOUNT # PROJECT CODE ITEM AMT------------------------------------------------------------------------------------------------------------------------------------535517 R0002288 LENNAR2235 FAIRRAX09/21/21 01 SECURITY GUARANTEE REFUND 01-000-24-00-2415600.00INVOICE TOTAL:600.00 *576 WARBLER09/28/21 01 SECURITY GUARANTEE REFUND 01-000-24-00-2415600.00INVOICE TOTAL:600.00 *CHECK TOTAL:1,200.00535518 R0002471 JODI MORGAN09172109/17/21 01 REFUND OVERPAYMENT ON FINAL 01-000-13-00-1371237.9702 BILL ON ACCT#0102754421-01** COMMENT **INVOICE TOTAL:237.97 *CHECK TOTAL:237.97535519 R0002472 KERRI MISPAGELMENARDS6153609/23/21 01 DAMAGED MAILBOX REPLACEMENT 01-410-56-00-564013.78INVOICE TOTAL:13.78 *CHECK TOTAL:13.78535520 R0002473 ART PROCHASKA092421-RFND09/28/21 01 REFUND OVERPAYMENT ON FINAL 01-000-13-00-1371190.9002 BILL FOR ACCT#0103521030-02 ** COMMENT **INVOICE TOTAL:190.90 *CHECK TOTAL:190.90535521 R0002474 JASMINE WRIGHT092321-RFND09/23/21 01 REFUND OVERPAYMENT ON FINAL 01-000-13-00-1371218.85Page 26 of 36             01-110 ADMINISTRATION01-120 FINANCE01-210 POLICE01-220 COMMUNITY DEVELOPMENT01-410 STREETS OPERATION01-640 ADMINISTRATIVE SERVICES01-111 FOX HILL SSA         01-112 SUNFLOWER ESTATES 15-155 MOTOR FUEL TAX 23-216 MUNICIPAL BUILDING23-230 CITY-WIDE CAPITAL 24-216 BUILDING & GROUNDS25-205 POLICE CAPITAL25-215 PUBLIC WORKS CAPITAL  25-225 PARK & REC CAPITAL 42-420 DEBT SERVICE51-510 WATER OPERATIONS 52-520 SEWER OPERATIONS 72-720 LAND CASH79-790 PARKS DEPARTMENT 79-795 RECREATION DEPARTMENT  82-820 LIBRARY OPERATIONS84-840 LIBRARAY CAPITAL 87-870 COUNTRYSIDE TIF88-880 DOWNTOWN TIF89-890 DOWNTOWN TIF II 90-XXX DEVELOPER ESCROW950-XXX ESCROW DEPOSITDATE: 10/07/21TIME: 09:12:18UNITED CITY OF YORKVILLE CHECK REGISTERID: AP211001.W0WINVOICES DUE ON/BEFORE 10/12/2021CHECK # VENDOR #INVOICE ITEMINVOICE #DATE # DESCRIPTION ACCOUNT # PROJECT CODE ITEM AMT------------------------------------------------------------------------------------------------------------------------------------535521 R0002474 JASMINE WRIGHT092321-RFND09/23/21 02 BILL FOR ACCT#0102610290-03 ** COMMENT **INVOICE TOTAL:218.85 *CHECK TOTAL:218.85535522 RADARMAN CINDY GRISWOLD501905/13/21 01 RADAR CERTIFICATIONS & TUNING 01-210-54-00-5495570.00INVOICE TOTAL:570.00 *511107/28/21 01 RADAR CERTIFICATIONS & TUNING 01-210-54-00-5495120.00INVOICE TOTAL:120.00 *CHECK TOTAL:690.00D002232 REDMONST STEVE REDMON10012110/01/21 01 SEPT 2021 MOBILE EMAIL79-795-54-00-544045.0002 REIMBURSEMENT** COMMENT **INVOICE TOTAL:45.00 *DIRECT DEPOSIT TOTAL:45.00535523 RIETZR ROBERT L. RIETZ JR.09162109/16/21 01 UMPIRE79-795-54-00-5462160.00INVOICE TOTAL:160.00 *09232109/23/21 01 UMPIRE79-795-54-00-5462160.00INVOICE TOTAL:160.00 *CHECK TOTAL:320.00D002233 ROSBOROS SHAY REMUSPage 27 of 36            01-110 ADMINISTRATION01-120 FINANCE01-210 POLICE01-220 COMMUNITY DEVELOPMENT01-410 STREETS OPERATION01-640 ADMINISTRATIVE SERVICES01-111 FOX HILL SSA           01-112 SUNFLOWER ESTATES 15-155 MOTOR FUEL TAX 23-216 MUNICIPAL BUILDING23-230 CITY-WIDE CAPITAL 24-216 BUILDING & GROUNDS25-205 POLICE CAPITAL25-215 PUBLIC WORKS CAPITAL  25-225 PARK & REC CAPITAL 42-420 DEBT SERVICE51-510 WATER OPERATIONS 52-520 SEWER OPERATIONS 72-720 LAND CASH79-790 PARKS DEPARTMENT 79-795 RECREATION DEPARTMENT  82-820 LIBRARY OPERATIONS84-840 LIBRARAY CAPITAL 87-870 COUNTRYSIDE TIF88-880 DOWNTOWN TIF89-890 DOWNTOWN TIF II 90-XXX DEVELOPER ESCROW950-XXX ESCROW DEPOSITDATE: 10/07/21TIME: 09:12:18UNITED CITY OF YORKVILLE CHECK REGISTERID: AP211001.W0WINVOICES DUE ON/BEFORE 10/12/2021CHECK # VENDOR #INVOICE ITEMINVOICE #DATE # DESCRIPTION ACCOUNT # PROJECT CODE ITEM AMT------------------------------------------------------------------------------------------------------------------------------------D002233 ROSBOROS SHAY REMUS10012110/01/21 01 SEPT 2021 MOBILE EMAIL79-795-54-00-544045.0002 REIMBURSEMENT** COMMENT **INVOICE TOTAL:45.00 *DIRECT DEPOSIT TOTAL:45.00D002234 SCHREIBE EMILY J. SCHREIBER10012110/01/21 01 SEPT 2021 MOBILE EMAIL79-795-54-00-544045.0002 REIMBURSEMENT** COMMENT **INVOICE TOTAL:45.00 *DIRECT DEPOSIT TOTAL:45.00D002235 SCODROP PETER SCODRO10012110/01/21 01 SEPT 2021 MOBILE EMAIL51-510-54-00-544045.0002 REIMBURSEMENT** COMMENT **INVOICE TOTAL:45.00 *DIRECT DEPOSIT TOTAL:45.00D002236 SCOTTTR TREVOR SCOTT10012110/01/21 01 SEPT 2021 MOBILE EMAIL79-790-54-00-544045.0002 REIMBURSEMENT** COMMENT **INVOICE TOTAL:45.00 *DIRECT DEPOSIT TOTAL:45.00535524 SEBIS SEBIS DIRECT3508909/13/21 01 AUG 2021 UTILITY BILLING01-120-54-00-5430359.8002 AUG 2021 UTILITY BILLING51-510-54-00-5430482.05Page 28 of 36            01-110 ADMINISTRATION01-120 FINANCE01-210 POLICE01-220 COMMUNITY DEVELOPMENT01-410 STREETS OPERATION01-640 ADMINISTRATIVE SERVICES01-111 FOX HILL SSA          01-112 SUNFLOWER ESTATES15-155 MOTOR FUEL TAX23-216 MUNICIPAL BUILDING23-230 CITY-WIDE CAPITAL 24-216 BUILDING & GROUNDS25-205 POLICE CAPITAL25-215 PUBLIC WORKS CAPITAL  25-225 PARK & REC CAPITAL 42-420 DEBT SERVICE51-510 WATER OPERATIONS52-520 SEWER OPERATIONS72-720 LAND CASH79-790 PARKS DEPARTMENT 79-795 RECREATION DEPARTMENT  82-820 LIBRARY OPERATIONS84-840 LIBRARAY CAPITAL 87-870 COUNTRYSIDE TIF88-880 DOWNTOWN TIF89-890 DOWNTOWN TIF II90-XXX DEVELOPER ESCROW950-XXX ESCROW DEPOSITDATE: 10/07/21TIME: 09:12:18UNITED CITY OF YORKVILLE CHECK REGISTERID: AP211001.W0WINVOICES DUE ON/BEFORE 10/12/2021CHECK # VENDOR #INVOICE ITEMINVOICE #DATE # DESCRIPTION ACCOUNT # PROJECT CODE ITEM AMT------------------------------------------------------------------------------------------------------------------------------------535524 SEBIS SEBIS DIRECT3508909/13/21 03 AUG 2021 UTILITY BILLING52-520-54-00-5430224.8604 AUG 2021 UTILITY BILLING79-795-54-00-5426264.60INVOICE TOTAL:1,331.31 *CHECK TOTAL:1,331.31D002237 SENGM MATT SENG10012110/01/21 01 SEPT 2021 MOBILE EMAIL01-410-54-00-544045.0002 REIMBURSEMENT** COMMENT **INVOICE TOTAL:45.00 *DIRECT DEPOSIT TOTAL:45.00535525 SENIOR SENIOR SERVICES ASSOCIATES,INC092021-SPONSOR09/20/21 01 BIG BAND & BBQ SPONSORSHIP79-795-56-00-5602200.0002 PROCEEDS** COMMENT **INVOICE TOTAL:200.00 *CHECK TOTAL:200.00535526 SIMMONS SIMMONS, SHARON10012110/01/21 01 SEPT 2021 MOBILE EMAIL01-120-54-00-544045.0002 REIMBURSEMENT** COMMENT **INVOICE TOTAL:45.00 *CHECK TOTAL:45.00535527 SIPEST TIM SIPESSEPT 15-SEPT 2709/27/21 01 UMPIRE79-795-54-00-546255.00INVOICE TOTAL:55.00 *CHECK TOTAL:55.00Page 29 of 36            01-110 ADMINISTRATION01-120 FINANCE01-210 POLICE01-220 COMMUNITY DEVELOPMENT01-410 STREETS OPERATION01-640 ADMINISTRATIVE SERVICES01-111 FOX HILL SSA           01-112 SUNFLOWER ESTATES 15-155 MOTOR FUEL TAX 23-216 MUNICIPAL BUILDING23-230 CITY-WIDE CAPITAL 24-216 BUILDING & GROUNDS25-205 POLICE CAPITAL25-215 PUBLIC WORKS CAPITAL  25-225 PARK & REC CAPITAL 42-420 DEBT SERVICE51-510 WATER OPERATIONS 52-520 SEWER OPERATIONS 72-720 LAND CASH79-790 PARKS DEPARTMENT 79-795 RECREATION DEPARTMENT  82-820 LIBRARY OPERATIONS84-840 LIBRARAY CAPITAL 87-870 COUNTRYSIDE TIF88-880 DOWNTOWN TIF89-890 DOWNTOWN TIF II 90-XXX DEVELOPER ESCROW950-XXX ESCROW DEPOSITDATE: 10/07/21TIME: 09:12:18UNITED CITY OF YORKVILLE CHECK REGISTERID: AP211001.W0WINVOICES DUE ON/BEFORE 10/12/2021CHECK # VENDOR #INVOICE ITEMINVOICE #DATE # DESCRIPTION ACCOUNT # PROJECT CODE ITEM AMT------------------------------------------------------------------------------------------------------------------------------------D002238 SLEEZERJ JOHN SLEEZER10012110/01/21 01 SEPT 2021 MOBILE EMAIL01-410-54-00-544045.0002 REIMBURSEMENT** COMMENT **INVOICE TOTAL:45.00 *DIRECT DEPOSIT TOTAL:45.00D002239 SLEEZERS SCOTT SLEEZER10012110/01/21 01 SEPT 2021 MOBILE EMAIL79-790-54-00-544045.0002 REIMBURSEMENT** COMMENT **INVOICE TOTAL:45.00 *DIRECT DEPOSIT TOTAL:45.00D002240 SMITHD DOUG SMITH10012110/01/21 01 SEPT 2021 MOBILE EMAIL79-790-54-00-544045.0002 REIMBURSEMENT** COMMENT **INVOICE TOTAL:45.00 *DIRECT DEPOSIT TOTAL:45.00D002241 SOELKET TOM SOELKE10012110/01/21 01 SEPT 2021 MOBILE EMAIL52-520-54-00-544045.0002 REIMBURSEMENT** COMMENT **INVOICE TOTAL:45.00 *DIRECT DEPOSIT TOTAL:45.00D002242 STEFFANG GEORGE A STEFFENS10012110/01/21 01 SEPT 2021 MOBILE EMAIL52-520-54-00-544045.0002 REIMBURSEMENT** COMMENT **INVOICE TOTAL:45.00 *DIRECT DEPOSIT TOTAL:45.00Page 30 of 36            01-110 ADMINISTRATION01-120 FINANCE01-210 POLICE01-220 COMMUNITY DEVELOPMENT01-410 STREETS OPERATION01-640 ADMINISTRATIVE SERVICES01-111 FOX HILL SSA           01-112 SUNFLOWER ESTATES15-155 MOTOR FUEL TAX23-216 MUNICIPAL BUILDING23-230 CITY-WIDE CAPITAL 24-216 BUILDING & GROUNDS25-205 POLICE CAPITAL25-215 PUBLIC WORKS CAPITAL  25-225 PARK & REC CAPITAL 42-420 DEBT SERVICE51-510 WATER OPERATIONS52-520 SEWER OPERATIONS72-720 LAND CASH79-790 PARKS DEPARTMENT 79-795 RECREATION DEPARTMENT  82-820 LIBRARY OPERATIONS84-840 LIBRARAY CAPITAL 87-870 COUNTRYSIDE TIF88-880 DOWNTOWN TIF89-890 DOWNTOWN TIF II90-XXX DEVELOPER ESCROW950-XXX ESCROW DEPOSITDATE: 10/07/21TIME: 09:12:18UNITED CITY OF YORKVILLE CHECK REGISTERID: AP211001.W0WINVOICES DUE ON/BEFORE 10/12/2021CHECK # VENDOR #INVOICE ITEMINVOICE #DATE # DESCRIPTION ACCOUNT # PROJECT CODE ITEM AMT------------------------------------------------------------------------------------------------------------------------------------535528 STOKES STOKES EXCAVATING, INC491509/20/21 01 ENGINEER'S PAYMENT ESTIMATE 51-510-60-00-6025160,701.2602 #4-ELIZABETH ST AND APPLETREE ** COMMENT **03 CT WATER MAIN IMPROVEMENTS** COMMENT **INVOICE TOTAL:160,701.26 *CHECK TOTAL:160,701.26D002243 THOMASL LORI THOMAS10012110/01/21 01 SEPT 2021 MOBILE EMAIL01-120-54-00-544045.0002 REIMBURSEMENT** COMMENT **INVOICE TOTAL:45.00 *DIRECT DEPOSIT TOTAL:45.00535529 TIETZJ JAMES A. TIETZSEPT 15-SEPT 2709/27/21 01 UMPIRE79-795-54-00-546255.00INVOICE TOTAL:55.00 *CHECK TOTAL:55.00535530 TRAFFIC TRAFFIC CONTROL CORPORATION12964106/25/21 01 GREEN LEDS01-410-54-00-5435113.09INVOICE TOTAL:113.09 *CHECK TOTAL:113.09535531 TRICO TRICO MECHANICAL , INC600308/23/21 01 HVAC REPAIR AT PW AND IN IT 24-216-54-00-5446765.0002 ROOM** COMMENT **INVOICE TOTAL:765.00 *Page 31 of 36            01-110 ADMINISTRATION01-120 FINANCE01-210 POLICE01-220 COMMUNITY DEVELOPMENT01-410 STREETS OPERATION01-640 ADMINISTRATIVE SERVICES01-111 FOX HILL SSA          01-112 SUNFLOWER ESTATES15-155 MOTOR FUEL TAX23-216 MUNICIPAL BUILDING23-230 CITY-WIDE CAPITAL 24-216 BUILDING & GROUNDS25-205 POLICE CAPITAL25-215 PUBLIC WORKS CAPITAL  25-225 PARK & REC CAPITAL 42-420 DEBT SERVICE51-510 WATER OPERATIONS52-520 SEWER OPERATIONS72-720 LAND CASH79-790 PARKS DEPARTMENT 79-795 RECREATION DEPARTMENT  82-820 LIBRARY OPERATIONS84-840 LIBRARAY CAPITAL 87-870 COUNTRYSIDE TIF88-880 DOWNTOWN TIF89-890 DOWNTOWN TIF II90-XXX DEVELOPER ESCROW950-XXX ESCROW DEPOSITDATE: 10/07/21TIME: 09:12:18UNITED CITY OF YORKVILLE CHECK REGISTERID: AP211001.W0WINVOICES DUE ON/BEFORE 10/12/2021CHECK # VENDOR #INVOICE ITEMINVOICE #DATE # DESCRIPTION ACCOUNT # PROJECT CODE ITEM AMT------------------------------------------------------------------------------------------------------------------------------------535531 TRICO TRICO MECHANICAL , INC600608/31/21 01 HVAC REPAIR AT PD24-216-54-00-5446458.71INVOICE TOTAL:458.71 *CHECK TOTAL:1,223.71535532 TURFTEAM THE TURF TEAM, INC.17858109/03/21 01 APRON CHAPS51-510-56-00-560074.0002 APRON CHAPS52-520-56-00-562073.9903 APRON CHAPS01-410-56-00-562073.99INVOICE TOTAL:221.98 *17889709/14/21 01 BRUSHCUTTER REPAIR01-410-56-00-5628231.93INVOICE TOTAL:231.93 *1789809/14/21 01 CHOKE KNOB01-410-56-00-562810.41INVOICE TOTAL:10.41 *CHECK TOTAL:464.32535533 UMBBANK UMB BANK073121-STREBATE09/22/21 01 MAY 2021-JUL 2021 SALES TAX 01-640-54-00-5492140,373.9302 REBATE** COMMENT **INVOICE TOTAL:140,373.93 *CHECK TOTAL:140,373.93535534 VOITIKM MICHAEL VOITIK09162109/16/21 01 UMPIRE79-795-54-00-5462160.00INVOICE TOTAL:160.00 *CHECK TOTAL:160.00Page 32 of 36             01-110 ADMINISTRATION01-120 FINANCE01-210 POLICE01-220 COMMUNITY DEVELOPMENT01-410 STREETS OPERATION01-640 ADMINISTRATIVE SERVICES01-111 FOX HILL SSA            01-112 SUNFLOWER ESTATES 15-155 MOTOR FUEL TAX 23-216 MUNICIPAL BUILDING23-230 CITY-WIDE CAPITAL 24-216 BUILDING & GROUNDS25-205 POLICE CAPITAL25-215 PUBLIC WORKS CAPITAL  25-225 PARK & REC CAPITAL 42-420 DEBT SERVICE51-510 WATER OPERATIONS 52-520 SEWER OPERATIONS 72-720 LAND CASH79-790 PARKS DEPARTMENT 79-795 RECREATION DEPARTMENT  82-820 LIBRARY OPERATIONS84-840 LIBRARAY CAPITAL 87-870 COUNTRYSIDE TIF88-880 DOWNTOWN TIF89-890 DOWNTOWN TIF II 90-XXX DEVELOPER ESCROW950-XXX ESCROW DEPOSITDATE: 10/07/21TIME: 09:12:18UNITED CITY OF YORKVILLE CHECK REGISTERID: AP211001.W0WINVOICES DUE ON/BEFORE 10/12/2021CHECK # VENDOR #INVOICE ITEMINVOICE #DATE # DESCRIPTION ACCOUNT # PROJECT CODE ITEM AMT------------------------------------------------------------------------------------------------------------------------------------535535 WALDEB BRYAN WALDE09182109/18/21 01 UMPIRE79-795-54-00-5462105.00INVOICE TOTAL:105.00 *CHECK TOTAL:105.00535536 WATERSYS WATER SOLUTIONS UNLIMITED, INC4547209/10/21 01 CHLORINE51-510-56-00-5638396.00INVOICE TOTAL:396.00 *CHECK TOTAL:396.00D002244 WEBERR ROBERT WEBER10012110/01/21 01 SEPT 2021 MOBILE EMAIL01-410-54-00-544045.0002 REIMBURSEMENT** COMMENT **INVOICE TOTAL:45.00 *DIRECT DEPOSIT TOTAL:45.00D002245 WILLRETE ERIN WILLRETT10012110/01/21 01 SEPT 2021 MOBILE EMAIL01-110-54-00-544045.0002 REIMBURSEMENT** COMMENT **INVOICE TOTAL:45.00 *DIRECT DEPOSIT TOTAL:45.00535537 YORKACE YORKVILLE ACE & RADIO SHACK17419109/21/21 01 BATTERIES79-795-56-00-564015.98INVOICE TOTAL:15.98 *17419609/21/21 01 RETURNED BATTERIES CREDIT 79-795-56-00-5640-7.99INVOICE TOTAL:-7.99 *Page 33 of 36    01-110 ADMINISTRATION01-120 FINANCE01-210 POLICE01-220 COMMUNITY DEVELOPMENT01-410 STREETS OPERATION01-640 ADMINISTRATIVE SERVICES01-111 FOX HILL SSA   01-112 SUNFLOWER ESTATES15-155 MOTOR FUEL TAX23-216 MUNICIPAL BUILDING23-230 CITY-WIDE CAPITAL 24-216 BUILDING & GROUNDS25-205 POLICE CAPITAL25-215 PUBLIC WORKS CAPITAL  25-225 PARK & REC CAPITAL 42-420 DEBT SERVICE51-510 WATER OPERATIONS52-520 SEWER OPERATIONS72-720 LAND CASH79-790 PARKS DEPARTMENT 79-795 RECREATION DEPARTMENT  82-820 LIBRARY OPERATIONS84-840 LIBRARAY CAPITAL 87-870 COUNTRYSIDE TIF88-880 DOWNTOWN TIF89-890 DOWNTOWN TIF II90-XXX DEVELOPER ESCROW950-XXX ESCROW DEPOSITDATE: 10/07/21TIME: 09:12:18UNITED CITY OF YORKVILLE CHECK REGISTERID: AP211001.W0WINVOICES DUE ON/BEFORE 10/12/2021CHECK # VENDOR #INVOICE ITEMINVOICE #DATE # DESCRIPTION ACCOUNT # PROJECT CODE ITEM AMT------------------------------------------------------------------------------------------------------------------------------------535537 YORKACE YORKVILLE ACE & RADIO SHACK17420209/23/21 01 2 IN 1 FILE HOLDER79-790-56-00-562042.99INVOICE TOTAL:42.99 *CHECK TOTAL:50.98575,708.2431,946.00TOTAL CHECKS PAID: TOTAL DIRECT DEPOSITS PAID: TOTAL AMOUNT PAID:607,654.24Page 34 of 36 REGULAR OVERTIME TOTAL IMRF FICA TOTALSADMINISTRATION15,575.27$ -$ 15,575.27 1,689.74$ 766.02$ 18,031.03$ FINANCE11,519.60 - 11,519.60 1,313.16 883.20 13,715.96$ POLICE135,171.68 1,283.45 136,455.13 662.21 10,258.18 147,375.52$ COMMUNITY DEV.20,937.45 - 20,937.45 2,392.82 1,587.91 24,918.18$ STREETS17,473.94 202.96 17,676.90 1,963.90 1,295.63 20,936.43$ WATER17,767.87 238.03 18,005.90 2,000.47 1,311.74 21,318.11$ SEWER9,947.23 - 9,947.23 1,105.15 725.03 11,777.41$ PARKS26,101.03 281.31 26,382.34 2,735.88 1,972.95 31,091.17$ RECREATION20,346.75 20,346.75 1,922.60 1,552.50 23,821.85$ LIBRARY17,704.62 - 17,704.62 1,191.68 1,316.49 20,212.79$ TOTALS292,545.44$ 2,005.75$ 294,551.19$ 16,977.61$ 21,669.65$ 333,198.45$ TOTAL PAYROLL333,198.45$ UNITED CITY OF YORKVILLEPAYROLL SUMMARYOctober 1, 2021Page 35 of 36 ACCOUNTS PAYABLE DATE City Check Register (Pages 1 - 34)10/12/2021 607,654.24$ SUB-TOTAL:$607,654.24 ACH/WIRE PAYMENTS Dearborn Insurannce 10/01/2021 2,718.38$ Blue Cross/ Blue Shield Insurance - Aug 2021 09/30/2021 127,511.02 TOTAL PAYMENTS:$130,229.40 Bi - Weekly (Page 35)09/17/2021 337,928.73$ SUB-TOTAL:337,928.73$ TOTAL DISBURSEMENTS:1,075,812.37$ UNITED CITY OF YORKVILLE BILL LIST SUMMARY Tuesday, October 12, 2021 PAYROLL Page 36 of 36 Have a question or comment about this agenda item? Call us Monday-Friday, 8:00am to 4:30pm at 630-553-4350, email us at agendas@yorkville.il.us, post at www.facebook.com/CityofYorkville, tweet us at @CityofYorkville, and/or contact any of your elected officials at http://www.yorkville.il.us/320/City-Council Agenda Item Summary Memo Title: Meeting and Date: Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Agenda Item Notes: Reviewed By: Legal Finance Engineer City Administrator Human Resources Community Development Police Public Works Parks and Recreation Agenda Item Number Administration Committee #1 Tracking Number CC 2021-44 Copier RFP – Results & Recommendation City Council – October 12, 2021 Majority Approval Please see attached. Rob Fredrickson Finance Name Department Last month the City issued a request for proposals (RFP) for copier equipment and related services for six copiers located at City Hall (Administration/Finance & Community Development), the Police Department (Police Admin & Patrol Room), Public Works and Recreation. Staff also requested proposals for four additional copiers (Administration/Finance, Community Development and Preschool), to be implemented once renovations at the Prairie Point building are complete. Staff received nine proposals from the following firms: Impact Networking; Konica Minolta Business Solutions; Marco; Proven IT; Xerox Business Solutions; CDS Office Technologies; RK Dixon; COTG; McGrath Office Equipment; and Toshiba Business Solutions. One of the issues encountered during the RFP process had to do with the four additional copiers that will be needed once the City moves its operations to the new City Hall/Police Station. Since the City is not exactly sure as to when this transition will take place, none of proposing firms were able to lock in lease rates presently for the four additional copiers. Furthermore, assuming the City enters into 36-month term for the six existing copiers (which has been our past practice), we would have to do a custom lease (i.e., 24-months or less) for the additional four copiers in order for the lease terms to run coterminous; which would be rather expensive due to the shortened lease term. Moreover, several vendors have expressed concern about their ability to have the new copiers in place by the end of the October, as the recent global chip shortage has begun to impact inventory levels. Upon review of the proposal submissions, it is the recommendation of staff that the City reject all RFP’s at this time and instead continue on a month-to-month basis with our current provider, Impact Networking, LLC. As noted on the 36-month bid summary exhibit, Impact’s current prices are approximately $750 a year less than the current low-cost provider and the existing copiers (manufactured by Toshiba) have required little to no maintenance. It is staff’s intention to continue with our current provider for the next 10-12 months, until we have a better idea as to when the City will commence operations in the new building. Once that date is known, staff would once again go out for RFP for ten copiers and would expect to find more favorable pricing as the global chip shortage will hopefully have been abated. Memorandum To: City Council From: Rob Fredrickson, Finance Director Date: October 7, 2021 Subject: Copier RFP Results & Recommendation Monthly Cost Annualized Cost $ 1,548.65 $ 18,583.80 RK Dixon 1,611.48$ 19,337.76$ Marco 1,656.55 19,878.54 CDS Office Technology 1,750.34 21,004.08 Toshiba Business Solutions 1,773.38 21,280.50 Impact Networking 2,027.31 24,327.66 Proven IT 2,038.30 24,459.58 Xerox Business Solutions 2,123.22 25,478.64 Konica Minolta 2,507.00 30,083.94 McGrath Office Equipment 2,777.50 33,330.00 Impact Networking - current provider Existing Copiers (6) 36 - Month Lease Term 1 Make/Model 36 - Month Lease 36 - Month Maint Contract Other Features Monthly Cost Annualized Cost B&W Color CDS Office Technologies Admin-1 Sharp MX-5051 12,800 5,400 213.14$ B/W - $0.004/pg. Color - $0.03/pg.includes hole punch, staple & fax $ 426.34 $ 5,116.08 Police-1 Sharp MX-5051 5,400 1,500 213.14 B/W - $0.004/pg. Color - $0.03/pg.includes hole punch, staple & fax 279.74 3,356.88 Police-2 Sharp MX-M3051 3,800 - 123.31 B/W - $0.004/pg. includes staple & fax 138.51 1,662.12 Comm Dvlp-1 Sharp MX-5051 3,300 3,700 213.14 B/W - $0.004/pg. Color - $0.03/pg.includes hole punch, staple & fax 337.34 4,048.08 Public Works Sharp MX-3051 850 300 138.67 B/W - $0.004/pg. Color - $0.03/pg. includes staple & fax 151.07 1,812.84 Recreation Sharp MX-5051 5,300 6,100 213.14 B/W - $0.004/pg. Color - $0.03/pg.includes hole punch, staple & fax 417.34 5,008.08 31,450 17,000 36-Month Subtotal $ 1,750.34 $ 21,004.08 Impact (Current Provider) Admin-1 TASKalfa 5053cici 12,800 5,400 214.17$ B/W - $0.0065/pg. Color - $0.035/pg.includes hole punch, staple & fax $ 486.37 $ 5,836.44 Police-1 TASKalfa 5053cici 5,400 1,500 214.17 B/W - $0.0065/pg. Color - $0.035/pg.includes hole punch, staple & fax 301.77 3,621.24 Police-2 TASKalfa 4003i 3,800 - 164.60 B/W - $0.0065/pg. includes staple & fax 189.30 2,271.60 Comm Dvlp-1 TASKalfa 5053cici 3,300 3,700 214.17 B/W - $0.0065/pg. Color - $0.035/pg.includes hole punch, staple & fax 365.12 4,381.44 Public Works TASKalfa 5053cici 850 300 206.60 B/W - $0.0065/pg. Color - $0.035/pg. includes staple & fax 222.63 2,671.50 Recreation TASKalfa 5053cici 5,300 6,100 214.17 B/W - $0.0065/pg. Color - $0.035/pg.includes hole punch, staple & fax 462.12 5,545.44 31,450 17,000 36-Month Subtotal $ 2,027.31 $ 24,327.66 Average Volumes 2 Make/Model 36 - Month Lease 36 - Month Maint Contract Other Features Monthly Cost Annualized Cost B&W Color Average Volumes Konica Minolta Admin-1 BizHub C5501 12,800 5,400 334.96$ B/W - $0.0039/pg. Color - $0.04/pg.includes hole punch, staple & fax $ 600.88 $ 7,210.56 Police-1 BizHub C5501 5,400 1,500 334.96 B/W - $0.0039/pg. Color - $0.04/pg.includes hole punch, staple & fax 416.02 4,992.24 Police-2 BizHub C3001 3,800 - 182.25 B/W - $0.0039/pg. includes staple & fax 197.07 2,364.84 Comm Dvlp-1 BizHub C5501 3,300 3,700 334.96 B/W - $0.0039/pg. Color - $0.04/pg.includes hole punch, staple & fax 495.83 5,949.96 Public Works BizHub C3001 850 300 182.25 B/W - $0.0039/pg. includes staple & fax 197.57 2,370.78 Recreation BizHub C5501 5,300 6,100 334.96 B/W - $0.0039/pg. Color - $0.04/pg.includes hole punch, staple & fax 599.63 7,195.56 31,450 17,000 36-Month Subtotal $ 2,507.00 $ 30,083.94 Marco Admin-1 Sharp MX 5071 12,800 5,400 176.94$ B/W - $0.0035/pg. Color - $0.035/pg.includes hole punch, staple & fax $ 410.74 $ 4,928.88 Police-1 Sharp MX 5071 5,400 1,500 176.94 B/W - $0.0035/pg. Color - $0.035/pg.includes hole punch, staple & fax 248.34 2,980.08 Police-2 Sharp MX M3071 3,800 - 110.15 B/W - $0.0035/pg. Color - $0.035/pg. includes staple & fax 123.45 1,481.40 Comm Dvlp-1 Sharp MX 5071 3,300 3,700 176.94 B/W - $0.0035/pg. Color - $0.035/pg.includes hole punch, staple & fax 317.99 3,815.88 Public Works Sharp MX 3071 850 300 133.56 B/W - $0.0035/pg. Color - $0.035/pg. includes staple & fax 147.04 1,764.42 Recreation Sharp MX 5071 5,300 6,100 176.94 B/W - $0.0035/pg. Color - $0.035/pg.includes hole punch, staple & fax 408.99 4,907.88 31,450 17,000 36-Month Subtotal $ 1,656.55 $ 19,878.54 3 Make/Model 36 - Month Lease 36 - Month Maint Contract Other Features Monthly Cost Annualized Cost B&W Color Average Volumes McGrath Office Equipment Admin-1 Savin IMC6000 12,800 5,400 322.80$ B/W - $0.0072/pg. Color - $0.055/pg.includes hole punch, staple & fax $ 711.96 $ 8,543.52 Police-1 Savin IMC6000 5,400 1,500 322.80 B/W - $0.0072/pg. Color - $0.055/pg.includes hole punch, staple & fax 444.18 $ 5,330.16 Police-2 Savin IM3500 3,800 - 158.00 B/W - $0.0072/pg. Color - $0.055/pg. includes staple & fax 185.36 2,224.32 Comm Dvlp-1 Savin IMC6000 3,300 3,700 322.80 B/W - $0.0072/pg. Color - $0.055/pg.includes hole punch, staple & fax 550.06 6,600.72 Public Works Savin IM3000 850 300 180.66 B/W - $0.0072/pg. Color - $0.055/pg. includes staple & fax 203.28 2,439.36 Recreation Savin IMC6000 5,300 6,100 309.00 B/W - $0.0072/pg. Color - $0.055/pg.includes hole punch, staple & fax 682.66 8,191.92 31,450 17,000 36-Month Subtotal $ 2,777.50 $ 33,330.00 ProvenIT Admin-1 Toshiba 5015 12,800 5,400 227.80$ B/W - $0.00464/pg. Color - $0.0393/pg. includes hole punch, staple & fax $ 499.41 $ 5,992.94 Police-1 Toshiba 5015 5,400 1,500 227.80 B/W - $0.00464/pg. Color - $0.0393/pg. includes hole punch, staple & fax 311.81 3,741.67 Police-2 Toshiba 5015 3,800 - 137.94 B/W - $0.00464/pg. includes staple & fax 155.57 1,866.86 Comm Dvlp-1 Toshiba 5015 3,300 3,700 227.80 B/W - $0.00464/pg. Color - $0.0393/pg. includes hole punch, staple & fax 388.52 4,662.26 Public Works Toshiba 5015 850 300 175.13 B/W - $0.00464/pg. Color - $0.0393/pg.includes staple & fax 190.86 2,290.37 Recreation Toshiba 5015 5,300 6,100 227.80 B/W - $0.00464/pg. Color - $0.0393/pg. includes hole punch, staple & fax 492.12 5,905.46 31,450 17,000 36-Month Subtotal $ 2,038.30 $ 24,459.58 4 Make/Model 36 - Month Lease 36 - Month Maint Contract Other Features Monthly Cost Annualized Cost B&W Color Average Volumes RK Dixon Admin-1 Xerox AltaLink C8155 12,800 5,400 154.46$ B/W - $0.0054/pg. Color - $0.0360/pg. includes hole punch, staple & fax $ 417.98 $ 5,015.76 Police-1 Xerox AltaLink C8155 5,400 1,500 154.46 B/W - $0.0054/pg. Color - $0.0360/pg. includes hole punch, staple & fax 237.62 2,851.44 Police-2 Xerox AltaLink B7030 3,800 - 64.99 B/W - $0.0054/pg. Color - $0.0360/pg.includes staple & fax 85.51 1,026.12 Comm Dvlp-1 Xerox AltaLink C8155 3,300 3,700 154.46 B/W - $0.0054/pg. Color - $0.0360/pg. includes hole punch, staple & fax 305.48 3,665.76 Public Works Xerox AltaLink C8130 850 300 146.82 B/W - $0.0054/pg. Color - $0.0360/pg.includes staple & fax 162.21 1,946.52 Recreation Xerox AltaLink C8155 5,300 6,100 154.46 B/W - $0.0054/pg. Color - $0.0360/pg. includes hole punch, staple & fax 402.68 4,832.16 31,450 17,000 36-Month Subtotal $ 1,611.48 $ 19,337.76 Toshiba Business Solutions Admin-1 Toshiba e-Studio 5015AC 12,800 5,400 208.86$ B/W - $0.0045/pg. Color - $0.034/pg.includes hole punch, staple & fax $ 450.06 $ 5,400.72 Police-1 Toshiba e-Studio 5015AC 5,400 1,500 208.86 B/W - $0.0045/pg. Color - $0.034/pg. includes hole punch, staple & fax 284.16 3,409.92 Police-2 Toshiba e-Studio 3018A 3,800 - 92.66 B/W - $0.0045/pg. includes staple & fax 109.76 1,317.12 Comm Dvlp-1 Toshiba e-Studio 5015AC 3,300 3,700 208.86 B/W - $0.0045/pg. Color - $0.034/pg.includes hole punch, staple & fax 349.51 4,194.12 Public Works Toshiba e-Studio 3015AC 850 300 125.75 B/W - $0.0045/pg. Color - $0.034/pg. includes staple & fax 139.78 1,677.30 Recreation Toshiba e-Studio 5015AC 5,300 6,100 208.86 B/W - $0.0045/pg. Color - $0.034/pg.includes hole punch, staple & fax 440.11 5,281.32 31,450 17,000 36-Month Subtotal $ 1,773.38 $ 21,280.50 5 Make/Model 36 - Month Lease 36 - Month Maint Contract Other Features Monthly Cost Annualized Cost B&W Color Average Volumes Xerox Business Solutions Admin-1 Xerox C8155 12,800 5,400 237.84$ B/W - $0.004/pg. Color - $0.04/pg.includes hole punch, staple & fax $ 505.04 $ 6,060.48 Police-1 Xerox C8155 5,400 1,500 237.84 B/W - $0.004/pg. Color - $0.04/pg.includes hole punch, staple & fax 319.44 3,833.28 Police-2 Xerox B8155 3,800 - 192.77 B/W - $0.004/pg. Color - $0.04/pg. includes staple & fax 207.97 2,495.64 Comm Dvlp-1 Xerox C8155 3,300 3,700 237.84 B/W - $0.004/pg. Color - $0.04/pg.includes hole punch, staple & fax 399.04 4,788.48 Public Works Xerox C8135 850 300 173.29 B/W - $0.004/pg. Color - $0.04/pg. includes staple & fax 188.69 2,264.28 Recreation Xerox C8155 5,300 6,100 237.84 B/W - $0.004/pg. Color - $0.04/pg.includes hole punch, staple & fax 503.04 6,036.48 31,450 17,000 36-Month Subtotal $ 2,123.22 $ 25,478.64 6 Monthly Cost Annualized Cost RK Dixon 1,471.38$ 17,656.56$ Marco 1,473.34 17,680.02 CDS Office Technology 1,522.46 18,269.52 Toshiba Business Solutions 1,570.72 18,848.58 Proven IT 1,805.58 21,666.94 Impact Networking 1,819.98 21,839.70 Xerox Business Solutions 1,901.66 22,819.92 Konica Minolta 2,035.92 24,430.98 McGrath Office Equipment 2,445.75 29,349.00 48 - Month Lease Term Existing Copiers (6) 7 Make/Model 48 - Month Lease 48 - Month Maint Contract Other Features Monthly Cost Annualized Cost B&W Color CDS Office Technologies Admin-1 Sharp MX-5051 12,800 5,400 169.37$ B/W - $0.004/pg. Color - $0.03/pg.includes hole punch, staple & fax $ 382.57 $ 4,590.84 Police-1 Sharp MX-5051 5,400 1,500 169.37 B/W - $0.004/pg. Color - $0.03/pg.includes hole punch, staple & fax 235.97 2,831.64 Police-2 Sharp MX-M3051 3,800 - 97.99 B/W - $0.004/pg. includes staple & fax 113.19 1,358.28 Comm Dvlp-1 Sharp MX-5051 3,300 3,700 169.37 B/W - $0.004/pg. Color - $0.03/pg.includes hole punch, staple & fax 293.57 3,522.84 Public Works Sharp MX-3051 850 300 111.19 B/W - $0.004/pg. Color - $0.03/pg. includes staple & fax 123.59 1,483.08 Recreation Sharp MX-5051 5,300 6,100 169.37 B/W - $0.004/pg. Color - $0.03/pg.includes hole punch, staple & fax 373.57 4,482.84 31,450 17,000 48-Month Subtotal $ 1,522.46 $ 18,269.52 Impact (Current Provider) Admin-1 TASKalfa 5053cici 12,800 5,400 178.04$ B/W - $0.0065/pg. Color - $0.035/pg.includes hole punch, staple & fax $ 450.24 $ 5,402.88 Police-1 TASKalfa 5053cici 5,400 1,500 178.04 B/W - $0.0065/pg. Color - $0.035/pg.includes hole punch, staple & fax 265.64 3,187.68 Police-2 TASKalfa 4003i 3,800 - 136.65 B/W - $0.0065/pg. includes staple & fax 161.35 1,936.20 Comm Dvlp-1 TASKalfa 5053cici 3,300 3,700 178.04 B/W - $0.0065/pg. Color - $0.035/pg.includes hole punch, staple & fax 328.99 3,947.88 Public Works TASKalfa 5053cici 850 300 171.74 B/W - $0.0065/pg. Color - $0.035/pg. includes staple & fax 187.77 2,253.18 Recreation TASKalfa 5053cici 5,300 6,100 178.04 B/W - $0.0065/pg. Color - $0.035/pg.includes hole punch, staple & fax 425.99 5,111.88 31,450 17,000 48-Month Subtotal $ 1,819.98 $ 21,839.70 Average Volumes 8 Make/Model 48 - Month Lease 48 - Month Maint Contract Other Features Monthly Cost Annualized Cost B&W Color Average Volumes Konica Minolta Admin-1 BizHub C5501 12,800 5,400 238.54$ B/W - $0.0039/pg. Color - $0.04/pg.includes hole punch, staple & fax $ 504.46 $ 6,053.52 Police-1 BizHub C5501 5,400 1,500 238.54 B/W - $0.0039/pg. Color - $0.04/pg.includes hole punch, staple & fax 319.60 3,835.20 Police-2 BizHub C3001 3,800 - 139.55 B/W - $0.0065/pg. includes staple & fax 154.37 1,852.44 Comm Dvlp-1 BizHub C5501 3,300 3,700 238.54 B/W - $0.0039/pg. Color - $0.04/pg.includes hole punch, staple & fax 399.41 4,792.92 Public Works BizHub C3001 850 300 139.55 B/W - $0.0065/pg. includes staple & fax 154.87 1,858.38 Recreation BizHub C5501 5,300 6,100 238.54 B/W - $0.0039/pg. Color - $0.04/pg.includes hole punch, staple & fax 503.21 6,038.52 31,450 17,000 48-Month Subtotal $ 2,035.92 $ 24,430.98 Marco Admin-1 Sharp MX 5071 12,800 5,400 142.87$ B/W - $0.0035/pg. Color - $0.035/pg.includes hole punch, staple & fax $ 376.67 $ 4,520.04 Police-1 Sharp MX 5071 5,400 1,500 142.87 B/W - $0.0035/pg. Color - $0.035/pg.includes hole punch, staple & fax 214.27 2,571.24 Police-2 Sharp MX M3071 3,800 - 88.94 B/W - $0.0035/pg. Color - $0.035/pg. includes staple & fax 102.24 1,226.88 Comm Dvlp-1 Sharp MX 5071 3,300 3,700 142.87 B/W - $0.0035/pg. Color - $0.035/pg.includes hole punch, staple & fax 283.92 3,407.04 Public Works Sharp MX 3071 850 300 107.84 B/W - $0.0035/pg. Color - $0.035/pg. includes staple & fax 121.32 1,455.78 Recreation Sharp MX 5071 5,300 6,100 142.87 B/W - $0.0035/pg. Color - $0.035/pg.includes hole punch, staple & fax 374.92 4,499.04 31,450 17,000 48-Month Subtotal $ 1,473.34 $ 17,680.02 9 Make/Model 48 - Month Lease 48 - Month Maint Contract Other Features Monthly Cost Annualized Cost B&W Color Average Volumes McGrath Office Equipment Admin-1 Savin IMC6000 12,800 5,400 257.33$ B/W - $0.0072/pg. Color - $0.055/pg.includes hole punch, staple & fax $ 646.49 $ 7,757.88 Police-1 Savin IMC6000 5,400 1,500 257.33 B/W - $0.0072/pg. Color - $0.055/pg.includes hole punch, staple & fax 378.71 4,544.52 Police-2 Savin IM3500 3,800 - 126.00 B/W - $0.0072/pg. Color - $0.055/pg. includes staple & fax 153.36 1,840.32 Comm Dvlp-1 Savin IMC6000 3,300 3,700 257.33 B/W - $0.0072/pg. Color - $0.055/pg.includes hole punch, staple & fax 484.59 5,815.08 Public Works Savin IM3000 850 300 140.01 B/W - $0.0072/pg. Color - $0.055/pg. includes staple & fax 162.63 1,951.56 Recreation Savin IMC6000 5,300 6,100 246.31 B/W - $0.0072/pg. Color - $0.055/pg.includes hole punch, staple & fax 619.97 7,439.64 31,450 17,000 48-Month Subtotal $ 2,445.75 $ 29,349.00 ProvenIT Admin-1 Toshiba 5015 12,800 5,400 184.68$ B/W - $0.00464/pg. Color - $0.0393/pg. includes hole punch, staple & fax $ 456.29 $ 5,475.50 Police-1 Toshiba 5015 5,400 1,500 184.68 B/W - $0.00464/pg. Color - $0.0393/pg. includes hole punch, staple & fax 268.69 3,224.23 Police-2 Toshiba 5015 3,800 - 111.83 B/W - $0.00464/pg. includes staple & fax 129.46 1,553.54 Comm Dvlp-1 Toshiba 5015 3,300 3,700 184.68 B/W - $0.00464/pg. Color - $0.0393/pg. includes hole punch, staple & fax 345.40 4,144.82 Public Works Toshiba 5015 850 300 141.00 B/W - $0.00464/pg. Color - $0.0393/pg.includes staple & fax 156.73 1,880.81 Recreation Toshiba 5015 5,300 6,100 184.68 B/W - $0.00464/pg. Color - $0.0393/pg. includes hole punch, staple & fax 449.00 5,388.02 31,450 17,000 48-Month Subtotal $ 1,805.58 $ 21,666.94 10 Make/Model 48 - Month Lease 48 - Month Maint Contract Other Features Monthly Cost Annualized Cost B&W Color Average Volumes RK Dixon Admin-1 Xerox AltaLink C8155 12,800 5,400 128.49$ B/W - $0.0054/pg. Color - $0.0360/pg. includes hole punch, staple & fax $ 392.01 $ 4,704.12 Police-1 Xerox AltaLink C8155 5,400 1,500 128.49 B/W - $0.0054/pg. Color - $0.0360/pg. includes hole punch, staple & fax 211.65 2,539.80 Police-2 Xerox AltaLink B7030 3,800 - 54.07 B/W - $0.0054/pg. Color - $0.0360/pg.includes staple & fax 74.59 895.08 Comm Dvlp-1 Xerox AltaLink C8155 3,300 3,700 128.49 B/W - $0.0054/pg. Color - $0.0360/pg. includes hole punch, staple & fax 279.51 3,354.12 Public Works Xerox AltaLink C8130 850 300 121.52 B/W - $0.0054/pg. Color - $0.0360/pg.includes staple & fax 136.91 1,642.92 Recreation Xerox AltaLink C8155 5,300 6,100 128.49 B/W - $0.0054/pg. Color - $0.0360/pg. includes hole punch, staple & fax 376.71 4,520.52 31,450 17,000 48-Month Subtotal $ 1,471.38 $ 17,656.56 Toshiba Business Solutions Admin-1 Toshiba e-Studio 5015AC 12,800 5,400 168.69$ B/W - $0.0045/pg. Color - $0.034/pg.includes hole punch, staple & fax $ 409.89 $ 4,918.68 Police-1 Toshiba e-Studio 5015AC 5,400 1,500 168.69 B/W - $0.0045/pg. Color - $0.034/pg.includes hole punch, staple & fax 243.99 2,927.88 Police-2 Toshiba e-Studio 3018A 3,800 - 74.85 B/W - $0.0045/pg. includes staple & fax 91.95 1,103.40 Comm Dvlp-1 Toshiba e-Studio 5015AC 3,300 3,700 168.69 B/W - $0.0045/pg. Color - $0.034/pg.includes hole punch, staple & fax 309.34 3,712.08 Public Works Toshiba e-Studio 3015AC 850 300 101.58 B/W - $0.0045/pg. Color - $0.034/pg. includes staple & fax 115.61 1,387.26 Recreation Toshiba e-Studio 5015AC 5,300 6,100 168.69 B/W - $0.0045/pg. Color - $0.034/pg.includes hole punch, staple & fax 399.94 4,799.28 31,450 17,000 48-Month Subtotal $ 1,570.72 $ 18,848.58 11 Make/Model 48 - Month Lease 48 - Month Maint Contract Other Features Monthly Cost Annualized Cost B&W Color Average Volumes Xerox Business Solutions Admin-1 Xerox C8155 12,800 5,400 197.84$ B/W - $0.004/pg. Color - $0.04/pg.includes hole punch, staple & fax $ 465.04 $ 5,580.48 Police-1 Xerox C8155 5,400 1,500 197.84 B/W - $0.004/pg. Color - $0.04/pg.includes hole punch, staple & fax 279.44 3,353.28 Police-2 Xerox B8155 3,800 - 160.35 B/W - $0.004/pg. Color - $0.04/pg. includes staple & fax 175.55 2,106.60 Comm Dvlp-1 Xerox C8155 3,300 3,700 197.84 B/W - $0.004/pg. Color - $0.04/pg.includes hole punch, staple & fax 359.04 4,308.48 Public Works Xerox C8135 850 300 144.15 B/W - $0.004/pg. Color - $0.04/pg. includes staple & fax 159.55 1,914.60 Recreation Xerox C8155 5,300 6,100 197.84 B/W - $0.004/pg. Color - $0.04/pg.includes hole punch, staple & fax 463.04 5,556.48 31,450 17,000 48-Month Subtotal $ 1,901.66 $ 22,819.92 12 Monthly Cost Annualized Cost Marco 1,322.24$ 15,866.82$ RK Dixon 1,322.77 15,873.24 CDS Office Technology 1,372.18 16,466.16 Toshiba Business Solutions 1,420.13 17,041.50 Impact Networking 1,638.88 19,666.50 Proven IT 1,647.94 19,775.26 Xerox Business Solutions 1,665.48 19,985.76 Konica Minolta 1,826.52 21,918.18 McGrath Office Equipment 2,197.39 26,368.68 Existing Copiers (6) 60 - Month Lease Term 13 Make/Model 60 - Month Lease 60 - Month Maint Contract Other Features Monthly Cost Annualized Cost B&W Color CDS Office Technologies Admin-1 Sharp MX-5051 12,800 5,400 140.82$ B/W - $0.004/pg. Color - $0.03/pg.includes hole punch, staple & fax $ 354.02 $ 4,248.24 Police-1 Sharp MX-5051 5,400 1,500 140.82 B/W - $0.004/pg. Color - $0.03/pg.includes hole punch, staple & fax 207.42 2,489.04 Police-2 Sharp MX-M3051 3,800 - 81.48 B/W - $0.004/pg. includes staple & fax 96.68 1,160.16 Comm Dvlp-1 Sharp MX-5051 3,300 3,700 140.82 B/W - $0.004/pg. Color - $0.03/pg.includes hole punch, staple & fax 265.02 3,180.24 Public Works Sharp MX-3051 850 300 91.62 B/W - $0.004/pg. Color - $0.03/pg. includes staple & fax 104.02 1,248.24 Recreation Sharp MX-5051 5,300 6,100 140.82 B/W - $0.004/pg. Color - $0.03/pg.includes hole punch, staple & fax 345.02 4,140.24 31,450 17,000 60-Month Subtotal $ 1,372.18 $ 16,466.16 Impact (Current Provider) Admin-1 TASKalfa 5053cici 12,800 5,400 146.45$ B/W - $0.0065/pg. Color - $0.035/pg.includes hole punch, staple & fax $ 418.65 $ 5,023.80 Police-1 TASKalfa 5053cici 5,400 1,500 146.45 B/W - $0.0065/pg. Color - $0.035/pg.includes hole punch, staple & fax 234.05 2,808.60 Police-2 TASKalfa 4003i 3,800 - 112.31 B/W - $0.0065/pg. includes staple & fax 137.01 1,644.12 Comm Dvlp-1 TASKalfa 5053cici 3,300 3,700 146.45 B/W - $0.0065/pg. Color - $0.035/pg.includes hole punch, staple & fax 297.40 3,568.80 Public Works TASKalfa 5053cici 850 300 141.34 B/W - $0.0065/pg. Color - $0.035/pg. includes staple & fax 157.37 1,888.38 Recreation TASKalfa 5053cici 5,300 6,100 146.45 B/W - $0.0065/pg. Color - $0.035/pg.includes hole punch, staple & fax 394.40 4,732.80 31,450 17,000 60-Month Subtotal $ 1,638.88 $ 19,666.50 Average Volumes 14 Make/Model 60 - Month Lease 60 - Month Maint Contract Other Features Monthly Cost Annualized Cost B&W Color Average Volumes Konica Minolta Admin-1 BizHub C5501 12,800 5,400 198.93$ B/W - $0.0039/pg. Color - $0.04/pg.includes hole punch, staple & fax $ 464.85 $ 5,578.20 Police-1 BizHub C5501 5,400 1,500 198.93 B/W - $0.0039/pg. Color - $0.04/pg.includes hole punch, staple & fax 279.99 3,359.88 Police-2 BizHub C3001 3,800 - 114.07 B/W - $0.0065/pg. includes staple & fax 128.89 1,546.68 Comm Dvlp-1 BizHub C5501 3,300 3,700 198.93 B/W - $0.0039/pg. Color - $0.04/pg.includes hole punch, staple & fax 359.80 4,317.60 Public Works BizHub C3001 850 300 114.07 B/W - $0.0065/pg. includes staple & fax 129.39 1,552.62 Recreation BizHub C5501 5,300 6,100 198.93 B/W - $0.0039/pg. Color - $0.04/pg.includes hole punch, staple & fax 463.60 5,563.20 31,450 17,000 60-Month Subtotal $ 1,826.52 $ 21,918.18 Marco Admin-1 Sharp MX 5071 12,800 5,400 114.77$ B/W - $0.0035/pg. Color - $0.035/pg.includes hole punch, staple & fax $ 348.57 $ 4,182.84 Police-1 Sharp MX 5071 5,400 1,500 114.77 B/W - $0.0035/pg. Color - $0.035/pg.includes hole punch, staple & fax 186.17 2,234.04 Police-2 Sharp MX M3071 3,800 - 71.45 B/W - $0.0035/pg. Color - $0.035/pg. includes staple & fax 84.75 1,017.00 Comm Dvlp-1 Sharp MX 5071 3,300 3,700 114.77 B/W - $0.0035/pg. Color - $0.035/pg.includes hole punch, staple & fax 255.82 3,069.84 Public Works Sharp MX 3071 850 300 86.63 B/W - $0.0035/pg. Color - $0.035/pg. includes staple & fax 100.11 1,201.26 Recreation Sharp MX 5071 5,300 6,100 114.77 B/W - $0.0035/pg. Color - $0.035/pg.includes hole punch, staple & fax 346.82 4,161.84 31,450 17,000 60-Month Subtotal $ 1,322.24 $ 15,866.82 15 Make/Model 60 - Month Lease 60 - Month Maint Contract Other Features Monthly Cost Annualized Cost B&W Color Average Volumes McGrath Office Equipment Admin-1 Savin IMC6000 12,800 5,400 206.98$ B/W - $0.0072/pg. Color - $0.055/pg.includes hole punch, staple & fax $ 596.14 $ 7,153.68 Police-1 Savin IMC6000 5,400 1,500 206.98 B/W - $0.0072/pg. Color - $0.055/pg.includes hole punch, staple & fax 328.36 3,940.32 Police-2 Savin IM3500 3,800 - 101.00 B/W - $0.0072/pg. Color - $0.055/pg. includes staple & fax 128.36 1,540.32 Comm Dvlp-1 Savin IMC6000 3,300 3,700 206.98 B/W - $0.0072/pg. Color - $0.055/pg.includes hole punch, staple & fax 434.24 5,210.88 Public Works Savin IM3000 850 300 115.81 B/W - $0.0072/pg. Color - $0.055/pg. includes staple & fax 138.43 1,661.16 Recreation Savin IMC6000 5,300 6,100 198.20 B/W - $0.0072/pg. Color - $0.055/pg.includes hole punch, staple & fax 571.86 6,862.32 31,450 17,000 60-Month Subtotal $ 2,197.39 $ 26,368.68 ProvenIT Admin-1 Toshiba 5015 12,800 5,400 154.30$ B/W - $0.00464/pg. Color - $0.0393/pg. includes hole punch, staple & fax $ 425.91 $ 5,110.94 Police-1 Toshiba 5015 5,400 1,500 154.30 B/W - $0.00464/pg. Color - $0.0393/pg. includes hole punch, staple & fax 238.31 2,859.67 Police-2 Toshiba 5015 3,800 - 98.09 B/W - $0.00464/pg. includes staple & fax 115.72 1,388.66 Comm Dvlp-1 Toshiba 5015 3,300 3,700 154.30 B/W - $0.00464/pg. Color - $0.0393/pg. includes hole punch, staple & fax 315.02 3,780.26 Public Works Toshiba 5015 850 300 118.62 B/W - $0.00464/pg. Color - $0.0393/pg.includes staple & fax 134.35 1,612.25 Recreation Toshiba 5015 5,300 6,100 154.30 B/W - $0.00464/pg. Color - $0.0393/pg. includes hole punch, staple & fax 418.62 5,023.46 31,450 17,000 60-Month Subtotal $ 1,647.94 $ 19,775.26 16 Make/Model 60 - Month Lease 60 - Month Maint Contract Other Features Monthly Cost Annualized Cost B&W Color Average Volumes RK Dixon Admin-1 Xerox AltaLink C8155 12,800 5,400 100.80$ B/W - $0.0054/pg. Color - $0.0360/pg. includes hole punch, staple & fax $ 364.32 $ 4,371.84 Police-1 Xerox AltaLink C8155 5,400 1,500 100.80 B/W - $0.0054/pg. Color - $0.0360/pg. includes hole punch, staple & fax 183.96 2,207.52 Police-2 Xerox AltaLink B7030 3,800 - 42.41 B/W - $0.0054/pg. Color - $0.0360/pg.includes staple & fax 62.93 755.16 Comm Dvlp-1 Xerox AltaLink C8155 3,300 3,700 100.80 B/W - $0.0054/pg. Color - $0.0360/pg. includes hole punch, staple & fax 251.82 3,021.84 Public Works Xerox AltaLink C8130 850 300 95.33 B/W - $0.0054/pg. Color - $0.0360/pg.includes staple & fax 110.72 1,328.64 Recreation Xerox AltaLink C8155 5,300 6,100 100.80 B/W - $0.0054/pg. Color - $0.0360/pg. includes hole punch, staple & fax 349.02 4,188.24 31,450 17,000 60-Month Subtotal $ 1,322.77 $ 15,873.24 Toshiba Business Solutions Admin-1 Toshiba e-Studio 5015AC 12,800 5,400 138.84$ B/W - $0.0045/pg. Color - $0.034/pg.includes hole punch, staple & fax $ 380.04 $ 4,560.48 Police-1 Toshiba e-Studio 5015AC 5,400 1,500 138.84 B/W - $0.0045/pg. Color - $0.034/pg. includes hole punch, staple & fax 214.14 2,569.68 Police-2 Toshiba e-Studio 3018A 3,800 - 61.60 B/W - $0.0045/pg. includes staple & fax 78.70 944.40 Comm Dvlp-1 Toshiba e-Studio 5015AC 3,300 3,700 138.84 B/W - $0.0045/pg. Color - $0.034/pg.includes hole punch, staple & fax 279.49 3,353.88 Public Works Toshiba e-Studio 3015AC 850 300 83.64 B/W - $0.0045/pg. Color - $0.034/pg. includes staple & fax 97.67 1,171.98 Recreation Toshiba e-Studio 5015AC 5,300 6,100 138.84 B/W - $0.0045/pg. Color - $0.034/pg.includes hole punch, staple & fax 370.09 4,441.08 31,450 17,000 60-Month Subtotal $ 1,420.13 $ 17,041.50 17 Make/Model 60 - Month Lease 60 - Month Maint Contract Other Features Monthly Cost Annualized Cost B&W Color Average Volumes Xerox Business Solutions Admin-1 Xerox C8155 12,800 5,400 155.20$ B/W - $0.004/pg. Color - $0.04/pg.includes hole punch, staple & fax $ 422.40 $ 5,068.80 Police-1 Xerox C8155 5,400 1,500 155.20 B/W - $0.004/pg. Color - $0.04/pg.includes hole punch, staple & fax 236.80 2,841.60 Police-2 Xerox B8155 3,800 - 125.79 B/W - $0.004/pg. Color - $0.04/pg. includes staple & fax 140.99 1,691.88 Comm Dvlp-1 Xerox C8155 3,300 3,700 155.20 B/W - $0.004/pg. Color - $0.04/pg.includes hole punch, staple & fax 316.40 3,796.80 Public Works Xerox C8135 850 300 113.09 B/W - $0.004/pg. Color - $0.04/pg. includes staple & fax 128.49 1,541.88 Recreation Xerox C8155 5,300 6,100 155.20 B/W - $0.004/pg. Color - $0.04/pg.includes hole punch, staple & fax 420.40 5,044.80 31,450 17,000 60-Month Subtotal $ 1,665.48 $ 19,985.76 18 Have a question or comment about this agenda item? Call us Monday-Friday, 8:00am to 4:30pm at 630-553-4350, email us at agendas@yorkville.il.us, post at www.facebook.com/CityofYorkville, tweet us at @CityofYorkville, and/or contact any of your elected officials at http://www.yorkville.il.us/320/City-Council Agenda Item Summary Memo Title: Meeting and Date: Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Agenda Item Notes: Reviewed By: Legal Finance Engineer City Administrator Human Resources Community Development Police Public Works Parks and Recreation Agenda Item Number Administration Committee #2 Tracking Number ADM 2021-37 Tax Levy Estimate City Council – October 12, 2021 N/A Majority Approval Please see attached memo. Rob Fredrickson Finance Name Department Summary Approval of a 2021 tax levy estimate, for purposes of publishing a public notice for an upcoming public hearing. Background Each year, the first step of the tax levy process involves adopting a tax levy estimate for purposes of holding a public hearing (if required). The estimated tax levy for the City and Library operations (capped taxes or PTELL) is $4,489,852, as shown on Exhibit A. The City’s levy request totals $3,554,858 and includes increment generated from an augmented new construction only amount of $22,219,396. The Library operations levy is set at the max rate of $0.15 per $100 of EAV; however, due to the property tax extension limitation law (PTELL), staff would expect the actual Library levy to be lower. 2017 Tax Levy (FY 19) thru 2020 Tax Levy (FY 22 - current fiscal year) Beginning with the 2017 levy process, the City Council began to ease back into its past practice of marginally increasing the levy each year as allowed under PTELL. Pursuant to PTELL, two factors determine how much the City, as a non-home rule municipality, can increase its levy by each year: the equalized assessed valuation (EAV) of new construction and the year-over-year change in inflation (as measured by the Consumer Price Index or CPI). For the 2018 (collected in FY 20) and 2019 (collected in FY 21 – last fiscal year) levies the City Council chose to increase the levy by new construction only, thus foregoing the inflationary increment. For the 2020 levy year (currently being collected in FY 22) City Council decided to continue this practice, once again increasing the levy by estimated new construction ($88,383) only; and again, forfeiting the inflationary increment of $76,771. As a result, most residents over the last four levy cycles should have seen the City portion of their property tax bill stay relatively the same or even decrease slightly, assuming that the change in EAV of their homes was less than the overall increase in EAV for all taxable property in the City. 2021 Tax Levy (FY 23 – next fiscal year) For this year’s levy new construction EAV is currently estimated by Kendall County at $20,219,396, which would generate additional property tax proceeds of $116,484 for the City. As shown on Exhibit E, after two consecutive years of low inflation (levy years 2015-2016), CPI returned to more of a historical norm in 2017 of 2.1%. After holding right around 2.0% in levy years 2018 through 2020, CPI for 2021 has fallen by ~40%, to 1.4%. This inflationary portion of the levy equates to a projected increment of Memorandum To: City Council From: Rob Fredrickson, Finance Director Date: October 5, 2021 Subject: 2021 Tax Levy Estimate $47,970, for an estimated grand total of $164,454 in additional property taxes that could be levied under PTELL. Based on the information presented above, it is the recommendation of staff that the City increase its levy only by the amount of incremental property taxes generated from new construction, which is currently estimated at $116,484 (as shown on Exhibit C). While this will result in the City not levying approximately $47,970 (CPI portion) under PTELL (which means this amount is lost for subsequent levy years), staff believes that this is a balanced approach as it allows the City to marginally expand its tax base with minimal impact on homeowners. Depending on how the City Council decides to levy, either including incremental property taxes from both CPI and new construction (Exhibit B) or new construction only (Exhibit C), will result in the City’s portion of the levy either increasing by approximately 4.8% (Exhibit B) or 3.4% (Exhibit C). For the 2021 levy year the City’s contribution (i.e., actuarially determined funding policy contribution) to the Yorkville Police Pension Fund is $1,320,595 (Exhibit G – page 1), as calculated by the City’s actuary, MWM Consulting Group. This amount is calculated based on the assumption of a 100% funding level by the year 2040, pursuant to the City’s pension funding policy. This amount is a decrease of $14,176 (1.1%) in comparison to the 2020 contribution amount of $1,334,771. The main driver behind the decrease in the City’s pension contribution is the result of superior investment performance, as Pension Fund assets yielded a 28% return in FY 21 (Exhibit G – page 4), which is four times higher than the actuarial assumed rate of 7%. After declining significantly with the onset of the COVID-19 pandemic in March of 2020, equity markets came roaring back for the duration of FY 21. The Police Pension Fund, with approximately 65% of its portfolio invested in equities, was able to capitalize on these returns generating a money-weighted return of 43.8% (net); although this was tempered by the fixed income side of the portfolio, which finished at essentially break-even due to the low interest rate environment which permeated throughout the previous fiscal year. The current funding level of the Police Pension Fund is 58.2% (as calculated by dividing the market value of assets of $14,576,330 by the accrued liability of $25,026,357), which is significantly up from the FYE 20 funding level of 46.2%. Despite the strong returns experienced by the Fund over the course of FY 21, the City should expect its pension contribution to likely increase in subsequent levy years due to several factors including:  A shrinking amortization period (i.e., as we get closer to the year 2040, there is less time to spread out the remaining costs associated with the unfunded liability).  Normal costs continue to increase, as each year of additional service by current employees generates additional pension benefits.  Changes in actuarial assumptions pertaining to mortality, retirement and termination rates. Based on the above considerations, staff recommends holding the City’s pension contribution amount steady at the 2020 level of $1,334,771 for the current year’s levy, as reflected on Exhibits A thru D. Looking back at the last five levy cycles, you may recall that a reoccurring policy question has been whether the City and Library levies should be combined or levied separately. In an effort to “level the playing field” by applying the same rules of property tax growth (lesser of CPI or 5%, plus new construction) to both entities, the City Council has chosen to levy the two entities separately since in 2016. Last year the Library Operations tax rate was capped at $0.133 per $100 of EAV, resulting in a property tax extension of $776,734. This was an increase of $37,650 (5.1%) over the 2019 extended amount of $739,084. For the 2021 levy staff recommends that Council continue with the practice of levying separately for the City and the Library, which is currently estimated to yield property taxes for library operations in the amount of $814,015. This amount includes both CPI ($10,874) and new construction ($26,407) increments. Based on current EAV the library operations tax rate is estimated to be at $0.131 per $100 of EAV (max amount is $0.15 per $100 EAV) for the 2021 levy year, which is an increase of 4.8% ($37,281) over the 2020 extension. The levy amount for the Library will be formally approved by the Board at their upcoming October or November meetings. In addition, the FY 22 (2020 levy) certifications from the Kendall County Clerk are attached as Exhibit F. The first page contains all City (non-Library) taxes, and the second page contains Library taxes (operations and debt service for the 2006 & 2013 refunding bonds). As usual, all City debt service amounts are expected to be fully abated for the 2021 levy year. Materials regarding the City’s bond abatements will be presented at a future Administration Committee meeting, before being presented to the City Council for approval in either November or December. Homeowner Impact The property tax bill lists the City and the Library as two distinct itemized charges. Assuming the City levies for the new construction increment only (Exhibit C), the City’s (capped and uncapped) estimated levy extension is projected to increase by 3.4% for the 2021 levy year (payable in 2022). The Library (capped and uncapped) levy is projected to be 2.7% higher than the 2020 levy year extension (payable in 2021). Overall EAV for the City is currently estimated at $623.3 million, which is a $40.6 million (7.0%) increase over the prior year amount of $582.7 million. However, half of this increase is attributable to new construction, which is currently estimated at $20.2 million. When adjusting for new construction, EAV of existing property increased by ~3.5%, which should be closer to the typical EAV increase that homeowners experience in the upcoming levy year. Based on the above statements, the amount that each property owner pays to the City and the Library should be approximately the same as the prior year’s tax bill, assuming that their individual property’s EAV increases at a rate similar to overall EAV, adjusted for new construction. Recommendation The preliminary staff recommendations for aggregate levy amounts are below. City Tax Levy 2020 Levy Extension 2021 Maximum Levy (Estimate) 2021 Levy Estimate Recommended Amount City Levy (Capped) $3,426,430 $3,590,884 $3,554,858 City Bonds (Uncapped) N / A N / A N / A Totals $3,426,430 $3,590,884 $3,554,858 Library Tax Levy 2020 Levy Extension 2021 Maximum Levy (Estimate) 2021 Levy Estimate Recommended Amount Library Operations (Capped) $776,734 $934,994 $934,994 Library Bonds (Uncapped) 840,248 847,313 847,313 Totals $1,616,983 $1,782,307 $1,782,307 In regard to the setting of a tax levy estimate, staff recommends the approval of Exhibit A, which shows the City’s levy increasing by an augmented new construction only amount and sets the Library’s levy at their ceiling rate of $0.15 per $100 of EAV, for the purposes of setting a maximum levy amount for the public hearing. In order to capture every dollar possible generated from the new construction increment, staff has increased the County’s current new construction EAV estimate ($20,219,396) by approximately 10% ($22,219,396); which would increase projected new construction incremental property tax amounts by $11,944, from $116,484 to $128,428. Since the estimated amount of new construction is likely to be updated by the County between now and December, this would allow Council maximum flexibility to adjust the levy accordingly to ensure that the entire new construction component of the levy could be utilized, if desired. As a reminder, the tax levy estimate sets the maximum amount that the City and Library could levy, with the understanding that Council and the Library Board reserve the right to levy less than that amount should they desire to do so. Exhibit B is an estimate of how much the City could levy under PTELL (includes increases for both new construction & CPI) for a total of $164,454 in additional property tax proceeds. Exhibit C shows the new construction increment only, for both the City ($116,484) and Library ($26,407); hence foregoing the CPI increments of $47,970 (City) and $10,874 (Library), respectively, in subsequent tax years. At last month’s Administration Committee, one of the committee members suggested the option of keeping the City’s 2021 levy equal to what was levied last year. This option has been quantified and is included in the packet materials as Exhibit D. Keeping the City’s levy “flat” with the prior year would yield property tax proceeds in the amount of $3,426,246 - which is equal to the total amount shown in the 2020 levy request column. This scenario would result in the General Fund (i.e., Corporate Levy) receiving nominally less ($172) property taxes in FY 23 then it will in the current budget year (FY 22). For the individual property owner, this should result in a ~$14 decrease in the City’s portion of their property tax bill, assuming the EAV of their individual property increased at a similar rate to overall EAV (3.5%), adjusted for new construction. In addition to the levy recommendation above, staff also recommends that the City instruct the County Clerk to levy separately once again for the City and the Library, so that both entities are held to the same rules when it comes to growth. A tentative timeline for the remainder of the 2021 tax levy process is presented below for your review and consideration:  October 12th & 26th (City Council) - Tax Levy Estimate review and approval o Tax Levy Estimate must be adopted 20 days prior to City Council approval of levy  November 9th (City Council) – Tax Levy Public Hearing o Public Hearing Notice will be published on November 1st o Per State Statute, the Public Hearing Notice must be published in a local paper between 14 and 7 days prior to the hearing  November 23rd or December 14th (City Council) - Approval of the Tax Levy Ordinance o Must be filed with Kendall County before the last Tuesday in December (December 28th) 2019 Rate Setting EAV % Change over Prior Yr EAV 2020 Rate Setting EAV % Change over Prior Yr EAV 2021 Estimated EAV % Change over Prior Yr EAV $ Change Farm 3,259,791$ 1.80%Farm 3,360,133$ 3.08%Farm 3,527,532$ 4.98%167,399$ Residential 450,745,939 8.15%Residential 484,024,398 7.38%Residential 520,988,654 7.64%36,964,256 Commercial 83,974,878 0.12%Commercial 79,649,698 -5.15%Commercial 83,183,473 4.44%3,533,775 Industrial 15,509,884 0.80%Industrial 15,586,411 0.49%Industrial 15,553,866 -0.21%(32,545) State Railroad 89,004 47.74%State Railroad 75,859 -14.77%State Railroad 75,859 0.00%- Total 553,579,496$ 6.60%Total 582,696,499$ 5.26%Total 623,329,384$ 6.97%40,632,885$ 2019 2019 2019 2020 2020 2020 2021 2021 % Change over $ Change over Rate Levy Request Levy Extension Rate Levy Request Levy Extension Rate Levy Request Prior Yr Ext.Prior Yr Ext. Corporate 0.18111 1,002,536$ 1,002,588$ 0.16937 986,912$ 986,913$ 0.15797 984,681$ -0.23%(2,232)$ Bonds & Interest 0.00000 - - 0.00000 - - 0.00000 - - - IMRF Pension 0.00000 - - 0.00000 - - 0.00000 - - - Police Protection 0.15618 864,563 864,580 0.14838 864,563 864,605 0.15969 995,406 15.13%130,801 Police Pension 0.22230 1,230,604 1,230,607 0.22907 1,334,771 1,334,783 0.21414 1,334,771 0.00%(12) Audit 0.00542 30,000 30,004 0.00515 30,000 30,009 0.00481 30,000 -0.03%(9) Liability Insurance 0.00723 40,000 40,024 0.00687 40,000 40,031 0.00642 40,000 -0.08%(31) Social Security 0.02710 150,000 150,020 0.02575 150,000 150,044 0.02406 150,000 -0.03%(44) School Crossing Guard 0.00362 20,000 20,040 0.00344 20,000 20,045 0.00321 20,000 (0.00) (45) Unemployment Insurance 0.00000 - - 0.00000 - - 0.00000 - - - Subtotal City 0.60296 3,337,703$ 3,337,863$ 0.58803 3,426,246$ 3,426,430$ 0.57030 3,554,858$ 3.75%128,428 Library Operations 0.13351 739,047$ 739,084$ 0.13330 875,782$ 776,734$ 0.15000 934,994$ 20.38%158,260$ Library Bonds & Interest 0.14941 827,088 827,103 0.14420 840,225 840,248 0.13593 847,313 0.84%7,065 Subtotal Library 0.28292 1,566,135$ 1,566,187$ 0.27750 1,716,007$ 1,616,983$ 0.28593 1,782,307$ 10.22%165,324 Total City (PTELL & Non-PTELL)0.88588 4,903,838$ 4,904,050$ 0.86553 5,142,253$ 5,043,413$ 0.85624 5,337,165$ 5.82%293,752$ less Bonds & Interest 0.14941 827,088 827,103 0.14420 840,225 840,248 0.13593 847,313 0.84%7,065 P-TELL Totals 0.73647 4,076,750$ 4,076,947$ 0.72133 4,302,028$ 4,203,165$ 0.72030 4,489,852$ 6.82%286,687$ 2021 Tax Levy - Public Hearing ** (Based on new construction EAV estimate of $22,219,396) ** (Limiting Rate Applied to City) 1 2021 % Change over $ Change over 2019 Requested 2019 Extended 2020 Requested 2020 Requested Levy Request Prior Yr Ext.Prior Yr Ext. City 2,107,099$ 2,107,256$ City 2,091,475$ 2,091,647$ City 2,220,087$ 6.14%128,440$ Library 739,047 739,084 Library 875,782 776,734 Library 934,994 20.38%158,260 Police Pension 1,230,604 1,230,607 Police Pension 1,334,771 1,334,783 Police Pension 1,334,771 0.00%(12) City Debt Service - - City Debt Service - - City Debt Service - - - Library Debt Service 827,088 827,103 Library Debt Service 840,225 840,248 Library Debt Service 847,313 0.84%7,065 Total 4,903,838$ 4,904,050$ Total 5,142,253$ 5,043,413$ Total 5,337,165$ 5.82%293,752$ less Bonds & Interest 827,088 827,103 less Bonds & Interest 840,225 840,248 less Bonds & Interest 847,313 0.84%7,065 PTELL Subtotal 4,076,750$ 4,076,947$ PTELL Subtotal 4,302,028$ 4,203,165$ PTELL Subtotal 4,489,852$ 6.82%286,687$ City (excluding Debt Service)3,337,703$ 3,337,863$ City (excluding Debt Service)3,426,246$ 3,426,430$ City (excluding Debt Service)3,554,858$ 3.75%128,428$ Lib (excluding Debt Service)739,047 739,084 Lib (excluding Debt Service)875,782 776,734 Lib (excluding Debt Service)934,994 20.38%158,260 2021 Tax Levy - Public Hearing (Limiting Rate Applied to City) 2 2019 Rate Setting EAV % Change over Prior Yr EAV 2020 Rate Setting EAV % Change over Prior Yr EAV 2021 Estimated EAV % Change over Prior Yr EAV $ Change Farm 3,259,791$ 1.80%Farm 3,360,133$ 3.08%Farm 3,527,532$ 4.98%167,399$ Residential 450,745,939 8.15%Residential 484,024,398 7.38%Residential 520,988,654 7.64%36,964,256 Commercial 83,974,878 0.12%Commercial 79,649,698 -5.15%Commercial 83,183,473 4.44%3,533,775 Industrial 15,509,884 0.80%Industrial 15,586,411 0.49%Industrial 15,553,866 -0.21%(32,545) State Railroad 89,004 47.74%State Railroad 75,859 -14.77%State Railroad 75,859 0.00%- Total 553,579,496$ 6.60%Total 582,696,499$ 5.26%Total 623,329,384$ 6.97%40,632,885$ 2019 2019 2019 2020 2020 2020 2021 2021 % Change over $ Change over Rate Levy Request Levy Extension Rate Levy Request Levy Extension Rate Levy Request Prior Yr Ext.Prior Yr Ext. Corporate 0.18111 1,002,536$ 1,002,588$ 0.16937 986,912$ 986,913$ 0.15606 972,737$ -1.44%(14,176)$ Bonds & Interest 0.00000 - - 0.00000 - - 0.00000 - - - IMRF Pension 0.00000 - - 0.00000 - - 0.00000 - - - Police Protection 0.15618 864,563 864,580 0.14838 864,563 864,605 0.16739 1,043,376 20.68%178,771 Police Pension 0.22230 1,230,604 1,230,607 0.22907 1,334,771 1,334,783 0.21414 1,334,771 0.00%(12) Audit 0.00542 30,000 30,004 0.00515 30,000 30,009 0.00481 30,000 -0.03%(9) Liability Insurance 0.00723 40,000 40,024 0.00687 40,000 40,031 0.00642 40,000 -0.08%(31) Social Security 0.02710 150,000 150,020 0.02575 150,000 150,044 0.02406 150,000 -0.03%(44) School Crossing Guard 0.00362 20,000 20,040 0.00344 20,000 20,045 0.00321 20,000 (0.00) (45) Unemployment Insurance 0.00000 - - 0.00000 - - 0.00000 - - - Subtotal City 0.60296 3,337,703$ 3,337,863$ 0.58803 3,426,246$ 3,426,430$ 0.57608 3,590,884$ 4.80%164,454 Library Operations 0.13351 739,047$ 739,084$ 0.13330 875,782$ 776,734$ 0.13059 814,015$ 4.80%37,281$ Library Bonds & Interest 0.14941 827,088 827,103 0.14420 840,225 840,248 0.13593 847,313 0.84%7,065 Subtotal Library 0.28292 1,566,135$ 1,566,187$ 0.27750 1,716,007$ 1,616,983$ 0.26652 1,661,328$ 2.74%44,345 Total City (PTELL & Non-PTELL)0.88588 4,903,838$ 4,904,050$ 0.86553 5,142,253$ 5,043,413$ 0.84261 5,252,212$ 4.14%208,799$ less Bonds & Interest 0.14941 827,088 827,103 0.14420 840,225 840,248 0.13593 847,313 0.84%7,065 P-TELL Totals 0.73647 4,076,750$ 4,076,947$ 0.72133 4,302,028$ 4,203,165$ 0.70667 4,404,899$ 4.80%201,734$ 2021 Tax Levy - Estimated CPI and New Construction Increments (Limiting Rate Applied to City & Library) ** (Based on original new construction EAV estimate of $20,219,396 as of September 1, 2021) ** 1 2021 % Change over $ Change over 2019 Requested 2019 Extended 2020 Requested 2020 Requested Levy Request Prior Yr Ext.Prior Yr Ext. City 2,107,099$ 2,107,256$ City 2,091,475$ 2,091,647$ City 2,256,113$ 7.86%164,466$ Library 739,047 739,084 Library 875,782 776,734 Library 814,015 4.80%37,281 Police Pension 1,230,604 1,230,607 Police Pension 1,334,771 1,334,783 Police Pension 1,334,771 0.00%(12) City Debt Service - - City Debt Service - - City Debt Service - - - Library Debt Service 827,088 827,103 Library Debt Service 840,225 840,248 Library Debt Service 847,313 0.84%7,065 Total 4,903,838$ 4,904,050$ Total 5,142,253$ 5,043,413$ Total 5,252,212$ 4.14%208,799$ less Bonds & Interest 827,088 827,103 less Bonds & Interest 840,225 840,248 less Bonds & Interest 847,313 0.84%7,065 PTELL Subtotal 4,076,750$ 4,076,947$ PTELL Subtotal 4,302,028$ 4,203,165$ PTELL Subtotal 4,404,899$ 4.80%201,734$ City (excluding Debt Service)3,337,703$ 3,337,863$ City (excluding Debt Service)3,426,246$ 3,426,430$ City (excluding Debt Service)3,590,884$ 4.80%164,454$ Lib (excluding Debt Service)739,047 739,084 Lib (excluding Debt Service)875,782 776,734 Lib (excluding Debt Service)814,015 4.80%37,281 2021 Tax Levy - Estimated CPI and New Construction Increments (Limiting Rate Applied to City & Library) 2 2019 Rate Setting EAV % Change over Prior Yr EAV 2020 Rate Setting EAV % Change over Prior Yr EAV 2021 Estimated EAV % Change over Prior Yr EAV $ Change Farm 3,259,791$ 1.80%Farm 3,360,133$ 3.08%Farm 3,527,532$ 4.98%167,399$ Residential 450,745,939 8.15%Residential 484,024,398 7.38%Residential 520,988,654 7.64%36,964,256 Commercial 83,974,878 0.12%Commercial 79,649,698 -5.15%Commercial 83,183,473 4.44%3,533,775 Industrial 15,509,884 0.80%Industrial 15,586,411 0.49%Industrial 15,553,866 -0.21%(32,545) State Railroad 89,004 47.74%State Railroad 75,859 -14.77%State Railroad 75,859 0.00%- Total 553,579,496$ 6.60%Total 582,696,499$ 5.26%Total 623,329,384$ 6.97%40,632,885$ 2019 2019 2019 2020 2020 2020 2021 2021 % Change over $ Change over Rate Levy Request Levy Extension Rate Levy Request Levy Extension Rate Levy Request Prior Yr Ext.Prior Yr Ext. Corporate 0.18111 1,002,536$ 1,002,588$ 0.16937 986,912$ 986,913$ 0.15606 972,737$ -1.44%(14,176)$ Bonds & Interest 0.00000 - - 0.00000 - - 0.00000 - - - IMRF Pension 0.00000 - - 0.00000 - - 0.00000 - - - Police Protection 0.15618 864,563 864,580 0.14838 864,563 864,605 0.15969 995,406 15.13%130,801 Police Pension 0.22230 1,230,604 1,230,607 0.22907 1,334,771 1,334,783 0.21414 1,334,771 0.00%(12) Audit 0.00542 30,000 30,004 0.00515 30,000 30,009 0.00481 30,000 -0.03%(9) Liability Insurance 0.00723 40,000 40,024 0.00687 40,000 40,031 0.00642 40,000 -0.08%(31) Social Security 0.02710 150,000 150,020 0.02575 150,000 150,044 0.02406 150,000 -0.03%(44) School Crossing Guard 0.00362 20,000 20,040 0.00344 20,000 20,045 0.00321 20,000 (0.00) (45) Unemployment Insurance 0.00000 - - 0.00000 - - 0.00000 - - - Subtotal City 0.60296 3,337,703$ 3,337,863$ 0.58803 3,426,246$ 3,426,430$ 0.56839 3,542,914$ 3.40%116,484 Library Operations 0.13351 739,047$ 739,084$ 0.13330 875,782$ 776,734$ 0.12885 803,141$ 3.40%26,407$ Library Bonds & Interest 0.14941 827,088 827,103 0.14420 840,225 840,248 0.13593 847,313 0.84%7,065 Subtotal Library 0.28292 1,566,135$ 1,566,187$ 0.27750 1,716,007$ 1,616,983$ 0.26478 1,650,454$ 2.07%33,471 Total City (PTELL & Non-PTELL)0.88588 4,903,838$ 4,904,050$ 0.86553 5,142,253$ 5,043,413$ 0.83317 5,193,368$ 2.97%149,955$ less Bonds & Interest 0.14941 827,088 827,103 0.14420 840,225 840,248 0.13593 847,313 0.84%7,065 P-TELL Totals 0.73647 4,076,750$ 4,076,947$ 0.72133 4,302,028$ 4,203,165$ 0.69723 4,346,055$ 3.40%142,890$ 2021 Tax Levy - Estimated New Construction Only ** (Based on original new construction EAV estimate of $20,219,396 as of September 1, 2021) ** (Limiting Rate Applied to City & Library) 1 2021 % Change over $ Change over 2019 Requested 2019 Extended 2020 Requested 2020 Requested Levy Request Prior Yr Ext.Prior Yr Ext. City 2,107,099$ 2,107,256$ City 2,091,475$ 2,091,647$ City 2,208,143$ 5.57%116,496$ Library 739,047 739,084 Library 875,782 776,734 Library 803,141 3.40%26,407 Police Pension 1,230,604 1,230,607 Police Pension 1,334,771 1,334,783 Police Pension 1,334,771 0.00%(12) City Debt Service - - City Debt Service - - City Debt Service - - - Library Debt Service 827,088 827,103 Library Debt Service 840,225 840,248 Library Debt Service 847,313 0.84%7,065 Total 4,903,838$ 4,904,050$ Total 5,142,253$ 5,043,413$ Total 5,193,368$ 2.97%149,955$ less Bonds & Interest 827,088 827,103 less Bonds & Interest 840,225 840,248 less Bonds & Interest 847,313 0.84%7,065 PTELL Subtotal 4,076,750$ 4,076,947$ PTELL Subtotal 4,302,028$ 4,203,165$ PTELL Subtotal 4,346,055$ 3.40%142,890$ City (excluding Debt Service)3,337,703$ 3,337,863$ City (excluding Debt Service)3,426,246$ 3,426,430$ City (excluding Debt Service)3,542,914$ 3.40%116,484$ Lib (excluding Debt Service)739,047 739,084 Lib (excluding Debt Service)875,782 776,734 Lib (excluding Debt Service)803,141 3.40%26,407 2021 Tax Levy - Estimated New Construction Only (Limiting Rate Applied to City & Library) 2 2019 Rate Setting EAV % Change over Prior Yr EAV 2020 Rate Setting EAV % Change over Prior Yr EAV 2021 Estimated EAV % Change over Prior Yr EAV $ Change Farm 3,259,791$ 1.80%Farm 3,360,133$ 3.08%Farm 3,527,532$ 4.98%167,399$ Residential 450,745,939 8.15%Residential 484,024,398 7.38%Residential 520,988,654 7.64%36,964,256 Commercial 83,974,878 0.12%Commercial 79,649,698 -5.15%Commercial 83,183,473 4.44%3,533,775 Industrial 15,509,884 0.80%Industrial 15,586,411 0.49%Industrial 15,553,866 -0.21%(32,545) State Railroad 89,004 47.74%State Railroad 75,859 -14.77%State Railroad 75,859 0.00%- Total 553,579,496$ 6.60%Total 582,696,499$ 5.26%Total 623,329,384$ 6.97%40,632,885$ 2019 2019 2019 2020 2020 2020 2021 2021 % Change over $ Change over Rate Levy Request Levy Extension Rate Levy Request Levy Extension Rate Levy Request Prior Yr Ext.Prior Yr Ext. Corporate 0.18111 1,002,536$ 1,002,588$ 0.16937 986,912$ 986,913$ 0.13917 867,507$ -12.10%(119,406)$ Bonds & Interest 0.00000 - - 0.00000 - - 0.00000 - - - IMRF Pension 0.00000 - - 0.00000 - - 0.00000 - - - Police Protection 0.15618 864,563 864,580 0.14838 864,563 864,605 0.15786 983,968 13.81%119,363 Police Pension 0.22230 1,230,604 1,230,607 0.22907 1,334,771 1,334,783 0.21414 1,334,771 0.00%(12) Audit 0.00542 30,000 30,004 0.00515 30,000 30,009 0.00481 30,000 -0.03%(9) Liability Insurance 0.00723 40,000 40,024 0.00687 40,000 40,031 0.00642 40,000 -0.08%(31) Social Security 0.02710 150,000 150,020 0.02575 150,000 150,044 0.02406 150,000 -0.03%(44) School Crossing Guard 0.00362 20,000 20,040 0.00344 20,000 20,045 0.00321 20,000 (0.00) (45) Unemployment Insurance 0.00000 - - 0.00000 - - 0.00000 - - - Subtotal City 0.60296 3,337,703$ 3,337,863$ 0.58803 3,426,246$ 3,426,430$ 0.54967 3,426,246$ -0.01%(184) Library Operations 0.13351 739,047$ 739,084$ 0.13330 875,782$ 776,734$ 0.13059 814,015$ 4.80%37,281$ Library Bonds & Interest 0.14941 827,088 827,103 0.14420 840,225 840,248 0.13593 847,313 0.84%7,065 Subtotal Library 0.28292 1,566,135$ 1,566,187$ 0.27750 1,716,007$ 1,616,983$ 0.26652 1,661,328$ 2.74%44,345 Total City (PTELL & Non-PTELL)0.88588 4,903,838$ 4,904,050$ 0.86553 5,142,253$ 5,043,413$ 0.81619 5,087,574$ 0.88%44,161$ less Bonds & Interest 0.14941 827,088 827,103 0.14420 840,225 840,248 0.13593 847,313 0.84%7,065 P-TELL Totals 0.73647 4,076,750$ 4,076,947$ 0.72133 4,302,028$ 4,203,165$ 0.68026 4,240,261$ 0.88%37,096$ 2021 Tax Levy - No Change from 2020 Levy ** (Based on original new construction EAV estimate of $20,219,396 as of September 1, 2021) ** (Limiting Rate Applied to City) 1 2021 % Change over $ Change over 2019 Requested 2019 Extended 2020 Requested 2020 Requested Levy Request Prior Yr Ext.Prior Yr Ext. City 2,107,099$ 2,107,256$ City 2,091,475$ 2,091,647$ City 2,091,475$ -0.01%(172)$ Library 739,047 739,084 Library 875,782 776,734 Library 814,015 4.80%37,281 Police Pension 1,230,604 1,230,607 Police Pension 1,334,771 1,334,783 Police Pension 1,334,771 0.00%(12) City Debt Service - - City Debt Service - - City Debt Service - - - Library Debt Service 827,088 827,103 Library Debt Service 840,225 840,248 Library Debt Service 847,313 0.84%7,065 Total 4,903,838$ 4,904,050$ Total 5,142,253$ 5,043,413$ Total 5,087,574$ 0.88%44,161$ less Bonds & Interest 827,088 827,103 less Bonds & Interest 840,225 840,248 less Bonds & Interest 847,313 0.84%7,065 PTELL Subtotal 4,076,750$ 4,076,947$ PTELL Subtotal 4,302,028$ 4,203,165$ PTELL Subtotal 4,240,261$ 0.88%37,096$ City (excluding Debt Service)3,337,703$ 3,337,863$ City (excluding Debt Service)3,426,246$ 3,426,430$ City (excluding Debt Service)3,426,246$ -0.01%(184)$ Lib (excluding Debt Service)739,047 739,084 Lib (excluding Debt Service)875,782 776,734 Lib (excluding Debt Service)814,015 4.80%37,281 2021 Tax Levy - No Change from 2020 Levy (Limiting Rate Applied to City) 2 Illinois Dept. of Revenue History of CPI's Used for the PTELL 01/13/2021 % Change From December Previous % Use for Years Taxes Year CPI-U December PTELL Comments Levy Year Paid 1991 137.900 -- 1992 141.900 2.9%2.9%1993 1994 1993 145.800 2.7%2.7%(5 % for Cook)1994 1995 1994 149.700 2.7%2.7%1995 1996 1995 153.500 2.5%2.5%1996 1997 1996 158.960 3.6%3.6%1997 1998 1997 161.300 1.5%1.5%1998 1999 1998 163.900 1.6%1.6%1999 2000 1999 168.300 2.7%2.7%2000 2001 2000 174.000 3.4%3.4%2001 2002 2001 176.700 1.6%1.6%2002 2003 2002 180.900 2.4%2.4%2003 2004 2003 184.300 1.9%1.9%2004 2005 2004 190.300 3.3%3.3%2005 2006 2005 196.800 3.4%3.4%2006 2007 2006 201.800 2.5%2.5%2007 2008 2007 210.036 4.08%4.1%2008 2009 2008 210.228 0.1%0.1%2009 2010 2009 215.949 2.7%2.7%2010 2011 2010 219.179 1.5%1.5%2011 2012 2011 225.672 3.0%3.0%2012 2013 2012 229.601 1.7%1.7%2013 2014 2013 233.049 1.5%1.5%2014 2015 2014 234.812 0.8%0.8%2015 2016 2015 236.525 0.7%0.7%2016 2017 2016 241.432 2.1%2.1%2017 2018 2017 246.524 2.1%2.1%2018 2019 2018 251.233 1.9%1.9%2019 2020 2019 256.974 2.3%2.3%2020 2021 2020 260.474 1.4%1.4%2021 2022 Tax Year: 2020Page 1 of 1Kendall County07/27/2021 09:20:47 AMTax Computation ReportTaxing DistrictLYYV - YORKVILLE LIBRARYEqualization Factor1.000000Fund/NameLevy RequestCalc. RateMax. RateNon-PTELLExtensionPTELLFactorRateLimited% BurdenRateTotal ExtensionKendall CountyPercentActual Rate003 BONDS & INTEREST840,2250.00000$840,248.351.000000.144200.00000$840,248.3551.96400.1441960.14420** 016 LIBRARY875,7820.15000$874,044.750.888670.133300.00000$776,734.4348.03600.1502980.15000Totals (Capped)Totals (Not Capped)Totals (All)875,782840,2251,716,007$874,044.75$840,248.35$1,714,293.100.133300.144200.277500.000000.000000.00000$776,734.43$840,248.35$1,616,982.7848.036051.9640100.00000.1502980.150000.1441960.144200.2944940.29420** Subject to PTELLProperty Type586,996,676Total + OverlapFarmResidential 484,820,010CommercialIndustrial 15,586,965Mineral0State Railroad 75,859Local Railroad 0County Total 586,996,6763,360,133 3,360,133484,024,39883,153,709 79,649,69815,586,4110582,696,49975,8590582,696,499Total EAVRate Setting EAVAnnexation EAV0Disconnection EAV16,390Recovered TIF EAV0Agg. Ext. Base (2019)739,084Limiting Rate 0.13330% of Burden 0.00%TIF Increment 4,300,177New Property 15,495,719New Property (Overlap) 0Total New Property15,495,719PTELL ValuesCopyright (C) 1997-2021 DEVNET IncorporatedJHANNA Actuarial Valuation City of Yorkville Yorkville Police Pension Fund As of May 1, 2021 For the Year Ending April 30, 2022 SUMMARY OF PRINCIPAL VALUATION RESULTS Contributions..........................................................................................................................................1 Statutory Minimum Funding Cost Elements...........................................................................................1 Funding Policy Actuarially Determined Contribution Cost Elements.....................................................2 Contriubtion to Avoid Negative Funding................................................................................................2 Financial Thumbnail Ratios.....................................................................................................................2 Plan Maturity Measures.........................................................................................................................3 Participant Data Summary......................................................................................................................3 VALUATION RESULTS Significant Events, Risk Disclosures and Issues Influencing Valuation Results.......................................4 Actuarial Certification.............................................................................................................................6 FINANCIAL AND ACTUARIAL EXHIBITS Exhibit 1 - Statement of Market Assets Available for Benefits..............................................................7 Exhibit 2 - Statement of Changes in Net Assets Available for Benefits..................................................8 Exhibit 3 - Determination of the Actuarial Value of Assets....................................................................9 Exhibit 4 - Determination of Statutory Minimum Required Annual Contribution.................................10 Exhibit 5 - Determination of Funding Policy Annual Contribution.........................................................11 Exhibit 6 - Determination of Contribution Required to Prevent Negative Funding...............................11 Exhibit 7 - Summary of Participant Data as of May 1, 2021...................................................................12 SUMMARY OF PRINCIPAL PLAN PROVISIONS Definitions...............................................................................................................................................13 Pension (3-111).......................................................................................................................................13 Pension to Survivors (3-112)...................................................................................................................14 Disability Pension Line of Duty (3-114.1)................................................................................................15 Disability Pension Not on Duty (3-114.2)...............................................................................................15 Other Provisions......................................................................................................................................15 Glossary of Terms...................................................................................................................................16 SUMMARY OF ACTUARIAL ASSUMPTIONS AND COST METHODS Nature of Actuarial Calculations.............................................................................................................18 Assumptions............................................................................................................................................18 Asset Valuation Methods........................................................................................................................19 Actuarial Cost Methods..........................................................................................................................19 Table of Contents SECTION 1SECTION 2SECTION 3SECTION 4SECTION 5 CONTRIBUTIONS Current Prior Year Valuation Valuation as of 5/1/2021 as of 5/1/2020 Contribution Required To Prevent Negative Funding $1,264,818 (46.1%)$1,310,260 (49.8%) Actuarially Determined Funding Policy Contribution $1,320,595 (48.1%)$1,334,771 (50.7%) Statutory Minimum Contribution per 40 ILCS 5/3 Section 125 $1,104,801 (40.3%)$1,128,201 (42.9%) Current Prior Year Item Valuation Valuation as of 5/1/2021 as of 5/1/2020 Accrued Liability $ 24,049,282 $ 22,452,270 Market Value of Assets $ 14,576,330 $ 10,864,983 Actuarial (Smoothed) Value of Assets $ 13,210,427 $ 11,553,728 Normal Cost (employer) $ 425,925 $ 454,684 Amortization Amount $ 588,960 $ 582,651 Statutory Minimum Contribution $ 1,104,801 $ 1,128,201 MWM Consulting Group was retained to prepare an actuarial valuation as of May 1,2021 for the Yorkville Police Pension Fund.The purpose of the actuarial valuation was to determine the financial position and the annual actuarial requirements of the pension fund under Illinois statute 40 ILCS 5/3,Section 125,and to develop a recommended minimum contribution amount. For quick reference,some of the key results of the valuation,along with selected financial and demographic information for the year ending April 30,2022 are summarized in this overview section along with (for comparison) the results from the prior year. Illinois statues require employers to contribute at least the amount necessary such that assets will equal at least 90% of the accrued liability by 2040. The minimum amount is determined under the Projected Unit Credit funding method, with smoothed assets, and is equal to the normal cost plus the amortization amount. Section 1 - Summary of Principal Valuation Results STATUTORY MINIMUM FUNDING COST ELEMENTS () amounts expressed as a percentage of payroll The plan sponsor must contribute at least the statutorily required minimum contribution under Illinois statutes equal to the normal cost plus the amount necessary to amortize the unfunded accrued liability such that by 2040, the liabilities will be 90% funded. Other contribution amounts are shown including Funding Policy Contribution and the contribution required to prevent negative funding. Item Page 1 City of Yorkville Police Pension Fund Actuarial Valuation as of May 1, 2021 Accrued Liability Market Value of Assets Actuarial (Smoothed) Value of Assets Normal Cost (employer) Amortization Amount Actuarially Determined Funding Policy Contribution Accrued Liability Market Value of Assets Actuarial (Smoothed) Value of Assets Normal Cost (employer) Amortization Amount Amount of Contribution Needed to Avoid Negative Funding FINANCIAL THUMBNAIL RATIOS Tests Liquidity Ratio (based upon year ended) Coverage Ratio (Market Value Assets) Annual Benefit Payments (expected) Annual Contributions (expected) Members City $ 13,210,427 $ 391,429 $ 825,133 $ 1,320,595 FUNDING POLICY CONTRIBUTION COST ELEMENTS Item The funding policy contribution amount is determined under the Entry Age Normal funding method, with smoothed assets, and is equal to the normal cost plus the amortization amount. 100% of the unfunded liability is amortized as a level percentage of pay on a closed basis over 19 years. Current Valuation as of 5/1/2021 $ 25,026,357 $ 14,576,330 Prior Year Valuation as of 5/1/2020 $ 23,533,723 $ 10,864,983 $ 11,553,728 $ 423,745 $ 806,646 $ 1,334,771 $ 838,600 $ 1,264,818 $ 1,310,260 46.17% $ 993,095 $ 868,094 $ 25,026,357 $ 23,533,723 The statutory minimum contribution amortization amount is based upon a percentage of increasing payroll and, in the early years of funding, may not be sufficient to cover the interest cost on the unfunded liability. In order to avoid an increase in the unfunded liability (known as negative funding), the minimum amortization amount must be adjusted to be at least equal to the interest on the unfunded liability. The amount shown in the table as “Contribution to Avoid Negative Funding” provides for interest on 100% of the unfunded liability. $ 14,576,330 $ 10,864,983 $ 13,210,427 $ 11,553,728 $ 391,429 $ 423,745 $ 827,115 AMOUNT REQUIRED TO AVOID NEGATIVE FUNDING Item Current Prior Year Valuation Valuation as of 5/1/2021 as of 5/1/2020 This chart summarizes traditional financial ratios as applied to the pension plan. This liquidity ratio relates the cash flow position of the Fund by comparing the investment income plus employer and employee contributions to the annual benefit payments. Maintaining a ratio well above 100% prevents the liquidation of assets to cover benefit payments. The increase in benefits paid over the years is generally a result of the maturing of the pension plan. Coverage of the Accrued Liabilities by the Assets is the Coverage Ratio and is one indication of the long term funding progress of the plan. $ 269,627 $ 260,748 $ 1,320,595 $ 1,334,771 5/1/2021 Valuation 5/1/2020 Valuation 510%158% 58.24% Page 2 City of Yorkville Police Pension Fund Actuarial Valuation as of May 1, 2021 PLAN MATURITY MEASURES Tests Ratio of Market Value of Assets to Active Participant Payroll is a measure of volatility risk associated with asset losses Ratio of Accrued Liability to Payroll is a measure of volatility risk associated with changes in assumptions Ratio of retired life Actuarial Accrued Liability to total Actuarial Accrued Liability Percentage of Contributions less Benefit Payments to Market Value of Assets Ratio of Benefit Payments to Contributions Support Ratio: Ratio of Active Participants to Retired Participants Tier 1 Tier 2 Total Tier 1 Tier 2 Total Active Members Vested 12 3 15 14 2 16 Non-Vested 0 17 17 0 14 14 Total Active 12 20 32 14 16 30 Terminated entitled to future benefits 4 3 7 4 3 7 Retired 13 0 13 11 0 11 Surviving Spouse 0 0 0 0 0 0 Minor Dependent 0 0 0 0 0 0 Disabled 0 0 0 0 0 0 Total 29 23 52 29 19 48 0.67 0.61 5/1/2021 Valuation 5/1/2020 Valuation 5.31 4.13 9.12 8.94 as of 5/1/2020as of 5/1/2021 Item This chart includes financial relationship measures which are meant to help understand the risks associated with the plan. The ratio of Market Value of Assets to Active Payroll is measure of volatility risk associated with asset losses. The higher the ratio, the greater the volatility in contribution risks. The Ratio of Accrued Liability to Payroll is a measure of the volatility risk associated with assumption or other changes in liabilities. The higher the ratio, the greater the volatility in contribution risks. The Ratio of retired life actuarial accrued liability to total actuarial accrued liability is a measure of the maturity of the Plan. A mature plan will have a ratio above 60%. The Support Ratio (Actives: Retirees). A number less than 1 indicates a more mature plan. PARTICIPANT DATA SUMMARY The Actuarial Valuation takes into account demographic and benefit information for active employees, vested former employees, and retired pensioners and beneficiaries. The statistics for the past two years are compared in the chart. Prior Year Valuation Valuation 5.51%5.77% 0.60 0.57 1.60 1.67 Current Year Page 3 City of Yorkville Police Pension Fund Actuarial Valuation as of May 1, 2021 Change in Assumptions Funded Status The funded ratio measurement presented in the Actuarial Valuation Report for the Fund is the ratio of the actuarial value of fund assets available for benefits compared to the actuarial accrued liability.By monitoring changes in the funding ratio each year,one can determine whether or not funding progress is being made. Please understand that: • The funded ratio measurement is dependent upon the actuarial cost method which, in combination with the plan’s amortization policy, affects the timing and amounts of future contributions. The amounts of future contributions will most certainly differ from those assumed in this report due to future actual experience differing from assumed experience based upon the actuarial assumptions. Attainment of a funded status measurement in the Actuarial Valuation of 90% or 100% is not synonymous with no required future annual contributions. Even if the funded status attained is 100%, the plan would still require future normal cost contributions (i.e., contributions to cover the annual cost of the active membership accruing an additional year of service credit). • The funded ratio measurement is a different result depending upon whether the market value of assets or the actuarial value of assets is used. The fully generational mortality projection scale was updated from MP2019 to MP2020. SECTION 2 - VALUATION RESULTS Significant Events, Disclosure Risks and Issues Influencing Valuation Results Actuarial valuations are snapshot calculations which incorporate and reflect the experience and events of the past year such as changes in the demographics of the plan participants,gains and losses in the plan assets, changes in actuarial assumptions about future experience and outside influences such as legislation.Some of the more significant issues affecting the Plan’s contribution level are described here. Asset Performance for yearend 4/30/2021 The approximate 28.01%return (not time weighted)on net assets was above the actuarial assumption of 7.00% in effect for the 2020/2021 year. 7.06%5.46%8.02%-1.13% 28.01% 7.00%7.00% -10.00% 0.00% 10.00% 20.00% 30.00% 2017 2018 2019 2020 2021 Historical Rates of Return Rate of Return on Assets Assumed Rate of Return 0.00% 25.00% 50.00% 75.00% 100.00% 2017 2018 2019 2020 2021 Funded Percentages Funded Ratios - Market Assets Funded Ratios - Smoothed Assets Page 4 City of Yorkville Police Pension Fund Actuarial Valuation as of May 1, 2021 The employer contribution is expected to be paid according to the funding policy, which exceeds the required statutory minimum amount. An additional funding contribution amount is included which determines the amount necessary to prevent negative funding. Employer Contributions Negative Funding The current Funding Policy amortizes the unfunded amount based upon a level percentage of payroll.This amortization method develops dollar amounts which increase as payroll increases.The dollar amounts under this amortization method in the early years are less than the interest on the unfunded liability.For 2021,the interest on the unfunded is $827,115,whereas the funding policy amortization is $882,892 (ie,$825,133 plus interest at 7%;see exhibits 5 and 6 on page 11).The dollar amounts towards the end of the closed amortization period are necessarily much larger,and if payroll does not increase as expected,the amortization amount can dramatically increase the contribution as a percentage of payroll. Since the Funding Policy percentage of payroll amortization (end of year)is greater than the negative funding amount, at this point, the dollar value of the interest on the unfunded liability is covered. Assuming the Funding Policy Contributions are received (and the actuarial assumptions are met)each year through 2040,the Fund’s funded ratio is projected to increase to 100%by 2040.If only the Minimum Statutory contributions are made,the Fund’s funded ratio would be projected to increase to 90%by 2040 and would require steeper contributions in years closer to 2040. The ability of the fund to reach 100%is heavily dependent on the City contributing the Funding Policy Employer Contribution each and every year.Actuarial standards do not require the actuary to evaluate the ability of the City or other contributing entity to make such required contributions to the Fund when due.Such an evaluation is not within the actuary’s domain of expertise.Consequently,the actuary performed no such evaluation. The articulated Funding Policy amortizes 100%the unfunded amount based upon a level percentage of pay. The statutory funding required amortization method develops dollar amounts which also increase as payroll increases.The dollar amounts towards the end of the closed amortization period are necessarily much larger, and if payroll does not increase as expected,the amortization amount can dramatically increase the contribution as a percentage of payroll. Page 5 City of Yorkville Police Pension Fund Actuarial Valuation as of May 1, 2021 ACTUARIAL CERTIFICATION MWM CONSULTING GROUP Kathleen E Manning, FSA, EA, FCA, MAAA Kyle Bang, FSA, EA, FCA, MAAA Date Managing Principal & Consulting Actuary Consulting Actuary Karl K. Oman, ASA, EA, FCA, MAAA Consulting Actuary The results shown in this report have been calculated under the supervisions of a qualified Actuary as defined in appropriate State statutes.All results are based upon demographic data submitted by the Fund /City,financial data submitted by the Fund,applications of actuarial assumptions,and generally accepted actuarial methods. This valuation report has been prepared at the request of City of Yorkville to assist in administering the Plan and meeting specified financial and accounting requirements.This valuation report may not otherwise be copied or reproduced in any form without the consent of the Fund sponsor and may only be provided to other parties in its entirety.The information and valuation results shown in this report are prepared with reliance upon information and data provided to us,which we believe to the best of our knowledge to be complete and accurate and include: • Employee census data submitted by the City of Yorkville. This data was not audited by us but appears to be consistent with prior information, and sufficient and reliable for purposes of this report. We believe the assumptions and methods used are within the range of possible assumptions that are reasonable and appropriate for the purposes for which they have been used.In our opinion,all methods, assumptions and calculations are in accordance with requirements and the procedures followed and presentation of results are in conformity with generally accepted actuarial principles and practices.The undersigned actuary meets the Qualification Standards of the American Academy of Actuaries to render the actuarial opinions contained herein.There is no relationship between the City of Yorkville and MWM Consulting Group that impacts our objectivity.I certify that the results presented in this report are accurate and correct to the best of my knowledge. This is to certify that MWM Consulting Group has prepared an Actuarial Valuation of the Plan as of May 1, 2021 for the purposes of determining statutory contribution requirements for the Fund in accordance with the requirements of 40 ILCS 5/3,Section 125,of determining the funding policy contribution amount (the Actuarially Determined Contribution).The funding policy is selected by the City.The contributions determined are net of contributions made by active member police officers during the year. The measurements shown in this actuarial valuation may not be applicable for other purposes.Actuarial valuations involve calculations that require assumptions about future events.Certain of the assumptions or methods are mandated for specific purposes.Future actuarial measurements may differ significantly from the current measurements presented in the report due to such factors as experience that deviates from the assumptions,changes in assumptions,increases or decreases expected as part of the natural operation of the methodology used for these measurements (such as the end of an amortization period, or additional cost or contributions based on the Plan’s funded status)and changes in plan provisions or applicable law.This report does not include an analysis of the potential range of such future measurements. • Financial data submitted by the City of Yorkville. Page 6 City of Yorkville Police Pension Fund Actuarial Valuation as of May 1, 2021 Exhibit 1 - Statement of Market Value of Assets 4/30/2021 4/30/2020 1. Investments at Fair Value: a. Cash and Cash equivalents $ 0 $ 0 b. Money Market Mutual Funds 965,709 508,401 c. Municipal and Corporate Bonds 1,006,175 837,353 d. Certificates of Deposit 0 0 e. US Government and Agency Bonds 3,309,833 3,039,164 f. Common and Preferred Stocks 3,971,171 3,149,663 g. Insurance Contracts (at contract value): 0 0 h. Mutual Funds 5,306,001 3,309,914 i. Accrued Interest and receivables 30,542 22,950 j. Other 0 0 k. Subtotal Assets (a + b + c + d + e + f + g + h + i +j) $ 14,589,431 $ 10,867,445 2. Liabilities: a. Expenses Payable $ 7,019 $ 2,462 b. Liability for benefits due and unpaid 0 0 c. Other Liabilities 6,082 0 d. Total Liabilities $ 13,101 $ 2,462 3. Net Market Value of Assets Available for Benefits: (1k – 2d) $ 14,576,330 $ 10,864,983 Item Plan Year Ending SECTION 3 - FINANCIAL AND ACTUARIAL EXHIBITS Page 7 City of Yorkville Police Pension Fund Actuarial Valuation as of May 1, 2021 4/30/2021 4/30/2020 Additions Contributions Employer $ 1,230,604 $ 1,111,484 Plan Member 261,904 269,903 Other 0 0 Total Contributions $ 1,492,508 $ 1,381,387 Investment Income Realized and Unrealized Gains/(Losses) $ 2,666,024 $ (540,057) Interest 436,546 337,334 Dividends 57,080 76,811 Other Income 1,457 48,314 Investment Expenses (36,168) (43,563) Net Investment Income 3,124,939 (121,161) Total additions $ 4,617,447 $ 1,260,226 Deductions Benefits $ 893,334 $ 781,425 Refunds 0 5,947 Administrative Expenses 12,766 11,589 Total deductions $ 906,100 $ 798,961 Total increase (decrease) $ 3,711,347 $ 461,265 Net Market Value of Assets Available for Benefits: Beginning of year $ 10,864,983 $ 10,403,718 End of year $ 14,576,330 $ 10,864,983 Item Plan Year Ending Exhibit 2 - Statement of Change in Net Assets Page 8 City of Yorkville Police Pension Fund Actuarial Valuation as of May 1, 2021 1. Expected Return on Assets a. Market Value of Assets as of Beginning of Year 10,864,983$ b. Income and Disbursements During the year i. Contributions Received (weighted 50%)746,254$ ii. Benefit Payments and Expenses (weighted 50%)453,050 iii. Weighted net income (other than investment income) (i) – (ii)293,204 c. Market Value adjusted for income and disbursements 11,158,187$ d. Expected Return on Assets at assumed rate of 7.00%781,073$ 2. Actual Return on Assets for year a. Market Value of Assets (Beginning of Year)10,864,983$ b. Income (less investment income)1,492,508 c. Disbursements 906,100 d. Market Value of Assets (End of Year)14,576,330 e. Actual Return on Assets (d) – (a) – (b) + (c)3,124,939 f. Investment Gain/(Loss) for year: 2(e) - 1(d) 2,343,866$ 3. Actuarial Value of Assets a. Market Value of Assets as of End of Year 14,576,330$ b. Deferred Investment gains/(losses) i. 80% of 2021 gain of $2,343,866 (1,875,093) ii. 60% of 2020 loss of $(869,806)521,884 iii. 40% of 2019 gain of $95,566 (38,226) iv. 20% of 2018 loss of $(127,661)25,532 v. Total (1,365,903) c. Actuarial Value of Assets for statutory funding 3(a) + 3(b)(v)13,210,427$ The Chart Below shows the comparison of smoothed to market assets over the past five years Under 40 ILCS 5/3,the statutory minimum required contribution is to be determined based upon Actuarial Value of Assets,which are asset values which have been smoothed over a five-year period,beginning with the year 2011.The Actuarial Value of Assets has been calculated below based upon the market value of assets at May 1,2021 with adjustments for the preceding year’s gains/losses,which are reflected at the rate of 20%per year. Exhibit 3 - Actuarial Value of Assets $7,000,000 $9,000,000 $11,000,000 $13,000,000 $15,000,000 2017 2018 2019 2020 2021 Smoothed vs Market Assets Market Value of Assets Actuarial (Smoothed) Value of Assets Page 9 City of Yorkville Police Pension Fund Actuarial Valuation as of May 1, 2021 Present Value of Benefits as of 5/1/2021 Projected Unit Credit (PUC) Normal Cost as of 5/1/2021 PUC Actuarial Accrued Liability as of 5/1/2021 1. Active Officers a) Normal & Early Retirement 12,848,386$ 481,011$ 5,654,815$ b) Vested Withdrawal 1,104,927 72,563 658,857 c) Pre-Retirement Death 428,782 29,058 223,971 d) Disability 1,748,449 112,920 850,448 e) Total Active Police Officers 16,130,544$ 695,552$ 7,388,091$ 2. Inactive Police Officers and Survivors: a) Normal Retirees 15,493,451$ 15,493,451$ b) Widows (survivors)0 0 c) Deferred Vested 1,167,740 1,167,740 d) Disabled 0 0 e) Total - Nonactive 16,661,191$ 16,661,191$ 3. Total – All 32,791,735$ 24,049,282$ Amount 2,744,017$ 425,925 269,627 24,049,282 21,644,354 13,210,427 8,433,927 588,960 89,916 $1,104,801 (40.3%) *() amount as a percent of payroll 10. Minimum statutory tax levy contribution per 40 ILCS 5/3 – (2) + (8) + (9) Under 40 ILCS 5/3,the statutory minimum required contribution is to be determined based upon the Projected Unit Credit actuarial funding method,where the unfunded liability is amortized such that 90%of the liability will be funded as of 2040.Under the statute,90%of the unfunded liability is to be amortized as a level percentage of payroll over the period through 2040.The mandated funding method,the Projected Unit Credit funding method,requires the annual cost of the plan to be developed in two parts:that attributable to benefits allocated to the current year (the normal cost); and that allocated to benefits attributable to prior service (the accrued liability). Funding Elements for 40 ILCS 5/3 Minimum Statutory Contribution under 40 ILCS 5/3 Item 1. Annual Payroll 2. Normal Cost (net of employee/member contributions) 3. Employee Contributions (expected) 4. Funding Actuarial Liability 5. 90% of Funding Actuarial Liability Exhibit 4 - Determination of the Statutory Minimum Required Contribution 6. Actuarial Value of Assets (Exhibit 3) 7. Unfunded Actuarial Balance 8. Amortization of Unfunded Balance over 19 years as a level percentage of payroll 9. Interest on (2), (3) and (8) Page 10 City of Yorkville Police Pension Fund Actuarial Valuation as of May 1, 2021 Present Value of Benefits as of 5/1/2021 Entry Age Normal Cost as of 5/1/2021 Entry Age Accrued Liability as of 5/1/2021 1. Active Officers a) Normal & Early Retirement 12,848,386$ 467,600$ 7,378,248$ b) Vested Withdrawal 1,104,927 71,791 240,447 c) Pre-Retirement Death 428,782 22,557 166,146 d) Disability 1,748,449 99,108 580,325 e) Total Active Police Officers 16,130,544$ 661,056$ 8,365,166$ 2. Inactive Police Officers and Survivors: a) Normal Retirees 15,493,451$ 15,493,451$ b) Widows (survivors)0 0 c) Deferred Vested 1,167,740 1,167,740 d) Disabled 0 0 e) Total - Nonactive 16,661,191$ 16,661,191$ 3. Total – All 32,791,735$ 25,026,357$ Amount 391,429$ 269,627 25,026,357 25,026,357 13,210,427 11,815,930 825,133 104,033 $1,320,595 (48.1%) Amount 391,429$ 269,627 25,026,357 13,210,427 11,815,930 827,115 46,274 $1,264,818 (46.1%) Exhibit 5 - Determination of the Funding Policy Contribution Funding Elements for Funding Policy Contribution The Tax Levy amount based upon the articulated funding policy is the actuarially determined contribution,rather than the amount determined as the minimum under 40 ILCS 5/3.The funding policy contribution is developed below,based upon the Entry Age Normal Funding Method,with 100%of the unfunded accrued liability amortized as a level percentage of payroll over the 19 years through FYE 2040.The contribution is then the sum of the Normal Cost (developed under the entry age method,)plus the amortization payment.Also shown is the contribution amount necessary to prevent negative funding. 1. Normal Cost (net of employee/member contributions) Actuarially Determined Funding Policy Contribution for Tax Levy Item 6. Unfunded Actuarial Balance 7. Amortization of Unfunded Balance over 19 years as a level percentage of payroll 8. Interest on (1), (2) and (7) 9. Actuarially Determined Funding Policy Contribution for Tax Levy (1) + (7) + (8) 2. Employee Contributions (expected) 3. Funding Actuarial Liability 4. 100% of Funding Actuarial Liability 5. Actuarial Value of Assets (Exhibit 3) Exhibit 6 - Contribution Necessary to Prevent Negative Funding Item 1. Normal Cost (net of employee/member contributions) 2. Employee Contributions (expected) 3. 100% of Funding Actuarial Liability 4. Actuarial Value of Assets (Exhibit 3) 5. Unfunded Actuarial Balance 6. Interest on Unfunded Liability 7. Interest on (1), (2) 8. Contribution Necessary to Prevent Negative Funding (1) + (6) + (7) Page 11 City of Yorkville Police Pension Fund Actuarial Valuation as of May 1, 2021 Tier 1 Tier 2 Total 12 3 15 0 17 17 12 20 32 4 3 7 13 0 13 0 0 0 0 0 0 0 0 0 29 23 52 0 - 4 5 - 9 10 - 14 15 - 19 20 - 24 25 - 29 30 - 34 35 - 39 40+ Under 20 0 20 - 24 4 4 25 - 29 4 4 30 - 34 4 4 8 35 - 39 1 5 6 40 - 44 1 2 3 1 7 45 - 49 1 1 2 50 - 54 1 1 55 - 59 0 60 - 64 0 65 & Over 0 Total 13 7 7 4 1 0 0 0 0 32 Average Length of Service: Participant Data Exhibit 7 - Summary of Participant Data as of May 1, 2021 35.1 years 8.3 years Active Employee Participants AGE AND SERVICE DISTRIBUTION AS OF MAY 1, 2021 Average Age: Age Group Service Total Item As of 5/1/2021 Active Members Total Actives Retired Members Minor Dependents Disabled Participants Total Vested Non-Vested Terminated Members entitled to future benefits Surviving Spouses Page 12 City of Yorkville Police Pension Fund Actuarial Valuation as of May 1, 2021 SECTION 4 - SUMMARY OF PRINCIPAL PLAN PROVISIONS This summary provides a general description of the major eligibility and benefit provisions of the pension fund upon which this valuation has been based.It is not intended to be,nor should it be interpreted as,a complete statement of all provisions Definitions Tier 1 – For Police Officers first entering Article 3 prior to January 1, 2011 Tier 2 – For Police Officers first entering Article 3 after December 31, 2010 Police Officer (3-106):Any person appointed to the police force and sworn and commissioned to perform police duties. Persons excluded from Fund (3-109):Part-time officers,special police officer,night watchmen,traffic guards,clerks and civilian employees of the department.Also,police officers who fail to pay the required fund contributions or who elect the Self-Managed Plan option. Creditable Service (3-110):Time served by a police officer,excluding furloughs in excess of 30 days,but including leaves of absences for illness or accident and periods of disability where no disability pension payments have been received and also including up to 3 years during which disability payments have been received provided contributions are made. Pension (3-111) Normal Pension Age Tier 1 - Age 50 with 20 or more years of creditable service. Tier 2 - Age 55 with 10 or more years of creditable service. Normal Pension Amount Tier 1 -50%of the greater of the annual salary held in the year preceding retirement or the annual salary held on the last day of service, plus 2½% of such annual salary for service from 20 to 30 year (maximum 25%)]. Tier 2 -2½%of Final Average salary for each year of service.Final Average Salary is the highest salary based on the highest consecutive 48 months of the final 60 months of service Early Retirement at age 50 with 10 or more years of service but with a penalty of ½%for each month prior to age 55. Annual Salary capped at $106,800 increased yearly by the lesser of the Consumer Price Index-Urban (CPI-U)or 3%. The Salary cap for valuations beginning in 2021 is $116,740. Minimum Monthly Benefit: $1,000 Maximum Benefit Percentage: 75% of salary Page 13 City of Yorkville Police Pension Fund Actuarial Valuation as of May 1, 2021 Termination Retirement Pension Date Separation of service after completion of between 8 and 20 years of creditable service. Termination Pension Amount Commencing at age 60,2½%of annual salary held in the year preceding termination times years of creditable service or refund of contributions,or for persons terminating on or after July 1,1987,2½%of annual salary held on the last day of service times years of credible service, whichever is greater. Pension Increase Non-Disabled Tier 1 -3%increase of the original pension amount after attainment of age 55 for each year elapsed since retirement,followed by an additional 3%of the original pension amount on each May 1 thereafter.Effective July 1, 1993,3%of the amount of pension payable at the time of the increase including increases previously granted, rather than 3% of the originally granted pension amount. Tier 2 -The lesser of ½of the Consumer Price Index-Urban (CPI-U)or 3%increase of the original pension amount after attainment of age 60 and an additional such increase of the original pension amount on each May 1 thereafter. Disabled 3%increase of the original pension amount after attainment of age 60 for each year he or she received pension payments, followed by an additional 3% of the original pension amount in each May 1 thereafter. Pension to Survivors (3-112 ) Death of Retired Member Tier 1 - 100% of pension amount to surviving spouse (or dependent children). Tier 2 -66 2/3%of pension amount to surviving spouse (or dependent children),subject to the following increase: The lesser of ½of the Consumer Price Index-Urban (CPI-U)or 3%increase of the original pension amount after attainment of age 60 and an additional such increase of the original pension amount on each May 1 thereafter. Death While in Service (Not in line of duty) With 20 years of creditable service, the pension amount earned as of the date of death. With less than 20 years of creditable service,50%of the salary attached to the rank for the year prior to the date of death. Death in Line of Duty 100% of the salary attached to the rank for the last day of service year prior to date of death. Minimum Survivor Pension $1,000 per month to all surviving spouses. Page 14 City of Yorkville Police Pension Fund Actuarial Valuation as of May 1, 2021 Disability Pension - Line of Duty (3-114.1) Eligibility Suspension or retirement from police service due to sickness, accident or injury while on duty. Pension Greater of 65%of salary attached to rank at date of suspension or retirement and the retirement pension available. Minimum $1,000 per month. Disability Pension - Not on Duty (3-114.2) Eligibility Suspension or retirement from police service for any cause other than while on duty. Pension 50% of salary attached to rank at date of suspension or retirement. Minimum $1,000 per month. Other Provisions Marriage after Retirement (3-120) No surviving spouse benefit available. Refund (3-124) At termination with less than 20 years of service, contributions are refunded upon request. Contributions by Police Officers (3-125.1) Beginning May 1,2001,9.91%of salary including longevity,but excluding overtime pay,holiday pay,bonus pay, merit pay or other cash benefit. Page 15 City of Yorkville Police Pension Fund Actuarial Valuation as of May 1, 2021 GLOSSARY Actuarial Accrued Liability See Entry Age Normal Cost Method and Projected Unit Credit Cost Method. Actuarial Assumptions The economic and demographic predictions used to estimate the present value of the plan’s future obligations. They include estimates of investment earnings,salary increases,mortality,withdrawal and other related items. The Actuarial Assumptions are used in connection with the Actuarial Cost Method to allocate plan costs over the working lifetimes of plan participants. Actuarial Cost Method The method used to allocate the projected obligations of the plan over the working lifetimes of the plan participants. Also referred to as an Actuarial Funding Method. Actuarial Funding Method See Actuarial Cost Method Actuarial Gain (Loss) The excess of the actual Unfunded Actuarial Accrued Liability over the expected Unfunded Actuarial Accrued Liability represents an Actuarial Loss.If the expected Unfunded Actuarial Accrued Liability is greater,an Actuarial Gain has occurred. Actuarial Present Value The value of an amount or series of amounts payable or receivable at various times,determined as of a given date by the application of a particular set of Actuarial Assumptions . Actuarial Value of Assets The asset value derived by using the plan’s Asset Valuation Method. Asset Valuation Method A valuation method designed to smooth random fluctuations in asset values.The objective underlying the use of an asset valuation method is to provide for the long-term stability of employer contributions. Employee Retirement Income Security Act of 1974 (ERISA) The primary federal legislative act establishing funding,participation,vesting,benefit accrual,reporting, and disclosure standards for pension and welfare plans. Entry Age Normal Cost Method One of the standard actuarial funding methods in which the Present Value of Projected Plan Benefits of each individual included in the Actuarial Valuation is allocated on a level basis over the earnings of the individual between entry age and assumed exit age(s).The portion of this Actuarial Present Value allocated to a valuation year is called the Normal Cost .The portion of this Actuarial Present Value not provided for at a valuation date by the Actuarial Present Value of future Normal Costs is called the Actuarial Accrued Liability . Page 16 City of Yorkville Police Pension Fund Actuarial Valuation as of May 1, 2021 GLOSSARY (Continued) Normal Cost The portion of the Present Value of Projected Plan Benefits that is allocated to a particular plan year by the Actuarial Cost Method .See Entry Age Normal Cost Method for a description of the Normal Cost under the Entry Age Normal Cost Method.See Projected Unit Credit Cost Method for a description of the Normal Cost under the Projected Unit Credit Cost Method. Present Value of Future Normal Costs The present value of future normal costs determined based on the Actuarial Cost Method for the plan.Under the Entry Age Normal Cost Method ,this amount is equal to the excess of the Present Value of Projected Plan Benefits over the sum of the Actuarial Value of Assets and Unfunded Actuarial Accrued Liability. Present Value of Projected Plan Benefits The present value of future plan benefits reflecting projected credited service and salaries.The present value is determined based on the plan’s actuarial assumptions. Projected Unit Credit Cost Method One of the standard actuarial funding methods in which the Present Value of Projected Plan Benefits of each individual included in the Actuarial Valuation is allocated by a consistent formula to valuation years.The Actuarial Present Value allocated to a valuation year is called the Normal Cost .The Actuarial Present Value of benefits allocated to all periods prior to a valuation year is called the Actuarial Accrued Liability . Unfunded Actuarial Accrued Liability The excess of the Actuarial Accrued Liability over the Actuarial Value of Assets. Page 17 City of Yorkville Police Pension Fund Actuarial Valuation as of May 1, 2021 Mortality Retirement Tier 1 Age Age Age Age 50 15.00%61 25.00%50 15.00%61 25.00% 51 15.00%62 25.00%51 15.00%62 25.00% 52 20.00%63 25.00%52 20.00%63 25.00% 53 20.00%64 25.00%53 20.00%64 25.00% 54 20.00%65 100%54 20.00%65 100% 55 25.00%66 100%55 25.00%66 100% 56 25.00%67 100%56 25.00%67 100% 57 25.00%68 100%57 25.00%68 100% 58 25.00%69 100%58 25.00%69 100% 59 25.00%70 100%59 25.00%70 100% 60 25.00%60 25.00% Tier 2 Age Age Age Age 50 5.00%61 25.00%50 5.00%61 25.00% 51 5.00%62 25.00%51 5.00%62 25.00% 52 5.00%63 25.00%52 5.00%63 25.00% 53 5.00%64 25.00%53 5.00%64 25.00% 54 5.00%65 100%54 5.00%65 100% 55 40.00%66 100%55 40.00%66 100% 56 25.00%67 100%56 25.00%67 100% 57 25.00%68 100%57 25.00%68 100% 58 25.00%69 100%58 25.00%69 100% 59 25.00%70 100%59 25.00%70 100% 60 25.00%60 25.00% Withdrawal Age Age 25 10.40%25 10.40% 40 1.90%40 1.90% 50 1.50%50 1.50% 55 1.50%55 1.50% SECTION 5 - SUMMARY OF ACTUARIAL ASSUMPTIONS AND COST METHODS Annual Actuarial Valuation Funding Policy Amount for Tax Levy Annual Actuarial Valuation Statutory Minimum Actuarial Assumption Interest 7.00% per annum 7.00% per annum The results documented in this report are estimates based on data that may be imperfect and on assumptions about future events,some of which are mandated assumptions.Certain provisions may be approximated or deemed immaterial and therefore are not valued.Assumptions may be made about participant data or other factors.A range of results,different from those presented in this report could be considered reasonable.The numbers are not rounded,but this is for convenience and should not imply precisions, which is not inherent in actuarial calculations. Nature of Actuarial Calculations RP2014 Healthy Annuitant with Blue Collar Adjustments Projected Generationally from 2013 with Scale MP2020 RP2014 Healthy Annuitant with Blue Collar Adjustments Projected Generationally from 2013 with Scale MP2020 Rates of retirement for all ages are: Rates of termination are based upon age only. Sample rates for selected ages are: Rates of retirement for all ages are: Tier 1 Tier 2 Rates of termination are based upon age only. Sample rates for selected ages are: Page 18 City of Yorkville Police Pension Fund Actuarial Valuation as of May 1, 2021 Disability Age Age 25 0.03%25 0.03% 40 0.42%40 0.42% 50 0.71%50 0.71% 55 0.90%55 0.90% Salary Increase This method projects benefits from entry age to retirement age and attributes costs over total service, as a level percentage of pay. Amounts attributable to past service have been amortized over 19 years on a closed basis as a level percentage of pay. Assets are valued at fair market value and smoothed over three years, reflecting gains and losses at 20% per year. Projected Unit Credit Cost Method 80% are married, females are assumed to be 3 years younger 80% are married, females are assumed to be 3 years younger Annual Actuarial Valuation Funding Policy Amount for Tax Levy Actuarial Assumption Item Annual Actuarial Valuation Statutory Minimum Rates of disability are based upon age only. Sample rates for selected ages are: Payroll Growth Entry Age Normal Cost Method Percentage Married Asset Valuation Method Actuarial Cost Methods This is the mandated actuarial method to be used in determining the statutory contribution requirements and under PA 096-1495. This method determines the present value of projected benefits and prorates the projected benefit by service to date to determine the accrued liability. Amounts attributable to past service are amortized as a level percentage of pay with the goal of reaching 90% of the accrued liability by 2040. Rates of disability are based upon age only. Sample rates for selected ages are: 60%of disablities are assumed to occur in the line of duty 60%of disablities are assumed to occur in the line of duty Assets are valued at fair market value and smoothed over five years, reflecting gains and losses at 20% per year. 3.50% per annum 3.50% per annum 5% per annum 5% per annum Page 19 City of Yorkville Police Pension Fund Actuarial Valuation as of May 1, 2021 Have a question or comment about this agenda item? Call us Monday-Friday, 8:00am to 4:30pm at 630-553-4350, email us at agendas@yorkville.il.us, post at www.facebook.com/CityofYorkville, tweet us at @CityofYorkville, and/or contact any of your elected officials at http://www.yorkville.il.us/320/City-Council Agenda Item Summary Memo Title: Meeting and Date: Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Agenda Item Notes: Reviewed By: Legal Finance Engineer City Administrator Community Development Purchasing Police Public Works Parks and Recreation Agenda Item Number Mayor’s Report #1 Tracking Number CC 2021-51 Bond Refinancing Discussion City Council – October 12, 2021 Informational Rob Fredrickson Finance Name Department Summary Staff is seeking direction from City Council regarding its desire to include additional proceeds (“new money”) in conjunction with the refinancing of the 2011 refunding bonds. Three different scenarios are presented below, along with various timelines and projected debt service reports provided by the City’s financial advisor (Speer Financial), for your review and consideration. Current cost estimates for the 651 Prairie Point building renovation total $7,312,209, which would exceed remaining bond proceeds of $6,128,918 from the 2021 issuance by $1,183,391. Background The 2011 refunding bonds were issued in November of 2011 in order to refinance the 2005D and 2008 refunding bonds, which were initially issued to finance construction of the Rob Roy Creek sewer interceptor. Scenario One – Refinance the 2011 Refunding Bonds Only Exhibit A shows various projected debt service reports related to the refinancing of the 2011 refunding bonds, without the inclusion of any new money. As shown on page 1, total debt service savings are estimated at approximately $242,000 (5.7%), over the final four years of the 2011 bond. Due to the relatively small size of the issue, Speer believes that it may be advantageous for the City to sell these bonds via private placement (i.e., when bonds are sold directly to a small number of local or regional banks) instead of through a public offering, in an effort to minimize issuance costs. The private placement route would save the City an estimated $48,000 in issuance costs, as it would eliminate the underwriter’s discount and the rating agency fees, estimated at $33,000 and $15,000, respectively. From the City Council perspective, the timeline associated with this scenario would be fairly straightforward. As shown in Exhibit B, the only action required by Council would be to approve the bond ordinance at the December 14th meeting. Scenario Two – Refinance the 2011 Refunding Bonds + New Money in the Amount of $1 Million Exhibit C shows various projected debt service reports related to the refinancing of the 2011 refunding bonds, with the inclusion of an additional $1 million in new money. As shown on page 1, total bond proceeds totaling $5,155,000 would be allocated between the (52) Sewer Fund ($4.145 million to refinance the 2011 bonds) and the (24) Buildings & Grounds Fund ($1.01 million) to finance improvements to the 651 Prairie Point building, less issuance costs. This scenario would increase annual debt service amounts by an estimated average of $262,000 per year, for fiscal years 2023 thru 2026, in comparison to the first scenario; with the additional debt service cost being borne by the Buildings and Ground Fund. The 2011 bond refunding savings would remain at ~$242,000, as noted on page 6. Memorandum To: City Council From: Rob Fredrickson, Finance Director Date: October 6, 2021 Subject: Refinancing and Potential New Money Bond Issuance A timeline for this scenario has been attached as Exhibit E, a summary of which is shown below:  Adoption of the Authorizing Ordinance by City Council on October 26th, which would establish the maximum amount of principal that could be issued.  The next step would be the publication of the Authorizing Ordinance and a Notice of Public Hearing in a local newspaper, which would be completed by staff later on during that week. The publication of these document would also begin the 30-day Backdoor Referendum period, pursuant to the Bond Issuance Notification Act (BINA).  A Bond Issuance Notification Act (BINA) Hearing would be conducted at City Council on November 9th.  The 30-day Backdoor Referendum period would end during the week of November 29th.  The final preliminary official statement (POS), which describes the terms and features of the bonds, would be disseminated to potential buyers at the end of November.  The bond sale would take place on December 14th, followed by adoption of the bond ordinance by City Council that evening.  Closing would take place in early January 2022; issuance costs would be paid, and the City would receive the new money bond proceeds to finance improvements. All and all, the issuance process would take roughly 60 days to complete, from approval of the authorizing ordinance through the closing date, assuming the City chooses to begin the process on October 26th. Scenario Three – Refinance the 2011 Refunding Bonds + New Money in the Amount of $2 Million Exhibit D shows various projected debt service reports related to the refinancing of the 2011 refunding bonds, with the inclusion of an additional $2 million in new money. As shown on page 1, total bond proceeds totaling $6,160,000 would be allocated between the (52) Sewer Fund ($4.14 million to refinance the 2011 bonds), with the remainder going to the (24) Buildings & Grounds Fund or another City Fund to finance improvements to the 651 Prairie Point building and/or other capital projects, less issuance costs. This would increase annual debt service costs by an average of $523,000 per year for fiscal years 2023 thru 2026 in comparison to the first scenario, as noted on the previous page. The timeline for this scenario would be exactly same as the one presented in scenario two above. Recommendation This is an informational item for discussion purposes, as staff seeks direction from City Council regarding its desire to include additional proceeds (“new money”) as a means to finance improvements to the Prairie Point building and/or other capital projects, in conjunction with the refinancing of the 2011 refunding bonds. While no formal recommendation is offered by staff at this time, staff would suggest that if Council desires to issue new money, it consider doing so in concurrence with the 2011 refunding process; in order to minimize issuance costs and to take advantage of the current low interest rate environment. United City of Yorkville, Kendall County, Illinois General Obligation Refunding Bonds (ARS), Series 2021 Dated: January 6, 2022 Refunding of 2011 Bonds / Preliminary Table of Contents Report Debt Service Comparison 1 Sources & Uses 2 Debt Service Schedule 3 Net Debt Service Schedule 4 Pricing Summary 5 Proof of Bond Yield @ 1.5000368%6 Current Refunding Escrow 7 Debt Service To Maturity And To Call 8 2022 Refunding PRLM 10.6. | SINGLE PURPOSE | 10/ 6/2021 | 2:41 PM Speer Financial, Inc. Preliminary, as of October 6, 2021 United City of Yorkville, Kendall County, Illinois General Obligation Refunding Bonds (ARS), Series 2021 Dated: January 6, 2022 Refunding of 2011 Bonds / Preliminary Debt Service Comparison Date Total P+I Net New D/S Old Net D/S Savings 12/30/2022 1,076,138.75 1,076,138.75 1,135,266.00 59,127.25 12/30/2023 1,071,950.00 1,071,950.00 1,134,178.00 62,228.00 12/30/2024 1,076,575.00 1,076,575.00 1,136,378.00 59,803.00 12/30/2025 1,075,900.00 1,075,900.00 1,136,652.00 60,752.00 Total $4,300,563.75 $4,300,563.75 $4,542,474.00 $241,910.25 PV Analysis Summary (Net to Net) Gross PV Debt Service Savings 231,939.72 Net PV Cashflow Savings @ 1.949%(AIC)231,939.72 Contingency or Rounding Amount 2,078.90 Net Present Value Benefit $234,018.62 Net PV Benefit / $4,095,000 Refunded Principal 5.715% Net PV Benefit / $4,145,000 Refunding Principal 5.646% Refunding Bond Information Refunding Dated Date 1/06/2022 Refunding Delivery Date 1/06/2022 2022 Refunding PRLM 10.6. | SINGLE PURPOSE | 10/ 6/2021 | 2:41 PM Speer Financial, Inc. Page 1 Preliminary, as of October 6, 2021 United City of Yorkville, Kendall County, Illinois General Obligation Refunding Bonds (ARS), Series 2021 Dated: January 6, 2022 Refunding of 2011 Bonds / Preliminary Sources & Uses Dated 01/06/2022 | Delivered 01/06/2022 Sources Of Funds Par Amount of Bonds $4,145,000.00 Total Sources $4,145,000.00 Uses Of Funds Costs of Issuance 45,000.00 Deposit to Current Refunding Fund 4,097,921.10 Rounding Amount 2,078.90 Total Uses $4,145,000.00 2022 Refunding PRLM 10.6. | SINGLE PURPOSE | 10/ 6/2021 | 2:41 PM Speer Financial, Inc. Page 2 Preliminary, as of October 6, 2021 United City of Yorkville, Kendall County, Illinois General Obligation Refunding Bonds (ARS), Series 2021 Dated: January 6, 2022 Refunding of 2011 Bonds / Preliminary Debt Service Schedule Date Principal Coupon Interest Total P+I Fiscal Total 01/06/2022 - - - - - 06/30/2022 - - 30,051.25 30,051.25 - 12/30/2022 1,015,000.00 1.500% 31,087.50 1,046,087.50 1,076,138.75 06/30/2023 - - 23,475.00 23,475.00 - 12/30/2023 1,025,000.00 1.500% 23,475.00 1,048,475.00 1,071,950.00 06/30/2024 - - 15,787.50 15,787.50 - 12/30/2024 1,045,000.00 1.500% 15,787.50 1,060,787.50 1,076,575.00 06/30/2025 - - 7,950.00 7,950.00 - 12/30/2025 1,060,000.00 1.500% 7,950.00 1,067,950.00 1,075,900.00 Total $4,145,000.00 -$155,563.75 $4,300,563.75 - Yield Statistics Bond Year Dollars $10,370.92 Average Life 2.502 Years Average Coupon 1.5000000% Net Interest Cost (NIC)1.5000000% True Interest Cost (TIC)1.5000368% Bond Yield for Arbitrage Purposes 1.5000368% All Inclusive Cost (AIC)1.9488527% IRS Form 8038 Net Interest Cost 1.5000000% Weighted Average Maturity 2.502 Years 2022 Refunding PRLM 10.6. | SINGLE PURPOSE | 10/ 6/2021 | 2:41 PM Speer Financial, Inc. Page 3 Preliminary, as of October 6, 2021 United City of Yorkville, Kendall County, Illinois General Obligation Refunding Bonds (ARS), Series 2021 Dated: January 6, 2022 Refunding of 2011 Bonds / Preliminary Net Debt Service Schedule Date Principal Coupon Interest Total P+I Net New D/S 12/30/2022 1,015,000.00 1.500% 61,138.75 1,076,138.75 1,076,138.75 12/30/2023 1,025,000.00 1.500% 46,950.00 1,071,950.00 1,071,950.00 12/30/2024 1,045,000.00 1.500% 31,575.00 1,076,575.00 1,076,575.00 12/30/2025 1,060,000.00 1.500% 15,900.00 1,075,900.00 1,075,900.00 Total $4,145,000.00 -$155,563.75 $4,300,563.75 $4,300,563.75 2022 Refunding PRLM 10.6. | SINGLE PURPOSE | 10/ 6/2021 | 2:41 PM Speer Financial, Inc. Page 4 Preliminary, as of October 6, 2021 United City of Yorkville, Kendall County, Illinois General Obligation Refunding Bonds (ARS), Series 2021 Dated: January 6, 2022 Refunding of 2011 Bonds / Preliminary Pricing Summary Maturity Type of Bond Coupon Yield Maturity Value Price Dollar Price 12/30/2022 Serial Coupon 1.500% 1.500% 1,015,000.00 100.000% 1,015,000.00 12/30/2023 Serial Coupon 1.500% 1.500% 1,025,000.00 100.000% 1,025,000.00 12/30/2024 Serial Coupon 1.500% 1.500% 1,045,000.00 100.000% 1,045,000.00 12/30/2025 Serial Coupon 1.500% 1.500% 1,060,000.00 100.000% 1,060,000.00 Total ---$4,145,000.00 -$4,145,000.00 Bid Information Par Amount of Bonds $4,145,000.00 Gross Production $4,145,000.00 Bid (100.000%)4,145,000.00 Total Purchase Price $4,145,000.00 Bond Year Dollars $10,370.92 Average Life 2.502 Years Average Coupon 1.5000000% Net Interest Cost (NIC)1.5000000% True Interest Cost (TIC)1.5000368% 2022 Refunding PRLM 10.6. | SINGLE PURPOSE | 10/ 6/2021 | 2:41 PM Speer Financial, Inc. Page 5 Preliminary, as of October 6, 2021 United City of Yorkville, Kendall County, Illinois General Obligation Refunding Bonds (ARS), Series 2021 Dated: January 6, 2022 Refunding of 2011 Bonds / Preliminary Proof of Bond Yield @ 1.5000368% Date Cashflow PV Factor Present Value Cumulative PV 01/06/2022 - 1.0000000x - - 06/30/2022 30,051.25 0.9928029x 29,834.97 29,834.97 12/30/2022 1,046,087.50 0.9854121x 1,030,827.31 1,060,662.28 06/30/2023 23,475.00 0.9780764x 22,960.34 1,083,622.62 12/30/2023 1,048,475.00 0.9707952x 1,017,854.53 2,101,477.15 06/30/2024 15,787.50 0.9635683x 15,212.33 2,116,689.48 12/30/2024 1,060,787.50 0.9563952x 1,014,532.02 3,131,221.51 06/30/2025 7,950.00 0.9492754x 7,546.74 3,138,768.25 12/30/2025 1,067,950.00 0.9422087x 1,006,231.75 4,145,000.00 Total $4,300,563.75 -$4,145,000.00 - Derivation Of Target Amount Par Amount of Bonds $4,145,000.00 Original Issue Proceeds $4,145,000.00 2022 Refunding PRLM 10.6. | SINGLE PURPOSE | 10/ 6/2021 | 2:41 PM Speer Financial, Inc. Page 6 Preliminary, as of October 6, 2021 United City of Yorkville, Kendall County, Illinois General Obligation Refunding Bonds (ARS), Series 2021 Dated: January 6, 2022 Refunding of 2011 Bonds / Preliminary Current Refunding Escrow Date Rate Receipts Disbursements Cash Balance 01/06/2022 - 4,097,921.10 4,097,921.10 - Total -$4,097,921.10 $4,097,921.10 - Investment Parameters Investment Model [PV, GIC, or Securities]Securities Default investment yield target Unrestricted Cash Deposit 4,097,921.10 Total Cost of Investments $4,097,921.10 Target Cost of Investments at bond yield $4,097,921.10 Yield to Receipt - Yield for Arbitrage Purposes 1.5000368% 2022 Refunding PRLM 10.6. | SINGLE PURPOSE | 10/ 6/2021 | 2:41 PM Speer Financial, Inc. Page 7 Preliminary, as of October 6, 2021 United City of Yorkville, Kendall County, Illinois Series 2011 - Refunds 2005D Except for 500 in 2011 Blc Review Debt Service To Maturity And To Call Date Refunded Bonds Refunded Interest D/S To Call Principal Coupon Interest Refunded D/S 01/06/2022 4,095,000.00 2,921.10 4,097,921.10 - - - - 06/30/2022 - - - - - 87,633.00 87,633.00 12/30/2022 - - - 960,000.00 4.280% 87,633.00 1,047,633.00 06/30/2023 - - - - - 67,089.00 67,089.00 12/30/2023 - - - 1,000,000.00 4.280% 67,089.00 1,067,089.00 06/30/2024 - - - - - 45,689.00 45,689.00 12/30/2024 - - - 1,045,000.00 4.280% 45,689.00 1,090,689.00 06/30/2025 - - - - - 23,326.00 23,326.00 12/30/2025 - - - 1,090,000.00 4.280% 23,326.00 1,113,326.00 Total $4,095,000.00 $2,921.10 $4,097,921.10 $4,095,000.00 -$447,474.00 $4,542,474.00 Yield Statistics Base date for Avg. Life & Avg. Coupon Calculation 1/06/2022 Average Life 2.536 Years Average Coupon 4.2800000% Weighted Average Maturity (Par Basis) 2.536 Years Weighted Average Maturity (Original Price Basis) 2.536 Years Refunding Bond Information Refunding Dated Date 1/06/2022 Refunding Delivery Date 1/06/2022 Ser 2011 FINAL | SINGLE PURPOSE | 10/ 6/2021 | 2:41 PM Speer Financial, Inc. Page 8 Speer Financial, Inc. INDEPENDENT MUNICIPAL ADVISORS ESTABLISHED 1954 SUITE 2630 ● 230 WEST MONROE STREET ● CHICAGO, ILLINOIS 60606 ● (312) 346-3700 ● FAX (312) 346-8833 All City Council Events or Actions are Highlighted in BLUE All Publication Events Highlighted in GRAY     UNITED CITY OF YORKVILLE, ILLINOIS General Obligation Bonds (Alternate Revenue Source), Series 2021 Preliminary Timetable (August 12, 2021) Task Party Responsible Date Distribute Draft POS Speer Week of October 11 Distribute Rating Package Speer Week of October 11 Comments received on draft All Parties Week of November 1 POS Rating Call City and Speer Week of November 8 Receive Bond Rating City and Speer Week of November 15 Distribute Bond Bond Counsel Week of November 22 Ordinance Finalize and Print POS Speer November 30 Bond Sale All Parities December 14 Bond Ordinance Adopted City December 14 Bond Closing All Parties January 6 United City of Yorkville, Kendall County, Illinois General Obligation Bonds (ARS), Series 2021 Dated: January 6, 2022 Refunding of 2011 Bonds / $1M New Money /Preliminary Table of Contents Report ISSUE SUMMARY Total Issue Sources And Uses 1 Debt Service Schedule 2 Net Debt Service Schedule 3 Pricing Summary 4 Proof of Bond Yield @ 1.5000368%5 REFUNDING OF 2011 Debt Service Comparison 6 Debt Service Schedule 7 Net Debt Service Schedule 8 Current Refunding Escrow 9 Debt Service To Maturity And To Call 10 NEW MONEY Debt Service Schedule 11 Net Debt Service Schedule 12 2022 Refunding PRLM $1M n | Issue Summary | 10/ 5/2021 | 4:39 PM Speer Financial, Inc. Preliminary, As of October 5, 2021 United City of Yorkville, Kendall County, Illinois General Obligation Bonds (ARS), Series 2021 Dated: January 6, 2022 Refunding of 2011 Bonds / $1M New Money /Preliminary Total Issue Sources And Uses Dated 01/06/2022 | Delivered 01/06/2022 Refunding of 2011 New Money Issue Summary Sources Of Funds Par Amount of Bonds $4,145,000.00 $1,010,000.00 $5,155,000.00 Total Sources $4,145,000.00 $1,010,000.00 $5,155,000.00 Uses Of Funds Costs of Issuance 42,213.87 10,286.13 52,500.00 Deposit to Project Construction Fund - 1,000,000.00 1,000,000.00 Deposit to Current Refunding Fund 4,097,921.10 - 4,097,921.10 Rounding Amount 4,865.03 (286.13)4,578.90 Total Uses $4,145,000.00 $1,010,000.00 $5,155,000.00 2022 Refunding PRLM $1M n | Issue Summary | 10/ 5/2021 | 4:39 PM Speer Financial, Inc. Page 1 Preliminary, As of October 5, 2021 United City of Yorkville, Kendall County, Illinois General Obligation Bonds (ARS), Series 2021 Dated: January 6, 2022 Refunding of 2011 Bonds / $1M New Money /Preliminary Debt Service Schedule Date Principal Coupon Interest Total P+I Fiscal Total 01/06/2022 - - - - - 06/30/2022 - - 37,373.75 37,373.75 - 12/30/2022 1,260,000.00 1.500% 38,662.50 1,298,662.50 1,336,036.25 06/30/2023 - - 29,212.50 29,212.50 - 12/30/2023 1,275,000.00 1.500% 29,212.50 1,304,212.50 1,333,425.00 06/30/2024 - - 19,650.00 19,650.00 - 12/30/2024 1,300,000.00 1.500% 19,650.00 1,319,650.00 1,339,300.00 06/30/2025 - - 9,900.00 9,900.00 - 12/30/2025 1,320,000.00 1.500% 9,900.00 1,329,900.00 1,339,800.00 Total $5,155,000.00 -$193,561.25 $5,348,561.25 - Yield Statistics Bond Year Dollars $12,904.08 Average Life 2.503 Years Average Coupon 1.5000000% Net Interest Cost (NIC)1.5000000% True Interest Cost (TIC)1.5000368% Bond Yield for Arbitrage Purposes 1.5000368% All Inclusive Cost (AIC)1.9206652% IRS Form 8038 Net Interest Cost 1.5000000% Weighted Average Maturity 2.503 Years 2022 Refunding PRLM $1M n | Issue Summary | 10/ 5/2021 | 4:39 PM Speer Financial, Inc. Page 2 Preliminary, As of October 5, 2021 United City of Yorkville, Kendall County, Illinois General Obligation Bonds (ARS), Series 2021 Dated: January 6, 2022 Refunding of 2011 Bonds / $1M New Money /Preliminary Net Debt Service Schedule Date Principal Coupon Interest Total P+I Net New D/S 12/30/2022 1,260,000.00 1.500% 76,036.25 1,336,036.25 1,336,036.25 12/30/2023 1,275,000.00 1.500% 58,425.00 1,333,425.00 1,333,425.00 12/30/2024 1,300,000.00 1.500% 39,300.00 1,339,300.00 1,339,300.00 12/30/2025 1,320,000.00 1.500% 19,800.00 1,339,800.00 1,339,800.00 Total $5,155,000.00 -$193,561.25 $5,348,561.25 $5,348,561.25 2022 Refunding PRLM $1M n | Issue Summary | 10/ 5/2021 | 4:39 PM Speer Financial, Inc. Page 3 Preliminary, As of October 5, 2021 United City of Yorkville, Kendall County, Illinois General Obligation Bonds (ARS), Series 2021 Dated: January 6, 2022 Refunding of 2011 Bonds / $1M New Money /Preliminary Pricing Summary Maturity Type of Bond Coupon Yield Maturity Value Price Dollar Price 12/30/2022 Serial Coupon 1.500% 1.500% 1,260,000.00 100.000% 1,260,000.00 12/30/2023 Serial Coupon 1.500% 1.500% 1,275,000.00 100.000% 1,275,000.00 12/30/2024 Serial Coupon 1.500% 1.500% 1,300,000.00 100.000% 1,300,000.00 12/30/2025 Serial Coupon 1.500% 1.500% 1,320,000.00 100.000% 1,320,000.00 Total ---$5,155,000.00 -$5,155,000.00 Bid Information Par Amount of Bonds $5,155,000.00 Gross Production $5,155,000.00 Bid (100.000%)5,155,000.00 Total Purchase Price $5,155,000.00 Bond Year Dollars $12,904.08 Average Life 2.503 Years Average Coupon 1.5000000% Net Interest Cost (NIC)1.5000000% True Interest Cost (TIC)1.5000368% 2022 Refunding PRLM $1M n | Issue Summary | 10/ 5/2021 | 4:39 PM Speer Financial, Inc. Page 4 Preliminary, As of October 5, 2021 United City of Yorkville, Kendall County, Illinois General Obligation Bonds (ARS), Series 2021 Dated: January 6, 2022 Refunding of 2011 Bonds / $1M New Money /Preliminary Proof of Bond Yield @ 1.5000368% Date Cashflow PV Factor Present Value Cumulative PV 01/06/2022 - 1.0000000x - - 06/30/2022 37,373.75 0.9928029x 37,104.77 37,104.77 12/30/2022 1,298,662.50 0.9854121x 1,279,717.78 1,316,822.54 06/30/2023 29,212.50 0.9780764x 28,572.06 1,345,394.60 12/30/2023 1,304,212.50 0.9707952x 1,266,123.28 2,611,517.88 06/30/2024 19,650.00 0.9635683x 18,934.12 2,630,451.99 12/30/2024 1,319,650.00 0.9563952x 1,262,106.86 3,892,558.86 06/30/2025 9,900.00 0.9492754x 9,397.83 3,901,956.68 12/30/2025 1,329,900.00 0.9422087x 1,253,043.32 5,155,000.00 Total $5,348,561.25 -$5,155,000.00 - Derivation Of Target Amount Par Amount of Bonds $5,155,000.00 Original Issue Proceeds $5,155,000.00 2022 Refunding PRLM $1M n | Issue Summary | 10/ 5/2021 | 4:39 PM Speer Financial, Inc. Page 5 Preliminary, As of October 5, 2021 United City of Yorkville, Kendall County, Illinois General Obligation Bonds (ARS), Series 2021 Dated: January 6, 2022 Refunding of 2011 Bonds Portion Debt Service Comparison Date Total P+I Net New D/S Old Net D/S Savings 12/30/2022 1,076,138.75 1,076,138.75 1,135,266.00 59,127.25 12/30/2023 1,071,950.00 1,071,950.00 1,134,178.00 62,228.00 12/30/2024 1,076,575.00 1,076,575.00 1,136,378.00 59,803.00 12/30/2025 1,075,900.00 1,075,900.00 1,136,652.00 60,752.00 Total $4,300,563.75 $4,300,563.75 $4,542,474.00 $241,910.25 PV Analysis Summary (Net to Net) Gross PV Debt Service Savings 232,078.32 Net PV Cashflow Savings @ 1.921%(AIC)232,078.32 Contingency or Rounding Amount 4,865.03 Net Present Value Benefit $236,943.35 Net PV Benefit / $4,095,000 Refunded Principal 5.786% Net PV Benefit / $4,145,000 Refunding Principal 5.716% Refunding Bond Information Refunding Dated Date 1/06/2022 Refunding Delivery Date 1/06/2022 2022 Refunding PRLM $1M n | Refunding of 2011 | 10/ 5/2021 | 4:39 PM Speer Financial, Inc. Page 6 Preliminary, As of October 5, 2021 United City of Yorkville, Kendall County, Illinois General Obligation Bonds (ARS), Series 2021 Dated: January 6, 2022 Refunding of 2011 Bonds Portion Debt Service Schedule Date Principal Coupon Interest Total P+I Fiscal Total 01/06/2022 - - - - - 06/30/2022 - - 30,051.25 30,051.25 - 12/30/2022 1,015,000.00 1.500% 31,087.50 1,046,087.50 1,076,138.75 06/30/2023 - - 23,475.00 23,475.00 - 12/30/2023 1,025,000.00 1.500% 23,475.00 1,048,475.00 1,071,950.00 06/30/2024 - - 15,787.50 15,787.50 - 12/30/2024 1,045,000.00 1.500% 15,787.50 1,060,787.50 1,076,575.00 06/30/2025 - - 7,950.00 7,950.00 - 12/30/2025 1,060,000.00 1.500% 7,950.00 1,067,950.00 1,075,900.00 Total $4,145,000.00 -$155,563.75 $4,300,563.75 - Yield Statistics Bond Year Dollars $10,370.92 Average Life 2.502 Years Average Coupon 1.5000000% Net Interest Cost (NIC)1.5000000% True Interest Cost (TIC)1.5000368% Bond Yield for Arbitrage Purposes 1.5000368% All Inclusive Cost (AIC)1.9208627% IRS Form 8038 Net Interest Cost 1.5000000% Weighted Average Maturity 2.502 Years 2022 Refunding PRLM $1M n | Refunding of 2011 | 10/ 5/2021 | 4:39 PM Speer Financial, Inc. Page 7 Preliminary, As of October 5, 2021 United City of Yorkville, Kendall County, Illinois General Obligation Bonds (ARS), Series 2021 Dated: January 6, 2022 Refunding of 2011 Bonds Portion Net Debt Service Schedule Date Principal Coupon Interest Total P+I Net New D/S 12/30/2022 1,015,000.00 1.500% 61,138.75 1,076,138.75 1,076,138.75 12/30/2023 1,025,000.00 1.500% 46,950.00 1,071,950.00 1,071,950.00 12/30/2024 1,045,000.00 1.500% 31,575.00 1,076,575.00 1,076,575.00 12/30/2025 1,060,000.00 1.500% 15,900.00 1,075,900.00 1,075,900.00 Total $4,145,000.00 -$155,563.75 $4,300,563.75 $4,300,563.75 2022 Refunding PRLM $1M n | Refunding of 2011 | 10/ 5/2021 | 4:39 PM Speer Financial, Inc. Page 8 Preliminary, As of October 5, 2021 United City of Yorkville, Kendall County, Illinois General Obligation Bonds (ARS), Series 2021 Dated: January 6, 2022 Refunding of 2011 Bonds Portion Current Refunding Escrow Date Rate Receipts Disbursements Cash Balance 01/06/2022 - 4,097,921.10 4,097,921.10 - Total -$4,097,921.10 $4,097,921.10 - Investment Parameters Investment Model [PV, GIC, or Securities]Securities Default investment yield target Unrestricted Cash Deposit 4,097,921.10 Total Cost of Investments $4,097,921.10 Target Cost of Investments at bond yield $4,097,921.10 Yield to Receipt - Yield for Arbitrage Purposes 1.5000368% 2022 Refunding PRLM $1M n | Refunding of 2011 | 10/ 5/2021 | 4:39 PM Speer Financial, Inc. Page 9 Preliminary, As of October 5, 2021 United City of Yorkville, Kendall County, Illinois Series 2011 - Refunds 2005D Except for 500 in 2011 Blc Review Debt Service To Maturity And To Call Date Refunded Bonds Refunded Interest D/S To Call Principal Coupon Interest Refunded D/S 01/06/2022 4,095,000.00 2,921.10 4,097,921.10 - - - - 06/30/2022 - - - - - 87,633.00 87,633.00 12/30/2022 - - - 960,000.00 4.280% 87,633.00 1,047,633.00 06/30/2023 - - - - - 67,089.00 67,089.00 12/30/2023 - - - 1,000,000.00 4.280% 67,089.00 1,067,089.00 06/30/2024 - - - - - 45,689.00 45,689.00 12/30/2024 - - - 1,045,000.00 4.280% 45,689.00 1,090,689.00 06/30/2025 - - - - - 23,326.00 23,326.00 12/30/2025 - - - 1,090,000.00 4.280% 23,326.00 1,113,326.00 Total $4,095,000.00 $2,921.10 $4,097,921.10 $4,095,000.00 -$447,474.00 $4,542,474.00 Yield Statistics Base date for Avg. Life & Avg. Coupon Calculation 1/06/2022 Average Life 2.536 Years Average Coupon 4.2800000% Weighted Average Maturity (Par Basis) 2.536 Years Weighted Average Maturity (Original Price Basis) 2.536 Years Refunding Bond Information Refunding Dated Date 1/06/2022 Refunding Delivery Date 1/06/2022 Ser 2011 FINAL | SINGLE PURPOSE | 10/ 5/2021 | 4:39 PM Speer Financial, Inc. Page 10 Preliminary, As of October 5, 2021 United City of Yorkville, Kendall County, Illinois General Obligation Bonds (ARS), Series 2021 Dated: January 6, 2022 $1M New Money Portion Debt Service Schedule Date Principal Coupon Interest Total P+I Fiscal Total 01/06/2022 - - - - - 06/30/2022 - - 7,322.50 7,322.50 - 12/30/2022 245,000.00 1.500% 7,575.00 252,575.00 259,897.50 06/30/2023 - - 5,737.50 5,737.50 - 12/30/2023 250,000.00 1.500% 5,737.50 255,737.50 261,475.00 06/30/2024 - - 3,862.50 3,862.50 - 12/30/2024 255,000.00 1.500% 3,862.50 258,862.50 262,725.00 06/30/2025 - - 1,950.00 1,950.00 - 12/30/2025 260,000.00 1.500% 1,950.00 261,950.00 263,900.00 Total $1,010,000.00 -$37,997.50 $1,047,997.50 - Yield Statistics Bond Year Dollars $2,533.17 Average Life 2.508 Years Average Coupon 1.5000000% Net Interest Cost (NIC)1.5000000% True Interest Cost (TIC)1.5000367% Bond Yield for Arbitrage Purposes 1.5000368% All Inclusive Cost (AIC)1.9198564% IRS Form 8038 Net Interest Cost 1.5000000% Weighted Average Maturity 2.508 Years 2022 Refunding PRLM $1M n | New Money | 10/ 5/2021 | 4:39 PM Speer Financial, Inc. Page 11 Preliminary, As of October 5, 2021 United City of Yorkville, Kendall County, Illinois General Obligation Bonds (ARS), Series 2021 Dated: January 6, 2022 $1M New Money Portion Net Debt Service Schedule Date Principal Coupon Interest Total P+I Net New D/S 12/30/2022 245,000.00 1.500% 14,897.50 259,897.50 259,897.50 12/30/2023 250,000.00 1.500% 11,475.00 261,475.00 261,475.00 12/30/2024 255,000.00 1.500% 7,725.00 262,725.00 262,725.00 12/30/2025 260,000.00 1.500% 3,900.00 263,900.00 263,900.00 Total $1,010,000.00 -$37,997.50 $1,047,997.50 $1,047,997.50 2022 Refunding PRLM $1M n | New Money | 10/ 5/2021 | 4:39 PM Speer Financial, Inc. Page 12 United City of Yorkville, Kendall County, Illinois General Obligation Bonds (ARS), Series 2021 Dated: January 6, 2022 Refunding of 2011 Bonds / $2M New Money /Preliminary Table of Contents Report ISSUE SUMMARY Total Issue Sources And Uses 1 Debt Service Schedule 2 Net Debt Service Schedule 3 Pricing Summary 4 Proof of Bond Yield @ 1.5000368%5 REFUNDING OF 2011 Debt Service Comparison 6 Debt Service Schedule 7 Net Debt Service Schedule 8 Current Refunding Escrow 9 Debt Service To Maturity And To Call 10 NEW MONEY Debt Service Schedule 11 Net Debt Service Schedule 12 2022 Refunding PRLM $2M n | Issue Summary | 10/ 5/2021 | 3:52 PM Speer Financial, Inc. Preliminary, As of October 5, 2021 United City of Yorkville, Kendall County, Illinois General Obligation Bonds (ARS), Series 2021 Dated: January 6, 2022 Refunding of 2011 Bonds / $2M New Money /Preliminary Total Issue Sources And Uses Dated 01/06/2022 | Delivered 01/06/2022 Refunding of 2011 New Money Issue Summary Sources Of Funds Par Amount of Bonds $4,140,000.00 $2,020,000.00 $6,160,000.00 Total Sources $4,140,000.00 $2,020,000.00 $6,160,000.00 Uses Of Funds Costs of Issuance 40,324.68 19,675.32 60,000.00 Deposit to Project Construction Fund - 2,000,000.00 2,000,000.00 Deposit to Current Refunding Fund 4,097,921.10 - 4,097,921.10 Rounding Amount 1,754.22 324.68 2,078.90 Total Uses $4,140,000.00 $2,020,000.00 $6,160,000.00 2022 Refunding PRLM $2M n | Issue Summary | 10/ 5/2021 | 3:52 PM Speer Financial, Inc. Page 1 Preliminary, As of October 5, 2021 United City of Yorkville, Kendall County, Illinois General Obligation Bonds (ARS), Series 2021 Dated: January 6, 2022 Refunding of 2011 Bonds / $2M New Money /Preliminary Debt Service Schedule Date Principal Coupon Interest Total P+I Fiscal Total 01/06/2022 - - - - - 06/30/2022 - - 44,660.00 44,660.00 - 12/30/2022 1,505,000.00 1.500% 46,200.00 1,551,200.00 1,595,860.00 06/30/2023 - - 34,912.50 34,912.50 - 12/30/2023 1,525,000.00 1.500% 34,912.50 1,559,912.50 1,594,825.00 06/30/2024 - - 23,475.00 23,475.00 - 12/30/2024 1,555,000.00 1.500% 23,475.00 1,578,475.00 1,601,950.00 06/30/2025 - - 11,812.50 11,812.50 - 12/30/2025 1,575,000.00 1.500% 11,812.50 1,586,812.50 1,598,625.00 Total $6,160,000.00 -$231,260.00 $6,391,260.00 - Yield Statistics Bond Year Dollars $15,417.33 Average Life 2.503 Years Average Coupon 1.5000000% Net Interest Cost (NIC)1.5000000% True Interest Cost (TIC)1.5000368% Bond Yield for Arbitrage Purposes 1.5000368% All Inclusive Cost (AIC)1.9022613% IRS Form 8038 Net Interest Cost 1.5000000% Weighted Average Maturity 2.503 Years 2022 Refunding PRLM $2M n | Issue Summary | 10/ 5/2021 | 3:52 PM Speer Financial, Inc. Page 2 Preliminary, As of October 5, 2021 United City of Yorkville, Kendall County, Illinois General Obligation Bonds (ARS), Series 2021 Dated: January 6, 2022 Refunding of 2011 Bonds / $2M New Money /Preliminary Net Debt Service Schedule Date Principal Coupon Interest Total P+I Net New D/S 12/30/2022 1,505,000.00 1.500% 90,860.00 1,595,860.00 1,595,860.00 12/30/2023 1,525,000.00 1.500% 69,825.00 1,594,825.00 1,594,825.00 12/30/2024 1,555,000.00 1.500% 46,950.00 1,601,950.00 1,601,950.00 12/30/2025 1,575,000.00 1.500% 23,625.00 1,598,625.00 1,598,625.00 Total $6,160,000.00 -$231,260.00 $6,391,260.00 $6,391,260.00 2022 Refunding PRLM $2M n | Issue Summary | 10/ 5/2021 | 3:52 PM Speer Financial, Inc. Page 3 Preliminary, As of October 5, 2021 United City of Yorkville, Kendall County, Illinois General Obligation Bonds (ARS), Series 2021 Dated: January 6, 2022 Refunding of 2011 Bonds / $2M New Money /Preliminary Pricing Summary Maturity Type of Bond Coupon Yield Maturity Value Price Dollar Price 12/30/2022 Serial Coupon 1.500% 1.500% 1,505,000.00 100.000% 1,505,000.00 12/30/2023 Serial Coupon 1.500% 1.500% 1,525,000.00 100.000% 1,525,000.00 12/30/2024 Serial Coupon 1.500% 1.500% 1,555,000.00 100.000% 1,555,000.00 12/30/2025 Serial Coupon 1.500% 1.500% 1,575,000.00 100.000% 1,575,000.00 Total ---$6,160,000.00 -$6,160,000.00 Bid Information Par Amount of Bonds $6,160,000.00 Gross Production $6,160,000.00 Bid (100.000%)6,160,000.00 Total Purchase Price $6,160,000.00 Bond Year Dollars $15,417.33 Average Life 2.503 Years Average Coupon 1.5000000% Net Interest Cost (NIC)1.5000000% True Interest Cost (TIC)1.5000368% 2022 Refunding PRLM $2M n | Issue Summary | 10/ 5/2021 | 3:52 PM Speer Financial, Inc. Page 4 Preliminary, As of October 5, 2021 United City of Yorkville, Kendall County, Illinois General Obligation Bonds (ARS), Series 2021 Dated: January 6, 2022 Refunding of 2011 Bonds / $2M New Money /Preliminary Proof of Bond Yield @ 1.5000368% Date Cashflow PV Factor Present Value Cumulative PV 01/06/2022 - 1.0000000x - - 06/30/2022 44,660.00 0.9928029x 44,338.58 44,338.58 12/30/2022 1,551,200.00 0.9854121x 1,528,571.29 1,572,909.87 06/30/2023 34,912.50 0.9780764x 34,147.09 1,607,056.96 12/30/2023 1,559,912.50 0.9707952x 1,514,355.62 3,121,412.58 06/30/2024 23,475.00 0.9635683x 22,619.77 3,144,032.34 12/30/2024 1,578,475.00 0.9563952x 1,509,645.84 4,653,678.18 06/30/2025 11,812.50 0.9492754x 11,213.32 4,664,891.50 12/30/2025 1,586,812.50 0.9422087x 1,495,108.50 6,160,000.00 Total $6,391,260.00 -$6,160,000.00 - Derivation Of Target Amount Par Amount of Bonds $6,160,000.00 Original Issue Proceeds $6,160,000.00 2022 Refunding PRLM $2M n | Issue Summary | 10/ 5/2021 | 3:52 PM Speer Financial, Inc. Page 5 Preliminary, As of October 5, 2021 United City of Yorkville, Kendall County, Illinois General Obligation Bonds (ARS), Series 2021 Dated: January 6, 2022 Refunding of 2011 Bonds Portion Debt Service Comparison Date Total P+I Net New D/S Old Net D/S Savings 12/30/2022 1,071,065.00 1,071,065.00 1,135,266.00 64,201.00 12/30/2023 1,071,950.00 1,071,950.00 1,134,178.00 62,228.00 12/30/2024 1,076,575.00 1,076,575.00 1,136,378.00 59,803.00 12/30/2025 1,075,900.00 1,075,900.00 1,136,652.00 60,752.00 Total $4,295,490.00 $4,295,490.00 $4,542,474.00 $246,984.00 PV Analysis Summary (Net to Net) Gross PV Debt Service Savings 237,151.84 Net PV Cashflow Savings @ 1.902%(AIC)237,151.84 Contingency or Rounding Amount 1,754.22 Net Present Value Benefit $238,906.06 Net PV Benefit / $4,095,000 Refunded Principal 5.834% Net PV Benefit / $4,140,000 Refunding Principal 5.771% Refunding Bond Information Refunding Dated Date 1/06/2022 Refunding Delivery Date 1/06/2022 2022 Refunding PRLM $2M n | Refunding of 2011 | 10/ 5/2021 | 3:52 PM Speer Financial, Inc. Page 6 Preliminary, As of October 5, 2021 United City of Yorkville, Kendall County, Illinois General Obligation Bonds (ARS), Series 2021 Dated: January 6, 2022 Refunding of 2011 Bonds Portion Debt Service Schedule Date Principal Coupon Interest Total P+I Fiscal Total 01/06/2022 - - - - - 06/30/2022 - - 30,015.00 30,015.00 - 12/30/2022 1,010,000.00 1.500% 31,050.00 1,041,050.00 1,071,065.00 06/30/2023 - - 23,475.00 23,475.00 - 12/30/2023 1,025,000.00 1.500% 23,475.00 1,048,475.00 1,071,950.00 06/30/2024 - - 15,787.50 15,787.50 - 12/30/2024 1,045,000.00 1.500% 15,787.50 1,060,787.50 1,076,575.00 06/30/2025 - - 7,950.00 7,950.00 - 12/30/2025 1,060,000.00 1.500% 7,950.00 1,067,950.00 1,075,900.00 Total $4,140,000.00 -$155,490.00 $4,295,490.00 - Yield Statistics Bond Year Dollars $10,366.00 Average Life 2.504 Years Average Coupon 1.5000000% Net Interest Cost (NIC)1.5000000% True Interest Cost (TIC)1.5000368% Bond Yield for Arbitrage Purposes 1.5000368% All Inclusive Cost (AIC)1.9020945% IRS Form 8038 Net Interest Cost 1.5000000% Weighted Average Maturity 2.504 Years 2022 Refunding PRLM $2M n | Refunding of 2011 | 10/ 5/2021 | 3:52 PM Speer Financial, Inc. Page 7 Preliminary, As of October 5, 2021 United City of Yorkville, Kendall County, Illinois General Obligation Bonds (ARS), Series 2021 Dated: January 6, 2022 Refunding of 2011 Bonds Portion Net Debt Service Schedule Date Principal Coupon Interest Total P+I Net New D/S 12/30/2022 1,010,000.00 1.500% 61,065.00 1,071,065.00 1,071,065.00 12/30/2023 1,025,000.00 1.500% 46,950.00 1,071,950.00 1,071,950.00 12/30/2024 1,045,000.00 1.500% 31,575.00 1,076,575.00 1,076,575.00 12/30/2025 1,060,000.00 1.500% 15,900.00 1,075,900.00 1,075,900.00 Total $4,140,000.00 -$155,490.00 $4,295,490.00 $4,295,490.00 2022 Refunding PRLM $2M n | Refunding of 2011 | 10/ 5/2021 | 3:52 PM Speer Financial, Inc. Page 8 Preliminary, As of October 5, 2021 United City of Yorkville, Kendall County, Illinois General Obligation Bonds (ARS), Series 2021 Dated: January 6, 2022 Refunding of 2011 Bonds Portion Current Refunding Escrow Date Rate Receipts Disbursements Cash Balance 01/06/2022 - 4,097,921.10 4,097,921.10 - Total -$4,097,921.10 $4,097,921.10 - Investment Parameters Investment Model [PV, GIC, or Securities]Securities Default investment yield target Unrestricted Cash Deposit 4,097,921.10 Total Cost of Investments $4,097,921.10 Target Cost of Investments at bond yield $4,097,921.10 Yield to Receipt - Yield for Arbitrage Purposes 1.5000368% 2022 Refunding PRLM $2M n | Refunding of 2011 | 10/ 5/2021 | 3:52 PM Speer Financial, Inc. Page 9 Preliminary, As of October 5, 2021 United City of Yorkville, Kendall County, Illinois Series 2011 - Refunds 2005D Except for 500 in 2011 Blc Review Debt Service To Maturity And To Call Date Refunded Bonds Refunded Interest D/S To Call Principal Coupon Interest Refunded D/S 01/06/2022 4,095,000.00 2,921.10 4,097,921.10 - - - - 06/30/2022 - - - - - 87,633.00 87,633.00 12/30/2022 - - - 960,000.00 4.280% 87,633.00 1,047,633.00 06/30/2023 - - - - - 67,089.00 67,089.00 12/30/2023 - - - 1,000,000.00 4.280% 67,089.00 1,067,089.00 06/30/2024 - - - - - 45,689.00 45,689.00 12/30/2024 - - - 1,045,000.00 4.280% 45,689.00 1,090,689.00 06/30/2025 - - - - - 23,326.00 23,326.00 12/30/2025 - - - 1,090,000.00 4.280% 23,326.00 1,113,326.00 Total $4,095,000.00 $2,921.10 $4,097,921.10 $4,095,000.00 -$447,474.00 $4,542,474.00 Yield Statistics Base date for Avg. Life & Avg. Coupon Calculation 1/06/2022 Average Life 2.536 Years Average Coupon 4.2800000% Weighted Average Maturity (Par Basis) 2.536 Years Weighted Average Maturity (Original Price Basis) 2.536 Years Refunding Bond Information Refunding Dated Date 1/06/2022 Refunding Delivery Date 1/06/2022 Ser 2011 FINAL | SINGLE PURPOSE | 10/ 5/2021 | 3:52 PM Speer Financial, Inc. Page 10 Preliminary, As of October 5, 2021 United City of Yorkville, Kendall County, Illinois General Obligation Bonds (ARS), Series 2021 Dated: January 6, 2022 $2M New Money Portion Debt Service Schedule Date Principal Coupon Interest Total P+I Fiscal Total 01/06/2022 - - - - - 06/30/2022 - - 14,645.00 14,645.00 - 12/30/2022 495,000.00 1.500% 15,150.00 510,150.00 524,795.00 06/30/2023 - - 11,437.50 11,437.50 - 12/30/2023 500,000.00 1.500% 11,437.50 511,437.50 522,875.00 06/30/2024 - - 7,687.50 7,687.50 - 12/30/2024 510,000.00 1.500% 7,687.50 517,687.50 525,375.00 06/30/2025 - - 3,862.50 3,862.50 - 12/30/2025 515,000.00 1.500% 3,862.50 518,862.50 522,725.00 Total $2,020,000.00 -$75,770.00 $2,095,770.00 - Yield Statistics Bond Year Dollars $5,051.33 Average Life 2.501 Years Average Coupon 1.5000000% Net Interest Cost (NIC)1.5000000% True Interest Cost (TIC)1.5000368% Bond Yield for Arbitrage Purposes 1.5000368% All Inclusive Cost (AIC)1.9026036% IRS Form 8038 Net Interest Cost 1.5000000% Weighted Average Maturity 2.501 Years 2022 Refunding PRLM $2M n | New Money | 10/ 5/2021 | 3:52 PM Speer Financial, Inc. Page 11 Preliminary, As of October 5, 2021 United City of Yorkville, Kendall County, Illinois General Obligation Bonds (ARS), Series 2021 Dated: January 6, 2022 $2M New Money Portion Net Debt Service Schedule Date Principal Coupon Interest Total P+I Net New D/S 12/30/2022 495,000.00 1.500% 29,795.00 524,795.00 524,795.00 12/30/2023 500,000.00 1.500% 22,875.00 522,875.00 522,875.00 12/30/2024 510,000.00 1.500% 15,375.00 525,375.00 525,375.00 12/30/2025 515,000.00 1.500% 7,725.00 522,725.00 522,725.00 Total $2,020,000.00 -$75,770.00 $2,095,770.00 $2,095,770.00 2022 Refunding PRLM $2M n | New Money | 10/ 5/2021 | 3:52 PM Speer Financial, Inc. Page 12 Speer Financial, Inc. INDEPENDENT MUNICIPAL ADVISORS ESTABLISHED 1954 SUITE 2630 ● 230 WEST MONROE STREET ● CHICAGO, ILLINOIS 60606 ● (312) 346-3700 ● FAX (312) 346-8833 All City Council Events or Actions are Highlighted in BLUE All Publication Events Highlighted in GRAY     UNITED CITY OF YORKVILLE, ILLINOIS General Obligation Bonds (Alternate Revenue Source), Series 2021 Preliminary Timetable (September 1, 2021) Task Party Responsible Date Distribute Draft POS Speer Week of October 11 Adoption of Authorizing City October 26 Ordinance Publish Authorizing City Week of October 26 Ordinance and Notice of BINA Hearing Begin 30-Day Backdoor Referendum Period Distribute Rating Package Speer Week of October 11 Comments received on draft All Parties Week of November 1 POS Bond Issue Notification Act City November 9 (BINA) Hearing Rating Call City and Speer Week of November 8 Receive Bond Rating City and Speer Week of November 15 Distribute Bond Bond Counsel Week of November 22 Ordinance Finalize and Print POS Speer November 30 Bond Sale All Parities December 14 Bond Ordinance Adopted City December 14 Bond Closing All Parties January 6 Have a question or comment about this agenda item? Call us Monday-Friday, 8:00am to 4:30pm at 630-553-4350, email us at agendas@yorkville.il.us, post at www.facebook.com/CityofYorkville, tweet us at @CityofYorkville, and/or contact any of your elected officials at http://www.yorkville.il.us/320/City-Council Agenda Item Summary Memo Title: Meeting and Date: Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Agenda Item Notes: Reviewed By: Legal Finance Engineer City Administrator Community Development Purchasing Police Public Works Parks and Recreation Agenda Item Number Mayor’s Report #2 Tracking Number CC 2021-04 City Buildings Updates City Council – October 12, 2021 A verbal discussion will take place at the meeting. Bart Olson Administration Name Department Have a question or comment about this agenda item? Call us Monday-Friday, 8:00am to 4:30pm at 630-553-4350, email us at agendas@yorkville.il.us, post at www.facebook.com/CityofYorkville, tweet us at @CityofYorkville, and/or contact any of your elected officials at http://www.yorkville.il.us/320/City-Council Agenda Item Summary Memo Title: Meeting and Date: Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Agenda Item Notes: Reviewed By: Legal Finance Engineer City Administrator Community Development Purchasing Police Public Works Parks and Recreation Agenda Item Number Mayor’s Report #3 Tracking Number CC 2021-38 Water Study Update City Council – October 12, 2021 A verbal discussion will take place at the meeting. Bart Olson Administration Name Department