A home equity loan calculator payment schedule estimates the fixed monthly payment and shows how each payment is divided between principal and interest over the loan term. Enter the loan amount, annual percentage rate (APR), and term to see the estimated payment and total interest; the schedule itself can be built by recalculating the remaining balance after each monthly payment.
Formula
The calculator uses the standard fixed-payment amortization formula. It first finds the monthly payment, then subtracts the original loan principal from all scheduled payments to estimate total interest:
- Monthly payment: M = P × r ÷ [1 − (1 + r)−n]
- Total interest: I = M × n − P
Here, M is the monthly payment in dollars, P is the amount borrowed in dollars, r is the monthly interest rate as a decimal (APR ÷ 1,200), and n is the number of monthly payments (term in years × 12). The APR is entered as a percentage per year. The displayed monthly payment is rounded to the nearest cent, and total interest uses that rounded payment. Actual lender calculations can differ because of payment dates, rounding practices, fees, or loan terms.
Worked Example
Using the calculator’s default inputs—$20,000 borrowed, 8% APR, and a 5-year term—the calculation is:
- Convert APR to a monthly decimal rate: r = 8 ÷ 1,200 = 0.0066667.
- Find the number of payments: n = 5 × 12 = 60.
- Apply the payment formula: M = 20,000 × 0.0066667 ÷ [1 − (1.0066667)−60] ≈ $405.53 per month.
- Calculate total interest using the rounded monthly payment: I = ($405.53 × 60) − $20,000 = $4,331.80.
The calculator therefore returns a monthly payment of $405.53 and estimated total interest of $4,331.80. Multiplying the rounded payment by 60 gives total scheduled payments of $24,331.80, including the $20,000 principal.
Assumptions
- The interest rate is fixed for the full term.
- Payments are equal monthly payments made at the end of each monthly period.
- Interest accrues monthly using APR divided by 12.
- The estimate excludes fees, taxes, insurance, PMI, escrow, and any charges not entered as inputs.
- No extra payments, missed payments, or changes to the loan are included.
How to Read a Payment Schedule
A payment schedule, also called an amortization schedule, lists the payment number, payment amount, interest charged, principal repaid, and remaining balance for each period. For a fixed-rate, fully amortizing loan, the scheduled payment generally stays level. The split changes over time: interest is calculated on the outstanding balance, so the interest portion is usually larger in early payments and declines as the principal is paid down. The principal portion correspondingly grows.
To create each row, multiply the opening balance by the monthly rate to estimate that month’s interest. Subtract that interest from the payment to find the principal portion, then subtract principal repaid from the opening balance. For example, with the default inputs, first-month interest is approximately $20,000 × 0.0066667 = $133.33. From a $405.53 payment, about $272.20 goes to principal, leaving an estimated balance of $19,727.80. Small differences can appear because lenders may retain more decimal places and round each component differently.
The calculator provides the payment and total-interest summary, not a row-by-row schedule. To estimate later rows, repeat the same balance calculation using the prior month’s ending balance. The final row may need a small adjustment if cent rounding would otherwise leave a residual balance.
Using the Estimate and Avoiding Common Errors
Enter the amount actually being borrowed, the APR quoted for the loan, and the repayment term. APR is entered as a yearly percentage: 8 means 8%, not 0.08 or 8 as a decimal. The formula converts it to a monthly rate by dividing by 1,200. The term is in years, and the calculator converts it into monthly payments.
- Do not confuse payment with total cost. The payment is a monthly amount; total interest is the estimated interest across all scheduled payments.
- Check the loan structure. This calculation assumes equal payments that repay the balance by the end of the term. It does not model an interest-only period, a balloon payment, a variable rate, or a draw period.
- Account for charges separately. If fees are financed, the amount borrowed may be higher than the cash received. Fees paid separately are not represented in these outputs.
- Use the lender’s stated terms. A lender’s payment may differ due to its precise APR, disbursement date, first-payment timing, daily interest calculation, or rounding method.
A home equity loan is generally structured as a lump-sum borrowing with scheduled repayments, unlike a revolving line of credit that can allow repeated draws. This calculator models only the lump-sum, fixed-rate repayment case. It does not determine available equity, eligibility, approval, or the consequences of borrowing against a home. Obtain the actual rate, fees, payment dates, and full payment schedule from the lender before relying on a figure.
Frequently Asked Questions
How do I calculate a home equity loan monthly payment?
Use the fixed-payment formula: principal multiplied by the monthly rate, divided by one minus one plus the monthly rate raised to the negative number of monthly payments. This calculator applies that formula and rounds the payment to cents.
Does each payment reduce my home equity loan balance?
Under the fixed-payment assumptions here, each payment covers that period’s interest first and the remainder reduces principal. The principal reduction typically increases over the repayment term as the balance declines.
Why does my lender’s payment differ from this estimate?
The lender may use different rounding, payment dates, day-count conventions, fees, or loan features. Compare the calculator inputs with the lender’s disclosure and use the lender’s stated payment for the actual account.
Does this calculator show a full amortization schedule?
No. It estimates the monthly payment and total interest. A full schedule requires a row for each month showing opening balance, interest, principal paid, and ending balance; those rows can be calculated iteratively from the monthly rate and payment.
Can I use it for a home equity line of credit?
Not reliably. A line of credit may have changing balances, rates, draw periods, and repayment rules. This calculator assumes one lump-sum advance, a fixed APR, and equal payments throughout the term.
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