Magic Formula TSN

A variation of the magic formula from Joel Greenblatt. I include additional filters to remove companies with NaN values.

by Tsniranjan

35 results found: Showing page 1 of 2
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 % ROCE 3Yr % Earnings Yield % ROCE3yr avg %
1. Life Insurance 954.4512.49603689.411.0519038.6737.55243134.491.8553.4890.0510.5490.05
2. Coal India 397.306.94244845.206.429592.5312.4537824.54-1.0248.0463.0621.7763.06
3. Monarch Networth 309.5516.272428.760.1624.72-18.9960.97-10.6133.2738.7311.6538.73
4. Share India Sec. 174.5311.633808.611.0318.64-83.87239.44-48.5520.6937.1227.9237.12
5. Ashoka Buildcon 220.083.656178.160.00451.68132.802694.42-11.7139.9431.6535.9531.65
6. West Coast Paper 480.5510.203174.031.6646.15-63.281041.29-2.6911.1931.0913.3931.09
7. IIFL Capital 305.6413.309473.490.98128.02-28.87537.14-21.7534.5830.6717.2630.67
8. Dolat Algotech 100.788.231773.730.2539.79-41.70113.91-20.8835.4830.3118.8930.31
9. NMDC 71.179.5862571.373.401476.713.437004.597.9429.5929.8516.4229.85
10. Master Trust 155.3213.291743.720.0024.55-35.17121.98-25.6930.0929.4145.0829.41
11. Mahanagar Gas 1325.2012.5313090.032.26252.19-4.831864.8519.0024.4829.2910.7229.29
12. Gokul Agro 246.0714.783630.600.0048.7110.105462.1538.7234.2028.0013.4428.00
13. GHCL 612.709.405866.901.96150.2720.35781.47-5.0925.0827.0815.3827.08
14. Natco Pharma 883.408.4015822.571.08406.005.101221.0014.2932.8026.8616.6326.86
15. Panama Petrochem 362.0011.712189.871.9344.27-27.40695.23-6.1720.4126.6112.0826.61
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 % ROCE 3Yr % Earnings Yield % ROCE3yr avg %
16. Bombay Burmah 2021.0012.5114100.900.84584.780.774518.828.5835.4626.4321.3226.43
17. Authum Invest 2379.209.5140409.550.041766.4617.901442.0762.7631.2526.3210.1226.32
18. Ceigall India 249.8515.194352.510.2072.39-33.031011.617.2121.6026.0411.0226.04
19. Petronet LNG 307.3011.6046095.003.251094.9043.2312315.75-10.7125.5725.7413.8525.74
20. Crest Ventures 400.6012.641139.700.257.92-32.6547.5619.539.7825.6410.8925.64
21. KNR Construct. 210.805.325928.430.127.60-76.14975.21-31.0329.1825.2221.8225.22
22. Natl. Aluminium 180.356.2933123.654.442067.23203.245267.8347.1943.9624.9725.6024.97
23. Suraj Estate 321.0515.311533.760.3118.28-5.04136.4835.9917.3922.7810.3222.78
24. Vedanta 435.5512.21170316.959.994961.00142.2340455.0013.9327.0022.6714.6922.67
25. EID Parry 950.1522.3916891.600.42539.44-31.346811.1222.5717.3521.6715.5921.67

Search Query

You can customize the query below:

Custom query example

Market capitalization > 500 AND Price to earning < 15 AND Return on capital employed > 22%