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.