calculate-loan

01 Loan payments

Determine Loan Payoff Date: Formula & Calculator

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

Monthly payment $405.53
Total interest remaining
$4,331.67
= Monthly payment × remaining term (years) × 12 − current loan balance
Current loan balance
$20,000
Input
Annual interest rate (APR)
8 %
Input
You enter
Current loan balance ($), Annual interest rate (APR) (%), Remaining term (years) (years)
You get
Monthly payment ($), Total interest remaining ($)
Rounding
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.

This calculator determines the exact date your loan will be paid off based on your current balance, interest rate, and monthly payment. You enter the loan amount, APR, and either the remaining term or your desired payment, and it returns the payoff date, total interest, and final payment amount. The result is an estimate based on standard amortization math, and your lender’s statement is the final authority.

Formula

The standard amortization formula calculates the fixed monthly payment that fully repays a loan over a specified number of months. The formula is:

Monthly Payment = P × (r × (1 + r)^n) / ((1 + r)^n − 1)

Where:

  • P = current loan balance (principal remaining), in dollars
  • r = monthly interest rate = APR / 1200 (APR is the annual percentage rate, as a percent, e.g., 8 for 8%)
  • n = number of remaining monthly payments = years × 12

The payoff date is simply today’s date plus n months (or the date of the last payment). The total interest is the sum of all payments minus the principal.

Worked Example

Using the defaults from the calculator above: balance = $20,000, APR = 8%, remaining term = 5 years.

  1. Convert APR to monthly rate: r = 8 / 1200 = 0.0066667
  2. Number of payments: n = 5 × 12 = 60
  3. Apply the formula: Payment = 20000 × (0.0066667 × (1.0066667^60)) / ((1.0066667^60) − 1)
  4. Calculate (1.0066667^60) ≈ 1.48985
  5. Numerator: 20000 × 0.0066667 × 1.48985 ≈ 198.647
  6. Denominator: 1.48985 − 1 = 0.48985
  7. Payment ≈ 198.647 / 0.48985 ≈ 405.53 (rounded to the cent)

So the monthly payment is $405.53. Over 60 months, total paid = 405.53 × 60 = $24,331.80. Total interest = 24,331.80 − 20,000 = $4,331.80. If today is January 15, 2025, the payoff date is January 15, 2030 (60 months later).

Assumptions

  • Fixed interest rate for the entire remaining term (no rate changes).
  • Payments are made monthly at the end of each month (standard amortization).
  • Interest compounds monthly at APR / 12.
  • No extra fees, late charges, prepayment penalties, or skipped payments are included.
  • The payment is rounded to the cent, and the final payment may be slightly different due to rounding.

How to Use the Payoff Date Calculator

To get a realistic payoff date, you need three numbers from your latest loan statement:

  • Current balance – the principal remaining, not the original loan amount.
  • APR – the annual interest rate, usually shown as a percentage.
  • Remaining term – how many months (or years) are left on the loan, or your desired monthly payment if you plan to pay extra.

If you want to see the effect of extra payments, you can adjust the payment upward (by increasing the payment amount manually, but this calculator uses the term to derive the payment). For a true extra-payment scenario, you would need a calculator that takes a custom payment amount. The key insight is that paying extra reduces the number of months, not the monthly payment (unless you recast the loan).

Common Mistakes and Misconceptions

  • Using the original loan amount instead of the current balance. The payoff date depends on what you owe now, not what you borrowed.
  • Mixing APR with monthly rate. APR is annual; you must divide by 12 to get the monthly rate. Using 8% directly in the formula gives a wildly wrong payment.
  • Ignoring payment timing. The formula assumes the first payment is due one month after the balance date. If your statement date differs, the payoff date shifts by a few days.
  • Assuming the payoff date is the same as the original maturity date. If you’ve made extra payments or missed payments, the remaining term changes.
  • Rounding too early. Always keep full precision until the final payment, then round to cents.

Why the Payoff Date Matters

Knowing your payoff date helps you plan for when you’ll be free of that debt, whether it’s a car loan, student loan, or personal loan. It also lets you compare the cost of different payment strategies. For example, if you increase your monthly payment by $50, you might shave several months off the term and save hundreds in interest. The calculator shows the trade-off between payment size and term length.

Another common use is for refinancing decisions. If you’re considering a new loan with a lower rate, you can compare the payoff date and total interest under the new terms versus your current plan. However, always factor in any fees or closing costs, which are not included here.

Limits of This Calculation

This formula assumes a fixed-rate, fully amortizing loan with equal monthly payments. It does not apply to:

  • Interest-only loans (where payments don’t reduce principal for a period)
  • Balloon loans (where a large final payment is due)
  • Variable-rate loans (where the rate changes, altering the payment)
  • Loans with fees added to the balance or prepayment penalties

For those, the payoff date can change based on future rate adjustments or fee schedules. Also, if you make biweekly payments (half the monthly payment every two weeks), you effectively make 13 full payments a year, which shortens the term—this calculator does not model that.

Frequently Asked Questions

How do I calculate my payoff date manually?

Use the formula above to find the monthly payment, then count forward that many months from your next payment due date. For example, if you have 24 payments left and your next payment is due March 1, 2025, your payoff date is March 1, 2027.

What if I make an extra payment?

An extra payment reduces the principal immediately, which shortens the term. To see the effect, you’d need to recalculate the remaining term using the new balance and the same monthly payment. The formula for months remaining is: n = −ln(1 − r × P / M) / ln(1 + r), where M is your monthly payment. This calculator doesn’t handle extra payments, but you can approximate by reducing the balance and term accordingly.

Does the payoff date include the day I make the payment?

Typically, the payoff date is the date of your final payment, not the day before. If you pay on the 15th of each month, the last payment is on the 15th, and the loan is considered paid off that day. However, some lenders may require payment by a specific time on that date.

Why does my lender’s payoff quote differ from this calculation?

Lenders often include per-diem interest (interest accrued from the last payment date to the payoff date) and may charge a payoff processing fee. Also, if you’re paying off early, the lender may calculate interest using a different method (e.g., daily simple interest). Always request a formal payoff quote for the exact amount.

Can I use this for a mortgage?

Yes, the math is the same for a fixed-rate mortgage. However, mortgages often have escrow for taxes and insurance, which are not part of the principal and interest payment. This calculator only covers principal and interest, so your total monthly payment will be higher. Also, mortgage interest may be calculated differently if you pay biweekly or if the loan is an adjustable-rate mortgage.

This result is an estimate based on standard amortization; your lender’s disclosure provides the exact payoff figures.

Related

Formula used
in p | Current loan balance | $ | 20000 | 0 | 100000000
in apr | Annual interest rate (APR) | % | 8 | 0.01 | 100
in yrs | Remaining term (years) | years | 5 | 0.0833 | 50
out pmt | Monthly payment | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2
out int | Total interest remaining | $ | pmt * yrs * 12 - p | 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 →