ASPIRERS

Average ROCE 3Years > 20 AND Average ROCE 5Years > 20 AND Average ROCE 10Years > 20 AND Profit growth 5Years > 5 AND Profit growth 5Years < 15 AND Profit growth 10Years > 5 AND Profit growth 10Years < 15 AND Debt to equity < 1 AND Market Capitalization > 1000

by Bagaria Rajat

40 results found: Showing page 1 of 2

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 %	ROCE 3Yr %	ROCE 5Yr %	ROCE 10Yr %
1.	Mahanagar Gas	1391.35	10.63	13743.45	1.87	317.18	84.33	1568.76	-6.14	26.79	25.54	30.08	31.93
2.	Sun TV Network	597.25	12.45	23536.70	2.80	454.09	6.79	923.15	4.09	25.49	27.40	30.73	33.61
3.	Petronet LNG	300.15	13.19	45022.50	2.33	1190.67	0.86	14747.21	-6.52	26.55	28.37	28.72	24.59
4.	Savita Oil Tech	592.20	19.68	4092.13	0.68	68.35	138.24	958.39	5.48	24.24	28.60	25.01	20.74
5.	Swaraj Engines	2435.35	21.46	2958.28	3.90	35.18	0.63	350.96	-2.45	52.00	52.28	48.66	45.24
6.	VST Industries	3924.85	21.48	6059.97	3.82	53.72	-31.98	362.58	4.86	38.05	42.93	48.59	53.52
7.	Infosys	1411.25	22.33	585791.17	2.69	7975.00	30.04	37923.00	1.29	40.30	39.23	37.04	34.70
8.	eClerx Services	2408.20	22.94	11806.29	0.04	139.06	6.70	752.76	9.62	36.47	31.52	27.93	36.86
9.	Dhanuka Agritech	1261.25	23.43	5748.57	0.63	45.37	-1.52	403.24	2.51	27.01	31.16	28.62	30.50
10.	ITC	424.75	25.91	530288.54	3.00	5406.52	6.65	18019.37	1.78	39.01	33.64	33.53	37.45
11.	MPS	1623.95	26.29	2777.90	1.85	32.00	37.52	84.04	11.67	33.72	28.69	24.49	33.07
12.	Emami	441.95	26.76	19291.12	1.81	260.65	13.29	996.32	1.38	28.02	29.05	24.84	31.10
13.	Mphasis	2280.30	27.50	43097.79	2.19	373.60	-9.38	3337.95	-4.80	28.90	27.11	26.38	20.79
14.	TCS	3826.20	29.71	1384352.65	1.25	12502.00	9.15	61237.00	3.51	64.28	59.14	54.63	50.43
15.	Oracle Fin.Serv.	7602.75	30.81	65898.87	2.96	740.81	69.39	1823.62	25.83	35.11	35.95	38.89	38.48
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 %	ROCE 3Yr %	ROCE 5Yr %	ROCE 10Yr %
16.	Bajaj Auto	8804.50	31.89	245803.82	0.91	2011.43	17.99	11554.95	29.41	33.47	27.69	27.61	31.83
17.	Sanofi India	8259.10	32.21	19020.71	2.02	137.70	13.24	693.90	3.27	71.10	49.08	41.43	33.72
18.	Hawkins Cookers	6317.25	33.92	3341.83	1.58	19.71	8.96	272.40	6.05	45.83	51.15	55.29	62.12
19.	Foseco India	3441.95	34.42	2199.41	0.73	16.31	30.59	122.32	15.71	31.64	27.16	24.78	31.89
20.	Prec. Wires (I)	123.90	34.68	2213.57	0.69	18.05	19.22	804.83	14.38	26.75	25.75	25.22	21.87
21.	Nippon Life Ind.	561.15	36.76	35378.17	2.05	284.27	38.56	423.32	19.65	26.64	29.26	27.54	28.30
22.	Sharda Cropchem	357.40	36.96	3224.48	1.68	4.64	-95.72	632.46	-37.83	20.75	22.50	21.77	25.96
23.	Pfizer	4130.20	37.20	18894.73	0.85	129.98	-17.62	539.97	-13.15	26.15	26.23	24.47	23.61
24.	Tech Mahindra	1193.65	41.43	116590.78	2.68	523.70	-60.29	13101.30	-4.61	22.14	23.66	23.60	27.02
25.	ICICI Lombard	1689.75	43.39	83255.01	0.89	519.50	18.89	5367.05	18.77	22.49	20.99	23.34	23.88
	Median: 40 Co.	1960.67	35.72	33572.63	1.25	272.46	15.13	1142.59	4.64	28.36	28.87	28.28	31.91

1 2 Next

Results per page

10 25 50

Search Query

You can customize the query below:

Query

Custom query example

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

Detailed guide on creating screens

Only companies with Mar 2024 results