<aside> 💡
Where TAM/SAM/SOM gives you the macro view, this template helps you build a bottom-up market sizing model from unit economics.
Bottom-Up Market Sizing and ARR Milestone Model
Most founders size their market from the top down - find a big industry report, take 1% and call it a plan. This prompt does the opposite.
By grounding your market sizing in your actual unit economics - your contract value, churn rate, expansion revenue, and sales cycle - it builds a model that connects directly to how your business actually grows. Rather than just calculating a market size number, you achieve a clear answer to the question every founder and investor really wants answered: how many customers do I actually need, and is that realistic?
Key inputs: your product and pricing model, average contract value, churn rate, expansion revenue assumptions, sales cycle length, ICP, and your addressable segment size.
What you get out:
The difference between this and a spreadsheet someone built in an afternoon is the assumptions log and the validation action list. Those two outputs alone will save you from building a go-to-market strategy on numbers that have never been stress-tested.
Want AI to do it for you?
Run the Bottom Up Market SIzing Model Prompt at the bottom of this page to generate a first draft for you.
</aside>
| Milestone | Active Customers Needed | Total Acquisitions Needed | Monthly New Customers Required | Implied Penetration of SAM | Time-to-Milestone Estimate |
|---|---|---|---|---|---|
| $1M ARR | |||||
| $5M ARR | |||||
| $10M ARR |
| Variable | Base Case | Optimistic (−20%) | Pessimistic (+20%) | Impact on Milestone |
|---|---|---|---|---|
| [Variable 1] | ||||
| [Variable 2] | ||||
| [Variable 3] |