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

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

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