This calculator works out how long it will take to pay off a loan given the amount borrowed, the annual interest rate (APR), and a fixed monthly payment you enter. You get back the number of months until the balance reaches zero, along with the total interest paid over that period. The result assumes a fixed rate and level monthly payments, which is the standard way most installment loans work.
Formula
The time to pay off a fixed-rate loan with level monthly payments is found by solving the standard amortization formula for the number of periods. The formula is:
n = ⌈ -ln(1 – r × P / M) / ln(1 + r) ⌉
Where:
- n = number of monthly payments (months) to pay off the loan
- r = monthly interest rate, equal to APR / 12 (as a decimal, so APR 8% gives r = 0.08/12 = 0.0066667)
- P = principal (loan amount) in dollars
- M = monthly payment in dollars
The expression uses the natural logarithm (ln) because the formula is derived from the geometric series that describes how each payment reduces the balance. The ceiling function (⌈ ⌉) rounds up to the next whole month, because you can’t make a fraction of a payment in practice.
Worked Example
Using the default values from the calculator above: loan amount P = $20,000, APR = 8%, monthly payment M = $450.
- Convert APR to monthly rate: r = 8 / 1200 = 0.0066667.
- Compute r × P / M = 0.0066667 × 20000 / 450 = 133.334 / 450 = 0.296296.
- Compute 1 – that value: 1 – 0.296296 = 0.703704.
- Take the natural log: ln(0.703704) = -0.351397 (approximately).
- Compute ln(1 + r) = ln(1.0066667) = 0.0066445.
- Divide: -(-0.351397) / 0.0066445 = 52.89.
- Round up to the nearest whole month: 53 months.
So with a $450 monthly payment, the loan is paid off in 53 months (about 4 years and 5 months). The total interest paid is 450 × 53 – 20000 = 23850 – 20000 = $3,850. The calculator shows exactly that.
Assumptions
- The interest rate is fixed for the entire loan term.
- Payments are made at the end of each month (ordinary annuity).
- Interest compounds monthly at APR / 12.
- The monthly payment stays the same every month.
- No fees, taxes, insurance, or other charges are included.
How to Read the Result
The result tells you the number of months until the balance is zero if you make exactly the payment you entered every month, on time. If you miss a payment or pay late, the actual time will be longer. If you pay extra, it will be shorter. The total interest figure is the sum of all interest charges over that period, assuming you never change the payment.
Note that the calculator rounds the time up to a whole month. In reality, your final payment may be smaller than the regular payment, so the exact payoff date could be a few days earlier. The rounded month count is a safe estimate for planning.
Common Mistakes and Misconceptions
- Using the APR directly as a monthly rate: The APR is annual, so you must divide by 12. Using 8% instead of 0.6667% per month gives a wildly wrong answer.
- Ignoring rounding: The formula gives a decimal like 52.89. Rounding down to 52 months would mean your last payment is larger than the regular one, but the calculator rounds up to 53 to show the full month count.
- Thinking the payment covers interest first: In the early months, most of your payment goes to interest. The formula accounts for that automatically, but it’s a common surprise.
- Assuming a lower payment always works: If your monthly payment is less than the monthly interest (r × P), the balance grows forever and the formula returns “Cannot compute” because the loan never gets paid off. That’s a real scenario with minimum credit card payments.
When to Use This Calculator
Use this calculator when you know the loan amount, the APR, and a monthly payment you’re considering, and you want to know how long it will take to clear the debt. It’s especially useful for:
- Comparing a longer term with a lower payment versus a shorter term with a higher payment.
- Seeing the impact of increasing your monthly payment by a set amount (e.g., an extra $50).
- Estimating the total interest you’ll pay under different payment scenarios.
It’s not designed for loans with variable rates, interest-only periods, or balloon payments. For those, you need a more detailed amortization schedule.
Limits of the Formula
This formula assumes a fixed APR and level payments. Real loans may have:
- Variable rates that change over time.
- Fees added to the balance (e.g., origination fees).
- Payment holidays or deferment periods.
- Prepayment penalties that could affect the true cost.
Also, the formula gives the time to pay off the current balance. If you have multiple loans, you’d need to calculate each separately or combine them into a weighted average rate, which is beyond this simple tool.
Frequently Asked Questions
What if my payment is exactly the minimum on a credit card?
Credit card minimums are often calculated as a percentage of the balance (e.g., 2% or 3%) plus interest, so they decrease as the balance drops. That means the time to pay off is much longer than a fixed-payment loan. This calculator assumes a fixed payment, so it would overestimate how fast you pay off a card with a declining minimum. To model a credit card accurately, you’d need a calculator that recalculates the minimum each month.
Why does the calculator show “Cannot compute” for some payments?
That happens when your monthly payment is less than the monthly interest charge. For example, with a $20,000 loan at 8% APR, the monthly interest is about $133. If you pay only $100, the interest adds more than you pay, so the balance grows. The formula requires 1 – r×P/M to be positive; when it’s zero or negative, the loan never gets paid off. In that case, no finite number of months exists.
Does paying bi-weekly (every two weeks) change the time?
Yes, but this calculator assumes monthly payments. If you pay half your monthly payment every two weeks, you effectively make 26 half-payments per year, which equals 13 full monthly payments. That extra payment per year reduces the balance faster and shortens the payoff time. To get an accurate estimate, you’d need a bi-weekly calculator that accounts for the more frequent compounding.
What’s the difference between APR and interest rate?
APR (Annual Percentage Rate) includes the interest rate plus certain fees and costs, expressed as a yearly rate. For this calculator, we use APR as the annual rate, which is the standard for comparing loans. The formula uses APR/12 as the monthly rate. If you only know the nominal interest rate, the APR might be slightly higher due to fees, so the actual payoff time could be longer.
Can I use this for a mortgage or auto loan?
Yes, as long as the loan has a fixed rate and level payments. Mortgages and auto loans typically work this way. However, mortgages often have escrow for taxes and insurance, which are not included here. Auto loans may have fees. The calculator gives the time to pay off the principal and interest only, not the total monthly payment including escrow.
How does making extra payments affect the time?
If you pay more than the required amount, the extra goes directly to principal, reducing the balance faster. The formula here assumes a constant payment, but you can simulate extra payments by increasing the monthly payment input. For example, if your required payment is $400 and you pay $450, enter $450 to see the new payoff time. The result will be shorter, and the total interest will be lower.
This calculator provides an estimate based on the inputs you provide. Your lender’s disclosure statement gives the exact payoff figures, including any fees or adjustments.
Related
Formula used
in p | Loan amount | $ | 20000 | 1 | 100000000 in apr | Interest rate (APR) | % | 8 | 0.01 | 100 in pmt | Monthly payment | $ | 450 | 1 | 10000000 out months | Months to pay off | - | ceil(round(-ln(1 - (apr / 1200) * p / pmt) / ln(1 + apr / 1200), 6)) | 0 out int | Total interest paid | $ | pmt * months - 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 Benefits Explained$405.53
- Personal Interest Rate Loan Options: How to Compare$405.53
- Personal Loan vs Savings: Which to Use?$405.53
- Personal Interest Rate Loan Application: How It Works$405.53
- Open Savings Account Interest Rates: How They Work$5,384.45