CUMPRINC
Description
Returns the cumulative payment on the principal between the two specified periods.
Syntax
CUMPRINC(
rate
,
nper
,
pv
,
start_period
,
end_period
,
type
)
- rate: The interest rate.
- nper: The total number of payment periods.
- pv: The present value.
- start_period: The first period.
- end_period: The last period.
- type: The payment timing. 0 = the payment occurs at the end of the period; 1 = the payment occurs at the beginning of the period.