Please show work in detail with excel formula.

PROBLEM 1 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 a consolidated basis, and the tax rate would therefore increase to 35 percent. HCA also would increase the debt capitalization in the Mission Health subsidiary to 40 percent of assets, which would increase its beta to 1.50. HCA estimates that Mission Health if acquired, would produce the following net cash flows to HCA's shareholders (in millions 1 of dollars): 2 Year Free Cash Flows to Equityholders 4 1 $1.30 2 $1.50 5 $1.75 4 $2.00 3 5 and beyond Constant growth at 6% 3 CAN 7 These cash flows include all acquisition effects. HCA's cost of equity is 14 percent, its beta is 1.0, 1 and its cost of debt is 10 percent. The risk-free rate is 8 percent. 2 a. What discount rate should be used to discount the estimated cash flow? (Hint: Use HCA's cost of 3 equity to determine the market risk premium.) 4 b. What is the dollar value of Mission Health to HCA's shareholders? 5 5