Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesBusiness & StrategyStartup PlanningMarket Sizing Calculator (TAM, SAM, SOM)

SpreadsheetStartup PlanningFree

Market Sizing Calculator (TAM, SAM, SOM)

Size a market bottom-up by segment: number of customers, share you can reach, share you can win and annual value.

Shown with sample data

Colour

Market Sizing Calculator (TAM, SAM, SOM)

Size a market bottom-up by segment: number of customers, share you can reach, share you can win and annual value.

TAM
$1,287,500,000
Everyone who could buy
SAM
$516,120,000
Those you can serve
SOM
$15,659,400
What you can win in 3 years
SOM as share of TAM
1.2%
Obtainable market by region
  • North America$11,907,000
  • Europe$3,574,800
  • Asia-Pacific$177,600

How to use it

  1. 1List customer segments with a sourced count of potential customers.
  2. 2Enter the annual revenue you would earn per customer.
  3. 3Set the share you can serve (product fit, geography) and the share you can win in three years.
  4. 4Quote SOM as your near-term target and TAM as the long-term prize.

In this workbook

  • About
  • What’s included
  • How to use
  • Related resources

About this template

Investors trust a market size built from customers and prices, not a top-down percentage of a huge number. List each segment with how many customers exist, the share you can serve and the share you can realistically win; the sheet multiplies through to total, serviceable and obtainable market in annual revenue.

Who it’s for

  • Pitch decks and business plans
  • Choosing which segment to enter first
  • Sense-checking revenue forecasts

What’s included

  • Segments sheet: One row per segment and region.
  • By region sheet: SAM and SOM and the number of entries for each region.

How to use it

  1. 1List customer segments with a sourced count of potential customers.
  2. 2Enter the annual revenue you would earn per customer.
  3. 3Set the share you can serve (product fit, geography) and the share you can win in three years.
  4. 4Quote SOM as your near-term target and TAM as the long-term prize.
Related searchesmarket sizingtam sam sommarket sizeaddressable marketstartup pitch

Details

Format
Spreadsheet
Category
Startup Planning
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetStartup PlanningFree

Market Sizing Calculator (TAM, SAM, SOM)

Size a market bottom-up by segment: number of customers, share you can reach, share you can win and annual value.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Startup Planning
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More startup planning templates

View all
Startup Financial Model2 sheets

MRR in month 12

$27,234

Average monthly burn

$61,419

Cash at month 12

$162,967

ABCD
1MonthCustomersRevenueCost of revenue
2M1120$10,680$1,922
3M2139$12,371$2,227
4M3158$14,062$2,531
5M4176$15,664$2,820
Model
SpreadsheetStartup Planning

Startup Financial Model

Monthly revenue, costs, burn and runway for the next 12 months.

45 min setupPreview

Company Name: Investor Update, Month Year

TL;DR: One sentence on the month.

Key metrics

MetricThis monthLast month
Revenue (MRR)$42,500$38,900
Customers318291

Highlights

  • •Win 1
  • •Win 2

Lowlights

  • •Challenge and what we're doing about it
DocumentStartup Planning

Investor Update

A monthly founder update: highlights, metrics, lowlights, asks and runway.

30 min setupPreview
Business Startup Costs Calculator2 sheets

One-time costs

$53,300

Monthly costs

$13,090

Total funding needed

$151,616

ABCD
1TypeCategoryItemEstimated cost
2One-timePremisesLease deposit (2 months)$6,400
3One-timeEquipmentEspresso machine + grinders$14,500
4One-timePremisesFit-out and furniture$22,000
5One-timeLegal & licencesCompany setup, permits$2,100
Costs
SpreadsheetStartup Planning

Business Startup Costs Calculator

Estimate one-time and monthly costs to launch and how much funding you need.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ