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
| App | Support | Syntax & notes |
|---|---|---|
| Excel | ✔ Built in | FV(rate, nper, pmt, [pv], [type]) |
| Google Sheets | ✔ Built in | FV(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). |
| 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)) |
Excel & Sheets use cell ranges. Paste this sample data into cell A1 of a blank sheet, then paste the formula into any empty cell.
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
| Argument | What it means |
|---|---|
rate | Interest rate per period, e.g. 5%/12 for monthly compounding at 5% a year. |
nper | Total number of periods, e.g. 10*12. |
pmt | Payment made each period. Deposits are money going out, so enter them as negative numbers. |
[pv] optional | Starting balance, also negative if it is money you put in. Defaults to 0. |
[type] optional | 0 (default) = payments at the end of each period, 1 = at the beginning. |
Examples
| Formula | Result | Why | Copy |
|---|---|---|---|
=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.84 | A single lump sum compounding yearly for 20 years. | |
=FV(0, 12, -100) | 1200 | No 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.