FundamentallyAvoidList-NoDemandForProducts

As per @Atulsingh_asan -"If a company working capital per share higher than its stock prices then it means company going to consume its own products." Means there is no Demand for Products. Mostly suitable for manufacturing & related sector companies ! So it is kind of Fundamentally weak/avoid list. I am just automating @Atulsingh_asan thought via this #screener. No Credit for me !

by @Coolfundoo

249 results found: Showing page 1 of 10
Edit Columns
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 % Working Cap Rs.Cr. No. Eq. Shares Cr.
1. I R F C 125.0923.91163434.011.281776.9810.196371.89-7.655.83447913.331306.85
2. Zee Entertainmen 103.8315.619976.952.3476.50-62.131969.20-1.579.219985.2096.05
3. Brightcom Group 14.063.732841.370.00210.8732.191455.4923.0912.326580.67201.79
4. Den Networks 33.658.351602.930.0035.17-32.45241.43-3.075.283070.4347.72
5. Jyoti Structures 13.4738.471601.500.0011.16119.25156.1676.871.612465.08119.07
6. Asian Star Co. 710.5524.751137.360.2119.344.71716.54-5.624.201367.991.60
7. Coffee Day Enter 42.30888.380.0023.2840.61269.323.561.012078.6221.13
8. JP Associates 3.30810.020.00232.30-247.29672.42-59.75-2.035552.67245.46
9. The Invest.Trust 140.8218.54728.520.0010.20-26.1570.10-1.009.44764.845.22
10. Mishtann Foods 5.231.63563.590.0082.6615.93386.050.8842.17962.93107.76
11. Kothari Products 89.80529.990.0021.25303.23248.410.31-4.68586.075.97
12. Sakuma Exports 2.9242.54457.770.001.65-71.00375.77-49.272.79643.56156.77
13. Emami Realty Ltd 93.43409.500.00-50.80-267.586.0110.68-1.92548.094.38
14. Riddhi Siddhi Gl 550.359.83392.390.558.04-62.81154.61984.224.88428.150.71
15. Osia Hyper Reta. 21.6917.11356.960.008.0420.18326.480.5614.72538.4016.46
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 % Working Cap Rs.Cr. No. Eq. Shares Cr.
16. Shankara Build. 140.383.64341.222.1432.40101.871644.0027.3516.76556.072.42
17. Shiv Texchem 143.856.93333.330.0027.4947.561170.9926.9614.46424.932.32
18. Baroda Rayon 134.459.47308.050.007.1098.8822.36113.165.04484.622.29
19. Shemaroo Entert. 114.45305.550.00-45.75-165.57139.52-9.63-9.31387.292.73
20. EKI Energy 105.40291.361.90-1.29-154.9614.94-91.620.80327.702.76
21. Sicagen India 63.4216.49250.951.584.54-5.42204.54-11.935.57281.493.96
22. Trigyn Techno. 78.813021.20241.700.00-4.61-156.69224.50-7.214.17570.683.08
23. Hind.Organ.Chem. 34.08228.920.00-6.2261.43163.89176.10-5.20963.116.72
24. Prajay Engineers 32.03222.200.00-3.2035.9614.71212.31-4.18296.966.99
25. Anik Industries 77.2396.19216.420.000.23-77.4547.76350.140.86223.442.78

Search Query

You can customize the query below:

Custom query example

Market capitalization > 500 AND Price to earning < 15 AND Return on capital employed > 22%