Description Computes the cumulative principal paid for the specified period.
Syntax CUMPRINC (rate, n_periods, PV, start_period, end_period, type)
| Argument | Description |
|---|---|
| rate | The interest rate. The rate should be adjusted to reflect the period length. For example, if you have a mortgage with an annual rate of 9%, but pay monthly, the appropriate rate is .0075 (.09/12 months). |
| n_periods | The total number of payment periods. Decimal values will be truncated to integers |
| PV | The present value or principal amount of the loan. |
| start_period | The first period for accumulating interest; payment periods start with 1. Decimal values will be truncated to integers. |
| end_period | The last period of the calculation. If the calculation is based on a 30 year mortgage paid monthly, the maximum number would be 360. Decimal values will be truncated to integers. |
| type | Indicates whether payment is due at the beginning or end of the period. Enter 0 for the end of the period (typical for most consumer loans and mortgages) or 1 for the beginning of the period. |
Remarks The result (payment for principal) displays as a negative number because it reflects "cash flow out" in Present Value nomenclature.
Examples This function returns -8483.764676:
See Also FV, CUMIPMT, IPMT, NPER, PMT, PPMT, PV, RATE
