Documentation/Calc Functions/CUMIPMT

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.


 * 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.

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/CUMIPMT_ADD CUMIPMT_ADD]

[[Special:MyLanguage/Documentation/Calc_Functions/CUMPRINC CUMPRINC]

[[Special:MyLanguage/Documentation/Calc_Functions/CUMPRINC_ADD CUMPRINC_ADD]

[[Special:MyLanguage/Documentation/Calc_Functions/IPMT IPMT]

ODF standard:
Section 6.12.11, part 2

Equivalent Excel functions:
CUMIPMT