CUMPRINC
Returns the cumulative principal paid on a loan between two periods
Syntax
CUMPRINC(rate, nper, pv, start_period, end_period, type)
Parameters
- rate: Required. The interest rate
- nper: Required. The total number of payment periods
- pv: Required. The present value
- start_period: Required. The first period
- end_period: Required. The last period
- type: Required. The timing of the payment (0=end, 1=beginning)
Example
=CUMPRINC(0.09/12, 30*12, 125000, 1, 1, 0)