PDURATION Function in Google Sheets

Calculate the number of periods required for an investment to grow to a future value using the PDURATION function.

PDURATION Function

The PDURATION function in Google Sheets calculates the number of periods required for an investment to grow to a specified future value at a constant interest rate.

Syntax

PDURATION(rate, present_value, future_value)
  • rate: The interest rate per period. This is a required parameter.
  • present_value: The present value, or the current amount of the investment. This is a required parameter.
  • future_value: The desired future value of the investment. This is a required parameter.

Examples

  1. Period Calculation for Investment Growth

Calculate the number of periods needed for an investment of $1000 to grow to $2000 with an annual interest rate of 5%:

=PDURATION(5%, 1000, 2000)

This will output approximately 14.21 periods.

Notes

  • PDURATION is useful for determining how long it will take for an investment to reach a specific goal at a given interest rate.
  • NPER: Calculate the number of periods required for an investment to reach a target value.
  • FV: Calculate the future value of an investment based on periodic payments and a constant interest rate.