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

534 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.	Central Mine Pla	155.99	16.70	11137.69	0.00					48.53	33.66	34.04	0.00
2.	Wonder Electric.	80.31	79.31	1076.22	0.37	0.57	-88.80	152.56	-31.13	18.12	18.11	16.28	0.92	0.37
3.	Dharmaj Crop	245.13	17.16	828.47	0.00	0.77	-34.75	189.54	8.61	12.00	11.62	15.07	0.31	0.41
4.	Agarwal Indl.	384.05	9.84	574.45	0.86	2.80	-89.89	408.44	-24.66	16.90	22.77	23.19	0.63	0.69
5.	Praj Industries	334.10	83.15	6141.20	1.80	-12.39	-77.06	841.49	-1.35	17.92	19.93	18.05	0.16	1.12
6.	Paramount Comm.	32.55	17.14	993.46	0.00	7.48	-66.99	460.92	17.69	16.30	15.81	13.00	0.14	1.62
7.	Systematix Corp.	62.89	29.78	858.69	0.16	0.69	-96.93	33.60	-20.51	25.09	23.31	20.19	0.06	1.70
8.	Rashi Peripheral	364.70	9.90	2403.36	0.55	74.60	131.00	4030.41	42.60	14.19	13.58	18.43	0.52	1.85
9.	MIC Electronics	33.03	85.69	796.06	0.00	1.88	-13.36	90.23	667.91	8.71	19.75		0.20	2.08
10.	Orient Tech.	254.06	27.76	1163.75	0.64	-14.96	-66.19	198.23	-4.17	26.52	24.82	24.73	0.05	2.16
11.	Vasa Denticity	373.00	47.08	646.91	0.00	1.56	-60.90	71.47	13.75	22.42	25.36	28.18	0.00	2.18
12.	LG Electronics	1318.80	43.52	89516.50	0.00	89.67	-61.59	4114.39	-6.40	56.83	36.47	29.39	0.07	2.18
13.	Som Distilleries	69.52	16.34	1445.33	0.00	5.49	-75.99	250.55	-16.79	17.98	17.35	10.05	0.24	2.19
14.	Bharat Seats	156.33	23.73	981.75	0.70	9.90	43.61	491.01	60.26	15.65	16.68	13.44	0.64	2.22
15.	Western Carriers	83.34	19.03	849.69	0.00	10.83	-17.95	478.09	7.92	13.16	17.23	19.43	0.23	2.27
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.	Advance Agrolife	96.28	21.15	618.94	0.00	3.01	8.27	132.64	17.20	28.00	33.60	33.00	0.47	2.27
17.	POCL Enterprises	163.25	12.36	502.26	0.43	8.51	55.08	364.42	6.83	32.43	32.88	25.79	0.97	2.39
18.	Creative Newtech	595.80	13.51	894.69	0.08	23.37	36.91	914.00	38.68	21.13	22.04	21.71	0.39	2.56
19.	Divine Power	416.05	110.61	1038.67	0.00	4.74	5.33	179.59	24.70	14.57	19.50	16.77	0.82	2.64
20.	Prec. Wires (I)	300.05	42.20	5485.15	0.38	37.70	98.94	1347.61	37.19	26.78	15.47	15.63	0.19	2.80
21.	West Coast Paper	431.95	19.99	2853.03	1.16	29.57	-58.16	1049.78	3.34	11.47	23.39	20.12	0.13	2.82
22.	Pyramid Technopl	143.43	20.76	527.60	0.35	4.74	-30.19	161.49	5.31	14.03	17.80	22.00	0.54	2.94
23.	Shree Refrigerat	195.15	112.88	695.33	0.00	1.48	-82.19	50.39	-1.12	17.83	18.67	19.87	0.13	2.94
24.	Dixon Technolog.	9920.50	42.81	60318.52	0.08	320.56	67.80	10671.59	2.08	39.95	28.07	26.94	0.34	3.00
25.	Cellecor Gadgets	27.05	16.67	596.93	0.00	19.53	33.58	641.49	50.69	24.21	30.12	31.07	0.80	3.04

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