Company Valuation: Bharti Airtel Limited

Data adjusted to current consolidation scope
Fiscal Period: March 2021 2022 2023 2024 2025 2026 2027 2028
Capitalization 1 28,39,283 43,00,863 43,17,350 72,68,942 1,03,72,537 1,08,97,958 - -
Change - 51.48% 0.38% 68.37% 42.7% 5.07% - -
Enterprise Value (EV) 1 42,91,693 58,54,085 56,51,805 92,58,771 1,24,10,921 1,24,33,235 1,20,83,343 1,16,25,194
Change - 36.41% -3.46% 63.82% 34.05% 0.18% -2.81% -3.79%
P/E ratio -18.7x 99x 51.4x 96x 30.9x 38.5x 26.8x 21.5x
PBR 4.82x 6.34x 5.48x 8.74x 8.83x 7.9x 6.67x 5.6x
PEG - -1x 0.6x -7.9x 0x -2.3x 0.6x 0.9x
Capitalization / Revenue 2.82x 3.69x 3.1x 4.85x 6x 5.18x 4.56x 4.09x
EV / Revenue 4.27x 5.02x 4.06x 6.17x 7.17x 5.91x 5.05x 4.37x
EV / EBITDA 9.33x 10.1x 7.83x 11.8x 13.3x 10.4x 8.76x 7.5x
EV / EBIT 25.8x 23.4x 15.8x 23.9x 26.1x 18.4x 14.6x 12x
EV / FCF 18.2x 19.5x 14.4x 22.7x 20.4x 23.5x 19.7x 16.2x
FCF Yield 5.48% 5.12% 6.96% 4.41% 4.9% 4.25% 5.08% 6.19%
Dividend per Share 2 4 3 4 8 16 20.72 28.76 38.25
Rate of return 0.77% 0.4% 0.53% 0.65% 0.92% 1.15% 1.59% 2.12%
EPS 2 -27.65 7.63 14.57 12.8 56.04 46.8 67.4 83.82
Distribution rate -14.5% 39.3% 27.5% 62.5% 28.6% 44.3% 42.7% 45.6%
Net sales 1 10,06,158 11,65,469 13,91,448 14,99,824 17,29,852 21,04,222 23,90,579 26,62,789
EBITDA 1 4,60,145 5,80,682 7,22,101 7,82,918 9,31,592 11,96,623 13,79,625 15,50,234
EBIT 1 1,66,101 2,49,775 3,57,783 3,87,542 4,75,889 6,76,472 8,29,819 9,67,563
Net income 1 -1,50,835 42,549 83,459 74,670 3,35,561 2,80,302 3,99,953 5,05,993
Net Debt 1 14,52,410 15,53,222 13,34,455 19,89,829 20,38,384 15,35,277 11,85,385 7,27,236
Reference price 2 517.30 755.40 749.00 1,229.05 1,730.95 1,803.60 1,803.60 1,803.60
Nbr of stocks (in thousands) 54,88,659 58,81,247 59,64,355 60,44,454 60,91,275 60,90,056 - -
Announcement Date 17/05/21 17/05/22 16/05/23 14/05/24 13/05/25 - - -
1INR in Million2INR
Estimates

P/E ratio, Detailed evolution

P/E (Y) EV / Sales (Y) EV / EBITDA (Y) Dividend Yield (Y) Capi.($)
38.48x5.9x10.38x1.15% 12TCr
18.06x2.1x8.09x4.11% 6.42TCr
-133.68x9.41x11.66x2.88% 2.23TCr
14.04x2.99x6.71x3.79% 2.1TCr
14.79x1.99x4.62x2.1% 2.01TCr
28.44x5.42x12.09x4.03% 1.41TCr
13.73x2.66x6.98x4.6% 1.36TCr
-3.95x6.95x16.49x-.--% 1.12TCr
22.66x3.26x9.43x4.43% 1.04TCr
13.26x3.18x6.26x5.91% 959.4Cr
Average 2.58x 4.39x 9.27x 3.3% 3.04TCr
Weighted average by Cap. 13.82x 4.59x 9.35x 2.65%

Y-o-Y evolution of P/E

Historical PBR trend

Evolution Enterprise Value / Sales

Change in Enterprise Value/EBITDA

Year-on-year evolution of the Yield

  1. Stock Market
  2. Equities
  3. 532454 Stock
  4. Valuation Bharti Airtel Limited
SPRING SALE - 40%: The Best Tools Reserved for Subscribers to Identify Tomorrow's Top Investments!
d
:
:
BENEFIT NOW