COMPANY WITH GOOD BALANCE SHEET - CHECK CASH FLOW
Market Capitalization > 1000 AND Debtor days < Average debtor days 3years AND Days Payable Outstanding > Debtor days AND Cash Conversion Cycle < Cash end of preceding year AND Days Inventory Outstanding < Cash Conversion Cycle, CHECK CASH FLOWS AND MOAT OVER ALL Debtor Days < Average Debtor Days 3 Years: This condition filters for companies with a lower current debtor days compared to their average debtor days over the past 3 years. This indicates improved efficiency in collecting payments from customers. 3. Days Payable Outstanding > Debtor Days: This condition filters for companies that take longer to pay their suppliers than they take to collect payments from their customers. While this might seem counterintuitive, it could indicate strong negotiating power with suppliers or effective working capital management. However, it's important to consider other factors like the company's creditworthiness and supplier relationships. 4. Cash Conversion Cycle < Cash End of Preceding Year: This condition is a bit complex. It's not directly related to the cash conversion cycle formula. It might be intended to filter for companies with a positive cash balance at the end of the preceding year and a decreasing cash conversion cycle. This could indicate improved operational efficiency and strong cash flow generation. 5. Days Inventory Outstanding < Cash Conversion Cycle: This condition is also a bit unclear. It might be intended to filter for companies with a relatively low inventory turnover period compared to their cash conversion cycle. This could indicate efficient inventory management.
by Ankit
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 % | Debtor days | Debtor days 3yrs |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1. | Sanofi Consumer | 5004.70 | 61.49 | 11526.14 | 1.10 | 50.00 | -20.26 | 172.60 | -22.11 | 111.44 | 6.90 | 13.83 |
2. | Colgate-Palmoliv | 2689.70 | 50.05 | 73155.98 | 1.78 | 322.78 | -2.22 | 1461.84 | 4.74 | 96.80 | 10.76 | 12.61 |
3. | Gillette India | 8610.00 | 59.19 | 28059.99 | 0.75 | 125.97 | 21.18 | 685.55 | 7.21 | 58.91 | 38.03 | 42.80 |
4. | Hyundai Motor I | 1855.60 | 27.45 | 150775.13 | 0.00 | 1582.56 | -4.05 | 17561.95 | 2.51 | 54.22 | 12.09 | 13.80 |
5. | Ingersoll-Rand | 3866.40 | 46.28 | 12205.45 | 1.81 | 77.66 | 40.99 | 385.32 | 17.04 | 51.35 | 74.84 | 82.60 |
6. | Coal India | 404.80 | 7.07 | 249467.24 | 6.30 | 9592.53 | 12.45 | 37824.54 | -1.02 | 48.04 | 32.40 | 33.63 |
7. | Action Const.Eq. | 1259.00 | 38.53 | 14992.57 | 0.16 | 111.68 | 26.56 | 875.11 | 16.20 | 42.30 | 20.58 | 30.49 |
8. | Akzo Nobel | 3598.40 | 38.23 | 16387.23 | 2.08 | 107.50 | -1.19 | 1022.10 | 5.00 | 41.68 | 52.18 | 52.74 |
9. | Bayer Crop Sci. | 5040.70 | 43.51 | 22653.96 | 2.78 | 34.20 | -63.27 | 1056.90 | 10.68 | 33.91 | 68.67 | 71.80 |
10. | Hind.Aeronautics | 5127.70 | 41.02 | 342927.76 | 0.68 | 3976.63 | -7.71 | 13699.85 | -7.24 | 33.87 | 54.76 | 58.06 |
11. | Emami | 636.30 | 34.60 | 27774.50 | 1.26 | 162.17 | 10.51 | 963.05 | 8.06 | 33.86 | 43.24 | 46.03 |
12. | Bajaj Auto | 8482.50 | 31.44 | 236880.27 | 0.94 | 2195.65 | 8.02 | 13168.88 | 8.25 | 33.53 | 16.88 | 17.04 |
13. | Apar Inds. | 8228.00 | 40.24 | 33050.49 | 0.62 | 249.97 | 5.82 | 5209.76 | 16.94 | 32.09 | 80.11 | 83.44 |
14. | Trent | 5583.00 | 129.35 | 198468.65 | 0.09 | 311.60 | 18.57 | 4216.94 | 27.88 | 31.71 | 1.34 | 1.76 |
15. | Natco Pharma | 841.15 | 8.08 | 15065.83 | 1.13 | 132.40 | -37.75 | 474.80 | -37.41 | 30.10 | 108.52 | 113.47 |
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 % | Debtor days | Debtor days 3yrs |
16. | Force Motors | 10954.50 | 26.39 | 14433.94 | 0.18 | 434.74 | 26.81 | 2356.01 | 17.14 | 29.80 | 7.88 | 9.20 |
17. | Godawari Power | 201.71 | 16.70 | 13499.62 | 0.50 | 145.04 | -36.82 | 1297.60 | -0.86 | 29.19 | 14.21 | 18.89 |
18. | Dixon Technolog. | 16660.00 | 157.94 | 100354.33 | 0.03 | 216.23 | 77.51 | 10453.68 | 116.96 | 29.16 | 47.82 | 48.49 |
19. | Sonata Software | 397.80 | 26.27 | 11155.30 | 1.99 | 107.53 | -2.56 | 2617.20 | 19.42 | 29.08 | 62.56 | 63.72 |
20. | ITD Cem | 653.65 | 30.12 | 11228.90 | 0.26 | 113.91 | 26.86 | 2479.72 | 9.83 | 28.21 | 64.47 | 66.40 |
21. | Kirl. Brothers | 1885.80 | 35.59 | 14974.94 | 0.32 | 137.80 | -9.26 | 1281.30 | 4.70 | 28.18 | 40.02 | 45.22 |
22. | Chambal Fert. | 632.10 | 15.35 | 25325.23 | 1.19 | 130.31 | 34.65 | 2448.73 | -7.35 | 27.87 | 8.07 | 11.70 |
23. | Vedanta | 441.20 | 12.37 | 172526.32 | 9.86 | 4961.00 | 142.23 | 40455.00 | 13.93 | 27.00 | 8.68 | 9.26 |
24. | Narayana Hrudaya | 1774.60 | 46.28 | 36265.87 | 0.23 | 193.06 | 2.62 | 1366.68 | 13.55 | 26.54 | 30.69 | 36.19 |
25. | Blue Star | 1563.20 | 55.24 | 32141.70 | 0.45 | 194.00 | 21.24 | 4018.96 | 20.77 | 26.05 | 59.76 | 68.07 |