WorksheetFunction.FVSchedule Method (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.
Syntax
expression .FVSchedule(Arg1, Arg2)
expression A variable that represents a WorksheetFunction object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Arg1 |
Required |
Variant |
Principal - the present value. |
Arg2 |
Required |
Variant |
Schedule - an array of interest rates to apply. |
Return Value
Double
Remarks
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).