Spread.Sheets Documentation
PDURATION
Spread.Sheets Documentation > Formula Reference > Formula Functions > PDURATION

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

Syntax

PDURATION(rate,pv,fv)

Arguments

This function has the following arguments:

Argument Description
rate Value of interest rate per period
pv Present value of the investment
fv Desired future value of the investment

All the arguments of this function has positive values.

Remarks

All the passed arguments should be positive values.

Data Types

Accepts numeric data. Returns numeric data.

Examples

PDURATION(0.025/12,1000,1200) gives the result 87.6