Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
CUMPRINC
CUMPRINC sums the principal repayment portions of loan installments over a specified range of payment periods. Pair it with CUMIPMT to show the split between principal and interest for any segment of a loan.
Excel
=CUMPRINC(0.005,60,10000,1,12,0)Google Sheets
=CUMPRINC(0.005,60,10000,1,12,0)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Parameter | Value |
| Rate/mo | 0.005 |
| Nper | 60 |
| PV | 10000 |
| Start | 13 |
| End | 24 |
=CUMPRINC(0.005,60,10000,1,12,0)→-1768.0316724466
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Supply periodic rate, total periods, loan PV, start and end period numbers, and type (0 for end-of-period).
- 2Enter =CUMPRINC(rate, nper, pv, start_period, end_period, type) — result is negative.
- 3Combine with CUMIPMT over the same range to verify that principal + interest equals total payments made.
Need a version for your data?
Try: “How much principal will I repay in months 13 to 24 of a $10,000 loan at 6% annual rate over 60 months?”