60PitchPal
Founder journal

Market sizing / 2 min read

Build a bottom-up TAM spreadsheet from a customer list

A practical spreadsheet structure for customer counts, annual revenue per account, exclusions, and a defensible bottom-up TAM.

By PitchPal · Practical founder guide

Create an auditable customer list

Use one row per paying account, not one row per contact. Columns should include account ID, segment, geography, eligibility, source URL, date checked, and reason for exclusion. If a chain buys centrally, decide whether the paying unit is the chain or each location. Mixing those units can inflate the estimate.

Keep assumptions outside the customer table

Create a separate assumptions sheet for monthly price, paid months, discounts, and expected account mix. Reference those cells in formulas so a pricing change updates the model consistently. Document whether the price is list price or expected realized revenue. Annual software revenue should exclude taxes collected on behalf of the government.

Worked calculation

Assume a hypothetical eligible list contains 800 small accounts at ₹12,000 annually and 200 larger accounts at ₹36,000. TAM = 800 × ₹12,000 + 200 × ₹36,000 = ₹16,800,000, or ₹1.68 crore. Do not replace both segments with ₹36,000 pricing: most customers in this model buy the smaller plan.

Audit before sharing

Check duplicates, blanks, non-operating businesses, and outdated sources. Independently recompute totals from a pivot table. Sample excluded and included accounts so your filter is not silently reversing the logic. A prospect list is evidence of existence, not evidence of willingness to buy; attach pilot or pricing research separately.

Your next steps

  • Choose a consistent paying unit.
  • Deduplicate account IDs.
  • Separate prices from counts.
  • Audit a sample and show source dates.

Sources & further reading

Sources support the concepts. Hypothetical examples and calculations are teaching material, not measured market statistics.

Turn the thinking into a clear pitch.

Bring your own facts and assumptions to the one-minute coach.

Work on your pitch

Keep reading