Vodafone Idea Ltd

About

Vodafone Idea is one of the leading telecom service providers in India. The Company is engaged in the business of Mobility and Long Distance services, trading of handsets and data cards.[1]

Key Points

Business Areas
The company's business services include voice business/ services, broadband services, content services, enterprise services and other VAS offerings like entertainment, SMS, Utility, etc.[1]

See full details
  • Market Cap 33,046 Cr.
  • Current Price 11.5
  • High / Low 13.8 / 4.55
  • Stock P/E
  • Book Value -13.3
  • Dividend Yield 0.00 %
  • ROCE -51.7 %
  • ROE %
  • Face Value 10.0

Pros

Cons

  • Company has low interest coverage ratio.
  • The company has delivered a poor sales growth of 3.14% over past five years.
  • Company's cost of borrowing seems high
Loading peers table ...

Quarterly Results

Consolidated Figures in Rs. Crores / View Standalone

Sep 2018 Dec 2018 Mar 2019 Jun 2019 Sep 2019 Dec 2019 Mar 2020 Jun 2020 Sep 2020 Dec 2020 Mar 2021 Jun 2021
7,664 11,765 11,775 11,270 10,844 11,089 11,755 10,659 10,791 10,894 9,608 9,152
7,202 10,602 9,960 7,554 7,448 7,669 7,374 6,561 6,639 6,608 5,199 5,445
Operating Profit 461 1,163 1,815 3,716 3,396 3,420 4,380 4,098 4,152 4,286 4,408 3,708
OPM % 6% 10% 15% 33% 31% 31% 37% 38% 38% 39% 46% 41%
Other Income -308 -543 -934 -469 -30,343 -242 -5,907 -19,779 -642 1,793 -934 212
Interest 2,166 2,851 2,976 3,790 3,703 3,722 4,177 3,804 4,700 4,787 4,707 5,228
Depreciation 3,006 4,773 4,664 6,131 6,309 5,877 6,039 5,976 6,029 5,824 5,810 6,010
Profit before tax -5,019 -7,004 -6,759 -6,674 -36,959 -6,421 -11,743 -25,460 -7,218 -4,532 -7,042 -7,319
Tax % 1% 29% 28% 27% -38% -0% 1% 0% 0% 0% 0% -0%
Net Profit -4,974 -5,005 -4,882 -4,874 -50,922 -6,439 -11,644 -25,460 -7,218 -4,532 -7,023 -7,319
EPS in Rs -1.73 -1.74 -1.70 -1.70 -17.72 -2.24 -4.05 -8.86 -2.51 -1.58 -2.44 -2.55

Profit & Loss

Consolidated Figures in Rs. Crores / View Standalone

Mar 2010 Mar 2011 Mar 2012 Mar 2013 Mar 2014 Mar 2015 Mar 2016 Mar 2017 Mar 2018 Mar 2019 Mar 2020 Mar 2021 TTM
12,398 15,438 19,489 22,407 26,519 31,571 35,949 35,576 28,279 37,092 44,958 41,952 40,445
9,231 11,680 14,440 16,439 18,237 20,771 24,281 25,348 22,224 32,976 30,042 25,006 23,890
Operating Profit 3,167 3,758 5,048 5,969 8,282 10,800 11,668 10,227 6,054 4,116 14,916 16,946 16,555
OPM % 26% 24% 26% 27% 31% 34% 32% 29% 21% 11% 33% 40% 41%
Other Income 614 160 44 131 247 497 641 746 703 1,789 -36,964 -19,563 429
Interest 691 524 1,056 1,045 966 1,060 1,803 4,010 4,847 9,545 15,393 17,998 19,423
Depreciation 2,015 2,397 2,981 3,478 4,519 5,304 6,256 7,827 8,409 14,536 24,356 23,638 23,673
Profit before tax 1,075 997 1,055 1,577 3,044 4,933 4,250 -863 -6,499 -18,175 -61,797 -44,253 -26,112
Tax % 11% 10% 31% 36% 35% 35% 36% 54% 36% 20% -20% 0%
Net Profit 954 899 723 1,011 1,968 3,193 2,728 -400 -4,168 -14,604 -73,878 -44,233 -26,092
EPS in Rs 0.88 0.83 0.66 0.93 1.80 2.70 2.30 -0.34 -2.91 -5.08 -25.71 -15.39 -9.08
Dividend Payout % 0% 0% 0% 10% 7% 7% 8% 0% 0% 0% 0% 0%
Compounded Sales Growth
10 Years:11%
5 Years:3%
3 Years:14%
TTM:-9%
Compounded Profit Growth
10 Years:%
5 Years:%
3 Years:%
TTM:46%
Stock Price CAGR
10 Years:-15%
5 Years:-25%
3 Years:-21%
1 Year:12%
Return on Equity
10 Years:%
5 Years:%
3 Years:%
Last Year:%

Balance Sheet

Consolidated Figures in Rs. Crores / View Standalone

Mar 2010 Mar 2011 Mar 2012 Mar 2013 Mar 2014 Mar 2015 Mar 2016 Mar 2017 Mar 2018 Mar 2019 Mar 2020 Mar 2021
3,302 3,305 3,311 3,316 3,322 3,598 3,601 3,605 4,359 8,736 28,735 28,735
Reserves 8,026 8,995 9,739 10,989 13,205 19,429 19,950 21,127 22,903 50,899 -22,756 -66,963
Borrowings 7,859 12,070 13,337 14,044 20,635 26,859 40,541 55,055 57,985 125,940 27,343 29,379
4,329 5,843 6,250 8,031 9,397 10,580 16,034 16,881 13,264 44,078 193,595 212,327
Total Liabilities 23,514 30,212 32,635 36,378 46,557 60,467 80,126 96,668 98,511 229,652 226,918 203,478
18,174 22,491 26,994 29,160 29,602 35,540 65,190 76,763 79,692 177,800 185,836 167,490
CWIP 546 3,601 680 881 11,419 5,141 6,040 7,535 3,585 5,103 1,138 606
Investments 1,130 1,020 98 1,028 216 11,527 3,471 6,378 7,290 8,239 1,979 4
3,663 3,100 4,864 5,309 5,321 8,260 5,425 5,991 7,944 38,511 37,964 35,378
Total Assets 23,514 30,212 32,635 36,378 46,557 60,467 80,126 96,668 98,511 229,652 226,918 203,478

Cash Flows

Consolidated Figures in Rs. Crores / View Standalone

Mar 2010 Mar 2011 Mar 2012 Mar 2013 Mar 2014 Mar 2015 Mar 2016 Mar 2017 Mar 2018 Mar 2019 Mar 2020 Mar 2021
2,542 5,093 3,818 6,297 8,219 10,418 10,949 10,476 5,332 5,348 7,328 15,640
-2,937 -8,359 -4,685 -3,411 -6,565 -5,726 -2,389 -15,556 -9,303 -1,640 -2,698 1,075
-2,401 3,345 -361 -1,965 -2,466 8,028 -9,330 4,506 3,925 -2,949 -5,019 -16,731
Net Cash Flow -2,796 79 -1,228 921 -811 12,720 -770 -574 -46 758 -389 -17

Ratios

Consolidated Figures in Rs. Crores / View Standalone

Mar 2010 Mar 2011 Mar 2012 Mar 2013 Mar 2014 Mar 2015 Mar 2016 Mar 2017 Mar 2018 Mar 2019 Mar 2020 Mar 2021
Debtor Days 14 13 15 16 11 11 12 13 11 32 25 22
Inventory Days
Days Payable
Cash Conversion Cycle 14 13 15 16 11 11 12 13 11 32 25 22
Working Capital Days -20 -81 -44 -60 -56 -55 -87 -113 -78 -218 -516 -275
ROCE % 8% 7% 8% 10% 12% 14% 11% 4% -2% -8% -8% -52%

Shareholding Pattern

Numbers in percentages

Sep 2018 Dec 2018 Mar 2019 Jun 2019 Sep 2019 Dec 2019 Mar 2020 Jun 2020 Sep 2020 Dec 2020 Mar 2021 Jun 2021
71.33 71.33 71.33 71.57 72.05 72.05 72.05 72.05 72.05 72.05 72.05 72.05
12.35 12.81 13.13 15.67 14.61 12.52 8.82 7.19 6.20 6.08 4.60 4.29
6.09 5.63 4.47 7.15 6.50 7.78 6.01 3.63 0.91 1.39 1.07 1.30
10.23 10.24 11.08 5.61 6.84 7.65 13.12 17.13 20.84 20.48 22.28 22.36

Documents