Bharti Hexacom Ltd. benchmarking: Perfomance to industry peers

Financial

	Bharti Hexacom Ltd.	Indus Towers	Vodafone Idea
Operational Metrics
Media & Entertainment
Churn Rate	2.6 %	n/a	n/a
Telecom
No Of Mobile Subscribers	2.8 Crs	n/a	20.28 Crs
Monthly Data Usage Per User	30.7 GB/User	n/a	17.58 GB/User
No Of Data Subscribers	2.2 Crs	n/a	13.47 Crs
Average Revenue Per User (ARPU)	251.0 Rs	n/a	167.0 Rs
Average Revenue Per User (ARPU) - Broadband	484.0 Rs	n/a	n/a
Net Rupee Retention	99.43 %	n/a	96.91 %
No Of Broadband Subscribers	5.61 Lakh	n/a	1277.8 Lakh
Financials
5 yr Average ROE	8.56 %	23.02 %	53.92 %
5yr average Equity Multiplier	4.46	2.22	-3.17
5yr Average Asset Turnover Ratio	0.38	0.5	0.21
5yr Avg Net Profit Margin	8.29 %	22.27 %	-76.87 %
Price to Book	14.71	2.93	0.0
P/E	59.56	11.29	0.0
5yr Avg Cash Conversion Cycle	11.8 Days	68.06 Days	17.58 Days
Inventory Days	0.0	0.02 Days	0.04 Days
Days Receivable	11.8 Days	67.97 Days	17.57 Days
Days Payable	0.0	16.02 Days	0.0
5yr Average Interest Coverage Ratio	2.34	5.81	-0.46
5yr Avg ROCE	10.84 %	20.92 %	-4.06 %
5yr Avg Operating Profit Margin	39.04 %	48.14 %	40.57 %
5 yr average Debt to Equity	1.63	0.24	-3.06
5yr CAGR Net Profit	n/a	21.32 %	-9.15 %
5yr Average Return on Assets	3.48 %	10.59 %	-16.23 %
Shareholdings
Promoter Holding	70.0 %	51.03 %	25.57 %
Share Pledged by Promoters	0.0	0.0	0.0
Change in Promoter Holding (3 Yrs)	0.0	-17.97 %	-49.42 %
Change in Mutual Fund Holding (3 Yrs)	0.35 %	13.24 %	4.17 %

	Bharti Hexacom Ltd.	Indus Towers	Vodafone Idea
Product Wise Break-Up	Product Wise Break-Up Mobile Services 96.22 Home & office services 3.78 Telecom Towers 0 PI (Passive Infrastructure) 0 ILD (International Long Distance) 0 Mobility 0	Product Wise Break-Up Home & office services 0 ILD (International Long Distance) 0 Mobile Services 0 Mobility 0 PI (Passive Infrastructure) 0 Telecom Tower 100.0	Product Wise Break-Up Home & office services 0 ILD (International Long Distance) 0 Mobile Services 0 Mobility 100.0 PI (Passive Infrastructure) 0 Telecom Towers 0
Location Wise Break-Up	Location Wise Break-Up Domestic 99.85 India 0 Others 0.15	Location Wise Break-Up Domestic 0 Indi 100.0	-
Operating Profit Break-Up	Operating Profit Break-Up Mobile Services 99.8 Homes and Office Services 0.2	-	-
Capex - Segment Wise	Capex - Segment Wise Mobile Services 65.89 Home & office services 34.11	-	-