Documentation/Calc Functions/CUMPRINC ADD

Function name:
CUMPRINC_ADD

Category:
Financial Analysis

Summary:
Calculates the cumulative redemption of a loan in a period.

Syntax:
CUMPRINC_ADD(Rate; NPer; PV; StartPeriod; EndPeriod; Type)

Returns:
Returns the cumulative interest paid for an investment period with a constant interest rate.

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 CUMPRINC_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/CUMIPMT_ADD CUMIPMT_ADD]

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

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

ODF standard:
None

Equivalent Excel functions:
None