Question
Located at about 5 miles north of Nobleton Lakes, Triple-F Health Golf Club, offers a challenging layout and beautiful views to golf lovers including retirees
Located at about 5 miles north of Nobleton Lakes, Triple-F Health Golf Club, offers a challenging layout and beautiful views to golf lovers including retirees for improving their physical and mental health. As a not-for-profit, family-oriented golf club, the main objective is to become a popular course with visitors to, and residents of the Nobleton Lakes area. To move along with this overall strategy, the clubs board of directors is developing plans to purchase more golf equipment and expand club facilities in the course. The board plans to purchase about $26,400 of new equipment each year and also wants to establish a fund to purchase the neighboring property in the next four or five years. The neighboring property is currently listed at a market value of about $301,400.
Emily Shawn, the golf club manager, has some concerns over this expansion strategy and believes that the board might have some unrealistic goals given the clubs recent financial performance. She recently found out that one of the golf club members, Jack Sally, has taken a Managerial Accounting course at York University. Jack has agreed to assist Emily in preparing a report to the board supporting her concerns.
Here are the clubs records, including this cash-basis income statement, which have been reviewed by Jack:
TRIPLE-F HEALTH CLUB | |||||||||||||||||||
Income Statement (Cash Basis) | |||||||||||||||||||
For Years Ended October 31 (in thousands) | |||||||||||||||||||
2020 | 2019 | ||||||||||||||||||
Cash revenues: | |||||||||||||||||||
Annual membership fees | $ | 355.00 | $ | 313.05 | |||||||||||||||
Lesson and class fees | 239.46 | 184.20 | |||||||||||||||||
Miscellaneous | 2.00 | 1.50 | |||||||||||||||||
Total cash revenues | $ | 596.46 | $ | 498.75 | |||||||||||||||
Cash expenses: | |||||||||||||||||||
Managers salary and benefits | $ | 36.28 | $ | 36.28 | |||||||||||||||
Regular employees wages and benefits | 191.40 | 191.40 | |||||||||||||||||
Lesson and class employees wages and benefits | 196.82 | 151.40 | |||||||||||||||||
Towels and supplies | 16.00 | 15.50 | |||||||||||||||||
Utilities (heat and light) | 22.00 | 15.00 | |||||||||||||||||
Mortgage interest | 35.10 | 37.80 | |||||||||||||||||
Miscellaneous | 2.00 | 1.50 | |||||||||||||||||
Total cash expenditures | $ | 499.60 | $ | 448.88 | |||||||||||||||
Increase in cash | $ | 96.86 | $ | 49.87 | |||||||||||||||
- As of October 31, 2020, other financial information is listed below:
- Petty cash, $580.
- Cash in checking account, $8,400.
- Accounts payable are from invoices for the course supplies and utilities that are unpaid as of October 31, 2020, and due in November 2020, $2,780.
- Outstanding mortgage balance, $348,800.
- Membership rose 3% in 2020. The club has experienced approximately this same annual growth rate since it opened and this rate is expected to continue in the future.
- Membership fees increased by 15% in 2020. The board has tentative plans to increase these fees by 10% in 2021.
- Lesson and class fees in the course have not been increased for 3 years. The board policy is to encourage classes and lessons by keeping the fees low. The members have taken advantage of this policy, and the number of classes and lessons has increased significantly each year. The club expects the percentage growth experienced in 2020 to be repeated in 2021.
- Miscellaneous revenues are expected to grow at the same rate as in 2020.
- No other unpaid bills existed on October 31, 2020.
- The club purchased $26,400 worth of golf equipment during the current fiscal year. Cash of $12,800 was paid on delivery, with the balance due on October 1. This amount had not been paid as of October 31, 2020. An additional $26,400 (cash) of equipment purchases is planned for the coming year.
- The club began operations in 2016 in rental quarters. In October 2016, it purchased its current property (course/land and building) for $600,000, paying $120,000 down and agreeing to pay $32,800 plus 9% interest annually on the unpaid loan balance each November 1, starting November 1, 2017.
- Operating expenses expected to increase as follows:
- Towels and supplies, utilities, and miscellaneous club expenses: 25%.
- Hourly wage rates and the managers salary: 15%.
Required:
1. Prepare a cash budget for 2021 for the Triple-F Health Golf Club. (Round your "Growth" column answers to 2 decimal places and your remaining answers to nearest whole dollar or percentage amount.)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started