HELOC Payment Formula and Calculation

Learn the HELOC draw payment, amortizing repayment, utilization, CLTV capacity, interest, fees, schedule, and rate-sensitivity formulas.

How do the HELOC Calculator formulas work?

This formula page defines the variables used by the HELOC Calculator, shows how those values are combined, and explains the order of operations behind the result. Use the worked steps to verify an estimate, compare scenarios, and understand which assumptions or rounding rules can affect the displayed answer.

Formula Overview

The calculator adds the optional new advance to the current balance, then models two phases. During draw, monthly interest is calculated on the beginning balance and optional principal reduces that balance. During repayment, the end-of-draw balance is amortized over the entered repayment term.

The base schedule holds the user-entered rate constant. A separate sensitivity series recalculates representative payments at two percentage points below through two points above that rate.

Variable Definitions

Symbol	Meaning	Unit or convention
L	Entered HELOC credit limit	Currency
B₀	Current balance plus optional additional draw	Currency
r	Entered annual interest rate	Decimal
i	Monthly rate	r / 12
P_d	Monthly principal paid during draw	Currency per month
F	Annual account fee	Currency per year
d	Remaining draw months	Draw years x 12
n	Repayment months	Repayment years x 12
B_d	Balance at the end of draw	Currency
M	Amortizing repayment principal and interest	Currency per month
V	Entered home value	Currency
c	Maximum CLTV assumption	Decimal
M₁	First-mortgage balance	Currency

Monthly Payment

The starting balance and first draw-period payment are:

B_0=Current\ balance+Additional\ draw

D_1=B_0\frac{r}{12}+\min(B_0,P_d)+\frac{F}{12}

The displayed draw payment is the first modeled month. When draw-period principal is entered, later interest and payments can decline as the balance falls.

The repayment principal-and-interest amount is:

M=B_d\frac{i}{1-(1+i)^{-n}}

R=M+\frac{F}{12}

At a zero rate, the engine uses M = B_d / n. The payment change is R - D₁.

Amortization

During each draw month, optional principal is capped at the beginning balance:

Interest_m=Balance_{m-1}\times i

Principal_m=\min(Balance_{m-1},P_d)

Balance_m=Balance_{m-1}-Principal_m

During repayment, each fixed principal-and-interest amount is divided between interest and principal:

Interest_m=Balance_{m-1}\times i

Principal_m=M-Interest_m

Balance_m=Balance_{m-1}-Principal_m

The final posting is capped at the remaining balance. Monthly schedule amounts are rounded to cents, and annual rows total interest, principal and fees.

Total\ interest=\sum Interest_m

Total\ fees=F\frac{Schedule\ months}{12}

Total\ cost=Total\ interest+Total\ fees

Extra Payments

The recurring P_d amount is applied only during the remaining draw phase. It reduces the balance before amortizing repayment begins.

The calculator does not model irregular principal, repeated new advances, recasting, fixed-rate conversions or account-specific payment allocation. Use separate runs to compare no principal with a sustainable monthly amount, then confirm posting rules with the creditor.

For an amortizing closed-end balance, use the Extra Payment Calculator to test monthly, annual and lump-sum principal.

Ownership Costs

Utilization and available credit are:

Utilization=\frac{B_0}{L}\times100\%

Available\ credit=L-B_0

The illustrative CLTV-based line estimate is:

Estimated\ line=\max(0,Vc-M_1)

Additional\ equity\ capacity=\max(0,Estimated\ line-B_0)

This is a planning relationship, not an underwriting formula or offer. It omits other liens and does not evaluate income, debts, credit, appraisal, occupancy, law or lender policy.

Property tax, homeowners insurance, HOA dues, maintenance, the first-mortgage payment and transaction-specific HELOC costs are outside the schedule.

Worked Calculation

Use a $100,000 line, $50,000 current balance, no additional draw, 8.50% annual rate, 10 draw years, 20 repayment years, no draw-period principal and a $50 annual fee.

Starting balance: $50,000.00.
Available credit: $100,000 - $50,000 = $50,000.00.
Utilization: $50,000 / $100,000 = 50.00%.
Monthly rate: 0.085 / 12 = 0.00708333.
First-month interest: $50,000 x 0.00708333 = $354.17.
Monthly-equivalent annual fee: $50 / 12 = $4.17.
First draw payment: $358.34.
End-of-draw balance with no principal: $50,000.00.
Repayment principal and interest: $433.91.
Repayment payment with fee: $438.08.
Payment change: $79.74.

Assumptions

The draw period uses monthly interest plus optional fixed principal and a monthly-equivalent annual fee.
The repayment period fully amortizes the end-of-draw balance over the entered term.
The entered rate remains constant in the base schedule.
The sensitivity series changes the entered rate by fixed one-point steps and is not a forecast.
No future advances occur after the entered additional draw.
Fees other than the entered annual fee are excluded.
Daily balance methods, minimum floors, index resets, margins, caps, floors, introductory terms, balloons and fixed-rate conversions are excluded.
Home value and CLTV fields are illustrative and do not predict approval or a credit limit.
Displayed money and schedule postings are rounded to cents.

Formula FAQ

Why can the repayment payment rise if the rate is unchanged?

Interest-only draw payments do not retire principal. Repayment adds principal over a finite term, so the required payment can increase without a rate change. Use realistic inputs and review the HELOC Calculator formula assumptions before relying on this result for decisions.

Why can payment change be negative?

If the user enters substantial principal during draw, the first draw payment includes that amount and the end-of-draw balance can be much smaller. Use realistic inputs and review the HELOC Calculator formula assumptions before relying on this result for decisions.

Does utilization measure total housing leverage?

No. HELOC utilization compares only the line balance with its limit. CLTV considers the first mortgage and the HELOC relative to home value. Use realistic inputs and review the HELOC Calculator formula assumptions before relying on this result for decisions.

Does the rate chart predict future APR?

No. It is a sensitivity test. The agreement's index, margin, adjustment timing, caps and floor determine the actual rate. For a useful HELOC Calculator formula result, use realistic inputs, compare relevant scenarios, and review the stated assumptions before making a decision.

References

Use the HELOC Calculator