Summary

The Excel CUMPRINC function returns the cumulative principal paid on a loan between two periods. Microsoft defines it in those terms, which is important because the function does not return the total payment and does not return the interest portion. It isolates only the amount that reduces the outstanding balance.

That makes CUMPRINC especially useful in amortization analysis. In a level-payment loan, the principal portion is smaller near the beginning and larger near the end, so the cumulative principal paid over different windows can vary meaningfully even when the payment amount stays constant.

CUMPRINC is therefore a schedule-analysis function. It helps answer questions such as how much debt has been repaid after one year, how much principal is reduced in the final year, or how fast equity is being built over time.

Syntax

=CUMPRINC(rate, nper, pv, start_period, end_period, type)

rate is the interest rate per period, nper is the total number of periods, pv is the present value of the loan, start_period and end_period define the window to sum, and type sets payment timing as end-of-period (0) or beginning-of-period (1).

Microsoft notes that the period numbers must be integers and that the rate, term, and period numbering must use the same unit. If the loan is monthly, use a monthly rate and monthly period numbers throughout.

Arguments

• rate - Interest rate per payment period.
• nper - Total number of payment periods in the loan.
• pv - Present value, or original loan amount.
• start_period - First period included in the cumulative window.
• end_period - Last period included in the cumulative window.
• type - Payment timing: 0 for end of period, 1 for beginning of period.

Because CUMPRINC follows Excel's cash-flow sign convention, the result is often negative when the loan amount is entered as a positive present value. The negative sign reflects cash paid out by the borrower.

CUMPRINC vs Other Functions

CUMPRINC belongs to the same loan-analysis family as PMT, IPMT, and PPMT, but each function answers a different question.

Use CUMPRINC when the question is about balance reduction across a window, not about one payment or the total periodic payment amount.

Using the CUMPRINC Function

CUMPRINC is most useful in amortization schedules and loan dashboards. It can show how much of the original balance has been repaid by a certain date, which is often more informative than simply showing how many payments have been made.

It is also valuable for comparing different parts of the loan term. Early payment windows usually contain less principal because interest consumes a larger share of each payment. Later windows show the reverse pattern.

• Use CUMPRINC when principal reduction over a range matters more than the payment total.
• Keep rate, term, and period numbers in the same unit.
• Interpret the sign correctly, especially if the model uses Excel's default loan cash-flow convention.

Example 1 - First Year Principal Audit

This formula sums the principal repaid in months 1 through 12 of a 5-year loan. It is a useful way to see how much of the first year's payments actually reduced the balance instead of going to interest.

=CUMPRINC(B1/12,60,30000,1,12,0)

Example 2 - Late Stage Equity Audit

Summing months 49 through 60 shows how much principal is repaid in the final year. In a standard amortizing loan, this number is usually larger in absolute terms than the first-year principal total because less of each payment is being consumed by interest.

=CUMPRINC(B1/12,60,30000,49,60,0)

Example 3 - Logic Payment Verification

This test checks whether the principal repaid in month 1 is more negative than -400. The comparison is framed with a negative threshold because CUMPRINC usually returns a negative cash outflow under the standard sign convention.

=CUMPRINC(B1/12,60,30000,1,1,0)<-400

Example 4 - Dynamic Period Principal

Using B2 as the ending period makes the formula easier to reuse. A dashboard can then change the reporting window without rewriting the core amortization logic.

=CUMPRINC(B1/12,60,30000,1,B2,0)

Conclusion Recap

• Summary: CUMPRINC returns the cumulative principal paid between two periods.
• Syntax: =CUMPRINC(rate,nper,pv,start_period,end_period,type).
• Core setup: Use aligned units and expect negative outputs under the standard loan sign convention.
• Best use: Amortization analysis, debt paydown tracking, and equity-build reporting.