Over 2 million + professionals use CFI to learn accounting, financial analysis, modeling and more. Unlock the essentials of corporate finance with our free resources and get an exclusive sneak peek at the first module of each course.
Start Free
What is Comparable Company Analysis?
Comparable company analysis (or “comps” for short) is a valuation methodology that looks at ratios of similar public companies and uses them to derive the value of another business. Comps is a relative form of valuation, unlike a discounted cash flow (DCF) analysis, which is an intrinsic form of valuation.
In this guide, we will break down all the steps necessary to perform comparable company analysis, as required in most financial analyst jobs.
Steps in Performing Comparable Company Analysis
In the next section of this guide, we will go through a detailed list of how to build your own comps table. This type of work will be routine for anyone working as an analyst in investment banking, equity research, corporate development, or private equity.
1. Find the right comparable companies
This is the first and probably the hardest (or most subjective) step in performing a ratio analysis of public companies. The very first thing an analyst should do is look up the company you are trying to value on CapIQ or Bloomberg so you can get a detailed description and industry classification of the business.
The next step is to search either of those databases for companies that operate in the same industry and that have similar characteristics. The closer the match, the better.
The analyst will run a screen based on criteria that include:
Once you’ve found the list of companies that you feel are most relevant to the company you’re trying to value it’s time to gather their financial information.
Once again, you will probably be working with Bloomberg Terminal or Capital IQ and you can easily use either of them to import financial information directly into Excel.
The information you need will vary widely by industry and the company’s stage in the business lifecycle. For mature businesses, you will look at metrics like EBITDA and EPS, but for earlier stage companies you may look at Gross Profit or Revenue.
If you don’t have access to an expensive tool like Bloomberg or Capital IQ you can manually gather this information from annual and quarterly reports, but it will be much more time-consuming.
With a combination of historical financials and analyst estimates populated in the comps table, it’s time to start calculating the various ratios that will be used to value the company in question.
The main ratios included in a comparable company analysis are:
Download CFI’s Free Comparable Company Analysis Template
Complete the form below to download CFI’s free Comparable Company Analysis template!
5. Use the multiples from the comparable companies to value the company in question
Analysts will typically take the average or median of the comparable companies’ multiples and then apply them to the revenue, gross profit, EBITDA, net income, or whatever metrics they included in the comps table.
In order to come up with a meaningful average, they often remove or exclude outliers and continually massage the numbers until they seem relevant and realistic.
For example, if the average P/E ratio of the group of comparable companies is 12.5 times, then the analyst will multiply the earnings of the company they are trying to value by 12.5 times to arrive at their equity value.
Formatting the Table
For a good financial analyst, formatting matters a lot! In the tables shown above, you can see what type of formatting is recommended.
It’s important to clearly separate market data, financial data, and the multiples into separate sections, so the reader can easily follow the information.
Multiples should have an “x” next to them (which we explain how to do in our free Excel Crash Course) and should be to one decimal place.
The average or median section should be clearly separated at the bottom of the table and indicate if any adjustments have been made.
Interpreting the Results
Once the numbers are complete and the comps table is finalized, it’s time to start interpreting the results. One way to use the information is to look for companies that are overvalued or undervalued. Comps can help you uncover the opportunities, but the results need to be interpreted carefully as they don’t include any qualitative factors whatsoever.
To properly evaluate the numbers in the comps table you have to understand why numbers are what they are. Why does Company A trade at a discounted EV/EBITDA multiple to Company B?
Is it because it’s undervalued and a good buying opportunity?
Or, is it because it has a much lower growth rate and requires more CapEx spending?
Even though Company A trades at a lower multiple, it might actually be “more expensive” than Company B!
This is where the art of being a great financial analyst comes into play.
Applications of Comparable Company Analysis
There are many uses for comps (or comparable companies analysis, or market multiples, or whatever name you use for them). Typically performed by financial analysts and associates, the most common uses include:
Multiples play a significant role in financial modeling. They are commonly used as the terminal value assumption in a Discounted Cash Flow (DCF) model, with the most common assumption being an EV/EBITDA multiple based on currently observable prices in the market.
Multiples can also be used to tie the results of the financial model back to reality. If the result that comes out of the financial model implies a 30x EV/EBITDA multiple, and none of the comps are currently trading about 12x, the model may require some adjusting.
For more on the art of financial modeling, please check out CFI’s wide range of financial modeling courses.
More Resources from CFI
Thank you for reading CFI’s guide to Comparable Company Analysis. At CFI, we’re on a mission to help you advance your career. Some of our most popular free resources include:
CFI is a global provider of financial modeling courses and of the FMVA Certification. CFI’s mission is to help all professionals improve their technical skills. If you are a student or looking for a career change, the CFI website has many free resources to help you jumpstart your Career in Finance. If you are seeking to improve your technical skills, check out some of our most popular courses. Below are some additional resources for you to further explore:
CFI is a global provider of financial modeling courses and of the FMVA Certification. CFI’s mission is to help all professionals improve their technical skills. If you are a student or looking for a career change, the CFI website has many free resources to help you jumpstart your Career in Finance. If you are seeking to improve your technical skills, check out some of our most popular courses. Below are some additional resources for you to further explore:
Below is a break down of subject weightings in the FMVA® financial analyst program. As you can see there is a heavy focus on financial modeling, finance, Excel, business valuation, budgeting/forecasting, PowerPoint presentations, accounting and business strategy.
A well rounded financial analyst possesses all of the above skills!
Additional Questions & Answers
CFI is the global institution behind the financial modeling and valuation analyst FMVA® Designation. CFI is on a mission to enable anyone to be a great financial analyst and have a great career path. In order to help you advance your career, CFI has compiled many resources to assist you along the path.
In order to become a great financial analyst, here are some more questions and answers for you to discover:
Take your learning and productivity to the next level with our Premium Templates.
Upgrading to a paid membership gives you access to our extensive collection of plug-and-play Templates designed to power your performance—as well as CFI's full course catalog and accredited Certification Programs.
Gain unlimited access to more than 250 productivity Templates, CFI's full course catalog and accredited Certification Programs, hundreds of resources, expert reviews and support, the chance to work with real-world finance and research tools, and more.