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

  Appropriate schedule compression technique

This project is in the execution stage of the project. It is behind schedule by 8 weeks; it was scheduled to be completed in 10 weeks. The sponsor is desperate to accomplish something on this project. The budget is limited to the original amount, ..

  What was the beginning balance

What was the beginning balance and evaluate amount of overhead assigned to Job 3 during 2007

  What amount of deferred income tax liability

Stone’s tax rate for 2009 was 40%, and the enacted rate for years after 2009 is 35%. In its December 31, 2009, balance sheet, what amount of deferred income tax liability should Stone report?

  Using the high-low method to estimate the cost

The Chambers Manufacturing Company recorded overhead costs of $16,468 at an activity level of 5,100 machine hours and $10,017 at 2,400 machine hours. The records also indicated that overhead of $10,078 was incurred at 3,050 machine hours. What is the..

  How does disney describe cash and cash equivalents

How does Disney describe cash and cash equivalents

  Illustrate what is the total amount credited to the factory

If the predertimed overhead rate is base on machine hours, illustrate what is the total amount credited to the factory overhead account for the year for carlson?

  Determine the cost and accumulated depreciation of equipment

New equipment purchased during 20x4 totaled $280,000. The 20x4 income statement disclosed equipment depreciation expense of $41,000 and a $9,000 loss on the sale of equipment. Determine the cost and accumulated depreciation of equipment sold during 2..

  Preparation of closing entries and statement of retained

preparation of closing entries and statement of retained earnings.the adjusted trial balance for china tea company at

  Unit product cost on the job cost sheet

Job 412 was one of the many jobs started and completed during the year. The job required $8,800 in direct materials and 45 hours of direct labor time at a total direct labor cost of $9,700. If the job contained four units and the company billed at 60..

  Assuming a flexible budget

The Hernandez Company budgeted for an output of 50,000 units. Budgeted amounts were as follows: direct material, $100,000; direct labor, $50,000; variable factory overhead, $75,000; and fixed factory overhead, $100,000. Assuming a flexible budget,

  Using the cma code of professional ethics for management

Using the CMA Code of Professional Ethics for management accountants, recommend the approach that Emily should take. Suppose Tim insists that his suggested accounting treatment be implemented.

  Illustrate the entire audit process with a short example

Illustrate the entire audit process with a short example of each phase. Determine which phase of the audit process you feel is the most important. Defend your selection.

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