Please show work in excel with formulas

1..The YTM on a bond is the interest rate you earn on your investment if interest rates don't change. If you actually sell the bond before it matures, your realized return is known as the holding period yield (HPY).

a. Suppose that today you buy a Merck 6.4 percent coupon bond making semi-annual payments for $122.78. The bond has 10 years to maturity. What rate of return do you expect to earn on your investment?

b. Two years from now, the YTM on your bond has declined by 1.17 percent, and you decide to sell. What price will your bond sell for? What is the HPY on your investment? Compare this to the YTM when you first bought the bond. Why are they different?