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

ArgumentRequired?What it does
principalYesThe starting amount.
scheduleYesA 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)
AB
1YearRate
214%
325.5%
433.2%
546%
6Value after 4 years$120,024.90

Common mistakes

  • Blank cells in the schedule. Blanks count as 0% — fine — but text causes #VALUE!.

Notes

Kyle Stott

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.