MDURATION function
the Macauley modified duration for a security with an assumed par value of $100.
Financial
Where can you use it?
Budgeting, treasury and finance teams. When reviewing a scenario with cash flows, payment periods and rate assumptions, compare the input and output units in the example.
Scenario in the workbook
Adjust one year of Macaulay duration by the annual yield. Higher yields reduce modified duration.
A worked example from the workbook
| Row | A | B |
|---|---|---|
| 6 | Input | Second input |
| 7 | 0.05 | 0.05 |
| 8 | 0.06 | 0.07 |
| 9 | 0.08 | 0.09 |
Record 1
=MDURATION(DATE(2026,1,1),DATE(2027,1,1),A7,B7,1,3)Expected result0.9523809524
See the inputs and instructions for all 3 examplesCopyable formulas
English Excel · en-US
=MDURATION(DATE(2026,1,1),DATE(2027,1,1),A7,B7,1,3)Turkish Excel · tr-TR
=MSÜRE(TARİH(2026;1;1);TARİH(2027;1;1);A7;B7;1;3)Worked examples
Adjust one year of Macaulay duration by the annual yield. Higher yields reduce modified duration.
Use the blue inputs in the table starting at A6. F7:F9 calculate results and G7:G9 retain the original values for comparison.
| Row | A | B |
|---|---|---|
| 6 | Input | Second input |
| 7 | 0.05 | 0.05 |
| 8 | 0.06 | 0.07 |
| 9 | 0.08 | 0.09 |
| Trial | Expression | Sample output |
|---|---|---|
| Record 1 | =MDURATION(DATE(2026,1,1),DATE(2027,1,1),A7,B7,1,3) |
0.9523809524 |
| Record 2 | =MDURATION(DATE(2026,1,1),DATE(2027,1,1),A8,B8,1,3) |
0.9345794393 |
| Record 3 | =MDURATION(DATE(2026,1,1),DATE(2027,1,1),A9,B9,1,3) |
0.9174311927 |