Page 128 - City of Westlake FY20 Budget

SUMMARY ‐ FIVE YEAR FINANCIAL FORECAST

Revision 06
ADOPTED ESTIMATED ADOPTED Projected Projected Projected Projected
FY 18‐19 FY 18‐19 FY 19‐20 FY 20‐21 FY 21‐22 FY 22‐23 FY 23‐24

DEBT SERVICE FUNDS
Total Revenues and Other Sources $ 2,662,779 $ 2,705,331 $ 2,654,710 $ 2,692,314 $ 2,695,083 $ 2,691,693 $ 2,688,588
Total Expenditures and Other Uses (2,693,600) (2,693,600) (2,697,690) (2,692,314) (2,695,083) (2,691,693) (2,688,588)
NET CHANGE TO FUND BALANCE (30,821) 11,731 (42,980) ‐ ‐ ‐ ‐
Beginning Fund Balance 30,821 31,249 42,980 ‐ ‐ ‐ ‐
Ending Fund Balance 0 42,980 ‐ ‐ ‐ ‐ ‐
Restricted/Committed/Assigned 0 42,980 ‐ ‐ ‐ ‐ ‐
Unassigned Ending Balance $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐

CAPITAL PROJECT FUNDS

Total Revenues and Other Sources $ 4,643,614 $ 2,388,826 $ 1,370,886 $ 2,371,751 $ 508,945 $ 462,505 $ 462,505
Total Expenditures and Other Uses (4,676,681) (3,010,728) (2,385,749) (1,794,646) (55,000) ‐ ‐
NET CHANGE TO FUND BALANCE (33,067) (621,902) (1,014,863) 577,105 453,945 462,505 462,505
Beginning Fund Balance 7,202,595 7,245,405 6,623,503 5,608,640 6,185,745 6,639,690 7,102,195
Ending Fund Balance 7,169,528 6,623,503 5,608,640 6,185,745 6,639,690 7,102,195 7,564,700
Restricted/Committed/Assigned 7,169,528 6,623,503 5,608,640 6,185,745 6,639,690 7,102,195 7,564,700
Unassigned Ending Balance $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐

GRAND TOTAL ALL MUNICIPAL FUND TYPES
Total Revenues and Other Sources $ 38,749,699 $ 32,652,311 $ 24,396,042 $ 26,351,310 $ 24,680,453 $ 25,512,541 $ 26,246,591
Total Expenditures and Other Uses (29,762,974) (29,640,792) (25,235,238) (24,493,938) (22,654,903) (22,828,606) (25,029,386)
NET CHANGE TO FUND BALANCE 8,986,724 3,011,519 (839,196) 1,857,373 2,025,551 2,683,936 1,217,205
Beginning Fund Balance 19,629,052 21,405,778 24,417,301 23,578,101 25,435,474 27,461,024 30,144,960
Ending Fund Balance 28,615,777 24,417,297 23,578,105 25,435,474 27,461,024 30,144,960 31,362,165
Restricted/Committed/Assigned 11,906,771 11,793,149 10,217,862 10,553,604 11,279,349 12,654,869 12,532,339
Unassigned Ending Balance $ 16,709,008 $ 12,624,148 $ 13,360,243 $ 14,881,870 $ 16,181,676 $ 17,490,091 $ 18,829,826

116