CUMPRINC Function
Adds up the principal repaid between two loan periods.
Category
Financial
Available in
All versions, Microsoft 365
Returns
Total principal over a range of periods
Overview
CUMPRINC totals the principal paid from one period to another — how much of the balance you cleared in year 2, or by month 30.
Every argument is required, pv must be positive and type must be 0 or 1. Over the whole loan it returns exactly the loan amount (as a negative).
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| rate | Yes | The interest rate per period (annual rate ÷ 12 for monthly payments). |
| nper | Yes | The total number of payment periods. |
| pv | Yes | The loan amount, as a positive number. |
| start_period | Yes | The first period to include. |
| end_period | Yes | The last period to include. |
| type | Yes | 0 = payments at period end, 1 = at period start. |
Examples
Example 1 — Balance paid down each year
Principal repaid on the $45,000 van loan.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Span | From | To | Principal |
| 2 | Year 1 | 1 | 12 | -$7,872.51 |
| 3 | Year 2 | 13 | 24 | -$8,399.75 |
| 4 | Whole loan | 1 | 60 | -$45,000.00 |
Example 2 — Balance left after year 1
Add the (negative) principal paid to the loan amount.
Result: $37,127.49 still owed.
Common mistakes
- #NUM! error. pv must be positive and type must be 0 or 1 — it can't be left out.
- Rate and periods in different units. Keep them matched: for monthly payments divide the annual rate by 12 and multiply the years by 12. Mixing an annual rate with monthly periods gives wildly wrong answers.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.