calculate-loan

01 Loan payments

Amortization Schedule for Home Equity Loan

Calculator No. 01-26314 · Updated · Formula and assumptions shown below

Monthly payment $405.53
Total interest
$4,331.67
= Monthly payment × loan term × 12 − loan amount
Loan amount
$20,000
Input
Interest rate (APR)
8 %
Input
You enter
Loan amount ($), Interest rate (APR) (%), Loan term (years)
You get
Monthly payment ($), Total interest ($)
Rounding
2 dp

Estimate for education, not financial advice. The result follows from the numbers you enter and the formula shown. It is not a quote or an offer, and it does not include fees, taxes or insurance unless the calculator asks for them. Ask your lender for the exact figures.

An amortization schedule for a home equity loan shows each monthly payment broken into interest and principal, plus the remaining balance, over the life of the loan. You enter the loan amount, annual interest rate (APR), and term in years, and the calculator below generates the full schedule and totals.

Formula

The monthly payment for a fixed-rate home equity loan is calculated with the standard amortization formula:

M = P × (r × (1 + r)^n) / ((1 + r)^n – 1)

Where:

  • M = monthly payment (in dollars)
  • P = principal loan amount (in dollars)
  • r = monthly interest rate = APR / 12 / 100 (as a decimal)
  • n = total number of monthly payments = years × 12

Each month’s interest is r × (current balance). The rest of the payment goes to principal, reducing the balance. The schedule lists this for every month until the balance reaches zero.

Worked Example

Using the default inputs: loan amount $20,000, APR 8%, term 5 years (60 months).

  1. Monthly rate r = 8 / 1200 = 0.0066667
  2. n = 5 × 12 = 60
  3. Payment = 20000 × (0.0066667 × (1.0066667)^60) / ((1.0066667)^60 – 1)
  4. (1.0066667)^60 ≈ 1.48985
  5. Payment ≈ 20000 × (0.0066667 × 1.48985) / (1.48985 – 1) ≈ 20000 × 0.0099323 / 0.48985 ≈ 405.53

So the monthly payment is $405.53. Over 60 months, total paid = 405.53 × 60 = $24,331.80. Total interest = $24,331.80 – $20,000 = $4,331.80. These match the calculator outputs.

Assumptions

  • Fixed interest rate for the entire term (home equity loans typically have fixed rates, unlike HELOCs).
  • Payments are made at the end of each month.
  • Interest compounds monthly at APR/12.
  • No fees, closing costs, taxes, or insurance are included.

How Home Equity Loan Amortization Works

Unlike a credit line, a home equity loan is a lump sum repaid in equal installments. Early in the schedule, most of each payment goes to interest; later, most goes to principal. This is because interest is calculated on the remaining balance, which is largest at the start. For example, in month 1 of the $20,000 loan, interest is 0.0066667 × 20,000 = $133.33, so principal reduction is $405.53 – $133.33 = $272.20. By month 60, interest is only about $2.70, and principal is $402.83.

The schedule also shows the total interest paid over the life of the loan, which is the cost of borrowing. This is different from a simple-interest loan where you might pay interest only on the outstanding balance each day; the amortization formula assumes a fixed payment that covers all interest plus some principal each month.

How to Read the Schedule

Each row of a full amortization schedule typically includes:

  • Payment number (1 to n)
  • Payment amount (constant)
  • Interest portion (decreases over time)
  • Principal portion (increases over time)
  • Remaining balance (decreases to zero)

The key number to watch is the remaining balance. It tells you how much you still owe at any point, which matters if you sell the house or want to pay off the loan early. The total interest column (sum of all interest portions) is what you actually pay to borrow the money.

Common Mistakes and Misconceptions

A frequent error is confusing APR with the monthly rate. Always divide APR by 12 (and by 100) before using it. Another mistake is ignoring that the payment is rounded to the cent; using an unrounded payment in calculations can cause a small discrepancy in the final balance. Also, some people think that making extra payments automatically reduces the monthly payment—it doesn’t; extra payments reduce the principal and shorten the term, but the scheduled payment stays the same unless you recast the loan.

A common misconception is that a home equity loan is the same as a home equity line of credit (HELOC). A HELOC typically has a variable rate and interest-only payments during a draw period; a home equity loan is fixed and fully amortizing from day one. This calculator is for the fixed-rate loan.

How to Choose a Term

Shorter terms (e.g., 5 years) have higher monthly payments but much lower total interest. Longer terms (e.g., 15 or 20 years) have lower monthly payments but you pay significantly more interest over time. For example, a $20,000 loan at 8% for 15 years gives a payment of about $191.13 and total interest of about $14,403.40—more than triple the interest of the 5-year loan. Use the calculator to compare different terms by changing the years input. The right choice depends on your cash flow and how long you plan to stay in the home, but the numbers themselves are neutral.

Costs Beyond the Schedule

The amortization schedule only covers principal and interest. A home equity loan often comes with closing costs, such as appraisal fees, title search, and origination fees, which can be rolled into the loan amount or paid upfront. If rolled in, the principal increases, so the payment and total interest rise. Some lenders also charge prepayment penalties if you pay off the loan early; check your loan documents. Property taxes and homeowners insurance are not included unless you escrow them separately.

Frequently Asked Questions

Can I pay off my home equity loan early?

Yes, most home equity loans allow extra payments or full payoff at any time, but some have prepayment penalties. Check your loan agreement. If you make an extra payment, it reduces the principal, which shortens the term and lowers total interest, but your scheduled monthly payment stays the same.

What is the difference between a home equity loan and a HELOC?

A home equity loan gives you a lump sum with a fixed rate and fixed monthly payments, amortized over a set term. A HELOC is a revolving line of credit with a variable rate, often interest-only payments during a draw period. This calculator is for the fixed-rate loan.

How is the monthly payment calculated?

The payment is calculated using the standard amortization formula shown above, which ensures that the present value of all payments equals the loan amount at the given interest rate. The calculator does this for you.

What happens if I miss a payment?

Missing a payment can trigger late fees and may lead to default, which could result in foreclosure because the loan is secured by your home. The amortization schedule assumes on-time payments; late payments can change the actual interest accrued.

Does the schedule change if interest rates change?

No, for a fixed-rate home equity loan the schedule is set at closing. If you have a variable-rate loan (rare for home equity loans), the payment would change when the rate changes, and the schedule would need to be recalculated.

This result is an estimate based on the inputs; your lender’s disclosure provides the exact figures for your loan.

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
out pmt | Monthly payment | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2
out int | Total interest | $ | pmt * yrs * 12 - p | 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

The whole Loan payments section →