PDURATION

Scripting Formulas Finance

FINANCE.PDURATION

FINANCE.PDURATION(rate, value, future_value)

Calculates the number of periods required by an investment to reach a specified value.

  • rate: Interest per period.
  • value: Present value of an investment.
  • future_value: Desired future value of an investment.