A useful HELOC shopping worksheet gives every offer the same borrowing plan and records both cost and unresolved conditions. Start with net cash, draw dates, and a payoff target. Then compare rate scenarios, fees, required payments, and ending balances. Keep eligibility and unanswered questions visible so a slightly lower estimated price does not hide an unsuitable obligation.
What to take away
- Use one borrowing scenario across all offers.
- Separate quoted facts, planning assumptions, and missing information.
- A tiny modeled price difference may be less important than an unresolved term.
Write the borrowing brief before collecting quotes
Describe the purpose, cash already available, amount needed now, possible later draws, and expected repayment. Add the property’s use and your preferred timing so each lender can identify whether its product is relevant. Avoid requesting a different amount from each provider just because an advertisement highlights a particular limit.
Keep the brief short enough to send consistently. It should not include account passwords or unnecessary sensitive information. The objective is to obtain comparable written illustrations, not to submit personal documents indiscriminately to every site that promises a low percentage.
Use three labels for every entry
Mark a number “quoted” when supported by a current written offer, “assumed” when chosen for your analysis, and “unconfirmed” when information is missing. Include the document date and the lender contact who can resolve questions. This prevents an attractive estimate from becoming a supposed guarantee as the spreadsheet grows.
Record the rate formula and conditions, cash delivered, opening and ongoing fees, required payments, end-of-draw obligations, and relevant exit charges. Put approvals or property conditions in their own column. A low estimated price is not yet an available option if essential eligibility questions remain unanswered.
Apply one draw schedule to three invented offers
For a worked illustration, assume $35,000 borrowed immediately and another $15,000 after six months, with interest-only payments and no principal reduction. Offer A is assumed at 7.00% for six months and 8.00% afterward, plus $350 in fees. B is assumed at 7.75% all year plus $100. C is assumed at 8.00% all year with no fees.
A’s estimated interest is $1,225 plus $2,000, totaling $3,225; with fees it costs $3,575. B costs $1,356.25 plus $1,937.50 plus $100, or $3,393.75. C costs $1,400 plus $2,000, or $3,400. All rates and fee packages here are hypothetical.
| Invented offer | First-year interest and fees | Debt after one year |
|---|---|---|
| A: lower initial rate | $3,575.00 | $50,000 |
| B: 7.75% assumption | $3,393.75 | $50,000 |
| C: 8.00% assumption | $3,400.00 | $50,000 |
Do not overstate a narrow modeled winner
B is only $6.25 cheaper than C in the illustration. A small fee, different transaction date, or rate movement could reverse that result. The appropriate next step is to resolve unknowns, not declare B universally best. Also compare required principal payments and flexibility to make your intended extra payments.
A looks cheapest if the reader sees only the introductory 7.00% rate. The full-year worksheet shows why that impression fails for this draw schedule. It also exposes the next issue: every option still has $50,000 outstanding. Extend the comparison to the actual repayment plan before making a decision.
Finish with a decision note and a follow-up list
Write two or three sentences explaining which option currently fits, which assumptions drive that result, and what must be confirmed before proceeding. For example: the costs are close, but the selected plan must permit the later draw and fit a specified monthly principal-repayment budget.
Give each unanswered question an owner and a date for follow-up. Ask Shawn to help review the scenario and discuss options available for your circumstances, then retain the actual lender disclosures. A completed worksheet should make the choice understandable even to someone who was not present for the sales conversation.
Questions that come up
How many quotes do I need?
More than one comparable written option can expose meaningful differences. The CFPB provides a three-offer comparison format; relevance and completeness matter more than collecting a large stack.
Should I rank offers solely by the first-year total?
No. Review the intended payoff period, future rate scenarios, required payments, fees, access conditions, and remaining debt.
What is the most important blank to resolve?
Any term that could change your decision: net proceeds, ongoing pricing, payment obligations, fees, or whether the option is actually available to you.
Sources & context
Primary sources checked for this guide on October 14, 2026. Examples are hypothetical, not current offers. Lender terms and individual circumstances can differ.
- CFPB: What you should know about HELOCs ↗
- CFPB: Home equity advertising and promotional terms ↗
- FTC: Home equity loans and lines of credit ↗
This guide is educational and is not individualized financial, tax, or legal advice. A home equity loan or line puts your home at risk if you cannot repay.