please wlak me through this using excel and any formaulas used

13 Consider Bond sider the following bonds: Coupon Rate (annual payments) Maturity (years) 0% 4% 6% 10% a. What is the percentage change in the price of each bond if its yield to maturity falls from 7% to 6%? D. Which of the bonds A-D is most sensitive to a 1% drop in interest rates from 7% to 6% and why? When bond is least sensitive? Provide an intuitive explanation for your