# CUMPRINC

The `CUMPRINC` function calculates the cumulative principal paid on a loan between two periods. It is commonly used in financial analysis to determine the total principal paid on a loan during a specific time period. The function uses the declining balance method to calculate the interest and principal payments on a loan.

## Usage

Use the `CUMPRINC` formula with the syntax shown below, it has 6 required parameters:

Parameters:
1. rate (required):
The interest rate per period for the loan.
2. number_of_periods (required):
The total number of payment periods for the loan.
3. present_value (required):
The present value of the loan, or the amount borrowed.
4. first_period (required):
The first payment period for which to calculate the cumulative principal paid.
5. last_period (required):
The last payment period for which to calculate the cumulative principal paid.
6. end_or_beginning (required):
A string indicating whether payments are due at the end or beginning of each period. Use "END" for payments due at the end of each period or "BEGINNING" for payments due at the beginning of each period.

## Examples

Here are a few example use cases that explain how to use the `CUMPRINC` formula in Google Sheets.

### Calculate cumulative principal paid on a loan

Use `CUMPRINC` to determine the total principal paid on a loan over a specific time period.

### Calculate principal paid in a single period

Use `CUMPRINC` with the same value for `first_period` and `last_period` to calculate the principal paid in a single payment period.

### Calculate total interest paid on a loan

Use `CUMIPMT` with the same arguments as `CUMPRINC`, but replace the first argument with the interest rate per period, to calculate the total interest paid on a loan over a specific time period.

## Common Mistakes

`CUMPRINC` not working? Here are some common mistakes people make when using the `CUMPRINC` Google Sheets Formula:

### Incorrect use of rate argument

Users sometimes enter the rate argument as a whole number instead of a decimal, resulting in incorrect calculations. Make sure to convert the rate to a decimal before entering it.

### Incorrect use of first_period argument

Users sometimes enter the first_period argument as a negative number or zero, resulting in errors. Make sure to enter a positive number for the first period.

### Incorrect use of end_or_beginning argument

Users sometimes enter the end_or_beginning argument as an incorrect string ('E' or 'B') or as a number. Make sure to enter the correct string ('END' or 'BEGINNING') for the argument.

The following functions are similar to `CUMPRINC` or are often used with it in a formula:

• `PPMT`

The `PPMT` function calculates the payment on the principal of an investment or loan given the interest rate, number of periods, and present value. It is commonly used in financial analysis to calculate the principal portion of a loan or investment payment. The function returns a negative number because it represents a payment toward the principal balance, which reduces the overall balance.

• `IPMT`

The `IPMT` function calculates the interest payment for a given period of an investment or loan. It is commonly used to determine the interest portion of a loan payment. This function can be helpful when creating loan amortization schedules or when analyzing the cost of borrowing money.

• `FV`

The `FV` function calculates the future value of an investment based on periodic constant payments and a constant interest rate. It takes into account the present value of the investment, the number of periods in which the payments are made, and the compounding frequency. This formula is commonly used in financial planning and investment analysis.

• `PV`

The `PV` function in Google Sheets calculates the present value of a regular payment stream or a lump sum amount, based on a constant interest rate. It is commonly used in financial analysis to determine the value of investments or loans. This function returns a negative value, as it represents money flowing out from the user.

You can learn more about the `CUMPRINC` Google Sheets function on Google Support.