This calculator works out how long it will take to pay off a loan based on your current balance, interest rate, and monthly payment. You enter the loan amount, APR, and your target monthly payment, and it returns the number of months until the balance reaches zero, along with the total interest you will pay. The result is a clear timeline you can use to plan your budget.
Formula
The calculator uses the standard amortization formula solved for the number of payments. Given a fixed monthly payment m, an annual interest rate APR expressed as a percentage, and a starting principal p, the monthly interest rate is r = APR / 1200. The number of months n required to pay off the loan is:
n = ceil( −ln(1 − r × p / m) / ln(1 + r) )
Where:
- p = loan amount (in dollars, e.g., $20,000)
- APR = annual percentage rate (e.g., 8% per year)
- r = monthly interest rate = APR / 1200 (e.g., 8 / 1200 = 0.0066667)
- m = monthly payment (in dollars, e.g., $500)
- n = number of months to pay off the loan, rounded up to the next whole month
The logarithm in the numerator becomes undefined when r × p / m is greater than or equal to 1, which happens when the monthly payment does not cover the monthly interest. In that case the loan balance grows forever, and the calculator shows “Cannot compute” instead of a number.
Worked Example
Using the default values: loan amount = $20,000, APR = 8%, monthly payment = $500.
- Convert APR to monthly rate: r = 8 / 1200 = 0.0066667
- Compute r × p / m = 0.0066667 × 20000 / 500 = 0.266667
- Compute 1 − 0.266667 = 0.733333
- Compute −ln(0.733333) = 0.310155
- Compute ln(1 + 0.0066667) = ln(1.0066667) = 0.0066445
- Divide: 0.310155 / 0.0066445 = 46.68 months
- Round up to the next whole month: 47 months
So with a $500 monthly payment, the loan is paid off in 47 months. Total interest = $500 × 47 − $20,000 = $23,500 − $20,000 = $3,500. The calculator shows 47 months and $3,500.00 total interest.
Assumptions
- The interest rate is fixed for the entire payoff period.
- Payments are made at the end of each month, starting one month after the loan begins.
- Interest compounds monthly at a rate of APR / 12.
- No fees, penalties, taxes, or insurance are included.
- The monthly payment is constant; extra payments are not modelled separately.
How to Read the Result
The “months to payoff” figure tells you how many monthly payments of the amount you entered are needed to bring the balance to zero. The total interest is the extra money you pay beyond the original principal. If you compare two different payment amounts, you can see how much interest you save by paying more each month. For example, increasing the payment from $500 to $600 on the $20,000 loan at 8% APR shortens the timeline to about 37 months and reduces total interest to roughly $2,200. The calculator is meant for planning; your lender’s statement will show the exact remaining balance and interest accrual.
Common Mistakes and Misconceptions
- Using the annual rate instead of monthly: The formula requires the monthly rate. Forgetting to divide by 12 will produce a wildly wrong number of months.
- Ignoring rounding: The calculator rounds the payment count up to a whole month. A loan that mathematically needs 46.2 months still requires 47 payments.
- Payment less than interest: If your payment is lower than the monthly interest, the balance grows. The calculator correctly shows “Cannot compute” rather than a false timeline.
- Assuming the payment includes fees: If you pay origination fees or annual fees separately, those are not part of the interest calculation and will affect the actual payoff date.
How to Choose a Payment Amount
To use this calculator effectively, start with the minimum payment required by your lender, then try higher amounts to see how the timeline shortens. A common approach is to round up the payment to the nearest $50 or $100. For example, on the $20,000 loan at 8% APR, the minimum payment for a 5-year term is about $405.53. If you pay $500 instead, you finish in 47 months instead of 60 and save roughly $1,668 in interest. The calculator lets you test any amount that exceeds the monthly interest charge. Remember that the payment you enter is what you plan to send each month; if you make extra payments at irregular times, the result will be an approximation.
Limits of This Calculation
This timeline assumes you make the same payment every month without skipping or varying. Real life often includes extra payments, rate changes on variable loans, or fees that alter the balance. The formula also assumes interest is calculated monthly, which is standard for most loans but not universal. Some lenders use daily interest, which can change the payoff date by a few days. The calculator is a planning tool, not a billing statement. For an exact payoff quote, contact your lender and ask for a payoff amount as of a specific date.
Frequently Asked Questions
What happens if I pay more than the minimum?
Paying more than the minimum reduces the principal faster, which shortens the timeline and lowers total interest. The calculator shows exactly how many months you save for any payment amount.
Why does the calculator show “Cannot compute”?
That means your monthly payment is less than the monthly interest. The loan balance is growing, so it will never be paid off. Increase the payment to a value greater than the monthly interest.
Does this work for credit cards?
Yes, if you enter the current balance as the loan amount and the card’s APR. Credit cards often compound daily, so the result is approximate, but it gives a useful timeline for a fixed monthly payment.
How do I include extra one-time payments?
This calculator assumes a constant monthly payment. To model a one-time extra payment, subtract it from the loan amount before entering it, or use a separate calculator that handles extra payments.
Is the total interest accurate?
It is accurate under the assumptions of a fixed rate and constant monthly payments. If your rate changes or you miss a payment, the actual interest will differ.
What if my loan has a prepayment penalty?
Prepayment penalties are not included. If your loan charges one, paying off early may add a fee, which would change the total cost. Check your loan agreement.
This result is an estimate based on the inputs you provide; your lender’s disclosure gives the exact payoff figures.
Related
Formula used
in p | Loan amount | $ | 20000 | 1 | 100000000 in apr | Interest rate (APR) | % | 8 | 0.01 | 100 in m | Monthly payment | $ | 500 | 1 | 1000000 out months | Months to payoff | months | ceil(round(-ln(1 - apr / 1200 * p / m) / ln(1 + apr / 1200), 6)) | 0 out int | Total interest paid | $ | m * ceil(round(-ln(1 - apr / 1200 * p / m) / ln(1 + apr / 1200), 6)) - 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
- Debt Ratio Benchmarks: What Is a Good Debt Ratio?24.0 %
- Debt Ratio Calculation Formula & How to Use It25.00 %
- Car Loan Calculator: Estimate Your Monthly Payment$405.53
- Calculate My Payoff Date: Loan Payoff Calculator
- Student Loan Interest Deduction Limit: 2025 Rules$405.53
- Car Loan EMI Calculator Month Wise$405.53