NPer

Syntax

NPer(Rate, PeriodPayment, PresentValue, FutureValue, Type)

Parameters

Rate. Interest rate per period. Parameter value must be greater than zero.

PeriodPayment. Amount of periodic payment. This value cannot be changed during the payment period. As a rule, payment consists of the principle and of interest payment and does not include taxes and charges. Parameter value must be greater than or equal to one.

PresentValue. The present value, or the lump-sum amount that a series of future payments is worth now.

FutureValue. The required value of future cost or the remainder after the last payment.

Type. Selecting payment time. The parameter may take the following values:

0. Payment at the end of the period.
1. Payment at the beginning of the period.

NOTE. To determine the parameter, specify either the parameter value or the cell address where it is located.

Description

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

Example

Formula

Result

Description

=NPer(0.011, -100, -800, 5000, 0)

32,35

Investment payment periods based on the following terms:

The interest rate over the period is 0.011.
The payment amount is -100.
The current value is -800.
The future value is 5000.
The payments are effected at the end of period.

=NPer(A0, B0, -800, 5000, 0)

8,56

Investment payment periods based on the following terms:

The interest rate over the period is specified in the A0 cell (value 0.15).
The payment amount is specified in the B0 cell (value -153.1).

The current value is -800.
The future value is 5000.
The payments are effected at the end of period.