10. McCurdy Co.'s Class Q bonds have a 12-year maturity, $1,000 par value, and a 5.75% coupon paid semiannually (2.875% each 6 months), and those bonds sell at their par value. McCurdy's Class P bonds have the same risk, maturity, and par value, but the P bonds pay a 5.75% annual coupon. Neither bond is callable. At what price should the annual payment bond sell?

If there is a way to do this in Excel, please show how so I can do it myself.