Required Information [The following information applies to the questions displayed below.] Triple-F Health Club (Family, Fitness, and Fun) is a not-for-profit, family-oriented health club. The club's board of directors is developing plans to acquire more equipment and expand club facilities. The board plans to purchase about $25.000 of new equipment each year and wants to establish a fund to purchase the adjoining property In four or five years. The adjoining property has a market value of about $300,000 The club manager, Jane Crowe, is concerned that the board has unrealistic goals in light of the club's recent financial performance. She has sought the help of a club member with an accounting background to assist her in preparing a report to the board supporting her concerns. The member reviewed the club's records, including this cash-basis Income statement TRIPLE-F HEALTH CLUB Income Statement (Cash Basis) For Years End October 31 2023 2022 $ 445,880 253,500 5,689 $ 783,500 $ 380,880 195,880 1,500 $ 496,500 Cash revenues : Annual membership fees Lesson and class fees Miscellaneous Total cash revenues Cash expenses: Manager's salary and benefits Regular employees' wages and benefits Lesson and class employees' wages and benefits Towels and supplies Utilities (heat and light) Mortgage interest Miscellaneous Total cash expenditures Increase in cash $ 51,000 285,880 210,880 31,080 37,000 33,880 9,500 $ 543,582 $ 160,000 $ 36,089 190,880 150.000 15,560 15.000 37,880 1,500 $ 445,888 $ 50, 700 Other financial Information as of October 31, 2023: Cash in checking account, $7.000. Petty cash, $300 Outstanding mortgage balance. $330,000. Accounts payable arising from invoices for supplies and utilities that are unpaid as of October 31, 2023, and due in November 2023. $10,000. No other unpaid bills existed on October 31, 2023. The club purchased $25.000 worth of exercise equipment during the current fiscal year. Cash of $10.000 was pald on delivery, with the balance due on October 1. This amount had not been paid as of October 31, 2023. An additional $25.000 (cash) of equipment purchases is planned for the coming year. The club began operations in 2022 in rental quarters. In October 2022. It purchased its current property (land and building) for $600.000, paying $120.000 down and agreeing to pay $37,500 plus 9% Interest annually on the unpaid loan balance each November 1, starting November 1, 2023. Membership rose 3% in 2023. 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 2023. The board has tentative plans to Increase these fees by 10% in 2024. Lesson and class fees 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 2023 to be repeated in 2024. Miscellaneous revenues are expected to grow at the same rate as in 2023. Operating expenses expected to Increase: Hourly wage rates and the manager's salary: 15% Towels and supplies, utilities, and miscellaneous expenses: 25% urod Required: 1. Prepare a cash budget for 2024 for the Triple-F Health Club. (Round your "Growth SS" column answers to 2 decimal places and your remaining answers to nearest whole dollar or percentage amount.) ges TRIPLE-F HEALTH CLUB Cach Budget For the Year Ending Otober 31, 2024 2020 Growth Prio Inoreste 2024 Operating Cash Infows 96 95 Total Operang Cash intows $ 0 $ Operating Cash Outfons: Total Operating Cash Outflows Net Operating Cash Flow 1 - $ Non-Operating Cash Outfions: Total Non-Opersing Cash Outow $ ol Net Cash Flow $ 0 Budgeted Ending Cash Balance $ Required Information [The following information applies to the questions displayed below.] Triple-F Health Club (Family, Fitness, and Fun) is a not-for-profit, family-oriented health club. The club's board of directors is developing plans to acquire more equipment and expand club facilities. The board plans to purchase about $25.000 of new equipment each year and wants to establish a fund to purchase the adjoining property In four or five years. The adjoining property has a market value of about $300,000 The club manager, Jane Crowe, is concerned that the board has unrealistic goals in light of the club's recent financial performance. She has sought the help of a club member with an accounting background to assist her in preparing a report to the board supporting her concerns. The member reviewed the club's records, including this cash-basis Income statement TRIPLE-F HEALTH CLUB Income Statement (Cash Basis) For Years End October 31 2023 2022 $ 445,880 253,500 5,689 $ 783,500 $ 380,880 195,880 1,500 $ 496,500 Cash revenues : Annual membership fees Lesson and class fees Miscellaneous Total cash revenues Cash expenses: Manager's salary and benefits Regular employees' wages and benefits Lesson and class employees' wages and benefits Towels and supplies Utilities (heat and light) Mortgage interest Miscellaneous Total cash expenditures Increase in cash $ 51,000 285,880 210,880 31,080 37,000 33,880 9,500 $ 543,582 $ 160,000 $ 36,089 190,880 150.000 15,560 15.000 37,880 1,500 $ 445,888 $ 50, 700 Other financial Information as of October 31, 2023: Cash in checking account, $7.000. Petty cash, $300 Outstanding mortgage balance. $330,000. Accounts payable arising from invoices for supplies and utilities that are unpaid as of October 31, 2023, and due in November 2023. $10,000. No other unpaid bills existed on October 31, 2023. The club purchased $25.000 worth of exercise equipment during the current fiscal year. Cash of $10.000 was pald on delivery, with the balance due on October 1. This amount had not been paid as of October 31, 2023. An additional $25.000 (cash) of equipment purchases is planned for the coming year. The club began operations in 2022 in rental quarters. In October 2022. It purchased its current property (land and building) for $600.000, paying $120.000 down and agreeing to pay $37,500 plus 9% Interest annually on the unpaid loan balance each November 1, starting November 1, 2023. Membership rose 3% in 2023. 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 2023. The board has tentative plans to Increase these fees by 10% in 2024. Lesson and class fees 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 2023 to be repeated in 2024. Miscellaneous revenues are expected to grow at the same rate as in 2023. Operating expenses expected to Increase: Hourly wage rates and the manager's salary: 15% Towels and supplies, utilities, and miscellaneous expenses: 25% urod Required: 1. Prepare a cash budget for 2024 for the Triple-F Health Club. (Round your "Growth SS" column answers to 2 decimal places and your remaining answers to nearest whole dollar or percentage amount.) ges TRIPLE-F HEALTH CLUB Cach Budget For the Year Ending Otober 31, 2024 2020 Growth Prio Inoreste 2024 Operating Cash Infows 96 95 Total Operang Cash intows $ 0 $ Operating Cash Outfons: Total Operating Cash Outflows Net Operating Cash Flow 1 - $ Non-Operating Cash Outfions: Total Non-Opersing Cash Outow $ ol Net Cash Flow $ 0 Budgeted Ending Cash Balance $