Projected Income Statement: Bharti Airtel Limited

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 16,69,500 12,48,477 7,76,047
Change - 6.94% -14.08% 49.11% 2.44% -18.1% -25.22% -37.84%
Announcement Date 17/05/21 17/05/22 16/05/23 14/05/24 13/05/25 - - -
1INR in Million
Estimates

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,35,486 4,49,349 4,67,758
Change - 1.58% 3.62% 46.6% -1.31% 15.91% 3.18% 4.1%
Free Cash Flow (FCF) 1 2,35,344 2,99,550 3,93,565 4,08,295 6,07,627 5,46,699 6,53,305 7,56,550
Change - 27.28% 31.39% 3.74% 48.82% -10.03% 19.5% 15.8%
Announcement Date 17/05/21 17/05/22 16/05/23 14/05/24 13/05/25 - - -
1INR in Million
Estimates

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.63% 57.66% 58.22%
EBIT Margin (%) 16.51% 21.43% 25.71% 25.84% 27.51% 31.94% 34.74% 36.44%
EBT Margin (%) -14.4% 10.71% 11.9% 8.45% 22.2% 22.91% 27.3% 30.35%
Net margin (%) -14.99% 3.65% 6% 4.98% 19.4% 13.59% 17.08% 19.57%
FCF margin (%) 23.39% 25.7% 28.28% 27.22% 35.13% 26.09% 27.44% 28.61%
FCF / Net Income (%) -156.03% 704.01% 471.57% 546.8% 181.08% 191.94% 160.71% 146.15%

Profitability

        
ROA -4.27% 1.2% 2.06% 2.83% 7% 7.73% 9.16% 10.5%
ROE -15.03% 6.78% 11.58% 15.61% 34.3% 21.53% 26.25% 27.95%

Financial Health

        
Leverage (Debt/EBITDA) 3.16x 2.67x 1.85x 2.54x 2.19x 1.41x 0.91x 0.5x
Debt / Free cash flow 6.17x 5.19x 3.39x 4.87x 3.35x 3.05x 1.91x 1.03x

Capital Intensity

        
CAPEX / Current Assets (%) 24.52% 21.5% 18.66% 25.38% 21.72% 20.79% 18.88% 17.69%
CAPEX / EBITDA (%) 53.61% 43.16% 35.96% 48.62% 40.33% 36.7% 32.73% 30.38%
CAPEX / FCF (%) 104.83% 83.66% 65.98% 93.24% 61.83% 79.66% 68.78% 61.83%

Items per share

        
Cash flow per share 1 88.37 101.3 114 135.2 164.2 150.1 170.5 189.7
Change - 14.58% 12.63% 18.6% 21.42% -8.58% 13.59% 11.26%
Dividend per Share 1 4 3 4 8 16 20.29 28.89 38.33
Change - -25% 33.33% 100% 100% 26.84% 42.34% 32.7%
Book Value Per Share 1 107.3 119.1 136.7 140.6 196 226 269.7 323.7
Change - 10.96% 14.83% 2.84% 39.39% 15.3% 19.35% 20.03%
EPS 1 -27.65 7.63 14.57 12.8 56.04 47.77 69.05 86.28
Change - 127.59% 90.96% -12.15% 337.81% -14.76% 44.54% 24.95%
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 - - -
1INR
Estimates
2026 *2027 *
P/E ratio 41.6x 28.8x
PBR 8.79x 7.36x
EV / Sales 6.49x 5.54x
Yield 1.02% 1.46%
More valuation ratios * Estimated data

EPS & Dividend

Y-o-Y evolution of P/E

Year-on-year evolution of the Yield

Trader
Investor
Global
Quality
ESG MSCI
BB
More Ratings
Sell
Consensus
Buy
Mean consensus
BUY
Number of Analysts
35
Last Close Price
1,985.25INR
Average target price
2,336.62INR
Spread / Average Target
+17.70%
Consensus

Quarterly revenue - Rate of surprise

  1. Stock Market
  2. Equities
  3. BHARTIARTL Stock
  4. Financials Bharti Airtel Limited