Cash flow budget for the next 12 months

Assignment Help Financial Management
Reference no: EM13868959

Question 1
Suppose you are asked to do a cash flow budget for the next 12 months for a newly opened baby health clinic. The budget must be done on a month-by-month basis. As the clinic has just opened you have no historical accounting data. The clinic is allowed to treat both private (fee paying) and public (no fee charged) patients. Outline the steps you would take, the type of questions you would need to ask and 
any assumptions you would need to make to develop the budget. Highlight the main areas of concern you would have about the accuracy of your forecasts - in particular, would you be more confident about your revenue or expense forecasts?

Question 2 
Cavalier Skilled Nursing Homes is considering setting up a new medical facility. Management estimates that it will cost $1.5 million to purchase the necessary equipment and renovate the building to support its long term care services. The projected net cash flows generated by the new facility over the next five years are given below: 
Year 1      -0- 
Year 2 $380,000 
Year 3 $400,000 
Year 4 $420,000 
Year 5 $440,000
Assuming a five year life and an 8% cost of capital, compute the net present value of this proposal.   On the merits of your net present value computation, should Cavalier Skilled Nursing Homes invest in this project? Explain your answer.

Question 3
Painless Dentists (Painless) expected to treat 6,000 patients during 2011. The practice expected each patient to need an average of 3 X-rays at a cost to Painless of $11 per X-ray. Painless charges Patients $20 for each X-ray. The actual activity reports for 2011 showed that 5,500 patients came to the clinic and received an average of 3.25 X-rays with an average per X-ray cost of $10.50.  For this question 
there is no need to do an adjusted budget, simply do the difference between the actual and budgeted figures.
a. What is Painless' revenue variance? Is the total revenue variance favourable or unfavourable? Why? 
b. What is Painless' expense variance? Is the total expense variance favourable or unfavourable? Why? 
c. Was the net impact of the two variances helpful or harmful to the economic health of the organisation? Why? 

Question 4 
Rotary Hospital's static nursing labour expense budget for the month of November 2012 was $64,800 (1,200 patients * 1.5 nursing labour hours per patient * $36 per nursing labour hour). During the month of November 2012 Rotary Hospital actually 
cared for 1,300 patients. The actual nurse labour expense for the month was $84,175 and 2,275 nursing hours were actually worked.
Calculate Rotary Hospital's total variance between its budget and actual nurse labour expense. How much of this variance was due to:
a. actual patient numbers being different from the budget?
b. the hourly cost of nursing services being different from budget?
c. the number of nursing hours used being different from budget?
d. what factor caused the biggest difference between the actual and budgeted figures?

Question 5 
Better Health Pty. Ltd. is evaluating whether to buy pieces of medical equipment each of which requires an up-front expenditure of $1.5 million. The projects are expected to produce the following net cash inflows:
Year Equipment A Equipment B
1 $500,000 $2,000,000
2 $1,000,000 $1,000,000
3 $2,000,000 $600,000
a. What is the internal rate of return for each piece of equipment?
b. What is the payback period for each machine?
c. What is the net present value of each machine if the cost of capital is 10 per cent? 5 per cent? 15 per cent?
d. Should Better Health buy both machines, only one, or none? Explain your answer.

Question 6
The Adelaide Private Hospital has 3 patient services departments - Adult Medicine, Obstetrics and Pediatrics. It also has 3 patient support departments - administration, Facilities and Finance.
The revenues of the three patient services departments are:
Adult medicine $12 million
Obstetrics $6 million
Pediatrics $2 million
The direct costs of all 6 departments are:
Adult medicine $6 million
Obstetrics $3.6 million
Pediatrics $1.2 million
Administration $1 million
Facilities $4.4 million
Finance $1.8 million
Direct costs of the support departments are allocated to patient services departments using the direct method on the basis of the % of services provided by the support departments to the patient service departments.Table 1 below gives the percentages of support provided by the support departments to both each other and the services departments. For example, 10% of admin's services are provided to the finance department and 20% to obstetrics. 
Table 1 
% of services provided by Admin Facilities Finance 

Services 
provided to 
Admin 0 5 5 
Facilities 10 0 5 
Finance 10 10 0 
Adult Medicine 35 55 50 
Obstetrics 20 10 25 
Pediatriacs 25 20 15 
Total 100 100 100 
a. Allocate the support department overheads to the 3 patient service departments on the basis of the % of services provided.
b. Calculate the profit and loss position for each of the patient service departments and the hospital as a whole.
c. Should the hospital consider closing down any or all of the patient service departments to increase its profitability or reduce its losses? Explain why or why not. 

Reference no: EM13868959

Questions Cloud

Write a short summary of how he used the key components : For your first written assignment, choose one of the first social actions Myles Horton participated in and write a short summary of how he used the four key components of story, shared story, risk-taking, and collective action to promote social ch..
Trinidad company report on its balance sheet : On January 1, 2010, the Hadad Company entered into a consignment agreement with the Trinidad Company. The agreement specifies that the consignee (Trinidad) is to sell the merchandise at a price of 30% above cost.
Find and summarize three cases of research ethics violations : Find and summarize three cases of research ethics violations and their consequences in your area of study(choose your own topic of interest ).
Construct a frequency distribution figure according to apa : Construct a frequency distribution figure according to the APA guidelines found in the APA Style Guide, located in the Student Success Center.
Cash flow budget for the next 12 months : Suppose you are asked to do a cash flow budget for the next 12 months for a newly opened baby health clinic. The budget must be done on a month-by-month basis. As the clinic has just opened you have no historical accounting data. The clinic is allowe..
Why is sovereignty so important for economies development : Why is sovereignty so important for Economies development in Indian Country?
Salaries paid during the year amounted : Salaries paid during the year amounted to $ 580,000; police officers earned an additional $ 12,000 during December that will be paid in January.
Identify the appropriation to be charged : Prepare journal entries to record the following transactions and events applicable to calendar year 2013 identify the appropriation to be charged
The accounts related to the ski park contract : At December 31, 2010, Roko Co. has two fixed price construction contracts in progress. Both contracts have monthly billings supported by certified surveys of work completed. The contracts are:

Reviews

Write a Review

Financial Management Questions & Answers

  Commodity price changes and labor costs

An example of diversifiable risk that a financial manager should ignore when analyzing a project's risk would include: Commodity price changes, Labor costs, Overall stock price fluctuations

  Upfront total after-tax cash cost for this proposed project

Reality Automotive Corp. (“RAC”) manufactures after-market parts for automobiles and trucks (seat belts, windshield wiper blades, floor mats, and truckbed mats). The company is evaluating the expansion of its manufacturing plant to enable it to take ..

  Forecasting interest rates based on prevailing

forecasting interest rates based on prevailing conditions.consider the prevailing conditions for the following factors

  Primary asset classes-equities-fixed income and cash

If you were allocating moneys among the three primary asset classes (equities, fixed income, and cash) what would be the standard allocations for a conservative investor, a moderate investor, and an aggressive investor

  Encompasses the operational financial

Establish five (5) key objectives for Eastman Kodak that encompasses the operational, financial, human resource aspects of the business. Next, argue that each of the established objectives is essential to the success of the company within the Cloud s..

  About the retirement annuity

Funding Jill Moran’s Retirement Annuity: Sunrise Industries wishes to accumulate funds to provide a retirement annuity for its vice president of research, Jill Moran. Ms. Moran by contract, will retire at the end of exactly 12 years. How large a sum ..

  Exercise good financial planning and control

Does your current organization (or an organization you have worked for in the past,) exercise good financial planning and control? Can it be improved? How? Why? Be prepared to cite real life examples as evidence.

  What is the estimated cost of common equity

Booher Book Stores has a beta of 1.1. The yield on a 3-month T-bill is 4.5% and the yield on a 10-year T-bond is 7%. The market risk premium is 5%. What is the estimated cost of common equity using the CAPM? Round your answer to two decimal places

  Let ckdenote a european vanilla call option with strike

let ckdenote a european vanilla call option with strike price k. assume that all options are identical except for

  Using one of the equity standards

Keller works within the City and County of Denver and lives in the suburbs. His employer deducts $6.00 per month from his salary for deposit in the Denver budgetary revenue accounts. Using one of the equity standards, develop an argument making a cas..

  In tax less world with no brokerage coasts

In a tax less world with no brokerage coasts, repurchases and dividends have the same effect on shareholder wealth. In the real world, however, repurchases provide more preferable tax treatment than dividends to ordinary investors. Is it necessary fo..

  Value of the option to wait if the applicable discount rate

Wilson's Antiques is considering a project that has an initial cost today of $10,000. The project has a two year life with cash inflows of $6,500 a year. Should Wilson's decide to wait one year to commence this project; the initial cost will increase..

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