WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 250+ Courses All In One Bundle
  • Login
Home » Risk Management Tutorials » Fixed Income Tutorials » Duration Formula

Duration Formula

What is the Duration Formula?

The formula for the duration is a measure of a bond’s sensitivity to changes in the interest rate, and it is calculated by dividing the sum product of discounted future cash inflow of the bond and a corresponding number of years by a sum of the discounted future cash inflow. The cash inflow basically comprises of coupon payment and the maturity at the end. It is also known as Macaulay duration.

Mathematically, the equation for the duration is represented as below,

Duration Formula = [ ∑in-1 i*Ci/(1+r)i + n*M/(1+r)n] / [∑in-1  Ci/(1+r)i + M/(1+r)n]

where,

  • C = Coupon payment per period
  • M= Face or Par value
  • r =Effective periodic rate of interest
  • n = Number of periods to maturity

Further, the denominator, which is the summation of the discounted cash inflow of the bond, is equivalent to the present value or price of the bond. Therefore, the formula for the duration can be further simplified as below,

duration formula 2

DURATION FORMULA

Explanation of the Duration Formula

The equation for the duration can be computed by using the following steps:

Step 1: Firstly, the face or par value of the bond issuance is figured out, and it is denoted by M.

Step 2: Now, the coupon payment of the bond is calculated based on the effective periodic rate of the interest. Then the frequency of the coupon payment is also determined. The coupon payment is denoted by C, and the effective periodic rate of interest is denoted by r.

Step 3: Now, the total number of periods till maturity is computed by multiplying the number of years till maturity and the frequency of the coupon payments in a year. The number of periods till maturity is denoted by n. Also, the time of the periodic payment is noted, which is denoted by i.

Step 4: Finally, based on the available information, the equation for the duration can be derived as below,

duration formula 1

Examples of Duration Formula (with Excel Template)

Let’s see some simple to advanced types of duration formula to understand it better.

You can download this Duration Formula Excel Template here – Duration Formula Excel Template

Popular Course in this category
Sale
Fixed Income Course
4.7 (487 ratings)
9 Courses | 37+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Duration Formula Formula – Example #1

Let us take an example of a bond with annual coupon payments. Let us assume that company XYZ Ltd has issued a bond having a face value of $100,000, carrying an annual coupon rate of 7% and maturing in 5 years. The prevailing market rate of interest is 10%.

Given, M = $100,000

  • C = 7% * $100,000 = $7,000
  • n = 5
  • r = 10%

The denominator or the price of the bond is calculated using the formula as,

duration formula examplee 1.1

  • Bond price = 84,281.19

Calculation of the numerator of Duration formula is as follows –

duration formula examplee 1.2

= (6,363.64 + 11,570.25 + 15,777.61 + 19,124.38 + 310,460.70)

= 363,296.50

Therefore, the calculation of duration of the bond will be as below,

 

duration formula example 1.3

Duration = 363,296.50 / 84,281.19

  • Duration =4.31 years

Duration Formula Formula – Example #2

Let us take an example of a bond with annual coupon payments. Let us assume that company XYZ Ltd has issued a bond having face value of $100,000 and maturing in 4 years. The prevailing market rate of interest is 10%. Calculate the bond duration for the following annual coupon rate: (a) 8% (b) 6% (c) 4%

Given, M = $100,000

  • n = 4
  • r = 10%

Calculation for Coupon Rate of 8%

Coupon payment (C)= 8% * $100,000 = $8,000

The denominator or the price of the bond is calculated using the formula as,

duration formula examplee 2.1

  • Bond price = 88,196.16

Calculation of the numerator of the Duration formula will be as follows –

duration formula examplee 2.2

= 311,732.81

Therefore, the calculation of duration of the bond will be as below,

 

duration formula example 2.3

Duration = 311,732.81/ 88,196.16

  • Duration = 3.53 years

Calculation for Coupon Rate of 6%

Coupon payment (C) = 6% * $100,000 = $6,000

The denominator or the price of the bond is calculated using the formula as,

 

duration formula example 2.4

  • Bond price = 83,222.46

Calculation of the numerator of the Duration formula will be as follows –

 

duration formula example 2.5

= 302,100.95

Therefore, the calculation of the duration of the bond will be as below,

duration formula examplee 2.6

Duration = 302,100.95 / 83,222.46

  • Duration = 63 years

The calculation for Coupon Rate of 4%

Coupon payment = 4% * $100,000 = $4,000

The denominator or the price of the bond is calculated using the formula as,

duration formula examplee 2.7

  • Bond price = 78,248.75

Calculation of the numerator of the Duration formula will be as follows –

duration formula example 2.8

= 292,469.09

Therefore, the calculation of the duration of the bond will be as below,

duration formula example 2.9

Duration Formula = 292,469.09 / 78,248.75

  • Duration = 3.74 years

From the example, it can be seen that the duration of a bond increases with the decrease in coupon rate.

Relevance and Use of Duration Formula

It is important to understand the concept of duration as it is used by bond investors to check a bond’s sensitivity to changes in interest rates. The duration of a bond basically indicates how much the market price of a bond will change owing to the change in the rate of interest. It is noteworthy to remember that rate of interest and bond price move in opposite directions, and as such, bond price rise when the rate of interest falls and vice versa.

In case investors are seeking benefits from a fall in interest rate, the investors will intend to buy bonds with a longer duration, which is possible in the case of bonds with lower coupon payment and long maturity. On the other hand, investors who want to avoid the volatility in interest rate, the investors will be required to invest in bonds that have a lower duration or short maturity and higher coupon payment.

Recommended Articles

This has been a guide to Duration Formula. Here we discuss how to calculate the Duration of Bond using practical examples and a downloadable excel template. You can learn more about financial analysis from the following articles –

  • What is Coupon Rate Formula?
  • Subordinated Debt Meaning
  • Bond Pricing Formula Calculation
  • Examples of Current Yield of a Bond
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Login

Forgot Password?

WallStreetMojo

Download Duration Formula Excel Template

New Year Offer - Fixed Income Course (9 courses, 37+ hours videos) View More