The CUMPRINC Function in Excel returns the cumulative principal paid on a loan between the start and end period. This is an excellent tool to quickly understand your total principle on a loan. Plus, it’s extremely easy to setup and use. Let’s take a look.


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


  • rate – The interest rate per period.
  • nper – Total number of payments for the loan.
  • pv – Present value/total value of the loan
  • start_period – First payment
  • end_period – Last payment
  • type – When payments are due. 0 = end of period. 1 = beginning of period.

CUMPRINC Function Example

Let’s look at the following Example.

Leave a Reply

RANK Function

The Excel Rank function returns the numeric value when compared to a list of numeric values. You can rank lists

Read More »


The Excel CONCATENATE function joins multiple strings into a single string. You can combine up to 30 text items together.

Read More »

VBA Comment Structure

This section of the VBA learning course reviews the Comment Structure. In every programming language, you need to have the

Read More »
Scroll to Top