CUMPRINC

• How to use CUMPRINC formula?
• Examples of using CUMPRINC formula
• CUMPRINC formula not working?
• Similar formulas to CUMPRINC

Usage

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

=CUMPRINC(rate, number_of_periods, present_value, first_period, last_period, end_or_beginning)

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

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

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.

Related Formulas

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.

Learn More

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