Skip to content
Excel

CUMPRINC function in Excel

Returns the cumulative principal paid on a loan between two periods

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

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

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 Google Sheets

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