Yan Yan Corp. has $2,000 par value bond outstanding with a coupon rate of 4.9 percent paid semiannually and 13 years to maturity. The yeild of the bond is 3.8 percent. What is the dollar price of the bond?

Settlement date= 1/1/2000

Maturity date = 1/1/2013

coupon rate = 4.90%

coupon per year =2

redemption value (% of par) = 100

Yield to maturity = 3.80%

par value = 2,000

Please answer in excel format: =Price(settlement, maturity, rate, yld, redemption, frequency, [basis])