SmartHelping / Market Sizing / Excel
TAM Sizing Financial Model Template
Turn top-down TAM, SAM and SOM assumptions into a five-year view of potential revenue, margins, EBITDA, valuation and price per share. Model as many as three target channels and compare downside, base and upside cases.
Immediate download after purchase. By purchasing, you agree to the Terms of Service.
See the model in action
Review the assumptions, scenario controls and outputs.
Watch the walkthrough, then open the presentation for a closer look at the channel structure, five-year sizing logic, profitability summaries, visualizations and valuation outputs.
What the template includes
A focused market-sizing model with financial outputs.
Move from market potential to obtainable demand, channel economics and estimated company value without turning the analysis into an input-heavy operating model.
Size distinct paths to market
Configure up to three channels or customer segments, each with its own TAM, serviceability and market-penetration assumptions.
Separate potential from obtainable demand
Move from total addressable market to the share you can service, then to the portion you expect to obtain in each channel.
Compare downside, base and upside
Apply separate TAM-growth and market-penetration ramp multipliers, with adjustable downside and upside magnitudes.
Control when each channel begins
Forecast up to five years and adjust the start year for every segment as well as the timing of the fixed-expense schedule.
Keep channel margins practical
Enter COGS, variable costs and direct labor for each channel using a percentage of revenue and a cost per unit or customer.
Track the economics over time
Review overall and channel-level gross margins, market growth, annual revenue growth and implied value per unit or customer.
Translate the forecast into value
Enter EBITDA or revenue multiples and outstanding shares by year to estimate annual valuation and price per share.
Communicate the model clearly
Use detailed results through EBITDA, high-level summaries on major assumption tabs and 13 visualizations across the workbook.
How the sizing logic works
Move from the full market to the share the company can obtain.
The model keeps the sizing framework transparent: annual TAM defines the opportunity, serviceability narrows it to SAM, and annual penetration turns SAM into SOM. Scenario controls then show how market growth and adoption can change the outcome.
Total addressable market
Enter TAM for each channel by year. The annual assumptions can change as the potential customer or unit base grows with trends, awareness or category development.
Serviceable available market
Apply an adjustable serviceability percentage within each channel to move from TAM to SAM. The percentage remains constant over the five-year period to represent structural coverage constraints.
Serviceable obtainable market
Set market penetration separately for each year to move from SAM to SOM and represent the company capturing more of its serviceable market over time.
Scenario engine
Use TAM-growth and penetration-ramp multipliers for downside, base and upside cases, then adjust the magnitude of the lower and upper cases to fit the analysis.
Economics and valuation
Connect obtainable units or customers to revenue, direct costs, margins and EBITDA. Apply revenue or EBITDA multiples and yearly share counts to estimate value per year and price per share.
How to use it
From market assumptions to a scenario-tested valuation.
Define the channels and total market
Choose up to three channels, enter annual TAM for each one and set the start year that reflects the go-to-market plan.
Set serviceability and adoption
Enter the portion of each market the company can service, then build the annual penetration ramp used to calculate obtainable demand.
Add channel costs and company assumptions
Configure direct costs by channel, the fixed-expense schedule, outstanding shares and the revenue or EBITDA multiples used for valuation.
Compare scenarios and review the outputs
Test downside, base and upside growth and penetration, then review revenue, margins, EBITDA, valuation, price per share and the 13 visualizations.
Who gets value from it
Built for people turning a market thesis into a financial view.
Founders and operators
Frame the opportunity by channel and test how quickly market coverage and adoption could translate into revenue and profitability.
Investors and lenders
Challenge the market-growth, penetration, margin and valuation assumptions behind a company's five-year plan.
Finance teams and analysts
Build a concise top-down forecast with consistent scenario logic, annual summaries and valuation outputs.
Advisors and consultants
Use a reusable structure to explain TAM, SAM, SOM, channel economics and the range between downside and upside cases.
Also available in these bundles
Need a broader financial-model library?
The TAM sizing model is included in four SmartHelping collections. Compare the bundles if you expect to model more industries, scenarios or valuation questions.
Industry-Specific Models
Explore editable operating and investment models built around the economic drivers of many different industries.
View Industry-Specific ModelsScenario Analysis Models
Compare templates with built-in controls for testing changes in market, operating and transaction assumptions.
View Scenario Analysis ModelsValuation Models
Work with DCF, multiple-based and deal-focused templates that connect financial forecasts to estimated value.
View Valuation ModelsSuper Smart Bundle
Get the complete SmartHelping collection of operating forecasts, valuation tools, deal models and financial templates.
View Super Smart BundleRelated financial models
Explore ownership, exit, valuation and cost analysis.
Cap Table with Convertible Notes
Model ownership, dilution, note conversion and financing outcomes across founders, investors and noteholders.
Explore the cap table modelExit Readiness Model
Assess how prepared a business is for sale and identify operating, financial and organizational gaps.
Explore the exit readiness modelSmall Business Valuation
Estimate business value and compare how changes in key assumptions affect the modeled valuation range.
Explore the valuation modelAbsorption Costing Model
Assign manufacturing costs to production and analyze fully absorbed unit costs through an editable framework.
Explore the absorption costing modelQuestions before you choose
A few useful details.
What do TAM, SAM and SOM mean in this model?
TAM is the total addressable market. A channel-specific serviceability assumption narrows TAM to SAM, the serviceable available market. Annual market penetration then turns SAM into SOM, the serviceable obtainable market.
How many channels can I model?
You can configure up to three target channels or segments. Each can have its own TAM, serviceability, penetration timing and direct-cost assumptions.
How do the scenarios work?
The model includes downside, base and upside cases. You can configure TAM-growth and penetration-ramp multipliers and adjust the magnitude of the downside and upside assumptions.
How long is the forecast?
The template forecasts up to five years. You can set different start years for each channel and adjust the start of the fixed-expense schedule.
Why is serviceability constant over the forecast?
The serviceability percentage is adjustable within each channel but remains constant across the five years to represent structural coverage or distribution constraints. Annual penetration remains flexible so obtainable share can grow over time.
How detailed are the direct-cost inputs?
The direct-cost section is intentionally high level. For COGS, variable costs and direct labor in each channel, enter a percentage of revenue and a cost per unit or customer.
Does the model estimate valuation and price per share?
Yes. Enter a revenue multiple, an EBITDA multiple or both, plus total outstanding shares for each year, to estimate annual company value and price per share.
What outputs are included?
The workbook includes detailed results through EBITDA, high-level summaries, 13 visualizations, channel and overall gross margins, market and revenue growth, annual valuation and implied value per unit or customer.
Connect the market opportunity to financial outcomes
Turn TAM, SAM and SOM into a five-year decision model.
Get the editable Excel TAM sizing model for $45.
