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

Tyler Durden's picture

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. 

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
Tim Knight from Slope of Hope's picture

Cool stuff; thank you!

GUS100CORRINA's picture

Yes indeed, this is very cool stuff. 

I am sane and NOT hallucinating. The MARKET is indeed WAY OVER PRICED.

The phrase "FIGURES LIE and LIARS can FIGURE" is once again proven to be true.

Seasmoke's picture

Good stuff here. This is why I pay the big bucks to be at ZeroHedge.

Dead Canary's picture

Funny. What do some outfits charge for "Market research and analysis". Tens of thousands of dollars?

Here's all you need to know: "All markets are rigged for people that aren't you."

That will be $50,000 please.

order66's picture

Well the price to book is 5. If you're stupid enough to pay that, you'll buy anything.

Racer's picture

Mark to fantasy by the snake oil salemen

saveUSsavers's picture

Read ultra-fine print on IWM -It used to say  "ALL P/Es over SIXTY are set at 60 "

HRH Feant2's picture

Wow. People have no idea how many lies they are being told. When the market goes up in a puff of smoke the next time, I can hear the caterwauling.

No one told me, we didn't know, what?

OT: Did anyone else happen to catch the livestream of Reggie yesterday? Founder of VERI? He was in a fucking NYC restaurant, at a table, live streaming and taking questing about VERI. I like the cryptos, but the nigger is running a big scam on a lot of dumb MFs. Similar to this phony P/E ratio in an index. At least the QQQ fund took the time to be creative. I went to the VERI site. What a joke. Three people are the "founders" and reportedly one of them has left.

Cordeezy's picture

Most of the valuation is in FANG and etfs


Ban KKiller's picture

It all starts with the "accounting"...yeah, broken record. 

Was evaluating a company, in person, the other day. Liquor distributorship. Asked them how the company was structured. LLC, ok, how many shares and where are they pledged? 

End of evaluation. You guess what they said. No wonder they are looking for investors....they are fucking anyone who comes on board. 

Due dillegence....ever hear of it? I DO look a gift horse in the mouth....may be a little rude but too bad. 

spanish inquisition's picture

Is the initial example correct? $3M with earning of 170K and I come up with P/E 17.64. Averging the P/E's seems incorrect. Edit: Sorry, didn't know we were in make up numbers land of Wall Street.

hooligan2009's picture


if you exclude the loss making companies from the p/e calculations of the index (trailing and forward estimate?) - why do you include loss making companies in the index at all?

seems to me that the way to analyze the index - aka, the market - is to sum all earnings/losses and divide by market cap.

of course, price to free cahs flow on a current and expected basis would be useful, as would accurate PE to accurate gorwith in accurate E.

if the index does not reflect the accurate characterisitcs of its components, valuation metrics such as PE are useless.

i applaud the work done to expose this fraud and also would applaud mightily if this exposed any corruption in the use of etf's to attract investment funds based on this flase premise.

just how many of these factors are distorted in this way AND THEN USED  to tilt investments in, for example,  active beta or facotr based investing?

well done!

max2205's picture

Buy em when they go up sell em when they go down....it's that simple 

Panic Mode's picture

I always thought I am a smart investor as I made money on 2008 crash. However, my investment have been stagnant since then. Everyone told me their investments is great.

I have come to conclusion I was lucky, not smart. I surrender, liquidate my pensions & shares. Keeping cash, tangible assets & collecting diecast cars as a hobby.

I'll keep on working as long as I can, I like working anyway.

konadog's picture

It's no secret that equities and bonds are in a massive bubble. The multi-trillion dollar ocean of liquidity from central banks had to go somewhere. Public companies are borrowing like there is no tomorrow at low interest rates and buying back stock. They seem to have forgotten that someday that debt has to be paid back and when interest rates rise, simply servicing it will crush their profits. Such is the problem with public companies being run by massively overpaid ivy league inbreeds and not by their owners. Even foreign central banks are in on the action with Swiss National Bank buying Apple and Bank of Japan buying Yamaha just to name a couple. Against this backdrop, how could the markets not be in a bubble? This is completely f*cked and it won't end well.

To me about the only takeaway from this article is that when the investment banks start rationalizing and publishing deceptive crap like weighted harmonic mean, history suggests that it's likely closer to the end than the beginning. It's an epoch moment and massive fortunes will be made and lost in getting this one right.

BuddhistAescetic's picture

Zerohedgers please make this tyrannical United States legislation go viral now!



BocceBaal's picture

A harmonic mean is far better than a simple average. If, for example, AMZN had a profit of $1, its P/E would be about 500B, making the average P/E of the index meaningless.

Better is to take the total earnings divided by the total market cap because that allows for negative earnings. This article should have been far shorter.

Entitled Millennial's picture

Indeed harmonic mean makes the most sense as a measure of an index's P/E. I find E/P is a more intuitive ratio, something akin to realized growth rate, and E/P can be arithmetically averaged. To your point if a company has 0 earnings its P/E is infinite and is useless in an arithmetic mean, but its 0 E/P is intuitive and useful. The article makes harmonic mean sound a bit nefarious, but it's not.


shoWTHyme's picture

Why not (sum of  [price*weight])/(sum of [earnings*weight])?



ThanksIwillHaveAnother's picture

What other indexes calculate p/e similarly?  Stack the bullshit high!