calculate-loan

01 Loan payments

When Will This Loan Be Paid Off? Calculator

Calculator No. 01-22609 · Updated · Formula and assumptions shown below

Months to payoff 62 months
Payoff date
0:00
= 0
Total paid
$24,800.00
From the formula below, to the cent
Total interest
$4,800.00
From the formula below, to the cent
You enter
Current balance ($), Interest rate (APR) (%), Monthly payment ($)
You get
Months to payoff (months), Payoff date, Total paid ($), Total interest ($)
Rounding
0 dp · h:mm:ss · 2 dp

Estimate for education, not financial advice. The result follows from the numbers you enter and the formula shown. It is not a quote or an offer, and it does not include fees, taxes or insurance unless the calculator asks for them. Ask your lender for the exact figures.

This calculator works out the exact date and remaining balance when your loan will be paid off, based on the amount you owe, your interest rate, and your monthly payment. You enter the current balance, the annual percentage rate (APR), and either your fixed monthly payment or the number of months you plan to keep paying. The result shows the month and year of your final payment, plus the total interest you will have paid by then.

Formula

The number of months to pay off a loan with a fixed monthly payment is found using the standard amortization formula:

n = ⌈ -ln(1 – r × P / M) / ln(1 + r) ⌉

Where:

  • n = number of monthly payments (rounded up to the next whole month)
  • P = current loan balance (in dollars)
  • r = monthly interest rate = APR / 12, expressed as a decimal (e.g., 8% APR → r = 0.08/12 = 0.0066667)
  • M = fixed monthly payment (in dollars)

This formula comes from solving the present value of an annuity for the number of periods. It assumes the payment is made at the end of each month, and that the interest rate stays constant for the entire remaining term.

Worked Example

Using the default values: P = $20,000, APR = 8%, M = $400 per month.

  1. Monthly rate: r = 8 / 1200 = 0.0066667
  2. Compute the term inside the logarithm: 1 – r × P / M = 1 – 0.0066667 × 20000 / 400 = 1 – 0.333333 = 0.666667
  3. Take the natural log: ln(0.666667) = -0.405465
  4. Divide by ln(1 + r) = ln(1.0066667) = 0.0066445: -0.405465 / 0.0066445 = -61.02
  5. Negate: 61.02, round up to 62 months.

So the loan is paid off in 62 months (5 years and 2 months). The total paid is 62 × $400 = $24,800, and the total interest is $24,800 – $20,000 = $4,800.

Assumptions

  • Fixed interest rate for the entire remaining term (no rate changes).
  • Payments are made monthly at the end of each period.
  • Interest compounds monthly at APR / 12.
  • The payment amount stays constant every month.
  • No extra fees, late charges, or prepayment penalties are included.

How to Use This Calculator

Enter the current outstanding balance on your loan, the annual interest rate (APR) your lender charges, and the fixed monthly payment you plan to make. The calculator then tells you how many months remain until the balance reaches zero, and what that final payment date will be (assuming you start paying from today).

You can use this for any type of amortizing loan—auto loans, personal loans, student loans, or mortgages—as long as the payment is fixed and the rate is fixed. If you have an adjustable-rate loan, the result is only an estimate for the current rate; it will change if the rate changes.

Reading the Results

The Months to payoff is the number of monthly payments needed. The Payoff date is the month and year of your last payment, based on today’s date. Total paid is the sum of all payments you will make from now until payoff, and Total interest is that total minus your current balance.

Note that the payoff date assumes you make your first payment one month from today. If you make an extra payment this month, the date will be earlier. The result is rounded up to the next full month because a partial month’s payment is not typical—your last payment may be smaller than the regular payment, but the number of months is still a whole number.

Common Mistakes

  • Using the annual rate instead of the monthly rate. Always divide the APR by 12. If you plug in 8 instead of 0.006667, the formula will give a nonsense result.
  • Forgetting to round up. The formula often gives a decimal like 61.02 months. You cannot make 0.02 of a payment, so you round up to 62. If you round down, you will underpay and still owe a small balance.
  • Ignoring the payment date. If your first payment is due in 15 days, the actual payoff date will be slightly earlier than the calculation shows because interest accrues daily in many loans. This calculator assumes exactly one month between payments.
  • Using the original loan amount instead of the current balance. If you have been paying for a while, use the remaining principal, not what you originally borrowed.

What If My Payment Is Too Low?

If your monthly payment does not cover the interest that accrues each month, the loan balance will grow, not shrink. In that case, the formula inside the logarithm tries to take the square root of a negative number, and the calculator shows “Cannot compute.” That is a real warning: your payment is below the interest-only amount. For the example above, the interest-only payment is $20,000 × 0.006667 = $133.33 per month. Any payment below that will never pay off the loan.

Frequently Asked Questions

What is the difference between payoff date and maturity date?

The maturity date is the original end date of the loan when you signed the agreement, assuming you make the minimum required payments. The payoff date is when you will actually finish paying if you make a different payment amount. If you pay extra, your payoff date comes earlier than the maturity date.

Does making extra payments change the payoff date?

Yes. If you make an extra payment or increase your monthly payment, the number of months decreases. You can try this by entering a higher monthly payment in the calculator. For example, with a $20,000 loan at 8% APR, paying $500 instead of $400 reduces the payoff time from 62 months to about 47 months.

How do I find my current loan balance?

Your current balance is the remaining principal on the loan. You can find it on your latest monthly statement, in your online account, or by calling your lender. It is not the same as the payoff quote, which may include accrued interest and fees up to a specific date.

What if my interest rate changes?

This calculator assumes a fixed rate. If you have a variable-rate loan, the payoff date will change whenever the rate changes. You can re-run the calculation with the new rate to get an updated estimate, but the actual date may differ slightly due to the timing of rate adjustments.

Why does the total interest seem so high?

Interest accumulates on the remaining balance every month. Early in the loan, most of your payment goes toward interest, and only a small portion reduces the principal. Over a long term, this can add up significantly. The total interest shown is the sum of all interest charges over the remaining life of the loan.

This calculator provides an estimate based on the information you enter. The exact payoff amount and date will be shown on your lender’s payoff statement, which includes any fees or adjustments not modelled here.

Related

Formula used
in p | Current balance | $ | 20000 | 1 | 100000000
in apr | Interest rate (APR) | % | 8 | 0.01 | 100
in pmt | Monthly payment | $ | 400 | 1 | 1000000
out months | Months to payoff | months | ceil(round(-ln(1 - apr / 1200 * p / pmt) / ln(1 + apr / 1200), 6)) | 0
out date | Payoff date | - | 0 | time
out tot | Total paid | $ | pmt * (ceil(round(-ln(1 - apr / 1200 * p / pmt) / ln(1 + apr / 1200), 6))) | 2
out int | Total interest | $ | pmt * (ceil(round(-ln(1 - apr / 1200 * p / pmt) / 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

The whole Loan payments section →