Loan Payoff Date Calculator
A $18,000 balance at 6.5% paid at $450 a month, with the next payment in December 2026, is paid off in September 2030: 46 payments and $2,342 of interest.
Enter your own loan to get the month of your last payment, then read the tables for what a bigger payment or a different rate does to it.
Loan payoff date calculator
Last payment: September 2030
That is 46 payments, 3 years 10 months, and $2,342 of interest in total.
A bigger payment moves the date
The loan is $18,000 at 6.5%, first payment in December 2026. One month of interest is $97.50.
| Monthly payment | Last payment | Time | Interest paid |
|---|---|---|---|
| $350 | December 2031 | 5 years 1 month | $3,156 |
| $450 | September 2030 | 3 years 10 months | $2,342 |
| $550 | December 2029 | 3 years 1 month | $1,867 |
| $700 | March 2029 | 2 years 4 months | $1,436 |
The same $450 payment at three rates
A higher rate leaves less of each payment for principal, so the last payment comes later.
| Rate | Last payment | Time | Interest paid |
|---|---|---|---|
| 4.5% | July 2030 | 3 years 8 months | $1,539 |
| 6.5% | September 2030 | 3 years 10 months | $2,342 |
| 8.5% | November 2030 | 4 years | $3,240 |
How the calculator works
- Each month, interest = balance x rate / 12.
- The payment minus that interest comes off the balance.
- It counts payments until the balance reaches zero, then adds that many months to the month of your next payment.
It assumes a fixed rate and that every payment lands on its due date. For the payoff schedule year by year see the loan payoff calculator with amortization, and for one extra payment the early loan payoff calculator for a lump sum.
Check before you pay early
The CFPB says a prepayment penalty is a fee that some lenders charge if you pay off all or part of your mortgage early.
Other loans set their own terms, so read your loan agreement for a prepayment fee and ask how an extra payment is applied.
Frequently asked questions
How do I find my loan payoff date?
Enter the balance you owe today, the rate and the payment you make each month, and set the month of your next payment. The calculator counts the payments until the balance reaches zero and names the month of the last one.
Why is the date different from the end date on my loan paperwork?
The paperwork date follows the original schedule. If you pay more than required, pay late, or the rate changed, the real date moves. This calculator uses the payment you enter and a fixed rate.
How much sooner does an extra payment end the loan?
On the example loan, $550 a month instead of $450 ends it in 3 years 1 month instead of 3 years 10 months.
What if my payment is lower than the interest?
The balance never falls. On the example loan one month of interest is $97.50, so a payment of that size or less never pays it off.
How do I work out the payoff date in a spreadsheet?
Use NPER(rate/12, -payment, balance) for the number of payments, then =EDATE(first payment date, payments - 1) for the date of the last one.
Sources
Every figure on this page comes from the pages below. Checked 2026-11-14. Rules change, so confirm with your own servicer.
- CFPB: What is a prepayment penalty? (the definition of a prepayment penalty)
More recast guides
- Free Mortgage Recast Calculator - enter your own loan and see the new payment.
- Recast vs Refinance Calculator - Compare both options on the same loan, with a break-even point.
- Recast Fees and Rules by Lender - Fees, minimums and loan limits published by four large lenders.
- How to Calculate a Recast Payment - The formula, a step-by-step example and the numbers to check.
- How Much Will a Recast Lower My Payment? - The lump sum divided by balance shortcut, with lookup tables.
- Recast vs Extra Principal Payment - The same lump sum two ways: payment, payoff date and interest.
- Recast Amortization Schedule - Balance and interest by year, before and after a recast.
- Chase Mortgage Recast Calculator - No stated minimum, what the lender page says and what a lump sum does.
- Wells Fargo Mortgage Recast Calculator - The jumbo loan recast option, the $10,000 starting point and the rate used.
- Bank of America Mortgage Recast Calculator - Eligibility, timing and an estimate the lender will not give you.
- Best Mortgage Recast Calculator: What to Check - Seven checks and a test loan with the right answer.
- Mortgage Recast Calculator in Excel or Google Sheets - Cell-by-cell layout with PMT, interest saved and a fee break-even.
- How Much Does a Mortgage Recast Cost? - What lenders publish about the fee, and months to pay it back.
- Mortgage Recast Savings Calculator - Monthly saving, interest saved and the net after a fee, by lump sum.
- Home Loan Recast Calculator - The three numbers to enter and three worked loans.
- What Is a Mortgage Recast? - What changes, what stays the same, with a worked example.
- Mortgage Loan Payoff Calculator With Extra Payments - New payoff date and interest saved, for monthly extras and one-time payments.
- Dave Ramsey Mortgage Payoff Calculator Explained - What the calculator asks for, a loan you can check and a calculator of your own.
- Amortization Schedule for a Balloon Mortgage - Balance by year and the balloon due at the end of a 5, 7 or 10-year term.
- Car Loan Early Payoff Calculator - New payoff date and interest saved for monthly extras and a one-time payment.
- HELOC Monthly Payment Calculator - The interest-only draw payment, the repayment payment and the rise between them.
- Biweekly Mortgage Payment Calculator - Monthly against biweekly, with and without extras, and the free alternative.
- Loan Payoff Calculator for Weekly Payments - Weekly against monthly on the same loan, and the interest saved.
- Personal Loan Early Payoff Calculator - Monthly extras, and what you owe and skip if you pay the whole loan off early.
- Loan Payoff Calculator With Additional Payments - The extra as a share of the payment, and the same extra on three loans.
- Early Payoff Home Loan Calculator - The extra a month it takes to finish a home loan in the year you pick.
- Refinance Break-Even Point Calculator - Closing costs divided by the monthly saving, for any rate drop and term.
- UCCU HELOC Payment Calculator Explained - Interest-only and principal and interest HELOC payments, and the rise in repayment.
- House Loan Payoff Calculator - What you owe each year on a house loan and what a monthly extra saves.
- Estimated Loan Payoff Calculator - The balance after your payments and the interest added by the day.
- 401k Loan Payoff Calculator - A monthly extra or a one-time payment on a 401k loan, and the interest saved.
- Home Equity Loan Payoff Calculator - A monthly extra on a home equity loan and the balance you would owe by year.
- Car Loan Payoff Calculator, Biweekly - Half the car payment every 14 days against monthly, and the interest saved.
- Early Loan Payoff Calculator, Lump Sum - One extra payment on a loan: the amount, the timing and the interest saved.
- PMI Removal Calculator - When the balance reaches 80% and 78% of the original value, and what an extra payment changes.
- Loan Payoff Calculator With Amortization - The payoff schedule by year, interest against principal, with a monthly extra.
- HELOC Loan Payoff Calculator - Months to pay off a HELOC balance at your payment, and the interest it costs.