FVSCHEDULE Function
Grows an amount through a series of different interest rates.
Category
Financial
Available in
All versions, Microsoft 365
Returns
A future value
Want to practice FVSCHEDULE in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
FVSCHEDULE compounds a starting amount through a list of rates, one per period — ideal when the rate changes every year.
It's the same as multiplying principal × (1+r1) × (1+r2) × …
Syntax
=FVSCHEDULE(principal, schedule) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| principal | Yes | The starting amount. |
| schedule | Yes | A range or array of the rates to apply, in order. |
Examples
Example 1 — Variable deposit rates
Northstar's $100,000 deposit earns a different rate each year.
B6fx=FVSCHEDULE(100000,B2:B5)
| A | B | |
|---|---|---|
| 1 | Year | Rate |
| 2 | 1 | 4% |
| 3 | 2 | 5.5% |
| 4 | 3 | 3.2% |
| 5 | 4 | 6% |
| 6 | Value after 4 years | $120,024.90 |
Common mistakes
- Blank cells in the schedule. Blanks count as 0% — fine — but text causes #VALUE!.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.