Ying Import has several bond Issues outstanding, each making semiannual interest

payments. The bonds are listed in the following table.

If the corporate tax rate is $24$ percent, what is the aftertax cost of the company's debt?

$($Do not round Intermedlate calculations and enter your answer as a percent rounded

to $2$ decimal places, e$.$g$.,32\mathrm{.}16.)$

Answer is complete but not entirely correct.

Step by step please. Excel is okay too.