The FTSE 100 Cyclically Adjusted PE Ratio (FTSE 100 CAPE or PE10) – November 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,819 which is flat against the 01 October 2012 Price of 5,820 and 7.3% above the 01 November 2011 Price of 5,422.
• The FTSE 100 Dividend Yield is currently 3.71% which is also flat against the 01 October 2012 yield of 3.72%.
• The FTSE 100 Price to Earnings (P/E) Ratio is currently 11.41.
• 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 510.  They are down 1.0% month on month and down 7.9 year on year.  The Earnings Yield is therefore 8.8%.

The S&P 500 Cyclically Adjusted PE (aka S&P 500 or Shiller PE10 or CAPE) – November 2012 Update

This is the Retirement Investing Today monthly update for the S&P500 Cyclically Adjusted PE (S&P 500 CAPE).  Last month’s update can be found here.

As usual before we look at the CAPE let us first look at other key S&P 500 metrics:

• The S&P 500 Price is currently 1,360 which is a fall of 5.4% on last month’s Price of 1,438 and 10.9% above this time last year’s Price of 1,226.
• The S&P 500 Dividend Yield is currently 2.2%.
• The S&P As Reported Earnings (using a combination of actual and estimated earnings) are currently $88.20 for an Earnings Yield of 6.5%.
• The S&P 500 P/E Ratio is currently 15.4 which is down from last month’s 16.4.

The first chart below provides a historic view of the Real (inflation adjusted) S&P 500 Price and the S&P 500 P/E.  The second chart provides a historic view of the Real (after inflation) Earnings and Real (after inflation) Dividends for the S&P 500.

 

 Click to enlarge

The ASX 200 Cyclically Adjusted PE (aka ASX 200 PE10 or ASX200 CAPE) – October 2012 Update

This is the Retirement Investing Today monthly update for the Australian ASX 200 Cyclically Adjusted PE (ASX 200 CAPE).  The last update can be found here.

Before we run the analysis we need to discuss an anomaly with the dataset that has been built over many years.  The dataset is calculated using data published by the Reserve Bank of Australia.  I show a screen grab of this data below.  Reading this table I have always assumed that the columns “Dividend yield per cent per annum” and “Price/Earnings ratio” referred to the ASX200.  It turns out that this was a bad assumption and this month I have noticed some small print that highlights that these two columns actually refer to the MSCI Australia Index with all other columns being the ASX200.  This to me is just bizarre but if we want to continue with this dataset it looks like I am going to have to think outside the box as I’ve tried searching for new data that details the P/E and Dividend Yield of the ASX200 and not surprisingly drawn a blank.

 Click to enlarge

The FTSE 100 Cyclically Adjusted PE Ratio (FTSE 100 CAPE or PE10) – October 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,911 which is 2.6% above the 03 September 2012 Price of 5,758 and 16.5% above the 03 October 2011 Price of 5,076.
• The FTSE 100 Dividend Yield is currently 3.70% which is a slight fall from the 03 September 2012 yield of 3.75%.
• The FTSE 100 Price to Earnings (P/E) Ratio is currently 11.43.
• 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 517.  They are up 2.3% month on month and down 17.7% year on year.  The Earnings Yield is therefore 8.7%.

The S&P 500 Cyclically Adjusted PE (aka S&P 500 or Shiller PE10 or CAPE) – October 2012 Update

This is the Retirement Investing Today monthly update for the S&P500 Cyclically Adjusted PE (S&P 500 CAPE).  Last month’s update can be found here.

As usual before we look at the CAPE let us first look at other key S&P 500 metrics:

• The S&P 500 Price is currently 1,435 which is 0.6% below last month’s Price of 1,443 and 18.8% above this time last year’s Price of 1,207.
• The S&P 500 Dividend Yield is currently 1.97%.
• The S&P As Reported Earnings (using a combination of actual and estimated earnings) are currently $88.87 for an Earnings Yield of 6.2%.
• The S&P 500 P/E Ratio is currently 16.2 which is down from last month’s 16.3.

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 S&P 500 Cyclically Adjusted PE (aka S&P 500 or Shiller PE10 or CAPE) – September 2012 Update

Stock markets today provided big rises after Mario Draghi announced that he plans to buy up the debt of his favourite PIGS.  The German DAX rose 2.9%, France’s CAC 40 rose 3.1%, the UK’s FTSE 100 was up 2.1% and the Spanish IBEX was up a large 4.9%.  Positive market responses were not limited to Europe with the US S&P 500 also up 1.9% as I write this post. 

Given these market moves let’s look at the Retirement Investing Today monthly update for the S&P500 Cyclically Adjusted PE (S&P 500 CAPE).  Last month’s update can be found here.

Before we look at the CAPE let us first look at other key S&P 500 metrics:

• The S&P 500 Price is currently 1,430 which is 1.9% above last month’s Price of 1,403 and 21.8% above this time last year’s Price of 1,174.
• The S&P 500 Dividend Yield is currently 1.98%.
• The S&P As Reported Earnings (using a combination of actual and estimated earnings) are currently $88.59 for an Earnings Yield of 6.2%.
• The S&P 500 P/E Ratio is currently 16.1 which is up from last month’s 15.9.

The FTSE 100 Cyclically Adjusted PE Ratio (FTSE 100 CAPE or PE10) – August 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,835 which is a 3.4% above the 01 July 2012 Price of 5,641 and 13.7% above the 01 August 2011 Price of 5,130.
• The FTSE 100 Dividend Yield is currently 3.69% having fallen back from 3.75% on the 01 July 2012.
• The FTSE 100 Price to Earnings (P/E) Ratio is currently 11.23 which is up 10.7% since the 01 July 2012 and 19.3% since the 01 August 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 520.  Of concern is that Earnings in nominal terms now seem to be falling with them down 6.6% since the 01 July 2012 and down 4.7% since the 01 August 2011.

The S&P 500 Cyclically Adjusted PE (aka S&P 500 or Shiller PE10 or CAPE) – August 2012 Update

This is the Retirement Investing Today monthly update for the S&P500 Cyclically Adjusted PE (S&P 500 CAPE).  Last month’s update can be found here.

Before we look at the CAPE let us first look at other key S&P 500 metrics:

• The S&P 500 Price is currently 1,406 which is 3.4% above last month’s Price of 1,360 and 18.6% above this time last year’s Price of 1,185.
• The S&P 500 Dividend Yield is currently 2.01%.
• The S&P As Reported Earnings (using a combination of actual and estimated earnings) are currently $90.02.
• The S&P 500 P/E Ratio is currently 15.6 which is up from last month’s 15.2.

The ASX 200 Cyclically Adjusted PE (aka ASX 200 PE10 or ASX200 CAPE) – July 2012 Update

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

Let us firstly look at the key ASX 200 market metrics:
-    The ASX 200 Price at market close on Friday is 4,210 which is 2.8% above last month’s Price of 4,095 and 4.9% down year on year.
-    The ASX 200 Dividend Yield is currently 5.0%.
-    The ASX 200 Earnings are currently 333.
-    The ASX 200 P/E Ratio is currently 12.6 compared with the a dataset (since December 1982) average P/E of 18.3

The FTSE 100 Cyclically Adjusted PE Ratio (FTSE 100 CAPE or PE10) – July 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.

Before we look at the CAPE let us first look at other key FTSE 100 metrics:
-    The FTSE 100 Price is currently 5,608 which is a large 6.6% above the 01 June 2012 Price of 5,260.
-    The FTSE 100 Dividend Yield is currently 3.78% having fallen back from 4.00% on the 01 June 2012.
-    The FTSE 100 Price to Earnings (P/E) Ratio is currently 10.08 which is up 7.7% since the 01 June 2012.
-    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 556.

The S&P 500 Cyclically Adjusted PE (aka S&P 500 or Shiller PE10 or CAPE) – July 2012 Update

This is the Retirement Investing Today monthly update for the S&P500 Cyclically Adjusted PE (S&P 500 CAPE).  Last month’s update can be found here.

Before we look at the CAPE let us first look at other key S&P 500 metrics:
-    The S&P 500 Price is currently 1,341 which is 1.3% above last month’s Price of 1,328.
-    The S&P 500 Dividend Yield is currently 2.11%.
-    The S&P As Reported Earnings (using a combination of actual and estimated earnings) are currently $93.25.
-    The S&P 500 P/E Ratio is currently 14.4 which is up slightly from last month’s 14.3.

The S&P 500 Cyclically Adjusted PE (aka S&P 500 or Shiller PE10 or CAPE) – June 2012 Update

The S&P 500 closed on Friday at 1,335.  By my calculations I also have as Reported Earnings (using a combination of actual and estimated earnings) at $92.33.  Combining these two pieces of data gives us an S&P 500 P/E Ratio of 14.5. 

While interesting, for my own investment purposes, I do not use the P/E ratio.  Instead I use what I have called the Shiller PE10 which is shown in my first chart (effectively an S&P 500 cyclically adjusted PE or CAPE for short).  This method is used and was made famous by Professor Robert Shiller.  It is simply the ratio of Real (ie after inflation) S&P 500 Monthly Prices to 10 Year Real (ie after inflation) Average Earnings.

The ASX 200 Cyclically Adjusted PE (aka ASX 200 PE10 or ASX200 CAPE) – June 2012 Update

The ASX 200 closed on Friday priced at 4,063 which is a 12% fall from 1 year ago.  At this price I have earnings (which are 12-month trailing underlying profits) at 337 which results in a price earnings ratio (P/E Ratio) of 12.1.  In comparison I have calculated the S&P 500 P/E Ratio at 14.3 and the FTSE 100 P/E Ratio at 9.4 this month.

The history of the ASX 200 P/E Ratio since 1993 can be seen in my first chart today along with the Ratio I am personally far more interested in which is the ASX 200 PE10 (effectively  an ASX 200 cyclically adjusted PE or ASX 200 CAPE for short).  The method is based on that made famous by Professor Robert Shiller and in this instance it is simply the ratio of Inflation Adjusted Monthly ASX 200 Monthly Prices to Inflation Adjusted Average Earnings.  Today the ASX 200 PE10 sits at 13.9.  A full summary of relevant ASX 200 PE10 data follows:

• ASX 200 PE10 = 13.9
• Dataset Average PE10 = 22.1.  If this average was “fair value” then it indicates that today the ASX200 is 37% undervalued.  I’m not convinced of this though and think it is a result of a relatively short dataset but I’ll talk more of that later in this post.
• Dataset Median PE10 = also at 22.1
• Dataset 20th Percentile = 16.9
• Dataset 80th Percentile = 27.5

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

It’s been a year almost to the day since I last posted data on the FTSE 100 Cyclically Adjusted PE ratio.  It’s therefore worth taking a little more time on this post to spell out how exactly I’m calculating this metric.  To my knowledge I am the only person on the internet who is freely making this data available however I have had to make some assumptions to build this dataset.

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.

The S&P 500 Cyclically Adjusted PE (aka S&P 500 or Shiller PE10 or CAPE) – May 2012 Update

As I write this post the S&P 500 is priced at 1,310.  By my calculations I have current earnings at $91.4 for an S&P 500 P/E Ratio of 14.3.  The earnings I use are as Reported Earnings, as opposed to the much more ambitious Operating Earnings, as I believe these are a much more appropriate (and conservative) measure.  As a quick reminder Reported Earnings will typically always be lower than Operating Earnings as they include the cost of non-recurring items such litigation charges, costs of shutting a factory and good will write downs to name but three.  Now it’s only my humble opinion, but I believe these are real and true costs incurred by the business, even if they are non-recurring and so badly want to be excluded by the “Company Bean Counters”. 

Let me also be clear on how I calculate the Reported Earnings.  I am using the Earnings as published by Standard and Poors.  At the time of writing they have published:

• Actuals for quarter end 30 June 2011, 30 September 2011 and 31 December 2011;
• A hybrid of 98.7% actual with the remaining as estimates for quarter end 31 March 2012; and
• An estimate for quarter end 30 June 2012

I then extrapolate these figures to cover a year to the end of May 2012.

The FTSE 100 cyclically adjusted PE ratio (FTSE 100 CAPE or PE10) – June 2011

While we all sit back and watch the train wreck that is Greece prepare to default (or whatever posh name they will come up with in due course) the UK goes on happily borrowing money at the rate of £17.4 billion for the month.  That’s £17,400,000,000 in a month.  What’s concerning me is that servicing our debt now takes 8.5% of government spending.  That’s more than the complete tax take from corporation tax (page 6 here).  All I can say is that the future generations will not be pleased.  I’m just a simple Average Joe but it really just doesn’t seem right asking children who are not yet born to pay for our lifestyle today.    

As this all unfolds we’ve seen stock markets around the world decrease in price in recent times.  I actually have no idea what moves prices (that’s why I don’t trade) but I can’t help feel that Greece is having a good impact but also we shouldn’t forget good news like this from China.

Is the Australian stock market cheap? - ASX 200 cyclically adjusted PE ratio (ASX 200 CAPE or ASX200 PE10) – June 2011 Update

As shown in my first chart the ASX200 cyclically adjusted PE (ASX200 PE10 or CAPE) has been steadily declining since February.  Today with the ASX200 closing at a price of 4567 the PE10 is 15.8 compared to the long run average since 1993 of 22.4.  A quick look at these two values would suggest that the ASX200 is undervalued however I’m not so sure.  The problem for me is that the data set that I have is a short period of time.  Comparing the ASX200 to the S&P500 where I have S&P500 PE10 data going back to 1881 allows for a very crude extrapolation though.  The long run average S&P500 PE10 is 16.4 however the average PE10 for the same period as my ASX200 dataset is 26.9.  Extrapolating this to a long run average ASX200 PE10 reveals (22.4/26.9)x16.4=13.7 which would imply that the ASX200 is in fact not undervalued but overvalued to the tune of about 15%.  To put this value in to perspective the PE10 low during the Global Financial Crisis (GFC) was 13.8 in February of 2009. 

The S&P 500 cyclically adjusted PE (S&P500 PE10 or S&P500 CAPE) – May 2011 Update

Today I update the last May 2011 period cyclically adjusted PE ratio that I track – the S&P500 CAPE.   As I say every time I post on this index I am using this ratio to try and squeeze some extra performance out of my portfolio.  This method is used by Professor Robert Shiller however I modify it slightly by incorporating forecast earnings up to the month of interest. For new readers some background information on the CAPE is available here and if you’d like some information on why I use the CAPE then that is available here.

The ASX 200 cyclically adjusted PE ratio (ASX 200 CAPE or ASX200 PE10) – May 2011 Update

Since simultaneously getting back into the blogging world and sorting my Retirement Investing Today strategy I have already looked at the valuation of the UK Equities market (proxy FTSE100 CAPE) where I personally hold 16.8% of my net worth.  Today it’s time to value the Australian Equities market (proxy ASX200 CAPE) where I currently hold 18.9% of my net worth.