Home Equity Loan Calculator: Fixed Payment & CLTV

Home equity loan calculator: fixed payment and CLTV

This calculator estimates fixed principal-and-interest on a home equity loan lump sum, checks combined loan-to-value (CLTV), and computes effective APR after closing costs. Results are illustrative, not a lender quote.

What this calculator does

The widget estimates fixed monthly principal-and-interest on a home equity loan (second-mortgage lump sum), checks combined loan-to-value (CLTV) against a 70% safety guide and 80% lender-style cap, computes an effective APR when closing costs are paid from proceeds, and compares total interest to a 22% credit-card scenario on the same balance and term. Section 03 includes an expandable amortization schedule with CSV export. It does not model taxes, insurance escrows, prepayment penalties, or state-specific fees.

Monthly payment:

$P = L \times \frac{r\,(1+r)^{n}}{(1+r)^{n} - 1}$
CLTV:

$\text{CLTV} = \frac{\text{First Mortgage} + \text{Equity Loan}}{\text{Home Value}} \times 100$

How the math works

With default inputs, the home is valued at $500,000, the remaining first mortgage is $300,000, and the desired loan is $50,000. Combined loan-to-value (CLTV) adds both liens and divides by home value: ($300,000 + $50,000) ÷ $500,000 = 70%, which sits at the widget’s conservative guide line on the results bar.

The fixed annual rate defaults to 7.2% over 10 years (120 months). Standard amortization converts that to a level monthly payment of about $586. Total interest over the term is total payments minus the $50,000 principal, about $20,285 at defaults.

Closing costs default to 3% of the loan ($1,500), treated as paid from proceeds, so net cash received is $48,500. The widget solves for an effective APR where the present value of the $586 monthly payments equals that net amount, about 7.89%. The built-in card comparison runs the same $50,000 balance at 22% APR for 10 years; total interest savings on the results card is about $54,000.

Limits of the model

Real home equity loans vary by lender credit overlays, appraisal method, prepayment penalties, and whether you pay closing costs in cash instead of from proceeds. This calculator holds the rate fixed for the full term, does not model tax deductibility or debt-to-income approval, and compares to a simplified 22% card illustration rather than your actual cards. Use section 03 amortization and the CLTV bar before treating the payment as long-term affordable.

Home Equity Loan Calculator FAQ

How is a home equity loan different from a HELOC?

A home equity loan is a fixed-rate installment loan: you receive a lump sum and pay principal plus interest from month one. A home equity line of credit (HELOC) is a revolving line, usually variable, with an interest-only draw period before amortizing repayment. This widget models the fixed lump-sum path with one payment schedule, not draw-period interest-only phases.

What is CLTV and why does 80% matter?

Combined loan-to-value (CLTV) is (first mortgage + equity loan) ÷ home value. The widget computes it from section 01 Equity and shows a Combined LTV bar on the results card with markers at 70% and 80%. Default scenario: $500,000 home, $300,000 mortgage, $50,000 loan → CLTV 70%. Above 80% triggers a rejection warning under the inputs.

How do closing costs affect the effective APR?

Section 02 Loan terms sets closing costs (default 3% of the loan, or switch to dollars). The widget treats fees as paid from proceeds, so net cash is loan amount minus closing costs. The results card shows APR (net proceeds), which solves for the rate where the present value of level payments equals that net amount. At defaults, note rate 7.2% rises to about 7.89% effective APR.

How does this compare to credit card debt?

The results card includes Interest savings vs card, comparing total interest on your loan to a built-in 22% APR card illustration on the same balance and term. At defaults ($50,000, 10 years, 7.2%), home equity loan interest is about $20,285 versus about $74,000 on the card scenario, roughly $54,000 difference. The trade-off is collateral: the loan is secured by your home.

Why pay principal from day one?

Unlike a HELOC draw period, every payment here retires principal. After five years on the default $50,000 / 7.2% / 10-year loan, remaining balance is about $29,400, and the results card shows 5-yr equity near $170,600 (home value minus both liens). Fixed rate also removes payment surprise if market rates rise later.

Is home equity loan interest tax-deductible?

Only when proceeds pay for qualifying home improvements under current mortgage-interest rules. This calculator does not model tax treatment; it projects payments, CLTV, and interest cost only. Keep receipts and confirm with a tax professional. Results here are not tax advice.

What does APR (net proceeds) on the results card mean?

The signed Interest rate (%) is the note rate used in amortization. APR (net proceeds) adjusts for closing costs financed out of the lump sum: the widget finds the annual rate where fixed monthly payments, discounted back, equal what you actually receive after fees. Compare it to the note rate to see how much upfront costs lift the true borrowing cost.

What does the strategy chip on the results card mean?

The dark Fixed-rate equity card shows a chip such as Equity heavy (CLTV ≤ 70%), High leverage (CLTV above 75%), Debt consolidation fit (interest savings vs the 22% card), or Lender reject (CLTV) (above 80%). At defaults (70% CLTV with positive card savings), the chip reads Equity heavy.

Home Equity Loan Calculator

Equity

Loan terms

Amortization schedule

How to use this calculator

Reading your fixed payment and CLTV

Example: $500K home, $300K mortgage, $50K loan

Combined LTV bar on the results card

APR (net proceeds) vs note rate

Section 03 amortization schedule