Edition:
United Kingdom

Bharti Infratel Ltd (BHRI.NS)

BHRI.NS on National Stock Exchange of India

354.50INR
15 Dec 2017
Change (% chg)

Rs-2.15 (-0.60%)
Prev Close
Rs356.65
Open
Rs358.05
Day's High
Rs361.45
Day's Low
Rs353.30
Volume
2,416,817
Avg. Vol
5,007,873
52-wk High
Rs482.80
52-wk Low
Rs281.75

Revenue & Earnings Per Share

    Revenue* Earnings Per Share**
FY 2018 Sep 16,587.00 3.453
Jun 15,934.00 3.591
FY 2017 Mar '17 16,053.00 3.197
Dec 15,300.00 3.354
Sep 14,963.00 4.141
Jun 14,531.00 3.990
FY 2016 Mar '16 14,181.00 3.792
Dec 13,959.00 2.610
Sep 13,726.00 3.122
Jun 13,717.00 2.340
FY 2015 Mar '15 29,467.00 2.938
Dec 29,488.00 2.677
Sep 29,301.00 2.457
Jun 28,427.00 2.445
 
*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 Mar-17 12 34,871.50 35,280.00 34,577.00 --
Quarter Ending Jun-18 2 36,398.70 37,558.50 35,239.00 --
Year Ending Mar-17 21 133,863.00 135,099.00 133,083.00 --
Year Ending Mar-18 25 147,149.00 153,403.00 144,467.00 143,755.00
Year Ending Mar-19 25 156,876.00 167,000.00 150,648.00 155,277.00
Earnings (per share)
Quarter Ending Mar-17 9 3.64 4.04 3.48 --
Quarter Ending Jun-18 3 3.94 4.37 3.59 --
Year Ending Mar-17 23 15.11 16.13 14.25 --
Year Ending Mar-18 27 15.85 17.85 14.24 16.22
Year Ending Mar-19 27 17.75 21.36 13.10 18.18
LT Growth Rate (%) 3 8.23 18.82 -1.70 17.38
Sales and Profit Figures in India Rupee (INR);

Valuation Ratios

  Company industry sector
P/E Ratio (TTM) 28.00 21.36 27.87
P/E High - Last 5 Yrs. 36.57 42.70 45.33
P/E Low - Last 5 Yrs. 22.14 13.67 14.74
Beta 0.78 0.80 0.78
Price to Sales (TTM) 11.88 4.30 3.83
Price to Book (MRQ) 4.59 6.00 5.36
Price to Tangible Book (MRQ) 4.59 7.07 6.39
Price to Cash Flow (TTM) 19.16 10.64 9.70
% Owned Institutions -- 0.09 0.13

Dividends

  Company industry sector
Dividend Yield 4.00 2.85 2.56
Dividend Yield - 5 Year Avg 2.54 2.96 2.63
Dividend 5 Year Growth Rate -- 18.19 15.85
Payout Ratio(TTM) 27.87 44.75 41.02

Growth Rates

  Company industry sector
Sales (MRQ) vs Qtr. 1 Yr. Ago 9.66 12.73 11.62
Sales (TTM) vs TTM 1 Yr. Ago 10.38 11.67 9.87
Sales - 5 Yr. Growth Rate -8.43 12.00 11.04
EPS (MRQ) vs Qtr. 1 Yr. Ago -10.00 6.38 16.16
EPS (TTM) vs TTM 1 Yr. Ago 5.69 -- --
EPS - 5 Yr. Growth Rate 27.96 16.02 12.07
Capital Spending - 5 Yr. Growth Rate -8.48 13.27 11.54

Financial Strength

  Company industry sector
Quick Ratio (MRQ) -- 0.91 0.89
Current Ratio (MRQ) 2.46 1.06 1.02
LT Debt to Equity (MRQ) 1.54 92.13 93.39
Total Debt to Equity (MRQ) 2.32 117.32 119.49
Interest Coverage (TTM) -- 25.84 90.39

Profitability Ratios

  Company industry sector
Gross Margin (TTM) 65.70 71.91 71.26
Gross Margin - 5 Yr. Avg. 63.61 71.36 69.77
EBITD Margin (TTM) 47.87 -- --
EBITD - 5 Yr. Avg 42.00 53.91 51.05
Operating Margin (TTM) 28.48 39.98 35.33
Operating Margin - 5 Yr. Avg. 21.81 37.52 33.16
Pre-Tax Margin (TTM) 58.80 35.93 31.01
Pre-Tax Margin - 5 Yr. Avg. 30.32 33.00 28.31
Net Profit Margin (TTM) 42.65 27.13 23.48
Net Profit Margin - 5 Yr. Avg. 21.41 25.12 21.48
Effective Tax Rate (TTM) 27.47 24.29 22.15
Effective Tax Rate - 5 Yr. Avg. 29.39 24.45 23.04

Efficiency

  Company industry sector
Revenue/Employee (TTM) 26,489,360 5,189,581,530 5,292,922,469
Net Income/Employee (TTM) 11,296,600 1,467,440,766 1,243,624,235
Receivable Turnover (TTM) 61.88 9.32 10.59
Inventory Turnover (TTM) -- 33.11 38.49
Asset Turnover (TTM) 0.31 0.63 0.61

Management Effectiveness

  Company industry sector
Return on Assets (TTM) 13.39 16.39 14.20
Return on Assets - 5 Yr. Avg. 7.98 14.70 12.61
Return on Investment (TTM) 14.52 23.94 20.68
Return on Investment - 5 Yr. Avg. 9.14 22.06 18.84
Return on Equity (TTM) 15.14 27.17 24.13
Return on Equity - 5 Yr. Avg. 11.04 24.37 21.20
  1 Year 3 Year 5 Year
Sales % 9.47 -17.48 -8.43
EPS (TTM) % 24.18 22.44 27.96
Dividend % 433.33 53.78 --
Note: Units in Millions of US Dollars

Performance for Bharti Infratel Ltd

Period %
Actual
% vs.
S&P 500
Rank In
Industry
Industry
Rank
4 Week 7.91 7.48 99 15
13 Week -1.09 -2.50 99 25
26 Week 15.06 7.44 99 53
52 Week 4.89 -7.33 99 25
YTD 16.45 -2.54 99 45
Note:: Rank is a percentile that ranges from 0 to 99, with 99 = best.

Institutional Holders

% Shares Owned: 19.00%
# of Holders: 175
Total Shares Held: 351,464,046
3 Mo. Net Change: 20,469,509
# New Positions: 8
# Closed Positions: 6
# Increased Positions: 50
# Reduced Positions: 52
# Net Buyers: -2
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.