Page 143 - 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
#
# FUND 301 ‐ DEBT SERVICE (property tax supported)
#
#
# Property Tax $ 256,878 $ 299,430 $ 666,221 $ 669,523 $ 668,654 $ 672,827 $ 667,098
# TOTAL REVENUES 256,878 299,430 666,221 669,523 668,654 672,827 667,098
#
# Bank Charge ‐ 2011 CO Issue 2011 CO (440) (440) (440) (440) (440) (440) (440)
# Principal ‐ 2011 CO Road Improvements (83,000) (83,000) (87,000) (91,000) (96,000) (101,000) (106,000)
# Interest ‐ 2011 CO Program 011 (34,356) (34,356) (32,316) (30,180) (27,936) (25,572) (23,088)
# TOTAL 2011 CO (117,796) (117,796) (119,756) (121,620) (124,376) (127,012) (129,528)
#
# Bank Charge ‐ Issue 2013 CO SPLIT Academy Expansion ‐ ‐ ‐ ‐ ‐ ‐ ‐
WITH
# Principal ‐ Issue 2013 CO Fund Issue‐2013‐CO ‐ ‐ (158,150) (119,475) (124,370) (129,944) (136,219)
# Interest ‐ Issue 2013 CO 300 Program 12 ‐ ‐ (259,830) (255,525) (250,630) (245,056) (238,781)
# TOTAL 2013 CO ‐ ‐ (417,980) (375,000) (375,000) (375,000) (375,000)
#
# Bank Charge ‐ 2013 GORB Issue 2013 GORB (440) (440) (440) (440) (440) (440) (440)
# Principal ‐ 2013 GORB Refunding of 2018 (A&S) (135,000) (135,000) (140,000) (145,000) (145,000) (150,000) (145,000)
# Interest ‐ 2013 GORB Program 013 (34,463) (34,463) (31,025) (27,463) (23,838) (20,375) (17,130)
# TOTAL 2013 GORB (169,903) (169,903) (171,465) (172,903) (169,278) (170,815) (162,570)
#
# TOTAL EXPENDITURES (287,699) (287,699) (709,201) (669,523) (668,654) (672,827) (667,098)
#
# 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 $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐
#
#
#

131