calculate-loan

01 Loan payments

Home Equity Loan Calculator Monthly Schedule

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

Monthly payment $405.53
Total interest
$4,331.80
= Monthly payment × loan term × 12 − loan amount
Number of monthly payments
60 months
= Loan term × 12
Loan amount
$20,000
Input
You enter
Loan amount ($), Interest rate (APR) (%), Loan term (years)
You get
Monthly payment ($), Total interest ($), Number of monthly payments (months)
Rounding
2 dp · 0 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 loan calculator monthly schedule estimates the fixed payment and shows, month by month, how each payment is divided between interest and principal. Enter the loan amount, annual percentage rate (APR), and term to see the payment, total interest, and a schedule of estimated balances.

Formula

The calculator uses the standard level-payment formula for a fixed-rate, fully amortizing loan:

Monthly 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. For an 8% APR, r = 0.08 ÷ 12, or about 0.006667 per month.
  • n is the number of monthly payments: loan term in years × 12.

The payment is rounded to the nearest cent before total interest is calculated. Total interest is estimated as the rounded monthly payment multiplied by the number of payments, minus the original principal: total interest = monthly payment × n − P. This convention makes the displayed total consistent with the displayed payment, though a lender’s final payment may be adjusted for rounding or its payment rules.

Worked Example

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

  1. Monthly rate: 8 ÷ 1,200 = 0.0066667.
  2. Number of payments: 5 × 12 = 60.
  3. Monthly payment before rounding: $20,000 × 0.0066667 ÷ [1 − (1.0066667)−60] ≈ $405.53.
  4. Total of scheduled payments: $405.53 × 60 = $24,331.80.
  5. Estimated total interest: $24,331.80 − $20,000 = $4,331.80.

These are the formula’s rounded results for the defaults. The schedule below shows how the estimated payment changes the balance over time; it does not mean the amount of principal repaid is identical each month.

Assumptions

  • The interest rate is fixed for the full term, and payments are equal monthly amounts.
  • Payments are assumed to be made once per month, with interest accruing monthly at APR ÷ 12.
  • The estimate excludes lender fees, taxes, insurance, mortgage insurance, and escrow amounts.
  • It assumes the loan is fully repaid by the scheduled final payment, with no missed payments or extra principal payments.

How to Read a Monthly Schedule

An amortization schedule is a table with one row for each payment. A useful version includes the payment number or date, starting balance, payment, interest charged, principal repaid, and ending balance. The monthly payment stays level under the assumptions above, while the split between interest and principal changes.

For a simple monthly estimate, calculate interest as the starting balance multiplied by the monthly rate. Subtract that interest from the payment to find the principal portion. Then subtract principal repaid from the starting balance to get the ending balance.

  • Month 1: Starting balance is $20,000. At 8% APR divided monthly, estimated interest is $20,000 × 0.0066667, or about $133.33. Of the $405.53 payment, about $272.20 reduces principal, leaving an estimated balance of $19,727.80.
  • Later months: Because the balance is lower, the interest portion generally falls and more of the same payment goes to principal.
  • Near payoff: Most of the scheduled payment goes to principal. A lender may adjust the last amount to account for rounding, payment dates, or its method of calculating interest.

For a more exact schedule, repeat the calculation using the lender’s actual payment dates and interest method. A calculator may display a cent-rounded estimate for each row, so adding the displayed row amounts can differ slightly from a balance calculated using unrounded values.

Using the Estimate and Choosing Inputs

Use the principal amount, APR, and term quoted for the specific loan offer when available. The amount you hope to borrow is not necessarily the final principal: lender charges or other amounts may affect the figures in an offer, so check how the lender defines the loan amount. Enter APR as a percentage, such as 8 for 8%, not 0.08. Enter the term in years; the calculator converts it to months.

The payment formula is useful for comparing scenarios on the same mathematical basis. Holding the rate and amount constant, a longer term generally produces a lower scheduled payment but more payments overall, which can increase total interest. Holding the amount and term constant, a higher APR increases the calculated payment and interest. These are formula effects, not an assessment of eligibility or a recommendation about borrowing.

A home equity loan is generally structured as a lump sum repaid in installments, unlike a revolving home equity line of credit, which allows borrowing and repayment under a credit limit. This calculator models only a fixed-rate, equal-payment loan. It does not model a revolving balance, variable rate, draw period, or changing payment.

Common Limits and Mistakes

  • Confusing APR and monthly rate: The formula divides annual APR by 1,200 to get a monthly decimal rate. Do not enter a monthly rate in the APR field.
  • Assuming the payment is the full housing cost: The estimate covers principal and interest only. It does not add any separate charges, taxes, insurance, or escrow.
  • Treating the schedule as a lender quote: Fees, timing, rounding conventions, and contract terms can change actual figures. Use the lender’s disclosed payment schedule for exact amounts.
  • Applying it to a different product: Interest-only periods, adjustable rates, irregular payments, and extra payments need different calculations or additional inputs.
  • Ignoring the home’s role as security: A home equity loan is secured by the home. Missing required payments can have serious consequences, so the calculator’s arithmetic alone cannot represent the full risks or terms.

Frequently Asked Questions

How do I calculate a home equity loan payment?
Convert APR to a monthly rate by dividing it by 1,200, convert years to monthly payments by multiplying by 12, then use the level-payment formula shown above. This calculator performs those steps and rounds the result to cents.

Why does the interest portion fall each month?
Interest is calculated on the outstanding balance in this estimate. As principal is paid down, the balance used to calculate the next month’s interest decreases, so more of a level payment can go toward principal.

Does this calculator show the exact payoff balance?
No. It estimates balances under fixed-rate monthly compounding and regular payments. The lender’s balance can differ because of payment dates, rounding, fees, or contract-specific interest calculations.

Can I use this schedule for a home equity line of credit?
Not directly. A line of credit can have a changing balance, rate, and payment structure. This calculator assumes a single amount borrowed and equal monthly payments over a fixed term.

Does the monthly payment include fees or taxes?
No. The calculated payment is principal and interest only. Check the loan disclosure for any additional costs or amounts due.

This result is an estimate for educational purposes, 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
out n | Number of monthly payments | months | yrs * 12 | 0

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 →