Page 135 - 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
# Peak Payment dept 16 2% (409,500) (409,500) (456,879) (466,017) (475,337) (484,844) (494,541)
# TRA‐Wastewater Treatment dept 16 2% (479,303) (479,303) (479,303) (486,493) (493,790) (501,197) (508,715)
# Southlake‐Wastewater Treatment dept 16 2% (1,302,497) (1,302,497) (1,302,497) (1,322,034) (1,341,865) (1,361,993) (1,382,423)
# Testing‐Water/Bacteria/Rgltry dept 16 2% (30,000) (30,000) (30,000) (30,450) (30,907) (31,370) (31,841)
# Utility Billing dept 16 2% (27,321) (27,321) (27,321) (27,731) (28,147) (28,569) (28,998)
# Line Location dept 16 2% (5,660) (5,660) (5,660) (5,745) (5,831) (5,919) (6,007)
# Application Software Maint. dept 16 2% $ (10,750) $ (10,750) $ (11,985) $ (12,165) $ (12,347) $ (12,532) $ (12,720)
# Keller Waste Water dept 16 2% (1,300) (1,300) (1,300) (1,320) (1,339) (1,359) (1,380)
# Insurance General Liability dept 16 2% (980) (835) (835) (848) (860) (873) (886)
# Mobile Phone dept 16 2% (1,000) (1,000) (1,000) (1,015) (1,030) (1,046) (1,061)
# Misc Rental/Lease dept 16 2% (500) (500) (1,500) (1,523) (1,545) (1,569) (1,592)
# Printing dept 16 2% (1,130) (1,130) (1,130) (1,147) (1,164) (1,182) (1,199)
# Courier Service dept 16 2% (200) (200) (200) (203) (206) (209) (212)
# Total Services (3,306,555) (3,307,793) (3,466,618) (3,526,106) (3,586,636) (3,648,227) (3,710,898)
#
# Computer Eqpmt/Software dept 16 2% (210) (210) (210) (213) (216) (220) (223)
# Safety Supplies dept 16 2% (100) (100) (100) (102) (103) (105) (106)
# Misc Hand Tools dept 16 2% (1,855) (1,855) (1,855) (1,883) (1,911) (1,940) (1,969)
# Chemical Supplies dept 16 2% (350) (350) (350) (355) (361) (366) (371)
# Office Supplies dept 16 2% (538) (538) (538) (546) (554) (563) (571)
# Postage & Shipping dept 16 2% (400) (400) (400) (406) (412) (418) (425)
# Vehicle Fuel dept 16 2% (3,000) (3,000) (3,000) (3,045) (3,091) (3,137) (3,184)
# Uniforms dept 16 2% (587) (587) (587) (596) (605) (614) (623)
# Total Supplies (7,040) (7,040) (7,040) (7,146) (7,253) (7,362) (7,472)
#
# Travel Airfare dept 16 2% (800) (800) (800) (812) (824) (837) (849)
# Travel Car Rental/Parking dept 16 2% (100) (100) (100) (102) (103) (105) (106)
# Travel Lodging dept 16 2% (1,560) (1,560) (1,560) (1,583) (1,607) (1,631) (1,656)
# Travel Meals dept 16 2% (77) (77) (77) (78) (79) (81) (82)
# Travel Mileage dept 16 2% (58) (58) (58) (59) (60) (61) (62)
# Training/Seminars/Meetings dept 16 2% (3,000) (3,000) (3,000) (3,045) (3,091) (3,137) (3,184)
# Dues & Subscriptions dept 16 2% (1,500) (1,500) (1,500) (1,523) (1,545) (1,569) (1,592)
# Licenses/Registrations dept 16 2% (700) (700) (700) (711) (721) (732) (743)
# Total Travel & Training (7,795) (7,795) (7,795) (7,912) (8,031) (8,151) (8,273)
#
# Transfer Out ‐ UMR Fund 510 dept 99 linked to UMR (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000)
# Transfer Out ‐ VMR Fund 505 dept 99 linked to VMR (10,000) (10,000) (10,000) (5,000) (5,000) (5,000) (5,000)
# Transfer Out ‐ GF 100 Impact Fees dept 99 GF linked to this (66,539) (66,539) (67,225) (6,181) (6,305) (6,431) (6,560)
# Total Transfers Out (81,539) (81,539) (82,225) (16,181) (16,305) (16,431) (16,560)
#
# Texas Water Development Board ‐ (1,996,332) ‐ ‐ ‐ ‐ ‐
# Total Capital Projects ‐ (1,996,332) ‐ ‐ ‐ ‐ ‐
# TOTAL EXPENSES (6,347,244) (6,630,617) (4,875,165) (4,762,730) (4,836,108) (4,909,096) (4,983,701)

# NET CHANGE TO FUND BALANCE 1,175,257 346,684 774,863 1,021,737 1,041,529 1,063,884 1,102,340
# Beginning Fund Balance 197,156 (424,904) 1,873,862 2,648,725 3,670,462 4,711,991 5,775,876

# Prior Period Adjustment (Texas Water Development Board) ‐ 1,952,082 ‐ ‐ ‐ ‐ ‐
Restated Beginning Fund Balance 197,156 1,527,178 1,873,862 2,648,725 3,670,462 4,711,991 5,775,876
# Ending Fund Balance 1,372,413 1,873,862 2,648,725 3,670,462 4,711,991 5,775,876 6,878,216
# Restricted/Committed/Assigned Hillwood 888,000 888,000 888,000 750,000 750,000 750,000 750,000
# Restricted/Committed/Assigned Deposits 186,130 186,130 186,130 186,130 186,130 186,130 186,130
# Restricted/Committed/Assigned Other ‐ ‐ ‐ ‐ ‐ ‐ ‐
# Unassigned Ending Balance 298,283 $ 799,732 $ 1,574,595 $ 2,734,332 $ 3,775,861 $ 4,839,746 $ 5,942,086
# Operating Expenses 6,347,244 6,630,617 4,875,165 4,762,730 4,836,108 4,909,096 4,983,701
# Operating Cost Per Day 17,390 18,166 13,357 13,049 13,250 13,450 13,654
# OPERATING DAYS 79 103 198 281 356 429 504
#
#

123