media

Markets

Market Nav

RATIO ANALYSIS

You can view the ratio analysis for the last 5 years.
Bharti Airtel Ltd.
ParticularsMar 23Mar 22Mar 21Mar 20Mar 19
Months1212121212
Source Of Info (AR = Annual Report, PR = Press Release)ARARARARAR
FaceValue5.005.005.005.005.00
      
PER SHARE RATIOS     
      
Basic EPS (Rs.)14.807.67-27.65-63.410.96
Diluted EPS (Rs.)14.577.63-27.65-63.410.96
Cash EPS (Rs.)84.5569.7231.20-6.6556.73
Book Value[Excl.RevalReserv]/Share (Rs.)210.95164.46147.90187.20212.51
Book Value[Incl.RevalReserv]/Share (Rs.)210.95164.46147.90187.20212.51
Revenue From Operations / Share (Rs.)245.27208.49183.20160.46202.08
PBDIT / Share (Rs.)127.28103.8883.7870.4267.43
PBIT / Share (Rs.)63.0644.6830.2419.6614.02
PBT / Share (Rs.)27.8618.00-26.21-79.73-5.22
Net Profit / Share (Rs.)20.3310.52-22.34-57.403.33
NP After MI And SOA / Share (Rs.)14.717.61-27.46-58.991.02
      
PROFITABILITY RATIOS     
      
PBDIT Margin (%)51.8949.8245.7343.8833.36
PBIT Margin (%)25.7121.4316.5012.256.93
PBT Margin (%)11.368.63-14.30-49.69-2.58
Net Profit Margin (%)8.295.04-12.19-35.771.64
NP After MI And SOA Margin (%)5.993.65-14.99-36.760.50
Return on Networth / Equity (%)9.196.39-25.58-41.710.57
Return on Capital Employeed (%)11.0110.007.084.673.07
Return On Assets (%)1.861.17-4.35-8.920.14
Long Term Debt / Equity (X)1.671.711.881.181.15
Total Debt / Equity (X)1.822.002.201.521.69
Asset Turnover Ratio (%)0.240.220.200.180.20
      
LIQUIDITY RATIOS     
      
Current Ratio (X)0.470.450.490.580.35
Quick Ratio (X)0.460.450.480.580.35
Dividend Payout Ratio (NP) (%)20.340.00-8.230.00588.42
Dividend Payout Ratio (CP) (%)3.790.008.670.0011.07
Earning Retention Ratio (%)79.660.00108.230.00-488.42
Cash Earning Retention Ratio (%)96.210.0091.330.0088.93
      
COVERAGE RATIOS     
      
Interest Coverage Ratio (%)3.743.493.052.752.54
Interest Coverage Ratio (Post Tax) (%)1.631.250.501.640.84
      
VALUATION RATIOS     
      
Enterprise Value (Cr.)605930.28567069.50422698.86367084.74259208.25
EV / Net Operating Revenue (X)4.354.874.204.193.21
EV / EBITDA (X)8.399.779.199.569.62
MarketCap / Net Operating Revenue (X)3.053.622.822.751.65
Retention Ratios (%)79.650.00108.230.00-488.42
Price / BV (X)4.686.344.823.121.86
Price / Net Operating Revenue (X)3.053.622.822.751.65
EarningsYield0.010.01-0.05-0.130.00
ParticularsMar 23
Months12
Source Of Info (AR = Annual Report, PR = Press Release)AR
FaceValue5.00
  
PER SHARE RATIOS 
Basic EPS (Rs.)14.80
Diluted EPS (Rs.)14.57
Cash EPS (Rs.)84.55
Book Value[Excl.RevalReserv]/Share (Rs.)210.95
Book Value[Incl.RevalReserv]/Share (Rs.)210.95
Revenue From Operations / Share (Rs.)245.27
PBDIT / Share (Rs.)127.28
PBIT / Share (Rs.)63.06
PBT / Share (Rs.)27.86
Net Profit / Share (Rs.)20.33
NP After MI And SOA / Share (Rs.)14.71
PROFITABILITY RATIOS 
PBDIT Margin (%)51.89
PBIT Margin (%)25.71
PBT Margin (%)11.36
Net Profit Margin (%)8.29
NP After MI And SOA Margin (%)5.99
Return on Networth / Equity (%)9.19
Return on Capital Employeed (%)11.01
Return On Assets (%)1.86
Long Term Debt / Equity (X)1.67
Total Debt / Equity (X)1.82
Asset Turnover Ratio (%)0.24
LIQUIDITY RATIOS 
Current Ratio (X)0.47
Quick Ratio (X)0.46
Dividend Payout Ratio (NP) (%)20.34
Dividend Payout Ratio (CP) (%)3.79
Earning Retention Ratio (%)79.66
Cash Earning Retention Ratio (%)96.21
COVERAGE RATIOS 
Interest Coverage Ratio (%)3.74
Interest Coverage Ratio (Post Tax) (%)1.63
VALUATION RATIOS 
Enterprise Value (Cr.)605930.28
EV / Net Operating Revenue (X)4.35
EV / EBITDA (X)8.39
MarketCap / Net Operating Revenue (X)3.05
Retention Ratios (%)79.65
Price / BV (X)4.68
Price / Net Operating Revenue (X)3.05
EarningsYield0.01