Can someone explain how you do c and d in excel?

1. total 2 points) Consider a 5-year bond with a face value of $100 that pays interest semiannually at the rate of 4% per year (that is, 2% every six months). (a). (1/2 point) The current price of the bond is $100. What is the yield to maturity of the bond, assuming semi-annual compounding? (b) (1/2 point) Suppose the price of the 5-year bond in part (a) is now $93. What is the yield to maturity of the bond, assuming semi-annual compounding? Hint. You will need to do a trial-and-error" search: use Excel, or Python, or Matlab, or another package or programming language. (c)(1/2) Continuing to assume that the price is $93, what is the Macaulay duration of the bond? (d) (1/2 point) Continuing to assume that the price is $93, what is the modified duration of the bond