What is the formula of duration?
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.
What is the formula for modified duration?
To find the modified duration, all an investor needs to do is take the Macaulay duration and divide it by 1 + (yield-to-maturity / number of coupon periods per year). In this example that calculation would be 2.753 / (1.05 / 1), or 2.62%.
How do you calculate duration of a bond?
The Macaulay Duration formula reflects the fact that Duration = Present value of a bond’s cash flows, weighted by the length of time to receipt, and divided by the bond’s current market value.
What is duration example?
Duration is defined as the length of time that something lasts. When a film lasts for two hours, this is an example of a time when the film has a two hour duration. Rationing will last at least for the duration.
How is duration calculated in Excel?
Another simple technique to calculate the duration between two times in Excel is using the TEXT function:
- Calculate hours between two times: =TEXT(B2-A2, “h”)
- Return hours and minutes between 2 times: =TEXT(B2-A2, “h:mm”)
- Return hours, minutes and seconds between 2 times: =TEXT(B2-A2, “h:mm:ss”)
Why do we calculate duration?
Duration can measure how long it takes, in years, for an investor to be repaid the bond’s price by the bond’s total cash flows. Duration can also measure the sensitivity of a bond’s or fixed income portfolio’s price to changes in interest rates. Coupon rate: A bond’s coupon rate is a key factor in calculation duration.
How do I calculate modified duration in Excel?
The formula used to calculate a bond’s modified duration is the Macaulay duration of the bond divided by 1 plus the bond’s yield to maturity divided by the number of coupon periods per year. In Excel, the formula used to calculate a bond’s modified duration is built into the MDURATION function.
What is the duration of a 5 year bond?
If sold for face value, a 5-year Treasury bond with a 1% coupon rate will have a duration of 4.89 years. The reason the duration is less than 5 years is that some of the cash flows (specifically, the interest payments) will be received prior to the bond’s 5-year maturity.
What is the duration of a 10 year bond?
The 10-year Treasury note is a debt obligation issued by the United States government with a maturity of 10 years upon initial issuance. A 10-year Treasury note pays interest at a fixed rate once every six months and pays the face value to the holder at maturity.
What is time and duration?
duration Add to list Share. Duration is how long something lasts, from beginning to end. The noun duration has come to mean the length of time one thing takes to be completed. The duration of something might be known or not — in past times, the unknown length of time the current war would last was called “the duration.
What is duration in years?
Duration can measure how long it takes, in years, for an investor to be repaid the bond’s price by the bond’s total cash flows. In general, the higher the duration, the more a bond’s price will drop as interest rates rise (and the greater the interest rate risk).
