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