Every quarter I take a look at the biggest FTSE 100 companies in each of the index’s 10 industries to see how they shape up as a potential starter portfolio. I’ve been saying for a while I think there’s good value in most of these titans. This quarter is no different, and I’ll explain why shortly.
First, the table below shows the companies’ individual valuations based on forecast 12-month price-to-earnings (P/E) ratios and dividend yields.
| Â | Industry | Share price (p) | P/E | Yield (%) |
| BAE Systems | Industrials | 545 | 11.3 | 4.4 |
| British American Tobacco | Consumer Goods | 2,897 | 8.4 | 7.7 |
| GlaxoSmithKline | Health Care | 1,670 | 14.3 | 4.8 |
| HSBC | Financials | 603 | 10.3 | 6.9 |
| National Grid | Utilities | 864 | 14.3 | 5.7 |
| Rio Tinto | Basic Materials | 4,006 | 8.3 | 7.8 |
| Royal Dutch Shell | Oil & Gas | 2,300 | 10.2 | 6.7 |
| Sage (LSE: SGE) | Technology | 662 | 20.8 | 2.7 |
| Tesco | Consumer Services | 240 | 13.8 | 3.5 |
| Vodafone | Telecommunications | 156 | 18.1 | 5.2 |
The average P/E of the group is 13 and the average dividend yield is 5.5%. As you can see from the table below — which puts the current group rating into a historical context of the last four quarters and eight years — the P/E and yield have been within a fairly narrow range since this time last year, apart from a material dip into cheaper territory in my January review.
| Â | P/E | Yield (%) |
| October 2019 | 13.0 | 5.5 |
| July 2019 | 13.3 | 5.4 |
| April 2019 | 13.3 | 5.5 |
| January 2019 | 12.3 | 5.9 |
| October 2018 | 13.3 | 5.3 |
| October 2017 | 16.5 | 4.5 |
| October 2016 | 17.3 | 4.0 |
| October 2015 | 13.7 | 5.6 |
| October 2014 | 13.1 | 4.6 |
| October 2013 | 12.1 | 4.7 |
| October 2012 | 11.1 | 4.7 |
| October 2011 | 9.8 | 5.0 |
My rule of thumb for the group is that an average P/E below 10 is bargain territory, 10 to 14 is good value, and above 14 starts to move towards expensive. At 13, we’re in my good value band.
If I were looking to set up an instant starter portfolio today, I’d happily buy these industry heavyweights — with the exception of one. Let me explain the exception, before commenting on the other nine.
Unwise
I’ve been concerned for some time that the market has been overvaluing accountancy software firm Sage. I think there’s been overestimation of the ‘stickiness’ of its customers and ability to attract new ones at premium prices, and underestimation of the keen pricing and allure of the offerings of competitors.
In short, I believe the company has been valued for higher revenue growth, profit margins and return on equity than it’s likely to deliver.
At the time of my last quarterly review, the shares were trading at 802p and the P/E was 25.5. The shares are now 17.5% lower at 662p and the P/E has come down to 20.8. The reason for this is a profit warning in July in which management said revenue growth in the first nine months of its financial year had disappointed, and that profit margins would be at the lower end of its previous guidance.
In my view, fair value for Sage is a sub-20 P/E. It’s getting closer, but isn’t there yet, so I’m content to avoid this stock for the time being.
Nifty nine
With the exception of Vodafone on an elevated P/E of 18.1, all the other stocks are trading on multiples between 8.3 and 14.3. The two trading on 14.3 are stocks in defensive sectors — GlaxoSmithKline and National Grid — which I think merit a somewhat higher P/E than average.
Vodafone’s shares are up 21% since I highlighted the value I reckoned they offered in my last quarterly review. Despite the rise and the now-high-teens P/E, I still see decent value, due to the company’s demerger plans for its towers network and longer-term earnings outlook. As such, I’d be happy to buy it today alongside the other heavyweights, while continuing to hold off on Sage.