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

526 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.	Prostarm Info	131.28	32.27	772.91	0.00					33.42	34.79		0.50
2.	Monolithisch	231.00	34.97	502.10	0.00					61.16	56.21	55.41	0.21
3.	Rashi Peripheral	296.15	9.47	1951.62	0.34	52.74	52.69	2973.17	-0.97	14.02	13.58	18.54	0.52	1.71
4.	Speciality Rest.	126.39	28.07	609.65	0.79	2.12	-31.61	103.01	7.09	9.10	15.64	9.12	0.47	2.06
5.	Sanstar	91.03	37.88	1658.97	0.00	5.52	-65.84	226.32	-11.46	11.72	20.12	20.31	0.04	2.44
6.	Khazanchi Jewell	559.35	30.82	1384.22	0.09	24.93	114.91	1015.70	144.74	23.96	22.48	21.04	0.28	2.45
7.	RNFI Services	255.50	35.05	637.54	0.00	11.33	125.52	458.67	12.31	29.39	28.91		0.16	2.47
8.	Dixon Technolog.	14047.00	109.68	84952.99	0.04	464.95	138.10	10292.54	120.97	39.81	28.09	26.96	0.22	2.55
9.	Cellecor Gadgets	37.75	26.59	821.73	0.00	16.28	79.49	600.23	106.41	24.20	30.12		0.77	2.71
10.	Prec. Wires (I)	176.82	35.08	3159.03	0.59	29.58	34.95	1054.38	19.28	26.88	15.50	15.65	0.11	2.81
11.	Bharat Seats	102.62	19.77	644.45	1.07	11.39	40.97	392.91	41.28	15.65	16.68	13.44	0.78	2.90
12.	Focus Lighting	112.75	50.02	758.28	0.44	1.22	-88.66	41.50	-30.39	14.03	25.30	21.44	0.12	2.94
13.	Wonder Electric.	174.34	140.91	2336.30	0.11	9.19	40.74	312.03	20.34	18.21	16.14	14.99	0.98	2.95
14.	Aditya Vision	355.60	43.37	4575.26	0.25	15.98	103.57	486.69	29.55	18.70	26.03	28.62	0.82	3.28
15.	Western Carriers	108.18	16.93	1102.95	0.00	14.08	-41.82	428.58	6.71	13.08	17.23	19.43	0.21	3.29
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.	Bansal Wire Inds	381.60	47.74	5974.18	0.00	30.01	51.11	896.73	57.07	15.06	18.70	20.76	0.45	3.35
17.	Creative Newtech	680.85	18.26	969.64	0.07	13.73	-32.56	402.99	32.50	21.13	23.36	22.75	0.24	3.41
18.	Eveready Inds.	320.00	28.21	2325.99	0.31	10.42	29.44	299.04	6.46	16.98	16.39	30.89	0.68	3.48
19.	Pondy Oxides	704.55	30.46	1981.52	0.35	18.01	46.42	516.63	44.80	16.76	15.20	15.74	0.17	3.49
20.	Ellen.Indl.Gas	310.00	133.91	5637.42	0.00	0.87	132.58	24.44	4.36	12.88	10.96	18.55	0.43	3.56
21.	JTL Industries	75.26	29.10	2875.25	0.17	16.77	-42.37	466.07	0.00	13.17	15.93	18.06	0.04	3.60
22.	Sky Gold & Diam.	318.05	35.17	4665.76	0.00	38.17	180.46	1058.17	106.12	23.40	26.44		0.92	3.61
23.	Paramount Comm.	54.25	19.03	1654.80	0.00	18.74	-36.45	507.02	56.79	16.51	15.90	13.07	0.05	3.70
24.	Agarwal Indl.	978.55	12.65	1463.69	0.31	30.54	-19.65	823.44	6.05	17.05	22.86	23.26	0.69	3.71
25.	BCL Industries	41.21	12.81	1216.37	0.61	27.56	10.35	722.77	20.94	13.31	14.56	16.39	0.67	3.81

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