Page 407 - ANALYSIS.XLS

City of McAllen, Texas
General Depreciation Fund
Working Capital Summary

Adjusted
Actual Budget Estimated Budget Four Year Plan
18-19 19-20 19-20 20-21 21-22 22-23 23-24 24-25
RESOURCES
BEGINNING WORKING CAPITAL $ 10,457,836 $ 11,440,994 $ 10,320,435 $ 11,138,984 $ 12,086,906 $ 12,374,561 $ 12,791,120 $ 15,482,930
Revenues:
Rentals - General Fund 2,764,775 2,935,642 2,935,642 2,965,878 3,669,786 3,984,813 3,773,899 3,599,149
Other 122,051 - - - - - - -

Vehicle Shortage - 941,367 20,700 133,500 - - - -
Interest Earned 281,828 - - 111,390 120,869 123,746 127,911 154,829
Total Revenue 3,168,654 3,877,009 2,956,342 3,210,768 3,790,655 4,108,559 3,901,810 3,753,978
TOTAL RESOURCES $ 13,626,490 $ 15,318,003 $ 13,276,777 $ 14,349,752 $ 15,877,561 $ 16,483,120 $ 16,692,930 $ 19,236,908

APPROPRIATIONS
Capital Outlay for General Fund:
Vehicles $ 3,281,432 $ 4,084,228 $ 2,591,557 $ 2,613,052 $ 3,503,000 $ 3,692,000 $ 1,210,000 $ 2,144,000
Equipment 24,625 - - - - - - -
Other Financing Sources (Uses):
Transfer out - Sanitation Depreciation - - - 45,000 - - - -
TOTAL APPROPRIATIONS 3,306,057 4,084,228 2,591,557 2,658,052 3,503,000 3,692,000 1,210,000 2,144,000
Other items affecting Working Capital
Toll Bridge Fund Loan Payment - 67,932 58,558 - - - - -
Airport Fund Loan Payment - 395,206 395,206 395,206 - - - -
ENDING WORKING CAPITAL $ 10,320,435 $ 11,696,913 $ 11,138,984 $ 12,086,906 $ 12,374,561 $ 12,791,120 $ 15,482,930 $ 17,092,908

-357-