Google Sheets function

FV in Google Sheets

FV 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 FV Excel guide; check the function help in Google Sheets for its own argument list.

	A	B	C
1	Rate	Months	Deposit
2	0.05	120	200

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

Result: 31056.46

Depositing 200 a month for ten years at 5% grows to about 31,056.

	A
1	Deposit
2	1000

Formula: C2: =ROUND(FV(0.04,10,0,-A2),2)

Result: 1480.24

With no regular payment, 1,000 at 4% for ten years becomes about 1,480.

	A	B	C	D
1	Rate	Months	Deposit	Start
2	0.05	120	200	5000

Formula: F2: =ROUND(FV(A2/12,B2,-C2,-D2),2)

Result: 39291.5

The 5,000 already saved is added through the pv argument and grows alongside the deposits.

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

Formula in D2: =FV(5%/12,12,-200,-1000)

Result in D2: 3506.9329962

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