The Magic formula

Debt to equity < 1 AND Profit growth 5Years > 15 AND Profit growth 10Years >15 AND Operating cash flow 3years >0 AND Operating cash flow 5years >0 AND Operating cash flow 10years >0 AND Cash from operations last year >0 AND Cash from operations preceding year >0 AND Free cash flow 5years >0 AND Free cash flow 10years >0 AND Return on assets 3years >8 AND Return on assets 5years >8 AND Average return on capital employed 3Years >20 AND Average return on capital employed 5Years >20 AND Average return on capital employed 10Years >20 AND Pledged percentage <15 AND Change in promoter holding 3Years > -15% AND Current assets > Contingent liabilities AND Market Capitalization >500

by Jayesh

72 results found: Showing page 1 of 3

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 %	Debt / Eq	Profit Var 5Yrs %	Profit Var 10Yrs %
1.	Tips Music	587.95	44.51	7515.86	1.19	45.84	5.23	88.07	19.14	108.83	0.02	70.34	50.52
2.	Waaree Renewab.	998.60	35.81	10410.06	0.10	86.54	203.97	603.10	155.26	84.91	0.06	273.69	121.99
3.	Shilchar Tech.	5170.60	40.17	5915.27	0.24	55.36	121.26	231.86	119.92	71.30	0.00	151.28	38.19
4.	Esab India	5188.00	45.73	7985.90	1.25	47.43	7.19	367.72	7.86	70.03	0.01	19.74	18.84
5.	Ingersoll-Rand	3608.20	42.55	11390.37	2.22	67.66	5.93	322.34	7.91	60.02	0.02	26.30	16.95
6.	One Global Serv	255.95	27.45	500.20	0.39	11.00	171.79	55.46	128.23	56.36	0.00	128.82	68.47
7.	Shakti Pumps	831.35	24.87	10258.69	0.12	96.83	4.50	622.50	9.68	55.31	0.14	98.74	31.57
8.	Indian Energy Ex	138.04	28.34	12308.93	2.17	113.04	21.00	139.99	13.30	53.61	0.01	19.79	17.87
9.	Jyoti Resins	1343.85	21.83	1612.62	0.67	19.78	5.38	78.61	10.35	49.99	0.00	56.42	79.73
10.	I R C T C	718.95	44.90	57516.00	1.11	357.95	17.74	1268.53	9.85	49.03	0.02	20.04	25.65
11.	Abbott India	32845.00	49.33	69795.63	1.45	367.04	27.86	1604.59	11.54	46.25	0.05	18.98	20.03
12.	Advani Hotels.	56.77	20.84	524.77	3.35	2.35	-34.90	19.92	-9.70	45.45	0.01	18.64	21.70
13.	Fluidomat	1100.05	24.41	542.32	0.50	6.39	53.98	20.95	33.87	42.16	0.00	47.06	15.35
14.	C D S L	1567.10	66.24	32752.39	0.80	102.41	-23.70	258.81	0.55	41.96	0.00	37.79	30.94
15.	Frontier Springs	4772.30	54.25	1880.29	0.03	11.66	130.89	70.08	58.77	41.83	0.05	19.83	57.89
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 %	Debt / Eq	Profit Var 5Yrs %	Profit Var 10Yrs %
16.	Tanfac Inds.	4077.90	42.28	4067.71	0.17	19.35	71.39	176.00	84.58	41.57	0.13	39.03	32.97
17.	Action Const.Eq.	1078.10	30.37	12838.36	0.19	97.72	16.08	652.08	-11.19	40.11	0.01	51.13	60.73
18.	Dynacons Sys.	992.65	17.44	1263.18	0.05	18.17	27.15	330.61	17.13	39.15	0.60	63.91	59.26
19.	Indrapr.Medical	450.35	24.62	4128.49	1.00	51.46	14.94	365.06	4.94	39.01	0.05	29.38	17.35
20.	Bharat Electron	384.60	51.12	281134.09	0.62	969.05	22.51	4439.74	4.62	38.88	0.00	23.80	16.07
21.	Sharda Motor	1041.50	18.80	5979.01	1.56	99.10	7.32	756.25	10.33	38.68	0.05	43.33	24.08
22.	3M India	31615.00	71.75	35630.11	0.51	177.69	13.07	1195.97	14.28	38.17	0.05	16.80	15.93
23.	Solar Industries	14462.00	103.72	130866.72	0.07	352.62	18.24	2154.45	27.88	38.13	0.22	36.25	23.30
24.	Wealth First Por	1270.70	36.32	1353.93	0.94	16.23	17.69	24.80	21.99	37.50	0.00	93.35	35.67
25.	Benares Hotels	9251.70	27.09	1202.72	0.27	7.58	17.88	25.01	8.74	37.33	0.02	31.81	16.69

1 2 3 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