**Public Function FutureValueSchedule( _
ByVal vPrincipal As Variant _
, ParamArray vValues() As Variant _
) As Variant**

**Calculate the future value of an initial principal amount after applying a series of compound interest rates. **

Use to calculate the future value of an investment with a variable or adjustable interest rates.

**Example:** What is the future value of $10,000 which is compounded at 7%, 8%, 9%, and 9.5%? Approximately $13,792.66. FutureValueSchedule(10000, 0.07, 0.08, 0.09, 0.095) = 13792.6638
FutureValueSchedule(10000, Array(0.07, 0.08, 0.09, 0.095)) = 13792.6638

**See also:** FVSCHEDULE Function (Microsoft Excel)

**vPrincipal:** Present value amount. Function returns Null if vPrincipal is Null or cannot be interpreted as a number.

**vValues:** The interest rates that are to be applied. Can be numbers, one-dimensional numeric arrays, one-dimensional Variant arrays, one-dimensional Variant arrays with embedded arrays, or any combination of these.

**v2.0 Addition:** This function is new to this version of Entisoft Tools. Copyright 1996-1999 Entisoft

Entisoft Tools is a trademark of Entisoft.