(10 points) Carlson Corporation finances its capital needs with 20% long term debt and 80% equity. Carlsons outstanding debt carries a coupon rate of 7.5%, and as of now has a yield to maturity of 3.8%. By comparison, the yield to maturity on short term U.S. Treasury Bills is currently 0.5%. The beta coefficient for Carlson Corporations equity was recently estimated to be 0.6. Historically, returns on short term treasuries have averaged 3.5% per year. The expected return on the overall market for upcoming years is 7.5%.

Carlson is considering going into the widget production business, where it has not operated before. Carlsons analysts have estimated in light of Carlsons funding methods and the competitive nature of the widget business that the beta of the widget cash flows will be 1.1. Carlsons marginal tax rate is 35%.

(a) (3 points) Which of the two beta estimates described above is relevant for computing the NPV of the widget production proposal, and why (Please explain in detail as it has to wrt NPV)?

(b) (3 points) Provide and interpret an estimate of the cost of capital (expected return) for Carlsons equity investment in the widget business.

(c) (4 points) Provide an estimate of the weighted average cost of capital for Carlsons overall investment in the widget business. What is the purpose of obtaining this estimate?

PLEASE PROVIDE EXCEL AND ACTUAL FORMULA