- 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)
What is Macaulay Duration?
The duration of a fixed income instrument is a weighted average of the times that payments (cash flows) are made. The weighting coefficients are the present value of the individual cash flows.
where PV(t) denotes the present value of the cash flow that occurs at time t.
If the present value calculations are based on the bond’s yield, then it is called the Macaulay duration. Duration is an important concept in bonds. It is a measure of how long in years it takes for the price of a bond to be repaid by its internal cash flows. Bonds with higher durations are more risky and have higher price volatility than bonds with lower durations.
Example:
Calculate the Macaulay Duration for 9%, 5-year bond selling to yield 9% (compounded semi-annually).
| yield | 0.09 | ||
| Period | CF | PV | t*PV/P |
| 0.5 | 4.5 | 4.31 | 0.02 |
| 1 | 4.5 | 4.12 | 0.04 |
| 1.5 | 4.5 | 3.94 | 0.06 |
| 2 | 4.5 | 3.77 | 0.08 |
| 2.5 | 4.5 | 3.61 | 0.09 |
| 3 | 4.5 | 3.46 | 0.10 |
| 3.5 | 4.5 | 3.31 | 0.12 |
| 4 | 4.5 | 3.16 | 0.13 |
| 4.5 | 4.5 | 3.03 | 0.14 |
| 5 | 104.5 | 67.29 | 3.36 |
| 100.00 | 4.13 |
The Macaulay Duration is 4.13 years.
Data Science in Finance: 9-Book Bundle
Master R and Python for financial data science with our comprehensive bundle of 9 ebooks.
What's Included:
- Getting Started with R
- R Programming for Data Science
- Data Visualization with R
- Financial Time Series Analysis with R
- Quantitative Trading Strategies with R
- Derivatives with R
- Credit Risk Modelling With R
- Python for Data Science
- Machine Learning in Finance using Python
Each book includes PDFs, explanations, instructions, data files, and R code for all examples.
Get the Bundle for $29 (Regular $57)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.
