PDURATION Function

The PDURATION function is one of the financial functions. It is used to calculate the number of periods required by an investment to reach a specified value.

Syntax

PDURATION(rate, pv, fv)

The PDURATION function has the following arguments:

Argument	Description
rate	The interest rate per period.
pv	The present value of the investment.
fv	The desired future value of the investment.

Notes

All arguments must be represented by positive numbers.

How to apply the PDURATION function.

Examples

The figure below displays the result returned by the PDURATION function.