CalcUnit Logo

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 * 100

The 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:

VariableTypeExample value
Home ValueInput (you provide)$450,000
Current Mortgage BalanceInput (you provide)$260,000
Home Equity Loan AmountInput (you provide)$50,000
Interest Rate (APR)Input (you provide)8 %
Loan TermInput (you provide)15
Monthly PaymentResult (calculated)—
Total Cost of the LoanResult (calculated)—
Total Interest PaidResult (calculated)—
Your Current Home EquityResult (calculated)—
Combined LTV After This LoanResult (calculated)—
Max Loan at 80% CLTVResult (calculated)—
Max Loan at 85% CLTVResult (calculated)—
Max Loan at 90% CLTVResult (calculated)—

Step-by-Step Method

  1. 1Write down the values you know: Home Value, Current Mortgage Balance, Home Equity Loan Amount, Interest Rate (APR), Loan Term.
  2. 2Substitute your known values into the formula: monthlyPayment = loanAmount * (APR / 1200) / (1 - (1 + APR /.
  3. 3Work through the arithmetic in the standard order of operations — parentheses first, then exponents, then multiplication and division, then addition and subtraction.
  4. 4Check that your result carries the correct unit and falls in a reasonable range for the problem.
  5. 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 ValueMonthly PaymentTotal Cost of the LoanTotal Interest PaidYour Current Home EquityCombined LTV After This LoanMax Loan at 80% CLTVMax Loan at 85% CLTVMax Loan at 90% CLTV
$50,000477.8386008.6936008.6921111.00157.7811111.0013611.0016111.00
$200,000477.8386008.6936008.6984444.0082.7844444.0054444.0064444.00
$300,000477.8386008.6936008.69126667.0074.4466667.0081667.0096667.00
$500,000477.8386008.6936008.69211111.0067.78111111.00136111.00161111.00
$600,000477.8386008.6936008.69253333.0066.11133333.00163333.00193333.00
$700,000477.8386008.6936008.69295556.0064.92155556.00190556.00225556.00
$900,000477.8386008.6936008.69380000.0063.33200000.00245000.00290000.00
$1,000,000477.8386008.6936008.69422222.0062.78222222.00272222.00322222.00
$2,000,000477.8386008.6936008.69844444.0060.28444444.00544444.00644444.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

home equity loansecond mortgageCLTVfixed rateequity loan payment

Use the Interactive Calculator

Skip the manual math — get instant results with our free Home Equity Loan calculator.

Open Calculator

Related Calculators