Please answer using excel formulas

Red Mountain, Inc. bonds have a face value of $1,000. The bonds carry a 7 percent coupon, pay interest semiannually, and mature in 13.5 years. What is the current price of these bonds if the yield to maturity is 6.82 percent? $1,020.00$1,015.72$1,018.27$989.50$994.56