How Do I Calculate the Duration of a Bond ... you would have a choice between two formulas: Macaulay Duration, which is expressed in years, and Modified Duration, the more modern measurement ...

To use the Duration function in Microsoft Excel, follow the steps below. Launch Excel Create a table or use an existing table Type the formula for the Duration function into the cell you want to ...

Modified duration is a formula that measures the sensitivity ... who developed the concept of bond duration in the 1930s. Calculating the Macaulay duration is the most difficult part of ...