Loan Payoff Date Calculator: Estimate Your Final Payment

This loan payoff date calculator estimates how many monthly payments remain when you enter the current balance, annual percentage rate (APR), and monthly payment. It returns the estimated number of months to payoff and the corresponding final-payment month, assuming the payment covers interest and stays the same.

Formula

The calculator first estimates the number of monthly payments using the standard amortization payoff formula:

n = ceil(round(−ln(1 − r × B / M) / ln(1 + r), 6))

• B is the current principal balance, in dollars.
• APR is the annual percentage rate, entered as a percent per year.
• r is the monthly rate, calculated as APR ÷ 1,200.
• M is the fixed monthly payment, in dollars.
• n is the estimated whole number of monthly payments remaining; the result rounds the fractional repayment period up.

The approximate years are n ÷ 12. The final-payment estimate applies one more month of interest to the balance remaining after n − 1 full payments: final payment = remaining balance × (1 + r). It can be smaller than the regular payment because the last installment may not need to cover a full scheduled amount. Calculations use the unrounded formula internally; displayed money is rounded to cents.

Worked Example

Using the calculator’s default inputs—balance $20,000, APR 8%, and monthly payment $405.53—first convert the APR to a monthly rate:

• r = 8 ÷ 1,200 = 0.0066667, or about 0.66667% per month.
• n = ceil(round(−ln(1 − 0.0066667 × 20,000 ÷ 405.53) ÷ ln(1.0066667), 6)) = ceil(60.000) = 60 months.
• Approximate years = 60 ÷ 12 = 5.00 years.

The payment is set so the balance is approximately cleared in 60 installments. Because the calculator rounds the month count up, its estimated final payment is the balance after 59 regular payments plus one month of interest. Using the formula, that final payment is approximately $405.53. Actual lender calculations can differ by cents or by a payment period depending on dates, daily interest, and payment posting.

Assumptions

• The APR is fixed throughout the estimated payoff period.
• Payments are monthly, equal to the amount entered, and made at the end of each monthly period.
• Interest compounds monthly at APR ÷ 12.
• The model excludes fees, taxes, insurance, PMI, escrow, late charges, payment changes, and extra payments not included in the monthly amount.

How to Use the Payoff Estimate

Enter the loan’s current balance, not necessarily the original amount borrowed. For an accurate starting point, use a recent statement or account balance and check whether it shows principal only or includes accrued interest and charges. Enter the APR as a percentage—for example, enter 8 for 8%, not 0.08. Enter the amount actually applied as the recurring monthly loan payment.

The output is a mathematical estimate of the number of monthly periods needed to repay the balance under the inputs. It is not automatically a calendar date: to identify a likely month, count that many payment cycles from the next scheduled payment, using the lender’s payment calendar. A specific payoff date requires the next due date, payment posting rules, and any interest accrued between payments. For a formal payoff, request the payoff amount and good-through date from the loan servicer; the amount can change as interest accrues.

The final-payment output is useful because the last installment is often not identical to the regular payment. It is an estimate derived from monthly compounding and a fixed schedule, not a quote. If it is close to the scheduled payment, the loan is approximately paid off by that period in the model. If the entered monthly payment is too small to cover interest, no finite payoff period exists; the formula cannot produce a valid result.

Common Errors and Limits

• Using the original principal: If payments have already been made, use the remaining balance. Using the original amount overstates the time left.
• Mixing APR and monthly rate: Enter annual APR as a percent. The calculator converts it to a monthly rate; do not enter a monthly percentage in the APR field.
• Including non-loan costs: A combined bill may include insurance, escrow, or fees that do not reduce principal. Use the loan payment portion, not the full bill, unless the extra amounts are consistently applied to the balance.
• Assuming exact calendar timing: The formula counts periods, not actual days. Daily-interest methods, irregular payment dates, and processing delays can change the payoff date and final amount.
• Rounding and changing terms: The estimate rounds the number of months to a whole period and assumes the entered payment and APR remain unchanged. Variable rates, missed payments, and additional principal payments are not modelled.

This is an amortization estimate, not a live account calculation. To model extra payments, add them to the monthly amount only if they are actually applied to principal and occur on the assumed schedule; a separate calculation may be needed when payment timing or amount varies.

Frequently Asked Questions

How do I calculate my loan payoff date?
Use the remaining balance, annual APR, and regular monthly payment to estimate the number of monthly periods left. Count those periods from the next scheduled payment month for an approximate calendar month; ask the servicer for an exact payoff quote and date.

Why can’t the calculator find a payoff date?
If the monthly payment is no greater than the interest generated on the balance for a month, the balance will not amortize under this model. Check the balance, APR units, and payment amount. The lender can explain how the account is accruing interest.

Is the final payment always the same as my normal payment?
No. The final payment may be smaller or otherwise differ because it covers only the remaining balance and applicable interest. The precise amount depends on the lender’s interest method, payment date, and any charges.

Does this estimate include extra payments?
Only if you include them in the monthly payment amount and they are applied consistently as assumed. One-time or irregular extra payments require a calculation that accounts for their amounts and dates.

Why does my lender’s payoff amount differ?
A payoff quote can include interest accrued through a specified date and account-specific charges or adjustments. This calculator assumes level monthly payments and monthly compounding, so it is not a substitute for the servicer’s current figure.

This result is an estimate for educational purposes, and the lender’s disclosure gives the exact figures.

Related

• Loan Calculator With Down Payment: Payment on What You Borrow
• Loan Payment Calculator: Monthly Payment, Total Interest and Cost
• Student Loan Monthly Payment Calculator and Formula

in bal | Current loan balance | $ | 20000 | 0.01 | 100000000
in apr | Interest rate (APR) | % | 8 | 0.01 | 100
in pmt | Monthly payment | $ | 405.53 | 0.01 | 100000000
out mos | Months to payoff | months | ceil(round(-ln(1 - (apr / 1200) * bal / pmt) / ln(1 + apr / 1200), 6)) | 0
out yrs | Approximate years to payoff | years | mos / 12 | 2
out last | Estimated final payment | $ | (bal * (1 + apr / 1200) ^ (mos - 1) - pmt * ((1 + apr / 1200) ^ (mos - 1) - 1) / (apr / 1200)) * (1 + apr / 1200) | 2