please show work not just excel

A $5,000 bond with a coupon rate of 6.7% paid semiannually has four years to maturity and a yield to maturity of 7%. If interest rates fall and the yield to maturity decreases by 0.8%, what will happen to the price of the bond? A. The price of the bond will rise by $194.5. B. The price of the bond will rise by $138.93. C. The price of the bond will fall by $138.93. D. The price of the bond will fall by $166.72