Category: Home Equity Loans
Resource type: Worksheet
What This Worksheet Answers
How much can you borrow against your home before the loan becomes risky for you, not just acceptable to the lender? A lender's maximum is set to protect the lender. Your safety margin is the cushion you keep so that a price drop, a job loss, or a rate increase doesn't put your home at risk.
The Formulas
Step 1: Current equity
Equity = Current Home Value − Mortgage Balance
Step 2: Combined loan-to-value ratio (CLTV)
CLTV = (First Mortgage Balance + New Home Equity Loan or HELOC) ÷ Home Value
Step 3: Lender's maximum draw
Maximum Draw = (Home Value × Lender CLTV Limit) − First Mortgage Balance
Many lenders cap CLTV at around 80% to 85%, though limits vary by lender and loan type.
Step 4: Your safety-margin draw
Safe Draw = (Home Value × Your Personal CLTV Ceiling) − First Mortgage Balance
A cautious personal ceiling is 70% to 75%. This is a rule of thumb, not a standard.
Step 5: Price-drop stress test
Stressed CLTV = Total Loans ÷ (Home Value × (1 − Price Drop %))
If the stressed CLTV is above 100%, you would owe more than the home is worth in that scenario.
Step 6: Payment stress test (variable-rate HELOCs)
Stressed Payment = Draw × (Current Rate + Rate Increase) ÷ 12
This is an interest-only estimate. Many HELOCs convert to full principal-and-interest payments after the draw period, which raises the payment further.
Step 7: Affordability check
Payment-to-Income = New Monthly Payment ÷ Gross Monthly Income
Pair this with the DTI Headroom Test to confirm the new payment fits.
Worked Example
The scenario
| Item | Amount |
|---|---|
| Current home value | $400,000 |
| First mortgage balance | $240,000 |
| Lender CLTV limit | 85% |
| Your personal CLTV ceiling | 75% |
| Desired draw | $90,000 |
| HELOC rate | 8.50% (variable) |
| Gross monthly income | $7,500 |
Step 1: Equity
$400,000 − $240,000 = $160,000 (40% equity)
Step 2: Lender's maximum draw
($400,000 × 0.85) − $240,000 = $340,000 − $240,000 = $100,000
The desired $90,000 draw fits within the lender's limit.
Step 3: CLTV with the desired draw
($240,000 + $90,000) ÷ $400,000 = 82.5%
Step 4: Your safe draw
($400,000 × 0.75) − $240,000 = $300,000 − $240,000 = $60,000
The desired draw is $30,000 above the safe draw.
Step 5: Price-drop stress test
Total loans: $330,000
| Price Drop | Stressed Home Value | Stressed CLTV |
|---|---|---|
| 0% | $400,000 | 82.5% |
| 10% | $360,000 | 91.7% |
| 15% | $340,000 | 97.1% |
| 20% | $320,000 | 103.1% |
Reading the result: A 20% price drop would leave this borrower owing more than the home is worth. At the $60,000 safe draw (total loans $300,000), the same drop gives a stressed CLTV of 93.8%, which keeps some equity intact.
Step 6: Payment stress test (interest-only)
| Scenario | Rate | Monthly Payment on $90,000 |
|---|---|---|
| Today | 8.50% | $637.50 |
| Rates up 2 points | 10.50% | $787.50 |
| Rates up 3 points | 11.50% | $862.50 |
The payment rises about $225 per month if rates climb 3 points.
Step 7: Affordability
$862.50 ÷ $7,500 = 11.5% of gross income in the stressed scenario, on top of the existing mortgage payment.
Worksheet Summary Table
Fill in your own numbers using this layout.
| Line | Item | Example | Yours |
|---|---|---|---|
| A | Home value | $400,000 | |
| B | First mortgage balance | $240,000 | |
| C | Lender CLTV limit | 85% | |
| D | Lender maximum draw: (A × C) − B | $100,000 | |
| E | Your personal CLTV ceiling | 75% | |
| F | Your safe draw: (A × E) − B | $60,000 | |
| G | Amount you want to borrow | $90,000 | |
| H | CLTV at G: (B + G) ÷ A | 82.5% | |
| I | Stressed CLTV at 15% price drop | 97.1% | |
| J | Stressed monthly payment (rates +3 points) | $862.50 | |
| K | Stressed payment ÷ gross income | 11.5% | |
| L | Pass if G ≤ F and I < 100% | Fail on G |
Reading Your Result
| Result | What it generally suggests |
|---|---|
| Desired draw is at or below your safe draw | Comfortable margin |
| Above safe draw, below lender maximum | Approved but thin cushion; consider borrowing less |
| Stressed CLTV above 100% in a 15% drop | You could end up underwater if prices fall |
| Stressed payment pushes DTI past your comfort level | Choose a fixed-rate home equity loan or borrow less |
These are rules of thumb, not guarantees. Lending Logic Lab provides educational information, not personalized financial advice.
Ways to Widen Your Margin
- Borrow less. Cutting the draw to $60,000 here gets you within your safe draw.
- Choose a fixed-rate home equity loan over a variable-rate HELOC if you need certainty on the payment.
- Draw in stages from a HELOC rather than taking the full line at once.
- Build a payment reserve of three to six months of total housing and loan payments.
- Shorten the purpose horizon. Borrow for projects that add value or reduce other debt, not for spending that leaves nothing behind.
Common Mistakes
- Treating the lender maximum as a goal. Approval is not the same as safety.
- Using an optimistic home value. Use a conservative estimate, since lenders rely on an appraisal.
- Ignoring the payment shift. Many HELOCs move from interest-only to full repayment after the draw period, and the payment can jump sharply.
- Forgetting closing costs and annual fees. These can reduce what you actually receive.
- Overlooking the risk. A home equity loan is secured by your home, so missed payments can lead to foreclosure.
Reader Checklist Before You Borrow
- Get a recent estimate of your home value, and use a conservative figure
- Confirm your first mortgage balance from your latest statement
- Ask the lender for its CLTV limit, fees, and whether the rate is fixed or variable
- Find out when the draw period ends and how the payment changes afterward
- Run the price-drop and rate stress tests above
- Confirm the new payment with the DTI Headroom Test
Lending Logic Lab provides educational information, not personalized financial advice. Confirm your figures with your lender..
0 Comments