Calculates the accumulated future value of principal for a series of rates.
Sample Usage
FVSCHEDULE(1000,A2:A100)
FVSCHEDULE(B2,C2:C20)
Syntax
FVSCHEDULE(principal, schedule)
- principal - The starting capital.
- schedule - An series of interest rates to apply.
Examples
FVSCHEDULE(1000,A2:A100) returns the future value of a staring capital of 1000 with compound annual interest rates.