← All posts

Investors  ·   ·  6 min read

Stress-Testing the Pro Forma: The Questions I Ask Before I Believe a Deal's Numbers

Every deal I'm shown arrives with a spreadsheet that works. My job is to find the version of the spreadsheet that doesn't.

Zay Hampton seated aboard a private jet

I have never been shown a deal with a bad spreadsheet. Land, new construction, an acquisition, a private lending opportunity. Whatever it is, the projections almost always look clean, the returns look attractive and the timeline looks tidy. That's not because everyone is dishonest. It's because a pro forma is a story about the future, and people tend to tell the version of the story they hope comes true.

Over time I've learned that my real job when I review a deal isn't to admire the model. It's to stress it. I want to find the assumptions doing the heavy lifting and see what happens when they bend.

This is how I personally approach it. It's education from my own experience, not financial, legal or tax advice. Nothing here is an offer of securities, a solicitation or a promise of any return, and every real decision should involve your own qualified advisors.

Separate the facts from the hopes

The first thing I do with any pro forma is split every number into one of two buckets. Facts are things that already exist and can be verified: the purchase price under contract, current taxes, existing leases, quotes in hand. Assumptions are everything else: future sale prices, rents, absorption, construction costs, financing terms a year from now.

It's usually eye-opening. On a lot of deals, the facts bucket is small and the assumptions bucket carries almost all of the projected upside. That doesn't make it a bad deal. It tells me exactly where to spend my time.

Find the one number that matters most

Most models have one or two assumptions that drive nearly everything. In a land or subdivision conversation, it might be the price per finished lot or how quickly lots sell. In new construction, it's often the exit price and the build cost. In a business acquisition, it's usually whether the revenue the seller shows is truly repeatable.

I ask a simple question: if I could only verify one number in this model, which one would I pick? Then I go verify it as hard as I can. Comparable sales, conversations with builders and brokers, current cost quotes, the seller's actual records. I wrote about the broader process in due diligence questions for a land deal and verify before you trust.

Run the downside cases, not just the base case

A pro forma usually shows one scenario. I want at least three:

  • Base case. What the sponsor or seller projects.
  • Slow case. Everything takes longer. Permits, construction, sales, lease-up. Same prices, more time.
  • Hard case. Things take longer and cost more, and the exit comes in lower than hoped.

The question isn't whether the hard case looks good. It won't. The question is whether the deal survives it. Can the debt still be serviced? Do the partners still get their capital back, even if the profit disappears? Is there a point where someone has to come up with more money, and who would that be? If the base case only works when everything goes right, I'm not looking at an investment. I'm looking at a bet.

Time is the assumption people forget

In my experience, the most underestimated variable in almost every deal is time. Projections tend to assume things happen on schedule. Real projects rarely do. Approvals stall, contractors get busy, markets slow and buyers take longer to decide.

Time costs money even when nothing else changes. Interest keeps accruing, taxes and insurance keep coming due, and capital that's tied up can't be used elsewhere. I wrote about why land in particular rewards patience in patient capital, but patience only works if the deal was built to afford a longer clock. I want to see what a six- or twelve-month delay does to the numbers before I ever get excited.

Costs only move one direction in a model

When I look at cost lines, I pay attention to how they were built. Is the construction budget a real bid or an estimate from a while ago? Is there a contingency, and is it realistic? Are soft costs like permits, engineering, legal and financing fees fully included? Small gaps in these categories add up quickly.

Who is building matters as much as the budget. A reliable builder with a track record changes the risk of the whole project, which is why I spent a full post on choosing a builder.

Follow the money, in order

A projected return means very little until I understand who gets paid and in what order. Lenders, preferred positions, sponsor fees, promotes and splits all affect what any one party actually receives. Two deals with the same headline projection can deliver very different results depending on the structure. I break that down in who gets paid first.

I also look at how the sponsor is paid. When fees are earned up front regardless of outcome, incentives can drift. When the sponsor only does well if the partners do well, I pay closer attention in a good way.

What a good pro forma conversation sounds like

The best operators I've worked with don't get defensive when I push on their numbers. They've already run the downside. They can tell me which assumptions they're least sure about and what they'll do if those miss. That kind of honesty builds more trust than any projection.

When the answers are vague, when every question gets met with "the market is strong" or "we've never had a problem," I slow down. And sometimes I walk away entirely. I've learned to be comfortable with that, which I wrote about in walking away from deals.

Preparation goes both ways

Stress-testing isn't just something I do to other people's deals. When I bring a partner into a conversation, I want my own numbers to hold up to the same scrutiny. That's part of the investment readiness I expect from myself before any partnership call.

A spreadsheet will always tell you what you want to hear if you let it. The discipline is making it tell you what could go wrong, and then deciding, with clear eyes, whether the opportunity is still worth it. That's the habit I try to build in every investor and operator I mentor, and it's the one I trust most in my own decisions.

← Back to the blogZayhampton.com home