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).
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.