CUMPRINC
Formulas / CUMPRINCThe CUMPRINC function calculates the cumulative principal paid on a loan between two specified periods, providing the total amount of principal repaid over a range of payment periods.
CUMPRINC(rate, nper, pv, start_period, end_period, type)
- rate - The interest rate for each period.
- nper - The total number of payment periods in the loan or investment.
- pv - The present value or the total amount of the loan or investment.
- start_period - The first period in the range for which the cumulative principal is calculated.
- end_period - The last period in the range for which the cumulative principal is calculated.
- type - Indicates when payments are due: 0 (end of period) or 1 (beginning of period).
Examples
=CUMPRINC(0.05/12, 360, 200000, 1, 12, 0)This formula calculates the cumulative principal paid on a loan with an annual interest rate of 5%, a total of 360 monthly payments, a loan amount of $200,000, for the first 12 payment periods (months), with payments made at the end of each period. The result is the total principal paid in the first year.
=CUMPRINC(0.04/12, 240, 150000, 13, 24, 0)This formula calculates the cumulative principal paid on a loan with an annual interest rate of 4%, a total of 240 monthly payments, a loan amount of $150,000, for payment periods 13 to 24 (second year), with payments made at the end of each period. The result is the total principal paid in the second year.
Summary
The CUMPRINC function calculates the cumulative principal paid on a loan or investment between two specified periods, given a constant interest rate and periodic payments.
- The CUMPRINC function calculates the cumulative principal paid on a loan between specified periods, based on constant payments and a constant interest rate.
- The function requires input of the interest rate, number of total payment periods, present value of the loan, start and end periods for the cumulative calculation, and payment type (0 or 1).
- CUMPRINC returns a negative value, as it represents an outgoing payment from the borrower's perspective.
Frequently Asked Questions
What does the CUMPRINC function do?
Can CUMPRINC be used to calculate principal paid for a single period?
What error does CUMPRINC return if the arguments are invalid?
Can CUMPRINC handle different payment frequencies, such as quarterly or annual payments?
