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.
NPER(rate: Number, paymentamount: Number, presentvalue: Number, futurevalue: Number, paymentsatthebeginningofperiod: Boolean) => Number
The interest rate
The amount of each payment made
The current value of the annuity
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