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

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

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