CUMIPMT DAX Function (Financial)
Returns the cumulative interest paid on a loan between start_period and end_period.
Syntax
| Parameter | Attributes | Description |
|---|---|---|
| Rate |
The interest rate. |
|
| Nper |
The total number of payment periods. |
|
| Pv |
The present value. |
|
| Start_period |
The first period in the calculation. Payment periods are numbered beginning with 1. |
|
| End_period |
The last period in the calculation. |
|
| Type |
The timing of the payment. |
Return values
Remarks
Type sets when the payment is made. Use 0 for payment at the end of the period. Use 1 for payment at the beginning of the period.
Keep Rate and Nper in the same units. For monthly payments on a four-year loan at 10 percent a year, use 0.1/12 for Rate and 4*12 for Nper. For annual payments on the same loan, use 0.1 for Rate and 4 for Nper.
Start_period, End_period, and Type are rounded to the nearest integer.
CUMIPMT returns an error in these conditions:
– Rate is less than or equal to 0.
– Nper is less than 1.
– Pv is less than or equal to 0.
– Start_period is less than 1 or greater than End_period.
– End_period is greater than Nper.
– Type is not 0 or 1.
Examples
-- CUMIPMT and CUMPRINC for a loan with these terms:
-- Annual rate 9%, 30 years, present value 125000, monthly payments
-- Row 1: interest and principal in the second year (periods 13-24), payment at beginning
-- Row 2: interest and principal in the first month (period 1), payment at end
EVALUATE
VAR Rate = 0.09 / 12
VAR Nper = 30 * 12
VAR Pv = 125000
RETURN
ADDCOLUMNS (
{
( 13, 24, 1, "Second year, begin" ),
( 1, 1, 0, "First month, end" )
},
"CUMIPMT", CUMIPMT ( Rate, Nper, Pv, [Value1], [Value2], [Value3] ),
"CUMPRINC", CUMPRINC ( Rate, Nper, Pv, [Value1], [Value2], [Value3] )
)
| Value1 | Value2 | Value3 | Value4 | CUMIPMT | CUMPRINC |
|---|---|---|---|---|---|
| 13 | 24 | 1 | Second year, begin | -11052.339583871802 | -927.1534723780624 |
| 1 | 1 | 0 | First month, end | -937.4999999999998 | -68.2782711809784 |
Last update: Nov 7, 2026 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://learn.microsoft.com/en-us/dax/cumipmt-function-dax