Bharti Airtel

1. BHARTI Rohit Parkar 13055 eMBA

2. INDEX Sr. No. Particulars 1 History 2 Brand History 3 New Highlights 4 Achievements 5 Management Teams 6 Product & Service offered 7 International Operations 8 Shareholding Patterns 9 Competitors 10 Capital Structures 11 Top Sellers & Buyers 12 Future Plan 13 Position and Ranking

3. HISTORY OF BHARTI AIRTEL Bharti Airtel formely known as Bharti Tele-Ventures LTD (BTVL). Bharti Airtel was founded in July 07, 1995 by Sunil Bharti Mittal. Bharti Airtel is the largest cellular service provider in India, with more than 261 million subscriber across 20 countries as of August 2012.

4. Brand History Bharti group was established in 1983 by Sunil Mittal . In 1986 Bharti telecom was incorporated, first company to push button telephones. In early 90’s country’s first Fax machine and cordless phones were launched by BTL. In 1992, Sunil Mittal won a bid to set up a cellular network in Delhi.

5. New Highlights Bharti Airtel Launches Cloud Enablement Platform powered by HP. Airtel Rising Stars’ to bring alive young India’s soccer dreams. Bharti and Qualcomm announce partnership for 4G. Bharti airtel to observe Silent period from 30 th June 2012. Bharti Airtel acquired Zain South Africa.

6. Sunil Bharti Mittal Founder, chairman and group CEO of Bharti Enterprises. Sunil Bharti Mittal is an Indian telecom Mogul, philanthropist. Son of Sat Paul (Former MP) and Lalita . Padma Bhushan in 2007, from the President of India. India’s third highest civilian honour.

7. Achievements Airtel wins top honours at the 7th Frost & Sullivan ICT Awards 2008 . Bharti Airtel hs been awarded the 'Best Cellular Service Provider' and 'Best Broadband Service Provider' at the 2008 V&D 100 Awards. Bharti Airtel has been voted as India 's most innovative company , in a survey conducted by The Wall Street Journal. Airtel has been voted the 2nd Most Trusted Service Brand in the Annual Economic Times-Brand Equity, Most Trusted Brands survey. Airtel   bagged 'Wireless Service Provider of the Year' award at the 2008 Frost & Sullivan Asia Pacific ICT Awards. Bharti Airtel has received the prestigious Businessworld -FICCI-SEDF Corporate Social Responsibility Award 2009-2010.

8. Sr. No. Key People Designation 1 Sunil Bharti Mittal Chairman 2 Manoj Kohli Managing Director 3 Sanjay Kapoor Chief Executive Officer 4 Sarvjit Singh Dhillon Chief Financial Officer 5 Girish Mehta Chief Marketing Officer 6 Shankar Halder Chief Technology Officer 7 Alexander Andrew President 8 Argha Basu Vice President 9 Mukesh Bhavnani Secretary Management Team

9. Products and services offered by the company Mobile Prepaid Postpaid Broadband & Internet Speed on demand Airtel PC secure Airtel Net PC IPTV Digital TV

10. Data and IP Solutions Wireless Internet Data Card USB Modem Email on the go Windows Mobile 5.0 Airtel Easy Mail Calling Cards  International Calling Cards Airtel Call Home Airtel World Calling Cards Voice SolutionsConferencing

11. Airtel as a Brand There is an amazing consistency in the manner in which AIRTEL has over the two years emerged as the countries top 2 nd service brand in the Most Trusted Brands Survey. Brand ambassadors: - Sharukh Khan - A.R.Rehman - Vidya Balan - Madhavan - Sachin (Currently Dropped)

12. Countering The Threat Advertising Strategy - Kuch Bandhan atoot hote hain ....’ - Barriers break when people talk’ - Har eak friend zaruri hota hai .’

13. Subscriber Base Bharti Airtel has about 230.8 million subscribers Worldwide. 169.18 million in India. 46 million in Africa. 4 million in Bangladesh. 1.8 million in Sri Lanka.

14. International Operations Africa Airtel Africa is a subsidiary of Indian telecommunications company Airtel , that operates in 17 countries across Africa. BhartiAirtel completed its $9 billion acquisition of African operations from Kuwait's Zain , making the firm the world's No. 5 wireless carrier by subscribers. The company has over 57% share of the mobile market of Seychelles. Airtel has reported that its revenues for the fourth quarter of 2010 grew by 53% to US$3.2 billion compared to the previous year, newly acquired Zain Africa division contributed US$911 million to the total. However, net profits dropped by 41% from US$470 million last year to US$291 million this year due to a US$188 million increase in radio spectrum charges in India and an increase of US$106 million in debt interest.

15. Sri Lanka Bharti Airtel Lanka ( Pvt ) Ltd is a subsidiary of Bharti Airtel Limited, the third largest mobile operator in the world , with over 240 million mobile customers as of December 2011. Airtel Lanka commenced commercial operations of services on 13 January 2009. All of these services are provided under the airtel brand. Net income - US$402.2 million (2010) .

16. Bangladesh Airtel Bangladesh Ltd. is a GSM-based cellular operator in Bangladesh. Airtel is the sixth mobile phone carrier to enter the Bangladesh market, and originally launched commercial operations under the brand name " Warid Telecom" on 10 May 2007. Net income - 18.282 billion (US$300 million) (2010) .

17. Metro City Subscribers (INDIA)

18. Telecom Operators in India

19. Shareholding Pattern (in %)

20. Bharti Airtel Competitors Sr. No. Company Symbol 1 Idea Cellular Ltd. IDECEL 2 Mahanagar Telephone Nigam Ltd. MAHATE 3 Nettlinx Ltd. NETTLT 4 OnMobile Global Ltd. ONMGLO 5 Quadrant Televentures Ltd. HFCINF 6 Reliance Communications Ltd. RELCOL 7 Spice Communications Ltd. [Merged] SPICOM 8 Tata Communications Ltd. VIDSAN 9 Tata Teleservices (Maharashtra) Ltd. TAT182

21. Comparison(NSE ) Company Current Price Change (%Chg) TODAY Low / High EPS PE Bharti Airtel Ltd. 288.65 1.55 (0.54%) 285.10 / 289.90 73.6131 12.75 Reliance Communications Ltd. 112.20 - 0.10 (-0.09%) 111.90 / 113.50 37.11 3.02

22. Capital Structure Period Instrument Authorized Capital Issued Capital - P A I D U P - From To   (Rs. cr ) (Rs. cr) Shares (no's) Face Value Capital (Rs. Cr) 2012 2013 Equity Share 2500.0 1898.8 3797530096 5.0 1898.8 2011 2012 Equity Share 2500.0 1898.8 3797530096 5.0 1898.8 2010 2011 Equity Share 2500.0 1898.8 3797530096 5.0 1898.8 2009 2010 Equity Share 2500.0 1898.8 3797530096 5.0 1898.8 2008 2009 Equity Share 2500.0 1898.2 1898239796 10.0 1898.2

23. Current Ratio (2:1)

24. Liquid Ratio (1:1)

25. Cash Ratio

26. Debt Equity Ratio

27. Proprietory Ratio (In %)

28. Total Asset to Debt Ratio (in %)

29. Debtors Turnover

30. Gross Profit Margin (in %)

31. Operating Ratio (in %)

32. Net Profit Margin (in %)

33. Profit After Tax (in Cr.)

34. Profit Before Tax (in Cr.)

35. EBIDTA (in Cr.)

36. Return on Equity (in %)

37. Net Sales of TOP COMPANIES Company Name Last Price Change % Change Net Sales (Rs. cr) Bharti Airtel 290.00 2.90 1.01 45,350.90 Idea Cellular 126.75 -0.55 -0.43 22,043.44 Reliance Comm 110.15 -2.15 -1.91 12,135.00 Tata Comm 279.25 1.45 0.52 4,091.77 MTNL 14.25 0.10 0.71 3,428.66

38. Positions and Rankings