A loan end date calculator estimates when a fixed-rate loan will be paid off from its balance, APR, monthly payment, and the date payments begin. Enter those figures to see the estimated number of monthly payments and the calendar date of the final payment; the estimate assumes payments arrive on schedule and does not account for fees or payment changes.
Formula
The calculator first estimates the number of level monthly payments needed to repay the remaining balance, then places the final payment that many payment dates into the future. Its payoff calculation is:
n = ceil(round(−ln(1 − r × B ÷ M) ÷ ln(1 + r), 6))
- B is the remaining principal balance in dollars.
- APR is the annual percentage rate entered as a percentage.
- r is the monthly interest rate, calculated as APR ÷ 1200.
- M is the fixed monthly payment in dollars.
- n is the estimated count of monthly payments, rounded up to a whole payment.
The calendar estimate uses the first payment month as payment one. Therefore, the final payment falls n − 1 months after the first payment month. The calculator advances by calendar months; a lender’s exact due date, weekend handling, and final-payment adjustment can make the actual date or amount differ. The remaining-payment total is M × n, and estimated interest is that total minus B. This interest figure is only for the remaining repayment period, not interest already paid over the life of the loan.
Worked Example
Using the calculator’s default inputs: balance B = $20,000, APR = 8%, monthly payment M = $405.53, and first payment in December 2026:
- Convert the APR to a monthly rate: r = 8 ÷ 1200 = 0.0066667, or about 0.66667% per month.
- Calculate the unrounded payment count: −ln(1 − 0.0066667 × 20,000 ÷ 405.53) ÷ ln(1.0066667) ≈ 59.99 months.
- Round the count up to a whole payment: n = 60 monthly payments.
- Payment one is due in December 2026. Payment 60 falls 59 months later, in November 2031.
- Total of the remaining payments: $405.53 × 60 = $24,331.80. Estimated remaining interest: $24,331.80 − $20,000 = $4,331.80.
The last payment may be smaller than the regular payment because of payment rounding or the lender’s daily interest calculation. The displayed total treats all 60 payments as $405.53, so it is a planning estimate rather than a lender payoff quote.
Assumptions
- The APR and monthly payment remain fixed throughout the estimated payoff period.
- Payments are made monthly, on schedule, with the first payment in the month entered.
- Interest is modelled monthly at APR ÷ 12; actual contracts can accrue interest differently.
- The calculation excludes fees, taxes, insurance, PMI, escrow, missed or late payments, and payment changes.
How to Use the Estimate
Use a current remaining principal balance rather than the original amount borrowed. If a recent statement shows a principal balance, that is generally the relevant starting figure for this calculation. An account’s total amount due or a payoff quote may include accrued interest and charges as well, so it may not equal principal alone.
Enter the APR as a percentage: for example, enter 8 for 8%, not 0.08. Enter the regular monthly amount actually applied to the loan. If part of a combined bill pays insurance, escrow, or another charge, do not treat the entire bill as principal-and-interest payment unless those amounts are included in the loan’s payment calculation.
The result is most useful for a straightforward, amortizing loan with a fixed rate and a steady monthly payment. It can help answer “about when would this balance be cleared if I keep paying this amount?” It is not a substitute for a lender’s payoff statement, which may specify an amount good through a particular date.
What Can Change the Payoff Date?
The estimate depends strongly on whether the payment covers monthly interest. At the entered APR, the first month’s approximate interest on a $20,000 balance is $133.33. A payment must exceed the interest accruing each month to reduce principal under this model. If the payment is too small, the logarithm in the formula has no valid real result; the calculator cannot produce a payoff date. A payment that barely exceeds interest can also imply a very long payoff period.
Real accounts may differ because interest can accrue daily, payments may post after their due date, the rate may change, or a payment may include charges that do not reduce principal. Extra principal payments, skipped payments, and late payments also change the schedule. For variable-rate loans, a single APR cannot describe the whole future unless the rate stays unchanged.
Another common misunderstanding is that an “end date” is always the date printed in the original loan agreement. That date usually follows the contract’s scheduled term and payment plan. Paying more, paying less, changing the rate, or starting with a different balance can shift the estimated payoff date. Conversely, a calculated date does not amend the loan contract or guarantee that the account will close on that day.
Frequently Asked Questions
How do I calculate when my loan will be paid off?
Use the remaining balance, APR, and monthly payment in the payoff formula above. The calculator estimates the required whole monthly payments and counts forward from the first payment month.
Does the loan end date calculator include extra payments?
No. This version assumes one fixed monthly payment. Extra principal payments can shorten repayment, but their timing and amount must be modelled separately to estimate their effect.
Why does the calculator say it cannot calculate a date?
The entered payment may not cover the interest due at the entered APR, or the values may otherwise make the formula invalid. Check that APR is entered as a percentage and that the payment is the amount applied to the loan each month.
Is the estimated date the exact date my loan closes?
No. It is a mathematical estimate based on monthly interest and on-time payments. The servicer’s account records and payoff quote determine the amount and date needed to clear the actual balance.
What balance should I enter?
Enter the current unpaid principal balance when available. A payoff quote may include interest accrued through a specific date and other amounts, so it is not always the same as the principal balance used by this calculator.
This result is an estimate, and the lender’s disclosure gives the exact figures.
Related
Formula used
in bal | Remaining loan balance | $ | 20000 | 0.01 | 100000000 in apr | Interest rate (APR) | % | 8 | 0.01 | 100 in pmt | Monthly payment | $ | 405.53 | 0.01 | 100000000 in yr | First payment year | years | 2026 | 1900 | 9999 in mon | First payment month | month | 12 | 1 | 12 out n | Estimated payments remaining | months | ceil(round(-ln(1 - (apr / 1200) * bal / pmt) / ln(1 + apr / 1200), 6)) | 0 out end | Estimated final payment month | months after first payment | n - 1 | 0 out total | Total of remaining payments | $ | pmt * n | 2 out int | Estimated interest remaining | $ | pmt * n - 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
- Student Loan Balance England Calculator45,308.39 £
- Scottish Student Loan Balance Calculator and Repayment
- See Student Loan Balance: Estimate What You Owe$405.53
- Private Student Loan Past-Due Balance Calculator$855.33
- RD Student Loan Payment Calculator and Guidelines$405.53
- NI Student Loan Balance: How It’s Calculated$405.53