Calculating the Macaulay Duration Using Excel

This video takes a simple example and demonstrates how the duration of the bond is calculated using excel.  In this example, The bond has a duration of 20 years, and pays annual coupon of 3%. The current market interest rates are 4%.

Duration Calculator

Download the duration calculator to calculate the duration and modified duration of a bond.

Series NavigationDuration of a Bond – VideoProperties of Duration
  • Pingback: Properties of Duration | Finance Train()

  • whitecloud

    For monthly payments with a current rate higher than the coupon rate the duration exceeds the term to maturity. This is impossible.

    • Did you try this in the calculator link provided above?