Calculates the cumulative principal paid for an investment based on a constant interest rate.

### **Sample Usage**

CUMPRINC(0.12,12,100,1,5,0)

CUMPRINC(A2,A3,A4,1,1,0)

**Syntax**

CUMPRINC(rate, total_periods, present_value, first_period, last_period, type)

- rate - The annualized rate of interest.

- total_periods - The total number of payment periods.
- present_value - The present value of the annuity.
- first_period - The first period in the calculation.
- last_period - The last period in the calculation.
- type - [OPTIONAL] The due date type for the payment – at the beginning (0) or end of each period (1).

**Examples**

CUMPRINC(A2,A3,A4,1,1,0) returns the principal paid in a single payment in the first month.

**Notes**

- Ensure that consistent units are used for rate and total_periods