This calculator works out the remaining balance on a home equity loan after a certain number of payments, or the payoff amount needed to settle the loan early. You enter the original loan amount, the annual interest rate (APR), the loan term, and the number of payments already made, and you get the current outstanding balance plus the total interest paid to date.
Formula
The remaining balance on a fixed-rate amortizing loan after k payments is:
B = P × (1 + r)^k − PMT × ((1 + r)^k − 1) / r
Where:
- P = original loan amount (in $)
- r = monthly interest rate = APR / 1200 (as a decimal, e.g., 8% APR → 0.006667)
- k = number of payments already made
- PMT = the fixed monthly payment = P × r / (1 − (1 + r)^(−n)), where n = loan term in months
The monthly payment is rounded to the cent in practice, and the balance formula uses that rounded payment. The calculator above does the same, so the result matches what a lender would show on a statement.
Worked Example
Using the default inputs: loan amount $20,000, APR 8%, term 5 years, and 12 payments made.
- Convert APR to monthly rate: r = 8 / 1200 = 0.0066667
- Total months: n = 5 × 12 = 60
- Monthly payment: PMT = 20000 × 0.0066667 / (1 − (1.0066667)^−60) = 20000 × 0.0066667 / (1 − 0.67121) = 20000 × 0.0066667 / 0.32879 = 20000 × 0.020276 = $405.53 (rounded to the cent)
- Balance after 12 payments: B = 20000 × (1.0066667)^12 − 405.53 × ((1.0066667)^12 − 1) / 0.0066667
- Compute (1.0066667)^12 ≈ 1.082999
- B = 20000 × 1.082999 − 405.53 × (0.082999) / 0.0066667 = 21659.98 − 405.53 × 12.4499 = 21659.98 − 5048.72 = $16,611.26
The calculator shows a remaining balance of $16,611.26, matching the step-by-step result.
Assumptions
- Fixed interest rate for the entire loan term.
- Payments are made monthly, at the end of each month.
- Interest is compounded monthly at APR / 12.
- The monthly payment is constant and rounded to the cent.
- No extra fees, prepayment penalties, taxes, or insurance are included.
How a Home Equity Loan Balance Works
A home equity loan (often called a second mortgage) gives you a lump sum that you repay in equal monthly installments over a fixed term, typically 5 to 30 years. Each payment covers the interest that accrued since the last payment plus a portion of the principal. Early in the term, interest makes up most of the payment; as the balance declines, more of each payment goes toward principal. The remaining balance at any point is simply the original principal plus accrued interest minus the sum of principal portions of payments made so far. The formula above is the standard way lenders calculate it.
Knowing your current balance is useful for several reasons: you might be considering a refinance, planning to sell the home, or wanting to pay off the loan early. The balance shown on your monthly statement is the same number this calculator produces, assuming you have made all payments on time and no fees were added.
Payoff Amount vs. Remaining Balance
The remaining balance is not always the same as the payoff amount. When you request a payoff quote, the lender calculates the exact amount needed to close the loan on a specific future date, usually within 10 to 30 days. That payoff figure includes the remaining principal, interest accrued up to the payoff date, and any fees such as a statement fee or prepayment penalty (if your loan has one). Because interest accrues daily between the last payment and the payoff date, the payoff amount is slightly higher than the principal balance shown on your last statement. The difference is usually a few dollars to a few hundred, depending on the rate and how many days have passed.
To get an exact payoff figure, you must contact your lender and request a payoff statement. The calculator gives you the principal balance, which is the starting point for that quote.
How to Use the Calculator for Early Payoff
If you are thinking about paying off your home equity loan early, the calculator helps you see how much principal remains. For example, with the default $20,000 loan at 8% for 5 years, after 12 payments you owe about $16,611. If you want to pay it off at that point, you would need that amount plus accrued interest for the days since your last payment. You can also simulate different scenarios:
- Enter a different number of payments made to see the balance at any point in the term.
- Compare the balance at 12 months vs. 24 months to see how much faster the principal drops.
- Use the total interest paid output to understand how much interest you have already paid.
This can help you decide whether an early payoff makes sense for your cash flow, but remember that the calculator does not account for prepayment penalties or tax implications. Check your loan documents or ask your lender about any fees for paying off early.
Common Mistakes When Estimating Balance
One common mistake is using the annual rate instead of the monthly rate in the formula. Always divide the APR by 12 (and by 100 to convert percentage to decimal). Another is forgetting to round the monthly payment to the cent before using it in the balance formula. Lenders round payments, so using an unrounded payment can produce a balance that is off by a few cents. Also, if you have made extra payments or missed a payment, the balance will differ from the formula’s result because the payment schedule is no longer regular. The calculator assumes level payments with no prepayments.
Finally, remember that the balance is the principal remaining, not the total amount you will pay if you continue the loan. The total interest paid output shows how much interest you have already paid, which can be surprising for long-term loans.
Comparing Home Equity Loans to Other Options
Home equity loans are one of several ways to borrow against your home’s value. A home equity line of credit (HELOC) works differently: it gives you a revolving credit line with variable payments, and the balance can go up as you borrow. In contrast, a home equity loan has a fixed payment and a fixed balance that decreases over time. A cash-out refinance replaces your entire mortgage with a new, larger loan, and you receive the difference in cash. Each option has different costs, interest rates, and repayment structures. This calculator is specific to fixed-rate, amortizing home equity loans; it does not apply to HELOCs or adjustable-rate loans.
When comparing, you need to know the actual APR, fees, and terms offered by lenders. The calculator can help you estimate the balance for any fixed-rate loan, but it does not compare costs across products.
Safety and Accuracy Notes
This calculator is for educational estimation only. It does not include fees, prepayment penalties, or daily interest accrual that a lender’s payoff statement would include. To get the exact payoff amount, always request a written payoff quote from your lender. The result is an estimate, and the lender’s disclosure gives the exact figures.
Frequently Asked Questions
How do I find out my current home equity loan balance?
Your monthly statement shows the principal balance as of the statement date. You can also log into your lender’s online portal or call customer service. For a payoff amount, request a payoff statement, which gives the exact amount needed to close the loan on a specific date.
What is the difference between principal balance and payoff amount?
The principal balance is the remaining amount you borrowed, not including interest that has accrued since your last payment. The payoff amount includes that accrued interest plus any fees, so it is typically slightly higher. The payoff amount is what you actually need to pay to close the loan.
Can I pay off my home equity loan early without a penalty?
It depends on your loan agreement. Some home equity loans have prepayment penalties, especially in the first few years. Check your loan documents or ask your lender. If there is a penalty, it will be added to the payoff amount.
How does making extra payments affect my balance?
Extra payments reduce the principal faster, which means you pay less interest over time and the loan is paid off sooner. However, the exact effect depends on whether the lender applies the extra payment to principal immediately or holds it as a prepayment of future installments. Ask your lender how they apply extra payments.
Why does my balance seem to go down slowly at first?
In the early years of an amortizing loan, most of your monthly payment goes toward interest, so the principal decreases slowly. As the balance shrinks, the interest portion gets smaller and more of your payment goes to principal. This is normal for fixed-rate loans.
Related
Formula used
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 | Remaining balance | $ | p * (1 + apr / 1200) ^ k - (p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12))) * ((1 + apr / 1200) ^ k - 1) / (apr / 1200) | 2 out paid | Total paid so far | $ | (p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12))) * k | 2 out int | Interest paid so far | $ | (p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12))) * k - (p * k / (yrs * 12)) | 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
- JS Bank Credit Card: Features & How to Apply$405.53
- JD Gift Card Balance: How to Check It$60.00
- JD Bank Credit Card: How It Works & What to Know$405.53
- In-N-Out Gift Card Balance: Check & Use Guide$30.00
- JCPenney Credit Card Balance: How to Check It27 months
- Houston Metro Q Card Balance: Check & Add Funds$35.00