Documentation/Calc Functions/NPER

From The Document Foundation Wiki
Jump to: navigation, search


Under construction.
For now, see the system Help files.

Function name:



Financial Analysis


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


NPER(Rate; Pmt; PV; FV; Type)



Rate is the periodic interest rate.

Pmt is the constant annuity paid in each period.

PV is the present value (cash value) in a sequence of payments.

FV (optional) is the future value, which is reached at the end of the last period.

Type (optional) is the due date of the payment at the beginning or at the end of the period.

In the LibreOffice Calc functions, parameters marked as "optional" can be left out only when no parameter follows. For example, in a function with four parameters, where the last two parameters are marked as "optional", you can leave out parameter 4 or parameters 3 and 4, but you cannot leave out parameter 3 alone.

Additional details:


How many payment periods does a payment period cover with a periodic interest rate of 6%, a periodic payment of 153.75 currency units and a present cash value of 2.600 currency units.

=NPER(6%;153.75;2600) = -12,02. The payment period covers 12.02 periods.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: