Stefano Ramella
Nov 2019 · 25 min read
Valuation Models are used to assess the worth of a given company : this is needed for IPO, Acquisition, Mergers. In this article, 3 methods are presented : Discounted Cash Flow Analysis, Comparable Companies Analysis and Precedent Transaction Analysis. Each of these methods can be thought as 5steps process.
————————————–
Overview
The three methods presented here are among the most commonly used among the finance professionals. They rest on different assumptions :

 Discounted Cash Flow Analysis (DCF) : Discounted future free cash flow projections are a good estimate of the worth of the company
 Comparable Companies Analysis (CCA) : Similar companies will have similar valuation multiples
 Past Transaction Analysis (PTA) : Precedent transactions for similar companies are a good estimate of what the company would be worth in the case of an acquisition.
Discounted Cash Flow Analysis (DCF)
Presentation of DCF Analysis
The main assumption behind DCF is that the value of the company of interest is best approached through the present value of all future monetary benefits
Let’s go through each of the five steps.
Step 1 : Determine the Target and the Key Performance Drivers
To perform a DCF, it is key to study and learn as much as possible about the target and the sector in order to avoid misguided assumptions and valuation distortions. This is easily done for public companies (availability of data), but more challenging for private companies.

 If the company is public, data can be get from SEC filing, earnings call transcripts and investor presentations. Equity research reports add additional information on the financial performance estimates
 If the comapy is private, company management is the primary source of data to provide materials containing basic business and financial information
Once the data is acquired, one needs to determine the key performance drivers, as shown below :
Step 2 : Project Free Cash Flow
Free Cash Flow (FCF) is the cash generated by a company after paying all cash operating expenses and associated taxes, as well as the funding of capex and working capital, but prior to the payment of any interest expense. It can computed according to the following formula :
One should consider keep in mind the historical performance of the company as it provides valuable insight for developing defensible assumptions to project FCF : past growth, profit margins are usually a reliable indicator of future performance, especially for mature companies in noncyclical sectors. The Projection Period Length is often set to five years depending on its sector, stage of development, and the predictability of its financial performance.
Step 3 : Calculate the WACC
WACC (Weighted Average Cost of Capital) is the rate used to discount the target’s projected FCF and terminal value to the present : it represents the weighted average of the required return on the invested capital and can be thought of as an opportunity cost of capital or what an investor would expect to earn in an alternative investment with a similar risk profile.
The calculation of the WACC is performed by following these four steps :
1. Determine Target Capital Structure

 Choose a target capital structure that is consistent with the firm long term strategy ( Debt and equity components have different risk profiles and tax ramifications, WACC is dependent on a company’s target capital structure).
 Use comparables from public market to get a proxy of the optimal capital structure
 The target capital structure is represented by debttototal capitalization
2. Estimate Cost of Debt

 A company’s cost of debt reflects its credit profile at the target capital structure
 Cost of debt is generally derived from the blended yield on its outstanding debt instruments
3. Estimate Cost of Equity

 It is the required annual rate of return that a company’s equity investors expect to receive (including dividends)
 CAPM ( Capital Asset Pricing Model ) :

 The riskfree rate is often estimated with TBills and TNotes
 The Market Premium can range from approximately 5% to 8%
 To calculate Beta from the public market one should neutralize the effects of different capital structures “Unlevering the Betas” :

 Once the Unlevered Betas have been computed an average is computed
 The beta is then relevered using the company’s target capital structure
 CAPM is applied with the calculated Beta in order to obtain the cost of equity
4. Calculate WACC
Step 4 : Determine Terminal Value
Terminal Value quantifies the remaining value of the target after the projection period, and is typically calculated on the basis of the company’s FCF in the final year of the projection period. There two widely accepted methods: the exit multiple method (EMM) and the perpetuity growth method (PGM).
Step 5 : Present Value and Valuation
The final step consists in discounting FCF and Terminal Value to calculate the present enterprise value (EV). Present value centers on the notion of time value of money and it is performed by multiplying the FCF for each year in the projection period and the terminal value by its respective discount factor :
Implied equity value and share price can be derived from the EV :
Comparable Companies Analysis (CCA)
Overview of CCA
The logic behind CCA is different from DCF. The approach is comparative and is based on the assumption that similar companies will have similar valuation multiples. The criteria to judge the similarity between companies are mainly based on the size and sector.
Here are the five steps one could follow in order to conduct CCA :
Step 1 : Select the Universe of Comparable Companies
The process of learning the indepth story of the target should be exhaustive. The knowledge of the company and the sectorspecific material is essential : it can be simple and intuitive for certain sectors but challenging for others, especially when peers not readily apparent.
Note that the actual selection of the comparable companies should only begin once this research is completed.
It is important to consider the following points while screening for Comparable Companies :

 Various sources can be used to screen for potential comparable companies. Initially, the focus is on identifying companies with a similar business profile
 Public companies typically discuss their primary competitors
 Additional source for locating comparables is the proxy statement for a relatively recent M&A transaction in the sector as it contains excerpts from a fairness opinions
 Sector knowledge and familiarity with the target from senior bankers could be the most valuable resource
Step 2 : Locate the Necessary Financial Information
The most common sources for public financial data are SEC filings, earnings announcement, investor presentations, equity research reports, consensus estimates and press releases available via Bloomberg. Here is a summary of financial data source that can be used :
Step 3 : Key Statistics, Ratios and Trading Multiples
Several metrics and ratios are to be used here :

 Size
 Profitability
 Gross Profit Margin
 EBITDA Margin
 Ebit Margin
 Net Income Margin
 Growth Profile
 Look at historical and estimated future growth rates as well as compound annual growth rates (CAGRs)

 Return on Investment
 ROIC
 ROE
 ROA
 Credit Profile
 Leverage
 Interest Coverage Ratio
 Return on Investment
Step 4 : Benchmark the Comparable Companies
Benchmarking centers on analyzing and comparing each of the comparable companies with one another and the target. The objective is to determine the target’s relative ranking so as to frame valuation accordingly. Benchmarking is a twofold process :
1. Benchmark the Financial Statistics and Ratios

 It involves the comparison of the target and comparables universe on the basis of key financial performance metrics. Compute the mean, median, minimum and maximum for the universe’s selected financial statistics and ratios
 Benchmarking goes beyond a quantitative comparison but examines the reason the a company’s high and low performance
 Is the company market leader?
 Is it gaining market share?
 Effect of latest announcements?
 What are the strategic initiatives?
2. Benchmark the Trading Multiples

 Get a full range of multiples and assess relative valuation for each of the comparable companies
 After an analysis of the trading multiples, one could operate a refinement of the comparable universe
 Depending on the output it may become apparent that certain outliers need to be excluded from the analysis or that the comparables should be further tiered
Step 5 : Determine Valuation
The mean and medians of the most relevant multiple for the sector are used (typically EV/EBITDA or P/E), then the low and high multiples of the comparables universe are used as floor and ceiling to provide further guidance :
Precedent Transaction Analysis (PTA)
Overview of PTA
PTA logic holds the same logic as CCA, that is relative valuation of a company based on comparison with similar players. The main difference with CCA is that one estimates the value of the company based on previous transactions such as the price paid for similar players. As PTA and CCA are very similar, only an overview of PTA is presented below :
—————————————————————————————————————————————
Stay tuned for other articles from The Finance Association of EPFL! Don’t hesitate to send us any suggestions to tfa@epfl.ch or write to us in our Facebook and Instagram pages
—————————————————————————————————————————————
Written by Stefano Ramella
—————————————————————————————————————————————