Skip to content
Google Sheets

CUMPRINC function in Google Sheets

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

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

CUMPRINC 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.

  • last_periodnumberRequired

    The number of the payment period to end the cumulative calculation. last_period must be greater than first_period.

  • end_or_beginningnumberRequired

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

CUMPRINC examples

Formulas you'll actually reuse.

  1. Principal repaid in the first year of the mortgage:

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

    Result-3688.41

  2. The share of the loan paid down after five years:

    =-CUMPRINC(5%/12, 360, 250000, 1, 60, 0) / 250000

    Result0.0817

CUMPRINC in Excel

Same name — your formula ports as-is.

Try CUMPRINC in the playground

Edit the example — nothing to install.

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

Loading the editor…

Related functions

More ways Google Sheets gets this done.