The FVSCHEDULE function is one of the financial functions. It is used to calculate the future value of an investment based on a series of changeable interest rates.
Syntax
FVSCHEDULE(principal, schedule)
The FVSCHEDULE function has the following arguments:
Argument
Description
principal
The current value of an investment.
schedule
An array or a range of interest rates.
Notes
Schedule values can be numbers or empty cells (they are interpreted as 0).