All functions / Financial
PV
The present value: what a series of future payments is worth now.
Syntax
=PV(rate, nper, pmt, [fv], [type])
Arguments
rate: Interest rate per period, e.g. 5%/12 for monthly payments at 5% a year.nper: Total number of payments.pmt: The payment each period.fv(optional): Final balance (default 0).type(optional): 0 (default) = payments at the end of each period, 1 = at the start.