NPER (Rate, Payment, PresentValue, FutureValue?, Type?) NPER (Rate; Payment; PresentValue; FutureValue?; Type?)
Rate
Number Number
The (fixed) interest rate per period.
Payment
Number Number
The payment made each period.
PresentValue
Number Number
The lump sum payment at the start of the term.
FutureValue
Number Number (optional)
The cash balance paid at the end of the term. If omitted, it is assumed to be 0.
Type
Number Number (optional)
0 If payments are made at the end of each period and 1 if payments are made at the start of each period (including a payment at the start of the term). If omitted, it is assumed to be 0.
Returns
Number Number
The number of payment periods.
Returns the number of payment periods needed to reach a target value, given a constant interest rate and regular payments. This is useful for answering questions such as "how many months until I have saved a particular amount?"