BHARTI AIRTEL LTD.
Market Cap.(`)
|
777879.62 Cr.
|
P/BV
|
10.02
|
Book Value (`)
|
134.47
|
52 Week High/Low ( ` )
|
1360/793
|
FV/ML
|
5/1
|
P/E(X)
|
104.18
|
Book Closure
|
11/08/2023
|
EPS (`)
|
12.94
|
Div Yield (%)
|
0.59
|
You can view the
Consolidated
Ratio Analysis
for the last 5 years.
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.) | 14.80 | 7.67 | -27.65 | -63.41 | 0.96 |
Diluted EPS (Rs.) | 14.57 | 7.63 | -27.65 | -63.41 | 0.96 |
Cash EPS (Rs.) | 84.55 | 69.72 | 31.20 | -6.65 | 56.73 |
Book Value[Excl.RevalReserv]/Share (Rs.) | 210.95 | 164.46 | 147.90 | 187.20 | 212.51 |
Book Value[Incl.RevalReserv]/Share (Rs.) | 210.95 | 164.46 | 147.90 | 187.20 | 212.51 |
Revenue From Operations / Share (Rs.) | 245.27 | 208.49 | 183.20 | 160.46 | 202.08 |
PBDIT / Share (Rs.) | 127.28 | 103.88 | 83.78 | 70.42 | 67.43 |
PBIT / Share (Rs.) | 63.06 | 44.68 | 30.24 | 19.66 | 14.02 |
PBT / Share (Rs.) | 27.86 | 18.00 | -26.21 | -79.73 | -5.22 |
Net Profit / Share (Rs.) | 20.33 | 10.52 | -22.34 | -57.40 | 3.33 |
NP After MI And SOA / Share (Rs.) | 14.71 | 7.61 | -27.46 | -58.99 | 1.02 |
| | | | | |
PROFITABILITY RATIOS | | | | | |
| | | | | |
PBDIT Margin (%) | 51.89 | 49.82 | 45.73 | 43.88 | 33.36 |
PBIT Margin (%) | 25.71 | 21.43 | 16.50 | 12.25 | 6.93 |
PBT Margin (%) | 11.36 | 8.63 | -14.30 | -49.69 | -2.58 |
Net Profit Margin (%) | 8.29 | 5.04 | -12.19 | -35.77 | 1.64 |
NP After MI And SOA Margin (%) | 5.99 | 3.65 | -14.99 | -36.76 | 0.50 |
Return on Networth / Equity (%) | 9.19 | 6.39 | -25.58 | -41.71 | 0.57 |
Return on Capital Employeed (%) | 11.01 | 10.00 | 7.08 | 4.67 | 3.07 |
Return On Assets (%) | 1.86 | 1.17 | -4.35 | -8.92 | 0.14 |
Long Term Debt / Equity (X) | 1.67 | 1.71 | 1.88 | 1.18 | 1.15 |
Total Debt / Equity (X) | 1.82 | 2.00 | 2.20 | 1.52 | 1.69 |
Asset Turnover Ratio (%) | 0.24 | 0.22 | 0.20 | 0.18 | 0.20 |
| | | | | |
LIQUIDITY RATIOS | | | | | |
| | | | | |
Current Ratio (X) | 0.47 | 0.45 | 0.49 | 0.58 | 0.35 |
Quick Ratio (X) | 0.46 | 0.45 | 0.48 | 0.58 | 0.35 |
Dividend Payout Ratio (NP) (%) | 20.34 | 0.00 | -8.23 | 0.00 | 588.42 |
Dividend Payout Ratio (CP) (%) | 3.79 | 0.00 | 8.67 | 0.00 | 11.07 |
Earning Retention Ratio (%) | 79.66 | 0.00 | 108.23 | 0.00 | -488.42 |
Cash Earning Retention Ratio (%) | 96.21 | 0.00 | 91.33 | 0.00 | 88.93 |
| | | | | |
COVERAGE RATIOS | | | | | |
| | | | | |
Interest Coverage Ratio (%) | 3.74 | 3.49 | 3.05 | 2.75 | 2.54 |
Interest Coverage Ratio (Post Tax) (%) | 1.63 | 1.25 | 0.50 | 1.64 | 0.84 |
| | | | | |
VALUATION RATIOS | | | | | |
| | | | | |
Enterprise Value (Cr.) | 605930.28 | 567069.50 | 422698.86 | 367084.74 | 259208.25 |
EV / Net Operating Revenue (X) | 4.35 | 4.87 | 4.20 | 4.19 | 3.21 |
EV / EBITDA (X) | 8.39 | 9.77 | 9.19 | 9.56 | 9.62 |
MarketCap / Net Operating Revenue (X) | 3.05 | 3.62 | 2.82 | 2.75 | 1.65 |
Retention Ratios (%) | 79.65 | 0.00 | 108.23 | 0.00 | -488.42 |
Price / BV (X) | 4.68 | 6.34 | 4.82 | 3.12 | 1.86 |
Price / Net Operating Revenue (X) | 3.05 | 3.62 | 2.82 | 2.75 | 1.65 |
EarningsYield | 0.01 | 0.01 | -0.05 | -0.13 | 0.00 |