Suppose you own a home in Henrico County, Virginia, currently worth a defensible $450,000 based on recent comps, with a mortgage balance of $310,000 at 6.75%. That’s $140,000 in raw equity sitting on paper, but not all of it is usable. Run it through a real worksheet instead of a generic online calculator, and at a 90% loan-to-value cap you land closer to $95,000 in usable equity before closing costs, and roughly $80,000 to $85,000 in your pocket after them. That’s the number that actually matters when you’re deciding between a cash-out refinance and a HELOC. This guide walks you through building that worksheet by hand, step by step, so the figure you bring into a lending conversation matches what underwriting will actually approve. You’ll need your latest mortgage statement and a realistic home value estimate before you start.
Duane Buziak, NMLS #1110647, has run this exact math for homeowners across Virginia, Florida, Tennessee, Georgia, DC, North Carolina, South Carolina, and Maryland, and the pattern is consistent: automated valuation tools and “equity calculator” widgets routinely overstate what’s borrowable because they skip the LTV caps and cost line items that follow.
Step 1: Pull your current loan balance and terms
Start with your most recent mortgage statement, not the original loan amount from your closing documents years ago. You want the exact unpaid principal balance as of your last payment, sometimes labeled “current principal balance” or “outstanding principal.” This single figure anchors every calculation that follows, so don’t round it or estimate from memory.
While you have the statement out, note three more things:
- Your current interest rate, which you’ll compare against today’s market rate later in this process.
- Your remaining term, since a refinance that resets you to a fresh 30-year term changes your total interest cost even if the monthly payment drops.
- Your loan type: FHA, VA, USDA, or conventional. This matters more than most homeowners realize, because the LTV ceiling you’re allowed to borrow against in Step 4 depends entirely on which bucket your loan falls into.
If you’re not sure which type of loan you have, check the top of your statement or your original closing disclosure. VA loans usually reference a Certificate of Eligibility somewhere in your closing file. FHA loans carry a case number starting with a three-digit code tied to HUD. Conventional loans typically show a Fannie Mae or Freddie Mac loan number once your servicer has sold the loan on the secondary market, which is common and doesn’t change your obligations.
Write your balance, rate, term, and loan type at the top of your worksheet. Everything else builds from these four data points, and getting any one of them wrong throws off the usable-equity figure you’ll calculate a few steps from now.
Step 2: Get a defensible home value estimate
This is where most online equity calculators fall apart. Automated valuation models pull from public records and recent sales algorithms, and they can be off by 5% to 10% in either direction, especially in neighborhoods with limited recent turnover or unique lot characteristics. A 7% miss on a $450,000 home is over $31,000 of equity that either doesn’t exist or is being left on the table.
Instead of trusting a single online number, pull three to four recent comparable sales from your county’s real estate assessment records, or ask a local real estate agent for a quick comparative market analysis. Most agents will run one for free because it’s a low-cost way to build a relationship with a future client. Look for homes with similar square footage, lot size, and finish level that sold within the last six to nine months, ideally within a mile of your property.
Here’s a worked example: a Henrico County homeowner pulls comps from the Henrico County Real Estate Assessment records and finds three similar homes on their street that closed between $440,000 and $462,000 over the past eight months. They land on $450,000 as a defensible, middle-of-the-range value. Against a $310,000 balance, that’s $140,000 in raw equity, the starting number for the rest of this worksheet.
If your estimate ends up being a stretch, don’t worry too much at this stage. A lender-ordered appraisal during underwriting will correct any inflated number before a loan closes. The goal of this worksheet is to give you a realistic planning figure now, not a guaranteed appraised value. Build the worksheet with your best defensible estimate, and verify it later once you’re in an actual application.
Step 3: Calculate raw equity on the worksheet
With your balance from Step 1 and your value estimate from Step 2, the math here is simple: home value minus loan balance equals raw equity. Using the Henrico County example, $450,000 minus $310,000 leaves $140,000 in raw equity.
Write this number down as the first real line on your worksheet. It’s the foundation, but it is not the number you can actually borrow, and this is where a lot of homeowners get tripped up. Raw equity is a paper figure. It reflects ownership stake, not lending capacity.
The common mistake is treating that $140,000 as spendable cash, mentally budgeting a kitchen remodel or debt payoff plan around the full figure. Lenders don’t work that way. Every refinance and every HELOC has a maximum loan-to-value ratio it will lend against, and that ceiling is what determines how much of your raw equity actually converts into usable funds. According to the Consumer Financial Protection Bureau’s refinancing guidance, understanding these limits before applying is one of the most overlooked steps homeowners skip.
Treat the raw equity figure as your worksheet’s opening line, not your conclusion. The next step applies the LTV cap that turns this paper number into something closer to real.
Step 4: Apply the correct LTV cap to find usable equity
This is the step that separates a real worksheet from a rough guess, and it’s where your loan type from Step 1 finally matters.
Conventional cash-out refinances are capped at a maximum of 90% loan-to-value under current Fannie Mae guidelines as of 2026. VA cash-out refinances, by contrast, allow eligible veterans and service members to borrow up to 100% loan-to-value per VA.gov’s cash-out loan guidance. That gap between 90% and 100% is not a rounding difference. On a $450,000 home, it’s the difference between a $405,000 maximum new loan and a $450,000 maximum new loan, a $45,000 swing in usable equity for otherwise identical numbers.
Here’s the worked math for the conventional scenario. On a $450,000 home value, 90% LTV allows a maximum new loan amount of $405,000. Subtract the existing $310,000 balance, and you’re left with $95,000 in usable equity before any costs are factored in. That’s already $45,000 less than the $140,000 raw equity figure from Step 3, purely because of the LTV ceiling.
If this same homeowner were an eligible veteran using a VA cash-out refinance, the math shifts: 100% of $450,000 is the full value, minus the $310,000 balance, for $140,000 in usable equity before costs, the full raw equity amount. That’s a meaningful reason VA-eligible borrowers should always run both scenarios rather than assuming conventional limits apply to them.
Write both figures, or whichever applies to your loan type, as the next line on your worksheet. This is your true usable-equity ceiling before the cost adjustments in Step 5.
Step 5: Subtract closing costs and reserves for your real number
Usable equity before costs is still not your real number. Closing costs on a cash-out refinance typically run 2% to 4% of the new loan amount, covering the appraisal, title work, lender fees, and prepaid items like escrow setup. On a $405,000 new loan, that’s a range of roughly $8,100 to $16,200. Don’t assume no-out-of-pocket closing options apply automatically. Rolling costs into the loan is possible in many cases, but it either increases your loan amount or reduces the equity you actually walk away with, so it belongs on the worksheet either way.
There’s a second deduction many homeowners miss: lenders often require you to retain a minimum equity cushion after closing, particularly on investment properties or second homes where the risk profile is higher. That cushion might mean the lender won’t let you draw all the way to the 90% or 100% ceiling calculated in Step 4, even if you technically qualify on paper. Ask your loan officer directly what post-closing equity requirement applies to your specific property type before you finalize your worksheet number.
Continuing the Henrico County example: $95,000 in usable equity before costs, minus an estimated $14,000 in closing costs (roughly 3.5% of the $405,000 new loan), leaves approximately $81,000 in realistic cash-in-hand equity. That’s the number that should drive your planning, not the $140,000 raw equity figure from Step 3 and not even the $95,000 pre-cost figure from Step 4.
This final subtraction step is what makes this worksheet fundamentally different from a plug-and-play online calculator. Those tools rarely account for closing costs or cushion requirements, which is exactly why they routinely overstate what a homeowner can actually access.
Step 6: Compare your worksheet number against a HELOC
A cash-out refinance and a home equity line of credit draw against the same usable-equity ceiling you just calculated, but they get you there in structurally different ways. A cash-out refinance replaces your entire first mortgage with a new, larger one at a new rate, meaning your existing rate disappears entirely, whether that’s good or bad news depends on where your current rate sits relative to today’s market. A HELOC, by contrast, sits on top of your existing first mortgage as a second lien, letting you draw only what you need against your equity ceiling while your original rate and balance stay untouched.
Run your worksheet twice to see which structure actually makes financial sense:
- Scenario one, full cash-out refinance: calculate the new monthly payment on a $405,000 loan at today’s conventional rate, and compare that to your current payment on the $310,000 balance.
- Scenario two, HELOC layered on top: keep your existing mortgage payment as-is, and add a second monthly payment based on however much of your $81,000 usable equity you actually plan to draw, at current HELOC rates.
The right answer depends heavily on where your current first-mortgage rate sits relative to today’s market. If your existing rate is meaningfully below current 30-year fixed averages as reported in Freddie Mac’s Primary Mortgage Market Survey, a full cash-out refinance means giving up that below-market rate on your entire balance just to access a portion of your equity, which often makes a HELOC the more efficient tool. If your current rate is above today’s market, a cash-out refinance can actually lower your overall payment while still putting equity in your hand, making it the stronger option on both fronts.
Rates move weekly, so pull a current PMMS figure before finalizing this comparison rather than relying on a number from a few months back.
Step 7: Run the break-even math and get a soft-pull pre-qualification
Before committing to either path, calculate your break-even month: divide your total estimated closing costs by your monthly savings, or by the monthly cost of accessing the cash if you’re comparing a HELOC draw. If your closing costs land around $14,000 and the new structure saves or costs you $180 a month relative to your current situation, that’s roughly a 78-month break-even. Whether that timeline works depends on how long you plan to stay in the home, a question worth answering honestly before you sign anything.
Once your worksheet is complete, the next move is confirming it against real underwriting numbers rather than continuing to work from estimates. A soft-pull pre-qualification with Duane Buziak, NMLS #1110647, checks your worksheet figures against actual rate sheets and loan program guidelines without a hard credit inquiry, so there’s no credit impact from finding out where you really stand.
Bring your completed worksheet, balance, value estimate, LTV cap, cost estimate, and break-even month, into that conversation. Starting from real math rather than a rough online estimate means the discussion moves faster and the numbers you hear back are grounded in what you already calculated, not a surprise in either direction.
What Happens After the Worksheet
With your worksheet complete, the next step is verifying these numbers against current rates and your actual credit profile through a no-impact soft-pull pre-qualification. That conversation will confirm whether your defensible value estimate holds up, whether your loan type qualifies for the LTV ceiling you calculated, and whether the break-even math still favors moving forward once real rate quotes replace estimates.
Call (804) 212-8663 now for your free soft-pull rate analysis, no credit impact, no obligation, and find out if refinancing can lower your monthly payments or unlock your home’s equity.
One Response