Accessibility tab summary: Students please use the information below to complete the question completing the required cells. Given information for this question is presented in rows $6$ through $27.$ The required answers are in rows $35$ through $46.$

"Given the following information for Lightning Power$$Co$.,$ find the WACC. Assume the company$$s tax rate is $21$ percent.

Debt: $12,000$ bonds with a $4\mathrm{.}6$ percent coupon outstanding, $$1,000$par value, $25$ years to maturity, selling for $105$ percent of par;$$the bonds make semiannual payments.

Common stock: $575,000$ shares outstanding, selling for $$81$ per share; the beta$$is $1\mathrm{.}04.$

Preferred stock: $30,000$ shares of $3\mathrm{.}4$ percent preferred stock outstanding, a $$100$par value, currently selling for $$94$ per share.

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

Input Area:

Tax rate $21\%$

Debt $$

Bonds outstanding $12,000$

Settlement date $1/1/2020$

Maturity date $1/1/2045$

Annual coupon rate $4\mathrm{.}60\%$

Coupons per year $2$

Bond price $(\%$ of par$)105$

Redemption $(\%$ of par$)100$

Par value $($$$)$ $$1,000$

Common stock $$

Shares outstanding $575,000$

Beta $1\mathrm{.}04$

Share price $$81$

Preferred stock outstanding $$

Shares outstanding $30,000$

Coupon rate $3\mathrm{.}40\%$

Par value $$100$

Share price $$94$

Market $$

Market risk premium $7\mathrm{.}00\%$

Risk$-$free rate $3\mathrm{.}20\%$

$($Use cells A$6$ to B$27$ from the given information to complete this question. You must use the built$-$in Excel function to answer this question. Leave the $$Basis$$ input blank in the function. You may enter a constant as a hard coded value.$)$

$$

Output Area:

Market value of debt $$

Market value of equity $$

Market value of preferred $$

Market value of firm $$

Weight of debt

Weight of equity

Weight of preferred

Pretax cost of debt $$

Aftertax cost of debt $$

Cost of equity $$

Cost of preferred $$

WACC