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

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

  1. Years for 2,000 to reach 2,200 at 2.5%

    ABCDE
    1RateNowTarget
    22.5%200022003.86

    In E2: =PDURATION(A2, B2, C2) → 3.86

    Try this example

  2. Years to double at 7%

    ABC
    1Rate
    27%10.24

    In C2: =PDURATION(A2, 1, 2) → 10.24

    Try this example

Common mistakes

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.

Translate a whole formula

Try PDURATION in the playground

Related functions