Documentation/Calc Functions/CUMIPMT
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
Function name:
CUMIPMT
Category:
Financial Analysis
Summary:
Calculates the cumulative interest payments, that is, the total interest, for an investment based on a constant interest rate.
Syntax:
CUMIPMT(Rate; NPer; PV; S; E; Type)
Returns:
Returns a negative real number(in currency units) which is the cumulative interest payment on the loan with given arguments. Here negative sign indicates the amount is a debt.
Arguments:
Rate is a positive real number or a reference to the cell containing that number which is the periodic interest rate.
NPer is a positive real number or a reference to the cell containing that number which is the payment period with the total number of periods. Nper can also be a non-integer value.
PV is a positive real number or a reference to the cell containing that number which is the current value in the sequence of payments.
S is a positive real number or a reference to the cell containing that number which is the first period.
E is a positive real number or a reference to the cell containing that number which is the last period.
Type is the due date of the payment at the beginning or end of each period.
Type | Maturity Date |
---|---|
0 | due at the end |
1 | due at the beginning |
- If Rate, NPer or PV. are less than or equal to 0 then the function will return an error value.
- If S or E are non-integer values then the function uses their floor values, i.e. they are truncated to integers.
- If S(after truncation) is less than 1 or greater than E(after truncation) then the function returns an error value.
- If E(after truncation) is greater than NPer then the function returns an error value.
- If Type is any thing accept 0 or 1, then the function returns an error value.
Additional details:
- The formula for CUMIPMT is:
where Rate is Rate, Start is S, End is E, Periods is NPer, Value is PV and Type is Type.
Examples:
Formula | Description | Returns |
---|---|---|
=CUMIPMT(5.5%/12;24;5000;4;6;1) | The function calculates the interest payments at a yearly interest rate of 5.5 %, a payment period of monthly payments for 2 years and a current cash value of 5,000 currency units. The start period is the 4th and the end period is the 6th period. The payment is due at the beginning of each period. | -57.54 (currency units) |
=CUMIPMT(5.5%/12;24;5000;4;6;0) | The function calculates the interest payments at a yearly interest rate of 5.5 %, a payment period of monthly payments for 2 years and a current cash value of 5,000 currency units. The start period is the 4th and the end period is the 6th period. The payment is due at the end of each period. | -57.80 (currency units) |
=CUMIPMT(5.5%/12;24;5000;4;6;2) | The function returns an error for any value of Type except for 0 or 1. | Err:502 |
=CUMIPMT(5.5%/12;24;5000;0.9;6;1) | The function returns an error since S is less than 1. | Err:502 |
Related LibreOffice functions:
ODF standard:
Equivalent Excel functions:
CUMIPMT