NPER function
NPER(Rate, Payment,
PresentValue, FutureValue?, Type?) NPER(Rate; Payment;
PresentValue; FutureValue?; Type?)
Rate
Number or { Number }
The (fixed) interest rate per period.
Payment
Number or { Number }
The payment made each period.
PresentValue
Number or { Number }
The lump sum payment at the start of the term.
FutureValue
Number or { Number } (optional)
The cash balance paid at the end of the term. If omitted, it is assumed to be 0.
Type
Number or { 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 or { Number }
The number of payment periods.
Returns the number of payment periods for an annuity.
Example
Partly derived from the OpenOffice.org documentation, licensed
under the Apache License 2.0.