MUST use excel

Yan Yan Corp. has a $2,000 par value bond outstanding with a coupon rate of 4.9 percent paid semiannually and 13 years to maturity. The yield to maturity of the bond is 3.8 percent. What is the dollar price of the bond? 1/1/2000 1/1/2013 4.90% Settlement date Maturity date Coupon rate Coupons per year Redemption value (% of par) Yield to maturity Par value 100 3.80% 2,000 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