This calculator splits each monthly loan payment into the interest portion and the principal portion, and it shows the total interest paid over the life of the loan. You enter the loan amount, the annual interest rate (APR), and the loan term in years; the calculator returns the monthly payment, the interest portion of the first payment, and the total interest paid over the full term. It uses the standard level-payment amortization formula, which is the same math most fixed-rate loans use.
Formula
The monthly payment is calculated with the standard amortization formula:
M = P × (r × (1 + r)^n) / ((1 + r)^n − 1)
Where:
- M = monthly payment (in dollars)
- P = principal loan amount (in dollars)
- r = monthly interest rate = APR / 12 / 100 (as a decimal)
- n = total number of monthly payments = loan term in years × 12
The interest portion of any specific payment k is calculated as:
Interest_k = remaining balance before payment k × r
The principal portion is simply the monthly payment minus that interest amount. The remaining balance after each payment is the previous balance minus the principal portion.
Worked Example
Using the default values: loan amount $20,000, APR 8%, term 5 years.
- Convert APR to monthly rate: r = 8 / 1200 = 0.0066667
- Total number of payments: n = 5 × 12 = 60
- Apply the formula: M = 20000 × (0.0066667 × (1.0066667)^60) / ((1.0066667)^60 − 1)
- Compute (1.0066667)^60 ≈ 1.48985
- M = 20000 × (0.0066667 × 1.48985) / (1.48985 − 1) = 20000 × 0.0099323 / 0.48985 ≈ 405.53
- Monthly payment = $405.53 (rounded to the cent)
- Interest in the first payment = 20000 × 0.0066667 = $133.33
- Total paid over 60 months = 405.53 × 60 = $24,331.80
- Total interest = $24,331.80 − $20,000 = $4,331.80
The calculator shows the same results: monthly payment $405.53, first payment interest $133.33, total interest $4,331.80.
Assumptions
- The interest rate is fixed for the entire term.
- Payments are made at the end of each month, starting one month after the loan is issued.
- Interest compounds monthly at the APR divided by 12.
- The payment amount is rounded to the cent, and all totals use that rounded payment.
- This calculation does not include fees, taxes, insurance, PMI, escrow, or any prepayment penalties.
How to Read the Split
In the early months of a loan, most of your payment goes toward interest. As the balance decreases, the interest portion shrinks and the principal portion grows. This is called amortization. For example, in the first payment above, $133.33 goes to interest and $272.20 goes to principal. By the last payment, the interest portion is only a few dollars.
Knowing the split helps you understand how much of your hard-earned money is actually reducing the debt versus paying the lender for the privilege of borrowing. It also explains why paying extra early can have a big impact: extra principal reduces the balance faster, which cuts the interest on all future payments.
Common Mistakes
- Using the APR as a monthly rate: Always divide the annual rate by 12. An 8% APR is 0.6667% per month, not 8% per month.
- Forgetting to convert years to months: A 5-year loan has 60 payments, not 5.
- Rounding the payment too early: If you round the monthly payment to the nearest dollar before calculating total interest, the total will be off by several dollars. Use cents.
- Assuming interest is calculated on the original balance: That would be simple interest, not amortized interest. Amortized interest is always on the remaining balance.
When to Use This Calculator
Use this tool when you want to see the breakdown of a fixed-rate loan payment—for example, a car loan, a personal loan, or a fixed-rate mortgage. It is particularly useful when comparing loan offers with different rates and terms. You can enter each offer’s rate and term to see which one results in lower total interest, but remember that the monthly payment is what you must budget for.
This calculator is not designed for variable-rate loans, interest-only loans, or loans with balloon payments. Those require different calculations.
Frequently Asked Questions
Why is the interest portion so high at the beginning?
Because the loan balance is at its largest at the start. Interest is calculated on the remaining balance, so a larger balance generates more interest. As you pay down principal, the interest decreases.
Does paying extra each month reduce the interest split?
Yes. Any extra payment goes directly to principal, reducing the balance faster. That lowers the interest charged in subsequent months, so more of your regular payment goes to principal as well.
What is the difference between APR and the interest rate?
APR includes the interest rate plus certain fees and costs spread over the loan term. The interest rate is the base cost of borrowing. This calculator uses the APR as the rate, which gives a more accurate total cost if the APR is provided.
Can I use this for a mortgage with property taxes and insurance?
No. This calculator only handles principal and interest. Property taxes, homeowners insurance, and PMI are separate costs that are often escrowed into the monthly payment but are not part of the loan’s amortization.
What happens if I make a large lump-sum payment?
The loan balance drops immediately, which reduces the interest on all future payments. You can either keep the same monthly payment and pay off the loan early, or recast the loan to lower the payment. This calculator does not model lump-sum payments.
Why is the total interest not simply the payment times the term minus the principal?
It is exactly that. The total interest is the total of all payments minus the original principal. The formula used here computes the monthly payment, then multiplies it by the number of payments and subtracts the principal.
This result is an estimate based on the inputs you provide; the lender’s disclosure statement gives the exact figures for your specific loan.
Related
Formula used
in p | Loan amount | $ | 20000 | 1 | 100000000 in apr | Interest rate (APR) | % | 8 | 0.01 | 100 in yrs | Loan term | years | 5 | 0.0833 | 50 out pmt | Monthly payment | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2 out int_first | Interest in first payment | $ | p * (apr / 1200) | 2 out tot_int | Total interest | $ | pmt * yrs * 12 - p | 2
Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work
Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.
More in this section
- QNB Car Loan Payment Calculator and Guide$405.53
- Car Loan Payment Calculator and Formula$405.53
- VA Down Payment Assistance Calculator and Guide$15,000.00
- Low Down Payment Home Loans: Costs and Trade-Offs$405.53
- Down Payment vs Advance Payment: Key Differences
- DIB Bank Car Loan Calculator and Payment Guide$405.53