I'm just looking to fill in the excel portion, thanks!!

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. Debt Bonds outstanding Settlement date Maturity date Annual coupon rate Coupons per year Bond price (% of par) Common stock Shares outstanding Beta Share price Market Market risk premium Risk-free rate Tax rate Market value of debt Market value of equity Market value of firm Pretax cost of debt Aftertax cost of debt Cost of equity 100 WACC What is the company's WACC?L