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.
- Step-by-step math
- Plain-English explanations
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.
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.