# CUMPRINC

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## Content



This function returns the cumulative principal paid on a loan between the start and end periods.

## Syntax

CUMPRINC(*rate*,*nper*,*pval*,*startperiod*,*endperiod*,*paytype*)

## Arguments

This function has these arguments:

| **Argument** | **Description** |
| -------- | ----------- |
| *rate* | Interest rate |
| *nper* | Total number of payment periods |
| *pval* | Present value |
| *startperiod* | Starting period |
| *endperiod* | Ending period |
| *paytype* | Type of payment timing; can be any of: |
|   |      0 - Payment at end of the period |
|   |      1 - Payment at beginning of the period |

## Remarks

This functions returns a #NUM! error when *rate*, *nper*, or *pval* is negative or zero. Nper, startperiod, endperiod, and paytype are truncated to integers. If startperiod or endperiod is less than 1 or startperiod is greater than endperiod, a #NUM! error is returned. If paytype is a number other than 0 or 1, a #NUM! error is returned.

## Data Types

Accepts numeric and DateTime object data. Returns numeric data.

## Examples

<span class="Example" style="box-sizing: border-box;">CUMPRINC(B2/12,B4\*12,C4,14,20,0)</span>
<span class="Example" style="box-sizing: border-box;">CUMPRINC(B2/12,B4\*12,C4,14,20,0)</span>

## Version Available

This function is available in product version 2.0 or later.

## See Also

[CUMIPMT](https://developer.mescius.com/spreadnet/docs/latest/online-formula/FunctionCUMIPMT.html) \| [IPMT](https://developer.mescius.com/spreadnet/docs/latest/online-formula/FunctionIPMT.html) \| [Financial Functions](https://developer.mescius.com/spreadnet/docs/latest/online-formula/formulas-functsfinance.html)

<br>