Page 337 - ANALYSIS.XLS

City of McAllen, Texas
Health Insurance Fund
Working Capital Summary

Actual Adj. Budget Estimated Budget
18-19 19-20 19-20 20-21

RESOURCES

BEGINNING WORKING CAPITAL $ (3,339,266) $ (3,370,737) $ (1,587,863) $ 196,575

Revenues:
Contributions:
General Fund 4,745,118 5,400,288 5,430,374 6,096,552
CDBG Fund 8,856 10,032 14,064 20,448
Downtown Services Fund 62,202 70,728 66,434 74,760
Water Fund 512,443 612,744 594,222 727,632
Wastewater Fund 314,403 328,944 364,364 367,272
Sanitation Fund 563,913 626,400 656,945 732,672
Palm View Golf Course Fund 49,262 62,328 49,504 54,144
Convention Center Fund 142,459 158,184 173,702 202,728
Airport Fund 142,614 161,808 155,891 176,976
Bus Terminal Fund 19,535 25,000 19,624 37,152
Toll Bridge Fund 127,256 146,616 143,612 166,152
Metro McAllen Fund 133,872 136,824 166,044 182,136
Anzalduas Crossing Fund 27,707 29,000 25,469 19,200
Fleet/Mat. Mgm't Fund 90,509 99,816 93,254 109,224
Workmans Compensation Fund 26,897 27,936 21,928 28,272
Life Insurance (All funds) 59,732 62,000 47,495 65,000
Health Ins. Admin Fund 22,849 25,512 26,784 25,872
Employees 2,298,157 2,440,824 2,499,153 2,523,300
Other Agencies 759,198 839,052 816,433 902,268
Other 373,622 292,432 266,071 203,808
Total Contributions 10,480,604 11,556,468 11,631,368 12,715,568
Other Financing Sources:
Transfer In -

General Fund - 800,650 800,650 806,704
Downtown Services Fund 65,550 28,757 28,757 11,342
Water Fund 472,651 207,352 207,352 101,370
Wastewater Fund 269,100 118,054 118,054 51,039
Sanitation Fund 455,401 199,784 199,784 103,496
Palm View Golf Course Fund 44,850 19,676 19,676 7,798
Convention Center Fund 117,300 51,460 51,460 29,773
Airport Fund 117,300 51,460 51,460 25,520
Bus Terminal Fund 17,251 7,568 7,568 4,962
Toll Bridge Fund 93,150 40,865 40,865 24,811
Metro McAllen Fund 113,850 49,946 49,946 25,520
Anzalduas Crossing Fund 27,600 12,108 12,108 2,836
Fleet/Mat. Mgm't Fund 72,450 31,784 31,784 14,886
Workmans Compensation Fund 4,150,105 2,766,736 2,766,736 1,390,151
Total Transfers In 6,016,558 4,386,200 4,386,200 2,600,208

Total Revenues 16,497,162 15,942,668 16,017,568 15,315,776

TOTAL RESOURCES $ 13,157,896 $ 12,571,931 $ 14,429,705 $ 15,512,351

-287-