Bharti Hexacom Ltd. benchmarking: Perfomance to industry peers

Financial

	Bharti Hexacom Ltd.	Vodafone Idea	Indus Towers
Operational Metrics
Media & Entertainment
Churn Rate	2.4 %	n/a	n/a
Telecom Sector
No Of Mobile Subscribers	2.81 Crs	20.39 Crs	n/a
Monthly Data Usage Per User	29.4 GB/User	16.3 GB/User	n/a
No Of Data Subscribers	2.16 Crs	13.48 Crs	n/a
Average Revenue Per User (ARPU)	246.0 Rs	165.0 Rs	n/a
Average Revenue Per User (ARPU) - Broadband	485.0 Rs	n/a	n/a
Net Rupee Retention	99.25 %	96.51 %	n/a
No Of Broadband Subscribers	5.02 Lakh	1275.7 Lakh	n/a
Financials
5 yr Average ROE	8.56 %	53.92 %	23.02 %
5yr average Equity Multiplier	4.46	-3.17	2.22
5yr Average Asset Turnover Ratio	0.38	0.21	0.5
5yr Avg Net Profit Margin	8.29 %	-76.87 %	22.27 %
Price to Book	13.93	0.0	2.86
P/E	60.16	0.0	9.54
5yr Avg Cash Conversion Cycle	11.8 Days	17.58 Days	68.06 Days
Inventory Days	0.0	0.04 Days	0.02 Days
Days Receivable	11.8 Days	17.57 Days	67.97 Days
Days Payable	0.0	0.0	16.02 Days
5yr Average Interest Coverage Ratio	2.34	-0.46	5.81
5yr Avg ROCE	10.84 %	-4.06 %	20.92 %
5yr Avg Operating Profit Margin	39.04 %	40.57 %	48.14 %
5 yr average Debt to Equity	1.63	-3.06	0.24
5yr CAGR Net Profit	n/a	-9.15 %	21.32 %
5yr Average Return on Assets	3.48 %	-16.23 %	10.59 %
Shareholdings
Promoter Holding	70.0 %	25.57 %	50.0 %
Share Pledged by Promoters	0.0	0.0	0.0
Change in Promoter Holding (3 Yrs)	0.0	-49.42 %	-18.81 %
Change in Mutual Fund Holding (3 Yrs)	0.22 %	2.62 %	12.61 %

	Bharti Hexacom Ltd.	Vodafone Idea	Indus Towers
Product Wise Break-Up	Product Wise Break-Up Mobile Services 96.55 Home & office services 3.45 PI (Passive Infrastructure) 0 ILD (International Long Distance) 0 Mobility 0 Telecom Towers 0	Product Wise Break-Up PI (Passive Infrastructure) 0 ILD (International Long Distance) 0 Mobility 100.0 Telecom Towers 0 Mobile Services 0 Home & office services 0	Product Wise Break-Up PI (Passive Infrastructure) 0 ILD (International Long Distance) 0 Mobility 0 Telecom Tower 100.0 Mobile Services 0 Home & office services 0
Location Wise Break-Up	Location Wise Break-Up Domestic 99.85 India 0 Others 0.15	-	Location Wise Break-Up Indi 100.0 Domestic 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 94.4 Home & office services 5.6	-	-