Learn finance, banking, risk, data science and fintech

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.

Try our courses on Data Science for Finance. JOIN FREE

Leave a Reply

Your email address will not be published. Required fields are marked *

Name *