WorksheetFunction.FVSchedule (Excel)

Returns the future value of an initial principal after applying a series of compound interest rates. Use FVSchedule to calculate the future value of an investment with a variable or adjustable rate.

The values in schedule can be numbers or blank cells; any other value produces the #VALUE! error value for FVSchedule. Blank cells are taken as zeros (no interest).

FVSchedule (Arg1, Arg2)

Dim dblFVSchedule As Double
dblFVSchedule = WorksheetFunction.FVSchedule(Arg1:=, Arg2:=)

Arguments

Arg1 - Principal - the present value

Arg2 - Schedule - an array of interest rates to apply