Page 137 - 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
# WA Playground Equipment tied to vision (5,000) ‐ (5,000) ‐ (5,000) ‐ (40,000)
# WA‐Plumbing Repair/Replacement tied to vision (9,000) (9,000) (8,000) (5,000) (5,000) (5,000) (5,000)
# WA‐Carpet/VCT Flooring tied to vision (35,000) (35,000) (30,000) (15,000) (15,000) (15,000) (15,000)
# WA‐Envrnmt Bldg UG light/water tied to vision (10,000) (10,000) (8,000) (5,000) (5,000) (5,000) (5,000)
# WA‐Refurbish Classrooms tied to vision (30,000) (30,000) (30,000) (25,000) (25,000) (25,000) (25,000)
# WA‐Interior Building R&M tied to vision (15,000) (15,000) (10,000) (15,000) (15,000) (15,000) (15,000)
# WA‐Exterior Paint & Wood R&M tied to vision (4,500) (4,500) (12,000) (8,000) (8,000) (8,000) (8,000)
# WA‐Roof Repairs tied to vision (47,550) (47,550) (60,000) (30,000) (25,000) (25,000) (25,000)
# WA Facilities Allotment tied to vision ‐ (90,194) ‐ ‐ ‐ ‐ ‐
# WA‐Mechanical Equipment tied to vision (25,000) (25,000) ‐ ‐ ‐ ‐ ‐
# WA‐Furniture/Interior Bldg tied to vision (15,000) (7,500) (8,000) (10,000) (10,000) (10,000) (10,000)
# Dept 17 ‐ Westlake Academy Facilities (299,775) (377,469) (298,500) (230,000) (228,000) (208,000) (268,000)
#
# Trail Repairs and Maintenance tied to vision (10,000) (10,000) (30,000) (10,000) (30,000) (10,000) (10,000)
# Park Repairs and Maintenance tied to vision (10,000) (10,000) (33,029) (15,000) (33,029) (10,000) (10,000)
# Dept 19 ‐ Town Parks (20,000) (20,000) (63,029) (25,000) (63,029) (20,000) (20,000)
#
# Servers & Network Storage tied to vision (40,000) (40,000) (40,000) (30,000) (30,000) (30,000) (30,000)
# Network Printers/Peripheal Dev tied to vision (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000)
# Network Equipment tied to vision (115,000) (115,000) (25,000) (25,000) (25,000) (25,000) (150,000)
# Server Replacements tied to vision (20,000) (20,000) (20,000) (125,000) (20,000) (20,000) (20,000)
# Phone System/Peripheal Devices tied to vision (65,000) (65,000) (100,000) (15,000) (15,000) (15,000) (65,000)
# Dept 20 ‐ Town IT Dept (245,000) (245,000) (190,000) (200,000) (95,000) (95,000) (270,000)
#
# Town‐Irrigation R&M tied to vision (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000)
# Town Open Space Improvements tied to vision ‐ ‐ (8,000) (20,000) (1,000) (8,000) (10,000)
# Town‐15 Ton Split HVAC System tied to vision ‐ ‐ ‐ (30,000) (5,000) (3,000) (3,000)
# Town‐2 Ton Roof Top Units tied to vision ‐ ‐ (3,000) (5,000) (5,000) (3,000) (3,000)
# Town‐AC ton/7.5 ton server roo tied to vision ‐ ‐ (3,000) (3,000) (8,000) ‐ (3,000)
# Town‐HVAC System Replacement tied to vision (5,000) (5,000) ‐ (5,000) (5,000) (5,000) (5,000)
# Town‐Contract Landscaping tied to vision ‐ ‐ ‐ (5,000) (8,000) (3,000) (3,000)
# Town‐Security System tied to vision ‐ ‐ (3,000) (5,000) (5,000) (10,000) (5,000)
# Town‐Security Cameras tied to vision ‐ ‐ (3,000) (5,000) (12,000) (5,000) (5,000)
# Town‐Safety Doors tied to vision ‐ ‐ (8,000) (8,000) (10,000) (8,000) (10,000)
# Town‐Ground R&M tied to vision ‐ ‐ (4,000) (4,000) (10,000) (5,000) (6,000)
# Town‐Heater Boiler tied to vision (3,000) (3,000) ‐ (3,000) (3,000) (3,000) (3,000)
# Town‐Painting/Cloth Wall R&M tied to vision ‐ ‐ (4,000) (4,000) (10,000) (5,000) (6,000)
# Town‐Signs and Signals tied to vision ‐ ‐ (4,000) (4,000) (4,000) (6,000) (6,000)
# Town‐Environmental Improvement tied to vision ‐ ‐ ‐ (4,000) ‐ (5,000) ‐
# Town‐Parking Lot tied to vision (4,000) (4,000) (4,000) (4,000) (4,000) (4,000) (4,000)
# Town‐Plumbing Repair/Replace tied to vision ‐ ‐ (1,000) (2,000) (2,000) (2,000) (2,000)
# Town‐Carpet/Flooring R&M tied to vision ‐ ‐ ‐ ‐ ‐ (5,000) ‐
# Town‐Env Bldg UG light/water tied to vision (10,000) (10,000) (1,000) (10,000) (10,000) (10,000) (10,000)
# Town‐Interior Building R&M tied to vision ‐ ‐ (5,000) (5,000) (10,000) (5,000) (5,000)
# Town‐Bldg Exterior Paint/R&M tied to vision ‐ ‐ ‐ (5,000) (5,000) (10,000) (5,000)
# Town‐Roof Repairs tied to vision ‐ ‐ ‐ (6,000) (6,000) (6,000) (6,000)
# Town‐Furniture/Interior Bldg tied to vision (2,700) (10,200) (10,200) (3,000) (5,000) (3,000) (5,000)
# Dept 26 ‐ Town Facilities (Fire Station) (29,700) (37,200) (66,200) (145,000) (133,000) (119,000) (110,000)
#
# TOTAL EXPENDITURES (594,475) (679,669) (617,729) (600,000) (519,029) (442,000) (668,000)
#
#
# NET CHANGE TO FUND BALANCE 414,614 888,273 (379,120) (90,576) (109,605) (32,576) (258,576)
# Beginning Fund Balance 122,794 157,098 1,045,371 666,251 575,675 466,070 433,494
# Ending Fund Balance 537,408 1,045,371 666,251 575,675 466,070 433,494 174,918
# Restricted/Committed/Assigned 537,408 1,045,371 666,251 575,675 466,070 433,494 174,918
# Unassigned Ending Balance $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐
#
#
#
#

125