As I write this post the UK stock market is closed. The last trading day was Friday 01 June 2012 at which point the FTSE 100 closed at 5,260. At this price the FTSE Actuaries Share Indices provides us with a FTSE 100 P/E Ratio of 9.4 which allows us to calculate Earnings as 562. These Earnings are as Reported Earnings, which are the last reported year’s earnings and are made up of the sum of the latest two half years earnings. This will differ from a lot of calculated earnings presented online, which will be on an ‘as earned’ (which is the current forecast earnings) basis, resulting in differences, particularly when there are large upward or downward adjustments in earnings.
As of Friday the dividend yield has crept up to 4%. The last time we were over 4% was July 2009.
If you look back over recent posts you will see that I do not use the P/E ratio to make investment decisions from. This is largely due to the fact that the P/E ratio does not take the business cycle into account. Instead to try and adjust for this cycle I use what I have called the FTSE 100 PE10 (effectively a FTSE 10 cyclically adjusted PE or CAPE for short). The method used is similar to that developed by Professor Robert Shiller for the S&P500. The calculation is the ratio of Real (ie after inflation) FTSE 100 first possible day of the month Prices to 10 Year Real (ie after inflation) first possible day of the month Earnings. The inflation adjuster I use is the CPI. Unfortunately the dataset I have created only goes back to July 1993. Therefore to get a meaningful set of numbers I have had to average in to a PE10 for the first 10 years. What this means is that July 1994 is actually a PE1, July 1995 is a PE2 and so forth until July 2003 when we have a full FTSE 100 PE10.
So that’s the methodology what are the numbers? Well today the FTSE 100 PE10 stands at 11.2. The history of the PE10 is shown in my first chart along with the Real (inflation adjusted) FTSE 100 price and the FTSE 100 P/E. Some further PE10 data that might be of interest:
- FTSE 100 PE10 = 11.2
- Dataset Average PE10 = 19.3. Assuming this is “fair value” it indicates that the FTSE 100 is 42% undervalued. I don’t actually believe this and think that this is a function of the fact that the dataset is quite short. More about that later.
- Dataset Median PE10 = 19.5
- Dataset 20th Percentile = 14.9
- Dataset 80th Percentile = 23.3
My second chart plots the FTSE 100 Real (inflation adjusted) Earnings. It shows we are quite a way off the October 2011 high of 645 but when comparing to historic Earnings we are still very healthy at 562.
My third chart shows the relationship between the FTSE 100 PE10 and the Nominal 5 Year Capital Gains from August 1993 to June 2007. Ideally this would be a 5 Year Total Return Chart, ie including dividends, however this dataset is not yet mature enough to allow this given my dividend data only goes back to 2006. Even so just looking at 5 Year Capital Gains we see a correlation of -0.48 with an R^2 of 0.16. With the FTSE 100 PE10 at 11.2 the trendline suggests a future Nominal 5 Year Capital Gain of 68%. In contrast the Real (inflation adjusted) 5 Year Capital Gain (not charted today) trendline implies a return of 49%.
Finally, unlike when I lasted posted on the FTSE 100, I am now using the FTSE 100 PE10 to make investment decisions from. My problem, as previously mentioned, is that the dataset is quite short. To correct for this I make what some might consider to be a large assumption. As always I would value Retirement Investing Today readers opinions on this. The assumption is that there is a high level of correlation between UK Equities and International Equities. Tim Hale in his excellent book Smarter Investing shows a table which suggests this correlation could be as high as 0.9. Therefore if I look at my mature S&P 500 dataset it shows that from 1881 to present we have seen an average PE10 of 16.4 and from 1993 to present (the length of my FTSE 100 dataset) we have seen a much higher average PE10 of 26.6. If I ratio these two numbers and multiply by the PE10 Average from my FTSE 100 dataset I can get a pseudo “long run” Historic FTSE 100 PE10. Doing the maths this is (16.4/26.6)x19.3=11.9. Comparing that number with today’s PE10 of 11.2 suggests the market is undervalued by 6% compared with the 42% undervaluation presented earlier. It is that 6% I am basing my own personal investment decisions on.
As always do your own research.
- UK CPI inflation data from May and June 2012 are estimated.