Spread Formula Reference
Formula Functions / Functions M to Q / PDURATION
In This Topic
    PDURATION
    In This Topic

    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

    Version Available

    This function is available in Spread for Windows Forms 11.0 or later.