calculate-loan

01 Loan payments

How to Calculate a Loan Payoff Date

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

Monthly payments remaining 47 months
Estimated payoff month
2,030
Result, rounded to a whole number
Current loan balance
$20,000
Input
Interest rate (APR)
8 %
Input
You enter
Current loan balance ($), Interest rate (APR) (%), Monthly payment ($), Starting year (years), Starting month
You get
Monthly payments remaining (months), Estimated payoff month
Rounding
0 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.

Estimate when a fixed-rate loan will be paid off by entering its current balance, annual percentage rate (APR), and planned monthly payment. The calculator returns the number of monthly payments remaining and an estimated payoff date, using today as the starting point.

Formula

For a fixed rate and equal monthly payments, calculate the number of payments with n = ceil(round(-ln(1 − r × B / M) / ln(1 + r), 6)), where r = APR / 1200. Here, B is the current principal balance in dollars, M is the monthly payment in dollars, and APR is the annual percentage rate entered as a percentage. The calculator rounds the required payment count up to the next whole month because a partial final month is not a full scheduled payment.

To estimate the calendar month, add n months to the starting month: year = Y + floor((m − 1 + n) / 12), and month = m − 1 + n − 12 × floor((m − 1 + n) / 12), with month numbering adjusted so January is 1. Y and m are the starting year and month. The date output displays the year and month as a number, such as 2027.4 for April 2027. It is a month estimate, not a specific day.

The calculator assumes the payment is made monthly and applies interest at APR divided by 12. It requires a positive APR and a monthly payment large enough to cover the month’s interest; otherwise the balance does not decline under this model. The calculated month count is an estimate based on steady payments, not a lender’s payoff quote.

Worked Example

Using the defaults: balance B = $20,000, APR = 8%, payment M = $500 per month, and starting month November 2026:

  1. Convert APR to a monthly rate: r = 8 / 1200 = 0.0066667, or about 0.66667% per month.
  2. Calculate the unrounded payment count: −ln(1 − 0.0066667 × 20,000 / 500) / ln(1.0066667) ≈ 44.1 months.
  3. Round up to a whole payment: n = 45 monthly payments.
  4. Add 45 months to November 2026. The result is August 2030, displayed by the date formula as 2030.8.

The calculator therefore gives 45 months and an estimated payoff month of August 2030. Actual payment amounts, posting dates, and the lender’s interest calculation can change the final date and amount.

Assumptions

  • The interest rate stays fixed at the entered APR throughout the estimate.
  • Payments are equal, monthly, and made on schedule; the starting month is the month from which payments begin.
  • Interest compounds monthly at APR divided by 12.
  • Fees, taxes, insurance, PMI, escrow, late payments, skipped payments, and extra principal payments are not included.

What You’ll Need

  • Your current principal balance, not the original amount borrowed. Check a recent statement or account record.
  • The loan’s current APR and the regular monthly amount applied to the loan. If your payment includes escrow or insurance, identify the portion that goes toward the debt.
  • The month and year from which you want to count payments. The example starts in November 2026; replace those defaults with your intended starting point.
  • A calculator or spreadsheet is optional. The calculator block performs the formula, but knowing the inputs helps you check whether its assumptions fit your loan.

Step-by-Step

  1. Find the current balance. Use the outstanding principal rather than the original loan amount. If you are asking for an exact payoff amount today, request a payoff quote from the servicer; that figure may include accrued interest or other items that this estimate does not model.
  2. Confirm the APR and payment. Enter the rate as a percentage, such as 8 for 8%, not 0.08. Enter the monthly amount that actually pays down principal and interest. If your monthly bill combines the loan payment with other charges, do not treat the entire bill as principal-and-interest payment.
  3. Set the starting month and year. The calculator adds the number of remaining monthly payments to this point. Use the month when the next scheduled payment cycle begins, rather than the loan’s original start date.
  4. Enter all four inputs and check them. Make sure the balance is current, the APR is annual, the payment is monthly, and the month is from 1 through 12. A decimal or unit error can make the result misleading.
  5. Read the payment count first. The first result is the estimated number of full monthly payments remaining. It rounds upward because a fraction of a payment period still means the balance needs another payment cycle in this simplified calculation.
  6. Read the estimated payoff month. The second result is displayed as year.month: for example, 2030.8 means August 2030. It does not identify the payment due date or guarantee that the loan will be closed on that date.
  7. Compare the estimate with your account. Check your next due date, payment allocation, rate terms, and any planned extra payments with the servicer. For a precise amount to close the loan on a particular day, use a current payoff quote and follow its instructions.

Common Mistakes

  • Using the original loan amount: The payoff calculation starts with the balance still owed, not the amount borrowed at the outset.
  • Mixing up APR and monthly rate: Enter APR as an annual percentage. The formula converts it to a monthly rate by dividing by 1,200.
  • Including unrelated charges in the payment: Escrow, insurance, or fees may not reduce the loan balance. Use the amount applied to principal and interest for this estimate.
  • Assuming the displayed month is an exact date: The calculator estimates a calendar month. Due dates, weekends, posting delays, and lender processing are not represented.
  • Ignoring a variable rate or payment changes: A rate reset, changing payment, missed payment, or additional principal payment can move the actual payoff date.
  • Rounding inputs too early: Use the current figures shown on your account. Rounding the balance, APR, or payment before entering it can shift the estimate by a month.

Tips

  • Use a recent statement and verify whether its balance is principal, a payoff quote, or a total that includes other amounts.
  • Run the estimate again after the balance, payment, or rate changes. Keep a note of the date and figures used so you can compare estimates consistently.
  • If you make extra payments, ask how the servicer applies them. This calculator assumes only the same regular monthly payment and cannot model the timing or allocation of extra amounts.
  • For an adjustable-rate loan, treat this result as a scenario using the APR entered, not a forecast of future rate changes.
  • When planning a final payment, confirm the amount and valid-through date with the servicer rather than paying solely from this estimate.

Troubleshooting

“Cannot compute” or no valid result: Check that the monthly payment exceeds the estimated interest for one month, calculated as balance × APR / 1200. If it does not, the payment is insufficient to reduce principal under this model. Confirm that the payment and rate were entered in the correct units.

The date looks far off: Check whether you entered the current balance rather than the original loan amount and whether the payment is monthly rather than biweekly or annual. Confirm the starting month and year, too.

Your statement shows a different payoff date: The account may use a different interest method, payment schedule, variable rate, or balance. Compare the inputs and assumptions, then ask the servicer how it calculates payoff timing.

The lender’s payoff amount differs: A payoff quote is calculated for a particular date and can reflect accrued interest and account-specific amounts. Request an updated quote if the date changes; this calculator is not a substitute for it.

Frequently Asked Questions

Is the payoff date the same as the last payment due date?
The estimate gives a payoff month based on scheduled monthly payments. The exact final due date and payment amount depend on the loan terms and servicing details.

Can I use this for a variable-rate loan?
You can estimate a scenario using the current APR, but the result assumes that rate remains unchanged. Future rate changes can alter the number of payments.

What if I pay extra each month?
This calculator does not account for extra payments. Extra principal can change the payoff timing, but the impact depends on when payments are made and how the servicer applies them.

Why does it round the number of payments up?
The formula estimates the time needed to bring the balance to zero, then rounds up to a whole monthly payment period. The lender may require a smaller final payment rather than another full regular payment.

Does the estimate include fees or a payoff quote?
No. It models principal and interest with steady monthly payments and excludes fees and other account-specific amounts. Request a dated payoff quote from the servicer for an exact figure.

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

Related

Formula used
in bal | Current loan balance | $ | 20000 | 0.01 | 100000000
in apr | Interest rate (APR) | % | 8 | 0.01 | 100
in pmt | Monthly payment | $ | 500 | 0.01 | 100000000
in yr | Starting year | years | 2026 | 1 | 9999
in mon | Starting month | - | 11 | 1 | 12
out n | Monthly payments remaining | months | ceil(round(-ln(1 - (apr / 1200) * bal / pmt) / ln(1 + apr / 1200), 6)) | 0
out date | Estimated payoff month | - | yr + floor((mon - 1 + n) / 12) + (mon - 1 + n - 12 * floor((mon - 1 + n) / 12)) / 100 | 0

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 →