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
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.
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
Last updated