WorksheetFunction.CumPrinc (Excel)

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

The following table lists values used in Arg6.

CumPrinc (Arg1, Arg2, ..., Arg6)

Dim dblCumPrinc As Double
dblCumPrinc = WorksheetFunction.CumPrinc(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