Revenue Assumptions and Budgeting for CCSD 146 Tinley Park

CCSD 146 Tinley Park Presented by Steve Crouse Senior Analytics Advisor February 13, 2017

Budgeted Revenues by Source: Operating Funds 2017 Budgeted Revenue Allocation by Source Other State Revenue 6% Federal Revenue 5% General State Aid 4% Other Local Revenue 2% Property Taxes 83% 3/18/2025 Forecast5 Analytics, Inc. 2

Key Revenue Assumptions Local Revenue Equalized Assessed Valuation (EAV) Changes without New Property 2016 Levy 5.00% growth 2017 Levy 5.00% growth 2018 Levy 1.70% growth 2019 Levy 1.70% growth 2020 Levy 1.70% growth 2021 Levy 1.70% growth New Property Assumptions $1,000,000 per year Expiration of TIF in Tax Year 2018 3/18/2025 Forecast5 Analytics, Inc. 3

Key Revenue Assumptions Local Revenue Consumer Price Index (CPI) 2014 Levy 1.5% (actual) 2015 Levy 0.8% (actual) 2016 Levy 0.7% (actual) 2017 Levy 2.1% (actual) 2018 Levy 1.6% (projected) 2019 Levy 1.6% (projected) 2020 Levy 1.6% (projected) 2021 Levy 1.6% (projected) 3/18/2025 Forecast5 Analytics, Inc. 4

Key Revenue Assumptions General State Aid $6,119 foundation level held flat 100% proration for all future years General State Aid Revenue $1,800 $1,600 $1,400 $1,200 $1,000 $800 $600 $400 $200 $0 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 Enrollment Projections Held flat at 2,275 through FY18, increased to 2,386 for Full Day Kindergarten in future years 3/18/2025 Forecast5 Analytics, Inc. 5

Key Revenue Assumptions Ed Fund Tuition and Other Local Revenue increased by 2% in future years Transportation Fund State Reimbursement increased by 2% in future years All other revenues held flat 3/18/2025 Forecast5 Analytics, Inc. 6

Budgeted Expenses by Object: Operating Funds 2017 Budgeted Expenditure Allocation by Object Other Objects 2% Non-Capitalized Equipment 2% Capital Outlay 1% Supplies And Materials 8% Purchased Services 10% Salaries 61% Benefits 16% 3/18/2025 Forecast5 Analytics, Inc. 7

Key Expenditure Assumptions Salaries per negotiated agreements (tied to CPI) FTE increased in FY19 for Full Day Kindergarten, flat otherwise Health insurance increasing by 5% in future years Dental Insurance increasing by 1% in future years Ed Fund Purchased Services, Supplies, Other Objects, Capital Outlay & Non- Capitalized Equipment increased 1.6% in future years O&M Fund: Purchased Services increased 2% in future years Supplies, Capital Outlay, & Non-Capitalized Equipment increased 1.6% in future years Transportation Fund: Purchased Services, & Supplies increased 2% in future years Capital Projects Fund: $6 Million construction in FY18, $3 million in FY19 for FDK 3/18/2025 Forecast5 Analytics, Inc. 8

Aggregate Projections Operating Funds Budget REVENUE / EXPENDITURE PROJECTIONS FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 % % % % % REVENUE Local State Federal Other $30,940,524 $3,566,673 $1,947,773 $31,380,231 $3,521,773 $1,947,773 1.42% -1.26% 0.00% $32,303,590 $3,546,555 $1,947,773 2.94% 0.70% 0.00% $33,469,981 $3,595,441 $1,947,773 3.61% 1.38% 0.00% $33,791,145 $3,631,977 $1,947,773 0.96% 1.02% 0.00% $34,388,939 $3,657,483 $1,947,773 1.77% 0.70% 0.00% $0 $0 $0 $0 $0 $0 TOTAL REVENUE $36,454,970 $36,849,777 1.08% $37,797,918 2.57% $39,013,194 3.22% $39,370,895 0.92% $39,994,196 1.58% EXPENDITURES Salary and Benefit Costs $27,239,692 $8,189,528 $35,429,220 $28,156,499 $8,324,542 $36,481,041 3.37% 1.65% 2.97% $29,792,030 $8,527,880 $38,319,910 5.81% 2.44% 5.04% $30,650,874 $8,668,702 $39,319,576 2.88% 1.65% 2.61% $31,536,918 $8,811,948 $40,348,866 2.89% 1.65% 2.62% $32,451,121 $8,957,660 $41,408,782 2.90% 1.65% 2.63% Other TOTAL EXPENDITURES SURPLUS / DEFICIT $1,025,750 $368,736 ($521,992) ($306,382) ($977,970) ($1,414,586) OTHER FINANCING SOURCES/USES Other Financing Sources Other Financing Uses TOTAL OTHER FIN. SOURCES/USES $0 $0 $0 $0 $0 $0 $0 $0 ($6,000,000) ($6,000,000) ($3,000,000) ($3,000,000) ($325,000) ($325,000) ($325,000) ($325,000) ($325,000) ($325,000) SURPLUS / DEFICIT INCL. OTHER FIN. SOURCES $1,025,750 ($5,631,264) ($3,521,992) ($631,382) ($1,302,970) ($1,739,586) BEGINNING FUND BALANCE $32,241,281 $33,267,031 $27,635,767 $24,113,775 $23,482,393 $22,179,422 $0 $0 $0 $0 $0 $0 AUDIT ADUSTMENTS TO FUND BALANCE PROJECTED YEAR END BALANCE $33,267,031 $27,635,767 $24,113,775 $23,482,393 $22,179,422 $20,439,836 FUND BALANCE AS % OF EXPENDITURES 93.90% 75.75% 62.93% 59.72% 54.97% 49.36% FUND BALANCE AS # OF MONTHS OF EXPEND. 11.27 9.09 7.55 7.17 6.60 5.92 3/18/2025 Forecast5 Analytics, Inc. 9

Aggregate Projections Operating Funds Projected Year-End Balances FY 2012 $40 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Millions $35 $33,267,031 $32,738,834 $32,241,281 $31,634,059 $30,752,366 $30,372,334 $30 $27,635,767 $25 $24,113,775 $22,179,422 $23,482,393 $20,439,836 $20 18,028,595 17,867,539 17,382,924 16,992,377 16,514,189 16,025,974 $15 12,567,703 $10 9,112,130 7,825,371 6,737,788 $5 4,962,061 $- $(5) $(10) 10 Educational 20 Operations & Maintenance 40 Transportation 50 Municipal Retirement/Social Security 70 Working Cash 80 Tort 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 FY End Balances % of Revenues Estimated Low-Point 3/18/2025 Forecast5 Analytics, Inc. 10

Aggregate Projections All Funds Budget REVENUE / EXPENDITURE PROJECTIONS FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 % % % % % REVENUE Local State Federal Other $33,995,492 $3,566,673 $1,947,773 $34,280,013 $3,521,773 $1,947,773 0.84% -1.26% 0.00% $35,210,783 $3,546,555 $1,947,773 2.72% 0.70% 0.00% $36,391,090 $3,595,441 $1,947,773 3.35% 1.38% 0.00% $36,665,801 $3,631,977 $1,947,773 0.75% 1.02% 0.00% $37,262,091 $3,657,483 $1,947,773 1.63% 0.70% 0.00% $0 $0 $0 $0 $0 $0 TOTAL REVENUE $39,509,938 $39,749,559 0.61% $40,705,111 2.40% $41,934,303 3.02% $42,245,551 0.74% $42,867,348 1.47% EXPENDITURES Salary and Benefit Costs $27,239,692 $11,449,842 $38,689,534 $28,156,499 $17,269,528 $45,426,027 3.37% 50.83% 17.41% $29,792,030 $14,485,633 $44,277,663 5.81% -16.12% -2.53% $30,650,874 $11,932,022 $42,582,896 2.88% -17.63% -3.83% $31,536,918 $12,051,099 $43,588,017 2.89% 1.00% 2.36% $32,451,121 $12,237,660 $44,688,782 2.90% 1.55% 2.53% Other TOTAL EXPENDITURES SURPLUS / DEFICIT $820,404 ($5,676,468) ($3,572,552) ($648,593) ($1,342,465) ($1,821,434) OTHER FINANCING SOURCES/USES Other Financing Sources Other Financing Uses TOTAL OTHER FIN. SOURCES/USES $0 $0 $0 $6,000,000 ($6,000,000) $3,000,000 ($3,000,000) $325,000 ($325,000) $325,000 ($325,000) $325,000 ($325,000) $0 $0 $0 $0 $0 SURPLUS / DEFICIT INCL. OTHER FIN. SOURCES $820,404 ($5,676,468) ($3,572,552) ($648,593) ($1,342,465) ($1,821,434) BEGINNING FUND BALANCE $35,930,907 $36,751,311 $31,074,843 $27,502,291 $26,853,698 $25,511,232 $0 $0 $0 $0 $0 $0 AUDIT ADUSTMENTS TO FUND BALANCE PROJECTED YEAR END BALANCE $36,751,311 $31,074,843 $27,502,291 $26,853,698 $25,511,232 $23,689,798 FUND BALANCE AS % OF EXPENDITURES 94.99% 68.41% 62.11% 63.06% 58.53% 53.01% FUND BALANCE AS # OF MONTHS OF EXPEND. 11.40 8.21 7.45 7.57 7.02 6.36 3/18/2025 Forecast5 Analytics, Inc. 11

Aggregate Projections All Funds Projected Year-End Balances FY 2012 $40 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Millions $36,751,311 $35,930,907 $35 $34,576,663 $33,652,534 $33,446,715 $33,407,970 $31,074,843 $30 $27,502,291 $25,511,232 $26,853,698 $23,689,798 $25 20,235,330 $20 18,686,263 18,544,284 18,392,003 17,727,239 17,680,104 17,653,539 $15 12,720,717 $10 10,054,643 8,960,725 7,127,121 $5 $- $(5) $(10) 10 Educational 20 Operations & Maintenance 30 Debt Services 40 Transportation 50 Municipal Retirement/Social Security 60 Capital Projects 70 Working Cash 80 Tort 90 Fire Prevention & Safety 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 FY End Balances % of Revenues Estimated Low-Point 3/18/2025 Forecast5 Analytics, Inc. 12

Data Elements Observations FY17 Budget is the basis of projections Significant legislative unknowns Grand Bargain Property Tax Freeze GSA Formula Changes & State Categorical Funding TRS Cost Shift No State Budget Assumptions provided by the District 3/18/2025 Forecast5 Analytics, Inc. 13

DISCLAIMER The information in this presentation was prepared for informational purposes solely for client or prospective cClient ( Client ) from products or services of Forecast 5 Analytics, Inc. (F5) including 5Cast and is therefore subject to the Terms and Conditions of such products available at forecast5analytics.com. F5 has explained the formulas and methodologies used by 5Cast and Client agrees that such formulas and methodologies are appropriate and suitable for its financial management applications. F5 has made no independent examination of the context in which the District intends to use the data from 5Cast. The data and assumptions underlying this output were provided by District. Changes to any prices, levels, or assumptions may have a material impact on results. A change in District s fiscal policies, fundamental changes in legislative or other actions will likely also have a substantial impact on any output. At the request of Client, F5 may provide opinions or representations with respect to the financial feasibility and/or fiscal prudence of any assumptions and/or projections that Client may select and such input is subject to change without notice. Moreover, in that instance it is understood that Client is solely responsible for the decision and any associated risk of incorporating any particular assumption in its financial plan. Examples are merely representative and are not meant to be all-inclusive. F5 s analyses are not and do not purport to be appraisals of the assets, or business of Client or other entity. It is expected that the Client review the financial plan data for reasonableness, and to verify such results or otherwise seek assistance from F5 or another third party before relying on such data in such cases. The information set forth herein was gathered from sources which F5 believes but does not guarantee to be accurate. Neither the information, nor any options expressed, constitute a solicitation for purposes of the purchase or sale of any securities or other investments and is not in any way intended to suggest/discuss potentially applicable financing applications. Investment/financing decisions by market participants should not be based on this information. F5 also does not provide legal, tax, or accounting advice. It is imperative that Client perform its own research and due diligence, independent of F5 or its affiliates, to determine the appropriateness of the proposed financial plan with respect to the aforementioned potential economic risks and legal, tax, and accounting consequences. F5 is affiliated with PMA Financial Network, Inc., PMA Securities, Inc. and Prudent Man Advisors, Inc. (the three entities collectively being referred to as PMA ). Securities, public finance/municipal advisory services and institutional brokerage services are offered through PMA Securities, Inc. PMA Securities, Inc. is a broker- dealer and municipal advisor registered with the SEC and MSRB, and is a member of FINRA and SIPC. Prudent Man Advisors, Inc., an SEC registered investment adviser, provides investment advisory services to local government investment pools and separate institutional accounts. All other products and services through PMA are provided by PMA Financial Network, Inc. The presenter is a registered person associated with PMA Securities. If posted on a webpage, this information has been prepared for informational purposes and does not constitute a solicitation to purchase or sell securities, which may be done through a registered entity only after client suitability is reviewed and determined. Services offered by PMA Securities, Inc. and this registered presenter, in particular, are available only in the following state: IL. This information is not an advertisement of services available in any state other than those listed above. 3/18/2025 Forecast5 Analytics, Inc. 14