Sum-of-the-Parts
Value the segments separately and show what a single multiple hides.
Seat
IB · ER/HF
Level
Analyst / Associate
Runtime
~30 min
Output
Sum-of-the-parts page: Excel + slide
What this helps you accomplish
Each segment on its own multiple range to an enterprise value, less capitalised corporate cost and net debt, to a value per share. The argument only works if the segment multiples are defensible against named peers, so the useful question on this page is which segment carries the value and whether its multiple survives being asked about.
What you get
Not a description of an output. The file itself, in the conventions a banker, a PE associate or a hedge fund analyst already reads without being told.
{TICKER}_sotp.xlsx
Excel workbook
- 1
Inputs
Shares, net debt, the current price, the offer and the metric basis the segment multiples are struck on
- 2
Segments
Each segment’s metric with a low and high multiple, to a low and high enterprise value, and corporate cost capitalised as its own line
- 3
Bridge to equity value per share
Segment enterprise value less corporate cost and net debt, to an equity value and a per-share range against the offer
- 4
Chart data: EV contribution by segment ($mm)
The rows behind the stacked chart, so the contribution of each segment is a formula rather than a drawing
- 5
PowerPoint
One slide: the segment table, the contribution chart and a per-share KPI rail
Where the numbers come from
From the filings: the header only, which is shares, net debt and prices. Every filed figure resolves to its form, period, page, the printed value and a link into the filing on EDGAR. Not from filings: every segment and multiple, which arrive as illustrative placeholders the build warns about. Replace them from the segment note in the 10-K. Assumptions are listed on the slide’s source line under "Not from filings", so an assumed input is never read as a filed one.
Run it yourself
python3 skills/deal-slides/build.py sotp --ticker BSX --offer 60Delegate · Verify · Decide
The core L3VLUP principle: AI output is never automatically correct. Know what to hand off, what to check, and what only you can own.
Delegate
AI is good enough to do this.
- • Filling the header from the filings with a citation on each figure
- • Applying the multiple range to each segment and capitalising the corporate cost
- • The bridge to equity value and the per-share range as live formulas
- • Building the branded slide with the contribution chart
Verify
AI accelerates you here, but a professional checks the work.
- • That the segment metrics reconcile to the group: segment EBITDA less corporate cost equals reported EBITDA
- • That a segment valued on revenue does not also carry EBITDA in the total
- • That each segment multiple is supported by named peers on the same metric basis
- • That the metric basis, trailing or forward, is the same for every segment
Decide
Judgment the human owns. This is the skill.
- • The segmentation itself, where the reported segments do not match how the business runs
- • Each segment multiple and the peers it is defended with
- • Whether a conglomerate discount belongs on the page
- • Whether the range is credible against the trading comparables, since a sum-of-the-parts far above them needs a named reason
Inputs required
- Company name or ticker
- The offer per share
- The segments with their metrics, from the segment note
- The multiple range for each segment and the peers that justify it
- Your own numbers where you would rather not use the default
The workflow
- 1
Resolve the company
A ticker or a name fills the header the bridge is built on.
- 2
Take the segments from the note
The company’s own reporting segments, not a split invented for the page. Revenue and EBITDA by segment come from the segment note.
- 3
Justify each multiple
Every segment multiple names the peers that support it. A multiple with no named peer set is an opinion in the shape of a number.
- 4
Handle corporate cost
Unallocated cost is capitalised as its own negative line rather than spread silently across the segments.
- 5
Build and reconcile
Segment EBITDA less corporate cost has to equal reported EBITDA. If it does not, the page is double counting or missing something.
Run this skill
Any listed company, anywhere. Ticker or name.
Quality checklist
The output isn’t done until every box ticks.
- verify reports zero errors: change a multiple or the metric basis and the per-share range moves
- Units are on the table headers ($mm), the KPI rail ($ per share) and the multiples (x)
- The per-share row states the current price and the offer, and the subtitle names the metric basis and the pricing date
- Segment EBITDA less corporate cost equals reported EBITDA
- A range far above the trading comparables carries a named reason, or it will not survive the fairness committee
Practise the fundamentals first
Free, no sign-up — in the Labs.