Comparable Companies Analysis in Investment Banking Valuation

Comparable Companies Analysis in Investment Banking Valuation is a relative valuation method used to estimate what a company may be worth based on how similar publicly traded businesses are valued in the market. Investment bankers use peer companies, financial metrics and valuation multiples to build a comparable companies analysis, commonly called a comps analysis.

The quality of the analysis depends heavily on selecting relevant peers and using appropriate financial metrics. Analysts generally consider factors such as industry, geography, company size, growth, margins and profitability before comparing multiples such as EV/EBITDA, EV/Revenue and P/E.

How Is Comparable Companies Analysis Used in Investment Banking Valuation?

Comparable Companies Analysis gives investment bankers a market-based reference for estimating the value of a company. Instead of valuing the business only from its own forecasts, analysts compare it with businesses that investors are already valuing in the public market.

1. Select a Relevant Peer Group
   Analysts identify companies with similar business models and characteristics. Industry, geography, revenue, enterprise value, growth rate, margins and profitability can all be considered when building the peer group.

2. Collect Company and Market Data
   Relevant information can include share price, market capitalisation, net debt, enterprise value, revenue, EBITDA, EPS and analyst estimates. This information forms the basis of the comps table.

3. Calculate Trading Multiples
   Financial and market data are used to calculate multiples such as EV/Revenue, EV/EBITDA and P/E. These multiples make it easier to compare companies of different sizes.

4. Establish a Valuation Range
   Analysts generally review the multiples across the peer group and may use median or average values to establish a benchmark. Unusual values may need further review before being used in the valuation.

5. Apply the Selected Multiple
   The selected multiple is applied to the corresponding financial metric of the target company to estimate its implied value. For example, an EV/EBITDA multiple can be applied to the target company's EBITDA to estimate enterprise value.

Which Valuation Multiples Are Used in Comparable Companies Analysis?

The multiple used in a comps analysis depends on the company's industry, business model and available financial information. Common multiples include EV/Revenue, EV/EBITDA, P/E, P/B and EV/Gross Profit.

EV/EBITDA is widely used in valuation because enterprise value can be compared with EBITDA across companies with different capital structures. The formula is:

EV/EBITDA = Enterprise Value ÷ EBITDA

The appropriate multiple should be selected based on the characteristics of the target company and its peer group rather than applying the same multiple in every situation.

How Do You Build a Comparable Companies Analysis in Excel?

Excel is commonly used to organise peer information, calculate trading multiples and present the valuation range. A typical comps table separates market data, financial information and calculated multiples so the analysis can be reviewed easily.

1. Build the Comps Table
   Add the selected companies and enter information such as share price, market capitalisation, net debt, enterprise value, revenue, EBITDA and earnings.

2. Calculate the Multiples
   Use the relevant financial metrics to calculate multiples for each peer. For example:
   EV/EBITDA = Enterprise Value ÷ EBITDA

3. Compare Peer Statistics
   Review the multiples across the peer group and calculate statistics such as minimum, maximum, mean and median. This helps show the range at which comparable companies are being valued.

4. Apply the Multiple to the Target
   Select an appropriate peer multiple and apply it to the target company's corresponding metric.
   Implied Enterprise Value = Target EBITDA × Selected EV/EBITDA Multiple

5. Interpret the Valuation
   The resulting value should be considered alongside the company's business characteristics and other valuation methods. Comparable analysis does not capture every qualitative factor affecting a company's value.

What Are the Applications and Skills of Comparable Companies Analysis in Investment Banking?

Comparable Companies Analysis is used in several investment banking situations, including IPOs, follow-on offerings, M&A advisory, fairness opinions, restructuring and other corporate finance activities.

1. Financial Modeling
   Building a comps analysis develops practical financial modelling skills, including working with financial statements, assumptions, valuation formulas and Excel models.

2. Business Valuation
   You learn how market-based valuation works through comparable companies, DCF and transaction multiples.

3. Excel for Finance
   Comps analysis requires Excel for organising financial data, calculating multiples and presenting valuation ranges, making investment banking Excel skills useful for this type of work.

4. Financial Statement Analysis
   Understanding revenue, EBITDA, earnings, net debt and other financial metrics is important when comparing companies and selecting relevant multiples.

5. M&A and Capital Markets
   Comparable valuation is relevant to activities such as M&A advisory and IPOs, where understanding market-based company valuations can support transaction analysis.

6. Practical Valuation Projects
   Working on comps tables and valuation models can help you apply financial modelling concepts to practical investment banking scenarios.

Skills You Can Build With the PW Skills Investment Banking Course

Comparable Companies Analysis requires more than knowing valuation multiples. You also need financial modelling, Excel, financial statement analysis, valuation, and the ability to present your findings clearly.

The PW Skills Investment Banking Course covers several of these areas through practical learning. You can work towards building skills in:

The course also offers live weekend doubt sessions every Saturday from 7–9 pm, along with communication training under the Premium and Pro plans. 

Comparable Companies Analysis provides a market-based approach to estimating company value by examining how similar businesses are valued. In investment banking, the process involves selecting appropriate peers, gathering financial data, calculating trading multiples and applying relevant multiples to the target company.

Building the analysis in Excel also connects valuation concepts with practical financial modelling and investment banking Excel and financial modelling skills. The results can be considered alongside other approaches such as DCF and precedent transaction analysis when assessing a company's valuation.