
description:
Returns the present value of an investment: the total amount that a series of future payments is worth now. |
syntax:
=NPER( rate, nper, pmt, [fv], [type] ) |
required arguments:
rate | The interest rate per period. |
nper | The total number of payment periods. |
pmt | The payment made each period. |
optional arguments:
[fv] | The future value. |
[type] | 0 = end of period. 1 = beginning of period. Default is 0. |
