calculate-loan

01 Loan payments

Home Equity Amortization Schedule Calculator

Calculator No. 01-15824 · 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 calculator estimates each monthly payment’s interest and principal portions and the remaining balance over the loan term. Enter the amount borrowed, annual percentage rate (APR), and term to see the level payment and total interest; the schedule can then be built month by month from those figures.

Formula

This calculator uses the standard fixed-payment loan formula. It calculates a monthly payment and total interest, which are the core inputs for an amortization schedule. It does not display every monthly row in this compact calculator; each row can be worked out using the balance formula below.

  • Monthly payment: M = P × r ÷ [1 − (1 + r)−n]
  • Total interest: I = M × n − P
  • Balance after k payments: Bk = P(1 + r)k − M × [(1 + r)k − 1] ÷ r

P is the starting loan principal in dollars; APR is the annual percentage rate entered as a percentage; r is the monthly rate, APR ÷ 1,200; n is the number of monthly payments, years × 12; M is the monthly payment in dollars; I is total interest in dollars; k is the number of payments made; and Bk is the balance in dollars after payment k. The displayed payment is rounded to cents, and the total-interest estimate uses that rounded payment.

Worked Example

Using the calculator’s defaults—$20,000 borrowed, 8% APR, and 5 years—the monthly rate is 0.08 ÷ 12 = 0.0066667, and the term is 5 × 12 = 60 monthly payments.

  1. Payment before rounding: 20,000 × 0.0066667 ÷ [1 − (1.0066667)−60] ≈ $405.53.
  2. Monthly payment rounded to cents: $405.53.
  3. Total of rounded payments: $405.53 × 60 = $24,331.80.
  4. Estimated total interest: $24,331.80 − $20,000 = $4,331.80.

For the first month, interest is approximately $20,000 × 0.0066667 = $133.33. About $272.20 of the $405.53 payment reduces principal, leaving a balance near $19,727.80. In later months, interest is calculated on the smaller balance, so more of the same payment goes to principal. Small differences can arise if a lender rounds interest or payments differently.

Assumptions

  • The interest rate is fixed for the entire term.
  • Payments are equal monthly payments, made at the end of each monthly period.
  • Interest accrues monthly at APR ÷ 12; the model does not calculate daily interest.
  • Fees, taxes, insurance, mortgage insurance, escrow, and any separate line-of-credit charges are not included.
  • The estimate assumes no extra payments, missed payments, payment changes, or early payoff.

How a Home Equity Amortization Schedule Works

Home equity borrowing generally uses a home as security, but the product structure matters. A home equity loan commonly provides a set amount with scheduled principal-and-interest payments. A home equity line of credit may allow borrowing and repayment over time, and its balance, rate, or payment calculation can change under the agreement. This calculator models a single disbursement repaid through fixed monthly payments; it is not a full model of a revolving line.

An amortization schedule is a dated list of payments showing, for each period, the starting balance, interest charged, principal repaid, payment, and ending balance. To calculate a row, multiply the opening balance by the monthly rate for that period to estimate interest. Subtract that interest from the payment to find principal reduction, then subtract principal reduction from the opening balance. Repeat using the new balance. In the final period, a lender may adjust the payment slightly to clear remaining cents.

When to Use the Estimate and How to Read It

Use the calculation to understand the mechanics of a proposed fixed-rate loan, compare hypothetical principal amounts or terms, or check how principal reduction develops over time. It is educational arithmetic, not a lender quote or an assessment of eligibility. Enter the rate and amount supplied for the specific loan scenario; do not treat the example defaults as market figures.

  • A higher principal generally raises the payment and interest if rate and term stay unchanged.
  • A higher APR generally raises the payment and the interest portion of payments.
  • A longer term generally lowers the required monthly payment but can increase total interest because repayment lasts longer.
  • Early in repayment, interest usually makes up a larger share of each level payment; later, principal makes up more.

Total interest is not the same as the total cost of borrowing when charges outside principal and interest apply. Review the lender’s payment schedule and disclosures for the exact payment dates, fees, and terms. Also check whether a quoted rate can change and whether the payment shown includes anything beyond principal and interest.

Common Limits and Calculation Mistakes

A frequent error is entering an APR as a decimal when the calculator expects a percentage: enter 8 for 8%, not 0.08. The formula converts the annual percentage to a monthly rate by dividing by 1,200. Enter the term in years, not months; the calculator converts years to 12-month periods.

Rounding can create small discrepancies. The calculator rounds the monthly payment to cents before multiplying by the number of payments, as shown in the example. A lender may calculate interest daily, round each period differently, collect a first payment after an irregular interval, or include charges not represented here. The schedule is therefore an estimate rather than a promise of the exact payoff balance.

The formula also assumes the APR behaves like a fixed nominal annual rate divided into monthly periods. It cannot represent a changing rate, a draw-and-repayment pattern, a balloon payment, skipped payments, or extra principal unless those features are separately modelled. For a line of credit or a loan with changing terms, use the lender’s stated payment method and account-specific schedule.

Frequently Asked Questions

What is a home equity amortization schedule?
An amortization schedule lists each planned payment and separates it into interest and principal, while tracking the outstanding balance. It shows how a fully amortizing fixed-payment loan is expected to be repaid over time.

Does this calculator show a month-by-month table?
No. It calculates the level monthly payment and estimated total interest. You can calculate individual schedule rows from the opening balance, monthly rate, and payment, or consult the lender’s schedule for a complete dated table.

Does the calculator work for a home equity line of credit?
Only as a simplified illustration when a balance is repaid at a fixed rate through equal monthly payments. A line of credit may have variable rates, changing balances, or different payment rules that this formula does not model.

Why does the interest share fall over time?
Each period’s interest is based on the remaining principal. As principal declines, the interest charge generally declines too; with a level payment, more of the payment can then go toward principal.

Why does my lender’s payment differ from this estimate?
The lender may use different rounding, payment dates, daily interest, fees, or loan terms. Confirm the actual APR, amount financed, repayment period, and payment breakdown against the lender’s disclosure.

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 | $ | 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 →