You intend to purchase a 10-year, $1,000 face value bond that pays interest of $55 every 6 months.If your nominal annual required rate of return is 10 percent with semiannual compounding, how much should you be willing to pay for this bond? How do I solve this in Excel?