Calculate present value
=PV(B4,B3,0,-B2)Excel · result on the sample sheet: $31,370.62
Describe what you need and get a working PV formula for Excel and Google Sheets, tested on real data before you copy it. PV calculates what a series of future payments, or a single future amount, is worth today at a given interest rate.
Each formula below was calculated on its own sample sheet. Open one to see the sheet, why it works, and to try it yourself.
=PV(B4,B3,0,-B2)Excel · result on the sample sheet: $31,370.62
=PV(B3/12,B4*12,-B2)Excel · result on the sample sheet: $38,232.98
=PV(B4/B6,B5*B6,-B2*B3/B6,-B2)Excel · result on the sample sheet: $925.21
You describe the task in plain English, and it writes the formula, using PV where that's the right tool, for your table or a sample one. The formula is run in our engine in Excel and Google Sheets mode before you see it, so you get its result, not just a guess.
PV calculates what a series of future payments, or a single future amount, is worth today at a given interest rate.
Yes. Each example below opens a page where you try the formula in a live grid and it's checked as you go, and the PV function page has a practice exercise.