HHI calculation for the cement industry in India

	A	B	C	D	E	F	G	H	I	L	M
1	Company	Gross Sales, 2016-17 (lakhs). Source: Annual Reports	Comments	Share of market, if selected is 80% of market	HHI for 80% estimate	Share of market, if selected is 90% of market	HHI for 90% estimate	Share of market, if selected is 100% of market	HHI for 100% estimate

2	Ultratech Cement (Birla group)	2,716,200.00	Aditya Birla group	17.58350059	309.179493	19.78143848	391.3053084	21.97937538	483.0929421
3	ACC	1,127,400.00	50% stake belongs to Ambuja cement	7.298298566	53.26516195	8.210586019	67.41372278	9.122873059	83.22681286	Total measured gross sales	12,357,949.00
4	Shree Cement	949,652.00	29.3	6.147635116	37.79341751	6.916089617	47.83229559	7.68454377	59.05221296	Industry gross sales if this is 90% of market	13731054
5	Ambuja Cement	916,000.00		5.929786665	35.16236989	6.671010106	44.50237583	7.412233211	54.94120118	Industry gross sales if this is 100% of market	12357949
6	Jaypee Group	651,907.00		4.220163139	17.80977692	4.747683608	22.54049964	5.275203838	27.82777554	Industry gross sales if this is 80% of market	15447436
7	Heidelberg group	627,200.00	2016, calculated, approximate	4.060220738	16.48539244	4.567748404	20.86432549	5.075275841	25.75842486	CR4 at 80%	36.95922093
8	Nuvoco	583,200.00		3.775383824	14.25352302	4.247306871	18.03961566	4.719229704	22.271129	CR4 at 90%	41.57912422
9	India Cements	577,700.00		3.73977921	13.98594854	4.207251679	17.70096669	4.674723937	21.85304389	CR4 at 100%	46.19902542
10	Birla Corporation	489,122.00	MP Birla group	3.166363661	10.02585883	3.562159176	12.68897799	3.957954512	15.66540392	HHI at 80%	550.0104952
11	Kesoram	439,600.00	BK Birla group	2.845779714	8.09846218	3.20150223	10.24961653	3.557224585	12.65384675	HHI at 90%	696.1070555
12	Century	436,656.00	BK Birla group, 4.3% stake in Kesoram	2.826721535	7.990354636	3.180061778	10.11279291	3.533401861	12.48492871	HHI at 100%	859.3913709
13	JK Cement	370,500.00		2.398456288	5.752592563	2.698263367	7.280625198	2.998070311	8.988425589
14	JK Lakshmi	326,000.00		2.11038259	4.453714678	2.374180453	5.636732821	2.637978195	6.958928959
15	OCL India	323,100.00		2.091609248	4.374829248	2.353060442	5.536893446	2.614511518	6.835670478
16	Prism Cement	234,700.00		1.519345994	2.308412249	1.709264271	2.921584347	1.899182461	3.606894022
17	Orient Cement	217,128.00		1.405592488	1.975690242	1.581291575	2.500483044	1.756990582	3.087015904
18	JSW cement	200,000.00	http://www.thehindu.com/business/Industry/JSW-Cement-eyes-IPO-by-FY-2019-20/article16082381.ece	1.294713246	1.676282388	1.456552425	2.121544966	1.618391531	2.619191147
19	Star Cement	174,577.00		1.130135771	1.277206862	1.271402763	1.616464987	1.412669691	1.995635657
20	Heidelberg Cement	174,120.00		1.127177352	1.270528782	1.268074541	1.608013042	1.408971667	1.985201158
21	Binani Cement	153,462.00		0.9934464205	0.9869357904	1.117627241	1.24909065	1.241808006	1.542087123
22	Mangalam Cement	96,871.00		0.6271008341	0.3932554561	0.7054884498	0.4977139527	0.7838760299	0.6144616303
23	KCP Limited	94,899.00		0.6143349615	0.3774074449	0.6911268428	0.4776563129	0.7679186894	0.5896991136
24	KCP Group	84,828.00		0.549139676	0.3015543838	0.6177821455	0.3816547793	0.6864245839	0.4711787094
25	Sanghi Industries	84,001.00		0.5437860367	0.2957032537	0.6117593012	0.3742494426	0.6797325349	0.462036319
26	Deccan Cement	55,986.00		0.3624290788	0.1313548372	0.4077327203	0.1662459712	0.4530363412	0.2052419265
27	Hathi Cement	48,551.00		0.3142981139	0.09878330443	0.3535853839	0.1250226237	0.3928726361	0.1543489082
28	Sidhee cements	44,360.00		0.2871673979	0.0824651144	0.3230633278	0.1043699138	0.3589592415	0.1288517371
29	Malabar Cements	39,325.00	2015-16	0.2545729919	0.06480740821	0.2863946205	0.08202187868	0.3182162347	0.1012615721
30	Anjani Cement	36,009.00		0.2331066463	0.05433870855	0.2622449813	0.06877243024	0.2913833032	0.08490422937
31	Shree Digvijay Cement	31,606.00		0.2046035342	0.04186260621	0.2301789797	0.0529823627	0.2557544136	0.06541032008
32	Panyam Cements	26,655.00		0.1725529078	0.02977450599	0.1941220244	0.03768336037	0.2156911313	0.04652266411
33	Shriram	16,000.00		0.1035770596	0.01072820729	0.116524194	0.01357788779	0.1294713225	0.01676282334
34	Kalyanpur	6,604.00		0.04275143137	0.001827684884	0.04809536107	0.002313163756	0.05343928835	0.002855757539
35	OneIndia	4,030.00		0.0260884719	0.000680608366	0.02934953136	0.0008613949911	0.03261058935	0.001063450538
36	Maha Cement	0.00		0	0	0	0	0	0
37	Parasakti cements	0.00		0	0	0	0	0	0
38	Penna Cement	0.00		0	0	0	0	0	0
39	Tancem	0.00		0	0	0	0	0	0
40					550.0104952		696.1070555		859.3913709
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100