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.	Emami Paper	92.19	11.32	557.75	1.74	1.70	-95.68	454.31	-11.83	12.20	21.32	14.89	0.79	0.37
2.	Allcargo Logist.	28.65	58.52	2815.67	3.84	10.31	503.68	4105.74	27.84	3.32	19.56	15.32	0.86	0.42
3.	Themis Medicare	128.07	25.55	1178.76	0.39	0.52	-92.94	93.81	13.70	13.51	18.19	17.59	0.20	0.55
4.	Dharmaj Crop	204.35	20.38	690.65	0.00	1.18	-84.73	174.51	41.40	14.52	16.42	19.37	0.35	0.68
5.	PSP Projects	637.40	37.85	2526.77	0.00	6.08	-81.30	623.21	-10.54	19.08	18.99	20.24	0.23	0.98
6.	Rashi Peripheral	273.20	9.53	1800.38	0.37	32.07	28.49	2826.31	7.71	14.50	19.67	22.15	0.49	1.13
7.	Craftsman Auto	4654.60	56.58	11103.82	0.24	12.93	-73.96	1576.09	39.51	19.99	18.66	15.91	0.70	1.21
8.	PDS	370.95	32.29	5242.21	1.28	42.45	70.44	3124.88	21.13	17.47	23.24	20.10	0.69	1.36
9.	HMA Agro Inds.	31.81	21.56	1592.95	0.94	21.19	-56.00	1454.98	16.24	14.03	24.82	26.09	0.72	1.46
10.	Redington	251.80	16.08	19685.08	2.46	402.96	17.47	26716.08	13.66	19.46	20.48	18.64	0.23	1.51
11.	Vishnu Prakash R	170.26	19.38	2122.19	0.00	3.86	-77.78	240.93	-0.46	24.71	28.93	26.71	0.74	1.60
12.	RNFI Services	241.10	58.98	601.61	0.00	8.77	51.81	458.11	-13.10	30.21	37.90		0.22	1.91
13.	Prec. Wires (I)	135.96	29.49	2429.03	0.77	18.95	4.99	982.26	22.05	25.35	15.83	14.74	0.19	1.93
14.	Gretex Corporate	309.80	27.28	701.37	0.10	1.28	-93.16	65.70	50.17	50.19	47.98	43.32	0.03	1.95
15.	Gandhar Oil Ref.	145.20	18.35	1421.21	0.34	20.42	-59.15	1005.29	-8.83	21.63	22.70	20.50	0.19	2.03
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.	Ram Ratna Wires	513.70	35.00	2262.44	0.49	18.34	42.58	888.67	27.24	17.37	16.39	13.91	0.51	2.06
17.	Dixon Technolog.	16347.00	154.97	98468.92	0.03	216.23	77.51	10453.68	116.96	29.16	23.30	23.83	0.36	2.07
18.	Greenpanel Inds.	230.47	38.93	2826.19	0.65	8.50	-68.28	359.44	-6.80	12.80	19.12	15.48	0.24	2.36
19.	ICE Make Refrig.	923.20	57.13	1456.79	0.22	2.81	39.11	110.56	34.13	34.30	24.29	19.07	0.74	2.54
20.	Creative Newtech	728.30	17.21	1027.90	0.07	17.07	47.79	659.06	29.03	26.48	25.15	23.43	0.31	2.59
21.	Cellecor Gadgets	45.40	31.98	988.26	0.00	16.28	79.49	600.23	106.41	32.44	36.76		0.77	2.71
22.	BASF India	4298.80	30.83	18607.63	0.35	103.58	-26.05	3758.67	13.00	24.99	20.23	17.93	0.05	2.76
23.	BCL Industries	37.34	11.91	1102.14	0.67	20.92	-37.30	735.43	18.20	15.71	18.16	17.37	0.50	2.84
24.	Western Carriers	76.89	10.42	783.93	0.00	13.20	-35.26	443.00	-3.00	21.90	24.39	25.05	0.35	2.98
25.	Pondy Oxides	791.25	37.49	2225.37	0.32	15.14	20.93	502.42	10.55	16.10	19.01	16.17	0.36	3.01

1 2 3 4 21 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 2025 results