Functions
PV
Present value
Try it
When to use it
When should I use PV instead of NPV?
Use PV when the payments are equal and periodic; use NPV when the cash flows vary from period to period.
Use cases
Value a future lump sum in today's money
Price an annuity paying a fixed amount each year
Used in
finance · personal-finance · real-estate
Syntax
PV(rate, nper, pmt)Examples
=PV(2,12,100) // => -49.99990591617884
=PV(0.05,10,-200,1000,1) // => 1007.6510815880524