This function returns the cumulative principal paid on a loan between the start and end periods.
Syntax
CUMPRINC(rate,nper,pval,startperiod,endperiod,paytype)
Arguments
This function has these arguments:
| Argument | Description | |
|---|---|---|
| rate | Interest rate | |
| nper | Total number of payment periods | |
| pval | Present value | |
| startperiod | Starting period | |
| endperiod | Ending period | |
| paytype | Type of payment timing; can be any of: | |
| 0 - Payment at end of the period | ||
| 1 - Payment at beginning of the period | ||
Remarks
This functions returns a #NUM! error when rate, nper, or pval is negative or zero. Nper, startperiod, endperiod, and paytype are truncated to integers. If startperiod or endperiod is less than 1 or startperiod is greater than endperiod, a #NUM! error is returned. If paytype is a number other than 0 or 1, a #NUM! error is returned.
Data Types
Accepts numeric and DateTime object data. Returns numeric data.
Examples
CUMPRINC(B2/12,B4*12,C4,14,20,0)
CUMPRINC(B2/12,B4*12,C4,14,20,0)
Version Available
This function is available in product version 2.0 or later.
See Also
CUMIPMT | IPMT | Financial Functions