Most models do not fail because the business is weak. They fail because nobody built them to survive questioning. And the first question is always the same: where does the revenue come from?
Of the last 30 models sent to us for review, 21 built revenue top-down from market size: the market is $4 billion, we take one per cent, so revenue is $40 million. It is arithmetic, and it answers a question no investor asked.
15 of the 30 had a hardcoded figure inside a formula cell. Most had no headcount plan tied to revenue at all — the plan could grow sales without hiring anyone to sell.
| What we found | Models |
|---|---|
| Revenue built top-down from market size | 21 of 30 |
| Hardcoded figure hidden inside a formula | 15 of 30 |
| No headcount plan linked to revenue | Most |
| Runway shorter than the founder believed | 2 to 3 months |
Why investors distrust it immediately
A top-down number tells an investor what you hope for. A bottom-up number tells them what has to happen. Only the second is testable, and testable is the whole point.
One per cent of a market tells an investor the next three questions will not be answerable: how many customers, at what price, sold by how many people, closing at what rate. Then the conversation is about the file, not the business.
Founders who can walk an investor through their own assumptions close faster than founders who outsourced the thinking.
What to build instead
Build revenue from the smallest unit you actually control, then multiply upward. For most companies that is one of three things:
- Volume and price. Units sold per month, at a stated price, with the mix visible.
- Cohorts. Customers acquired per month, retained on a stated curve, spending a stated amount.
- Capacity. Sales people or delivery capacity, with a quota and a ramp period per person.
Then connect the cost of getting there. If revenue rises, something has to hire, spend or ship. Revenue that grows while headcount does not says nobody has thought about delivery.
The runway consequence
When we rebuild a model bottom-up, the runway date usually moves earlier by two to three months. Not pessimism: top-down revenue arrives sooner than sold revenue does, and the original plan assumed the optimistic timing.
Two to three months is often the difference between raising from choice and raising from need. Better to know before you set the timetable.
How to check your own model this week
- Find your first revenue month and ask what physically has to happen for that number to occur.
- Search the file for constants inside formulas. Every one is a decision nobody recorded.
- Check that hiring is driven by the plan rather than typed in beside it.
- Move your best assumption down 20% and see whether the story survives. If it does not, that is the assumption to defend.
None of this needs a rebuild to test. It needs an hour and a willingness to find something you would rather not — cheaper than an investor finding it.