PLEASE SHOW ANSWER IN EXCEL WITH FORMULA THANKS

Question 2 - Calculate the yield to maturity of the following bond with a par value of $1,000 that pays a 3.9% coupon semiannually. The bond was settled on Jan 1, 2010 and matures on Jan 1, 2032. It currently trades at a price of $972.84 (5 points) Coupon Bond - YTM Settlement date Maturity date Coupon rate Coupons per year Face value % of par) Bond price (% of par) 1/1/10 1/1/32 3.90% 2 100 972.84 YTM 8.66%