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:
|
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.