Page 394 - ANALYSIS.XLS

City of McAllen, Texas
Development Corporation
of McAllen, Inc.
Fund Balance 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
BEGINNING FUND BALANCE $ 16,105,703 $ 17,595,752 $ 17,607,023 $ 3,476,678 $ 4,510,309 $ 13,547,506 $ 22,058,675 $ 30,967,074
Revenues:
1/2CENT SALES TAX COLLECTIONS 15,940,779 14,322,612 14,322,612 14,322,612 14,680,677 14,974,291 15,348,648 15,655,621
Insight 1,380,287 1,104,705 1,104,705 1,104,705 1,000,000 1,000,000 1,000,000 1,000,000
Christmas in the Park 6,384 6,384 33,024 - - - - -
El Rancho Santa Cruz Subd Drainage Imprv HMGP 298,424 83,702 - - - - - -
Hackberry Building Lease Reimbursement 4,500 18,000 18,000 - - - - -
Kennedy Ave Drainage Imprv. HMGP 46 610,110 546,677 - - - - -
McAllen CARES Reimbursement - - - 5,400,000 - - - -
McAllen Marathon 122,470 130,000 125,880 130,000 130,000 130,000 130,000 130,000
Miscellaneous / Recovery Prior Year Exp (20,279) - - - - - - -
Other revenue - Parade 46,054 - - - - - - -
Pecan Blvd. at N. 27th St. Drainage Imprv HMGP 172,826 210,933 33,384 - - - - -
Quince Avenue at N. 27th St Drainage 14,204 598,652 - 583,425 - - - -
Sponsorships- City Annual Parade (2018) 684,576 - - - - - - -
War Memorial 22,733 - - - - - - -
Westway Heights Drainage Improvements HMGP 1,152,461 2,315,292 932,217 - - - - -
Investment Earnings 407,191 150,000 150,000 34,767 120,000 120,000 120,000 120,000
Total Revenues 20,232,654 19,550,391 17,266,499 21,575,509 15,930,677 16,224,291 16,598,648 16,905,621
Operating Financing Sources:
Transfer In - Hotel Occupancy Tax Fund 100,000 - - - - - - -
TOTAL RESOURCES $ 36,438,357 $ 37,146,143 $ 34,873,522 $ 25,052,186 $ 20,440,987 $ 29,771,796 $ 38,657,323 $ 47,872,696
Expenditures
Skill Job Training & Learning Centers 1,001,123 999,338 999,338 885,000 1,210,062 1,210,062 1,210,062 1,210,062
Health Clinic Facility 233,942 233,942 233,942 230,000 256,514 256,514 256,514 256,514
Business District Improvements 5,106,858 12,453,825 11,008,432 6,370,202 2,019,016 1,918,750 1,896,823 1,592,765

McAllen Cares - 5,400,000 5,400,000 - - - - -
Public Safety - 610,950 610,950 - - - - -
Street and Drainage Improvements 3,285,565 3,578,556 3,081,344 4,660,697 - - - -
Recreation / Community Centers Impv & Entertainment 1,926,219 1,992,085 572,596 1,646,470 170,000 170,000 170,000 170,000
Other 2,610,921 7,185,920 4,025,403 5,105,633 1,987,704 1,987,704 1,987,704 1,987,704
Total Expenditures (Detail Schedule Attached) 14,164,628 32,454,616 25,932,005 18,898,002 5,643,296 5,543,030 5,521,103 5,217,045
Other Financing Sources (Uses):
Transfer to General Fund 3,488,825 3,492,600 3,492,600 200,000 200,000 200,000 200,000 200,000
Transfer to McAllen System Fund 925,618 933,914 540,537 67,000 70,000 984,971 984,971 984,971
Tansfer to Transit System Fund 263,533 775,626 268,219 466,441 75,000 75,000 75,000 75,000
Transfer to Christmas Parade Fund - 93,114 93,114 - - - - -
Transfer to Local Govt. Co. Debt Service Fund - 1,070,369 1,070,369 910,435 905,185 910,120 909,175 906,800
Total Other Sources 4,677,976 6,365,623 5,464,839 1,643,876 1,250,185 2,170,091 2,169,146 2,166,771
TOTAL APPROPRIATIONS 18,842,605 38,820,239 31,396,844 20,541,878 6,893,481 7,713,121 7,690,249 7,383,816
Revenues over/(under) Expenditures 1,490,050 (19,269,848) (14,130,345) 1,033,631 9,037,196 8,511,170 8,908,399 9,521,805
Other items affecting Working Capital 11,270 - - - - - - -
UNRESERVED ENDING FUND BALANCE $ 17,607,023 $ (1,674,096) $ 3,476,678 $ 4,510,309 $ 13,547,506 $ 22,058,675 $ 30,967,074 $ 40,488,880

-344-