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

39 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	1429.10	10.93	14129.42	1.82	317.18	84.33	1568.76	-6.14	26.79	25.54	30.08	31.93
2.	Sun TV Network	655.95	13.68	25865.71	2.55	454.09	6.79	923.15	4.09	25.49	27.40	30.73	33.61
3.	Petronet LNG	313.80	13.79	47077.34	2.23	1190.67	0.86	14747.21	-6.52	26.55	28.37	28.72	24.59
4.	Savita Oil Tech	569.65	18.92	3935.28	0.70	68.35	138.24	958.39	5.48	24.24	28.60	25.01	20.74
5.	Gandhi Spl. Tube	832.70	19.16	1009.80	1.44	13.21	38.18	41.25	12.28	35.97	31.78	27.28	22.57
6.	VST Industries	3981.65	20.38	6145.02	3.77	88.20	28.38	375.06	24.30	32.46	37.65	43.83	49.83
7.	Swaraj Engines	2433.05	21.40	2949.90	3.90	35.18	0.63	350.96	-2.45	52.00	52.28	48.66	45.24
8.	Infosys	1416.30	22.58	587721.16	2.68	7975.00	30.04	37923.00	1.29	39.99	39.12	36.98	34.67
9.	eClerx Services	2418.90	22.98	11826.64	0.04	139.06	6.70	752.76	9.62	36.47	31.52	27.93	36.86
10.	HCL Technologies	1348.05	23.30	365896.29	3.86	3995.00	0.13	28499.00	7.11	29.84	27.82	27.27	30.54
11.	Dhanuka Agritech	1368.80	25.45	6245.05	0.58	45.37	-1.52	403.24	2.51	27.01	31.16	28.62	30.50
12.	ITC	436.45	26.62	544771.57	2.92	5406.52	6.65	18019.37	1.78	39.01	33.64	33.53	37.45
13.	MPS	1652.45	26.73	2824.09	1.82	32.00	37.52	84.04	11.67	33.72	28.69	24.49	33.07
14.	TCS	3843.40	29.84	1390413.80	1.25	12502.00	9.15	61237.00	3.51	64.28	59.14	54.63	50.43
15.	Emami	495.45	30.02	21637.53	1.61	260.65	13.29	996.32	1.38	28.02	29.05	24.84	31.10
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.	Oracle Fin.Serv.	7780.70	30.37	67404.38	3.08	560.12	16.86	1642.44	11.69	39.54	36.89	37.39	39.96
17.	Bajaj Auto	9105.60	33.00	254401.19	0.88	2011.43	17.99	11554.95	29.41	33.47	27.69	27.61	31.83
18.	Sanofi India	8624.25	33.63	19857.76	1.94	137.70	13.24	693.90	3.27	71.10	49.08	41.43	33.72
19.	Foseco India	3464.00	34.08	2211.75	0.72	15.85	11.31	122.55	10.46	31.64	27.16	24.78	31.89
20.	Hawkins Cookers	6370.60	34.21	3370.04	1.57	19.71	8.96	272.40	6.05	45.83	51.15	55.29	62.12
21.	Coforge	4482.55	34.66	27709.34	1.70	229.20	42.25	2358.50	8.69	28.32	30.21	28.56	26.18
22.	Sharda Cropchem	365.65	37.83	3300.26	1.64	4.64	-95.72	632.46	-37.83	20.75	22.50	21.77	25.96
23.	Pfizer	4210.90	37.96	19279.23	0.83	129.98	-17.62	539.97	-13.15	26.15	26.23	24.47	23.61
24.	Prec. Wires (I)	140.45	38.99	2488.12	0.61	18.05	19.22	804.83	14.38	26.75	25.75	25.22	21.87
25.	ICICI Lombard	1673.40	43.03	82551.43	0.90	519.50	18.89	5367.05	18.77	22.49	20.99	23.34	23.88
	Median: 39 Co.	1673.4	34.21	25865.71	1.25	229.2	16.86	1092.31	6.05	29.84	28.69	28.56	31.93

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