Page 134 - 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
#
# Bond Proceeds ‐ Tx Water Development Board 0% 2,600,000 2,100,000 ‐ ‐ ‐ ‐ ‐
# Other Resources 2,600,000 2,100,000 ‐ ‐ ‐ ‐ ‐
#
# TOTAL REVENUES 7,522,501 6,977,301 5,650,028 5,784,467 5,877,637 5,972,981 6,086,041
# Operating Xfr Out for PR Costs 1% $ (559,024) $ (547,472) $ (522,424) $ (527,648) $ (532,925) $ (538,254) $ (543,637)
# Compensated Absences 1% ‐ (2,785) (2,785) (2,813) (2,841) (2,869) (2,898)
# Compensated Absences 1% ‐ (4,645) (4,645) (4,691) (4,738) (4,786) (4,834)
# Compensated Absences 1% ‐ (1,640) (1,640) (1,656) (1,673) (1,690) (1,707)
# Compensated Absences 1% ‐ (125) (125) (126) (128) (129) (130)
# Total Payroll and Related (559,024) (556,667) (531,619) (536,935) (542,305) (547,728) (553,205)
#
# Computer Hardware/Software 2% (1,000) (1,000) (1,000) (1,015) (1,030) (1,046) (1,061)
# Mechanical Equipment 2% (1,000) (1,000) (1,000) (1,015) (1,030) (1,046) (1,061)
# Water Meters /Equipment 2% (20,275) (20,275) (20,275) (20,579) (20,888) (21,201) (21,519)
# Water Taps 2% (8,780) (8,780) (8,780) (8,912) (9,045) (9,181) (9,319)
# Total Capital Outlay (31,055) (31,055) (31,055) (31,521) (31,994) (32,474) (32,961)
#
# Fort Worth Waterline Payment 0% (1,711,840) ‐ ‐ ‐ ‐ ‐ ‐
# Keller OH Storage ‐ Principal ends 2020 tied to schedule (113,756) (113,756) (120,165) ‐ ‐ ‐ ‐
# Keller OH Storage ‐ Interest ends 2020 tied to schedule (7,393) (7,393) (2,523) ‐ ‐ ‐ ‐
# Service Area ‐ Hillwood tied to revenues (48,240) (48,240) (48,240) (48,960) (49,939) (50,938) (51,957)
# Service Area ‐ Town tied to revenues (43,215) (43,215) (43,215) (43,860) (44,737) (45,632) (46,545)
# TXWDB FW Phase 2 Waterline ‐ Principal tied to schedule (5,000) (5,000) (95,000) (100,000) (100,000) (100,000) (100,000)
# TXWDB FW Phase 2 Waterline ‐ Interest tied to schedule (31,056) (31,056) (43,120) (41,984) (40,744) (39,404) (37,949)
# GS Tank 2013 CO ‐ Principal tied to schedule (22,550) (22,550) (23,650) (23,650) (24,750) (25,300) (26,400)
# GS Tank 2013 CO ‐ Interest tied to schedule (32,576) (32,576) (32,114) (31,582) (30,977) (30,288) (29,512)
# Total Debt (2,015,626) (303,786) (408,027) (290,035) (291,147) (291,561) (292,362)
#
#
# Office Rent dept 10 from schedule (70,295) (70,295) (72,472) (74,668) (76,242) (76,936) (77,653)
# Electric ‐ Town Hall dept 10 0% (7,500) (7,500) (7,500) (7,500) (7,500) (7,500) (7,500)
# Electric ‐ Lift Station dept 16 2% (2,680) (2,680) (2,680) (2,720) (2,761) (2,802) (2,844)
# Electric ‐ Pump Station dept 16 2% (1,291) (1,291) (1,291) (1,310) (1,330) (1,350) (1,370)
# Electric ‐ Pump Station dept 16 2% (70,277) (70,277) (70,277) (71,331) (72,401) (73,487) (74,589)
# Internet Service dept 10 2% (2,327) (2,327) (2,327) (2,362) (2,397) (2,433) (2,470)
# Telephone ‐ Town Hall dept 10 2% (724) (724) (724) (735) (746) (757) (768)
# Telephone dept 16 2% (1,000) (1,000) (1,000) (1,015) (1,030) (1,046) (1,061)
# Water ‐ Other dept 16 2% (850) (850) (850) (863) (876) (889) (902)
# Water ‐ Pump Station dept 16 2% (20,600) (20,600) (20,600) (20,909) (21,223) (21,541) (21,864)
# Total Rent & Utilities (177,544) (177,544) (179,721) (183,413) (186,506) (188,741) (191,023)
#
# WaterTower Landscape R&M dept 16 2% (6,000) (6,000) (6,000) (6,090) (6,181) (6,274) (6,368)
# Water Main R&M dept 16 2% (35,045) (35,045) (35,045) (35,571) (36,104) (36,646) (37,195)
# Water Tower R&M dept 16 2% (1,000) (1,000) (1,000) (1,015) (1,030) (1,046) (1,061)
# Sewer Main R&M dept 16 2% (24,973) (24,973) (24,973) (25,348) (25,728) (26,114) (26,505)
# Pump Station Landscape R&M dept 16 2% (12,500) (12,500) (12,500) (12,688) (12,878) (13,071) (13,267)
# Lift Station R&M dept 16 2% (6,000) (6,000) (6,000) (6,090) (6,181) (6,274) (6,368)
# Instrument R&M dept 16 2% (9,473) (9,473) (9,473) (9,615) (9,759) (9,906) (10,054)
# Ground Storage Tank R&M dept 16 2% (2,300) (2,300) (2,300) (2,335) (2,370) (2,405) (2,441)
# Generator R&M dept 16 2% (6,815) (6,815) (6,815) (6,917) (7,021) (7,126) (7,233)
# Pump Station R&M dept 16 2% (12,500) (12,500) (12,500) (12,688) (12,878) (13,071) (13,267)
# Duct Bank R&M dept 16 2% (6,940) (6,940) (6,940) (7,044) (7,150) (7,257) (7,366)
# Meter Repair & Replacement dept 16 2% (35,793) (35,793) (35,793) (36,330) (36,875) (37,428) (37,989)
# Water/Sewer R&M dept 16 2% (726) (726) (726) (737) (748) (759) (771)
# Vehicle R&M dept 16 2% (1,000) (1,000) (1,000) (1,015) (1,030) (1,046) (1,061)
# Total Repair and Maintenance (161,065) (161,065) (161,065) (163,481) (165,933) (168,422) (170,949)
#
# Insurance Automobile dept 10 2% (661) (1,479) (1,479) (1,501) (1,524) (1,547) (1,570)
# Insurance Property dept 10 2% (6,975) (7,865) (7,865) (7,983) (8,103) (8,224) (8,348)
# Bank Service Charges dept 10 2% (7,547) (7,547) (7,547) (7,660) (7,775) (7,892) (8,010)
# Engineering dept 16 2% (4,540) (4,540) (4,540) (4,608) (4,677) (4,747) (4,819)
# Water Utility Engineering dept 16 2% (37,555) (37,555) (37,555) (38,118) (38,690) (39,270) (39,860)
# Misc. Engineering dept 16 2% (4,126) (4,126) (4,126) (4,188) (4,251) (4,314) (4,379)
# Consultant Fees dept 16 2% (5,138) (5,138) (5,138) (5,215) (5,293) (5,373) (5,453)
# Auditor dept 16 2% (7,235) (6,910) (8,000) (8,120) (8,242) (8,365) (8,491)
# Attorney ‐ Boyle & Lowry dept 16 2% (9,421) (9,421) (9,421) (9,562) (9,706) (9,851) (9,999)
# Attorney ‐ Lloyd Gosselink dept 16 2% (10,256) (10,256) (10,256) (10,410) (10,566) (10,724) (10,885)
# Contract Services dept 16 2% (7,860) (7,860) (7,860) (7,978) (8,098) (8,219) (8,342)
# Water Purchases dept 16 2% (934,500) (934,500) (1,042,621) (1,063,473) (1,084,743) (1,106,438) (1,128,567)
# Water Service Charge dept 16 0% (600) (600) (600) (600) (600) (600) (600)

122