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

542 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.	102.65	101.33	1375.59	0.29	0.57	-88.80	152.56	-31.13	18.12	18.11	16.28	0.92	0.37
2.	Dharmaj Crop	264.00	18.50	892.24	0.00	0.77	-34.75	189.54	8.61	12.00	11.62	15.07	0.31	0.41
3.	Agarwal Indl.	403.00	10.34	602.80	0.81	2.80	-89.89	408.44	-24.66	16.90	22.77	23.19	0.63	0.69
4.	Praj Industries	365.25	90.90	6713.81	1.64	-12.39	-77.06	841.49	-1.35	17.92	19.93	18.05	0.16	1.12
5.	Redington	218.70	10.71	17097.35	3.16	287.58	61.68	33213.03	25.62	17.47	16.04	18.19	0.28	1.16
6.	Sunlite Recycli.	451.55	15.55	623.42	0.00	25.80	257.84	1642.41	116.13	46.52	39.32		0.07	1.57
7.	Paramount Comm.	54.89	28.91	1675.23	0.00	7.48	-66.99	460.92	17.69	16.30	15.81	13.00	0.14	1.62
8.	Innovision	306.00	23.75	728.72	0.00	4.37	43.27	233.26	2.12	37.48	32.30		0.97	1.87
9.	Glottis	60.55	14.56	559.48	0.00	2.70	-79.96	143.87	-27.24	89.96	107.52	107.65	0.25	1.88
10.	Rashi Peripheral	517.00	12.30	3407.03	0.38	86.84	70.49	4489.38	51.00	16.82	13.26	15.98	0.49	1.93
11.	Heritage Foods	325.00	21.18	3015.87	0.76	23.94	-47.27	1157.56	10.40	15.92	15.75	14.42	0.33	2.02
12.	Orient Tech.	266.95	29.15	1222.77	0.62	-14.96	-66.19	198.23	-4.17	26.52	24.82	24.73	0.05	2.16
13.	Vasa Denticity	403.00	50.86	698.95	0.00	1.56	-60.90	71.47	13.75	22.42	25.36	28.18	0.00	2.18
14.	LG Electronics	1525.55	50.30	103550.10	0.00	89.67	-61.59	4114.39	-6.40	56.83	36.47	29.39	0.07	2.18
15.	Som Distilleries	84.00	19.74	1746.38	0.00	5.49	-75.99	250.55	-16.79	17.98	17.35	10.05	0.24	2.19
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.	Rajoo Engineers	54.00	20.22	964.84	0.27	1.83	-89.35	79.40	-11.68	24.49	20.55	18.52	0.07	2.30
17.	Bharat Seats	180.60	26.21	1134.17	0.60	13.25	16.33	574.28	46.16	20.16	18.34	16.61	0.48	2.31
18.	POCL Enterprises	176.65	13.37	543.52	0.36	8.51	55.08	364.42	6.83	32.43	32.88	25.79	0.97	2.39
19.	Creative Newtech	623.40	13.35	936.15	0.08	17.79	29.57	740.81	83.17	18.75	21.40	21.86	0.89	2.40
20.	Coromandel Inter	1842.00	27.04	54341.71	0.66	114.64	-42.51	6003.66	20.35	22.75	17.49	20.44	0.12	2.50
21.	Amal	566.30	31.26	700.10	0.18	1.90	-71.98	75.74	94.40	26.05	20.37	11.04	0.00	2.51
22.	Prec. Wires (I)	373.40	52.48	6826.08	0.32	37.70	98.94	1347.61	37.19	26.78	15.47	15.63	0.19	2.80
23.	West Coast Paper	468.20	21.69	3092.48	1.08	29.57	-58.16	1049.78	3.34	11.47	23.39	20.12	0.13	2.82
24.	Dixon Technolog.	10777.65	45.50	65530.12	0.07	297.97	13.15	10510.51	2.12	41.97	33.57	31.23	0.21	2.83
25.	Shree Refrigerat	228.05	131.92	812.53	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