FVSCHEDULE FunctionWayne Becker
The FVSCHEDULE function calculates the Future Value of an investment with a variable interest rate.
||The present value of the investment
||An array of values, that provides the schedule of interest rates to be applied to the principal
||If provided as a range of cells, these may contain numeric values or be empty (empty cells denote a zero interest rate)
The following spreadsheet shows the FVSCHEDULE function used to calculate the future value of an investment of $10,000, over 3 years. The investment earns interest of 9% during the first year, 10% the 2nd year, and 11% the 3rd year.
||Future value of $10,000 with compound annual interest rates of 9%, 11%, and 10%
Common Function Error(s)
||What went wrong
||Occurs if any of the supplied arguments are non-numeric
||(blank cells as a part of the schedule array are acceptable and are treated as the numeric value 0)
||Occurs when Analysis ToolPak add-in is not enabled