PDURATION (PQL - xl)

This function returns the number of periods required by an investment to reach specified value

  • Library: PQL \ Spreadsheet \ Financial
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module

Syntax

PDURATION(rate, pv, fv)

Function Arguments

Name

Description

Type

Optional

rate

Value of interest rate per period

Number

pv

Present value of the investment

Number

fv

Desired future value of the investment

Number

Comments

This function is the same as the Microsoft Excel 'PDURATION' function - using the same inputs, logic and outputs.