Page 144 - 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
#
# CAPITAL PROJECTS FUNDS
#
#
#
#
# FUND 405 ‐ FIRE STATION PROJECT
#
#
# Cash (Fund Balance) hard coded $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐
# TOTAL REVENUES ‐ ‐ ‐ ‐ ‐ ‐ ‐
#
# Engineering Fees tied to vision (4,100) (4,100) ‐ ‐ ‐ ‐ ‐
# Design Fees tied to vision (61,474) (61,474) ‐ ‐ ‐ ‐ ‐
# Contingency tied to vision (107,700) (107,700) ‐ ‐ ‐ ‐ ‐
# Advertising tied to vision (2,500) (2,500) ‐ ‐ ‐ ‐ ‐
# Printing tied to vision (1,000) (1,000) ‐ ‐ ‐ ‐ ‐
# Security Service tied to vision (150,500) (150,500) ‐ ‐ ‐ ‐ ‐
# Misc. Expense tied to vision (258,075) (258,075) ‐ ‐ ‐ ‐ ‐
# Construction Expense tied to vision (1,739,281) (1,739,281) ‐ ‐ ‐ ‐ ‐
# Furniture & Fixtures tied to vision (75,000) (75,000) ‐ ‐ ‐ ‐ ‐
# TOTAL EXPENDITURES (2,399,630) (2,399,630) ‐ ‐ ‐ ‐ ‐
#
# NET CHANGE TO FUND BALANCE (2,399,630) (2,399,630) ‐ ‐ ‐ ‐ ‐
# Beginning Fund Balance 3,829,956 3,616,683 1,217,053 1,217,053 1,217,053 1,217,053 1,217,053
# Ending Fund Balance 1,430,326 1,217,053 1,217,053 1,217,053 1,217,053 1,217,053 1,217,053
# Restricted Funds 1,430,326 1,217,053 1,217,053 1,217,053 1,217,053 1,217,053 1,217,053
# Unassigned Ending Balance $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐
#
#

#
# FUND 412 ‐ ACADEMY EXPANSION FUND
#
#
# Interest Earned tied to vision $ 29,180 $ 151,021 $ 151,021 $ 27,400 $ 27,400 $ 27,400 $ 27,400
# Contributions tied to vision ‐ 1,000,000 ‐ ‐ ‐ ‐ ‐
# Transfer in from ED 200 tied to bldg permits 164,300 164,300 280,000 290,000 100,000 100,000 100,000
# TOTAL REVENUES 193,480 1,315,321 431,021 317,400 127,400 127,400 127,400
#
# Consultant Fees ‐ Master Plan tied to vision (85,000) (85,000) ‐ ‐ ‐ ‐ ‐
# TOTAL EXPENDITURES (85,000) (85,000) ‐ ‐ ‐ ‐ ‐
#
# NET CHANGE TO FUND BALANCE 108,480 1,230,321 431,021 317,400 127,400 127,400 127,400
# Beginning Fund Balance 1,782,565 1,651,843 2,882,164 3,313,185 3,630,585 3,757,985 3,885,385
# Ending Fund Balance 1,891,045 2,882,164 3,313,185 3,630,585 3,757,985 3,885,385 4,012,785
# Restricted Funds 1,891,045 2,882,164 3,313,185 3,630,585 3,757,985 3,885,385 4,012,785
# Unassigned Ending Balance $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐

#
# FUND 410 ‐ CAPITAL PROJECT FUND
#
#
# Transfer in from GF $ 1,025,000 $ 1,025,000 $ 891,360 $ 343,545 $ 343,545 $ 297,105 $ 297,105
# Interest Income 38,000 48,505 48,505 38,000 38,000 38,000 38,000
# Bond Revenue 3,387,134 ‐ ‐ 1,672,806 ‐ ‐ ‐
# TOTAL REVENUES 4,450,134 1,073,505 939,865 2,054,351 381,545 335,105 335,105
#
# FM 1938 Town Improvements (220,000) (112,300) ‐ ‐ ‐ ‐ ‐
# Roanoke Road Recon/Drain South ‐ (3,625) (540,000) ‐ ‐ ‐ ‐
# Sam School Road Recon & Drainage (281,960) (3,215) ‐ ‐ (55,000) ‐ ‐
# Ottinger Road Reconstruction & Drainage ‐ ‐ ‐ (1,063,800) ‐ ‐ ‐
# Pearson Lane Recon & Drainage (404,125) (22,305) (290,016) ‐ ‐ ‐ ‐
# Dove Road/FM1938 Signalization ‐ (159,360) ‐ ‐ ‐ ‐ ‐
# Solana/FM 1938 Signalization ‐ (8,375) ‐ ‐ ‐ ‐ ‐
# Flashing Crosswalk Lights (80,000) ‐ (53,850) (51,840) ‐ ‐ ‐
# Solana Pavement Repairs (90,000) ‐ (90,000) ‐ ‐ ‐ ‐
# Wyck Hill Pavement Resurface (54,450) ‐ (58,806) ‐ ‐ ‐ ‐

132