A FTSE 100 Value Trawl

Published in Company Comment on 2 September 2010

Stephen Bland trawls the blue chip index for value shares.

I haven't done this for a few months, so I'm going to repeat the FTSE 100 value analysis system I devised many years ago and run occasionally here. 

The idea is to locate big cap value from a purely mechanical survey of the index which readers may find useful as a starting point for further investigation. I stress the latter point, readers should not invest on the basis alone of any findings here as the results are intended more to be a pointer to something potentially interesting lurking amongst these shares so further research would be required if you spot something you like. Not too much further research though, you don't want to overanalyse.

Three ratios

What I do is to consider three popular ratios, yield, P/E and P/B, selecting the top ten of each in value terms from the index. 

The idea is to look for multiple appearances in the tables and any share scoring three may be an attractive value candidate with a score two possibly worth a look as well, maybe some of the single appearances too. 

Note that I have drawn the selections from Digital Look with little checking on the veracity of the figures though I have amended some of the information where I was aware of inaccuracies. It must be borne in mind that databases like this do contain errors and that is another reason to look behind my results here if you like a share.

Note that the yields and P/Es are forecasts whilst the P/Bs are last full year actual. Book in the P/B calculation refers to net assets, not net tangible assets, because that is the way the database I used is shown. 

Value players though may be more interested in net tangibles, which is something they will have to work out themselves.

Top ten yields

 Price
(p)
Forecast
Yield
(%)
Man Group (LSE: EMG)2197.3
RSA (LSE: RSA)1267.1
Aviva (LSE: AV)3956.9
Home Retail (LSE: HOME)2236.8
Cable & Wireless Worldwide (LSE: CW)706.7
Scottish & Southern Energy (LSE:SSE)1,1496.5
Shell (LSE: RDSB)1,7176.6
National Grid (LSE: NG)5436.4
Standard Life (LSE: SL)2126.3
BritishLand (LSE: BLND)4675.8

 

Ten lowest P/E

 Price
(p)
Forecast
P/E
BP (LSE: BP)3895.4
Aviva3956.1
BAE (LSE: BA)3116.8
Legal & General (LSE: LGEN)957.4
BT (LSE: BT-A)1387.6
AstraZeneca (LSE: AZN)3,2758.0
TUI (LSE: TT)2188.2
Old Mutual (LSE: OML)1358.2
Barclays (LSE: BARC)3168.5
Investec (LSE: INVP)4948.6

 

Ten lowest Price to Book

 Price
(p)
P/B
Royal Bank of Scotland (LSE: RBS)460.28
Schroders (LSE: SDRC)1,1240.41
Barclays3160.65
Home Retail (LSE: HOME)2230.65
Royal Dutch Shell (LSE: RDSB)1,7170.68
Old Mutual1350.70
Vedanta (LSE: VED)1,9930.70
Aviva3950.72
SEGRO (LSE: SGRO)2750.78
Investec4940.80

That's the raw data but what is it saying?

Aviva again

First thing is to look for triple appearances and this throws up just one, a repeated pick of mine in the value portfolio I run here, life and general insurer Aviva.

When I last did this exercise in May, the same share dropped out as the sole triple scorer. The big difference is that Aviva was then 312p and now it's 395p, a rise of 27%. I think that says something about the validity of this little mechanical jobbie of mine. Despite that decent rise though, plus the fat yield on this share adding to returns, the very interesting fact is that it remains as the sole triple.

That might not have been the expected result given the rise to date, but it happened because the share was monstrously undervalued at the earlier price and now it is merely grossly undervalued. There is a lot more to come from Aviva I'm convinced before its value is played out.

Financials and oil

Insurers actually occupy quite a few positions in these tables with Old Mutual in two and others putting in various single showings. 

In fact financials of various types actually occupy a large proportion of all places with Barclays managing the double amongst banks and Royal Bank of Scotland top of the P/B listing. Continuing the financial theme, fund manager Investec scores twice.

BP unsurprisingly appears as the lowest P/E, but Royal Dutch Shell does a double making it look quite attractive right now, possibly because it has been bargepoled by many investors frightened by what happened to BP as this could just as easily happen to Shell. But how likely is that? Not very in my view.

Retail and property

An oddity amongst doubles, or in appearing here at all really, is Home Retail. This is the Homebase DIY and Argos catalogue shops business.

The share caught my eye a while back and at that time I seem to recall it even had that value player's wet dream, net cash. I almost reached for my wallet but in the event sheer funk prevailed because it didn't quite smell right somehow. I am very wary of specialist retailers because so many fail but they are not all rubbish and some do prosper.

Normally I would expect a few property shares in the P/B table because these traditionally trade below book but there's only SEGRO this time. 

Oddly though perhaps, British Land appears though not on P/B but on yield. It's packing a pretty high yield for a major property share, and looks quite good to me for that reason, though for others it may depend upon your view of the progress of the recovery.

What would be my personal candidates for further investigation as possible value plays here? Well, I've already mentioned Aviva, which I hold, and British Land and Shell look too cheap. As an outsider for the extremely patient, though with the downside for a value investor of no yield for the time being, RBS sooner or later will deliver, and may do so in majestic fashion. Just don't hold your breath.

More from Stephen Bland:

> Of the shares shown, Stephen holds Aviva, BAE, BP, BT, National Grid and Scottish & Southern.

> If you're in the market for buying shares, consider opening an online broker account with The Motley Fool's Share Dealing Service. You can buy and sell shares in real time for a flat rate of just £10. Click here to open an account for free today.

Share & subscribe

Comments

The opinions expressed here are those of the individual writers and are not representative of The Motley Fool. If you spot any comments that are unsuitable hit the flag to alert our moderators.

SanMiguel101 02 Sep 2010 , 2:33pm

With all the outflows from mutual funds, are people really going to be picking up value shares in the present market?
Especially with all the US trouble.
I feel momentum investing may be a better bet in the current market and holding stocks for temporary periods.
Longer term investing value will come from China.

seriousmoneyFool 02 Sep 2010 , 3:31pm

Now is exactly the right time to be buying value shares.
Even if you have to wait longer for a recovery than expected, reinvesting those high dividends payments will only enhance your returns in the long term.

Luniversal 03 Sep 2010 , 12:08pm

Fellow Fool Todd Wenning has put forward some reasons to be wary of Shell's yield:

http://www.fool.co.uk/news/investing/company-comment/2010/09/01/dividend-report-card-royal-dutch-shell.aspx

geddinquick 05 Sep 2010 , 12:54pm

Personally, Shell is my favourite from the list - closely followed by Aviva (i.e. at the latest much-increased price of the latter). According to brokers' forecasts from Hemscott, Shell should have made the P/E list in sixth place with a figure of 7.96 (though this is of course - a forward figure). As for Todd Wenning's article - nthis is really more about whether Shell will up the divi - but around the 112p mark, they don't really need to!

Join the conversation

Please take note - some tags have changed.

Line breaks are converted automatically.

You may use the following tags in your post: [b]bolded text[/b], [i]italicised text[/i]. All other tags will be removed from your post.

If you want to add a link, please ensure you type it as http://www.fool.co.uk as opposed to www.fool.co.uk.

Hello stranger

To add your own comment, please login.

Not yet registered? Register now.