Nifty
Sensex
:
:
10791.55
35929.64
53.95 (0.50%)
150.57 (0.42%)

Telecommunication - Service Provider

Rating :
36/99

BSE: 532822 | NSE: IDEA

34.90
0.25 (0.72%)
13-Dec-2018 | 3:59PM
  • Day's Open
  • Day's High
  • Day's Low
  • Previous Close
  •  34.90
  •  35.80
  •  34.70
  •  34.65
  • Volume
  • Traded Value (lacs)
  • 52 Week High
  • 52 Week Low
  •  19399454
  •  6770.41
  •  118.90
  •  32.00

Stock Summary

  • Market Cap(Crs)
  • Stock P:E
  • Face Value
  • 30,224.44
  • N/A
  • 10
  • Enterprise Value(Crs)
  • Dividend Yield
  • Price:Book Value
  • 88,180.44
  • N/A
  • 0.43

Shareholding Pattern

  • Promoter
  • Corporate
  • Public
  • 71.33%
  • 0.31%
  • 1.54%
  • FII
  • DII
  • Others
  • 0.05%
  • 6.03%
  • 20.74%

Chart

Price | P:E | P:BV | EV:EBITDA

Revenue CAGR (%)

  • 10 Years
  • 5 Years
  • 3 Years
  • 10.81
  • 1.29
  • -7.69

EBITDA CAGR (%)

  • 10 Years
  • 5 Years
  • 3 Years
  • 8.18
  • -6.05
  • -12.30

PAT CAGR (%)

  • 10 Years
  • 5 Years
  • 3 Years
  • -
  • -
  • -

P:E (Median)

  • 8 Years
  • 5 Years
  • 3 Years
  • 23.09
  • 15.46
  • -

P:BV (Average)

  • 8 Years
  • 5 Years
  • 3 Years
  • 2.07
  • 1.82
  • 1.26

EV:EBITDA (Average)

  • 8 Years
  • 5 Years
  • 3 Years
  • 8.50
  • 8.40
  • 8.89

Quarterly Results

Consolidated Figures in Rs. Crores /

Standalone
Description
Sep 18
Sep 17
Var%
Jun 18
Jun 17
Var%
Mar 18
Mar 17
Var%
Dec 17
Dec 16
Var%
Net Sales
7,663.50
7,465.50
2.65%
5,889.20
8,166.50
-27.89%
6,137.30
8,126.10
-24.47%
6,509.60
8,662.70
-24.85%
Expenses
7,202.10
5,963.90
20.76%
5,229.80
6,291.10
-16.87%
4,690.20
6,006.20
-21.91%
5,286.20
6,471.10
-18.31%
EBITDA
461.40
1,501.60
-69.27%
659.40
1,875.40
-64.84%
1,447.10
2,119.90
-31.74%
1,223.40
2,191.60
-44.18%
EBIDTM
6.02%
20.11%
11.20%
22.96%
23.58%
26.09%
18.79%
25.30%
Other Income
215.10
45.40
373.79%
141.40
15.20
830.26%
250.40
68.40
266.08%
42.00
43.60
-3.67%
Interest
2,166.20
1,228.30
76.36%
1,525.80
1,169.10
30.51%
1,224.60
1,005.00
21.85%
1,191.00
993.10
19.93%
Depreciation
3,005.90
2,114.30
42.17%
2,092.40
2,067.90
1.18%
2,085.40
1,988.50
4.87%
2,141.50
1,965.20
8.97%
PBT
-5,061.40
-1,795.60
-
547.10
-1,346.40
-
-1,612.50
-805.20
-
-2,067.10
-723.10
-
Tax
-45.30
-604.70
-
350.40
-449.70
-
-575.80
-379.20
-
-700.80
-224.80
-
PAT
-5,016.10
-1,190.90
-
196.70
-896.70
-
-1,036.70
-426.00
-
-1,366.30
-498.30
-
PATM
-65.45%
-15.95%
3.34%
-10.98%
-16.89%
-5.24%
-20.99%
-5.75%
EPS
-5.69
-3.07
-
0.59
-2.26
-
-2.21
-0.91
-
-3.56
-1.07
-

Annual Results

Consolidated Figures in Rs. Crores /

Standalone
Description
TTM
Mar 18
Mar 17
Mar 16
Mar 15
Mar 14
Mar 13
Mar 12
Mar 11
Mar 10
Mar 09
Net Sales
26,199.60
28,278.94
35,575.74
35,949.41
31,570.89
26,518.90
22,407.44
19,488.69
15,438.40
12,397.88
10,131.28
Net Sales Growth
-19.19%
-20.51%
-1.04%
13.87%
19.05%
18.35%
14.98%
26.24%
24.52%
22.37%
 
Cost Of Goods Sold
4.10
7.26
27.92
28.90
145.16
192.70
231.84
141.37
41.22
30.48
14.79
Gross Profit
26,195.50
28,271.68
35,547.82
35,920.51
31,425.72
26,326.21
22,175.61
19,347.31
15,397.17
12,367.40
10,116.50
GP Margin
99.98%
99.97%
99.92%
99.92%
99.54%
99.27%
98.97%
99.27%
99.73%
99.75%
99.85%
Total Expenditure
22,408.30
22,224.44
25,348.28
24,281.22
20,771.19
18,248.46
16,444.16
14,441.45
11,704.80
9,146.49
7,371.95
Power & Fuel Cost
-
3,113.98
3,118.74
2,577.72
2,458.96
2,317.44
1,949.94
1,605.92
1,451.42
1,138.35
574.92
% Of Sales
-
11.01%
8.77%
7.17%
7.79%
8.74%
8.70%
8.24%
9.40%
9.18%
5.67%
Employee Cost
-
1,543.04
1,797.64
1,611.85
1,529.87
1,312.12
1,122.53
949.92
805.55
638.97
519.56
% Of Sales
-
5.46%
5.05%
4.48%
4.85%
4.95%
5.01%
4.87%
5.22%
5.15%
5.13%
Manufacturing Exp.
-
13,303.49
16,225.40
15,809.57
13,253.80
11,512.10
10,327.17
9,120.63
7,228.35
5,463.10
4,748.38
% Of Sales
-
47.04%
45.61%
43.98%
41.98%
43.41%
46.09%
46.80%
46.82%
44.06%
46.87%
General & Admin Exp.
-
424.83
451.81
398.06
382.54
337.50
288.01
265.13
237.31
204.43
179.75
% Of Sales
-
1.50%
1.27%
1.11%
1.21%
1.27%
1.29%
1.36%
1.54%
1.65%
1.77%
Selling & Distn. Exp.
-
3,473.25
3,284.15
3,175.71
2,729.28
2,319.70
2,350.24
2,225.24
1,812.70
1,441.27
1,185.01
% Of Sales
-
12.28%
9.23%
8.83%
8.64%
8.75%
10.49%
11.42%
11.74%
11.63%
11.70%
Miscellaneous Exp.
-
358.59
442.62
679.41
271.56
256.89
174.43
133.24
128.25
229.89
1,185.01
% Of Sales
-
1.27%
1.24%
1.89%
0.86%
0.97%
0.78%
0.68%
0.83%
1.85%
1.48%
EBITDA
3,791.30
6,054.50
10,227.46
11,668.19
10,799.70
8,270.44
5,963.28
5,047.24
3,733.60
3,251.39
2,759.33
EBITDA Margin
14.47%
21.41%
28.75%
32.46%
34.21%
31.19%
26.61%
25.90%
24.18%
26.23%
27.24%
Other Income
648.90
486.10
357.18
219.51
496.67
258.80
136.34
95.10
176.60
529.49
516.33
Interest
6,107.60
4,953.08
4,042.49
1,803.18
1,060.21
965.59
1,044.53
1,105.73
516.00
690.63
933.74
Depreciation
9,325.20
8,409.10
7,827.20
6,256.07
5,303.62
4,519.40
3,477.76
2,981.34
2,397.34
2,014.91
1,402.79
PBT
-8,193.90
-6,821.58
-1,285.06
3,828.45
4,932.53
3,044.26
1,577.32
1,055.27
996.86
1,075.35
939.13
Tax
-971.50
-2,331.07
-463.54
1,521.99
1,739.63
1,076.44
566.40
332.29
98.15
121.41
57.55
Tax Rate
11.86%
34.17%
36.07%
39.75%
35.27%
35.36%
35.91%
31.49%
9.85%
11.29%
6.13%
PAT
-7,222.40
-4,490.51
-821.52
2,306.45
3,192.91
1,967.82
1,010.93
722.99
898.71
953.94
881.58
PAT before Minority Interest
-7,222.40
-4,490.51
-821.52
2,306.45
3,192.91
1,967.82
1,010.93
722.99
898.71
953.94
881.58
Minority Interest
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
PAT Margin
-27.57%
-15.88%
-2.31%
6.42%
10.11%
7.42%
4.51%
3.71%
5.82%
7.69%
8.70%
PAT Growth
0.00%
-
-
-27.76%
62.26%
94.65%
39.83%
-19.55%
-5.79%
8.21%
 
Unadjusted EPS
-10.87
-11.36
-1.23
7.42
9.03
5.93
3.05
2.19
2.72
3.07
3.01

Results Balance Sheet

Consolidated Figures in Rs. Crores /

Standalone
Description
Mar 18
Mar 17
Mar 16
Mar 15
Mar 14
Mar 13
Mar 12
Mar 11
Mar 10
Mar 09
Shareholder's Funds
27,262.46
24,732.24
23,550.49
23,029.24
16,526.97
14,305.29
13,050.22
12,299.93
11,372.35
13,265.31
Share Capital
4,359.32
3,605.33
3,600.51
3,599.77
3,321.56
3,316.25
3,310.77
3,305.20
3,301.76
3,102.02
Total Reserves
22,822.94
20,992.78
19,814.75
19,386.32
13,189.05
10,967.62
9,704.50
8,946.93
8,026.15
10,145.06
Non-Current Liabilities
59,278.61
54,874.10
40,986.29
20,041.50
21,363.19
14,031.57
10,947.29
9,710.28
8,073.50
9,025.23
Secured Loans
9,394.73
7,856.92
3,859.86
6,778.82
8,277.64
9,163.00
7,997.60
7,996.17
7,316.62
6,545.20
Unsecured Loans
47,546.07
43,780.90
32,044.18
9,824.36
9,850.77
2,641.71
1,524.55
998.59
542.68
2,367.03
Long Term Provisions
310.75
384.23
345.39
573.51
498.60
314.21
192.04
170.95
0.00
0.00
Current Liabilities
10,830.93
17,061.46
15,588.73
17,396.07
8,667.29
8,041.21
8,637.67
8,201.46
4,067.98
4,036.11
Trade Payables
3,547.91
4,077.67
3,247.13
3,097.39
2,788.00
2,687.10
2,184.04
3,577.96
2,413.44
2,596.52
Other Current Liabilities
7,238.96
12,929.22
10,603.38
13,789.24
5,044.44
4,770.73
4,718.82
2,826.40
1,431.27
1,267.15
Short Term Borrowings
21.69
34.71
1,645.58
207.30
647.16
458.53
1,727.53
1,790.39
0.00
0.00
Short Term Provisions
22.37
19.86
92.64
302.13
187.69
124.85
7.27
6.71
223.26
172.44
Total Liabilities
97,372.00
96,667.80
80,125.51
60,466.81
46,557.45
36,378.07
32,635.18
30,211.67
23,513.83
26,326.65
Net Block
79,691.91
76,763.24
65,190.16
35,539.73
29,601.97
29,160.03
26,993.78
22,491.01
18,173.98
16,772.08
Gross Block
101,496.91
90,689.96
71,359.33
61,826.81
51,225.73
46,611.07
41,097.81
33,703.79
27,064.65
22,769.16
Accumulated Depreciation
21,805.00
13,926.72
6,169.17
26,287.08
21,623.77
17,451.04
14,104.02
11,212.78
8,890.67
5,997.08
Non Current Assets
87,137.45
89,035.27
75,628.59
45,001.26
44,063.28
33,089.03
29,929.91
27,013.32
18,720.45
18,912.97
Capital Work in Progress
3,585.29
7,535.10
6,039.73
5,140.53
11,419.41
881.08
679.85
3,600.55
546.47
2,140.86
Non Current Investment
1,660.11
1,478.47
2,140.45
0.00
0.00
0.00
0.00
0.00
0.00
0.02
Long Term Loans & Adv.
2,096.39
1,914.17
1,422.04
4,275.19
2,897.07
3,047.92
2,256.27
921.75
0.00
0.00
Other Non Current Assets
103.75
1,344.29
836.21
45.80
144.84
0.00
0.00
0.00
0.00
0.00
Current Assets
10,234.56
7,632.52
4,496.91
15,465.56
2,494.17
3,289.04
2,705.27
3,198.35
4,793.38
7,413.69
Current Investments
5,630.43
4,899.75
1,330.46
11,526.73
215.53
1,028.02
97.60
1,020.00
1,130.37
2,045.17
Inventories
36.66
58.80
106.54
71.03
68.31
72.64
92.57
65.92
53.63
52.13
Sundry Debtors
887.39
1,313.92
1,142.35
978.91
800.62
960.08
822.70
555.71
465.56
361.79
Cash & Bank
29.13
82.74
769.13
1,553.72
188.10
142.91
152.07
457.74
289.99
3,086.40
Other Current Assets
3,650.95
1,232.84
1,051.02
447.71
1,221.61
1,085.40
1,540.34
1,098.98
2,853.84
1,868.21
Short Term Loans & Adv.
2,416.66
44.47
97.40
887.45
870.55
726.36
1,538.57
1,098.17
2,466.92
1,592.77
Net Current Assets
-596.38
-9,428.93
-11,091.82
-1,930.51
-6,173.11
-4,752.17
-5,932.40
-5,003.11
725.41
3,377.57
Total Assets
97,372.01
96,667.79
80,125.50
60,466.82
46,557.45
36,378.07
32,635.18
30,211.67
23,513.83
26,326.66

Cash Flow

Consolidated Figures in Rs. Crores /

Standalone
Description
Mar 18
Mar 17
Mar 16
Mar 15
Mar 14
Mar 13
Mar 12
Mar 11
Mar 10
Mar 09
Cash From Operating Activity
5,332.36
10,537.32
10,948.61
10,417.86
8,219.20
6,297.09
3,818.08
5,093.22
2,542.09
2,264.21
PBT
-6,821.58
-863.24
4,250.13
3,192.91
1,967.82
1,010.93
722.99
898.71
953.94
881.58
Adjustment
12,990.80
11,385.39
7,957.65
7,775.20
6,354.40
5,087.55
4,356.00
2,951.63
2,573.30
1,942.21
Changes in Working Capital
-420.44
696.00
-398.02
554.00
535.38
609.58
-846.82
1,575.59
-750.43
-413.25
Cash after chg. in Working capital
5,748.78
11,218.15
11,809.75
11,522.11
8,857.60
6,708.05
4,232.17
5,425.92
2,776.80
2,410.54
Interest Paid
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Tax Paid
-416.42
-680.84
-861.14
-1,104.26
-638.40
-410.96
-414.09
-332.70
-234.71
-146.33
Other Direct Exp. Paid
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Extra & Other Items
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Cash From Investing Activity
-9,271.67
-15,555.69
-2,388.99
-5,725.63
-6,564.24
-3,410.90
-4,685.09
-8,359.18
-2,953.15
-10,023.49
Net Fixed Assets
-7,885.33
-20,067.58
-16,223.82
-4,263.48
-14,617.72
-5,375.93
-4,177.64
-9,190.96
-6,012.41
-2,454.55
Net Investments
-134.83
-3,751.61
10,314.41
-11,172.90
926.10
-930.50
936.00
182.32
2,173.67
-4,358.87
Others
-1,251.51
8,263.50
3,520.42
9,710.75
7,127.38
2,895.53
-1,443.45
649.46
885.59
-3,210.07
Cash from Financing Activity
3,924.87
4,444.49
-9,330.08
8,027.98
-2,466.08
-1,965.34
-361.40
3,345.29
-2,401.05
10,202.72
Net Cash Inflow / Outflow
-14.44
-573.89
-770.46
12,720.21
-811.12
920.85
-1,228.41
79.33
-2,812.11
2,443.45
Opening Cash & Equivalents
12.06
617.43
1,387.88
354.32
1,165.81
244.96
1,473.37
1,394.04
3,086.40
497.45
Closing Cash & Equivalent
-2.38
43.54
617.43
13,074.53
354.32
1,165.81
244.96
1,473.37
289.99
3,086.40

Financial Ratios

Consolidated /

Standalone
Description
Mar 18
Mar 17
Mar 16
Mar 15
Mar 14
Mar 13
Mar 12
Mar 11
Mar 10
Mar 09
Book Value (Rs.)
62.35
68.23
65.03
63.88
49.73
43.09
39.33
37.09
34.32
42.73
ROA
-4.63%
-0.93%
3.28%
5.97%
4.75%
2.93%
2.30%
3.35%
3.83%
4.50%
ROE
-17.34%
-3.42%
9.94%
16.17%
12.78%
7.41%
5.72%
7.62%
7.76%
10.50%
ROCE
-2.26%
3.83%
9.88%
13.77%
12.24%
9.58%
8.51%
6.94%
8.53%
11.62%
Fixed Asset Turnover
0.29
0.44
0.54
0.56
0.54
0.51
0.52
0.51
0.50
0.56
Receivable days
14.21
12.60
10.77
10.29
12.12
14.52
12.91
12.07
12.18
10.09
Inventory Days
0.62
0.85
0.90
0.81
0.97
1.35
1.48
1.41
1.56
1.44
Payable days
46.59
41.43
39.27
42.22
45.05
45.73
61.66
79.54
85.13
93.99
Cash Conversion Cycle
-31.77
-27.98
-27.60
-31.12
-31.96
-29.86
-47.27
-66.06
-71.39
-82.46
Total Debt/Equity
2.13
2.24
1.73
1.17
1.25
0.98
1.02
0.99
0.69
0.67
Interest Cover
-0.38
0.68
3.12
5.65
4.15
2.51
1.95
2.93
2.56
2.01

News Update:


  • Vodafone Idea plans to cut 16,000 distributors, 2,000 retail stores by FY19
    26th Nov 2018, 11:52 AM

    The company also plans to reduce the number of its call centres to 38 from 82 by March 2019 as part of its integration plan

    Read More
  • Vodafone Idea planning to invest Rs 27,000 crore in FY20
    22nd Nov 2018, 09:47 AM

    The company expects advancing of synergy target by two years which will help it to improve cash flow to the tune of Rs 8,400 crore

    Read More
  • Vodafone Idea’s Q2 consolidated net loss widens to Rs 4,973.80 crore
    15th Nov 2018, 11:11 AM

    Total consolidated income of the company increased by 4.90% at Rs 7,878.60 crore for Q2FY19

    Read More
  • Vodafone Idea - Quarterly Results
    14th Nov 2018, 18:55 PM

    Read More
  • Vodafone Idea introduces festive season offers: Report
    17th Oct 2018, 12:38 PM

    The company is looking to hook subscribers with post-paid offers since it generates higher average revenue per user

    Read More
  • Vodafone Idea partners with Paytm
    1st Oct 2018, 09:30 AM

    This partnership offers Vodafone and Idea customers exclusive cashback offers and exciting vouchers on recharging through Paytm

    Read More
  • Brickwork Ratings revises ratings assigned to Idea Cellular’s NCDs
    12th Sep 2018, 15:47 PM

    The rating agency revised ratings assigned to the company’s NCDs from 'AA+' to 'AA'

    Read More
  • Idea Cellular raises Rs 1500 crore via NCDs
    4th Sep 2018, 11:36 AM

    The Securities Allotment Committee at their meeting held September 03, 2018, has allotted 15,000 Unsecured Redeemable NCDs of Rs 10 lakh each

    Read More

Source: www.accordfintech.com. Price feed provided by www.nseindia.com and www.bseindia.com value addition by www.accordfintech.com. Intraday data delayed 15 minutes.

DISCLAIMER: Information is provided " as is" and solely for informational purposes, not for trading purposes or advice, and may be delayed.