Home Equity Loan Payoff Calculator: Estimate Your Balance

A home equity loan payoff calculator estimates the amount still owed after a specified number of monthly payments, using the original loan amount, APR, term, and payments made. Enter those figures to see an estimated remaining balance, scheduled monthly payment, and total interest over the full term.

Formula

The calculator uses a fixed-rate, fully amortizing loan model. First it calculates the monthly payment, then estimates the principal balance after the specified number of payments:

• Monthly rate: r = APR ÷ 1,200, where APR is entered as a percentage per year.
• Number of scheduled payments: n = 12 × term in years.
• Monthly payment: M = round[P × r ÷ (1 − (1 + r)⁻ⁿ), 2].
• Balance after k payments: B = P × (1 + r)^k − M × [(1 + r)^k − 1] ÷ r.
• Total scheduled interest: I = M × n − P.

P is the original loan principal in dollars; r is the monthly interest rate as a decimal; M is the monthly payment in dollars rounded to cents; n is the total scheduled payment count; k is the number of payments made; B is the estimated remaining principal in dollars; and I is total interest paid across the scheduled term, assuming every payment is made as calculated. The payment count input is limited to 600, matching the calculator’s maximum 50-year term.

Worked Example

Using the calculator’s defaults—an original loan of $20,000, an 8% APR, a 5-year term, and 12 payments made—the calculation is:

1. Monthly rate: 8 ÷ 1,200 = 0.0066667.
2. Scheduled payment count: 5 × 12 = 60.
3. Monthly payment: $20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰] = $405.53, rounded to the nearest cent.
4. Balance after 12 payments: $20,000 × (1.0066667)¹² − $405.53 × [(1.0066667)¹² − 1] ÷ 0.0066667 = approximately $16,583.43.
5. Total scheduled interest: $405.53 × 60 − $20,000 = $4,331.80.

The remaining balance is not simply the original loan minus 12 payments. Each payment covers interest accrued for the period first, with the rest reducing principal. Therefore, early payments on an amortizing loan generally reduce principal by less than the full payment amount.

Assumptions

• The APR and payment amount remain fixed for the full loan term.
• Payments are made monthly, on schedule, with the first payment one month after the loan is advanced.
• Interest compounds monthly at APR ÷ 12, as a simplified standard amortization assumption.
• The model excludes fees, taxes, insurance, and escrow, as well as late charges, missed payments, payment changes, and extra principal payments.

Using a Payoff Estimate

Use the calculator to understand the scheduled principal balance at a point in the repayment timeline. Enter the original amount borrowed—not the home’s current value—and use the loan’s APR and original repayment term. Payments made means the number of regular monthly installments already completed. If you have not made a payment, enter zero.

For an estimate based on a current statement, the original loan amount and payment count may not be enough. A statement can show a more current principal balance, while a lender’s payoff quote can include interest accrued through a particular date and other amounts due under the loan. The calculator’s balance is a modeled principal balance, not a formal payoff quote or a guaranteed amount to close the account.

For example, if a loan started at $20,000 but you made extra principal payments, the calculator will generally overstate the remaining balance because it assumes only the scheduled payment. If you missed payments or the rate changed, the estimate may differ in either direction. For a date-specific figure, request the applicable payoff amount directly from the lender and check the date through which it is valid.

How to Read the Results

Estimated balance after payments is the modeled principal remaining immediately after the payment count entered. Scheduled monthly payment is the level payment required by the formula for the entered principal, APR, and term. Total interest over full term assumes all scheduled payments are made and uses the calculator’s cent-rounded payment, so it reflects the full modeled schedule rather than interest accrued only up to the current balance date.

The balance formula can produce small differences from a lender’s amortization schedule because lenders may calculate interest using their contract’s exact conventions and handle rounding differently. The output should be treated as an estimate, not as an amount to send to satisfy a debt.

Common Errors and Limits

• Entering a monthly rate as APR: Enter the annual percentage rate as a percentage, such as 8 for 8%. The calculator divides it by 12 and converts percent to a decimal.
• Using home value as the loan amount: The principal input is the amount borrowed, not the property’s value or available equity.
• Counting payments inaccurately: Enter completed monthly payments, not elapsed years or the number of payments remaining. A partial month is not represented.
• Ignoring extra payments or account changes: The formula assumes fixed monthly payments and rate, with no additional principal payments, skipped installments, or fees.

A home equity loan is generally structured with a lump-sum advance and scheduled repayment, but the calculator does not determine a loan’s actual terms. It also does not calculate home equity, an interest-only period, a variable-rate schedule, or a date-specific payoff figure. Use the loan documents or lender statement to confirm the principal, APR, payment schedule, and any account-specific adjustments.

Frequently Asked Questions

How do I calculate the payoff balance on a home equity loan?
For a fixed-rate loan with regular monthly payments, calculate the scheduled payment from the principal, monthly rate, and total term, then apply the amortization balance formula for the number of payments made. This calculator performs those steps, but it does not generate a lender’s official payoff quote.

Is the calculator’s balance the same as a payoff amount?
No. The result estimates remaining principal after the entered number of payments. A lender’s payoff amount may account for interest through a requested date and other amounts applicable to the account.

Can I use this calculator if I paid extra each month?
You can use it for a rough comparison, but its result assumes only the scheduled payment. Extra principal payments usually reduce the balance faster, so the calculated balance may be higher than the actual one.

Does this calculator work for a home equity line of credit?
Not reliably. A line of credit can have changing balances, variable rates, and different draw and repayment phases. This calculator models a single fixed-rate loan with equal monthly payments.

What information do I need for a more accurate estimate?
Use the original amount borrowed, APR, original term, and exact count of completed payments. For the current account balance or payoff amount on a specific date, consult the lender’s statement or request its payoff figure.

This result is an estimate for educational purposes, and the lender’s disclosure gives the exact figures.

Related

• Mortgage Calculator With Escrow: Payment With Tax and Insurance
• Mortgage Loan Amount Calculator: The Loan a Monthly Payment Repays
• Home Equity Loan Calculator: Amount Up to a CLTV Limit and Payment

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 | - | 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) | 2
out pmt | Scheduled monthly payment | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) | 2
out int | Total interest over full term | $ | pmt * yrs * 12 - p | 2