Page 58 - CityofTrophyClubFY26Budget

Hotel Occupancy Tax FY 2022 FY 2023 FY 2024 FY 2025 FY 2025 FY 2025 YEAR FY 2026 FY 2027

Fund ACTUAL ACTUAL ACTUAL APPROVED AMENDED TO DATE PROPOSED PROJECTED

Beginning Fund Balance $ 1,726,744 $ 2,465,552 $ 3,102,338 $ 3,887,902 $ 3,887,902 $ 3,887,902 $ 4,318,720 $ 4,359,378

Revenue
Hotel Occupancy Tax $ 781,831 $ 822,484 $ 885,378 $ 750,000 $ 750,000 $ 659,052 $ 800,000 $ 824,000

July 4th Revenue 21,442 14,272 20,635 10,000 10,000 6,390 15,000 15,450

Sponsorships - Christmas - - - - - 1,500 1,500 -

Interest Income 12,140 99,941 159,312 50,000 50,000 93,585 100,000 103,000

Miscellaneous Revenue - - 2,081 - - 2,336 - -

Total Revenue $ 815,413 $ 936,697 $ 1,067,406 $ 810,000 $ 810,000 $ 760,527 $ 916,500 $ 942,450

Expenditures
Personnel
Salaries $ 12,264 $ 89,135 $ 98,654 $ 163,580 $ 163,580 $ 121,488 $ 174,605 $ 179,843
Salaries - Part Time - - - - - 96 1,000 1,030

Overtime - - - - - 552 15,000 15,450

Longevity - - 300 376 376 376 349 359

Salaries - Certification - 563 1,653 2,310 2,310 2,083 2,460 2,534

Salaries - Cell Phone Stipend - 326 639 1,860 1,860 1,376 1,860 1,916

Retirement 1,032 9,986 10,658 24,550 24,550 17,710 26,994 27,804

457 Contributions - - - - - - 2,350 2,350

Medical insurance 795 2,549 773 10,367 10,367 9,011 22,419 23,091

Dental Insurance 48 433 782 1,222 1,222 975 2,006 2,066

Vision Insurance 7 63 163 279 279 212 436 449

Life Insurance & Other 38 308 445 1,005 1,005 673 1,287 1,326

Social Security Taxes 744 1,280 4,926 10,713 10,713 7,625 11,404 11,746

Medicare Taxes 174 299 1,184 2,505 2,505 1,807 2,667 2,747

Unemployment Taxes 5 9 12 517 517 236 517 532

Workers Compensation - - 111 2,723 2,723 523 2,679 2,759

Auto/Housing Allowance - - 25 1,410 1,410 - 1,410 1,452

Mileage Allowance - - - - - 1,803 1,200 1,200
Total Personnel $ 15,107 $ 104,951 $ 120,326 $ 223,417 $ 223,417 $ 166,546 $ 269,442 $ 277,455
Services & Supplies
Professional Outside Services $ 5,484 $ 121,500 $ 34,050 $ 190,000 $ 190,000 $ - $ 105,000 $ 108,150
Auditing 4,000 4,000 3,286 3,384 3,384 2,823 6,000 6,180
Software & Support 18,284 21,434 22,506 47,000 47,000 6,170 30,000 30,900
Advertising 19,292 18,780 65,168 61,500 61,500 7,657 120,000 123,600
Schools & Training - - - - - - 1,500 -

Service Charges & Fees - - 24 - - - - -
Communications/Pagers/Mobiles 1,368 1,368 1,254 - - 1,026 1,400 -

Event Rentals 1,968 - - - - - - -

Dues & Membership - - - 4,000 4,000 - 1,500 10,000

Travel & Per Diem - - - - - - 2,000 2,000
Uniforms - - - - - - 1,000 1,000
Program/Event Supplies - - - - - 21 - -

July 4 Celebration 95,602 115,677 130,228 160,000 160,000 84,534 160,000 160,000

Taste of Trophy Club - - - 39,000 39,000 - 39,000 40,170

Harvest Festival - - - - - - 39,000 39,000
Winter Wonderlights - - - 80,000 80,000 60,934 80,000 80,000

Art Programs - - - - - - 20,000 20,000

Bad Debt Expense 10,500 - - - - - - -
Total Services & Supplies $ 156,498 $ 282,760 $ 256,515 $ 584,884 $ 584,884 $ 163,163 $ 606,400 $ 621,000
Capital Outlay
Capital Outlay $ - $ 7,200 $ - $ 20,000 $ 20,000 $ - $ - $ -
Total Capital $ - $ 7,200 $ - $ 20,000 $ 20,000 $ - $ - $ -
Total Expenditures $ 171,605 $ 394,911 $ 376,842 $ 828,302 $ 828,302 $ 329,709 $ 875,842 $ 898,455

Other Sources (Uses)

Transfer To General Fund $ 95,000 $ 95,000 $ 95,000 $ - $ 95,000 $ - $ - $ -
Total Other Sources (Uses) $ 95,000 $ 95,000 $ 95,000 $ - $ 95,000 $ - $ - $ -

Net Increase (Decrease) $ 738,808 $ 636,786 $ 785,564 $ (18,302) $ 76,698 $ 430,818 $ 40,658 $ 43,995
Ending Fund Balance $ 2,465,552 $ 3,102,338 $ 3,887,902 $ 3,869,600 $ 3,964,600 $ 4,318,720 $ 4,359,378 $ 4,403,373

FY26 Adopted Budget 50 9/9/25