answer and excel formula please

Task 2: Bond Valuation (Use task 2 in youc excel sheet to answer the question) Yan Corp. has a $1,000 par value bond outstanding with a coupon rate of 6.9 percent paid semiannually and 15 years to maturity. The yield to maturity of the bond is 7.8 percent. Questions: 3. What is the current bond price? (5 point) Answer: Heginbotham Corp. issued 10-year bonds two years ago at a coupon rate of 6.3 percent. The bonds make semiannual payments. These bonds currently sell for $950. Questions: 4. What is the YTM? (10 point)