P$14-9$M $($changes from the text are in bold$)$

Temple$-$Midland, Inc., is issuing a $$1,000$ par value bond that pays $4\mathrm{.}5$ percent annual interest and matures in $10$ years. Investors are willing to pay $$975$ for the bond, and Temple faces a tax rate of $27$ percent. What is Temple's after$-$tax cost of debt on the bond where interest is paid semiannually?

Cost of Debt

Coupon rate

Par $($FV$)$

Years $($n$)$

$m$

PMT

PV $($price$)$

YTM $($Before Tax Cost of Debt$)$

Tax Rate

After Tax Cost of Debt

Please solve for Excel