Manuals/calci/cumprinc
CUMPRINC(R, NPPeriods, PV, SP, EP, Type)
where,
R - the interest rate.
NPPeriods - the total number of payment periods.
PV - the present value.
SP - the first period beginning with 1.
EP - the last period.
Type - the timing of the payment.
TYPE TIMIING
0 Payment at the end of the period
1 Payment at the beginning of the period
This function gives the cumulative principal paid on a loan between SP and EP.
CUMPRINC shows the ERROR value when R<=0, NPPeriods<=0, PV<=0, or SP<1, EP <1, SP>EP,
Type should be 0 or 1.
CUMPRINC
Lets see an example
=CUMPRINC(0.03/12,B3*12,B4,13,24,0)
CUMPRINC returns -11046.6464.
Consider another example
=CUMPRINC(0.02/12,10*12,200000,10,20,1)
CUMPRINC returns -16939.2946.
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | ||||
| Row2 | 15 | 10 | 128 | |
| Row3 | 200000 | 200000 | ||
| Row4 | -11046.646138 | -16939.294642 | 10000 | |
| Row5 | 183070.705358 | 10000 | 128 | |
| Row6 | 0.850904 | 1.619775 | 0.525322 |
