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. |