BHARTI AIRTEL LIMITE

532454
End-of-day quote. End-of-day quote  - 01/19
592.5INR +0.99%
Income Statement Evolution
Annual Income Statement Data
Fiscal Period: March 2020 2021
Net sales1 875 3901 021 467
EBITDA1 369 343461 416
Operating profit (EBIT)1 92 447163 902
Operating Margin 10,6%16,0%
Pre-Tax Profit (EBT)1 -428 465-81 896
Net income1 -321 832-144 306
Net margin -36,8%-14,1%
EPS2 -63,4-26,6
Dividend per Share2 2,001,79
Last update 05/18/202001/17/2021
1 INR in Million
2 INR
Estimates
Finances - Leverage
Fiscal Period: March 2020 2021
Net Debt1 975 1521 348 302
Net Cash position1 --
Leverage (Debt / EBITDA) 2,64x2,92x
Free Cash Flow1 -10 615149 354
ROE (Net Profit / Equities) -4,56%0,33%
Shareholders' equity1 7 055 398-43 919 309
ROA (Net Profit / Asset) -1,07%0,43%
Assets1 30 201 952-33 325 406
Book Value Per Share2 141122
Cash Flow per Share2 35,756,9
Capex1 191 902229 897
Capex / Sales 21,9%22,5%
Last update 05/18/202001/18/2021
1 INR in Million
2 INR
Estimates
Balance Sheet Analysis
Financial Ratios
Size 2021e 2022e
Capitalization 3 231 131 M INR -
Entreprise Value (EV) 4 579 433 M INR 4 527 750 M INR
Valuation 2021e 2022e
P/E ratio (Price / EPS) -22,3x 48,6x
Capitalization / Revenue 3,16x 2,83x
EV / Revenue 4,48x 4,01x
EV / EBITDA 9,92x 8,35x
Yield (DPS / Price) 0,30% 0,43%
Price to book (Price / BVPS) 4,88x 4,44x
Profitability 2021e 2022e
Operating Margin (EBIT / Sales) 16,0% 21,0%
Operating Leverage (Delta EBIT / Delta Sales) 4,63x 3,91x
Net Margin (Net Profit / Revenue) -14,1% 6,19%
ROA (Net Profit / Asset) 0,43% 2,57%
ROE (Net Profit / Equities) 0,33% 11,7%
Rate of Dividend -6,74% 20,7%
Balance Sheet Analysis 2021e 2022e
CAPEX / Sales   22,5% 22,0%
Cash Flow / Sales 30,4% 41,6%
Capital Intensity (Assets / Sales) -32,6x 2,41x
Financial Leverage (Net Debt / EBITDA) 2,92x 2,36x
Price Earning Ratio
EPS & Dividend