calculate-loan

01 Loan payments

5-Year Home Equity Loan Payoff Calculator

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

This calculator works out how much you still owe on a 5-year home equity loan after a certain number of payments, and how much interest you’ve paid up to that point. You enter the original loan amount, your APR, and how many months you’ve already paid. It’s for anyone with a fixed-rate home equity loan who wants to track progress, plan extra payments, or just see where they stand mid-term.

Formula

The calculator uses the standard fixed-rate amortization formula. First, the monthly payment M is computed as:

M = P × (r / (1 − (1 + r)−n))

where:

  • P = loan amount (principal), in dollars
  • r = monthly interest rate = APR / 1200 (APR is in percent per year)
  • n = total number of monthly payments = years × 12

Then total interest over the full term is simply M × n − P. The monthly payment is rounded to the nearest cent, and all totals are based on that rounded payment, matching how lenders actually calculate your statement.

Worked Example

Using the default values: loan amount $20,000, APR 8%, term 5 years.

First, convert APR to monthly rate: r = 8 / 1200 = 0.0066667.

Total payments: n = 5 × 12 = 60.

Now compute the payment:

M = 20000 × (0.0066667 / (1 − (1.0066667)−60))

Calculate (1.0066667)−60 ≈ 0.67121.

So denominator = 1 − 0.67121 = 0.32879.

Then M = 20000 × (0.0066667 / 0.32879) = 20000 × 0.02028 = 405.53 (rounded to the cent).

Total interest = 405.53 × 60 − 20000 = 24331.80 − 20000 = 4331.80.

These match the calculator’s outputs: monthly payment $405.53 and total interest $4,331.80.

Assumptions

  • Fixed interest rate for the entire term (no rate adjustments).
  • Payments are made monthly at the end of each period.
  • Interest compounds monthly at APR / 12.
  • No fees, closing costs, taxes, insurance, or prepayment penalties are included.

How to Use This Calculator

Enter your original loan amount, the APR you actually have (check your loan documents), and the term in years. The calculator instantly shows your required monthly payment and the total interest you’ll pay over the full term. That monthly payment is the baseline—if you pay more than that, you’ll finish early and save interest, but this calculator doesn’t model extra payments directly.

To find your remaining balance after a certain number of months, you can use the balance formula: B = P × (1 + r)k − M × ((1 + r)k − 1) / r, where k is the number of payments made. For example, after 30 payments on the default loan, the balance is about $10,870. This is useful if you’re considering refinancing or paying off a lump sum.

Common mistakes: using the APR as a monthly rate (divide by 12), forgetting to convert years to months, or rounding the payment before calculating totals—always use the rounded payment for exact match with lender statements.

The formula assumes a fixed rate and level payments. If your loan has a variable rate or interest-only period, the result will be off. Also, it ignores any fees or points that were rolled into the loan amount—those are already part of the principal you entered.

This is an estimate for educational purposes. Your lender’s disclosure will show the exact payoff amount, including any fees accrued.

How to Choose

When deciding whether to use this calculator versus a full amortization schedule, consider what you need: a quick monthly payment and total interest, or a detailed breakdown of each payment. For payoff planning, you also need to know your current balance—you can get that from your lender or by using the balance formula above. The most important input is the APR: use the exact rate from your loan agreement, not a generic market rate. Also, remember that extra payments reduce interest faster, so if you plan to pay extra, use a calculator that allows extra payments to see the true savings.

Frequently Asked Questions

Q: Can I use this calculator for a home equity line of credit (HELOC)?
A: No, HELOCs typically have variable rates and draw periods, so fixed-rate amortization doesn’t apply. Use a HELOC-specific calculator.

Q: What if my loan has a different term, like 10 years?
A: You can change the term input to any number of years (up to 50). The formula works for any fixed-rate loan.

Q: How do I find my current balance?
A: Your lender’s statement shows the payoff amount, or you can calculate it using the balance formula with your original terms and the number of payments made.

Q: Does this include property taxes or insurance?
A: No, those are separate. This calculator only covers principal and interest.

Q: What happens if I make extra payments?
A: The calculator doesn’t model extra payments. To see the impact, use a calculator with an extra payment option, or manually recalculate with a lower balance.

Q: Why does the total interest seem high?
A: Because interest is front-loaded in amortization. Early payments go mostly to interest, so over a 5-year term you pay a significant amount of interest even at moderate rates.

Final Thoughts

Knowing your monthly payment and total interest helps you budget and plan. This calculator gives you a clear picture of your 5-year home equity loan, but remember it’s an estimate—your lender’s exact figures will be on your statement.

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 →