Excel-based financial model to calculate market revenues
Download the model here
-
3.2 Market Revenue
Excel-based financial model for calculating Total Addressable Market (TAM), Serviceable Addressable Market (SAM), and Serviceable Obtainable Market (SOM) revenues.
The model features dynamic, modular components that allow for easy-adjustment and toggling of market acquisition assumptions and 3-case scenarios.
- Market revenue model for a product-based business that sells one or more products into one or more market segments (e.g. regions, customer types, platforms)
- Financial modeling template for related top-down revenue analysis
- Starting template for a comprehensive operating model
- Calculates TAM units by segment per product
- Top-down driver for SAM / SOM units and revenue
- Calculates TAM / SAM / SOM market revenues via % acquisition assumptions
- SOM market acquisition % are toggled via 3-case scenarios: base, upside, downside
- Sheet with detail tables for products, market segments, and drivers
- Product and segment names and IDs are defined here for indexing throughout the model
- Drivers detail provides guidance for market acquisition assumptions
- Cols B and C are used for line item index IDs
- IDs enable flexible summary and analysis calculations by product, segment
- Microsoft Excel - required if working local
- Google Sheets - upload to Google Drive, open as sheets
- 20221117_Market_Revenue_Model.xlsx - financial model
- MindMap_Market_Revenue_Model.png - mindmap
- MindMapMD_Market_Revenue_Model.md - markdown of components and parameters shown in mindmap
All repo assets were developed by me and are open to all for use.