Question

PLEASE SHOW WORK USING EXCEL SPREADSHEET HCA HealthCare is considering an acquisition of Mission Health. Mission...

PLEASE SHOW WORK USING EXCEL SPREADSHEET

HCA HealthCare is considering an acquisition of Mission Health. Mission Health is a publicly traded company, and its current beta is 1.30. Mission Health has been barley profitable and had paid an average of only 20% in taxes during the last several years. In addition, it uses little debt, having a debt ration of just 25%. If the acquisition were made, HCA would operate Mission Health as a separate, wholly owned subsidiary. Mission Health would pay taxes on a consolidated basis, and the tax rate would therefore increase to 35%. HCA also would increase the debt capitalization in the Mission Health subsidiary to 40% of assets, which would increase its beta to 1.5. HCA estimates that Mission Health, if acquired, would produce the following net cash flows to HCA's shareholders (in millions of dollars):

Year

Free Cash Flows to Equityholders

1

$1.30

2

$1.50

3

$1.75

4

$2.00

5+

constant growth rate at 6%

These cash flows include all acquisition effects. HCA's cost of equity is 14%; its beta is 1.0; and its cost of debt is 10%. The risk free rate is 8%

A. What discount rate should be used to discount the estimated cash flow? (Hint: Use HCA's cost of equity to determine the market risk premium)

B. What is the dollar value of Mission Health to HCA's shareholders?

Homework Answers

Answer #1

A.

HCA cost of equity = 14

cost of equity = risk free rate + market risk premium *beta

14 = 8 + MRP*1

MRP = 6

Cost of equity for Mission helath = 8 + 6 *1.50 = 17%

discount rate used to discount the cash flows = weighted average cost of capital

=0.4* 10 * ( 1 - 0.35) + 0.6*17

= 12.80%

B.

FCFF for year 5 = 2*1.06 = 2.12

Present value of cash flows = present value of cash flows from year 1 to 4 + present value of terminal value

terminal value = FCFF for year 5 / ( wacc - growth rate )

= 2.12 / ( 0.128 -0.06) = 31.18

Dollar value of Mission Health to HCA's shareholders = 1.3 /1.128 + 1.5/1.128^2 + 1.75/1.128^3 + 2/1.128^4 + 31.18/1.128^4

= 24.05 million

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
HCA Healthcare is considering an acquisition of Mission Health. Mission Health is a publicly traded company,...
HCA Healthcare is considering an acquisition of Mission Health. Mission Health is a publicly traded company, and its current beta is 1.30. Mission Health has been barely profitable and had paid an average of only 20 percent in taxes during the last several years. In addition, it uses little debt, having a debt ratio of just 25 percent. If the acquisition were made, HCA would operate Mission Health as a separate, wholly owned subsidiary. Mission Health would pay taxes on...
ABC is considering an acquisition of XYZ. XYZ has a capital structure of 60% debt and...
ABC is considering an acquisition of XYZ. XYZ has a capital structure of 60% debt and 40% equity, with a current book value of $15 million in assets. XYZ’s pre-merger beta is 1.26 and is not likely to be altered as a result of the proposed merger. ABC’s pre-merger beta is 1.02, and both it and XYZ face a 40% tax rate. ABC’s capital structure is 50% debt and 50% equity, and it has $34 million in total assets. The...
. ABC is considering an acquisition of XYZ. XYZ has a capital structure of 60% debt...
. ABC is considering an acquisition of XYZ. XYZ has a capital structure of 60% debt and 40% equity, with a current book value of $15 million in assets. XYZ’s pre-merger beta is 1.36 and is not likely to be altered as a result of the proposed merger. ABC’s pre-merger beta is 1.02, and both it and XYZ face a 40% tax rate. ABC’s capital structure is 50% debt and 50% equity, and it has $34 million in total assets....
Suppose that Ret is considering the acquisition of another firm in its industry for $100 million....
Suppose that Ret is considering the acquisition of another firm in its industry for $100 million. The acquisition is expected to increase Ret’s free cash flow by $5 million the first year, and this contribution is expected to grow at a rate of 3% every year thereafter. Ret currently maintains a debt to equity ratio of 1, its corporate tax rate is 21%, its cost of debt rD is 6%, and its cost of equity rE is 10%. Ret will...
Suppose that Rose Industries is considering the acquisition of another firm in its industry for $100...
Suppose that Rose Industries is considering the acquisition of another firm in its industry for $100 million. The acquisition is expected to increase Rose's free cash flow by $5 million the firs year, and this contribution is expected to grow at a rate of 3% every year there after. Rose currently maintains a debt to equity ratio of 1, its marginal tax rate is 40%, its cost of debt rD is 6%, and its cost of equity rE is 10%....
Question 1 Company A plans to acquire Company B. The acquisition would result in incremental cash...
Question 1 Company A plans to acquire Company B. The acquisition would result in incremental cash flows for Company A of R15 million in each of the first five years. Company A expects to divest from Company B at the end of the fifth year for R100 million. The beta for Company A is 1.1, which is expected to remain unchanged after the acquisition. The risk-free rate, Rf, is 7 percent, and the expected market rate of return, Rm, is...
Simon Corporation is considering the acquisition of Ingram Company. Ingram has a capital structure consisting of $7.5 million (market value) of 11% bonds and $15 million (market value) of common stock.
Simon Corporation is considering the acquisition of Ingram Company. Ingram has a capital structureconsisting of $7.5 million (market value) of 11% bonds and $15 million (market value) of common stock.Ingram's pre-merger beta is 1.36. Simon's beta is 1.02, and both it and Ingram face a 40% tax rate.Simon's capital structure is 40% debt and 60% equity. The free cash flows from Ingram are estimated to be$4.5 million for each of the next 4 years and a horizon value of $15...
Penn Corp. is analyzing the possible acquisition of Teller Company. Both firms have no debt. Penn...
Penn Corp. is analyzing the possible acquisition of Teller Company. Both firms have no debt. Penn believes the acquisition will increase its total aftertax annual cash flows by $3 million indefinitely. The current market value of Teller is $48 million, and that of Penn is $90 million. The appropriate discount rate for the incremental cash flows is 10 percent. Penn is trying to decide whether it should offer 45 percent of its stock or $73 million in cash to Teller's...
Mr. Gatti’s Pizza, a regional pizza chain, is considering purchasing a smaller chain, CiCi’s Pizza, which...
Mr. Gatti’s Pizza, a regional pizza chain, is considering purchasing a smaller chain, CiCi’s Pizza, which is currently financed with 20 percent debt at a cost of 6%. Mr. Gatti's analysts project that the purchase will result in incremental free cash flows and interest tax savings. The acquisition would be made immediately, if it were undertaken. CiCi's pre-merger beta is estimated to be 2.1, and its post-merger tax rate would be 28 percent. The risk-free rate is 1 percent, and...
Penn Corp. is analyzing the possible acquisition of Teller Company. Both firms have no debt. Penn...
Penn Corp. is analyzing the possible acquisition of Teller Company. Both firms have no debt. Penn believes the acquisition will increase its total after-tax annual cash flows by $3.1 million indefinitely. The current market value of Teller is $78 million, and that of Penn is $135 million. The appropriate discount rate for the incremental cash flows is 12 percent. Penn is trying to decide whether it should offer 40 percent of its stock or $94 million in cash to Teller’s...