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

Duration Calculator - Use this calculator to calculate the duration and modified duration of a bond.

Series Navigation

Duration of a Bond – VideoProperties of Duration