|
Bharti Airtel Ltd.
|
Ratio Analysis
|
|
|
You can view the
Ratio Analysis
for the last 5 years.
|
Market Cap. (Rs.)
|
1057546.32 Cr.
|
P/BV
|
12.14
|
Book Value (Rs.)
|
150.17
|
|
52 Week High/Low (Rs.)
|
1904/1219
|
FV/ML
|
5/1
|
P/E(X)
|
141.63
|
|
Bookclosure
|
07/08/2024
|
EPS (Rs.)
|
12.87
|
Div Yield (%)
|
0.44
|
|
| Months | 12 | 12 | 12 | 12 | 12 |
| Source Of Info (AR = Annual Report, PR = Press Release) | AR | AR | AR | AR | AR |
| FaceValue | 5.00 | 5.00 | 5.00 | 5.00 | 5.00 |
| | | | | | |
| PER SHARE RATIOS | | | | | |
| | | | | | |
| Basic EPS (Rs.) | 13.09 | 14.80 | 7.67 | -27.65 | -63.41 |
| Diluted EPS (Rs.) | 12.80 | 14.57 | 7.63 | -27.65 | -63.41 |
| Cash EPS (Rs.) | 78.89 | 84.55 | 69.72 | 31.20 | -6.65 |
| Book Value[Excl.RevalReserv]/Share (Rs.) | 216.40 | 210.95 | 164.46 | 147.90 | 187.20 |
| Book Value[Incl.RevalReserv]/Share (Rs.) | 216.40 | 210.95 | 164.46 | 147.90 | 187.20 |
| Revenue From Operations / Share (Rs.) | 260.69 | 245.27 | 208.49 | 183.20 | 160.46 |
| PBDIT / Share (Rs.) | 138.58 | 127.28 | 103.88 | 83.78 | 70.42 |
| PBIT / Share (Rs.) | 69.86 | 63.06 | 44.68 | 30.24 | 19.66 |
| PBT / Share (Rs.) | 17.33 | 27.86 | 18.00 | -26.21 | -79.73 |
| Net Profit / Share (Rs.) | 10.17 | 20.33 | 10.52 | -22.34 | -57.40 |
| NP After MI And SOA / Share (Rs.) | 12.98 | 14.71 | 7.61 | -27.46 | -58.99 |
| | | | | | |
| PROFITABILITY RATIOS | | | | | |
| | | | | | |
| PBDIT Margin (%) | 53.15 | 51.89 | 49.82 | 45.73 | 43.88 |
| PBIT Margin (%) | 26.79 | 25.71 | 21.43 | 16.50 | 12.25 |
| PBT Margin (%) | 6.64 | 11.36 | 8.63 | -14.30 | -49.69 |
| Net Profit Margin (%) | 3.89 | 8.29 | 5.04 | -12.19 | -35.77 |
| NP After MI And SOA Margin (%) | 4.97 | 5.99 | 3.65 | -14.99 | -36.76 |
| Return on Networth / Equity (%) | 7.39 | 9.19 | 6.39 | -25.58 | -41.71 |
| Return on Capital Employeed (%) | 13.13 | 11.01 | 10.00 | 7.08 | 4.67 |
| Return On Assets (%) | 1.67 | 1.86 | 1.17 | -4.35 | -8.92 |
| Long Term Debt / Equity (X) | 1.30 | 1.67 | 1.71 | 1.88 | 1.18 |
| Total Debt / Equity (X) | 1.50 | 1.82 | 2.00 | 2.20 | 1.52 |
| Asset Turnover Ratio (%) | 0.33 | 0.24 | 0.22 | 0.20 | 0.18 |
| | | | | | |
| LIQUIDITY RATIOS | | | | | |
| | | | | | |
| Current Ratio (X) | 0.42 | 0.47 | 0.45 | 0.49 | 0.58 |
| Quick Ratio (X) | 0.41 | 0.46 | 0.45 | 0.48 | 0.58 |
| Dividend Payout Ratio (NP) (%) | 30.47 | 20.34 | 0.00 | -8.23 | 0.00 |
| Dividend Payout Ratio (CP) (%) | 4.84 | 3.79 | 0.00 | 8.67 | 0.00 |
| Earning Retention Ratio (%) | 69.53 | 79.66 | 0.00 | 108.23 | 0.00 |
| Cash Earning Retention Ratio (%) | 95.16 | 96.21 | 0.00 | 91.33 | 0.00 |
| | | | | | |
| COVERAGE RATIOS | | | | | |
| | | | | | |
| Interest Coverage Ratio (%) | 3.52 | 3.74 | 3.49 | 3.05 | 2.75 |
| Interest Coverage Ratio (Post Tax) (%) | 1.59 | 1.63 | 1.25 | 0.50 | 1.64 |
| | | | | | |
| VALUATION RATIOS | | | | | |
| | | | | | |
| Enterprise Value (Cr.) | 866218.75 | 605930.28 | 567069.50 | 422698.86 | 367084.74 |
| EV / Net Operating Revenue (X) | 5.78 | 4.35 | 4.87 | 4.20 | 4.19 |
| EV / EBITDA (X) | 10.86 | 8.39 | 9.77 | 9.19 | 9.56 |
| MarketCap / Net Operating Revenue (X) | 4.71 | 3.05 | 3.62 | 2.82 | 2.75 |
| Retention Ratios (%) | 69.52 | 79.65 | 0.00 | 108.23 | 0.00 |
| Price / BV (X) | 7.00 | 4.68 | 6.34 | 4.82 | 3.12 |
| Price / Net Operating Revenue (X) | 4.71 | 3.05 | 3.62 | 2.82 | 2.75 |
| EarningsYield | 0.01 | 0.01 | 0.01 | -0.05 | -0.13 |
