- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Financial - CUMPRINC Function
Description
The CUMPRINC function returns the cumulative principal paid on a loan between start_period and end_period.
Syntax
CUMPRINC (rate, nper, pv, start_period, end_period, type)
Arguments
| Argument | Description | Required/ Optional |
|---|---|---|
| Rate | The interest rate. | Required |
| Nper | The total number of payment periods. | Required |
| Pv | The present value. | Required |
| Start_period | The first period in the calculation. Payment periods are numbered beginning with 1. | Required |
| End_period | The last period in the calculation. | Required |
| Type | The timing of the payment. Look at the Type-Timing Table given below. |
Required |
Type-Timing Table
| Type | Timing |
|---|---|
| 0 (zero) | Payment at the end of the period |
| 1 | Payment at the beginning of the period |
Notes
Make sure that you are consistent about the units you use for specifying rate and nper
If you make monthly payments on a four-year loan at an annual interest rate of 12 percent, use 12%/12 for rate and 4*12 for nper.
If you make annual payments on the same loan, use 12% for rate and 4 for nper.
If rate ≤ 0, nper ≤ 0, or pv ≤ 0, CUMPRINC returns the #NUM! error value.
If start_period < 1, end_period < 1, or start_period > end_period, CUMPRINC returns the #NUM! error value.
If type is any number other than 0 or 1, CUMPRINC returns the #NUM! error value.
If any of the specified arguments is not recognized as numeric value, CUMPRINC returns the #VALUE! error value.
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016
Example
