How to Calculate Duration and Convexity of a Bond with Excel

Bond duration measures the change in a bond’s price when interest rates fluctuate. If the duration is high, the bond’s price will move in the opposite direction to a greater degree than the change in interest rates. Conversely, when this figure is low, the debt instrument will show less movement to the change in interest rates. Most mortgage-backed securities (MBS) will have negative convexity because their yield is typically higher than traditional bonds. As a result, it would take a significant rise in yields to make an existing holder of an MBS have a lower yield, or less attractive, than the current market.

  • The convexity of a bond portfolio can significantly impact the portfolio’s overall return.
  • It’s a much more holistic picture of a bond’s movement given the interest rate environment.
  • Overall, the convexity of a bond portfolio is an important consideration for investors when choosing which bonds to include in their portfolio.
  • With coupon bonds, investors rely on a metric known as duration to measure a bond’s price sensitivity to changes in interest rates.
  • One of the important aspects of bond investing is understanding how bond prices react to changes in interest rates.

If the bond with prepayment or call option has a premium to be paid for the early exit, then the convexity may turn positive. Negative convexity happens when the tenure of a bond increases at the same time that the yield does. When interest rates fall, bond prices rise, but a bond with negative convexity depreciates as rates fall. A bond’s or bond portfolio’s approximate price change can be predicted quite well using duration.

What is the Convexity of a Bond?

This means convexity formula that for every 1% change in interest rates, Bond A’s price will change by 4% while Bond B’s price will change by 5.5%. A convexity measure is used to improve the estimate of the percentage price change. Bond B’s higher convexity protects against changes in interest rates, resulting in a less significant price movement than predicted based on tenure. Apply the same interest-rate forecast criterion when considering the overall impact of a new position and its allocation. Using position sizes and diversity to reduce risk, you can still buy bonds you like, even if their duration or convexity is at odds with your predicted interest rate. Note that these functions return the modified duration and Macaulay duration in years, so there is no need to divide by the payment frequency.

Why bond convexities may differ

If interest rates increase by 1%, the price of Bond A will decrease by 8.19% according to duration, and by 7.51% according to duration and convexity. The price of Bond B will decrease by 4.37% according to duration, and by 4.23% according to duration and convexity. The difference between the duration and convexity estimates is larger for Bond A than for Bond B, because Bond A has a higher convexity and a more curved price-yield curve. As a rule of thumb, non-callable bonds would normally have positive convexity, while many bonds that can be redeemed prior to maturity (callable bonds, i.e. those that have an embedded option) should have negative convexity.

For example, if the bond duration is 5 years, and the yield changes by 0.01%, then the bond price will change by approximately -0.05%. Where $P$ is the bond price, $C$ is the annual coupon payment, $F$ is the face value, $y$ is the yield to maturity, and $n$ is the number of periods. In the equations, $P$ is the bond price, $CF_t$ is the cash flow in period $t$, and $i$ is the per period yield to maturity. It is important to note that these equations work only on an interest payment date. The approximation technique that we will show will work on any date as long as you use the Price function. Eventually, the price of these bonds with the lower coupon rates will drop to a level where the rate of return is equal to the prevailing market interest rates.

Convexity is a risk management tool used to define how risky a bond is as more the convexity of the bond; more is its price sensitivity to interest rate movements. A bond with a higher convexity has a larger price change when the interest rate drops than a bond with lower convexity. Hence when two similar bonds are evaluated for investment with similar yield and duration, the one with higher convexity is preferred in stable or falling interest rate scenarios as price change is larger. In a falling interest rate scenario again, a higher convexity would be better as the price loss for an increase in interest rates would be smaller.

How bond duration changes with a changing interest rate

Bond convexity is a measure of how the curvature of the bond price-yield curve changes as interest rates change. It captures the non-linear relationship between bond prices and interest rates, and helps investors to better estimate the price change of a bond for a given change in interest rates. Several factors influence convexity, including a bond’s cash flows, maturity, coupon rate, yield to maturity (YTM), and market price. Cash flows consist of periodic coupon payments and the final principal repayment, each occurring at a set future time. The timing of these payments affects convexity, as longer maturities or higher coupon rates produce different convexity characteristics than shorter-term or lower-coupon bonds. While duration and convexity are useful measures of bond risk, they are not sufficient to capture all the sources of risk and uncertainty that bond investors face.

Bond convexity

Note that for bonds with somewhat unpredictable cash flows, we use effective duration to measure interest rate risk. Similarly, we use the effective convexity to measure the change in price resulting from a change in the benchmark yield curve for securities with uncertain cash flows. In fact, effective convexity is a secondary curve convexity statistic that measures the secondary effect of a change in the benchmark yield curve. For example, when yields fall bond prices rise, but due to convexity the price does increase more steeply than a linear calculation using the modified duration would estimate. On the other hand, when yields rise bond prices fall, but not as steeply as predicted by a linear model.

  • Negative convexity happens when the tenure of a bond increases at the same time that the yield does.
  • It captures the non-linear relationship between bond prices and interest rates, and helps investors to better estimate the price change of a bond for a given change in interest rates.
  • These are typically bonds with call options, mortgage-backed securities, and those bonds which have a repayment option.
  • The image below shows how we will set up the worksheet to calculate modified duration using the approximation technique that was just outlined.
  • When graphed on a two-dimensional plot, this relationship should generate a long-sloping U shape (hence, the term “convex”).
  • Convexity builds on the concept of duration by measuring the sensitivity of the duration of a bond as yields change.

Duration and Convexity To Measure Bond Risk

If market rates rise, new bond issues must also have higher rates to satisfy investor demand for lending money. The price of bonds returning less than that rate will fall, as there would be very little demand for them, as bondholders will look to sell their existing bonds and opt for bonds with higher yields. The convexity adjustment is the annual convexity statistic, AnnConvexity, times one-half, multiplied by the change in the yield-to-maturity squared. This amount adds to the linear estimate provided by the duration alone, which brings the adjusted estimate very close to the actual price on the curved line. The measured convexity of the bond when there is no expected change in future cash flows called modified convexity. When there are changes expected in the future cash flows, the convexity that is measured is the effective convexity.

The duration of a bond is the linear relationship between the bond price and interest rates, where, as interest rates increase, bond price decreases. Simply put, a higher duration implies that the bond price is more sensitive to rate changes. For a small and sudden change in bond, yield duration is a good measure of the sensitivity of the bond price. However, for larger changes in yield, the duration measure is not effective as the relationship is non-linear and is a curve. What they differ is in how they treat the interest rate changes, embedded bond options, and bond redemption options. They, however, do not take into account the non-linear relationship between price and yield.

Modified Duration

In other words, they aren’t really suited for a spreadsheet solution without resorting to VBA. Duration and convexity let investors quantify this uncertainty, helping them manage their fixed-income portfolios. If rates rise by 1%, a bond or bond fund with a five-year average duration would likely lose approximately 5% of its value.

As we can see, bond convexity measures the sensitivity of bond price to interest rate changes by accounting for the curvature of the bond price-yield curve and the changes in duration as interest rates change. It helps investors to better estimate the price change of a bond for a given change in interest rates, and to identify bonds that have more or less exposure to interest rate risk. Bond convexity is especially important for bonds that have low coupon rates, low yields, and long maturities, as they tend to have higher convexity and more non-linear price-yield curves. Duration tells you how much the bond price will change for a small change in interest rates, assuming that the interest rate change is constant across all maturities. Convexity tells you how much the bond price will change for a large change in interest rates, or for a change in interest rates that varies across different maturities. For example, if the yield curve shifts up or down by the same amount for all maturities, the bond price change will be mainly determined by the duration.

Where $P_+$ is the bond price when the yield increases by $\Delta y$, $P_-$ is the bond price when the yield decreases by $\Delta y$, and $P_0$ is the bond price at the original yield. As we can see, bond A has the highest convexity, and therefore the lowest price change when interest rates increase, and the highest price change when interest rates decrease. Bond C has the lowest convexity, and therefore the highest price change when interest rates increase, and the lowest price change when interest rates decrease.