FUNCTION CATALOGUE / FINANCIAL
PV Excel function
Calculates present value.
Correct sentence to use
Calculate present value using rate [rate], [periods] periods, and payment [payment].
Modify this query in PlainFormula →Example formula
=PV(5%/12,60,-200)
Returns present value.
Syntax
PV(rate, nper, pmt, [fv], [type])
Argument signature: rate, nper, pmt, [fv], [type]
Availability note
Commonly available in current Excel; verify platform and locale-specific behaviour.