Loan Payoff Amount Calculator and Formula

A loan payoff amount calculator estimates the balance needed to repay a fixed-rate loan after a chosen number of monthly payments. Enter the original loan amount, annual percentage rate (APR), loan term, and the number of payments already made to estimate the remaining principal; the lender’s official payoff quote may differ because of payment timing, fees, or accrued interest.

Formula

The calculator first determines the scheduled monthly payment, then estimates the balance remaining after the stated number of payments. It uses the standard amortizing-loan formulas:

• Monthly interest rate: r = APR / 1200.
• Scheduled payment: M = P × r / [1 − (1 + r)⁻ⁿ], rounded to the nearest cent.
• Balance after k payments: B = P × (1 + r)^k − M × [(1 + r)^k − 1] / r.

P is the original principal in dollars; APR is the annual percentage rate in percent per year; r is the monthly rate as a decimal; n is the total scheduled number of monthly payments; k is the number of payments made; M is the rounded monthly payment in dollars; and B is the estimated remaining principal in dollars. The formula assumes regular end-of-month payments and a fixed rate. It estimates principal outstanding, not a dated, lender-issued payoff quote.

Worked Example

Using the calculator’s default inputs—$20,000 principal, 8% APR, five years, and 12 payments made:

1. Convert the APR to a monthly rate: r = 8 / 1200 = 0.0066667.
2. Find the number of scheduled payments: n = 5 × 12 = 60.
3. Calculate the scheduled payment: M = 20,000 × 0.0066667 / [1 − (1.0066667)⁻⁶⁰] ≈ $405.53, rounded to cents.
4. Apply the balance formula after 12 payments: B = 20,000 × (1.0066667)¹² − 405.53 × [(1.0066667)¹² − 1] / 0.0066667 ≈ $16,438.67.

The estimated payoff balance is $16,438.67, with a scheduled payment of $405.53 and 60 payments in the original schedule. The payment is rounded before calculating the balance, as specified in the calculator.

Assumptions

• The interest rate stays fixed for the entire modeled term.
• Payments are equal, made monthly at the end of each period; the entered count represents payments already made.
• Interest accrues monthly using APR divided by 12.
• The estimate excludes payoff fees, late charges, payment-processing timing, taxes, insurance, PMI, and escrow. It also does not account for extra payments, skipped payments, rate changes, or lender-specific rounding.

When to Use a Payoff Calculator

Use this estimate when you want to understand how amortization affects a loan balance, check a statement against a simplified schedule, or prepare questions before requesting a payoff quote. It can also illustrate why the amount owed falls gradually: each regular payment covers interest for that period first, and the remainder reduces principal. Early in a standard amortizing loan, the principal portion may be smaller than it is later, even though the payment stays level.

For the input called “Payments made,” count payments actually credited to the account, not simply the number of months since borrowing. If a payment is pending, late, split, or applied on a different date, the calculator’s estimate may not match the lender’s current balance. Use the original principal and the rate and term that govern the loan, rather than a current statement balance as the original amount.

Payoff Balance Versus Current Balance

A displayed account balance and a payoff amount can be different quantities. The account balance may reflect principal as of a statement date, while a payoff quote is typically calculated for a specified date and may include interest accruing between the last payment and that date, plus any applicable account charges. The precise components and validity period depend on the loan and lender, so ask the lender or servicer for the dated amount and instructions to pay it.

This calculator does not know the next payment date, daily interest method, or any fees. Therefore, do not treat its result as the exact amount to send to close an account. If you need an official figure, request a payoff statement and follow its date and payment instructions; an estimate is useful for planning, but cannot replace that quote.

Common Errors and Limits

• Entering a percentage incorrectly: Enter 8 for an 8% APR, not 0.08. The formula converts the percent to a monthly decimal.
• Using the wrong payment count: The count should be payments credited, not elapsed calendar months. Extra principal payments change the balance from this standard schedule.
• Confusing term with payments made: The term determines all scheduled payments; “Payments made” identifies how far through the schedule the estimate has progressed.
• Assuming APR captures every charge: APR is used here as a fixed periodic rate input. The calculator does not separately model fees or other contract terms.
• Rounding differences: The scheduled payment is rounded to cents, while lenders may use different posting dates and rounding practices. Small differences can build up over time.

The formula is designed for level-payment, fixed-rate amortizing debt. It is not a full account ledger and may be unsuitable for interest-only loans, variable rates, balloon payments, irregular payment schedules, or loans with changing terms. For those situations, a lender’s account history and payoff quote provide details this calculation does not have.

Frequently Asked Questions

How do I calculate a loan payoff amount?
Estimate the scheduled payment from principal, APR, and term, then apply the amortization balance formula after the number of payments made. This gives estimated remaining principal; request a dated lender quote for the exact amount to repay.

Is a payoff amount the same as the loan balance?
Not necessarily. A balance may be stated as of a particular posting date, while a payoff quote can account for interest through a later payoff date and other applicable items.

Does the calculator include interest after my last payment?
No. It estimates the balance immediately after the stated number of regular monthly payments under its monthly-interest assumptions. It does not calculate interest through a separate future payoff date.

Can I use this for a variable-rate loan?
Only as a simplified estimate for a period modeled with one fixed APR. A changing rate alters the amortization schedule, so use the lender’s current figures and request a payoff quote.

Why is my lender’s amount different?
Payment dates, accrued interest, fees, additional principal payments, rate changes, and rounding can make an official figure differ from this estimate. Check the payoff statement for its calculation date and included items.

This calculator provides estimate arithmetic for education, not financial advice; the lender’s disclosure gives the exact figures.

Related

• 30 Year Loan Repayment Calculator: Monthly Payment & Interest
• Loan Calculator Monthly Breakdown: Payment and Interest
• Advanced Loan Payment Calculator: Payments and Interest

in p | 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 | - | 12 | 0 | 600
out bal | Estimated payoff balance | $ | p * (1 + apr / 1200) ^ k - (round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) * ((1 + apr / 1200) ^ k - 1) / (apr / 1200)) | 2
out pmt | Monthly payment | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) | 2
out n | Scheduled payments | - | yrs * 12 | 0