The above criteria can be set in a financial database, such as Bloomberg or CapIQ, and exported to Excel for further analysis.
#2 Analyze and refine the available transactions
Once the initial screen has been performed and the data is transferred into Excel, then it’s time to start filtering out the transactions that don’t fit the current situation.
In order to sort and filter the transactions, an analyst has to “scrub” the transactions by carefully reading the business descriptions of the companies on the list and removing any that aren’t a close enough fit.
Many of the transactions would have missing and limited information if the deal terms were not publicly disclosed. The analyst will search high and low for a press release, equity research report, or another source that contains deal metrics. If nothing can be found, those companies will be removed from the list.
#3 Determine a range of valuation multiples
When a shortlist is prepared (following steps 1 and 2), the average, or selected range, of valuation multiples can be calculated.
The most common multiples for precedent transaction analysis are EV/EBITDA and EV/Revenue.
An analyst may exclude any extreme outliers, such as transactions that had EV/EBITDA multiples much lower or much higher than the average (assuming there is a good justification for doing so).
#4 Apply the valuation multiples to the company in question
After a range of valuation multiples from past transactions has been determined, those ratios can be applied to the financial metrics of the company in question.
For example, if the valuation range was:
4.5x EV/EBITDA (low)
6.0x EV/EBITDA (high)
And the company in question has an EBITDA of $150 million,
The valuation ranges for the business would be:
$675 million (low)
$900 million (high)
#5 Graph the results (with other methods) in a football field
Once a valuation range has been determined for the business that’s being valued, it’s important to graph the results so they can be easily understood and compared to other methods.
The Football field chart is the best way to illustrate the various methods on one page in a simple way.
The main valuation methods included in the chart are:
Comparable Company Analysis vs. Precedent Transaction Analysis
Both methods are a form of relative valuation, where the company in question is being compared to other businesses to derive its value. However, “comps” are current multiples that can be observed in the public markets, while “precedents” include a takeover premium and took place in the past.
Shows what a presumably rational investor/acquirer is willing to pay (observable)
The main differences are:
Takeover premium (included in precedents – not in comps)
Timing (precedents quickly become old– comps are current)
Available information (difficult to find for precedents– readily available for comps)
DCF Analysis vs. Precedent Transactions
Discounted Cash Flow (DCF) analysis is a form of an intrinsic valuation performed by building a financial model in Excel. Unlike relative methods, it does not take into account what any other businesses are worth.
Financial modeling is a much more detailed and totally customized way to value a business. A financial forecast is made for the company by building up its revenue drivers, margins, cost structure, capital expenditures, and balance sheet items to determine its unlevered free cash flow.