FVSCHEDULE function
FVSCHEDULE compounds a starting amount through a list of different interest rates, one per period, and returns the result. It suits variable-rate investments where each year's rate differs.
Example
Read it as a sentence: grow 1000 by the rates in U1:U3 one after another (5%, 6% and 4%), which gives 1157.52.
Excel shows 1157.52
U
1
0.05
2
0.06
3
0.04
Data
Syntax
FVSCHEDULE(principal, schedule)
-
principal(required) - Starting amount.
-
schedule(required) - Range or array of interest rates, one per period.
Returns: Principal grown through the series of rates.
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 |
|---|---|---|
=FVSCHEDULE(1000,{0.05,0.06}) | 1113 | Array |
=FVSCHEDULE(1000,{-1}) | 0 | Negative rate |
=FVSCHEDULE("1000",{0.05}) | 1050 | Text number principal |
=FVSCHEDULE(1000,Data!U1:U3) | 1157.52 | Range |
=FVSCHEDULE(1000,Data!D1:D3) | 1000 | Blank rates (0) |
=FVSCHEDULE(1000,{0.05,"a"}) | #VALUE! | Text in array |
=FVSCHEDULE(1000,{0.05,"0.06"}) | #VALUE! | Text number in array |
=FVSCHEDULE(1000,{TRUE}) | #VALUE! | TRUE in array |
The Data sheet these formulas read
A cell that starts with = holds that formula.
D
U
1
0.05
2
0.06
3
0.04
Data
Watch out for
- Rates are applied in order, so each entry is one period.
- Blank cells in the schedule count as zero.
Where it works
- Excel
- FVSCHEDULE 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 .