How to Calculate Home Equity Loan
Calculate the monthly payment, total interest and total cost of a fixed-rate home equity loan, your combined LTV after the loan, and the most you could borrow at 80%, 85% and 90% CLTV caps.
The Formula
monthlyPayment = loanAmount * (APR / 1200) / (1 - (1 + APR / 1200) ^ (-termYears * 12)); combinedLTV = (mortgageBalance + loanAmount) / homeValue * 100The home equity loan formula uses the mathematical relationship: monthlyPayment = loanAmount * (APR / 1200) / (1 - (1 + APR / 1200) ^ (-termYears * 12)); combinedLTV = (mortgageBalance . Each variable in the formula represents a measurable quantity that affects the final result.
What Each Variable Means
Every value in the home equity loan formula, what it measures, and the value used in the worked example on this page:
| Variable | Type | Example value |
|---|---|---|
| Home Value | Input (you provide) | $450,000 |
| Current Mortgage Balance | Input (you provide) | $260,000 |
| Home Equity Loan Amount | Input (you provide) | $50,000 |
| Interest Rate (APR) | Input (you provide) | 8 % |
| Loan Term | Input (you provide) | 15 |
| Monthly Payment | Result (calculated) | — |
| Total Cost of the Loan | Result (calculated) | — |
| Total Interest Paid | Result (calculated) | — |
| Your Current Home Equity | Result (calculated) | — |
| Combined LTV After This Loan | Result (calculated) | — |
| Max Loan at 80% CLTV | Result (calculated) | — |
| Max Loan at 85% CLTV | Result (calculated) | — |
| Max Loan at 90% CLTV | Result (calculated) | — |
Step-by-Step Method
- 1Write down the values you know: Home Value, Current Mortgage Balance, Home Equity Loan Amount, Interest Rate (APR), Loan Term.
- 2Substitute your known values into the formula: monthlyPayment = loanAmount * (APR / 1200) / (1 - (1 + APR /.
- 3Work through the arithmetic in the standard order of operations — parentheses first, then exponents, then multiplication and division, then addition and subtraction.
- 4Check that your result carries the correct unit and falls in a reasonable range for the problem.
- 5Verify your answer with the interactive Home Equity Loan Calculator — it solves the same formula instantly.
Worked Example
Take a concrete case: home value = $200,000, with the other inputs at the typical values from the variables table above. Substituting into the formula gives monthly payment = 477.83, total cost of the loan = 86008.69, total interest paid = 36008.69, your current home equity = 84444.00, combined ltv after this loan = 82.78, max loan at 80% cltv = 44444.00, max loan at 85% cltv = 54444.00, max loan at 90% cltv = 64444.00. These numbers are solved by the same engine that powers the Home Equity Loan calculator, so you can reproduce them exactly by entering the same inputs there.
| Home Value | Monthly Payment | Total Cost of the Loan | Total Interest Paid | Your Current Home Equity | Combined LTV After This Loan | Max Loan at 80% CLTV | Max Loan at 85% CLTV | Max Loan at 90% CLTV |
|---|---|---|---|---|---|---|---|---|
| $50,000 | 477.83 | 86008.69 | 36008.69 | 21111.00 | 157.78 | 11111.00 | 13611.00 | 16111.00 |
| $200,000 | 477.83 | 86008.69 | 36008.69 | 84444.00 | 82.78 | 44444.00 | 54444.00 | 64444.00 |
| $300,000 | 477.83 | 86008.69 | 36008.69 | 126667.00 | 74.44 | 66667.00 | 81667.00 | 96667.00 |
| $500,000 | 477.83 | 86008.69 | 36008.69 | 211111.00 | 67.78 | 111111.00 | 136111.00 | 161111.00 |
| $600,000 | 477.83 | 86008.69 | 36008.69 | 253333.00 | 66.11 | 133333.00 | 163333.00 | 193333.00 |
| $700,000 | 477.83 | 86008.69 | 36008.69 | 295556.00 | 64.92 | 155556.00 | 190556.00 | 225556.00 |
| $900,000 | 477.83 | 86008.69 | 36008.69 | 380000.00 | 63.33 | 200000.00 | 245000.00 | 290000.00 |
| $1,000,000 | 477.83 | 86008.69 | 36008.69 | 422222.00 | 62.78 | 222222.00 | 272222.00 | 322222.00 |
| $2,000,000 | 477.83 | 86008.69 | 36008.69 | 844444.00 | 60.28 | 444444.00 | 544444.00 | 644444.00 |
How each result changes as home value changes, holding the other inputs constant.
Practice Problems
1. Standard loan — $50,000 at 8% for 15 years: You enter Home Value $450,000, Current Mortgage Balance $260,000, Home Equity Loan Amount $50,000, Interest Rate (APR) 8%, Loan Term 15 years — what does the calculator return?
Answer: The calculator returns Monthly Payment $477.83, Total Cost of the Loan $86,008.69, Total Interest Paid $36,008.69, Your Current Home Equity $190,000.00, Combined LTV After This Loan 68.89%, and 3 more more results for Home Value $450,000, Current Mortgage Balance $260,000, Home Equity Loan Amount $50,000, Interest Rate (APR) 8%, Loan Term 15 years.
2. With Home Value $750,000, Current Mortgage Balance $300,000, Home Equity Loan Amount $100,000, Interest Rate (APR) 7.25%, Loan Term 20 years, what are the results?
Answer: With Home Value $750,000, Current Mortgage Balance $300,000, Home Equity Loan Amount $100,000, Interest Rate (APR) 7.25%, Loan Term 20 years, the results are Monthly Payment $790.38, Total Cost of the Loan $189,690.24, Total Interest Paid $89,690.24, Your Current Home Equity $450,000.00, Combined LTV After This Loan 53.33%, and 3 more more results.
Frequently Asked Questions
What is the formula for home equity loan?
The formula is: monthlyPayment = loanAmount * (APR / 1200) / (1 - (1 + APR / 1200) ^ (-termYears * 12)); combinedLTV = (mortgageBalance + loanAmount) / homeValue * 100. Calculate the monthly payment, total interest and total cost of a fixed-rate home equity loan, your combined LTV after the loan, and the most you could borrow at 80%, 85% and 90% CLTV caps.
What values do I need to calculate home equity loan?
You need home value, current mortgage balance, home equity loan amount, interest rate (apr), loan term. The calculator produces monthly payment, total cost of the loan, total interest paid, your current home equity, combined ltv after this loan, max loan at 80% cltv, max loan at 85% cltv, max loan at 90% cltv from those inputs.
What is the home equity loan when home value is $200,000?
With home value = $200,000, the result is monthly payment = 477.83, total cost of the loan = 86008.69, total interest paid = 36008.69, your current home equity = 84444.00, combined ltv after this loan = 82.78, max loan at 80% cltv = 44444.00, max loan at 85% cltv = 54444.00, max loan at 90% cltv = 64444.00. This is worked through in full in the example on this page.
Related Topics
Use the Interactive Calculator
Skip the manual math — get instant results with our free Home Equity Loan calculator.
