Calculate current bond price using excel formula and cell numbers.

Settlement date = D7

Maturity date = D8

Coupon rate = D9

Coupons per year = D10

Face value = D11

Yield to Maturity = D12

A1 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 6 Settlement date Maturity date Coupon rate Coupons per year Face value Yield to maturity 1/1/2000 1/1/2013 6.90% 10 902 12 13 14 15 16 17 18 19 20 21 Complete the following analysis. Do not hard code values in your answers. Price . | Sheet1 | +100% Attempt(s)