Toll Free: 1800 22 0369 / 1800 103 1369 Email Us: customercare@canmoney.in
Market

Ratio Analysis

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

RATIOS

Bharti Airtel Ltd.

GO
Market Cap. ( ₹ in Cr. ) 299510.10 P/BV 3.88 Book Value ( ₹ ) 141.41
52 Week High/Low ( ₹ ) 612/326 FV/ML 5/1 P/E(X) 0.00
Book Closure 07/08/2020 EPS ( ₹ ) 0.00 Div Yield (%) 0.36
Reported EPS (₹ Cr.)
NP After MI And SOA Margin (%)
Book Value (₹ Cr.)
Return on Networth (%)

ParticularsMar 20Mar 19Mar 18Mar 17Mar 16
Months1212121212
Source Of Info (AR = Annual Report, PR = Press Release)ARARARARAR
FaceValue5.005.005.005.005.00
      
PER SHARE RATIOS     
      
Basic EPS (Rs.)-63.410.962.759.5115.21
Diluted EPS (Rs.)-63.410.962.759.5115.20
Cash EPS (Rs.)-6.6556.7350.9557.4658.23
Book Value[Excl.RevalReserv]/Share (Rs.)187.20212.51196.00185.95180.79
Book Value[Incl.RevalReserv]/Share (Rs.)187.20212.51196.00185.95180.79
Revenue From Operations / Share (Rs.)160.46202.08209.98239.13241.49
PBDIT / Share (Rs.)70.4267.4375.8388.3584.98
PBIT / Share (Rs.)19.6614.0227.6938.8941.32
PBT / Share (Rs.)-79.73-5.225.5216.7129.47
Net Profit / Share (Rs.)-57.403.332.818.0014.57
NP After MI And SOA / Share (Rs.)-58.991.022.759.5115.20
      
PROFITABILITY RATIOS     
      
PBDIT Margin (%)43.8833.3636.1136.9435.18
PBIT Margin (%)12.256.9313.1816.2617.11
PBT Margin (%)-49.69-2.582.626.9812.20
Net Profit Margin (%)-35.771.641.333.346.03
NP After MI And SOA Margin (%)-36.760.501.303.976.29
Return on Networth / Equity (%)-41.710.571.585.639.10
Return on Capital Employeed (%)4.673.076.429.159.88
Return On Assets (%)-8.920.140.431.622.69
Long Term Debt / Equity (X)1.181.151.221.331.34
Total Debt / Equity (X)1.521.691.411.521.50
Asset Turnover Ratio (%)24.2629.3533.4940.9742.76
      
LIQUIDITY RATIOS     
      
Current Ratio (X)0.580.350.420.280.38
Quick Ratio (X)0.580.350.420.280.38
Inventory Turnover Ratio (X)557.93913.801211.211958.79570.52
Dividend Payout Ratio (NP) (%)0.00588.42168.1017.2117.57
Dividend Payout Ratio (CP) (%)0.0011.079.082.774.53
Earning Retention Ratio (%)0.00-488.42-68.1082.7982.43
Cash Earning Retention Ratio (%)0.0088.9390.9297.2395.47
      
COVERAGE RATIOS     
      
Interest Coverage Ratio (%)0.760.521.372.022.39
Interest Coverage Ratio (Post Tax) (%)1.640.841.241.571.53
      
VALUATION RATIOS     
      
Enterprise Value (Cr.)367084.74259208.25259498.49244247.21241120.77
EV / Net Operating Revenue (X)4.193.213.092.562.50
EV / EBITDA (X)9.569.628.566.927.10
MarketCap / Net Operating Revenue (X)2.751.651.901.461.45
Retention Ratios (%)0.00-488.42-68.1082.7882.42
Price / BV (X)3.121.862.292.072.10
Price / Net Operating Revenue (X)2.751.651.901.461.45
EarningsYield-0.130.000.010.020.04
ParticularsMar 20
Months12
Source Of Info (AR = Annual Report, PR = Press Release)AR
FaceValue5.00
  
PER SHARE RATIOS 
Basic EPS (Rs.)-63.41
Diluted EPS (Rs.)-63.41
Cash EPS (Rs.)-6.65
Book Value[Excl.RevalReserv]/Share (Rs.)187.20
Book Value[Incl.RevalReserv]/Share (Rs.)187.20
Revenue From Operations / Share (Rs.)160.46
PBDIT / Share (Rs.)70.42
PBIT / Share (Rs.)19.66
PBT / Share (Rs.)-79.73
Net Profit / Share (Rs.)-57.40
NP After MI And SOA / Share (Rs.)-58.99
PROFITABILITY RATIOS 
PBDIT Margin (%)43.88
PBIT Margin (%)12.25
PBT Margin (%)-49.69
Net Profit Margin (%)-35.77
NP After MI And SOA Margin (%)-36.76
Return on Networth / Equity (%)-41.71
Return on Capital Employeed (%)4.67
Return On Assets (%)-8.92
Long Term Debt / Equity (X)1.18
Total Debt / Equity (X)1.52
Asset Turnover Ratio (%)24.26
LIQUIDITY RATIOS 
Current Ratio (X)0.58
Quick Ratio (X)0.58
Inventory Turnover Ratio (X)557.93
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 (%)0.76
Interest Coverage Ratio (Post Tax) (%)1.64
VALUATION RATIOS 
Enterprise Value (Cr.)367084.74
EV / Net Operating Revenue (X)4.19
EV / EBITDA (X)9.56
MarketCap / Net Operating Revenue (X)2.75
Retention Ratios (%)0.00
Price / BV (X)3.12
Price / Net Operating Revenue (X)2.75
EarningsYield-0.13