Google Sheets function

PV in Google Sheets

PV with worked examples you can test in the live grid. The argument details are in the Excel guide.

In Google Sheets

The arguments and common errors are covered in the PV Excel guide; check the function help in Google Sheets for its own argument list.

	A	B	C
1	Rate	Months	Payment
2	0.06	60	400

Formula: E2: =ROUND(PV(A2/12,B2,-C2),2)

Result: 20690.22

A 400 monthly payment over 60 months at 6% a year services a loan of about 20,690.

	A
1	Future amount
2	10000

Formula: C2: =ROUND(PV(0.08,5,0,-A2),2)

Result: 6805.83

With pmt at 0 and the future value as a negative amount, 10,000 in five years at 8% is worth 6,805.83 today.

	A	B	C
1	Rate	Months	Payment
2	0.06	60	400

Formula: E2: =ROUND(PV(A2/12,B2,-C2,0,1),2)

Result: 20793.68

Type 1 pays each instalment a month earlier, so the supportable amount rises.

A tiny spreadsheet with example data. Edit the formula or any number and see the result.

Formula in D2: =PV(6%/12,24,-500)

Result in D2: 11281.4331109

Google Sheets is used here only as a descriptive product name. FormulaCamp is not affiliated with Google.