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.

Syntax

Remarks

Examples

Description