PV function
DESCRIPTION:
Returns the present value of an investment: the total amount that 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. |