calculate-loan

01 Loan payments

Loan Payoff Date Estimator: How It Works

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

The calculator on this page is switched off while it is checked. The formula is below, and the worked example shows how to do the sum by hand.

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.

A loan payoff date estimator calculates the exact month and year you will make your final loan payment, based on your current balance, interest rate, monthly payment, and any extra amounts you plan to pay. You enter those four numbers, and the estimator returns the number of months remaining and the projected payoff date. This lets you see how extra payments shorten your loan term and how much interest you save.

Formula

The estimator uses the standard amortization formula to first find your required monthly payment, then calculates how many payments are needed to reach a zero balance.

Step 1 – Monthly payment:

M = P × (r / (1 − (1 + r)^(−n)))

  • P = loan amount (principal) in dollars
  • r = monthly interest rate = APR ÷ 1200 (APR is the annual percentage rate, e.g., 8% → 0.08 ÷ 12 = 0.0066667)
  • n = total number of payments = loan term in years × 12
  • M = monthly payment in dollars, rounded to the nearest cent

Step 2 – Months to payoff with a given payment:

m = ⌈ −ln(1 − r × P / M) / ln(1 + r) ⌉

where M is the actual monthly payment you make (which may be higher than the minimum), and m is the number of months until the balance reaches zero. The ceiling brackets (⌈ ⌉) mean you round up to the next whole month, because you make a full payment each month.

This formula comes directly from solving the amortization equation for the number of periods. It works for any fixed interest rate and any payment amount, as long as the payment is greater than the monthly interest charge.

Worked Example

Using the default values from the calculator above:

  • Loan amount (P) = $20,000
  • APR = 8% → monthly rate r = 8 ÷ 1200 = 0.0066667
  • Loan term = 5 years → n = 5 × 12 = 60 payments

Step 1 – Monthly payment:

M = 20000 × (0.0066667 / (1 − (1 + 0.0066667)^(−60)))

First compute (1 + 0.0066667)^(−60):

1.0066667^60 = 1.4898457, so the inverse is 1 / 1.4898457 = 0.6712132.

Then 1 − 0.6712132 = 0.3287868.

Now M = 20000 × (0.0066667 / 0.3287868) = 20000 × 0.0202760 = $405.52 (rounded to the cent).

Step 2 – Total interest:

Total paid = $405.52 × 60 = $24,331.20

Total interest = $24,331.20 − $20,000 = $4,331.20

So with the default inputs, your payoff date is exactly 60 months from your first payment, and you pay $4,331.20 in interest.

Assumptions

  • Fixed interest rate for the entire loan term (no rate changes).
  • Payments are made monthly, on the same day each month.
  • Interest compounds monthly at APR ÷ 12, which is standard for most installment loans.
  • The payment amount stays constant each month.
  • No additional fees, late charges, prepayment penalties, taxes, or insurance are included. If your loan has those, the actual payoff date will differ.

How to Use the Estimator for Your Actual Loan

To get a meaningful payoff date, you need the current numbers from your lender, not the original loan terms. Here is what to gather:

  1. Current principal balance – This is what you still owe, not the original amount. It appears on your latest statement.
  2. Current APR – Your annual percentage rate. If you have a variable rate, use the current rate; the estimate will only be accurate as long as that rate holds.
  3. Your actual monthly payment – This is what you plan to pay each month, including any extra amount. If you pay the minimum, use the minimum payment.
  4. Extra payments – If you make a lump-sum payment (like a tax refund), you can add that to the next month’s payment, but the estimator above assumes a level monthly payment. For lump sums, you would need to recalculate after the payment is applied.

Once you have those, replace the default loan amount with your current balance, set the term to your original term (or any number – the payment formula will adjust), and then look at the “Months to payoff” output. The estimator shows how many months remain, so your payoff date is that many months from today.

Common Mistakes and Misconceptions

  • Using the original loan amount instead of the current balance. If you have made payments for two years, your remaining balance is lower, so the payoff date will be sooner than the original schedule. Always use the current balance.
  • Mixing up APR and monthly rate. The APR is annual; you must divide by 12 to get the monthly rate. Using 8 instead of 0.6667% will give a wildly wrong payment.
  • Rounding too early. In the worked example, rounding the monthly rate to 0.0067 instead of 0.0066667 changes the payment by a few cents, which over 60 months adds up. Keep full precision until the final answer.
  • Assuming the payoff date is the same as the original term. If you make extra payments, the term shortens. The estimator shows that.
  • Forgetting that the payment must cover the interest. If your payment is less than the monthly interest, the balance grows and the formula returns “Cannot compute” – that is correct, because you would never pay off the loan.

How Extra Payments Change Your Payoff Date

Making extra payments reduces the principal faster, which means less interest accrues and more of each subsequent payment goes toward principal. The effect is non-linear: a small extra amount early in the loan saves more interest than the same extra amount later.

For example, on the $20,000, 8%, 5-year loan above, the required payment is $405.52. If you pay $455.52 each month (an extra $50), the payoff time becomes:

m = −ln(1 − 0.0066667 × 20000 / 455.52) / ln(1.0066667)

Compute the inside: 0.0066667 × 20000 = 133.334, divided by 455.52 = 0.2927. Then 1 − 0.2927 = 0.7073. The natural log of 0.7073 is −0.3465, and ln(1.0066667) = 0.006644. So m = −(−0.3465) / 0.006644 = 52.15, rounded up to 53 months.

That is 7 months sooner than the original 60-month term. Total paid = $455.52 × 53 = $24,142.56, so total interest = $4,142.56 – about $188 less than the original schedule.

You can experiment with different extra payment amounts in the calculator by changing the “Monthly payment” output – but note that the calculator above computes the payment from the term. To model extra payments, you would need a version where you input the payment directly. Many loan calculators offer that; the key is to understand the relationship.

Limits of the Estimator

This estimator assumes a fixed rate and level payments. Real loans often have variable rates, biweekly payments, or fees that alter the math. Also, lenders may round the daily interest differently, especially if you pay off the loan early – the final payoff quote from the lender will include interest up to the exact payoff date, which may differ by a few dollars from this estimate.

If you have a loan with a prepayment penalty, making extra payments could cost you money, so check your loan contract. The estimator does not include penalties, so your actual savings could be lower.

Finally, the “months to payoff” formula assumes you make a payment every month until the balance is zero. If you skip a payment or make a late payment, the interest accrues differently and the date shifts.

Frequently Asked Questions

What is the difference between payoff date and maturity date?

The maturity date is the originally scheduled final payment date based on your loan term. The payoff date is when you actually finish paying, which can be earlier if you make extra payments or later if you miss payments. The estimator calculates the payoff date based on your actual payment behavior.

Does making an extra payment always shorten the loan term?

Yes, if the extra payment is applied to the principal and you continue making at least the regular payment. Some lenders apply extra payments to next month’s payment instead of principal unless you specify otherwise. Always tell your lender to apply extra amounts to principal.

Can I use this estimator for a mortgage?

Yes, the math is the same, but mortgages often have escrow for taxes and insurance, which are not included here. Also, mortgage interest may be calculated daily rather than monthly, which can shift the payoff date by a few days. Use the current principal balance and your actual payment amount.

What if my interest rate is variable?

The estimator uses the rate you enter for the entire remaining term. If your rate changes, the payment and payoff date will change. You would need to re-run the calculation with the new rate after each adjustment period.

Why does the calculator show “Cannot compute” for my payoff months?

That happens when your payment is less than the monthly interest charge. In that case, the balance grows, so you never pay off the loan. You need to increase your payment to at least cover the interest, or the loan will not amortize.

The result from this estimator is an estimate based on the numbers you enter; your lender’s payoff statement provides the exact amount and date.

Related

Formula used
in p | Loan amount | $ | 20000 | 1 | 100000000
in apr | Interest rate (APR) | % | 8 | 0.01 | 100
in yrs | Loan term | years | 5 | 0.0833 | 50
out pmt | Monthly payment | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2
out int | Total interest | $ | pmt * yrs * 12 - 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 →