Sign up today for an exclusive discount along with our 30-day GUARANTEE — Love us or leave, with your money back! Click here to become a part of our growing community and learn how to stop gambling with your investments. We will teach you to BE THE HOUSE — Not the Gambler!

When Is A P/E Not A P/E, Or How To Turn 90 Into 22 In Three Easy Steps

By VW Staff. Originally published at ValueWalk.

Horizon Kinetics commentary for the month of August 2017, titled, “When is A P/E Not a P/E, or How To Turn 90 into 22 in Three Easy Steps.”

Get The Full Walter Schloss Series in PDF

Get the entire 10-part series on Walter Schloss in PDF. Save it to your desktop, read it on your tablet, or email to your colleagues.

According to the PowerShares QQQ fact sheet, the P/E ratio of the NASDAQ 100 is 22.19x, calculated on a trailing basis, and that is roughly comparable to the P/E of the S&P 500. No doubt, the P/E – the price, in essence – is an important fact for investors who are considering whether to own it or not. But is it really a fact, as we think of facts? Because the QQQ P/E is not the simple mathematical average of the P/E ratios of all of the companies in the index, as one might naturally expect.

First, it is calculated by excluding all firms with negative earnings. It also effectively excludes companies with excessively high P/E ratios. Would you do that? Does it make sense?

Let’s reason through the easy one first, the idea of excluding companies with negative earnings. For the simplicity of round numbers, say an investor in private businesses made a \$1 million investment in each of 3 small companies, flower shops, convenience stores, what have you, for a total of \$3 million. One business earns \$100,000 per year, so it has a price-to-earnings ratio of 10x; the second earns \$50,000, for a P/E ratio of 20, and the third earns only \$20,000 and so has a P/E of 50. This last one is probably situated on a high-growth street corner. Averaging the three P/E ratios of 10, 20 and 50 means that the average P/E of the 3-company portfolio is 26.7x. So far, so good.

But what if business number two loses \$50,000 a year instead of making \$50,000? One can see that averaging the three P/E ratios would be misrepresentative, because then the average P/E ratio would be 13.3x (+10, -20 and +50, divided by 3), which is one-half as expensive as the original P/E of 26.7x. Obviously, the portfolio with a loss-generating company is not cheaper than the all-profitable one. In a sense, the ETF organizers are staying within the logic of averaging individual P/E ratios by eliminating the company with the negative P/E ratio from the calculation as a statistical aberration or outlier. As if it does not exist or have an impact. The resultant P/E, however, does not represent reality.

To try representing reality better, how do we imagine the private investor would look at his or her investments? I think we all know how they’d look at actual dollars. Perhaps they would add up all the earnings of the three businesses, which in the first instance was \$170,000 (\$100,000 + \$50,000 + \$20,000), and compare that with the \$3 million of total investment: that’s 17.1x earnings. In the second instance, including the business that loses \$50,000, the three together earn \$70,000 a year, not \$170,000. Earnings of \$70,000 is not a lot for \$3,000,000 of investment; that’s 42.9x earnings or, in income yield terms, 2.03%. That’s reality.

So, in reality one knows that an unprofitable company makes an investment more expensive, while in the world of indexation, such as in the QQQ, unprofitable companies are eliminated, making the P/E lower.

Now for the more interesting technique of P/E reduction: neutralizing the impact of the excessively high P/E ratio. Companies with very high P/E ratios, say over 100, are effectively eliminated from the calculation of the QQQ valuation. For instance, in 2016, Amazon earned \$4.90 per share. The trailing P/E for its current share price would be roughly 188.7x. Since Amazon is a 6.82% position in the NASDAQ 100 Index, its full inclusion would raise the index P/E by some appreciable and observable degree.

Similarly, by this convention, which we’ll explain shortly, there is no way of informing prospective NASDAQ 100 purchasers of the valuation impact of holdings other than Amazon, such as Netflix, Tesla, and JD.com. Their trailing P/E ratios are 191x, -82x (yes, that’s negative), and -117x, respectively. Such names effectively do not exist from a P/E risk measurement perspective, even though, as weightings in the index, they definitely affect the risk of any dollar invested in the index.

The manner in which this is done is as follows. On the PowerShares QQQ fact sheet (see accompanying excerpt), one will note the aforementioned P/E ratio of 22.19. A footnote to that figure indicates that the P/E is calculated using the Weighted Harmonic Mean. Seems harmless enough. Wikipedia provides a definition: The harmonic mean can be expressed as the reciprocal of the arithmetic mean of the reciprocals of the given set of observations. Huh?

To translate that bewildering language into the 3-step recipe via which an egregiously high P/E ratio is cleansed into a harmless middling sort of group average, we’ll use a couple of examples. Observe the following hypothetical equal-weighted 4-stock portfolio consisting of a range of low, somewhat high and egregiously high-valuations, ranging from 10x to 300x. A simple average results in a portfolio P/E of 90x.

The first step in the P/E transformation process, from the definition of Harmonic Mean, is to calculate the reciprocals of each P/E ratio, so that, for example, 10 is turned into 1/10, or 0.10. This is done for each of the 4 companies, and those reciprocals will be added up.

This step is the critical part of the alchemy, because note how Stock D is treated. Its P/E ratio of 300, which is very large in relation to Stock A’s P/E of 10, is transformed, as 1/300, into 0.003. This is very small. So small, that when those four fractions are added together, Stock D accounts for only 1.61% of the sum of those fractions (.003 ÷ .1867); whereas, it began as an equal one-quarter member of the four-stock portfolio. Now, it is virtually a rounding error.

Steps 2 and 3, as shown in the accompanying table, involve taking an average of the reciprocals just summed, in this case dividing by four, since it is a four-stock portfolio, and then taking the reciprocal of that number. That completes the strange journey of transforming a fairly understandable, if alarming, P/E of 90x into the more comforting Harmonic Mean P/E ratio of only 21.5x

A more representative and straightforward way of calculating the index P/E ratio would be to simply divide its total market capitalization by the total GAAP net profit that all those companies produce, as in the private investor example. Done this way, the P/E is not 22.19, but 25.77x. Moreover, the lowest P/E stock in the NASDAQ 100 is

The post When Is A P/E Not A P/E, Or How To Turn 90 Into 22 In Three Easy Steps appeared first on ValueWalk.