Hi I am having a hard time figuring out how to use the excel function to find present value for this question.

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. 1/1/2000 I 1/1/2013 Settlement date Maturity date Coupon rate Coupons per yearI Face value Yield to maturity 100 520%) Complete the following analysis. Do not hard code values in your answers. PV(D12/D10,D8-D7,1000*D9 PV(rate, nper, pmt, [fvl, [typel) Price