Village Board of Trustees Standing Committee

AGENDA Finance Committee Regular Meeting Village Hall 1900 Hassell Road, Hoffman Estates, IL 60169 April 27, 2026 Council Chambers Immediately Following Public Health & Safety Committee 1. CALL TO ORDER/ROLL CALL 2. APPROVAL OF MINUTES A. Finance Committee 03-23-2026 3. PUBLIC COMMENT 4. NEW BUSINESS A. Approval of a Resolution authorizing a professional services agreement with DB Sterlin Consultants, Inc., Chicago, Illinois, for engineering services for the evaluation and development of construction documents for the NOW Arena main entrance monumental stair repair or replacement project in an amount not to exceed $66,770. 5. REPORTS A. Finance Department Monthly Report B. Information Technology Department Monthly Report C. NOW Arena Monthly Report 6. PRESIDENT'S REPORT 7. ITEMS IN REVIEW 8. OTHER 9. ADJOURNMENT Further details and information can be found in the agenda packet attached hereto and incorporated herein and Page 1 Page 1 of 89 April 27, 2026 Village of Hoffman Estates Finance Committee can also be viewed online at www.hoffmanestates.org and/or in person in the Village Clerk's office. The Village of Hoffman Estates complies with the Americans with Disabilities Act (ADA). For accessibility assistance, call the ADA Coordinator at 847/882-9100. Page 2 Page 2 of 89 Village of Hoffman Estates FINANCE COMMITTEE MEETING MINUTES March 23, 2026 I. Roll call Members in Attendance: Gary Pilafas, Chair Anna Newell, Vice Chairperson Karen Mills, Trustee Gary Stanton, Trustee Karen Arnet, Trustee Patrick Kinnane, Trustee William McLeod, Mayor Management Team Members in Attendance: Eric Palm, Village Manager Dan O’Malley, Deputy Village Manager Art Janura, Corporation Counsel Kasia Cawley, Chief of Police Alan Wax, Fire Chief Rachel Musiala, Finance Director Bryan Ackerlund, Asst. PW Director Darek Raszka, Director of IT William Lynch, Supt. of Facilities Ben Gibbs, GM, NOW Arena Ric Signorella, Multimedia Prod. Manager The Finance Committee meeting was called to order at 7:10 p.m. 2. APPROVAL OF MINUTES Motion by Trustee Stanton, seconded by Trustee Mills, to approve the Finance Committee Minutes from February 23, 2026. Voice vote taken. All ayes. Motion carried. Motion by Trustee Kinnane, seconded by Trustee Arnet, to approve the Special Finance Committee minutes from March 2, 2026. Voice vote taken. All ayes. Motion carried. 3. PUBLIC COMMENT Page 3 of 89 Finance Committee -2- March 23, 2026 4. NEW BUSINESS A. Approval of a Resolution authorizing the purchase and installation of LED display panels for the monument sign at the NOW Arena from Vernon & Maz, Inc., Monee, IL, in the amount not to exceed $292,494. Item summary sheet from Ben Gibbs, William Lynch and Dan O’Malley was presented to Committee. Ben Gibbs addressed the Committee and reported that the LED monument sign was originally installed in 2014 and has reached the end of its life. Motion by Trustee Kinnane, seconded by Trustee Arnet, to approve a resolution authorizing the purchase and installation of LED display panels for the monument sign at the NOW Arena from Vernon & Maz, Inc., Monee, IL, in the amount not to exceed $292,494. Voice vote taken. All ayes. Motion carried. 5. REPORTS A. Finance Committee Monthly Report The Finance Department Monthly Report was received and filed. B. Information Technology Department Monthly Report The Information Technology Department Monthly Report was received and filed. C. NOW Arena Monthly Report The NOW Arena Monthly Report was received and filed. Ben Gibbs advised that the summer line-up at the Hideaway will be released soon. 6. PRESIDENT’S REPORT 7. ITEMS IN REVIEW 8. OTHER 9. ADJOURNMENT Motion by Trustee Arnet, seconded by Trustee Kinnane, to adjourn the meeting at 7:16 p.m. Voice vote taken. All ayes. Motion carried. Minutes submitted by: Debbie Schoop, Executive Assistant Date Page 4 of 89  AGENDA ITEM REPORT Finance Committee April 27, 2026 ITEM 4A REQUEST: Approval of a Resolution authorizing a professional services agreement with DB Sterlin Consultants, Inc., Chicago, Illinois, for engineering services for the evaluation and development of construction documents for the NOW Arena main entrance monumental stair repair or replacement project in an amount not to exceed $66,770. FROM: Dan O'Malley, Deputy Village Manager Kevin McGraw, Superintendent of Streets ITEM TYPE: Contract - Committee REQUEST SUMMARY The NOW Arena main entrance stairs are twenty years old and have experienced long- term settlement and deterioration. These conditions present potential structural, safety, and accessibility concerns for a high-traffic public facility that supports a wide range of events. To address these concerns, the Village issued a Request for Proposals (RFP) for a qualified engineering consultant to evaluate existing conditions and develop recommendations and construction documents for repair or replacement. The selected consultant will perform a comprehensive assessment that may include destructive and non-destructive testing, identify root causes of settlement, develop repair and replacement alternatives, provide opinions of probable cost, and prepare a phased implementation plan that maintains arena operations. A key component of this project is maintaining safe and continuous ingress, egress, and emergency access during both the evaluation and any future construction activities. The Village received one proposal in response to the RFP from DB Sterlin Consultants, Inc. While only one proposal was received, DB Sterlin’s submission was comprehensive and aligned with the Village’s scope. Staff is familiar with their work and has received positive references on this firm. Their proposal includes a structured approach consisting of field investigation, structural analysis, development of alternatives and cost estimating. The evaluation phase is anticipated to take approximately 12 weeks during 2026, anticipated construction would most likely occur in 2027. FINANCIAL IMPACT There is $325,000 budgeted for this project in the current budget. This expense will be covered by these funds and the balance of the project construction cost will be evaluated by the report and, if necessary, the budget will be adjusted for work in 2027. Page 1 of 2 Page 5 of 89 RECOMMENDATION Approval of a Resolution authorizing a professional services agreement with DB Sterlin Consultants, Inc., Chicago, Illinois, for engineering services for the evaluation and development of construction documents for the NOW Arena main entrance monumental stair repair or replacement project in an amount not to exceed $66,770. ATTACHMENTS 1. RESOLUTION Now Arena Monumental Stairs 2. DBS Assessment PSA 2026 REV 3. DRAFT - OPINION OF PROBABLE COSTS - 2026 NOW Arena Exterior Stair Repair or Replacement Page 2 of 2 Page 6 of 89  RESOLUTION NO. ____-2026 VILLAGE OF HOFFMAN ESTATES APPROVAL OF A RESOLUTION AUTHORIZING A PROFESSIONAL SERVICES AGREEMENT WITH DB STERLIN CONSULTANTS, INC., CHICAGO, ILLINOIS, FOR ENGINEERING SERVICES RELATED TO THE EVALUATION AND DEVELOPMENT OF CONSTRUCTION DOCUMENTS FOR THE NOW ARENA MAIN ENTRANCE MONUMENTAL STAIR REPAIR OR REPLACEMENT PROJECT IN AN AMOUNT NOT TO EXCEED $66,770 WHEREAS, the Village of Hoffman Estates (“Village”) is a home-rule municipality located in Cook County, Illinois; and WHEREAS, the main entrance stairs at the NOW Arena have experienced long-term settlement and deterioration, raising concerns related to structural integrity, safety, and accessibility; and WHEREAS, the Village issued a Request for Proposals (RFP) to retain a qualified engineering consultant to evaluate existing conditions and develop recommendations and construction documents for repair or replacement of the main entrance stairs; and WHEREAS, staff received one proposal in response to the RFP from DB Sterlin Consultants, Inc., and have determined that the proposal is responsive, comprehensive, and aligned with the Village’s scope and operational requirements; and WHEREAS, the Corporate Authorities find and determine that it is in the best interests of the Village to approve an agreement with DB Sterlin Consultants, Inc. of Chicago, Illinois, for engineering services not to exceed $66,770. NOW, THEREFORE, BE IT RESOLVED, by the President and Board of Trustees of the Village of Hoffman Estates, as follows: Section 1: RECITALS. The facts and statements contained in the preambles of this Resolution are found to be true and correct and are hereby adopted as part of this Resolution. Section 2: APPROVAL OF AGREEMENT. The President and Board of Trustees hereby approve an agreement with DB Sterlin Consultants, Inc, of Chicago, Illinois, for 2026 for engineering and design services, in an amount not to exceed $66,770. Section 3: AUTHORIZATION TO EXECUTE AGREEMENT. The President or Village Manager is hereby authorized to execute the contract, and to execute any other documents in furtherance of this Resolution in accordance with the Village Code and state and federal law. Section 4: EFFECTIVE DATE. This Resolution shall be in full force and effect from and after its passage and approval as provided by law. RESOLVED THIS ________ day of _________________, 2026 VOTE AYE NAY ABSENT ABSTAIN Trustee Karen V. Mills _____ _____ _____ _____ Trustee Anna Newell _____ _____ _____ _____ Trustee Gary J. Pilafas _____ _____ _____ _____ Trustee Gary G. Stanton _____ _____ _____ _____ Trustee Karen Arnet _____ _____ _____ _____ Trustee Patrick Kinnane _____ _____ _____ _____ President William D. McLeod _____ _____ _____ _____ APPROVED THIS ______ DAY OF _______________, 2026 ______________________________ Village President ATTEST: ____________________________ Village Clerk Page 7 of 89  VILLAGE OF HOFFMAN ESTATES This Professional Services Agreement (the “Agreement”) is made and entered into this 5th day of May, 2026, by and between the VILLAGE OF HOFFMAN ESTATES, ILLINOIS, a municipal corporation located at 1900 Hassell Road, Hoffman Estates, IL (“Village”) and DB Sterlin Consultants, Inc., with a principal place of business at 123 N. Wacker Drive, Suite 2000, Chicago, IL 60606 (“Contractor”) and sets forth the terms and conditions under which Contractor agrees to perform certain land surveying services as set forth below. This Agreement is made pursuant to Hoffman Estates procurement process and Contractor’s Proposal dated March 30th, 2026, attached hereto as Exhibit A and incorporated herein by reference. 1. SERVICES Contractor will complete services as outlined in Exhibits A. Other than what is provided in Paragraph 3 below, Village shall not be responsible for the cost of materials and equipment necessary for the performance of the Services. No claim for services furnished by Contractor, not specifically provided for in this Agreement, shall be allowed by the Village nor shall Contractor perform any services or furnish any material not covered by this Agreement without prior written approval by Village. Such approval shall be considered a modification of this Agreement. 2. TERM AND TERMINATION This Agreement shall be effective and binding upon execution. The parties agree that the time for completion of the services outlined in Exhibit A is approximately 12 weeks from Notice to Proceed, failure to complete the services outlined in Exhibit A within the agreed timeframe shall be considered a breach of this Agreement unless an extension is agreed to in writing by both parties. 3. FEES AND PAYMENT TERMS The total cost for services shall not exceed $66,770. Any fee for additional services must be agreed to in writing by the Village. Contractor shall not incur any expenses or costs on behalf of the Village or in performing the Services, other than what is provided for above, unless Village specifically authorizes in advance such expenses or costs in writing. Such additional expenses may include, but are not limited to, travel and lodging expenses. Page 1 of 5 Page 8 of 89  Final invoice must be provided with sufficient supporting documents for all time and material used for the project. 4. RELATIONSHIP OF THE PARTIES In performing Services hereunder, Contractor shall at all times act as an independent contractor and not as an agent or employee of Village. The Services shall be completed to the satisfaction of Village; however, the actual details of the Services shall be under Contractor’s control. Contractor agrees to comply with the professional standard of care relative to applicable state and federal statutes and the Municipal Code of the Village. Contractor further agrees to indemnify and hold Village harmless for any and all damages to the extent caused by Contractor’s negligent breach of the obligations contained in this paragraph. Contractor is in no way authorized to make any agreement, warranty or representation on behalf of Village or to incur any expenses or implied obligation on behalf of Village without first obtaining Village’s prior written consent. 5. STANDARD OF PERFORMANCE AND ACCEPTANCE Work must comply with the professional standard of care relative to the rules & regulations outlined by Village Of Hoffman Estates Construction Standards Manual. 6. INSURANCE At Contractor’s sole expense, Contractor shall be required to maintain at all times insurance of such types and such amounts, as are necessary to cover responsibilities and liabilities on a project of the character contemplated under this proposal. The Consultant shall meet all insurance requirements as stated in Article 107.27 of the “Standard Specifications for Road and Bridge Construction” adopted January 1, 2022. All insurance policies obtained for the project shall include the Village of Hoffman Estates and its duly authorized representatives as an additional insured. Village shall be named as an additional insured and the address for certificate holder must read exactly as: Village of Hoffman Estates 1900 Hassell Rd. Hoffman Estates, IL 7. INDEMNIDICATION Contractor shall indemnify and hold harmless the Village, and all of its officers, directors, officers, and employees of the foregoing from and against any and all losses, liabilities, damages, costs, and expenses (including, without limitation, reasonable attorneys’ fees and court costs) to Page 2 of 5 Page 9 of 89 the extent resulting from: (i) the negligent failure to comply with any applicable law or regulation or breach of this Agreement by Contractor or any of its employees, agents or contractors; (ii) negligent performance of Services by Contractor or any of its employees, agents or contractors; (iii) the negligent acts or omissions, including negligence , of any of its employees, agents or contractors. Nothing in this Section shall be construed as a waiver of Village’s rights to choose its own counsel to defend any claim arising under this Agreement. This Section shall survive the expiration or earlier termination of this Agreement. 8. ASSIGNMENT AND SUBCONTRACTING This Agreement shall not be assigned by Contractor without prior written approval of the Village, subject to such conditions and provisions as the Village may deem necessary in its sole and absolute discretion. No such approval by the Village of any assignment shall be deemed in any event or in any manner to provide for the incurrence of any obligation of the Village in addition to the total agreed upon price. Approval by the Village of an assignment shall not be deemed a waiver of any right accrued or accruing against Contractor. No assignee of Contractor shall assign this Agreement without prior written approval of the Village. This Agreement shall be binding upon the parties and their respective heirs, successors, and assigns. Furthermore, Contractor shall not enter into any subcontract with any agency or individual with respect to the performance of Services under this Agreement without the written consent of the Village. Such consent Village may grant, condition or withhold in Village’s sole discretion. 9. NOTICE All notices and other communications required to be given under the Agreement shall be in writing and shall be deemed to have been given (i) when personally delivered; (ii) three (3) business days after sending certified mail, or (iii) sending via email to the addresses below. If to Village: Village of Hoffman Estates Eric Palm, Village Manager 1900 Hassell Rd. Hoffman Estates, IL 60169 If to Contractor: DB Sterlin Consultants, Inc. Brad Noack, PE, SE 123 N Wacker Dr. Suite 2000 Chicago, IL 60606 Page 3 of 5 Page 10 of 89  10. GOVERNING LAW AND VENUE The parties agree this Agreement has been executed and delivered in Illinois and that their relationship and any and all disputes, controversies or claims arising under this Agreement shall be governed by the laws of the State of Illinois, without regard to conflicts of laws principles. The parties further agree that the exclusive venue for all such disputes shall be the Circuit Court in Cook Village, Illinois, and the parties hereby consent to the personal jurisdiction thereof. 11. COMPLIANCE WITH LAWS Each party hereto covenants and agrees to comply with the professional standard of care relative to applicable federal, state, and local laws, codes, ordinances, rules and regulations. Additionally, the Parties acknowledge that this project is a covered public works project under the Illinois Prevailing Wage Act 820 ILCS 130/ and agree to comply with all applicable requirements of said Act. 12. SEVERABILITY The invalidity or unenforceability of any particular word, phrase, sentence, paragraph or provision of this Agreement shall not affect the other words, phrases, sentences, paragraphs or provisions hereof. This Agreement shall be construed in all respects as if such invalid or unenforceable provisions were omitted and the remainder construed so as to give them meaningful and valid effect. It is the intention of the parties that if any particular provision of this Agreement is capable of two constructions, one of which would render the provision void and the other of which would render the provision valid, the provision shall have the meaning which renders it valid. 13. WAIVER Either Party’s failure to insist upon strict compliance with any provision hereof or its failure to enforce any rights or remedy in any instance shall not constitute or be deemed to be a waiver of any provision, right or remedy. 14. ENTIRE AGREEMENT This Agreement constitutes the entire agreement and understanding of the parties with regard to the subject matter contained herein and supersedes all prior agreements and understandings between the parties dealing with such subject matter, whether written or oral. No agreement hereafter made between the parties shall be binding on either party unless reduced in writing and signed by the party sought to be bound thereby. IN WITNESS WHEREOF, the Parties have executed this contract as of the date first written above. Page 4 of 5 Page 11 of 89 The Village of Hoffman Estates DB Sterlin Consultants, Inc. By: By: Printed Name: Printed Name: Regine Jeune Title: Title: President Date: Date: 4/20/2026 Page 5 of 5 Page 12 of 89  March 30th, 2026 NOW ARENA EXTERIOR STAIR REPAIR OR REPLACEMENT SUBMITTED BY: PREPARED FOR: DB Sterlin Consultants Inc. Village of Hoffman Estates ATTN: Brad Noack, PE, SE ATTN: Kevin McGraw 123 N Wacker Dr, Suite 2000 2305 Pembroke Ave Chicago, IL 60606 Hoffman Estates, IL 60169 Page 13 of 89 03/30/2026 Kevin McGraw Superintendent of Streets Village of Hoffman Estates 2305 Pembroke Avenue Hoffman Estates, Illinois, 60169 Dear Mr. McGraw, DB Sterlin is pleased to submit our proposal to the Village of Hoffman Estates for the NOW Arena Exterior Stair Repair or Replacement Project. With extensive experience in structural inspec on, analysis, and design, along with a strong track record in delivering municipal projects, we are well posi oned to bring significant value and proven capabili es to this project. The “Approach and Methodology” sec on of our proposal outlines how we will effec vely address each of the requirements described in the RFP. Our team has immediate availability to begin work on this project and the capacity to meet all project deadlines. As civil engineers, our mission is to leave a posi ve, las ng impact on every community we serve. With that passion in mind, we are excited for the opportunity to partner with the Village of Hoffman Estates and are commi ed to delivering though ul solu ons and meaningful improvements to your community. Sincerely, Brad Noack, PE, SE Structural Engineering Department Head DB Sterlin Consultants Inc. BNoack@DBSterlin.com Enclosure: Statement of Qualifica on Engineering Services Page 14 of 89 DB Sterlin Consultants is pleased to submit this statement of interest to the Village of Hoffman Estates. We are commi ed to delivering innova ve and high-quality engineering solu ons for the NOW Arena Exterior Stair Repair or Replacement project. Over the years, the indoor stadium’s main entrance has experienced significant se lement issues, which has been raising concerns for the thousands of patrons who visit each year. Our team is dedicated to performing an extensive and detailed evalua on and inves ga on of the current condi ons, and to developing prac cal and cost effec ve solu ons and construc on documents to address all discovered issues. DB Sterlin Consultants Inc. is a mul disciplinary engineering firm with offices in Wisconsin and Illinois, providing excep onal engineering and surveying services throughout the Midwest. As a local, minority-owned business, we are dedicated to delivering innova ve solu ons to our clients in the transporta on, sewer and water, u li es, and other infrastructure sectors. Our areas of exper se include civil and structural design, construc on management, planning and repor ng, constructability reviews, quality control, electrical engineering, water resources, and land surveying. We specialize in highways, bridges/structures, airports, u li es, railways, tunnels, and public sewer and water systems. Our clientele includes state and local government agencies, developers, consul ng engineering firms, construc on management firms, and general contractors. Our extensive knowledge, gained from years of experience, demonstrates our understanding and familiarity with the prac ces, procedures, requirements, and constraints involved in execu ng work for our clients. With years of hands-on experience and a deep understanding of industry standards, we pro- vide innova ve solu ons that ensure the consistent delivery of high-quality, reliable results tailored to our clients’ needs. We take a personalized approach to every project, offering solu ons that are specifically designed to address our clients’ unique needs, challenges, and goals for op mal outcomes. At DB Sterlin, we have earned the trust of our clients by consistently delivering projects with precision, professionalism, and a focus on high-impact results, ensuring that each project is executed with excellence. NOW Arena – Main Stair Repair RFP Facili es Page 15 of 89 DB Sterlin has a reputa on for delivering complex structural projects for federal, state, and municipal clients, including the Illinois Department of Transporta on, Illinois Tollway, City of Chicago, ComEd, Peoples Gas, Chicago Transit Authority, and Union Pacific Railroad/Metra. We have extensive experience preparing contract plans, specifica ons, and cost es mates for concrete structural projects. This experience results from in-depth inspec ons, destruc ve and nondestruc ve tes ng, evalua ons, and the analyses of repair or replacement alterna ves. Our team is ready to deliver prac cal and cost-effec ve solu ons that align with the Village’s priori es and ensure a smooth path from evalua on through construc on. Similiar Project Examples : Project Scope DB Sterlin conducted rou ne and ini al bridge inspec ons and asset inventory and management. Applying NBIS coding systems and protocols wherever possible, the team developed a customized inspec on form and numerical sufficiency ra ng to standardize future evalua ons. Based on inspec on findings, DB Sterlin prepared detailed repair recommenda ons with cost es mates, assisted in programming infrastructure improvements, and projected the remaining service life of each structure. All results and recommenda ons were compiled and delivered to the district in a formal report. Project Overview Since 2024, DB Sterlin has provided comprehensive structural inspec on services and proac ve maintenance recommenda ons for a system of nearly 100 bridges within the Forest Preserve District. These bridges, located across 33 parks, vary in length from nine to 635 feet and include a range of structural types such as prestressed concrete beams, prefabricated steel, concrete arches, mber structures, and a historic 1870’s wrought iron bowstring arch truss. While most bridges serve as pedestrian facili es and accommodate light maintenance vehicles, three structures provide public automobile access and require NBIS-compliant inspec ons to meet federal standards. Services Bridge Inspec on - Rou ne (Periodic) Bridge Inspec on - Ini al (Inventory) Structural Load Ra ng Analysis Asset Inventory Key Personnel Brad Noack PE, SE - Project Manager Client - Forest Preserve District of DuPage County Date Completed - 2026 Construc on Value - $1.5 Million Total Fee - $40,000 Project Reference: Facili es Manager Jason Berger (630) 876-5912 jberger@dupageforest.org NOW Arena – Main Stair Repair RFP Facili es Page 16 of 89 Project Scope DB Sterlin completed in-depth inspec ons of 48 pedestrian bridges throughout various forest preserves in Cook County. Responsibili es included reports and documenta on of inspec on findings, development of repair rec- ommenda ons, and construc on cost es mates. The repair recommenda ons for each structure ensured sta- bility, longevity, and compliance with all relevant safety regula ons and standards. Recommended repairs were priori zed based on severity and benefits to the public while accommoda ng the es mated construc on budget of $2,000,000. For Phase II of the project, DB Sterlin competed design plans for seven high priority pedestrian bridges and provided bid support assistance throughout the procurement process. Detailed repairs included stone riprap replacement, expansion joint replacement, mber deck replacement, stone masonry pier and abutment repairs, cleaning and pain ng, concrete patching, epoxy crack injec on, fiber wrapping, railing repairs, bridge washing, and PPC I-Beam repairs. Project Overview This work was part of the Forest Preserves of Cook County Structure Inspec on and Repair Project. The focus is to inspect various pedestrian bridges, culverts, and pipes throughout the Forest Preserves of Cook County. Based on the results of these inspec ons, repair plans were developed for selected structures to ensure their safety and longevity. This project was an important step in maintaining FPCC infrastructure and ensuring that visitors will con nue to enjoy its natural beauty. Services NBIS/Biennial Bridge Inspec ons Bridge Inspec on Reports/Forms Asset Inventory and Management Cost Es ma ng Repair Plan Development Bid Assistance Key Personnel Brad Noack PE, SE - Project Manager Michael Mar n, PE - Project Structural Engineer Client - Forest Preserves of Cook County Date Completed - 2024 Construc on Value - $2 Million Total Fee - $117,000 Project Reference HW Lochner Jordan McNally, PE - Structural Engineer 312-772-5648 NOW Arena – Main Stair Repair RFP Facili es Page 17 of 89 Project Scope DB Sterlin provided structural engineering services for the planning and design of combined Phase 2 inspec on and Phase 3 remedia on of Tunnels 16 and 17. Services included project management, development of inspec on and remedia on plans, and prepara on of design documents for structural repairs such as pipe support retrofits, new sha lids and ladders, tunnel concrete repairs, and pipe steel repairs. Addi onal support included permi ng assistance, technical guidance, and bid phase services. DB Sterlin also provided construc on engineering services for the Peoples Gas Tunnel Remedia on Program, including project management, stakeholder coordina on, schedule and budget control with Primavera P6, and bi-weekly progress reports. Field support covered 16 tunnel sites, with one engineer per inspec on. At 13 sites with groundwater above the tunnel crown, DB Sterlin conducted drawdown tes ng and coordinated water sampling. Addi onal tasks included reviewing documenta on, preliminary condi on assessments, risk ranking, and on-call engineering support throughout Phase I and beyond. Their work informed priori za on of tunnel remedia on, replacement, or decommissioning. Project Overview The Tunnel Remedia on Program (TRP), ini ated by Peoples Gas, involved the evalua on and risk assessment of 17 u lity tunnels and associated pipelines throughout Chicago. These tunnels, ranging from 25 to over 140 years in age, span approximately 10,000 linear feet and vary in diameter from 7 to 10 feet. The program was executed in three phases: Phase I focused on data collec on, ini al inspec ons, and risk ranking; Phase II involved detailed physical inspec ons; and Phase III provided ongoing engineering support for remedia on planning and execu on. Many tunnels were in complex urban environments, including beneath major highways, rail corridors, and waterways, requiring careful coordina on and logis cal planning. The objec ve was to assess structural integrity, iden fy high-risk assets, and support long-term decisions regarding tunnel rehabilita on, replacement, or decommissioning. Services Site Assessments Inspec on Project Documenta on Project Mee ngs Data Organiza on and Collec on Report Prepara on Key Personnel Brad Noack PE, SE - Supervisor Client - Peoples Gas Light and Coke Company Date Completed - 2024 Construc on Value - $5 Million Total Fee - $500,000 Project Reference Black & Veatch Corpora on Faruk Oksuz, PE 312-683-7850 Our inspec on teams are highly skilled in iden fying poten al issues and recommending solu ons to extend the lifespan and improve the safety of these vital structures. NOW Arena – Main Stair Repair RFP Facili es Page 18 of 89 Our key leadership team brings decades of proven experience managing structural projects throughout the Northwest, combining deep technical exper se with a collabora ve approach and a steadfast commitment to delivering high-quality, on- me, and cost-effec ve solu ons. The team will be led by Brad Noack, PE, SE, as Project Manager, with Michael Mar n, PE, serving as Project Engineer. Both have extensive experience in performing thorough, hands-on inspec ons and evalua ons of bridges, buildings, and transporta on structures to assess condi on, iden fy deteriora on, and evaluate overall safety and serviceability. Our inspec on team is well-versed in documen ng issues such as material degrada on, structural fa gue, and stability concerns, providing a clear understanding of each structure’s current condi on and remaining service life. Backed by years of experience, our team demonstrates a deep understanding of the prac ces, procedures, requirements, and constraints involved in successfully delivering work for our clients. MS, Civil Engineering, MS, Civil Engineering, 2009, University of Illinois 2008, Purdue University at Urbana-Champaign BS, Civil Engineering, BS, Civil Engineering, 2003, 2007, Purdue University University of Illinois at Chicago Mr. Noack will serve as Project Manager, overseeing Mr. Mar n will serve as Project Engineer for all aspects of the project. He brings over 20 years the project and brings 16 years of experience in of experience in the management and design of structural analysis, design, inspec on, maintenance, highway bridges, elevated railroad structures, and rehabilita on. Through his diverse experience, buildings, and rehabilita on projects, with exper se he is equipped with a deep understanding of the in contract plans, specifica ons, cost es mates, effort required to complete and deliver successful engineering reports, bridge inspec ons, and QC/QA quality work. In addi on, Mr. Mar n has strong oversight. skills in leadership, teamwork, and mentorship. Bringing decades of combined experience managing complex structural projects across Illinois, our team offers deep exper se in structural inspec ons, evalua ons, and the prepara on of contract plans and construc on documents, ensuring that every phase of the project is guided by proven leadership. Please see the full resumes included for details on our key staff ’s individual project experience. DB Sterlin’s key personnel are fully available to commence work immediately, ready to facilitate comprehensive field assessments, develop detailed plans and specifica ons, prepare accurate cost es mates, provide recommenda ons for the best solu ons, review and coordinate structural plans, and deliver seamless oversight throughout the project lifecycle. This full availability allows us to rapidly establish efficient workflows, maintain clear and con nuous communica on with all stakeholders, and ensure that every task is executed with safety, reliability, and construc bility in mind. Our team is posi oned to deliver high-quality, ac onable results, minimizing risks, maximizing efficiency, and ensuring that the final construc on documents reflect prac cal, buildable solu ons tailored to the specific needs of the project. NOW Arena – Main Stair Repair RFP Facili es Page 19 of 89 The NOW Arena’s main entrance stairs serve high-volume event traffic and must remain safe, code-compliant, and opera onal during inves ga ons and any subsequent work. Our approach priori zes: • Safety and con nuity of NOW Arena opera ons— maintaining rou ne ingress/egress and emergency egress during assessments and construc on. • Root-cause diagnosis of se lement-related issues through targeted destruc ve and non-destruc ve tes ng (NDT), third-party specialty tes ng oversight, and holis c structural/geotechnical evalua on. • Clear, phased recommenda ons with opinions of probable cost (OPC) for both hard and so costs, and a prac cal implementa on/phasing plan that respects the event calendar. Step 1 - Mobiliza on & Coordina on (Week 1) • Kickoff workshop (on-site): Align objec ves, confirm points of contact in Public Works and Arena Opera ons, review known issues, past repairs, and event schedules; validate data needs and site protocols. • Health and safety + access plan: Define barricades, off-hour tes ng windows, and egress con nuity during site work. Step 2 - Mul -Disciplinary Field Inves ga on (Weeks 2-4) • Visual/condi on survey: Document deteriora on (spalls, cracks, corrosion, se lement indicators, uneven treads/loose railings), drainage pathways, and adjacent plaza condi ons. • Non-destruc ve tes ng (as applicable): Ground-penetra ng radar to iden fy excessive moisture in subsurface soil (clearest evidence of drainage issue) and to iden fy any voids in stair concrete and subsurface soil interface (clearest evidence of se lement/drainage erosion), and complete hammer sounding to iden fy extent of concrete delamina ons. • Targeted destruc ve tes ng: Cores for compressive strength and petrography (if distress suggests freeze-thaw/ASR) lab tes ng and our QA oversight and review of lab reports, selec ve removals of delamina ons to inspect damage extent and reinforcement. • Code, life safety, and accessibility screening: High-level review against current safety and accessibility requirements to flag non-conformances for inclusion in final report and incorpora on into selected alterna ve concepts. Step 3 - Analysis & Diagnos cs (Weeks 5-6) • Structural review: Evaluate the exis ng stair system’s structural integrity and details rela ve to observed defects and tes ng results; evaluate future deteriora on risk and load path con nuity. • Root-cause review: Correlate se lement history with subgrade findings, drainage pa erns, freeze-thaw cycles, and detailing to determine whether repair or replacement is the more resilient life cycle solu on. NOW Arena – Main Stair Repair RFP Facili es Page 20 of 89 We will structure stakeholder engagement across three coordinated work tracks to capture input and keep all par es aligned: • Opera ons & Safety Track: Bi-weekly touchpoints with Arena Opera ons, Security/Fire, and Public Works to coordinate site access, barricading, and egress routes - especially around event days. • Leadership Track: Milestone briefings for Village leadership/elected officials to preview findings and op ons before public communica ons or bid release, with formal presenta on(s) upon request. • Technical Track: Working sessions with third-party tes ng partners and our structural/geotechnical team to review test plans and results, maintaining a unified technical basis for recommenda ons. • Engagement tools: On-site mee ngs, annotated plan markups, and decision logs; all mee ng minutes issued within 48 hours to clearly document decisions. • Maintaining Event Opera ons: Phased barricading and off-hour work windows to keep primary entrances open; temporary ramps/alternate paths of travel if localized closures are unavoidable. • Se lement & Subgrade Risk: Poten al voids, saturated soils, poor drainage detailing, or frost suscep bility driving differen al movement under the stair founda ons and adjacent plaza. • Durability & Life Cycle: Freeze-thaw, de-icing chemicals, and corrosion of rebar/embedded railing; details must address drainage, join ng, and protec ve systems for long-term performance. • Accessibility & Safety Compliance: Tread/riser uniformity, railing compliance, landings, slip resistance; provide for seamless accessible routes during and a er construc on. • Constructability in a Live Venue: Logis cs for deliveries, temporary signage/wayfinding, and clear separa on of construc on zones from patrons. • Budget Transparency: OPC ranges for repair vs. replacement, inclusive of design con ngencies, tes ng, permits, and construc on-phase services. NOW Arena – Main Stair Repair RFP Facili es Page 21 of 89 Kickoff & Data Collec on 1 week Week 1 Agenda, data request, safety/ access plan Field Inves ga on & Tes ng 3 weeks Week 2-4 Survey notes, NDT execu on, lab work ini ated Analysis & Diagnos cs 2 weeks Weeks 5-6 Structural checks, root-cause memo Dra Recommenda ons (Alt. Analysis + OPC) 2 weeks Weeks 7-8 Alterna ves matrix, OPC (hard/so ), phasing dra Stakeholder Review Workshop 1 week Week 9 Feedback log, direc on on preferred alterna ve Final Report Prepara on & Delivery 3 weeks Weeks 10-12 Final Report with visuals; presenta on (if requested) Total Analysis Dura on: 12 weeks from No ce to Proceed, subject to tes ng lead mes and event blackout dates. Weeks 1-4 Post- Concept Drawings, outline specs, code/accessibility 30% Design (Basis of Design) 4 weeks Authoriza on checklist Plans/sec ons/ details; dra techical specs; updated 60% Design 4 weeks Weeks 5-8 OPC Near-final documents; constructability review; cost 90% Design & QA/QC 4 weeks Weeks 9-12 update Final Issue for Bid 3 weeks Weeks 13-15 Sealed drawings/ specs; bit form; addenda Bidding Support 5 weeks Weeks 16-20 Pre-bid mee ng, RFI’s addenda, bid review memo NOW Arena – Main Stair Repair RFP Facili es Page 22 of 89  Phasing Objec ves: Maintain safe event opera ons; minimize closure footprints; accelerate cri cal path elements. Temporary barriers, demo/rebuild or repair localized area; maintain adjacent stairs; provide temporary wayfinding and, if needed, a temporary ADA route Phase I - Lateral Third 1 Weeks 1-8 via nearby entrances per opera ons plan. Execute during lower-volume event windows; augment staffing for crowd Phase 2 - Center Third 2 Weeks 9-16 control; preserve emergency egress rou ng verified with Fire/Security. Complete remaining work, finalize handrails/guards, join ng, sealers, and Phase 3- Lateral Third 3 Weeks 17-24 site drainage e-ins. Punchlist and Closeout Weeks 25-28 Correct any substandard work; site restora on and cleanup. The es mated schedule above is based on the full replacement op on. If full replacement is selected, we will explore prefabrica on of stair components, night work, and micro-phasing to compress work dura ons on-site, while coordina ng staging away from patron pathways. NOW Arena – Main Stair Repair RFP Facili es Page 23 of 89 • Scope narra ves and concept details (typical sec ons, connec on details, drainage improvements). • Risk/benefit and life cycle comparisons, including opera onal impacts and maintenance expecta ons. • Opinions of Probable Cost separated into Hard and So costs for each alterna ve. • Preferred approach with a preliminary phasing plan synchronized to the arena calendar. Deliver a comprehensive Final Report consolida ng findings, analysis, and recommenda ons, with visual aids (exis ng condi ons plans, concept plan/sec on). Present findings to Village leadership and/or elected officials if requested. • Design QA/QC: Internal peer reviews at Dra Recommenda ons and Final Report phases of the analysis. • Documenta on: Maintain organized records and mee ng minutes to support transparency and mely responses. • Local hydrology and drainage path evalua on (downspouts, plaza drainage, sub-slab flow paths). • Televising nearby storm sewer laterals to detect any joint failure or infiltra on. • High accuracy LiDAR or total sta on topographic surveying to document any out of plumb or misaligned condi ons. Our team specializes in developing contract plans, specifica ons, and cost es mates for concrete structural projects, resul ng from in-depth inspec ons, destruc ve and nondestruc ve tes ng evalua ons, and repair or replacement alterna ve analyses. NOW Arena – Main Stair Repair RFP Facili es Page 24 of 89 Address: 3S580 Naperville Road, Wheaton, IL 60189 Contact Person: Jason Berger Phone Number: 630-876-5912 Project Year: 2024-2026 Project Name: Forest Preserves Bridge Inventory and Inspec on Address: 536 N Harlem Ave., River Forest, IL 60305 Contact Person: Jordan McNally, PE (HW Lochner) Phone Number: 312-772-5648 Project Year: 2022-2026 Project Name: Forest Preserves of Cook County Structure and Repairs Address: 200 E. Randolph St., Chicago, IL 60601 Contact Person: Faruk Oksuz, PE (Black & Veatch Corpora on) Phone Number: 312-683-7850 Project Year: 2024 Project Name: Peoples Gas Tunnel Remedia on Program NOW Arena – Main Stair Repair RFP Facili es Page 25 of 89  Brad L. J. Noack, PE, SE STRUCTURAL ENGINEERING DEPARTMENT HEAD Mr. Noack is the Structural Department Head for DB Sterlin and has over 20 years of experience in project management and design of various engineering projects including highway bridges, elevated railroad structures, buildings, airport structures, and rehabilitation projects. Mr. Noack has managed and been responsible for many prominent transportation projects having extensive experience with the preparation of contract plans, technical specifications, cost Years with this firm: 3 estimates, and engineering reports. He also has extensive experience in bridge Years with other firms: 19 inspections and quality control and assurance. EDUCATION PROJECT EXPERIENCE Master of Science 95th Street Bridge over Calumet River Civil Engineering CHICAGO DEPARTMENT OF TRANSPORTATION University of Illinois at Chicago Structural Engineer of Record for various portions of the historic 95th Street 2009 Bascule Bridge over Calumet River replacement. These elements included Bachelor of Science various steel framing, fixed span concrete deck and sidewalk replacement, Civil Engineering dolphin replacement, railing replacement, and replacement bridge operator’s University of Illinois house. He was responsible for design, plans, specifications, quantities, and multi- at Urbana-Champaign firm coordination. The 95th Street Bridge over the Calumet River in Southeast 2003 Chicago underwent comprehensive structural rehabilitation. The scope included Bachelor of Science replacement of original steel beams with upgraded materials, modernization of Physics mechanical and electrical systems, and enhancement of pedestrian and cyclist Loyola University Chicago safety features. The project preserved the bridge’s historic integrity while 2001 ensuring compliance with current CDOT standards and addressing future load and traffic requirements. PROFESSIONAL REGISTRATION Chicago Bridge Inspection Team Bridge Inspections and Load Ratings CHICAGO DEPARTMENT OF TRANSPORTATION Structural Engineer Illinois # 081-007166 (2012) Quality Manager responsible for supervision and quality control for the Washington # 48462 inspections of various bridges, viaducts, and culverts throughout the City of Chicago. The work included bridge inspections, the development of bridge Professional Engineer condition reports and required IDOT forms, permitting, and coordination with Illinois # 062-061264 (2008) various entities such as CDOT, Metra, Amtrak, BNSF, and CN railroads. The Indiana # PE11200118 inspections consisted of NBIS routine, IDOT element level, NSTM, and special inspections. Load rating of structures was performed using AASHTOWare BrR TRAINING / CERTIFICATION software. The overall project objective was to ensure the CDOT bridges were IDOT Certified Bridge structurally adequate for their intended use. Inspection Program Manager – Digital Twin and AI-Powered Inspection of the Chicago Skyway Bridge Element Level # 00465 AREN AI FHWA-NHI-130078 Fracture Project Manager responsible for scheduling drone pilots and coordination with Critical Inspection Techniques railroads, utilities, and City of Chicago for flight authorization and access. DB for Steel Bridges Sterlin Consultants, Inc. (in partnership with Aren AI, SkyDeploy UAS, and Aerdia) was selected by the Skyway Concession Company (SCC) to complete drone inspections to develop a 3D digital twin model of Calumet River High Bridge and adjacent approach span viaducts, Chicago’s highest and longest bridge. In total, Page 26 of 89  Brad L. J. Noack, PE, SE STRUCTURAL ENGINEERING DEPARTMENT HEAD this bridge was a 7,243-foot-long, 43-span steel through truss and deck truss viaduct structure. The resulting model and AI software was used to automatically detect and quantify findings within 0.6mm accuracy and track changes over time. North Main Line Viaducts and Walls Structural Engineering CHICAGO TRANSIT AUTHORITY Structural Lead responsible for managing field operations for inspection of concrete viaduct walls and inspecting concrete viaduct walls, writing of inspection condition report with repair recommendations. The project consisted of investigating the deterioration of the viaducts and retaining walls along a four-mile section of the embankment- supported rail line on the busiest Chicago Transit Authority line. The scope included the preparation of repair plans to stabilize a 60-foot section of retaining wall that was leaning and exhibiting signs of movement. Wilson Station Renovation Structural Services CHICAGO TRANSIT AUTHORITY Structural Lead responsible for structural inspection of the historic station house and development of structural analysis, plans, and specifications for recommended rehabilitation of the Chicago Transit Authority’s (CTA) Wilson Station. The project included structural rehabilitation of the historic Wilson Station Gerber Building on CTA’s Red Line, the busiest rail line on the CTA system. DuPage County Various Bridge and or Retaining Wall Repairs DUPAGE COUNTY DIVISION OF TRANSPORTATION Project Manager for a task-based contract to provide preliminary investigations and Phase II structural engineering services in DuPage County, Illinois. Project tasks included the investigation of 11 bridges, including ground penetrating radar deck scanning for various repairs and thin polymer deck overlay; PS&E for bridge deck overlay and repairs to five of these structures; investigation of 11 retaining walls and PS&E for two walls; load rating the Medinah Road over Meacham Creek culvert; and training of DuPage DOT staff in AASHTOWare load rating software. Feasibility Study for Coffin Road Bridge VILLAGE OF LONG GROVE Project Manager conducted field inspection, hydraulic evaluation, and development of repair/rehabilitation recommendations and cost estimates for a more than 100-year-old pin-connected pony truss bridge in Long Grove, Illinois. The project included development of recommendations and cost estimates for the replacement of some of the bridge’s original historic features. FPDDC District-Wide Pedestrian Bridge Replacement Study FOREST PRESERVE DISTRICT OF DUPAGE COUNTY Project Manager for a project to provide bridge repair or replacement study services for four Forest Preserve District of DuPage County (FPDDC) bridges. The project included inspection reports for the four bridges. The project goal was to study several alternatives including multiple replacement structure types and present both initial engineer’s estimates of initial construction costs as well as 100-year life cycle cost estimates. Hidden Lake Forest Preserve Bridges: Phase II Engineering Services FOREST PRESERVE DISTRICT OF DUPAGE COUNTY Project Manager provided Phase II engineering services for the complete replacement of a prefabricated steel pedestrian bridge and the historic rehabilitation and strengthening of the 1870s wrought iron bowstring arch truss bridge crossing the East Branch DuPage River. The project required extensive permitting through the IDNR, Army Corps, Village of Downers Grove, DuPage County Building Department, and DuPage County Stormwater Management. Page 27 of 89  Michael Martin, PE STRUCTURAL PROJECT ENGINEER Mr. Martin is a Structural Project Engineer with 16 years of experience in structural bridge design, inspection, maintenance, and rehabilitation. Through his diverse experience, he is equipped with a deep understanding of the effort required to complete and deliver successful quality work. In addition, Mr. Martin has strong skills in leadership, teamwork, and mentorship. He has worked on projects with several agencies and municipalities including the Years with this firm: 1 Skyway Concession Company, IDOT, CDOT, and the Illinois Tollway. Years with other firms: 15 PROJECT EXPERIENCE EDUCATION CBIT Bridge Inspection Project Master of Science CHICAGO DEPARTMENTOF TRANSPORTATION Civil Engineering Project Engineer and Inspection Team Leader responsible for planning, Purdue University scheduling, and coordinating annual inspections. The team performed and West Lafayette, IN managed more than 50 bridge inspections, including bi-annual in-depth bridge 2008 inspections (NBIS Routine, Element, Fracture Critical). Scope of work Bachelor of Science included reporting of existing conditions and significant findings; completion Civil Engineering and submittal of IDOT forms to the Illinois Highway Information System; and Purdue University CDOT work items to the ATOM management inventory. West Lafayette, IN 2007 Jackson Blvd BCR Bridge Inspection Project CHICAGO DEPARTMENTOF TRANSPORTATION PROFESSIONAL REGISTRATION Project Engineer and Inspection Team Leader responsible for Bridge Condition Report (BCR) inspection and reporting for the fixed span portions of the Professional Engineer bascule lift bridge. Scope of work included reporting of existing conditions, Illinois #062-064595 significant findings and repair recommendations for the BCR. Indiana #1140029 Washington #51907 IDOT District 1 – Bridge Inspections ILLINOIS DEPARTMENTOF TRANSPORTATION TRAINING / CERTIFICATION Project Engineer and Inspection Team Leader responsible for planning, scheduling, and coordinating various IDOT bridge inspections. The team IDOT Certified Bridge performed numerous bridge inspections, including NBIS Routine, Element, Inspection Program Manager - Fracture Critical inspections. Scope of work included reporting of existing Element (00697) conditions and significant findings; and completion and submittal of IDOT NHI Certified Fracture Critical forms to the Illinois Highway Information System. Inspection Techniques (NHI 130053) AREMA Bridge Inspection O’Hare Airport 2025 Inspection Project CHICAGO DEPARTMENTOF AVIATION Certification S-BRITE Fatigue Inspection of Project Engineer and Inspection Team Leader responsible for planning, Steel Bridges Certification scheduling, and coordinating inspections at O’Hare International airport. The team performed inspections, including seven bridge inspections (NBIS Routine, and Element Level inspections) and seventeen overhead sign structures. Scope of work included reporting of existing conditions and significant findings, repair recommendations and preliminary repair cost estimates. Page 28 of 89  Michael Martin, PE STRUCTURAL PROJECT ENGINEER Annual State of the Chicago Skyway and Capital Improvement Program SKYWAY CONCESSION COMPANY Project Engineer and Inspection Team Leader responsible for planning, scheduling, and coordinating annual inspections, including coordination with multiple subconsultants, municipalities, railroads, coast guard, equipment rental, traffic control, and local businesses. He performed and managed annual bridge inspections, including multiple teams (6-10 inspectors_ efforts during bi-annual in-depth bridge inspections (NBIS Routine, Element, Fracture Critical). Led and managed reporting effort; including reporting of existing conditions and significant findings; repair recommendations, preliminary cost estimates for repair recommendations, and planning of repair/maintenance work over a 10-year Capital Improvement Plan. Annual inspections and reporting for the 7.8-mile-long Chicago Skyway Toll Bridge System. This comprised NBIS Routine, Element Level and Fracture Critical inspections of 60 bridges including the 7,243-foot-long, 43-span fracture critical steel through truss and deck truss viaduct centered over the Calumet River along with roadway (and ancillary structures) and facilities buildings inspections. Reporting included inspection findings, repair recommendations and rehabilitation/maintenance planning via a 10-year Capital Improvement Plan. Chicago Skyway Construction Inspection - Structural Steel and Substructure Concrete Repairs SKYWAY CONCESSION COMPANY Project Engineer and Inspection Team Leader responsible for performing preliminary sounding inspections and providing preliminary repair locations, quantities, and cost estimates for substructure concrete repairs. He reviewed shop drawings and submittals for adherence to repair plans and specifications. Mr. Martin conducted field observations for truss steel rehabilitation work to ensure adherence to plans and specifications and managed construction engineering inspectors to observe and document contractor progress during substructure concrete repair, including cleaning, and removal and replacement of existing reinforcement. This project involved Construction Inspection services for structural steel repairs on the 15-span Commercial Avenue structure and the 10-span 100th Street Viaduct structures of the Chicago Skyway in the City of Chicago as well as substructure concrete repairs to over 30 bridge structures, for a total of over 20,000 square feet of concrete repairs. IDOT Phase II Various Work Order Structural Services ILLINOIS DEPARTMENT OF TRANSPORTATION Project Engineer and Inspection Team Leader responsible for coordinating and scheduling field inspections in all nine IDOT districts with Bridge Maintenance Engineers. He performed Load Rating Inspections, provided information required for rating analysis; including communication of Critical Findings and emergency actions, such as reduced lane and shoring recommendations. In addition, he performed load rating analysis utilizing AASHTOWARE BrDR Software. Phase I Engineering for Kennedy Expressway (I-90) Rehabilitation, Edens Expressway (I-94) to Ohio Street ILLINOIS DEPARTMENT OF TRANSPORTATION Project Engineer and Inspection Team Leader responsible for planning, scheduling, and coordinating BCR inspections; including coordination with multiple subconsultants, CTA, equipment rental, traffic control, and local businesses. He performed and managed inspections and the inspection team for completion of in-depth BCR inspections of 36 bridges totaling 1.3 million square feet of deck area, including preliminary repair locations and quantity estimates for decks, superstructures, and substructures. In addition, he drafted 36 Bridge Condition Reports and cost estimates for joint replacements, deck overlays, steel superstructure cleaning and painting, PPC I-beam repair, and various substructure repairs totaling $75 Million of proposed work. IDOT Local Roads Structure Ratings ILLINOIS DEPARTMENT OF TRANSPORTATION Project Engineer responsible for creating and updating as-built and as-inspected AASHTOWARE models, performing load rating analysis utilizing AASHTOWARE BrDr software, and updating Load Rating Summary Reports. Page 29 of 89 DRAFT - OPINION OF PROBABLE COSTS Village of Hoffman Estates NOW ARENA EXTERIOR STAIR REPAIR OR REPLACEMENT DB STERLIN CONSULTANTS, INC. NOW ARENA EXTERIOR STAIR REPAIR OR REPLACEMENT - ASSESSMENT, RECOMMENDATIONS AND REPORT Site Assessment Estimated Hours Avg. Hourly Total - Kick-off Meeting 8 $200 $1,600 - Evaluation of Existing Conditions 32 $170 $5,440 - Oversight of Third Party Testing 16 $200 $3,200 - Condition Assessment, Accessibility, and Compliance 44 $175 $7,700 Draft Recommendations and Implementations Plan Estimated Hours Avg. Hourly Total - Provide Recommendations 32 $170 $5,440 - Develop Implementation Strategy 24 $200 $4,800 - Draft Opinions of Probable Cost 24 $170 $4,080 Final Report Estimated Hours Avg. Hourly Total - Prepare Report Findings, Analysis, and Recommendations 48 $170 $8,160 - Prepare Visual Aids 24 $155 $3,720 - Present Findings to Village (if needed) 24 $200 $4,800 QC/QA/PM/Admin. Tasks Estimated Hours Avg. Hourly Total - QC/QA (5% of 276 hours) 14 $270 $3,780 - Project Management/Administration (5% of 276 hours) 14 $270 $3,780 Direct Costs Direct Costs Total Ground Penetrating Radar Field Investigation $3,500 Concrete Coring and Restoration - 4 Cores Collected $2,550 Concrete Compressive Strength Testing ($125/Sample) $500 Field Supervision and Reporting $3,000 Inspection Vehicle (8 Days x $90/Day) $720 Sub-Total: $66,770 NOT-TO-EXCEED TOTAL FEE (Labor + Direct Costs) $66,770 Note: Development of construction documents, bid support, and construction phase support are not included in this Opinion of Probable Cost. However, these services may be provided at an additional cost. Page 30 of 89  HOFFMAN ESTATES DEPARTMENT OF FINANCE MONTHLY REPORT FEBRUARY 2026 Water Billing A total of 14,271 residential water bills were mailed on February 1st for December's water consumption. Average consumption was 4,610 gallons, resulting in an average residential water bill of $83.35. Total consumption for all customers was 109 million gallons, with 66 million gallons attributable to residential consumption. When compared to the February 2025 billing, residential consumption decreased by 2.9%. Total Water Consumption Total Water Consumption Year-To-Date Comparison Month of February Month of February 120 250 100 200 38 41 43 39 75 82 86 80 36 76 78 150 60 100 40 68 65 68 66 132 132 133 58 127 127 50 20 0 0 2022 2023 2024 2025 2026 2022 2023 2024 2025 2026 Residential Commercial Residential Commercial 1900 Hassell Road Hoffman Estates, Illinois 60169 www.hoffmanestates.org Phone: 847.882.9100 Fax: 847.843.4822 Page 31 of 89  Village Investments As of February 28, 2026, the Village's investment portfolio (not including pension trust funds) totaled $81.9 million. Of this amount, $64.5 million pertained to the various operating funds. As can be seen in the following graphs, the remaining $17.4 million is related to debt service and capital projects funds. Investment Portfolio by Fund Type Investment Portfolio by Type As February 28, 2026 As of February 28, 2026 0% 3% 21% 16% 24% 33% 79% 24% Money Market CD's Debt Service Operating Capital Projects IL Funds MaxSafe Treasury Bills/Municipal Bonds General Fund Investments 40.0 35.0 30.0 Millions of Dollars 25.0 20.0 15.0 10.0 5.0 0.0 Feb-25 Mar-25 Apr-25 May-25 Jun-25 Jul-25 Aug-25 Sep-25 Oct-25 Nov-25 Dec-25 Jan-26 Feb-26 2 Page 32 of 89  Operating Funds General Fund For the month of February, General Fund revenues totaled $9,375,753 and expenditures totaled $8,350,542 resulting in a surplus of $1,025,211. Revenues: February year-to-date figures are detailed in the table below. Property taxes are due in March and August every year. License and Permits are over budget due to large development building permits being paid. Intergovernmental revenues are over budget due to higher Local Use Tax received. Fines and Forfeits are under budget due to a delay from the County for court fines. Most miscellaneous revenues are not received on a monthly basis. YEAR-TO-DATE YEAR-TO-DATE REVENUES BUDGET ACTUAL VARIANCE Taxes $ 5,607,378 $ 8,191,844 46.1% Licenses & Permits 1,029,167 4,670,348 353.8% Intergovernmental 2,858,428 4,006,151 40.2% Charges for Services 1,970,833 1,741,605 -11.6% Fines & Forfeits 128,333 105,602 -17.7% Investments 200,000 193,950 -3.0% Miscellaneous 83,500 45,011 -46.1% Operating Transfers 41,667 - -100.0% TOTAL $ 11,919,307 $ 18,954,510 59.0% YTD Budget and Actual Comparison $9,000,000 $8,000,000 $7,000,000 $6,000,000 $5,000,000 Budget $4,000,000 Actual $3,000,000 $2,000,000 $1,000,000 $0 Taxes Lic. & Intergov't Serv. Chgs. Fines Investments Misc. Op Transfers Permits 3 Page 33 of 89  Hotel Tax $250,000 $200,000 $150,000 Dec-04 2025 Actual 2026 Budget 2026 Actual $100,000 $50,000 $0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Cumulative Variance 2026 Actual Month Received 2025 Actual 2026 Budget 2026 Actual vs. Budget Jan $ 88,073 $ 123,333 $ 99,828 $ (23,505) Feb $ 40,564 $ 123,333 $ 156,901 10,062 Mar $ 107,358 $ 123,333 Apr $ 157,882 $ 123,333 May $ 69,092 $ 123,333 Jun $ 139,928 $ 123,333 Jul $ 191,916 $ 123,333 Aug $ 135,070 $ 123,333 Sep $ 159,400 $ 123,333 Oct $ 112,785 $ 123,333 Nov $ 102,178 $ 123,333 Dec $ 232,103 $ 123,333 YTD Totals $ 1,536,349 $ 1,480,000 $ 256,730 4 Page 34 of 89  Real Estate Transfer Tax $450,000 $400,000 $350,000 $300,000 Dec-04 $250,000 2025 Actual 2026 Budget $200,000 2026 Actual $150,000 $100,000 1 $50,000 $0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Cumulative Variance 2026 Actual Month Received 2025 Actual 2026 Budget 2026 Actual vs. Budget Jan $404,185 $ 100,000 $ 141,302 $ 41,302 Feb 27,419 $ 100,000 83,175 24,477 Mar 42,318 $ 100,000 Apr 91,206 $ 100,000 May 61,044 $ 100,000 Jun 95,827 $ 100,000 Jul 86,215 $ 100,000 Aug 87,616 $ 100,000 Sep 57,164 $ 100,000 Oct 69,845 $ 100,000 Nov 89,035 $ 100,000 Dec 90,028 $ 100,000 YTD Totals $ 1,201,902 $ 1,200,000 $ 224,477 5 Page 35 of 89  Home Rule Sales Tax $700,000 $600,000 $500,000 $400,000 Dec-04 2025 Actual 2026 Budget $300,000 2026 Actual $200,000 $100,000 $0 Jan (Nov) Feb (Dec) Mar (Jan) Apr (Feb) May (Mar) Jun (Apr) Jul (May) Aug (Jun) Sep (Jul) Oct (Aug) Nov (Sep) Dec (Oct) Cumulative Variance Month Received 2026 Actual (Liability Period) 2025 Actual 2026 Budget 2026 Actual vs. Budget Jan (Nov) $507,966 $ 500,000 $ 601,437 $ 101,437 Feb (Dec) 443,795 500,000 558,904 160,341 Mar (Jan) 558,558 500,000 Apr (Feb) 470,363 500,000 May (Mar) 435,681 500,000 Jun (Apr) 518,884 500,000 Jul (May) 482,274 500,000 Aug (Jun) 538,564 500,000 Sep (Jul) 556,545 500,000 Oct (Aug) 579,664 500,000 Nov (Sep) 510,038 500,000 Dec (Oct) 550,803 500,000 YTD Totals $ 6,153,135 $ 6,000,000 $ 1,160,341 6 Page 36 of 89  Telecommunications Tax $90,000 $80,000 $70,000 2025 Actual $60,000 2026 Budget 2026 Actual $50,000 Dec-04 $40,000 $30,000 $20,000 $10,000 $0 Jan (Oct) Feb (Nov) Mar (Dec) Apr (Jan) May (Feb) Jun (Mar) Jul (Apr) Aug (May) Sep (Jun) Oct (Jul) Nov (Aug) Dec (Sep) Cumulative Variance Month Received 2026 Actual (Liability Period) 2025 Actual 2026 Budget 2026 Actual vs. Budget Jan (Oct) $67,263 $ 60,450 $ 63,425 $ 2,975 Feb (Nov) 64,510 60,450 62,535 5,060 Mar (Dec) 68,821 60,450 Apr (Jan) 60,259 60,450 May (Feb) 73,977 60,450 Jun (Mar) 68,979 60,450 Jul (Apr) 66,983 60,450 Aug (May) 69,021 60,450 Sep (Jun) 81,753 60,450 Oct (Jul) 64,845 60,450 Nov (Aug) 73,684 60,450 Dec (Sep) 61,917 60,450 YTD Totals $ 822,012 $ 725,400 $ 125,960 7 Page 37 of 89  Building Permits $3,500,000 $3,000,000 $2,500,000 $2,000,000 Dec-04 2025 Actual 2026 Budget 2026 Actual $1,500,000 $1,000,000 $500,000 $0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Cumulative Variance 2026 Actual Month Received 2025 Actual 2026 Budget 2026 Actual vs. Budget Jan $62,321 $ 458,333 $ 2,962,976 $ 2,504,643 Feb 532,532 458,333 1,691,210 3,737,519 Mar 381,361 458,333 Apr 103,334 458,333 May 78,044 458,333 Jun 196,296 458,333 Jul 87,686 458,333 Aug 68,274 458,333 Sep 161,813 458,333 Oct 197,115 458,333 Nov 1,847,077 458,333 Dec 57,212 458,333 YTD Totals $ 3,773,065 $ 5,500,000 $ 4,654,185 8 Page 38 of 89  State Sales Tax $1,200,000 $1,000,000 $800,000 Dec-04 2025 Actual $600,000 2026 Budget 2026 Actual $400,000 $200,000 $0 Jan (Nov) Feb (Dec) Mar (Jan) Apr (Feb) May (Mar) Jun (Apr) Jul (May) Aug (Jun) Sep (Jul) Oct (Aug) Nov (Sep) Dec (Oct) Cumulative Variance Month Received 2026 Actual (Liability Period) 2025 Actual 2026 Budget 2026 Actual vs. Budget Jan (Nov) $898,813 $ 883,333 $ 1,015,549 $ 132,216 Feb (Dec) 863,110 883,333 943,855 192,737 Mar (Jan) 1,004,954 883,333 Apr (Feb) 842,181 883,333 May (Mar) 779,724 883,333 Jun (Apr) 973,989 883,333 Jul (May) 911,229 883,333 Aug (Jun) 940,535 883,333 Sep (Jul) 947,868 883,333 Oct (Aug) 986,395 883,333 Nov (Sep) 927,113 883,333 Dec (Oct) 950,798 883,333 YTD Totals $ 11,026,709 $ 10,600,000 $ 1,959,405 9 Page 39 of 89  Income Tax $1,800,000 $1,600,000 $1,400,000 $1,200,000 ### $1,000,000 2025 Actual 2026 Budget $800,000 2026 Actual $600,000 $400,000 $200,000 $0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Cumulative 2024-2025 2025-2026 Variance Month Month 2026 Actual Received Liab Pd 2025 Actual Received 2026 Budget Liab Pd 2026 Actual vs. Budget Jan 24-Dec $959,934 Jan $ 760,738 Dec-25 $ 999,806 $ 239,069 Feb 25-Jan 784,186 Feb 760,738 Jan-26 800,836 279,167 Mar 25-Feb 503,166 Mar 760,738 Feb-26 Apr 25-Mar 921,369 Apr 760,738 Mar-26 May 25-Apr 1,643,815 May 760,738 Apr-26 Jun 25-May 570,082 Jun 760,738 May-26 Jul 25-Jun 956,934 Jul 760,738 Jun-26 Aug 25-Jul 548,460 Aug 760,738 Jul-26 Sep 25-Aug 467,752 Sep 760,738 Aug-26 Oct 25-Sep 1,007,594 Oct 760,738 Sep-26 Nov 25-Oct 579,634 Nov 760,738 Oct-26 Dec 25-Nov 530,562 Dec 760,738 Nov-26 YTD Totals $ 9,473,488 $ 9,128,850 $ 1,800,641 10 Page 40 of 89  Fines $90,000 $80,000 $70,000 $60,000 Dec-04 $50,000 2025 Actual 2026 Budget $40,000 2026 Actual $30,000 $20,000 $10,000 $0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Cumulative Variance 2026 Actual Month Received 2025 Actual 2026 Budget 2026 Actual vs. Budget Jan $62,547 $ 64,167 $ 77,025 $ 12,858 Feb 44,970 64,167 28,576 (22,732) Mar 49,421 64,167 Apr 64,019 64,167 May 64,390 64,167 Jun 54,969 64,167 Jul 77,782 64,167 Aug 37,727 64,167 Sep 59,433 64,167 Oct 52,105 64,167 Nov 49,759 64,167 Dec 73,386 64,167 YTD Totals $ 690,508 $ 770,000 $ 105,601 11 Page 41 of 89 Expenditures: General Fund expenditures in February were $1,270,626 above the budgeted figure of $7,079,916. The summary of year-to-date actuals versus budgeted expenditures shown below reflect positive variances for the Village departments for the year. Administration is over budget due to annual memberships and dues paid at the beginning of the year. Police and Fire are over budget due to their pension contribution expenses, which are directly tied to the Village's receipt of property taxes. When property taxes are received, the pension contribution expense (transfer of property tax revenue to the Pension Funds) occurs. YEAR-TO-DATE YEAR-TO-DATE EXPENDITURES BUDGET ACTUAL VARIANCE Legislative $ 86,495 $ 56,816 34.3% Administration 184,452 214,195 -16.1% Legal 95,767 32,178 66.4% Finance 240,165 225,360 6.2% Village Clerk 51,468 44,031 14.4% HRM 152,412 133,314 12.5% Communications 84,112 56,759 32.5% Spatial Technology 126,205 39,032 69.1% Police 4,419,173 5,758,956 -30.3% Fire 4,303,805 4,798,716 -11.5% Public Works 1,692,623 1,462,996 13.6% Development Services 1,134,320 857,654 24.4% H&HS 283,407 232,382 18.0% Miscellaneous 1,303,847 49,015 96.2% TOTAL $ 14,158,250 $ 13,961,405 1.4% YTD Budget and Actual Comparison $6,000,000 $5,000,000 $4,000,000 $3,000,000 Budget Actual $2,000,000 $1,000,000 $0 General Police Fire Public Works Devel. Health & Misc. Services Admin. Services Human Svcs 12 Page 42 of 89  Department News During the month of February, the following training sessions were attended by Finance staff: • Attended the Sikich webinar “Yellowbook Session 1: Preparing for an Annual Comprehensive Financial Report” (Various Finance Staff) • Attended BS&A Training on various Finance procedures including payroll, accounts payable, accounts receivable, utility billing and general ledger (various Finance staff) Also during the month, Finance staff participated in the following events and planning meetings: • Completed the final FY2026 Operating and Capital Budget document and submitted it to the Government Finance Officers Association for the GFOA Budget Award. The final budget document is now available on the Village website. Many thanks goes out to everyone who was involved with putting together the final budget document. • Staff is working hard in preparation for final audit fieldwork, which begins March 16th for FY2025. Respectfully Submitted, Rachel Musiala 13 Page 43 of 89  MONTHLY REPORT STATISTICS February-26 % Inc / Dec Feb-26 YTD Feb-26 Feb-25 YTD Feb-25 Month Year Credit Card Transactions Finance and Code Front Counter Number 454 709 252 535 80.2% 32.5% Amount $ 67,195 123,177 $ 33,385 81,981 101.3% 50.3% Internet Sales Number 3,133 6,092 2,643 5,714 18.5% 6.6% Amount $ 503,453 991,601 $ 326,210 764,427 54.3% 29.7% Total Number 3,587 6,801 2,895 6,249 23.9% 8.8% Amount $ 570,647 1,114,778 $ 359,595 846,409 58.7% 31.7% Credit Card Company Fees General Fund $ 736 868 $ 119 239 516.5% 263.6% Water Fund 13,137 22,544 7,590 15,139 73.1% 48.9% Total Fees $ 13,873 $ 23,412 $ 7,709 $ 15,378 80.0% 52.2% Accounts Receivable Invoices Mailed Number 38 85 41 136 -7.3% -37.5% Amount $ 123,320 275,832 $ 138,961 300,773 -11.3% -8.3% Invoices Paid Number 31 114 60 130 -48.3% -12.3% Amount $ 105,955 269,546 $ 80,021 198,166 32.4% 36.0% Reminders Sent Number 12 22 18 25 -33.3% -12.0% Amount $ 3,215 62,975 $ 59,568 61,711 -94.6% 2.0% Accounts Payable Checks Issued Number 359 699 311 661 15.4% 5.7% Amount $ 2,203,710 5,660,080 $ 2,166,759 4,364,506 1.7% 29.7% Manual Checks Issued - Number 20 47 28 80 -28.6% -41.3% As % of Total Checks 5.57% 13.51% 9.00% 12.10% -38.1% 11.6% Amount $ 35,442 187,837 $ 635,910 836,835 -94.4% -77.6% As % of Total Checks 1.61% 6.02% 29.35% 19.17% -94.5% -68.6% Utility Billing New Utility Accounts 45 91 46 85 -2.2% 7.1% Bills Mailed / Active Accounts 15,036 30,647 15,740 31,482 -4.5% -2.7% Final Bills Mailed 56 108 59 111 -5.1% -2.7% Shut-Off Notices - 999 1,045 2,187 -100.0% -54.3% Actual Shut-Offs - - 4 11 -100.0% -100.0% Total Billings $ 2,484,238 5,000,361 $ 2,172,656 4,277,641 14.3% 16.9% Direct Debit (ACH) Program New Accounts (463) (420) 34 184 -1461.8% -328.3% Total Accounts 6,389 13,241 6,550 13,076 -2.5% 1.3% As % of Active Accounts 42.49% 86.38% 41.61% 41.53% 0.9% 108.0% Water Payments Received in Current Month Total Bills Mailed 15,036 30,647 15,740 31,482 -4.5% -2.7% ACH Payments 6,389 13,241 6,550 13,076 -2.5% 1.3% ACH Payments-% of Total Bills 42.49% 86.38% 41.61% 41.53% 2.1% 108.0% On-line Payments (Internet Sales) 2,566 5,158 2,248 4,713 14.1% 9.4% On-line Payments-% of Total Bills 17.07% 33.67% 14.28% 29.94% 19.5% 12.5% Over-the-phone Payments 338 615 455 955 -25.7% -35.6% Over-the-phone Payments-% of Total Bills 2.25% 4.02% 2.89% 3.03% -22.2% 32.6% Mail-in Payments 3,864 10,498 6,094 12,302 -36.6% -14.7% Mail-in Payments-% of Total Bills 25.70% 68.19% 38.72% 39.08% -33.6% 74.5% Page 44 of 89  WATER BILLING ANALYSIS February 28, 2026 Residential Billings Average Monthly Consumption/Customer Month Billed 2023-2024 2024-2025 2025-2026 February 3,945 4,370 4,610 March 3,766 3,886 3,895 April 4,361 4,092 3,813 May 3,753 4,014 4,045 June 4,878 4,319 4,847 July 5,692 4,910 4,884 August 4,780 4,670 4,952 September 5,031 5,320 5,093 October 4,377 5,320 4,374 November 4,191 4,197 4,553 December 4,079 4,103 3,782 January 4,203 4,352 4,687 February 4,370 4,612 4,610 13 Month Average - 4,417 4,474 4,473 % Change - 0.0% 1.3% 0.0% Total Water Customers Average Bill Customer Type Customer Type Feb-25 Feb-26 % Change Feb-25 Feb-26 % Change Residential 14,832 14,271 -3.8% Residential $ 73.89 $ 62.23 -15.8% Commercial 908 751 -17.3% Total 15,740 15,022 -4.6% Total Consumption - All Customers (000,000's) Month-To-Date Year-To-Date Feb-25 Feb-26 % Change Feb-25 Feb-26 % Change Residential 68 66 -3.3% Residential 132 133 0.6% Commercial 41 43 4.6% Commercial 82 86 4.7% 109 109 -0.3% 214 219 2.2% Page 45 of 89  STATEMENT OF INVESTMENTS-VILLAGE As of February 28, 2026 Investment Book Market Maturity Rate of Fund Date Value Value Value Interest General Fund Illinois Funds - General 3,649,568.55 4.504 Illinois Funds - Veterans Memorial 373.59 4.504 HE Community Bank-Money Marke 4,219,502.92 4.560 Treasury Bills/Municipal Bonds 07/9/25-02/28/26 762,812.85 802,400.00 802,400.00 1.500 PMA iPrime 1,560,228.28 4.240 CD with PMA 20,684,200.00 21,248,000.00 22,246,445.41 4.210 30,876,686.19 Motor Fuel Tax Illinois Funds 474,069.24 4.504 HE Community Bank-Money Market 149,324.04 4.560 623,393.28 Asset Seizure - State Illinois Funds 66,355.59 4.504 Asset Seizure - BATTLE Illinois Funds 1,076.27 4.504 Municipal Waste System Illinois Funds 290,053.95 4.504 HE Community Bank-Money Market 0.00 4.560 290,053.95 2015A & 2015C G.O.D. S. HE Community Bank-Money Market 75,739.98 4.560 Central Road Corridor Improv. Illinois Funds 53,203.98 4.504 PMA iPrime 4,538.57 4.240 57,742.55 Hoffman Blvd Bridge Maintenance Illinois Funds 13,396.04 4.504 HE Community Bank-Money Market 294,460.00 4.560 307,856.04 Western Corridor Illinois Funds 2,049,277.01 4.504 PMA iPrime 559,341.16 4.240 2,608,618.17 Page 46 of 89  STATEMENT OF INVESTMENTS-VILLAGE As of February 28, 2026 Investment Book Market Maturity Rate of Fund Date Value Value Value Interest Prairie Stone Capital Illinois Funds 480,210.72 4.504 PMA iPrime 2,432,065.85 4.240 2,912,276.57 Road Improvement Illinois Funds 729,843.21 4.504 HE Community Bank-Money Market 1,128,304.21 4.560 Treasury Bills 07/09/25-02/28/26 740,377.17 778,800.00 778,800.00 1.500 PMA iPrime 6,080.76 4.240 2,604,605.35 Western Area Rd Impr Impact Fees Illinois Funds 1,317,723.81 4.504 HE Community Bank-Money Market 48,847.56 4.560 1,366,571.37 Capital Improvements Illinois Funds 1,131,999.16 4.504 PMA iPrime 91,792.75 4.240 1,223,791.91 Capital Vehicle & Equipment Illinois Funds 1,688,439.99 4.504 PMA iPrime 73,566.82 4.240 HE Community Bank-Money Market 526,772.44 IMET Convenience Fund 10/20/05 0.00 - 2,288,779.25 Capital Replacement Illinois Funds 1,717,518.77 4.504 HE Community Bank-Money Marke 1,035,382.53 4.560 PMA iPrime 303,808.57 4.240 3,056,709.87 Water and Sewer Illinois Funds 191,787.98 4.504 Treasury Bills 07/09/25-02/28/26 740,377.17 751,359.47 740,377.18 1.500 PMA iPrime 5,961,232.31 4.240 HE Community Bank-Money Market 3,556,345.20 4.560 CD with PMA 04/30/25-10/2/25 5,470,400.00 10,680,800.00 10,680,800.00 4.210 15,920,142.66 Water and Sewer-2017 Bond Projects PMA iPrime - 4.240 Page 47 of 89  STATEMENT OF INVESTMENTS-VILLAGE As of February 28, 2026 Investment Book Market Maturity Rate of Fund Date Value Value Value Interest Now Arena Operating Illinois Funds 456,794.01 4.504 HE Community Bank-Money Market 1,550,462.05 4.560 PMA iPrime 720,120.93 4.240 CD with PMA 04/30/25-10/2/25 716,900.00 716,900.00 749,380.05 4.210 3,444,276.99 Now Arena H.E. Community Bank-MaxSafe 2,822,661.00 4.560 Insurance Illinois Funds 265,966.58 4.504 HE Community Bank-Money Market 512,402.11 4.560 PMA iPrime 797,923.07 4.240 IMET Convenience Fund 10/20/05 0.00 - CD with PMA 04/30/25-10/2/25 477,300.00 477,300.00 499,508.72 4.210 2,053,591.76 Information Technology Illinois Funds 1,900,025.36 4.504 HE Community Bank-Money Market 190,230.73 4.560 PMA iPrime 419,651.31 4.240 CD with PMA 04/30/25-10/2/25 0.00 - - 4.210 2,509,907.40 Roselle Road TIF Illinois Funds 2,082,802.21 4.504 HE Community Bank-Money Market 1,368,444.35 4.560 PMA iPrime 138,067.33 4.240 3,589,313.89 Barr./Higgins TIF Illinois Funds 199,203.88 4.504 HE Community Bank-Money Market 1,061,107.47 4.560 1,260,311.35 2019 Captial Project Fund HE Community Bank-Money Market 527,962.93 4.560 Lakewood Center TIF Illinois Funds 430,671.78 4.504 HE Community Bank-Money Market 49,650.45 4.560 480,322.23 Page 48 of 89  STATEMENT OF INVESTMENTS-VILLAGE As of February 28, 2026 Investment Book Market Maturity Rate of Fund Date Value Value Value Interest Hig/Old Sutton TIF HE Community Bank-Money Market 72,529.76 4.560 Hig/Hassell TIF HE Community Bank-Money Market 488,930.89 4.560 2018G.O. Debt Serv. HE Community Bank-Money Market 0.00 4.560 2024 G.O. Debt Serv. PMA iPrime 323,417.00 4.240 Total Investments $ 81,853,624.20 Percent Total Invested Per Institution Invested Illinois Funds 19,190,361.68 23.44 CD with PMA 27,348,800.00 33.41 HE Community Bank-MaxSafe 2,822,661.00 3.45 HE Community Bank-Money Market 16,856,399.62 20.59 Treasury Bills/Municipal Bonds 2,243,567.19 2.74 ISC at PMA 13,391,834.71 16.36 $81,853,624.20 100.00 Total Invested Per Fund Total Investments - Operating Funds 64,499,553.21 Total Investments - Debt Service Funds 399,156.98 Total Investments - Capital Projects Funds $16,954,914.01 Total Investments - All Funds $81,853,624.20 - Page 49 of 89  PMA INVESTMENTS February 28, 2026 Settlement Maturity Cost Market Value Interest Rate GENERAL FUND US Treasury N/B (50976) 2/24/2022 2/28/2026 762,813 802,400 0.500% Cendera Bank, National Assoc. 6/30/2025 3/27/2026 242,800 242,800 3.930% Western Alliance Bank 6/30/2025 3/27/2026 242,700 242,700 4.002% Customers Bank 6/30/2025 3/27/2026 242,700 242,700 3.954% Harmony Bank 6/30/2025 3/27/2026 242,800 242,800 3.939% GBank 6/30/2025 3/27/2026 242,500 242,500 4.052% Winchester Savings Bank 6/30/2025 3/27/2026 242,800 242,800 3.939% iPrime Term Series 20260406AA105556 9/27/2024 4/6/2026 3,000,000 3,000,000 3.603% T Bank, National Association 8/8/2025 8/7/2026 239,900 239,900 4.116% Cornerstone Bank 8/8/2025 8/7/2026 240,100 240,100 4.024% Solera National Bank 8/8/2025 8/7/2026 239,900 239,900 4.122% Iprime Term Series 8/15/2025 8/14/2026 2,108,000 2,108,000 3.850% iPrime Term Series 20260724AA1053647-23 7/25/2025 7/24/2026 6,400,000 6,400,000 4.200% iPrime Term Series 5/9/2025 11/10/2026 2,000,000 2,000,000 3.800% iPrime Term Series 5/30/2025 12/2/2026 5,000,000 5,000,000 3.950% GENERAL FUND TOTALS: $21,447,013 $21,486,600 ROAD IMPROVEMENT FUND US Treasury N/B (50976) 02/24/22 02/28/26 740,377 778,800 0.500% ROAD IMPROVEMENT TOTALS: $740,377 $778,800 WATER & SEWER FUND US Treasury N/B (50976) 2/24/2022 02/28/26 740,377 778,800 0.500% Boone Bank & Trust Co 6/30/2025 03/27/26 242,800 242,800 3.930% Preferred Bank 6/30/2025 03/27/26 242,400 242,400 4.161% ServisFirst Bank 6/30/2025 03/27/26 242,600 242,600 4.059% Cross River Bank 6/30/2025 03/27/26 242,800 242,800 3.930% Customers Bank 11/18/2025 08/14/26 1,540,500 1,540,500 3.610% Financial Federal Bank 11/18/2025 08/14/26 243,100 243,100 3.800% FirstBank Southwest 11/18/2025 08/14/26 243,400 243,400 3.612% Flagstar Bank, National Association 11/18/2025 08/14/26 243,300 243,300 3.679% New Republic Bank 11/18/2025 08/14/26 243,300 243,300 3.664% American Pride Bank 11/18/2025 08/14/26 243,400 243,400 3.610% Bank of China 11/18/2025 08/14/26 242,800 242,800 3.959% iPrime Term Series 12/5/2025 12/04/26 1,500,000 1,500,000 3.440% WATER & SEWER TOTALS: $6,210,777 $6,249,200 NOW ARENA FUND Bank Hapoalim B.M. 05/01/25 07/24/26 238,600 238,600 3.800% Baxter Credit Union 05/01/25 07/24/26 238,300 238,300 3.893% Nex Bank 08/08/25 08/07/26 240,000 240,000 4.143% NOW ARENA TOTALS: $ 716,900.00 $ 716,900.00 INSURANCE FUND Premier Bank 05/01/25 07/24/26 238,600 238,600 3.792% American Commercial Bank & Trust Nat'l Assn 05/01/25 07/24/26 238,700 238,700 3.772% INSURANCE TOTALS: $ 477,300.00 $ 477,300.00 TOTAL: $29,592,367 $29,708,800 Page 50 of 89  OPERATING REPORT SUMMARY REVENUES February 28, 2026 CURRENT MONTH YEAR-TO-DATE ANNUAL % ACTUAL BENCH- BUDGET ACTUAL BUDGET ACTUAL BUDGET TO BUDGET MARK General Fund Property Taxes 2,000,000 - 2,000,000 1,215,468 13,654,510 8.9% Hotel Tax 123,333 156,901 246,667 256,729 1,480,000 17.3% Real Estate Transfer Tax 100,000 83,175 200,000 224,477 1,200,000 18.7% Home Rule Sales Tax 500,000 558,904 1,000,000 1,160,342 6,000,000 19.3% Telecommunications Tax 60,450 62,535 120,900 125,960 725,400 17.4% Property Tax - Fire 750,000 1,607,407 750,000 2,090,998 5,930,460 35.3% Property Tax - Police 1,000,000 2,200,417 1,000,000 2,901,619 7,185,920 40.4% Other Taxes 144,906 87,876 289,812 216,252 1,738,870 12.4% Total Taxes 4,678,689 4,757,215 5,607,378 8,191,844 37,915,160 21.6% Business Licenses 33,333 1,951 66,667 6,077 400,000 1.5% Liquor Licenses 22,917 4,855 45,833 10,085 275,000 3.7% Building Permits 458,333 1,691,210 916,667 4,654,186 5,500,000 84.6% Total Licenses & Permits 514,583 1,698,016 1,029,167 4,670,348 6,175,000 75.6% Sales Tax 883,333 943,855 883,333 1,959,404 10,600,000 18.5% Grocery Tax 66,667 - 133,333 - 800,000 0.0% Local Use Tax 16,167 30,924 32,333 72,652 194,000 37.4% State Income Tax 779,292 800,836 1,558,583 1,800,642 9,351,500 19.3% Replacement Tax 34,964 - 69,928 65,395 419,570 15.6% Other Intergovernmental 90,458 70,543 180,917 108,058 1,085,500 10.0% Total Intergovernmental 1,870,881 1,846,158 2,858,428 4,006,151 22,450,570 17.8% Engineering Fees 66,667 143,878 133,333 143,878 800,000 18.0% Ambulance Fees 204,167 147,232 408,333 354,354 2,450,000 14.5% GEMT Income 204,167 162,169 408,333 478,893 2,450,000 19.5% Police Hireback 37,500 45,611 75,000 91,832 450,000 20.4% Lease Payments 50,458 17,994 100,917 85,281 605,500 14.1% Cable TV Fees 122,500 111,308 162,500 111,308 455,300 24.4% 4th of July Proceeds - - - - 100,000 0.0% Employee Payments 150,000 44,953 300,000 166,655 1,800,000 9.3% Hireback - Arena 25,000 59,405 50,000 79,423 300,000 26.5% Rental Inspection Fees 10,000 67,050 160,000 67,563 250,000 27.0% Other Charges for Services 86,208 130,371 172,417 162,416 1,034,500 15.7% Total Charges for Services 956,667 929,972 1,970,833 1,741,605 10,695,300 16.3% Court Fines-County 12,083 50 24,167 11,893 145,000 8.2% Ticket Fines-Village 20,833 20,787 41,667 46,234 250,000 18.5% Overweight Truck Fines 1,250 520 2,500 1,920 15,000 12.8% Red Light Camera Revenue 25,833 2,525 51,667 34,100 310,000 11.0% Local Debt Recovery 4,167 4,694 8,333 11,454 50,000 22.9% Total Fines & Forfeits 64,167 28,576 128,333 105,602 770,000 13.7% Total Investment Earnings 100,000 92,206 200,000 193,950 1,200,000 16.2% Reimburse/Recoveries 14,583 7,482 29,167 10,826 175,000 6.2% S.Barrington Fuel Reimbursement 2,917 3,519 5,833 6,621 35,000 18.9% Shaumburg Twn Fuel Reimbursement 3,750 2,351 7,500 5,007 45,000 11.1% Tollway Payments 3,000 - 6,000 9,010 36,000 25.0% Other Miscellaneous 17,500 10,258 35,000 13,546 210,000 6.5% Total Miscellaneous 41,750 23,611 83,500 45,011 501,000 9.0% Total Operating Transfers In 20,833 - 41,667 - 250,000 0.0% Total General Fund 8,247,570 9,375,753 11,919,307 18,954,510 79,957,030 23.7% 16.7% Page 51 of 89  OPERATING REPORT SUMMARY REVENUES February 28, 2026 CURRENT MONTH YEAR-TO-DATE ANNUAL % ACTUAL BENCH- BUDGET ACTUAL BUDGET ACTUAL BUDGET TO BUDGET MARK Water & Sewer Fund Water Sales 2,150,556 2,015,749 4,301,112 4,121,927 25,806,670 16.0% Connection Fees 4,167 13,189 8,333 24,086 50,000 48.2% Cross Connection Fees 3,167 6,374 6,333 6,377 38,000 16.8% Penalties 10,833 0 21,667 (37) 130,000 0.0% Investment Earnings 66,667 50,848 133,333 100,249 800,000 12.5% Other Revenue Sources 2,333 10,422 4,667 19,502 28,000 69.7% Capital Projects - - - - 6,000,000 0.0% Total Water Fund 2,237,723 2,096,581 4,475,445 4,272,105 32,852,670 13.0% 16.7% Motor Fuel Tax Fund 201,697 207,921 403,393 421,643 2,420,360 17.4% Community Dev. Block Grant Fund 22,250 - 44,500 - 267,000 0.0% Asset Seizure Fund - 62,520 - 80,305 - N/A Municipal Waste System Fund 329,175 586,719 658,350 591,963 3,950,100 15.0% NOW Arena Operating Fund 336,507 251,656 673,013 555,721 4,038,080 13.8% NOW Arena Activity Fund 1,528,263 - 3,056,527 - 18,339,160 0.0% Stormwater Management 151,667 301,760 303,333 551,805 1,820,000 30.3% Insurance Fund 206,648 188,388 413,297 377,628 2,479,780 15.2% Roselle Road TIF 71,667 24,518 143,333 467,510 860,000 54.4% Barrington/Higgins TIF - 3,743 - 7,395 - N/A Lakewood Center TIF 47,917 1,426 95,833 2,999 575,000 0.5% Higgins-Old Sutton TIF 14,861 215 29,722 414 178,330 0.2% Stonington-Pembroke TIF 75,694 58,820 151,388 171,540 908,330 18.9% Higgins/Hassell TIF 54,583 1,452 109,167 340,170 655,000 51.9% Information Technology 234,732 177,362 469,463 356,569 2,816,780 12.7% Total Spec Rev. & Int. Svc. Fund 3,275,660 1,866,502 6,551,320 3,925,660 39,307,920 10.0% TOTAL OPERATING FUNDS 13,760,953 13,338,836 22,946,072 27,152,275 152,117,620 17.8% 16.7% 2015A & C G.O. Debt Service 225 225 679 679 3,932,450 0.0% 2015B G.O. Debt Service - - - - 124,700 0.0% 2016 G.O. Debt Service - - 132,192 132,192 284,100 46.5% 2017A & B G.O. Debt Service - - - - 181,750 0.0% 2018 G.O. Debt Service 19,500 19,500 89,980 89,980 2,946,950 3.1% 2019 G.O. Debt Service - - - - 136,710 0.0% 2024 G.O. Debt Service - - - - 385,530 0.0% TOTAL DEBT SERV. FUNDS 19,725 19,725 222,851 222,851 7,992,190 2.8% 16.7% Central Rd. Corridor Fund 83.33 169 167 348 1,000 34.8% Hoffman Blvd Bridge Maintenance 833.33 914 1,667 1,762 10,000 17.6% Western Corridor Fund 118,750.00 7,464 237,500 16,072 1,425,000 1.1% Prairie Stone Capital Fund 279,166.67 7,395 558,333 16,242 3,350,000 0.5% Western Area Traffic Impr. Impact Fee 3,333.33 4,057 6,667 4,234 40,000 10.6% Capital Improvements Fund 177,916.67 241,787 355,833 474,887 2,135,000 22.2% Capital Vehicle & Equipment Fund 205,731.67 6,758 411,463 13,657 2,468,780 0.6% Capital Replacement Fund 16,666.67 8,924 33,333 17,720 200,000 8.9% 2019 Project Fund 19,166.67 1,568 38,333 3,058 230,000 1.3% 2025 Project Fund - 878 - 2,601 - N/A 2026 Project Fund 1,333,333.33 - 2,666,667 - 16,000,000 0.0% Road Improvement Fund 919,390.00 162,367 1,838,780 349,305 11,032,680 3.2% TOTAL CAP. PROJECT FUNDS 3,074,372 442,280 6,148,743 899,885 36,892,460 2.4% 16.7% Police Pension Fund 735,143 2,280,864 1,470,287 3,065,136 8,821,720 34.7% Fire Pension Fund 646,253 1,693,428 1,292,505 2,265,387 7,755,030 25.7% TOTAL TRUST FUNDS 1,381,396 3,974,292 2,762,792 5,330,523 16,576,750 32.2% 16.7% TOTAL ALL FUNDS 18,236,445 17,775,133 32,080,458 33,605,535 213,579,020 15.7% 16.7% Page 52 of 89  OPERATING REPORT SUMMARY EXPENDITURES February 28, 2026 CURRENT MONTH YEAR-TO-DATE ANNUAL BENCH- BUDGET ACTUAL BUDGET ACTUAL BUDGET % MARK General Fund General Admin. Legislative 43,248 34,554 86,495 56,816 518,970 10.9% Administration 92,226 109,723 184,452 214,195 1,106,710 19.4% Legal 47,883 19,497 95,767 32,178 574,600 5.6% Finance 120,083 97,961 240,165 225,360 1,440,990 15.6% Village Clerk 25,734 22,158 51,468 44,031 308,810 14.3% Human Resource Mgmt. 76,206 77,050 152,412 133,314 914,470 14.6% Spatial Technology 63,103 34,391 126,205 39,032 757,230 5.2% Communications 42,056 29,786 84,112 56,759 504,670 11.2% Total General Admin. 510,538 425,119 1,021,075 801,686 6,126,450 13.1% 16.7% Police Department Administration 176,744 296,370 353,488 455,343 2,120,930 21.5% Juvenile Investigations 82,006 124,429 164,012 191,612 984,070 19.5% Tactical 128,968 212,774 257,937 333,343 1,547,620 21.5% Patrol and Response 1,293,839 2,381,133 2,587,678 3,639,609 15,526,070 23.4% Traffic 97,745 135,968 195,490 197,671 1,172,940 16.9% Investigations 171,721 253,963 343,442 393,921 2,060,650 19.1% Community Relations 975 1,308 1,950 1,253 11,700 10.7% Communications 33,647 33,043 67,293 99,130 403,760 24.6% Canine 19,615 36,506 39,230 55,210 235,380 23.5% Special Services 21,214 42,991 42,428 64,505 254,570 25.3% Records 37,182 28,509 74,363 57,303 446,180 12.8% Administrative Services 135,204 115,403 270,408 228,036 1,622,450 14.1% Emergency Operations 10,727 4,869 21,453 42,020 128,720 32.6% Total Police 2,209,587 3,667,265 4,419,173 5,758,956 26,515,040 21.7% 16.7% Fire Department Administration 83,923 103,821 167,845 174,759 1,007,070 17.4% Public Education 12,972 27,258 25,943 54,587 155,660 35.1% Suppression 1,013,197 1,467,787 2,026,393 2,381,206 12,158,360 19.6% Emer. Med. Serv. 979,212 1,334,490 1,958,423 2,119,039 11,750,540 18.0% Prevention 58,563 34,319 117,125 66,776 702,750 9.5% Fire Stations 4,038 2,925 8,075 2,349 48,450 4.8% Total Fire 2,151,903 2,970,600 4,303,805 4,798,716 25,822,830 18.6% 16.7% Public Works Department Administration 35,151 32,355 70,302 61,905 421,810 14.7% Snow/Ice Control 182,770 197,585 365,540 567,221 2,193,240 25.9% Traffic Operations 109,789 92,947 219,578 166,676 1,317,470 12.7% Forestry 184,845 95,185 369,690 173,028 2,218,140 7.8% Facilities 112,631 84,780 225,262 150,264 1,351,570 11.1% Fleet Services 156,614 149,208 313,228 275,000 1,879,370 14.6% F.A.S.T. 21,523 22,275 43,047 26,869 258,280 10.4% Storm Sewers 42,988 21,051 85,977 42,033 515,860 8.1% Total Public Works 846,312 695,386 1,692,623 1,462,996 10,155,740 14.4% 16.7% Page 53 of 89  OPERATING REPORT SUMMARY EXPENDITURES February 28, 2026 CURRENT MONTH YEAR-TO-DATE ANNUAL BENCH- BUDGET ACTUAL BUDGET ACTUAL BUDGET % MARK Development Services Administration 42,005 20,092 84,010 35,076 504,060 7.0% Planning & Transportation 78,612 70,867 157,223 133,458 943,340 14.1% Code Enforcement 186,601 161,536 373,202 308,915 2,239,210 13.8% Engineering 173,014 123,170 346,028 261,621 2,076,170 12.6% Economic Development 86,928 55,557 173,857 118,583 1,043,140 11.4% Total Development Services 567,160 431,221 1,134,320 857,654 6,805,920 12.6% 16.7% Health & Human Services 141,703 125,302 283,407 232,382 1,700,440 13.7% 16.7% Miscellaneous 4th of July 4,082 4,082 6,582 6,582 275,500 2.4% Police & Fire Comm. 6,940 (278) 13,880 92 83,280 0.1% Misc. Boards & Comm. 29,203 26,975 58,407 32,808 350,440 9.4% Misc. Public Improvements 612,489 4,871 1,224,978 9,533 7,349,870 0.1% Total Miscellaneous 652,715 35,650 1,303,847 49,015 8,059,090 0.6% 16.7% Total General Fund 7,079,916 8,350,542 14,158,250 13,961,405 85,185,510 16.4% 16.7% Water & Sewer Fund Water Department 1,414,247 1,263,130 2,828,493 1,640,471 16,970,960 9.7% Sewer Department 226,553 194,819 453,107 362,228 2,718,640 13.3% Billing Division 90,734 72,024 181,468 140,947 1,088,810 12.9% Debt Service Division - - 61,400 61,400 145,800 42.1% Capital Projects Division 151,643 151,643 151,643 151,643 10,740,000 1.4% 2015 Bond Capital Projects - - - - 421,200 0.0% 2017 Bond Capital Projects - - - - 484,520 0.0% 2018 Bond Capital Projects - - - - 247,640 0.0% 2019 Bond Capital Projects - - - - 622,530 0.0% Operating Transfers 2,083 - 4,167 - 25,000 0.0% Total Water & Sewer 1,885,261 1,681,616 3,680,278 2,356,690 33,465,100 7.0% 16.7% Motor Fuel Tax 225,000 - 450,000 - 2,700,000 0.0% Community Dev. Block Grant Fund - - - - 267,000 0.0% Asset Seizure Fund 3,706 155 7,412 65 44,470 0.1% Municipal Waste System 317,738 312,076 635,477 635,505 3,812,860 16.7% NOW Arena Operating Fund 469,634 38,308 939,268 39,179 5,635,610 0.7% NOW Arena Activity Fund 1,528,263 - 3,056,527 - 18,339,160 0.0% Stormwater Management 128,467 7,500 256,933 7,500 1,541,600 0.5% Insurance 216,491 95,917 432,982 112,924 2,597,890 4.3% Information Technology 293,483 289,224 586,965 545,782 3,521,790 15.5% Roselle Road TIF 174,444 - 348,888 1,750 2,093,330 0.1% Barrington/Higgins TIF 7,851 - 15,702 - 94,210 0.0% Lakewood Center TIF 9,861 - 19,722 25,000 118,330 21.1% Higgins-Old Sutton TIF 14,861 - 29,722 - 178,330 0.0% Higgins/Hassell TIF 35,278 2,214 70,555 8,964 423,330 2.1% Stonington/Pembroke TIF 75,694 - 151,388 - 908,330 0.0% TOTAL OPERATING FUNDS 12,465,947 10,777,553 24,840,069 17,694,762 160,926,850 11.0% 16.7% Page 54 of 89  OPERATING REPORT SUMMARY EXPENDITURES February 28, 2026 CURRENT MONTH YEAR-TO-DATE ANNUAL BENCH- BUDGET ACTUAL BUDGET ACTUAL BUDGET % MARK 2015A G.O. Debt Service - - - - 3,932,450 0.0% 2015 G.O. Debt Service - - - - 124,700 0.0% 2016 G.O. Debt Service - - - - 284,100 0.0% 2017A & B G.O. Debt Service - - - - 181,750 0.0% 2018 G.O. Debt Service - - - - 2,946,950 0.0% 2019 G.O. Debt Service - - - - 136,710 0.0% 2024 G.O. Debt Service - - - - 385,530 0.0% TOTAL DEBT SERV. FUNDS - - - - 7,992,190 0.0% 16.7% Western Corridor Fund 114,583 - 229,167 - 1,375,000 0.0% Prairie Stone Capital 279,167 365,167 558,333 365,167 3,350,000 10.9% Western Area Rd Improve Imp. Fee 68,358 209 136,717 209 820,300 0.0% Capital Improvements Fund 165,625 - 331,250 - 1,987,500 0.0% Capital Vehicle & Equipment Fund 201,565 16,636 403,130 (7,331) 2,418,780 -0.3% Capital Replacement Fund 266,667 - 533,333 - 3,200,000 0.0% 2019 Project Fund 69,167 - 138,333 - 830,000 0.0% 2025 Project Fund 275,000 18,358 550,000 18,453 3,300,000 0.6% 2026 Project Fund 1,000,000 - 2,000,000 77,000 12,000,000 0.6% Road Improvement Fund 950,640 279,959 1,901,280 279,959 11,407,680 2.5% TOTAL CAP. PROJECT FUNDS 3,390,772 680,329 6,781,543 733,456 40,689,260 1.8% 16.7% Police Pension Fund 851,207 600 1,702,413 600 10,214,480 0.0% Fire Pension Fund 756,371 - 1,512,742 - 9,076,450 0.0% TOTAL TRUST FUNDS 1,607,578 600 3,215,155 600 19,290,930 0.0% 16.7% TOTAL ALL FUNDS 17,464,296 11,458,482 34,836,767 18,428,818 228,899,230 8.1% 16.7% Page 55 of 89  HOFFMAN ESTATES DEPARTMENT OF FINANCE MONTHLY REPORT MARCH 2026 Water Billing A total of 14,143 residential water bills were mailed on March 1st for January's water consumption. Average consumption was 4,007 gallons, resulting in an average residential water bill of $74.14. Total consumption for all customers was 95 million gallons, with 56 million gallons attributable to residential consumption. When compared to the March 2025 billing, residential consumption decreased by 3.4%. Total Water Consumption Total Water Consumption Year-To-Date Comparison Month of March Month of March 100 350 300 80 34 36 38 35 39 250 109 114 120 125 111 60 200 150 40 62 56 58 58 56 100 191 183 185 190 189 20 50 0 0 2022 2023 2024 2025 2025 2022 2023 2024 2025 2025 Residential Commercial Residential Commercial 1900 Hassell Road Hoffman Estates, Illinois 60169 www.hoffmanestates.org Phone: 847.882.9100 Fax: 847.843.4822 Page 56 of 89  Village Investments As of March 31, 2026 the Village's investment portfolio (not including pension trust funds) totaled $87.2 million. Of this amount, $69.8 million pertained to the various operating funds. As can be seen in the following graphs, the remaining $17.4 million is related to debt service and capital projects funds. Investment Portfolio by Fund Type Investment Portfolio by Type As March 31, 2026 As of March 31, 2026 0% 0% 20% 16% 25% 34% 80% 25% Money Market CD's Debt Service Operating Capital Projects IL Funds MaxSafe Treasury Bills/Municipal Bonds General Fund Investments 40.0 35.0 30.0 Millions of Dollars 25.0 20.0 15.0 10.0 5.0 0.0 Mar-25 Apr-25 May-25 Jun-25 Jul-25 Aug-25 Sep-25 Oct-25 Nov-25 Dec-25 Jan-26 Feb-26 Mar-26 2 Page 57 of 89  Operating Funds General Fund For the month of March, General Fund revenues totaled $8,885,228 and expenditures totaled $7,749,851 resulting in a surplus of $1,135,377. Revenues: March year-to-date figures are detailed on the table below. License and Permits are over budget due to large development building permits being paid. Intergovernmental revenues are over budget due to higher Local Use Tax received. Fines and Forfeits are over budget due to Ticket fines due to higher than expected receipts. Most miscellaneous revenues are not received on a monthly basis. YEAR-TO-DATE YEAR-TO-DATE REVENUES BUDGET ACTUAL VARIANCE Taxes $ 14,636,068 $ 14,011,654 -4.3% Licenses & Permits 1,592,500 4,852,008 204.7% Intergovernmental 3,845,976 5,893,265 53.2% Charges for Services 2,807,050 2,503,321 -10.8% Fines & Forfeits 192,500 222,404 15.5% Investments 300,000 295,627 -1.5% Miscellaneous 125,250 61,458 -50.9% Operating Transfers 62,500 - -100.0% TOTAL $ 23,561,843 $ 27,839,738 18.2% YTD Budget and Actual Comparison $16,000,000 $14,000,000 $12,000,000 $10,000,000 $8,000,000 Budget Actual $6,000,000 $4,000,000 $2,000,000 $0 Taxes Lic. & Intergov't Serv. Chgs. Fines Investments Misc. Op Transfers Permits 3 Page 58 of 89  Hotel Tax $250,000 $200,000 $150,000 Dec-04 2025 Actual 2026 Budget 2026 Actual $100,000 $50,000 $0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Cumulative Variance 2026 Actual Month Received 2025 Actual 2026 Budget 2026 Actual vs. Budget Jan $88,073 $ 123,333 $ 99,828 $ (23,505) Feb $40,564 $ 123,333 156,901 10,062 Mar $107,358 $ 123,333 73,177 (40,094) Apr $157,882 $ 123,333 May $69,092 $ 123,333 Jun $139,928 $ 123,333 Jul $191,916 $ 123,333 Aug $135,070 $ 123,333 Sep $159,400 $ 123,333 Oct $112,785 $ 123,333 Nov $102,178 $ 123,333 Dec $232,103 $ 123,333 YTD Totals $ 1,536,349 $ 1,480,000 $ 329,907 4 Page 59 of 89  Real Estate Transfer Tax $450,000 $400,000 $350,000 $300,000 Dec-04 $250,000 2025 Actual 2026 Budget $200,000 2026 Actual $150,000 $100,000 1 $50,000 $0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Cumulative Variance 2026 Actual Month Received 2025 Actual 2026 Budget 2026 Actual vs. Budget Jan $404,185 $ 100,000 $ 141,302 $ 41,302 Feb 27,419 $ 100,000 83,175 24,477 Mar 42,318 $ 100,000 63,333 (12,190) Apr 91,206 $ 100,000 May 61,044 $ 100,000 Jun 95,827 $ 100,000 Jul 86,215 $ 100,000 Aug 87,616 $ 100,000 Sep 57,164 $ 100,000 Oct 69,845 $ 100,000 Nov 89,035 $ 100,000 Dec 90,028 $ 100,000 YTD Totals $ 1,201,902 $ 1,200,000 $ 287,810 5 Page 60 of 89  Home Rule Sales Tax $800,000 $700,000 $600,000 $500,000 Dec-04 2025 Actual $400,000 2026 Budget 2026 Actual $300,000 $200,000 $100,000 $0 Jan (Nov) Feb (Dec) Mar (Jan) Apr (Feb) May (Mar) Jun (Apr) Jul (May) Aug (Jun) Sep (Jul) Oct (Aug) Nov (Sep) Dec (Oct) Cumulative Variance Month Received 2026 Actual (Liability Period) 2025 Actual 2026 Budget 2026 Actual vs. Budget Jan (Nov) $507,966 $ 500,000 $601,437 $ 101,437 Feb (Dec) 443,795 500,000 558,904 160,341 Mar (Jan) 558,558 500,000 704,654 364,995 Apr (Feb) 470,363 500,000 May (Mar) 435,681 500,000 Jun (Apr) 518,884 500,000 Jul (May) 482,274 500,000 Aug (Jun) 538,564 500,000 Sep (Jul) 556,545 500,000 Oct (Aug) 579,664 500,000 Nov (Sep) 510,038 500,000 Dec (Oct) 550,803 500,000 YTD Totals $ 6,153,135 $ 6,000,000 $ 1,864,995 6 Page 61 of 89  Telecommunications Tax $160,000 $140,000 $120,000 2025 Actual 2026 Budget $100,000 2026 Actual Dec-04 $80,000 $60,000 $40,000 $20,000 $0 Jan (Oct) Feb (Nov) Mar (Dec) Apr (Jan) May (Feb) Jun (Mar) Jul (Apr) Aug (May) Sep (Jun) Oct (Jul) Nov (Aug) Dec (Sep) Cumulative Variance Month Received 2026 Actual (Liability Period) 2025 Actual 2026 Budget 2026 Actual vs. Budget Jan (Oct) $67,263 $ 60,450 $63,425 $ 2,975 Feb (Nov) 64,510 60,450 62,535 5,060 Mar (Dec) 68,821 60,450 148,405 93,015 Apr (Jan) 60,259 60,450 May (Feb) 73,977 60,450 Jun (Mar) 68,979 60,450 Jul (Apr) 66,983 60,450 Aug (May) 69,021 60,450 Sep (Jun) 81,753 60,450 Oct (Jul) 64,845 60,450 Nov (Aug) 73,684 60,450 Dec (Sep) 61,917 60,450 YTD Totals $ 822,012 $ 725,400 $ 274,365 7 Page 62 of 89  Building Permits $3,500,000 $3,000,000 $2,500,000 $2,000,000 Dec-04 2025 Actual 2026 Budget 2026 Actual $1,500,000 $1,000,000 $500,000 $0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Cumulative Variance 2026 Actual Month Received 2025 Actual 2026 Budget 2026 Actual vs. Budget Jan $62,321 $ 458,333 $2,962,976 $ 2,504,643 Feb 532,532 458,333 1,691,210 3,737,519 Mar 381,361 458,333 153,860 3,433,046 Apr 103,334 458,333 May 78,044 458,333 Jun 196,296 458,333 Jul 87,686 458,333 Aug 68,274 458,333 Sep 161,813 458,333 Oct 197,115 458,333 Nov 1,847,077 458,333 Dec 57,212 458,333 YTD Totals $ 3,773,065 $ 5,500,000 $ 4,808,045 8 Page 63 of 89  State Sales Tax $1,400,000 $1,200,000 $1,000,000 $800,000 Dec-04 2025 Actual 2026 Budget $600,000 2026 Actual $400,000 $200,000 $0 Jan (Nov) Feb (Dec) Mar (Jan) Apr (Feb) May (Mar) Jun (Apr) Jul (May) Aug (Jun) Sep (Jul) Oct (Aug) Nov (Sep) Dec (Oct) Cumulative Variance Month Received 2026 Actual (Liability Period) 2025 Actual 2026 Budget 2026 Actual vs. Budget Jan (Nov) $898,813 $ 883,333 $1,015,549 $ 132,216 Feb (Dec) 863,110 883,333 943,855 192,737 Mar (Jan) 1,004,954 883,333 1,205,094 514,498 Apr (Feb) 842,181 883,333 May (Mar) 779,724 883,333 Jun (Apr) 973,989 883,333 Jul (May) 911,229 883,333 Aug (Jun) 940,535 883,333 Sep (Jul) 947,868 883,333 Oct (Aug) 986,395 883,333 Nov (Sep) 927,113 883,333 Dec (Oct) 950,798 883,333 YTD Totals $ 11,026,709 $ 10,600,000 $ 3,164,499 9 Page 64 of 89  Income Tax $1,800,000 $1,600,000 $1,400,000 $1,200,000 ### $1,000,000 2025 Actual 2026 Budget $800,000 2026 Actual $600,000 $400,000 $200,000 $0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Cumulative 2024-2025 2025-2026 Variance Month Month 2026 Actual Received Liab Pd 2025 Actual Received 2026 Budget Liab Pd 2026 Actual vs. Budget Jan 24-Dec $959,934 Jan $ 760,738 Dec-24 $999,806 $ 239,069 Feb 25-Jan 784,186 Feb 760,738 Jan-25 800,836 279,167 Mar 25-Feb 503,166 Mar 760,738 Feb-25 533,702 52,132 Apr 25-Mar 921,369 Apr 760,738 Mar-25 May 25-Apr 1,643,815 May 760,738 Apr-25 Jun 25-May 570,082 Jun 760,738 May-25 Jul 25-Jun 956,934 Jul 760,738 Jun-25 Aug 25-Jul 548,460 Aug 760,738 Jul-25 Sep 25-Aug 467,752 Sep 760,738 Aug-25 Oct 25-Sep 1,007,594 Oct 760,738 Sep-25 Nov 25-Oct 579,634 Nov 760,738 Oct-25 Dec 25-Nov 530,562 Dec 760,738 Nov-25 YTD Totals $ 9,473,488 $ 9,128,850 $ 2,334,343 10 Page 65 of 89  Fines $140,000 $120,000 $100,000 Dec-04 $80,000 2025 Actual 2026 Budget 2026 Actual $60,000 $40,000 $20,000 $0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Cumulative Variance 2026 Actual Month Received 2025 Actual 2026 Budget 2026 Actual vs. Budget Jan $62,547 $ 64,167 $77,025 $ 12,858 Feb 44,970 64,167 28,576 (22,732) Mar 49,421 64,167 116,803 29,904 Apr 64,019 64,167 May 64,390 64,167 Jun 54,969 64,167 Jul 77,782 64,167 Aug 37,727 64,167 Sep 59,433 64,167 Oct 52,105 64,167 Nov 49,759 64,167 Dec 73,386 64,167 YTD Totals $ 690,508 $ 770,000 $ 222,404 11 Page 66 of 89 Expenditures: General Fund expenditures in March were $671,921 above the budgeted figure of $7,077,930. The summary of year-to-date actuals versus budgeted expenditures shown below reflect positive variances for the Village departments for the year. Administration is over budget due to annual memberships and dues paid at the beginning of the year. Police and Fire are over budget due to their pension contribution expenses, which are directly tied to the Village's receipt of property taxes. When property taxes are received, the pension contribution expense (transfer of property tax revenue to the Pension Funds) occurs. YEAR-TO-DATE YEAR-TO-DATE EXPENDITURES BUDGET ACTUAL VARIANCE Legislative $ 129,743 $ 91,878 29.2% Administration 276,678 323,373 -16.9% Legal 143,650 94,408 34.3% Finance 360,248 402,548 -11.7% Village Clerk 77,203 68,809 10.9% HRM 228,618 217,490 4.9% Communications 126,168 93,406 26.0% Spatial Technology 189,308 138,153 27.0% Police 6,628,760 9,057,424 -36.6% Fire 6,455,708 7,292,758 -13.0% Public Works 2,538,935 2,124,349 16.3% Development Services 1,701,480 1,361,362 20.0% H&HS 425,110 365,368 14.1% Miscellaneous 1,954,575 79,929 95.9% TOTAL $ 21,236,180 $ 21,711,256 -2.2% YTD Budget and Actual Comparison $10,000,000 $9,000,000 $8,000,000 $7,000,000 $6,000,000 $5,000,000 Budget Actual $4,000,000 $3,000,000 $2,000,000 $1,000,000 $0 General Police Fire Public Works Devel. Health & Misc. Services Admin. Services Human Svcs 12 Page 67 of 89  Department News During the month of May, Finance staff attended the following training sessions:  Attended the IGFOA Pension Institute seminar (Director of Finance).  Attended the Equitable Sharing Funds webinar “Accounting and Bookkeeping Requirements” (Deputy Finance Director). Also during the month, Finance staff participated in the following events and planning meetings:  Attended IPBC Executive Board Meeting (Director of Finance).  Audit Fieldwork continued and the external auditors worked both in-office and remotely reviewing all of the financial activity for FY2025. Respectfully Submitted, Rachel Musiala 13 Page 68 of 89  MONTHLY REPORT STATISTICS March-26 % Inc / Dec Mar-26 YTD Mar-26 Mar-25 YTD Mar-25 Month Year Credit Card Transactions Finance and Code Front Counter Number 491 1,200 310 845 58.4% 42.0% Amount $ 82,015 205,192 $ 52,455 134,436 56.4% 52.6% Internet Sales Number 6,263 12,355 2,987 8,701 109.7% 42.0% Amount $ 943,228 1,934,829 $ 404,822 1,169,249 133.0% 65.5% Total Number 6,754 13,555 3,297 9,546 104.9% 42.0% Amount $ 1,025,243 2,140,021 $ 457,277 1,303,685 124.2% 64.2% Credit Card Company Fees General Fund $ 795 1,663 $ 119 358 565.8% 364.4% Water Fund 8,698 31,242 7,911 23,050 10.0% 35.5% Total Fees $ 9,493 $ 32,905 $ 8,030 $ 23,408 18.2% 40.6% Accounts Receivable Invoices Mailed Number 40 125 41 177 -2.4% -29.4% Amount $ 98,324 374,156 $ 117,191 417,964 -16.1% -10.5% Invoices Paid Number 48 162 59 189 -18.6% -14.3% Amount $ 211,847 481,393 $ 239,032 437,198 -11.4% 10.1% Reminders Sent Number 10 32 12 37 -16.7% -13.5% Amount $ 2,808 65,783 $ 59,008 120,719 -95.2% -45.5% Accounts Payable Checks Issued Number 268 967 344 1,005 -22.1% -3.8% Amount $ 1,467,842 7,127,922 $ 2,595,112 6,959,618 -43.4% 2.4% Manual Checks Issued Number 29 76 22 102 31.8% -25.5% As % of Total Checks 10.82% 7.86% 6.40% 10.15% 69.2% -22.6% Amount $ 475,800 663,637 $ 106,234 943,069 347.9% -29.6% As % of Total Checks 32.41% 9.31% 4.09% 13.55% 691.8% -31.3% Utility Billing New Utility Accounts 72 163 53 138 35.8% 18.1% Bills Mailed / Active Accounts 14,893 45,540 15,737 47,219 -5.4% -3.6% Final Bills Mailed 95 203 71 182 33.8% 11.5% Shut-Off Notices - 999 1,146 3,333 -100.0% -70.0% Actual Shut-Offs - - 45 56 -100.0% -100.0% Total Billings $ 2,299,137 7,299,499 $ 1,972,907 6,250,548 16.5% 16.8% Direct Debit (ACH) Program New Accounts (1,446) (1,866) 69 253 -2195.7% -837.5% Total Accounts 4,943 18,184 6,579 19,655 -24.9% -7.5% As % of Active Accounts 33.19% 39.93% 41.81% 41.63% -8.6% -4.1% Water Payments Received in Current Month Total Bills Mailed 14,893 45,540 15,737 47,219 -5.4% -3.6% ACH Payments 4,943 18,184 6,579 19,655 -24.9% -7.5% ACH Payments-% of Total Bills 33.19% 39.93% 41.81% 41.63% -20.6% -4.1% On-line Payments (Internet Sales) 5,076 10,234 2,428 7,141 109.1% 43.3% On-line Payments-% of Total Bills 34.08% 22.47% 15.43% 15.12% 120.9% 48.6% Over-the-phone Payments 125 740 531 1,486 -76.5% -50.2% Over-the-phone Payments-% of Total Bills 0.84% 1.62% 3.37% 3.15% -75.1% -48.4% Mail-in Payments 6,513 17,011 6,198 18,500 5.1% -8.0% Mail-in Payments-% of Total Bills 43.73% 37.35% 39.38% 39.18% 11.0% -4.7% Page 69 of 89  WATER BILLING ANALYSIS March 31, 2026 Residential Billings Average Monthly Consumption/Customer Month Billed 2023-2024 2024-2025 2025-2026 March 3,766 3,886 3,895 April 4,361 4,092 3,813 May 3,753 4,014 4,045 June 4,878 4,319 4,847 July 5,692 4,910 4,884 August 4,780 4,670 4,952 September 5,031 5,320 5,093 October 4,377 5,320 4,374 November 4,191 4,197 4,553 December 4,079 4,103 3,782 January 4,203 4,352 4,687 February 4,370 4,612 4,610 March 3,886 3,895 4,007 13 Month Average - 4,413 4,438 4,426 % Change - 1.4% 0.6% -0.3% Total Water Customers Average Bill Customer Type Customer Type Mar-25 Mar-26 % Change Mar-25 Mar-26 % Change Residential 14,829 14,143 -4.6% Residential $ 63.47 $ 74.14 16.8% Commercial 908 748 -17.6% Total 15,737 14,891 -5.4% Total Consumption - All Customers (000,000's) Month-To-Date Year-To-Date Mar-25 Mar-26 % Change Mar-25 Mar-26 % Change Residential 58 56 -3.4% Residential 190 189 -0.6% Commercial 38 39 2.6% Commercial 120 125 4.1% 96 95 -1.0% 310 314 1.2% Page 70 of 89  STATEMENT OF INVESTMENTS-VILLAGE As of March 31, 2026 Investment Book Market Maturity Rate of Fund Period Value Value Value Interest General Fund Illinois Funds - General 6,198,252.73 4.436 Illinois Funds - Veterans Memorial 374.75 4.436 HE Community Bank-Money Marke 6,539,191.83 4.490 PMA iPrime 1,895,375.66 4.213 CD with PMA 21,201,900.00 21,201,900.00 22,322,058.63 4.230 35,835,094.97 Motor Fuel Tax Illinois Funds 676,522.32 4.436 HE Community Bank-Money Market 149,775.00 4.490 826,297.32 Asset Seizure - State Illinois Funds 66,568.73 4.436 Asset Seizure - BATTLE Illinois Funds 1,079.69 4.436 Municipal Waste System Illinois Funds 290,956.24 4.436 HE Community Bank-Money Market 0.00 4.490 290,956.24 2015A & 2015C G.O.D. S. HE Community Bank-Money Market 75,968.71 4.490 Central Road Corridor Improv. Illinois Funds 53,369.49 4.436 PMA iPrime 4,552.21 4.213 57,921.70 Hoffman Blvd Bridge Maintenance Illinois Funds 13,437.71 4.436 HE Community Bank-Money Market 295,349.27 4.490 308,786.98 Western Corridor Illinois Funds 2,055,651.83 4.436 PMA iPrime 561,022.77 4.213 2,616,674.60 Page 71 of 89  STATEMENT OF INVESTMENTS-VILLAGE As of March 31, 2026 Investment Book Market Maturity Rate of Fund Period Value Value Value Interest Prairie Stone Capital Illinois Funds 481,753.16 4.436 PMA iPrime 2,439,377.65 4.213 2,921,130.81 Road Improvement Illinois Funds 732,113.58 4.436 HE Community Bank-Money Market 1,131,711.69 4.490 CD with PMA 03/09/17 721,375.40 719,129.95 720,000.00 4.490 PMA iPrime 65,649.14 4.213 2,650,849.81 Western Area Rd Impr Impact Fees Illinois Funds 1,321,822.94 4.436 HE Community Bank-Money Market 48,995.08 4.490 1,370,818.02 Capital Improvements Illinois Funds 1,135,520.54 4.436 PMA iPrime 92,068.72 4.213 1,227,589.26 Capital Vehicle & Equipment Illinois Funds 1,693,692.33 4.436 PMA iPrime 73,787.99 4.213 HE Community Bank-Money Market 528,363.29 2,295,843.61 Capital Replacement Illinois Funds 1,722,861.57 4.436 HE Community Bank-Money Marke 1,038,509.39 4.490 PMA iPrime 304,721.94 4.213 3,066,092.90 Water and Sewer Illinois Funds 192,384.59 4.436 PMA iPrime 5,632,324.42 4.213 HE Community Bank-Money Market 3,567,085.00 4.490 CD with PMA 4/30/25-10/2/25 6,625,800.00 6,625,800.00 6,838,420.12 4.230 16,017,594.01 Page 72 of 89  STATEMENT OF INVESTMENTS-VILLAGE As of March 31, 2026 Investment Book Market Maturity Rate of Fund Period Value Value Value Interest Now Arena Operating Illinois Funds 458,261.20 4.436 HE Community Bank-Money Market 1,555,144.45 4.490 PMA iPrime 722,285.91 4.213 CD with PMA 4/30/25-10/2/25 716,900.00 716,900.00 749,380.05 4.230 3,452,591.56 Now Arena H.E. Community Bank-MaxSafe 2,822,661.00 4.490 Insurance Illinois Funds 266,793.94 4.436 HE Community Bank-Money Market 513,949.56 4.490 PMA iPrime 11/07/08 800,321.96 4.213 CD with PMA 4/30/25-10/2/25 477,300.00 477,300.00 499,508.72 4.230 2,058,365.46 Information Technology Illinois Funds 1,905,935.89 4.436 HE Community Bank-Money Market 190,805.23 4.490 PMA iPrime 420,912.96 4.213 2,517,654.08 Roselle Road TIF Illinois Funds 2,089,281.32 4.436 HE Community Bank-Money Market 1,372,577.05 4.490 PMA iPrime 138,482.42 4.213 3,600,340.79 Barr./Higgins TIF Illinois Funds 199,823.56 4.436 HE Community Bank-Money Market 1,064,312.02 4.490 1,264,135.58 2019 Captial Project Fund HE Community Bank-Money Market 529,557.38 4.490 Lakewood Center TIF Illinois Funds 432,011.50 4.436 HE Community Bank-Money Market 49,800.39 4.490 481,811.89 Page 73 of 89  STATEMENT OF INVESTMENTS-VILLAGE As of March 31, 2026 Investment Book Market Maturity Rate of Fund Period Value Value Value Interest Hig/Old Sutton TIF HE Community Bank-Money Market 72,748.80 4.490 Hig/Hassell TIF HE Community Bank-Money Market 490,407.46 4.490 2018G.O. Debt Serv. HE Community Bank-Money Market 0.00 4.490 2024 G.O. Debt Serv. PMA iPrime 324,378.51 4.213 Total Investments $ 87,243,919.87 Percent Total Invested Per Institution Invested Illinois Funds 21,988,469.61 25.20 CD with PMA 29,743,275.40 34.09 HE Community Bank-MaxSafe 2,822,661.00 3.24 HE Community Bank-Money Market 19,214,251.60 22.02 Treasury Bills/Municipal Bonds 0.00 - ISC at PMA 13,475,262.26 15.45 $87,243,919.87 100.00 Total Invested Per Fund Total Investments - Operating Funds 69,798,307.58 Total Investments - Debt Service Funds 400,347.22 Total Investments - Capital Projects Funds $17,045,265.07 Total Investments - All Funds $87,243,919.87 Page 74 of 89  PMA INVESTMENTS January 31, 2026 Settlement Maturity Cost Market Value Interest Rate GENERAL FUND iPrime Term Series 20260406AA105556 9/27/2024 4/6/2026 3,000,000 3,000,000 3.603% T Bank, National Association 8/8/2025 8/7/2026 239,900 239,900 4.116% Cornerstone Bank 8/8/2025 8/7/2026 240,100 240,100 4.024% Solera National Bank 8/8/2025 8/7/2026 239,900 239,900 4.122% Iprime Term Series 8/15/2025 8/14/2026 2,108,000 2,108,000 3.850% iPrime Term Series 20260724AA1053647-23 7/25/2025 7/24/2026 6,400,000 6,400,000 4.200% iPrime Term Series 5/9/2025 11/10/2026 2,000,000 2,000,000 3.800% iPrime Term Series 5/30/2025 12/2/2026 5,000,000 5,000,000 3.950% Integro Bank 3/2/2026 3/2/2027 241,500.00 241,500.00 3.493% First State Bank of DeQueen 3/2/2026 3/2/2027 241,300.00 241,300.00 3.561% CFG Bank 3/2/2026 3/2/2027 241,200.00 241,200.00 3.592% IPrime Term Series 3/27/2026 3/25/2027 1,250,000 1,250,000 3.924% GENERAL FUND TOTALS: $21,201,900 $21,201,900 ROAD IMPROVEMENT FUND Wells Fargo Bank NA 3/6/2026 3/5/2027 240,458 239,712 3.750% State Bank of India 3/9/2026 3/9/2027 240,459 239,709 3.750% Goldman Sachs Bank USA 3/10/2026 3/10/2027 240,459 239,708 3.750% ROAD IMPROVEMENT TOTALS: $721,375 $719,130 WATER & SEWER FUND Customers Bank 11/18/2025 8/14/2026 1,540,500 1,540,500 3.610% Financial Federal Bank 11/18/2025 8/14/2026 243,100 243,100 3.800% FirstBank Southwest 11/18/2025 8/14/2026 243,400 243,400 3.612% Flagstar Bank, National Association 11/18/2025 8/14/2026 243,300 243,300 3.679% New Republic Bank 11/18/2025 8/14/2026 243,300 243,300 3.664% American Pride Bank 11/18/2025 8/14/2026 243,400 243,400 3.610% Bank of China 11/18/2025 8/14/2026 242,800 242,800 3.959% iPrime Term Series 12/5/2025 12/4/2026 1,500,000 1,500,000 3.440% BOM Bank 3/2/2026 3/2/2027 241,100 241,100 3.664% Priority Bank 3/2/2026 3/2/2027 241,500 241,500 3.461% KS State Bank 3/2/2026 3/2/2027 241,000 241,000 3.701% First Federal Savings & Loan Assoc. 3/2/2026 3/2/2027 152,400 152,400 3.457% IPrime Term Series 3/27/2026 3/25/2027 1,250,000 1,250,000 3.924% WATER & SEWER TOTALS: $6,625,800 $6,625,800 NOW ARENA FUND Bank Hapoalim B.M. 05/01/25 07/24/26 238,600 238,600 3.800% Baxter Credit Union 05/01/25 07/24/26 238,300 238,300 3.893% Nex Bank 08/08/25 08/07/26 240,000 240,000 4.143% NOW ARENA TOTALS: $ 716,900.00 $ 716,900.00 INSURANCE FUND Premier Bank 05/01/25 07/24/26 238,600 238,600 3.792% American Commercial Bank & Trust Nat'l Assn 05/01/25 07/24/26 238,700 238,700 3.772% INSURANCE TOTALS: $ 477,300.00 $ 477,300.00 TOTAL: $29,743,275 $29,741,030 Page 75 of 89  OPERATING REPORT SUMMARY REVENUES March 31, 2026 CURRENT MONTH YEAR-TO-DATE ANNUAL % ACTUAL BENCH- BUDGET ACTUAL BUDGET ACTUAL BUDGET TO BUDGET MARK General Fund Property Taxes 4,500,000 2,174,057 6,500,000 3,389,525 13,654,510 24.8% Hotel Tax 123,333 73,177 370,000 329,906 1,480,000 22.3% Real Estate Transfer Tax 100,000 63,333 300,000 287,810 1,200,000 24.0% Home Rule Sales Tax 500,000 704,654 1,500,000 1,864,996 6,000,000 31.1% Telecommunications Tax 60,450 148,405 181,350 274,365 725,400 37.8% Property Tax - Fire 1,500,000 1,043,819 2,250,000 3,134,817 5,930,460 52.9% Property Tax - Police 2,100,000 1,428,958 3,100,000 4,330,577 7,185,920 60.3% Other Taxes 144,906 183,407 434,718 399,659 1,738,870 23.0% Total Taxes 9,028,689 5,819,810 14,636,068 14,011,654 37,915,160 37.0% Business Licenses 60,000 10,370 126,667 16,447 400,000 4.1% Liquor Licenses 45,000 17,430 90,833 27,514 275,000 10.0% Building Permits 458,333 153,860 1,375,000 4,808,046 5,500,000 87.4% Total Licenses & Permits 563,333 181,660 1,592,500 4,852,008 6,175,000 78.6% Sales Tax 883,333 1,205,094 883,333 3,164,499 10,600,000 29.9% Grocery Tax 66,667 - 200,000 - 800,000 0.0% Local Use Tax 16,167 49,024 48,500 121,676 194,000 62.7% State Income Tax 779,292 533,702 2,337,875 2,334,344 9,351,500 25.0% Replacement Tax 34,964 20,661 104,893 86,056 419,570 20.5% Other Intergovernmental 90,458 78,633 271,375 186,691 1,085,500 17.2% Total Intergovernmental 1,870,881 1,887,114 3,845,976 5,893,265 22,450,570 26.2% Engineering Fees 66,667 29,004 200,000 172,882 800,000 21.6% Ambulance Fees 204,167 195,841 612,500 550,195 2,450,000 22.5% GEMT Income 204,167 183,953 612,500 662,847 2,450,000 27.1% Police Hireback 37,500 52,697 112,500 144,530 450,000 32.1% Lease Payments 50,458 47,632 151,375 132,913 605,500 22.0% Cable TV Fees - - 162,500 111,308 455,300 24.4% 4th of July Proceeds 7,050 7,050 7,050 7,050 100,000 7.1% Employee Payments 150,000 45,152 450,000 211,807 1,800,000 11.8% Hireback - Arena 25,000 21,805 75,000 101,228 300,000 33.7% Rental Inspection Fees 5,000 100,850 165,000 168,413 250,000 67.4% Other Charges for Services 86,208 77,733 258,625 240,149 1,034,500 23.2% Total Charges for Services 836,217 761,716 2,807,050 2,503,321 10,695,300 23.4% Court Fines-County 12,083 13,236 36,250 25,130 145,000 17.3% Ticket Fines-Village 20,833 46,544 62,500 92,778 250,000 37.1% Overweight Truck Fines 1,250 2,310 3,750 4,230 15,000 28.2% Red Light Camera Revenue 25,833 53,600 77,500 87,700 310,000 28.3% Local Debt Recovery 4,167 1,113 12,500 12,567 50,000 25.1% Total Fines & Forfeits 64,167 116,803 192,500 222,404 770,000 28.9% Total Investment Earnings 100,000 101,678 300,000 295,627 1,200,000 24.6% Reimburse/Recoveries 14,583 3,169 43,750 13,995 175,000 8.0% S.Barrington Fuel Reimbursement 2,917 3,104 8,750 9,725 35,000 27.8% Schaumburg Twn Fuel Reimbursement 3,750 1,966 11,250 6,973 45,000 15.5% Tollway Payments 3,000 4,240 9,000 13,250 36,000 36.8% Other Miscellaneous 17,500 3,969 52,500 17,515 210,000 8.3% Total Miscellaneous 41,750 16,448 125,250 61,458 501,000 12.3% Total Operating Transfers In 20,833 - 62,500 - 250,000 0.0% Total General Fund 12,525,870 8,885,228 23,561,843 27,839,738 79,957,030 34.8% 25.0% Page 76 of 89  OPERATING REPORT SUMMARY REVENUES March 31, 2026 CURRENT MONTH YEAR-TO-DATE ANNUAL % ACTUAL BENCH- BUDGET ACTUAL BUDGET ACTUAL BUDGET TO BUDGET MARK Water & Sewer Fund Water Sales 2,150,556 1,823,810 6,451,668 5,945,737 25,806,670 23.0% Connection Fees 4,167 16,770 12,500 40,856 50,000 81.7% Cross Connection Fees 3,167 3,182 9,500 9,559 38,000 25.2% Penalties 10,833 (9) 32,500 (46) 130,000 0.0% Investment Earnings 66,667 41,269 200,000 141,518 800,000 17.7% Other Revenue Sources 2,333 18,256 7,000 37,758 28,000 134.9% Capital Projects - - - 6,000,000 N/A Total Water Fund 2,237,723 1,903,278 6,713,168 6,175,383 32,852,670 18.8% 25.0% Motor Fuel Tax Fund 201,697 202,904 605,090 624,547 2,420,360 25.8% Community Dev. Block Grant Fund 22,250 - 66,750 - 267,000 0.0% Asset Seizure Fund - 8,384 - 88,690 - N/A Municipal Waste System Fund 329,175 278,862 987,525 870,825 3,950,100 22.0% NOW Arena Operating Fund 336,507 260,095 1,009,520 815,816 4,038,080 20.2% NOW Arena Activity Fund 1,528,263 - 4,584,790 - 18,339,160 0.0% Stormwater Management 151,667 150,889 455,000 702,694 1,820,000 38.6% Insurance Fund 206,648 201,257 619,945 578,885 2,479,780 23.3% Roselle Road TIF 71,667 170,993 215,000 638,503 860,000 74.2% Barrington/Higgins TIF - 3,824 - 11,219 - N/A Lakewood Center TIF 47,917 1,036,437 143,750 1,039,435 575,000 180.8% Higgins-Old Sutton TIF 14,861 219 44,583 633 178,330 0.4% Stonington & Pembroke TIF 75,694 123,517 227,083 295,056 908,330 32.5% Higgins/Hassell TIF 54,583 214,074 163,750 554,245 655,000 84.6% Information Technology 234,732 168,306 704,195 524,875 2,816,780 18.6% Total Spec Rev. & Int. Svc. Fund 3,275,660 2,819,762 9,826,980 6,745,422 39,307,920 17.2% TOTAL OPERATING FUNDS 18,039,253 13,608,268 40,101,991 40,760,543 152,117,620 26.8% 25.0% 2015A & C G.O. Debt Service 229 229 908 908 3,932,450 0.0% 2015B G.O. Debt Service - - - - 124,700 0.0% 2016 G.O. Debt Service 50,250 50,250 182,442 182,442 284,100 0.0% 2017A & B G.O. Debt Service - - - - 181,750 0.0% 2018 G.O. Debt Service 301,931 301,931 391,912 391,912 2,946,950 0.0% 2019 G.O. Debt Service - - - - 136,710 0.0% 2024 G.O. Debt Service - - - - 385,530 0.0% TOTAL DEBT SERV. FUNDS 352,410 352,410 575,261 575,261 7,992,190 7.2% 25.0% Central Rd. Corridor Fund 83 179 250 527 1,000 52.7% Hoffman Blvd Bridge Maintenance 833 931 2,500 2,692 10,000 26.9% Western Corridor Fund 118,750 8,056 356,250 24,128 1,425,000 1.7% Prairie Stone Capital Fund 279,167 258,343 837,500 274,585 3,350,000 8.2% Western Area Traffic Impr. Impact Fee 3,333 4,247 10,000 8,480 40,000 0.0% Capital Improvements Fund 177,917 271,491 533,750 746,378 2,135,000 35.0% Capital Vehicle & Equipment Fund 205,732 7,064 617,195 20,721 2,468,780 0.8% Capital Replacement Fund 16,667 9,383 50,000 27,103 200,000 13.6% 2019 Project Fund 19,167 1,594 57,500 4,653 230,000 2.0% 2024 Project Fund - 962 - 3,563 - N/A 2025 Project Fund 1,333,333 - 4,000,000 - 16,000,000 0.0% Road Improvement Fund 919,390 160,228 2,758,170 509,533 11,032,680 4.6% TOTAL CAP. PROJECT FUNDS 3,074,372 722,479 9,223,115 1,622,364 36,892,460 4.4% 25.0% Police Pension Fund 735,143 1,509,994 2,205,430 4,575,130 8,821,720 51.9% Fire Pension Fund 646,253 1,131,004 1,938,758 3,396,391 7,755,030 43.8% TOTAL TRUST FUNDS 1,381,396 2,640,998 4,144,188 7,971,521 16,576,750 48.1% 25.0% TOTAL ALL FUNDS 22,847,430 17,324,154 54,044,555 50,929,689 213,579,020 23.8% 25.0% Page 77 of 89  OPERATING REPORT SUMMARY EXPENDITURES March 31, 2026 CURRENT MONTH YEAR-TO-DATE ANNUAL BENCH- BUDGET ACTUAL BUDGET ACTUAL BUDGET % MARK General Fund General Admin. Legislative 43,248 35,061 129,743 91,878 518,970 17.7% Administration 92,226 109,178 276,678 323,373 1,106,710 29.2% Legal 47,883 62,230 143,650 94,408 574,600 16.4% Finance 120,083 177,188 360,248 402,548 1,440,990 27.9% Village Clerk 25,734 24,778 77,203 68,809 308,810 22.3% Human Resource Mgmt. 76,206 84,176 228,618 217,490 914,470 23.8% Spatial Technology 63,103 99,122 189,308 138,153 757,230 18.2% Communications 42,056 36,646 126,168 93,406 504,670 18.5% Total General Admin. 510,538 628,379 1,531,613 1,430,064 6,126,450 23.3% 25.0% Police Department Administration 176,744 227,506 530,233 682,849 2,120,930 32.2% Juvenile Investigations 82,006 111,764 246,018 303,376 984,070 30.8% Tactical 128,968 190,216 386,905 523,559 1,547,620 33.8% Patrol and Response 1,293,839 2,167,563 3,881,518 5,807,172 15,526,070 37.4% Traffic 97,745 139,244 293,235 336,915 1,172,940 28.7% Investigations 171,721 216,503 515,163 610,425 2,060,650 29.6% Community Relations 975 43 2,925 1,296 11,700 11.1% Communications 33,647 33,043 100,940 132,173 403,760 32.7% Canine 19,615 27,385 58,845 82,595 235,380 35.1% Special Services 21,214 18,853 63,643 83,357 254,570 32.7% Records 37,182 39,269 111,545 96,572 446,180 21.6% Administrative Services 135,204 122,652 405,613 350,688 1,622,450 21.6% Emergency Operations 10,727 4,427 32,180 46,447 128,720 36.1% Total Police 2,209,587 3,298,468 6,628,760 9,057,424 26,515,040 34.2% 25.0% Fire Department Administration 83,923 87,721 251,768 262,480 1,007,070 26.1% Public Education 12,972 12,079 38,915 66,666 155,660 42.8% Suppression 1,013,197 1,227,218 3,039,590 3,608,424 12,158,360 29.7% Emer. Med. Serv. 979,212 1,130,111 2,937,635 3,249,150 11,750,540 27.7% Prevention 58,563 31,356 175,688 98,132 702,750 14.0% Fire Stations 4,038 5,557 12,113 7,906 48,450 16.3% Total Fire 2,151,903 2,494,043 6,455,708 7,292,758 25,822,830 28.2% 25.0% Public Works Department Administration 35,151 30,944 105,453 92,849 421,810 22.0% Snow/Ice Control 182,770 166,134 548,310 733,354 2,193,240 33.4% Traffic Operations 109,789 97,078 329,368 263,755 1,317,470 20.0% Forestry 184,845 93,326 554,535 266,354 2,218,140 12.0% Facilities 112,631 87,421 337,893 237,685 1,351,570 17.6% Fleet Services 156,614 156,789 469,843 431,789 1,879,370 23.0% F.A.S.T. 21,523 6,088 64,570 32,957 258,280 12.8% Storm Sewers 42,988 23,573 128,965 65,606 515,860 12.7% Total Public Works 846,312 661,353 2,538,935 2,124,349 10,155,740 20.9% 25.0% Page 78 of 89  OPERATING REPORT SUMMARY EXPENDITURES March 31, 2026 CURRENT MONTH YEAR-TO-DATE ANNUAL BENCH- BUDGET ACTUAL BUDGET ACTUAL BUDGET % MARK Development Services Administration 42,005 19,040 126,015 54,116 504,060 10.7% Planning & Transportation 78,612 78,353 235,835 211,811 943,340 22.5% Code Enforcement 186,601 193,190 559,803 502,105 2,239,210 22.4% Engineering 173,014 164,039 519,043 425,660 2,076,170 20.5% Economic Development 86,928 49,087 260,785 167,670 1,043,140 16.1% Total Development Services 567,160 503,708 1,701,480 1,361,362 6,805,920 20.0% 25.0% Health & Human Services 141,703 132,986 425,110 365,368 1,700,440 21.5% 25.0% Miscellaneous 4th of July 2,096 2,096 8,678 8,678 275,500 3.1% Police & Fire Comm. 6,940 - 20,820 92 83,280 0.1% Misc. Boards & Comm. 29,203 23,916 87,610 56,724 350,440 16.2% Misc. Public Improvements 612,489 4,903 1,837,468 14,436 7,349,870 0.2% Total Miscellaneous 650,728 30,914 1,954,575 79,929 8,059,090 1.0% 25.0% Total General Fund 7,077,930 7,749,851 21,236,180 21,711,256 85,185,510 25.5% 25.0% Water & Sewer Fund Water Department 1,414,247 1,170,396 4,242,740 2,810,867 16,970,960 16.6% Sewer Department 226,553 212,009 679,660 574,237 2,718,640 21.1% Billing Division 90,734 115,128 272,203 256,075 1,088,810 23.5% Debt Service Division - - 61,400 61,400 145,800 42.1% Capital Projects Division 100,412 100,412 252,055 252,055 10,740,000 2.3% 2015 Bond Capital Projects - - - - 421,200 0.0% 2017 Bond Capital Projects - - - - 484,520 0.0% 2018 Bond Capital Projects - - - - 247,640 0.0% 2019 Bond Capital Projects - - - - 622,530 0.0% Operating Transfers 2,083 - 6,250 - 25,000 0.0% Total Water & Sewer 1,834,030 1,597,945 5,514,308 3,954,635 33,465,100 11.8% 25.0% Motor Fuel Tax 225,000 - 675,000 - 2,700,000 0.0% Community Dev. Block Grant Fund - - - - 267,000 0.0% Asset Seizure Fund 3,706 - 11,118 65 44,470 0.1% Municipal Waste System 317,738 311,355 953,215 946,860 3,812,860 24.8% NOW Arena Operating Fund 469,634 1,943 1,408,903 41,122 5,635,610 0.7% NOW Arena Activity Fund 1,528,263 - 4,584,790 - 18,339,160 0.0% Stormwater Management 128,467 9,000 385,400 16,500 1,541,600 1.1% Insurance 216,491 19,785 649,473 132,709 2,597,890 5.1% Information Technology 293,483 268,086 880,448 813,868 3,521,790 23.1% Roselle Road TIF 174,444 3,840 523,333 5,590 2,093,330 0.3% Barrington/Higgins TIF 7,851 1,352 23,553 1,352 94,210 1.4% Lakewood Center TIF 9,861 17,395 29,583 42,395 118,330 35.8% Higgins-Old Sutton TIF 14,861 5,447 44,583 5,447 178,330 3.1% Higgins/Hassell TIF 35,278 17,147 105,833 26,111 423,330 6.2% Stonington & Pembroke TIF 75,694 8,660 227,083 8,660 908,330 1.0% TOTAL OPERATING FUNDS 12,412,729 10,011,805 37,252,798 27,706,567 160,926,850 17.2% 25.0% Page 79 of 89  OPERATING REPORT SUMMARY EXPENDITURES March 31, 2026 CURRENT MONTH YEAR-TO-DATE ANNUAL BENCH- BUDGET ACTUAL BUDGET ACTUAL BUDGET % MARK 2015A G.O. Debt Service - - - - 3,932,450 0.0% 2015 G.O. Debt Service - - - - 124,700 0.0% 2016 G.O. Debt Service - - - - 284,100 0.0% 2017A & B G.O. Debt Service - - - - 181,750 0.0% 2018 G.O. Debt Service - - - - 2,946,950 0.0% 2019 G.O. Debt Service - - - - 136,710 0.0% 2024 G.O. Debt Service - - - - 385,530 0.0% TOTAL DEBT SERV. FUNDS - - - - 7,992,190 0.0% 25.0% Western Corridor Fund 114,583 - 343,750 - 1,375,000 0.0% Prairie Stone Capital 279,167 562,845 837,500 928,012 3,350,000 27.7% Western Area Rd Improve Imp. Fee 68,358 - 205,075 209 820,300 0.0% Capital Improvements Fund 165,625 - 496,875 - 1,987,500 0.0% Capital Vehicle & Equipment Fund 201,565 181,804 604,695 174,472 2,418,780 7.2% Capital Replacement Fund 266,667 - 800,000 - 3,200,000 0.0% 2019 Project Fund 69,167 - 207,500 - 830,000 0.0% 2024 Project Fund 275,000 37,494 825,000 55,946 3,300,000 1.7% 2025 Project Fund 1,000,000 - 3,000,000 77,000 12,000,000 0.6% Road Improvement Fund 950,640 175,693 2,851,920 455,652 11,407,680 4.0% TOTAL CAP. PROJECT FUNDS 3,390,772 957,835 10,172,315 1,691,292 40,689,260 4.2% 25.0% Police Pension Fund 851,207 - 2,553,620 600 10,214,480 0.0% Fire Pension Fund 756,371 - 2,269,113 - 9,076,450 0.0% Barrington Higgins TIF 0.0% TOTAL TRUST FUNDS 1,607,578 - 4,822,733 600 19,290,930 0.0% 25.0% TOTAL ALL FUNDS 17,411,079 10,969,640 52,247,846 29,398,459 228,899,230 12.8% 25.0% Page 80 of 89  Information Technology Department – March 2026 Monthly Report Contents Software Systems ..........................................................................................................................................................2 BS&A ERP Software....................................................................................................................................................2 UKG Ready & PACE Timekeeping Software ...............................................................................................................2 GovQA Public Records Request Software..................................................................................................................2 e-Plan Soft Plan Review Software..............................................................................................................................2 Laserfiche Document Repository Software ...............................................................................................................3 Technical Support, Hardware & Software Review.........................................................................................................3 Project Activities ........................................................................................................................................................3 Security and Other Updates ......................................................................................................................................3 Training..........................................................................................................................................................................4 Meetings ........................................................................................................................................................................4 Completed Work Orders by Location ............................................................................................................................5 Completed Work Orders by Month ...............................................................................................................................5 System Data Functions ..................................................................................................................................................6 Email Spam Report ........................................................................................................................................................6 Page 81 of 89 Software Systems BS&A ERP Software • Configured BS&A Privileges to better reflect roles and user accesses • Worked with technical team to resolve technical related issues with BS&A • Actively working with Development Services and Clerk to work around software limitations and issues • Organizing and being the point of contact for BS&A vendor meetings with Customer Representative Kurt • Worked with HR to create and establish an integration between BS&A and NeoGov o Developed a manual workflow for New Hire Import from NeoGov to BS&A o Created export files for Employee and Position exports from BS&A to NeoGov o Developed a workflow to automate exporting of the Employees file o Developed a manual workflow to export the Positions file o Tested the integration with HR and NeoGov • Working with BS&A users to identify bugs, issues and possible enhancement requests UKG Ready & PACE Timekeeping Software • Worked with Payroll for any Employee Profile Changes • Worked with Payroll to resolve Comp Time Issues that PW were facing • Attended and worked with HR to develop and implement LOA forms in UKG • Worked with Andrews Technology for Best Practices for Employee changes that occur in the middle of the pay period • Worked with Andrews Technology and Payroll to resolve UKG Accrual issues PW were facing GovQA Public Records Request Software • Created New Users and assigned proper securities/access • Updated user accesses per request of Managers • Assisted Users with account locks and password resets • Working with Granicus to better understand our GovQA environment and what new features we may want to have moving forward e-Plan Soft Plan Review Software • Attended User training and UAT meetings • Worked with e-Plan to configure the correct privileges to assign to users for BS&A and e- Plan integration Page 82 of 89  • Assigned appropriate BS&A privileges to e-Plan users • Created Microsoft Teams team to keep track of e-Plan UAT and Go-Live and transferred necessary documents to connecting SharePoint Laserfiche Document Repository Software • Worked with BS&A to explore integration capabilities with Laserfiche • Future meetings scheduled to work with Development Services on how we can utilize the BS&A Laserfiche integration • Worked with Development Services and developed a process to import all historical Fire Inspections into Laserfiche Technical Support, Hardware & Software Review Project Activities • Project – CAD Software Upgrade o NWCD has upgraded CAD which is used by Fire and Police. IT staff completed testing this version and are ready to start installing the new version on all Fire and Police computers including in-car MDT’s • Project - Email Security o IT staff implemented a new email security solution which will add an additional layer of security for the Village. This solution will assist in blocking or preventing malicious emails from becoming security concerns • Project – Fire Station 21 (new) o IT staff completed the move into the new Fire Station 21. Staff also worked to relocate the fiber lines going to the old fire station to the new fire station. Removed all equipment and connections to the previous Fire Station for upcoming demolition • Project – NOWArena Beer Garden o The new beer garden outside the NOWArena is nearing construction completion. IT staff are preparing for hardware installation which includes networking, CCTV and Wi-Fi Security and Other Updates • Continued Windows Updates and firmware updates on all PC’s and servers • IT staff are preparing for multiple projects that will be occurring at the NOWArena including Wi-Fi expansion and replacement of the building cameras Page 83 of 89 Training • 8 new user Orientations • Created multiple training documents for Mimecast implementation • Staff attended multiple IT workshops and webinars, including Veeam, CrowdStrike, Mimecast and Dell Meetings • Met with storage vendors and Cybersecurity vendors to discuss upcoming projects • Met with Spatial Technology department members • Quarterly tech meeting with NWCD members • Met with SCADA team members • e-Plan Admin Training • e-Plan UAT Kickoff • Weekly NeoGov BS&A Integration Implementation meeting • Weekly CD/BL User Group meeting • Docusign Exploration Vendor meeting • UKG LOA Implementation meeting • BS&A ESS Configuration and Implementation plan • Laserfiche Fire Inspections Import from Central Square planning meeting • Plante Moran Project Status calls • BS&A Webinars attended: o Community Development Advanced o UB Commonly Requested Reports • Bi-Weekly BS&A and Related Software Internal Touchpoint meeting • Bi-Weekly BS&A Touchpoint meeting • ADA Compliance meetings Page 84 of 89 Completed Work Orders by Location Completed Work Orders by Month Page 85 of 89 System Data Functions Email Spam Report D AREK RASZKA , I NFORMATION TECHNOLOGY D IRECTOR Page 86 of 89 Page 87 of 89  Now Arena General Manager Update April 2026 Report Update Event Highlights Notes April 11: PCB Border Battle April 25-26: Paw Patrol Live April 30: Whiskey & Roses Finance Department General 2025 Year End Completed - Jan to March Financials Pending Building Event Revenue YTD: $4,345,726 Monthly Financial Statement Building Sponsor/Other Revenue YTD: $150,570 Building Expenses YTD: In process $4,591,493 Operations Department General Working on parking lot hut renovations, Hideaway season start-up, capital items including sport lights and seating. Positions to Fill Third Party Providers N/A Village Support PW assisting with summer projects including repair of all concession flooring. Events Department General Event Managers prepping for graduation season. Positions to Fill n/a Marketing Department General Spearheading marketing campaign for Hideaway. Positions to Fill N/A Group Sales Department General N/A Box Office Department General Working on several on sales including Phil Wickham, Volleyball and New Japan Wrestling. Food & Beverage Department General Looking to hire additional culinary support. Premium Seating Department General Continue to renew annual suites, marquee signage and working on beer pouring rights. Positions to Fill NA Sponsorship Department General Concentrating on unsold categories including insurance and liquor. Corporate Sales/Premium: $111,568 Monthly Financial Statement 0 Club Seat Sales: $5,333 General Page 88 of 89 Capital Improvements/Repairs Working on capital projects including marquee and Northside Renovation Project. Page 89 of 89