ExcelFlux

PDURATION function

the number of periods required by an investment to reach a specified value.

Financial · Excel 2013+

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

Find how many periods are needed to reach a target at a constant rate.

A worked example from the workbook

RowABC
6RateStartTarget
70.1100121
80.1100110
90.05100100
Record 1
=PDURATION(A7,B7,C7)

Expected result2

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=PDURATION(0.1,100,121)
Turkish Excel · tr-TR
=PSÜRE(0,1;100;121)

Expected result

2

Worked examples

Find how many periods are needed to reach a target at a constant rate.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A B C
6 Rate Start Target
7 0.1 100 121
8 0.1 100 110
9 0.05 100 100
Case Formula Expected result
Record 1 =PDURATION(A7,B7,C7) 2
Record 2 =PDURATION(A8,B8,C8) 1
Record 3 =PDURATION(A9,B9,C9) 0
Microsoft Excel reference