Bharti Hexacom Ltd.

Financial

	Bharti Hexacom Ltd.	Vodafone Idea	Indus Towers
Operational Metrics
Media & Entertainment
Churn Rate	1.9 %	n/a	n/a
Telecom Sector
No Of Mobile Subscribers	2.76 Crs	20.73 Crs	n/a
Monthly Data Usage Per User	26.2 GB/User	14.21 GB/User	n/a
No Of Data Subscribers	2.1 Crs	13.42 Crs	n/a
Average Revenue Per User (ARPU)	241.0 Rs	163.0 Rs	n/a
Average Revenue Per User (ARPU) - Broadband	499.0 Rs	n/a	n/a
Net Rupee Retention	103.8 %	99.99 %	n/a
No Of Broadband Subscribers	3.95 Lakh	1263.7 Lakh	n/a
Financials
5 yr Average ROE	-14.47 %	-200.95 %	21.78 %
5yr average Equity Multiplier	4.8	4.99	2.13
5yr Average Asset Turnover Ratio	0.34	0.21	0.48
5yr Avg Net Profit Margin	-9.23 %	-97.16 %	25.46 %
Price to Book	14.04	0.0	3.25
P/E	55.75	0.0	10.63
5yr Avg Cash Conversion Cycle	15.28 Days	18.73 Days	72.23 Days
Inventory Days	0.0	0.04 Days	0.0
Days Receivable	15.28 Days	18.65 Days	72.23 Days
Days Payable	0.0	0.0	32.44 Days
5yr Average Interest Coverage Ratio	0.5	-1.04	6.65
5yr Avg ROCE	3.59 %	-4.92 %	18.77 %
5yr Avg Operating Profit Margin	31.67 %	38.85 %	48.38 %
5 yr average Debt to Equity	1.85	1.35	0.26
5yr CAGR Net Profit	n/a	-15.82 %	12.85 %
5yr Average Return on Assets	-1.97 %	-19.98 %	10.81 %
Shareholdings
Promoter Holding	70.0 %	38.8 %	50.0 %
Share Pledged by Promoters	0.0	0.0	0.0
Change in Promoter Holding (3 Yrs)	0.0	-36.19 %	-17.49 %
Change in Mutual Fund Holding (3 Yrs)	0.45 %	3.09 %	12.99 %

Business

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