Quality & Growth Quantifier All-Star StockS
To identify undervalued stocks from the results of my formula, you can use additional valuation metrics and analysis techniques. ### Steps to Find Undervalued Stocks 1. **Run the Screen**: First, use the formula to filter stocks . This will give you a list of high-quality stocks based on your criteria. 2. **Valuation Metrics**: Evaluate the valuation of these stocks using additional metrics: - **Price-to-Earnings (P/E) Ratio**: Compare the P/E ratios of the screened stocks to the industry average. Stocks with a lower P/E ratio than the industry average may be undervalued. - **Price-to-Book (P/B) Ratio**: Compare the P/B ratios to identify stocks trading below their book value. A lower P/B ratio could indicate undervaluation. - **Dividend Yield**: A higher dividend yield compared to industry peers can be a sign of undervaluation. - **Price/Earnings-to-Growth (PEG) Ratio**: Ensure that stocks with a PEG ratio less than 1 are potentially undervalued, as they offer growth at a reasonable price. 3. **Relative Valuation**: Compare the valuation ratios of the stocks to their historical averages. Stocks trading below their historical P/E, P/B, or PEG ratios might be undervalued. 4. **Discounted Cash Flow (DCF) Analysis**: Perform a DCF analysis to estimate the intrinsic value of the stocks. If the current stock price is below the intrinsic value, the stock may be undervalued. 5. **Industry and Peer Comparison**: Compare the valuation ratios of the screened stocks with their industry peers to identify relative undervaluation. 6. **Analyze Earnings Reports**: Review recent earnings reports, analyst ratings, and future growth projections to understand if the stock is undervalued based on its future earnings potential. ### Example Process 1. **Run Your Screen**: - Enter the formula in the custom filter section and run the screen to get the list of high-quality stocks. 2. **Sort by Valuation Metrics**: - After getting the list, you can sort the stocks by various valuation metrics like P/E ratio, P/B ratio, and PEG ratio. - Click on each column header (P/E, P/B, PEG) to sort the results in ascending or descending order. 3. **Add Valuation Metrics to the Display**: - Customize the display columns to include additional metrics like PEG ratio, dividend yield, and price-to-book ratio for easier comparison. - You can do this by clicking on the "Columns" button and selecting the desired metrics. 4. **Compare and Analyze**: - Compare the sorted list to identify stocks with lower P/E, P/B, and PEG ratios relative to their peers and industry averages. - Conduct further analysis by reading recent earnings reports and analyst opinions available on Screener.in.
by Sathyajith
| 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 % | ROE 3Yr % | ROCE 3Yr % |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1. | Esab India | 5228.40 | 41.13 | 8048.09 | 1.25 | 43.00 | 29.62 | 378.83 | 12.25 | 70.03 | 54.13 | 72.46 |
| 2. | Ingersoll-Rand | 3627.40 | 41.37 | 11451.00 | 2.21 | 71.89 | 15.75 | 455.48 | 19.39 | 60.02 | 38.69 | 51.64 |
| 3. | One Global Serv | 540.00 | 17.02 | 1055.27 | 0.00 | 21.66 | 522.41 | 141.27 | 323.34 | 56.38 | 44.15 | 53.66 |
| 4. | Swaraj Engines | 3534.20 | 22.62 | 4294.02 | 2.97 | 42.10 | 39.50 | 473.20 | 36.96 | 56.21 | 40.57 | 54.36 |
| 5. | Mazagon Dock | 2265.00 | 37.91 | 91365.55 | 0.80 | 879.78 | 9.01 | 3601.09 | 14.55 | 43.19 | 32.35 | 40.00 |
| 6. | Oriana Power Ltd | 1793.00 | 15.75 | 3643.23 | 0.00 | 121.63 | 149.88 | 781.18 | 117.27 | 42.31 | 50.73 | 35.44 |
| 7. | Frontier Springs | 1305.00 | 27.42 | 1541.99 | 0.05 | 14.28 | 63.57 | 81.43 | 39.75 | 41.56 | 20.84 | 25.33 |
| 8. | Premier Energies | 916.20 | 31.19 | 41503.24 | 0.11 | 391.62 | 53.48 | 1936.46 | 13.02 | 41.12 | 42.94 | 24.03 |
| 9. | KPIT Technologi. | 695.50 | 25.07 | 19066.67 | 1.28 | 133.41 | -6.28 | 1617.46 | 9.44 | 40.03 | 30.38 | 36.19 |
| 10. | Ashoka Buildcon | 112.10 | 3.04 | 3146.89 | 0.00 | 2111.41 | -71.23 | 1827.33 | -23.48 | 39.70 | 37.42 | 31.57 |
| 11. | Indo Tech.Trans. | 1250.50 | 14.81 | 1328.04 | 0.00 | 24.90 | 29.22 | 196.30 | 10.69 | 37.80 | 22.70 | 31.04 |
| 12. | Benares Hotels | 9480.00 | 27.98 | 1232.42 | 0.27 | 14.23 | 5.68 | 41.63 | 7.10 | 37.33 | 28.73 | 37.37 |
| 13. | Garden Reach Sh. | 2248.45 | 37.37 | 25756.46 | 0.62 | 170.77 | 73.92 | 1895.69 | 49.15 | 36.64 | 22.70 | 28.01 |
| 14. | Waaree Energies | 3078.65 | 25.53 | 88557.81 | 0.06 | 1106.79 | 158.06 | 7565.05 | 118.81 | 34.94 | 30.72 | 43.48 |
| 15. | Shanthi Gears | 444.05 | 40.55 | 3406.53 | 1.10 | 16.19 | -34.02 | 116.82 | -25.83 | 34.87 | 24.90 | 33.49 |
| 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 % | ROE 3Yr % | ROCE 3Yr % |
| 16. | Indiamart Inter. | 2020.65 | 20.00 | 12141.45 | 1.46 | 188.30 | 55.62 | 401.60 | 13.35 | 34.24 | 19.67 | 25.65 |
| 17. | Cigniti Tech. | 1195.35 | 10.82 | 3292.83 | 0.00 | 80.30 | 31.76 | 579.40 | 12.20 | 34.09 | 27.21 | 34.47 |
| 18. | IIFL Capital | 259.70 | 14.00 | 8088.07 | 1.16 | 187.85 | -5.21 | 586.28 | 0.63 | 33.27 | 28.77 | 30.24 |
| 19. | Natco Pharma | 1028.25 | 11.86 | 18416.97 | 0.60 | 151.30 | 13.91 | 647.30 | 36.33 | 32.78 | 23.86 | 26.85 |
| 20. | Kingfa Science | 4218.80 | 34.04 | 5717.07 | 0.00 | 45.17 | 30.44 | 489.46 | 11.15 | 30.55 | 22.14 | 28.44 |
| 21. | I T D C | 404.00 | 43.23 | 3465.11 | 0.73 | 28.01 | 35.11 | 184.78 | 28.74 | 30.54 | 20.70 | 30.35 |
| 22. | Pokarna | 868.00 | 23.63 | 2691.17 | 0.07 | 20.37 | -59.66 | 134.96 | -39.64 | 28.38 | 19.90 | 20.47 |
| 23. | Gulf Oil Lubric. | 888.70 | 11.98 | 4390.22 | 5.48 | 77.11 | -5.60 | 997.92 | 10.28 | 28.30 | 23.82 | 26.28 |
| 24. | Dhanuka Agritech | 961.35 | 16.37 | 4333.63 | 0.21 | 40.00 | -27.33 | 409.92 | -7.94 | 28.29 | 21.29 | 27.40 |
| 25. | Kirl.Pneumatic | 1095.00 | 33.88 | 7112.93 | 0.91 | 43.10 | 53.33 | 403.50 | 18.68 | 28.27 | 17.64 | 23.17 |