calculate-loan

01 Loan payments

Home Equity Calculator Payment Schedule Explained

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

Monthly payment $405.53
Total interest
$4,331.80
= 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.

A home equity calculator payment schedule estimates the monthly principal-and-interest payment on a fixed-rate home equity loan and shows how the balance and interest change over time. Enter the loan amount, annual percentage rate (APR), and term to calculate the payment and total interest; the schedule itself can be generated by applying the monthly balance formula below.

Formula

The calculator uses the standard fixed-payment amortization formula. It assumes the same payment is made once each month and that interest accrues at a monthly rate derived from the APR.

  • Monthly rate, r = APR ÷ 1,200, expressed as a decimal.
  • Number of payments, n = term in years × 12.
  • Monthly payment, M = P × r ÷ [1 − (1 + r)−n], rounded to the nearest cent.
  • Total interest = M × n − P, using the rounded monthly payment.

Here, P is the amount borrowed in dollars, r is the monthly interest rate, n is the number of monthly payments, and M is the monthly principal-and-interest payment in dollars. Rounding the payment to cents before calculating total interest reflects the repeated payment amount shown by this estimate.

Worked Example

Using the calculator’s default inputs—$20,000 borrowed, an 8% APR, and a five-year term:

  1. Convert the annual rate to a monthly decimal: 8 ÷ 1,200 = 0.0066667.
  2. Find the number of payments: 5 × 12 = 60.
  3. Substitute into the payment formula: $20,000 × 0.0066667 ÷ [1 − (1.0066667)−60] = $405.53 per month, rounded to cents.
  4. Calculate total interest using that rounded payment: $405.53 × 60 − $20,000 = $4,331.80.

The payment is an estimate of principal and interest, not necessarily the full amount due to the lender. Actual payment dates and rounding methods can change the final figures slightly.

Assumptions

  • The interest rate stays fixed for the full term.
  • Payments are made monthly, with the first payment one month after the loan begins.
  • Interest is calculated monthly using APR divided by 12.
  • Fees, taxes, insurance, PMI, escrow, and any lender-specific charges are not included.

How to Read a Home Equity Payment Schedule

A payment schedule, also called an amortization schedule, breaks each monthly payment into interest and principal. In the early months, interest is calculated on a larger outstanding balance, so a greater share of the payment generally goes to interest. As principal is repaid, the balance falls and the interest portion of later payments declines.

For each period, the basic schedule calculations are:

  • Interest for the month = beginning balance × monthly rate.
  • Principal repaid = monthly payment − interest for the month.
  • Ending balance = beginning balance − principal repaid.

For example, with the defaults, first-month interest is approximately $20,000 × 0.0066667 = $133.33. From the $405.53 payment, about $272.20 reduces principal, leaving an estimated balance of $19,727.80. Small differences can arise from rounding each line of a schedule.

Home Equity Loan Versus HELOC

This calculator models a home equity loan with a single amount borrowed, a fixed rate, and equal monthly payments. A home equity line of credit (HELOC) works differently: it is a revolving credit line, and its balance can change as money is drawn or repaid. Rates may be variable, and payment calculations can depend on the line’s terms and current balance.

As a result, the fixed-payment schedule here cannot fully represent a HELOC. To estimate a HELOC payment, the borrower would need the amount currently drawn, applicable rate, repayment rules, and other terms from the lender. Do not treat the calculator’s output as a quote or as an estimate of an undrawn credit line.

Inputs, Costs, and Common Problems

Enter the amount actually borrowed, not the home’s value or the available equity. The APR should come from the lender’s loan disclosure or estimate; a sample rate is only an illustration. Use the repayment term in years, and check whether the lender’s stated term refers to the same repayment period that you want to model.

  • Confusing equity with the loan amount: Equity is not automatically the amount borrowed. The calculator needs the proposed principal.
  • Leaving out charges: Origination or other charges may affect the amount received or the cost of borrowing, but they are not included here.
  • Assuming the payment is the whole housing cost: The result includes principal and interest only. It does not include property-related costs or other charges.
  • Rounding too early: A schedule that rounds monthly interest and principal separately may differ by a few cents from one that carries extra decimal places.
  • Using a changing rate: A fixed-rate formula does not predict payments when the rate can change.

Borrowing against home equity also uses the home as collateral under the loan’s terms. The calculator only performs payment arithmetic; it does not assess eligibility, collateral risk, or whether a particular amount is appropriate.

Frequently Asked Questions

What does a home equity calculator payment schedule show?
It estimates the monthly principal-and-interest payment and, in a full amortization table, shows each period’s interest, principal repaid, and remaining balance.

How do I calculate a home equity loan payment?
Use the loan amount, monthly rate (APR divided by 1,200), and total number of monthly payments in the fixed-payment formula. This calculator rounds the resulting payment to cents.

Does the payment include taxes or insurance?
No. The estimate covers principal and interest only. Check the lender’s documents and relevant bills for other costs that may apply.

Can I use this schedule for a HELOC?
Not as a complete schedule. A HELOC’s balance and rate may change, so its payment depends on the current draw and the line’s specific terms.

Why might my lender’s payment differ?
The lender may use different rounding, payment dates, fees, or loan terms. Compare the calculator’s assumptions with the lender’s disclosure rather than treating a small difference as an error.

This result is an estimate, and the lender’s disclosure gives the exact figures.

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 | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) | 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 →