calculate-loan

01 Loan payments

Debt Calculator Payoff Schedule and Payment Timeline

Calculator No. 01-18951 · Updated · Formula and assumptions shown below

Payments to payoff 24 months
Total paid
$12,000.00
= Monthly payment × payments to payoff
Total interest
$2,000.00
= Total paid − current debt balance
Current debt balance
$10,000
Input
You enter
Current debt balance ($), Interest rate (APR) (%), Monthly payment ($)
You get
Payments to payoff (months), Total paid ($), Total interest ($)
Rounding
0 dp · 2 dp

Estimate for education, not financial advice. The result follows from the numbers you enter and the formula shown. It is not a quote or an offer, and it does not include fees, taxes or insurance unless the calculator asks for them. Ask your lender for the exact figures.

A debt payoff schedule shows how a balance changes with each payment and estimates how many monthly payments it takes to reach zero. Enter your current debt balance, annual percentage rate (APR), and planned monthly payment to see the estimated payoff time, total paid, and interest.

Formula

The calculator estimates the number of equal monthly payments needed to pay off a balance when interest accrues monthly and each payment is made at month-end. It uses:

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

  • B is the starting balance in dollars.
  • APR is the annual percentage rate in percent; the monthly rate is r = APR / 1200.
  • M is the planned monthly payment in dollars.
  • n is the estimated number of monthly payments, rounded up to a whole payment.

The schedule totals use Total paid = M × n and Total interest = Total paid − B. The formula assumes the same payment each month, including the final payment. In practice, the last payment is usually smaller than the regular payment; the total figures here therefore represent a simplified estimate and may overstate the actual final payment.

Worked Example

Using the default inputs—$10,000 balance, 18% APR, and $500 monthly payment—the monthly rate is 18 / 1200 = 0.015, or 1.5%.

  1. Substitute into the payoff formula: n = ceil(round(-ln(1 − 0.015 × 10,000 / 500) / ln(1.015), 6)).
  2. Calculate the expression inside the logarithm: 1 − 150 / 500 = 0.7.
  3. Then −ln(0.7) / ln(1.015) ≈ 23.98, so rounding up gives 24 monthly payments.
  4. The estimated total paid is $500 × 24 = $12,000.
  5. Estimated interest is $12,000 − $10,000 = $2,000.

These results follow the calculator’s level-payment approximation. A real statement schedule can differ because the final payment, payment posting dates, and the way interest is calculated may not match those assumptions.

Assumptions

  • The APR stays fixed throughout repayment.
  • Payments are made once per month at the end of each monthly period.
  • Interest compounds monthly at APR divided by 12.
  • Payments are level and are applied to interest and then principal.
  • Fees, taxes, insurance, new charges, missed payments, and other account-specific adjustments are not included.

How to Read a Debt Payoff Schedule

A full amortization schedule lists each payment period, the opening balance, interest charged, payment amount, principal reduction, and closing balance. At first, a larger share of a payment can go to interest because interest is calculated on the outstanding balance. As the balance declines, the interest portion generally falls and more of a level payment reduces principal.

This calculator summarizes that timeline rather than displaying every row. “Payments to payoff” is a count of monthly periods, not necessarily an exact calendar date. To estimate a date, count that many payment periods from the next expected payment, but allow for posting dates and changes in the account. “Total paid” and “total interest” are estimates based on repeated full payments; the actual last payment may be lower.

Using the Calculator Carefully

  • Use the current principal or payoff balance, not the original amount borrowed. For a revolving account, check whether new purchases or transactions will be added.
  • Enter the APR as a percentage number. For example, enter 18 for 18%, not 0.18.
  • Enter the amount you expect to pay each month, not the minimum due unless that is the amount you intend to use. Minimum payments can change as the balance changes.
  • Use the rate and payment frequency that match the debt. This calculator treats payments and interest as monthly.
  • Compare the estimate with a current statement or account payoff quote, since timing, fees, and daily interest methods can affect the balance.

Limits and Common Problems

The payment must be large enough to cover the interest accruing each month. In this formula, that means M > r × B. If a payment is equal to or below the monthly interest, the balance will not decline under the model, so there is no finite payoff schedule. The calculator reports that the payoff cannot be computed rather than presenting a misleading timeline.

APR is an annualized rate, while the formula uses a monthly rate. Dividing APR by 12 and converting percent to a decimal gives APR divided by 1,200. Confusing these units can produce a dramatically incorrect result. The model also assumes a fixed rate and regular payments; variable APRs, payment holidays, extra payments, late charges, and new borrowing can all change the outcome. For a more detailed plan, calculate each debt separately using its current balance, applicable APR, and expected payment, and account for payments or charges not represented here.

Related Payoff Questions

A common misconception is that paying the same amount every month always leads to the same payoff date. It does not if the rate changes, the payment is posted at a different point in the cycle, or the balance receives new charges. Likewise, the number of scheduled payments does not mean every payment must be identical: lenders may calculate a smaller final amount to clear the remaining balance.

For debts with different interest rates, this one-debt calculator does not determine how payments across several accounts should be allocated. It can estimate each balance separately, but it does not model account-specific minimum-payment rules or the effect of moving money between debts. Treat its totals as arithmetic estimates, not a statement of what an account provider will collect.

Frequently Asked Questions

How do I calculate how long it will take to pay off debt?
Use the current balance, monthly interest rate, and fixed monthly payment in the payoff formula. The calculator rounds the result up to a whole number of payment periods.

Why does the calculator say it cannot compute my payoff?
The monthly payment may not exceed the interest estimated for one month. If the payment does not cover that interest, the model has no finite payoff time.

Does the payoff schedule include the final smaller payment?
No. The summary multiplies the regular payment by the number of periods, so it treats the last payment as a full payment. A real final payment is often smaller, making actual totals somewhat lower.

Is APR divided by 12 for monthly debt interest?
This estimate converts annual percentage APR to a monthly decimal rate by dividing by 1,200. An account may calculate interest using daily balances or other terms, so check its disclosure for the method that applies.

Can I use this for several debts at once?
Not as one combined schedule when the debts have different rates or payment terms. Estimate each balance separately; this calculator does not model how payments are divided among accounts.

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

Related

Formula used
in bal | Current debt balance | $ | 10000 | 0.01 | 100000000
in apr | Interest rate (APR) | % | 18 | 0.01 | 100
in pmt | Monthly payment | $ | 500 | 0.01 | 100000000
out months | Payments to payoff | months | ceil(round(-ln(1 - (apr / 1200) * bal / pmt) / ln(1 + apr / 1200), 6)) | 0
out total | Total paid | $ | pmt * months | 2
out int | Total interest | $ | total - bal | 2

Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work

Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.

More in this section

The whole Loan payments section →