CUMPRINC Function
The CUMPRINC function in Google Sheets calculates the cumulative principal paid on a loan between two periods.
Syntax
CUMPRINC(rate, number_of_periods, present_value, first_period, last_period, end_or_beginning)
rate: The interest rate for each period.number_of_periods: The total number of payment periods.present_value: The present value, or the total value of all loan payments.first_period: The first period in the calculation.last_period: The last period in the calculation.end_or_beginning: Specifies when payments are due. Use 0 for payments due at the end of the period, and 1 for payments due at the beginning.
Examples
- Basic Cumulative Principal Calculation
Calculate the principal paid between periods 1 and 12 for a loan with a 5% annual interest rate, over 5 years, with a $10,000 present value:
=CUMPRINC(0.05/12, 60, 10000, 1, 12, 0)
This will output the cumulative principal paid in the first year.
- Principal Calculation with Payments at Beginning of Period
Calculate with payments at the beginning of the period:
=CUMPRINC(0.05/12, 60, 10000, 1, 12, 1)
This will output the cumulative principal considering payments at the beginning.
Notes
- The function helps to track the principal portion of payments over time.
- Ensure that the first_period and last_period are within the range of total periods.