Page 133 - 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
#
# ENTERPRISE FUNDS
#
#
#
#
# FUND 255 ‐ CEMETERY FUND
#
#
# Section Sales 0% $ 13,700 $ 16,675 $ 13,700 $ 13,700 $ 13,700 $ 13,700 $ 13,700
# Perpetual Care ‐ Section 15% 0% 150 150 150 150 150 150 150
# Perpetual Care‐interment 100 % 0% 50 50 50 50 50 50 50
# Marker Sales 0% 250 250 250 250 250 250 250
# Contractor Fee 0% 350 350 350 350 350 350 350
# Misc Revenue 0% 1,275 1,275 1,275 1,275 1,275 1,275 1,275
# Interest Income 0% 2,465 5,600 5,600 5,600 5,600 5,600 5,600
# TOTAL REVENUES 18,240 24,350 21,375 21,375 21,375 21,375 21,375
#
# Engineering 0% (6,453) (6,453) (6,453) (6,453) (6,453) (6,453) (6,453)
# Contract Services 0% (370) (370) (370) (370) (370) (370) (370)
# Irrigation R&M 0% ‐ ‐ (2,500) (2,500) (2,500) (2,500) (2,500)
# Contract Landscaping 0% (6,375) (6,375) (6,375) (6,375) (6,375) (6,375) (6,375)
# ROW Irrigation 0% ‐ (1,625) (1,625) (1,625) (1,625) (1,625) (1,625)
# Grounds R&M 0% (2,000) (2,000) (2,000) (2,000) (2,000) (2,000) (2,000)
# Training/Meetings/Seminars 0% ‐ ‐ (2,500) (2,500) (2,500) (2,500) (2,500)
# Dues & Memberships 0% (125) (125) (125) (125) (125) (125) (125)
# Cost of Sales ‐ Cemetery Lots 0% (1,441) (1,441) (1,441) (1,441) (1,441) (1,441) (1,441)
# TOTAL EXPENDITURES (16,764) (18,389) (23,389) (23,389) (23,389) (23,389) (23,389)
#
# NET CHANGE TO FUND BALANCE 1,476 5,961 (2,014) (2,014) (2,014) (2,014) (2,014)
# Beginning Fund Balance 235,563 235,563 241,524 239,510 237,496 235,482 233,468
# Ending Fund Balance 237,039 241,524 239,510 237,496 235,482 233,468 231,454
# Restricted/Committed/Assigned 237,039 241,524 239,510 237,496 235,482 233,468 231,454
# Unassigned Ending Balance $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐
# Operating Expenses 16,764 18,389 23,389 23,389 23,389 23,389 23,389
# Operating Cost Per Day 46 50 64 64 64 64 64
# OPERATING DAYS 5,129 4,676 3,769 3,738 3,706 3,675 3,643
#
#
#
# FUND 500 ‐ UTILITY FUND
#
#
# Water Revenue 2% $ 3,211,156 $ 3,211,156 $ 3,720,177 $ 3,794,581 $ 3,870,472 $ 3,947,882 $ 4,026,839
# DS ‐ Hillwood Service Area 2% 48,000 48,000 48,000 48,960 49,939 50,938 51,957
# DS ‐ Town Service Area Accts 2% 43,000 43,000 43,000 43,860 44,737 45,632 46,545
# Waste Management 2% 6,129 6,129 6,190 6,314 6,440 6,569 6,700
# Sewer Revenue ‐ Westlake 2% 1,137,544 1,137,544 1,378,927 1,406,506 1,434,636 1,463,328 1,492,595
# Sewer Revenue ‐ Keller 2% 1,280 1,280 1,293 1,319 1,345 1,372 1,400
# Water Tap Fees 2% 34,026 34,026 34,366 35,053 35,754 36,469 37,199
# Sewer Tap Fees 2% 17,251 17,251 17,424 17,772 18,128 18,490 18,860
# Fort Worth Impact fees 0% 66,539 66,539 67,225 67,225 67,225 67,225 67,225
# Meter Repair & Replacement 2% 6,000 6,000 6,060 6,181 6,305 6,431 6,560
# Sub‐Total Charge For Services 4,570,925 4,570,925 5,322,662 5,427,771 5,534,982 5,644,337 5,755,879
#
# Duct Bank Leases 40,391 40,391 40,391 40,391 40,391 40,391 40,391
# TRA Wastewater Settle‐Up 69,750 69,750 69,750 69,750 69,750 69,750 69,750
# Duct Bank Permit Fees linked to PD schedule 164,300 119,100 145,700 173,600 158,100 142,600 142,600
# Sub‐Total Permits and Fees 274,441 229,241 255,841 283,741 268,241 252,741 252,741
#
# Interest Income 2% 55,300 55,300 55,300 56,406 57,534 58,685 59,858
# Total Interest 55,300 55,300 55,300 56,406 57,534 58,685 59,858
#
# Cross Connection Control Prog. 2% 3,510 3,510 ‐ ‐ ‐ ‐ ‐
# Insurance Refund/Equity Return 2% 750 750 750 765 780 796 812
# Misc Revenue 2% 8,000 8,000 8,000 8,160 8,323 8,490 8,659
# Administrative Fee 2% 7,475 7,475 7,475 7,625 7,777 7,933 8,091
# Misc Reimbursements 2% 2,100 2,100 ‐ ‐ ‐ ‐ ‐
# Total Misc Income 21,835 21,835 16,225 16,550 16,880 17,218 17,562

121