WorksheetFunction.CumIPmt Method
| Excel Developer Reference |
Returns the cumulative interest paid on a loan between start_period and end_period.
Syntax
expression.CumIPmt(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