Function Math Financial Class

FutureValueSchedule

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.

Signature (Visual Basic / VBA)

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

Code Example

    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

Parameters

Parameter Description
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.

Notes & Version History

Example What is the future value of $10,000 which is compounded at 7%, 8%, 9%, and 9.5%? Approximately $13,792.66.
v2.0 Addition This function is new to this version of Entisoft Tools.