Skip to content
Google Sheets

CUMIPMT function in Google Sheets

Calculates the cumulative interest over a range of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.

=CUMIPMT(rate, number_of_periods, present_value, first_period, last_period, end_or_beginning)

CUMIPMT syntax and parameters

Six arguments, six required.

  • ratenumberRequired

    The interest rate.

  • number_of_periodsnumberRequired

    The number of payments to be made.

  • present_valuenumberRequired

    The current value of the annuity.

  • first_periodnumberRequired

    The number of the payment period to begin the cumulative calculation. first_period must be greater than or equal to 1. If a decimal is used, the range starts at the next whole integer. For example, 2.1 becomes 3.

  • last_periodnumberRequired

    The number of the payment period to end the cumulative calculation. last_period must be greater than first_period. If a decimal is used, the range ends at the previous whole integer. For example, 4.9 becomes 4.

  • end_or_beginningnumberRequired

    Whether payments are due at the end (0) or beginning (1) of each period.

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 Excel

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 Google Sheets gets this done.