NPER

Number of payment periods

Description

Calculates how many payment periods are needed for an investment. This is done based on a constant interest rate and periodic payments of constant amounts.

Function signature

NPER(rate: Number, paymentamount: Number, presentvalue: Number, futurevalue: Number, paymentsatthebeginningofperiod: Boolean) => Number

Parameter

Description

Rate

The interest rate

Payment amount

The amount of each payment made

Present value

The current value of the annuity

Future value

Future value left when the final payment has been completed, defaults to 0.

Payments at the beginning of period

Whether payments are due at the end (false) or beginning (true) of each period

Examples

Formula

Return value

NPER(0.1, 4, 100)

-13.14406259

NPER(0.5, 4, 100)

-6.419022583

NPER(0.5, 6, 100)

-5.508716229

NPER(0.5, 6, 100, -200)

1.573717172

NPER(0.5, 6, 100, -200, true)

1.513842809