Why Most Investors Never Look Inside Their Underwriting Model—And Why It's Costing Them Six Figures

You built a model. It says the deal returns 18% IRR. You trust it. You bid. You win.
Then, six months in, the numbers don't match reality. Neither does your confidence.

The problem isn't the model. The problem is you've never actually looked inside it.

The Black Box Problem

Most investors treat their underwriting spreadsheet like a black box. Plug in some numbers. Wait for the output. Done.
They don't know which assumptions are moving the needle. They don't know if a 50 basis point rent miss kills the deal or barely scratches it. They don't know if their model is even internally consistent.

They build a spreadsheet, but they never actually read it.

That's how you end up confident in a deal that falls apart at first stress test.
That's how you bid on something that looks good in isolation but collapses when the market moves half a percent.

Know Your Model Before Anyone Else Does

The discipline is simple: you need to know your model inside out before you ever show it to a lender, a partner, or a seller.

That means running sensitivity tables on every major input—rent growth, expense ratios, exit cap rates, hold period—and watching how each one moves your IRR and equity multiple.
Change one assumption at a time. Watch what breaks and what doesn't. When rent stays flat instead of growing 2.5% annually, which line item gets hit hardest? How many months does that buy you before the deal underwater?

It also means asking yourself the stress-test question: "If everything else is perfect but this one thing goes wrong, do I still make money?"
If the answer is no, you don't have a deal. You have a hope.

The investors who actually make money don't build models that predict a single rosy outcome. They build models that survive a bad one.

Your Model Is a Stress-Testing Machine, Not a Prediction Machine

Here's the reframe: your model isn't trying to predict the future. Nobody can.
Its real job is to show you exactly how much pain the deal can take before it doesn't work.

A deal that survives a bad case gives you certainty. A deal that only works if everything goes perfectly gives you a problem masquerading as confidence.

Once you understand the inner mechanics of your model—which levers move the needle, which assumptions are load-bearing—you'll know whether you're looking at an 18% IRR deal or an 18% IRR fantasy.

That distinction is worth six figures.

Where to Start

Open your last model. Pick one major assumption—rent growth, expense ratio, exit cap rate, whatever.
Change it by one standard deviation down (rent grows 1% instead of 2.5%). Watch what happens to your IRR. Write it down.

Do that for five major assumptions. That takes 30 minutes.
Now you know which assumptions can move without breaking the deal and which ones are load-bearing.

That's the start of understanding your model instead of trusting it blindly.

When you're ready to build models that actually stand up to pressure, the Free Underwriting Masterclass walks you through exactly how we structure sensitivity analysis and stress testing for multifamily deals. It's the foundation most investors skip.

© 2026 Ironclad Underwriting · ironcladunderwriting.com · info@ironcladunderwriting.com · (940) 247-0204

By Jason L. Williams, Ph.D.