Real Estate Deal Underwriting Step by Step: A 2026 Investor's Framework

Published 2026-04-16 by Home Pros | Last updated 2026-04-16

Real estate fund analyst underwriting an investment property deal using a laptop spreadsheet with ARV and cash flow projections

Every deal you lose money on started with an underwriting mistake. Not a market mistake, not a contractor mistake, not bad luck. An underwriting mistake. Either you were optimistic where you should have been conservative, or you didn't ask the question the deal was quietly begging you to ask. That's why real estate deal underwriting step by step matters more than any other skill in this business.

This is the framework our team uses internally and the one we see institutional buyers run on the Home Pros platform. It works for flips, BRRRRs, rentals, and small commercial. The tools change, but the logic doesn't.

What Underwriting Actually Is

Underwriting is the analytical process that turns "this looks interesting" into "here's my offer and here's what I need to be true for it to work." It's not a vibe check. It's a structured set of inputs (comps, rehab, financing, hold costs, exit assumptions) run through a model that produces a clear output: offer price, projected return, and walk-away triggers.

The Investopedia definition of underwriting frames it as risk assessment, and that's exactly right. You're pricing risk. Every assumption you make is either bearing risk accurately or hiding it.

The Eight-Step Underwriting Sequence

Real estate deal underwriting step by step looks like this. Skip a step and you're flying blind.

  1. Build your comp set and lock down ARV
  2. Scope the rehab and price it
  3. Choose the exit (flip, BRRRR, hold)
  4. Model financing costs including carry
  5. Compute the return for the chosen exit
  6. Run sensitivity analysis on the two or three most fragile inputs
  7. Apply risk adjustments and define walk-away triggers
  8. Set your offer

Let's walk through each step with real numbers.

Step 1: Comps and ARV

ARV is the number your entire underwriting hangs from. Get it wrong and nothing else matters. For a deep dive on methodology, our guide to how to calculate ARV for investment properties in 2026 covers the full process. The short version:

Always carry two ARV numbers: your expected ARV and a conservative ARV (5-7% lower). Use the conservative number as your underwriting base. If the deal works at the conservative number, any upside on exit is bonus.

Step 2: Rehab Estimate

This is the second biggest assumption. If you haven't read our full guide on how to estimate rehab costs for investment properties, start there. In underwriting, the key rules are:

Step 3: Pick the Exit First, Then Underwrite to It

Too many investors model both flip and rental and pick whichever gives the better number. That's backwards. The exit drives the entire underwriting. A property that works as a flip might be a losing rental, and vice versa.

Flip exit: you're selling retail within 6-12 months. Focus on ARV, gross profit after commissions, and days-on-market risk.

BRRRR exit: you're rehabbing, renting, refinancing, and holding. Focus on all-in cost versus ARV (to maximize refinance pull), stabilized rent, and long-term cash flow.

Long-term rental exit: you're holding for cash flow and appreciation. Focus on cap rate, cash-on-cash, DSCR, and rent-to-price ratio.

Pick one and commit. You can always switch later if conditions change, but the underwriting needs to target a specific strategy.

Step 4: Financing and Carry

In 2026, with 30-year conventional rates hovering in the mid-6s and hard money still pricing 10-12% for most operators, financing costs are a meaningful line. Data from the Federal Reserve H.15 release and the Mortgage Bankers Association both reflect this ongoing elevated-rate environment. Your underwriting has to reflect it too.

Model these line items explicitly:

A common miss: assuming a three-month rehab when your last four projects averaged five. Underwrite your actual timeline, not your aspirational one.

Step 5: Compute the Return

Flip Return

Gross profit = ARV - purchase price - rehab - financing costs - selling costs. Net-margin percentage = gross profit ÷ ARV. A healthy flip hits 12-18% net margin. Below 10%, the deal is too fragile.

BRRRR Return

Two numbers matter: capital left in after refinance (purchase + rehab + closing - refinance proceeds) and cash-on-cash return on that remaining capital. A true BRRRR pulls 90-100% of capital back and still cash-flows. A partial BRRRR leaves some equity in but produces strong returns on a smaller denominator.

Rental Return

Three metrics:

Cap rate and cash-on-cash answer different questions. Cap rate says "is this property priced well." Cash-on-cash says "given my debt terms, does this deal pay me." You need both.

Step 6: Sensitivity Analysis

This is the step most investors skip. Run your model again with:

If the deal still hits your minimum return under all four shocks, it's a real deal. If two out of four break it, you've got a thin deal. If one shock blows it up, walk away.

Step 7: Risk Adjustments and Walk-Away Triggers

Before you submit the offer, define the conditions under which you'd kill the deal. Writing them down in advance prevents emotional commitment from carrying you past the exit ramp.

Example walk-away triggers:

Put these in writing before inspection. Future-you will thank present-you.

Step 8: Set Your Offer

Your offer is the output of the process, not the input. For flips, most operators anchor to the 70 percent rule (max offer = 70% ARV - rehab). For BRRRRs, you reverse-engineer from target refinance proceeds. For rentals, you work from required cap rate or cash-on-cash.

Whatever the model, your offer needs to survive sensitivity analysis and respect your walk-away triggers.

A Sample Deal Walk-Through

Let's run a real underwriting end-to-end. Subject: 1,600 sq ft, 3/2, built 1985, Southeast suburb.

Step 1 - ARV: Five comps average $275,000. Conservative ARV: $260,000.

Step 2 - Rehab: Standard scope. Hard costs $72,000. Contingency at 15% = $10,800. Rehab budget: $82,800.

Step 3 - Exit: BRRRR. Rent comps support $2,150/mo.

Step 4 - Financing: Hard money at 11%, 2 points. Purchase loan of $160,000, rehab loan of $82,800. Interest carry over 5 months = roughly $10,800. Refinance at stabilization into a 30-year DSCR loan at 7.1%, 75% LTV on appraised value.

Step 5 - Returns:

Verdict: At $155,000, this deal does not work. DSCR fails and cash-on-cash is weak. Back into the required numbers: to hit 1.25 DSCR you need refinance debt of roughly $170,000, which means ARV needs to appraise higher or you need to buy cheaper.

Re-underwrite at $140,000 offer: all-in drops to $245,100, refinance pulls $183,750, capital left in drops to $61,350, DSCR improves to 1.17 (still short), cash-on-cash improves to 4.5%.

Re-underwrite at $128,000 offer: all-in is $233,100, refinance pulls $174,825, capital in is $58,275, DSCR hits 1.23, cash-on-cash clears 8%. Now it works.

That's the whole point of real estate deal underwriting step by step. The model tells you what the offer needs to be. You don't argue with it.

Common Underwriting Mistakes

Patterns we see on deals that blow up:

Deeper reading on portfolio-level risk sits in NREIA's investor education library and Forbes Real Estate for market context.

Spreadsheet or Software

Honest answer: both, in sequence. Start with a spreadsheet. Build it yourself. You'll understand the levers because you wired them. Once you're running 20+ deals per month or need investor-grade reporting, move to dedicated tools. The trap is skipping the spreadsheet phase and using a black-box tool that spits out an IRR you can't explain to a partner or lender.

Frequently Asked Questions

What is underwriting in real estate?

Underwriting is the process of analyzing a potential real estate deal to determine whether it meets your return and risk criteria. It combines comp analysis, rehab estimation, financing cost modeling, exit strategy, and risk adjustments into a single go/no-go decision. In institutional investing, the same term covers the detailed financial model built before committing capital.

How long should deal underwriting take?

A quick screen takes 10-15 minutes. A full underwriting on a flip runs 1-3 hours once you have comps, rehab estimate, and financing terms. A BRRRR or long-term rental underwriting typically takes 2-4 hours because you're also modeling cash flow, refinance, and hold-period returns. Institutional deals with partners or debt covenants can take several days.

What's the difference between underwriting a flip vs a rental?

Flip underwriting focuses on ARV, rehab, holding cost, and exit profit within 6-12 months. Rental underwriting focuses on stabilized NOI, cap rate, cash-on-cash return, debt coverage ratio, and long-term appreciation. Flips care about one number (net profit at sale). Rentals care about monthly cash flow, refinance outcomes, and total return over a multi-year hold.

What metrics matter most when underwriting a BRRRR deal?

The three that matter most are all-in cost versus ARV (to measure whether you can pull most or all of your capital back on refinance), stabilized cash-on-cash return after refinance, and debt service coverage ratio. If your all-in is 75% or less of ARV, cash-on-cash clears 8-10%, and DSCR is above 1.2, the deal generally works.

What are the biggest underwriting mistakes?

The most common mistakes are overly optimistic ARV, understated rehab, ignoring holding and interest carry, using outdated cap rates, assuming 0% vacancy on rentals, and forgetting selling costs at exit. Investors also commonly skip sensitivity analysis, which means they don't know what their return looks like if ARV comes in 5% low or rehab runs 15% over.

Should you use a spreadsheet or software for underwriting?

Use a spreadsheet when you're learning the mechanics and doing fewer than 10 deals per month. Move to software when volume, investor reporting, or portfolio analytics become the bottleneck. The worst underwriting is a black-box tool that spits out an IRR without showing you the inputs. Always be able to audit your own assumptions line by line.

Closing Thought

Real estate deal underwriting step by step is not a magic formula. It's disciplined skepticism applied in a consistent order. Comps, rehab, exit, financing, return, sensitivity, risk, offer. Run that loop on every deal, carry conservative numbers, and define your walk-away triggers before you fall in love. The investors who do this consistently are the ones who are still in business in five years.

See real deals with this framework applied. Join the Home Pros Marketplace to access institutional-quality inventory across 48 markets with verified comps and rehab data ready to plug into your underwriting model. For market-specific applications, see our Charlotte market data, Cleveland BRRRR numbers, and how wholesale contract assignments fit into the acquisition workflow.