Calculates the cumulative interest payments for an investment based on a constant interest rate.
Sample Usage
CUMIPMT(A2,A3,A4,1,1,0)
CUMIPMT(0.12,12,100,1,5,0)
Syntax
CUMIPMT(rate, total_periods, present_value, first_period, last_period, type)
- rate - The annualized rate of interest.
- total_periods - The total number of payment periods.
- present_value - The present value of the annuity.
- first_period - The first period in the calculation.
- last_period - The last period in the calculation.
- type - [OPTIONAL] The due date type for the payment – at the beginning (0) or end of each period (1).
Examples
CUMIPMT(A2,A3,A4,1,1,0) returns the interest paid in a single payment in the first month.
Notes
- Ensure that consistent units are used for rate and total_periods.
- Divide the rate by 12 to get a monthly rate.