FVSCHEDULE
Returns the future value of an initial principal after applying a series of compound interest rates. Use FVSCHEDULE to calculate future value of an investment with a variable or adjustable rate.
If this function is not available, run the Setup program to install the Analysis ToolPak. After you install the Analysis ToolPak, you must enable it by using the Add-Ins command on the Tools menu.
Syntax
FVSCHEDULE(principal,schedule)
Principal—is the present value.
Schedule—is an array of interest rates to apply.
Remarks
- If principal is nonnumeric, FVSCHEDULE returns the #VALUE! error value.
- The values in schedule can be numbers or blank cells; any other value produces the #VALUE! error value for FVSCHEDULE. Blank cells are taken as zeros (no interest).
Example
FVSCHEDULE(1,{0.09,0.11,0.1})
equals 1.33089