# CUMPRINC

The CUMPRINC function returns cumulative principal paid on a loan between two periods.

### Syntax

CUMPRINC (Rate, Nper, PV, start\_period, end\_period, Type) - > Number 

### Arguments

<table><thead><tr><th width="141">Arguments</th><th width="138">Datatype</th><th>Description</th></tr></thead><tbody><tr><td>Rate</td><td>Number, Rate</td><td>The interest rate per period.</td></tr><tr><td>Nper</td><td>Number</td><td>The total number of periods.</td></tr><tr><td>PV</td><td>Number</td><td>The present value of the loan.</td></tr><tr><td>start_period</td><td>Number</td><td>The first payment period.</td></tr><tr><td>end_period</td><td>Number</td><td>The last payment period.</td></tr><tr><td>Type</td><td>Number</td><td>Indicates when the payments are made. Type is zero if payments are made at the end of the period and non-zero if payments are made at the start of the period.</td></tr></tbody></table>

### Example

Consider a $10,000 loan at an annual rate of 10% that is to be paid off in 1.5 years. All payments are made at the beginning of the month. Calculate cumulative principal payments for all the periods.

<table><thead><tr><th width="202">Periods</th><th width="89">1</th><th width="64">2</th><th width="64">3</th><th width="64">4</th><th width="64">5</th><th width="64">6</th><th width="64">7</th><th width="64">8</th><th width="64">9</th><th width="64">10</th><th width="64">11</th><th width="64">12</th><th width="64">13</th><th width="64">14</th><th width="64">15</th><th width="64">16</th><th width="64">17</th><th width="64">18</th></tr></thead><tbody><tr><td><mark style="color:purple;">Nper</mark></td><td>18</td><td>18</td><td>18</td><td>18</td><td>18</td><td>18</td><td>18</td><td>18</td><td>18</td><td>18</td><td>18</td><td>18</td><td>18</td><td>18</td><td>18</td><td>18</td><td>18</td><td>18</td></tr><tr><td><mark style="color:red;">Loan Amount</mark></td><td>10000</td><td>10000</td><td>10000</td><td>10000</td><td>10000</td><td>10000</td><td>10000</td><td>10000</td><td>10000</td><td>10000</td><td>10000</td><td>10000</td><td>10000</td><td>10000</td><td>10000</td><td>10000</td><td>10000</td><td>10000</td></tr><tr><td>Start Period</td><td>1</td><td>1</td><td>1</td><td>1</td><td>1</td><td>1</td><td>1</td><td>1</td><td>1</td><td>1</td><td>1</td><td>1</td><td>1</td><td>1</td><td>1</td><td>1</td><td>1</td><td>1</td></tr><tr><td><mark style="color:green;">End Period</mark></td><td>1</td><td>2</td><td>3</td><td>4</td><td>5</td><td>6</td><td>7</td><td>8</td><td>9</td><td>10</td><td>11</td><td>12</td><td>13</td><td>14</td><td>15</td><td>16</td><td>17</td><td>18</td></tr><tr><td>Payments Type</td><td>1</td><td>1</td><td>1</td><td>1</td><td>1</td><td>1</td><td>1</td><td>1</td><td>1</td><td>1</td><td>1</td><td>1</td><td>1</td><td>1</td><td>1</td><td>1</td><td>1</td><td>1</td></tr></tbody></table>

To calculate the principal payment for all periods, the formula should be written in the \[Cumulative Principal Payments] node:

<mark style="color:blue;">**`CUMPRINC`**</mark>**`(10%/12,`**<mark style="color:purple;">**`[Nper]`**</mark>**`,`**<mark style="color:red;">**`[Loan Amount]`**</mark>**`,1,`**<mark style="color:green;">**`[End Period]`**</mark>**`,1)`**

### Result

<table data-header-hidden><thead><tr><th width="202">Column1</th><th width="89">Column2</th><th width="75">Column3</th><th width="75">Column4</th><th width="75">Column5</th><th width="75">Column6</th><th width="75">Column7</th><th width="75">Column8</th><th width="75">Column9</th><th width="83">Column10</th><th width="83">Column11</th><th width="83">Column12</th><th width="83">Column13</th><th width="83">Column14</th><th width="83">Column15</th><th width="83">Column16</th><th width="83">Column17</th><th width="83">Column18</th><th width="83">Column19</th></tr></thead><tbody><tr><td>Cumulative Principal Payments</td><td>-595.607405</td><td>-1112.8449</td><td>-1634.3927</td><td>-2160.2867</td><td>-2690.5631</td><td>-3225.2586</td><td>-3764.4098</td><td>-4308.0539</td><td>-4856.22845</td><td>-5408.9711</td><td>-5966.31993</td><td>-6528.31333</td><td>-7094.99001</td><td>-7666.389</td><td>-8242.54965</td><td>-8823.51163</td><td>-9409.31497</td><td>-10000</td></tr></tbody></table>