FV function
FV returns the future value of an investment or loan, projecting what regular payments plus any starting balance will grow to at a fixed interest rate. It is a basic tool for savings projections.
Example
Read it as a sentence: find what 10 payments of $100 at 5% interest per period will be worth at the end, which gives 1257.78925355488.
A
B
C
D
1
1257.78925355488
2
3
Syntax
FV(rate, nper, pmt, [pv], [type])
Arguments in [square brackets] are optional.
-
rate(required) - Interest rate per period.
-
nper(required) - Total number of periods.
-
pmt(required) - Payment made each period; keep sign consistent.
-
pv(optional) - Present value; 0 if omitted.
-
type(optional) - 0 = payments at period end (default), 1 = at start.
Returns: Future value of an investment or loan.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=FV(0.05/12,120,-100) | $15,528.23 | Savings |
=FV(0.05/12,120,-100,-1000,1) | $17,239.94 | With pv and type |
=FV(0,10,-100) | $1,000.00 | Rate 0 |
=FV(0.05,0,-100,-1000) | $1,000.00 | Nper 0 |
=FV(0.05,-10,-100) | ($772.17) | Negative nper |
=FV(-1,10,-100) | $100.00 | Rate -1 |
=FV(10,1000,-1) | #NUM! | Overflow |
=FV("a",10,-100) | #VALUE! | Text |
Watch out for
- Cash you pay out should be negative; the result then comes back positive.
- Match rate and nper units, e.g. monthly rate with months.
Where it works
- Excel
- FV is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Financial functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .