Summary

The Excel CUMPRINC function is a financial function that returns the cumulative principal paid on a loan between a start period and an end period. You can use CUMPRINC to calculate and verify the total principal paid on a loan, or the principal paid between any two payment periods.

Purpose 

Get cumulative principal paid on a loan

Return value 

The principal amount

Arguments 

  • rate - The interest rate per period.
  • nper - The total number of payments for the loan.
  • pv - The present value, or total value of all payments now.
  • start_period - First payment in calculation.
  • end_period - Last payment in calculation.
  • type - When payments are due. 0 = end of period. 1 = beginning of period.

Syntax 

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

Usage notes 

  1. Be consistent with inputs for rate. For example, for 5-year loan with 4.5% annual interest, enter the rate as 4.5%/12.
  2. The loan value (pv) must be entered as a positive value.
Dave Bruns Profile Picture

AuthorMicrosoft Most Valuable Professional Award

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.