CUMPRINC

Syntax:

CUMPRINC ( rate , nper , pv , start-period , end-period , type )

Description: Computes the cumulative principal paid on a loan between start-period and end-period.

Arguments:

Name	Type	Description
rate	number	The interest rate.
nper	number	The total number of payment periods, truncated to integer.
pv	number	The present value.
start-period	number	The first period in the calculation. (Payment periods are numbered beginning with 1.)
end-period	number	The last period in the calculation.
type	number	The timing of the payment, truncated to integer, as follows: Value Timing 0 Payment at the end of the period 1 Payment at the beginning of the period

 

Time information in the date arguments is ignored.

Return Type and Value: number – The cumulative principal paid on a loan.

However, if

• rate, nper, or pv ≤ 0, #NUM! is returned.

• start-period < 1 or end-period < 1, or start-period > end_period, #NUM! is returned.

• type is any number other than 0 or 1, #NUM! is returned.

[Example:

CUMPRINC(0.09/12,30*12,125000,13,24,0) results in -934.11
CUMPRINC(0.09/12,30*12,125000,1,1,0) results in -68.28

end example]