PV function

description:

Returns the present value of an investment: the total amount that a series of future payments is worth now.

 

syntax:

=NPER( ratenperpmt[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.

Skillshare’s usually $10 a month, but because you’re an OfficeTuts reader you can get your first month free by clicking here. That’s unlimited access to over 18,000 classes on Excel, VBA, and much more.