XI Calculating a bond price - Excel 7 - X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri Dili M Paste BIU - A A % A Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells Editing Clipboard Font X B D E F G H I J K 1 2 You find a zero coupon bond with a par value of $10,000 and 17 years to maturity. If the yield to maturity on this bond is 4.9 percent, what is the price of the bond? Assume semiannual compounding periods. 4 5 6 7 8 9 TO 11 12 13 14 Settlement date Maturity date Coupon rate Coupons per year Redemption value (% of par) Yield to maturity Par value $ 1/1/2000 1/1/2017 0.00% 2 100 4.90% 10,000 15 Complete the following analysis. Do not hard code values in your calculations. Leave the "Basis" input blank in the function. You must use the built-in Excel function to answer this question. Dollar price 16 17 18 19