Please use the excel file to calculate WACC for Hunting Power Co$.($see

detail information on slide $38$ for chapter $13)$ that we went through in the

video and submit your excel file here. Please lay out your input information

separately and label it clearly.

Given the following information for Huntington Power Co$.,$ find the WACC.

Assume the company's tax rate is $35$ percent.

$10,0005\mathrm{.}6$ percent coupon bonds outstanding, $$1,000$ par

Debt:

value, $25$ years to maturity, selling for $97$ percent of par; the

bonds make semiannual payments.

Common $425,000$ shares outstanding, selling for $$61$ per share; the beta

stock: $,$ is $.95.$

Market: $,7$ percent market risk premium and $3\mathrm{.}8$ percent risk$-$free rate.

Please show formulas in excel