Market Sizing Template: A Proven Framework to Estimate Any Market

Knowing the top-down and bottom-up methods is one thing. Having an actual worksheet that walks you through both, side by side, so you can fill in your specific numbers, is what turns methodology into something you can use this afternoon.

Quick Answer

• This template has 4 parts: a top-down worksheet, a bottom-up worksheet, a TAM/SAM/SOM summary, and a cross-check section
• For the underlying methodology and reasoning, see market size calculation
• Fill in both worksheets independently, then compare results in the cross-check section
• The template forces the discipline that actually matters: sourcing every filter and assumption explicitly, not just landing on a number
• Works for any market, adjust the specific filters and inputs to your own category and business

Introduction

Most market sizing advice explains the concept and leaves the actual worksheet up to you. This template does the opposite: a genuine, fill-in-the-blank structure covering both methods, a summary layer connecting them to TAM, SAM, and SOM, and a built-in cross-check step, ready to use for any market you're actually trying to size.

This guide covers:

• The complete 4-part template
• A fully worked example, filled out with real numbers
• Common mistakes when using a template like this
• How to adapt it to your specific market

Why a Market Sizing Template Matters

• A template forces explicit assumptions. Filling in a specific line for each filter or input prevents the vague, unsourced estimation that undermines most market size claims.
• Consistency makes the calculation defensible. A structured worksheet is easier to walk someone else through than an ad hoc, unstructured calculation.
• It saves real time on repeat use. Once built, the same structure works for sizing a new segment, a new geography, or a new product line.
• This is exactly the kind of practical, downloadable resource that gets used, per your own note, rather than read once and forgotten.

What Is a Market Sizing Template?

A market sizing template is a structured, fill-in-the-blank worksheet guiding a user through both top-down and bottom-up market size calculation, culminating in a TAM/SAM/SOM summary and a cross-check step, designed to produce a defensible, sourced estimate rather than an ad hoc guess.

The Complete Market Sizing Template

Part 1: Top-Down Worksheet

• Total industry size (source): ______ (cite the specific report or database)
• Relevant segment filter: % →
• Geographic filter: % →
• Additional relevant filter (customer type, price tier, etc.): % →
• Resulting top-down estimate: ______

Part 2: Bottom-Up Worksheet

• Realistic potential customer count in target segment: ______
• Source of customer count (database, discovery interviews, census data): ______
• Average annual revenue per customer: ______
• Resulting bottom-up estimate (customers × revenue): ______

Part 3: TAM / SAM / SOM Summary

• TAM (broadest figure, typically top-down): ______
• SAM (portion your business model can realistically serve): ______
• SOM (portion realistically obtainable given resources and competition): ______
• Basis for SOM estimate (realistic acquisition capacity, sales cycle, go-to-market plan): ______

Part 4: Cross-Check

• Top-down estimate: ______
• Bottom-up estimate: ______
• Do they roughly converge? Yes / No
• If no, what explains the gap? ______ (overly generous top-down filters, underestimated customer count, etc.)

A Fully Worked Example

Top-Down:

• Total industry size: 50 billion (source: industry trade report)
• Segment filter: 20% → 10 billion
• Geographic filter: 15% → 1.5 billion
• Resulting top-down estimate: 1.5 billion

Bottom-Up:

• Realistic customer count: 50,000 (source: B2B firmographic database)
• Average annual revenue per customer: 1,200
• Resulting bottom-up estimate: 60 million

TAM/SAM/SOM Summary:

• TAM: 1.5 billion
• SAM: 300 million (the geography and segment your business model can actually serve)
• SOM: 60 million (based on realistic first-2-years acquisition capacity, matching the bottom-up figure)

Cross-Check:

• SOM (60 million) and the bottom-up estimate (60 million) converge closely, since both were built from the same realistic customer count and pricing assumption, giving genuine confidence in the resulting SOM figure specifically

Comparison: What Each Part of the Template Produces

Top-Down Worksheet

• Produces: A broad, source-grounded TAM figure
• Best cross-check target: Bottom-up SOM

Bottom-Up Worksheet

• Produces: A grounded, realistic SOM estimate
• Best cross-check target: Top-down SAM or SOM

TAM/SAM/SOM Summary

• Produces: Three genuinely distinct planning numbers
• Best cross-check target: Internal consistency across all three

Cross-Check Section

• Produces: A confidence signal or a flagged gap
• Best cross-check target: The template's actual purpose

Real Examples

• Template used for a new segment: a team reuses the same worksheet structure to size a new customer segment within an existing category, filling in new filters and a new bottom-up customer count without rebuilding the framework from scratch
• Cross-check catching a gap: a team's top-down and bottom-up estimates diverge significantly using the template, prompting a specific review of whether the top-down filters were too generous or the bottom-up customer count too conservative
• Template used for a new geography: the same structure gets reused for a market expansion into a new region, with the geographic filter and customer count fields updated for the new target market
• Template revealing a missing source: filling in the "source" field for a top-down filter forces a team to realize a key assumption was never actually sourced, prompting a quick fix before the estimate goes into a real pitch

Common Mistakes When Using a Market Sizing Template

• Leaving the source fields blank. A number without a cited source undermines the whole point of using a structured template in the first place.
• Skipping the cross-check section. Filling out both worksheets without comparing them wastes the template's most valuable built-in discipline.
• Treating the template as rigid rather than adaptable. Add or remove filter rows as your specific market actually requires; the structure is a starting point, not a fixed formula.
• Never reusing the template for future sizing needs. Once built, the same structure saves real time on the next market, segment, or geography you need to size.

Adapting the Template to Different Scenarios

• Sizing a brand-new category with no existing industry report: rely more heavily on the bottom-up worksheet, substituting discovery interviews for a missing top-down data source, and note the gap explicitly in the cross-check section
• Sizing an expansion into a new geography: duplicate the template with the geographic filter and customer count updated specifically for the new region, keeping the original market's template as a reference point
• Sizing a B2B market with account-level data available: strengthen the bottom-up worksheet using a real firmographic database for the customer count field, rather than an estimate
• Sizing for an investor pitch specifically: pay particular attention to sourcing every top-down filter clearly and grounding SOM directly in a realistic, explainable go-to-market plan, since both are exactly what a skeptical investor will test first

PulseAI Research Insight

A good template forces the discipline that actually matters, sourced assumptions and a genuine cross-check, rather than a number that just looks confident.

PulseAI Research supports every part of this template with real data, using Smytten's network of 30M+ active Indian consumers:

• Real customer count validation for the bottom-up worksheet, beyond estimation alone
• Willingness-to-pay research informing the revenue-per-customer input
• Support cross-checking top-down and bottom-up results, catching a genuine gap before it undermines a real decision
• 72-hour turnaround, fast enough to fill in this template with real, validated data rather than assumption

How Brands Can Use This

• Fill in every source field, not just the numbers. An unsourced assumption undermines the template's whole purpose.
• Always complete the cross-check section. It's the step that actually reveals whether your estimate is defensible.
• Adapt the filter rows to your specific category. The structure is a starting point, add or remove rows as your market actually requires.
• Reuse the same template for future sizing needs. A new segment, geography, or product line can use the identical structure.
• Revisit and refresh the inputs periodically. Markets shift, and a template filled out a year ago may need updated source data.

Related Concepts

• Market size calculation the full methodology and reasoning behind each part of this template
• Market sizing for startups startup-accessible data sources for filling in the template's source fields
• Market opportunity analysis using the resulting SOM figure as one input into a broader attractiveness assessment
• Market sizing tools the platforms that can help populate this template's data fields
• Startup validation where a completed market sizing template fits into the broader validation journey

FAQs

1.What should a market sizing template include?

Four parts: a top-down worksheet with sourced industry and filter data, a bottom-up worksheet with customer count and pricing assumptions, a TAM/SAM/SOM summary distinguishing the three planning numbers, and a cross-check section comparing both methods.

2.How do you use a market sizing template?

Fill in the top-down and bottom-up worksheets independently, using sourced data for each input, then complete the TAM/SAM/SOM summary and compare both methods in the cross-check section to confirm the resulting estimate is defensible.

3.Can the same market sizing template be reused for different markets?

Yes. The same structure works for sizing a new customer segment, a new geography, or a new product line, simply by updating the specific filters, customer counts, and pricing assumptions for that particular market.

4.What is the cross-check section for in a market sizing template?

It compares the top-down and bottom-up estimates directly, revealing whether they converge, evidence the number is credible, or diverge significantly, a signal worth investigating before presenting the figure as final.

5.Why should every field in a market sizing template include a source?

Because an unsourced number undermines the template's entire purpose, producing a figure that looks structured but isn't actually more defensible than an unstructured guess. Sourcing each input is what makes the resulting estimate genuinely credible.

6.What is the difference between TAM, SAM, and SOM in a market sizing template?

TAM is the broadest figure, typically from the top-down worksheet. SAM narrows to what your specific business model can realistically serve. SOM narrows further to what's realistically obtainable given your actual resources and competition.

7./Should the market sizing template be adapted for different industries?

Yes. The core structure, top-down, bottom-up, TAM/SAM/SOM, and cross-check, applies broadly, but the specific filter rows and data sources should be adapted to fit the particular category, geography, and business model being sized.