Joint Review Board

AGENDA JOINT REVIEW BOARD MEETING JANUARY 28, 2022 1:00 P.M. DeKalb Police Department 700 W. Lincoln Highway 2nd Floor Training Room DeKalb, Illinois A. CALL TO ORDER B. ROLL CALL City of DeKalb – Bill Nicklas* DeKalb Community Unit School District #428 – Cindy Carpenter* DeKalb County – Brian Gregory* DeKalb County Forest Preserve – Terry Hannan DeKalb Park District – John Shea* DeKalb Public Library – Emily Faulkner DeKalb Township – Mary Hess* DeKalb Township Road and Bridge District – Craig Smith Kishwaukee College #523 – Bob Johnson* Kishwaukee Water Reclamation District – Mark Eddington Public Member – Larry Berke* C. APPROVAL OF THE AGENDA D. APPOINTMENT OF THE PERMANENT CHAIR E. APPROVAL OF MINUTES 1. Minutes of the Joint Review Board Meeting of October 22, 2021. F. PUBLIC PARTICIPATION G. PRESENTATION OF THE FOURTH QUARTER FY2021 TIF FINANCIALS H. UPDATE ON CURRENT TIF PROJECTS I. NEXT MEETING: APRIL 22, 2022 J. ADJOURNMENT *Voting Members of the Joint Review Board TO: DeKalb Community Unit School District #428—Cindy Carpenter* DeKalb County – Brian Gregory* DeKalb County Forest Preserve – Terry Hannan DeKalb Park District – John Shea* DeKalb Public Library – Emily Faulkner DeKalb Township – Mary Hess* DeKalb Township Road and Bridge District – Craig Smith Kishwaukee College – Bob Johnson* Kishwaukee Water Reclamation District – Mark Eddington Public Member – Larry Berke* FROM: Bill Nicklas, City Manager* DATE: January 10, 2022 RE: Background Notes for the January 28, 2022, Agenda The following notes provide background for the items on the published JRB agenda. Approval of Minutes. The minutes from the October 21, 2021, JRB meeting are attached for the Board’s review and approval. Presentation of Fourth Quarter, FY2021 TIF Financials. The following reports are attached for the Board’s review:  Combined TIF Project Tracker as of December 31, 2021. Over the December holidays and the first week in January, the COVID omicron variant settled heavily on DeKalb’s finance department. In the event that some end-of-year entries were not made in time for the mailing of this agenda, final year-end financials for the TIF #1 and TIF #3 Funds will be forwarded later.  TIF #1 and TIF #3 Income Statement Summaries and Revenue and Expenditure Reports.  Approved FY2022 Budget for Fund 260 (TIF 1) & Fund 262 (TIF 3). TIF #3 Project Summaries. 1. Architectural Improvement Program (AIP) Summary Property owners whose properties fall within the TIF #3 district boundaries may apply for limited incentives up to a maximum of $25,000 based on a three-tiered list of reimbursable expenses. The tiers are shown on the following page: * Indicates voting membership  Major Capital Improvements – 50% Reimbursement: ADA Compliance Façade Renovations Life Safety Equipment Electrical, Mechanical, and Architectural Design Fees Restoration of Historic Plumbing Upgrades Architectural Features Fire Alarm and Suppression Tuckpointing Systems Minor Capital Improvements – 25% Reimbursement: Exterior Lighting Exterior Painting Window & Door Replacement Screening of Unsightly Utilities Deferred Maintenance – 10% Reimbursement: Roof Repair or Replacement Gutter Replacement Stair and Handrail Replacement Floor Surface Repair Water Damage Repair According to the terms of the AIP program, the City “forgives” 20% of the value of the matching funds each year for five years. In FY2021, the AIP budget allocated $70,000 for 5 qualified projects on a first-come, first-served basis. Chris Brundies is the owner of AccuLab, which acquired the former Camelot training center (and, originally, the Farm Bureau building) at 310 N. Fifth Street and 509 Oak Street in DeKalb. The property had been vacant for a number of years, and Mr. Brundies has converted the space to accommodate his expanding business, which grinds optical lenses for world-wide distribution. Among the extensive tasks before Mr. Brundies were substantial new plumbing systems, electrical systems, mechanical upgrades, an enhanced fire protection system, and window/door replacements. The private rehabilitation was estimated to exceed $1.1 million. Although the AIP program grants are limited to $25,000, Mr. Brundies was grateful for the City support for his productive reinvestment. Plumbing repairs were eligible for a 50% reimbursement. Since both of the several plumbing contractor quotes submitted by Mr. Brundies exceeded $50,000, he applied for the maximum reimbursement of $25,000 for the plumbing work in his building, and the Council supported his request on October 11. 2. Major Project Summaries The attached “Project Tracking” schedule provides financial detail on all outstanding projects. Some highlights are reported below:  Agora Tower. The Project’s developer, John Pappas, and general contractor, Weaver Construction, were able to install exterior windows and doors and get the four-story building under roof in mid-December because of the unseasonably mild weather. As a result, interior work can continue through the winter and early spring of 2022. The project completion remains likely in the fall of 2022. Thus far, $1,962,583 of the $3,000,000 TIF allocation has been disbursed (see attached Project Tracking form). This project funding was approved in September 2019 and is supported by the TIF #3 Fund. Page |2  Fire Station #1. This $181,554 project is complete. It was the last TIF #1 major rehab project and included the replacement of the “Plymovent” exhaust system for vehicles in Station #1 (N. Seventh Street), as well as HVAC and plumbing repairs. The outstanding balance is $0.00.  IL Rt. 38 Reconfiguration. This TIF #3 project is still awaiting final IDOT approval. The reconfiguration will reduce the four-lane downtown section of IL Rt. 38 between First and Fourth Streets to three lanes (with a center turn lane). This will widen the downtown sidewalks by about 5-6 feet on both the north and south sides, allowing for a more pedestrian-friendly streetscape and mitigating the truck “raceway” through the heart of DeKalb’s downtown. The wider sidewalks will afford more room for sidewalk sales, outdoor seating, and more leisurely enjoyment of the downtown businesses. To date, the City has received conceptual approval, has addressed the IDOT requirement for a parallel bike path by committing to such a pathway on Grove Street, and has addressed various IDOT technical suggestions for turn radii, etc. The City also made some design changes to address IDOT’s concern about impacts on the Union Pacific’s Fourth Street rail crossing. Having run out of construction-friendly weather, the City hopes to get IDOT approval in the January-February 2022 period so work can begin in the late spring and be comfortably completed before Corn Fest in late August. The FY22 Budget allocates $1,250,000 for this carryover project.  DeKalb Taylor Airport. The re-paving of the newer north/south runway (Runway 2/20) and associated taxiways had been on the State/Federal Transportation Improvement Plan for over five years and was finally funded in the spring of 2021. The higher governmental partners (FAA and IDOT’s Division of Aeronautics) controlled the bidding which was not completed until mid-summer. The milling and paving (less striping) was completed during the week of October 4 and the project was complete by mid-November. For the last two weeks in September through the re-opening on October 8, both runways were closed because of the “crossover” of the runways at the east end of the Airport field. This naturally cut into fuel sales and involved rent credits to hangar tenants, but the new surfaces should enhance the appeal of the airport for business and recreational pilots. No final TIF #1 outlay is expected because of federal COVID grant support.  223 S. Fourth Street: City Hall Suites. This TIF #3 redevelopment project will be an “earner.” The one-block area has been off the tax rolls since the late 1960s so once the property is occupied all of the assessed valuation will count toward the calculation of the increment. The former city hall has been razed, the excavator has crushed and removed much of the masonry debris for recycling (except what will be used on the site). Pappas Development and its general contractor has also replaced old water and sewer mains as well as electrical and natural gas services. To date, $502,846 of the $750,000 grant has been allocated. Page |3  MINUTES CITY OF DEKALB JOINT REVIEW BOARD MEETING OCTOBER 22, 2021 The Joint Review Board (JRB) of the City of DeKalb, Illinois, convened on October 22, 2021, at 1:00 p.m. at the DeKalb Police Department, located at 700 W. Lincoln Highway, DeKalb, Illinois. A. CALL TO ORDER Assistant to the City Manager Josh Boldt called the meeting to order at 1:02 p.m. B. ROLL CALL Executive Assistant Ruth Scott called the roll, and the following members of the JRB were present:  City of DeKalb – Bill Nicklas*  DeKalb County – Brian Gregory*  DeKalb Park District – John Shea*  Kishwaukee College – Jill Hansen*  Public Member – Larry Berke* The following members of the JRB were absent:  DeKalb Community Unit School District #428 – Cindy Carpenter*  DeKalb Township – Mary Hess*  Kishwaukee Water Reclamation District – Mark Eddington  DeKalb Public Library – Emily Faulkner  DeKalb Township Road and Bridge District – Craig Smith  DeKalb County Forest Preserve – Terry Hannan Others present included City Attorney Matt Rose. C. APPROVAL OF THE AGENDA MOTION: Mr. Gregory moved to approve the agenda; seconded by Mr. Berke. VOTE: Motioned passed by a voice vote of the majority of members present. D. APPOINTMENT OF THE PERMANENT CHAIR This item was not discussed and will be brought forward at the January 28, 2022, JRB meeting. E. APPROVAL OF THE MINUTES 1. Minutes of the Joint Review Board meeting of July 9, 2021. MOTION: Mr. Berke moved to approve the minutes; seconded by Mr. Gregory. VOTE: Motioned passed by a voice vote of the majority of members present. Joint Review Board Meeting Minutes October 22, 2021 Page 2 of 3 F. PUBLIC PARTICIPATION There was none. G. PRESENTATION OF THE THIRD QUARTER FY2021 TAX INCREMENT FINANCING (TIF) FINANCIALS Mr. Boldt provided an overview of this item based on the information provided in the agenda packet, which included a combined TIF project tracker as of October 6, 2021, a TIF #1 income statement summary, a TIF #3 income statement summary, a Council approved FY2021 budget for Fund 260 (Central Area TIF) and Fund 262 (TIF #3), and a revenue and expenditure report for the Central Area TIF and TIF #3. H. UPDATE ON CURRENT TIF PROJECTS Mr. Boldt provided an overview of TIF #3 projects from 2021, which included Architectural Improvement Program (AIP) projects at the Egyptian Theatre, the Hillside Restaurant, 115 N. 1st Street, Hickey’s Corner Store, 201-203 E. Locust Street, 151 N. 4th Street. A new project, AccuLab at 509 Oak Street, was approved by the City Council on October 11. The overview also contained major TIF #3 projects, including Agora Tower, Fire Station #1, the Illinois Route 38 (Lincoln Highway) reconfiguration, DeKalb Taylor Municipal Airport (DTMA), and City Hall Suites on S. Fourth Street. Mr. Berke stated that he lives in the downtown area and all these projects are good things. Mr. Boldt added that a lot of college students are moving into the downtown area. Mr. Nicklas spoke briefly regarding the DTMA projects, noting that a majority was done from TIF #1. Now that that TIF #1 is being terminated, work done at the DTMA will have to come out of general capital dollars. Mr. Gregory asked about the solar project at the DTMA and if it was TIF 1. Mr. Nicklas replied that it was. Mr. Gregory then asked about the Lincoln Highway reconfiguration. Mr. Nicklas explained it will go from four lanes to three from First Street to Fourth Street. I. TIF #1 TERMINATION Mr. Nicklas stated that letters have been sent to each taxing body regarding this item. The City Council will be voting on the termination of TIF #1 at their next meeting. City Attorney Rose briefly explained the process following the termination. Continuing, Mr. Nicklas stated the fund will be carried through 2022 with a small reserve for open appeals. He also indicated that the taxing districts may be getting another small surplus payment. J. NEXT MEETING The next meeting of the JRB will be scheduled for January 28, 2022.  Joint Review Board Meeting Minutes October 22, 2021 Page 3 of 3 K. ADJOURNMENT MOTION: Mr. Berke moved to adjourn the meeting; seconded by Mr. Gregory. VOTE: Motion carried by a voice vote of the majority of members present. The meeting adjourned at 1:22 p.m. Respectfully submitted, __________________________________ Ruth A. Scott, Executive Assistant 01/04/2022 05:06 PM REVENUE AND EXPENDITURE REPORT FOR CITY OF DEKALB Page: 1/5 User: CARRIE.DITTMA Balances as of 12/31/2021 DB: Dekalb Fund 260 - TIF FUND #1 (CENTRAL AREA) 2021 YEAR-TO-DATE Available % Account Description Amended Budget THRU 12/31/21 Balance Used Revenues Department 00-00: GENERAL 30300 PROPERTY TAX - TIF 05/28/2021 CR PROPERTY TAX REVENUE 05/28/2021 87110 829,326.28 PROPERTY TAX REVENUE 05/28/2021 06/28/2021 CR PROPERTY TAX REVENUE 06/28/2021 88216 2,998,178.47 PROPERTY TAX REVENUE 06/28/2021 07/23/2021 CR PROPERTY TAX REVENUE 07/23/2021 90041 96,484.52 PROPERTY TAX REVENUE 07/23/2021 08/20/2021 CR PROPERTY TAX REVENUE 08/20/2021 91798 125,559.20 PROPERTY TAX REVENUE 08/20/2021 09/17/2021 CR PROPERTY TAX REVENUE 09/17/2021 92887 2,548,435.15 PROPERTY TAX REVENUE 09/17/2021 09/17/2021 GJ CORRECT TIF #3 TAX PAYMENT - DISTR #5 93136 (186,177.14) JE# 3213 11/24/2021 CR PROPERTY TAX REVENUE 11/24/2021 98130 315,451.47 PROPERTY TAX REVENUE 11/24/2021 30300 PROPERTY TAX - TIF 7,050,000.00 6,727,257.95 322,742.05 95.42 37100 INVESTMENT INTEREST 01/31/2021 GJ INTEREST JAN 2021 82136 118.81 JE# 2759 02/28/2021 GJ INTEREST FEB 2021 82137 96.26 JE# 2760 03/31/2021 GJ INTEREST MARCH 2021 88910 82.88 JE# 3069 04/30/2021 GJ INTEREST APR 2021 85847 14.47 JE# 2967 04/30/2021 GJ INTEREST APR 2021 85847 54.47 JE# 2967 05/31/2021 GJ INTEREST MAY 2021 88157 49.01 JE# 3045 06/30/2021 GJ INTEREST - JUNE 2021 89493 31.60 JE# 3082 06/30/2021 GJ INTEREST - JUNE 2021 89493 54.89 JE# 3082 07/31/2021 GJ JULY 2021 FNB TIF INTEREST ALLOCATION 90965 23.87 JE# 3136 07/31/2021 GJ JULY 21 IL FUNDS TIF INTEREST ALLOCATION 90966 28.06 JE# 3137 08/31/2021 GJ AUG 2021 TIF INTEREST ALLOCATION 93148 35.63 JE# 3210 09/30/2021 GJ ILTIF INTEREST ALLOCATION - SEPT 2021 94181 27.30 JE# 3245 09/30/2021 GJ TIF INTEREST ALLOCATION - SEPT 2021 94182 91.66 JE# 3246 10/31/2021 GJ ILTIF INTEREST ALLOCATION - OCT 2021 96810 35.30 JE# 3270 10/31/2021 GJ TIF INTEREST ALLOCATION - OCT 2021 96811 102.14 JE# 3271 11/30/2021 GJ TIF INTEREST ALLOCATION - NOV 2021 99176 99.59 JE# 3321 11/30/2021 GJ ILTIF INTEREST - NOV 2021 99177 37.57 JE# 3322 37100 INVESTMENT INTEREST 50,000.00 983.51 49,016.49 1.97 37500 GAIN/LOSS ON INVESTMENTS 09/15/2021 CR REFUNDS/REIMBURSEMENTS 09/15/2021 92709 13,104.24 REFUNDS/REIMBURSEMENTS 09/15/2021 37500 GAIN/LOSS ON INVESTMENTS 0.00 13,104.24 (13,104.24) 100.00 Total - Dept 00-00 7,100,000.00 6,741,345.70 358,654.30 94.95 Total Revenues 7,100,000.00 6,741,345.70 358,654.30 94.95 Expenditures Department 00-00: GENERAL 62100 FINANCIAL SERVICES 03/02/2021 AP FY2020 SIKICH AUDIT FEES 83358 325.00 Inv #: '485615' Vendor '000943' 03/03/2021 AP FY2020 SIKICH EXTERNAL AUDIT FEES 83359 100.00 Inv #: '490170' Vendor '000943' 05/20/2021 AP FY2020 SIKICH EXTERNAL AUDIT FEES 87741 615.90 Inv #: '506050-1' Vendor '000943' 05/20/2021 AP FY2020 SIKICH EXTERNAL AUDIT FEES 87741 12,990.00 Inv #: '506050-1' Vendor '000943' 06/07/2021 AP FY2020 SIKICH EXTERNAL AUDIT FEES 89208 350.00 Inv #: '514441' Vendor '000943' 62100 FINANCIAL SERVICES 10,000.00 14,380.90 (4,380.90) 143.81 63800 CONTRACTED SERVICES 03/09/2021 AP LEASE - LINCOLN/3RD 10-20-20/10-19-21 83384 5,760.26 Inv #: '308975059' Vendor '001070' 01/04/2022 05:06 PM REVENUE AND EXPENDITURE REPORT FOR CITY OF DEKALB Page: 2/5 User: CARRIE.DITTMA Balances as of 12/31/2021 DB: Dekalb Fund 260 - TIF FUND #1 (CENTRAL AREA) 2021 YEAR-TO-DATE Available % Account Description Amended Budget THRU 12/31/21 Balance Used Expenditures Department 00-00: GENERAL 11/22/2021 AP 10/20/21-10/19/22 LAND LEASE - LINCOLN/3 97724 5,933.07 Inv #: '11222021' Vendor '001070' 63800 CONTRACTED SERVICES 0.00 11,693.33 (11,693.33) 100.00 65300 LEGAL EXPENSES & NOTICES 12/21/2021 AP TIF 2 FINAL PTAB & ERROR CERTIFICATES 99654 1,912.46 Inv #: '12212021' Vendor '000264' 65300 LEGAL EXPENSES & NOTICES 0.00 1,912.46 (1,912.46) 100.00 68600 TIF SURPLUS DISTRIBUTION 01/01/2021 GJ 2020 INVOICE - TIF 1-022521 RUN IN 2021 82940 (307,301.90) JE# 2826 02/26/2021 AP FY2020 TIF 1 SURPLUS STATE PORTION 81870 307,301.90 Inv #: 'TIF1-022521' Vendor '000533' 12/21/2021 AP FY2021 DECLARED TIF 1 SURPLUS 99655 3,063,297.57 Inv #: '12212021' Vendor '000278' 12/21/2021 AP FY2021 DECLARED TIF 1 SURPLUS - STATE SH 99738 300,331.43 Inv #: '12212021' Vendor '000533' 68600 TIF SURPLUS DISTRIBUTION 3,525,000.00 3,363,629.00 161,371.00 95.42 69199 PRIV PROP REHAB / REDEVELOP 01/15/2021 AP ESCROW DEPOSIT LOVELLS FINAL TIF INCENTI 79173 20,000.00 Inv #: '2018-095' Vendor '002412' 01/15/2021 GJ RECLASS AMERICAN TITLE GUARANTY INV-FY20 82957 (20,000.00) JE# 2835 69199 PRIV PROP REHAB / REDEVELOP 0.00 0.00 0.00 100.00 82000 BUILDINGS & IMPROVEMENTS 01/15/2021 AP CUT IN VIEWING WINDOW 79422 790.00 Inv #: '21.AIRPORT.205' Vendor '000934' 03/04/2021 AP AP LED UPGRADE PROJECT 83347 801.20 Inv #: '607' Vendor '172111' 03/04/2021 AP AP LED UPGRADE PROJECT 83348 240.00 Inv #: '640' Vendor '172111' 03/05/2021 AP TILE 84699 1,596.66 Inv #: '021621' Vendor '172163' 03/10/2021 AP POLY ASPARTIC REPLACEMENT FLOORING FOR 3 83266 14,445.00 Inv #: '136' Vendor '172140' 03/19/2021 AP PAINT-AIRPORT 84487 250.89 Inv #: '0352-6' Vendor '000936' 03/19/2021 AP LABOR TO INSTALL STONE TILES ON AIRPORT 84486 9,251.00 Inv #: '21.3232.213' Vendor '000934' 03/19/2021 AP PAINT-AIRPORT 84488 731.40 Inv #: '8859-0' Vendor '000936' 04/01/2021 AP DUMPSTER RENTAL-2/1/21-3/19/21 85288 250.00 Inv #: '481' Vendor '001245' 04/01/2021 AP PAINT 84489 53.40 Inv #: '9353-3' Vendor '000936' 04/01/2021 AP REPLACEMENT CARPETING FOR FBO OFFICES, C 85189 8,520.00 Inv #: 'D17078' Vendor '000299' 04/01/2021 AP EXTRAS FOR CARPET REPLACEMENT 85190 412.00 Inv #: 'D17079' Vendor '000299' 04/05/2021 AP REPAINT MAIN TERMINAL FBO FIRST, SECOND 85103 16,375.00 Inv #: '358' Vendor '002484' 05/04/2021 AP PLYMOVENT SYSTEM RENOVATION-TRACKS/HOSES 85564 41,078.53 Inv #: 'O74148' Vendor '000469' 05/06/2021 AP MISC ELECTRICAL PARTS 87589 194.13 Inv #: '194448' Vendor '000655' 05/06/2021 AP RETURN-TILE 87565 (152.49) Inv #: '2FJ59E062806434' Vendor '172163' 05/28/2021 AP APPLY 1 COAT OF LEAD BLOCKER-AP HANGAR 87632 1,905.00 Inv #: '360' Vendor '002484' 06/03/2021 AP REMOVE/REPLACE FBO 1ST/2ND FLOOR WINDOWS 87633 17,150.00 Inv #: '62427' Vendor '000149' 07/14/2021 AP SERVICE CALL-FBO 89970 241.82 Inv #: '61021-11' Vendor '000701' 07/16/2021 AP AIRPORT WINDOWS 89963 49.45 Inv #: '03285' Vendor '000655' 07/16/2021 AP AIRPORT WINDOWS 89959 33.59 Inv #: '03334' Vendor '000655' 07/16/2021 AP AIRPORT WINDOWS 89962 16.60 Inv #: '03386' Vendor '000655' 07/16/2021 AP AIRPORT WINDOWS 89958 97.72 Inv #: '03530A' Vendor '000655' 07/16/2021 AP AIRPORT WINDOWS 89960 54.68 Inv #: '03651' Vendor '000655' 07/16/2021 AP CREDIT-AIRPORT WINDOWS 89961 (50.77) Inv #: '16520' Vendor '000655' 07/29/2021 AP TUCKPOINT/REPAIRS 90701 4,977.00 Inv #: '21-9322' Vendor '001115' 09/01/2021 AP FIRE STATION 1 RENOVATIONS 91848 10,472.40 Inv #: '09.01.21' Vendor '172100' 09/22/2021 AP FURNISH AND INSTALL GLASS, GLAZING AND A 92990 4,250.00 Inv #: '62456' Vendor '000149' 09/27/2021 AP HANGAR/OFFICE DOORS 93937 4,238.70 Inv #: '91921-8' Vendor '000701' 11/17/2021 AP TIF 1 FIRE STATION 1 PAYOUT #2 97601 128,732.60 Inv #: '11172021' Vendor '172100' 01/04/2022 05:06 PM REVENUE AND EXPENDITURE REPORT FOR CITY OF DEKALB Page: 3/5 User: CARRIE.DITTMA Balances as of 12/31/2021 DB: Dekalb Fund 260 - TIF FUND #1 (CENTRAL AREA) 2021 YEAR-TO-DATE Available % Account Description Amended Budget THRU 12/31/21 Balance Used Expenditures Department 00-00: GENERAL 82000 BUILDINGS & IMPROVEMENTS 300,000.00 267,005.51 32,994.49 89.00 83900 OTHER CAPITAL IMPROVEMENTS 01/01/2021 GJ CMT INV 0213110 - FY20 83995 (2,644.52) JE# 2899 01/01/2021 GJ CMT INV 0213110 - FY20 84083 2,644.52 JE# 2910 01/21/2021 AP EMERGENCY FUEL FARM REPAIR 80531 390.05 Inv #: '00093501' Vendor '000380' 01/21/2021 AP EMERGENCY FUEL FARM REPAIRS 80613 340.23 Inv #: 'S159816' Vendor '001266' 03/24/2021 GJ RECLASS CMT INV 0213110 83996 2,644.52 JE# 2900 03/24/2021 GJ RECLASS CMT INV 0213110 85005 (2,644.52) JE# 2935 83900 OTHER CAPITAL IMPROVEMENTS 470,000.00 730.28 469,269.72 0.16 91262 TRANSFER TO TIF #3 FUND 01/31/2021 GJ FY2021 BUDGET TRANSFERS 83567 204,167.00 JE# 2853 02/28/2021 GJ FY2021 BUDGET TRANSFERS 83568 204,167.00 JE# 2854 03/31/2021 GJ FY2021 BUDGET TRANSFERS 83940 204,167.00 JE# 2885 04/30/2021 GJ FY2021 BUDGET TRANSFERS 85600 204,167.00 JE# 2957 05/27/2021 GJ FY2021 BUDGET TRANSFERS 87052 204,167.00 JE# 2983 06/30/2021 GJ FY2021 BUDGET TRANSFERS 88684 204,167.00 JE# 3055 07/16/2021 GJ FY2021 BUDGET TRANSFERS 89445 204,167.00 JE# 3078 08/31/2021 GJ FY2021 BUDGET TRANSFERS 93145 204,167.00 JE# 3206 09/27/2021 GJ FY2021 BUDGET TRANSFERS 93146 204,167.00 JE# 3207 10/30/2021 GJ FY2021 BUDGET TRANSFERS 96449 204,167.00 JE# 3254 91262 TRANSFER TO TIF #3 FUND 2,450,000.00 2,041,670.00 408,330.00 83.33 91375 TRANSFER TO TIF DEBT SERVICE FUND 01/31/2021 GJ FY2021 BUDGET TRANSFERS 83567 99,233.00 JE# 2853 02/28/2021 GJ FY2021 BUDGET TRANSFERS 83568 99,233.00 JE# 2854 03/31/2021 GJ FY2021 BUDGET TRANSFERS 83940 99,233.00 JE# 2885 04/30/2021 GJ FY2021 BUDGET TRANSFERS 85600 99,233.00 JE# 2957 05/27/2021 GJ FY2021 BUDGET TRANSFERS 87052 99,233.00 JE# 2983 06/30/2021 GJ FY2021 BUDGET TRANSFERS 88684 99,233.00 JE# 3055 07/16/2021 GJ FY2021 BUDGET TRANSFERS 89445 99,233.00 JE# 3078 08/31/2021 GJ FY2021 BUDGET TRANSFERS 93145 99,233.00 JE# 3206 09/27/2021 GJ FY2021 BUDGET TRANSFERS 93146 99,233.00 JE# 3207 10/30/2021 GJ FY2021 BUDGET TRANSFERS 96449 99,233.00 JE# 3254 91375 TRANSFER TO TIF DEBT SERVICE F 1,190,800.00 992,330.00 198,470.00 83.33 Total - Dept 00-00 7,945,800.00 6,693,351.48 1,252,448.52 84.24 Total Expenditures 7,945,800.00 6,693,351.48 1,252,448.52 84.24 NET OF REVENUES AND EXPENDITURES (845,800.00) 47,994.22 (893,794.22) 01/04/2022 05:06 PM REVENUE AND EXPENDITURE REPORT FOR CITY OF DEKALB Page: 4/5 User: CARRIE.DITTMA Balances as of 12/31/2021 DB: Dekalb Fund 262 - TIF FUND #3 2021 YEAR-TO-DATE Available % Account Description Amended Budget THRU 12/31/21 Balance Used Revenues Department 00-00: GENERAL 30300 PROPERTY TAX - TIF 05/28/2021 CR PROPERTY TAX REVENUE 05/28/2021 87110 17,452.95 PROPERTY TAX REVENUE 05/28/2021 06/28/2021 CR PROPERTY TAX REVENUE 06/28/2021 88216 198,966.56 PROPERTY TAX REVENUE 06/28/2021 07/23/2021 CR PROPERTY TAX REVENUE 07/23/2021 90041 15,129.53 PROPERTY TAX REVENUE 07/23/2021 08/20/2021 CR PROPERTY TAX REVENUE 08/20/2021 91798 6,533.52 PROPERTY TAX REVENUE 08/20/2021 09/17/2021 GJ CORRECT TIF #3 TAX PAYMENT - DISTR #5 93136 186,177.14 JE# 3213 11/24/2021 CR PROPERTY TAX REVENUE 11/24/2021 98130 34,549.27 PROPERTY TAX REVENUE 11/24/2021 30300 PROPERTY TAX - TIF 450,000.00 458,808.97 (8,808.97) 101.96 37100 INVESTMENT INTEREST 01/31/2021 GJ INTEREST JAN 2021 82136 167.29 JE# 2759 01/31/2021 GJ CORRECTION TO INTEREST ALLOCATION 2020 91803 (48.90) JE# 3166 02/28/2021 GJ INTEREST FEB 2021 82137 129.13 JE# 2760 03/31/2021 GJ INTEREST MARCH 2021 88910 18.28 JE# 3069 05/31/2021 GJ TIF INTEREST ALLOCATION 88093 14.93 JE# 3044 07/31/2021 GJ JULY 2021 FNB TIF INTEREST ALLOCATION 90965 152.45 JE# 3136 08/31/2021 GJ AUG 2021 TIF INTEREST ALLOCATION 93148 177.18 JE# 3210 09/30/2021 GJ TIF INTEREST ALLOCATION - SEPT 2021 94182 123.32 JE# 3246 10/31/2021 GJ TIF INTEREST ALLOCATION - OCT 2021 96811 168.14 JE# 3271 11/30/2021 GJ TIF INTEREST ALLOCATION - NOV 2021 99176 151.53 JE# 3321 37100 INVESTMENT INTEREST 250.00 1,053.35 (803.35) 421.34 39260 TRANSFER FROM TIF #1 FUND 01/31/2021 GJ FY2021 BUDGET TRANSFERS 83567 204,167.00 JE# 2853 02/28/2021 GJ FY2021 BUDGET TRANSFERS 83568 204,167.00 JE# 2854 03/31/2021 GJ FY2021 BUDGET TRANSFERS 83940 204,167.00 JE# 2885 04/30/2021 GJ FY2021 BUDGET TRANSFERS 85600 204,167.00 JE# 2957 05/27/2021 GJ FY2021 BUDGET TRANSFERS 87052 204,167.00 JE# 2983 06/30/2021 GJ FY2021 BUDGET TRANSFERS 88684 204,167.00 JE# 3055 07/16/2021 GJ FY2021 BUDGET TRANSFERS 89445 204,167.00 JE# 3078 08/31/2021 GJ FY2021 BUDGET TRANSFERS 93145 204,167.00 JE# 3206 09/27/2021 GJ FY2021 BUDGET TRANSFERS 93146 204,167.00 JE# 3207 10/30/2021 GJ FY2021 BUDGET TRANSFERS 96449 204,167.00 JE# 3254 39260 TRANSFER FROM TIF #1 FUND 2,450,000.00 2,041,670.00 408,330.00 83.33 Total - Dept 00-00 2,900,250.00 2,501,532.32 398,717.68 86.25 Total Revenues 2,900,250.00 2,501,532.32 398,717.68 86.25 Expenditures Department 00-00: GENERAL 62100 FINANCIAL SERVICES 03/02/2021 AP FY2020 SIKICH AUDIT FEES 83358 130.00 Inv #: '485615' Vendor '000943' 03/03/2021 AP FY2020 SIKICH EXTERNAL AUDIT FEES 83359 40.00 Inv #: '490170' Vendor '000943' 05/20/2021 AP FY2020 SIKICH EXTERNAL AUDIT FEES 87741 246.36 Inv #: '506050-1' Vendor '000943' 06/07/2021 AP FY2020 SIKICH EXTERNAL AUDIT FEES 89208 140.00 Inv #: '514441' Vendor '000943' 62100 FINANCIAL SERVICES 1,500.00 556.36 943.64 37.09 65300 LEGAL EXPENSES & NOTICES 12/08/2021 AP TIF JRB AGENDA/DATA REVIEW 2021 99116 2,244.50 Inv #: '120821' Vendor '172368' 01/04/2022 05:06 PM REVENUE AND EXPENDITURE REPORT FOR CITY OF DEKALB Page: 5/5 User: CARRIE.DITTMA Balances as of 12/31/2021 DB: Dekalb Fund 262 - TIF FUND #3 2021 YEAR-TO-DATE Available % Account Description Amended Budget THRU 12/31/21 Balance Used Expenditures Department 00-00: GENERAL 65300 LEGAL EXPENSES & NOTICES 6,150.00 2,244.50 3,905.50 36.50 69199 PRIV PROP REHAB / REDEVELOP 01/01/2021 GJ REVERSE PART OF 2019 AUDIT ENTRY 2339 82469 (500,000.00) JE# 2775 01/01/2021 GJ REVERSE PART OF 2019 AUDIT ENTRY 2339 82540 500,000.00 JE# 2780 01/01/2021 GJ REVERSE AJE #3 89717 (39,842.45) JE# 3097 01/01/2021 GJ REVERSE AJE #3 89717 (79,960.00) JE# 3097 01/11/2021 AP TIF 3 DEVELOPMENT INCENTIVE-REHABILITAT 78734 39,842.45 Inv #: '2020-009' Vendor '002412' 01/11/2021 AP TIF PAYOUT PER RESOLUTION 2020-043 78814 79,960.00 Inv #: '2020-043' Vendor '172100' 04/28/2021 AP 2021 EGYPTIAN THEATER AIP 85996 4,314.00 Inv #: '4282021' Vendor '001271' 08/26/2021 AP TIF 3 DEVELOPMENT INCENTIVE- DRAW 3 REH 91699 108,400.00 Inv #: '08262021' Vendor '002412' 09/08/2021 AP 200 S 4TH ST TIF 3 REDEVELOPMENT 92336 502,845.84 Inv #: '09082021' Vendor '172295' 09/17/2021 AP TIF 3 AIP 201 E LOCUST ST 92914 1,850.00 Inv #: '09172021' Vendor '172303' 11/17/2021 AP TIF 3 AIP - 115 N 1ST ST 97602 1,675.00 Inv #: '111721' Vendor '172354' 69199 PRIV PROP REHAB / REDEVELOP 1,845,000.00 619,084.84 1,225,915.16 33.55 83900 OTHER CAPITAL IMPROVEMENTS 03/24/2021 AP ENGINEERING DESIGN OF LINCOLN HWY LANE R 84366 22,400.00 Inv #: '70865' Vendor '000349' 03/24/2021 AP ENGINEERING DESIGN OF LINCOLN HWY LANE R 84367 36,337.75 Inv #: '71065' Vendor '000349' 04/23/2021 AP ENGINEERING DESIGN OF LINCOLN HWY LANE R 86000 20,589.25 Inv #: '71240' Vendor '000349' 07/01/2021 AP ENGINEERING DESIGN OF LINCOLN HWY LANE R 89075 1,039.00 Inv #: '71666' Vendor '000349' 07/27/2021 AP ENGINEERING DESIGN OF LINCOLN HWY LANE R 90588 4,190.50 Inv #: '71464' Vendor '000349' 07/27/2021 AP ENGINEERING DESIGN OF LINCOLN HWY LANE R 90589 1,543.50 Inv #: '71856' Vendor '000349' 08/30/2021 AP ENGINEERING/ON STREET BIKE LANES 92453 220.25 Inv #: '100321' Vendor '000378' 08/30/2021 AP ENGINEERING/ON STREET BIKE LANES 92451 856.00 Inv #: '100986' Vendor '000378' 08/30/2021 AP ENGINEERING/ON STREET BIKE LANES 92452 871.00 Inv #: '101292' Vendor '000378' 10/27/2021 AP CHARGEPOINT CT-4021 DUAL BOLLARD CAR CHA 97782 12,494.00 Inv #: '2949' Vendor '172050' 10/29/2021 AP ENGINEERING DESIGN OF LINCOLN HWY LANE R 97837 1,342.50 Inv #: '72550' Vendor '000349' 12/01/2021 AP INSTALLATION PALMER COURT ELECTRIC CAR C 98883 2,500.00 Inv #: '2118' Vendor '172079' 83900 OTHER CAPITAL IMPROVEMENTS 1,165,000.00 104,383.75 1,060,616.25 8.96 Total - Dept 00-00 3,017,650.00 726,269.45 2,291,380.55 24.07 Total Expenditures 3,017,650.00 726,269.45 2,291,380.55 24.07 NET OF REVENUES AND EXPENDITURES (117,400.00) 1,775,262.87 (1,892,662.87) TOTAL REVENUES - ALL FUNDS 10,000,250.00 9,242,878.02 757,371.98 92.43 TOTAL EXPENDITURES - ALL FUNDS 10,963,450.00 7,419,620.93 3,543,829.07 67.68 NET OF REVENUES AND EXPENDITURES (963,200.00) 1,823,257.09 (2,786,457.09)  TIF 1 - Central Business District TIF Income Statement Summary TIF # 1 (esta. 12/22/1986) Tax Year for Base EAV for TIF Increment 2019 2020 2021 Tax Year 2019 2020 2021 Year Tax Due 2020 2021 2022 Year Surplus Distributed (by 3/31) 2021 2022 2023 Beginning Balance (Jan 1) 4,373,313 3,178,752 781,277 Revenue Actual Actual YTD Revenue - Property Tax Increment 7,031,778 6,611,022 6,727,258 Revenue - Transfer from Other TIFs - - - Revenue - Interest Income 163,231 28,951 984 Revenue - Gain/Loss on Investments 143,465 - 13,104 Revenue - Refunds/Reimbursements 43,387 - Revenue - Bond Proceeds - - - Revenue - Other - - - Total Revenue 7,381,861 6,639,973 6,741,346 Total Available (Rev. + Beg. Balance) 11,755,174 9,818,725 7,522,623 Expenses Incurred (Paid) Expenses - Non-Project (Admin) - - - Expenses - Public Infrastructure - 70,119 267,006 Expenses - Not-for-Profit - - - Expemses - Private For-Profit 3,380,053 20,055 - Expenses - Debt Service 1,192,400 1,195,000 992,330 Expenses - Other 85,043 - - Expenses - Engineering Services 19,735 - - Expenses - Contracted Services 5,592 - 11,693 Expenses - Financial Services - 85,247 14,381 Expenses - Legal & Dues 3,263 20,000 1,912 Expenses - Other Capital Improvements 5,000 98,871 730 Expenses - Transfer to General Fund 46,666 5,000 - Expenses - Transfer to Airport Fund - 37,646 Expenses - Transfer to TIF #3 Fund - 4,275,000 2,041,670 Total Expenses (excl IGA Surplus Pmt) 4,737,752 5,806,937 3,329,722 Expenses - Surplus IGA 3,515,888 3,305,511 3,363,629 Year End Adjustments 322,782 75,000 - Ending Balance (Dec 31) 3,178,752 781,277 829,271 * *remaining balance to be transferred to TIF #3 after final year end adjustments are made less a small reserve (approx. $20,000) for possible tax refunds CITY OF DEKALB 2019 2020 2021 2021 2022 AMENDED PROJECTED REQUESTED GL NUMBER DESCRIPTION ACTIVITY ACTIVITY BUDGET ACTIVITY BUDGET Fund 262 - TIF FUND #3 ESTIMATED REVENUES OTHER INCOME 262-00-00-37100 INVESTMENT INTEREST 0 201 250 450 250 OTHER INCOME 0 201 250 450 250 PROPERTY TAXES 262-00-00-30300 PROPERTY TAX - TIF 0 300,640 450,000 450,000 460,000 PROPERTY TAXES 0 300,640 450,000 450,000 460,000 TRANSFERS IN 262-00-00-39260 TRANSFER FROM TIF #1 FUND 0 4,275,000 2,450,000 2,190,000 0 TRANSFERS IN 0 4,275,000 2,450,000 2,190,000 0 TOTAL ESTIMATED REVENUES 0 4,575,841 2,900,250 2,640,450 460,250 EXPENDITURES CONTRACTUAL SERVICES 262-00-00-62100 FINANCIAL SERVICES 0 703 1,500 750 750 262-00-00-63800 CONTRACTED SERVICES 0 0 0 0 6,111 262-00-00-65300 LEGAL EXPENSES & NOTICES 0 0 6,150 0 0 262-00-00-68600 TIF SURPLUS DISTRIBUTION 0 0 0 0 138,000 262-00-00-69199 PRIV PROP REHAB / REDEVELOP 500,000 2,803,802 1,845,000 577,846 1,354,571 CONTRACTUAL SERVICES 500,000 2,804,505 1,852,650 578,596 1,499,432 EQUIPMENT 262-00-00-83900 OTHER CAPITAL IMPROVEMENTS 0 0 1,165,000 150,000 1,250,000 EQUIPMENT 0 0 1,165,000 150,000 1,250,000 TOTAL EXPENDITURES 500,000 2,804,505 3,017,650 728,596 2,749,432 NET OF REVENUES/EXPENDITURES (500,000) 1,771,336 (117,400) 1,911,854 (2,289,182) ESTIMATED REVENUES - FUND 262 4,575,841 2,900,250 2,640,450 460,250 EXPENDITURES - FUND 262 500,000 2,804,505 3,017,650 728,596 2,749,432 NET OF REVENUES/EXPENDITURES - FUND 262 (500,000) 1,771,336 (117,400) 1,911,854 (2,289,182) BEGINNING FUND BALANCE (500,000) 1,271,337 1,271,337 3,183,191 ENDING FUND BALANCE (500,000) 1,271,336 1,153,937 3,183,191 894,009 170  TIF 3 - Central Business District TIF Income Statement Summary TIF # 3 (esta. 2/11/2019) Tax Year for Base EAV for TIF Increment 2019 2020 2021 TIF Year 0 1 2 Tax Year 2019 2020 2021 Year Tax Due 2020 2021 2022 Year Surplus Distributed (by 3/31) 2021 2022 2023 Beginning Balance (Jan 1) - (500,000) 1,271,337 Projected Totals Over Life of TIF Revenue Actual Actual YTD Revenue - Property Tax Increment - 300,640 458,809 11,975,812 Revenue - Transfer from Other TIFs - 4,275,000 2,041,670 6,316,670 Revenue - Interest Income - 202 1,053 1,255 Revenue - Bond Proceeds - - - - Revenue - Other - - - - Total Revenue - 4,575,842 2,501,532 $ 18,293,737 Total Available (Rev. + Beg. Balance) - 4,075,842 3,772,869 Expenses Incurred (Paid) Expenses - Non-Project (Admin) - - - - Expenses - Other Capital-Public Infrastructure - - 104,384 104,384 Expenses - Not-for-Profit - - - - Expemses - Private For-Profit 500,000 2,803,802 619,085 3,922,887 Expenses - Debt Service - - - - Expenses - Other - - - - Expenses - Engineering Services - - - - Expenses - Financial Services 703 556 1,259 Expenses - Legal & Notices - - 2,244 2,244 Expenses - Surplus Other - - - - Total Expenses (excl IGA Surplus Pmt) 500,000 2,804,505 726,269 $ 4,030,774 Expenses - Surplus IGA - - 137,643 $ 5,526,444 Ending Balance/(Deficit) (Dec 31) (500,000) 1,271,337 2,908,957 $ 8,736,520 IGA % of Surplus 0% 0% 30%  TIF 1 & TIF 3 - Central Business District Estimated Pay Out Schedule ("Project Tracking") Period Ending 12/31/2021 Applicable Income Statement Year of Total RDA/TIF Approved Remaining Redevelopment Project Party (Developer) Paid to Date PINS Expense Category RDA Commitment Eligible Obligation Administrative (Non-Project) N/A City of DeKalb Administrative NA $ - $ - Debt Service - TIF 1 City of DeKalb Debt Service 2021 $ 2,385,800 N/A $ 2,187,330 $ 198,470 Agora Tower Private - For Profit 2019 $ 3,000,000 Y $ 1,962,583 $ 1,037,417 206 E. Lincoln Ave. apartments Private - For Profit 2020 $ 216,800 Y $ 216,800 $ - 200 S. Fourth Street Private - For Profit 2020 $ 750,000 Y $ 502,846 $ 247,154 AIP - 121 N. Second Street - Hillside Private - For Profit 2020 $ 18,076 Y $ - $ 18,076 AIP - 135 N. Second St - Egyptian Theater Private - For Profit 2021 $ 4,314 Y $ 4,314 $ - AIP - 115 N 1st St - R.A.M.P Private - For Profit 2021 $ 1,675 Y $ 1,675 $ - AIP - Hickeys Private - For Profit 2021 $ 1,185 Y $ - $ 1,185 AIP - 151 N 4th St Private - For Profit 2021 $ 25,000 Y $ - $ 25,000 AIP - Acculab - 509 Oak St Private - For Profit 2021 $ 25,000 Y $ - $ 25,000 AIP - 201-203 E. Locust St Private - For Profit 2021 $ 1,850 Y $ 1,850 $ - IL Route 38 Downtown City of DeKalb Infrastructure 20XX $ 1,850,000 Y $ 89,391 $ 1,760,609 Electric Car Charging Station - Palmer Ct. City of DeKalb Infrastructure 2021 $ 15,000 Y $ 14,994 $ - Fire Station #1** City of DeKalb Infrastructure 2021 $ 181,554 Y $ 180,284 $ - DeKalb-Taylor Municipal Airport* City of DeKalb Infrastructure 2021 $ 200,000 Y $ 86,723 $ 113,277 Total Project Expenses $ 8,676,254 $ 5,248,790 $ 3,426,187 *Total RDA Commitment estimated based on the Municipal Share of Grant Activity to Rehabilitate Airport Facilities **Fire Station #1 Rehab Complete & Under Budget as of 11/18/2021