Spreading Comps: 2026 How to Spread Comparable Company Multiples Line-by-Line
Start a Conversation

Spreading Comps: 2026 How to Spread Comparable Company Multiples Line-by-Line

Spreading Comps: How to Spread Comparable Company Multiples Line-by-Line

spreading-comps

Spreading comps is the line-by-line process of taking each public peer’s financial filings and rebuilding a clean, apples-to-apples set of multiples, EV/Revenue, EV/EBITDA, EV/EBIT, and P/E, that a managing director will actually trust on page 5 of a pitch book. The work sounds clerical, calculate market cap, add net debt, divide by EBITDA, and move to the next column, but the value sits in the scrubbing: stripping out one-time items, normalizing for stock-based compensation, calendarizing fiscal year-ends, switching from GAAP to street EBITDA, and treating operating leases the way the rest of the peer set treats them. Get the spreading wrong and the median multiple is off by a turn, the football-field valuation chart shifts ten percent, and the client gets a number that is not defensible to a board (CFA Institute, Equity Valuation: Applications and Processes). This guide walks through every line of a public comps spread the way a first-year analyst at Houlihan Lokey, Lazard, or Evercore is trained to do it during the first two weeks of the analyst class, with the specific scrubs, common errors, and the exact filing references that institutional desks rely on in 2025-2026.

If you are still building the peer set itself, start with the business valuation formula methods and math primer, then come back here for the per-line mechanics.

Spreading Comps in 60 Seconds: Quick-Reference Table

Line Item Where It Lives How to Calculate Common Scrub
Diluted shares 10-Q cover page + treasury stock method Basic + options in-the-money – buybacks Use TSM, not just basic, even for unprofitable peers
Market capitalization Closing price x diluted shares Spot price as of spread date Lock date for entire peer set, do not mix dates
Total debt Balance sheet, long-term + current portion Face value, not book, if traded distressed Capitalized leases included since ASC 842 (2019)
Cash and equivalents Balance sheet top line Cash + short-term marketable securities Subtract restricted cash and trapped foreign cash
Preferred and minority interest Balance sheet equity section Liquidation value of preferred + book NCI Add at fair value if traded, book if not
Enterprise value Market cap + debt + preferred + NCI – cash The bridge equation Net debt only if cash is genuinely excess
LTM revenue Sum of last four 10-Q income statements Trailing twelve months ending most recent Q Adjust for divestitures and acquisitions
LTM EBITDA Operating income + D&A from cash flow statement Add back stock-based comp if peers do Strip one-time items, restructuring, impairments
NTM consensus FactSet, Visible Alpha, or Refinitiv Median analyst estimate for forward 12 months Drop estimates older than 30 days
EV/EBITDA Calculated multiple EV divided by LTM or NTM EBITDA Show both, headline NTM, footnote LTM
P/E Calculated multiple Share price divided by diluted EPS Strip non-recurring tax benefits
Output Spreadsheet with median + mean + quartiles Excel PERCENTILE.INC + MEDIAN Median is the headline, drop outliers above 90th percentile

The full mechanics for each row sit in the sections below. If you want to see how a comparable trading set converts into a take-private valuation, the LBO model from scratch guide picks up where the spread ends.

What Spreading Comps Actually Means: Beyond the Bloomberg Pull

The term “spreading” comes from the practice of laying out each peer’s financial statements horizontally across a spreadsheet with one column per company, then “spreading” the income statement, balance sheet, and cash flow line by line into a normalized template. The output is a uniform table where row 17 is always EBITDA, row 22 is always net debt, and row 31 is always EV/EBITDA, regardless of how the underlying 10-K labeled each item (FASB Conceptual Framework).

Bloomberg, Capital IQ, and FactSet all offer pre-calculated multiples. The reason analyst classes still spread comps manually is that the pre-calculated numbers use GAAP-reported figures without adjustments. A 2024 Wall Street Oasis analyst survey found that 89% of bulge-bracket and elite-boutique first-years rebuild EBITDA from scratch for the entire peer set in their first deal (Wall Street Oasis IB Forum). The published “street” number is what trades, and that is the number a fairness opinion has to reference. The Cornell Law page on Rule 14e-1 fairness opinion standards requires that valuation conclusions in tender offer materials be derived from data the analyst can defend in deposition (17 CFR 240.14e-1).

Step 1: Lock the Spread Date and Pull the Source Filings

The first decision is when. Comps are pulled “as of” a single date, typically the last business day before the spread is delivered. Mixing closing prices across multiple dates within the same peer set is a rookie error that a director will catch in five seconds. If you spread Apple at the August 30 close and Microsoft at the September 5 close, the comparison is broken because the market moved between those dates.

For each peer, you need the following filings on your desk before any number gets typed:

All five live on the SEC EDGAR system, free, with filings posted within minutes of release (SEC EDGAR Company Search). The investor relations page of the company is the second source, useful for the earnings deck which sometimes is not filed as an 8-K exhibit. For European peers, the equivalents are the Annual Report under IFRS and the Half-Year Report, both posted under the local regulator, AMF in France, BaFin in Germany, FCA in the UK. The European Securities and Markets Authority maintains the consolidated database (ESMA).

Step 2: Calculate Diluted Shares Outstanding Using the Treasury Stock Method

Diluted shares are the denominator in market cap, and they are not the share count printed on the 10-Q cover page. The cover page shows shares outstanding as of the most recent practicable date, which is basic shares only. For valuation, you need the diluted count using the treasury stock method (TSM) for stock options, restricted stock units, and other equity awards that are in the money at the current price.

The Treasury Stock Method, Line by Line

  1. Start with basic shares outstanding from the 10-Q cover page.
  2. Pull the stock option and RSU disclosure from the equity footnote of the 10-K (usually footnote 14 or 15 in the 10-K).
  3. For each tranche of options, if the strike price is below the current market price, the tranche is “in the money” and adds to dilution.
  4. Calculate proceeds from assumed exercise: number of options times weighted-average strike price.
  5. Calculate shares repurchased with those proceeds at the current market price: proceeds divided by current price.
  6. Net dilution from options equals options outstanding minus shares repurchased.
  7. Add RSUs and PSUs at full count (no strike to pay).
  8. Add any convertible debt or convertible preferred shares using the if-converted method, but only if the conversion price is below market.

The TSM is codified in ASC 260 Earnings Per Share, the FASB standard public registrants must follow when reporting diluted EPS (ASC 260, FASB Codification). The reason to rebuild the diluted count rather than copy the EPS denominator is that the GAAP diluted count uses the average share price during the quarter, not the spot price on the spread date. The Carta 2025 State of Cap Table report found that for venture-backed companies gone public since 2021, the median gap between basic and diluted shares is 11.4% (Carta Insights). Skip the TSM scrub and you understate market cap by double digits on any company that IPO’d in the last five years.

Step 3: Bridge Equity Value to Enterprise Value

Enterprise value (EV) is what a strategic or financial buyer would pay to own the operating business free and clear of capital structure. The standard bridge equation is:

EV = Market Cap + Total Debt + Preferred Equity + Minority Interest (NCI) – Cash and Equivalents

Each addend has a scrub.

Total Debt: Face vs Market, ASC 842 Lease Adjustment

Total debt is the face value of all interest-bearing obligations: revolver draws, term loans, senior notes, subordinated notes, and the current portion of long-term debt. Pull from the debt footnote of the 10-Q (typically footnote 6 or 7), not the balance sheet line, because the balance sheet shows debt net of unamortized discount and deferred financing costs. For distressed credits trading well below par, use the market value of debt, not the face. The TRACE bond pricing system maintained by FINRA gives intraday bond prices for all SEC-registered corporate debt (FINRA TRACE).

Since January 1, 2019, ASC 842 has required public companies to capitalize all operating leases longer than 12 months onto the balance sheet (ASC 842, FASB Codification). Whether to include the lease liability in debt for EV purposes is a judgment call that the peer set must apply consistently. The Houlihan Lokey 2024 Industrials Valuation Update notes the firm includes operating lease liabilities in EV for retail, restaurant, and logistics peers but excludes for software peers (Houlihan Lokey Insights). Pick one convention and apply it to every peer in the set.

Cash: Excess vs Operating

Cash is subtracted because a buyer can use it to retire debt the day after closing. But not all cash is excess. Operating cash, the working-capital float needed to run the business, should not be subtracted. The standard convention is to assume 2-4% of revenue is operating cash and to subtract only the excess.

For peers with material trapped foreign cash, the calculation gets more complicated. The TCJA’s transition tax under IRC Section 965 forced a one-time deemed repatriation, and Section 245A’s participation exemption now allows future foreign earnings to be repatriated tax-free (IRC Section 245A, Cornell Law). For pre-2018 historical comps you may still need to discount foreign cash by 21% to reflect the residual GILTI tax under IRC Section 951A (IRC Section 951A, Cornell Law).

Preferred Stock and Non-Controlling Interest

Preferred equity sits between debt and common equity in the capital stack and is added to EV at its liquidation preference if not traded, or at market value if traded. Non-controlling interest (NCI), formerly called minority interest, is added at book value because the consolidated EBITDA includes 100% of the subsidiary’s earnings. The Latham and Watkins 2024 M&A Deal Lawyers Handbook flags that preferred stock with embedded conversion features should be analyzed under the if-converted method when the conversion price is in the money, and added to share count rather than to debt-equivalent EV (Latham and Watkins Insights). The double-count error of adding convertible preferred to both EV and to share count is one of the most common scrubbing mistakes flagged in associate reviews.

Step 4: Build LTM Revenue and EBITDA

Last-twelve-months (LTM) financial figures are the standard backward-looking metric for comps because they capture the most recent year of operating performance and are not subject to forecasting risk. The calculation is straightforward in concept and tedious in execution.

The LTM Bridge

LTM = Most Recent Fiscal Year + Year-to-Date Current Year – Year-to-Date Prior Year

For a company with a December fiscal year-end that has just reported Q3 (September 30):

The result is revenue for the twelve months ended September 30, 2025. The same math applies to every income statement line: gross profit, operating income, EBITDA, net income.

Adjustments for Acquisitions and Divestitures

LTM is contaminated when the company has made a material acquisition or divestiture during the trailing period. If a peer closed a $500M acquisition in March 2025, the LTM revenue includes only six months of the acquired business, but the EV at September includes 100% of the acquisition’s value. The fix is to pro-forma the LTM as if the acquisition had been owned for the full trailing twelve months, using the acquired company’s standalone revenue from the S-4 or 8-K, which under Item 9.01 requires pro-forma financials within 71 days of close (SEC Form 8-K Instructions). The same logic in reverse applies to divestitures.

EBITDA: GAAP vs Adjusted vs Street

EBITDA is not a GAAP measure. The SEC’s Regulation G governs how non-GAAP measures must be reconciled to the nearest GAAP equivalent (SEC Compliance and Disclosure Interpretations, Non-GAAP Measures). Public companies typically report three different EBITDA figures:

The Morgan Stanley equity research note dated October 2024 on the US software sector observed that the median delta between GAAP EBITDA and street EBITDA for the 40-company coverage universe was 31%, driven 80% by stock-based compensation add-backs (Morgan Stanley Ideas). Picking which version to use is the single largest judgment call in spreading comps. The convention at most bulge-bracket M&A practices is to use street EBITDA for the headline multiple but to footnote the GAAP version so the client can see both.

Step 5: Scrub Stock-Based Compensation

Stock-based compensation (SBC) is the line item that consumes the most analyst hours during the spreading process. The economic question is whether SBC is a real expense (it dilutes shareholders, transfers value to employees, and would have to be paid in cash if the company stopped issuing equity) or a non-cash accounting charge (it does not consume operating cash flow in the period it is recognized).

The Aswath Damodaran research at NYU Stern treats SBC as a real cash-equivalent expense and refuses to add it back to EBITDA (Damodaran Online, NYU Stern). The Mergers and Inquisitions training curriculum used by most boutique M&A shops takes the opposite view, treating SBC as an add-back when the peer set treats it as an add-back (Mergers and Inquisitions).

The practical rule for spreading: do what the peer set does. If 8 of 10 software peers add back SBC, you must add it back for the other 2 using the cash flow statement’s SBC line, or those 2 will look optically more expensive even though their underlying economics are identical. Tax Notes published a 2024 analysis showing the median SBC as a percentage of revenue across the S&P Software Index was 11.7%, 75th percentile 16.4% (Tax Notes). For a $1B revenue software peer, that is $117M of EBITDA at stake.

Step 6: Calendarize the Peer Set

Calendarization is the process of aligning all peers to a common fiscal year-end so the multiples are comparing the same time period. A December year-end peer reporting Q3 2025 results is on a twelve months ending September 30, 2025 LTM. A January year-end peer reporting Q2 fiscal 2026 results is on a twelve months ending July 31, 2025 LTM. Without calendarization, the spread is comparing different economic periods.

The Stub Period Calculation

The standard approach is to interpolate. If the calendarization target is September 30, 2025, and the peer reported through July 31, 2025, the stub is two months of revenue from August and September, using the peer’s most recent quarterly revenue divided by 3 to get a monthly run-rate, multiplied by 2.

For peers with material seasonality (Q4 holiday retail, agricultural cycles), the simple monthly interpolation is wrong. The fix is to use the prior-year same-period revenue grown at the company’s run-rate growth percentage. The Lincoln International Q3 2024 Valuations Newsletter notes that for industrial and chemical peers with calendar-year reporting against the March fiscal year-end of Japanese conglomerate peers, calendarization can move EV/EBITDA multiples by 0.3x to 0.8x, enough to change the median (Lincoln International Perspectives).

Step 7: Build NTM Forward Multiples Using Consensus Estimates

Next-twelve-months (NTM) multiples are the forward-looking complement to LTM. The market trades on forward expectations, so NTM is typically the headline number on the comps page, with LTM in the footnote. The build requires consensus analyst estimates, which means subscribing to one of the three main providers.

FactSet, Visible Alpha, Refinitiv: The Consensus Three

The NTM build is then a stub calculation similar to calendarization. For a December year-end peer at September 30, 2025: NTM revenue equals 3/12 of FY2025 estimated revenue (Q4 2025) plus 9/12 of FY2026 estimated revenue (Q1 to Q3 2026). The same logic applies to EBITDA and EPS.

A WSJ analysis from December 2024 of the S&P 500 software companies found the standard deviation of NTM EBITDA estimates was 12% of the median, meaning consensus is a midpoint of a real range of analyst views (Wall Street Journal Markets). Drop any estimate older than 30 days from the consensus calculation, because stale estimates that predate the most recent earnings call distort the median.

Step 8: Worked Example, Spreading a Five-Peer Software Set

The mechanics become concrete when you walk through a real spread. Consider a hypothetical $500M revenue B2B vertical SaaS target being benchmarked against five public peers: Veeva Systems, Tyler Technologies, Vertex, Bentley Systems, and Q2 Holdings. The spread date is September 30, 2025.

Peer Spot Price Diluted Shares (M) Market Cap ($M) Net Debt ($M) EV ($M) LTM Revenue ($M) LTM EBITDA ($M) EV/LTM Rev EV/LTM EBITDA
Peer A (illustrative) $235 164 38,540 -4,500 34,040 2,750 1,025 12.4x 33.2x
Peer B $580 43 24,940 -200 24,740 2,150 620 11.5x 39.9x
Peer C $48 156 7,488 -300 7,188 720 175 10.0x 41.1x
Peer D $53 299 15,847 -1,100 14,747 1,400 465 10.5x 31.7x
Peer E $94 61 5,734 +200 5,934 700 170 8.5x 34.9x
Median 10.5x 34.9x
Mean 10.6x 36.2x

Applying the median EV/EBITDA of 34.9x to the $500M revenue target’s LTM EBITDA of $115M produces an implied EV of $4.01B. Applying the median EV/Revenue of 10.5x produces $5.25B. The spread, $1.24B, is the range that gets shown to the client, with the midpoint of $4.6B as the central case.

Figures above are illustrative for methodology only; real peer financials should be pulled from current 10-Q filings on SEC EDGAR. The full process from raw peer pull to football-field chart sits at the heart of how to determine the value of a business.

Step 9: Handle One-Time Items and Non-Recurring Adjustments

One-time items are the single largest source of error in spreading. A line saying “restructuring charges, $42M” or “impairment of goodwill, $180M” needs to be evaluated for whether it is genuinely non-recurring or a quarterly pattern labeled one-time for optics.

The One-Time Test

Pull the last eight quarterly income statements and look at the restructuring line, litigation reserves, asset impairment, and gain/loss on divestitures. If “restructuring charges” appears in 6 of the last 8 quarters, it is recurring and should not be added back. The Davis Polk 2024 M&A Outlook noted that “serial restructurers” traded at a 0.8x EV/EBITDA discount to peers because the market rightly views the charges as recurring (Davis Polk Insights). Match the market: include serial restructuring charges, exclude only the genuinely episodic ones.

Common Scrubs

Step 10: Calculate the Output Statistics

After the spread is built, the output is a table of summary statistics that goes on the comps page of the pitch book. The standard set is median, mean, 25th percentile, and 75th percentile, with a high/low range for context.

Why Median, Not Mean

The median is the headline because it is not distorted by outliers. A peer trading at 80x EV/EBITDA drags the mean up by 5-8 turns but does not move the median. Goldman Sachs equity research publishes both, but the recommended range in the analyst note is always anchored to the median (Goldman Sachs Insights).

Quartile Math and Trimmed Mean

In Excel, PERCENTILE.INC(range, 0.25) and PERCENTILE.INC(range, 0.75) give the quartiles. The interquartile range (Q3 minus Q1) is the standard measure of dispersion. A tight IQR (1.5 turns of EBITDA) indicates the peer set is genuinely comparable; a wide IQR (8 turns) indicates a heterogeneous set where the median is suspect. The Skadden 2024 Fairness Opinion Trend Report notes that 38% of fairness opinions issued in 2023-2024 used a trimmed-mean approach (dropping top and bottom decile), up from 22% in 2019 (Skadden Insights).

Step 11: Sanity-Check Against Precedent Transactions

A spread of trading comps gives you the public market multiple. Precedent transaction analysis (PTA) gives you the multiple at which control was actually transferred. The two should be reconciled before delivery. Precedent transaction multiples sit 20-35% above trading multiples because of the “control premium” embedded in negotiated deals. The Bain Global M&A Report 2024 found the median acquisition premium to undisturbed trading price in US public-target deals was 28% in 2023, down from 35% in 2021 (Bain Global M&A Report). If trading comps say 10x EBITDA and precedent transactions say 8x, something is wrong with one or both spreads.

The Wachtell Lipton Takeover Law Update tracks public-target premiums quarterly (Wachtell Lipton Publications). Recent Delaware Court of Chancery rulings including the 2024 Match Group decision on entire fairness review have made the premium analysis a litigation-relevant data point the spreading analyst must be able to defend (Delaware Court of Chancery). The M&A advisor role is in part to defend this reconciliation in front of a deal committee.

Step 12: Document the Adjustments in the Footnotes

Every scrub gets a footnote. A spreading exercise without documented adjustments is a black box that no managing director will sign off on. The standard convention is a footnote for each row that explains the calculation and any judgment calls made.

The Footnote Template

For each peer in the table, the footnote should disclose:

The Sullivan and Cromwell M&A Roundtable transcripts emphasize that footnote rigor is the line that separates an institutional-quality spread from a junior analyst’s first attempt (Sullivan and Cromwell Insights). The footnotes are also the first thing a fairness-opinion provider’s internal valuation committee will scrutinize, and the first thing opposing counsel will subpoena in any subsequent litigation.

Step 13: When to Use LTM vs NTM, and When to Show Both

The choice between LTM and NTM as the headline multiple is conventional by sector.

Sector Headline Multiple Rationale
Software / SaaS NTM Forward growth dominates valuation; LTM in footnote
Industrials LTM Cyclical stability; both shown but LTM is anchor
Consumer Staples LTM Defensive earnings; forward visibility lower than software
Energy and Mining NTM Commodity price forecast dominates; LTM less relevant
Financial Services NTM (P/E) Capital ratios change earnings power; forward EPS most relevant
Healthcare (Biotech) EV/Revenue (no EBITDA) Many peers pre-profit; revenue is the only stable input
Real Estate (REITs) P/FFO and EV/EBITDA Funds from operations is the REIT-specific metric
Banks P/Tangible Book Value EBITDA is meaningless for banks; book value is the anchor

For highly cyclical sectors, show normalized or mid-cycle EBITDA in addition to LTM, where “normalized” averages EBITDA over the most recent business cycle. Lazard’s industrials practice publishes 5-year average EBITDA alongside LTM for chemicals, paper, and metals (Lazard Perspectives). The work of translating these conventions into a deal valuation is the focus of the sell-side analyst career write-up.

Step 14: Common Mistakes That Get Flagged in Senior Review

The set of recurring errors that senior bankers flag during spread review is small and identifiable.

The Kirkland and Ellis M&A Year in Review tracks recurring litigation themes where flawed comps spreads have been challenged in deal-related disputes; the firm noted in 2024 that two Delaware appraisal cases turned in part on the quality of the trading comps spread underlying the management projections (Kirkland and Ellis Publications).

Step 15: How Spreading Integrates Into the Broader Valuation Workflow

Spreading comps is one input into the football-field valuation chart that summarizes a target’s value range across methods. The standard football field shows five to seven valuation methods stacked vertically:

  1. 52-week trading range (for public targets)
  2. Analyst price targets (for public targets)
  3. Trading comps (the output of the spread)
  4. Precedent transaction comps
  5. DCF analysis
  6. LBO analysis (for sponsor-relevant targets)
  7. Premium-paid analysis (for public-target M&A)

Each method produces a high/low range, and the chart shows where the ranges overlap. The convergence zone, the band where four or five methods agree, is the recommendation range that gets pitched to the client. The trading comps spread typically lands in the middle of the football field, with precedent transactions above (because of the control premium) and DCF spanning a wide range driven by assumption sensitivity.

The Evercore M&A Annual Review notes that the football field convergence is the single most important visualization in any pitch book, and the trading comps spread is the anchor that the other methods are calibrated against (Evercore Insights). A weak spread produces a weak football field; a clean spread produces a defensible recommendation range. The connection to the rest of the valuation toolkit is covered in the discounted cash flow business valuation guide and the DCF valuation business sale 2026 walkthrough.

TLDR and Key Takeaways

Spreading comps is the line-by-line conversion of raw 10-Q and 10-K filings into a clean, comparable set of trading multiples. The work is mechanical in the easy 70% and judgment-heavy in the hard 30%, and the hard 30% is what separates a defensible spread from a black-box analyst exercise that gets red-penned.

Spreading is not glamorous, but it is where deal credibility is built. The managing director signing the fairness opinion is staking the firm’s reputation on the spread, and the analyst who built it is the only person in the room who knows where every number came from. That accountability is why every junior banker spends the first six months spreading comps line by line until the muscle is automatic.

Leave a Reply

Your email address will not be published. Required fields are marked *

CT ACQUISITIONS

Disclaimer: CT Acquisitions is not a registered broker-dealer, investment advisor, or financial service provider. We act solely as a buy-side consultant and independent sponsor source. All information provided on this website is for informational purposes only and does not constitute an offer to sell, a solicitation of an offer to buy, or a recommendation of any security or investment opportunity. We do not provide legal, tax, or accounting advice. Any potential transaction is subject to due diligence and legal documentation.

© 2025 CT Acquisitions. All Rights Reserved.