Search
Clear search
Close search
Google apps
Main menu

CUMPRINC

Calculates the cumulative principal paid over a range of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.

Sample Usage

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

CUMPRINC(A2,B2,C2,D2,E2,1)

Syntax

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

  • rate - The interest rate.

  • number_of_periods - The number of payments to be made.

  • present_value - The current value of the annuity.

  • first_period - The number of the payment period to begin the cumulative calculation.

    • first_period must be greater than or equal to 1.
  • last_period - The number of the payment period to end the cumulative calculation.

    • last_period must be greater than first_period.
  • end_or_beginning - Whether payments are due at the end (0) or beginning (1) of each period.

Notes

  • Ensure that consistent units are used for rate and number_of_periods. For example, a car loan for 36 months may be paid monthly, in which case the annual percentage rate should be divided by 12 and the number of payments is 36. On the other hand, a different type of loan of the same length might be paid quarterly, in which case the annual percentage rate should be divided by 4 and the number of payments would be 12.

See Also

RATE: Calculates the interest rate of an annuity investment based on constant-amount periodic payments and the assumption of a constant interest rate.

PV: Calculates the present value of an annuity investment based on constant-amount periodic payments and a constant interest rate.

PMT: Calculates the periodic payment for an annuity investment based on constant-amount periodic payments and a constant interest rate.

NPER: Calculates the number of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.

IPMT: Calculates the payment on interest for an investment based on constant-amount periodic payments and a constant interest rate.

FVSCHEDULE: Calculates the future value of some principal based on a specified series of potentially varying interest rates.

FV: Calculates the future value of an annuity investment based on constant-amount periodic payments and a constant interest rate.

CUMIPMT: Calculates the cumulative interest over a range of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.

Examples

Mary is a Docs & Drive expert and author of this help page. Leave her feedback below about the page.

Was this article helpful?
How can we improve it?