Please Fill out on on excel and show formulas. TIA

You are given the following information for Huntington Power Co. Assume the company's tax rate is 40 percent. ( 4 points) Debt 10,000 outstanding, 7.7 percent coupon bonds outstanding, $1,000 par value, 15 years to maturity, selling for 106 percent of par, the bonds make semiannual payments. Common stock 490,000 shares outstanding, selling for $67 per share, the beta is 1.10. Market 8 percent market risk premium and 5.70 percent risk-free rate. What is the company's WACC? Market value of debt Market value of equity Market value of firm Pretan cost of debt Aftertan cost of debt Cost of equity WACC You are given the following information for Huntington Power Co. Assume the company's tax rate is 40 percent. ( 4 points) Debt 10,000 outstanding, 7.7 percent coupon bonds outstanding, $1,000 par value, 15 years to maturity, selling for 106 percent of par, the bonds make semiannual payments. Common stock 490,000 shares outstanding, selling for $67 per share, the beta is 1.10. Market 8 percent market risk premium and 5.70 percent risk-free rate. What is the company's WACC? Market value of debt Market value of equity Market value of firm Pretan cost of debt Aftertan cost of debt Cost of equity WACC