Here is a step by step guide to build a stock screener and identify financially sound and good business. This is a guest post by Indraneal Balasubramanian, a passionate equity enthusiast who blogs at cognicrafting. Indraneal needs no introduction to Facebook group Asan Ideas for Wealth regulars.
The following can be thought as a sequel to Krishna Kishore's guest post explaining the features of screener.in
and as a guide to the Freefincal Excel Stock Screener
Information is a double-edged sword when it comes to investment in stocks. Investors are constantly bombarded with information about stock prices, macroeconomic data, news, which in turn could lead to suboptimal decision-making because people are more worried about the scoreboard than the field of play, which is the characteristics and performance of the business.
However, on the flipside, the internet and technology have also made it a lot easier to screen stocks and get historical as well as current information on the businesses they represent. Since when you buy the stock of a company, you are in fact buying a claim on current and all future earnings of the business, so long as you hold the shares of that company.
In order to construct a stock screen, the first step would be to think about what some basic characteristics of a financially sound, good business are. I created a mind map to help me think about this (click to enlarge).
This is not a comprehensive list by any means, but I think it is a decent place to start. I’ve categorized what I want to look for into 4 basic categories – Hygiene factors in Financials, Business Performance, Efficient use of capital and Reasonable valuation.
Charlie Munger has often said, “Tell me where I'm going to die, that is, so I don't go there”. Hygiene factors are aspects of the financials that are red flags and should be used to weed out potential sources of trouble.
Low Debt: Companies get into trouble when they take on leverage due to high interest expenses which have to be paid out before the bottom line. In crunch times, debt holders will still expect to be paid which means less money flows to the bottom line.
- Debt to Equity Ratio: It indicates the capital structure of the company and is typically calculated using – Total Liabilities / Shareholder Equity. Less than 1 is ideal, though I like to take a value lower than 0.5 for safety’s sake.
- Interest Coverage Ratio: Indicates the ability of the company to service its interest commitments on debt. Calculated as EBIT / Interest Expenses, and the higher the better. Look for minimum of 5-10.
Low Shareholder Pledging: Promoters can pledge their shareholding as collateral in order to secure financing. Typically a cover in terms of the share value to loan value is maintained, with a clause that if the value falls below a threshold, the promoter will have to pledge more shares to maintain the minimum cover. If the promoters are unable to unable to do so or fail to service the debt, they will need to sell pledged shares to pay off the debt. This could leave to severe corrections in the share price and hurt minority shareholders.
Overall Financial Risk
Altman Z score: It is a sort of credit strength test to measure the likelihood of bankruptcy. Look for a value above 3.
Piotroski score: A 9 point score based on 9 fundamental components. Use low scores to weed out companies. I typically look for a score of atleast 4 or better
Efficient use of Capital
The company’s management are not only there to operate the business, but are capital stewards who are supposed to use capital judiciously to enhance value. There are a lot of ways to check this, but these are the most common. Emphasis on rising or at least consistent values over 5 to 10 year periods.
- Return on Equity = Net Income / Average Shareholder Equity
In order to really understand the components of Return on Equity calculation, you should look at the DuPont model. I wrote about this in a Quora answer a while back
- Return on Capital Employed = EBIT / Total Capital Employed.
This is a way to determine how effectively the firm is using its capital to create value. There is some ambiguity about this because the definition of capital employed and hence the denominator may vary in certain calculations. Screener.in defines Capital Employed as Fixed Assets + Working Capital, which I think is a fair way to go about it. Total Assets – Current Liabilities is also used.
- Dividend Payout Ratio = Dividend per share / Earnings per share.
All things considered, I like firms paying dividends. Not only is the presence of a consistent dividend an indication that profits are real and not merely accounting gimmickry, but also a sign that the management is willing to payout cash that cannot be effectively used to grow the business rather than hoard it or use it in a less than efficient manner. I consider a minimum of 15%.
As far as businesses go, boring is better for investors. Warren Buffet’s wit is on offer in his 2001 Berkshire Hathway Shareholder letter as he quips – “I will tell you now that we have embraced the 21st century by entering such cutting-edge industries as brick, carpet, insulation and paint. Try to control your excitement”
Stable businesses in industries that don’t change a lot are less vulnerable to newcomers challenging their position or a shift in the inherent nature of the business. For example, I don’t know what a technology company might look like 10 or 20 years from now, but I can feel fairly sure the odds of a biscuit or toothpaste company not changing much are pretty good.
- Margins: If margins are coming under pressure, it could indicate either higher input costs, increased competitiveness, while high, stable or rising margins relative to industry players could indicate competitive advantage.
- Sales, Profits and Cashflows. Again, look for consistency and trends emerging over 3, 5 and 10 year periods.
The form of valuation that I covered in the mind map is known as relative valuation, because it makes business parameters comparable through a form of standardization. There are dozens of ratios, but some of the commonly used ones are –
- Price to Earnings: Typically, this is calculated as the Current Market Price / Trailing Twelve Month Earnings per Share (Add up last 4 quarterly EPS). It is often an expression of investor sentiment, as it reflects how much an investor is willing to pay for each rupee of earnings. Stable, well known businesses will command higher multiples as the market feels they are more predictable, which is why you will often see FMCG companies trading at higher P/E multiples to the rest.
A company with a high P/E is not necessarily expensive, contrary to common belief. Professor Sanjay Bakshi explained this beautifully in this article.
Warning: Cyclical stocks can look cheap on a P/E basis after a few growth years. Do not be fooled!
- PEG Ratio: First used by Peter Lynch, this is P/E Ratio divided by Annual EPS growth. Most screeners will use EPS growth last year, but I recommend calculating EPS growth over 5 and 10 year periods to determine whether the business is undervalued relative to its long term earnings growth.
- Price to Free Cash flow. Arguably a better metric than P/E, because all things being equal, a firm with higher Free Cash Flows (Operating Cash flow – Capital Expenditure) is superior.
- Price to Book Value: Current Market Price / Book value per Share
This is typically used to value banks and capital intensive industries. I would check the value relative to the industry to determine potential overvaluation and undervaluation. Firms that employ lower amounts of fixed assets like consumer companies and software companies will typically show much higher average P/BV than others.
- Dividend Yield: People neglect dividend yield thinking that since they are only receiving say 1-2% of their invested amount as dividend, it should be neglected. However, over long periods of time, dividends can not only reduce the cost basis of shares to a negligible amount, if reinvested they can produce mind-boggling differences in results.
Warning: Don’t be seduced by overly high dividend yields (often seen in commodity stocks). If share prices fall rapidly, it can push up dividend yields to unsustainable levels. Dividend yield should be looked at in conjunction with stable earnings growth and dividend payout ratios.
Putting it all Together in a Screener.
Now that we know what to look for, we can use a screening tool to help us identify stocks that meet criteria. I like using Screener.in because I find its interface very intuitive and versatile in customization options. Not only does it give you the option of writing your own custom screens, but there are also many user created screens for you to play around with.
If you like what you see, you can export the financials to excel (top right blue button) for further analysis, or add the stock to a watch list (green button)
If you need help on how to define the variables, click the “Show all variables button on the bottom” right.
After generating a screen and look at the financials, I typically look at downloading and reading the last 5 years Annual Reports to get more detailed information on the business. Key things to note are disclosures to financial statements as well as management commentary on strategy and future growth. Look for honesty above all else, I would rather that the management recognizes challenges and has a roadmap rather than present a uniformly rosy picture.
I hope this article gives you a basic idea on how to go about generating stock ideas through a screener. You do not have to rigidly follow the values I have taken either as there are many more permutations and combinations to what I have discussed, and I highly encourage you to experiment with the tool as well as the metrics involved.
Do join me in thanking Indraneal for a comprehensive guide to build a stock screener. Now that you know how to get a short-list of sound business, check out this automated stock analyzer to finalize your picks!
Get GameChanger (my second book) + Pranav's Travel Training Kit GameChanger (hardcopy is now available for ₹279 (249 +30 for shipping) and the Travel Training Kit is available for immediate download for ₹150.
Get free, yet comprehensive calculators, tools and analysis delivered to your mailbox! Subscribe to get posts via email
Buy our New Book!You Can Be Rich With Goal-based Investing A book by P V Subramanyam (subramoney.com) & M Pattabiraman. Read more about the book and pre-order now!