Skip to content
Excel

CUMIPMT function in Excel

Returns the cumulative interest paid between two periods

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

CUMIPMT syntax and parameters

Six arguments, six required.

  • ratenumberRequired

    The interest rate.

  • npernumberRequired

    The total number of payment periods.

  • pvnumberRequired

    The present value.

  • start_periodnumberRequired

    The first period in the calculation. Payment periods are numbered beginning with 1.

  • end_periodnumberRequired

    The last period in the calculation.

  • typenumberRequired

    The timing of the payment.

CUMIPMT examples

Formulas you'll actually reuse.

  1. Total interest paid in the first year of the mortgage (negative = paid out):

    =CUMIPMT(5%/12, 360, 250000, 1, 12, 0)

    Result-12416.24

  2. Total interest over the whole loan:

    =CUMIPMT(5%/12, 360, 250000, 1, 360, 0)

    Result-233139.46

CUMIPMT in Google Sheets

Same name — your formula ports as-is.

Try CUMIPMT in the playground

Edit the example — nothing to install.

Preloaded with the CUMIPMT formula from Example 1 — change anything and watch it respond.

Loading the editor…

CUMIPMT errors

What they mean — and the fixes.

  • #NUM!

    start_period is less than 1, end_period is before start_period, or the type isn't 0 or 1.

Related functions

More ways Excel gets this done.