BHARTIARTL
322.45
2019-01-04
BHARTI AIRTEL LTD.
Profitability metrics STANDALONE CONSOLIDATED
Asset Turnover 0.2505 0.3225
Current ratio 0.83 0.59
WC days -53.69 -138.42
EBITDA (%) 34.06 36.74
FCF (Rs Cr.) 380 3834
ROCE (%) 3.11 6.36
ROE (%) 0.08 1.58

Solvency metrics STANDALONE CONSOLIDATED
Cash Ratio 0.01 0.08
Div. payout (%) 2695.22 194.23
Int. Coverage 0.88 1.23
LT D/E 0.64 1.6
Solvency Ratio 0.2 0.18

Valuation STANDALONE CONSOLIDATED
Beta 0.9636 0.9636
Div. yield (%) 1 1
EV (Rs Cr.) 224326 264119
P/BV 1.55 2.29
P/E 2018.43 145.09
PEG 19.98 0
P/S 2.97 1.91

Balance sheet metrics STANDALONE CONSOLIDATED
BV/share 257.32 174.11
3Y growth BV/s (%) 31 12
Cash (Rs Cr.) 545.1 6670.6
Total Debt (Rs Cr.) 65415 111333
Net block (Rs Cr.) 122609 187200

P&L metrics STANDALONE CONSOLIDATED
DPS 5.33 5.34
EPS 0.2 2.75
Net Income (Rs Cr.) 79 1099
Operating profit (Rs Cr.) 17201 28819
No. of o/s shares 399.74 399.74
Revenue (Rs Cr.) 53663 83687
Total Income (Rs Cr.) 54740 86703

Cash Flow metrics STANDALONE CONSOLIDATED
CEPS (%) 3991 7468
3Y growth CEPS -0.11 0.08
CFF (Rs Cr.) 3867 1920
CFI (Rs Cr.) -19441 -27939
CFO (Rs Cr.) 15954 29853
FCF (Rs Cr.) 380 3834
3Y growth Op. CF (%) -11 8

Growth metrics STANDALONE CONSOLIDATED
3Y growth dividends (%) 38 24
1Q growth EBITDA (%) 0 0
3Y growth EBITDA (%) -26 -8
4Q growth EBITDA (%) 0 0
1Q growth EPS (%) 0 0
3Y growth EPS (%) -99 -79
4Q growth EPS (%) 0 0
3Y growth Net inc. (%) -99 -79
1Y growth Op. CF (%) -25 2
1Q growth revenue (%) 0 0
3Y growth revenue (%) -3 -9
4Q growth revenue (%) 0 0