The New FTSE 100 Cyclically Adjusted Price Earnings Ratio (FTSE 100 CAPE) Update - April 2013

Welcome to the new look UK FTSE 100 monthly stock market review which includes a couple of valuation metrics.  The last time we looked at this dataset was on the 10 March 2013.  This monthly review will now loosely follow the same format we use for the S&P 500 which will enable us to get some consistency across regions going forward.

FTSE 100 Price

At market close on Tuesday the FTSE 100 was priced at 6,430.  That is a rise of 0.8% when compared with the 01 March 2013 Price of 6,379 and 9.5% above the 02 April 2013 Price of 5,875.  How this pricing compares with history can be seen in the chart below.

Click to enlarge

This is a similar chart to that which you will see in many places within the mainstream media.  Let’s now remove the sensationalism by:

• Correcting the chart for the devaluation of the £ through inflation.  For this dataset I use the Consumer Price Index (CPI) to devalue the £.
• Plotting the Pricing on a logarithmic scale as opposed to a linear one.  By using this scale percentage changes in price appear the same.  

Looking at the chart this way reveals the FTSE 100 in a very different light.  That light shows that the compound annual growth rate (CAGR) in today’s £’s has only been 2.0%.  Correct it by the Retail Prices Index (RPI) and that falls to 1.2%.

Click to enlarge

FTSE 100 Earnings

As Reported Nominal Annual Earnings are currently 483, up from 458 on the 01 March 2013.  They are down 18.3% on last year and 23.0% on October 2011’s 628.  Or course this looks better than it really is as inflation flatters the result.  I therefore plot a chart below, again on a logarithmic axis, showing Real (inflation adjusted) Earnings performance over the long term.

Click to enlarge

This only tells half of the Earnings story as it is an absolute number and so doesn’t help us with assessing market value.  Let’s therefore divide the nominal Earnings by the nominal Price to calculate the Earnings Yield.  Today that’s 7.5% and can be compared with history in the chart below.

Click to enlarge

FTSE 100 Dividends

Dividends matter.  Today annual dividends for the FTSE 100 are 226.  The Real inflation adjusted growth of FTSE 100 Dividends, which is what many long term buy and holders including myself are looking for, can be seen in the chart below.  Unfortunately I only have dividend data from 2006 but with time that will grow and it’s better than nothing.

Click to enlarge

If we divide Dividends by Price we get the Dividend Yield which is currently 3.5% and can be compared with history below.

Click to enlarge

Valuing the FTSE 100 – The Price/Earnings Ratio (P/E or PE) and the Cyclically Adjusted Price/Earnings Ratio (aka PE10 or CAPE)

Many people use the FTSE 100 P/E as a valuation metric.  It’s actually nothing more than the inverse of the Earnings Yield shown above.  Today it sits at 13.3 which is down on last month’s 13.9.

Personally I prefer to use the FTSE 100 CAPE.  It was made famous by Professor Robert Shiller, who used it on the S&P 500, and it is the ratio of Real (ie after inflation) FTSE 100 Monthly Prices to 10 Year Real (ie after inflation) Average Earnings.  Today the FTSE 100 CAPE is 13.0 which is identical to its value on the 01 March 2013.

Both valuation metrics are shown in the chart below.

Click to enlarge

Does it work?  Well only time will tell but what I can say is that history suggests it has some value.  If we look at a history of 5 Year Nominal Capital Gain of the FTSE 100 and compare that with the two valuation metrics we find:

• The P/E has a correlation of -0.28 which is considered a weak or low correlation.
• The CAPE has a correlation of -0.45 which is considered a moderate correlation.  So it’s not perfect but it’s better than P/E when looking over longish periods which suits an investor like me.

A chart showing historic CAPE to 5 Year Capital Gain is shown below.  With the CAPE at 13.3 the trendline implies a person buying today could expect a future Nominal 5 Year Capital Gain of around 65%.

Click to enlarge

Some other CAPE metrics that may be of interest:

• The correlation between the Nominal FTSE100 Price and the FTSE100 PE10 is 0.20.  This is considered a weak or low correlation.  The correlation between the FTSE 100 Real Price and the FTSE 100 PE10 is a much more impressive 0.66.  This is considered a moderate correlation bordering on a strong or high correlation.
• The Dataset Average FTSE 100 PE10 is 19.0.  Assuming this is “fair value” it indicates that the FTSE 100 is 32% undervalued today.  I’m not so comfortable with this call and think that may be a function of the fact that the dataset is quite short.  I therefore rely on there being a high correlation between International Equities and UK Equities to make a correction for this short period.  My mature S&P 500 dataset 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.4.  If I ratio these two numbers and multiply by the Average FTSE 100 PE10 I get a pseudo “long run” Historic FTSE 100 PE10.  Doing the maths this is (16.5/26.4)x19.0=11.8.  Comparing that number with today’s PE10 of 13.0 suggests a 10% over valuation
• The Dataset Median FTSE 100 PE10 is 19.3.
• The Dataset 20th Percentile S&P 500 PE10 is 14.1.
• The Dataset 80th Percentile S&P 500 PE10 is 23.0.

Making Personal Investment Decisions from this Data

My Retirement Investing Today Strategy drives tactical allocations from CAPE values.  It uses the FTSE 100 CAPE to set my allocation to the UK Equities portion of my portfolio.  This is strategically set at 20% of total wealth.  By adding the FTSE 100 CAPE tactical spin on top, as detailed in the Strategy, it forces a lower tactical allocation target of 18.8% today.

As always do your own research.

Assumptions include:

• UK CPI inflation data for March and April 2013 is estimated.