calculate-loan

01 Loan payments

Home Equity Amortization Schedule Calculator

Calculator No. 01-15823 · 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.

A home equity amortization schedule shows how each fixed monthly payment is divided between interest and principal, and how the loan balance declines over time. Enter the amount borrowed, annual APR, and term to calculate the monthly payment, total interest, and total of scheduled payments; this calculator also uses the payment to illustrate the schedule’s standard math.

Formula

The schedule is built by applying interest to the outstanding principal each month, then using the rest of that month’s payment to reduce the balance. For a fixed-rate loan with equal monthly payments, the level-payment formula is:

Payment = P × r ÷ [1 − (1 + r)−n]

  • P is the amount borrowed, in dollars.
  • r is the monthly interest rate, calculated as APR ÷ 1,200. APR is entered as a percentage per year.
  • n is the number of monthly payments, calculated as years × 12.
  • Payment is the calculated monthly principal-and-interest amount, in dollars.

The calculator displays the payment rounded to cents and estimates total interest as the displayed payment multiplied by the number of months, less the original principal. Because the payment output is rounded for display, this total is an estimate; an actual lender schedule may account for unrounded calculations, payment dates, and adjustments.

Worked Example

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

  1. Convert the APR to a monthly rate: 8 ÷ 1,200 = 0.0066667, or about 0.66667% per month.
  2. Convert the term to payments: 5 × 12 = 60 monthly payments.
  3. Apply the payment formula: 20,000 × 0.0066667 ÷ [1 − (1 + 0.0066667)−60] ≈ $405.53 per month.
  4. Estimate total interest using the displayed payment: $405.53 × 60 − $20,000 = $4,331.80.

These outputs are estimates based on the formula and rounded monthly payment. A lender’s payment schedule can differ slightly if it uses more precise payment calculations or has additional charges.

Assumptions

  • The interest rate stays fixed for the entire modeled term.
  • Payments are equal monthly payments made at the end of each monthly period.
  • Interest is modeled monthly at APR divided by 12.
  • Fees, taxes, insurance, escrow, and other charges are not included.

How a Home Equity Schedule Works

A home equity loan generally provides a lump sum secured by home equity and repaid over an agreed term. An amortization schedule lays out each installment. Early in repayment, the outstanding balance is large, so the interest portion is usually larger; later, as principal falls, more of the same scheduled payment goes toward principal.

For each period, the basic calculation is:

  • Monthly interest = opening balance × monthly interest rate.
  • Principal paid = payment − monthly interest.
  • Closing balance = opening balance − principal paid.

For example, at the default 8% APR, the first month’s approximate interest on $20,000 is $133.33. From a $405.53 payment, about $272.20 therefore reduces principal, leaving a balance near $19,727.80. The exact figures can vary with rounding and the lender’s timing conventions.

How to Read and Use the Results

The monthly payment is the modeled regular principal-and-interest installment, not necessarily the complete amount due each month. The total-interest figure estimates the borrowing cost over the full scheduled term if payments are made as modeled. Neither figure establishes whether a borrower qualifies, what a lender will charge, or what payment fits a household budget.

To build a full month-by-month schedule, repeat the interest and balance steps for each payment period. A real statement may show a different principal balance if payments arrive on different dates, the rate changes, amounts are rounded differently, or the account includes fees. For an actual loan, compare these estimates with the lender’s disclosure and payment schedule.

Common Questions and Misconceptions

Does a home equity amortization schedule show how much equity I have? No. It shows the modeled loan balance over time. Home equity is generally discussed as the home’s value minus debts secured by it, but this calculator does not estimate home value or other liens.

Does a lower monthly payment always mean lower total interest? Not necessarily. A longer term can reduce the scheduled monthly payment while extending the time interest accrues. Compare both the payment and total interest, using the same loan amount and rate assumptions.

Why does my lender’s schedule differ? Differences can arise from the exact APR, payment due dates, daily versus monthly interest calculations, rounding, fees, variable-rate changes, or extra payments. Use the loan documents for contractual figures.

Does this model include a home equity line of credit? No. A line of credit can have changing balances, draw periods, variable rates, or payment rules that are not represented by a fixed, fully amortizing installment-loan formula.

Frequently Asked Questions

What is an amortization schedule for a home equity loan?
It is a payment-by-payment breakdown showing interest charged, principal repaid, and the remaining balance under stated loan assumptions.

How do I calculate a home equity loan payment?
Convert APR to a monthly rate, convert the term to months, then use the fixed-payment formula shown above. This estimate excludes charges not entered in the calculator.

Can I use this calculator for extra payments?
No. It assumes equal scheduled payments and does not model extra principal. Extra payments can change the payoff path, and their treatment depends on the loan’s terms.

Is the total interest exact?
No. It uses the displayed payment rounded to cents and assumes a fixed rate and regular monthly timing. The lender’s schedule provides the figures for its account.

Can I use it for a variable-rate home equity loan?
Not as a full projection. A changing rate can alter interest and payments, so the fixed-APR result is only a hypothetical estimate for the rate entered.

This result is an estimate for education, 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 | $ | 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 →