Documentation/Calc Functions/PDURATION

Function name:
PDURATION

Category:
Financial Analysis

Summary:
Calculates the number of periods required by an investment to attain the desired value.

Syntax:
PDURATION(Rate; PV; FV)

Returns:
Returns a real number which is the number of periods required by an investment, PV, to attain the desired value,FV, at a given rate, Rate.

Arguments:
Rate is a real number (expressed as a percentage or fraction) or a reference to the cell containing that number which is a constant. The interest rate is to be calculated for the entire duration (duration period). The interest rate per period is calculated by dividing the interest rate by the calculated duration. The internal rate for an annuity is to be entered as Rate/12.

PV is a positive real number or a reference to the cell containing that number which is the present cash value in a sequence of payments. The cash value is the deposit of cash or the current cash value of an allowance in kind.

FV is a real number or a reference to the cell containing that number which is the desired value (future value) at the end of the periods.


 * If either of Rate, PV or FV is less than or equal to 0, then the function returns an error value.
 * If PV is greater than FV then the function returns a negative period.

Additional details:

 * The formula for PDURATION is:

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/DURATION DURATION]

[[Special:MyLanguage/Documentation/Calc_Functions/MDURATION MDURATION]

ODF standard:
Section 6.12.35, part 2

Equivalent Excel functions:
PDURATION