Page 132 - 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
# Parks & Recreations dept 19 2% (12,343) (12,343) (12,843) (13,100) (13,362) (13,629) (13,902)
# Information Technology dept 20 2% (7,630) (7,630) (7,630) (7,783) (7,938) (8,097) (8,259)
# Human Resources dept 21 2% (3,770) (3,270) (3,270) (3,335) (3,402) (3,470) (3,540)
# Communications dept 22 2% (10,199) (12,519) (12,519) (12,769) (13,025) (13,285) (13,551)
# Facilities Maintenance Town dept 26 2% (17,700) (13,725) ‐ ‐ ‐ ‐ ‐
# Total Supply Expenditures (246,473) (250,434) (248,054) (253,015) (258,075) (263,236) (268,501)
#
# General Services dept 10 2% (60,303) (60,303) (60,303) (61,509) (62,739) (63,994) (65,274)
# Administrative dept 11 2% (32,128) (32,128) (32,128) (32,771) (33,426) (34,094) (34,776)
# Planning & Development dept 12 2% (7,921) (11,310) (11,310) (11,536) (11,767) (12,002) (12,242)
# Town Secretary dept 13 2% (4,340) (4,340) (4,340) (4,427) (4,515) (4,606) (4,698)
# Fire Department dept 14 2% (43,740) (48,995) (54,295) (55,381) (56,489) (57,618) (58,771)
# Municipal Court dept 15 2% (5,225) (7,407) (9,549) (9,740) (9,935) (10,134) (10,336)
# Public Works dept 16 2% (2,481) (2,481) (2,481) (2,531) (2,581) (2,633) (2,686)
# Facilities Maintenance WA dept 17 2% (3,283) (3,783) (10,222) (10,426) (10,634) (10,847) (11,064)
# Finance Department dept 18 2% (10,935) (10,935) (10,935) (11,154) (11,377) (11,604) (11,836)
# Parks & Recreations dept 19 2% (1,545) (1,545) (5,000) (5,100) (5,202) (5,306) (5,412)
# Information Technology dept 20 2% (9,618) (9,618) (9,618) (9,810) (10,007) (10,207) (10,411)
# Human Resources dept 21 2% (17,336) (17,250) (17,250) (17,595) (17,947) (18,306) (18,672)
# Communications dept 22 2% (7,039) (7,759) (7,759) (7,914) (8,072) (8,234) (8,399)
# Facilities Maintenance Town dept 26 2% (3,670) (3,670) ‐ ‐ ‐ ‐ ‐
# Total Travel & Training (209,564) (221,524) (235,190) (239,893) (244,691) (249,585) (254,577)
#
# Capital Operating Impact ‐ Roads dept 16 hard coded ‐ ‐ ‐ (12,200) (15,060) (17,431) (17,813)
# Capital Operating Impact ‐ Facilities dept 17 hard coded ‐ ‐ ‐ (5,060) (5,212) (5,368) (5,529)
# Capital Operating Impact ‐ Parks/Rec dept 19 hard coded ‐ ‐ ‐ (2,000) (2,060) (2,122) (2,185)
# Total Capital Operating Impact ‐ ‐ ‐ (19,260) (22,332) (24,921) (25,527)
#
# Transfer Out ‐ DS 300 hard coded inked to DSF (1,005,901) (455,901) (175,989) (174,041) (140,704) (95,426) (59,582)
# Total Operating Transfers Out (1,005,901) (455,901) (175,989) (174,041) (140,704) (95,426) (59,582)
#
# TOTAL OPERATING EXPENDITURES (payroll/operations/maintenance) (9,578,926) (9,237,500) (9,880,629) (10,121,803) (10,366,385) (10,604,279) (10,860,042)
#
# Transfer Out ‐ GMR Fund 600 linked to GMR (1,000,799) (1,463,799) (229,185) (500,000) (400,000) (400,000) (400,000)
# Transfer Out ‐ GF VMR Fund 605 linked to VMR (460,266) (678,266) (229,185) (250,000) (250,000) (250,000) (250,000)
# Transfer Out ‐ UF VMR Fund 505 linked to VMR ‐ ‐ (5,000) (5,000) (5,000) (5,000) (5,000)
# Transfer Out ‐ CP Fund 410 linked to CIP (1,025,000) (1,025,000) (891,360) (343,545) (343,545) (297,105) (297,105)
# Total Non‐Operating Transfers Out (2,486,065) (3,167,065) (1,354,730) (1,098,545) (998,545) (952,105) (952,105)
# TOTAL NON‐OPERATING EXPENDITURES (2,486,065) (3,167,065) (1,354,730) (1,098,545) (998,545) (952,105) (952,105)
#
# GRAND TOTAL ALL EXPENDITURES (12,064,992) (12,404,565) (11,235,359) (11,220,348) (11,364,930) (11,556,384) (11,812,147)
#
#
# NET CHANGE TO FUND BALANCE 7,498,617 2,353,447 (31,092) 361,894 258,276 244,531 237,395
# Beginning Fund Balance 9,216,610 9,761,849 12,115,296 12,084,204 12,446,098 12,704,374 12,948,905
# Ending Fund Balance 16,715,227 12,115,296 12,084,204 12,446,098 12,704,374 12,948,905 13,186,301
# Restricted/Committed/Assigned 304,504 290,880 298,560 298,560 298,560 298,560 298,560
# Unassigned Ending Balance $ 16,410,724 $ 11,824,416 $ 11,785,644 $ 12,147,538 $ 12,405,814 $ 12,650,345 $ 12,887,741
# Operating Expenditures 9,578,926 9,237,500 9,880,629 10,121,803 10,366,385 10,604,279 10,860,042
# Operating Cost per Day 26,146 25,308 27,070 27,731 28,401 29,053 29,754
# OPERATING DAYS 350 467 435 438 437 435 433
#
#
#
#

120