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 1,452,410 1,553,222 1,334,455 1,989,829 2,038,384 1,503,828 1,195,823 767,770
Change - 6.94% -14.08% 49.11% 2.44% -26.22% -20.48% -35.8%
Announcement Date 5/17/21 5/17/22 5/16/23 5/14/24 5/13/25 5/13/26 - -
1INR in Million
Estimates

Cash Flow Forecast: Bharti Airtel Limited

Fiscal Period: March 2021 2022 2023 2024 2025 2026 2027 2028
CAPEX 1 246,706 250,616 259,681 380,687 375,695 446,696 488,872 490,499
Change - 1.58% 3.62% 46.6% -1.31% 18.9% 9.44% 0.33%
Free Cash Flow (FCF) 1 235,344 299,550 393,565 408,295 607,627 525,662 562,388 717,744
Change - 27.28% 31.39% 3.74% 48.82% -13.49% 6.99% 27.62%
Announcement Date 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 2021 2022 2023 2024 2025 2026 2027 2028

Profitability

        
EBITDA Margin (%) 45.73% 49.82% 51.9% 52.2% 53.85% 56.73% 57.5% 58%
EBIT Margin (%) 16.51% 21.43% 25.71% 25.84% 27.51% 31.74% 34.19% 36.19%
EBT Margin (%) -14.4% 10.71% 11.9% 8.45% 22.2% 21.41% 26.6% 29.54%
Net margin (%) -14.99% 3.65% 6% 4.98% 19.4% 12.65% 16.77% 18.81%
FCF margin (%) 23.39% 25.7% 28.28% 27.22% 35.13% 24.97% 23.42% 26.82%
FCF / Net Income (%) -156.03% 704.01% 471.57% 546.8% 181.08% 186.03% 139.66% 142.64%

Profitability

        
ROA -4.27% 1.2% 2.06% 2.83% 7% 6.9% 8.85% 10.57%
ROE -15.03% 6.78% 11.58% 15.61% 34.3% 20.84% 22.46% 26.83%

Financial Health

        
Leverage (Debt/EBITDA) 3.16x 2.67x 1.85x 2.54x 2.19x 1.26x 0.87x 0.49x
Debt / Free cash flow 6.17x 5.19x 3.39x 4.87x 3.35x 2.86x 2.13x 1.07x

Capital Intensity

        
CAPEX / Current Assets (%) 24.52% 21.5% 18.66% 25.38% 21.72% 21.21% 20.36% 18.33%
CAPEX / EBITDA (%) 53.61% 43.16% 35.96% 48.62% 40.33% 37.3% 35.4% 31.61%
CAPEX / FCF (%) 104.83% 83.66% 65.98% 93.24% 61.83% 84.98% 86.93% 68.34%

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.65 34.78 38.99
Change - -25% 33.33% 100% 100% 29.06% 68.41% 12.13%
Book Value Per Share 1 107.3 119.1 136.7 140.6 196 227.9 281.9 323.7
Change - 10.96% 14.83% 2.84% 39.39% 16.29% 23.68% 14.85%
EPS 1 -27.65 7.63 14.57 12.8 56.04 44.37 62.1 83.27
Change - 127.59% 90.96% -12.15% 337.81% -20.82% 34.47% 34.08%
Nbr of stocks (in thousands) 5,488,659 5,881,247 5,964,355 6,044,454 6,091,275 6,090,056 6,090,056 6,090,056
Announcement Date 5/17/21 5/17/22 5/16/23 5/14/24 5/13/25 5/13/26 - -
1INR
Estimates
2026 2027 *
P/E ratio 40.2x 30.4x
PBR 8.26x 6.63x
EV / Sales 5.15x 5.28x
Yield 1.1% 1.9%

EPS & Dividend

Y-o-Y evolution of P/E

Year-on-year evolution of the Yield

Trader
Investor
Global
Quality
ESG MSCI
BB
Sell
Consensus
Buy
Mean consensus
BUY
Number of Analysts
31
Last Close Price
1,883.25INR
Average target price
2,326.74INR
Spread / Average Target
+23.55%

Quarterly revenue - Rate of surprise

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