Fund managers don't underwrite differently because they have better data. They underwrite differently because they have a standard — a repeatable process that applies the same analytical lens to every deal, regardless of who the operator is or how compelling the pitch deck looks.
That standard is not proprietary. You can apply it.
First, the Right Metric: IRR, Not Cash-on-Cash
If you are evaluating real estate deals primarily on cash-on-cash return, you are optimizing for the wrong variable.
Cash-on-cash is useful. It tells you how much annual cash flow you're generating relative to the equity you've deployed. For a buy-and-hold investor who never plans to sell, it captures most of what matters.
But most serious investors are not buy-and-hold investors who never plan to sell. They're capital allocators building a return profile across a portfolio with an exit horizon in mind. For those investors, cash-on-cash is one input — not the decision metric.
Internal Rate of Return is the annualized return on all cash flows across the entire hold period, including the exit. It weights the timing of cash flows — a dollar returned in year two is worth more than a dollar returned in year seven — and captures the full economics of the investment.
A deal with an 8% cash-on-cash and a 7-year hold might have a lower IRR than a deal with a 5% cash-on-cash and a 4-year hold — if the exit value on the second deal is significantly stronger. Cash-on-cash alone leads you to the wrong choice.
The real value of IRR shows up when you're comparing deals across different hold periods and exit scenarios. An operator projecting a 14% IRR over 5 years and an operator projecting a 10% cash-on-cash over an indefinite hold are not giving you comparable numbers.
The 5-Step Institutional Checklist
Step 1: Verify NOI Independently
The first number to check is Net Operating Income, and you shouldn't start with the operator's figure. Start with the rent roll.
Take occupied units, multiply by average current rent, add other income (parking, storage, pet fees). That's gross rent. Subtract actual vacancy — not the pro forma vacancy, the current occupancy from the rent roll. Subtract operating expenses using reported actuals, not the operator's projection.
If your NOI calculation matches the operator's within 5%, the underwriting is probably clean. If there's a 10–15% divergence, find out where it comes from before proceeding.
Step 2: Run Vacancy Stress (+10 Points)
Take the operator's vacancy assumption and add 10 percentage points. If the pro forma assumes 5% vacancy, run the model at 15%.
What does that do to NOI? What does that do to debt service coverage? Does the deal still cash flow?
If adding 10 points of vacancy turns a cash-flowing deal into a negative DSCR scenario, the deal is priced to perfection on occupancy. That's not disqualifying — but it's a risk you're buying that needs to be priced in.
This is NOI sensitivity testing. Three inputs can move: gross rent, vacancy, operating expenses. Reduce gross rent by 5%, increase vacancy by 8 points, increase OpEx by 10%. If NOI has to stay within 3% of projection for the deal to work, the underwriting has almost no room for error. If the deal still cash flows at 20% NOI compression, the structure is meaningfully more robust.
Step 3: Anchor Cap Rate to Submarket Comps + Stress Expansion
The cap rate in the offering memorandum is a single data point from a motivated seller. It is not a market rate.
Pull comparable sales in the same submarket from the past 12–18 months. What cap rates did comparable assets actually trade at? Is the operator's asking cap rate consistent with those comps, or at the low end of the range — meaning the seller is pricing for peak conditions?
For the exit cap rate assumption, the work doesn't stop at "anchor to comps." Take the operator's projected exit cap rate. Add 50 basis points. Recalculate the terminal value. What happens to IRR?
At typical leverage ratios, a 50 bps cap rate expansion at exit reduces IRR by 2–4 percentage points. A 100 bps expansion can cut projected IRR roughly in half on a 5-year hold. If the deal's investment thesis requires cap rates to stay flat or compress to generate the advertised return, the thesis is a market-timing bet — a different risk profile than the operator may be communicating.
Apply a 25–50 basis point premium to current market comps in your exit assumption by default. Markets don't compress on a straight line. The exit assumption should carry conservatism, not optimism.
Step 4: Check IRR Across Hold Periods + DSCR Buffer
Most operators present one IRR figure on one assumed hold period (typically 5 years). Before committing, run the model at 4 years and at 7 years.
If the 4-year IRR is materially lower, you need to be confident in the 5-year exit assumption. What market conditions are required for that exit to happen on schedule? What happens if the market is soft at year 5 and the hold extends to year 7?
If the 7-year IRR is still acceptable, the deal has a margin of safety on hold period. If the 7-year IRR drops below your minimum threshold, the deal only works if the timeline is met.
Pair this with DSCR buffer analysis. A deal underwritten at 1.25x DSCR with floating rate debt in a rate-volatile environment has different risk exposure than a deal at 1.4x DSCR on fixed debt. The question isn't just "does this deal currently cash flow?" — it's "at what point does NOI decline cause a covenant breach or force a capital call?"
Step 5: Run Scenario A and Scenario B
Run the full model twice.
Scenario A (rates ease): Cap rates compress 25–50 bps over the hold period. Refi availability improves. Exit at year 5 at current or better terms. This is the constructive case — roughly consistent with a late-2026 / 2027 rate environment if easing continues.
Scenario B (rates flat): Cap rates hold. Refi terms stay similar to today. Exit at year 5 requires selling into the same cap rate environment you bought into. Return is driven almost entirely by NOI growth, not compression.
If Scenario B still generates IRR above your minimum threshold, the deal doesn't require a macro tailwind to work. That's a materially different risk profile than a deal that only generates adequate return in Scenario A.
Why Retail Investors Skip This
Retail investors skip stress testing for a simple reason: the operator's offering memorandum doesn't present it. The OM shows the base case. Stress scenarios, if they exist, are in an appendix that most retail investors don't read.
Institutional investors model their own stress cases independently of the operator's presentation. The OM is a starting point, not a conclusion.
The number that retail investors chase is gross return. The number that institutional investors evaluate is risk-adjusted return. The difference between those two metrics explains why most retail real estate investors underperform over time, and why most institutional investors don't.
What This Process Produces
Running this 5-step framework takes 2–3 hours on a new deal. It requires nothing beyond a spreadsheet, the rent roll, a submarket comp search, and the offering memorandum.
What it produces is a clear answer to the question most retail investors never formally ask: what is the range of outcomes this deal can generate, and which outcomes require which assumptions to hold?
That's how a fund underwrites. That's the standard.
ProperLocating's Role
ProperLocating applies this framework to every deal before it reaches investors. The underwriting package is available for review: NOI reconciliation, vacancy stress test, comp-anchored cap rate analysis, IRR across hold periods, and scenario models across A and B.
You don't need to build the model from scratch on every deal. You do need to be asking for it.
If a deal memo doesn't include IRR projections with clearly stated hold period and exit cap assumptions, ask for them before proceeding. If the operator can't produce scenario analysis, model your own downside case before committing. Hobbyists evaluate deals on the return the operator tells them they'll earn. Professionals evaluate deals on the return they can independently verify under multiple scenarios.