Returns the number of periods for the specified investment based on the specified periodic, constant payments and the specified constant interest rate.
Syntax
 Copy Code
|
|---|
NPER( Number rate, Number payment, Number pv, [Number fv = 0], [Integer type = 0] ) → Number |
Parameters
- rate
- Required. The constant interest rate per period.
- payment
- Required. The payment made each period.
- pv
- Required. The present value of the investment.
- fv
- Optional. The future value. If omitted, fv is assumed to be 0.
- type
- Optional. A number specifying when the payment is due. If omitted, type is assumed to be 0.
Example
| Formula
Copy Code
|
|---|
=NPER(0.12,-100,-1000) |
See Also
Function Reference
FV Function
PMT Function
PV Function
RATE Function