<-- Previous || Up || Next -->

Future Value Schedule Function
Math Financial Class

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.