Value investing formula

((Average return on equity 3Years > 14.99 OR Average return on equity 5Years > 14.99) AND Debt to equity < 0.51 AND EPS >0 AND Market Capitalization > 20000 AND Sales growth 3Years >0 AND Profit growth 3Years >0 AND Pledged percentage = 0) OR ((Average return on equity 3Years > 14.99 OR Average return on equity 5Years > 14.99) AND Debt to equity < 0.51 AND (Current ratio > 0.99 OR Quick ratio > 0.49) AND EPS >0 AND Market Capitalization < 20000 AND Sales growth 3Years >0 AND Profit growth 3Years >0 AND Pledged percentage = 0)

by Shameek

544 results found: Showing page 1 of 22

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 %	ROE 3Yr %	ROE 5Yr %	Debt / Eq	NPM Qtr %
1.	Wonder Electric.	106.20	105.14	1426.78	0.28	0.57	-88.80	152.56	-31.13	18.12	18.11	16.28	0.92	0.37
2.	Dharmaj Crop	256.89	18.06	871.53	0.00	0.77	-34.75	189.54	8.61	12.00	11.62	15.07	0.31	0.41
3.	Agarwal Indl.	443.70	11.36	662.92	0.74	2.80	-89.89	408.44	-24.66	16.90	22.77	23.19	0.63	0.69
4.	Praj Industries	403.35	100.34	7411.31	1.49	-12.39	-77.06	841.49	-1.35	17.92	19.93	18.05	0.16	1.12
5.	Sunlite Recycli.	565.85	19.46	781.21	0.00	25.80	257.84	1642.41	116.13	46.52	39.32		0.07	1.57
6.	Paramount Comm.	40.27	21.26	1231.77	0.00	7.48	-66.99	460.92	17.69	16.30	15.81	13.00	0.14	1.62
7.	Systematix Corp.	73.35	34.90	1006.25	0.14	0.69	-96.93	33.60	-20.51	25.09	23.31	20.19	0.06	1.70
8.	Rashi Peripheral	472.30	12.79	3105.36	0.42	74.60	131.00	4030.41	42.60	14.19	13.58	18.37	0.52	1.85
9.	Innovision	330.45	25.57	784.28	0.00	4.37	43.27	233.26	2.12	37.48	32.30		0.97	1.87
10.	Glottis	63.58	15.34	588.29	0.00	2.70	-79.96	143.87	-27.24	89.96	107.52	107.65	0.25	1.88
11.	Orient Tech.	286.26	31.29	1311.48	0.57	-14.96	-66.19	198.23	-4.17	26.52	24.82	24.73	0.05	2.16
12.	Vasa Denticity	391.60	49.43	679.17	0.00	1.56	-60.90	71.47	13.75	22.42	25.36	28.18	0.00	2.18
13.	LG Electronics	1605.80	52.96	108955.84	0.00	89.67	-61.59	4114.39	-6.40	56.83	36.47	29.39	0.07	2.18
14.	Som Distilleries	91.16	21.42	1894.38	0.00	5.49	-75.99	250.55	-16.79	17.98	17.35	10.05	0.24	2.19
15.	Bharat Seats	177.08	26.82	1109.34	0.62	9.90	43.61	491.01	60.26	15.65	16.68	13.44	0.64	2.22
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 %	ROE 3Yr %	ROE 5Yr %	Debt / Eq	NPM Qtr %
16.	Western Carriers	103.24	23.66	1056.34	0.00	10.83	-17.95	478.09	7.92	13.16	17.23	19.43	0.23	2.27
17.	Advance Agrolife	115.38	25.27	739.54	0.00	3.01	8.27	132.64	17.20	28.00	33.60	33.00	0.47	2.27
18.	POCL Enterprises	189.20	14.33	582.09	0.37	8.51	55.08	364.42	6.83	32.43	32.88	25.79	0.97	2.39
19.	Amal	554.45	30.63	685.44	0.18	1.90	-71.98	75.74	94.40	26.05	20.37	11.04	0.00	2.51
20.	Creative Newtech	607.90	13.80	914.18	0.08	23.37	36.91	914.00	38.68	21.13	22.04	21.71	0.39	2.56
21.	Divine Power	443.10	117.81	1106.21	0.00	4.74	5.33	179.59	24.70	14.57	19.50	16.77	0.82	2.64
22.	Prec. Wires (I)	405.70	57.07	7418.42	0.28	37.70	98.94	1347.61	37.19	26.78	15.47	15.63	0.19	2.80
23.	West Coast Paper	490.15	22.66	3234.10	1.02	29.57	-58.16	1049.78	3.34	11.47	23.39	20.12	0.13	2.82
24.	Pyramid Technopl	178.09	25.75	654.27	0.28	4.74	-30.19	161.49	5.31	14.03	17.80	22.00	0.54	2.94
25.	Shree Refrigerat	214.45	124.04	764.09	0.00	1.48	-82.19	50.39	-1.12	17.83	18.67	19.87	0.13	2.94

1 2 3 421 22 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 2026 results