Lessons
- What is Macaulay Duration?
- Duration of a Bond - Video
- Calculating the Macaulay Duration Using Excel
- Properties of Duration
- Modified Duration of a Bond
- Calculating Price and Yield of a Bond Using Zero Curve
- Price-Yield Relationship
- Current Yield of a Bond
- Basis Point Value (BPV / DV01)
- Quick Approximation of Price Value of a Basis Point (PVBP)
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
Finance Train Premium
Accelerate your finance career with cutting-edge data skills.
Join Finance Train Premium for unlimited access to a growing library of ebooks, projects and code examples covering financial modeling, data analysis, data science, machine learning, algorithmic trading strategies, and more applied to real-world finance scenarios.
I WANT TO JOINJOIN 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.