What value did you choose for the growth rate

Assignment Help Other Subject
Reference no: EM131233607

You do not need to write a memo. Instead, answer the questions below.

Read Case: St. Benedict's Teaching Hospital.

1. Use the data contained in the case to estimate the post-merger cash flows for 2014 through 2018 assuming that Lafayette General Hospital is acquired by St. Benedict's Teaching Hospital. (Note that you have very limited data on which to base your forecasts. The key is to make supportable assumptions about the potential synergies that can be obtained from the merger. Also, note that any cost savings to St. Benedict's that result from the merger must be included in the analysis.) (Hint: Use embedded interest expense in your forecast, but do not include any interest to fund the acquisition.  That means you should input values for interest on current debt but ignore values for interest on required loans. This is because you have not yet establish the purchase price.  Once you do establish that price and pursue merger, interest expenses for required loans will change.) 

a. Paste your Lafayette General Hospital Pro Forma Forecasted Cash Flow statement below.

b. What value did you choose for the growth rate for inpatient revenues? Why?

c. What value did you choose for the growth rate for outpatient revenues? Why?

d. What value did you choose for the long term growth rate?  Why?

e. What value did you choose for patient service expenses as a percent of net patient revenue and why?

f. What share of cash flows would be retained for growth (i.e. Invested in Lafayette rather than available to investors)? Why?

2. Conceptually, what is the appropriate discount rate to apply to the cash flows obtained in Question 1? What is your estimate of the acquisition value to St. Benedicts using the cash flow method? Do you have much confidence in it? This is a brief essay answer justifying your choice of a discount rate

3. Excluding the discount rate, what are the 2 most critical assumptions (from 1b-1f) you made in generating these cash flow estimates?  Holding your assumed discount rate constant, identify the change in your cash flows that would result if you are off in your assumptions by +/- 30% for these two values.    The best way to calculate this is a sensitivity analysis using a 'what if' table.  What does it tell you about the assumptions you are making?

4. What is your estimate of Lafayette General's value using the market multiple valuation technique? What are the strengths and weaknesses of this technique both in general and as applied in this situation? (Remember that there are two bases for this approach, EBITDA and number of discharges.)

5. What is your final conclusion regarding the value of Lafayette General to St. Benedict's? How much should St. Benedict's initially offer for Lafayette General?  What should their target price and their BATNA be?  Why did you choose each number?

6. Assume the hospital is acquired at St. Benedicts target price.  How much of the acquisition would need to be financed with a loan?   (Hint:  Look at the balance sheet and ratios of St. Benedicts to help identify cash available for such a purchase.)  Assuming that, as a non-profit, St. Benedicts can issue tax exempt bonds, what would be the assumed interest rate for such bonds? Input that interest into the spreadsheet "interest on required loans."  How does that affect the cash flows from the purchase?  Does this materially change your answer to 5 (above)?

7. Assume the for profit competitor in the market is likewise evaluating Lafayette for a purchase.  How would their analysis be different than the analysis of St. Benedict?  

8. What are the most important qualitative considerations for considering this merger?  What are the most important qualitative considerations for implementing a merger once the acquisition has been finalized to address questions 1 and 2 on pages 154/155 regarding the acquisition?

Attachment:- Assignment.rar

Reference no: EM131233607

Questions Cloud

Determine the number of such strings : Determine the number of such strings, in which no two consecutive digits are equal. Justify your answer. Determine the number of such strings, in which there is at least one pair of consecutivedigits that are equal. Justify your answer.
What is the second-law efficiency for the total system : A compressor is used to bring saturated water vapor at 1 MPa up to 15 MPa, where the actual exit temperature is 650?C. Find the irreversibility and the second-law efficiency.
Is the author using the toulmin method : Does this essay discuss an issue that is facing you currently? Next, discuss whether or not your essay is peer-reviewed. How do you know? State the claim of the essay. Then, discuss how the author proves this claim. Is the author using the Toulmin..
Can the product of these crushers be processed : Can the product of these crushers be processed to provide the desired sizes in the specified percentages? If so, tell how.
What value did you choose for the growth rate : Paste your Lafayette General Hospital Pro Forma Forecasted Cash Flow statement below. What value did you choose for the growth rate for inpatient revenues? Why? What value did you choose for the growth rate for outpatient revenues? Why
Any old job versus working hard to pursue career : Discuss why it is important for you to do what you’re passionate about in life. Explain why you believe so many people settle for just “any old job” versus working hard to pursue a career that they are personally passionate about. Have you fallen int..
Which emerging contaminants are of concern in water supplies : Which emerging contaminants are of concern in water supplies? Explain how water storage in aquifers relates to water reuse. Identify sustainable practices for water use and wastewater treatment.
What is the turbine inlet pressure : Air enters a steady-flow turbine at 1600 K and exhausts to the atmosphere at 1000 K. The second-law efficiency is 85%. What is the turbine inlet pressure?
Quadratic equation by factoring : What process do you use to factor polynomials when the leading coefficient is not 1 (example: ax2 + bx + c)? How does this differ from factoring polynomials when the leading coefficient is 1 (example: x2 + bx + c)? Is it possible to solve every quadr..

Reviews

len1233607

10/7/2016 4:46:01 AM

Attached is a Healthcare Financial case on a hypothetic merger with financial data. I need the excel model completed and the questions/problems answered. You do not need to write a memo. Instead, answer the questions below. Read Case number 23: St. Benedict’s Teaching Hospital. Download the student spreadsheet for that case. Save it with the convention described in the introduction. You must submit this document and that spreadsheet.

Write a Review

Other Subject Questions & Answers

  Op-ed piece for the strengths and weaknesses

Give the APA reference for the op-ed piece, followed by a brief overview of the issue and of the author's position on the issue. Then offer your evaluation of the Op-Ed piece for the strengths and weaknesses of its evidence.

  Discuss what can cause blunt force trauma

Wounds produced by blunt force are classified as mechanical injuries. Discuss what can cause blunt force trauma and what types of injuries can result

  Which subject to choose for doctorate at university of paris

Suppose you are the educated young man who finished your doctorate at University of Paris in 1250 A.D. What would be subject of your "summa".

  Every organization adheres to certain cultural values

every organization adheres to certain cultural values. sometimes they are obvious sometimes not. frankly some values

  Changing as demand for ethical practices

The need for increasing oversight in psychological research is changing as demand for ethical practices and complexities of research are challenged. Present an overview, based on your readings and outside research, of this phenomenon.

  Historical philosopers that started beginning of formal

Historical philosopers that started the beginning of formal discipline?

  By using your prewriting and the feedback you received from

your topic should be one of these sports either general or types of fans genres of movies television shows or video

  Direct result of a condensation reaction

Which of the following is not formed as a direct result of a condensation reaction?

  Create a systemic cause-and-effect diagram

Assignment: Create a systemic cause-and-effect diagram (CED) with the desired effect of Reducing My Ecological Footprint. Start with the categories: People, Processes, Purchases, Equipment, Measures, and Environment

  Behaviorism and address how his theory has evolved

Skinner's behaviorism and Address how his theory has evolved. What were the influences on this theorist's thinking that led to the development of the concepts in the theory?

  Problem related to the unethical business study

Find an article using the University Library or in the Electronic Reserve Readings that discusses unethical business research conduct that has resulted in individuals or a firm being convicted or at least tried for, this conduct. Some examples inc..

  What issues of transference are displayed by the client

Did the consultant act ethically by allowing the client to be discharged? Discuss. Is it possible that countertransference played a part in how the consultant acted? If so, how? What are the other pitfalls facing consultants in the mental health prof..

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