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	36.61 GB/User
Monthly Voice Minutes Per User	1163.0 Mins/User	598.0 Mins/User	997.12 Mins/User
No Of Broadband Subscribers	2807.6 Lakh	1266.7 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	208.8 Rs
Net Rupee Retention	97.7 %	96.51 %	99.46 %
No Of Mobile Subscribers	38.98 Crs	20.44 Crs	46.76 Crs
No Of Data Subscribers	28.12 Crs	13.41 Crs	49.81 Crs
Financials
5 yr Average ROE	6.04 %	53.92 %	8.33 %
5yr average Equity Multiplier	5.14	-3.17	2.17
5yr Average Asset Turnover Ratio	0.34	0.21	0.48
5yr Avg Net Profit Margin	3.81 %	-76.87 %	8.23 %
Price to Book	10.27	0.0	2.26
P/E	34.78	0.0	23.43
5yr Avg Cash Conversion Cycle	-5727.99 Days	17.58 Days	-37.01 Days
Inventory Days	0.84 Days	0.04 Days	47.09 Days
Days Receivable	12.85 Days	17.57 Days	10.96 Days
Days Payable	4312.74 Days	0.0	103.94 Days
5yr Average Interest Coverage Ratio	1.6	-0.46	5.0
5yr Avg ROCE	12.05 %	-4.06 %	8.81 %
5yr Avg Operating Profit Margin	50.28 %	40.57 %	16.33 %
5 yr average Debt to Equity	1.9	-3.06	0.46
5yr CAGR Net Profit	n/a	-9.15 %	12.09 %
5yr Average Return on Assets	1.44 %	-16.23 %	3.85 %
Shareholdings
Promoter Holding	51.25 %	25.57 %	50.07 %
Share Pledged by Promoters	0.0	0.0	0.0
Change in Promoter Holding (3 Yrs)	-4.68 %	-49.42 %	-0.55 %
Change in Mutual Fund Holding (3 Yrs)	-1.05 %	2.62 %	3.68 %

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 Media & Entertainment 0 Digital Services 0 Petrochemicals 0 Passive Infrastructure Services 0 Digital TV 0 Oil to Chemicals 0 Oil and Gas 0 Mobile 0 Mobility 100.0 Financial Services 0 ILD (International Long Distance) 0 Business 0 Home 0 Organized Retail 0 Refining 0 PI (Passive Infrastructure) 0	Product Wise Break-Up Media & Entertainment 0 Digital services 13.73 Petrochemicals 0 Passive Infrastructure Services 0 Digital TV 0 Oil to Chemicals 50.67 Oil & Gas 2.0 Mobile 0 Mobility 0 Financial Services 0 ILD (International Long Distance) 0 Business 0 Home 0 Organized Retail 27.55 Refining 0 PI (Passive Infrastructure) 0 Others 6.05
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 Africa 0 India 64.98 South Asia 0 Rest of the World 35.02
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 Digital services 39.14 Organized Retail 13.64 Petrochemicals 0 Oil & Gas 10.68 Oil to Chemicals 31.01 Financial Services 0 Refining 0 Others 5.53
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