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?