{{ summaryTitle }}
{{ summaryValue }}

{{ summaryLine }}

{{ badge.label }} {{ badge.value }}
{{ summaryAnnouncement }}
HELOC agreement and payment assumptions
Use the opening or schedule month stated by the agreement.
{{ issueFor('agreement_month') }}
Maximum revolving line before the repayment period.
{{ issueFor('credit_limit') }}
Use 0 for an undrawn new line.
{{ issueFor('opening_balance') }}
months
Months when new draws are allowed.
{{ issueFor('draw_period_months') }}
months
Months after new draws stop.
{{ issueFor('repayment_period_months') }}
%
Public index value from the agreement source.
{{ issueFor('index_rate_percent') }}
points
Percentage points added to the index.
{{ issueFor('margin_rate_percent') }}
points
Comparison change from index plus margin.
{{ issueFor('stress_rate_change_percent') }}
%
Lowest effective annual rate in the agreement.
{{ issueFor('rate_floor_percent') }}
%
Maximum effective annual rate in the agreement.
{{ issueFor('lifetime_cap_percent') }}
Match the minimum-payment structure in the current agreement.
Principal paid in addition to monthly interest.
{{ issueFor('draw_principal_payment') }}
Amortizing retires the transition balance; fixed payment may leave a balloon.
Monthly principal-and-interest payment before fees.
{{ issueFor('repayment_fixed_payment') }}
Dated draws and principal repayments:
Optional dated activity updates the revolving balance path. {{ events.length }} of 24 rows used.
MonthTypeLabelAmountRemove
No dated events. The schedule starts from the opening balance.
{{ issueFor('events') }}
Neutral default: $0. Cash costs in the first modeled month.
{{ issueFor('upfront_fees') }}
Neutral default: $0. Applied after each modeled 12-month interval.
{{ issueFor('annual_fee') }}
Neutral default: $0. Applied once for each dated draw.
{{ issueFor('draw_transaction_fee') }}
Payment outlook
{{ row.label }}{{ row.value }}
How this estimate is built:
monthly interest = balance × effective annual rate ÷ 12
  1. {{ step }}
Planning estimate only. Compare the monthly convention, payment rule, fees, floor, and cap with the current lender agreement; missed payments can put the home at risk.
{{ chartExportStatus }}

The chart renderer is unavailable. The same scenario values remain in Payment outlook and the CSV export.

Monthly HELOC draw and repayment ledger in US dollars
MonthPhaseAPREventsOpening balanceDrawsExtra principalInterestScheduled principalFeesCash paymentEnding balanceAvailable creditCopy
{{ formatMonth(row.month) }}{{ row.phase }}{{ row.effective_apr }}{{ row.events }}{{ formatCurrency(row.opening_balance) }}{{ formatCurrency(row.draws) }}{{ formatCurrency(row.extra_principal) }}{{ formatCurrency(row.interest) }}{{ formatCurrency(row.scheduled_principal) }}{{ formatCurrency(row.fees) }}{{ formatCurrency(row.cash_payment) }}{{ formatCurrency(row.ending_balance) }}{{ formatCurrency(row.available_credit) }}
{{ ledgerExportStatus }}

A home equity line of credit (HELOC) is revolving debt secured by a home. During the draw period, the borrower can usually take additional advances up to the available limit and may face a relatively low minimum payment. When that period ends, new draws stop and repayment terms can raise the monthly payment sharply.

Most HELOCs have variable rates. The contract normally names a public index and adds a fixed margin, then applies any floor, periodic limit, or lifetime cap written into the agreement. A payment estimate is only as current as the index value entered, and a stress-rate scenario is a planning comparison rather than a forecast.

Typical differences between HELOC draw and repayment periods
Phase New borrowing Common payment pattern Main planning risk
Draw periodAllowed within the credit limitInterest only or interest plus some principalThe balance can stay high or grow with later draws.
Repayment periodNormally stopsAmortizing principal and interest, a fixed payment, or another contract ruleThe first repayment payment can jump, and a low fixed payment can leave a balloon.

The transition depends on more than the rate. Opening balance, future draws, principal repayments, payment rules, phase lengths, and fees all affect cash needs. A fixed repayment amount is not the same as a fully amortizing payment. If it is too small to retire the balance over the stated term, money remains due at the end.

Monthly conventions also differ by lender. A planning ledger that uses annual rate divided by 12 and start-of-month events will not exactly reproduce a statement based on daily balances, rate-change dates, payment floors, promotional periods, or lender-specific posting order. The agreement and current statement remain the controlling sources.

Falling behind on debt secured by a home can lead to foreclosure. Treat a modeled payment as budgeting evidence, not an approval, payoff quote, legal interpretation, or recommendation to borrow.

How to Use This Tool:

Use one current agreement and one dated index value so the term, rate limits, payment rules, and events describe the same line of credit.

  1. Enter the Agreement start month, Credit limit, Opening balance, and the draw and repayment periods in whole months.
  2. Copy the Current index, Contract margin, Rate floor, and Lifetime rate cap from the agreement or a current source. Enter a Stress change in percentage points for comparison.
  3. Choose the Draw-period payment rule. Under interest plus fixed principal, enter the principal amount paid with each draw-period interest payment.
  4. Choose a fully amortizing or fixed Repayment-period rule. Enter the fixed monthly payment only when that is the rule you want to test.
  5. Add dated draws and principal repayments when the balance will change during the schedule. Draws must occur inside the draw period and cannot take the modeled balance above the credit limit.
  6. Open Advanced for upfront, annual, or per-draw cash fees. These fees increase cash paid but do not increase the modeled line balance.
  7. Read the last draw payment, first repayment payment, payment change, and ending balloon together. Then compare the monthly ledger and assumptions with the lender's agreement and statement.

Interpreting Results:

Payment shock is the first repayment-period payment minus the final draw-period payment. A positive amount shows the immediate modeled increase. It does not capture every future rate reset, and a small transition does not prove the plan is affordable over the full term.

  • Effective APR is index plus margin after the entered floor and lifetime cap. It is held constant inside each scenario.
  • Repayment start balance is the amount left when draws stop. This is the balance the amortizing payment uses.
  • Ending balloon is debt still outstanding after the last modeled month. Any value above zero needs a payoff, refinance, sale, or other plan outside this schedule.
  • Maximum balance reveals whether dated draws push utilization higher than the opening balance suggests.
  • Total cash payments includes scheduled payments, event principal repayments, and modeled cash fees.

Compare the baseline, stress change, and contract-cap scenarios as sensitivity checks. The cap case shows the entered maximum-rate assumption, not the date or probability of reaching that rate.

Technical Details:

The model advances one calendar month at a time using integer cents and rates rounded to whole basis points. Dated draws or principal repayments are applied at the start of the month, interest is calculated on the resulting balance, and the selected phase payment is applied afterward.

Formula Core:

The effective annual rate is bounded by the entered contract floor and lifetime cap. Monthly interest uses one twelfth of that annual rate. A fully amortizing repayment payment is calculated once at the start of repayment.

reffective= min(rcap,max(rfloor,rindex+rmargin)) It= Bt×reffective12 M= Bq1(1+q)N

Here Bt is the balance after that month's dated events, It is monthly interest, q is the effective annual rate divided by 12, N is the repayment-month count, and M is the level amortizing payment. If the rate is zero, M is the repayment-start balance divided by N.

Mechanism Core:

Order of HELOC monthly ledger calculations
OrderMonthly actionBalance or cash effect
1Apply dated draw or principal repaymentA draw raises balance; repayment is limited to the amount owed.
2Calculate interestInterest is rounded to the nearest cent from the post-event balance.
3Apply phase paymentDraw payment pays interest and optional fixed principal; repayment follows the chosen rule.
4Add cash feesUpfront, annual, and per-draw fees increase cash payment without increasing balance.
5Record ending balance and available creditThe next month begins from the unrounded integer-cent balance.

Under the amortizing rule, the final payment is adjusted to clear the remaining balance and interest. Under the fixed-payment rule, each payment is limited to the balance plus interest; a payment that does not retire the debt leaves an ending balloon.

Limitations:

This is a monthly planning model, not an official lender calculation.

  • It does not fetch a live index or predict future rates.
  • It omits daily-balance interest, teaser periods, rate-adjustment timing, periodic caps, fixed-rate subaccounts, late fees, penalties, payment floors, escrow, taxes, and insurance.
  • It does not calculate official disclosure APR, underwriting, available home equity, payoff amounts, or tax treatment.
  • Actual agreements may suspend draws, require minimum advances, or use payment rules not represented here.

Worked Examples:

A fixed payment that leaves a balloon

A $5,000 opening balance receives a $2,000 draw, a later $500 principal repayment, and two months of $1,000 fixed repayment payments at an 8% effective annual rate. After $60 of modeled fees and $166.95 of interest, the schedule still ends with a $4,377.61 balance. The fixed payment controls monthly cash outflow; it does not guarantee full amortization.

References: