-
Define the screening criteria — Set sector, size, date range, deal type, and geography filters. Start broad, then narrow. Document every filter applied and the rationale for inclusion/exclusion thresholds.
-
Build the transaction universe — Pull all deals matching the screen. Record acquirer, target, announcement date, close date, TEV, equity value, and consideration type. Exclude withdrawn/terminated deals unless specifically relevant to the analysis narrative.
-
Normalize financial metrics — For each target, collect LTM and NTM revenue, EBITDA, and EBIT as of the announcement date (not close date). Adjust for non-recurring items, stock-based compensation, or restructuring charges only where disclosed and material. Flag any calendarization assumptions [VERIFY].
-
Calculate deal multiples — Compute TEV/Revenue, TEV/EBITDA, TEV/EBIT, and P/E for each transaction. If EBITDA is negative or unavailable, exclude that deal from EBITDA-based metrics rather than imputing. Present mean, median, 25th and 75th percentiles for each multiple.
-
Calculate premiums — Compute premium to unaffected share price at 1-day, 1-week, and 30-day prior to announcement (or first leak date if pre-announcement run-up occurred). Use VWAP where possible. Note whether price was affected by rumors or sector moves [VERIFY].
-
Segment and annotate — Group transactions by meaningful sub-categories: strategic vs. financial buyer, deal size tier, pre- vs. post-regulatory-change periods, auction vs. negotiated. Identify outliers and provide deal-specific context (e.g., distressed sale, competitive bidding, synergy-driven premium).
-
Derive valuation range — Apply selected multiples (typically median and interquartile range) to the subject company's financials to produce an implied valuation range. Cross-reference premium analysis against the subject's current trading price.
-
Contextualize and caveat — Note market conditions at the time of each precedent (credit environment, sector cycle, index levels). Acknowledge survivorship bias, data gaps, and any transactions where reported multiples may reflect non-public adjustments.