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

539 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.	Monolithisch Ind	428.65	64.88	931.71	0.00					61.16	56.21	55.41	0.21
2.	Anthem Bioscienc		63.24	32011.77						34.22	23.05	27.55	0.09
3.	Rashi Peripheral	304.70	9.74	2007.63	0.33	52.74	52.69	2973.17	-0.97	14.02	13.58	18.54	0.52	1.71
4.	Speciality Rest.	134.35	29.90	649.33	0.74	2.12	-31.61	103.01	7.09	9.10	15.64	9.12	0.47	2.06
5.	Sanstar	93.89	39.07	1711.45	0.00	5.52	-65.84	226.32	-11.46	11.72	20.12	20.31	0.04	2.44
6.	Khazanchi Jewell	588.60	32.43	1456.60	0.08	24.93	114.91	1015.70	144.74	23.96	22.48	21.04	0.28	2.45
7.	RNFI Services	266.50	36.56	664.99	0.00	11.33	125.52	458.67	12.31	29.39	28.91		0.16	2.47
8.	Dixon Technolog.	16099.00	125.74	97392.56	0.03	464.95	138.10	10292.54	120.97	39.81	28.09	26.96	0.22	2.55
9.	Cellecor Gadgets	35.80	25.22	779.29	0.00	16.28	79.49	600.23	106.41	24.20	30.12		0.77	2.71
10.	Prec. Wires (I)	191.30	37.80	3403.61	0.55	29.58	34.95	1054.38	19.28	26.88	15.50	15.65	0.11	2.81
11.	Bharat Seats	103.15	19.96	650.84	1.07	11.39	40.97	392.91	41.28	15.65	16.68	13.44	0.78	2.90
12.	Focus Lighting	103.60	45.96	696.74	0.48	1.22	-88.66	41.50	-30.39	14.03	25.30	21.44	0.12	2.94
13.	Wonder Electric.	157.65	127.26	2109.96	0.13	9.19	40.74	312.03	20.34	18.21	16.14	14.99	0.98	2.95
14.	JTL Industries	81.63	37.17	3120.86	0.15	15.87	-48.31	504.16	-2.23	13.17	15.93	18.06	0.04	3.15
15.	Aditya Vision	370.55	44.19	4791.19	0.30	15.98	103.57	486.69	29.55	19.13	26.34	28.90	0.82	3.28
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	115.65	18.12	1180.03	0.00	14.08	-41.82	428.58	6.71	13.08	17.23	19.43	0.21	3.29
17.	GP Eco Solutions	506.05	57.82	592.62	0.00	5.32		160.88		24.93	34.30		0.55	3.31
18.	Bansal Wire Inds	410.70	51.38	6430.54	0.00	30.01	51.11	896.73	57.07	15.06	18.70	20.76	0.45	3.35
19.	Creative Newtech	640.30	18.10	961.52	0.08	13.73	-32.56	402.99	32.50	21.13	23.36	22.75	0.24	3.41
20.	Eveready Inds.	371.60	32.80	2704.21	0.27	10.42	29.44	299.04	6.46	16.98	16.39	30.89	0.68	3.48
21.	Pondy Oxides	973.20	42.49	2764.71	0.26	18.01	46.42	516.63	44.80	16.76	15.20	15.74	0.17	3.49
22.	Sky Gold & Diam.	319.75	35.35	4689.97	0.00	38.17	180.46	1058.17	106.12	23.40	26.44		0.92	3.61
23.	Atmastco Ltd	233.60	29.05	577.80	0.00	5.49	-46.75	150.66	1.91	21.33	19.75	16.13	0.56	3.64
24.	Paramount Comm.	60.43	21.22	1845.15	0.00	18.74	-36.45	507.02	56.79	16.51	15.90	13.07	0.05	3.70
25.	Agarwal Indl.	931.50	12.06	1394.83	0.32	30.54	-19.65	823.44	6.05	17.05	22.86	23.26	0.69	3.71

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 Jun 2025 results