Ying Import has several bond issues outstanding, each making semiannual interest payments. The bonds are listed in the following table.

$\backslash$table$[[$Bond$,\backslash$table$[[$Coupon$],[$Rate$]],$Price Quote,Maturity,Face Value$],[1,5\mathrm{.}7\%,105\mathrm{.}46,5$ years,$53,000,000$

Use excel