Detailed Comps Table Excel Template

Use this Detailed Comps Table Excel Template to perform comparable companies analysis, calculate the valuation multiples and enterprise value, and determine the target share price of a company.

$25.00

Vendor: Corporate Finance Institute®

About this Detailed Comps Table Excel Template

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!

Reviews

There are no reviews yet.

Be the first to review “Detailed Comps Table Excel Template”

Your email address will not be published. Required fields are marked *