Financial Planning Tool for Multi-Year Budget Analysis
"Explore a powerful financial planning tool designed for developing multi-year financial plans, conducting scenario comparisons, detailed budget analysis, and more. Access historical financial data and revenue projections to enhance financial forecasting."
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
A powerful financial planning tool that can be used for: Development of a multi-year financial plan Scenario comparisons and what-if analysis Detailed budget and performance analysis Budget preparation and upload to accounting system Budget distribution and stakeholder reporting 4/19/2025 Forecast5 Analytics, Inc. 2
Data Elements Annual Financial Reports (AFRs) for the past five years FY19 Budget - Base for financial projections Historical Tax Extension Reports History of Equalized Assessed Valuations / New Construction Current & projected staffing 4/19/2025 Forecast5 Analytics, Inc. 3
Revenue Budget FY 2019 Budget Revenue by Source Operating Funds Budget Total = $11,942,580 Operating Funds Education, Operations & Maintenance, Transportation, Illinois Municipal Retirement, and Working Cash Funds 4/19/2025 Forecast5 Analytics, Inc. 4
Local Revenue: Tax Base Assumptions 4/19/2025 Forecast5 Analytics, Inc. 5
Local Revenue: Tax Base Assumptions 4/19/2025 Forecast5 Analytics, Inc. 6
Key Revenue Assumptions Revenue Sensitivity Tax Levy: CPI 1% +/- $90 thousand New Property: $1 million +/- $14,000 4/19/2025 Forecast5 Analytics, Inc. 7
Key Revenue Assumptions All other local revenues: Projected at current FY19 budgeted levels 4/19/2025 Forecast5 Analytics, Inc. 8
Key Revenue Assumptions Revenue Assumptions State & Federal State Revenue Evidence Based Funding (EBF) Tier 4 - Flat funding for projections Other State Grants Flat funding for projections Federal Revenue projected at current FY19 budgeted levels 4/19/2025 Forecast5 Analytics, Inc. 9
Expense Budget FY 2019 Budget Expenditures by Object Operating Funds Budget Total = $11,550,978 Operating Funds Education, Operations & Maintenance, Transportation, Illinois Municipal Retirement, and Working Cash Funds 4/19/2025 Forecast5 Analytics, Inc. 10
Key Expenditure Assumptions Salaries All Employees 3.0% - 3.5% annual increases Benefits 4% annual increases for health benefits Purchased Services, Supplies, Capital Outlay, Other CPI annual increases 4/19/2025 Forecast5 Analytics, Inc. 11
Other Assumptions Additional Assumptions and Potential Budget Threats No change to PTELL (Tax Cap) legislation FY19 Budget is accurate base for projections 4/19/2025 Forecast5 Analytics, Inc. 12
Education Fund Revenue and Expenditure Projections BUDGET REVENUE / EXPENDITURE PROJECTIONS FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 % % % % % REVENUE Local State Federal Other $8,129,901 $557,657 $382,199 $8,350,409 $557,657 $382,199 2.71% 0.00% 0.00% $8,561,608 $557,657 $382,199 2.53% 0.00% 0.00% $8,776,770 $557,657 $382,199 2.51% 0.00% 0.00% $8,995,982 $557,657 $382,199 2.50% 0.00% 0.00% $9,219,333 $557,657 $382,199 2.48% 0.00% 0.00% $0 $0 $0 $0 $0 $0 TOTAL REVENUE $9,069,757 $9,290,265 2.43% $9,501,464 2.27% $9,716,626 2.26% $9,935,838 2.26% $10,159,189 2.25% EXPENDITURES Salary and Benefit Costs $6,273,925 $2,797,008 $9,070,933 $6,230,630 $2,855,745 $9,086,375 -0.69% 2.10% 0.17% $6,425,969 $2,915,716 $9,341,685 3.14% 2.10% 2.81% $6,627,648 $2,976,946 $9,604,594 3.14% 2.10% 2.81% $6,835,874 $3,039,462 $9,875,336 3.14% 2.10% 2.82% $7,050,864 $3,103,290 $10,154,154 3.15% 2.10% 2.82% Other TOTAL EXPENDITURES SURPLUS / DEFICIT ($1,176) $203,889 $159,778 $112,032 $60,502 $5,035 OTHER FINANCING SOURCES / USES Other Financing Sources Other Financing Uses TOTAL OTHER FIN. SOURCES / USES $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 ($769,000) ($769,000) SURPLUS / DEFICIT INCL. OTHER FIN. SOURCES ($770,176) $203,889 $159,778 $112,032 $60,502 $5,035 BEGINNING FUND BALANCE $6,199,786 $5,429,610 $5,633,499 $5,793,277 $5,905,309 $5,965,811 AUDIT ADUSTMENTS TO FUND BALANCE PROJECTED YEAR END BALANCE $5,429,610 $5,633,499 $5,793,277 $5,905,309 $5,965,811 $5,970,846 FUND BALANCE AS % OF EXPENDITURES 59.86% 62.00% 62.02% 61.48% 60.41% 58.80% FUND BALANCE AS # OF MONTHS OF EXPEND. 7.18 7.44 7.44 7.38 7.25 7.06 4/19/2025 Forecast5 Analytics, Inc. 13
O&M Fund Revenue and Expenditure Projections BUDGET REVENUE / EXPENDITURE PROJECTIONS FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 % % % % % REVENUE Local State Federal Other $2,016,541 $1,485,973 -26.31% $1,520,696 2.34% $1,556,070 2.33% $1,592,110 2.32% $1,628,831 2.31% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 TOTAL REVENUE $2,016,541 $1,485,973 -26.31% $1,520,696 2.34% $1,556,070 2.33% $1,592,110 2.32% $1,628,831 2.31% EXPENDITURES Salary and Benefit Costs $122,730 $1,396,600 $1,519,330 $126,894 $1,425,404 $1,552,298 3.39% 2.06% 2.17% $131,201 $1,454,812 $1,586,013 3.39% 2.06% 2.17% $135,656 $1,484,838 $1,620,494 3.40% 2.06% 2.17% $140,263 $1,515,495 $1,655,758 3.40% 2.06% 2.18% $145,029 $1,546,795 $1,691,824 3.40% 2.07% 2.18% Other TOTAL EXPENDITURES SURPLUS / DEFICIT $497,211 ($66,325) ($65,317) ($64,424) ($63,648) ($62,993) OTHER FINANCING SOURCES / USES Other Financing Sources Other Financing Uses TOTAL OTHER FIN. SOURCES / USES $0 $0 $0 $0 $0 $0 ($353,185) ($353,185) ($353,185) ($353,185) ($353,185) ($353,185) ($353,185) ($353,185) ($353,185) ($353,185) ($353,185) ($353,185) SURPLUS / DEFICIT INCL. OTHER FIN. SOURCES $144,026 ($419,510) ($418,502) ($417,609) ($416,833) ($416,178) BEGINNING FUND BALANCE $1,835,459 $1,979,485 $1,559,975 $1,141,473 $723,864 $307,031 AUDIT ADUSTMENTS TO FUND BALANCE PROJECTED YEAR END BALANCE $1,979,485 $1,559,975 $1,141,473 $723,864 $307,031 ($109,147) FUND BALANCE AS % OF EXPENDITURES 130.29% 100.49% 71.97% 44.67% 18.54% -6.45% FUND BALANCE AS # OF MONTHS OF EXPEND. 15.63 12.06 8.64 5.36 2.23 -0.77 4/19/2025 Forecast5 Analytics, Inc. 14
Transportation Fund Revenue and Expenditure Projections BUDGET REVENUE / EXPENDITURE PROJECTIONS FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 % % % % % REVENUE Local State Federal Other $503,589 $184,388 $523,123 $184,388 3.88% 0.00% $536,745 $184,388 2.60% 0.00% $550,623 $184,388 2.59% 0.00% $564,762 $184,388 2.57% 0.00% $579,167 $184,388 2.55% 0.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 TOTAL REVENUE $687,977 $707,511 2.84% $721,133 1.93% $735,011 1.92% $749,150 1.92% $763,555 1.92% EXPENDITURES Salary and Benefit Costs $23,660 $745,665 $769,325 $24,374 $760,799 $785,173 3.02% 2.03% 2.06% $25,110 $776,251 $801,361 3.02% 2.03% 2.06% $25,869 $792,027 $817,896 3.02% 2.03% 2.06% $26,650 $808,135 $834,785 3.02% 2.03% 2.06% $27,455 $824,580 $852,035 3.02% 2.04% 2.07% Other TOTAL EXPENDITURES SURPLUS / DEFICIT ($81,348) ($77,662) ($80,228) ($82,885) ($85,635) ($88,480) OTHER FINANCING SOURCES / USES Other Financing Sources Other Financing Uses TOTAL OTHER FIN. SOURCES / USES $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 SURPLUS / DEFICIT INCL. OTHER FIN. SOURCES ($81,348) ($77,662) ($80,228) ($82,885) ($85,635) ($88,480) BEGINNING FUND BALANCE $375,639 $294,291 $216,629 $136,400 $53,516 ($32,119) AUDIT ADUSTMENTS TO FUND BALANCE PROJECTED YEAR END BALANCE $294,291 $216,629 $136,400 $53,516 ($32,119) ($120,599) FUND BALANCE AS % OF EXPENDITURES 38.25% 27.59% 17.02% 6.54% -3.85% -14.15% FUND BALANCE AS # OF MONTHS OF EXPEND. 4.59 3.31 2.04 0.79 -0.46 -1.70 4/19/2025 Forecast5 Analytics, Inc. 15
Aggregate Revenue and Expenditure Projections BUDGET REVENUE / EXPENDITURE PROJECTIONS FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 % % % % % REVENUE Local State Federal Other $10,818,606 $742,045 $382,199 $10,535,138 $742,045 $382,199 -2.62% 0.00% 0.00% $10,799,604 $742,045 $382,199 2.51% 0.00% 0.00% $11,069,032 $742,045 $382,199 2.49% 0.00% 0.00% $11,343,531 $742,045 $382,199 2.48% 0.00% 0.00% $11,623,214 $742,045 $382,199 2.47% 0.00% 0.00% $0 $0 $0 $0 $0 $0 TOTAL REVENUE $11,942,850 $11,659,382 -2.37% $11,923,848 2.27% $12,193,276 2.26% $12,467,775 2.25% $12,747,458 2.24% EXPENDITURES Salary and Benefit Costs $6,611,705 $4,939,273 $11,550,978 $6,575,764 $5,041,948 $11,617,711 -0.54% 2.08% 0.58% $6,782,424 $5,146,779 $11,929,203 3.14% 2.08% 2.68% $6,995,800 $5,253,811 $12,249,611 3.15% 2.08% 2.69% $7,216,114 $5,363,091 $12,579,205 3.15% 2.08% 2.69% $7,443,593 $5,474,666 $12,918,259 3.15% 2.08% 2.70% Other TOTAL EXPENDITURES SURPLUS / DEFICIT $391,872 $41,670 ($5,355) ($56,336) ($111,430) ($170,801) OTHER FINANCING SOURCES / USES Other Financing Sources Other Financing Uses TOTAL OTHER FIN. SOURCES / USES $0 $0 $0 $0 $0 $0 ($1,122,185) ($1,122,185) ($353,185) ($353,185) ($353,185) ($353,185) ($353,185) ($353,185) ($353,185) ($353,185) ($353,185) ($353,185) SURPLUS / DEFICIT INCL. OTHER FIN. SOURCES ($730,313) ($311,515) ($358,540) ($409,521) ($464,615) ($523,986) BEGINNING FUND BALANCE $9,002,656 $8,272,343 $7,960,828 $7,602,287 $7,192,767 $6,728,152 $0 $0 $0 $0 $0 $0 AUDIT ADUSTMENTS TO FUND BALANCE PROJECTED YEAR END BALANCE $8,272,343 $7,960,828 $7,602,287 $7,192,767 $6,728,152 $6,204,165 FUND BALANCE AS % OF EXPENDITURES FUND BALANCE AS # OF MONTHS OF EXPEND. 71.62% 8.59 68.52% 8.22 63.73% 7.65 58.72% 7.05 53.49% 6.42 48.03% 5.76 4/19/2025 Forecast5 Analytics, Inc. 16
Eleven Year Perspective 4/19/2025 Forecast5 Analytics, Inc. 17
