Looking to solve in Excel. Please show work.

1. What is the market interest rate on Harry Daviss debt, and what is the component cost of this debt for WACC purposes?

2. Harry Davis doesnt plan to issue new shares of common stock. Using the CAPM approach, what is Harry Daviss estimated cost of equity?

3. What is the estimated cost of equity using the discounted cash flow (DCF) approach?

4.Suppose the firm has historically earned 10% on equity (ROE) and retained 50% of earnings, and investors expect this situation to continue in the future. How could you use this information to estimate the future dividend growth rate, and what growth rate would you get? Is this consistent with the 4.5% growth rate given earlier?

5. What is the cost of equity based on the bond-yield-plus-judgmental-risk-premium method?

6. What is your final estimate for the cost of equity, r_s?

7. What is Harry Daviss weighted average cost of capital (WACC)?

During the last few years, Harry Davis Industries has been too constrained by the high cost of capital to make many capital investments. Recently, though, capital costs have been declining, and the company has decided to look seriously at a major expansion program that has been proposed by the marketing department. Assume that you are an assistant to Leigh Jones, the financial vice-president. Your first task is to estimate Harry Davis's cost of capital. Jones has provided you with the following data, which she believes may be relevant to your task The firm's tax rate is 35% The current price of Harry Davis's 6% coupon, semiannual payment, noncallable bonds with 15 years remaining to maturity is $1,065.27. Harry Davis does not use short-term interest-bearing debt on a permanent basis. New bonds would be privately placed with no flotation cost Harry Davis's common stock is currently selling at $50 per share. Its last dividend (Do) was $2.75, and dividends are expected to grow at a constant rate of 4.5% in the foreseeable future. Harry Davis's beta is .75, the yield on T-bonds is 4.9%; and the market risk premium is estimated to be 8%. For the over-own- bond-yield-plus-judgmental-risk-premium approach, the firm uses a 3.7% judgmental risk premium Harry Davis's target capital structure is 30% long-term debt and 70% common equity