HELOC Calculator
Prime rate today7.00%▲ up 0.25 on September 2026Federal Reserve H.15 data for Nov 16, 2026How prime sets your HELOC rate

How HELOC Payments Are Calculated

The formulas behind every HELOC payment, interest charge and credit limit, with worked examples. Enter your own numbers to see each step.

Your numbers
$
%
years
years

1. How is the interest-only payment calculated?

Payment = balance × annual rate ÷ 12

Example: $50,000 × 8.00% ÷ 12 = $333.33.

2. How is the repayment payment calculated?

Payment = B × r ÷ (1 − (1 + r)−n)

B is the balance, r the monthly rate (APR ÷ 12) and n the number of monthly payments. Example: $50,000, r = 0.08 ÷ 12 = 0.006667, n = 240 gives $418.22. If your rate is variable, the lender recalculates this payment when the rate changes, using the balance and months left.

3. How is HELOC interest calculated each month?

Interest = average daily balance × APR ÷ 365 × days

Example: an average balance of $45,000 at 8.00% for 31 days = $305.75. Try it with draws and payments on the HELOC interest calculator.

4. How is a HELOC rate calculated?

Rate = index (prime) + margin, limited by the floor and cap

Example: today’s prime 7.00% + margin 1.00% = 8.00%. See the HELOC rate calculator.

5. How is the credit limit (LTV) calculated?

Line = home value × CLTV limit − existing loans

Example: $500,000 × 85% − $280,000 = $145,000. See How much HELOC can I get?

6. How is the minimum payment calculated on a percent-of-balance plan?

Payment = the larger of (balance × percent) and that month’s interest

Example: 1% of $50,000 = $500.00, more than the $333.33 of interest, so the payment is $500.00.

Common questions

Can I calculate a HELOC payment in Excel?

Yes. Interest-only: =B*rate/12. Repayment: =PMT(rate/12, months, -balance). Or download the full schedule from the HELOC amortization calculator.

Why doesn’t my statement match the formula exactly?

Lenders usually count actual days and your daily balance, round to the cent and may apply rate changes mid-cycle. Differences of a few dollars are normal.

Related calculators

Sources

  • Standard loan amortization formula, as used for closed-end installment loans under Regulation Z, 12 CFR 1026.22 and Appendix J (APR calculation).
  • Regulation Z (Truth in Lending), 12 CFR 1026.40, Requirements for home equity plans; 12 CFR 1026.15, Right of rescission.
  • Consumer Financial Protection Bureau, “What You Should Know About Home Equity Lines of Credit” (consumer booklet).

Reviewed November 22, 2026. Prime rate: Federal Reserve data for November 16, 2026, updated daily.