Bharti Hexacom Ltd.

Financial

	Bharti Hexacom Ltd.	Indus Towers	Vodafone Idea
Operational Metrics
Media & Entertainment
Churn Rate	2.4 %	n/a	n/a
Telecom Sector
No Of Mobile Subscribers	2.81 Crs	n/a	20.44 Crs
Monthly Data Usage Per User	29.4 GB/User	n/a	14.97 GB/User
No Of Data Subscribers	2.16 Crs	n/a	13.41 Crs
Average Revenue Per User (ARPU)	246.0 Rs	n/a	164.0 Rs
Average Revenue Per User (ARPU) - Broadband	485.0 Rs	n/a	n/a
Net Rupee Retention	99.25 %	n/a	96.51 %
No Of Broadband Subscribers	5.02 Lakh	n/a	1266.7 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.34	2.7	0.0
P/E	61.92	9.02	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 %	50.0 %	25.57 %
Share Pledged by Promoters	0.0	0.0	0.0
Change in Promoter Holding (3 Yrs)	0.0	-18.81 %	-49.42 %
Change in Mutual Fund Holding (3 Yrs)	0.22 %	12.61 %	2.62 %

Business

	Bharti Hexacom Ltd.	Indus Towers	Vodafone Idea
Product Wise Break-Up	Product Wise Break-Up Mobile Services 96.91 Home & office services 3.09 Telecom Towers 0 PI (Passive Infrastructure) 0 ILD (International Long Distance) 0 Mobility 0	Product Wise Break-Up Mobile Services 0 ILD (International Long Distance) 0 Mobility 0 PI (Passive Infrastructure) 0 Home & office services 0 Telecom Tower 100.0	Product Wise Break-Up Mobile Services 0 ILD (International Long Distance) 0 Mobility 100.0 PI (Passive Infrastructure) 0 Home & office services 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 98.09 Homes and Office Services 1.91	-	-
Capex - Segment Wise	Capex - Segment Wise Mobile Services 86.13 Home & office services 13.87	-	-