Page 139 - 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
#
# SPECIAL REVENUE FUNDS
#
#
#
#
# FUND 220 ‐ VISITORS ASSOCIATION FUND
#
#
# Hotel Tax (Marriott) 1 % $ 779,720 $ 779,720 $ 779,720 $ 803,346 $ 811,380 $ 819,494 $ 819,494
# Hotel Tax (Other) 1% ‐ 230 ‐ 230 230 230 230
# Hotel Tax (Deloitte) Match Fund 210 # 1% 36,982 36,982 36,982 37,000 37,000 37,000 74,000
# Base Hotel Tax 816,702 816,932 816,702 840,576 848,610 856,724 893,724
# Hotel Tax ‐ Entrada 0% ‐ ‐ ‐ ‐ 300,000 600,000 600,000
# Hotel Tax ‐ Front 44 0% ‐ ‐ ‐ ‐ ‐ 300,000 600,000
# Additional Commercial Tax ‐ ‐ ‐ ‐ 300,000 900,000 1,200,000
# Total Hotel Occupancy Tax 816,702 816,932 816,702 840,576 1,148,610 1,756,724 2,093,724
#
# Interest Income 1% 14,606 14,606 14,606 14,250 14,250 14,250 14,250
# Community Tree Lighting 1% 3,675 3,675 3,675 2,756 2,784 2,811 2,811
# Insur Refund/Equity Return 1% 437 437 437 860 869 878 878
# Dept 10 ‐ General Service Revenues 18,718 18,763 18,718 17,866 17,903 17,939 17,939
#
# Membership Fees 1% 1,775 1,775 ‐ 1,775 1,775 1,775 1,775
# Special Events Revenue 1% 3,250 3,250 ‐ 3,250 3,250 3,250 3,250
# Sales of Printed Material 1% 200 200 ‐ 200 200 200 200
# Sponsors 1% 3,000 3,000 ‐ 3,000 3,000 3,000 3,000
# Misc Revenue 1% 250 ‐ ‐ ‐ ‐ ‐ ‐
# Dept 24 ‐ Historical Board Revenues 8,475 8,225 ‐ 8,225 8,225 8,225 8,225
#
# TOTAL REVENUES 843,895 843,920 835,420 866,667 1,174,738 1,782,888 2,119,888
#
# Office Rent 1% (70,295) (70,295) (72,472) (73,197) (73,929) (74,668) (75,415)
# Telephone Service 1% (624) (624) (624) (630) (637) (643) (649)
# Internet Expense 1% (2,195) (2,195) (2,195) (2,217) (2,239) (2,262) (2,284)
# Electric Service 1% (7,500) (7,500) (7,500) (7,575) (7,651) (7,727) (7,805)
# Dept 10 ‐ Rent & Utilities Expenditures (80,614) (80,614) (82,791) (83,619) (84,455) (85,300) (86,153)
#
# Operating Xfr Out to GF for Payroll Costs 1% (555,167) (610,971) (564,879) (570,528) (576,233) (581,996) (587,815)
# Auditor 1% (7,250) (6,925) (8,000) (8,080) (8,161) (8,242) (8,325)
# Marriott Marketing 1% (50,000) (50,000) (50,000) (50,500) (51,005) (51,515) (52,030)
# Marriott Transportation 1% (80,000) (80,000) (80,000) (80,800) (81,608) (82,424) (83,248)
# Other Hotels Marketing hard coded ‐ ‐ ‐ ‐ (100,000) (200,000) (200,000)
# Marketing & Promotions 1% (7,500) (7,500) (7,500) (7,575) (7,651) (7,727) (7,805)
# Application Software Maint. 1% (1,950) (1,950) (3,185) (3,217) (3,249) (3,282) (3,314)
# Community Tree Lighting 1% (11,762) (11,762) (11,762) (11,880) (11,998) (12,118) (12,240)
# Audio/Visual 1% (250) ‐ ‐ ‐ ‐ ‐ ‐
# Dues & Subscriptions 1% (125) ‐ ‐ ‐ ‐ ‐ ‐
# Dept 10 ‐ General Service Expenditures (714,004) (769,108) (725,326) (732,579) (839,905) (947,304) (954,777)
#
# Contract Services 1% (52,709) (52,709) (40,000) (40,200) (40,401) (40,603) (40,806)
# Community Services 1% (13,401) (13,401) (13,401) (13,468) (13,535) (13,603) (13,671)
# Masterworks 1% (5,750) (5,750) (5,750) (5,779) (5,808) (5,837) (5,866)
# Marketing & Promotions 1% (61,809) (60,309) (45,862) (46,091) (46,322) (46,553) (46,786)
# Community Picnic 1% (1,170) ‐ ‐ ‐ ‐ ‐ ‐
# Advertising/Public Notices 1% (20,615) (20,615) (20,615) (20,718) (20,822) (20,926) (21,030)
# Special Community Events 1% (7,239) (8,409) (8,409) (8,451) (8,493) (8,536) (8,578)
# Dues & Subscriptions 1% (5,794) (7,294) (7,294) (7,330) (7,367) (7,404) (7,441)
# Postage & Supplies 1% (139) (139) (139) (140) (140) (141) (142)
# Printing 1% (1,154) (1,154) (1,154) (1,160) (1,166) (1,171) (1,177)
# Dept 22 ‐ Communication Expenditures (169,780) (169,780) (142,624) (143,337) (144,054) (144,774) (145,498)
#
# Office Supplies 0% $ (10) $ (10) $ ‐ $ ‐ $ ‐ $ ‐ $ ‐
# Car Show Expenses 0% (5,825) (5,825) ‐ ‐ ‐ ‐ ‐
# Town Historical Board Expense 0% (2,075) (2,075) (5,225) (5,225) (5,225) (5,225) (5,225)
# Dept 24 ‐ Historical Board Expenditures (7,910) (7,910) (5,225) (5,225) (5,225) (5,225) (5,225)
#
# Sponsorship Expense 0% (10,000) (10,000) ‐ ‐ ‐ ‐ ‐
# Dept 25 ‐ Public Art Expenditures (10,000) (10,000) ‐ ‐ ‐ ‐ ‐

127