Please use excel and excel formuals to solve the following problems $H20$

$1$

A

$2$

$3$

$4$

$5$

$6$

$7$

$8$

$9$

$\mathrm{.}10$

$11$

$12$

$13$

$14$

$15$

$15$

$17$

$18$

$19$

$20$

$\frac{21}{21}$

$22$

$23$

$24$

$25$

$26$

$27$

$28$

$29$

$30$

$31$

$32$

$33$

$34$

$35$

$36$

$37$

$38$

$39$

$40$

$41$

$42$

$43$

$44$

$45$

$46$

$47$

$48$

market price

Dividend $($year $0)$

growth rate

D$1$

a$.$

Cost of Common Equity

b$.$ Cost of debt: Now let's assume that Torch's bonds are frequently traded. A Torch bond has a $$1,000$ par value $($face value$)$ and a coupon interest rate of $7$ percent that is paid semiannually. The bonds are currently selling for $$1,150$ and will mature in $20$ years. Torch's corporate tax rate is $28$ percent.

c$.$ Cost of preferred stock: Torch's preferred stock pays an $7\mathrm{.}5$ percent dividend on a $$100$ par value. However, the market price at which the preferred shares could be sold is only $$90.$

Cost of Common Equity

b$.$

Cost of Debt

Par

Coupon

Maturity $($n$)$

Compounding $($m$)$

Market Price

Tax Rate

Cost of Debt

After$-$tax Cost of Debt

c$.$

Cost of Preferred Stock

Market price

Parvalue

Dividend rate

Cost of Preferred Stock $$