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.
- Payment before rounding: 20,000 × 0.0066667 ÷ [1 − (1.0066667)−60] ≈ $405.53.
- Monthly payment rounded to cents: $405.53.
- Total of rounded payments: $405.53 × 60 = $24,331.80.
- 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
- Closing Costs on a House Loan: What to Expect$405.53
- Secured Loan for Home Refinancing: Payment Calculator$405.53
- Closing Cost House Calculator: Estimate Buyer Costs$8,500.00
- Closing Cost House Estimate Calculator
- Loan Repayment Extension Request Letter: What to Include$405.53
- Refinance Calculator With PMI and Loan Term