## 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.