Wednesday 12 September 2012

The FTSE 100 Cyclically Adjusted PE Ratio (FTSE 100 CAPE or PE10) – September 2012 Update

This is the Retirement Investing Today monthly update for the FTSE 100 Cyclically Adjusted PE (FTSE 100 CAPE).  Last month’s update can be found here.

As always before we look at the CAPE let us first look at other key FTSE 100 metrics:
  • The FTSE 100 Price is currently 5,782 which is a 1.2% above the 01 August 2012 Price of 5,712 and 6.7% above the 01 September 2011 Price of 5,419.
  • The FTSE 100 Dividend Yield is currently 3.74% which is a slight rise from the 01 August 2012 yield of 3.71%.
  • The FTSE 100 Price to Earnings (P/E) Ratio is currently 11.46 which is up 6.2% since the 01 August 2012 and 32.5% since the 01 September 2011.
  • The Price and the P/E Ratio allows us to calculate the FTSE 100 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) as 504.  Earnings are continuing to fall while Prices continue to rise.  They are down 4.7% month on month and down 19.5% year on year.
The first chart below provides a historic view of the Real (CPI adjusted) FTSE 100 Price and the Real FTSE 100 P/E.  The second chart provides a historic view of the Real Earnings along with a rolling Real 10 Year Earnings Average for the FTSE 100.

Click to enlarge

Click to enlarge

Let us now turn our attention to what this post is interested in which is the FTSE 100 Cyclically Adjusted PE.  This is also shown in the first chart above.  For completeness let me also detail the usual reminders.  I do not use P/E ratio’s to make investment decisions from and instead use this CAPE.  This is because the P/E ratio does not take the business cycle into account which the CAPE tries to adjust for.  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 Price to the 10 Year Real (CPI adjusted) first possible day of the month Earnings.  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.

The key FTSE 100 CAPE/PE10 metrics are:
  • FTSE 100 PE10 is 12.3 which is on par with the 01 August 2012 PE10 of 12.2.
  • The FTSE 100 Average PE10 is 19.2.  Assuming this is “fair value” it indicates that the FTSE 100 is 36% undervalued.  As I always say I don’t actually believe this and think that this is a function of the fact that the dataset is quite short but more on this later.
  • The FTSE 100 Median PE10 = 19.4
  • The FTSE 100 20th Percentile = 14.6
  • The FTSE 100 80th Percentile = 23.3
  • The correlation between the FTSE 100 Price and the FTSE 100 PE10 is 0.25
The chart below is why I use the FTSE 100 CAPE to drive a tactical portion of my Retirement Investing Today asset allocation.  It shows the relationship between the FTSE 100 PE10 and the Nominal 5 Year Capital Gains from August 1993 to August 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 Nominal Capital Gains we see a correlation of -0.48 with an R^2 of 0.16.  With the FTSE 100 PE10 at 12.3 the trendline suggests a future Nominal 5 Year Capital Gain of 61%.  In contrast the Real (inflation adjusted) 5 Year Capital Gain (not charted today) trendline implies a return of 44%.

 Click to enlarge

While I am making investment decisions from this FTSE 100 CAPE data I have a problem in that the dataset is quite short.  To correct for this I make a large assumption which 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.5 and from 1993 to present (the length of my FTSE 100 dataset) we have seen a much higher average PE10 of 26.5.  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.5/26.5)x19.2=11.9.  Comparing that number with today’s PE10 of 12.3 suggests a small 3% over valuation compared with the 36% undervaluation presented earlier.  It is this relationship that I am basing my own personal investment decisions on and with the market slightly over valued I am targeting an allocation of 19.8% of total assets towards UK Equities as my tactical allocation compared with a nominal strategic allocation of 20% of total assets.

As always do your own research.

Assumptions include:
-    UK CPI inflation data for August and September 2012 are estimated.

6 comments:

  1. Dont buy (16.5/26.5)x19.2=11.9.

    ReplyDelete
  2. Hi,
    First, please take my sincere apologies for disturbing you. I know you might be very busy but it will be very kind of you, if you read my mail fully.
    I just visited your site (retirementinvestingtoday.com) from google.
    The articles of your site is really worth reading. The quality of your content is excellent.

    I would like to contribute some idea to your viewers as a guest blogger.My article would be unique and will be published only in your site.

    Guest posts are great ways to gain extra traffic and share knowledge with a large audience.

    Please let me know your thoughts. Will wait for your response
    --
    Thanks & Regards,
    Kavin Matthews

    ReplyDelete
  3. Hi

    Thanks again for the posts.

    FWIW have you seen this recent article: http://www.mebanefaber.com/2012/09/05/global-valuation-10-year-pe-ratios/

    Regards
    Tony

    ReplyDelete
  4. Hi Tony

    Thanks for sharing the article. It's interesting to note that 9 of the lowest 10 PE10 countries within the dataset are European.

    Cheers
    RIT

    ReplyDelete
  5. Hi have you updated this recently? thanks

    ReplyDelete
    Replies
    1. For the latest version of this go to the Data/Charts tab underneath the site banner and then and click on the "UK FTSE100 Cyclically Adjusted PE (PE10/CAPE)" link. Hope that helps.

      Delete