On this page is a bond duration calculator. It will compute the mean bond duration measured in years (the Macaulay duration), and the bond’s price sensitivity to interest rate changes (the modified duration). You can input either the market yield or yield to maturity, or the bond’s price, and the tool will compute the associated durations.
Macaulay and Modified Bond Duration Calculator
Duration Calculator Inputs
This bond duration tool can calculate the Macaulay duration and modified duration based on either the market price of the bond or the yield to maturity (or the market interest rate) of the bond. Since you’ll have one or the other, choose the easier path to compute the duration.
Compute Duration Based on Market Price of a Bond
If you have all of the details of the bond and know the market price, click the blue «You Know Market Price» button.
Calculator Inputs
- Current Bond Trading Price ($) — The bond’s trading price on the secondary market. (If it’s new, match the par value you enter below.)
- Bond Face Value/Par Value ($) — The face or par value of the bond.
- Years to Maturity — How many years are left until the bond matures.
- Annual Coupon Rate (%) — The annual interest rate paid on the bond’s face value.
- Coupon Payment Frequency — How often the bond pays interest per year.
Calculator Outputs
- Yield to Maturity (%): The yield until the bond matures, as computed by the tool. See the yield to maturity calculator for more details.
- Macaulay Duration (Years) — The weighted average time (in years) for the bond’s cash flows to pay out.
- Modified Bond Duration (Δ%/1%) — The sensitivity of the bond’s trading price to the market interest rate. Measured in percentage change (in price) per percentage change (in interest rate/yield to maturity).
Compute Duration Based on Market Yield (or YTM) of a Bond
If you have all of the details of the bond and know the market yield or the bond’s yield to maturity, use the «You Know Yield to Maturity» option.
Calculator Inputs
- Bond Face Value/Par Value ($) — The face or par value of the bond.
- Years to Maturity — How many years are left until the bond matures.
- Annual Coupon Rate (%) — The annual interest rate paid on the bond.
- Yield to Maturity (Market Yield) (%) — The yield of the bond if held until maturity (assuming no missed payments), as implied by the market.
- Days Since Last Bond Payout — How many days ago was the last payment made? (0 means no accrued interest — see the bond pricing calculator for more information.)
- Coupon Payment Frequency — How often the bond pays interest annually.
Calculator Outputs
- Current Market Price ($): The market price or implied price of the bond.
- Macaulay Duration (Years) — Weighted average time for the bond’s cash flows to pay out, measured in years.
- Modified Bond Duration (Δ%/1%) — Sensitivity of the bond’s price to the yield to maturity. Measured in percentage price change per unit interest rate change.
What is the Macaulay Duration?
The Macaulay duration of a bond is the weighted average payout of the bond, measured in years. Practically, a longer Macaulay duration shows at a glance (and relative to another bond) a bond’s interest rate risk. Longer duration bonds are more volatile – they are more sensitive to interest rate changes. It was first introduced by Frank Macaulay.
Formula for Macaulay Duration
The Macaulay duration formula (written as a series) is:
\frac{ 1*\frac{Payment_1}{(1+yield)^1} + 2*\frac{Payment_2}{(1+yield)^2} +...+ (n-1)*\frac{Payment_{n-1}}{(1+yield)^{n-1}} + n*\frac{Payment_n+Par\ Value}{(1+yield)^n} } {Current\ Price}
Where:
- Payment_x: The payout of the bond at point x
- Par Value: The payout at maturity when the bond matures, or the par or face value
- n: The total number of bond payouts in the future (assuming no missed payment)
- yield: The yield of the bond at point x (remember yields are often annualized, this yield must be adjusted for periods per year)
- Current Price: The market price of the bond (if you only know yield to maturity, you can work this out. See the yield to maturity calculator)
From the series, you can see that a zero coupon bond has a duration equal to it’s time to maturity – it only pays out at maturity.
Example: Compute the Macaulay Duration for a Bond
Let’s compute the Macaulay duration for a bond with the following stats:
- Per Value: $1000
- Coupon: 5%
- Current Trading Price: $960.27
- Yield to Maturity: 6.5%
- Years to Maturity: 3
- Coupon Payouts: One a Year
\frac{ 1*\frac{50}{(1+.065)^1}+2*\frac{50}{(1+.065)^2}+3*\frac{50 + 1000}{(1+.065)^3} }{960.27} = \\~\\ \frac{46.948 + 88.166 + 2607.72}{960.27} = \\~\\ 2742.834/960.27 = 2.856\ years
For this bond, the Macaulay duration is 2.856 years, heavily weighted towards maturity (3 years).
What is the Modified Duration?
The modified duration of a bond is a measure of the sensitivity of a bond’s market price to a change in interest rates. It’s the percentage change of a bond’s price based on a one percentage point move in market interest rates. Bond prices move in an inverse direction from interest rates. For a one percent increase in interest rates, the bond’s market price will decrease by the percentage shown by the modified duration. For a one percentage point decrease in interest rates, the bond price will increase by the percentage shown by the modified duration.
Modified Duration Formula
The modified duration formula is:
\frac{Macaulay\ Duration}{1+\frac{YTM}{Annual\ Payments}}
Where:
- Macaulay Duration: The duration of the bond as measured in years (see how to compute it above)
- YTM: The calculated yield to maturity of the bond
- Annual Payments: How many coupon payments the bond makes a year
Example: Compute the Modified Duration for a Bond
Let’s extend the above example (from the Macaulay section) for a bond with the following characteristics:
- Per Value: $1000
- Coupon: 5%
- Current Trading Price: $960.27
- Yield to Maturity: 6.5%
- Years to Maturity: 3
- Coupon Payouts: One a Year
- Macaulay Duration: 2.856 years
\frac{2.856}{1+\frac{.065}{1}}=\\~\\2.856/1.065 =\\~\\2.682
Remember, the modified duration is a measure of sensitivity to interest rate changes at a point in time. Here’s the relationship:
- Interest rate/yield to maturity increases by 1%: bond price decreases by 2.682%
- Interest rate/yield to maturity decreases by 1%: bond price increases by 2.682%
Outputs for the example bond.
Bond Convexity
Bond duration is a linear estimate of a bond’s price sensitivity to changes in market yield. It’s the first derivative of price with respect to market yield. However – the relationship between yield and price isn’t linear, it’s a curve. Bond convexity is the second derivative, and a measure of the «curvedness» of the relationship. Here’s how the price estimate looks for the example bond in this post: The duration-based estimate is in blue, the convexity estimate in green The difference is slight – for small changes in yield – but it is real. Using convexity gives you a better measure.
Why Know a Bond’s Duration (Plus Other Bond Basics)
Duration helps you understand, at a glance, how sensitive your bond portfolio is to interest rate changes. Shorter duration bonds will be relatively price stable; they will pay out most of their promised cash flow in the near future. Longer duration bonds are less stable; long duration bonds have all the risk of taking longer to pay out their funds, including a shift in the market’s demanded yield. So, to insulate yourself from interest rate risk pick shorter duration bonds. If you want to take on more interest rate risk, pick longer. (You can also compute the Macaulay and modified duration of an entire portfolio by summing cash flow). For other bond calculators, check out the following:
- Bond Yield to Worst Calculator
- Bond Yield to Call Calculator
- Bond Yield to Put Calculator
- Bond Current Yield Calculator
- Tax Equivalent Yield Calculator
PK
PK started DQYDJ in 2009 to research and discuss finance and investing and help answer financial questions. He’s expanded DQYDJ to build visualizations, calculators, and interactive tools. PK is in his mid-30s and works and lives in the Bay Area with his wife, two kids, and dog. In the previous article, we have already learned about why the duration is considered to be a very important concept while investing in fixed income securities. However, it is important for the readers to understand how exactly duration is calculated and how it impacts the valuation of fixed income securities. In this article, we will have a closer look at the methodology which is commonly used to calculate bond duration.
Weighted Average of Cash Flows
Before we delve into the nitty-gritty of the calculation, it is important to understand what we are trying to achieve by calculating duration. As mentioned in the previous article, cash flows that are farther away in terms of time are impacted more by interest rate changes. Duration, therefore, tries to calculate a weighted average of the cash flows. The time factor is used as a weight to ensure that the negative impact related to cash flows that are farther into the future is captured.
- Step #1: Calculate the Cash Flows:The first step of the model is to calculate the nominal cash flows which will accrue to the bondholder. These nominal payments must then be converted to real payments by discounting them using the appropriate discount rate. This includes all the coupon payments as well as the principal repayment which generally occurs towards the maturity of the bond. It is important for investors to have complete visibility over the cash flow schedule of the bond before they begin calculating duration.
- Step #2: Calculate the Proportion of Cash Flow in Every Coupon:The next step is to calculate the proportion of cash flow that is being received in every coupon payment. For instance, the total value of the bond is $100, but the first coupon payment accounts for $7, then it can be said that 7% of the money will be received in that particular coupon payment. In order to calculate the duration, the proportion of funds being received as a result of every payment need to be calculated.
- Step #3: Multiply by Time Factor:The next step is to multiply each cash flow with the time factor. This ensures that the cash flows which occur later in the future will show greater sensitivity to interest rate changes as composed of cash flows that are closer.
- Step #4: Summation:The last and final step is to sum the weighted average of all cash flows. The product calculated above for each and every cash flow which is due to happen in the future is added in order to calculate a final sum. This sum represents the bond duration.
Duration of a Portfolio
It is common for individual investors as well as mutual funds to calculate the duration of an entire portfolio instead of an individual bond. The method used for calculation is the same. However, given a large number of bonds in any portfolio, the calculation can turn out to be quite complex. This is why such investors do not generally use spreadsheets for their calculations. Instead, they have specialized tools to calculate the duration of the entire portfolio. It is common for such investors to have a target bond duration. For example, if the investor believes that the interest rates will fall in the future, then they will increase the overall duration of their portfolio. This will help them lock in higher yields for a longer period of time. The opposite of this is also true. If investors feel that interest rates will rise in the future, then they try to reduce the duration of the portfolio in order to reduce the impact of this interest rate fall.
Factors Which Affect the Duration of a Bond
The duration of a bond is affected by the following factors. The weighted average of the time to receive the cash flows from a bond
What is Macaulay Duration?
Macaulay duration is the weighted average of the time to receive the cash flows from a bond. It is measured in units of years. Macaulay duration tells the weighted average time that a bond needs to be held so that the total present value of the cash flows received is equal to the current market price paid for the bond. It is often used in bond immunization strategies.
Summary
- Macaulay duration measures the weighted average of the time to receive the cash flows from a bond so that the present value of cash flows equals the bond price.
- A bond’s Macaulay duration is positively related to the time to maturity and inversely related to the bond’s coupon rate and interest rate.
- Modified duration measures the sensitivity of a bond’s price to the change in interest rates.
How to Calculate Macaulay Duration
In Macaulay duration, the time is weighted by the percentage of the present value of each cash flow to the market price of a bond. Therefore, it is calculated by summing up all the multiples of the present values of cash flows and corresponding time periods and then dividing the sum by the market bond price. Where:
- PV(CFt) – Present value of cash flow (coupon) at period t
- t – Time period for each cash flow
- C – Periodic coupon payment
- n – Total number of periods to maturity
- M – Value at maturity
- Y – Periodic yield
For example, a 2-year bond with a $1,000 par pays a 6% coupon semi-annually, and the annual interest rate is 5%. Thus, the bond’s market price is $1,018.81, summing the present values of all cash flows. The time to receive each cash flow is then weighted by the present value of that cash flow to the market price. The Macaulay duration is the sum of these weighted-average time periods, which is 1.915 years. An investor must hold the bond for 1.915 years for the present value of cash flows received to exactly offset the price paid.
Factors that Affect Macaulay Duration
The Macaulay duration of a bond can be impacted by the bond’s coupon rate, term to maturity, and yield to maturity. With all the other factors constant, a bond with a longer term to maturity assumes a greater Macaulay duration, as it takes a longer period to receive the principal payment at the maturity. It also means that Macaulay duration decreases as time passes (term to maturity shrinks). Macaulay duration takes on an inverse relationship with the coupon rate. The greater the coupon payments, the lower the duration is, with larger cash amounts paid in the early periods. A zero-coupon bond assumes the highest Macaulay duration compared with coupon bonds, assuming other features are the same. It is equal to the maturity for a zero-coupon bond and is less than the maturity for coupon bonds. Macaulay duration also demonstrates an inverse relationship with yield to maturity. A bond with a higher yield to maturity shows a lower Macaulay duration.
Macaulay Duration vs. Modified Duration
Modified duration is another frequently used type of duration for bonds. Different from Macaulay duration, which measures the average time to receive the present value of cash flows equivalent to the current bond price, Modified duration identifies the sensitivity of the bond price to the change in interest rate. It is thus measured in percentage change in price. Modified duration can be calculated by dividing the Macaulay duration of the bond by 1 plus the periodic interest rate, which means a bond’s Modified duration is generally lower than its Macaulay duration. If a bond is continuously compounded, the Modified duration of the bond equals the Macaulay duration. In the example above, the bond shows a Macaulay duration of 1.915, and the semi-annual interest is 2.5%. Therefore, the Modified duration of the bond is 1.868 (1.915 / 1.025). It means for each percentage increase (decrease) in the interest rate, the price of the bond will fall (raise) by 1.868%. Another difference between Macaulay duration and Modified duration is that the former can only be applied to the fixed income instruments that will generate fixed cash flows. For bonds with non-fixed cash flows or timing of cash flows, such as bonds with a call or put option, the time period itself and also the weight of it are uncertain. Therefore, looking for Macaulay duration, in this case, does not make sense. However, Modified duration can still be calculated since it only takes into account the effect of changing yield, regardless of the structure of cash flows, whether they are fixed or not.
Macaulay Duration and Bond Immunization
In asset-liability portfolio management, duration-matching is a method of interest rate immunization. A change in the interest rate affects the present value of cash flows, and thus affects the value of a fixed-income portfolio. By matching the durations between the assets and liabilities in a company’s portfolio, the change in interest rate will move the value of assets and the value of liabilities by exactly the same amount, but in opposite directions. Therefore, the total value of this portfolio remains unchanged. The limitation of duration-matching is that the method only immunizes the portfolio from small changes in interest rate. It is less effective for large interest rate changes.
Related Readings
Thank you for reading CFI’s guide on Macaulay Duration. To keep learning and developing your knowledge of financial analysis, we highly recommend the additional resources below:
- Discount Rate
- Effective Duration
- Yield Curve
- Modified Duration
Purchase a PDF
Purchase this article for $51.00 USD.
How does it work?
- Select the purchase
option. - Check out using a credit card or bank account with
PayPal. - Read your article online and download the PDF from your email or your account.
journal article A Closed-Form Formula for Calculating Bond Duration Financial Analysts Journal Vol. 40, No. 3 (May — Jun., 1984) , pp. 76-78 (3 pages) Published By: Taylor & Francis, Ltd. https://www.jstor.org/stable/4478749 Read and download Log in through your school or library Purchase article $51.00 — Download now and later Preview Preview
Abstract Calculating a bond’s duration is typically a tedious procedure, involving calculation of the present value of each coupon payment, multiplication of each present value by the maturity of the cash flow, addition of the weighted present values and division of the sum by the value of the bond. The author presents a closed-form equation that enables a faster and more direct calculation of bond duration.
Journal Information The Financial Analysts Journal aims to be the leading practitioner journal in the investment management community by advancing the knowledge and understanding of the practice of investment management through the publication of rigorous, peer-reviewed, practitioner-relevant research from leading academics and practitioners. Publisher Information Building on two centuries’ experience, Taylor & Francis has grown rapidlyover the last two decades to become a leading international academic publisher.The Group publishes over 800 journals and over 1,800 new books each year, coveringa wide variety of subject areas and incorporating the journal imprints of Routledge,Carfax, Spon Press, Psychology Press, Martin Dunitz, and Taylor & Francis.Taylor & Francis is fully committed to the publication and dissemination of scholarly information of the highest quality, and today this remains the primary goal. Rights & Usage This item is part of a JSTOR Collection.
For terms and use, please refer to our Terms and Conditions
Financial Analysts Journal
© 1984 CFA Institute Request Permissions
- How to understand your girlfriend
- How to start over and have the life you want
- How to share google play apps music and more between android devices
- How to add your gmail calendar to the calendar on mac os x
- How to grow cannabis outdoors