Question

The board of directors of the Cortez Beach Yacht Club (CBYC) is developing plans to acquire...

The board of directors of the Cortez Beach Yacht Club (CBYC) is developing plans to acquire more equipment for lessons and rentals and to expand club facilities. The board plans to purchase about $64,000 of new equipment each year and wants to begin a fund to purchase a $614,000 piece of property for club expansion.       

The club manager is concerned about the club’s capability to purchase equipment and expand its facilities. One club member has agreed to help prepare the following financial statements and help the manager ascertain whether the plans are realistic. Additional information follows the financial statements.

CORTEZ BEACH YACHT CLUB
Statement of Income (Cash Basis)
For the Year Ended October 31
Year 9 Year 8
Cash revenues
Annual membership fees $ 850,000 $ 614,000
Lesson and class fees 486,200 374,000
Miscellaneous 5,400 4,400
Total cash received $ 1,341,600 $ 992,400
Cash costs
Manager’s salary and benefits $ 86,000 $ 86,000
Regular employees’ wages and benefits 394,000 394,000
Lesson and class employees’ wages and benefits 404,000 314,000
Supplies 34,800 33,800
Utilities (heat and light) 46,800 32,800
Mortgage interest 49,000 54,800
Miscellaneous 5,400 4,400
Total cash costs $ 1,020,000 $ 919,800
Cash income $ 321,600 $ 72,600

  
Additional Information

  1. Other financial information as of October 31, year 9:

    1. Cash in checking account, $21,000.
    2. Petty cash, $1,300.
    3. Outstanding mortgage balance, $888,000.
    4. Accounts payable for supplies and utilities unpaid as of October 31, year 9, and due in November, year 9, $6,400.
  2. The club purchased $64,000 worth of sailing equipment during the current fiscal year (ending October 31, year 9). Cash of $34,000 was paid on delivery, with the balance due on October 1, which had not been paid as of October 31, year 9.
  3. The club began operations in year 3 in rental quarters. In October, year 5, it purchased its current property (land and building) for $1,452,000, paying $268,000 down and agreeing to pay $74,000 plus 5 percent interest annually on the previously unpaid loan balance each November 1, starting November 1, year 6.
  4. Membership rose 3 percent during year 9, approximately the same annual rate of increase the club has experienced since it opened and that is expected to continue in the future.
  5. Membership fees were increased by 13 percent in year 9. The board has tentative plans to increase them by 12 percent in year 10.
  6. Lesson and class fees have not been increased for three years. The number of classes and lessons has grown significantly each year; the percentage growth experienced in year 9 is expected to be repeated in year 10.
  7. Miscellaneous revenues are expected to grow in year 10 (over year 9) at the same percentage as experienced in year 9 (over year 8).
  8. Lesson and class employees’ wages and benefits will increase to $611,650. The wages and benefits of regular employees and the manager will increase 13 percent. Equipment depreciation and supplies, utilities, and miscellaneous expenses are expected to increase 17 percent.


Required:

a. Construct a cash budget for year 10 for Cortez Beach Yacht Club. (Do not round intermediate calculations.)

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Appendix: Adjustment Data on an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business...
Appendix: Adjustment Data on an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business clients. The trial balance for Alert Security Services Co. has been prepared on the following end-of-period spreadsheet for the year ended October 31, 20Y5. In addition, the data for year-end adjustments are as follows: Fees earned but not yet billed, $37. Supplies on hand, $9. Insurance premiums expired, $46. Depreciation expense, $18. Wages accrued but not paid, $18. Enter the adjustment data and place...
First Landing Golf Club Trial Balance December 31, 2018                        Unadjusted Debit Credit Cash  &nb
First Landing Golf Club Trial Balance December 31, 2018                        Unadjusted Debit Credit Cash                15,000 Accounts Receivable - Members                13,000 Allowance for Doubtful Accounts                  1,100 Rent Receivable                         -   Prepaid Insurance                  9,000 Shop Supplies                  3,600 Land             350,000 Buildings             120,000 Accumulated Depreciation - Buildings                40,000 Equipment             150,000 Accumulated Depreciation - Equipment                70,000 Interest Payable Salaries and Wages Payable                         -   Unearned Dues                         -   Note Payable             100,000 Common Stock            ...
  Cash $ 113,718   Petty cash 100   Accounts receivable 39,390   Allowance for doubtful accounts 4,662   Supplies 210...
  Cash $ 113,718   Petty cash 100   Accounts receivable 39,390   Allowance for doubtful accounts 4,662   Supplies 210   Merchandise inventory (48 @ $300) 14,400   Equipment 9,000   Van 27,000   Building 125,000   Accumulated depreciation 28,075   Land 25,000   Sales tax payable 390   Employee income tax payable 1,000   FICA—Social Security tax payable 840   FICA—Medicare tax payable 210   Warranty payable 918   Unemployment tax payable 945   Notes payable—Building 92,762   Bonds payable 50,000   Discount on bonds payable 800   Common stock 50,000   Retained earnings 124,816 I need to Indicate whether...
You have just been contracted as a budget consultant by LBJ Company, a distributor of bracelets...
You have just been contracted as a budget consultant by LBJ Company, a distributor of bracelets to various retail outlets across the country. The company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. You have decided to prepare a cash budget for the upcoming fourth quarter in order to show management the benefits that can be gained from proper cash planning. You have worked with accounting...
Course Project Week 4 For this next part of the project you will build the Income...
Course Project Week 4 For this next part of the project you will build the Income Statement and Balance Sheet for the Bike Repair & Maintenance Shop (BRMS) for 2018. Use the information below and add another sheet to your Excel Workbook. BRMS Information for 2018 In 2017, the repair shop was opened in October and ended the year with a ($10,500) operating loss. Supply Inventory of parts & supplies maintained $3,000 Replacement parts are ordered as they are used....
I completed everything except for the last part. I know my answers are right because i...
I completed everything except for the last part. I know my answers are right because i double checked but i just dont know how to answer the last section. Problem 3-1 Schedule C (LO 3.1) Scott Butterfield is self-employed as a CPA. He uses the cash method of accounting, and his Social Security number is 644-47-7833. His principal business code is 541211. Scott's CPA practice is located at 678 Third Street, Riverside, CA 92860. Scott’s income statement for the year...
Delta airlines case study Global strategy. Describe the current global strategy and provide evidence about how...
Delta airlines case study Global strategy. Describe the current global strategy and provide evidence about how the firms resources incompetencies support the given pressures regarding costs and local responsiveness. Describe entry modes have they usually used, and whether they are appropriate for the given strategy. Any key issues in their global strategy? casestudy: Atlanta, June 17, 2014. Sea of Delta employees and their families swarmed between food trucks, amusement park booths, and entertainment venues that were scattered throughout what would...
What tools could AA leaders have used to increase their awareness of internal and external issues?...
What tools could AA leaders have used to increase their awareness of internal and external issues? ???ALASKA AIRLINES: NAVIGATING CHANGE In the autumn of 2007, Alaska Airlines executives adjourned at the end of a long and stressful day in the midst of a multi-day strategic planning session. Most headed outside to relax, unwind and enjoy a bonfire on the shore of Semiahmoo Spit, outside the meeting venue in Blaine, a seaport town in northwest Washington state. Meanwhile, several members of...
Please answer the following Case analysis questions 1-How is New Balance performing compared to its primary...
Please answer the following Case analysis questions 1-How is New Balance performing compared to its primary rivals? How will the acquisition of Reebok by Adidas impact the structure of the athletic shoe industry? Is this likely to be favorable or unfavorable for New Balance? 2- What issues does New Balance management need to address? 3-What recommendations would you make to New Balance Management? What does New Balance need to do to continue to be successful? Should management continue to invest...
What role could the governance of ethics have played if it had been in existence in...
What role could the governance of ethics have played if it had been in existence in the organization? Assess the leadership of Enron from an ethical perspective. THE FALL OF ENRON: A STAKEHOLDER FAILURE Once upon a time, there was a gleaming headquarters office tower in Houston, with a giant tilted "£"' in front, slowly revolving in the Texas sun. The Enron Corporation, which once ranked among the top Fortune 500 companies, collapsed in 2001 under a mountain of debt...