Page 125 - Ord 866 Adopting a revised Fiscal Year 17-18 and new proposed Fiscal Year 18-19 budget

FIVE YEAR FINANCIAL FORECAST
ALL MUNICIPAL FUNDS

ESTIMATED PROPOSED 1 2 3 4
DESCRIPTION FY 17- 18 FY 18- 19 FY 19- 20 FY 20- 21 FY 21- 22 FY 22- 23

SPECIAL REVENUE FUNDS

FUND 220 - VISITORS ASSOCIATION FUND
Hotel Tax ( Marriott) 1.00% 779, 720 779, 720 795, 392 803, 346 811, 380 819, 494
Hotel Tax ( Deloitte) Match Fund 210 # 1.00% 36, 982 36, 982 32, 640 32, 640 32, 640 32, 640
Base Hotel Tax 816, 702 816, 702 828, 032 835, 986 844, 020 852, 134
Deloitte Abatement Ends 01- 01- 23 hard coded 0 0 0 0 0 32, 640
Entrada Hotel 1 hard coded 0 0 300, 000 600, 000 600, 000 600, 000
Entrada Hotel 2 hard coded 0 0 300, 000 600, 000 600, 000 600, 000
Blizzard Hotel hard coded 0 0 300, 000 600, 000 600, 000
Additional Commercial Tax 0 0 600, 000 1,500, 000 1,800, 000 1,832, 640
Total Hotel Occupancy Tax 816, 702 816, 702 1,428, 032 2,335, 986 2,644, 020 2,684, 774
Interest Income 1.00% 14, 606 14, 606 14, 250 14, 250 14, 250 14, 250
Community Tree Lighting 1.00% 3,675 3,675 2,675 2,756 2,784 2,811
Insur Refund/ Equity Return 1.00% 437 437 852 860 869 878
Dept 10 - General Service Revenues 18, 718 18, 718 17, 777 17, 866 17, 903 17, 939
Membership Fees 1.00% 1,775 1,775 1,775 1,775 1,775 1,775
Special Events Revenue 1.00% 3,250 3,250 3,250 3,250 3,250 3,250
Special Events Revenue 1.00% 2,550 0 0 0 0 0
Sponsors Car Show 1.00% 2,000 0 0 0 0 0
Sales of Printed Material 1.00% 200 200 200 200 200 200
Sponsors 1.00% 3,000 3,000 3,000 3,000 3,000 3,000
Misc Revenue 1.00% 250 250 0 0 0 0
Dept 24 - Historical Board Revenues 13, 025 8,475 8,225 8,225 8,225 8,225
Total Revenues & Transfers In 848, 445 843, 895 1,454, 034 2,362, 077 2,670, 148 2,710, 938
Operating Xfr Out to GF for Payroll Costs 1.00%( 518, 510)( 555, 167)( 560, 719)( 566, 326)( 571, 990)( 577, 709)
Auditor 1.00%( 7,250)( 7,250)( 7,323)( 7,396)( 7,470)( 7,544)
Community Services 1.00%( 133) 0 0 0 0 0
Marriott Marketing 1.00%( 50,000)( 50,000)( 50,500)( 51,005)( 51,515)( 52,030)
Marriott Transportation 1.00%( 80,000)( 80,000)( 80,800)( 81,608)( 82,424)( 83,248)
Marketing & Promotions 1.00%( 7,500)( 7,500)( 7,575)( 7,651)( 7,727)( 7,805)
Application Software Maint. 1.00%( 1,950)( 1,950)( 1,970)( 1,989)( 2,009)( 2,029)
Community Tree Lighting 1.00%( 11,762)( 11,762)( 11,880)( 11,998)( 12,118)( 12,240)
Audio/ Visual 1.00%( 250)( 250)( 253)( 255)( 258)( 260)
Dues & Subscriptions 1.00%( 125)( 125)( 126)( 128)( 129)( 130)
Dept 10 - General Service Expenditures ( 677, 480)( 714, 004)( 721, 144)( 728, 356)( 735, 639)( 742, 996)
Office Rent 0.00%( 50,250)( 70,295)( 72,475)( 74,670)( 76,245)( 76,935)
Telephone Service 1.00%( 624)( 624)( 630)( 637)( 643)( 649)
Internet Expense 1.00%( 2,195)( 2,195)( 2,217)( 2,239)( 2,262)( 2,284)
Electric Service 0.00%( 7,500)( 7,500)( 7,500)( 7,500)( 7,500)( 7,500)
Dept 10 - Rent & Utilities Expenditures ( 60,569)( 80,614)( 82,822)( 85,046)( 86,649)( 87,368)
Contract Services 0.50%( 52,709)( 52,709)( 52,973)( 53,237)( 53,504)( 53,771)
Community Services 0.50%( 13,401)( 13,401)( 13,468)( 13,535)( 13,603)( 13,671)
Masterworks 0.50%( 5,750)( 5,750)( 5,779)( 5,808)( 5,837)( 5,866)
Marketing & Promotions 0.50%( 29,309)( 61,809)( 62,118)( 62,429)( 62,741)( 63,054)
Community Picnic 0.50%( 1,170)( 1,170)( 1,176)( 1,182)( 1,188)( 1,194)
Other Hotels Marketing hard coded 0 0 ( 150, 000)( 375, 000)( 450, 000)( 450, 000)
Advertising 0.50%( 20,615)( 20,615)( 20,718)( 20,822)( 20,926)( 21,030)
Special Community Events 0.50%( 7,239)( 7,239)( 7,275)( 7,312)( 7,348)( 7,385)
Dues & Subscriptions 0.50%( 5,794)( 5,794)( 5,823)( 5,852)( 5,881)( 5,911)
Postage & Supplies 0.50%( 139)( 139)( 140)( 140)( 141)( 142)
Printing 0.50%( 1,154)( 1,154)( 1,160)( 1,166)( 1,171)( 1,177)
Dept 22 - Communication Expenditures ( 137, 280)( 169, 780)( 320, 629)( 546, 482)( 622, 339)( 623, 201)

Website Development/ Maint. 0.00%( 10) 0 0 0 0 0
Office Supplies 0.00%( 10)( 10)( 10)( 10)( 10)( 10)
Car Show Expenses 0.00%( 5,825)( 5,825)( 5,825)( 5,825)( 5,825)( 5,825)
Town Historical Board Expense 0.00%( 2,075)( 2,075)( 2,075)( 2,075)( 2,075)( 2,075)
Dept 24 - Historical Board Expenditures ( 7,920)( 7,910)( 7,910)( 7,910)( 7,910)( 7,910)

111