This calculator works out how long it takes to pay off a loan or credit card balance given your monthly payment, interest rate, and current balance. You enter the amount you owe, the annual interest rate, and your planned monthly payment, and it returns the number of months until the balance reaches zero, plus the total interest you’ll pay along the way.
Formula
The number of months to pay off a loan with a fixed monthly payment is calculated using the standard amortization formula solved for time:
n = ⌈ -ln(1 – r × P / M) / ln(1 + r) ⌉
- n = number of monthly payments (rounded up to the next whole month)
- P = current balance (in dollars)
- r = monthly interest rate = APR / 1200 (APR is the annual percentage rate, e.g., 18% becomes 0.015 per month)
- M = monthly payment amount (in dollars)
The ceiling function (⌈ ⌉) ensures you count the final partial month as a full month, which is how real lenders handle it.
Worked Example
Using the default values: balance = $5,000, APR = 18%, monthly payment = $200.
- Convert APR to monthly rate: r = 18 / 1200 = 0.015
- Compute r × P / M = 0.015 × 5000 / 200 = 75 / 200 = 0.375
- Compute 1 – 0.375 = 0.625
- Take natural log: ln(0.625) ≈ -0.4700036
- Compute ln(1 + r) = ln(1.015) ≈ 0.0148886
- Divide: -(-0.4700036) / 0.0148886 ≈ 31.57
- Round up to the next whole month: 32 months
So the calculator shows 32 months. Total paid = 32 × $200 = $6,400. Total interest = $6,400 – $5,000 = $1,400.
Assumptions
- Fixed interest rate for the entire payoff period.
- Payments are made monthly at the same time each month.
- Interest compounds monthly at APR / 12.
- Your payment stays constant; if you pay extra or change the amount, the timeline changes.
- No fees, penalties, or charges are included. Credit card minimum payments often change as the balance drops—this calculator assumes a fixed payment.
How to Read the Result
The number of months is the time until your balance reaches zero if you make exactly the payment you entered every month. The total interest figure shows what that payment plan costs over the whole period. A shorter timeline means less interest paid overall, but it requires a higher monthly payment. The calculator helps you see the trade-off between monthly cash flow and total cost.
For credit cards, note that the minimum payment is usually a percentage of the balance (often 1-3% plus interest), so it decreases over time. If you pay only the minimum, your timeline will be much longer than what this fixed-payment calculator shows. To use this tool for a card, enter the payment you intend to make as a fixed amount, not the minimum.
Common Mistakes
- Using the APR as a monthly rate. Always divide by 12. An 18% APR is 1.5% per month, not 18%.
- Forgetting to round up. If the math says 31.57 months, you actually make 32 payments. The final payment is smaller, but the number of months is a whole number.
- Ignoring payment timing. If you pay biweekly instead of monthly, the effective interest period is shorter, so the payoff comes sooner. This calculator assumes monthly payments.
- Using a payment that doesn’t cover interest. If your payment is less than the monthly interest, the balance grows forever. The formula returns a negative log, which the calculator shows as “Cannot compute.”
How to Choose a Payment Amount
There is no single “right” payment—it depends on your budget and goals. A common approach is to pay at least the minimum to avoid late fees, then add any extra cash you can spare. The more you pay each month, the fewer months you’ll be in debt and the less interest you’ll pay. For example, on a $5,000 balance at 18% APR:
- Paying $150/month takes about 46 months and costs about $1,900 in interest.
- Paying $200/month takes 32 months and costs $1,400.
- Paying $300/month takes about 20 months and costs about $1,000.
Use the calculator to try different payment amounts and see how the timeline and total interest change.
Alternatives to Fixed Payments
If you have multiple debts, you might consider the debt snowball (pay off smallest balances first) or debt avalanche (pay off highest interest first). These strategies don’t change the math for each individual loan, but they change how you allocate extra payments across accounts. The calculator works for any single debt; to compare multiple debts, run it for each one.
Another alternative is a balance transfer to a 0% APR card, but the calculator doesn’t model promotional periods or transfer fees. If you’re considering that, enter the promotional rate and the fee-adjusted balance to get an estimate, and check the card’s terms for the exact end date.
Frequently Asked Questions
What if my payment changes over time?
This calculator assumes a fixed payment. If you increase your payment later, your actual payoff will be sooner than the estimate. If you decrease it, it will take longer. For a more accurate plan, recalculate whenever your payment changes.
Why does the calculator say “Cannot compute”?
That happens when your payment is less than or equal to the monthly interest. For example, on a $5,000 balance at 18% APR, the monthly interest is $75. If you pay $75 or less, the balance never decreases, so there is no finite payoff time.
Does this work for student loans or mortgages?
Yes, the formula works for any fixed-rate loan with level payments. For mortgages, property taxes and insurance are not included—enter only the principal and interest portion of your payment. For student loans, if you’re on an income-driven plan, your payment changes annually, so the estimate is only accurate for a single year.
How does making extra payments affect the timeline?
Extra payments reduce the principal faster, which cuts both the number of months and the total interest. The calculator shows the effect of a higher fixed payment. If you make a one-time lump sum, the timeline shortens by more than you might expect because you avoid interest on that amount for the remaining term.
Is the total interest exact?
It’s an estimate based on the rounded-up number of months. In reality, your final payment may be smaller than your regular payment, so the exact interest could be a few cents less. The calculator rounds to the nearest cent, which is close enough for planning.
This result is an estimate based on the inputs you provide; your lender’s statement will show the exact figures.
Related
Formula used
in p | Current balance | $ | 5000 | 1 | 1000000 in apr | Interest rate (APR) | % | 18 | 0.01 | 100 in pmt | Monthly payment | $ | 200 | 1 | 100000 out months | Months to payoff | months | ceil(-ln(1 - apr / 1200 * p / pmt) / ln(1 + apr / 1200)) | 0 out total | Total paid | $ | pmt * ceil(-ln(1 - apr / 1200 * p / pmt) / ln(1 + apr / 1200)) | 2 out interest | Total interest | $ | pmt * ceil(-ln(1 - apr / 1200 * p / pmt) / ln(1 + apr / 1200)) - 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
- Personal Loan Interest Deduction: What’s Tax-Deductible?$4,331.67
- Personal Interest Rate Loan Options: How to Compare$405.53
- Personal Interest Rate Loan Benefits Explained$405.53
- Personal Loan vs Savings: Which to Use?$405.53
- Personal Interest Rate Loan Application: How It Works$405.53
- Open Bank Savings Interest Rate: How It Works$1,131.41