Edition:
India

Bharti Airtel Ltd (BRTI.NS)

BRTI.NS on National Stock Exchange of India

443.65INR
28 Sep 2020
Change (% chg)

Rs4.00 (+0.91%)
Prev Close
Rs439.65
Open
Rs446.00
Day's High
Rs447.65
Day's Low
Rs434.05
Volume
21,053,041
Avg. Vol
24,157,471
52-wk High
Rs612.00
52-wk Low
Rs325.50

Revenue & Earnings Per Share

    Revenue* Earnings Per Share**
FY 2021 Jun 239,387.00 -29.220
FY 2020 Mar '20 237,227.00 -9.696
Dec 219,471.00 -2.020
Sep 211,313.00 -44.918
Jun 207,379.00 -6.180
FY 2019 Mar '19 206,022.00 0.245
Dec 202,310.00 0.200
Sep 201,478.00 0.275
Jun 197,992.00 0.230
FY 2018 Mar '18 185,852.00 0.191
Dec 203,186.00 0.698
Sep 217,769.00 0.790
Jun 219,581.00 0.845
 
*Note: Units in Millions ofRupee
**Note: Units in Rupee

Consensus Estimates Analysis

  # of Estimates Mean High Low 1 Year Ago
SALES (in millions)
Quarter Ending Dec-20 3 245,882.00 253,669.00 230,977.00 --
Quarter Ending Mar-20 11 230,796.00 237,000.00 220,620.00 --
Year Ending Mar-20 24 870,594.00 891,681.00 858,955.00 --
Year Ending Mar-21 25 1,006,270.00 1,034,680.00 963,659.00 910,234.00
Year Ending Mar-22 25 1,137,460.00 1,217,120.00 1,028,700.00 999,802.00
Earnings (per share)
Quarter Ending Dec-20 3 -0.16 1.44 -2.04 --
Quarter Ending Mar-20 7 -0.28 5.00 -5.54 --
Year Ending Mar-20 14 -9.15 1.10 -54.88 --
Year Ending Mar-21 13 4.98 12.28 -5.00 -1.69
Year Ending Mar-22 16 15.36 24.70 5.40 2.80
Sales and Profit Figures in India Rupee (INR);

Valuation Ratios

  Company industry sector
P/E Ratio (TTM) 56.50 54.35 25.76
P/E High - Last 5 Yrs. 48.67 55.43 37.49
P/E Low - Last 5 Yrs. 23.07 19.12 14.43
Beta 1.06 0.68 0.81
Price to Sales (TTM) 1.66 1.71 3.80
Price to Book (MRQ) 2.25 2.27 5.28
Price to Tangible Book (MRQ) -- 3.44 6.17
Price to Cash Flow (TTM) 6.67 5.60 9.52
% Owned Institutions -- 0.65 0.14

Dividends

  Company industry sector
Dividend Yield 0.26 1.60 2.68
Dividend Yield - 5 Year Avg 0.53 1.41 2.79
Dividend 5 Year Growth Rate 0.00 6.20 16.21
Payout Ratio(TTM) 14.78 27.25 41.72

Growth Rates

  Company industry sector
Sales (MRQ) vs Qtr. 1 Yr. Ago -14.05 6.22 12.19
Sales (TTM) vs TTM 1 Yr. Ago -6.63 1.59 10.53
Sales - 5 Yr. Growth Rate 5.95 4.97 10.92
EPS (MRQ) vs Qtr. 1 Yr. Ago -74.86 69.96 13.95
EPS (TTM) vs TTM 1 Yr. Ago -50.17 -- --
EPS - 5 Yr. Growth Rate -3.26 -5.65 12.31
Capital Spending - 5 Yr. Growth Rate 20.75 2.36 12.06

Financial Strength

  Company industry sector
Quick Ratio (MRQ) 0.34 0.95 0.94
Current Ratio (MRQ) 0.34 1.01 1.06
LT Debt to Equity (MRQ) 128.92 71.22 73.06
Total Debt to Equity (MRQ) 151.36 93.43 93.05
Interest Coverage (TTM) 2.88 721.59 121.90

Profitability Ratios

  Company industry sector
Gross Margin (TTM) 66.83 66.94 70.81
Gross Margin - 5 Yr. Avg. 67.17 59.04 69.40
EBITD Margin (TTM) 36.50 -- --
EBITD - 5 Yr. Avg 34.24 36.78 50.80
Operating Margin (TTM) 14.28 13.88 34.94
Operating Margin - 5 Yr. Avg. 15.34 12.92 32.94
Pre-Tax Margin (TTM) 7.25 9.50 31.68
Pre-Tax Margin - 5 Yr. Avg. 9.83 7.20 29.05
Net Profit Margin (TTM) 3.67 7.14 23.97
Net Profit Margin - 5 Yr. Avg. 4.86 4.94 21.96
Effective Tax Rate (TTM) 49.34 20.21 23.64
Effective Tax Rate - 5 Yr. Avg. 50.54 17.83 23.67

Efficiency

  Company industry sector
Revenue/Employee (TTM) 40,271,712 5,238,441,271 5,156,506,837
Net Income/Employee (TTM) 1,479,246 149,937,791 1,244,923,575
Receivable Turnover (TTM) 15.78 17.92 10.53
Inventory Turnover (TTM) 250.82 58.09 37.38
Asset Turnover (TTM) 0.40 0.57 0.64

Management Effectiveness

  Company industry sector
Return on Assets (TTM) 1.47 4.76 15.23
Return on Assets - 5 Yr. Avg. 2.26 3.44 13.50
Return on Investment (TTM) 2.11 6.43 22.17
Return on Investment - 5 Yr. Avg. 3.30 4.54 20.19
Return on Equity (TTM) 4.09 9.93 24.39
Return on Equity - 5 Yr. Avg. 6.73 5.33 21.43
  1 Year 3 Year 5 Year
Sales % -1.10 3.60 5.95
EPS (TTM) % -37.48 10.68 -3.26
Dividend % -26.47 -17.79 0.00
Note: Units in Millions of US Dollars

Performance for Bharti Airtel Ltd

Period %
Actual
% vs.
S&P 500
Rank In
Industry
Industry
Rank
4 Week -5.25 -5.63 52 10
13 Week -0.93 -2.35 99 51
26 Week 10.91 3.56 99 29
52 Week 18.62 4.79 99 32
YTD 25.08 4.68 99 50
Note:: Rank is a percentile that ranges from 0 to 99, with 99 = best.

Institutional Holders

% Shares Owned: 28.78%
# of Holders: 249
Total Shares Held: 1,569,525,517
3 Mo. Net Change: -15,642,540
# New Positions: 15
# Closed Positions: 4
# Increased Positions: 100
# Reduced Positions: 76
# Net Buyers: 24
NYSE and AMEX quotes delayed by at least 20 minutes. NASDAQ delayed by at least 15 minutes. For a complete list of exchanges and delays, please click here.