Bharti Airtel Ltd.

Financial

	Bharti Airtel	Vodafone Idea	Reliance Industries
Operational Metrics
Financial Services
Airtel Money - Monthly Transaction Value per Subscriber	278.0 $	n/a	n/a
Airtel Money - ARPU	2.0 $	n/a	n/a
Telecom Sector
Monthly Data Usage Per User	25.1 GB/User	14.97 GB/User	33.39 GB/User
Monthly Voice Minutes Per User	1163.0 Mins/User	598.0 Mins/User	1017.34 Mins/User
No Of Broadband Subscribers	2807.6 Lakh	1256.3 Lakh	4765.8 Lakh
Average Revenue Per User (ARPU) - Broadband	543.0 Rs	n/a	n/a
No Of Mobile Subscribers - Africa	16.61 Crs	n/a	n/a
ARPU - Africa	2.4 $	n/a	n/a
Monthly Churn rate - Africa	4.2 %	n/a	n/a
Monthly Churn rate - India	2.3 %	n/a	n/a
Blended Churn	2.83 %	4.1 %	1.8 %
Average Revenue Per User (ARPU)	245.0 Rs	164.0 Rs	206.2 Rs
Net Rupee Retention	97.7 %	96.51 %	98.2 %
No Of Mobile Subscribers	38.98 Crs	20.47 Crs	46.76 Crs
No Of Data Subscribers	28.12 Crs	13.41 Crs	48.82 Crs
Financials
5 yr Average ROE	-8.21 %	-200.95 %	8.33 %
5yr average Equity Multiplier	5.14	4.99	2.17
5yr Average Asset Turnover Ratio	0.32	0.21	0.48
5yr Avg Net Profit Margin	-7.67 %	-97.16 %	8.23 %
Price to Book	10.38	0.0	2.34
P/E	35.16	0.0	28.3
5yr Avg Cash Conversion Cycle	-3108.76 Days	18.73 Days	-37.01 Days
Inventory Days	0.78 Days	0.04 Days	47.09 Days
Days Receivable	10.6 Days	18.65 Days	10.96 Days
Days Payable	4591.96 Days	0.0	103.94 Days
5yr Average Interest Coverage Ratio	0.59	-1.04	5.0
5yr Avg ROCE	9.73 %	-4.92 %	8.81 %
5yr Avg Operating Profit Margin	47.61 %	38.85 %	16.33 %
5 yr average Debt to Equity	1.94	1.35	0.46
5yr CAGR Net Profit	n/a	-15.82 %	12.09 %
5yr Average Return on Assets	-1.86 %	-19.98 %	3.85 %
Shareholdings
Promoter Holding	52.42 %	38.8 %	50.11 %
Share Pledged by Promoters	0.0	0.0	0.0
Change in Promoter Holding (3 Yrs)	-3.51 %	-36.19 %	-0.55 %
Change in Mutual Fund Holding (3 Yrs)	-0.71 %	3.09 %	4.02 %

Business

	Bharti Airtel	Vodafone Idea	Reliance Industries
Product Wise Break-Up	Product Wise Break-Up Mobile 70.99 Passive Infrastructure Services 14.5 Business 9.93 Home 2.98 Digital TV 1.43 PI (Passive Infrastructure) 0 ILD (International Long Distance) 0 Mobility 0 Oil to Chemicals 0 Financial Services 0 Media & Entertainment 0 Digital Services 0 Organized Retail 0 Oil and Gas 0 Petrochemicals 0 Refining 0 Others 0.17	Product Wise Break-Up Passive Infrastructure Services 0 Business 0 Mobility 100.0 Mobile 0 Media & Entertainment 0 Digital Services 0 ILD (International Long Distance) 0 Petrochemicals 0 Refining 0 Organized Retail 0 Home 0 Financial Services 0 Digital TV 0 PI (Passive Infrastructure) 0 Oil to Chemicals 0 Oil and Gas 0	Product Wise Break-Up Passive Infrastructure Services 0 Business 0 Mobility 0 Mobile 0 Media & Entertainment 0 Digital services 12.75 ILD (International Long Distance) 0 Petrochemicals 0 Refining 0 Organized Retail 27.66 Home 0 Financial Services 0 Digital TV 0 PI (Passive Infrastructure) 0 Oil to Chemicals 51.37 Oil & Gas 2.01 Others 6.21
Location Wise Break-Up	Location Wise Break-Up India 70.06 Africa 29.94 South Asia 0 Rest of the World 0	-	Location Wise Break-Up Rest of the World 35.02 South Asia 0 India 64.98 Africa 0
Operating Profit Break-Up	Operating Profit Break-Up Financial Services 0 Digital Services 0 Organised Retail 0 Petrochemicals 0 Refining 0 Oil & Gas 0 Oil to Chemicals 0 Others 100	-	Operating Profit Break-Up Refining 0 Oil & Gas 11.02 Digital services 37.18 Petrochemicals 0 Organized Retail 14.46 Financial Services 0 Oil to Chemicals 32.45 Others 4.89
Asset Break-Up	Asset Break-Up India 0 Others 100	-	Asset Break-Up India 97.78 Others 2.22

Bharti Airtel Ltd.

SIGN UP FOR FREE