Calculate Loan Payoff Date with Monthly Payments

This calculator estimates how many monthly payments it will take to repay a fixed-rate loan, based on the current balance, APR, and payment amount. Enter those figures to see the estimated payoff time in months and years; the result assumes payments stay level and are made monthly.

Formula

For a positive monthly interest rate, the number of level payments is calculated by solving the standard loan-balance equation for the number of periods, then rounding up to a whole payment:

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

• B is the current loan principal balance, in dollars.
• APR is the annual percentage rate entered as a percentage, such as 8 for 8%.
• r is the monthly rate as a decimal: APR ÷ 1,200.
• M is the monthly payment, in dollars.
• n is the estimated number of monthly payments. The calculator rounds up because a partial final month still requires a final payment.

The calculation requires M > rB: the payment must exceed the interest accrued in one month on the starting balance. If the payment only covers interest or is smaller, the balance will not be paid off under this model. Total scheduled payments are M × n, and estimated interest remaining is that total minus B. Those totals assume the same full payment is made each month, including the last one; an actual final payment is often smaller.

Worked Example

Using the calculator’s defaults, the current balance is $20,000, APR is 8%, and the monthly payment is $405.53.

1. Convert APR to a monthly decimal rate: r = 8 ÷ 1,200 = 0.0066667 (approximately).
2. Check the first month’s interest: $20,000 × 0.0066667 is approximately $133.33. The $405.53 payment exceeds that amount, so the model produces a payoff estimate.
3. Apply the payoff formula: −ln(1 − (0.0066667 × 20,000 ÷ 405.53)) ÷ ln(1.0066667) is approximately 59.99 months before rounding up.
4. Round up to a whole payment: 60 months, or 5.00 years.
5. Calculate the scheduled-payment total: $405.53 × 60 = $24,331.80. Subtract the starting balance to estimate $4,331.80 in interest remaining.

The months result is the calculator’s headline answer. Actual interest and the final payment can differ because the balance changes, payment dates vary, and lenders may calculate interest using a different schedule.

Assumptions

• The APR is fixed for the entire estimated payoff period.
• Payments are made once per month, on schedule, with no missed or late payments.
• Interest compounds monthly at APR ÷ 12, with the APR supplied as an annual percentage.
• The model excludes fees, taxes, insurance, PMI, escrow, penalties, and any extra charges or payments.
• The payment stays constant in the estimate; the model does not reduce the last payment to the precise remaining amount.

How to Use the Payoff Estimate

Use the current principal balance, not necessarily the original amount borrowed. If you have an account statement, look for the outstanding principal or loan balance and the current APR. Enter the regular amount actually applied as a monthly loan payment. If one amount includes insurance, escrow, or other charges, those portions do not necessarily reduce principal; use the loan-payment portion where it can be identified.

The result is a mathematical estimate of the number of monthly periods, not a calendar date. To turn it into a calendar estimate, count that many scheduled payment dates from the next payment date. The actual payoff date depends on the lender’s posting rules, payment timing, any rate changes, and the exact amount due. Ask the servicer for a payoff quote when a precise amount or date is needed.

For a more complete comparison, the calculator also shows the estimated total of scheduled payments and interest above the current balance. These are not the same as a formal payoff quote: a quote may include interest accrued since the last payment and other amounts that this simple calculation does not model.

Common Problems and Limits

• Payment does not cover monthly interest: If the payment is at or below the first month’s interest, the balance does not decline under the fixed-payment assumptions. The logarithm formula has no valid payoff result in that case.
• Using an outdated balance or rate: A balance from before a recent payment, or an APR that has changed, can shift the estimate. Use current loan information.
• Confusing APR and monthly rate: Enter the annual rate as a percentage, not as a monthly decimal. For example, enter 8 for 8% APR; the formula converts it to a monthly rate.
• Rounding the payment too early: Use the actual scheduled payment to the cent. Small differences can change the number of months near a whole-payment boundary.
• Assuming every loan accrues interest identically: Variable rates, daily interest calculations, irregular payment dates, fees added to principal, and payment allocation rules can all produce a different schedule.

This formula is for a balance repaid through equal monthly payments at a fixed positive rate. It does not forecast future rate changes or account for extra payments. If you regularly pay extra toward principal, the actual payoff may come sooner, but the result here will not reflect that unless the extra amount is included in the monthly payment input.

Frequently Asked Questions

How do I calculate my loan payoff date?
Enter the current balance, annual APR, and monthly payment. The calculator estimates the whole number of monthly payments needed; count that many payment dates from the next due date for an approximate calendar date.

What if my monthly payment is less than the interest?
The payment will not reduce the balance under this model. If it is equal to or below the first month’s interest, there is no finite payoff estimate using a fixed payment; check the loan terms and current balance with the servicer.

Does this include extra payments?
No. It assumes one unchanged monthly payment. To estimate a consistent extra amount, add it to the regular principal-and-interest payment before entering the total, while recognizing that actual payment allocation may vary.

Why is the payoff date different from my lender’s date?
The calculator uses simplified monthly compounding and whole monthly periods. A lender’s schedule can reflect exact payment dates, daily interest, rate adjustments, fees, posting delays, and a smaller final payment.

Is the payoff time the same as a payoff quote?
No. The result estimates time and scheduled-payment totals. A payoff quote is a lender-provided amount calculated for a particular date and may include accrued interest or other items not included here.

This result is an estimate for educational arithmetic; 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 payoff time | years | mos / 12 | 2
out paid | Total of scheduled payments | $ | pmt * mos | 2
out int | Estimated interest remaining | $ | paid - bal | 2