Debt Payoff Date Calculator: Estimate Your Final Payment

A debt payoff date calculator estimates how many monthly payments it will take to repay a balance, then converts that payment count into an approximate final-payment date. Enter your balance, APR, planned monthly payment, and the date of your next payment to see the estimated payoff date and the interest cost under a fixed-rate, monthly-payment model.

Formula

For a fixed monthly payment and a positive monthly interest rate, the number of payments is the rounded-up solution to the amortization equation:

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

• B is the current balance in dollars.
• APR is the annual percentage rate entered as a percent, such as 18 for 18%.
• r is the monthly rate as a decimal.
• M is the monthly payment in dollars.
• n is the number of full monthly payments remaining, rounded up to a whole payment.

The estimated payoff month is found by counting n payment dates forward from the entered month and year. The estimate treats each payment as occurring once per month. Estimated interest remaining is n × M − B; this uses the same full payment amount for every remaining payment and is therefore an approximation if the last payment is smaller.

Worked Example

Using the calculator’s default values: balance B = $5,000, APR = 18%, monthly payment M = $250, and next payment date in December 2026.

1. Convert the APR to a monthly decimal rate: r = 18 / 1200 = 0.015, or 1.5% per month.
2. Substitute into the payment-count formula: n = ceil(round(−ln(1 − 0.015 × 5,000 / 250) / ln(1.015), 6)).
3. Inside the first logarithm, 1 − 0.3 = 0.7. The unrounded quotient is approximately 24.15 months, so rounding up gives 25 payments remaining.
4. Counting 25 monthly payments starting in December 2026 gives an approximate payoff month of December 2028.
5. The simple estimated interest output is 25 × $250 − $5,000 = $1,250.00.

The final payment in a real amortization schedule may be less than $250. The interest estimate above counts 25 full payments, so it can overstate interest when the last payment only covers the smaller remaining balance and accrued interest.

Assumptions

• The APR and balance stay fixed throughout the estimate.
• Payments are made monthly, with the first payment in the month entered and subsequent payments one month apart.
• Interest accrues monthly using APR divided by 12, or APR / 1200 as a decimal rate.
• The calculation excludes fees, new purchases or borrowing, late charges, taxes, insurance, and changes in payment amount or interest rate.

How to Use the Payoff Estimate

Use the current amount owed rather than the original amount borrowed. Enter the APR that applies to that balance, not a promotional rate that has expired or a rate from a different account. If a statement gives a variable APR, the calculator can only show a snapshot based on the rate entered; it cannot predict future rate changes.

For the payment input, use the amount you expect to pay each month toward this debt. If you pay a minimum that changes as the balance falls, entering today’s minimum as a fixed payment will not reproduce the account’s actual schedule. The calculator also assumes the stated payment is applied to the modeled balance and that you do not add new charges.

Enter the month and year when the next payment is expected. The result is a month-level estimate, not a guaranteed calendar day: payment due dates, weekends, processing, statement cycles, and interest posting can shift the actual date. If today is before the next scheduled payment, use that future payment month rather than counting an immediate payment.

When the Calculation Cannot Work

The payment must be large enough to cover interest accruing in one month. The test is M > r × B. With a $5,000 balance at 18% APR, monthly interest at the starting balance is about $75; a payment of $75 or less does not reduce principal under this model. The calculator therefore cannot produce a finite payoff period when the payment fails this test. A payment only slightly above the monthly interest may still result in a very long repayment period.

Another common misunderstanding is treating the output as an exact statement payoff quote. The balance can accrue interest between the statement date and the date a payment posts, and account-specific rules can affect how payments are applied. For a precise amount to close an account on a particular date, consult the account provider’s current payoff information.

What the Date and Interest Results Mean

“Payments remaining” is the count of monthly payment periods implied by the formula, rounded upward so the balance is not left partially unpaid. The displayed month is based on the next payment month you entered. It does not account for a skipped or missed payment, extra payments, or a payment arriving late.

The interest output is a rough comparison aid, not a full statement-level ledger. It multiplies the payment by the rounded-up count and subtracts the starting balance. Because this treats the last payment as a full payment, the result may exceed the interest actually charged. A detailed schedule would calculate interest and principal for each period and adjust the final payment.

Frequently Asked Questions

How do I calculate when my debt will be paid off?
Use the balance, APR, and fixed monthly payment in the amortization formula to estimate the number of payments, then count those monthly payment dates from your next expected payment date.

Why does the calculator say it cannot compute?
The planned payment may not exceed the estimated interest added each month. If the payment does not cover interest, the balance will not be repaid by a sequence of fixed payments under this formula.

Does the payoff date include extra payments?
Not unless you include them in the monthly payment amount. This calculator assumes one fixed payment each month; irregular or one-time extra payments require a schedule that models their timing.

Will my last payment be the same as the monthly payment?
Not necessarily. The actual final payment is often adjusted to the remaining principal and accrued interest. This calculator rounds the payment count up and uses full payments for its simple interest estimate.

Is the payoff date exact?
No. It is an estimate based on the entered figures and simplified monthly timing. Variable rates, fees, payment posting dates, and account-specific calculations can change the actual payoff date.

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

Related

• Loan Calculator Based on Payment Amount: How Long to Pay It Off
• EMI Calculator: How the Monthly Instalment of a Loan Is Calculated
• Loan Calculator With Down Payment: Payment on What You Borrow

in bal | Current debt balance | $ | 5000 | 0.01 | 100000000
in apr | Interest rate (APR) | % | 18 | 0.01 | 100
in pay | Monthly payment | $ | 250 | 0.01 | 100000000
in yr | Year of next payment | years | 2026 | 1 | 9999
in mo | Month of next payment | month | 12 | 1 | 12
out n | Payments remaining | - | ceil(round(-ln(1 - (apr / 1200) * bal / pay) / ln(1 + apr / 1200), 6)) | 0
out date | Approximate payoff month | - | yr + floor((mo - 1 + n - 1) / 12) + (mo - 1 + n - 1 - 12 * floor((mo - 1 + n - 1) / 12) + 1) / 1000000 | 0
out int | Estimated interest remaining | $ | n * pay - bal | 2