Finance & Economics · Personal Finance
Debt Payoff Calculator
Calculates the number of months to pay off a debt and total interest paid given a fixed monthly payment, principal balance, and annual interest rate.
Calculator
Formula
n = number of monthly payments required to pay off the debt. P = outstanding principal balance (the amount currently owed). r = monthly interest rate = annual interest rate divided by 12. M = fixed monthly payment amount. The formula is the standard loan amortization payoff equation solved for the number of periods. Total interest paid = (n × M) − P.
Source: Derived from the standard amortization formula: Brealey, Myers & Allen, Principles of Corporate Finance, 13th Edition, Chapter 2.
How it works
When you carry a balance on a loan or credit card, each month your lender applies interest to the outstanding principal before subtracting your payment. This means only a portion of every payment reduces the debt — the rest covers interest charges. The higher your interest rate relative to your payment, the slower your principal shrinks. Understanding this dynamic is the first step toward eliminating debt strategically.
The payoff formula is derived from the standard amortization equation. Given a monthly interest rate r (annual rate ÷ 12), a principal P, and a fixed monthly payment M, the number of months required is: n = −ln(1 − rP/M) ÷ ln(1 + r). This formula breaks down only when your monthly payment is less than or equal to the monthly interest charge (r × P), in which case the debt will never be paid off — a situation known as negative amortization. Once n is known, total interest = (n × M) − P, giving you the full cost of carrying the debt over time.
This calculator is essential for budgeting decisions: Should you allocate an extra $50 per month to debt repayment? How much interest would you save by refinancing at a lower rate? Common applications include credit card debt payoff planning, personal loan management, auto loan tracking, and comparing the avalanche vs. snowball repayment strategies. Financial advisors and individuals pursuing FIRE (Financial Independence, Retire Early) goals frequently use payoff projections to set concrete milestones.
Worked example
Suppose you have a credit card balance of $5,000 at an APR of 19.99% and you commit to paying $200 per month.
Step 1 — Convert the annual rate to a monthly rate:
r = 19.99% ÷ 12 = 1.666% per month = 0.01666
Step 2 — Check the payment exceeds minimum interest:
Monthly interest on $5,000 = 0.01666 × 5,000 = $83.30
Since $200 > $83.30, the debt will be paid off.
Step 3 — Apply the payoff formula:
n = −ln(1 − (0.01666 × 5,000) / 200) ÷ ln(1 + 0.01666)
n = −ln(1 − 0.4165) ÷ ln(1.01666)
n = −ln(0.5835) ÷ 0.016523
n = 0.5390 ÷ 0.016523
n ≈ 32.6 months (about 2.7 years)
Step 4 — Calculate total interest:
Total paid = 32.6 × $200 = $6,520
Total interest = $6,520 − $5,000 = $1,520
Now compare: if you increase your payment to $300 per month, the debt clears in approximately 19.8 months and total interest drops to around $933 — saving nearly $587 in interest and 12.8 months of payments just by adding $100 per month.
Limitations & notes
This calculator assumes a fixed monthly payment that never changes and a constant interest rate throughout the repayment period. Variable-rate loans (such as many credit cards with promotional rates or adjustable personal loans) will produce different results as rates fluctuate. Credit cards typically have a minimum payment that changes month-to-month as your balance decreases — this calculator does not model that scenario. If your monthly payment is equal to or less than the monthly interest charge (r × P), the calculator will return an invalid result because the debt can never be paid off under those conditions; you must increase your payment first. This tool also does not account for additional charges such as annual fees, late fees, or new purchases added to the balance. For complex debt situations involving multiple accounts, consider using the debt avalanche or debt snowball method applied across each account individually.
Frequently asked questions
What is the minimum monthly payment needed to actually pay off my debt?
Your monthly payment must be strictly greater than the monthly interest charge, which equals (annual rate ÷ 12) × balance. For example, on a $5,000 balance at 19.99% APR, the monthly interest is about $83.30, so you must pay more than $83.30 per month. Paying exactly $83.30 means your balance never decreases — you are just treading water.
How does the debt avalanche method differ from the debt snowball method?
The debt avalanche method directs extra payments toward the highest-interest debt first, minimizing total interest paid across all accounts — mathematically optimal. The debt snowball method targets the smallest balance first, regardless of rate, providing faster psychological wins by eliminating individual debts sooner. Research suggests the avalanche saves more money, but the snowball method leads to higher completion rates for some people due to motivation effects.
How much interest do I save by making one extra payment per year?
The impact depends heavily on your interest rate and balance. On a $5,000 credit card balance at 19.99% APR with $200 monthly payments, making one extra $200 payment per year effectively raises your monthly average and can shave 2–4 months off the payoff timeline, saving $300–$500 in interest. Run the calculator with a slightly higher monthly payment (e.g., $217 = $200 × 13/12) to approximate the annual extra-payment scenario.
Can I use this calculator for a mortgage?
Yes, the underlying formula is identical for any fixed-rate amortizing loan, including mortgages. Enter your outstanding mortgage balance, current annual interest rate, and monthly principal-and-interest payment. Note that your quoted monthly payment may include escrow for taxes and insurance — use only the principal-and-interest portion for accurate results. Dedicated mortgage calculators may also account for refinancing costs and PMI.
What happens if I miss a payment or pay less one month?
Missing or reducing a payment increases your outstanding balance (because interest continues to accrue) and effectively restarts the amortization clock. Most lenders will also charge a late fee. This calculator models a consistent fixed payment every month — any deviation means the actual payoff date will be later than projected. If you anticipate irregular payments, use a month-by-month spreadsheet amortization table for a more realistic projection.
Last updated: 2025-01-15 · Formula verified against primary sources.