Documentation/Calc Functions/NPER

Function name:
NPER

Category:
Financial Analysis

Summary:
Calculates the number of periods for an investment based on periodic, constant payments and a constant interest rate.

Syntax:
NPER(Rate; Pmt; PV[; [FV] [; Type]])

Returns:
Returns a real number which is the number of payment periods for investment with specified parameters.

Arguments:
Rate is a real number (expressed as a percentage or fraction) or a reference to the cell containing that number which is the periodic interest rate.

Pmt is a real number or a reference to the cell containing that number which is the constant annuity paid in each period.

PV is a real number or a reference to the cell containing that number which is the present cash value in a sequence of payments.

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 it is omitted, then the function uses 0.

Type is the due date of the payment at the beginning or end of each period. If it is omitted, then the function uses 0.


 * If Pmt is 0 then the function returns an error value.
 * If Type is anything accept 0 or 1, then the function returns an error value.

Additional details:

 * NPER solves the following equation:

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

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

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

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

ODF standard:
Section 6.12.29, part 2

Equivalent Excel functions:
NPER