Excel functions / Financial
PDURATION function
How many periods an investment needs to reach a target at a steady rate.
Syntax
=PDURATION(rate, pv, fv)
Arguments
rate: The interest rate per period.pv: The starting amount.fv: The amount to reach.
When to use it
PDURATION gives how many periods an investment takes to grow from one value to another at a fixed rate, with no payments in between. It is the "how long to double?" question.
Examples
Years for 2,000 to reach 2,200 at 2.5%
A B C D E 1 Rate Now Target 2 2.5% 2000 2200 3.86 In E2:
=PDURATION(A2, B2, C2)→ 3.86Years to double at 7%
A B C 1 Rate 2 7% 10.24 In C2:
=PDURATION(A2, 1, 2)→ 10.24
Common mistakes
- Regular payments. PDURATION assumes no deposits along the way. With regular payments, use NPER.
PDURATION in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: PDURATION
- Danish: PVARIGHED
- Dutch: PDUUR
- Finnish: KESTO.JAKSO
- French: PDUREE
- German: PDURATION
- Hungarian: KAMATÉRZ.PER
- Italian: DURATA.P
- Norwegian: PVARIGHET
- Polish: O.CZAS.TRWANIA
- Portuguese (Brazil): DURAÇÃOP
- Portuguese (Portugal): PDURAÇÃO
- Russian: ПДЛИТ
- Spanish: P.DURACION
- Swedish: PLÖPTID
- Turkish: PSÜRE
Try PDURATION in the playground