Functions
FVSCHEDULE
Future value with variable rates
Try it
When to use it
When should I use FVSCHEDULE instead of FV?
Use FVSCHEDULE when interest rates vary period by period — for example, an investment earning different rates each year — whereas FV assumes a single constant rate.
Used in
Syntax
FVSCHEDULE(principal, schedule)Examples
=FVSCHEDULE(10000,{0.1,0.95,0.9,0.85}) // => 75396.75