Comparable companies analysis (“comparable companies”, “trading comps”, or simply “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. Comps 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 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).
Comps is designed to reflect “current” valuation based on prevailing market conditions and sentiment. As such, it is often more relevant than intrinsic valuation techniques, such as the DCF (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, 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. Or, it may indicate that you have discovered true valuation arbitrage in the market. Therefore, when performing comps and other valuation methodologies, 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 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).
Step I. | Select the Universe of Comparable Companies |
Step II. | Locate the Necessary Financial Information |
Step III. | Spread Key Statistics, Ratios, and Trading Multiples |
Step IV. | Benchmark the Comparable Companies |
Step V. | Determine Valuation |
EXHIBIT 1.1 Comparable Companies Analysis Steps
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 this exercise.
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).
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).
EXHIBIT 1.2 Comparable Companies Analysis—Trading Multiples Output Page
The selection of the right universe of comparable companies is the foundation for performing trading comps. To find companies with similar business and financial characteristics, you must first truly understand 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 certain companies, it may prove challenging for others with no readily apparent peers.
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.
The process of learning the in-depth “story” of the target should be exhaustive. 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).
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.
Business Profile | Financial Profile |
|
|
EXHIBIT 1.3 Business and Financial Profile Framework
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 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.
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 auto supplies, lumber, oil, machinery, 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, facilities maintenance, 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.
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.
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 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, salesforce, 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, online, 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.
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, 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 For comps, 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.
Key financial characteristics must also be examined both as a means of understanding the target and identifying the best comparable companies.
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.
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 peers is a core component of the benchmarking analysis (see Step IV).
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 (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.
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.
Once the target’s basic business and financial characteristics are researched and understood, the banker uses multiple 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 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 and industry experts are perhaps the most valuable resources. Given their sector knowledge and familiarity with the target, a brief conversation is usually sufficient to provide a strong starting point. Toward the end of the process—once the legwork to craft and refine a robust list of comparables has been completed—a senior banker should be called upon to provide the finishing touches.
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.
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. A summary list of where to locate key financial data is provided in Exhibit 1.4.
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 estimates15 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).
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.
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, investor days,24 and Regulation FD disclosure requirements.25The 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.
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. If you’re currently working at an investment bank, you should have access to the bank’s research reports through the internal portal. Also, if you’re an individual investor reading this book, you should have access to research through your brokerage account(s) as most brokerage houses provide customers with access to in-house or affiliate research.
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. The primary sources for consensus estimates are Bloomberg Estimates, Refinitiv IBES, S&P Capital IQ Estimates, and Thomson First Call, among other financial information services. Investment banks typically choose one source or the other so as to maintain consistency throughout the analysis.26
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 discussed throughout this section, financial information services a key source for obtaining SEC filings, research reports, consensus estimates, and press releases, among other items. They are 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. Corporate credit ratings information can be gleaned form various financial information services. 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.27
Exhibit 1.4 provides a summary of the primary sources used to obtain the necessary financial information to perform trading comps.
(a) As a non-GAAP (generally accepted accounting principles) financial measure, EBITDA is not reported on a public filer’s income statement. It may, however, be disclosed as supplemental information in the company’s public filings.
EXHIBIT 1.4 Summary of Financial Data Primary Sources
Once the necessary financial information for each of the comparables has been located, it is entered into an input page (see Exhibit 1.5).28 This sample input page is designed to assist the banker in calculating the key financial statistics, ratios, and multiples for the comparables universe.29 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).
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.
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.
EXHIBIT 1.5 Sample Comparable Company Input Page
Equity value (“market capitalization”) is the value represented by a given company’s basic shares outstanding plus “in-the-money” stock options,30 warrants,31 and convertible securities—collectively, “fully diluted shares outstanding”. It is calculated by multiplying a company’s current share price32 by its fully diluted shares outstanding (see Exhibit 1.6).
EXHIBIT 1.6 Calculation of Equity Value
While equity value provides perspective on relative size, it does not lend insight on share price performance. The company’s current share price as a percentage of its 52-week high is much more informative in this respect. 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.33 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.
EXHIBIT 1.7 Calculation of Fully Diluted Shares 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.34
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”) is typically set at a premium to the company’s underlying share price at the time the offering of the converts is priced.
The conversion feature can have different settlement mechanics. The simplest, “physical settlement”, requires the issuer to settle conversions entirely in shares (together with cash in lieu of any fractional share). On the other end of the spectrum is “flexible settlement” (sometimes called “Instrument X”), which allows the issuer to settle conversion by delivering any combination of cash and shares, at its election. Finally, “net share settlement” requires the issuer to settle the conversion value in cash up to the principal amount being converted, with any excess of the conversion value of over the principal amount settled in shares.
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. The number of diluted shares underlying cash-pay converts is often calculated using either the if-converted method or the treasury stock method, 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, the impact of physically settled converts on the number of diluted shares is calculated by adding an amount equal to the outstanding principal amount of the convert divided by the conversion price.35 The convert is then 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 number of dilutive shares underlying the convert by the company’s current share price. The convert is then 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 outstanding principal amount is simply divided by the conversion price to calculate new shares of 10 million ($150 million / $15.00). The number of underlying shares is 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 assumed 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 the if-converted method can be EPS dilutive due to the additional number of shares, net income is actually higher on a pro forma basis.
EXHIBIT 1.8 Calculation of Fully Diluted Shares Using the If-Converted Method
Net Share Settlement Net share settlement and flexible settlement are common features in convertible bonds and often used by more mature, larger capitalized issuers.36 These settlement methods serve to limit the dilutive effects of conversion and can in some cases afford the issuer TSM accounting treatment. For example, in net share settlement, 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, which results in less share issuance.37
As shown in Exhibit 1.9, the if-converted method results in incremental dilutive shares of 10 million, while NSS results in incremental dilutive shares of only 2.5 million. The NSS calculation is conducted by first multiplying the number of shares underlying 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 dilutive shares of 2.5 million ($50 million / $20.00).38 The $150 million principal amount of the convert remains treated as debt due to the fact that the issuer typically must settle this amount in cash at maturity.
EXHIBIT 1.9 Incremental Shares from If-Converted Versus Net Share Settlement
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 interest39 – cash and cash equivalents. The equity value component is calculated on a fully diluted basis.
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).40 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 distress41 and potential constraints to growth.
EXHIBIT 1.11 Effects of Capital Structure Changes on Enterprise Value
EXHIBIT 1.12 Gross Profit Margin
EXHIBIT 1.13 EBITDA and EBIT Margin
EXHIBIT 1.14 Net Income Margin
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).
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. 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-term46 EPS growth rates is generally obtained from consensus estimates.
EXHIBIT 1.16 Return on Invested Capital
EXHIBIT 1.17 Return on Equity
EXHIBIT 1.18 Return on Assets
EXHIBIT 1.19 Implied Dividend Yield
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.
EXHIBIT 1.20 Leverage Ratio
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.
EXHIBIT 1.22 Interest Coverage Ratio
Credit Ratings A credit rating is an assessment48 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.49
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.
EXHIBIT 1.23 Ratings Scales of the Primary Rating Agencies
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”).
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/2019.
EXHIBIT 1.25 Calculation of LTM 9/30/2019 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.50
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 2019 estimated (E) sales, assuming a fiscal year ending April 30.
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 provide a breakdown of recommended adjustments that can be helpful in identifying potential non-recurring items, ultimately professional judgment needs to be exercised.
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-effected51 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 2018 as it might appear in a 10-K. Let’s assume the corresponding notes to the 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 salesforce ($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.
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 25% marginal tax rate, we calculate tax expense of $3.8 million and additional net income of $11.3 million ($15 million – $3.8 million). The $11.3 million is added to reported net income, resulting in adjusted net income of $86.3 million. We then divide the $86.3 million by weighted average fully diluted shares outstanding of 30 million to calculate adjusted diluted EPS of $2.88.
EXHIBIT 1.29 Adjusted Income Statement
Adjustments for Recent Events In normalizing a company’s financials, adjustments also need to be made 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/prospectuses52) 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.53
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.
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 one- or two-year EPS (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.
EXHIBIT 1.30 Equity 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.
EXHIBIT 1.31 Enterprise Value-to-EBITDA and Enterprise Value-to-EBIT
Enterprise Value-to-Sales Multiple EV/sales is also analyzed, 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.
EXHIBIT 1.32 Enterprise Value-to-Sales
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.
EXHIBIT 1.33 Selected Sector-Specific Valuation Multiples
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.
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 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.
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.
The trading multiples for 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-or 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 2019E EBITDA, versus a high/low range of 5.5x to 8.5x, a mean of 7.0x and a median of 6.8x.
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.
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
EXHIBIT 1.35 Valuation Implied by EV/EBITDA
At a 6.5x to 7.5x multiple range for 2019E EBITDA, the endpoints are multiplied by the target’s 2019E 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/2020E EBITDA.
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 2019E net income, for example, yields an implied equity value of $900 million to $1,125 million when multiplied by the target’s 2019E 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.
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 2019E 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.
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.
The following section provides a detailed, step-by-step example of how comps 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.
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/presentation (CIM/CIP, see Exhibit 6.5), management presentation (see Exhibit 6.6), and data room, such as those provided by Datasite (formerly Merrill Corporation, 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 from 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 data downloaded from a financial information service in order to provide a basic understanding of their financial profiles.
EXHIBIT 1.38 List of Comparable Companies
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 financial information services.
10-K and 10-Q We used Gasparro’s most recent 10-K and 10-Q for the periods ending December 31, 2018, and September 30, 2019, 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 2019E and 2020E 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 a financial information service to source Gasparro’s closing share price on December 20, 2019 (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.
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).
Below, we walk through each section of the input sheet in Exhibit 1.39.
EXHIBIT 1.39 Comparable Companies Analysis—Trading Multiples Output Page
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 Nasdaq. Gasparro reports its financial results based on a fiscal year ending December 31 and has corporate credit ratings of Ba2 and BB as rated by Moody’s and S&P, respectively. Gasparro’s predicted levered beta is 1.3, as sourced from Barra (see Chapter 3). We also determined a 25% marginal tax rate from Gasparro’s tax rate disclosures in its 10-K.
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, 2019, 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).
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.
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.
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/2018 and the most recent quarter ending 9/30/2019, as sourced directly from its 10-Q (see Exhibit 1.44).
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/2019. 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.
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).
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:
As the adjustments for non-recurring items relied on judgment, we carefully footnoted our assumptions and sources.
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/2019” column heading. We also added back the $15 million restructuring charge in the other non-recurring items line under the “Current Stub 9/30/2019” 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 “2018A” 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 25%. This resulted in adjusted net income and diluted EPS of $468.8 million and $4.69, 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/2019.
EXHIBIT 1.48 Cash Flow Statement Data Section
Return on Invested Capital For ROIC, we calculated 21.1% (see Exhibit 1.49) by dividing Gasparro’s LTM 9/30/2019 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/2018 and 9/30/2019 ($725 million / (($1,875 million – $75 million + $1,600 million) + ($1,850 million – $100 million + $1,725 million) / 2)).
Return on Equity For ROE, we calculated 28.2% by dividing Gasparro’s LTM 9/30/2019 adjusted net income of $468.8 million (as calculated in Exhibit 1.47) by its average shareholders’ equity balance for the periods ending 12/31/2018 and 9/30/2019 (($1,600 million + $1,725 million) / 2).
Return on Assets For ROA, we calculated 9.5% by dividing Gasparro’s LTM 9/30/2019 adjusted net income of $468.8 million by its average total assets for the periods ending 12/31/2018 and 9/30/2019 (($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%.
EXHIBIT 1.49 LTM Return on Investment Ratios Section
Debt-to-Total Capitalization For debt-to-total capitalization, we divided Gasparro’s total debt of $1,850 million as of 9/30/2019 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/2019 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/2019 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 the company’s (EBITDA – capex)-to-interest expense and EBIT-to-interest expense ratios at 7.0x and 7.3x, respectively.
EXHIBIT 1.50 LTM Credit Statistics Section
In the “Trading Multiples” section, we entered consensus estimates for Gasparro’s 2019E, 2020E, and 2021E 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/2019 adjusted EBITDA of $900 million, providing a multiple of 7.5x. For EV/2019E EBITDA, we divided the same enterprise value of $6,750 million by Gasparro’s 2019E EBITDA of $950 million to calculate a multiple of 7.1x. This same methodology was used for EV/2020E EBITDA and EV/2021E 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, 2019E, 2020E, and 2021E EPS of $4.69, $5.10, $5.50, and $5.75, respectively. These calculations provided P/E ratios of 10.7x, 9.8x, 9.1x, and 8.7x 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, 2019E, 2020E, and 2021E is 6.3%, 7.5%, 8.3%, and 9.1%, respectively.
EXHIBIT 1.51 Trading Multiples Section
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).
EXHIBIT 1.52 Growth Rates Section
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 2018A to 2019E is 24.1%, with an expected 2018A to 2020E CAGR of 15.7%. We sourced Gasparro’s long-term EPS growth rate of 12%, which is based on equity research analysts’ estimates, from consensus estimates.
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.
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 more relevant. 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.
Exhibit 1.55(a) presents a comparable companies output page in a format preferred by certain equity research analysts and equity investors, namely those focused primarily on FCF generation for their valuation and investment decisions.
EXHIBIT 1.53 ValueCo Corporation: Benchmarking Analysis – Financial Statistics and Ratios, Page 1
EXHIBIT 1.54 ValueCo Corporation: Benchmarking Analysis – Financial Statistics and Ratios, Page 2
EXHIBIT 1.55 ValueCo Corporation: Comparable Companies Analysis — Trading Multiples Output Page
EXHIBIT 1.55(a) ValueCo Corporation: Trading Multiples Output Page for Equity Research Analysts/Equity Investors
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 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 2019E EBITDA, and 6.5x to 7.5x 2020E EBITDA. We also looked at the implied valuation based on a range of 7.0x to 8.0x LTM EBITDA.
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.
EXHIBIT 1.57 ValueCo Football Field Displaying Comparable Companies