How to use a Stock Screener

Published: March 4, 2016 at 1:01 am

Here is a step by step guide on how to use a stock screener and identify financially sound and good businesses.  This is a guest post by Indraneal Balasubramanian, a passionate equity enthusiast who blogs at cognicraftingIndraneal 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 investing 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).

How to use a Stock Screener: Overview

guide-to-stock-screener-1
Figure 1: Thinking about what to look for

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.

How to use a Stock Screener: Hygiene Factors

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

1 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.

  1. 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

  1. 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.

  1. 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%.

2 Business Performance

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.

Valuations

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.

  1. 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.

guide-to-stock-screener-2

 

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.

3 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.

Figure 2: A sample screener.in dashboard that can give you a snapshot of a company.
Figure 2: A sample screener.in dashboard that can give you a snapshot of a company.

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)

Writing a sample screen. Click to enlarge
Writing a sample screen. Click to enlarge

If you need help on how to define the variables, click the “Show all variables button on the bottom” right.

guide-to-stock-screener-5
Figure 4: Results of the Screen

Summary

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.

Download the  Freefincal Excel Stock Screener

~~~~~~~~~~~~~~~~~

Do join me in thanking Indraneal for a comprehensive guide to use 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!

Do share if you found this useful
Share your thoughts on this topic at the  Reddit freefincal_user_forum

Reach your financial goals like a pro! Join our 1600+ Facebook Group on Portfolio Management! You can now reduce fear, doubt and uncertainty while investing for your financial goals! Sign up for our lectures on goal-based portfolio management and join our exclusive Facebook Community. The 1st lecture is free!
Want to check if the market is overvalued or undervalued? Use our market valuation tool (will work with any index!) or you buy the new Tactical Buy/Sell timing tool!
About the Author Pattabiraman editor freefincalM. Pattabiraman(PhD) is the founder, managing editor and primary author of freefincal. He is an associate professor at the Indian Institute of Technology, Madras. since Aug 2006. Connect with him via Twitter or Linkedin Pattabiraman has co-authored two print-books, You can be rich too with goal-based investing (CNBC TV18) and Gamechanger and seven other free e-books on various topics of money management. He is a patron and co-founder of “Fee-only India” an organisation to promote unbiased, commission-free investment advice. He conducts free money management sessions for corporates and associations on the basis of money management. Previous engagements include World Bank, RBI, BHEL, Asian Paints, Cognizant, Madras Atomic Power Station, Honeywell, Tamil Nadu Investors Association. For speaking engagements write to pattu [at] freefincal [dot] com
About freefincal & its content policy Freefincal is a News Media Organization dedicated to providing original analysis, reports, reviews and insights on developments in mutual funds, stocks, investing, retirement and personal finance. We do so without conflict of interest and bias. Follow us on Google News Freefincal serves more than one million readers a year (2.5 million page views) with articles based only on factual information and detailed analysis by its authors. All statements made will be verified from credible and knowledgeable sources before publication. Freefincal does not publish any kind of paid articles, promotions or PR, satire or opinions without data. All opinions presented will only be inferences backed by verifiable, reproducible evidence/data. Contact information: letters {at} freefincal {dot} com (sponsored posts or paid collaborations will not be entertained)
Connect with us on social media
Our publications

You Can Be Rich Too with Goal-Based Investing

You can be rich too with goal based investingPublished by CNBC TV18, this book is meant to help you ask the right questions, seek the right answers and since it comes with nine online calculators, you can also create custom solutions for your lifestyle! Get it now. It is also available in Kindle format.
Gamechanger: Forget Startups, Join Corporate & Still Live the Rich Life You Want Gamechanger: Forget Start-ups, Join Corporate and Still Live the Rich Life you wantThis book is meant for young earners to get their basics right from day one! It will also help you travel to exotic places at low cost! Get it or gift it to a young earner

Your Ultimate Guide to Travel

Travel-Training-Kit-Cover-new This is a deep dive analysis into vacation planning, finding cheap flights, budget accommodation, what to do when travelling, how travelling slowly is better financially and psychologically with links to the web pages and hand-holding at every step. Get the pdf for Rs 199 (instant download)
Free android apps