Nifty
Sensex
:
:
10682.20
35457.16
65.50 (0.62%)
196.62 (0.56%)

Telecommunication - Service Provider

Rating :
46/99

BSE: 532454 | NSE: BHARTIARTL

332.75
28.35 (9.31%)
16-Nov-2018 | 3:58PM
  • Day's Open
  • Day's High
  • Day's Low
  • Previous Close
  •  302.90
  •  336.80
  •  302.00
  •  304.40
  • Volume
  • Traded Value (lacs)
  • 52 Week High
  • 52 Week Low
  •  22573096
  •  75111.98
  •  547.50
  •  276.85

Stock Summary

  • Market Cap(Crs)
  • Stock P:E
  • Face Value
  • 133,353.27
  • 220.49
  • 5
  • Enterprise Value(Crs)
  • Dividend Yield
  • Price:Book Value
  • 238,016.17
  • 0.75%
  • 1.94

Shareholding Pattern

  • Promoter
  • Corporate
  • Public
  • 67.14%
  • 0.62%
  • 0.80%
  • FII
  • DII
  • Others
  • 0.08%
  • 12.63%
  • 18.73%

Chart

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

Revenue CAGR (%)

  • 10 Years
  • 5 Years
  • 3 Years
  • 8.40
  • -0.51
  • -4.65

EBITDA CAGR (%)

  • 10 Years
  • 5 Years
  • 3 Years
  • 7.21
  • 1.58
  • -2.38

PAT CAGR (%)

  • 10 Years
  • 5 Years
  • 3 Years
  • -41.31
  • -56.68
  • -80.34

P:E (Median)

  • 8 Years
  • 5 Years
  • 3 Years
  • 32.12
  • 38.39
  • 38.41

P:BV (Average)

  • 8 Years
  • 5 Years
  • 3 Years
  • 2.54
  • 2.55
  • 2.43

EV:EBITDA (Average)

  • 8 Years
  • 5 Years
  • 3 Years
  • 7.74
  • 7.34
  • 7.32

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
20,422.50
21,776.90
-6.22%
20,080.00
21,958.10
-8.55%
19,634.30
21,934.60
-10.49%
20,318.60
23,335.70
-12.93%
Expenses
14,286.40
13,885.70
2.89%
13,358.20
14,164.00
-5.69%
12,723.20
14,122.00
-9.91%
12,850.00
14,803.30
-13.20%
EBITDA
6,136.10
7,891.20
-22.24%
6,721.80
7,794.10
-13.76%
6,911.10
7,812.60
-11.54%
7,468.60
8,532.40
-12.47%
EBIDTM
30.05%
36.24%
33.48%
35.50%
35.20%
35.62%
36.76%
36.56%
Other Income
387.10
220.30
75.71%
522.90
425.10
23.01%
636.20
401.50
58.46%
69.60
28.20
146.81%
Interest
3,303.40
2,491.60
32.58%
2,549.80
2,203.90
15.69%
2,390.20
2,271.70
5.22%
2,088.20
1,935.60
7.88%
Depreciation
5,236.60
4,687.30
11.72%
5,145.20
4,819.20
6.76%
4,899.10
4,941.80
-0.86%
4,837.50
4,835.00
0.05%
PBT
-2,161.70
754.00
-
-812.40
1,145.80
-
-66.70
395.10
-
373.00
1,586.00
-76.48%
Tax
-2,247.60
534.10
-
-1,126.70
813.60
-
-302.10
175.30
-
37.90
1,184.10
-96.80%
PAT
85.90
219.90
-60.94%
314.30
332.20
-5.39%
235.40
219.80
7.10%
335.10
401.90
-16.62%
PATM
0.42%
1.01%
1.57%
1.51%
1.20%
1.00%
1.65%
1.72%
EPS
0.30
0.86
-65.12%
0.24
0.92
-73.91%
0.21
0.93
-77.42%
0.77
1.26
-38.89%

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
80,455.40
83,687.90
95,468.30
96,532.10
96,100.70
85,863.50
76,947.00
71,505.80
59,601.80
41,829.46
37,352.08
Net Sales Growth
-9.61%
-12.34%
-1.10%
0.45%
11.92%
11.59%
7.61%
19.97%
42.49%
11.99%
 
Cost Of Goods Sold
0.00
999.40
907.30
605.30
279.60
472.80
783.40
938.90
816.90
85.89
99.85
Gross Profit
80,455.40
82,688.50
94,561.00
95,926.80
95,821.10
85,390.70
76,163.60
70,566.90
58,784.90
41,743.57
37,252.23
GP Margin
100.00%
98.81%
99.05%
99.37%
99.71%
99.45%
98.98%
98.69%
98.63%
99.79%
99.73%
Total Expenditure
53,217.80
53,651.10
60,270.40
62,650.30
62,498.70
58,086.50
53,689.10
47,793.50
39,530.00
25,360.09
22,379.40
Power & Fuel Cost
-
6,908.20
7,294.60
6,904.90
8,439.80
0.00
0.00
0.00
0.00
3,677.01
2,787.00
% Of Sales
-
8.25%
7.64%
7.15%
8.78%
0%
0%
0%
0%
8.79%
7.46%
Employee Cost
-
3,977.10
4,303.20
4,910.80
4,857.00
4,622.80
3,882.30
3,515.90
3,278.40
1,723.54
1,673.20
% Of Sales
-
4.75%
4.51%
5.09%
5.05%
5.38%
5.05%
4.92%
5.50%
4.12%
4.48%
Manufacturing Exp.
-
30,221.30
34,176.60
34,421.80
29,519.40
38,509.60
35,304.60
31,605.80
25,448.10
12,833.88
12,361.91
% Of Sales
-
36.11%
35.80%
35.66%
30.72%
44.85%
45.88%
44.20%
42.70%
30.68%
33.10%
General & Admin Exp.
-
3,865.60
4,237.50
4,864.30
8,401.80
13,774.90
13,192.40
11,247.40
9,661.90
3,470.12
2,367.67
% Of Sales
-
4.62%
4.44%
5.04%
8.74%
16.04%
17.14%
15.73%
16.21%
8.30%
6.34%
Selling & Distn. Exp.
-
5,576.60
6,673.20
8,241.00
8,686.80
0.00
0.00
0.00
0.00
2,521.68
2,266.27
% Of Sales
-
6.66%
6.99%
8.54%
9.04%
0%
0%
0%
0%
6.03%
6.07%
Miscellaneous Exp.
-
2,102.90
2,678.00
2,702.20
2,314.30
706.40
526.40
485.50
324.70
1,047.96
2,266.27
% Of Sales
-
2.51%
2.81%
2.80%
2.41%
0.82%
0.68%
0.68%
0.54%
2.51%
2.20%
EBITDA
27,237.60
30,036.80
35,197.90
33,881.80
33,602.00
27,777.00
23,257.90
23,712.30
20,071.80
16,469.37
14,972.68
EBITDA Margin
33.85%
35.89%
36.87%
35.10%
34.97%
32.35%
30.23%
33.16%
33.68%
39.37%
40.09%
Other Income
1,615.80
1,531.00
1,969.80
1,719.70
2,095.80
1,040.80
510.30
264.30
353.60
477.13
597.48
Interest
10,331.60
9,325.50
9,546.60
8,546.10
4,446.50
5,878.80
4,518.70
4,082.80
2,534.90
-148.33
2,306.38
Depreciation
20,118.40
19,243.10
19,773.00
17,449.80
19,858.30
15,649.60
14,814.80
13,368.10
10,206.60
6,199.41
4,672.77
PBT
-2,667.80
2,999.20
7,848.10
9,605.60
11,393.00
7,289.40
4,434.70
6,525.70
7,683.90
10,895.44
8,591.01
Tax
-3,638.50
1,083.50
3,481.90
5,953.30
5,486.70
4,844.90
2,518.40
2,260.20
1,779.00
1,533.92
546.83
Tax Rate
136.39%
49.11%
52.14%
50.54%
52.06%
65.98%
56.79%
34.64%
23.15%
14.08%
6.37%
PAT
970.70
38.10
2,754.90
5,010.10
4,626.10
2,498.30
1,916.30
4,264.20
5,757.40
9,163.13
7,858.95
PAT before Minority Interest
-133.00
1,122.60
3,196.50
5,826.40
5,053.10
2,498.30
1,916.30
4,265.50
5,904.90
9,361.52
8,044.18
Minority Interest
-1,103.70
-1,084.50
-441.60
-816.30
-427.00
0.00
0.00
-1.30
-147.50
-198.39
-185.23
PAT Margin
1.21%
0.05%
2.89%
5.19%
4.81%
2.91%
2.49%
5.96%
9.66%
21.91%
21.04%
PAT Growth
-17.30%
-98.62%
-45.01%
8.30%
85.17%
30.37%
-55.06%
-25.94%
-37.17%
16.59%
 
Unadjusted EPS
1.52
2.75
9.51
15.21
11.56
7.02
6.00
11.22
15.93
24.13
20.70

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
69,534.40
67,456.30
66,769.30
39,777.00
59,756.00
50,321.70
50,611.30
48,766.80
39,878.91
29,127.92
Share Capital
1,998.70
1,998.70
1,998.70
1,998.70
1,964.50
1,831.40
1,870.60
1,872.00
1,898.77
1,898.24
Total Reserves
67,457.50
65,051.10
64,253.70
37,644.00
57,791.50
48,490.30
48,740.70
46,894.80
37,718.19
27,088.81
Non-Current Liabilities
91,060.40
92,854.70
90,121.60
69,369.00
56,143.30
56,911.20
49,665.80
53,392.70
10,692.83
13,487.85
Secured Loans
225.60
705.30
1,875.60
9,356.90
9,888.20
8,441.10
9,888.70
8,540.50
4,958.43
1,428.73
Unsecured Loans
84,716.40
88,932.00
87,393.00
51,759.20
46,504.70
49,441.10
40,115.90
45,563.30
5,329.71
12,088.42
Long Term Provisions
721.20
747.10
735.00
1,797.00
1,004.40
974.40
724.00
608.50
0.00
0.00
Current Liabilities
78,239.90
63,459.70
58,931.60
84,530.70
56,805.00
42,054.70
48,887.30
36,984.50
21,633.95
21,486.94
Trade Payables
27,767.50
26,853.70
25,580.60
16,077.40
28,398.10
25,990.20
23,265.00
23,968.40
10,551.21
11,886.93
Other Current Liabilities
36,171.30
22,316.40
26,193.20
38,975.20
2,840.60
2,109.10
1,857.30
6,916.60
4,618.01
4,975.25
Short Term Borrowings
12,956.90
12,944.20
5,723.80
8,813.80
25,393.80
13,778.60
23,636.00
5,981.50
0.00
0.00
Short Term Provisions
1,344.20
1,345.40
1,434.00
20,664.30
172.50
176.80
129.00
118.00
6,464.72
4,624.76
Total Liabilities
247,648.60
230,645.70
221,320.60
200,567.30
176,914.50
153,376.20
151,933.90
142,000.30
75,061.22
65,332.46
Net Block
187,200.40
178,235.10
172,292.80
124,278.60
140,614.50
128,666.30
133,582.10
128,874.30
50,849.06
43,948.64
Gross Block
293,089.20
271,518.20
259,636.80
208,310.30
210,195.50
184,922.80
177,635.50
160,260.30
72,116.34
58,661.61
Accumulated Depreciation
105,888.80
93,283.10
87,344.00
84,031.70
69,317.30
55,992.80
43,789.70
31,122.30
21,267.28
14,712.96
Non Current Assets
214,149.60
212,441.90
198,194.20
159,596.00
154,528.80
133,685.60
137,125.50
130,792.60
53,295.83
48,098.96
Capital Work in Progress
9,751.20
10,838.50
5,702.00
17,414.80
0.00
0.00
0.00
0.00
2,435.94
4,143.65
Non Current Investment
9,260.80
12,646.40
8,961.20
2,743.40
9,304.30
1,155.20
22.30
0.00
10.84
6.67
Long Term Loans & Adv.
6,862.20
8,337.90
8,003.40
13,762.10
2,964.90
2,253.30
1,928.10
542.80
0.00
0.00
Other Non Current Assets
1,075.00
2,384.00
3,234.80
1,397.10
1,645.10
1,610.80
1,593.00
1,375.50
0.00
0.00
Current Assets
33,499.00
18,203.80
23,126.40
40,542.60
22,385.70
19,690.60
14,808.40
11,207.70
21,765.39
17,233.42
Current Investments
6,897.80
1,692.30
1,615.90
8,008.60
6,226.50
6,554.60
1,813.20
622.40
5,151.23
2,342.29
Inventories
69.30
48.80
440.40
375.40
142.20
110.90
130.80
213.90
48.39
96.27
Sundry Debtors
5,883.00
4,740.20
5,503.90
5,207.20
6,244.10
6,782.40
6,373.50
5,492.90
3,182.48
2,899.78
Cash & Bank
6,670.60
5,098.30
5,098.70
2,083.10
4,980.80
1,607.80
2,030.00
957.50
2,578.63
2,765.97
Other Current Assets
13,978.30
3,566.40
7,721.00
2,028.10
4,792.10
4,634.90
4,460.90
3,921.00
10,804.66
9,129.11
Short Term Loans & Adv.
9,164.60
3,057.80
2,746.50
22,840.20
1,081.40
1,232.00
1,077.80
836.00
10,731.43
8,973.89
Net Current Assets
-44,740.90
-45,255.90
-35,805.20
-43,988.10
-34,419.30
-22,364.10
-34,078.90
-25,776.80
131.45
-4,253.52
Total Assets
247,648.60
230,645.70
221,320.60
200,567.30
176,914.50
153,376.20
151,933.90
142,000.30
75,061.22
65,332.47

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
29,853.80
28,279.90
27,942.30
27,601.80
26,232.60
22,769.90
22,543.80
18,851.30
15,456.45
13,711.56
PBT
3,267.00
7,723.30
12,846.30
10,713.00
7,864.30
4,785.30
6,518.30
7,678.20
10,895.44
8,591.01
Adjustment
27,368.50
27,222.70
20,175.10
19,844.40
19,640.30
18,546.50
17,425.70
12,597.70
6,638.10
7,156.73
Changes in Working Capital
590.60
-3,507.40
-395.50
-163.90
1,753.30
1,963.40
1,505.00
957.70
255.78
-752.37
Cash after chg. in Working capital
31,226.10
31,438.60
32,625.90
30,393.50
29,257.90
25,295.20
25,449.00
21,233.60
17,789.32
14,995.38
Interest Paid
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Tax Paid
-1,372.30
-3,158.70
-4,683.60
-4,611.10
-3,503.90
-3,129.40
-2,945.30
-2,438.80
-2,332.86
-1,283.81
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
-27,967.60
-30,604.40
-14,225.70
-22,048.10
-24,973.30
-18,676.10
-18,379.50
-60,449.50
-14,703.11
-15,175.37
Net Fixed Assets
-18,213.10
-36,562.50
-40,345.10
-28,335.40
-3,581.60
-5,863.60
-3,456.70
-22,109.40
-5,973.83
-8,966.64
Net Investments
-2,169.20
23,938.30
-26,780.40
-8,593.00
-6,324.80
-15,861.30
-524.80
3,960.30
-3,995.54
-824.91
Others
-7,585.30
-17,980.20
52,899.80
14,880.30
-15,066.90
3,048.80
-14,398.00
-42,300.40
-4,733.74
-5,383.82
Cash from Financing Activity
1,920.50
-351.40
-11,946.10
-9,657.00
2,774.40
-4,565.50
-4,010.70
39,715.30
-1,374.92
2,064.85
Net Cash Inflow / Outflow
3,806.70
-2,675.90
1,770.50
-4,103.30
4,033.70
-471.70
153.60
-1,882.90
-621.58
601.04
Opening Cash & Equivalents
-988.00
1,763.50
-141.30
3,957.50
131.10
765.20
600.80
2,496.10
1,296.48
695.44
Closing Cash & Equivalent
2,846.80
-988.00
1,763.50
-141.50
3,957.50
131.10
803.70
600.80
2,095.65
1,296.48

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.)
173.75
167.73
165.74
98.09
149.57
132.69
133.35
128.49
104.32
76.35
ROA
0.47%
1.41%
2.76%
2.68%
1.51%
1.26%
2.90%
5.44%
13.34%
14.04%
ROE
1.64%
4.80%
11.05%
10.21%
4.53%
3.79%
8.58%
13.36%
27.29%
31.76%
ROCE
6.49%
9.49%
14.02%
11.34%
10.03%
7.27%
8.89%
12.42%
23.16%
29.47%
Fixed Asset Turnover
0.30
0.36
0.41
0.46
0.43
0.42
0.42
0.51
0.64
0.74
Receivable days
23.17
19.58
20.25
21.75
27.69
31.20
30.29
26.56
26.54
28.04
Inventory Days
0.26
0.94
1.54
0.98
0.54
0.57
0.88
0.80
0.63
1.03
Payable days
148.90
131.56
104.72
112.45
167.51
164.08
174.39
158.49
150.79
168.73
Cash Conversion Cycle
-125.48
-111.04
-82.93
-89.72
-139.29
-132.30
-143.23
-131.12
-123.62
-139.66
Total Debt/Equity
1.60
1.60
1.52
2.13
1.37
1.42
1.46
1.35
0.26
0.47
Interest Cover
1.24
1.70
2.38
3.37
2.25
1.98
2.60
4.03
-72.45
4.72

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.