Loan Payoff Date Calculator: Estimate Your Final Payment

A loan payoff date calculator estimates how many monthly payments remain and the calendar date your balance could reach zero. Enter your current balance, annual percentage rate (APR), and monthly payment to see the estimated number of payments, payoff date, and interest remaining under the calculator’s assumptions.

Formula

This estimate uses the standard amortizing-loan equation to find the number of level monthly payments needed to repay a balance. It rounds the result up to a whole payment because a partial final month is generally settled with a final payment rather than another full scheduled payment.

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 percentage, such as 8 for 8%.
• r is the monthly rate, calculated as APR ÷ 1,200.
• M is the monthly payment in dollars.
• n is the estimated whole number of monthly payments remaining.

The estimated interest remaining is M × n − B. This applies the entered payment amount to every remaining month. In practice, the final payment may be smaller than a regular payment, so the interest total is an approximation rather than an exact payoff quote.

Worked Example

Using the calculator’s defaults: balance $20,000, APR 8%, and monthly payment $500.

1. Convert the APR to a monthly rate: 8 ÷ 1,200 = 0.0066667.
2. Apply the payment-count formula: −ln(1 − 0.0066667 × 20,000 ÷ 500) ÷ ln(1.0066667) ≈ 44.69 months.
3. Round up to a whole payment: 45 payments remaining.
4. Estimate remaining interest using the rounded payment count: $500 × 45 − $20,000 = $2,500.

For a calendar date, count the estimated payment periods from the date of the next scheduled payment. If that payment is due on November 15, 2026, 45 monthly payment periods point to an estimated final-payment month of August 2030. The exact date depends on the lender’s schedule and how it handles the final amount due.

Assumptions

• The interest rate is fixed for the estimate.
• Payments are made monthly, with the next payment made on the date entered.
• Interest is modelled monthly at APR ÷ 12.
• The calculation excludes fees, taxes, insurance, PMI, escrow, late charges, payment changes, and any lender-specific payoff adjustments.

How to Use a Payoff Date Estimate

Use the current principal balance rather than the original amount borrowed. A recent statement may show both the principal balance and a payoff amount; these are not necessarily the same. A payoff amount can include interest accrued since the last payment and other amounts due, while this calculator models a balance as of a simplified point in the payment cycle.

Use the scheduled amount that actually goes toward the loan each month. If you routinely pay extra principal, include that extra amount in the monthly payment field only if it is consistent. Irregular extra payments change the schedule from month to month, so a single fixed payment cannot reproduce their exact effect.

• Check that the APR is entered as a percentage: enter 8 for 8%, not 0.08.
• Use the payment frequency the formula assumes—monthly—not a biweekly amount.
• Refresh the balance and rate when the loan terms or recent payments change.
• Compare the estimated date with the lender’s online balance or payoff statement, especially near the final payment.

Reading the Result and Its Limits

The payment count is a model of future monthly periods, not a promise that the lender will close the account on a particular day. The calendar estimate starts from the next payment date. Payment processing, weekends, holidays, and the lender’s rules for applying received payments can shift the actual date or final amount.

The formula can produce a valid repayment estimate only when the monthly payment is greater than the interest accruing each month. If the payment is too small, the balance does not amortize under this model; the calculator cannot return a meaningful payoff period. A changing-rate loan also needs a rate path the calculator does not collect, so its result assumes the entered APR stays fixed.

Rounding matters. This calculator rounds the number of payment periods up to a whole month. It then estimates interest using a full payment for each of those months, even though the final payment may be less. For an exact amount to close the loan on a particular day, request a dated payoff figure from the servicer; the figure may expire because interest can continue to accrue.

Payoff Date Versus Loan Maturity Date

A maturity date is the date scheduled by the original contract for the loan to end if payments are made according to its terms. A payoff date estimate instead starts with today’s balance and the payment amount entered. These dates can differ if there have been extra payments, missed or late payments, deferments, changes to the interest rate, or other adjustments.

Similarly, a zero balance shown on a statement is not always the same as a confirmed closed account. If the account is close to payoff, verify the final amount and payment instructions with the servicer, then check that the payment was received and the balance was cleared.

Frequently Asked Questions

How do I calculate the date I will pay off my loan?
Estimate the number of monthly payments from the current balance, APR, and payment amount, then count that many payment periods from the next scheduled payment date. A lender’s dated payoff quote is needed for the exact amount and date.

Does the calculator include extra payments?
It models one fixed monthly payment. You can use a regular extra amount as part of that payment for a rough estimate, but irregular extra payments require a month-by-month calculation for greater accuracy.

Why does my lender show a different payoff amount?
The lender may include interest accrued through a specific date, fees, pending transactions, or other account details not represented here. The calculator is an estimate based on the balance and assumptions you enter.

Can I use this for a variable-rate loan?
You can calculate a scenario using the APR entered, but the result assumes that rate remains unchanged. If the rate changes, the payment schedule and payoff estimate can change too.

What if my payment does not cover monthly interest?
The balance will not be paid off by a fixed payment under this formula if the payment is no greater than the interest accruing each month. Check the balance, rate, and payment figures; ask the servicer to explain the loan’s current payment treatment.

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

Related

• HUD Loan Payoff Request: Steps and What to Expect
• Huntington Bank Loan Payoff Calculator
• 0% APR Car Loan: How to Qualify

in bal | Current loan balance | $ | 20000 | 1 | 100000000
in apr | Interest rate (APR) | % | 8 | 0.01 | 100
in pmt | Monthly payment | $ | 500 | 0.01 | 100000000
in date | Date of next payment | - | 2026 | 2026 | 2026
out months | Payments remaining | months | ceil(round(-ln(1 - (apr / 1200) * bal / pmt) / ln(1 + apr / 1200), 6)) | 0
out payoff | Estimated payoff date (months after next payment) | months | months | 0
out int | Estimated interest remaining | $ | pmt * months - bal | 2