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. Example: What is the future value of $10,000 which is compounded at 7%, 8%, 9%, and 9.5%? Approximately $13,792.66.
Use to calculate the future value of an investment with a variable or adjustable interest rates.
FutureValueSchedule(10000, 0.07, 0.08, 0.09, 0.095) = 13792.6638
FutureValueSchedule(10000, Array(0.07, 0.08, 0.09, 0.095)) = 13792.6638See 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.