TSE.
MathematicsFinanceHealthPhysicsEngineeringBrowse all

Everyday Life · Finance & Tax

Loan Payoff Calculator

Calculate how long it will take to pay off a loan and the total interest paid based on your balance, interest rate, and monthly payment.

Calculator

Advertisement

Formula

n = number of months to pay off the loan; P = current outstanding principal balance; r = monthly interest rate (annual rate ÷ 12, expressed as a decimal); M = fixed monthly payment amount. Total interest paid = (n × M) − P. The formula assumes a fixed monthly payment greater than the monthly interest charge.

Source: Standard amortization mathematics — Investopedia / Consumer Financial Protection Bureau (CFPB) loan amortization guidance.

How it works

Every fixed-rate loan follows the same compounding logic: each month, interest accrues on the remaining principal, your payment covers that interest first, and whatever remains reduces the balance. Because the balance shrinks each month, an increasing share of each payment goes toward principal — this is the core of loan amortization. The payoff calculator automates this compounding process so you can see the full timeline without building a spreadsheet row by row.

The key formula used is n = −ln(1 − rP/M) / ln(1 + r), where n is the number of monthly payments, P is the current principal balance, r is the monthly interest rate (annual rate divided by 12), and M is the fixed monthly payment. This is the standard closed-form solution to the amortization equation. One critical constraint: your monthly payment must exceed the monthly interest charge (r × P); otherwise the balance grows indefinitely and the loan can never be paid off. Total interest paid is simply the total of all payments minus the original balance: (n × M) − P.

Practical applications are wide-ranging. A borrower with a $20,000 auto loan can instantly see how paying an extra $100 per month cuts years off the loan and saves hundreds in interest. Someone carrying a high-interest credit card balance can model a realistic payoff plan. Financial planners use this calculation to compare consolidation offers — if a lower interest rate reduces total interest paid even after fees, the refinance makes sense. The formula also reveals the break-even point for making extra principal payments, a powerful tool for accelerating debt freedom.

Worked example

Suppose you have a $15,000 personal loan at an annual interest rate of 6.5%, and you plan to pay $300 per month.

Step 1 — Monthly interest rate: r = 6.5% ÷ 12 = 0.065 ÷ 12 ≈ 0.005417 per month.

Step 2 — Check payment sufficiency: Monthly interest on the full balance = 0.005417 × $15,000 ≈ $81.25. Since $300 > $81.25, the payment covers interest and reduces principal — the loan will be paid off.

Step 3 — Calculate number of payments: n = −ln(1 − 0.005417 × 15000 / 300) / ln(1 + 0.005417) = −ln(1 − 0.2708) / ln(1.005417) = −ln(0.7292) / 0.005402 ≈ 0.3158 / 0.005402 ≈ 58.5 months (about 4 years and 10 months).

Step 4 — Total paid: 58.5 × $300 = $17,550.

Step 5 — Total interest: $17,550 − $15,000 = $2,550 in interest.

Now consider boosting the monthly payment to $400: the loan pays off in approximately 41.5 months (about 3 years 5 months), with total interest of roughly $1,600 — saving nearly $950 and more than a year of payments simply by paying $100 more per month.

Limitations & notes

This calculator assumes a fixed interest rate and a constant monthly payment throughout the loan's life. It will not accurately model variable-rate loans where the rate adjusts periodically, or loans with changing payment schedules. The result represents the mathematical payoff point — in practice, your final payment may differ slightly from your standard monthly payment (it will typically be smaller). The calculation also does not account for fees, prepayment penalties, or interest that has already accrued and been capitalized outside the stated balance. For credit cards, the minimum payment typically changes each month as the balance decreases, meaning a fixed-payment assumption may underestimate or overestimate actual payoff time. Always verify results against your lender's amortization schedule. If the monthly payment is less than or equal to the monthly interest charge, the balance will never decrease and the calculator will return an invalid result — in this case you must increase your payment.

Frequently asked questions

What happens if my monthly payment is less than the interest charge?

If your payment does not cover the monthly interest (annual rate ÷ 12 × balance), your loan balance will actually grow each month — a situation called negative amortization. In this case, no fixed payment schedule will ever pay off the loan. You must increase your monthly payment above the interest-only amount to make progress on the principal.

How does making extra principal payments affect my payoff date?

Extra principal payments directly reduce your outstanding balance, which lowers the interest accrued the following month — meaning more of every future payment goes toward principal. Even small additional payments made early in a loan's life have a compounding effect, shortening the payoff timeline and reducing total interest significantly. Use this calculator by entering a higher monthly payment to model the impact of extra payments.

Can I use this calculator for credit card debt?

Yes, with a caveat: enter your current balance, the card's APR, and a fixed monthly payment amount you plan to commit to. The result will show your payoff timeline assuming that payment stays constant. In reality, credit card minimum payments fluctuate with the balance, so this approach (paying a fixed amount) is actually the recommended strategy for eliminating card debt faster.

What is the difference between total interest paid and APR?

APR (Annual Percentage Rate) is the annual cost of borrowing expressed as a percentage — it may include fees in addition to interest. Total interest paid is the actual dollar amount of interest you will pay over the entire loan term. A lower APR always results in less total interest paid for the same loan amount and term, but total interest also depends heavily on how long the loan is outstanding.

Does this calculator account for loan origination fees or prepayment penalties?

No — this calculator focuses purely on the mathematical relationship between principal, interest rate, and monthly payment. Origination fees effectively increase your loan cost and should be factored into your comparison of loan offers (they are included in APR calculations). Prepayment penalties, if applicable, would reduce the financial benefit of paying extra. Always review your loan agreement for these terms before making extra payments.

Last updated: 2025-01-15 · Formula verified against primary sources.