NPER

Get number of periods for loan or investment

Syntax

EXCEL Copy

=NPER(rate, pmt, pv, [fv], [type])

Arguments

Parameter	Description
rate	The interest rate per period.
pmt	The payment made each period.
pv	The present value, or total value of all payments now.
fv	[optional] The future value, or a cash balance you want after the last payment is made. Defaults to 0.
type	[optional] When payments are due. 0 = end of period. 1 = beginning of period. Default is 0.

Return Value

The number of periods

Details

You can use the NPER function to get the number of payment periods for a loan (or an investment), given the amount, the interest rate, and a periodic payment amount.

See Also

FV PV RATE NPER PMT PPMT IPMT CUMPRINC