Nifty
:
11557.45
Sensex
:
39051.53
41.35 (0.36%)
71.68 (0.18%)
Nifty
Sensex
:
:
11557.45
39051.53
41.35 (0.36%)
71.68 (0.18%)

Bharti Airtel Ltd.

Telecommunication - Service Provider

Rating :
61/99

BSE: 532454 | NSE: BHARTIARTL

NSE BSE
479.00
17-Sep-2020
  • Open
  • High
  • Low
  • Previous Close
  •  480.00
  •  482.35
  •  474.00
  •  481.75
  • Volume
  • Traded Value (lacs)
  • 52 Week High
  • 52 Week Low
  •  13497203
  •  64515.65
  •  612.00
  •  325.50

Stock Summary

  • Market Cap(Crs)
  • Stock P:E
  • Face Value
  • 261,239.36
  • N/A
  • 5
  • Enterprise Value(Crs)
  • Dividend Yield
  • Price:Book Value
  • 362,965.66
  • 0.42%
  • 4.23

Shareholding Pattern

  • Promoter
  • Corporate
  • Public
  • 56.23%
  • 0.29%
  • 1.25%
  • FII
  • DII
  • Others
  • 20.15%
  • 17.99%
  • 4.09%

Chart

Price | P:E | P:BV | EV:EBITDA | MCap:Sales | EPS

Revenue CAGR (%)

  • 10 Years
  • 5 Years
  • 3 Years
  • 3.92
  • -1.94
  • 1.94

EBITDA CAGR (%)

  • 10 Years
  • 5 Years
  • 3 Years
  • 6.16
  • 1.49
  • 3.96

PAT CAGR (%)

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

P:E (Median)

  • 8 Years
  • 5 Years
  • 3 Years
  • 38.76
  • 30.61
  • 124.01

P:BV (Average)

  • 8 Years
  • 5 Years
  • 3 Years
  • 2.55
  • 2.54
  • 2.58

EV:EBITDA (Average)

  • 8 Years
  • 5 Years
  • 3 Years
  • 8.06
  • 8.32
  • 9.46

Quarterly Results

Consolidated Figures in Rs. Crores /

Standalone
Description
Jun 20
Jun 19
Var%
Mar 20
Mar 19
Var%
Dec 19
Dec 18
Var%
Sep 19
Sep 18
Var%
Net Sales
23,938.70
20,737.90
15.43%
23,722.70
20,602.20
15.15%
21,947.10
20,231.00
8.48%
21,131.30
20,147.80
4.88%
Expenses
13,530.80
12,495.20
8.29%
13,557.50
13,992.60
-3.11%
12,701.30
14,100.80
-9.92%
12,294.10
14,023.50
-12.33%
EBITDA
10,407.90
8,242.70
26.27%
10,165.20
6,609.60
53.79%
9,245.80
6,130.20
50.82%
8,837.20
6,124.30
44.30%
EBIDTM
43.48%
39.75%
14.01%
32.08%
42.13%
30.30%
41.82%
30.40%
Other Income
480.50
677.10
-29.04%
922.00
212.70
333.47%
371.50
746.50
-50.23%
346.60
398.90
-13.11%
Interest
3,456.20
3,784.00
-8.66%
4,130.20
2,674.30
54.44%
3,281.60
2,608.10
25.82%
3,187.20
3,303.40
-3.52%
Depreciation
7,226.80
6,758.70
6.93%
7,055.00
5,493.40
28.43%
6,940.80
5,472.30
26.84%
6,935.10
5,236.60
32.44%
PBT
-11,540.30
-3,092.30
-
-7,102.00
676.70
-
-1,655.10
210.00
-
-31,649.50
-2,161.70
-
Tax
3,817.50
-607.00
-
-2,033.50
137.40
-
-1,037.90
-182.40
-
-8,503.90
-2,247.60
-
PAT
-15,357.80
-2,485.30
-
-5,068.50
539.30
-
-617.20
392.40
-
-23,145.60
85.90
-
PATM
-64.15%
-11.98%
7.11%
2.62%
-2.81%
1.94%
-109.53%
0.43%
EPS
-28.15
-4.56
-
-9.29
0.99
-
-1.13
0.72
-
-42.43
0.16
-

Annual Results

Consolidated Figures in Rs. Crores /

Standalone
Description
TTM
Mar 20
Mar 19
Mar 18
Mar 17
Mar 16
Mar 15
Mar 14
Mar 13
Mar 12
Mar 11
Net Sales
90,739.80
87,539.00
80,780.20
82,638.80
95,468.30
96,532.10
96,100.70
85,863.50
76,947.00
71,505.80
59,601.80
Net Sales Growth
11.04%
8.37%
-2.25%
-13.44%
-1.10%
0.45%
11.92%
11.59%
7.61%
19.97%
 
Cost Of Goods Sold
4,644.10
1,295.90
1,085.50
999.40
907.30
605.30
279.60
472.80
783.40
938.90
816.90
Gross Profit
86,095.70
86,243.10
79,694.70
81,639.40
94,561.00
95,926.80
95,821.10
85,390.70
76,163.60
70,566.90
58,784.90
GP Margin
94.88%
98.52%
98.66%
98.79%
99.05%
99.37%
99.71%
99.45%
98.98%
98.69%
98.63%
Total Expenditure
52,083.70
51,056.70
56,576.70
52,602.00
60,270.40
62,650.30
62,498.70
58,086.50
53,689.10
47,793.50
39,530.00
Power & Fuel Cost
-
9,124.90
5,626.10
6,908.20
7,294.60
6,904.90
8,439.80
0.00
0.00
0.00
0.00
% Of Sales
-
10.42%
6.96%
8.36%
7.64%
7.15%
8.78%
0%
0%
0%
0%
Employee Cost
-
3,807.20
3,797.50
3,977.10
4,303.20
4,910.80
4,857.00
4,622.80
3,882.30
3,515.90
3,278.40
% Of Sales
-
4.35%
4.70%
4.81%
4.51%
5.09%
5.05%
5.38%
5.05%
4.92%
5.50%
Manufacturing Exp.
-
29,239.00
33,492.30
30,221.30
34,176.60
34,421.80
29,519.40
38,509.60
35,304.60
31,605.80
25,448.10
% Of Sales
-
33.40%
41.46%
36.57%
35.80%
35.66%
30.72%
44.85%
45.88%
44.20%
42.70%
General & Admin Exp.
-
3,378.10
5,693.70
4,850.70
4,237.50
4,864.30
8,401.80
13,774.90
13,192.40
11,247.40
9,661.90
% Of Sales
-
3.86%
7.05%
5.87%
4.44%
5.04%
8.74%
16.04%
17.14%
15.73%
16.21%
Selling & Distn. Exp.
-
3,432.50
4,127.70
4,527.50
6,673.20
8,241.00
8,686.80
0.00
0.00
0.00
0.00
% Of Sales
-
3.92%
5.11%
5.48%
6.99%
8.54%
9.04%
0%
0%
0%
0%
Miscellaneous Exp.
-
779.10
2,753.90
1,117.80
2,678.00
2,702.20
2,314.30
706.40
526.40
485.50
0.00
% Of Sales
-
0.89%
3.41%
1.35%
2.81%
2.80%
2.41%
0.82%
0.68%
0.68%
0.54%
EBITDA
38,656.10
36,482.30
24,203.50
30,036.80
35,197.90
33,881.80
33,602.00
27,777.00
23,257.90
23,712.30
20,071.80
EBITDA Margin
42.60%
41.68%
29.96%
36.35%
36.87%
35.10%
34.97%
32.35%
30.23%
33.16%
33.68%
Other Income
2,120.60
1,934.60
3,141.20
1,531.00
1,969.80
1,719.70
2,095.80
1,040.80
510.30
264.30
353.60
Interest
14,055.20
13,991.80
11,013.40
9,325.50
9,546.60
8,546.10
4,446.50
5,878.80
4,518.70
4,082.80
2,534.90
Depreciation
28,157.70
27,689.60
21,347.50
19,243.10
19,773.00
17,449.80
19,858.30
15,649.60
14,814.80
13,368.10
10,206.60
PBT
-51,946.90
-3,264.50
-5,016.20
2,999.20
7,848.10
9,605.60
11,393.00
7,289.40
4,434.70
6,525.70
7,683.90
Tax
-7,757.80
-12,182.30
-3,419.30
1,083.50
3,481.90
5,953.30
5,486.70
4,844.90
2,518.40
2,260.20
1,779.00
Tax Rate
14.93%
28.01%
163.81%
49.11%
52.14%
50.54%
52.06%
65.98%
56.79%
34.64%
23.15%
PAT
-44,189.10
-32,835.60
53.90
38.10
2,754.90
5,010.10
4,626.10
2,498.30
1,916.30
4,264.20
5,757.40
PAT before Minority Interest
-45,716.20
-31,316.60
1,331.90
1,122.60
3,196.50
5,826.40
5,053.10
2,498.30
1,916.30
4,265.50
5,904.90
Minority Interest
-1,527.10
-1,519.00
-1,278.00
-1,084.50
-441.60
-816.30
-427.00
0.00
0.00
-1.30
-147.50
PAT Margin
-48.70%
-37.51%
0.07%
0.05%
2.89%
5.19%
4.81%
2.91%
2.49%
5.96%
9.66%
PAT Growth
0.00%
-
41.47%
-98.62%
-45.01%
8.30%
85.17%
30.37%
-55.06%
-25.94%
 
EPS
-81.00
-60.19
0.10
0.07
5.05
9.18
8.48
4.58
3.51
7.82
10.55

Results Balance Sheet

Consolidated Figures in Rs. Crores /

Standalone
Description
Mar 20
Mar 19
Mar 18
Mar 17
Mar 16
Mar 15
Mar 14
Mar 13
Mar 12
Mar 11
Shareholder's Funds
77,144.80
71,422.20
69,534.40
67,456.30
66,769.30
39,777.00
59,756.00
50,321.70
50,611.30
48,766.80
Share Capital
2,727.80
1,998.70
1,998.70
1,998.70
1,998.70
1,998.70
1,964.50
1,831.40
1,870.60
1,872.00
Total Reserves
74,349.70
69,349.10
67,457.50
65,051.10
64,253.70
37,644.00
57,791.50
48,490.30
48,740.70
46,894.80
Non-Current Liabilities
100,145.90
88,256.70
91,060.40
92,854.70
90,121.60
69,369.00
56,143.30
56,911.20
49,665.80
53,392.70
Secured Loans
0.00
0.30
225.60
705.30
1,875.60
9,356.90
9,888.20
8,441.10
9,888.70
8,540.50
Unsecured Loans
91,079.20
87,245.10
84,716.40
88,932.00
87,393.00
51,759.20
46,504.70
49,441.10
40,115.90
45,563.30
Long Term Provisions
754.80
682.30
721.20
747.10
735.00
1,797.00
1,004.40
974.40
724.00
608.50
Current Liabilities
131,487.60
93,054.90
78,240.00
63,459.70
58,931.60
84,530.70
56,805.00
42,054.70
48,887.30
36,984.50
Trade Payables
25,019.90
28,003.10
26,853.60
26,853.70
25,580.60
16,077.40
28,398.10
25,990.20
23,265.00
23,968.40
Other Current Liabilities
43,303.10
32,999.60
37,085.20
22,316.40
26,193.20
38,975.20
2,840.60
2,109.10
1,857.30
6,916.60
Short Term Borrowings
16,703.40
31,009.70
12,956.90
12,944.20
5,723.80
8,813.80
25,393.80
13,778.60
23,636.00
5,981.50
Short Term Provisions
46,461.20
1,042.50
1,344.30
1,345.40
1,434.00
20,664.30
172.50
176.80
129.00
118.00
Total Liabilities
333,763.00
266,259.60
247,648.70
230,645.70
221,320.60
200,567.30
176,914.50
153,376.20
151,933.90
142,000.30
Net Block
229,255.50
200,831.50
187,200.40
178,235.10
172,292.80
124,278.60
140,614.50
128,666.30
133,582.10
128,874.30
Gross Block
375,334.90
328,441.10
294,267.60
271,518.20
259,636.80
208,310.30
210,195.50
184,922.80
177,635.50
160,260.30
Accumulated Depreciation
146,079.40
127,609.60
107,067.20
93,283.10
87,344.00
84,031.70
69,317.30
55,992.80
43,789.70
31,122.30
Non Current Assets
257,119.80
233,353.90
214,149.60
212,441.90
198,194.20
159,596.00
154,528.80
133,685.60
137,125.50
130,792.60
Capital Work in Progress
4,282.30
9,634.20
9,751.20
10,838.50
5,702.00
17,414.80
0.00
0.00
0.00
0.00
Non Current Investment
11,708.60
11,087.80
9,260.80
12,646.40
8,961.20
2,743.40
9,304.30
1,155.20
22.30
0.00
Long Term Loans & Adv.
6,726.90
9,102.50
6,862.20
8,337.90
8,003.40
13,762.10
2,964.90
2,253.30
1,928.10
542.80
Other Non Current Assets
5,146.50
2,697.90
1,075.00
2,384.00
3,234.80
1,397.10
1,645.10
1,610.80
1,593.00
1,375.50
Current Assets
76,643.20
32,905.70
33,499.10
18,203.80
23,126.40
40,542.60
22,385.70
19,690.60
14,808.40
11,207.70
Current Investments
13,767.90
4,623.20
6,897.80
1,692.30
1,615.90
8,008.60
6,226.50
6,554.60
1,813.20
622.40
Inventories
156.90
88.40
69.30
48.80
440.40
375.40
142.20
110.90
130.80
213.90
Sundry Debtors
4,605.80
4,300.60
5,883.00
4,740.20
5,503.90
5,207.20
6,244.10
6,782.40
6,373.50
5,492.90
Cash & Bank
15,892.70
8,105.50
6,670.60
5,098.30
5,098.70
2,083.10
4,980.80
1,607.80
2,030.00
957.50
Other Current Assets
42,219.90
3,184.10
4,813.80
3,566.40
10,467.50
24,868.30
4,792.10
4,634.90
4,460.90
3,921.00
Short Term Loans & Adv.
19,239.00
12,603.90
9,164.60
3,057.80
2,746.50
22,840.20
1,081.40
1,232.00
1,077.80
836.00
Net Current Assets
-54,844.40
-60,149.20
-44,740.90
-45,255.90
-35,805.20
-43,988.10
-34,419.30
-22,364.10
-34,078.90
-25,776.80
Total Assets
333,763.00
266,259.60
247,648.70
230,645.70
221,320.60
200,567.30
176,914.50
153,376.20
151,933.90
142,000.30

Cash Flow

Consolidated Figures in Rs. Crores /

Standalone
Description
Mar 20
Mar 19
Mar 18
Mar 17
Mar 16
Mar 15
Mar 14
Mar 13
Mar 12
Mar 11
Cash From Operating Activity
18,128.70
19,788.00
29,853.80
28,279.90
27,942.30
27,601.80
26,232.60
22,769.90
22,543.80
18,851.30
PBT
-42,846.50
-1,731.80
3,267.00
7,723.30
12,846.30
10,713.00
7,864.30
4,785.30
6,518.30
7,678.20
Adjustment
79,865.30
28,510.00
27,368.50
27,222.70
20,175.10
19,844.40
19,640.30
18,546.50
17,425.70
12,597.70
Changes in Working Capital
-16,596.40
-5,819.60
590.60
-3,507.40
-395.50
-163.90
1,753.30
1,963.40
1,505.00
957.70
Cash after chg. in Working capital
20,422.40
20,958.60
31,226.10
31,438.60
32,625.90
30,393.50
29,257.90
25,295.20
25,449.00
21,233.60
Interest Paid
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Tax Paid
-2,293.70
-1,170.60
-1,372.30
-3,158.70
-4,683.60
-4,611.10
-3,503.90
-3,129.40
-2,945.30
-2,438.80
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
-30,491.90
-28,500.90
-27,967.60
-30,604.40
-14,225.70
-22,048.10
-24,973.30
-18,676.10
-18,379.50
-60,449.50
Net Fixed Assets
-35,194.90
-23,053.00
-18,309.30
-36,562.50
-40,345.10
-28,335.40
-3,581.60
-5,863.60
-3,456.70
-22,109.40
Net Investments
-250.00
9,651.40
-2,169.20
23,938.30
-26,780.40
-8,593.00
-6,324.80
-15,861.30
-524.80
3,960.30
Others
4,953.00
-15,099.30
-7,489.10
-17,980.20
52,899.80
14,880.30
-15,066.90
3,048.80
-14,398.00
-42,300.40
Cash from Financing Activity
19,144.40
9,463.80
1,920.50
-351.40
-11,946.10
-9,657.00
2,774.40
-4,565.50
-4,010.70
39,715.30
Net Cash Inflow / Outflow
6,781.20
750.90
3,806.70
-2,675.90
1,770.50
-4,103.30
4,033.70
-471.70
153.60
-1,882.90
Opening Cash & Equivalents
5,379.30
2,846.80
-988.00
1,763.50
-141.30
3,957.50
131.10
765.20
600.80
2,496.10
Closing Cash & Equivalent
13,053.90
3,731.50
2,846.80
-988.00
1,763.50
-141.50
3,957.50
131.10
803.70
600.80

Financial Ratios

Consolidated /

Standalone
Description
Mar 20
Mar 19
Mar 18
Mar 17
Mar 16
Mar 15
Mar 14
Mar 13
Mar 12
Mar 11
Book Value (Rs.)
141.28
163.85
159.51
153.98
152.15
90.05
137.31
121.81
122.41
117.95
ROA
-10.44%
0.52%
0.47%
1.41%
2.76%
2.68%
1.51%
1.26%
2.90%
5.44%
ROE
-42.20%
1.89%
1.64%
4.80%
11.05%
10.21%
4.53%
3.79%
8.58%
13.36%
ROCE
-15.25%
4.73%
6.49%
9.49%
14.02%
11.34%
10.03%
7.27%
8.89%
12.42%
Fixed Asset Turnover
0.25
0.26
0.29
0.36
0.41
0.46
0.43
0.42
0.42
0.51
Receivable days
18.57
23.01
23.46
19.58
20.25
21.75
27.69
31.20
30.29
26.56
Inventory Days
0.51
0.36
0.26
0.94
1.54
0.98
0.54
0.57
0.88
0.80
Payable days
125.60
144.10
148.79
131.56
104.72
112.45
167.51
164.08
174.39
158.49
Cash Conversion Cycle
-106.52
-120.73
-125.07
-111.04
-82.93
-89.72
-139.29
-132.30
-143.23
-131.12
Total Debt/Equity
1.53
1.76
1.60
1.60
1.52
2.13
1.37
1.42
1.46
1.35
Interest Cover
-2.11
0.81
1.24
1.70
2.38
3.37
2.25
1.98
2.60
4.03

Annual Reports:

FY 2020
FY 2019
FY 2018
FY 2017
FY 2016
FY 2015
FY 2014
FY 2013
FY 2012
FY 2011

News Update:


  • Moody's revises Bharti Airtel’s credit outlook rating to stable
    12th Sep 2020, 10:32 AM

    Credit rating indicates ability of a company to pay back debt

    Read More
  • Bharti Airtel launches 'unlimited' category broadband plans at Rs 499 per month
    8th Sep 2020, 16:55 PM

    The new and revised plans will be rolled out September 7, 2020 onwards across 125 cities where the company has operations

    Read More
  • Bharti Airtel launches new Airtel Xstream Bundle
    7th Sep 2020, 09:53 AM

    The Airtel Xstream bundle is available to customers starting September 7, 2020

    Read More
  • Bharti Airtel inks strategic collaboration agreement with AWS
    5th Aug 2020, 15:31 PM

    Airtel Cloud will build an AWS Cloud Practice supported by AWS Professional Services

    Read More
  • TRAI gives Bharti Airtel time till August 10 on priority plan queries
    4th Aug 2020, 13:08 PM

    TRAI has granted additional time to Bharti Airtel to submit detailed responses on fresh set of questions on its premium plans

    Read More
  • Bharti Airtel reports consolidated net loss of Rs 15191 crore in Q1
    30th Jul 2020, 15:16 PM

    Total income of the company increased by 16.10% at Rs 24419.20 crore for Q1FY21

    Read More
  • Bharti Airtel - Quarterly Results
    29th Jul 2020, 19:22 PM

    Read More
  • Bharti Airtel conceptualizing 5G trials in association with OEMs, application developers
    29th Jul 2020, 09:19 AM

    These trials help to showcase company’s 5G capabilities through various eMBB and industrial use cases and applications

    Read More
  • Bharti Airtel loses 52.69 lakh subscribers in April
    25th Jul 2020, 10:24 AM

    Following this, the company’s total customer base decreased to 32.25 crore

    Read More
  • Bharti Airtel’s arm inks pact with NSDC
    23rd Jul 2020, 09:23 AM

    The partnership will leverage NSDC's experience, training infrastructure and wide network with Airtel Payment Bank's industry insights

    Read More
  • Bharti Airtel renews agreement with Ericsson to manage pan-India network operations
    21st Jul 2020, 16:31 PM

    Under the agreement, Ericsson will also manage Airtel's network operations center and field maintenance activities across India

    Read More
  • Bharti Airtel inks pact with Verizon to bring secure, world-class video conferencing solutions
    14th Jul 2020, 16:46 PM

    As part of this partnership, Airtel will offer secure enterprise-grade video conferencing solutions under the brand name - Airtel BlueJeans

    Read More
  • Bharti Airtel launches new prepaid packs with premium content from ZEE5
    8th Jul 2020, 08:59 AM

    These prepaid propositions are designed to deliver an exciting digital entertainment experience to Airtel smartphone customers by unlocking the full ZEE5 premium content catalogue

    Read More
  • Bharti Airtel launches ‘Priority 4G Network’ for Platinum mobile customers
    6th Jul 2020, 16:32 PM

    The company has deployed advanced technologies that give its Platinum mobile customers preference on the network

    Read More
  • Bharti Airtel deploys cloud-based VoLTE network powered by Nokia software products
    6th Jul 2020, 13:12 PM

    The cloud-based VoLTE deployment allows Airtel to provide its mobile customers faster and more reliable, cost-efficient call connectivity

    Read More
  • Carlyle to acquire 25% stake in Bharti Airtel’s data centre business
    1st Jul 2020, 08:52 AM

    The post-money enterprise valuation of Nxtra is approximately $1.2 billion

    Read More
  • Bharti Airtel adds 9.2 lakh subscribers in February
    30th Jun 2020, 10:16 AM

    Following this, the company’s total customer base increased to 32.90 crore

    Read More
  • Bharti Airtel acquires strategic stake in Lattu Kids
    17th Jun 2020, 15:21 PM

    The investment will enable Airtel to add Edtech to its premium digital content portfolio and give distribution scale to quality learning material from Lattu Kids

    Read More
  • Bharti Airtel’s arm acquires additional 6.3% stake in Robi Axiata
    10th Jun 2020, 09:50 AM

    The sale proceeds will be fully utilised to repay debt at Bharti Telecom and will make the promoter holding firm a 'debt free company'

    Read More

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