Bharti Hexacom Ltd. benchmarking: Perfomance to industry peers

Financial

	Bharti Hexacom Ltd.	Tata Communications	Indus Towers
Operational Metrics
Media & Entertainment
Churn Rate	2.6 %	n/a	n/a
Telecom
No Of Mobile Subscribers	2.8 Crs	n/a	n/a
Monthly Data Usage Per User	30.7 GB/User	n/a	n/a
No Of Data Subscribers	2.2 Crs	n/a	n/a
Average Revenue Per User (ARPU)	251.0 Rs	n/a	n/a
Average Revenue Per User (ARPU) - Broadband	484.0 Rs	n/a	n/a
Net Rupee Retention	99.43 %	n/a	n/a
No Of Broadband Subscribers	5.61 Lakh	n/a	n/a
Financials
5 yr Average ROE	8.56 %	295.24 %	23.02 %
5yr average Equity Multiplier	4.46	47.65	2.22
5yr Average Asset Turnover Ratio	0.38	0.86	0.5
5yr Avg Net Profit Margin	8.29 %	7.77 %	22.27 %
Price to Book	12.69	15.71	3.16
P/E	51.38	25.15	15.99
5yr Avg Cash Conversion Cycle	11.8 Days	63.23 Days	68.06 Days
Inventory Days	0.0	1.6 Days	0.02 Days
Days Receivable	11.8 Days	61.32 Days	67.97 Days
Days Payable	0.0	18.53 Days	16.02 Days
5yr Average Interest Coverage Ratio	2.34	4.82	5.81
5yr Avg ROCE	10.84 %	19.56 %	20.92 %
5yr Avg Operating Profit Margin	39.04 %	22.83 %	48.14 %
5 yr average Debt to Equity	1.63	21.8	0.24
5yr CAGR Net Profit	n/a	7.99 %	21.32 %
5yr Average Return on Assets	3.48 %	6.73 %	10.59 %
Shareholdings
Promoter Holding	70.0 %	58.86 %	51.03 %
Share Pledged by Promoters	0.0	0.0	0.0
Change in Promoter Holding (3 Yrs)	0.0	0.0	-17.97 %
Change in Mutual Fund Holding (3 Yrs)	0.33 %	6.53 %	13.48 %

	Bharti Hexacom Ltd.	Tata Communications	Indus Towers
Product Wise Break-Up	Product Wise Break-Up Mobile Services 96.22 Home & office services 3.78 0 IPL Lease 0 Ethernet 0 Internet connectivity 0 Global Virtual Private Network 0 Telecom Towers 0	Product Wise Break-Up Unified Communications and Collaboration (UCC) 6.39 Global Virtual Private Network 9.85 Mobile Services 0 IPL Lease 9.26 Internet 16.27 Telecom Towers 0 Ethernet 6.64 Home & office services 0 Others 51.59	Product Wise Break-Up 0 Global Virtual Private Network 0 Mobile Services 0 IPL Lease 0 Internet connectivity 0 Telecom Tower 100.0 Ethernet 0 Home & office services 0
Location Wise Break-Up	Location Wise Break-Up Domestic 99.85 India 0 Singapore 0 UK 0 South Africa 0 USA 0 Others 0.15	Location Wise Break-Up UK 8.04 Domestic 0 USA 21.09 South Africa 0 India 37.68 Singapore 5.09 Others 28.1	Location Wise Break-Up UK 0 Domestic 0 USA 0 South Africa 0 Indi 100.0 Singapore 0
Operating Profit Break-Up	Operating Profit Break-Up Mobile Services 99.8 Homes and Office Services 0.2 Real Estate 0 Transformation Services 0 Payment Solutions 0 Data Services 0 Voice Solutions 0	Operating Profit Break-Up Homes and Office Services 0 Payment Solutions 0 Voice Solutions 7.06 Mobile Services 0 Transformation Services 9.11 Real Estate 5.19 Data Services 63.37 Others 15.27	-
Capex - Segment Wise	Capex - Segment Wise Mobile Services 65.89 Home & office services 34.11	-	-