The Uninformed Investor: “This stock is so cheap! The current stock price is only $0.50!”.
The Smart Investor: “Umm...the stock price means nothing. Your stock’s EBITDA multiple is negative!”
I know. Cheesy example. But hopefully, it gets the point across. Just because the stock price is trading under $1 doesn’t make it cheap. The stock is only “cheap” if the value you’re getting back exceeds the price.
“Price is what you pay; value is what you get.”
- Warren Buffet
As the Smart Investor correctly pointed out using the EV / EBITDA valuation multiple, good value investors determine cheap versus expensive based on the price they’re paying relative to earnings and cash flow.
Like cash flow and profit ratios, valuation ratios provide a consistent methodology for benchmarking and analyzing trends. Unlike cash flow and income statement-based ratios that convert raw financial statement data into metrics that reveal insights about the operations of a business; valuation ratios help investors to compare the valuations of businesses.
In this post, I discuss the 12 valuation ratios (also known as valuation multiples) that allow investors to quickly estimate a business’s value relative to its earnings, as well as how to compare valuations of comparable companies. I’ve also discussed Profit & Return Ratios, Credit Ratios, and Cash Flow Ratios previously.
I’ve also created a spreadsheet template you can use to calculate the 12 valuation ratios I discuss. The spreadsheet contains three tabs:
-
Cheat Sheet: This tab lists Valuation ratios and formulas used to calculate each ratio.
-
[Example] Calculator: You can use this tab to calculate all the ratios discussed for any business by manually entering the financials required in designated cells colored in yellow under the "Required Data" section.
-
[Linked] Calculator: This tab has formulas that are powered by finbox.com's Spreadsheet add-on so you can use it to automatically fetch data for supported public companies by simply changing the ticker symbol in the designated cell.
You can make a copy of the Google Spreadsheet by clicking File > Make a copy from the menu or by using the Copy Google Spreadsheet Template link below:
[ Copy Google Spreadsheet Template ]
You can also download the spreadsheet template to Excel.
[ Download Excel Spreadsheet Template ]
The Top 12 Valuation Multiples
Before I get into the valuation multiples, I want to highlight the relationship between enterprise value and equity value multiples.
Computationally, it’s important to recognize the connection between the numerators and denominators used in calculations. Since enterprise value sums the value available to debt and equity holders, the denominators used in enterprise value ratios typically include earnings available to both types of stakeholders (like EBITDA or EBIT). Likewise, equity value multiples aren't usually computed using income before interest expense because shareholders can't claim earnings before paying interest on the issued debt.
You can blame it on my investment banking, but in practice, I prefer to discuss valuations based on enterprise value multiples. There are exceptions of course, such as commercial banks and investment funds wherein enterprise value multiples are difficult to calculate and therefore less meaningful.
Why the preference for enterprise value multiples you ask? Enterprise value multiples have two key advantages over equity value multiples:
Adjust for Differences in Capital Structure
Enterprise value multiples aren't easily skewed by differences in capital structure (the mix of debt and equity). All other things being equal, firms with more debt in their capital structure will have higher P/E multiples since their returns on equity will be higher. While that's not all bad, it can make it more difficult to compare valuations based on operating performance and earnings.
Don't Assume That Equity Definitely Has Value
Enterprise value multiples don't immediately assume that the equity of a business has value. This can be a dangerous assumption. For example, a firm may have $10 in EBITDA, $2 in Net Income, and $60 in debt. Similar firms in the sector may trade at EBITDA multiples around 5x and P/E multiples of 10x. If an investor relied only on the P/E multiple to estimate the value of equity, they would conclude that the equity is worth $20 ($2 Net Income * 10x P/E multiple). If they used the EBITDA multiple they would accurately conclude that the firm is insolvent and that the equity is actually worthless. Here's the math that would lead them there:
Debt = $60
EBITDA = $10
Selected EBITDA multiple = 5x
Enterprise Value = EBITDA x EBITDA multiple = ($10 * 5x) = $50
Equity Value = Enterprise Value - Debt = $50 - $60 = -$10
That said, equity value multiples are still useful when these two weaknesses aren't of concern. Equity multiples are also more popular in the news media since they're easier to compute and minority shareholders can't influence capital structure decisions. Lastly, enterprise value multiples are not meaningful for most stocks in the financial sector since stocks in this sector have a large amount of debt in their capital structure. That's why I've picked a mix of six commonly-used enterprise value multiples and six equity value multiples for this list.
For multiples that use earnings in the denominator, it's common to compute ratios using historical and forecasted data. Historical valuation multiples are calculated based on the last twelve months (LTM) of data. Forecast or forward (Fwd) multiples are typically based on the nearest fiscal year or the fiscal year after next fiscal year.
Valuation ratios vary significantly by Sector, so it's important to adjust expectations accordingly. To provide some guidance, I list the median valuation multiples in each Sector as of November 2017 based on finbox.com database.
1. EV / Revenue
EV / Revenue, also referred to as Revenue Multiple, Sales Multiple, or EV to Sales Multiple measures the dollars in Enterprise Value for each dollar of revenue. High-profit margins are highly correlated with higher revenue multiples. Revenue multiples are especially useful when a firm has negative EBITDA or EBIT, as might be the case with rapidly growing companies or successful internet startups. They also are the least susceptible to accounting differences between otherwise similar businesses.
Formula
EV / Revenue = Enterprise Value / Revenue
| Sector | EV / LTM Rev | EV / Fwd Rev |
|---|---|---|
| Consumer Discretionary | 1.2x | 1.1x |
| Consumer Staples | 1.6x | 1.5x |
| Energy | 3.1x | 2.9x |
| Financials | NM | NM |
| Healthcare | 4.9x | 4.3x |
| Industrials | 1.5x | 1.4x |
| Information Technology | 2.3x | 2.2x |
| Materials | 1.8x | 1.7x |
| Telecom | 2.0x | 1.7x |
| Utilities | 3.6x | 3.4x |
2. EV / EBITDA
EV / EBITDA also referred to as EBITDA Multiple is the most popular enterprise value multiple. EBITDA multiple measures the dollars in Enterprise Value for each dollar of EBITDA (See EBITDA for benefits). Firms with high growth rates typically trade at higher EBITDA Multiples.
Formula
EV / EBITDA = Enterprise Value / EBITDA
| Sector | EV / LTM EBITDA | EV / Fwd EBITDA |
|---|---|---|
| Consumer Discretionary | 9.4x | 8.5x |
| Consumer Staples | 12.5x | 11.0x |
| Energy | 10.6x | 8.8x |
| Financials | NM | NM |
| Healthcare | 16.3x | 13.6x |
| Industrials | 11.9x | 10.8x |
| Information Technology | 16.0x | 13.5x |
| Materials | 10.6x | 9.1x |
| Telecom | 6.4x | 5.9x |
| Utilities | 11.6x | 10.3x |
3. EV / EBIT
EV / EBIT is also referred to as EBIT Multiple, and measures the dollars in Enterprise Value for each dollar of EBIT. When capital expenditures are a significant consideration for the business, EBIT multiples may be better at capturing the value of capital efficiency. Subtracting D&A does, however, make EBIT susceptible to differences in depreciation and amortization policies.
Formula
EV / EBIT = Enterprise Value / EBIT
| Sector | EV / LTM EBIT | EV / Fwd EBIT |
|---|---|---|
| Consumer Discretionary | 14.0x | 12.4x |
| Consumer Staples | 17.4x | 14.9x |
| Energy | 18.7x | 16.3x |
| Financials | NM | NM |
| Healthcare | 24.3x | 19.4x |
| Industrials | 17.5x | 15.6x |
| Information Technology | 22.1x | 18.9x |
| Materials | 17.1x | 14.6x |
| Telecom | 15.8x | 12.1x |
| Utilities | 18.9x | 17.0x |
4. EV / Invested Capital
EV / Invested Capital measures the dollars in Enterprise Value for each dollar of capital invested by shareholders and lenders. The invested capital multiple is especially useful when capital assets are a key driver of revenue and earnings. Stocks trading at high multiples of invested capital may also be more susceptible to competition, since investing in similar assets will be attractive to investors.
Formula
Invested Capital = Total Equity + Total Debt
EV / Invested Capital = Enterprise Value / Invested Capital
| Sector | EV / Invested Capital |
|---|---|
| Consumer Discretionary | 1.5x |
| Consumer Staples | 1.9x |
| Energy | 1.1x |
| Financials | NM |
| Healthcare | 2.6x |
| Industrials | 1.7x |
| Information Technology | 2.2x |
| Materials | 1.6x |
| Telecom | 1.3x |
| Utilities | 1.4x |
5. EV / (EBITDA - CapEx)
EV / (EBITDA - CapEx) also referred to as EBITDA minus CapEx Multiple is similar to the EBIT multiple. EBITDA less CapEx is better at capturing value differences for growing companies since accounting for capital expenditures is less subjective than depreciation. When capital expenditures are cyclical or lumpy, analysts compute this ratio using the three-year average capital expenditures in the denominator.
Formula
EV / (EBITDA - CapEx) = Enterprise Value / (EBITDA - Capital Expenditures)
| Sector | EV / LTM EBITDA - CAPEX | EV / Fwd EBITDA - CAPEX |
|---|---|---|
| Consumer Discretionary | 13.3x | 11.9x |
| Consumer Staples | 17.3x | 15.8x |
| Energy | 15.1x | 16.6x |
| Financials | NM | NM |
| Healthcare | 20.1x | 16.4x |
| Industrials | 16.4x | 14.9x |
| Information Technology | 18.8x | 16.3x |
| Materials | 15.4x | 14.2x |
| Telecom | 13.7x | 11.9x |
| Utilities | 30.9x | 28.7x |
6. EV / Free Cash Flow
EV / Free Cash Flow measures the dollars in Enterprise Value for each dollar of free cash flow. The EV to Free Cash Flow multiple captures the working capital requirements of a business since cash inflows and outflows related to receivables and payables are reconciled in the cash flow statement.
Formula
Free Cash Flow = Cash Flows from Operations + Cash Flows from Investing
EV / FCF = Enterprise Value / Free Cash Flow
| Sector | EV / LTM Free Cash Flow |
|---|---|
| Consumer Discretionary | 19.6x |
| Consumer Staples | 29.6x |
| Energy | 16.1x |
| Financials | NM |
| Healthcare | 26.0x |
| Industrials | 25.9x |
| Information Technology | 25.2x |
| Materials | 25.3x |
| Telecom | 20.9x |
| Utilities | 50.1x |
7. P/E Ratio
P/E Ratio or Price / Earnings ratio is the most popular equity value multiple; it indicates the multiple of earnings that stock investors are willing to pay for one share of the firm. The P/E Ratio is nonetheless susceptible to several pitfalls which the PE conundrum video by Khan Academy does a great job of explaining.
Formula
P/E Ratio = Stock Price / Earnings
or
P/E Ratio = Market Cap / Net Income
| Sector | P/E Ratio (LTM) | P/E Ratio (Fwd) |
|---|---|---|
| Consumer Discretionary | 19.9x | 15.9x |
| Consumer Staples | 24.9x | 19.4x |
| Energy | 19.6x | 18.6x |
| Financials | 18.5x | 16.3x |
| Healthcare | 34.2x | 16.4x |
| Industrials | 25.0x | 20.4x |
| Information Technology | 29.9x | 20.5x |
| Materials | 24.5x | 18.7x |
| Telecom | 18.6x | 16.5x |
| Utilities | 24.5x | 22.3x |
8. Price / Sales
Price / Sales compares a firm's equity value to the twelve months of booked sales. Like the EV to Sales, the Price to Sales multiple is primarily useful when valuing firms with negative or depressed earnings.
Formula
Price / Sales = Market Cap / Sales
| Sector | Price / LTM Sales | Price / Fwd Sales |
|---|---|---|
| Consumer Discretionary | 1.0x | 0.9x |
| Consumer Staples | 1.3x | 1.2x |
| Energy | 1.7x | 1.7x |
| Financials | 3.5x | 3.3x |
| Healthcare | 5.1x | 4.4x |
| Industrials | 1.2x | 1.2x |
| Information Technology | 2.4x | 2.3x |
| Materials | 1.4x | 1.3x |
| Telecom | 1.6x | 1.2x |
| Utilities | 2.3x | 2.3x |
9. Price / Book
Price / Book or Price / Common Equity compares a firm's market value of equity to the amount of common equity listed on the balance sheet. Price to Book ratio is commonly used to compare banks because most bank loan assets and deposit liabilities are constantly revalued to reflect their market values. This ratio is also popular with value investors, as it provides a rough indication of downside risk if the firm was to become bankrupt.
Formula
Price / Book = Market Cap / Common Equity
| Sector | Market Cap / Book Value |
|---|---|
| Consumer Discretionary | 2.0x |
| Consumer Staples | 2.7x |
| Energy | 1.3x |
| Financials | 1.5x |
| Healthcare | 3.8x |
| Industrials | 2.5x |
| Information Technology | 3.2x |
| Materials | 2.1x |
| Telecom | 2.2x |
| Utilities | 2.0x |
10. Price / Tangible Book Value
Price / Tangible Book Value or Price / Tangible Common Equity compares a firm's market value of equity to its book value of tangible common equity value. Tangible common equity subtracts goodwill and intangibles from the listed total common equity since these assets often have little resale value in a bankruptcy. Tangible Equity gained popularity during the 2008–2009 economic crisis since it held banks and financial institutions to a stricter standard of balance sheet health from the perspective of common shareholders.
Formula
Tangible Common Equity = Common Equity - Goodwill & Intangibles
Price / Book = Market Cap / Tangible Common Equity
| Sector | Price / Tangible Book |
|---|---|
| Consumer Discretionary | 3.2x |
| Consumer Staples | 3.8x |
| Energy | 1.7x |
| Financials | 1.9x |
| Healthcare | 6.9x |
| Industrials | 4.8x |
| Information Technology | 5.4x |
| Materials | 2.7x |
| Telecom | 2.7x |
| Utilities | 2.4x |
11. Price / Cash Flow
Price / Cash Flow compares a firm's equity value to the Cash from Operations (OCF) reported on its Statement of Cash Flows. Investors often prefer to use Cash Flow vs. Net Income as the denominator, since it's more difficult for management to skew OCF with clever accounting practices.
Formula
Price / Cash Flow = Market Cap / Cash Flows from Operations
| Sector | Price / Operating Cash Flow |
|---|---|
| Consumer Discretionary | 9.5x |
| Consumer Staples | 13.2x |
| Energy | 7.7x |
| Financials | 12.4x |
| Healthcare | 18.8x |
| Industrials | 14.1x |
| Information Technology | 19.5x |
| Materials | 11.1x |
| Telecom | 6.5x |
| Utilities | 9.6x |
12. PEG Ratio
The Price-Earnings to Growth abbreviated as PEG Ratio is a crude heuristic used to measure the level of earnings growth reflected in a stock's market price. The benchmark for the PEG ratio is 1, and stocks with a PEG under 1 are considered undervalued. Similarly, those with a PEG greater than 1 are considered overvalued. Note, though this ratio is very popular, it provides a rough approximation of intrinsic value at best.
Formula
PEG Ratio = (Price / EPS) / (% Growth Rate * 100)
| Sector | PEG Ratio | PEG Ratio Fwd |
|---|---|---|
| Consumer Discretionary | 1.1 | 1.8 |
| Consumer Staples | 1.8 | 2.4 |
| Energy | 0.5 | 1.0 |
| Financials | 1.2 | 1.5 |
| Healthcare | 0.9 | 1.3 |
| Industrials | 1.3 | 2.3 |
| Information Technology | 1.1 | 1.6 |
| Materials | 0.9 | 2.2 |
| Telecom | 1.2 | 2.0 |
| Utilities | 2.4 | 3.5 |
Additional Resources
I’ve created a simple cheat sheet listing the formulas and short descriptions that you can download and print for quick reference.
