Page 272 - ANALYSIS.XLS

City of McAllen, Texas
Palm View Golf Course Fund
Working Capital Summary

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

RESOURCES

BEGINNING WORKING CAPITAL $ 905,109 $ 915,688 $ 1,015,803 $ 1,019,730

Revenues:
Green Fees 714,552 693,864 710,988 729,419
Annual Membership 179,734 172,237 166,685 178,293
Driving Range Fees 144,117 136,016 130,916 147,416
Trail Fees 6,196 7,921 7,427 8,235
Handicap Carts 600 400 160 -

Rental 7,975 8,700 9,425 8,700

Cart Rental 318,202 312,643 315,594 334,425
Pull Cart Rentals 372 216 216 332

Other Financial Resources 4,451 37,000 34,925 37,000

Interest Earned 28,684 10,000 10,000 10,197
Miscellaneous 8,818 - - -
Total Revenues 1,413,702 1,378,997 1,386,336 1,454,017
TOTAL RESOURCES $ 2,318,811 $ 2,294,685 $ 2,402,139 $ 2,473,747

APPROPRIATIONS

Expenses:
Maintenance & Operations $ 672,399 $ 686,622 $ 684,908 $ 723,216
Dining Room 986 2,000 2,000 2,000

Pro-Shop 356,760 401,026 395,643 400,870
Golf Carts 105,096 143,822 129,998 144,139
Capital Outlay - - - -
Total Operating Expenses 1,135,242 1,233,470 1,212,549 1,270,224

Other Financing Sources (Uses):
Transfer-Out PVGC Depreciation Fund 160,000 150,000 150,000 160,000
Transfer-Out Heath Insurance Fund 44,850 19,676 19,676 7,798
Debt Service - Motorola Lease Payment - 184 184 184

TOTAL APPROPRIATIONS 1,340,092 1,403,330 1,382,409 1,438,206

Revenues over/(under) Expenditures 73,610 (24,333) 3,927 15,811

Other Items Affecting Working Capital 37,084 - - -

ENDING WORKING CAPITAL $ 1,015,803 $ 891,355 $ 1,019,730 $ 1,035,541

-222-