Calculating the Macaulay Duration Using Excel

Premium

This video takes a simple example and demonstrates how the duration of the bond is calculated 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%.

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

Unlock Premium Content

Upgrade your account to access the full article, downloads, and exercises.

You'll get access to:

  • Access complete tutorials and examples
  • Download source code and resources
  • Follow along with practical exercises
  • Get in-depth explanations