FVSCHEDULE(principal, schedule)
Returns the future value of an initial principal after applying compound interest rates.
principal The present value.
schedule The array of interest rates.
REMARKS
#
This function is only available if you have the Analysis ToolPak add-in installed.
#
This function can be used to calculate future value of an investment with a variable or adjustable rate.
#
The "schedule" can be numbers or blank cells.
#
If "schedule" contains blank cells then these are taken as zeros (no interest).
#
If "schedule" is not numeric, then #VALUE! is returned.
EXAMPLES
A
1 =FVSCHEDULE(1,{0.09,0.11,0.1}) = £1.33
2 =FVSCHEDULE("some text",{0.09,0.11,0.1}) = #VALUE!