| Key Financial Ratios of Bharti Airtel (in Rs. Cr.) |
Mar 20 |
Mar 19 |
Mar 18 |
Mar 17 |
Mar 16 |
|
| Per Share Ratios |
|
|
|
|
|
|
| Basic EPS (Rs.) |
-63.41 |
0.96 |
2.75 |
9.51 |
15.21 |
|
| Diluted EPS (Rs.) |
-63.41 |
0.96 |
2.75 |
9.51 |
15.20 |
|
| Cash EPS (Rs.) |
-6.65 |
56.74 |
50.95 |
57.46 |
58.23 |
|
| Book Value [ExclRevalReserve]/Share (Rs.) |
187.20 |
212.51 |
196.00 |
185.95 |
180.79 |
|
| Book Value [InclRevalReserve]/Share (Rs.) |
187.20 |
212.51 |
196.00 |
185.95 |
180.79 |
|
| Revenue from Operations/Share (Rs.) |
160.46 |
202.08 |
209.98 |
239.13 |
241.49 |
|
| PBDIT/Share (Rs.) |
70.42 |
67.43 |
75.83 |
88.35 |
84.98 |
|
| PBIT/Share (Rs.) |
19.66 |
14.02 |
27.69 |
38.89 |
41.32 |
|
| PBT/Share (Rs.) |
-79.73 |
-5.22 |
5.52 |
16.71 |
29.47 |
|
| Net Profit/Share (Rs.) |
-57.40 |
3.33 |
2.81 |
8.00 |
14.58 |
|
| NP After MI And SOA / Share (Rs.) |
-58.99 |
1.02 |
2.75 |
9.51 |
15.20 |
|
| Profitability Ratios |
|
|
|
|
|
|
| PBDIT Margin (%) |
43.88 |
33.36 |
36.11 |
36.94 |
35.18 |
|
| PBIT Margin (%) |
12.25 |
6.93 |
13.18 |
16.26 |
17.11 |
|
| PBT Margin (%) |
-49.69 |
-2.58 |
2.62 |
6.98 |
12.20 |
|
| Net Profit Margin (%) |
-35.77 |
1.64 |
1.33 |
3.34 |
6.03 |
|
| NP After MI And SOA Margin (%) |
-36.76 |
0.50 |
1.30 |
3.97 |
6.29 |
|
| Return on Networth/Equity (%) |
-41.71 |
0.57 |
1.58 |
5.63 |
9.10 |
|
| Return on Capital Employed (%) |
4.67 |
3.07 |
6.42 |
9.15 |
3.63 |
|
| Return on Assets (%) |
-8.92 |
0.14 |
0.43 |
1.62 |
2.69 |
|
| Total Debt/Equity (X) |
1.52 |
1.69 |
1.41 |
1.52 |
1.50 |
|
| Asset Turnover Ratio (%) |
24.26 |
29.35 |
33.49 |
40.97 |
42.76 |
|
| Liquidity Ratios |
|
|
|
|
|
|
| Current Ratio (X) |
0.58 |
0.35 |
0.43 |
0.29 |
0.39 |
|
| Quick Ratio (X) |
0.58 |
0.35 |
0.43 |
0.29 |
0.39 |
|
| Inventory Turnover Ratio (X) |
557.93 |
913.80 |
1,211.21 |
1,958.79 |
570.52 |
|
| Dividend Payout Ratio (NP) (%) |
0.00 |
588.42 |
168.10 |
17.21 |
17.57 |
|
| Dividend Payout Ratio (CP) (%) |
0.00 |
11.07 |
9.08 |
2.77 |
4.53 |
|
| Earnings Retention Ratio (%) |
0.00 |
-488.42 |
-68.10 |
82.79 |
82.43 |
|
| Cash Earnings Retention Ratio (%) |
0.00 |
88.93 |
90.92 |
97.23 |
95.47 |
|
| Coverage Ratios |
|
|
|
|
|
|
| Interest Coverage Ratios (%) |
0.77 |
0.53 |
1.37 |
2.02 |
2.39 |
|
| Interest Coverage Ratios (Post Tax) (%) |
0.77 |
0.53 |
1.37 |
2.02 |
2.39 |
|
| Valuation Ratios |
|
|
|
|
|
|
| Enterprise Value (Cr.) |
367,084.74 |
259,208.25 |
259,498.49 |
244,247.21 |
241,120.77 |
|
| EV/Net Operating Revenue (X) |
4.19 |
3.21 |
3.09 |
2.56 |
2.50 |
|
| EV/EBITDA (X) |
9.56 |
9.62 |
8.56 |
6.92 |
7.10 |
|
| MarketCap/Net Operating Revenue (X) |
2.75 |
1.65 |
1.90 |
1.46 |
1.45 |
|
| Retention Ratios (%) |
0.00 |
-488.42 |
-68.10 |
82.78 |
82.42 |
|
| Price/BV (X) |
3.12 |
1.86 |
2.29 |
2.07 |
2.10 |
|
| Price/Net Operating Revenue |
2.75 |
1.65 |
1.90 |
1.46 |
1.45 |
|
| Earnings Yield |
-0.13 |
0.00 |
0.01 |
0.03 |
0.04 |
|
Source : Dion Global Solutions Limited
