The current stock price for a company is $35 per share, and there are 4 million shares outstanding. The beta for this firms stock is 1.5, the risk-free rate is 4.6, and the expected market risk premium is 6.1%. This firm also has 160,000 bonds outstanding, which pay interest semiannually. These bonds have a coupon interest rate of 9%, 20 years to maturity, a face value of $1,000, and a current price of 1,148.52. If the corporate tax rate is 39%, what is the Weighted Average Cost of Capital (WACC) for this firm? (Answer to the nearest hundredth of a percent, but do not use a percent sign).

Correct Answer:

8.57 0.04

Could you Please put in Excel. Show me how to do it in excel