Prepare a cash basis budgeted income statement

Assignment Help Financial Accounting
Reference no: EM131165529

Given the Case Study Answer the following Questions:

Requirements:
(1) Prepare a cash basis budgeted income statement for the fiscal year ending June 30, 2016 (use the statement included above for a format example).

(2) Prepare a cash budget for the fiscal year ending June 30, 2016. Your cash budget should be set up as follows:

(3) Prepare a memo to the golf club membership detailing if you believe the expansion is a reasonable goal based on the cash budget you have prepared. Be sure to provide specific information to support your conclusion.

Rolling Green Golf Course is member-owned golf club and contemplating expanding its golf course in the  upcoming year. Rolling Green operates on a fiscal year with a year ending date of June 30th . You have been hired to evaluate their budgeted information for the fiscal year ending June 30, 2016 to see if their expansion plan is reasonable.

Expansion plans for the fiscal year ending June 30, 2016 include new golf carts of $25,000 and additional land purchase of $500,000.
The following cash basis income statement has been prepared for your use. This income statement contains only the receipts and disbursements where cash was received or paid. This statement does not include any non-cash expenses such as depreciation.

The following information is also provided for your use:
(1) Account balance as of June 30, 2015 include:
a. Cash in the bank of $12,500
b. Petty cash on hand of $500
c. Outstanding mortgage balance of $1,020,000
d. Accounts payable for supplies and utilities of $6,000 which will be paid in July 2015

(2) Some additional golf carts were purchased in June 2015 for $35,000. Of this, $10,000 was paid when the carts were delivered in June 2015. The balance owed of $25,000 will be paid in August 2015. This purchase does not affect the planned golf cart purchases for the upcoming fiscal year.

(3) The club purchased additional property to expand it course on June 1, 2011. The value of property at the time of purchase was $1,500,000. A down payment of $200,000 was made on this property at the  time of purchase. A mortgage was taken for the remainder. Rolling Green pays $70,000 principal plus 6% interest annually on the previously unpaid loan balance each June 1st, beginning June 1, 2012.

(4) The following increases are expected for the fiscal year ending June 30, 2016:
a. Membership is expected to increase by 1%.
b. Membership fees are expected to increase by 5%.
c. Golf lesson fees are expected to increase the same amount for fiscal year ending June 30, 2016 as they did for fiscal year ended June 30, 2015.
d. Miscellaneous revenues are expected to increase the same amount for fiscal year ending June 30, 2016 as they did for fiscal year ended June 30, 2015.
e. Golf pro wages will increase to $500,000. The golf pro teaches all golf lessons.
f. Club staff wages will increase by 15% over the prior fiscal year.
g. Management salaries will increase by 20% over the prior fiscal year.
h. Utilities, Supplies, and Miscellaneous expenses will increase by 20% over the prior fiscal year.

Attachment:- Case-rolling Green golf course.rar

Reference no: EM131165529

Questions Cloud

What role should the church have concerning treatment : What do you believe are the most important components of effective treatment for substance abuse and addiction? Do you believe medications could/should be used as part of the treatment process? Provide support for the basis of your beliefs using s..
Federal government regulation : List and support your choice of one industry where there is too much federal government regulation and one industry where there is not enough federal government regulation.
Identify the areas of consumers surplus and producer surplus : Draw a supply and demand graph and identify the areas of consumers surplus and producer surplus. Given the demand curve, what impact will an increase in supply have on the amount of consumer surplus shown in your diagram? Problem: Refer to Table 4.2...
Federal government regulation and industry : List and support your choice of one industry where there is too much federal government regulation and one industry where there is not enough federal government regulation.
Prepare a cash basis budgeted income statement : Prepare a cash basis budgeted income statement for the fiscal year ending June 30, 2016- Prepare a cash budget for the fiscal year ending June 30, 2016.
Determine five of the controllers monitored variables : Determine five of the controller's monitored and controlled variables. Describe each variable and explain how it is used in the system. Propose five mode classes and five terms that may be helpful in monitoring this system.
Draw from the instructional material : Draw from the instructional material and your personal as well as professional experiences to answer the Discussion questions below on the Discussion topic. Remember that this is a Discussion. Explain your opinions and support your positions as su..
Estimating the different probabilities : How would you go about estimating the different probabilities of three alternatives occurring if you have little empirical data on which to base your estimates?
What are the two types of inflation : What are the two types of inflation? Of these two, which is one is usually the cause behind rising prices? What empirical evidence can be provided for the previous conclusion? Why would government expenditures (spending) into the circular flow not ge..

Reviews

Write a Review

Financial Accounting Questions & Answers

  Fixed manufacturing costs are written off as current expense

Fixed manufacturing costs are written off as current expenses of the period in which they occurred when using -------- costing. When inventory costing system is NOT acceptable for financial reporting purposes? Which of the following would Not be rele..

  Identify the roles and objectives of fasb and iasb

Identify the roles and objectives of FASB and IASB and what are the main reasons for this joint project under taken by FASB and IASB?

  What percentage of sales can newkirk pay

What percentage of sales can Newkirk pay as royalty to the stadium and earn $180,000 for the season and Newkirk bids 12 percent of sales, what income can he expect?

  The solvency of the subsidiary

In terms of the rules applying to a section 332 parent-subsidiary liquidation, comment on each of the following: The parent corporation's ownership interest in the subsidiary. The solvency of the subsidiary.

  How might a company reduce its cash conversion cycle

Why might a company want to reduce its cash conversion cycle - How might a company reduce its cash conversion cycle?

  Determine the amount of merchandise inventory lost

Complete the Balance Sheet using the information on the Post Closing Trial Balance and determine the amount of Merchandise Inventory lost and prepare the entry to write off the lose.

  General ledger entry to record the purchase of materials

The general ledger entry to record the purchase of materials is:

  Exchange lacked commercial substance

A machine cost $240,000, has annual depreciation expense of $48,000, and has accumulated depreciation of $120,000 on December 31, 2014. On April 1, 2015, when the machine has a fair value of $96,000, it is exchanged for a similar machine with a fair ..

  What type of working capital restructuring can the firm do

Calculate the firm's total operating cycle for 2005 and 2006 - what type of working capital restructuring can the firm do to turn around its performance?

  Calculate abercrombie and fitchs and aeropostale quick ratio

Calculate Abercrombie & Fitch's and Aeropostale's quick ratio and cash ratio for the years ended February 3, 2007, and January 28, 2006.

  What is desired inventory

Company projects the next period sales will be 12,000 units. Company desires ending inventory equal to 20% of next month's sales. What is desired inventory? Also, if the beginning inventory is 100, and the current months sales are 14,000, what is the..

  Determine direct materials efficiency usage variance

Determine Direct materials efficiency (usage) variance and Direct materials joint price-quantity variance (defined as: (AP-SP) x (AQ-SQ)).

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd