How to Calculate a Loan Payoff Date

A payoff-date calculator estimates how many monthly payments remain before a fixed-rate loan is repaid, based on its current balance, APR, and planned payment. Enter those figures to get an estimated payoff date and the total number of payments; check the lender’s payoff quote for the exact amount and date.

Formula

The calculator estimates the number of monthly payments needed to repay the balance when the interest rate and payment stay fixed. It first calculates the monthly rate, then solves the amortization equation for the repayment period and rounds up to a whole payment month.

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

• n = estimated months to payoff, in monthly payment periods.
• r = monthly interest rate as a decimal, calculated as APR ÷ 1,200. For an 8% APR, r = 0.08 ÷ 12.
• B = current principal balance in dollars.
• M = monthly payment in dollars, assumed to be applied to the loan each month.
• ceil = round up to the next whole month because a partial payment period still requires a final payment.

The total-payments output is n × M. It assumes the same payment is made for every counted month, including the last one. The actual final payment is often smaller, so this total is a simple estimate rather than an exact payoff quote.

Worked Example

Using the calculator’s defaults: balance B = $20,000, APR = 8%, and monthly payment M = $406.66.

1. Convert APR to a monthly decimal rate: r = 8 ÷ 1,200 = 0.0066667.
2. Calculate the numerator’s logarithm input: 1 − (0.0066667 × 20,000 ÷ 406.66) ≈ 0.67213.
3. Apply the formula: n = ceil(round(−ln(0.67213) ÷ ln(1.0066667), 6)) = ceil(60.000) = 60 months.
4. Calculate the estimated remaining payments: 60 × $406.66 = $24,399.60.

This is an estimate based on a fixed payment and monthly interest. It does not calculate an exact calendar date because payment due dates, posting delays, and lender-specific payoff processing can affect the date. To translate 60 months into a calendar date, count 60 payment periods from the next scheduled payment, then verify with the servicer.

Assumptions

• The APR and payment remain fixed throughout the estimated payoff period.
• Payments are made monthly and on schedule; the first remaining payment is one month from now.
• Interest compounds monthly at APR ÷ 12, with no daily-interest adjustments modeled.
• Fees, taxes, insurance, PMI, escrow, late charges, and extra payments are not included.
• The actual last payment may be less than the regular payment. The total output multiplies the regular payment by all estimated months as a simple estimate.

What You’ll Need

• Your current loan principal balance, not the original amount borrowed. A recent statement or online account may show it.
• The loan’s annual percentage rate (APR), expressed as a percentage. If the rate is variable, the result only reflects the rate entered.
• Your required monthly payment amount, excluding optional extra principal unless you intend to pay that amount consistently.
• Your next payment due date if you want to turn the month estimate into a tentative calendar date.
• A current payoff quote from the lender if you need the exact amount to close the loan on a particular date.

Step-by-Step

1. Find the current balance. Use the outstanding principal, not the amount originally borrowed and not a payoff quote that includes accrued interest and fees. Record the date of the balance; a balance can change after payments or interest accrual.
2. Enter the APR. Use the annual percentage rate shown in the loan documents or account. The formula converts it to a monthly rate by dividing by 1,200. If the rate can change, treat the result as a snapshot based on the APR entered.
3. Enter the monthly payment. Use the regular amount that will actually be paid each month. Do not include a one-time extra payment unless it is already reflected in the balance. If you plan to pay extra regularly, use the intended total monthly amount and understand that the estimate assumes it continues.
4. Calculate the number of months. The calculator applies the amortization formula and rounds up to a whole month. A result of 60 means the model requires 60 monthly payment periods; it does not by itself identify the exact date funds must arrive.
5. Estimate the calendar payoff date. Starting from the next scheduled payment date, count the calculated number of monthly payment periods. If the due date is the 29th, 30th, or 31st, or a payment may post late, the lender’s schedule can differ. Treat this date as provisional.
6. Request an exact payoff figure before paying off the loan. Ask the lender or servicer for a payoff quote good through the date you plan to pay. It may account for interest accruing daily, the payment posting date, and applicable charges. Follow its instructions for payment amount, method, and delivery deadline.
7. Confirm the account is settled. After paying, check that the transaction posted and the balance is zero. If a small amount remains, contact the servicer to clarify whether interest accrued or a payment was applied differently than expected.

Common Mistakes

• Entering the original loan amount: Use the current remaining principal. Starting with the original amount can overstate the time left.
• Mixing APR formats: Enter 8 for 8%, not 0.08. The calculator expects a percentage and divides by 1,200.
• Using a payment that does not cover interest: The monthly payment must be greater than the first month’s interest for the balance to decline. At or below that amount, the formula cannot produce a valid payoff estimate.
• Assuming the calculated total is the payoff quote: It multiplies the regular payment by the month count and does not model a smaller final installment or daily accrued interest.
• Ignoring rate or payment changes: A variable APR, skipped payment, late payment, or payment adjustment can shift the payoff timing.
• Confusing a payoff date with a payment due date: The final scheduled installment date and the date a lender’s payoff quote is valid through may not be the same.

Tips

• Use figures from the same recent statement or account snapshot so the balance and payment information are consistent.
• For a variable-rate loan, recalculate when the APR changes; do not treat one estimate as a guaranteed schedule.
• If you are planning extra payments, include only amounts you can actually maintain in the monthly-payment input. The result assumes that amount is paid every month.
• Keep the lender’s payoff quote and payment confirmation. The quote is the relevant source for the amount due on its stated date.
• Recheck the estimate after a payment posts or if the balance changes materially. The output is sensitive to the balance, rate, and payment.

Troubleshooting

The calculator says it cannot compute: Check that the monthly payment is greater than the monthly interest on the current balance. Monthly interest is approximately balance × APR ÷ 1,200. If the payment is not higher, the balance will not be repaid under the modeled terms. Verify that the APR was entered as a percentage and that the balance and payment use the same currency.

The result differs from the lender’s estimate: Compare the balance date, APR, payment amount, and due date. The lender may use daily interest, a different compounding convention, payment posting dates, fees, or a changing rate. Ask for an explanation of the lender’s calculation rather than adjusting figures to force a match.

The calendar date seems off by a month: The calculator returns payment periods, not a date. Whether the next payment is counted as period one depends on when it is due and when it posts. Count from the next scheduled payment and verify the final date with the servicer.

The final payment is not the regular amount: That is common in an amortizing schedule. Request an updated payoff quote for the intended payment date; do not assume the displayed total is the exact final amount.

Frequently Asked Questions

How do I calculate a loan payoff date manually?
Convert APR to a monthly decimal rate, then use the amortization formula to solve for the number of payment periods. Round up to a whole month and count those periods from the next scheduled payment date.

Is payoff date the same as the last payment due date?
Not necessarily. The date can depend on payment posting and accrued interest, while a payoff quote specifies an amount valid through a particular date.

Can I use this for a variable-rate loan?
You can estimate using the current APR, but the result assumes that rate stays fixed. Recalculate after rate changes and rely on the servicer for current payoff details.

What if my payment is only slightly above the interest?
The balance may decline very slowly, producing a long payoff estimate. Check the inputs and recognize that the formula assumes the same payment continues without interruption.

Does the total-payments figure include interest?
It represents the modeled sum of monthly payments, so it includes principal and interest in those payments. It is not an exact interest total or a lender payoff quote.

Can extra payments change the payoff date?
Yes, if they reduce principal and are applied to principal, they can shorten repayment. This calculator does not model a one-time extra payment; its payment input assumes the same amount each month.

This is estimate arithmetic for education, not financial advice; the lender’s disclosure gives the exact figures.

Related

• Monthly Loan Repayment Calculator and Payment Formula
• 30 Year Loan Repayment Calculator: Monthly Payment & Interest
• Loan Calculator Monthly Breakdown: Payment and Interest

in bal | Current loan balance | $ | 20000 | 0.01 | 100000000
in apr | Interest rate (APR) | % | 8 | 0.01 | 100
in pmt | Monthly payment | $ | 406.66 | 0.01 | 1000000
out date | Months to payoff | months | ceil(round(-ln(1 - (apr / 1200) * bal / pmt) / ln(1 + apr / 1200), 6)) | 0
out total | Estimated remaining payments | $ | pmt * date | 2