# Documentation/Calc Functions/CUMPRINC

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## Function name:

CUMPRINC

## Category:

Financial Analysis

## Summary:

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

## Syntax:

CUMPRINC(**Rate**; **NPer**; **PV**; **S**; **E**; **Type**)

## Returns:

## Arguments:

**Rate** is the periodic interest rate.

**NPer** is the payment period with the total number of periods. **Nper** can also be a non-integer value.

**PV** is the current value in the sequence of payments.

**S** is the first period.

**E** is the last period.

**Type** is the due date of the payment at the beginning or end of each period.

## Additional details:

## Examples:

What are the payoff amounts if the yearly interest rate is 5.5% for 36 months? The cash value is 15,000 currency units. The payoff amount is calculated between the 10th and 18th period. The due date is at the end of the period.

=CUMPRINC(5.5%/12;36;15000;10;18;0) = -3669.74 currency units. The payoff amount between the 10th and 18th period is 3669.74 currency units.