SheetFX
≡
<< Go back to all functions

CUMIPMT

The CUMIPMT function in Google Sheets is a powerful tool for calculating the cumulative interest over a range of payment periods for an investment. This function is particularly useful when you have constant-amount periodic payments and a constant interest rate. Learn how to apply this function effectively with our comprehensive guide.

Function Syntax and Parameters

Syntax: CUMIPMT(rate, number_of_periods, present_value, first_period, last_period, end_or_beginning)

Parameters:

  • rate: The interest rate for the investment.
  • number_of_periods: The total number of payment periods.
  • present_value: The current value or principal of the investment.
  • first_period: The first period from which to calculate the cumulative interest.
  • last_period: The last period up to which to calculate the cumulative interest.
  • end_or_beginning: [Optional] Specifies whether the payment is made at the end or beginning of the period. Possible values are 0 (end of the period) or 1 (beginning of the period).

Step-by-Step Tutorial

  1. Calculating cumulative interest for a loan:

    • Example: =CUMIPMT(0.05, 12, 10000, 1, 12, 0)
    • Result: The cumulative interest calculated for the loan with parameters specified.

  2. Calculating cumulative interest for an investment:

    • Example: =CUMIPMT(0.07, 8, -5000, 1, 8, 1)
    • Result: The cumulative interest calculated for the investment with parameters specified.

Use Cases and Scenarios

  1. Loan Analysis: Evaluate the cumulative interest paid for a loan over a specific period.
  2. Investment Analysis: Determine the cumulative interest earned on an investment over a given duration.
  3. Financial Planning: Calculate the cumulative interest accrued on savings or debts.

Related Functions

  • CUMPRINC: Calculates the cumulative principal over a range of payment periods.
  • IPMT: Calculates the interest payment for a specific period of an investment.
  • PPMT: Calculates the principal payment for a specific period of an investment.

Related Articles