May you answer question using Excel? Cost of debt. Kenny Enterprises has just issued a bond with a par value of $$1,000,$ a maturity of

twenty years, and a coupon rate of $10\mathrm{.}4\%$ with semiannual payments. What is the cost of debt for Kenny

Enterprises if the bond sells at the following prices? What do you notice about the price and the cost

of debt?

a$.$ $$954\mathrm{.}95$

b$.$ $$1,000\mathrm{.}00$

c$.$ $$1,048\mathrm{.}58$

d$.$ $$1,141\mathrm{.}06$