CHAPTER 1
Comparable Companies Analysis

Comparable companies analysis (“comparable companies” or “trading comps”) is one of the primary methodologies used for valuing a given focus company, division, business, or collection of assets (“target”). It provides a market benchmark against which a banker can establish valuation for a private company or analyze the value of a public company at a given point in time. Comparable companies has a broad range of applications, most notably for various mergers & acquisitions (M&A) situations, initial public offerings (IPOs), restructurings, and investment decisions.

The foundation for trading comps is built upon the premise that similar companies provide a highly relevant reference point for valuing a given target due to the fact that they share key business and financial characteristics, performance drivers, and risks. Therefore, the banker can establish valuation parameters for the target by determining its relative positioning among peer companies. The core of this analysis involves selecting a universe of comparable companies for the target (“comparables universe”). These peer companies are benchmarked against one another and the target based on various financial statistics and ratios. Trading multiples are then calculated for the universe, which serve as the basis for extrapolating a valuation range for the target. This valuation range is calculated by applying the selected multiples to the target's relevant financial statistics.

While valuation metrics may vary by sector, this chapter focuses on the most widely used trading multiples. These multiples—such as enterprise value-to-earnings before interest, taxes, depreciation, and amortization (EV/EBITDA) and price- to-earnings (P/E)—utilize a measure of value in the numerator and a financial statistic in the denominator. While P/E is the most broadly recognized in circles outside Wall Street, multiples based on enterprise value are widely used by bankers because they are independent of capital structure and other factors unrelated to business operations (e.g., differences in tax regimes and certain accounting policies).

Comparable companies analysis is designed to reflect “current” valuation based on prevailing market conditions and sentiment. As such, in many cases it is more relevant than intrinsic valuation analysis, such as discounted cash flow analysis (see Chapter 3). At the same time, market trading levels may be subject to periods of irrational investor sentiment that skew valuation either too high or too low. Furthermore, no two companies are exactly the same, so assigning a valuation based on the trading characteristics of similar companies may fail to accurately capture a given company's true value.

As a result, trading comps should be used in conjunction with the other valuation methodologies discussed in this book. A material disconnect between the derived valuation ranges from the various methodologies might be an indication that key assumptions or calculations need to be revisited. Therefore, when performing trading comps (or any other valuation/financial analysis exercise), it is imperative to diligently footnote key sources and assumptions both for review and defense of conclusions.

This chapter provides a highly practical, step-by-step approach to performing trading comps consistent with how this valuation methodology is performed in real world applications (see Exhibit 1.1). Once this framework is established, we walk through an illustrative comparable companies analysis using our target company, ValueCo (see Introduction for reference).

c02ex001.eps

EXHIBIT 1.1 Comparable Companies Analysis Steps

SUMMARY OF COMPARABLE COMPANIES ANALYSIS STEPS

  • Step I. Select the Universe of Comparable Companies. The selection of a universe of comparable companies for the target is the foundation for performing trading comps. While this exercise can be fairly simple and intuitive for companies in certain sectors, it can prove challenging for others whose peers are not readily apparent. To identify companies with similar business and financial characteristics, it is first necessary to gain a sound understanding of the target.

    As a starting point, the banker typically consults with peers or senior colleagues to see if a relevant set of comparable companies already exists internally. If beginning from scratch, the banker casts a broad net to review as many potential comparable companies as possible. This broader group is eventually narrowed, and then typically further refined to a subset of “closest comparables.” A survey of the target's public competitors is generally a good place to start identifying potential comparable companies.

  • Step II. Locate the Necessary Financial Information. Once the initial comparables universe is determined, the banker locates the financial information necessary to analyze the selected comparable companies and calculate (“spread”1) key financial statistics, ratios, and trading multiples (see Step III). The primary data for calculating these metrics is compiled from various sources, including a company's SEC filings,2 consensus research estimates, equity research reports, and press releases, all of which are available via Bloomberg.
  • Step III. Spread Key Statistics, Ratios, and Trading Multiples. The banker is now prepared to spread key statistics, ratios, and trading multiples for the comparables universe. This involves calculating market valuation measures such as enterprise value and equity value, as well as key income statement items, such as EBITDA and net income. A variety of ratios and other metrics measuring profitability, growth, returns, and credit strength are also calculated at this stage. Selected financial statistics are then used to calculate trading multiples for the comparables.

    As part of this process, the banker needs to employ various financial concepts and techniques, including the calculation of last twelve months (LTM)3 financial statistics, calendarization of company financials, and adjustments for non-recurring items. These calculations are imperative for measuring the comparables accurately on both an absolute and relative basis (see Step IV).

  • Step IV. Benchmark the Comparable Companies. The next level of analysis requires an in-depth examination of the comparable companies in order to determine the target's relative ranking and closest comparables. To assist in this task, the banker typically lays out the calculated financial statistics and ratios for the comparable companies (as calculated in Step III) alongside those of the target in spreadsheet form for easy comparison (see Exhibits 1.53 and 1.54). This exercise is known as “benchmarking.”

    Benchmarking serves to determine the relative strength of the comparable companies versus one another and the target. The similarities and discrepancies in size, growth rates, margins, and leverage, for example, among the comparables and the target are closely examined. This analysis provides the basis for establishing the target's relative ranking as well as determining those companies most appropriate for framing its valuation. The trading multiples are also laid out in a spreadsheet form for benchmarking purposes (see Exhibits 1.2 and 1.55). At this point, it may become apparent that certain outliers need to be eliminated or that the comparables should be further tiered (e.g., on the basis of size, sub-sector, or ranging from closest to peripheral).

  • Step V. Determine Valuation. The trading multiples of the comparable companies serve as the basis for deriving a valuation range for the target. The banker typically begins by using the means and medians for the relevant trading multiples (e.g., EV/EBITDA) as the basis for extrapolating an initial range. The high and low multiples for the comparables universe provide further guidance in terms of a potential ceiling or floor. The key to arriving at the tightest, most appropriate range, however, is to rely upon the multiples of the closest comparables as guideposts. Consequently, only a few carefully selected companies may serve as the ultimate basis for valuation, with the broader group serving as additional reference points. As this process involves as much “art” as “science,” senior bankers are typically consulted for guidance on the final decision. The chosen range is then applied to the target's relevant financial statistics to produce an implied valuation range.
c01ex002.eps

EXHIBIT 1.2 Comparable Companies Analysis—Trading Multiples Output Page

Bloomberg provides comparable companies analysis via the “Relative Valuation” function (see Appendix 1.1), which calculates key valuation multiples and other metrics for any public company and its peers. The analysis uses an algorithmic approach to identify comparable companies and calculate metrics, and can be customized to reflect a banker's judgment regarding specific calculations and company peers.

STEP I. SELECT THE UNIVERSE OF COMPARABLE COMPANIES

The selection of a universe of comparable companies for the target is the foundation for performing trading comps. In order to identify companies with similar business and financial characteristics, it is first necessary to gain a sound understanding of the target. At its base, the methodology for determining comparable companies is relatively intuitive. Companies in the same sector (or, preferably, “sub-sector”) with similar size tend to serve as good comparables. While this can be a fairly simple exercise for companies in certain sectors, it may prove challenging for others whose peers are not readily apparent.

For a target with no clear, publicly traded comparables, the banker seeks companies outside the target's core sector that share business and financial characteristics on some fundamental level. For example, a medium-sized manufacturer of residential windows may have limited or no truly direct publicly traded peers in terms of products, namely companies that produce windows. If the universe is expanded to include companies that manufacture building products, serve homebuilders, or have exposure to the housing cycle, however, the probability of locating companies with similar business drivers is increased. In this case, the list of potential comparables could be expanded to include manufacturers of related building products such as decking, roofing, siding, doors, and cabinets.

Study the Target

The process of learning the in-depth “story” of the target should be exhaustive as this information is essential for making decisions regarding the selection of appropriate comparable companies. Toward this end, the banker is encouraged to read and study as much company- and sector-specific material as possible. The actual selection of comparable companies should only begin once this research is completed.

For targets that are public registrants,4 annual (10-K) and quarterly (10-Q) SEC filings, consensus research estimates, equity and fixed income research reports, press releases, earnings call transcripts, investor presentations,5 and corporate websites provide key business and financial information. Private companies present a greater challenge as the banker is forced to rely upon sources such as corporate websites, sector research reports, news runs, and trade journals for basic company data. Public competitors' SEC filings, research reports, and investor presentations may also serve as helpful sources of information on private companies. In an organized M&A sale process6 for a private company, however, the banker is provided with detailed business and financial information on the target (see Chapter 6).

Identify Key Characteristics of the Target for Comparison Purposes

A simple framework for studying the target and selecting comparable companies is shown in Exhibit 1.3. This framework, while by no means exhaustive, is designed to determine commonality with other companies by profiling and comparing key business and financial characteristics. Relevant Bloomberg functions for the business and financial framework below are found in Appendix 1.2.

c02ex003.eps

EXHIBIT 1.3 Business and Financial Profile Framework

Business Profile

Companies that share core business characteristics tend to serve as good comparables. These core traits include sector, products and services, customers and end markets, distribution channels, and geography.

Sector

Sector refers to the industry or markets in which a company operates (e.g., consumer products, financials, healthcare, industrials, and technology). A company's sector can be further divided into sub-sectors, which facilitates the identification of the target's closest comparables. Within the industrials sector, for example, there are numerous sub-sectors, such as aerospace and defense, automotive, building products, chemicals, and paper and packaging. Even these sub-sectors can be further segmented—for example, chemicals can be divided into specialty and commodity chemicals. For companies with distinct business divisions, the segmenting of comparable companies by sub-sector may be critical for valuation.

A company's sector conveys a great deal about its key drivers, risks, and opportunities. For example, a cyclical sector such as oil & gas will have dramatically different earnings volatility from consumer staples. On the other hand, cyclical or highly fragmented sectors may present growth opportunities that are unavailable to companies in more stable or consolidated sectors. The proper identification and classification of the target's sector and sub-sector is an essential step toward locating comparable companies.

Products and Services

A company's products and services are at the core of its business model. Accordingly, companies that produce similar products or provide similar services typically serve as good comparables. Products are commodities or value-added goods that a company creates, produces, or refines. Examples of products include computers, lumber, oil, prescription drugs, and steel. Services are acts or functions performed by one entity for the benefit of another. Examples of common services include banking, consulting, installation, lodging, and transportation. Many companies provide both products and services to their customers, while others offer one or the other. Similarly, some companies offer a diversified product and/or service mix, while others are more focused.

Within a given sector or sub-sector, comparable companies may be tiered according to their products and services. For example, within the chemicals sector, specialty chemicals producers tend to consistently trade at a premium to commodity chemicals producers. Hence, they are often grouped together in a tighter comparables category within the broader chemicals universe. The same holds true for the commodity players.

Customers and End Markets
Customers

A company's customers refer to the purchasers of its products and services. Companies with a similar customer base tend to share similar opportunities and risks. For example, companies supplying automobile manufacturers abide by certain manufacturing and distribution requirements, and are subject to the automobile purchasing cycles and trends.

The quantity and diversity of a company's customers are also important. Some companies serve a broad customer base while others may target a specialized or niche market. While it is generally positive to have low customer concentration from a risk management perspective, it is also beneficial to have a stable customer core to provide visibility and comfort regarding future revenues.

End Markets

A company's end markets refer to the broad underlying markets into which it sells its products and services. For example, a plastics manufacturer may sell into several end markets, including automotive, construction, consumer products, medical devices, and packaging. End markets need to be distinguished from customers. For example, a company may sell into the housing end market, but to retailers or suppliers as opposed to homebuilders.

A company's performance is generally tied to economic and other factors that affect its end markets. A company that sells products into the housing end market is susceptible to macroeconomic factors that affect the overall housing cycle, such as interest rates and unemployment levels. Therefore, companies that sell products and services into the same end markets generally share a similar performance outlook, which is important for determining appropriate comparable companies.

Distribution Channels

Distribution channels are the avenues through which a company sells its products and services to the end user. As such, they are a key driver of operating strategy, performance, and, ultimately, value. Companies that sell primarily to the wholesale channel, for example, often have significantly different organizational and cost structures from those selling directly to retailers or end users. Selling to a superstore or value retailer requires a physical infrastructure, sales force, and logistics that may be unnecessary for serving the professional or wholesale channels.

Some companies sell at several levels of the distribution chain, such as wholesale, retail, and direct-to-customer. A flooring manufacturer, for example, may distribute its products through selected wholesale distributors and retailers, as well as directly to homebuilders and end users.

Geography

Companies that are based in (and sell to) different regions of the world often differ substantially in terms of fundamental business drivers and characteristics. These may include growth rates, macroeconomic environment, competitive dynamics, path(s)-to-market, organizational and cost structure, and potential opportunities and risks. Such differences—which result from local demographics, economic drivers, regulatory regimes, consumer buying patterns and preferences, and cultural norms—can vary greatly from country to country and, particularly, from continent to continent. Consequently, there are often valuation disparities for similar companies in different global regions or jurisdictions.7 Therefore, in determining comparable companies, bankers tend to group U.S.-based (or focused) companies in a separate category from European- or Asian-based companies even if their basic business models are the same.

For example, a banker seeking comparable companies for a U.S. retailer would focus primarily on U.S. companies with relevant foreign companies providing peripheral guidance. This geographic grouping is slightly less applicable for truly global industries such as oil and aluminum, for example, where domicile is less indicative than global commodity prices and supply/demand dynamics. Even in these instances, however, valuation disparities by geography are often evident.

Financial Profile

Key financial characteristics must also be examined both as a means of understanding the target and identifying the best comparable companies.

Size

Size is typically measured in terms of market valuation (e.g., equity value and enterprise value), as well as key financial statistics (e.g., sales, gross profit, EBITDA, EBIT, and net income). Companies of similar size in a given sector are more likely to have similar multiples than companies with significant size discrepancies. This reflects the fact that companies of similar size are also likely to be analogous in other respects (e.g., economies of scale, purchasing power, pricing leverage, customers, growth prospects, and the trading liquidity of their shares in the stock market).

Consequently, differences in size often map to differences in valuation. Hence, the comparables are often tiered based on size categories. For example, companies with under $5 billion in equity value (or enterprise value, sales) may be placed in one group and those with greater than $5 billion in a separate group. This tiering, of course, assumes a sufficient number of comparables to justify organizing the universe into sub-groups.

Profitability

A company's profitability measures its ability to convert sales into profit. Profitability ratios (“margins”) employ a measure of profit in the numerator, such as gross profit, EBITDA, EBIT, or net income, and sales in the denominator.8 As a general rule, for companies in the same sector, higher profit margins translate into higher valuations, all else being equal. Consequently, determining a company's relative profitability versus its peers' is a core component of the benchmarking analysis (see Step IV).

Growth Profile

A company's growth profile, as determined by its historical and estimated future financial performance, is a critical driver of valuation. Equity investors reward high growth companies with higher trading multiples than slower growing peers. They also discern whether the growth is primarily organic or acquisition-driven, with the former generally viewed as preferable. In assessing a company's growth profile, historical and estimated future growth rates for various financial statistics (e.g., sales, EBITDA, and earnings per share (EPS)) are examined at selected intervals. For mature public companies, EPS growth rates are typically more meaningful. For early stage or emerging companies with little or no earnings, however, sales or EBITDA growth trends may be more relevant.

Return on Investment

Return on investment (ROI) measures a company's ability to provide earnings (or returns) to its capital providers. ROI ratios employ a measure of profitability (e.g., EBIT, NOPAT,9 or net income) in the numerator and a measure of capital (e.g., invested capital, shareholders' equity, or total assets) in the denominator. The most commonly used ROI metrics are return on invested capital (ROIC), return on equity (ROE), and return on assets (ROA). Dividend yield, which measures the dividend payment that a company's shareholders receive for each share owned, is another type of return metric.

Credit Profile

A company's credit profile refers to its creditworthiness as a borrower. It is typically measured by metrics relating to a company's overall debt level (“leverage”) as well as its ability to make interest payments (“coverage”), and reflects key company and sector-specific benefits and risks. Moody's Investors Service (Moody's), Standard & Poor's (S&P), and Fitch Ratings (Fitch) are the three primary independent credit rating agencies that provide formal assessments of a company's credit profile.

Screen for Comparable Companies

Once the target's basic business and financial characteristics are researched and understood, the banker uses various resources to screen for potential comparable companies. At the initial stage, the focus is on identifying companies with a similar business profile. While basic financial information (e.g., sales, enterprise value, or equity value) should be assessed early on, more detailed financial benchmarking is performed in Step IV.

Investment banks generally have established lists of comparable companies by sector containing relevant multiples and other financial data, which are updated on a quarterly basis and for appropriate company-specific actions. Often, however, the banker needs to start from scratch. In these cases, an examination of the target's public competitors is usually the best place to begin. Competitors generally share key business and financial characteristics and are susceptible to similar opportunities and risks. Public companies typically discuss their primary competitors in their 10-Ks, annual proxy statement (DEF14A),10 and, potentially, in investor presentations. Furthermore, equity research reports, especially those known as initiating coverage,11 often explicitly list the research analyst's views on the target's comparables and/or primary competitors. For private targets, public competitors' 10-Ks, proxy statements, investor presentations, research reports, and broader industry reports are often helpful sources.

An additional source for locating comparables is the proxy statement for a relatively recent M&A transaction in the sector (“merger proxy”),12 as it contains excerpts from a fairness opinion. As the name connotes, a fairness opinion opines on the “fairness” of the purchase price and deal terms offered by the acquirer from a financial perspective (see Chapter 6). The fairness opinion is supported by a detailed overview of the methodologies used to perform a valuation of the target, typically including comparable companies, precedent transactions, DCF analysis, and LBO analysis, if applicable.13 The trading comps excerpt from the fairness opinion generally provides a list of the comparable companies used to value the M&A target as well as the selected range of multiples used in the valuation analysis.

The banker may also screen for companies that operate in the target's sector using SIC, NAICS, or other industry codes.14 Bloomberg provides comprehensive sector classification using such codes as well as proprietary Bloomberg Industry Classification Standard (“BICS”) codes (see Appendix 1.3). This type of screen is typically used either to establish a broad initial universe of comparables or to ensure that no potential companies have been overlooked. Sector reports published by the credit rating agencies (e.g., Moody's, S&P, and Fitch) may also provide helpful lists of peer companies.

In addition to the aforementioned, senior bankers are perhaps the most valuable resources for determining the comparables universe. Given their sector knowledge and familiarity with the target, a brief conversation is usually sufficient for them to provide the junior banker with a strong starting point. Toward the end of the process—once the junior banker has done the legwork to craft and refine a robust list of comparables—a senior banker often provides the finishing touches in terms of more nuanced additions or deletions.

At this stage of the process, there may be sufficient information to eliminate certain companies from the group or tier the selected companies by size, business focus, or geography, for example.

STEP II. LOCATE THE NECESSARY FINANCIAL INFORMATION

This section provides an overview of the relevant sources for locating the necessary financial information to calculate key financial statistics, ratios, and multiples for the selected comparable companies (see Step III). The most common sources for public company financial data are SEC filings (such as 10-Ks, 10-Qs, and 8-Ks), as well as earnings announcements, investor presentations, equity research reports, consensus estimates, and press releases, each of which are available via Bloomberg. A summary list of where to locate key financial data is provided in Exhibit 1.4.

c01ex004.eps

EXHIBIT 1.4 Summary of Financial Data Primary Sources

In trading comps, valuation is driven on the basis of both historical performance (e.g., LTM financial data) and expected future performance (e.g., consensus estimates for future calendar years). Depending on the sector and point in the cycle, however, financial projections tend to be more meaningful. Estimates for forward-year financial performance are typically sourced from consensus estimates such as Bloomberg BEst estimates (see Appendix 1.4)15 as well as individual company equity research reports. In the context of an M&A or debt capital raising transaction, by contrast, more emphasis is placed on LTM financial performance. LTM financial information is calculated on the basis of data obtained from a company's public filings (see Exhibits 1.24 and 1.25).

SEC Filings: 10-K, 10-Q, 8-K, and Proxy Statement

As a general rule, the banker uses SEC filings to source historical financial information for comparable companies. This financial information is used to determine historical sales, gross profit, EBITDA, EBIT, and net income (and EPS) on both an annual and LTM basis. SEC filings are also the primary source for other key financial items such as balance sheet data, capital expenditures (“capex”), basic shares outstanding, stock options/warrants data, and information on non-recurring items. SEC filings can be obtained through numerous mediums, including a company's corporate website (typically through an “Investor Relations” link) as well as EDGAR16 and other financial information services, such as Bloomberg.

10-K (Annual Report)

The 10-K is an annual report filed with the SEC by a public registrant that provides a comprehensive overview of the company and its prior year performance.17 It is required to contain an exhaustive list of disclosure items including, but not limited to, a detailed business description, management's discussion & analysis (MD&A),18 audited financial statements19 and supplementary data, outstanding debt detail, basic shares outstanding, and stock options/warrants data. It also contains an abundance of other pertinent information about the company and its sector, such as business segment detail, customers, end markets, competition, insight into material opportunities (and challenges and risks), significant recent events, and acquisitions.

10-Q (Quarterly Report)

The 10-Q is a quarterly report filed with the SEC by a public registrant that provides an overview of the most recent quarter and year-to-date (YTD) period.20 It is less comprehensive than the 10-K, but provides financial statements as well as MD&A relating to the company's financial performance for the most recent quarter and YTD period versus the prior year periods.21 The 10-Q also provides the most recent share count information and may also contain the most recent stock options/warrants data. For detailed financial information on a company's final quarter of the fiscal year, the banker refers to the 8-K containing the fourth quarter earnings press release that usually precedes the filing of the 10-K.

8-K (Current Report)

The 8-K, or current report, is filed by a public registrant to report the occurrence of material corporate events or changes (“triggering event”) that are of importance to shareholders or security holders.22 For the purposes of preparing trading comps, key triggering events include, but are not limited to, earnings announcements, entry into a definitive purchase/sale agreement,23 completion of an acquisition or disposition of assets, capital markets transactions, and Regulation FD disclosure requirements.24 The corresponding 8-Ks for these events often contain important information necessary to calculate a company's updated financial statistics, ratios, and trading multiples that may not be reflected in the most recent 10-K or 10-Q (see “Adjustments for Recent Events”).

Proxy Statement

A proxy statement is a document that a public company sends to its shareholders prior to a shareholder meeting containing material information regarding matters on which the shareholders are expected to vote. It is also filed with the SEC on Schedule 14A. For the purposes of spreading trading comps, the annual proxy statement provides a basic shares outstanding count that may be more recent than that contained in the latest 10-K or 10-Q. As previously discussed, the annual proxy statement also typically contains a suggested peer group for benchmarking purposes.

Equity Research

Research Reports

Equity research reports provide individual analyst estimates of future company performance, which may be used to calculate forward-looking multiples. They generally include estimates of sales, EBITDA and/or EBIT, and EPS for future quarters and the future two- or three-year period (on an annual basis). More comprehensive reports provide additional estimated financial information from the research analyst's model, including key items from the income statement, balance sheet, and cash flow statement. These reports may also provide segmented financial projections, such as sales and EBIT at the business division level.

Equity research reports often provide commentary on non-recurring items and recent M&A and capital markets transactions, which are helpful for determining pro forma adjustments and normalizing financial data. They may also provide helpful sector and market information, as well as explicitly list the research analyst's view on the company's comparables universe. Initiating coverage research reports tend to be more comprehensive than normal interim reports. As a result, it is beneficial to mine these reports for financial, market, and competitive insights. Research reports can be located through various subscription financial information services such as Bloomberg, where reports are available via function: RES<GO>.

Consensus Estimates

Consensus research estimates for selected financial statistics are widely used by bankers as the basis for calculating forward-looking trading multiples in trading comps. Bloomberg BEst consensus estimates are available via several Bloomberg functions, including Earnings Estimates (EEB<GO>), as well as programmatically via Excel.25

Press Releases and News Runs

A company issues a press release when it has something important to report to the public. Standard press releases include earnings announcements, declaration of dividends, and management changes, as well as M&A and capital markets transactions. Earnings announcements, which are accompanied by the filing of an 8-K, are typically issued prior to the filing of a 10-K or 10-Q. Therefore, the banker relies upon the financial data provided in the earnings announcement to update trading comps in a timely manner. A company may also release an investor presentation to accompany its quarterly earnings call, which may be helpful in readily identifying key financial data and obtaining additional color and commentary. In the event that certain financial information is not provided in the earnings press release, the banker must wait until the filing of the 10-K or 10-Q for complete information. A company's press releases and recent news articles are available on its corporate website as well as through Bloomberg.

Financial Information Services

As discussed throughout this section, Bloomberg is a key source for obtaining SEC filings, research reports, consensus estimates, and press releases, among other items. Bloomberg is also a primary source for current and historical company share price information, which is essential for calculating equity value and determining a company's current share price as a percentage of its 52-week high. Bloomberg Coverage Dashboard summarizes information for investment bankers to monitor and diligence public companies (see Appendix 1.5).

Financial information services, such as Bloomberg, may also be sourced to provide information on a company's credit ratings. If practical, however, we suggest sourcing credit ratings directly from the official Moody's, S&P, and Fitch websites and attributing such information to its original sources.26

Summary of Financial Data Primary Sources

Exhibit 1.4 provides a summary of the primary sources used to obtain the necessary financial information to perform trading comps.

STEP III. SPREAD KEY STATISTICS, RATIOS, AND TRADING MULTIPLES

Once the necessary financial information for each of the comparables has been located, it is entered into an input page (see Exhibit 1.5).27 This sample input page is designed to assist the banker in calculating the key financial statistics, ratios, and multiples for the comparables universe.28 The input page data, in turn, feeds into output sheets that are used to benchmark the comparables (see Exhibits 1.53, 1.54, and 1.55).

c01ex005.eps

EXHIBIT 1.5 Sample Comparable Company Input Page

In the pages that follow, we discuss the financial data displayed on the sample input sheet, as well as the calculations behind them. We also describe the mechanics for calculating LTM financial statistics, calendarizing company financials, and adjusting for non-recurring items and recent events.

Calculation of Key Financial Statistics and Ratios

In this section, we outline the calculation of key financial statistics, ratios, and other metrics in accordance with the financial profile framework introduced in Step I.

  • Size (Market Valuation: equity value and enterprise value; and Key Financial Data: sales, gross profit, EBITDA, EBIT, and net income)
  • Profitability (gross profit, EBITDA, EBIT, and net income margins)
  • Growth Profile (historical and estimated growth rates)
  • Return on Investment (ROIC, ROE, ROA, and dividend yield)
  • Credit Profile (leverage ratios, coverage ratios, and credit ratings)

Size: Market Valuation

Equity Value

Equity value (“market capitalization”) is the value represented by a given company's basic shares outstanding plus “in-the-money” stock options,29 warrants,30 and convertible securities—collectively, “fully diluted shares outstanding.” It is calculated by multiplying a company's current share price31 by its fully diluted shares outstanding (see Exhibit 1.6).

c01ex006.eps

EXHIBIT 1.6 Calculation of Equity Value

When compared to other companies, equity value only provides a measure of relative size. Therefore, for insight on absolute and relative market performance—which is informative for interpreting multiples and framing valuation—the banker looks at the company's current share price as a percentage of its 52-week high. This is a widely used metric that provides perspective on valuation and gauges current market sentiment and outlook for both the individual company and its broader sector. If a given company's percentage is significantly out of line with that of its peers, it is generally an indicator of company-specific (as opposed to sector-specific) issues. For example, a company may have missed its earnings guidance or underperformed versus its peers over the recent quarter(s). It may also be a sign of more entrenched issues involving management, operations, or specific markets.

Calculation of Fully Diluted Shares Outstanding

A company's fully diluted shares are calculated by adding the number of shares represented by its in-the-money options, warrants, and convertible securities to its basic shares outstanding.32 A company's most recent basic shares outstanding count is typically sourced from the first page of its 10-K or 10-Q (whichever is most recent). In some cases, however, the latest proxy statement may contain more updated data and, therefore, should be used in lieu of the 10-K or 10-Q. The most recent stock options/warrants information is obtained from a company's latest 10-K or, in some cases, the 10-Q.

The incremental shares represented by a company's in-the-money options and warrants are calculated in accordance with the treasury stock method (TSM). Those shares implied by a company's in-the-money convertible and equity-linked securities are calculated in accordance with the if-converted method or net share settlement (NSS), as appropriate.

Options and Warrants—The Treasury Stock Method

The TSM assumes that all tranches of in-the-money options and warrants are exercised at their weighted average strike price with the resulting option proceeds used to repurchase outstanding shares of stock at the company's current share price. In-the-money options and warrants are those that have an exercise price lower than the current market price of the underlying company's stock. As the strike price is lower than the current market price, the number of shares repurchased is less than the additional shares outstanding from exercised options. This results in a net issuance of shares, which is dilutive.

In Exhibit 1.7, we provide an example of how to calculate fully diluted shares outstanding using the TSM.

c01ex007.eps

EXHIBIT 1.7 Calculation of Fully Diluted Shares Outstanding Using the Treasury Stock Method

As shown in Exhibit 1.7, the 5 million options are in-the-money as the exercise price of $18.00 is lower than the current share price of $20.00. This means that the holders of the options have the right to buy the company's shares at $18.00 and sell them at $20.00, thereby realizing the $2.00 differential. Under the TSM, it is assumed that the $18.00 of potential proceeds received by the company is used to repurchase shares that are currently trading at $20.00. Therefore, the number of shares repurchased is 90% ($18.00 / $20.00) of the options, or 4.5 million shares in total (90% × 5 million). To calculate net new shares, the 4.5 million shares repurchased are subtracted from the 5 million options, resulting in 0.5 million. These new shares are added to the company's basic shares outstanding to derive fully diluted shares of 100.5 million.

Convertible and Equity-Linked Securities

Outstanding convertible and equity-linked securities also need to be factored into the calculation of fully diluted shares outstanding. Convertible and equity-linked securities bridge the gap between traditional debt and equity, featuring characteristics of both. They include a broad range of instruments, such as traditional cash-pay convertible bonds, convertible hybrids, perpetual convertible preferred, and mandatory convertibles.33

This section focuses on the traditional cash-pay convertible bond as it is the most “plain-vanilla” and commonly issued structure. A cash-pay convertible bond (“convert”) represents a straight debt instrument and an embedded equity call option that provides for the convert to be exchanged into a defined number of shares of the issuer's common stock under certain circumstances. The value of the embedded call option allows the issuer to pay a lower coupon than a straight debt instrument of the same credit. The strike price of the call option (“conversion price”), which represents the share price at which equity would be issued to convertible holders if the bonds were converted, is typically set at a premium to the company's underlying share price at the time of issuance.

For the purposes of performing trading comps, to calculate fully diluted shares outstanding, it is standard practice to first determine whether the company's outstanding converts are in-the-money, meaning that the current share price is above the conversion price. Cash-pay converts are converted into additional shares in accordance with either the if-converted method (physical settlement) or net share settlement, as applicable. Out-of-the-money converts, by contrast, remain treated as debt. Proper treatment of converts requires a careful reading of the relevant footnotes in the company's 10-K or prospectus for the security.

If-Converted Method In accordance with the if-converted method, when performing trading comps, in-the-money converts are converted into additional shares by dividing the convert's amount outstanding by its conversion price.34 Once converted, the convert is treated as equity and included in the calculation of the company's fully diluted shares outstanding and equity value. The equity value represented by the convert is calculated by multiplying the new shares outstanding from conversion by the company's current share price. Accordingly, the convert must be excluded from the calculation of the company's total debt.

As shown in Exhibit 1.8, as the company's current share price of $20.00 is greater than the conversion price of $15.00, we determine that the $150 million convert is in-the-money. Therefore the convert's amount outstanding is simply divided by the conversion price to calculate new shares of 10 million ($150 million / $15.00). The new shares from conversion are then added to the company's basic shares outstanding of 100 million and net new shares from in-the-money options of 0.5 million to calculate fully diluted shares outstanding of 110.5 million.

The conversion of in-the-money converts also requires an upward adjustment to the company's net income to account for the foregone interest expense payments associated with the coupon on the convert. This amount must be tax-effected before being added back to net income. Therefore, while conversion is typically EPS dilutive due to the additional share issuance, net income is actually higher on a pro forma basis.

c01ex008.eps

EXHIBIT 1.8 Calculation of Fully Diluted Shares Outstanding Using the If-Converted Method

Net Share Settlement Net share settlement is an increasingly common feature in convertible bonds. For converts issued with a net share settlement accounting feature,35 the issuer is permitted to satisfy the face (or accreted) value of an in-the-money convert with at least a portion of cash upon conversion. Only the value represented by the excess of the current share price over the conversion price is assumed to be settled with the issuance of additional shares,36 which results in less share issuance. This serves to limit the dilutive effects of conversion by affording the issuer TSM accounting treatment.

As shown in Exhibit 1.9, the if-converted method results in incremental shares of 10 million shares, while NSS results in incremental shares of only 2.5 million. The NSS calculation is conducted by first multiplying the number of underlying shares in the convert of 10 million by the company's current share price of $20.00 to determine the implied conversion value of $200 million. The $50 million spread between the conversion value and par ($200 million − $150 million) is then divided by the current share price to determine the number of incremental shares from conversion of 2.5 million ($50 million / $20.00).37 The $150 million face value of the convert remains treated as debt due to the fact that the issuer typically has the right to settle this amount in cash.

c01ex009.eps

EXHIBIT 1.9 Incremental Shares from If-Converted Versus Net Share Settlement

Enterprise Value

Enterprise value (“total enterprise value” or “firm value”) is the sum of all ownership interests in a company and claims on its assets from both debt and equity holders. As the graphic in Exhibit 1.10 depicts, it is defined as equity value + total debt + preferred stock + noncontrolling interest38 – cash and cash equivalents. The equity value component is calculated on a fully diluted basis.

c01ex010.eps

EXHIBIT 1.10 Calculation of Enterprise Value

Theoretically, enterprise value is considered independent of capital structure, meaning that changes in a company's capital structure do not affect its enterprise value. For example, if a company raises additional debt that is held on the balance sheet as cash, its enterprise value remains constant as the new debt is offset by the increase in cash (i.e., net debt remains the same, see Scenario I in Exhibit 1.11). Similarly, if a company issues equity and uses the proceeds to repay debt, the incremental equity value is offset by the decrease in debt on a dollar- for-dollar basis (see Scenario II in Exhibit 1.11).39 Therefore, these transactions are enterprise value neutral.

In both Scenario I and II, enterprise value remains constant despite a change in the company's capital structure. Hence, similar companies would be expected to have consistent enterprise value multiples despite differences in capital structure. One notable exception concerns highly leveraged companies, which may trade at a discount relative to their peers due to the perceived higher risk of financial distress40 and potential constraints to growth.

c01ex011.eps

EXHIBIT 1.11 Effects of Capital Structure Changes on Enterprise Value

Size: Key Financial Data

  • Sales (or revenue) is the first line item, or “top line,” on an income statement. Sales represents the total dollar amount realized by a company through the sale of its products and services during a given time period. Sales levels and trends are a key factor in determining a company's relative positioning among its peers. All else being equal, companies with greater sales volumes tend to benefit from scale, market share, purchasing power, and lower risk profile, and are often rewarded by the market with a premium valuation relative to smaller peers.
  • Gross Profit, defined as sales less cost of goods sold (COGS),41 is the profit earned by a company after subtracting costs directly related to the production of its products and services. As such, it is a key indicator of operational efficiency and pricing power, and is usually expressed as a percentage of sales for analytical purposes (gross profit margin, see Exhibit 1.12). For example, if a company sells a product for $100, and that product costs $60 in materials, manufacturing, and direct labor to produce, then the gross profit on that product is $40 and the gross profit margin is 40%.
  • EBITDA (earnings before interest, taxes, depreciation and amortization) is an important measure of profitability. As EBITDA is a non-GAAP financial measure and typically not reported by public filers, it is generally calculated by taking EBIT (or operating income/profit as often reported on the income statement) and adding back the depreciation and amortization (D&A) as sourced from the cash flow statement.42 EBITDA is a widely used proxy for operating cash flow as it reflects the company's total cash operating costs for producing its products and services. In addition, EBITDA serves as a fair “apples-to-apples” means of comparison among companies in the same sector because it is free from differences resulting from capital structure (i.e., interest expense) and tax regime (i.e., tax expense).
  • EBIT (earnings before interest and taxes) is often the same as reported operating income, operating profit, or income from operations43 on the income statement found in a company's SEC filings. Like EBITDA, EBIT is independent of tax regime and serves as a useful metric for comparing companies with different capital structures. It is, however, less indicative as a measure of operating cash flow than EBITDA because it includes non-cash D&A expense. Furthermore, D&A reflects discrepancies among different companies in capital spending and/or depreciation policy as well as acquisition histories (amortization).
  • Net income (“earnings” or the “bottom line”) is the residual profit after all of a company's expenses have been netted out. Net income can also be viewed as the earnings available to equity holders once all of the company's obligations have been satisfied (e.g., to suppliers, vendors, service providers, employees, utilities, lessors, lenders, state and local treasuries). Wall Street tends to view net income on a per share basis (i.e., earnings per share or EPS).

Profitability

  • Gross profit margin (“gross margin”) measures the percentage of sales remaining after subtracting COGS (see Exhibit 1.12). It is driven by a company's direct cost per unit, such as materials, manufacturing, and direct labor involved in production. These costs are typically largely variable, as opposed to corporate overhead, which is more fixed in nature.44 Companies ideally seek to increase their gross margin through a combination of improved sourcing/procurement of raw materials and enhanced pricing power, as well as by improving the efficiency of manufacturing facilities and processes.
c01ex012.eps

EXHIBIT 1.12 Gross Profit Margin

  • EBITDA and EBIT margin are accepted standards for measuring a company's operating profitability (see Exhibit 1.13). Accordingly, they are used to frame relative performance both among peer companies and across sectors.
c01ex013.eps

EXHIBIT 1.13 EBITDA and EBIT Margin

  • Net income margin measures a company's overall profitability as opposed to its operating profitability (see Exhibit 1.14). It is net of interest expense and, therefore, affected by capital structure. As a result, companies with similar operating margins may have substantially different net income margins due to differences in leverage. Furthermore, as net income is impacted by taxes, companies with similar operating margins may have varying net income margins due to different tax rates.
c01ex014.eps

EXHIBIT 1.14 Net Income Margin

Growth Profile

A company's growth profile is a critical value driver. In assessing a company's growth profile, the banker typically looks at historical and estimated future growth rates as well as compound annual growth rates (CAGRs) for selected financial statistics (see Exhibit 1.15).

c01ex015.eps

EXHIBIT 1.15 Historical and Estimated Diluted EPS Growth Rates

Historical annual EPS data is typically sourced directly from a company's 10-K or a financial information service that sources SEC filings, such as Bloomberg. As with the calculation of any financial statistic, historical EPS must be adjusted for non-recurring items to be meaningful. The data that serves as the basis for a company's projected 1-year, 2-year, and long-term45 EPS growth rates is generally obtained from consensus estimates.

Return on Investment

  • Return on invested capital (ROIC) measures the return generated by all capital provided to a company. As such, ROIC utilizes a pre-interest earnings statistic in the numerator, such as EBIT or tax-effected EBIT (also known as NOPAT or EBIAT) and a metric that captures both debt and equity in the denominator (see Exhibit 1.16). The denominator is typically calculated on an average basis (e.g., average of the balances as of the prior annual and most recent periods).
c01ex016.eps

EXHIBIT 1.16 Return on Invested Capital

  • Return on equity (ROE) measures the return generated on the equity provided to a company by its shareholders. As a result, ROE incorporates an earnings metric net of interest expense, such as net income, in the numerator and average shareholders' equity in the denominator (see Exhibit 1.17). ROE is an important indicator of performance as companies are intently focused on shareholder returns.
c01ex017.eps

EXHIBIT 1.17 Return on Equity

  • Return on assets (ROA) measures the return generated by a company's asset base, thereby providing a barometer of the asset efficiency of a business. ROA typically utilizes net income in the numerator and average total assets in the denominator (see Exhibit 1.18).
c01ex018.eps

EXHIBIT 1.18 Return on Assets

  • Dividend yield is a measure of returns to shareholders, but from a different perspective than earnings-based ratios. Dividend yield measures the annual dividends per share paid by a company to its shareholders (which can be distributed either in cash or additional shares), expressed as a percentage of its share price. Dividends are typically paid on a quarterly basis and, therefore, must be annualized to calculate the implied dividend yield (see Exhibit 1.19).46 For example, if a company pays a quarterly dividend of $0.05 per share ($0.20 per share on an annualized basis) and its shares are currently trading at $10.00, the dividend yield is 2% (($0.05 × 4 payments) / $10.00).
c01ex019.eps

EXHIBIT 1.19 Implied Dividend Yield

Credit Profile

Leverage Leverage refers to a company's debt level. It is typically measured as a multiple of EBITDA (e.g., debt-to-EBITDA) or as a percentage of total capitalization (e.g., debt-to-total capitalization). Both debt and equity investors closely track a company's leverage as it reveals a great deal about financial policy, risk profile, and capacity for growth. As a general rule, the higher a company's leverage, the higher its risk of financial distress due to the burden associated with greater interest expense and principal repayments.

  • Debt-to-EBITDA depicts the ratio of a company's debt to its EBITDA, with a higher multiple connoting higher leverage (see Exhibit 1.20). It is generally calculated on the basis of LTM financial statistics. There are several variations of this ratio, including total debt-to-EBITDA, senior secured debt- to-EBITDA, net debt-to-EBITDA, and total debt-to-(EBITDA less capex). As EBITDA is typically used as a rough proxy for operating cash flow, this ratio can be viewed as a measure of how many years of a company's cash flows are needed to repay its debt.
c01ex020.eps

EXHIBIT 1.20 Leverage Ratio

  • Debt-to-total capitalization measures a company's debt as a percentage of its total capitalization (debt + preferred stock + noncontrolling interest + equity) (see Exhibit 1.21). This ratio can be calculated on the basis of book or market values depending on the situation. As with debt-to-EBITDA, a higher debt-to-total capitalization ratio connotes higher debt levels and risk of financial distress.
c01ex021.eps

EXHIBIT 1.21 Capitalization Ratio

Coverage

Coverage is a broad term that refers to a company's ability to meet (“cover”) its interest expense obligations. Coverage ratios are generally comprised of a financial statistic representing operating cash flow (e.g., LTM EBITDA) in the numerator and LTM interest expense in the denominator. There are several variations of the coverage ratio, including EBITDA-to-interest expense, (EBITDA less capex)-to-interest expense, and EBIT-to-interest expense (see Exhibit 1.22). Intuitively, the higher the coverage ratio, the better positioned the company is to meet its debt obligations and, therefore, the stronger its credit profile.

c01ex022.eps

EXHIBIT 1.22 Interest Coverage Ratio

Credit Ratings

A credit rating is an assessment47 by an independent rating agency of a company's ability and willingness to make full and timely payments of amounts due on its debt obligations. Credit ratings are typically required for companies seeking to raise debt financing in the capital markets as only a limited class of investors will participate in a corporate debt offering without an assigned credit rating on the new issue.48

The three primary credit rating agencies are Moody's, S&P, and Fitch. Nearly every public debt issuer receives a rating from Moody's, S&P, and/or Fitch. Moody's uses an alphanumeric scale, while S&P and Fitch both use an alphabetic system combined with pluses (+) and minuses (–) to rate the creditworthiness of an issuer. The ratings scales of the primary rating agencies are shown in Exhibit 1.23.

c01ex006.eps

EXHIBIT 1.23 Ratings Scales of the Primary Rating Agencies

Supplemental Financial Concepts and Calculations

Calculation of LTM Financial Data

U.S. public filers are required to report their financial performance on a quarterly basis, including a full year report filed at the end of the fiscal year. Therefore, in order to measure financial performance for the most recent annual or LTM period, the company's financial results for the previous four quarters are summed. This financial information is sourced from the company's most recent 10-K and 10-Q, as appropriate. As previously discussed, however, prior to the filing of the 10-Q or 10-K, companies typically issue a detailed earnings press release in an 8-K with the necessary financial data to help calculate LTM performance. Therefore, it may be appropriate to use a company's earnings announcement to update trading comps on a timely basis.

As the formula in Exhibit 1.24 illustrates, LTM financials are typically calculated by taking the full prior fiscal year's financial data, adding the YTD financial data for the current year period (“current stub”), and then subtracting the YTD financial data from the prior year (“prior stub”).

c01ex024.eps

EXHIBIT 1.24 Calculation of LTM Financial Data

In the event that the most recent quarter is the fourth quarter of a company's fiscal year, then no LTM calculations are necessary as the full prior fiscal year (as reported) serves as the LTM period. Exhibit 1.25 shows an illustrative calculation for a given company's LTM sales for the period ending 9/30/2012.

c01ex025.eps

EXHIBIT 1.25 Calculation of LTM 9/30/2012 Sales

Calendarization of Financial Data

The majority of U.S. public filers report their financial performance in accordance with a fiscal year (FY) ending December 31, which corresponds to the calendar year (CY) end. Some companies, however, report on a different schedule (e.g., a fiscal year ending April 30). Any variation in fiscal year ends among comparable companies must be addressed for benchmarking purposes. Otherwise, the trading multiples will be based on financial data for different periods and, therefore, not truly “comparable.”

To account for variations in fiscal year ends among comparable companies, each company's financials are adjusted to conform to a calendar year end in order to produce a “clean” basis for comparison, a process known as “calendarization.” This is a relatively straightforward algebraic exercise, as illustrated by the formula in Exhibit 1.26, used to calendarize a company's fiscal year sales projection to produce a calendar year sales projection.49

c01ex026.eps

EXHIBIT 1.26 Calendarization of Financial Data

Note: “Month #” refers to the month in which the company's fiscal year ends (e.g., the Month # for a company with a fiscal year ending April 30 would be 4). FYA = fiscal year actual, and NFY = next fiscal year.

Exhibit 1.27 provides an illustrative calculation for the calendarization of a company's calendar year 2012 estimated (E) sales, assuming a fiscal year ending April 30.

c01ex027.eps

EXHIBIT 1.27 Calendarization of Sales

Adjustments for Non-Recurring Items

To assess a company's financial performance on a “normalized” basis, it is standard practice to adjust reported financial data for non-recurring items, a process known as “scrubbing” or “sanitizing” the financials. Failure to do so may lead to the calculation of misleading ratios and multiples, which, in turn, may produce a distorted view of valuation. These adjustments involve the add-back or elimination of one-time charges and gains, respectively, to create a more indicative view of ongoing company performance. Typical charges include those incurred for restructuring events (e.g., store/plant closings and headcount reduction), losses on asset sales, changes in accounting principles, inventory write-offs, goodwill impairment, extinguishment of debt, and losses from litigation settlements, among others. Typical benefits include gains from asset sales, favorable litigation settlements, and tax adjustments, among others.

Non-recurring items are often described in the MD&A section and financial footnotes in a company's public filings (e.g., 10-K and 10-Q) and earnings announcements. These items are often explicitly depicted as “non-recurring,” “extraordinary,” “unusual,” or “one-time.” Therefore, the banker is encouraged to comb electronic versions of the company's public filings and earnings announcements using word searches for these adjectives. Often, non-recurring charges or benefits are explicitly broken out as separate line items on a company's reported income statement and/or cash flow statement. Research reports can be helpful in identifying these items, while also providing color commentary on the reason they occurred.

In many cases, however, the banker must exercise discretion as to whether a given charge or benefit is non-recurring or part of normal business operations. This determination is sometimes relatively subjective, further compounded by the fact that certain events may be considered non-recurring for one company, but customary for another. For example, a generic pharmaceutical company may find itself in court frequently due to lawsuits filed by major drug manufacturers related to patent challenges. In this case, expenses associated with a lawsuit should not necessarily be treated as non-recurring because these legal expenses are a normal part of ongoing operations. While financial information services such as Bloomberg provide a breakdown of recommended adjustments that can be helpful in identifying potential non-recurring items, ultimately the banker should exercise professional judgment.

When adjusting for non-recurring items, it is important to distinguish between pre-tax and after-tax amounts. For a pre-tax restructuring charge, for example, the full amount is simply added back to calculate adjusted EBIT and EBITDA. To calculate adjusted net income, however, the pre-tax restructuring charge needs to be tax-effected50 before being added back. Conversely, for after-tax amounts, the disclosed amount is simply added back to net income, but must be “grossed up” at the company's tax rate (t) (i.e., divided by (1 – t)) before being added back to EBIT and EBITDA.

Exhibit 1.28 provides an illustrative income statement for the fiscal year 2011 as it might appear in a 10-K. Let's assume the corresponding notes to these financials mention that the company recorded one-time charges related to an inventory write-down ($5 million pre-tax) and restructuring expenses from downsizing the sales force ($10 million pre-tax). Provided we gain comfort that these charges are truly non-recurring, we would need to normalize the company's earnings statistics accordingly for these items in order to arrive at adjusted EBIT, EBITDA, and diluted EPS.

c01ex028.eps

EXHIBIT 1.28 Reported Income Statement

As shown in Exhibit 1.29, to calculate adjusted EBIT and EBITDA, we add back the full pre-tax charges of $5 million and $10 million ($15 million in total). This provides adjusted EBIT of $150 million and adjusted EBITDA of $200 million. To calculate adjusted net income and diluted EPS, however, the tax expense on the incremental $15 million pre-tax earnings must be subtracted. Assuming a 40% marginal tax rate, we calculate tax expense of $6 million and additional net income of $9 million ($15 million – $6 million). The $9 million is added to reported net income, resulting in adjusted net income of $69 million. We then divide the $69 million by weighted average fully diluted shares outstanding of 30 million to calculate adjusted diluted EPS of $2.30.

c01ex029.eps

EXHIBIT 1.29 Adjusted Income Statement

Adjustments for Recent Events

In normalizing a company's financials, the banker must also make adjustments for recent events, such as M&A transactions, financing activities, conversion of convertible securities, stock splits, or share repurchases in between reporting periods. Therefore, prior to performing trading comps, the banker checks company SEC filings (e.g., 8-Ks, registration statements/prospectuses51) and press releases since the most recent reporting period to determine whether the company has announced such activities.

For a recently announced M&A transaction, for example, the company's financial statements must be adjusted accordingly. The balance sheet is adjusted for the effects of the transaction by adding the purchase price financing (including any refinanced or assumed debt), while the LTM income statement is adjusted for the target's incremental sales and earnings. Equity research analysts typically update their estimates for a company's future financial performance promptly following the announcement of an M&A transaction. Therefore, the banker can use updated consensus estimates in combination with the pro forma balance sheet to calculate forward-looking multiples.52

Calculation of Key Trading Multiples

Once the key financial statistics are spread, the banker proceeds to calculate the relevant trading multiples for the comparables universe. While various sectors may employ specialized or sector-specific valuation multiples (see Exhibit 1.33), the most generic and widely used multiples employ a measure of market valuation in the numerator (e.g., enterprise value, equity value) and a universal measure of financial performance in the denominator (e.g., EBITDA, net income). For enterprise value multiples, the denominator employs a financial statistic that flows to both debt and equity holders, such as sales, EBITDA, and EBIT. For equity value (or share price) multiples, the denominator must be a financial statistic that flows only to equity holders, such as net income (or diluted EPS). Among these multiples, EV/EBITDA and P/E are the most common.

The following sections provide an overview of the more commonly used equity value and enterprise value multiples.

Equity Value Multiples

Price-to-Earnings Ratio / Equity Value-to-Net Income Multiple

The P/E ratio, calculated as current share price divided by diluted EPS (or equity value divided by net income), is the most widely recognized trading multiple. Assuming a constant share count, the P/E ratio is equivalent to equity value-to-net income. These ratios can also be viewed as a measure of how much investors are willing to pay for a dollar of a company's current or future earnings. P/E ratios are typically based on forward-year EPS53 (and, to a lesser extent, LTM EPS) as investors are focused on future growth. Companies with higher P/Es than their peers tend to have higher earnings growth expectations.

The P/E ratio is particularly relevant for mature companies that have a demonstrated ability to consistently grow earnings. However, while the P/E ratio is broadly used and accepted, it has certain limitations. For example, it is not relevant for companies with little or no earnings as the denominator in these instances is de minimis, zero, or even negative. In addition, as previously discussed, net income (and EPS) is net of interest expense and, therefore, dependent on capital structure. As a result, two otherwise similar companies in terms of size and operating margins can have substantially different net income margins (and consequently P/E ratios) due to differences in leverage. Similarly, accounting discrepancies, such as for depreciation or taxes, can also produce meaningful disparities in P/E ratios among comparable companies.

The two formulas for calculating the P/E ratio (both equivalent, assuming a constant share count) are shown in Exhibit 1.30.

c01ex030.eps

EXHIBIT 1.30 Equity Value Multiples

Enterprise Value Multiples

Given that enterprise value represents the interests of both debt and equity holders, it is used as a multiple of unlevered financial statistics such as sales, EBITDA, and EBIT. The most generic and widely used enterprise value multiples are EV/EBITDA, EV/EBIT, and EV/sales (see Exhibits 1.31 and 1.32). As with P/E ratios, enterprise value multiples tend to focus on forward estimates in addition to LTM statistics for framing valuation.

Enterprise Value-to-EBITDA and Enterprise Value-to-EBIT Multiples

EV/EBITDA serves as a valuation standard for most sectors. It is independent of capital structure and taxes, as well as any distortions that may arise from differences in D&A among different companies. For example, one company may have spent heavily on new machinery and equipment in recent years, resulting in increased D&A for the current and future years, while another company may have deferred its capital spending until a future period. In the interim, this situation would produce disparities in EBIT margins between the two companies that would not be reflected in EBITDA margins.

For the reasons outlined above, as well as potential discrepancies due to acquisition-related amortization, EV/EBIT is less commonly used than EV/EBITDA. However, EV/EBIT may be helpful in situations where D&A is unavailable (e.g., when valuing divisions of public companies) or for companies with high capex.

c01ex031.eps

EXHIBIT 1.31 Enterprise Value-to-EBITDA and Enterprise Value-to-EBIT

Enterprise Value-to-Sales Multiple

EV/sales is also used as a valuation metric, although it is typically less relevant than the other multiples discussed. Sales may provide an indication of size, but it does not necessarily translate into profitability or cash flow generation, both of which are key value drivers. Consequently, EV/sales is used largely as a sanity check on the earnings-based multiples discussed above.

In certain sectors, however, as well as for companies with little or no earnings, EV/sales may be relied upon as a meaningful reference point for valuation. For example, EV/sales may be used to value an early stage technology company that is aggressively growing sales, but has yet to achieve profitability.

c01ex032.eps

EXHIBIT 1.32 Enterprise Value-to-Sales

Sector-Specific Multiples Many sectors employ specific valuation multiples in addition to, or instead of, the traditional metrics previously discussed. These multiples use an indicator of market valuation in the numerator and a key sector-specific financial, operating, or production/capacity statistic in the denominator. Selected examples are shown in Exhibit 1.33. Bloomberg provides many data sets and analyses specific to individual industries via Bloomberg Industries (BI<GO>). Appendix 1.6 displays an example of comparable companies for Basic & Diversified Chemicals, in which P/E, EV/EBITDA, and P/FCF are displayed.

c02ex0033.eps

EXHIBIT 1.33 Selected Sector-Specific Valuation Multiples

STEP IV. BENCHMARK THE COMPARABLE COMPANIES

Once the initial universe of comparable companies is selected and key financial statistics, ratios, and trading multiples are spread, the banker is set to perform benchmarking analysis. Benchmarking centers on analyzing and comparing each of the comparable companies with one another and the target. The ultimate objective is to determine the target's relative ranking so as to frame valuation accordingly. While the entire universe provides a useful perspective, the banker typically hones in on a selected group of closest comparables as the basis for establishing the target's implied valuation range. The closest comparables are generally those most similar to the target in terms of business and financial profile.

We have broken down the benchmarking exercise into a two-stage process. First, we benchmark the key financial statistics and ratios for the target and its comparables in order to establish relative positioning, with a focus on identifying the closest or “best” comparables and noting potential outliers. Second, we analyze and compare the trading multiples for the peer group, placing particular emphasis on the best comparables.

Benchmark the Financial Statistics and Ratios

The first stage of the benchmarking analysis involves a comparison of the target and comparables universe on the basis of key financial performance metrics. These metrics, as captured in the financial profile framework outlined in Steps I and III, include measures of size, profitability, growth, returns, and credit strength. They are core value drivers and typically translate directly into relative valuation. The results of the benchmarking exercise are displayed on spreadsheet output pages that present the data for each company in an easy-to-compare format (see Exhibits 1.53 and 1.54). These pages also display the mean, median, maximum (high), and minimum (low) for the universe's selected financial statistics and ratios.

A thoughtful benchmarking analysis goes beyond a quantitative comparison of the comparables' financial metrics. In order to truly assess the target's relative strength, the banker needs to have a strong understanding of each comparable company's story. For example, what are the reasons for the company's high or low growth rates and profit margins? Is the company a market leader or laggard, gaining or losing market share? Has the company been successful in delivering upon announced strategic initiatives or meeting earnings guidance? Has the company announced any recent M&A transactions or significant ownership/management changes? The ability to interpret these issues, in combination with the above-mentioned financial analysis, is critical to assessing the performance of the comparable companies and determining the target's relative position.

Benchmark the Trading Multiples

The trading multiples for the comparables universe are also displayed on a spreadsheet output page for easy comparison and analysis (see Exhibit 1.55). This enables the banker to view the full range of multiples and assess relative valuation for each of the comparable companies. As with the financial statistics and ratios, the means, medians, highs, and lows for the range of multiples are calculated and displayed, providing a preliminary reference point for establishing the target's valuation range.

Once the trading multiples have been analyzed, the banker conducts a further refining of the comparables universe. Depending on the resulting output, it may become apparent that certain outliers need to be excluded from the analysis or that the comparables should be further tiered (e.g., on the basis of size, sub-sector, or ranging from closest to peripheral). The trading multiples for the best comparables are also noted as they are typically assigned greater emphasis for framing valuation.

STEP V. DETERMINE VALUATION

The trading multiples for the comparable companies serve as the basis for deriving an appropriate valuation range for the target. The banker typically begins by using the means and medians of the most relevant multiple for the sector (e.g., EV/EBITDA or P/E) to extrapolate a defensible range of multiples. The high and low multiples of the comparables universe provide further guidance. The multiples of the best comparables, however, are typically relied upon as guideposts for selecting the tightest, most appropriate range.

Consequently, as few as two or three carefully selected comparables often serve as the ultimate basis for valuation, with the broader group providing reference points. Hence, the selected multiple range is typically tighter than that implied by simply taking the high and low multiples for the universe. As part of this exercise, the banker must also determine which period financial data is most relevant for calculating the trading multiples. Depending on the sector, point in the business cycle, and comfort with consensus estimates, the comparable companies may be trading on the basis of LTM, one-year forward, or even two-year forward financials.

As shown in the illustrative example in Exhibit 1.34, the target has three closest comparables that trade in the range of approximately 6.5x to 7.5x 2012E EBITDA, versus a high/low range of 5.5x to 8.5x, a mean of 7.0x and a median of 6.8x.

c01ex034.eps

EXHIBIT 1.34 Selected Enterprise Value-to-EBITDA Multiple Range

The selected multiple range is then applied to the target's appropriate financial statistics to derive an implied valuation range.

Valuation Implied by EV/EBITDA

Exhibit 1.35 demonstrates how a given EV/EBITDA multiple range translates into an implied range for enterprise value, equity value, and share price. For these calculations, we assume net debt54 of $500 million and fully diluted shares outstanding of 100 million.55

c01ex035.eps

EXHIBIT 1.35 Valuation Implied by EV/EBITDA

At a 6.5x to 7.5x multiple range for 2012E EBITDA, the endpoints are multiplied by the target's 2012E EBITDA of $215 million to produce an implied enterprise value range of $1,398 million to $1,613 million.

To calculate implied equity value, we subtract net debt of $500 million from enterprise value, which results in a range of $898 million to $1,113 million. For public companies, the implied equity value is then divided by fully diluted shares outstanding to yield implied share price. Dividing the endpoints of the equity value range by fully diluted shares outstanding of 100 million provides an implied share price range of $8.98 to $11.13. The same methodology can then be performed using the selected multiple range for EV/LTM EBITDA and EV/2013E EBITDA.

Valuation Implied by P/E

Exhibits 1.36 and 1.37 demonstrate how the P/E ratio translates into implied share price and enterprise value ranges. As with the example in Exhibit 1.35, we assume net debt of $500 million and a static fully diluted shares outstanding count of 100 million.

Implied Share Price

For a public company, the banker typically begins with net income and builds up to implied equity value. The implied equity value is then divided by fully diluted shares outstanding to calculate implied share price. A P/E multiple range of 12.0x to 15.0x 2012E net income, for example, yields an implied equity value of $900 million to $1,125 million when multiplied by the target's 2012E net income of $75 million. Dividing this range by fully diluted shares outstanding of 100 million produces an implied share price range of $9.00 to $11.25.

c01ex036.eps

EXHIBIT 1.36 Valuation Implied by P/E – Share Price

Implied Enterprise Value

To calculate an implied enterprise value range using the assumptions above, the same P/E multiple range of 12.0x to 15.0x is multiplied by 2012E net income of $75 million to produce an implied equity value range of $900 million to $1,125 million. Net debt of $500 million is added to the low and high endpoints of the implied equity value range to calculate an implied enterprise value range of $1,400 million to $1,625 million.

c01ex037.eps

EXHIBIT 1.37 Valuation Implied by P/E – Enterprise Value

As a final consideration, it is necessary to analyze the extrapolated valuation range for the target and test the key assumptions and conclusions. The banker should also compare the valuation derived from comparable companies to other methodologies, such as precedent transactions, DCF analysis, and LBO analysis (if applicable). Significant discrepancies may signal incorrect assumptions, misjudgment, or even mathematical error, thereby prompting the banker to re-examine the inputs and assumptions used in each technique. Common errors in trading comps typically involve the inclusion or over-emphasis of inappropriate comparable companies, incorrect calculations (e.g., fully diluted equity value, enterprise value, LTM financial data, or calendarization), as well as the failure to accurately scrub the financials for non-recurring items and recent events.

KEY PROS AND CONS

Pros

  • Market-based – information used to derive valuation for the target is based on actual public market data, thereby reflecting the market's growth and risk expectations, as well as overall sentiment
  • Relativity – easily measurable and comparable versus other companies
  • Quick and convenient – valuation can be determined on the basis of a few easy-to-calculate inputs
  • Current – valuation is based on prevailing market data, which can be updated on a daily (or intraday) basis

Cons

  • Market-based – valuation that is completely market-based can be skewed during periods of irrational exuberance or bearishness
  • Absence of relevant comparables – “pure play” comparables may be difficult to identify or even non-existent, especially if the target operates in a niche sector, in which case the valuation implied by trading comps may be less meaningful
  • Potential disconnect from cash flow – valuation based on prevailing market conditions or expectations may have significant disconnect from the valuation implied by a company's projected cash flow generation (e.g., DCF analysis)
  • Company-specific issues – valuation of the target is based on the valuation of other companies, which may fail to capture target-specific strengths, weaknesses, opportunities, and risks

ILLUSTRATIVE COMPARABLE COMPANIES ANALYSIS FOR VALUECO

The following section provides a detailed, step-by-step example of how comparable companies analysis is used to establish a valuation range for our illustrative target company, ValueCo. For the purposes of Chapters 1 through 6, we assume that ValueCo is a private company and that the financial statistics and valuation multiples throughout the book represent normalized economic and market conditions.

Step I. Select the Universe of Comparable Companies

Study the Target

Our first task was to learn ValueCo's “story” in as much detail as possible so as to provide a frame of reference for locating comparable companies. As ValueCo is a private company, for the purposes of this exercise we assumed that it is being sold through an organized M&A sale process (see Chapter 6). Therefore, we were provided with substantive information on the company, its sector, products, customers, competitors, distribution channels, and end markets, as well as historical financial performance and projections. We sourced this information from the confidential information memorandum (CIM, see Exhibit 6.5), management presentation (see Exhibit 6.6), and data room, such as those provided by Intralinks (see Exhibit 6.7).56

Identify Key Characteristics of the Target for Comparison Purposes

This exercise involved examining ValueCo's key business and financial characteristics in accordance with the framework outlined in Exhibit 1.3, which provided us with a systematic approach for identifying companies that shared key similarities with ValueCo.

Screen for Comparable Companies

Our search for comparable companies began by examining ValueCo's public competitors, which we initially identified by perusing the CIM as well as selected industry reports. We then searched through equity research reports on these public competitors for the analysts' views on comparable companies, which provided us with additional companies to evaluate. We also reviewed the proxy statements for recent M&A transactions involving companies in ValueCo's sector, and found ideas for additional comparable companies from the enclosed fairness opinion excerpts. To ensure that no potential comparables were missed, we screened companies using SIC/NAICS codes corresponding to ValueCo's sector.

These sources provided us with enough information to create a solid initial list of comparable companies (see Exhibit 1.38). We also compiled summary financial information using Bloomberg in order to provide a basic understanding of their financial profiles.

c01ex038.eps

EXHIBIT 1.38 List of Comparable Companies

Step II. Locate the Necessary Financial Information

In Step II, we set out to locate the financial information necessary to spread the key financial statistics and ratios for each of the companies that we identified as being comparable to ValueCo. For Gasparro Corp. (“Gasparro”), one of ValueCo's closest comparables, for example, this information was obtained from its most recent SEC filings, consensus estimates, and equity research. Additional financial information was sourced from Bloomberg.

10-K and 10-Q

We used Gasparro's most recent 10-K and 10-Q for the periods ending December 31, 2011, and September 30, 2012, respectively, as the primary sources for historical financial information. Specifically, these filings provided us with the prior year annual as well as current and prior year YTD financial statistics necessary to calculate LTM data. They also served as sources for the most recent basic shares outstanding count, options/warrants data, and balance sheet and cash flow statement information. The MD&A and notes to the financials were key for identifying non-recurring items (see Exhibit 1.47).

Earnings Announcement and Earnings Call Transcript

We read through the most recent earnings announcement and earnings call transcript to gain further insight on Gasparro's financial performance and outlook.

8-K/Press Releases

We confirmed via a search of Gasparro's corporate website that there were no intra-quarter press releases, 8-Ks, or other SEC filings disclosing new M&A, capital markets, or other activities since the filing of its most recent 10-Q that would affect the relevant financial statistics.

Consensus Estimates and Equity Research

Consensus estimates formed the basis for the 2012E and 2013E income statement inputs, namely sales, EBITDA, EBIT, and EPS. We also read individual equity research reports for further color on factors driving Gasparro's growth expectations as well as insights on non-recurring items.

Financial Information Service

We used Bloomberg to source Gasparro's closing share price on December 20, 2012 (the day we performed the analysis), as well as its 52-week high and low share price data.

Moody's and S&P Websites

We obtained the Moody's and S&P credit ratings for Gasparro from the respective credit rating agencies' websites.

Step III. Spread Key Statistics, Ratios, and Trading Multiples

After locating the necessary financial information for the selected comparable companies, we created input sheets for each company, as shown in Exhibit 1.39 for Gasparro. These input sheets link to the output pages used for benchmarking the comparables universe (see Exhibits 1.53, 1.54, and 1.55).

c01ex039.eps

EXHIBIT 1.39 Comparable Companies Analysis—Trading Multiples Output Page

Below, we walk through each section of the input sheet in Exhibit 1.39.

General Information

In the “General Information” section of the input page, we entered various basic company data (see Exhibit 1.40). Gasparro Corp., ticker symbol JDG, is a U.S.-based company that is listed on the NYSE. Gasparro reports its financial results based on a fiscal year ending December 31 and has corporate credit ratings of Baa3 and BBB– as rated by Moody's and S&P, respectively. Gasparro's predicted levered beta is 1.25, as sourced from Bloomberg (see Chapter 3). We also determined a 38% marginal tax rate from Gasparro's tax rate disclosures in its 10-K.

c01ex040.eps

EXHIBIT 1.40 General Information Section

Selected Market Data

Under “Selected Market Data,” we entered Gasparro's share price information as well as the most recent quarterly (MRQ) dividend paid of $0.25 per share (as sourced from the latest 10-Q, see Exhibit 1.41). Gasparro's share price was $50.00 as of market close on December 20, 2012, representing 80% of its 52-week high. As the trading multiples benchmarking output page shows (see Exhibit 1.55), this percentage is consistent with that of most of the comparables, which indicates that the market expects Gasparro to perform roughly in line with its peers.

This section also calculates equity value and enterprise value once the appropriate basic shares outstanding count, options/warrants data, and most recent balance sheet data are entered (see Exhibits 1.42, 1.43, 1.44, and 1.45).

c01ex041.eps

EXHIBIT 1.41 Selected Market Data Section

Calculation of Fully Diluted Shares Outstanding

Gasparro's most recent basic shares outstanding count is 98.5 million, as sourced from the first page of its latest 10-Q. We searched recent press releases and SEC filings to ensure that no stock splits, follow-on offerings, or major share buybacks, for example, took place following the most recent 10-Q filing. We also confirmed that Gasparro does not have convertible securities outstanding. However, Gasparro has several tranches of options, which must be reflected in the calculation of fully diluted shares in accordance with the TSM.

As shown in Exhibit 1.42 under the “Options/Warrants” heading, Gasparro has four tranches of options, each consisting of a specified number of shares and corresponding weighted average exercise price. The first tranche, for example, represents a group of options collectively owning the right to buy 1.25 million shares at a weighted average exercise price of $10.00. This tranche is deemed in-the-money given that Gasparro's current share price of $50.00 is above the weighted average strike price. The exercise of this tranche generates proceeds of $12.5 million (1.25 million × $10.00), which are assumed to repurchase Gasparro shares at the current share price of $50.00.

c01ex042.eps

EXHIBIT 1.42 Calculation of Fully Diluted Shares Outstanding Section

We utilized this same approach for the other tranches of options. The fourth tranche, however, has a weighted average exercise price of $60.00 (above the current share price of $50.00) and was therefore identified as out-of-the-money. Consequently, these options were excluded from the calculation of fully diluted shares outstanding.

In aggregate, the 2.75 million shares from the in-the-money options generate proceeds of $62.5 million. At Gasparro's current share price of $50.00, these proceeds are used to repurchase 1.25 million shares ($62.5 million/$50.00). The repurchased shares are then subtracted from the 2.75 million total in-the-money shares to provide net new shares of 1.5 million, as shown under the net new shares from options line item in Exhibit 1.42. These incremental shares are added to Gasparro's basic shares to calculate fully diluted shares outstanding of 100 million.

Equity Value

The 100 million fully diluted shares outstanding output feeds into the “Selected Market Data” section, where it is multiplied by Gasparro's current share price of $50.00 to produce an equity value of $5,000 million (see Exhibit 1.43). This calculated equity value forms the basis for calculating enterprise value.

c01ex043.eps

EXHIBIT 1.43 Equity Value

Balance Sheet Data

In the “Balance Sheet Data” section, we entered Gasparro's balance sheet data for the prior fiscal year ending 12/31/2011 and the most recent quarter ending 9/30/2012, as sourced directly from its 10-Q (see Exhibit 1.44).

c01ex044.eps

EXHIBIT 1.44 Balance Sheet Data Section

Enterprise Value

We used selected balance sheet data, specifically total debt and cash, together with the previously calculated equity value to determine Gasparro's enterprise value. As shown in Exhibit 1.45, Gasparro had $1,850 million of total debt outstanding and cash and cash equivalents of $100 million as of 9/30/2012. The net debt balance of $1,750 million was added to equity value of $5,000 million to produce an enterprise value of $6,750 million.

c01ex045.eps

EXHIBIT 1.45 Enterprise Value

Reported Income Statement

In the “Reported Income Statement” section, we entered the historical income statement items directly from Gasparro's most recent 10-K and 10-Q. The LTM column automatically calculates Gasparro's LTM financial data on the basis of the prior annual year, and the prior and current year stub inputs (see Exhibit 1.46).

c01ex046.eps

EXHIBIT 1.46 Reported Income Statement Section

Adjusted Income Statement

After entering the reported income statement, we made adjustments in the “Adjusted Income Statement” section, as appropriate, for those items we determined to be non-recurring (see Exhibit 1.47), namely:

  • $25 million pre-tax gain on the sale of a non-core business in Q4 2011
  • $30 million pre-tax inventory valuation charge in Q2 2012 related to product obsolescence
  • $15 million pre-tax restructuring charge in Q3 2012 related to severance costs

As the adjustments for non-recurring items relied on judgment, we carefully footnoted our assumptions and sources.

c01ex047.eps

EXHIBIT 1.47 Adjusted Income Statement Section

As shown in Exhibit 1.47, we entered the $30 million non-recurring product obsolescence charge as an add-back in the non-recurring items in COGS line item under the “Current Stub 9/30/2012” column heading. We also added back the $15 million restructuring charge in the other non-recurring items line under the “Current Stub 9/30/2012” column. The $25 million gain on asset sale, on the other hand, was backed out of reported earnings (entered as a negative value) under the “2011A” column. These calculations resulted in adjusted LTM EBIT and EBITDA of $725 million and $900 million, respectively.

To calculate LTM adjusted net income after adding back the full non-recurring charges of $30 million and $15 million, respectively, and subtracting the full $25 million gain on sale amount, we made tax adjustments in the tax adjustment line item. These adjustments were calculated by multiplying each full amount by Gasparro's marginal tax rate of 38%. This resulted in adjusted net income and diluted EPS of $387.5 million and $3.88, respectively. The adjusted financial statistics then served as the basis for calculating the various LTM profitability ratios, credit statistics, and trading multiples used in the benchmarking analysis (see Exhibits 1.53, 1.54, and 1.55).

Cash Flow Statement Data

Gasparro's historical cash from operations, D&A, and capex were entered directly into the input page as they appeared in the cash flow statement from its 10-K and 10-Q with adjustments made as necessary for non-recurring items (see Exhibit 1.48). We also calculated free cash flow (FCF) by subtracting capex from cash from operations for each reporting period. This enabled us to calculate a FCF-to-sales margin of 6.7% and FCF per share of $3.15 for LTM 9/30/2012.

c01ex048.eps

EXHIBIT 1.48 Cash Flow Statement Data Section

LTM Return on Investment Ratios

Return on Invested Capital

For ROIC, we calculated 21.1% (see Exhibit 1.49) by dividing Gasparro's LTM 9/30/2012 adjusted EBIT of $725 million (as calculated in Exhibit 1.47) by the sum of its average net debt and shareholders' equity balances for the periods ending 12/31/2011 and 9/30/2012 ($725 million / (($1,875 million – $75 million + $1,600 million) + ($1,850 million – $100 million + $1,725 million) / 2)).

c01ex049.eps

EXHIBIT 1.49 LTM Return on Investment Ratios Section

Return on Equity

For ROE, we calculated 23.3% by dividing Gasparro's LTM 9/30/2012 adjusted net income of $387.5 million (as calculated in Exhibit 1.47) by its average shareholders' equity balance for the periods ending 12/31/2011 and 9/30/2012 (($1,600 million + $1,725 million) / 2).

Return on Assets

For ROA, we calculated 7.9% by dividing Gasparro's LTM 9/30/2012 adjusted net income of $387.5 million by its average total assets for the periods ending 12/31/2011 and 9/30/2012 (($4,825 million + $5,000 million) / 2).

Dividend Yield

To calculate dividend yield, we annualized Gasparro's dividend payment of $0.25 per share for the most recent quarter (see Exhibit 1.41), which implied an annual dividend payment of $1.00 per share. We checked recent press releases to ensure there were no changes in dividend policy after the filing of the 10-Q. The implied annualized dividend payment of $1.00 per share was then divided by Gasparro's current share price of $50.00 to calculate an implied annual dividend yield of 2%.

LTM Credit Statistics

Debt-to-Total Capitalization

For debt-to-total capitalization, we divided Gasparro's total debt of $1,850 million as of 9/30/2012 by the sum of its total debt and shareholders' equity for the same period ($1,850 million + $1,725 million). This provided a debt-to-total capitalization ratio of 51.7% (see Exhibit 1.50).

Total Debt-to-EBITDA

For total debt-to-EBITDA, we divided Gasparro's total debt of $1,850 million by its LTM 9/30/2012 adjusted EBITDA of $900 million. This provided a total leverage multiple of 2.1x (1.9x on a net debt basis).

EBITDA-to-Interest Expense

For EBITDA-to-interest expense, we divided Gasparro's LTM 9/30/2012 adjusted EBITDA of $900 million by its interest expense of $100 million for the same period. This provided a ratio of 9.0x. We also calculated Gasparro's (EBITDA – capex)-to-interest expense and EBIT-to-interest expense ratios at 7.0x and 7.3x, respectively.

c01ex050.eps

EXHIBIT 1.50 LTM Credit Statistics Section

Trading Multiples

In the “Trading Multiples” section, we entered consensus estimates for Gasparro's 2012E, 2013E, and 2014E sales, EBITDA, EBIT, and EPS (see Exhibit 1.51). These estimates, along with the calculated enterprise and equity values, were used to calculate forward trading multiples. Gasparro's LTM adjusted financial data is also linked to this section and used to calculate trailing trading multiples.

Enterprise Value Multiples

For enterprise value-to-LTM EBITDA, we divided Gasparro's enterprise value of $6,750 million by its LTM 9/30/2012 adjusted EBITDA of $900 million, providing a multiple of 7.5x. For EV/2012E EBITDA, we divided the same enterprise value of $6,750 million by Gasparro's 2012E EBITDA of $950 million to calculate a multiple of 7.1x. This same methodology was used for EV/2013E EBITDA and EV/2014E EBITDA, as well as for the trailing and forward sales and EBIT enterprise value multiples.

Price-to-Earnings Ratio

The approach for calculating P/E mirrors that for EV/EBITDA. We divided Gasparro's current share price of $50.00 by its LTM, 2012E, 2013E, and 2014E EPS of $3.88, $4.45, $5.00, and $5.50, respectively. These calculations provided P/E ratios of 12.9x, 11.2x, 10.0x, and 9.1x, respectively.

Free Cash Flow Yield

Free cash flow (FCF) generation is an important metric for determining valuation. FCF is an indicator of a company's ability to return capital to shareholders or repay debt, which accrues to equity holders. Therefore, many investors focus on FCF yield, calculated as (cash from operations – capex) / market capitalization or FCF per share / share price. Gasparro's FCF yield for LTM, 2012E, 2013E, and 2014E is 6.3%, 7.0%, 7.5%, and 8.3%, respectively.

c01ex051.eps

EXHIBIT 1.51 Trading Multiples Section

Growth Rates

In the “Growth Rates” section, we calculated Gasparro's historical and estimated growth rates for sales, EBITDA, and EPS for various periods. For historical data, we used the adjusted income statement financials from Exhibit 1.47. As shown in Exhibit 1.52, Gasparro's EPS grew 6.4% over the past year (1-year historical growth) and at an 11.6% CAGR over the past two years (2-year historical compounded growth).

For the forward growth rates, we used consensus estimates from the “Trading Multiples” section. On a forward year basis, Gasparro's expected EPS growth rate for 2011A to 2012E is 31%, with an expected 2011A to 2013E CAGR of 21.3%. We sourced Gasparro's long-term EPS growth rate of 12%, which is based on equity research analysts' estimates, from consensus estimates.

c01ex052.eps

EXHIBIT 1.52 Growth Rates Section

Step IV. Benchmark the Comparable Companies

After completing Steps I through III, we were prepared to perform the benchmarking analysis for ValueCo.

The first two benchmarking output pages focused on the comparables' financial characteristics, enabling us to determine ValueCo's relative position among its peers for key value drivers (see Exhibits 1.53 and 1.54). This benchmarking analysis, in combination with a review of key business characteristics (outlined in Exhibit 1.3), also enabled us to identify ValueCo's closest comparables—in this case, BuyerCo, Gasparro Corp., and Sherman Co. These closest comparables were instrumental in helping to frame the ultimate valuation range.

c01ex053.eps

EXHIBIT 1.53 ValueCo Corporation: Benchmarking Analysis – Financial Statistics and Ratios, Page 1

c01ex054.eps

EXHIBIT 1.54 ValueCo Corporation: Benchmarking Analysis – Financial Statistics and Ratios, Page 2

Similarly, the benchmarking analysis allowed us to identify outliers, such as McMenamin & Co. and Adler Worldwide among others, which were determined to be less relevant due to their profitability and size, respectively. In this case, we did not eliminate the outliers altogether. Rather, we elected to group the comparable companies into three tiers based on subsector and size—Specialty Chemicals, Commodity/Diversified Chemicals, and Small-Cap Chemicals. The companies in the “Specialty Chemicals” group are more similar to ValueCo in terms of key business and financial characteristics and, therefore, are more relevant in our view. The companies in the “Commodity/Diversified Chemicals” and “Small-Cap Chemicals” groups, however, provided further perspective as part of a more thorough analysis.

We used the output page in Exhibit 1.55 to analyze and compare the trading multiples for ValueCo's comparables. As previously discussed, financial performance typically translates directly into valuation (i.e., the top performers tend to receive a premium valuation to their peers, with laggards trading at a discount). Therefore, we focused on the multiples for ValueCo's closest comparables as the basis for framing valuation.

c01ex055.eps

EXHIBIT 1.55 ValueCo Corporation: Comparable Companies Analysis—Trading Multiples Output Page

Exhibit 1.55(a) presents a comparable companies output page in a format preferred by certain equity research analysts and equity investors. Many equity investors focus primarily on free cash flow generation for their valuation and investment decisions.

c01ex055a.eps

EXHIBIT 1.55(a) ValueCo Corporation: Trading Multiples Output Page for Equity Research Analysts and Equity Investors

Step V. Determine Valuation

The means and medians for the Specialty Chemicals comparables universe helped establish an initial valuation range for ValueCo, with the highs and lows providing further perspective. We also looked to the Commodity/Diversified Chemicals and Small-Cap Chemicals comparables for peripheral guidance. To fine-tune the range, however, we focused on those comparables deemed closest to ValueCo in terms of business and financial profile—namely, BuyerCo, Gasparro Corp., and Sherman Co., as well as Goodson Corp. and S. Momper & Co. to a lesser extent.

Companies in ValueCo's sector tend to trade on the basis of forward EV/EBITDA multiples. Therefore, we framed our valuation of ValueCo on the basis of the forward EV/EBITDA multiples for its closest comparables, selecting ranges of 6.75x to 7.75x 2012E EBITDA, and 6.5x to 7.5x 2013E EBITDA. We also looked at the implied valuation based on a range of 7.0x to 8.0x LTM EBITDA.

c01ex056.eps

EXHIBIT 1.56 ValueCo Corporation: Implied Valuation Range – Enterprise Value

The chosen multiple ranges in Exhibit 1.56 translated into an implied enterprise value range of approximately $4,900 million to $5,850 million. This implied valuation range is typically displayed in a format such as that shown in Exhibit 1.57 (known as a “football field”) for eventual comparison against other valuation methodologies, which we discuss in the following chapters.

c01ex057.eps

EXHIBIT 1.57 ValueCo Football Field Displaying Comparable Companies

Bloomberg Appendix

app1-ex001.eps

APPENDIX 1.1 Bloomberg “Relative Valuation” Comparable Companies Analysis (RV<GO>)

app1-ex001.eps

APPENDIX 1.2 Bloomberg Functions for Business and Financial Profile

app1-ex003.eps

APPENDIX 1.3 Bloomberg Company Classification Browser (CCB<GO>)

app1-ex004.eps

APPENDIX 1.4 Bloomberg BEst Consensus Estimates (EEB<GO>)

app1-ex005.eps

APPENDIX 1.5 Bloomberg Coverage Dashboard (IBNK<GO>)

app1-ex006.eps

APPENDIX 1.6 Bloomberg Industries Comparable Analysis for Basic & Diversified Chemicals (BI<GO>)

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset