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

NOMINAL

PMT

Last updated 11 months ago

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`

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