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.