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
| Row | A | B | C |
|---|---|---|---|
| 6 | Rate | Start | Target |
| 7 | 0.1 | 100 | 121 |
| 8 | 0.1 | 100 | 110 |
| 9 | 0.05 | 100 | 100 |
Record 1
=PDURATION(A7,B7,C7)Expected result2
See the inputs and instructions for all 3 examplesCopyable 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 |