CUMPRINC:
Returns the cumulative principal paid on a loan between two periods
The CUMPRINC function calculates the cumulative principal paid on a loan between two periods. It can be a very handy function and is relatively straightforward.
Using the CUMPRINC function:
Using the CUMPRINC function to calculate the interest for a single period:
The arguments for the CUMPRINC function are:
Argument

Required?

Description

rate 
Required 
The interest rate. 
nper 
Required 
The total number of payment periods. 
pv 
Required 
The present value. 
start_period 
Required 
The first period in the calculation. Payment periods are numbered beginning with 1. 
end_period 
Required 
The last period in the calculation. 
type 
Optional 
The timing of the payment 
The CUMPRINC function calculates the cumulative principal paid on a loan between two periods.