# Documentation/Calc Functions/CUMPRINC ADD

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

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

Type | Maturity Date |
---|---|

0 | due at the end |

1 | due at the beginning |

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

## Examples:

Formula | Description | Returns |
---|---|---|

=CUMPRINC_ADD(5.5%/12;36;15000;10;18;0) | The function calculates 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. | -₹3,669.74 (currency units) |

=CUMPRINC_ADD(5.5%/12;36;15000;10;18;1) | The function calculates 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 beginning of each period. | -3,652.99 (currency units) |

=CUMPRINC_ADD(5.5%/12;36;15000;10;18;2) | The function returns an error for any value of Type except for 0 or 1. |
Err:502 |

=CUMPRINC_ADD(5.5%/12;36;15000;0.9;18;1) | The function returns an error since S is less than 1. |
Err:502 |

## Related LibreOffice functions:

## ODF standard:

None

## Equivalent Excel functions:

None