Markets

Market Nav

RATIO ANALYSIS

You can view the ratio analysis for the last 5 years.
Bharti Airtel Ltd.
ParticularsMar 24Mar 23Mar 22Mar 21Mar 20
Months1212121212
Source Of Info (AR = Annual Report, PR = Press Release)ARARARARAR
FaceValue5.005.005.005.005.00
      
PER SHARE RATIOS     
      
Basic EPS (Rs.)13.0914.807.67-27.65-63.41
Diluted EPS (Rs.)12.8014.577.63-27.65-63.41
Cash EPS (Rs.)78.8984.5569.7231.20-6.65
Book Value[Excl.RevalReserv]/Share (Rs.)216.40210.95164.46147.90187.20
Book Value[Incl.RevalReserv]/Share (Rs.)216.40210.95164.46147.90187.20
Revenue From Operations / Share (Rs.)260.69245.27208.49183.20160.46
PBDIT / Share (Rs.)138.58127.28103.8883.7870.42
PBIT / Share (Rs.)69.8663.0644.6830.2419.66
PBT / Share (Rs.)17.3327.8618.00-26.21-79.73
Net Profit / Share (Rs.)10.1720.3310.52-22.34-57.40
NP After MI And SOA / Share (Rs.)12.9814.717.61-27.46-58.99
      
PROFITABILITY RATIOS     
      
PBDIT Margin (%)53.1551.8949.8245.7343.88
PBIT Margin (%)26.7925.7121.4316.5012.25
PBT Margin (%)6.6411.368.63-14.30-49.69
Net Profit Margin (%)3.898.295.04-12.19-35.77
NP After MI And SOA Margin (%)4.975.993.65-14.99-36.76
Return on Networth / Equity (%)7.399.196.39-25.58-41.71
Return on Capital Employeed (%)13.1311.0110.007.084.67
Return On Assets (%)1.671.861.17-4.35-8.92
Long Term Debt / Equity (X)1.301.671.711.881.18
Total Debt / Equity (X)1.501.822.002.201.52
Asset Turnover Ratio (%)0.330.240.220.200.18
      
LIQUIDITY RATIOS     
      
Current Ratio (X)0.420.470.450.490.58
Quick Ratio (X)0.410.460.450.480.58
Dividend Payout Ratio (NP) (%)30.4720.340.00-8.230.00
Dividend Payout Ratio (CP) (%)4.843.790.008.670.00
Earning Retention Ratio (%)69.5379.660.00108.230.00
Cash Earning Retention Ratio (%)95.1696.210.0091.330.00
      
COVERAGE RATIOS     
      
Interest Coverage Ratio (%)3.523.743.493.052.75
Interest Coverage Ratio (Post Tax) (%)1.591.631.250.501.64
      
VALUATION RATIOS     
      
Enterprise Value (Cr.)866218.75605930.28567069.50422698.86367084.74
EV / Net Operating Revenue (X)5.784.354.874.204.19
EV / EBITDA (X)10.868.399.779.199.56
MarketCap / Net Operating Revenue (X)4.713.053.622.822.75
Retention Ratios (%)69.5279.650.00108.230.00
Price / BV (X)7.004.686.344.823.12
Price / Net Operating Revenue (X)4.713.053.622.822.75
EarningsYield0.010.010.01-0.05-0.13
ParticularsMar 24
Months12
Source Of Info (AR = Annual Report, PR = Press Release)AR
FaceValue5.00
  
PER SHARE RATIOS 
Basic EPS (Rs.)13.09
Diluted EPS (Rs.)12.80
Cash EPS (Rs.)78.89
Book Value[Excl.RevalReserv]/Share (Rs.)216.40
Book Value[Incl.RevalReserv]/Share (Rs.)216.40
Revenue From Operations / Share (Rs.)260.69
PBDIT / Share (Rs.)138.58
PBIT / Share (Rs.)69.86
PBT / Share (Rs.)17.33
Net Profit / Share (Rs.)10.17
NP After MI And SOA / Share (Rs.)12.98
PROFITABILITY RATIOS 
PBDIT Margin (%)53.15
PBIT Margin (%)26.79
PBT Margin (%)6.64
Net Profit Margin (%)3.89
NP After MI And SOA Margin (%)4.97
Return on Networth / Equity (%)7.39
Return on Capital Employeed (%)13.13
Return On Assets (%)1.67
Long Term Debt / Equity (X)1.30
Total Debt / Equity (X)1.50
Asset Turnover Ratio (%)0.33
LIQUIDITY RATIOS 
Current Ratio (X)0.42
Quick Ratio (X)0.41
Dividend Payout Ratio (NP) (%)30.47
Dividend Payout Ratio (CP) (%)4.84
Earning Retention Ratio (%)69.53
Cash Earning Retention Ratio (%)95.16
COVERAGE RATIOS 
Interest Coverage Ratio (%)3.52
Interest Coverage Ratio (Post Tax) (%)1.59
VALUATION RATIOS 
Enterprise Value (Cr.)866218.75
EV / Net Operating Revenue (X)5.78
EV / EBITDA (X)10.86
MarketCap / Net Operating Revenue (X)4.71
Retention Ratios (%)69.52
Price / BV (X)7.00
Price / Net Operating Revenue (X)4.71
EarningsYield0.01