## Calculate cumulative loan principal payments in Excel

To calculate the cumulative principal paid between any two loan payments, you can use the CUMPRINC function. Formula =CUMPRINC(rate,nper,pv,start,end,type) Explanation In the example shown, we calculate the total principal paid over the full term of the loan by using the first and last period. The formula in C10 is: =CUMPRINC(C6/12,C8,C5,1,60,0) How this formula works For this example, …