WorksheetFunction.CumIPmt (Excel)

Returns the cumulative interest paid on a loan between start_period and end_period.

The following table lists values used in Arg6.

CumIPmt (Arg1, Arg2, ..., Arg6)

Dim dblCumIPmt As Double
dblCumIPmt = WorksheetFunction.CumIPmt(Arg1:=, Arg2:=, Arg3:=, Arg4:=, Arg5:=, Arg6:=)

Arguments

Arg1 - The interest rate

Arg2 - The total number of payment periods

Arg3 - The present value

Arg4 - The first period in the calculation. Payment periods are numbered beginning with 1

Arg5 - The last period in the calculation

Arg6 - The timing of the payment