Page 136 - City of Westlake FY20 Budget

FIVE YEAR FINANCIAL FORECAST

ALL MUNICIPAL FUNDS

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
#
# INTERNAL SERVICE ‐ M&R FUNDS
#
#
#
#
# FUND 505 ‐ UF VEHICLE MAINTENANCE/REPLACEMENT FUND
#
#
# Interest Earned tied to vision $ 350 $ 1,940 $ 1,940 $ 350 $ 350 $ 350 $ 350
# Transfer in from GF tied to vision ‐ ‐ 5,000 5,000 5,000 5,000 5,000
# Transfer in from UF tied to vision 10,000 10,000 10,000 5,000 5,000 5,000 5,000
# TOTAL REVENUES 10,350 11,940 16,940 10,350 10,350 10,350 10,350
#
# Public Works Vehicle tied to vision ‐ ‐ (50,000) ‐ ‐ ‐ ‐
# TOTAL EXPENDITURES ‐ ‐ (50,000) ‐ ‐ ‐ ‐
#
# NET CHANGE TO FUND BALANCE 10,350 11,940 (33,060) 10,350 10,350 10,350 10,350
# Beginning Fund Balance 23,674 23,759 35,699 2,639 12,989 23,339 33,689
# Ending Fund Balance 34,024 35,699 2,639 12,989 23,339 33,689 44,039
# Restricted/Committed/Assigned 34,024 35,699 2,639 12,989 23,339 33,689 44,039
# Unassigned Ending Balance $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐
#
#
#
#
#
# FUND 510 ‐ UTILITY MAINTENANCE/REPLACEMENT FUND
#
#
# Interest Income vision $ 16,350 $ 31,895 $ 31,895 $ 14,500 $ 14,500 $ 14,500 $ 14,500
# Transfers In from UF 500 vision 5,000 5,000 5,000 5,000 5,000 5,000 5,000
# TOTAL REVENUES 21,350 36,895 36,895 19,500 19,500 19,500 19,500
#
# Sewer Easement Cleaning Machine vision (45,000) ‐ (67,000) ‐ ‐ ‐ ‐
# Repaint Ground Storage Tank vision (90,000) (276,200) ‐ ‐ ‐ ‐ ‐
# Lift Station Pump Repairs vision ‐ ‐ (25,000) ‐ ‐ ‐ ‐
# Pump Station Equipment vision (90,000) ‐ (90,000) ‐ ‐ ‐ ‐
# TOTAL EXPENDITURES (225,000) (276,200) (182,000) ‐ ‐ ‐ ‐
#
# NET CHANGE TO FUND BALANCE (203,650) (239,305) (145,105) 19,500 19,500 19,500 19,500
# Beginning Fund Balance 845,683 778,190 538,885 393,780 413,280 432,780 452,280
# Ending Fund Balance 642,033 538,885 393,780 413,280 432,780 452,280 471,780
# Restricted/Committed/Assigned 642,033 538,885 393,780 413,280 432,780 452,280 471,780
# Unassigned Ending Balance $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐
#
#
#
#
#
# FUND 600 ‐ GENERAL MAINTENANCE/REPLACEMENT FUND
#
#
# Firefighter Equipment Fees Dept 14 tied to vision $ 6,000 $ 6,000 $ 6,000 $ 6,000 $ 6,000 $ 6,000 $ 6,000
# Interest Income Dept 00 tied to vision 2,290 3,424 3,424 3,424 3,424 3,424 3,424
# Misc Revenue Dept 00 tied to vision ‐ 1,980 ‐ ‐ ‐ ‐ ‐
# Sale of Surplus Dept 00 tied to vision ‐ 2,545 ‐ ‐ ‐ ‐ ‐
# Transfer in from GF Dept 88 tied to vision 1,000,799 1,463,799 229,185 500,000 400,000 400,000 400,000
# WA Facilities Allotment 50% Dept 17 ‐ 90,194 ‐ ‐ ‐ ‐ ‐
# TOTAL REVENUES 1,009,089 1,567,942 238,609 509,424 409,424 409,424 409,424
#
# WA‐Irrigation System tied to vision (6,500) (6,500) (15,000) (5,000) (5,000) (5,000) (5,000)
# WA‐15 Ton Split HVAC System tied to vision (14,000) (14,000) (10,000) (25,000) (25,000) (25,000) (25,000)
# WA‐2 Ton Roof Top Units tied to vision (7,500) (7,500) (15,000) (10,000) (10,000) (10,000) (10,000)
# WA‐AC ton/7.5 ton server room tied to vision (6,500) (6,500) (1,500) (20,000) ‐ (5,000) (5,000)
# WA‐HVAC System Replacement tied to vision (7,500) (7,500) (8,000) (5,000) (5,000) (5,000) (5,000)
# WA‐Update Security System tied to vision (2,750) (2,750) (20,000) (10,000) (8,000) (8,000) (8,000)
# WA‐Update Security Cameras tied to vision (10,300) (10,300) (5,000) (12,000) (12,000) (12,000) (12,000)
# WA‐Heater Boilers tied to vision (9,675) (9,675) (3,000) (5,000) (25,000) (5,000) (25,000)
# WA‐Painting/Cloth Wall R&M tied to vision (6,500) (6,500) (10,000) (8,000) (8,000) (8,000) (8,000)
# WA‐Ext Envrnmt Imprvmts Irrig tied to vision (7,500) (7,500) (15,000) (12,000) (12,000) (12,000) (12,000)
# WA‐Parking Lot tied to vision (25,000) (25,000) (25,000) (5,000) (5,000) (5,000) (5,000)

124