NPER function


DESCRIPTION:

Returns the number of periods for an investment based on periodic, constant payments and constant interest rate.

 

SYNTAX:

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

 

REQUIRED ARGUMENTS:

rate

The interest rate per period.

pmt

The payment made each period.

pv

The present value, or a total value of all payments.

 

OPTIONAL ARGUMENTS:

[fv]

The future value.

[type]

0 = end of period. 1 = beginning of period. Default is 0.