Financial
All versions
◉ 26 views
=CUMIPMT()
Returns the cumulative interest paid on a loan between start_period and end_period.
Applies To:
Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016
=CUMIPMT(rate, nper, pv, start_period, end_period, type)
Hover argument names in the table for details.
Output typeNumber
Popularity30 / 100
VolatileNo
Dynamic ArrayNo
📥 Download sample .xlsx ▦ Try in Playground
Dedicated file for this function — safe & lightweight · sample data + live formulas
⬇ Download Sample Workbook
A dedicated .xlsx for =CUMIPMT() with Persian sample data & live formulas — open in Excel and practice.
- Sheet “Sample” — data table + formula in place
- Sheet “Guide” — syntax, arguments & tips from this page
- Instant & secure (token + rate limit)
🧠 🧠 Quiz this function
%d questions — syntax, example & errors — test yourself!
◧ Arguments
| Argument | Type | Required | Description |
|---|---|---|---|
rate |
Number | Required | The interest rate. |
nper |
Number | Required | The total number of payment periods. |
pv |
Number | Required | The present value. |
start_period |
Number | Required | The first period in the calculation. Payment periods are numbered beginning with 1. |
end_period |
Number | Required | The last period in the calculation. |
type |
Number | Required | The timing of the payment. 0 (zero) = Payment at the end of the period; 1 = Payment at the beginning of the period. |
▣ Examples
▦ Data
| Cell | Value | Description |
|---|---|---|
A2 |
0.09 | Annual interest rate |
A3 |
30 | Years of the loan |
A4 |
125000 | Present value |
A5 |
0.09 | Annual interest rate |
A6 |
30 | Years of the loan |
A7 |
125000 | Present value |
Total interest paid in the second year of payments, periods 13 through 24
=CUMIPMT(A2/12,A3*12,A4,13,24,0)
Result:
-11135.23213
Interest paid in a single payment in the first month
=CUMIPMT(A2/12,A3*12,A4,1,1,0)
Result:
-937.5
§ Remarks
- 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 10 percent, use 10%/12 for rate and 4*12 for nper. If you make annual payments on the same loan, use 10% for rate and 4 for nper.
- If rate ≤ 0, nper ≤ 0, or pv ≤ 0, CUMIPMT returns the #NUM! error value.
- If start_period < 1, end_period < 1, or start_period > end_period, CUMIPMT returns the #NUM! error value.
- If type is any number other than 0 or 1, CUMIPMT returns the #NUM! error value.
✦ Tips
- 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 10 percent, use 10%/12 for rate and 4*12 for nper. If you make annual payments on the same loan, use 10% for rate and 4 for nper.
⚠ Common Errors
#NUM!
If rate ≤ 0, nper ≤ 0, or pv ≤ 0, CUMIPMT returns the #NUM! error value. If start_period < 1, end_period < 1, or start_period > end_period, CUMIPMT returns the #NUM! error value. If type is any number other than 0 or 1, CUMIPMT returns the #NUM! error value.
Fix: Check the inputs and the order of the start and end payments
💬 Comments & Q&A 0 approved
🔒 Your comment will be published after review.Share your thoughts — visible after admin approval
No comments yet — be the first!