Loan Payoff Date Calculator: Estimate Your Final Payment

A loan payoff date calculator estimates how many monthly payments remain and the calendar date of the final payment when you enter your balance, APR, and monthly payment. It assumes a fixed rate and regular payments; the actual payoff quote from your lender may differ because of payment timing, fees, or accrued interest.

Formula

The calculator finds the number of level monthly payments needed to bring a balance to zero, then converts that number into an approximate duration:

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.
• r is the monthly interest rate, calculated as APR ÷ 1,200.
• M is the fixed monthly payment, in dollars.
• n is the estimated number of monthly payments. The result rounds up to a whole payment.

Estimated total paid is M × n. Estimated interest is that total minus the entered balance. The interest estimate assumes the full rounded payment is made in every month, including the final month; in practice, the last payment is often smaller.

Worked Example

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

1. Convert the APR to a monthly rate: r = 8 ÷ 1,200 = 0.0066667.
2. Substitute the values: n = ceil(round(−ln(1 − 0.0066667 × 20,000 ÷ 500) ÷ ln(1 + 0.0066667), 6)).
3. Calculate the payment count: n = ceil(44.499…) = 45 months, or 45 ÷ 12 = 3.75 years.
4. Estimated total of payments: $500 × 45 = $22,500.00.
5. Estimated interest: $22,500.00 − $20,000.00 = $2,500.00.

Assumptions

• The APR remains fixed throughout repayment.
• Payments are made monthly, at the end of each period, with the first payment one month from now.
• Interest compounds monthly at APR ÷ 12.
• The entered balance is treated as principal. The estimate excludes fees, taxes, insurance, PMI, escrow, and any charges or credits not entered.
• The payment stays level; the calculation does not model a smaller final payment or lender-specific day-count methods.

How to use a payoff date estimate

Enter the current balance—not the original amount borrowed—plus the APR and the payment you expect to make each month. Use the contractual payment if you are estimating the scheduled payoff, or enter a different fixed amount to see the mathematical effect of that payment. The APR and payment should correspond to the same loan and repayment period.

The calculator returns months, not a specific calendar date, because a calendar date depends on when the next payment is due. To turn the estimate into a date, count the calculated number of monthly payment periods from the next scheduled payment date. A lender may calculate the final due date differently, particularly if payments post late or the payoff is made between regular due dates.

The payment must be greater than the interest charged in the first month for this formula to work. That monthly interest is approximately balance × APR ÷ 1,200. If the payment is equal to or below that amount, the balance will not decline under the model, so the calculator reports that it cannot compute a payoff period. A payment barely above monthly interest can still imply a very long repayment time.

Reading the result and its limits

The month count is rounded upward because a fraction of a scheduled payment period generally means another payment period is needed. The total-paid and interest outputs multiply the entered monthly payment by that rounded month count. They are useful for a consistent estimate, but can overstate the actual amount if the final payment is adjusted to the remaining balance.

For example, a balance can accrue interest daily while this calculator uses a monthly rate. The lender’s servicing system may also account for the precise date a payment is received, unpaid charges, past-due amounts, or payment allocation rules. Those differences matter when requesting an exact payoff amount for a particular date. Use the lender’s current payoff quote for a transaction or to confirm the final amount.

Common mistakes and related calculations

• Entering the original loan amount: use the current outstanding balance, since previous payments have already changed what remains.
• Mixing up APR and monthly rate: enter APR as an annual percentage, such as 8, not 0.6667. The formula converts it to a monthly rate.
• Using a total monthly bill as the loan payment: exclude amounts for escrow, insurance, or other separate charges unless they are part of the loan payment represented by the model.
• Assuming extra payments are automatically included: enter the total fixed amount you plan to pay each month. A one-time extra payment or varying payment schedule needs a month-by-month balance calculation instead.

A payoff calculator is not the same as a standard loan-payment calculator. A payment calculator usually starts with the amount borrowed and a chosen term to estimate a level payment. This payoff calculation starts with the balance and payment to estimate the remaining time. Both use simplified fixed-rate arithmetic and do not replace a lender’s account records.

Frequently Asked Questions

How do I calculate my loan payoff date?
Estimate the remaining number of monthly payments from the current balance, APR, and monthly payment. Then count that many payment periods from the next due date. Request a dated payoff quote from the lender for an exact amount and date.

Does this calculator give an exact payoff date?
No. It estimates the number of monthly periods under fixed-rate assumptions. Posting dates, daily interest, fees, and a different final payment can change the actual date or amount.

What if my monthly payment does not cover the interest?
The balance will not be paid off under the model if the payment is no greater than the first month’s interest. The calculator cannot produce a finite payoff estimate in that situation.

Can I include extra monthly payments?
Yes, for an estimate, enter the total fixed monthly amount, including the extra amount. The calculation assumes that same total is paid every month; it does not model occasional or changing extras.

Why is my lender’s payoff quote different?
A payoff quote may include interest accrued through a specified date and account-specific charges or credits. This calculator uses a simplified monthly schedule and the balance and APR you provide.

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

Related

• Calculate a Monthly Loan Payment: Formula and Example
• How to Calculate Loan Payments: Formula and Example
• Basic Loan Calculator Payment and Formula

in bal | Current loan balance | $ | 20000 | 0.01 | 100000000
in apr | Interest rate (APR) | % | 8 | 0.01 | 100
in pmt | Monthly payment | $ | 500 | 0.01 | 100000000
out mon | Estimated months to repay | months | ceil(round(-ln(1 - (apr / 1200) * bal / pmt) / ln(1 + apr / 1200), 6)) | 0
out yrs | Estimated time to repay | years | mon / 12 | 2
out paid | Total of rounded monthly payments | $ | pmt * mon | 2
out int | Estimated interest paid | $ | paid - bal | 2