The interest rates can vary in each period.
Example
In the example shown, an initial sum of $1000 is invested for 4 years.
The formula in F5 is:
FVSCHEDULE returns $1,147.26, whencurrency number formatis applied.
FVSCHEDULE Function
The Excel FVSCHEDULE function returns the future value of a single sum based on a schedule of given interest rates. FVSCHEDULE can be used to find the future value of an investment with a variable or adjustable rate.
