Company Profile

BHARTI AIRTEL LTD.

NSE : BHARTIARTLBSE : 532454ISIN CODE : INE397D01024Industry : Telecommunication - Service ProviderHouse : Bharti
BSE540.551.35 (+0.25 % )
PREV CLOSE (Rs.) 539.20
OPEN PRICE (Rs.) 540.00
BID PRICE (QTY) 0.00 (0 )
OFFER PRICE (QTY) 0.00 (0 )
VOLUME 911363
TODAY'S LOW / HIGH (Rs.)538.30 544.30
52 WK LOW / HIGH (Rs.)394.05 623
NSE540.75 1.4 (+0.26 % )
PREV CLOSE(Rs.) 539.35
OPEN PRICE (Rs.) 540.05
BID PRICE (QTY) 0.00 (0 )
OFFER PRICE (QTY) 540.75 (10214 )
VOLUME 6157781
TODAY'S LOW / HIGH(Rs.) 538.00 544.15
52 WK LOW / HIGH (Rs.)394 623

Financial ratio

Particulars Mar  2020 Mar  2019 Mar  2018 Mar  2017 Mar  2016
Operational & Financial Ratios          
   Earnings Per Share (Rs) -58.99 1.02 2.75 9.51 15.20
   CEPS(Rs) -6.65 52.08 46.77 52.75 53.45
   DPS(Rs) 2.00 2.50 5.34 1.00 1.36
   Book NAV/Share(Rs) 141.28 178.49 173.75 167.73 165.74
   Tax Rate(%) 28.01 163.81 49.11 52.14 50.54
Margin Ratios          
   Core EBITDA Margin(%) 41.68 29.90 36.35 36.87 35.10
   EBIT Margin(%) -33.71 10.57 13.95 17.00 21.06
   Pre Tax Margin(%) -49.69 -2.58 2.67 7.00 12.20
   PAT Margin (%) -35.77 1.65 1.36 3.35 6.04
   Cash Profit Margin (%) -4.14 28.08 24.64 24.06 24.11
Performance Ratios          
   ROA(%) -10.44 0.52 0.47 1.41 2.76
   ROE(%) -42.20 1.89 1.64 4.80 11.05
   ROCE(%) -15.25 4.58 6.49 9.49 14.02
   Asset Turnover(x) 0.29 0.31 0.35 0.42 0.46
   Sales/Fixed Asset(x) 0.25 0.26 0.29 0.36 0.41
   Working Capital/Sales(x) -1.60 -1.34 -1.85 -2.11 -2.70
Efficiency Ratios          
   Fixed Capital/Sales(x) 4.02 3.85 3.42 2.78 2.42
   Receivable days 18.57 23.01 23.46 19.58 20.25
   Inventory Days 0.51 0.36 0.26 0.94 1.54
   Payable days 125.60 138.71 148.74 131.56 104.72
Valuation Parameters          
   PER(x) 0.00 298.32 133.19 33.80 21.19
   PCE(x) -66.27 5.87 7.83 6.09 6.03
   Price/Book(x) 3.12 1.87 2.30 2.09 2.12
   Yield(%) 0.45 0.75 1.34 0.29 0.39
   EV/Net Sales(x) 3.91 3.04 3.20 2.54 2.44
   EV/Core EBITDA(x) 8.90 9.12 8.37 6.51 6.62
   EV/EBIT(x) -11.59 28.79 22.90 14.92 11.59
   EV/CE(x) 1.02 0.92 1.07 1.05 1.06
   M Cap / Sales 2.75 1.65 1.93 1.47 1.45
Growth Ratio          
   Net Sales Growth(%) 8.37 -2.25 -13.44 -1.10 0.45
   Core EBITDA Growth(%) 42.53 -14.62 -15.07 4.40 -0.27
   EBIT Growth(%) -445.73 -25.99 -28.93 -20.18 35.63
   PAT Growth(%) -2451.27 18.64 -64.88 -45.14 15.30
   EPS Growth(%) -5858.51 -62.74 -71.08 -37.47 31.51
Financial Stability Ratios          
   Total Debt/Equity(x) 1.53 1.69 1.60 1.60 1.52
   Current Ratio(x) 0.58 0.35 0.43 0.29 0.39
   Quick Ratio(x) 0.58 0.35 0.43 0.29 0.38
   Interest Cover(x) -2.11 0.80 1.24 1.70 2.38
   Total Debt/Mcap(x) 0.49 0.91 0.70 0.77 0.72