|
Market Closed -
Other stock markets
|
5-day change | 1st Jan Change | ||
| 1,904.60 INR | +1.13% |
|
+4.28% | -9.55% |
| 09:34pm | Uganda says it grants operating license to Elon Musk's Starlink | RE |
| 06:39pm | IIFL Downgrades Bharti Airtel to Add from Buy; Price Target is INR2,106 | MT |
Projected Income Statement: Bharti Airtel Limited
| Fiscal Period: March | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 |
|---|---|---|---|---|---|---|---|---|
| Net sales 1 | 10,06,158 | 11,65,469 | 13,91,448 | 14,99,824 | 17,29,852 | 21,09,728 | 24,02,346 | 26,84,190 |
| Change | - | 15.83% | 19.39% | 7.79% | 15.34% | 21.96% | 13.87% | 11.73% |
| EBITDA 1 | 4,60,145 | 5,80,682 | 7,22,101 | 7,82,918 | 9,31,592 | 11,96,745 | 13,74,513 | 15,50,717 |
| Change | - | 26.2% | 24.35% | 8.42% | 18.99% | 28.46% | 14.85% | 12.82% |
| EBIT 1 | 1,66,101 | 2,49,775 | 3,57,783 | 3,87,542 | 4,75,889 | 6,69,637 | 8,19,026 | 9,58,029 |
| Change | - | 50.38% | 43.24% | 8.32% | 22.8% | 40.71% | 22.31% | 16.97% |
| Interest Paid 1 | -1,48,019 | -1,66,162 | -1,92,999 | -2,26,477 | -2,17,539 | -2,05,238 | -1,94,169 | -1,68,519 |
| Earnings before Tax (EBT) 1 | -1,44,882 | 1,24,831 | 1,65,607 | 1,26,790 | 3,83,985 | 4,51,727 | 6,31,900 | 7,93,521 |
| Change | - | 186.16% | 32.66% | -23.44% | 202.85% | 17.64% | 39.89% | 25.58% |
| Net income 1 | -1,50,835 | 42,549 | 83,459 | 74,670 | 3,35,561 | 2,66,952 | 3,93,955 | 5,04,013 |
| Change | - | 128.21% | 96.15% | -10.53% | 349.39% | -20.45% | 47.58% | 27.94% |
| Announcement Date | 17/05/21 | 17/05/22 | 16/05/23 | 14/05/24 | 13/05/25 | 13/05/26 | - | - |
Forecast Balance Sheet: Bharti Airtel Limited
| Fiscal Period: March | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 |
|---|---|---|---|---|---|---|---|---|
| Net Debt 1 | 14,52,410 | 15,53,222 | 13,34,455 | 19,89,829 | 20,38,384 | 15,03,828 | 12,06,297 | 7,69,327 |
| Change | - | 6.94% | -14.08% | 49.11% | 2.44% | -26.22% | -19.78% | -36.22% |
| Announcement Date | 17/05/21 | 17/05/22 | 16/05/23 | 14/05/24 | 13/05/25 | 13/05/26 | - | - |
Cash Flow Forecast: Bharti Airtel Limited
| Fiscal Period: March | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 |
|---|---|---|---|---|---|---|---|---|
| CAPEX 1 | 2,46,706 | 2,50,616 | 2,59,681 | 3,80,687 | 3,75,695 | 4,48,987 | 5,05,781 | 5,01,962 |
| Change | - | 1.58% | 3.62% | 46.6% | -1.31% | 19.51% | 12.65% | -0.76% |
| Free Cash Flow (FCF) 1 | 2,35,344 | 2,99,550 | 3,93,565 | 4,08,295 | 6,07,627 | 5,25,662 | 5,95,552 | 7,40,750 |
| Change | - | 27.28% | 31.39% | 3.74% | 48.82% | -13.49% | 13.3% | 24.38% |
| Announcement Date | 17/05/21 | 17/05/22 | 16/05/23 | 14/05/24 | 13/05/25 | - | - | - |
Forecast Financial Ratios: Bharti Airtel Limited
| Fiscal Period: March | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 |
|---|---|---|---|---|---|---|---|---|
Profitability | ||||||||
| EBITDA Margin (%) | 45.73% | 49.82% | 51.9% | 52.2% | 53.85% | 56.73% | 57.22% | 57.77% |
| EBIT Margin (%) | 16.51% | 21.43% | 25.71% | 25.84% | 27.51% | 31.74% | 34.09% | 35.69% |
| EBT Margin (%) | -14.4% | 10.71% | 11.9% | 8.45% | 22.2% | 21.41% | 26.3% | 29.56% |
| Net margin (%) | -14.99% | 3.65% | 6% | 4.98% | 19.4% | 12.65% | 16.4% | 18.78% |
| FCF margin (%) | 23.39% | 25.7% | 28.28% | 27.22% | 35.13% | 24.97% | 24.79% | 27.6% |
| FCF / Net Income (%) | -156.03% | 704.01% | 471.57% | 546.8% | 181.08% | 186.03% | 151.17% | 146.97% |
Profitability | ||||||||
| ROA | -4.27% | 1.2% | 2.06% | 2.83% | 7% | 6.9% | 7.92% | 10.13% |
| ROE | -15.03% | 6.78% | 11.58% | 15.61% | 34.3% | 20.84% | 23% | 26.3% |
Financial Health | ||||||||
| Leverage (Debt/EBITDA) | 3.16x | 2.67x | 1.85x | 2.54x | 2.19x | 1.26x | 0.88x | 0.5x |
| Debt / Free cash flow | 6.17x | 5.19x | 3.39x | 4.87x | 3.35x | 2.86x | 2.03x | 1.04x |
Capital Intensity | ||||||||
| CAPEX / Current Assets (%) | 24.52% | 21.5% | 18.66% | 25.38% | 21.72% | 21.32% | 21.05% | 18.7% |
| CAPEX / EBITDA (%) | 53.61% | 43.16% | 35.96% | 48.62% | 40.33% | 37.49% | 36.8% | 32.37% |
| CAPEX / FCF (%) | 104.83% | 83.66% | 65.98% | 93.24% | 61.83% | 85.41% | 84.93% | 67.76% |
Items per share | ||||||||
| Cash flow per share 1 | 88.37 | 101.3 | 114 | 135.2 | 164.2 | 150 | 160.7 | 191 |
| Change | - | 14.58% | 12.63% | 18.6% | 21.42% | -8.69% | 7.18% | 18.85% |
| Dividend per Share 1 | 4 | 3 | 4 | 8 | 16 | 20.99 | 34.61 | 40.49 |
| Change | - | -25% | 33.33% | 100% | 100% | 31.22% | 64.85% | 16.98% |
| Book Value Per Share 1 | 107.3 | 119.1 | 136.7 | 140.6 | 196 | 227.9 | 284.7 | 326.4 |
| Change | - | 10.96% | 14.83% | 2.84% | 39.39% | 16.29% | 24.93% | 14.62% |
| EPS 1 | -27.65 | 7.63 | 14.57 | 12.8 | 56.04 | 44.37 | 63.01 | 83.55 |
| Change | - | 127.59% | 90.96% | -12.15% | 337.81% | -20.82% | 36.42% | 32.6% |
| Nbr of stocks (in thousands) | 54,88,659 | 58,81,247 | 59,64,355 | 60,44,454 | 60,91,275 | 60,90,056 | 60,90,056 | 60,90,056 |
| Announcement Date | 17/05/21 | 17/05/22 | 16/05/23 | 14/05/24 | 13/05/25 | 13/05/26 | - | - |
| 2026 | 2027 * | |
|---|---|---|
| P/E ratio | 40.2x | 30.2x |
| PBR | 8.36x | 6.69x |
| EV / Sales | 5.15x | 5.33x |
| Yield | 1.1% | 1.82% |
EPS & Dividend
Y-o-Y evolution of P/E
Year-on-year evolution of the Yield
Trader
This super rating is the result of a weighted average of the rankings based on the following ratings: Valuation (Composite), EPS Revisions (4 months), and Visibility (Composite). We recommend that you carefully review the associated descriptions.
Investor
This super composite rating is the result of a weighted average of the rankings based on the following ratings: Fundamentals (Composite), Valuation (Composite), EPS Revisions (1 year), and Visibility (Composite). We recommend that you carefully review the associated descriptions.
Global
This composite rating is the result of an average of the rankings based on the following ratings: Fundamentals (Composite), Valuation (Composite), Financial Estimates Revisions (Composite), Consensus (Composite) and Visibility (Composite). The company must be covered by at least 4 of these 5 ratings for the calculation to be carried out. We recommend that you carefully review the associated descriptions.
Quality
This composite rating is the result of an average of rankings based on the following ratings: Returns (Composite), Profitability (Composite) and Quality of Financial Reporting (Composite), and Financial Health (Composite). The company must be covered by at least 2 of these 3 ratings for the calculation to be performed. We recommend that you carefully read the associated descriptions.
ESG MSCI
The MSCI ESG score assesses a company’s environmental, social, and governance practices relative to its industry peers. Companies are rated from CCC (laggard) to AAA (leader). This rating helps investors incorporate sustainability risks and opportunities into their investment decisions.
Quarterly revenue - Rate of surprise
- Stock Market
- Equities
- 532454 Stock
- Financials Bharti Airtel Limited
Select your edition
All financial news and data tailored to specific country editions
MarketScreener is also available in this country: United States.
Switch edition