Citywire printed articles sponsored by:
View the article online at http://citywire.co.uk/money/article/a553608
Smart Investor: how I filter out dud investments
A simple filter system can help you find the highest quality and most attractively priced companies.
Markets
Over the years, I have met a fairly large number of private investors and, whenever we have discussed the topic of analysing companies, a question keeps coming up. The question is: how is it possible to monitor and analyse all companies in the FTSE 350 so as to find the highest quality and most attractively priced companies?
Often, the person asking the question feels that the markets are not efficient and that markets overreact to both positive and negative news flow. Furthermore, they have a reasonable amount of time in which to seek out said companies but struggle to pick out the relatively small number which merit investment.
Panning for investment gold
Of course, there is no perfect means of achieving the above, but a method I have used is incredibly simple and (I find) very effective. It involves using a filter system of various ratios to reduce the number of potential companies to invest in from 300+ to around 30.
Perhaps the most important decision you need to make is how big you want your filter system to be. You may wish to keep a large number of companies in the ‘possible’ pool, in which case you should select only a small number of ratios to whittle down the number of companies. On the other hand (and particularly when stock markets are low) you can afford to be a little tougher and require companies to pass a larger number of ratios. In addition, you may allow a pass rate of, say, 8 out of 10 ratios – meaning if 8 of the 10 ratios are passed then the company will be considered in more detail.
Pick your ratios
The ratios are, of course, subjective but I would suggest that you focus on: the past performance of the company, its present financial soundness, its viability in terms of having an economic moat and economic goodwill, as well as whether or not the shares offer good value. Within each of these areas there exist a vast number of ratios, so time spent deciding which ones to use will be time well spent: there is little point in checking ratios which are either of little use or that you do not understand.
On this point of understanding, the internet has made ratio analysis available to all so if you do get stuck, there will definitely be a website which will inform you as to what a particular ratio is, how to calculate it and what it measures. Indeed, with many ratios there are a number of different variations. For example, the interest coverage ratio can use net finance cost or just finance cost – both are fine but consistency is crucial if you are to compare like for like.
As for the ratios I use, regular readers will probably have a good idea of what I look for and taking a look at past articles (click here) will give you a feel for the ratios I use. In future articles I will go into more detail as to why I use the ones I do and how they interconnect and relate to each other.
Of course, things such as economic moats are subjective and would come after the initial ‘screening’. You may find first filtering out expensive companies is easiest or that companies which have performed poorly in the past (the company, not the share price) are the ones you want to exclude first.
It's all out there
Indeed, all of the figures you need are available in the annual report which is free and can be found on the company website. Various third party websites offer figures from the accounts, which are fine as long as they are correct. From my own experience, I find a simple spreadsheet is the easiest way to log all of the figures, with the ratios being added as formulas so that you do not have to manually perform any calculations.
The above may sound daunting and time consuming. However, I have built up my spreadsheet over many years using annual data only. It does take some effort to get all the figures on there and it may be an idea to just focus on the FTSE 100 for now.
However, even if you just check a few ratios such as company debt, interest coverage, return on equity and price to earnings then it is a start. You will probably be surprised at how many companies fail to pass quite reasonable limits on all of those four.
Indeed, if you can rely on facts such as those found in ratios rather than feelings and emotions, then you will find investing to be far less complicated, less emotional and (I hope) far more profitable in the long run.
Tools from Citywire Money
More about this:
More from us
- Smart Investor: the power of 'economic moats'
- Smart Investor: goodwill and the basics of share valuation
- Smart Investor: how to spot debt danger signs
- Smart Investor: how to analyse investment targets
- Citywire: Smart Investor
Archive
Today's articles
- Market blog: FTSE gains momentum to break 5,400
- Homeserve under investigation by City regulator
- Snap! Greece goes and we’re awash with ‘worthless paper’
- UK inflation drops sharply to 3%
- LTRO is biggest 'cash for trash' scheme in the world
- The Expert View: Marks & Spencer, Man Group and WH Smith
- Thirst for income is distorting investment trust prices, says Urquhart
- Citywire Top Stocks Daily News Digest





9 comments so far. Why not have your say?
Zaydac
Jan 03, 2012 at 08:29
@Smart Investor - at last, someone else who suspects that sometimes the financial data provided for free on the internet is not always correct!
@All - The thing I would most like would be charts of the key ratios, particularly P/E, over various time spans, preferably 1, 3, 5, & 10 years. Some companies experience (and deserve) fairly high ratios most of the time because of their performance - these are usually worth buying if you can get in at the right time. Having a chart of the key ratios would help to time entry and exit. Does anyone produce such charts?
report thisMartin
Jan 03, 2012 at 08:35
Unless you also use ratios based on at least two years forecasts, this system can go horribly wrong, especially for cyclicals.
report thisLong Term Investor
Jan 03, 2012 at 13:21
I have been trying to adopt a screening system based on ratios, but am constantly undermined by the lack of clarity in the historic company accounts. GEC nailed me in the 1990's and the banks in the 2000's, in addition to the inconsistency in the calculation of ratios. Is it the Accounting profession or the Directors?
report thisZaydac
Jan 04, 2012 at 10:01
@Long Term Investor - I'm with you there. How many people could have spotted the catastrophe at Marconi just by reading the accounts or plotting ratios? However I don't think the difficulties invalidate the method, they just emphasise the need to (1) not keep all your eggs in one basket, and (2) have trailing stops on everything, even your star picks
report thisJohn @ UKValueInvestor.com
Jan 04, 2012 at 10:16
Zaydac, ShareScope has charts of profit, eps, dividends, yield, turnover, PEG, P/E, and more for each stock.
As for data accuracy, it's probably always best to read the annual reports once you've honed in on something anyway and get the data straight from the horse's mouth.
report thisSteve Hayes
Jan 04, 2012 at 15:34
@zaydac what broker do you use who has a good trailing stop system?
report thisZaydac
Jan 04, 2012 at 20:43
@Steve Hayes - I haven't got automated stops at the moment, my active portfolio has only a small number of shares and take I decisions manually. I'm not convinced that automated stops really work because if a price gaps down you might be selling at the worst moment and would do better to hang on a bit. Even when BP was falling like a stone there were lots of rebounds on the way down. But when I am going away somewhere that puts me out of touch I do sometimes sell things because I can't leave an automated stop in place. What I meant in my post was that I don't believe in holding on to anything for ever. If an investment has had a good run and then starts to look as though it has peaked I believe in selling and moving on to the next idea. When I buy anything I always set a stop loss in case I am early or just plain wrong, and If I am right and the investment increases in price I ratchet the stop upwards.
report thisHotrod
Jan 08, 2012 at 13:02
Ratios, figures, numbers, digits. Theoretical values, all calculated, estimated, and assumed to be accurate.
Unfortunately I am as cynical as Victor Meldrew when it comes to accounts for the following reasons.
When I was working I gained first hand knowledge of just how unreliable accounts can be:
e.g. A supervisor instructed a team of temporary staff to help with the monthly stockcheck. After about an hour he walked round to see how they were getting on. He became suspicious when he looked in a box full of hundreds of items, which had been entered on the stocklist as only containing seventeen.
When asked to explain why he had recorded only seventeen items when any reasonable person could see at a glance that there were in fact many more, the operator replied. "You asked me to count the number of items in the boxes". "You didn't ask me if I could count" !!
Also: I have been reading about a statistical study which was conducted recently concerning the rounding up of numbers as entered in accounts.
The study found that a significant number of accounts contained a paucity of the digit four, in the context of: .4, .04, .004 etc.
The findings concluded that the reason for the shortage was that all point fours had been entered as point five, which could in turn be rounded up to the next whole number.
When dealing with millions or even billions of pounds this seemingly unimportant surd can make an enormous difference to how a companies financial performance is percieved, especially when considering values expressed in pence per share.
I accept that many Plcs do their best to produce accurate reports, but, as the collapse of the banking sector has clearly demonstrated, corporate governance is still sadly lacking in some of them.
As a footnote; some of my best investments have come from conducting my own, grass roots research, before I even looked at a balance sheet.
report thisRob Walker
Jan 08, 2012 at 14:52
I'm not disagreeing about the value of ratios from an historic standpoint, but if you want to identify a company that is 'turning a corner' etc then one should look for evidence on the ground. When it is difficult to find a space in the company's car park, asking the manager of the local Majestic Wine warehouse how the change from 12 bottles minimum to six has affected sales, looking through the recruitment pages, asking your kids why they all shop online at ASOS you get a feel for the companies who are changing for the better. What is more the reasons for change make sense to you so you have more confidence in your own hunches, far better than advice from those behind desks with their calculators! Keeping ahead of the game is far more profitable than just keeping up with it.
report thisleave a comment
Please sign in here or register here to comment. It is free to register and only takes a minute or two.