How to Use FV() in Google Sheets

Description

Calculates the future value of an annuity investment based on constant-amount periodic payments and a constant interest rate.

How To Actually Use FV() in Sheets

FV(rate, number_of_periods, payment_amount, [present_value], [end_or_beginning])

Try FV yourself

In cells A1 to A3, enter the interest rate (5%), number of periods (10), and payment amount (100). Use the FV formula in cell A5 to calculate the future value of the investment based on these inputs.

Your formula

Hints (2)

Locale Separator ,

Official Docs

Better Sheets Tutorial

Free Education Expense Template

Get this free education funding template I use myself. I use it and enjoy it. Thought you would too.

FV() JOIN() SUMIF() TODAY() YEAR()

Transcript-matched member videos for FV(). Click through to watch.

Watch more tutorials

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition,...

SUMIF() UNIQUE()

Unlock these tutorials

Learn more about the FV() formula:

Generate a FV() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses FV(). 2 free AI generations, no signup. Members get unlimited use.

Generate a FV() formula

How to Use FV() in Google Sheets

Try FV yourself

Free Education Expense Template

More related tutorials

Hardest Formula: SumIF | Addition Based on Dates / Values