SOTP Financial Model Template

8-Year Some Of The Parts (SOTP) Financial Model

Rather than valuing the company as one blended enterprise, the breakup analysis model breaks it into its component segments, forecasts each one on its own operating drivers, and values each using three standard methodologies — a discounted cash flow analysis, trading comparables, and precedent transactions. Those three views are blended into a single value per segment, summed together, and then adjusted for unallocated corporate overhead, a holding-company discount, and net debt to arrive at an implied share price. A terminal value captures the cash flows expected beyond the five-year explicit forecast, so no value is left on the table past 2030.

The workbook is organized into fifteen tabs, each with a distinct role in the analysis — from raw assumptions and historical data, through segment-level forecasting and valuation, to the final bridge and output summary. Every figure flows from formulas rather than hardcoded results, so a single change to an assumption — a growth rate, a multiple, a discount rate — ripples automatically through the entire model. Inputs are color-coded (blue for hardcoded assumptions, black for formulas, green for links to other tabs) so it’s always clear where a number originates and where it feeds.

Control & Navigation

Cover

The landing page of the model. It states the company name, preparation date, and units, summarizes the historical and forecast periods, and provides a clickable table of contents linking directly to every other tab. A short legend explains the color and formatting conventions used throughout the workbook, so any reader can orient themselves before diving into the numbers.

Assumptions

The control panel for the entire breakup model. Every hardcoded input lives here: the tax rate, WACC, terminal growth rate, share count, and holding-company discount; the weighting applied across the three valuation methodologies; and, for each segment, the revenue growth, EBITDA margin, D&A, capex, and working-capital assumptions that drive the five-year forecast. Trading and precedent transaction multiples and net debt inputs are also centralized here. Because every other tab references these cells rather than re-entering figures, updating an assumption in one place updates the entire model.

Historicals

The factual foundation of the model. Three years of actual segment-level financials — revenue, EBITDA, D&A, capex, and working capital — are entered here for each segment, then rolled up into a consolidated historical P&L down to net income. This tab anchors the forecast: growth rates and margins in later years are calculated relative to the actuals recorded here.