In excel formula please!

. Formatting" Table Styles Styles Clipboard Font D18 v . A B D E F G H 1 --- K 1 2 3 4 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. 5 6 7 8 9 Settlement date Maturity date Coupon rate Coupons per year Face value Yield to maturity 10 11 12 13 14 1/1/2000 1/1/2013 6.90% 2 100 5.20% 15 Complete the following analysis. Do not hard code values in your answers. 16 17 18 19 20 21 Sheet1 READY GINODE