Documentation/Calc Functions/CUMPRINC

Function name:
CUMPRINC

Category:
Financial Analysis

Summary:
Calculates a cumulative principal payment.

Syntax:
CUMPRINC(Rate; NPer; PV; S; E; 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.

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 anything accept 0 or 1, then the function returns an error value.

Additional details:

 * The formula for CUMPRINC 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 CUMIPMT]

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

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

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

ODF standard:
Section 6.12.12, part 2

Equivalent Excel functions:
CUMPRINC