PV Function in Excel (Present Value)

Originally published at: How to use the PV Function in Excel (Present Value) - Excelbuddy.com

The PV function in Excel returns the present value of an investment. The alternative function is the FV function (Future Value). The PV Function is used to obtain the current value of a future sum of money. Let’s walk through how this calculation is done below. Syntax: =PV (rate, nper, pmt, [fv], [type]) rate =…