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

GENERAL FUND

Total Revenues and Other Sources $ 19,563,609 $ 14,758,012 $ 11,204,267 $ 11,582,242 $ 11,623,206 $ 11,800,916 $ 12,049,542
Total Expenditures and Other Uses (12,064,992) (12,404,565) (11,235,359) (11,220,348) (11,364,930) (11,556,384) (11,812,147)
NET CHANGE TO FUND BALANCE 7,498,617 2,353,447 (31,092) 361,894 258,276 244,531 237,395
Beginning Fund Balance 9,216,610 9,761,849 12,115,296 12,084,204 12,446,098 12,704,374 12,948,905
Ending Fund Balance 16,715,227 12,115,296 12,084,204 12,446,098 12,704,374 12,948,905 13,186,301
Restricted/Committed/Assigned 304,504 290,880 298,560 298,560 298,560 298,560 298,560
Unassigned Ending Balance $ 16,410,724 $ 11,824,416 $ 11,785,644 $ 12,147,538 $ 12,405,814 $ 12,650,345 $ 12,887,741
Operating Expenditures 9,578,926 $ 9,237,500 $ 9,880,629 $ 10,121,803 $ 10,366,385 $ 10,604,279 $ 10,860,042
Operating Cost per Day 26,146 $ 25,308 $ 27,070 $ 27,731 $ 28,401 $ 29,053 $ 29,754
OPERATING DAYS 350 467 435 438 437 435 433

ENTERPRISE FUNDS
Total Revenues and Other Sources $ 7,540,741 $ 7,001,651 $ 5,671,403 $ 5,805,842 $ 5,899,012 $ 5,994,356 $ 6,107,416
Total Expenditures and Other Uses (6,364,008) (6,649,006) (4,898,554) (4,786,119) (4,859,497) (4,932,485) (5,007,090)
NET CHANGE TO FUND BALANCE 1,176,733 352,645 772,849 1,019,723 1,039,515 1,061,870 1,100,326
Beginning Fund Balance 432,719 1,762,740 2,115,385 2,888,234 3,907,958 4,947,473 6,009,343
Ending Fund Balance 1,609,452 2,115,385 2,888,234 3,907,958 4,947,473 6,009,343 7,109,669
Restricted/Committed/Assigned 1,311,169 1,315,653 1,313,640 1,173,626 1,171,612 1,169,598 1,167,584
Unassigned Ending Balance $ 298,283 $ 799,732 $ 1,574,595 $ 2,734,332 $ 3,775,861 $ 4,839,746 $ 5,942,086

INTERNAL SERVICE FUNDS
Total Revenues and Other Sources $ 1,503,545 $ 2,427,253 $ 528,839 $ 796,484 $ 696,484 $ 696,484 $ 696,484
Total Expenditures and Other Uses (1,079,475) (1,340,869) (932,438) (860,000) (584,029) (442,000) (2,268,000)
NET CHANGE TO FUND BALANCE 424,070 1,086,384 (403,599) (63,516) 112,455 254,484 (1,571,516)
Beginning Fund Balance 1,570,999 1,434,482 2,520,867 2,117,268 2,053,752 2,166,207 2,420,691
Ending Fund Balance 1,995,069 2,520,867 2,117,268 2,053,752 2,166,207 2,420,691 849,175
Restricted/Committed/Assigned 1,995,069 2,520,867 2,117,268 2,053,752 2,166,207 2,420,691 849,175
Unassigned Ending Balance $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐

SPECIAL REVENUE FUNDS

Total Revenues and Other Sources $ 2,835,410 $ 3,371,237 $ 2,965,937 $ 3,102,677 $ 3,257,723 $ 3,866,588 $ 4,242,056
Total Expenditures and Other Uses (2,884,218) (3,542,024) (3,085,448) (3,140,510) (3,096,364) (3,206,043) (3,253,561)
NET CHANGE TO FUND BALANCE (48,808) (170,787) (119,511) (37,833) 161,359 660,545 988,495
Beginning Fund Balance 1,175,308 1,170,052 999,265 879,754 841,921 1,003,280 1,663,825
Ending Fund Balance 1,126,501 999,265 879,754 841,921 1,003,280 1,663,825 2,652,320
Restricted/Committed/Assigned 1,126,500 999,265 879,754 841,921 1,003,280 1,663,825 2,652,320
Unassigned Ending Balance $ 1 $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐

115