Spreadsheet formulas explained, side by side

FV Function in Excel, Google Sheets, Airtable & Notion

FV returns the value of an investment at the end of a term, given a constant interest rate, regular payments and an optional starting balance.

Syntax in each app

AppSupportSyntax & notes
Excel✔ Built inFV(rate, nper, pmt, [pv], [type])
Google Sheets✔ Built inFV(rate, number_of_periods, payment_amount, [present_value], [end_or_beginning])
Airtable≈ Workaround-(pv * POWER(1 + rate, nper) + pmt * (POWER(1 + rate, nper) - 1) / rate)
No FV function in Airtable; this is the compound-interest formula with Excel's sign convention (deposits negative, result positive).
Notion≈ Workaround-(pv * pow(1 + rate, nper) + pmt * (pow(1 + rate, nper) - 1) / rate)
No fv() in Notion; use the closed-form formula. It divides by zero when the rate is 0, where the answer is simply -(pv + pmt * nper).
Try FV with your own values
Negative: money you pay in
Negative if you pay it in
%
Result (as Excel & Google Sheets return it)
$32,703.47
Your formula, ready to paste
Excel=FV(5%/12, 10*12, -200, -1000) open excel.new ↗
Google Sheets=FV(5%/12, 10*12, -200, -1000) open sheets.new ↗
Airtable
workaround
-((-1000) * POWER(1 + 0.05/12, 10*12) + (-200) * (POWER(1 + 0.05/12, 10*12) - 1) / (0.05/12))
Notion
workaround
-((-1000) * pow(1 + 0.05/12, 10*12) + (-200) * (pow(1 + 0.05/12, 10*12) - 1) / (0.05/12))

Deposits are entered as negative numbers (money leaving you), so the future value you get back is positive. The annual rate is divided by the periods per year, and years are multiplied by it.

Arguments

ArgumentWhat it means
rateInterest rate per period, e.g. 5%/12 for monthly compounding at 5% a year.
nperTotal number of periods, e.g. 10*12.
pmtPayment made each period. Deposits are money going out, so enter them as negative numbers.
[pv] optionalStarting balance, also negative if it is money you put in. Defaults to 0.
[type] optional0 (default) = payments at the end of each period, 1 = at the beginning.

Examples

FormulaResultWhyCopy
=FV(5%/12, 10*12, -200, -1000)32703.47$1,000 now plus $200 a month for 10 years at 5%.
=FV(7%, 20, 0, -10000)38696.84A single lump sum compounding yearly for 20 years.
=FV(0, 12, -100)1200No interest: just the deposits added up.

Examples use Excel / Google Sheets syntax unless noted.

How FV works

FV answers "how much will I have?": a savings plan with monthly deposits, a lump sum left to compound, or a mix of both. As with every Excel financial function, rate and nper must use the same period. Monthly deposits at 5% a year for 10 years means rate = 5%/12 and nper = 10*12; the result also assumes interest compounds monthly.

The sign convention trips people up. Money you pay in (pmt and pv) is negative and money you get back is positive, so =FV(5%/12, 120, -200, -1000) returns a positive balance. If you enter the deposits as positive numbers the answer is the same size but negative. Set type to 1 if deposits are made at the start of each period; that adds one extra period of interest to every deposit.

Airtable and Notion have no FV function, but the closed-form formula is exact: the copy buttons write it out with the same signs as Excel. The formula divides by the rate, so for a 0% rate use -(pv + pmt * nper) instead.

Frequently Asked Questions

Why does FV return a negative number?
You entered the deposits as positive numbers. Excel treats them as money you receive, so the future value is something you would owe. Enter deposits as negatives or wrap the result in -FV(…).
How do I calculate compound interest on a single amount?
Set pmt to 0: =FV(7%, 20, 0, -10000). That is the same as =10000*(1+7%)^20.

Part of the Financial functions. Results in the tester follow Excel and Google Sheets behaviour; always double-check important work in your own file.