Page 391 - ANALYSIS.XLS

City of McAllen, Texas
Hotel Occupancy Tax Fund
Working Capital Summary

Adjusted
Actual Budget Estimated Budget Four Year Plan
RESOURCES 18-19 19-20 19-20 20-21 21-22 22-23 23-24 24-25
BEGINNING
WORKING CAPITAL $ 40 $ 40 $ 329 329 $ 329 $ 329 $ 329 $ 329
Revenues:
Hotel Taxes 4,093,724 4,160,880 2,264,296 3,100,033 3,100,033 3,100,033 3,100,033 3,100,033
Penalty & Interest 33,658 - - - - - - -
Short Term Rentals 3,235 - - - - - - -
Miscellanous 20 - - - - - - -
Total Revenues 4,130,638 4,160,880 2,264,296 3,100,033 3,100,033 3,100,033 3,100,033 3,100,033
TOTAL RESOURCES $ 4,130,678 $ 4,160,920 $ 2,264,625 $ 3,100,362 $ 3,100,362 $ 3,100,362 $ 3,100,362 $ 3,100,362

APPROPRIATIONS
Chamber of Commerce $ 1,094,331 $ 1,101,823 $ 559,942 $ 820,474 $ 798,724 $ 798,724 $ 798,724 $ 798,724
Other Financing Sources (Uses):
Transfer Out -
Convention Center 2,188,662 2,206,646 1,122,883 1,643,197 1,600,447 1,600,447 1,600,447 1,600,447
Performing Arts Center Fund 547,357 552,411 281,471 411,362 400,862 400,862 400,862 400,862
Development Corp. Fund 100,000 - - - - - - -
Parade Fund - 100,000 100,000 25,000 100,000 100,000 100,000 100,000
Marketing Campaign 200,000 200,000 200,000 200,000 200,000 200,000 200,000 200,000
Total Other Sources 3,036,019 3,059,057 1,704,354 2,279,559 2,301,309 2,301,309 2,301,309 2,301,309
TOTAL APPROPRIATIONS 4,130,350 4,160,880 2,264,296 3,100,033 3,100,033 3,100,033 3,100,033 3,100,033
ENDING WORKING CAPITAL $ 329 40 329 329 $ 329 $ 329 $ 329 $ 329

City of McAllen, Texas
Venue Tax Fund
Working Capital Summary

Adjusted Approved
Actual Budget Estimated Budget Four Year Plan
RESOURCES 18-19 19-20 19-20 20-21 21-22 22-23 23-24 24-25
BEGINNING
WORKING CAPITAL $ 221,939 $ 320,362 $ 334,670 122,743 $ - $ (121,743) $ (219,606) $ (297,027)

Revenues:
Hotel Taxes 1,169,747 1,189,836 647,011 735,995 735,995 758,075 780,817 804,242
Penalty & Interest 10,186 - - - - - - -
Short term rentals 896 - - - - - - -
Total Revenues 1,180,829 1,189,836 647,011 735,995 735,995 758,075 780,817 804,242

TOTAL RESOURCES $ 1,402,768 $ 1,510,198 $ 981,681 $ 858,738 $ 735,995 $ 636,332 $ 561,211 $ 507,215
APPROPRIATIONS
Other Financing Sources (Uses):
Transfers Out -
Debt Service Fund $ 858,637 $ 858,938 $ 858,938 $ 858,738 $ 857,738 $ 855,938 $ 858,238 $ 859,538
Performing Arts Center Fund 209,461 330,898 - - - - - -
TOTAL APPROPRIATIONS 1,068,098 1,189,836 858,938 858,738 857,738 855,938 858,238 859,538

ENDING WORKING CAPITAL $ 334,670 320,362 122,743 - $ (121,743) $ (219,606) $ (297,027) $ (352,323)

-341-