began operations in 2022 in rental quarters. In October 202 (land and building) for $600,0o0, paying $120,000 down an plus 9% interest annually on the unpaid loan balance each N er 1, 2023. ship rose 3% in 2023. The club has experienced approximate ate since it opened and this rate is expected to continue in th ship fees increased by 15% in 2023. The board has tentative 10% in 2024. and class fees have not been increased for 3 years. The boar and lessons by keeping the fees low. The members have take nd the number of classes and lessons has increased significa the percentage growth experienced in 2023 to be repeated heous revenues are expected to grow at the same rate as in g expenses expected to increase:

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
• Other financial information as of October 31, 2023:
Cash in checking account, $7,000.
Petty cash, $300.
Outstanding mortgage balance, $352,000.
Accounts payable arising from invoices for supplies and utilities that are unpaid as of
October 31, 2023, and due in November 2023, $4,500.
• 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 paid on delivery, with the balance due on October 1. This amount had not been
paid as of October 31, 2023. An additional $25,00 (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
$32,000 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%.
Required:
1. Prepare a cash budget for 2024 for the Triple-F Health Club. (Round your "Growth %" column answers to 2
decimal places and your remaining answers to nearest whole dollar or percentage amount.)
Transcribed Image Text:• Other financial information as of October 31, 2023: Cash in checking account, $7,000. Petty cash, $300. Outstanding mortgage balance, $352,000. Accounts payable arising from invoices for supplies and utilities that are unpaid as of October 31, 2023, and due in November 2023, $4,500. • 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 paid on delivery, with the balance due on October 1. This amount had not been paid as of October 31, 2023. An additional $25,00 (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 $32,000 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%. Required: 1. Prepare a cash budget for 2024 for the Triple-F Health Club. (Round your "Growth %" column answers to 2 decimal places and your remaining answers to nearest whole dollar or percentage amount.)
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 Ended October 31
2023
2022
Cash revenues:
$ 379,000
239,200
2,800
$ 300,000
184,000
1,500
$ 485,500
Annual membership fees
Lesson and class fees
Miscellaneous
Total cash revenues
$ 621,000
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
$ 36,000
190,000
$ 40,000
194,000
199,000
20,000
26,000
35,200
4,000
$ 483,000
$ 138,000
150,000
15,500
15,000
37,800
1,500
Miscellaneous
$ 445,800
$ 39,700
Total cash expenditures
Increase in cash
Transcribed Image Text: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 Ended October 31 2023 2022 Cash revenues: $ 379,000 239,200 2,800 $ 300,000 184,000 1,500 $ 485,500 Annual membership fees Lesson and class fees Miscellaneous Total cash revenues $ 621,000 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 $ 36,000 190,000 $ 40,000 194,000 199,000 20,000 26,000 35,200 4,000 $ 483,000 $ 138,000 150,000 15,500 15,000 37,800 1,500 Miscellaneous $ 445,800 $ 39,700 Total cash expenditures Increase in cash
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Financial Reporting in Hyperinflationary Economies
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education