Page 50 - PowerPoint Presentation

FIVE YEAR FINANCIAL FORECAST

Revision 06
ADOPTED REVISED PROPOSED Projected Projected Projected Projected
FUND
FY 20/21 FY 20/21 FY 21/22 FY 22/23 FY 23/24 FY 24/25 FY 25/26

DEBT SERVICE FUNDS

Total Revenues and Other Sources $ 2,654,572 $ 2,649,259 2,760,000 3,122,425 3,127,621 3,423,779 3,413,229
Total Expenditures and Other Uses (2,691,274) (2,691,189) (2,868,589) (3,122,425) (3,127,621) (3,423,779) (3,413,229)
NET CHANGE TO FUND BALANCE (36,702) (41,930) (108,589) - - - -
Beginning Fund Balance 150,518 150,518 108,588 (0) (0) (0) (0)
Ending Fund Balance 113,816 108,588 (0) (0) (0) (0) (0)
Restricted/Committed/Assigned 113,816 108,973 (0) (0) (0) (0) (0)
Unassigned Ending Balance $ - $ (385) $ (0) $ - $ - $ - $ -

CAPITAL PROJECT FUNDS

Total Revenues and Other Sources $ 280,000 $ 2,568,000 $ 4,614,602 $ 10,000 $ 10,000 $ 10,000 $ 10,000

Total Expenditures and Other Uses (1,613,830) (2,169,130) (2,991,720) (579,017) (682,865) 0 0
NET CHANGE TO FUND BALANCE (1,333,830) 398,870 1,622,882 (569,017) (672,865) 10,000 10,000
Beginning Fund Balance 4,502,451 4,502,451 4,901,321 6,524,203 5,955,186 5,282,321 5,292,321
Ending Fund Balance 3,168,621 4,901,321 6,524,203 5,955,186 5,282,321 5,292,321 5,302,321
Restricted/Committed/Assigned 3,168,621 4,901,321 6,524,203 5,955,186 5,282,321 5,292,321 5,302,321
Unassigned Ending Balance $ - $ - $ - $ - $ - $ - $ -

GRAND TOTAL ALL MUNICIPAL FUND TYPES

Total Revenues and Other Sources $ 19,954,949 $ 24,329,158 $ 29,333,188 $ 25,500,405 $ 24,561,411 $ 27,416,899 $ 25,594,254

Total Expenditures and Other Uses (23,378,273) (22,634,136) (30,359,093) (24,661,647) (25,920,878) (28,910,659) (25,898,867)
NET CHANGE TO FUND BALANCE (3,423,324) 1,695,022 (1,025,905) 838,758 (1,359,468) (1,493,760) (304,613)
Beginning Fund Balance 27,705,352 27,705,352 25,005,509 28,374,467 29,213,225 27,853,758 26,359,998
Ending Fund Balance 24,282,027 29,400,373 28,374,468 29,213,225 27,853,758 26,359,998 26,055,384
Restricted/Committed/Assigned 6,676,631 9,729,207 12,123,654 12,050,189 11,732,628 9,998,264 10,123,441
Unassigned Ending Balance $ 17,605,396 $ 19,671,166 $ 16,250,814 $ 17,163,037 $ 16,121,130 $ 16,361,734 $ 15,931,943

48