NPER
Returns the number of periods for an investment
Syntax
NPER(rate, pmt, pv, [fv], [type])
Parameters
- rate: Required. The interest rate per period
- pmt: Required. The payment made each period
- pv: Required. The present value
- fv: Optional. The future value (default 0)
- type: Optional. When payments are due (0=end, 1=beginning)
Example
=NPER(0.12/12, -100, -1000, 10000, 1)