Here is a new update of a popular market valuation method using the most recent Standard & Poor's "as reported" earnings and earnings estimates and the index monthly average of daily closes for the past month. For the earnings, see the table below created from Standard & Poor's latest earnings spreadsheet.
● TTM P/E ratio = 20.4
● P/E10 ratio = 26.8
The Valuation Thesis
A standard way to investigate market valuation is to study the historic Price-to-Earnings (P/E) ratio using reported earnings for the trailing twelve months (TTM). Proponents of this approach ignore forward estimates because they are often based on wishful thinking, erroneous assumptions, and analyst bias.
TTM P/E Ratio
The "price" part of the P/E calculation is available in real time on TV and the Internet. The "earnings" part, however, is more difficult to find. The authoritative source is the Standard & Poor's website, where the latest numbers are posted on the earnings page.
The table here shows the TTM earnings based on "as reported" earnings and a combination of "as reported" earnings and Standard & Poor's estimates for "as reported" earnings for the next few quarters. The values for the months between are linear interpolations from the quarterly numbers.
The average P/E ratio since the 1870's has been about 16.6. But the disconnect between price and TTM earnings during much of 2009 was so extreme that the P/E ratio was in triple digits — as high as the 120s — in the Spring of 2009. In 1999, a few months before the top of the Tech Bubble, the conventional P/E ratio hit 34. It peaked close to 47 two years after the market topped out.
As these examples illustrate, in times of critical importance, the conventional P/E ratio often lags the index to the point of being useless as a value indicator. "Why the lag?" you may wonder. "How can the P/E be at a record high after the price has fallen so far?" The explanation is simple. Earnings fell faster than price. In fact, the negative earnings of 2008 Q4 (-$23.25) is something that has never happened before in the history of the S&P 500.
Let's look at a chart to illustrate the unsuitability of the TTM P/E as a consistent indicator of market valuation.
The P/E10 Ratio
Legendary economist and value investor Benjamin Graham noticed the same bizarre P/E behavior during the Roaring Twenties and subsequent market crash. Graham collaborated with David Dodd to devise a more accurate way to calculate the market's value, which they discussed in their 1934 classic book, Security Analysis. They attributed the illogical P/E ratios to temporary and sometimes extreme fluctuations in the business cycle. Their solution was to divide the price by a multi-year average of earnings and suggested 5, 7 or 10-years. In recent years, Yale professor and Nobel laureate Robert Shiller, the author of Irrational Exuberance, has popularized the concept to a wider audience of investors and has selected the 10-year average of "real" (inflation-adjusted) earnings as the denominator. Shiller refers to this ratio as the Cyclically Adjusted Price Earnings Ratio, abbreviated as CAPE, or the more precise P/E10, which is my preferred abbreviation.
The Correlation between the S&P Composite and its P/E10
As the chart below illustrates, the P/E10 closely tracks the real (inflation-adjusted) price of the S&P Composite. In fact, the detrended correlation between the two since 1881, the year when the first decade of average earnings is available, is 0.9977. (Note: A perfect positive correlation would be 1 and the absence of correlation would be 0).
The historic P/E10 average is 16.6. After dropping to 13.3 in March 2009, the ratio rebounded to an interim high of 23.5 in February of 2011 and then hovered in the 20-to-21 range. The latest ratio is at a new interim high -- the highest since December 2007. The ratio in the chart above is doubly smoothed (10-year average of earnings and monthly averages of daily closing prices for the index). Thus the fluctuations during the month aren't especially relevant (e.g., the difference between the monthly average and monthly close P/E10).
Of course, the historic P/E10 has never flat-lined on the average. On the contrary, over the long haul it swings dramatically between the over- and under-valued ranges. If we look at the major peaks and troughs in the P/E10, we see that the high during the Tech Bubble was the all-time high above 44 in December 1999. The 1929 high of 32.6 comes in at a distant second. The secular bottoms in 1921, 1932, 1942 and 1982 saw P/E10 ratios in the single digits.
The chart also includes a regression trendline through the P/E10 ratio for the edification of anyone who believes the price-earnings ratio has naturally tended higher over time as markets evolve. The latest ratio is 42% above trend.
Where does the current valuation put us?
For a more precise view of how today's P/E10 relates to the past, our chart includes horizontal bands to divide the monthly valuations into quintiles — five groups, each with 20% of the total. Ratios in the top 20% suggest a highly overvalued market, the bottom 20% a highly undervalued market. What can we learn from this analysis? The Financial Crisis of 2008 triggered an accelerated decline toward value territory, with the ratio dropping to the upper second quintile (from the bottom) in March 2009. The price rebound since the 2009 low pushed the ratio back into the top quintile, hovered around that boundary and has now moved higher.
A cautionary observation is that when the P/E10 has fallen from the top to the second quintile, it has eventually declined to the lowest quintile and bottomed in single digits. Based on the latest 10-year earnings average, to reach a P/E10 in the high single digits would require an S&P 500 price decline below 550. Of course, a happier alternative would be for corporate earnings to continue their strong and prolonged surge. If the 2009 trough was not a P/E10 bottom, when might we see it occur? These secular declines have ranged in length from over 19 years to as few as three.
We can also use a percentile analysis to put today's market valuation in the historical context. As the chart below illustrates, latest P/E10 ratio is approximately at the 94th percentile of this series.
Deviation from the Mean
Here are a pair of charts illustrating the historic P/E 10 ratio from its mean (average) and geometric mean with callouts for peaks and troughs along with the latest values.
Relative to the mean, the market is expensive, with the ratio approximately 61% above its arithmetic mean and 74% above its geometric mean.
The Prevailing Question...
Was March 2009 the beginning of a secular bull market? Perhaps, and certainly the new all-time highs repeatedly set over the past several months are conspicuous tick marks for the optimists. But the history of market valuations suggests a cautious perspective.
What Are the Impacts of Low Interest Rates and Inflation on Market Valuations?
For more on this topic, see my monthly update:
Wouldn't Valuations Be Much Lower If We Exclude the Financial Crisis Earnings Crash?
This is an often asked question, the assumption being that the unprecedented negative earnings of the Financial Crisis skewed the P/E10 substantially higher than would otherwise have been the case. While that may seem a reasonable assumption, a simple experiment shows that the earnings plunge did not dramatically impact the ratio. The "hypothetical" chart below,use2 the December 2007 TTM earnings of 66.18 as a constant for the next 29 months to totally eliminate the collapse in earnings of the Great Recession.
What impact does this have on the P/E 10? The mean (average) only drops from 16.6 to 16.5. The lower bound of the top quintile drops from 21.2 to 20.8.
Where Can I Find the Latest Earnings Data for the S&P 500?
Follow these steps to access the Standard & Poor's earnings spreadsheet:
- Go to the S&P 500 page on the S&P Dow Jones Indices website. Here is a: direct link to the page.
- Click the "ADDITIONAL INFO" button in the left column.
- Click the Index Earnings link to download the Excel file. Once you've downloaded the spreadsheet, scroll down to the "As Reported Earnings" data in column L.
Exactly What Is the S&P Composite index?
For readers unfamiliar with the index, see this article for some background information.