Loan Payoff Calculator: Estimate Your Remaining Balance

A loan payoff calculator estimates the amount still owed after a chosen number of monthly payments on a fixed-rate loan. Enter the original loan amount, annual percentage rate (APR), loan term, and number of payments already made to estimate the remaining balance and total paid so far; the result does not include a lender’s payoff fees or accrued interest after the calculation date.

Formula

The estimated balance after a number of level monthly payments is the original principal grown by monthly interest, minus the accumulated value of the payments made:

B_k = P(1 + r)^k − M × ((1 + r)^k − 1) / r

• B_k is the estimated balance after payment k, in dollars.
• P is the original loan principal, in dollars.
• r is the monthly interest rate, calculated as APR ÷ 1,200. APR is entered as a percentage per year.
• k is the number of payments made, in months.
• M is the monthly payment, in dollars, rounded to the nearest cent.

The payment is calculated from the standard fixed-payment loan formula: M = P × r / (1 − (1 + r)⁻ⁿ), where n is the term in months (years × 12). The calculator uses the rounded monthly payment when estimating the balance, reflecting the fact that payments are made in cents. The extra validation term in the calculator prevents a payment count beyond the full term from producing a misleading balance.

Worked Example

Using the calculator’s defaults: principal $20,000, APR 8%, term 5 years, and 12 payments made.

1. Convert the APR to a monthly rate: 8 ÷ 1,200 = 0.0066667, or about 0.66667% per month.
2. Convert the term to months: 5 × 12 = 60 payments.
3. Calculate and round the monthly payment: $20,000 × 0.0066667 ÷ (1 − (1.0066667)⁻⁶⁰) = $405.53.
4. Calculate the balance after 12 payments: $20,000 × (1.0066667)¹² − $405.53 × ((1.0066667)¹² − 1) ÷ 0.0066667 = approximately $16,464.88.
5. Calculate the amount paid in scheduled payments so far: $405.53 × 12 = $4,866.36.

These are formula-based estimates rounded to cents. Actual loan statements can differ because of payment dates, daily interest, fees, payment allocation, or rounding practices.

Assumptions

• The interest rate stays fixed for the full term.
• Payments are equal, made monthly, and applied at the end of each monthly period.
• Interest accrues monthly at APR divided by 12.
• The estimate excludes fees, taxes, insurance, PMI, escrow, late charges, extra payments, and lender-specific payoff adjustments.

How to Use a Loan Payoff Estimate

Enter the original amount borrowed, not the amount you think remains today. Use the APR stated for the loan as a percentage per year, and enter the original scheduled term in years. Then enter how many regular monthly payments have been made. The number of payments cannot exceed the loan term in months; for a loan that has been paid off early, this calculator is not designed to model the payoff event or its exact date.

For example, if the first payment has been made, enter 1. If no payment has yet been made, enter 0; the balance estimate will be the original principal. Count payments actually credited to the loan, not simply the number of calendar months since borrowing. A skipped, deferred, late, or extra payment can change the balance from the standard schedule.

Use the output as a scheduled-amortization estimate, not as an amount to send to close the account. A lender’s payoff figure is commonly calculated for a particular date and can account for interest accrued since the last payment and other contract-specific amounts. Request an official payoff statement for a real transaction and confirm its valid-through date and payment instructions with the servicer.

Reading the Balance and Total Paid

The first output, estimated balance after payments, is the modelled principal and interest balance immediately after the specified monthly payment. It is not the sum of future payments, and it may not match the lender’s current account balance if the payment history differs from the assumptions.

Monthly payment is the fixed amount implied by the entered principal, APR, and term. Payments made so far multiplies that rounded payment by the number of payments entered. It is not the amount of principal repaid: each scheduled payment generally covers interest for the period and reduces principal by what remains. Early payments therefore may reduce principal by a different amount than later payments under a standard amortization schedule.

Common Differences and Limitations

A frequent misconception is that “loan payoff” always means the remaining balance shown by a calculator. In practice, the phrase can mean either an estimated balance under a payment schedule or a lender-issued figure for paying the debt in full on a specific date. This calculator handles the first meaning only.

• Daily interest: Some loans accrue interest daily rather than using a simple monthly-period model. The elapsed days between payments can affect the amount due.
• Extra or missed payments: Additional principal payments, skipped installments, or payment changes alter the amortization path.
• Variable rates: If the APR changes, one fixed APR cannot accurately reproduce the full payment history.
• Fees and other charges: Fees, past-due amounts, and other contract-specific items are not inputs here.
• Rounding: The calculator rounds the scheduled payment to cents. A lender may round interest or payment allocations differently, creating small differences over time.

For the most accurate comparison with an account, use the lender’s transaction history and current loan terms. If the original loan amount or exact APR is unknown, obtain it from the loan documents or servicer rather than substituting a guess.

Frequently Asked Questions

Is loan payoff the same as remaining balance?
Not always. A calculated remaining balance estimates what is owed under a defined schedule. A payoff quote is a lender’s date-specific amount to settle the account and may include accrued interest or other amounts not represented here.

What information do I need to estimate my loan payoff?
You need the original principal, APR, original loan term, and count of payments made. The estimate assumes those payments were regular and on schedule.

Why is my lender’s balance different from this estimate?
Possible reasons include daily interest, payment dates, extra or missed payments, rate changes, fees, or different rounding. Compare the assumptions and payment history, and ask the servicer to explain the account figure.

Can I use this calculator after making extra payments?
Not accurately. The calculator assumes equal scheduled payments only. Extra principal payments reduce the balance differently, so a payment-by-payment amortization record or servicer balance is needed.

Does this calculate the exact amount to close my loan?
No. Request a dated payoff statement from the servicer for the exact amount and instructions. The result is an estimate, and the lender’s disclosure gives the exact figures.

Related

• Loan Application Letter: What to Include and How It Works
• Loan Application Online? Estimate Monthly Payments
• Loan Application Form: What It Asks and Why

in p | Original loan amount | $ | 20000 | 1 | 100000000
in apr | Interest rate (APR) | % | 8 | 0.01 | 100
in yrs | Loan term | years | 5 | 0.0833 | 50
in k | Payments made | months | 12 | 0 | 600
out bal | Estimated balance after payments | $ | p * (1 + apr / 1200) ^ k - round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) * ((1 + apr / 1200) ^ k - 1) / (apr / 1200) + 0 * sqrt(yrs * 12 - k) | 2
out pmt | Monthly payment | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) | 2
out paid | Payments made so far | $ | pmt * k | 2