Exceljet

Quick, clean, and to the point

Excel CUMPRINC Function

Excel CUMPRINC function
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
Syntax 
=CUMPRINC (rate, nper, pv, start_period, end_period, type)
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.
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.
Related functions 
Excel FV function
Excel FV Function
The Excel FV function is a financial function that returns the future value of an investment. You can use the FV function to get the future value of an investment assuming periodic, constant payments with a constant interest rate.
Excel PV function
Excel PV Function
The Excel PV function is a financial function that returns the present value of an investment. You can use the PV function to get the value in today's dollars of a series of future payments, assuming periodic, constant payments and a constant...
Excel RATE function
Excel RATE Function
The Excel RATE function is a financial function that returns the interest rate per period of an annuity. You can use RATE to calculate the periodic interest rate, then multiply as required to derive the annual interest rate. The RATE function...
Excel NPER function
Excel NPER Function
The Excel NPER function is a financial function that returns the number of periods for loan or investment. You can use the NPER function to get the number of payment periods for a loan, given the amount, the interest rate, and periodic payment...
Excel PMT function
Excel PMT Function
The Excel PMT function is a financial function that returns the periodic payment for a loan. You can use the NPER function to figure out payments for a loan, given the loan amount, number of periods, and interest rate.
Excel PPMT function
Excel PPMT Function

The Excel PPMT function can be used to calculate the principal portion of a given loan payment. For example, you can use PPMT to get the principal amount of a payment for the first period, the last period, or any period in between.

Excel IPMT function
Excel IPMT Function

The Excel IPMT function can be used to calculate the interest portion of a given loan payment in a given payment period. For example, you can use IPMT to get the interest amount of a payment for the first period, the last period, or any period in...

Excel CUMPRINC function
Excel CUMPRINC Function
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...
Excel CUMIPMT function
Excel CUMIPMT Function
The Excel CUMIPMT function is a financial function that returns the cumulative interest paid on a loan between a start period and an end period. You can use CUMIPMT to calculate and verify the total interest paid on a loan, or the interest paid...
500 Formula Examples, thoughtfully explained.