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%.

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

Lesson Resources

This excel calculator helps you to calculate the duration and modified duration of a bond.
Member-only
Membership
Learn the skills required to excel in data science and data analytics covering R, Python, machine learning, and AI.
I WANT TO JOIN
JOIN 30,000 DATA PROFESSIONALS

Free Guides - Getting Started with R and Python

Enter your name and email address below and we will email you the guides for R programming and Python.

Saylient AI Logo

Take the Next Step in Your Data Career

Join our membership for lifetime unlimited access to all our data analytics and data science learning content and resources.