This calculator works out the date your loan will be fully paid off based on your current balance, interest rate, and monthly payment. You enter those three numbers, and it returns the number of months remaining and the exact payoff date, assuming you make the same payment every month. It also shows the total interest you will pay between now and that final payment.
Formula
The payoff date is calculated using the standard loan amortization formula solved for the number of payments. The monthly interest rate r is the annual percentage rate (APR) divided by 12 and then by 100 (so 7% becomes 0.07 / 12 = 0.0058333). The number of months n needed to pay off a balance P with a fixed monthly payment M is:
n = ⌈ -ln(1 – r × P / M) / ln(1 + r) ⌉
where:
- P = current loan balance in dollars
- r = monthly interest rate (APR / 1200, as a decimal)
- M = monthly payment in dollars
- n = number of months until the balance reaches zero
The ceiling function (⌈ ⌉) rounds up to the next whole month, because you cannot make a fractional payment. The payoff date is simply today’s date plus n months. The total interest is the total of all payments minus the original balance: M × n – P.
Worked Example
Using the default values from the calculator above: balance P = $15,000, APR = 7%, monthly payment M = $300.
- Monthly rate r = 7 / 1200 = 0.0058333
- Compute r × P / M = 0.0058333 × 15000 / 300 = 0.2916667
- Compute 1 – 0.2916667 = 0.7083333
- Take the natural log: ln(0.7083333) = -0.344840
- Compute ln(1 + r) = ln(1.0058333) = 0.0058160
- Divide: -(-0.344840) / 0.0058160 = 59.29
- Round up to the next whole month: n = 60 months
- Payoff date = today + 60 months (if today is January 1, 2025, that is January 1, 2030)
- Total interest = 300 × 60 – 15000 = 18000 – 15000 = $3,000.00
The calculator shows 60 months, a payoff date of January 1, 2030 (for a January 1, 2025 start), and $3,000.00 total interest.
Assumptions
- The interest rate is fixed for the entire remaining term.
- Payments are made monthly at the end of each month (standard for most loans).
- Interest compounds monthly at APR / 12.
- The payment amount stays exactly the same every month until the loan is paid off.
- Fees, late charges, taxes, insurance, or other costs are not included.
How to Use This Calculator
This tool is useful when you want to know how much longer you will be making payments on a loan, or when you are considering increasing your monthly payment to pay off the loan faster. For example, if you have a car loan with a $10,000 balance, a 6% APR, and you are paying $400 per month, the calculator will tell you how many months remain. If you are thinking about paying an extra $50 each month, you can change the payment to $450 and see how much sooner the loan ends and how much interest you save.
To get the most accurate result, use the exact current balance from your latest statement, the exact APR from your loan agreement, and the exact monthly payment you plan to make. If your payment varies (for example, you pay extra some months), the calculator gives an estimate based on a constant payment.
Common Mistakes and Misconceptions
- Using the original loan amount instead of the current balance. The payoff date depends on what you still owe, not what you originally borrowed.
- Confusing APR with the monthly rate. Always divide the APR by 12 to get the monthly rate. Using 7% directly instead of 0.0058333 will give a wildly wrong answer.
- Forgetting that the payoff date depends on the payment amount. If you pay more than the minimum, you will finish sooner. The calculator uses the payment you enter, not the minimum payment on your statement.
- Assuming the payoff date is just balance divided by payment. Interest accrues each month, so the actual time is longer than a simple division.
- Not rounding up to a whole month. You cannot make a payment on day 15 of a month and call it done; the final payment is made on a regular payment date.
How to Choose the Right Payment Amount
If you are using this calculator to plan extra payments, try different monthly amounts to see how the payoff date changes. For instance, on a $15,000 balance at 7% APR, a $300 payment takes 60 months, but a $400 payment takes about 42 months and saves roughly $1,200 in interest. A $500 payment takes about 33 months and saves about $1,800. You can experiment with the calculator to find a payment that fits your budget.
Keep in mind that some loans have prepayment penalties, though these are rare for most consumer loans. Check your loan agreement to see if making extra payments is allowed and if there are any fees. Also, if you are paying off a mortgage, extra payments may not automatically reduce your principal unless you specify that the extra amount should go toward the principal balance.
Limitations of This Calculation
This calculator assumes a fixed interest rate and a constant payment. If you have an adjustable-rate loan, the rate can change, which will affect the payoff date. If you skip a payment or make a partial payment, the balance will be higher and the payoff date will be later. The calculator also does not account for any fees that may be added to the balance, such as late fees or annual fees. For the most accurate payoff date, contact your lender for a payoff quote, which typically includes interest up to a specific date and any fees.
Another limitation is that the payoff date is based on the calendar month. If you make a payment on the 15th, the interest accrues differently than if you pay on the 1st. Most lenders use the payment due date to calculate interest, so the calculator’s assumption of end-of-month payments is a close approximation but not exact for every lender.
Frequently Asked Questions
How do I find my current loan balance?
Your current balance is on your latest monthly statement, or you can log into your lender’s online portal. It is the amount you still owe, not including any interest that has not yet been billed.
What if I make extra payments?
If you make an extra payment, the balance decreases faster, and the payoff date moves earlier. You can use the calculator with a higher monthly payment to see the effect. Some lenders apply extra payments to future payments rather than principal, so specify that you want the extra amount applied to principal.
Does the payoff date include the final payment?
Yes. The number of months is the total number of monthly payments, including the final one. The payoff date is the date of that final payment, after which the balance is zero.
Why does the calculator show “Cannot compute”?
This happens when your monthly payment is less than the monthly interest on the loan. For example, if your balance is $10,000 at 12% APR, the monthly interest is $100. If your payment is only $50, the balance will never decrease, and the loan will never be paid off. In that case, you need to increase your payment to at least cover the interest.
Is the payoff date the same as the loan maturity date?
Not necessarily. The loan maturity date is the date the loan was originally scheduled to end. If you have been making minimum payments, the payoff date may match the maturity date. If you have made extra payments or refinanced, the payoff date can be earlier.
Can I use this for a credit card?
Yes, but with caution. Credit cards have variable interest rates and minimum payments that change as the balance decreases. This calculator assumes a fixed rate and a fixed payment, so it gives an estimate. For a more accurate payoff date, use the payment amount you plan to make each month and the current APR from your statement.
The result from this calculator is an estimate based on the information you enter; your lender’s payoff statement will give the exact amount and date.
Related
Formula used
in p | Current balance | $ | 15000 | 0 | 100000000 in apr | Interest rate (APR) | % | 7 | 0.01 | 100 in pmt | Monthly payment | $ | 300 | 1 | 10000000 out months | Months to payoff | months | ceil(round(-ln(1 - apr / 1200 * p / pmt) / ln(1 + apr / 1200), 6)) | 0 out date | Payoff date | - | (2025 + floor((0 + months) / 12)) * 10000 + ((0 + months) % 12 + 1) * 100 + 1 | 0 out int | Total interest from now | $ | 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
- 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