PV
Returns the present value of an investment
Syntax
PV(rate, nper, pmt, [fv], [type])
Parameters
- rate: Required. The interest rate per period
- nper: Required. The total number of payment periods
- pmt: Required. The payment made each period
- fv: Optional. The future value (default 0)
- type: Optional. When payments are due (0=end, 1=beginning)
Example
=PV(0.08/12, 20*12, 500)