Projected Income Statement: Bharti Airtel Limited

Forecast Balance Sheet: Bharti Airtel Limited

Fiscal Period: March 2020 2021 2022 2023 2024 2025 2026 2027
Net Debt 1 975,152 1,452,410 1,553,222 1,334,455 1,989,829 2,038,384 1,630,063 1,281,845
Change - 48.94% 6.94% -14.08% 49.11% 2.44% -0.12% -21.36%
Announcement Date 5/18/20 5/17/21 5/17/22 5/16/23 5/14/24 5/13/25 - -
1INR in Million
Estimates

Cash Flow Forecast: Bharti Airtel Limited

Fiscal Period: March 2020 2021 2022 2023 2024 2025 2026 2027
CAPEX 1 191,902 246,706 250,616 259,681 380,687 375,695 427,777 444,885
Change - 28.56% 1.58% 3.62% 46.6% -1.31% 2.47% 4%
Free Cash Flow (FCF) 1 -10,615 235,344 299,550 393,565 408,295 607,627 602,817 692,003
Change - 2,317.09% 27.28% 31.39% 3.74% 48.82% 36.57% 14.79%
Announcement Date 5/18/20 5/17/21 5/17/22 5/16/23 5/14/24 5/13/25 - -
1INR in Million
Estimates

Forecast Financial Ratios: Bharti Airtel Limited

Fiscal Period: March 2020 2021 2022 2023 2024 2025 2026 2027

Profitability

        
EBITDA Margin (%) 42.19% 45.73% 49.82% 51.9% 52.2% 53.85% 56.04% 57.12%
EBIT Margin (%) 10.56% 16.51% 21.43% 25.71% 25.84% 27.51% 31.56% 34.28%
EBT Margin (%) -48.95% -14.4% 10.71% 11.9% 8.45% 22.2% 22.13% 26.63%
Net margin (%) -36.76% -14.99% 3.65% 6% 4.98% 19.4% 13.93% 17.26%
FCF margin (%) -1.21% 23.39% 25.7% 28.28% 27.22% 35.13% 28.95% 29.35%
FCF / Net Income (%) 3.3% -156.03% 704.01% 471.57% 546.8% 181.08% 207.76% 170.08%

Profitability

        
ROA -1.07% -4.27% 1.2% 2.06% 2.83% 7% 7.8% 9.73%
ROE -4.56% -15.03% 6.78% 11.58% 15.61% 34.3% 23.03% 27.1%

Financial Health

        
Leverage (Debt/EBITDA) 2.64x 3.16x 2.67x 1.85x 2.54x 2.19x 1.4x 0.95x
Debt / Free cash flow -91.87x 6.17x 5.19x 3.39x 4.87x 3.35x 2.7x 1.85x

Capital Intensity

        
CAPEX / Current Assets (%) 21.92% 24.52% 21.5% 18.66% 25.38% 21.72% 20.54% 18.87%
CAPEX / EBITDA (%) 51.96% 53.61% 43.16% 35.96% 48.62% 40.33% 36.66% 33.04%
CAPEX / FCF (%) -1,807.84% 104.83% 83.66% 65.98% 93.24% 61.83% 70.96% 64.29%

Items per share

        
Cash flow per share 1 35.72 88.37 101.3 114 135.2 164.2 144.8 161
Change - 147.39% 14.58% 12.63% 18.6% 21.42% 10.55% 11.23%
Dividend per Share 1 2 4 3 4 8 16 19.91 26.9
Change - 100% -25% 33.33% 100% 100% 53.66% 35.12%
Book Value Per Share 1 141.4 107.3 119.1 136.7 140.6 196 228 267.7
Change - -24.12% 10.96% 14.83% 2.84% 39.39% 26.51% 17.44%
EPS 1 -63.41 -27.65 7.63 14.57 12.8 56.04 51.34 70.87
Change - 56.39% 127.59% 90.96% -12.15% 337.81% 12.31% 38.05%
Nbr of stocks (in thousands) 5,453,246 5,488,659 5,881,247 5,964,355 6,044,454 6,091,275 6,091,275 6,091,275
Announcement Date 5/18/20 5/17/21 5/17/22 5/16/23 5/14/24 5/13/25 - -
1INR
Estimates
2025 2026 *
P/E ratio 30.9x 37.4x
PBR 8.83x 8.43x
EV / Sales 7.17x 6.32x
Yield 0.92% 1.04%
More valuation ratios * Estimated data

EPS & Dividend

Year-on-year evolution of the PER

Year-on-year evolution of the Yield

Trading Rating
Investor Rating
ESG MSCI
BB
More Ratings
Sell
Consensus
Buy
Mean consensus
BUY
Number of Analysts
36
Last Close Price
1,922.45INR
Average target price
2,029.17INR
Spread / Average Target
+5.55%
Consensus

Quarterly revenue - Rate of surprise

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