Duration Excel Project

Please use Excel to complete the problem below.


  • What is the duration of a 5-year, 5% semi-annual bond if the market rate on bonds of similar quality is 5.1%?
  • Now suppose that the yield to maturity has changed to 5.05%.Using Macaulay duration, what is the approximate percent change in the price of the bond? (You do not need to recalculate Macaulay duration using 5.81%.Use the duration value that you found in Problem 1.)

Do the problem including convexity

“Order a similar paper and get 15% discount on your first order with us
Use the following coupon

Order Now