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
REIT Financial Model Template
235
0
This REIT financial model template acts as a guideline for modeling a real estate investment trust (REIT). This model will…
Energy Industry Comps Template Energy Industry Comps Template
1,105
65
This energy industry comps template provides a guideline and example of what a comparables universe would look like for a…
Financial Institution Dividend Discount Model
1,722
74
The financial institution dividend discount model uses future dividends to find the implied share price. This model is based on…
Loan Payment Calculator
1,401
0
The loan payment calculator allows users to determine the principal and interest payment each month until the full balance of…
DDM - Excel Dividend Discount Model Template
1,556
113
The dividend discount model template allows investors to value a company base on future dividend payments. This is based on…
Non-directional trading strategy template Non-directional Trading Strategies Template
1,304
0
The non-directional trading strategies template allow users to determine the profit when buying options. This template focuses on non-directional strategies…
See All