SLIDE 20 7
FIVE YEAR PLANNING FORECAST (NEW) Budget(Forecast)/Millage Rate Calculation Scenario 3
Amended Actual Amended Projected Projected Projected Projected FY19 FY19 FY20 FY21 FY22 FY23 FY24 BEGINNING FUND BALANCE 24,165,807 24,611,837 25,938,114 34,738,632 40,039,696 41,069,116 39,947,347 Property Value
79,417,253,029 79,417,253,029 85,328,871,674 91,683,159,071 88,015,832,708 88,895,991,035 90,673,910,856
Tax Revenue (95% in FY 21, all other years 97%) 69,184,896 68,840,746 74,334,844 78,223,613 76,675,609 77,442,365 78,991,212 Other Revenue 935,291 1,354,962 1,272,611 691,740 691,740 691,740 691,740 TOTAL NET REVENUES 70,120,187 70,195,708 75,607,455 78,915,353 77,367,349 78,134,105 79,682,952 TOTAL RESOURCES 94,285,994 94,807,545 101,545,569 113,653,985 117,407,044 119,203,220 119,630,299 Administration 7,921,732 7,394,004 8,258,127 8,413,639 9,034,680 9,579,158 10,185,914 Non-Administration 2,220,054 2,102,079 2,409,509 3,135,555 3,208,613 3,283,374 3,359,877 Program Continuation 64,089,884 56,134,560 66,475,597 66,120,447 68,268,018 70,860,306 73,494,071 Program COLAs
1,047,571 1,092,288 1,133,765 1,175,905 Capital RFA (One Time Only) 1,000,000 991,182 1,000,000 1,250,000 1,000,000 1,000,000 1,000,000 Future Programming 638,339
1,100,000 1,500,000 1,500,000 1,500,000 Contingency 500,000
1,000,000 1,000,000 1,000,000 1,000,000 TOTAL EXPENDITURES 76,370,009 66,621,825 79,667,581 82,067,212 85,103,600 88,356,603 91,715,767 REVENUE MINUS EXPENDITURES (6,249,822) 3,573,883 (4,060,126) (3,151,859) (7,736,251) (10,222,499) (12,032,815) Projected Lapse*
8,452,923 8,765,671 9,100,730 9,446,724 PROJECTED SURPLUS / (LOSS) (6,249,822) 3,573,883 8,800,518 5,301,064 1,029,420 (1,121,768) (2,586,091) Two Month Cash Flow Reserve 12,728,335 11,103,638 13,224,864 13,677,869 14,183,933 14,726,101 15,285,961 Unassigned Fund Balance less Cash Flow Reserve** 5,187,650 17,082,083 21,513,768 26,361,827 26,885,182 25,221,246 22,075,295 Unassigned Fund Balance % of Expenditures 7% 26% 27% 32% 32% 29% 24% Total Unassigned Fund Balance 17,915,985 28,185,720 34,738,632 40,039,696 41,069,116 39,947,347 37,361,256 TOTAL REQUIREMENTS 94,285,994 94,807,546 101,545,569 113,653,985 117,407,044 119,203,220 119,630,299 ADMINISTRATIVE RATE 8.40% 7.80% 8.13% 7.40% 7.70% 8.04% 8.51% FY20 FY21 FY22 FY23 FY24 Property Value (same as County) 7.49% 7.27%
1.00% 2.00% Millage Rate 0.8981 0.8981 0.8981 0.8981 0.8981 Other Revenues 36.07%
0.00% 0.00% 0.00% Administration Salaries 3.21% 1.90% 3.00% 3.00% 3.00% Fringe 11.02% 8.85% 15.00% 15.00% 15.00% Operating 3.06%
1.00% 1.00% 1.00% Non-Administration 8.53% 30.13% 2.33% 2.33% 2.33% Program Continuation 5.15%
3.25% 3.80% 3.72% Eligible Programs COLA's 1.38% 1.58% 1.60% 1.60% 1.60% Lapse Projection (3 year rolling average)* 16.14% 10.30% 10.30% 10.30% 10.30%
* Lapse Projections represent the anticipated annual lapse amount, and is not reflected in the annual budget ** Unassigned Fund Balance includes projected surplus/(loss) 9/15/2020
Forecast Assumptions
Balanced Budget - Recurring expenditures should be equal to or less than recurring revenues. Projected lapse used to balance the budget and projected one- time-
- nly expenditures are funded by excess fund balance.