When Is A P/E Not A P/E: How To Turn Nasdaq's 90x Into 22x In 3 Easy Steps

Having previously exposed the greatest trick the market has pulled on Biotech investors in the past - What Is The PE Of The iShares Biotech ETF? It Depends On Whether You Read The Fine Print -  it appears investors need another lesson in reality versus perception.

As Horizon Kinetics puts it so eloquently - It’s One Thing to Not Know, It’s Another to Be Told What Isn’t So

"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."

Unpacking a Mainstream Index, the NASDAQ 100

First, the Label

The essential value of an index is that it is a passive form of investing, the opposite  of active management. The active manager’s results are dependent upon security selection; in contrast, indexation’s foundational intent is that the results will derive from broad exposure to a vast array of securities; that no individual security will dramatically impact the result – the entire idea is to avoid company?specific risk.

This might seem self?evident.   But, of course, we write this for a reason. Those who subscribe to and practice indexation - which is increasingly becoming everyone - might wish to take an actual look at the NASDAQ 100. This is a mainstream index, intended to be the 100 largest firms of the NASDAQ Composite Index, which now contains over 3,000 firms. It is available via the popular PowerShares NASDAQ 100 ETF (ticker QQQ), which has almost $50 billion of assets, making it one of the country’s 10 largest.

Just the top five holdingsin the NASDAQ 100, which are Apple, Google, Microsoft, Amazon and Facebook, total 41% of the value of the entire index. If an active manager presented that level of exposure, it would be daring, to say the least. In some jurisdictions, it would violate regulations.

For example, in the European Community, what are known as UCITS1 funds cannot have more than 40% exposure from position sizes of 5% or greater. To do so is considered reckless. Yet, the NASDAQ 100 is available via the iShares NASDAQ 100 UCITS ETF. It has over $1.1 billion in assets under management in the UK alone. In other words, concentration risk that isforbidden to an active manager is considered reasonable and permissible if it happensto be an index.

Clearly, this index is the opposite of diversified – its results depend powerfully on individual securities.

Second, Valuation:  When is A P/E Not a P/E ?, or How To Turn 90 into 22 in Three Easy Steps

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 asthe 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. Asi f 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 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 Ebay, at, oddly, only 4.8x. That’s because almost two?thirds of its $7.8 billion of reported earnings in 2016, was from a non?cash tax adjustment and a gain on the sale of a stock. Its real earnings were $2.3 billion, which is more than analysts expect it to earn this year, and the real P/E is 16.61x. If one is comfortable with this single adjustment, the NASDAQ 100 P/E is 26.33x, not 22.19. 

However, comparing the total market value of the companies in the index to their total earnings is not the accepted procedure and, as a consequence, the NASDAQ 100 Index is not represented as a high?P/E, concentrated portfolio.

Incidentally, measuring the NASDAQ 100 valuation in a manner more aligned with accepted procedure, by calculating the simple average of the P/E ratios of the 91 profitable companies, results in a valuation of 43.6x earnings. Or, even closer to accepted practice, if one calculated the weighted average P/E ratios of the 91 profitable companies (giving proportionately greater weight to the larger companies), then the QQQ valuation is 41.04x. No active manager would be permitted to manage a concentrated, high?P/E portfolio for an institutional client. Only an index enjoys this privilege.

Without dwelling on the figures themselves, the industry sector concentration in the NASDAQ 100 is as extreme as its company?specific concentration. It is readily seen that it lacks many of the presumed characteristics of a bona fide diversified index, and that it is truly expensive if one includes in the valuation those of its components that are in fact remarkably expensive. Indeed, it has many of the characteristics that advocates of indexation claim, not without justification, typify active management, including no sense of risk control and no valuation discipline, yet all available in an index format at a reduced fee.


These issues of market saturation and valuation apply to substantially all of the major index?centric stocks that represent ‘the market’ as investors understand it, including the consumer branded products companies like McDonalds and Procter & Gamble. Indexation has unwittingly become the place to go for systemic risk. Whether the index constituents are designated as consumer discretionary or information technology, or as dividend aristocrats or REITs or Non?US Developed Nations, their practical capacity to provide differentiated outcomes has been largely drained away. The diversification exists primarily in name only.

The large?cap and mega?cap companies occupy the same multiplicity of ETFs and experience the same inflow of funds upon which they largely depend for their valuation. As they do upon artificially low interest rates. They have either substantially saturated their markets and cannot expand their sales, in which case they trade at P/E ratios traditionally reserved for growth companies, of 22x to 25x; or they manifest legitimately rapid growth, in which case their P/E ratios are so anomalously high that they are actually excluded from the index P/E calculations.

Under these circumstances, does the safety of the crowd, herd immunity, still pertain?  If the primary risks are systemic, then perhaps one should be outside the system.  No one requires you, many of us are driven to remind our teenage children, to stay at the party if you’re uncomfortable being there.