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

Arguments	Datatype	Description
Rate	Number, Rate	The interest rate per period.
Nper	Number	The total number of periods.
PV	Number	The present value of the loan.
start_period	Number	The first payment period.
end_period	Number	The last payment period.
Type	Number	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.

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.

Periods	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18
Nper	18	18	18	18	18	18	18	18	18	18	18	18	18	18	18	18	18	18
Loan Amount	10000	10000	10000	10000	10000	10000	10000	10000	10000	10000	10000	10000	10000	10000	10000	10000	10000	10000
Start Period	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
End Period	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18
Payments Type	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1

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

CUMPRINC(10%/12,[Nper],[Loan Amount],1,[End Period],1)

Result

Cumulative Principal Payments

-595.607405

-1112.8449

-1634.3927

-2160.2867

-2690.5631

-3225.2586

-3764.4098

-4308.0539

-4856.22845

-5408.9711

-5966.31993

-6528.31333

-7094.99001

-7666.389

-8242.54965

-8823.51163

-9409.31497

-10000