Best Query Large cap with Quality
Price to book value < 5 and Price to Earning < 25 and Dividend yield > .1 and Debt to equity < 1 and sales > 1 and Net profit > 1 and Quick ratio > 1 and Interest Coverage Ratio > 1 and Average return on equity 3Years > 15 and Average return on equity 10Years > 15 and Sales growth 3Years > 1 and Profit growth 3Years > 1 and Market Capitalization > 5000
by Prasanth Er
17 results found: Showing page 1 of 1
| 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 % | CMP / BV |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1. | Coal India | 452.45 | 9.50 | 278832.69 | 5.37 | 9093.69 | 17.49 | 36153.97 | 2.80 | 70.49 | 4.00 |
| 2. | Coromandel Inter | 1111.95 | 19.02 | 32740.52 | 1.06 | 228.11 | -56.70 | 5464.15 | -34.24 | 38.28 | 3.60 |
| 3. | GHCL | 533.00 | 6.95 | 5102.10 | 3.25 | 99.85 | -60.70 | 797.33 | -27.62 | 35.53 | 1.82 |
| 4. | NMDC | 252.25 | 12.75 | 73924.53 | 2.60 | 1481.72 | 82.98 | 5409.90 | 45.43 | 30.22 | 3.09 |
| 5. | JK Paper | 374.30 | 5.67 | 6340.75 | 2.14 | 236.36 | -28.61 | 1706.22 | 3.84 | 28.46 | 1.35 |
| 6. | Godawari Power | 907.80 | 14.00 | 12341.15 | 0.46 | 229.16 | 79.06 | 1308.92 | -10.53 | 27.49 | 3.02 |
| 7. | Dr Reddy's Labs | 6218.75 | 19.93 | 103740.16 | 0.67 | 1380.90 | 11.01 | 7236.80 | 6.58 | 26.73 | 4.02 |
| 8. | Indraprastha Gas | 453.05 | 18.67 | 31713.54 | 2.84 | 392.07 | 40.90 | 3556.19 | -4.17 | 26.67 | 4.02 |
| 9. | Petronet LNG | 302.60 | 13.42 | 45390.00 | 2.31 | 1190.67 | 0.86 | 14747.21 | -6.52 | 26.55 | 2.73 |
| 10. | Caplin Point Lab | 1357.15 | 23.56 | 10306.45 | 0.34 | 119.82 | 20.34 | 435.50 | 17.05 | 26.32 | 4.94 |
| 11. | Sun TV Network | 634.95 | 13.26 | 25022.40 | 2.68 | 454.09 | 6.79 | 923.15 | 4.09 | 25.49 | 2.49 |
| 12. | Gulf Oil Lubric. | 1043.15 | 17.99 | 5129.08 | 2.42 | 80.74 | 28.87 | 817.26 | 4.63 | 23.48 | 4.28 |
| 13. | Transport Corp. | 889.70 | 20.76 | 6916.93 | 0.86 | 80.20 | -7.35 | 1002.00 | 3.65 | 22.36 | 3.71 |
| 14. | Marksans Pharma | 167.15 | 23.92 | 7574.66 | 0.30 | 82.97 | 33.16 | 586.13 | 22.15 | 22.19 | 4.09 |
| 15. | Sarda Energy | 238.10 | 15.42 | 8390.20 | 0.32 | 114.44 | -11.11 | 925.39 | 1.91 | 19.31 | 2.27 |
| 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 % | CMP / BV |
| 16. | Guj. Ambuja Exp | 168.65 | 23.88 | 7735.50 | 0.21 | 100.66 | 22.89 | 1301.78 | 15.22 | 17.94 | 2.96 |
| 17. | Triven.Engg.Ind. | 361.70 | 18.60 | 7917.58 | 0.86 | 137.40 | -6.71 | 1311.18 | -10.36 | 17.53 | 2.95 |
| Median: 17 Co. | 453.05 | 17.99 | 10306.45 | 1.06 | 228.11 | 11.01 | 1308.92 | 3.65 | 26.55 | 3.09 |
Results per page