NPER

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

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)

Parameters

Example

See Also