Overview
Comparable company analysis (Comps) is a relative valuation technique which compares the valuation multiples of similar public companies and uses them to determine the target value of another company. Unlike the discounted cash flow (DCF) analysis, which is an intrinsic form of valuation where the firm value is calculated using forecasted free cash flows, Comps looks at available market information of industry peer group to estimate the value of a business.

How to Perform Comps Valuation

There are multiple steps in performing a Comps analysis on a target company:
  1. Identify the appropriate group of comparable companies based on criteria such as industry classification, geography, size (revenue, assets, no. of employees), growth rate, and margins.
  2. Gather financial information of the comparable companies from sources such as Bloomberg Terminal, Capital IQ, SEC filings, and company's annual reports.
  3. Create a Comps table listing key information including company name, share price, market capitalization, net debt, enterprise value, revenue, EBITDA, and earnings per share (EPS).
  4. Calculate valuation multiples for these companies; some of the most frequently used multiples are EV/Revenue, EV/EBITDA, P/E, P/NAV, and P/B.
  5. Take the average or median of the comparable companies' multiples and multiply it by the appropriate financial data of the target company to arrive at the enterprise value or equity value.
  Screenshot from the template.

How to Use this Excel Template

This detailed comps table template provides you the proper structure and layout of a professional comps table which can be used to value companies with multiple business segments. This comps analysis is performed on Amazon (AMZN) by comparing its industry peer companies in each segment and calculating the individual enterprise value. At the end, all enterprise values are combined to arrive at the sum-of-the-parts (SOTP) valuation of AMZN. The ultimate goal of this comps table to find out the target share price of Amazon, which investors can use to determine whether they should buy, sell, or hold the company's stocks. Once you've downloaded the template, change the business segments and comparable companies to what you would to analyze. Then, replace all hard-coded numbers in blue font to the appropriate figures of your comparable companies and target company. Finally, the model will automatically generate the enterprise value, market capitalization, and target price for the company. Use this Comps table to perform valuation on companies with complicated business structure at ease!
Share
Reviews Add a review
No reviews yet

More From Corporate Finance Institute®

Browse our top rated business templates. See All
restructuring financial model template preview 1 Restructuring Financial Model Template
198
0
This restructuring financial model template is used to demonstrate the financial interactions behind the restructuring process. Adjust this model to…
TMT Financial Model Template Preview TMT Financial Model Template
310
0
This TMT financial model template is used to value technology, media, and telecom firms. This model provides a template to…
bank financial model template preview 1 Bank Financial Model Template
294
0
This bank financial model template is used to value financial institutions group (FIG) companies. This is a comprehensive model that…
Synthetic Call Chart Option Profit/Loss Graph Maker
897
238
This free Option Profit/Loss Graph Maker allows the user to combine up to ten different types of options as well…
Directional Trading Strategies Template Directional Trading Strategies Template
720
0
The directional trading strategies template allow users to determine the profit when buying options. This template focuses on directional strategies…
HELOC Calculator Template Home Equity Line of Credit (HELOC) Calculator
421
106
This home equity line of credit (HELOC) calculator can calculate the maximum amount of loan a homeowner is eligible to…