PDURATION function

The PDURATION function returns the number of periods for an investment to reach a specific value at a given rate. Mathematically, PDURATION = (log(futureValue) - log (currentValue))/(log(1 + rate)).

Parts of a PDURATION function

PDURATION(rate, present_value, future_value)

Part Description
rate Required. The rate at which the investment grows each period.
present_valuepresent_value Required. The investment's current value.
future_valuefuture_value Required. The investment's desired future value.


All values must be positive and greater than 0.


1.817059493 =PDURATION(0.25, 10, 15)
3.600511394 =PDURATION(0.75, 2, 15)

Related functions

  • RRI: The RRI function returns the interest rate needed for an investment to reach a specific value within a given number of periods.
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Clear search
Close search
Google apps
Main menu