Documentation/Calc Functions/CUMIPMT ADD

Function name:
CUMIPMT_ADD

Category:
Financial Analysis

Summary:
Calculates the accumulated interest for a period, that is, the total interest, for an investment based on a constant interest rate.

Syntax:
CUMIPMT_ADD(Rate; NPer; PV; StartPeriod; EndPeriod; 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. Nper must refer to the same unit, and thus both be calculated annually or monthly.

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.

StartPeriod is a positive real number or a reference to the cell containing that number which is the first period.

EndPeriod 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 StartPeriod or EndPeriod are non-integer values then the function uses their floor values, i.e. they are truncated to integers.
 * If StartPeriod(after truncation) is less than 1 or greater than EndPeriod(after truncation) then the function returns an error value.
 * If EndPeriod(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_ADD is:

where Rate is Rate, Start is StartPeriod, End is EndPeriod, Periods is NPer, Value is PV and Type is Type.

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

[[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:
None

Equivalent Excel functions:
None