WorksheetFunction.FVSchedule Method

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.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Function FVSchedule ( _
    Arg1 As Object, _
    Arg2 As Object _
) As Double
'Usage
Dim instance As WorksheetFunction
Dim Arg1 As Object
Dim Arg2 As Object
Dim returnValue As Double

returnValue = instance.FVSchedule(Arg1, _
    Arg2)

double FVSchedule(
    Object Arg1,
    Object Arg2
)

Parameters

• Arg1
  Type: System.Object

  Principal - the present value.

• Arg2
  Type: System.Object

  Schedule - an array of interest rates to apply.

Return Value

Type: System.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).

See Also

Reference

WorksheetFunction Interface

WorksheetFunction Members

Microsoft.Office.Interop.Excel Namespace