Browse By

Tag Archives: Duration

Calculating Bond Convexity & Duration in Excel Spreadsheets

Macaulay Duration Excel calculation example

Macaulay Duration Excel Calculation Example A working example of  Macaulay & Modified duration calculation. Earlier we had considered the importance of the Duration risk metric to Asset Liability Management (ALM) and managing interest rate risk. In this post we will look at the specific mechanics of

No Thumbnail

Interest Rate Risk: Duration, Macaulay Duration and Modified Duration

Duration is a measure of how rapidly the prices of interest sensitive securities change as the rate of interest changes (see application example in the ALM section). For example, if the duration of a security works out to 2 this means that for a 1% increase in interest rates the price of the instrument will decrease by 2%. Similarly, if the interest rates were to decrease by 1% the price of the security would increase by 2%.