12.0 - Prices of annual bond -v- semiannual bond. Use Excel to solve the following problem. Please show all Excel commands / arguments.

McCurdy Co's Class Q bonds have 12-year maturity, a $1,000 par value, and a 11% coupon paid semiannually (5.5% every 6 months), and those bonds sell at their par value. McCurdy Co's Class P bonds have the same risk, maturity, and par value, but the P bonds pay a 11% annual coupon. Neither bond is callable. What is the selling price of the semiannual bond? What is the selling price of the annual bond?