FVSCHEDULE
Returns the future value of an initial principal after applying a series of compound interest rates.
FinancialFinance & Accounting
What it does
Calculates future value with variable interest rates.
Syntax
FVSCHEDULE(principal, schedule)
Arguments
principal(number) — Initial value.schedule(range) — Array of interest rates.
Examples
Variable Rates
FV of $1000 with rates 5%, 4%, 6%.
FORMULA
=FVSCHEDULE(1000, A2:A4)
RESULT
1157.52
SAMPLE DATA
| A | |
|---|---|
| 1 | Rates |
| 2 | 0.05 |
| 3 | 0.04 |
| 4 | 0.06 |