Page 49 - 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

GENERAL FUND

Total Revenues and Other Sources $ 9,620,674 $ 10,803,381 $ 10,788,545 $ 12,595,182 $ 11,146,167 $ 13,077,992 $ 11,870,153
Total Expenditures and Other Uses (10,675,746) (9,968,481) (14,070,731) (11,742,412) (12,223,542) (12,979,575) (12,456,975)
NET CHANGE TO FUND BALANCE (1,055,072) 834,900 (3,282,186) 852,770 (1,077,375) 98,417 (586,821)
Beginning Fund Balance 14,498,447 14,498,447 15,333,347 12,051,161 12,903,932 11,826,557 11,924,973
Ending Fund Balance 13,443,375 15,333,347 12,051,161 12,903,932 11,826,557 11,924,973 11,338,152
Restricted/Committed/Assigned 298,560 727,479 727,479 727,479 727,479 727,479 727,479
Unassigned Ending Balance $ 13,144,815 $ 14,605,868 $ 11,323,682 $ 12,176,453 $ 11,099,078 $ 11,197,494 $ 10,610,673
Operating Expenditures $10,665,746 $9,883,481 $10,070,731 $10,042,412 $10,273,542 $10,529,575 $10,756,975
Operating Cost per Day $29,221 $27,078 $27,591 $27,513 $28,147 $28,848 $29,471
OPERATING DAYS 450 539 410 443 394 388 360

ENTERPRISE FUNDS

Total Revenues and Other Sources $ 5,819,803 $ 5,781,493 $ 5,724,016 $ 5,799,081 $ 5,910,367 $ 6,020,717 $ 6,108,474

Total Expenditures and Other Uses (5,641,207) (5,018,495) (6,013,468) (5,748,112) (5,883,531) (5,892,159) (5,965,320)
NET CHANGE TO FUND BALANCE 178,596 762,998 (289,452) 50,969 26,836 128,558 143,154
Beginning Working Capital 5,738,480 5,738,480 6,501,477 6,212,025 6,262,994 6,289,830 6,418,388
Ending Working Capital 5,917,075 6,501,477 6,212,025 6,262,994 6,289,830 6,418,388 6,561,542
Restricted/Committed/Assigned 1,456,495 1,435,795 1,284,894 1,276,410 1,267,777 1,254,148 1,240,272
Unassigned Working Capital $ 4,460,581 $ 5,065,683 $ 4,927,131 $ 4,986,584 $ 5,022,052 $ 5,164,240 $ 5,321,270

INTERNAL SERVICE FUNDS

Total Revenues and Other Sources $ 109,275 $ 614,275 $ 2,980,775 $ 1,665,050 $ 1,980,050 $ 2,415,050 $ 1,665,050
Total Expenditures and Other Uses (1,143,500) (729,500) (2,033,287) (972,000) (1,518,000) (3,785,000) (1,218,515)
NET CHANGE TO FUND BALANCE (1,034,225) (115,225) 947,488 693,050 462,050 (1,369,950) 446,535
Beginning Fund Balance 1,980,839 1,980,839 1,865,614 2,813,102 3,506,152 3,968,202 2,598,252
Ending Fund Balance 946,614 1,865,614 2,813,102 3,506,152 3,968,202 2,598,252 3,044,787
Restricted/Committed/Assigned 946,614 1,865,614 2,813,102 3,506,152 3,968,202 2,598,252 3,044,787
Unassigned Ending Balance $ - $ - $ - $ - $ - $ - $ -

SPECIAL REVENUE FUNDS

Total Revenues and Other Sources $ 1,470,625 $ 1,912,750 $ 2,465,250 $ 2,308,667 $ 2,387,206 $ 2,469,361 $ 2,527,348

Total Expenditures and Other Uses (1,612,716) (2,057,341) (2,381,299) (2,497,682) (2,485,319) (2,830,146) (2,844,829)
NET CHANGE TO FUND BALANCE (142,091) (144,591) 83,951 (189,015) (98,113) (360,785) (317,481)
Beginning Fund Balance 834,616 834,616 690,025 773,976 584,962 486,849 126,064
Ending Fund Balance 692,525 690,025 773,976 584,962 486,849 126,064 (191,417)
Restricted/Committed/Assigned 692,525 690,025 773,976 584,962 486,849 126,064 (191,417)
Unassigned Ending Balance $ - $ - $ - $ - $ - $ - $ -

47