Comparable Company Analysis: How to Build a Trading Comparables Table

Comparable company analysis estimates a valuation range by examining how markets price similar listed businesses. Build a peer set, standardise financial metrics, calculate consistent multiples and explain the differences. The median is a reference point, not proof of fair value. Companies with different growth, profitability and risk can reasonably trade at different multiples.

Select peers by economics

Start with products, customers, geography, business model and revenue drivers. Then compare scale, growth, margins, capital intensity and financial risk. A company sharing an exchange sector label may be a poor peer if it earns money in a different way.

Write a short inclusion rationale beside each selected company. Identify exclusions too, particularly when a tempting peer is much larger, loss-making, diversified or affected by a temporary event. A defensible small set is more useful than a large list selected only because data is easy to obtain.

CFA Institute's market-based valuation reading describes the use of benchmark and peer multiples. Similarity must be evaluated rather than assumed from the spreadsheet layout.

Build the table with source discipline

Useful columns include company, valuation date, share price, diluted share count, equity value, debt, cash, enterprise value, revenue, EBITDA, EBIT and net income. Add growth and margins so readers can interpret multiple differences rather than just rank prices.

Keep market values on a common date and financial periods aligned. Last-twelve-month figures can help where fiscal year-ends differ. Forecast multiples need forecasts for comparable periods and a clear source. Do not mix one company's next-year EBITDA with another's last reported EBITDA and call the ratios directly comparable.

For every adjustment, preserve reported and adjusted values. Removing restructuring expenses can be reasonable if justified, but repeated “one-off” costs may belong in normal earnings. Check lease accounting, acquisitions, discontinued operations and currency units. The goal is comparability, not the highest possible adjusted profit.

Calculate multiples and an implied range

Consider three synthetic peers with EV/EBITDA multiples of 6×, 8× and 10×. Their median is 8×. If the hypothetical target's comparable EBITDA is ₹50 crore, an 8× multiple implies enterprise value ₹400 crore.

Using a 6×–10× illustrative range gives EV ₹300–₹500 crore. If target net debt is ₹80 crore and there are no other adjustments, implied equity value is ₹220–₹420 crore. Show the EV-to-equity bridge rather than treating enterprise value as shareholder proceeds.

In Excel, calculate each ratio explicitly, use =MEDIAN(range) for the selected peer distribution and multiply by the target's corresponding metric. Ratios with zero or negative denominators need separate treatment. A negative EV/EBITDA number should not enter the median as if it were an ordinary cheap positive multiple.

Explain the range before using it

Compare the target's growth, margins, reinvestment needs and risk with the peers. A lower multiple can reflect weaker economics rather than mispricing. A high multiple may require sustained improvement already embedded in the market price.

Test how the conclusion changes when one peer is removed. With a small dataset, a single company can shift the apparent range substantially. Presenting a median to two decimal places does not increase the quality of a thin peer set.

Damodaran's valuation material connects multiples with underlying fundamentals such as growth, risk and returns on capital. Use that logic to explain adjustments instead of applying an unexplained percentage discount because the target is private or smaller.

Conclude with a conditional valuation range and the main reasons it might be wrong. Cross-check with DCF or transaction evidence where available. The example formulas were not executed in Excel, and no live peer dataset or current stock prices are asserted here. An operational comps table requires dated filings and verified market inputs before investment or deal use.

Quick questions, clear answers

How many peers should I include?

There is no universal correct count. Include enough relevant observations to understand the market while avoiding unrelated businesses that create false precision. Explain the selection criteria, disclose weak comparability and test the effect of individual peers on the range.

Should I always use the median?

The median reduces the effect of extreme observations but does not fix poor peer selection or inconsistent data. Review the distribution and business differences. A carefully justified subset or range can be more informative than one mechanical summary statistic.

Can trading comps value a private company?

They can provide evidence, but differences in size, liquidity, governance, control and information quality need consideration. Do not add a universal discount without analysis. The stake and valuation purpose matter, and the final conclusion may require additional methods and professional judgement.

About this guide

Aniket Thakur prepared this educational guide from secondary research checked on 22 October 2026. All numerical illustrations are hypothetical unless stated otherwise. No investment product was tested, and no individual financial circumstances were assessed. Read the cited primary material and relevant product documents before acting.