1. Compute the current bond price. Bond Prices-Excel HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calitri B 1-ea. e-A. Alignment Number Conditional Format as. Cell Cells Editing Formatting Table Styles Styles Clipboard Font Al E F Ninja Co. issued 14-year bonds a year ago at a coupon rate of 6.9 percent. The bonds make semiannual payments. If the YTM on these bonds is 5.2 percent, what is the current bond price in dollars? Assume a par value of $1,000 Settlement date Maturity date Coupon rate Coupons per year Face value Yield to maturity 1/1/2000 1/1/2013 6.90% 2 900 5.20% 10 12 13 15 16 17 18 Complete the following analysis. Do not hard code values in your answers. Price