Training The Street Primers
Training The Street Primers
Training The Street Primers
Valuation Methodologies
In preparation for this training, we have compiled a summary of the primary and select secondary valuation topics that
will be discussed during this workshop. These valuation summaries provide a foundational overview of the valuation
methodologies most commonly used by practitioners in the financial services sector. Additionally, they serve as a good
foundation for understanding these technical concepts in preparation for technical interviews.
It is important to frame this discussion by stating that the technical valuation techniques frequently referenced by
practitioners to value a company fall under two categories: (i) Primary and (ii) Secondary.
Valuation
To gain the most from the workshop and participate in the in-class discussion, it is recommended that this foundational
material is read in its entirety prior to attending the training workshop. A summary of the valuation topics covered in
this document are:
As you review this material it is important that you seek to understand the underlying concepts and their application.
These technical valuation summaries are an excellent learning aid as they attempt to explain the purpose of each of
the valuation topics covered and the context in which they are typically used. This material should take approximately
1.5 – 2 hours to complete.
We hope that you will find this material useful in demystifying the commonly used valuation methodologies by
explaining each of them in a clear and concise manner.
Sincerely,
Training The Street
Preparing Financial Professionals for Success
www.trainingthestreet.com
Overview
Public comparables analysis is a relative valuation approach used by practitioners to evaluate how the equity
markets are valuing a peer group of companies that are like the target company. The public comparables analysis
operates on the basis that all things being equal, similar companies should have similar valuation multiples. The two
most important statistics used in the relative valuation exercise are: (i) the valuation measure (i.e. price per share)
and (ii) the performance measure (i.e. earnings per share or EPS). Each of them conveys information about the
company’s value or performance. But the real power of these metrics lies in combining them to calculate a multiple.
Hence, every relative valuation multiple has the following fundamental structure:
Valuation Measure “Value”
Performance Measure “Value Driver”
The multiples of the peer group are likely to diverge due to several factors, including but not limited to, each
company’s degree of financial risk, profitability & margins, growth prospects and takeover speculation. By analyzing
the key multiples for each of the companies in the peer group, it is possible for practitioners to estimate how the
public equity markets should value the target company. More importantly, this analysis allows practitioners to form
an opinion as to whether a target company is overvalued, fairly valued, or undervalued relative to its peers using
benchmark valuation multiples and performance measures. This approach is usually the first valuation methodology
used by practitioners when undertaking a valuation analysis of a target company.
There are several steps involved in doing a public comparables analysis. They include:
Selecting a peer group to include in a relative valuation analysis can be challenging. Therefore, it is important that
practitioners understand the target company's business beforehand. Ideally, companies that are to comprise the
peer group should have similar operational and financial characteristics as those of the target company. While the
list of common characteristics below is not exhaustive, it provides a broad overview of the practice and includes
suggested sources commonly used by practitioners to create a peer group:
distributor) 6) Shareholder base • Analyst research reports S&P Capital IQ, Value Line, and
5) Customers 7) Business outlook (i.e. Moody's company reports
A meaningful comparison in a relative valuation analysis may only occur when the companies in the peer group
have similar products, profitability statistics, financial leverage, prospects for growth, return measures etc. as the
target company. However, such a scenario is often difficult to realize as practitioners can rarely find companies that
have the exact same operational and financial characteristics. Depending on the size of the peer group,
practitioners may create sector subgroups to better understand and analyze the multiples.
Practitioners typically gather several documents for each company included in the peer group. Gathering the public
information to complete this analysis can be time-consuming and there are some items on the information list that
require a premium service subscription in order to view this information. Below is a list of items required to begin the
exercise of calculating valuation multiples.
1) 10-K (US) or annual report (non-US) for the most recent fiscal year
Obtained from a subscription-based database service, or freely available on the company’s website (usually
under investor relations or a similar section).
2) 10-Q (US) or interim report (non-US) for the most recent period
Obtained from a subscription-based database service, or freely available on the company’s website (usually
under investor relations or a similar section).
5) Most recent closing share price (and most recent dividend per share)
Obtained from a subscription-based database, or freely available on a company’s website or another finance
website (such as Yahoo! Finance or Google Finance).
Noncontrolling
Interest*
Preferred
Stock
Enterprise
Net Debt
Value
Equity
Value
Price x shares
outstanding
Also know as: Market Cap. Also know as: Firm Value. or
or Market Value Aggregate Value
• *It is also referred to as minority interest. It represents the interest of a noncontrolling shareholder in the net assets of a company.
Reflects the market value of the shareholders' Captures the value of an entire company,
residual interest after repaying all senior claims such comprising the sum of all forms of invested capital.
as debt, noncontrolling interest and preferred stock. More importantly, It represents the value of owning
the operating assets of the firm.
• Compute diluted shares to reflect any and all • Use the latest balance sheet information
shares from options, restricted awards, warrants
and convertible securities. • Net Debt = Total debt (interest-bearing liabilities)
less cash and equivalents. Include both the
These instruments are commonly referred to as current portion of long-term debt and long-term
dilutive securities. Practitioners need to know debt as well as short term debt when calculating
what the total number of shares outstanding total debt.
would be if all these instruments were converted • Preferred stock that is not convertible into
into shares. common stock is treated as a financial liability
equal to its liquidation value. Liquidation value is
the amount the firm must pay to eliminate the
obligation.
With most financial performance measures, it is not possible to eliminate all accounting differences between
companies. For example, a company that capitalizes (amount to have been expenses is added onto the balance
sheet and later amortized/expensed over time) most of their research & development costs versus another that
immediately expenses it through the income statement. This treatment would impact key items like operating
income, margins and net income. Therefore, practitioners generally use key performance measures that are least
likely to be distorted because of the company’s capital structure or the adoption of accounting rules. Some of the
standard financial performance measures (and select industry-specific ones) are summarized below:
1) Revenue - referred to as a suitable basis for 4) Unlevered Free Cash Flow (aka UFCF) and can
valuation on the premise that it is largely be defined as:
comparable across different accounting o EBIT * (1 – Tax Rate) + D&A +/- Chng
standards. However, it is an incomplete in W/C – Capex
measure of performance given its lack of focus This amount represents what is available to all
on profitability and cash flow. stakeholders.
Therefore, revenue as a performance measure 5) Earnings Per Share (aka) EPS: The portion of a
and basis for valuation should only be company's net income allocated to each
considered if more relevant profit measures are outstanding share of common stock. Usually, a
unavailable. forward median or average consensus estimate
is used.
2) Earnings Before Interest, Taxes, (aka EBIT)
and; 6) Some industry-specific performance measures
include:
3) Earnings Before Interest, Taxes, Depreciation
and Amortization (aka EBITDA) ─ Same-store sales growth rate compares the
sales of stores that have been open for at
least one year. Allows practitioners to
EBIT and EBITDA capture the "intrinsic core assess the portion of new sales derived from
operational performance" of a business and it is sales growth and the portion that can be
before the effects of the firm’s capital structure attributed to the opening of new stores.
(namely interest expense). In other words, the Commonly used within the retail sector.
performance when all costs that do not occur in
the normal course of business (i.e., restructuring
─ Average revenue per unit (ARPU): allows for
costs, impairment charges, advisory fees) are
the analysis of a company's revenue
ignored. We refer to these as normalized results
generation and growth at the per-unit level.
if any of the aforementioned items have been
Often used in the telecommunications sector.
excluded from the reported results.
*
Reported results adjusted to exclude any extraordinary items and one-time occurrences (e.g., restructuring charges).
**
The price/earnings to growth (PEG) ratio is used to determine a stock's value while taking the company's EPS growth rate into account. It is
considered to provide a more complete picture than the P/E ratio, and the EPS growth rate is based on consensus estimates.
Hint: The general rule on deriving a multiple is that if the performance measure used in the denominator is before
interest expense, then the numerator is the Enterprise Value. Any performance measure used in the denominator
that is after interest expense, the numerator is the Equity Value.
Once the multiples for the peer group have been calculated and a benchmarking analysis against the peers is
undertaken, the practitioner will use their best judgment when choosing the valuation metrics that will serve as the
basis for reaching a conclusion on how the target company trades relative to its peers. The selection of a multiple is
also driven by your perspective (i.e. equity holder or debt holder) as not all multiples apply to all stakeholders.
When benchmarking against peers the focus is on various data points including, but not limited to, growth, margins,
financial risk and return measures.
The public comparable analysis can also raise questions when significant discrepancies exist between the trading
multiples of the target company and those of its closest peers. In this instance, the practitioner is likely to undertake
additional research to better understand the discrepancy which may result in some companies being excluded from
the analysis. Research reports and news articles are good sources to review for insight. In summary, the
practitioner will provide compelling factual arguments to support their conclusions.
Microsoft Corporation $38.31 $318,000.7 $258,703.7 3.10x 8.1x 9.2x 14.0x 38.1% 8.7% 1.6x
(a) Calculated as Market Value of Equity plus total debt, non-controling interest and preferred stock, less cash & equivalents.
(b) Financial data provided by S&P Capital IQ as of Feb-28-2014. Footnotes are used for clarifying difficult
formulas or unusual terminology
A valuation range illustration
To demonstrate the application of deriving an equity value range let’s consider the following. A practitioner
concludes after narrowing the peer group, that a reasonable forward P/E multiple is 12.0x – 15.5x. To calculate an
equity value range, the next step is to apply the P/E multiple ranges to MSFT’s forward EPS consensus estimate of
$2.74. The calculation of the equity value ranges is shown below:
Consensus EPS estimate $2.74 Consensus EPS estimate $2.74
x P / E multiple 12.0x - x P / E multiple 15.5x
= Implied share price $32.88 = Implied share price $42.47
Based on the current share price of $38.31 for MSFT, the company appears to trade at the high end of the range.
The practitioner will defend their conclusion on MSFT being overvalued, fairly valued, or undervalued by performing
a detailed qualitative and quantitative analysis of MSFT against companies in the peer group.
Conclusion
It is important to compare a target company's multiples to those of its peer group in order to bring the comparative
analysis into context. To perform a relative value analysis effectively, practitioners identify the key operating
performance measures and benchmark the subject company against its peers. This analysis can contribute towards
understanding why the multiples trade at different levels. Practitioners in the sector teams will generally have a
fundamental understanding of the business being analyzed and sector nuances. There are a variety of variables
that can influence a company’s market multiple including, but not limited to, market factors, size, financial &
business risk and growth prospects.
The relative value analysis approach is highly subjective and will inherently result in differing valuation ranges, which
is why practitioners often refer to valuation as being part art and part science. To help validate and build confidence
around the valuation ranges, practitioners are likely to perform a Discounted Cash Flow (intrinsic value) analysis to
determine if the intrinsic value falls within the range of those implied under the relative valuation approach as well as
review stock price targets established by equity research analysts that cover the company. Due to the subjective
nature of this exercise, a company’s valuation is rarely quoted as just one value, but rather a range of values.
Remember, a goal of the analysis is to understand how the market is valuing the target company relative to the peer
group. Therefore, it is important to understand what has been priced into the stock of the target company or that of
its peers. For example, has a merger premium been built into the share price of the target company or peers? Are
any of the companies undergoing a restructuring? Analyzing market multiples allows practitioners to form an
opinion as to whether the target company is overvalued, fairly valued or undervalued relative to its peers.
Overview
Acquisition comparables or precedent transaction analysis is another relative valuation technique that is used by
practitioners to derive an implied value of a target company in an M&A context (sometimes referred to as M&A
value). This valuation approach is based on the premise that the implied value of a target company can be
estimated using historical transaction multiples and premiums paid by acquirers for comparable companies under
similar circumstances (i.e. timing, takeover environment, etc.). Examining prior transaction multiples and
premiums allows practitioners to assess what may be necessary for the current situation to gain full or majority
control of a target company or aid the target company’s shareholders on what they should expect to receive in an
acquisition. In other words, the offer price per share takes into consideration both control and potential cost synergies.
However, a limitation of using this analysis is that it is based on historical information.
There are several steps involved in doing a precedent transaction analysis. They include:
1) Determining the transaction list and information sources 4) Compute premiums paid
2) Calculate the valuation measures 5) Analyze the results and derive a valuation range
3) Calculate the multiples
• Industry and financial characteristics – Similar Sales, • Transaction-specific characteristics Domestic vs.
EPS growth and operating margins cross-border, full auction vs. negotiated deal, underlying
market conditions
• Size of the deal – as measured by offer and transaction
value • Timing – The more recent the data, the more relevant
the benchmark. Good to identify any significant
• Nature of the transaction - Hostile, friendly and did industry-wide events occurring at the time (i.e. wave of
multiple bidders exist. Full or majority control consolidation)
• Buyer type: Strategic vs. financial buyer
The precedent transaction analysis requires practitioners to study various documents and extract the relevant
information required to calculate the transaction multiples. Finding appropriate information for this analysis is akin
to putting together pieces of a puzzle using various information sources (i.e. merger agreement, investor
presentations, and regulatory filings). Research reports and industry magazines provide useful background
information on things like the strategic rationale for the transaction etc.
NCI*
Preferred
Stock
Transaction
Net Debt
Value
Offer Value
Offer Price x diluted
shares outstanding
* NCI = noncontrolling interest. It is also referred to as minority interest. It represents the % of equity in a consolidated subsidiary that is
owned by someone else.
The illustration below depicts the standard multiples that are calculated using the transaction and offer value:
An acquirer usually pays a premium above the current share price in order to compensate for the control it is
receiving over the target company. The premium also reflects the buyer’s expectation that the merger will yield
positive synergies (i.e. cost savings) once the two companies are combined, resulting in higher earnings on a
combined versus a standalone basis. Shareholders of the target company recognize this and want to be paid
upfront for it. So, in effect, the premium represents the price paid for control of the company and for the expected
resulting synergies. Because of the inherent price inflation, this analysis typically leads to a higher valuation range
in comparison to those derived from public comparables analysis. The acquisition premium is calculated using
the following formula:
Because information leaks in these kinds of transactions can occur, sudden target company share price increases
may not necessarily reflect improving underlying company fundamentals. Such a share price increase would
ultimately affect the premium paid which is to be used in the precedent transaction analysis. Under this scenario,
practitioners seek to calculate the premium using the company’s unaffected share price. To do so, the share
price at various time periods (i.e. one week prior to announcement) are used to calculate a “true” premium.
Alternatively, the practitioner could create a subset incorporating transactions that occurred in similar market
conditions, involved companies with similar products and services, the companies exhibited similar growth
prospects, operating margins and financial risk. The most appropriate method will depend on the perspective
(target or acquirer) and the situation.
A valuation illustration
To demonstrate the application of deriving an implied transaction and offer value, let’s consider the following. A
practitioner concludes, after a review of precedent transactions, a transaction value multiple of 18.0x – 19.5x and
premium of 30% - 40% are reasonable acquisition parameters to expect under the current situation. Using the
performance measures of the target company and transaction value multiple ranges, the practitioner will calculate
the following transaction and offer values:
For training purposes only Footnotes are used for clarifying difficult
Note: All transactions reported in USD$ formulas or unusual terminology
(a) Calculated as Offer Value of Equity plus total debt, minority interest and preferred stock, less cash & equivalents & unconsolidated affiliates.
Conclusion
The objective of a precedent transaction analysis is to calculate and to understand the premiums and multiples
paid in precedent transactions in which the acquirer sought control of the target company. It also sheds light on
the kind of structure that was used to facilitate the purchase (i.e. % stock / % cash). This analysis lays the
foundation for setting a realistic expectation of an acceptable premium and purchase price multiple in a
contemplated transaction by the shareholders of the target company. An important difference in this analysis,
when compared with the public comparables analysis, is that a control premium is built into the offer price and
therefore the transaction multiples.
Like other valuation techniques, precedent transaction analysis is as much an art as it is a science. Interpretation
of the data requires familiarity with the industry and the assets involved. Often, practitioners will specify a small
subset from a broader group of precedent transactions. These "most comparable transactions" can be analyzed
in more detail to get a better understanding of the circumstances leading to specific valuation levels.
A practitioner needs to know the story for each transaction in order to understand the transaction multiple when
compared to similar transactions. Besides the three main considerations that typically influence multiples –
company size, financial & operating risk and growth prospects – it is important to also understand the impact the
structure (70% stock / 30% cash) and potential synergies had on the final offer price and the resultant multiple.
In practice, finance professionals typically select a forecast period of 5 to 10 years. The length of the
projection period depends on the characteristics of the company and its industry. The main consideration
for determining the length of this period is when the company will reach a “steady state.” One steady-state
indicator is when a company is sustaining its capital investment – that is, all the company’s new spending
goes simply to replacing the fixed assets that they are losing each year from depreciation. This implies that
Conclusion
There is no single right answer when doing a DCF analysis, but there are simple steps one can take to improve
the quality of the analysis. First, use reasonable and defensible assumptions for your forecasted period. The
starting point for assumptions is usually management, consensus estimates, historical analysis or based on
performance of peers. Second, consider materiality when you are trying to develop your assumptions; what is
the impact on the final output? Third, there is no perfect WACC or terminal multiple to use, but observe
industry averages as a sanity check which can be sourced from equity research reports. Fourth, compare your
final equity value per share to the current stock price and calculate the implied CY+1 P/E multiple and compare
against the peer group to build confidence around your assumptions. If your assumptions reflect general
market consensus, then your implied share price should be within a reasonable range of the current share
price. Finally, because a DCF analysis has so many variables, your final equity value per share should be
shown as a range rather than as one single number in order to account for some variability in those
assumptions.
* In this example, net debt refers to all interest-bearing liabilities, plus the value of preferred stock, plus the value on any non-controlling interest
(often called minority interest), less all cash and cash equivalents.
amounts as a percentage of the purchase price (c) Definite life intangibles write-up: 10,215.0 x 10.0% = 1,021.5
and use that as a preliminary assumption. (d) Deferred tax liability = SUM(write-ups) x acquirer tax rate (38.0%)
Phase 3: Calculate Goodwill. Now that you have allocated the excess purchase price to specific assets, the
"residual" goes to goodwill. Goodwill is the excess purchase price over the fair market value of net identifiable
assets acquired.
Note: A deferred tax liability is generated as a result of the incremental depreciation and amortization
from the write-ups. A temporary timing difference arises from this disconnect between when taxes are
reported as opposed to when they’re actually paid.
This is an advanced tax concept and should be discussed in detail with an experienced tax advisor.
Income statement (pre and post-tax) adjustments
There are a few core transaction adjustments that most merger models account for. They are:
(a) Incremental interest expense from new debt issued to finance the transaction
(b) Synergies
▪ Additional cash flows or cost savings resulting from the combination of two similar businesses, divided
into two categories: incremental revenue or cost savings
(c) Additional depreciation and amortization expense resulting from the asset write-ups
(d) Adjusting for forgone interest income on the cash off the existing balance sheet used to finance the
acquisition
(e) New shares issued as part of the transaction consideration
After-tax
Acquirer’s Target’s “Incremental
Calculate pro forma EPS by combining the Pro Forma Net Income + Net Income +/- Adjustments”
=
two companies’ net incomes and then accounting for all EPS
Acquirer’s New
+
incremental adjustments. Shares Outstanding Shares Issued
In the example below, the acquirer’s fiscal year end is December while the targets is September. Only 75% of the
target’s FYE+1 overlaps with FYE+1 of the acquirer’s. 25% of FYE+2 overlaps as well.
LBO Math
An important valuation concept to understand when seeking to derive a levered value is that LBO transactions are
financed and purchased on a multiple of EBITDA. For example, if the purchase price (i.e. transaction value)
multiple for a business is 9.0x EBITDA and the banks determine that their maximum financing level is 5.0x Total
debt / EBITDA, it means that the balance of 4.0x EBITDA would be contributed in the form of equity. The return
(IRR) threshold on these types of investments is typically in excess of 20% over a 5-year period. In other words,
the equity invested grows annually at an average rate of 20% each year until year 5 which is the typical time
period for exiting the investment.
When evaluating a potential LBO on a target company, one of the main areas of focus for a financial sponsor is
the amount of projected free cash flows generated during the investment period of three to five years. This is
important as the cash flows generated will be used to service debt (interest and repayment of principal) created in
connection with the transaction and fund ongoing working capital requirements. Below are some common
calculations to arrive at the potential free cash flow (refer to Private Equity 2) that can be generated by the target
company. The amount of free cash flow would then be used to service interest, principal and possibly pay
dividends, if permitted.
= FCF
Equity 1
$300 FV N
Equity IRR = −1
$725 PV
1
$700
Debt Equity Value exit Holding period
IRR =
Equity Value −1
Debt $375 entry
3) Lender
The funding sources for the LBO include excess cash from the target’s balance sheet, leveraged loans
(secured bank debt), subordinated debt (high yield bonds), mezzanine financing and sponsor equity.
Because the use of financial leverage (or debt) allows for acceptable returns to the sponsor, the lenders play
a pivotal role in a LBO transaction. Debt capacity refers to the amount of leverage that the target company
can support based on the projected cash flow stream. Debt capacity is usually expressed as a multiple of
EBITDA. Determining the debt capacity is a function of assessing the following risks: (i) industry (ii) company,
(iii) structural and (iv) market. Also important is the management track record and the stability of the cash
flows to service the debt. Some of the key factors that
impact debt capacity are: Excess Cash
• Determining “financeable” EBITDA
• Maintenance versus growth CapEx Leveraged • Revolving credit facilities
• Average versus peak working capital requirements Loans • Term loans
• 2nd lien loans
• Historical performance 2.0x – 3.0x
• Achievability of projections
High yield • Senior secured notes
• Depth and quality of management bonds • Senior unsecured notes
• Growth capability given leverage constraints up to 5.0x • Subordinated notes
• Structural risk Mezzanine • PIKs
– Size capital • Warrants
• Convertible securities
– Leverage (e.g., Total and senior debt / EBITDA) up to 6.5x
– Coverage (e.g., EBITDA / Interest coverage) Equity Note: These parameters will
• Precedent LBO transaction debt structures 40% - 50% change with market conditions.
The remaining steps to complete in the model include the calculation of all the relevant ratios and credit
metrics which are usually summarized on one page.
Operating
improvements
driving cash flow
Conclusion
The LBO analysis will result in the practitioner arriving at a “levered” value for the target company.
This resultant value is determined by focusing on key variables such as purchase price multiple, debt financing
parameters, cash flow generation, debt reduction and IRR. Therefore, the LBO model allows a practitioner to
analyze and balance the trade-off between the purchase price multiple, leverage, equity contribution, and IRR in
order to establish what the company is worth to a financial sponsor.