Market

Ratio Analysis

You can view the Ratio Analysis for the last 5 years.

RATIOS

Bharti Airtel Ltd.

GO
Market Cap. ( ₹ in Cr. ) 1052152.15 P/BV 12.08 Book Value ( ₹ ) 150.17
52 Week High/Low ( ₹ ) 1917/1219 FV/ML 5/1 P/E(X) 31.36
Book Closure 07/08/2024 EPS ( ₹ ) 57.85 Div Yield (%) 0.88

ParticularsMar 25Mar 24Mar 23Mar 22Mar 21
Months1212121212
Source Of Info (AR = Annual Report, PR = Press Release)PRARARARAR
FaceValue5.005.005.005.005.00
      
PER SHARE RATIOS     
      
Basic EPS (Rs.)58.0013.0914.807.67-27.65
Diluted EPS (Rs.)56.0412.8014.577.63-27.65
Cash EPS (Rs.)136.8078.8984.5569.7231.20
Book Value[Excl.RevalReserv]/Share (Rs.)195.98216.40210.95164.46147.90
Book Value[Incl.RevalReserv]/Share (Rs.)195.98216.40210.95164.46147.90
Revenue From Operations / Share (Rs.)298.24260.69245.27208.49183.20
PBDIT / Share (Rs.)163.33138.58127.28103.8883.78
PBIT / Share (Rs.)84.7669.8663.0644.6830.24
PBT / Share (Rs.)59.8217.3327.8618.00-26.21
Net Profit / Share (Rs.)58.2410.1720.3310.52-22.34
NP After MI And SOA / Share (Rs.)57.8512.9814.717.61-27.46
      
PROFITABILITY RATIOS     
      
PBDIT Margin (%)54.7653.1551.8949.8245.73
PBIT Margin (%)28.4226.7925.7121.4316.50
PBT Margin (%)20.056.6411.368.63-14.30
Net Profit Margin (%)19.523.898.295.04-12.19
NP After MI And SOA Margin (%)19.394.975.993.65-14.99
Return on Networth / Equity (%)29.527.399.196.39-25.58
Return on Capital Employeed (%)14.7213.1311.0110.007.08
Return On Assets (%)6.521.671.861.17-4.35
Long Term Debt / Equity (X)0.921.301.671.711.88
Total Debt / Equity (X)1.301.501.822.002.20
Asset Turnover Ratio (%)0.360.330.240.220.20
      
LIQUIDITY RATIOS     
      
Current Ratio (X)0.370.420.470.450.49
Quick Ratio (X)0.370.410.460.450.48
Dividend Payout Ratio (NP) (%)0.0030.4720.340.00-8.23
Dividend Payout Ratio (CP) (%)0.004.843.790.008.67
Earning Retention Ratio (%)0.0069.5379.660.00108.23
Cash Earning Retention Ratio (%)0.0095.1696.210.0091.33
      
COVERAGE RATIOS     
      
Interest Coverage Ratio (%)4.353.523.743.493.05
Interest Coverage Ratio (Post Tax) (%)2.221.591.631.250.50
      
VALUATION RATIOS     
      
Enterprise Value (Cr.)1226297.15866218.75605930.28567069.50422698.86
EV / Net Operating Revenue (X)6.795.784.354.874.20
EV / EBITDA (X)12.4110.868.399.779.19
MarketCap / Net Operating Revenue (X)5.804.713.053.622.82
Retention Ratios (%)0.0069.5279.650.00108.23
Price / BV (X)8.837.004.686.344.82
Price / Net Operating Revenue (X)5.804.713.053.622.82
EarningsYield0.030.010.010.01-0.05
ParticularsMar 25
Months12
Source Of Info (AR = Annual Report, PR = Press Release)PR
FaceValue5.00
  
PER SHARE RATIOS 
Basic EPS (Rs.)58.00
Diluted EPS (Rs.)56.04
Cash EPS (Rs.)136.80
Book Value[Excl.RevalReserv]/Share (Rs.)195.98
Book Value[Incl.RevalReserv]/Share (Rs.)195.98
Revenue From Operations / Share (Rs.)298.24
PBDIT / Share (Rs.)163.33
PBIT / Share (Rs.)84.76
PBT / Share (Rs.)59.82
Net Profit / Share (Rs.)58.24
NP After MI And SOA / Share (Rs.)57.85
PROFITABILITY RATIOS 
PBDIT Margin (%)54.76
PBIT Margin (%)28.42
PBT Margin (%)20.05
Net Profit Margin (%)19.52
NP After MI And SOA Margin (%)19.39
Return on Networth / Equity (%)29.52
Return on Capital Employeed (%)14.72
Return On Assets (%)6.52
Long Term Debt / Equity (X)0.92
Total Debt / Equity (X)1.30
Asset Turnover Ratio (%)0.36
LIQUIDITY RATIOS 
Current Ratio (X)0.37
Quick Ratio (X)0.37
Dividend Payout Ratio (NP) (%)0.00
Dividend Payout Ratio (CP) (%)0.00
Earning Retention Ratio (%)0.00
Cash Earning Retention Ratio (%)0.00
COVERAGE RATIOS 
Interest Coverage Ratio (%)4.35
Interest Coverage Ratio (Post Tax) (%)2.22
VALUATION RATIOS 
Enterprise Value (Cr.)1226297.15
EV / Net Operating Revenue (X)6.79
EV / EBITDA (X)12.41
MarketCap / Net Operating Revenue (X)5.80
Retention Ratios (%)0.00
Price / BV (X)8.83
Price / Net Operating Revenue (X)5.80
EarningsYield0.03