Share via


WorksheetFunction.CumPrinc Method

Excel Developer Reference

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

Syntax

expression.CumPrinc(Arg1, Arg2, Arg3, Arg4, Arg5, Arg6)

expression   A variable that represents a WorksheetFunction object.

Parameters

Name Required/Optional Data Type Description
Arg1 Required Variant The interest rate.
Arg2 Required Variant The total number of payment periods.
Arg3 Required Variant The present value.
Arg4 Required Variant The first period in the calculation. Payment periods are numbered beginning with 1.
Arg5 Required Variant The last period in the calculation.
Arg6 Required Variant The timing of the payment.

Return Value
Double

Remarks

The following tables lists values used in

Arg6

.

Type Timing
0 (zero) Payment at the end of the period
1 Payment at the beginning of the period
  • Make sure that you are consistent about the units you use for specifying rate and nper. If you make monthly payments on a four-year loan at an annual interest rate of 12 percent, use 12%/12 for rate and 4*12 for Arg2
  • Arg2
  • If rate ≤ 0, Arg2
  • If Arg4
  • If Arg6

See Also