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

547 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	97.09	11.92	587.39	1.65	1.70	-95.68	454.31	-11.83	12.20	21.32	14.89	0.79	0.37
2.	Allcargo Logist.	30.75	62.81	3022.05	3.58	10.31	503.68	4105.74	27.84	3.32	19.56	15.32	0.86	0.42
3.	Themis Medicare	137.58	27.45	1266.29	0.36	0.52	-92.94	93.81	13.70	13.51	18.19	17.59	0.20	0.55
4.	Dharmaj Crop	221.73	22.11	749.39	0.00	1.18	-84.73	174.51	41.40	14.52	16.42	19.37	0.35	0.68
5.	I O C L	137.65	20.02	194378.85	8.72	2147.35	-81.87	194014.49	-2.95	21.14	18.14	16.29	0.90	0.86
6.	PSP Projects	640.65	38.04	2539.65	0.00	6.08	-81.30	623.21	-10.54	19.08	18.99	20.24	0.23	0.98
7.	Rashi Peripheral	304.85	10.63	2008.95	0.33	32.07	28.49	2826.31	7.71	14.50	19.67	22.15	0.49	1.13
8.	Craftsman Auto	4846.30	58.91	11561.13	0.23	12.93	-73.96	1576.09	39.51	19.99	18.66	15.91	0.70	1.21
9.	PDS	402.10	35.00	5682.41	1.18	42.45	70.44	3124.88	21.13	17.47	23.24	20.10	0.69	1.36
10.	HMA Agro Inds.	34.98	23.71	1751.69	0.86	21.19	-56.00	1454.98	16.24	14.03	24.82	26.09	0.72	1.46
11.	Redington	238.09	15.21	18613.27	2.60	402.96	17.47	26716.08	13.66	19.46	20.48	18.64	0.23	1.51
12.	Vishnu Prakash R	180.32	20.53	2247.58	0.00	3.86	-77.78	240.93	-0.46	24.71	28.93	26.71	0.74	1.60
13.	RNFI Services	256.10	62.65	639.04	0.00	8.77	51.81	458.11	-13.10	30.21	37.90		0.22	1.91
14.	Prec. Wires (I)	143.86	31.20	2570.17	0.73	18.95	4.99	982.26	22.05	25.35	15.83	14.74	0.19	1.93
15.	Gretex Corporate	310.00	27.30	701.83	0.10	1.28	-93.16	65.70	50.17	50.19	47.98	43.32	0.03	1.95
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.	Gandhar Oil Ref.	159.73	20.19	1563.43	0.31	20.42	-59.15	1005.29	-8.83	21.63	22.70	20.50	0.19	2.03
17.	Ram Ratna Wires	543.45	37.02	2393.46	0.46	18.34	42.58	888.67	27.24	17.37	16.39	13.91	0.51	2.06
18.	Dixon Technolog.	16607.00	157.44	100035.07	0.03	216.23	77.51	10453.68	116.96	29.16	23.30	23.83	0.36	2.07
19.	Greenpanel Inds.	243.03	41.05	2980.21	0.62	8.50	-68.28	359.44	-6.80	12.80	19.12	15.48	0.24	2.36
20.	ICE Make Refrig.	991.45	61.35	1564.48	0.20	2.81	39.11	110.56	34.13	34.30	24.29	19.07	0.74	2.54
21.	Creative Newtech	732.60	17.31	1033.97	0.07	17.07	47.79	659.06	29.03	26.48	25.15	23.43	0.31	2.59
22.	Cellecor Gadgets	49.85	35.12	1085.12	0.00	16.28	79.49	600.23	106.41	32.44	36.76		0.77	2.71
23.	BASF India	4600.40	32.99	19913.13	0.33	103.58	-26.05	3758.67	13.00	24.99	20.23	17.93	0.05	2.76
24.	Punjab Chemicals	1060.95	37.93	1300.72	0.28	6.07	-45.80	213.89	-0.13	22.49	26.63	26.50	0.35	2.84
25.	BCL Industries	40.31	12.85	1189.80	0.62	20.92	-37.30	735.43	18.20	15.71	18.16	17.37	0.50	2.84

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