Razik's screener
Medium to big size companies having consistent growth in sales, profit and returns and with less debt.--------------------------------------------------------------------------------------------------------------------------------------------- Approximately only around 200 to 300 companies will satisfy all the criteria among the 5000 listed companies in India.------------------------------------------------------------------------------------------------------------------ Parameters set and reasons for the same:---------------------------------------------------------------------------------------------- 1. Market Cap > 1000: Eliminates all the micro cap companies which are too risky to invest without understanding the Company 100% and a normal retail investor cannot get the complete picture from publicly available information.------------------------------------------------------------------------------------------------------------- 2. Sales > 500: The Company is too small to be considered a good potential and need to cross at least the 500 crore turnover mark to be looked into.--------------------------------------------------------------------------------------------- 3. Profit > 10: Companies making a loss are a big risk, turnaround cannot be guaranteed by anyone unless there is a suitable long term business plan and it is too early and unworthy risk to invest in such companies.------------------------------------------------------------------------------------------------------------------------------------------ 4. Debt to equity < 1: In simple words, debt means trouble and debt more than equity is a complete no-go. Companies with no debt or less debt are always a safer bet and these companies always have a better track record in performance due to the higher cash flow to reinvest in the business compared to the debt and interest paying companies.----------------------------------------------------------------------------------------------------------- 5. Average ROE - 3 years > 15: A Company that does not make returns more than its cost of equity does not have to run in the first place, a return of 15 or more signifies it is generating returns definitely higher than the cost of equity and a 3-year span gives a clear cut judgement--------------------------------------------------------------------- 6. Average ROCE - 3 years > 15: A Company that does not make returns more than its cost of capital employed (equity + debt) does not have to run in the first place, a return of 15 or more signifies it is generating returns definitely higher than the cost of equity and debt.------------------------------------------------------------------------ 7. PEG Ratio > 0 < 5: Usually the price-to-earnings (PE) ratio is considered by most investors to check whether the current market price of the share is overpriced or undervalued. But the price to earnings to growth (PEG) ratio factors in the expected growth of the Company to the PE ratio. And unlike the PE ratio which differs significantly for different industries, the PEG ratio usually stays in a range of 0 to 10, anything below 1 is usually considered undervalued, and 1 to 5 is acceptable if Company's other records are very good but anything more than 5 is extremely overpriced and the filter eliminates those companies alone. (the lower the PEG ratio, the better it is)------------------------------------------------------------------------------------------------8. Average dividend payout of 3 years > 0: It is important for an investor to receive dividends from the Company, it is the sole source of income from investing when share price plunges or stays flat, companies not paying dividend does not mean bad, it's just that they believe them reinvesting money back into the business is much better but shareholders need some or other income to be compensated for staying invested. Benjamin Graham considers this as one of the four main rules a defensive investor should follow before buying a stock. Have considered dividend payout ratio of 3 years because there could be off years for Company where they fail to declare dividend, so considering just one year doesn't give a true picture---------------There are several other factors to be looked into from this list which has not been applied as a filter so as to not eliminate these companies based on these factors but these are definitely to be looked into while doing your analysis, especially sales growth %, dividend yield %, interest coverage, free cash flow 3 years and therefore I would suggest you add these to your columns for a good analysis.------------------------------------------------------------ DISCLAIMER: Due to the ROCE and Debt/equity parameters set, banking companies would not form part of the list.
by Abdul Razik
S.No. | Name | CMP Rs. | P/E | Mar Cap Rs.Cr. | Div Yld % | NP Qtr Rs.Cr. | Qtr Profit Var % | Sales Qtr Rs.Cr. | Qtr Sales Var % | ROCE % | Sales Rs.Cr. | PAT 12M Rs.Cr. | Sales Var 3Yrs % |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1. | TCS | 3440.30 | 25.65 | 1244730.65 | 1.60 | 12293.00 | -1.69 | 64479.00 | 5.29 | 64.63 | 255324.00 | 48519.92 | 10.01 |
2. | Hawkins Cookers | 7980.00 | 36.89 | 4221.42 | 1.50 | 21.20 | 7.56 | 285.70 | 4.88 | 44.52 | 1085.85 | 114.44 | 10.05 |
3. | Infosys | 1507.60 | 23.61 | 626146.00 | 2.85 | 7038.00 | -11.75 | 40925.00 | 7.92 | 37.50 | 162990.00 | 26516.13 | 10.25 |
4. | Torrent Pharma. | 3141.20 | 57.09 | 106307.71 | 0.89 | 503.00 | 31.94 | 2809.00 | 2.82 | 23.16 | 11302.00 | 1862.00 | 10.25 |
5. | Supreme Inds. | 3483.80 | 46.06 | 44253.62 | 0.86 | 293.94 | -17.16 | 3027.07 | 0.64 | 22.95 | 10446.25 | 960.88 | 10.36 |
6. | Firstsour.Solu. | 325.10 | 39.13 | 22985.48 | 1.23 | 160.69 | 20.37 | 2161.46 | 29.39 | 14.78 | 7980.31 | 587.39 | 10.46 |
7. | Sun TV Network | 598.95 | 13.51 | 23603.70 | 2.80 | 363.26 | -20.00 | 827.56 | -10.35 | 26.20 | 4035.78 | 1746.54 | 10.46 |
8. | Datamatics Glob. | 559.90 | 17.86 | 3313.32 | 0.89 | 74.61 | 9.49 | 425.47 | 15.21 | 21.22 | 1638.92 | 185.57 | 10.49 |
9. | Abbott India | 30165.00 | 48.03 | 64100.63 | 1.36 | 360.78 | 16.01 | 1614.28 | 12.33 | 46.02 | 6243.19 | 1334.46 | 10.71 |
10. | Zydus Lifesci. | 878.65 | 19.50 | 88412.75 | 0.34 | 1026.20 | 33.34 | 5269.10 | 16.96 | 22.34 | 22247.40 | 4533.87 | 10.72 |
11. | Styrenix Perfor. | 2669.80 | 20.57 | 4696.18 | 3.67 | 47.70 | 36.52 | 690.79 | 42.52 | 31.40 | 2641.43 | 228.35 | 10.85 |
12. | Galaxy Surfact. | 2076.00 | 24.01 | 7360.41 | 1.06 | 64.61 | -9.47 | 1041.69 | 10.76 | 17.45 | 4007.74 | 306.54 | 10.87 |
13. | Sula Vineyards | 276.30 | 33.22 | 2331.87 | 1.30 | 13.03 | -3.84 | 125.71 | 2.60 | 13.29 | 579.15 | 70.20 | 10.92 |
14. | HCL Technologies | 1569.40 | 24.48 | 425882.60 | 3.44 | 4309.00 | 8.10 | 30246.00 | 6.13 | 31.88 | 117055.00 | 17399.00 | 10.97 |
15. | UTI AMC | 982.00 | 19.23 | 12568.67 | 2.44 | 124.02 | -18.04 | 316.88 | -3.24 | 23.71 | 1449.21 | 653.52 | 11.00 |
S.No. | Name | CMP Rs. | P/E | Mar Cap Rs.Cr. | Div Yld % | NP Qtr Rs.Cr. | Qtr Profit Var % | Sales Qtr Rs.Cr. | Qtr Sales Var % | ROCE % | Sales Rs.Cr. | PAT 12M Rs.Cr. | Sales Var 3Yrs % |
16. | Lincoln Pharma. | 557.10 | 12.49 | 1115.86 | 0.32 | 20.77 | -25.93 | 146.55 | 0.07 | 22.27 | 597.53 | 89.37 | 11.03 |
17. | Vedant Fashions | 723.05 | 45.22 | 17566.07 | 1.18 | 101.11 | -12.68 | 367.44 | 1.18 | 26.66 | 1386.48 | 388.47 | 11.18 |
18. | Praj Industries | 451.50 | 41.57 | 8299.16 | 1.33 | 39.81 | -56.70 | 859.68 | -15.60 | 19.15 | 3228.04 | 199.65 | 11.27 |
19. | C P C L | 591.90 | 41.17 | 8814.07 | 9.29 | 469.93 | -25.16 | 17249.12 | -2.66 | 4.30 | 59356.02 | 214.09 | 11.28 |
20. | Godawari Power | 178.03 | 14.74 | 11914.82 | 0.56 | 145.04 | -36.82 | 1297.60 | -0.86 | 29.19 | 5437.46 | 808.44 | 11.30 |
21. | NMDC | 64.29 | 8.72 | 56522.60 | 3.76 | 1880.00 | 12.62 | 6567.83 | 21.40 | 30.91 | 23390.24 | 6483.02 | 11.50 |
22. | G M Breweries | 657.65 | 11.71 | 1502.53 | 1.14 | 60.46 | -30.22 | 169.33 | 5.93 | 18.13 | 636.57 | 128.32 | 11.56 |
23. | Ajanta Pharma | 2537.90 | 34.44 | 31701.44 | 1.42 | 225.26 | 11.12 | 1170.41 | 11.04 | 33.33 | 4648.10 | 920.39 | 11.63 |
24. | Granules India | 440.90 | 22.32 | 10693.75 | 0.34 | 117.60 | -6.41 | 1137.70 | -1.55 | 15.40 | 4459.96 | 479.13 | 11.65 |
25. | United Spirits | 1531.20 | 75.88 | 111371.96 | 0.59 | 335.00 | 8.64 | 3433.00 | 14.36 | 27.87 | 11821.00 | 1467.70 | 11.66 |