ExcelFlux

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

RowAB
6InputSecond input
70.050.05
80.060.07
90.080.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 examples

Copyable 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
Microsoft Excel reference