Quick Navigation

CUMIPMT Function

Excel 2007+

Summary

The CUMIPMT function calculates the total interest paid on a loan over a specific range of payment periods. It's essential for financial analysis, helping users understand interest costs during different phases of loan repayment.

Syntax

CUMIPMT(rate, nper, pv, start_period, end_period, type)

Parameters

Parameter	Type	Required	Description
rate	`Number`	Yes	Interest rate per period
nper	`Number`	Yes	Total payment periods
pv	`Number`	Yes	Loan principal (present value)
start_period	`Number`	Yes	Starting period (1-based) for calculation
end_period	`Number`	Yes	Ending period for calculation
type	`Number`	Yes	Payment timing: 0=end of period, 1=beginning

Using the CUMIPMT Function

CUMIPMT is invaluable for loan analysis and mortgage planning. Use it to determine how much interest you'll pay during the first few years of a mortgage, or to compare interest costs between different repayment phases. Always match rate and nper units (monthly rate with monthly periods).

Common CUMIPMT Examples

Interest Paid in Second Year of 30-Year Mortgage

=CUMIPMT(0.09/12,30*12,125000,13,24,0)

Calculates total interest paid during months 13-24 (second year) on a $125,000 mortgage at 9% annual rate. Result: -$11,135.23 (negative indicates payment).

First Month's Interest Payment

=CUMIPMT(0.09/12,30*12,125000,1,1,0)

Shows interest portion of the very first monthly payment: -$937.50.

Frequently Asked Questions

Excel financial functions return negative values for payments made (outflows). Use ABS() if you need positive interest amounts.

Check that rate>0, nper>0, pv>0, start_period≥1, end_period≥start_period, and type is 0 or 1.

Be consistent: use monthly rate (annual/12) with monthly periods (years*12).

Common Errors and Solutions

#NUM!

Cause: Invalid parameters (rate≤0, nper≤0, pv≤0, start_period<1, end_period<1, start_period>end_period, or type not 0/1)

Solution: Verify all parameters meet requirements and units match

#VALUE!

Cause: Non-numeric arguments

Solution: Ensure all inputs are numbers

Notes

Always use consistent time units for rate and nper
Results are negative (payment outflows) - use ABS() for positive values
Period numbering starts at 1
Type=0 (most common) assumes payments at period end
Available in Excel 2007 and later versions

Compatibility

Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365

Not available in: Excel 2003 and earlier

Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+