StockAnalyzer

Financial Analysis

DashboardSectorsComparablesScreenerUniverseMicrocapsAI 2nd OrderTheme MapEnergy & MaterialsMacroWatchlistCompareMi CarteraPortfolio

Recent

v0.1
BHARTIARTL.NS$1810.60-1.25%
Fair $1810.60+0.0%

BHARTIARTL.NS

Bharti Airtel Limited

Communication Services / Telecom ServicesNSE

$1810.60

-23.20 (-1.25%)

Fairly Valued+0.0%Fair Value $1810.60Fund rank 34/100 · Data gapFallback financials|
SA 33/D
F-Score: 6/9

FCF base 3Y

n/d

n/d CAGR · yield n/d

FCF base 5Y

n/d

n/d base · n/d expected

Precio de entrada

n/d

MOS 23% · confianza 25%

FCF escenarios

weak_data · normalized FCF $388.5B · quality 65.0/100

Data gap 34/100
Bear 5Yn/dn/d
Base 5Yn/dn/d
Bull 5Yn/dn/d
Return 0/100Downside 20/100Model quality 87/100Data QA 20/100

Ranking barato/determinista: CAGR esperado 5Y + downside bear + calidad del modelo + balance + capital allocation + data gate. No entra en buy-candidate si la data es débil o el CAGR 5Y no compensa.

Quality + valuation scorecard

SA Score

33/100

D

Piotroski

6/9

balance/quality

Valuation

50/100

+0.0% upside

5Y CAGR

+0.0%

50/100

Data QA

16/100

SEC 0%

Latest source: unknownPeriods: 4Warnings: 0unknown: 4
No SEC-backed annual rows; valuation uses fallback financial data. Insufficient audited annual history (<3 SEC-backed years); composite fair value and forward targets are disabled until manually verified.
Thesis & Journal · BHARTIARTL.NSLocal privado en este navegador · Bharti Airtel Limited
Plantilla tipo buy-side: tesis, bull/base/bear, catalizadores, riesgos, kill criteria y fecha de revisión. Esto no gasta GPT-5.5; luego lo usamos como contexto del memo.

Sin guardar todavía.

Market Cap

$11.03T

P/E

40.7x

↑

EV/EBITDA

10.6x

↑

ROE

17.9%

↑

Gross Margin

71.2%

↑

Debt/Equity

1.31

↑
52-Week Range$1811
$1741$2175

TradingView lightweight chart

BHARTIARTL.NS price, volumen y niveles de valoración

Último $1,829Periodo +11563.1%
Fair value: $1,811

Price & Ratios

Absolute Values (Left Axis)

Ratios / Percentages (Right Axis)

Financial statement dashboard

Crecimiento, márgenes y provenance

2023–2026 · 3 años de histórico normalizado

Revenue CAGR

+14.9%

FCF CAGR

+25.0%

FCF margin

35.9%

FCF / Net income

2.84x

Latest source

Provider fallback

Margin decomposition

Último año: revenue $2.11T · net income $266.95B · FCF $758.29B

2023-FY → 2026-FY

Gross margin

71.2%+8.1% pts

Operating margin

31.7%+6.4% pts

Net margin

12.7%+6.7% pts

FCF margin

35.9%+8.1% pts
MetricTTM
2026
2025
2024
2023
Income Statement
Revenue$2109.73B$2109.73B$1729.85B$1499.82B$1391.45B
Net Income$266.95B$266.95B$335.56B$74.67B$83.46B
EBITDA$1194.39B$1194.39B$1057.23B$681.73B$672.88B
EPS44.3744.3756.0412.8014.57
Gross Margin71.2%71.2%68.5%64.3%63.2%
Operating Margin31.7%31.7%27.5%24.8%25.3%
Net Margin12.7%12.7%19.4%5.0%6.0%
Balance Sheet
Debt/Equity1.311.311.882.632.91
Current Ratio0.520.52———
Cash Flow
Free Cash Flow$758.29B$758.29B$376.42B$388.47B$387.86B
Returns
ROE17.9%17.9%29.5%9.1%10.8%
Valuation
P/E40.7440.7431.1193.0552.57
EV/EBITDA10.6410.6411.8413.269.77
P/B7.317.319.188.475.66
Growth & Yield
Revenue Growth22.0%22.0%15.3%7.8%—
EPS Growth-20.8%-20.8%337.8%-12.1%—
Dividend Yield0.9%0.9%———

Revenue, Net Income & Free Cash Flow ($B)

Margins (%)

Returns (%)

Leverage & Liquidity

Reverse DCF · market-implied EPS growthterminal P/E 15.0x · COE 10.0%

3Y implied EPS CAGR

53.6%

muy exigente

EPS terminal req.

$160.66

Spread vs growth

-74.4%

5Y implied EPS CAGR

34.4%

muy exigente

EPS terminal req.

$194.40

Spread vs growth

-55.2%

10Y implied EPS CAGR

21.6%

exigente

EPS terminal req.

$313.08

Spread vs growth

-42.4%

Qué te dice: cuánto EPS CAGR está descontando el precio si sales al múltiplo terminal indicado. Si el growth observado queda por debajo, el mercado está pidiendo una ejecución muy fina.

Return attribution · 1Y approxreconcilia total +0.1%

Total return

+0.1%

Start / end P/E

32.9x → 41.2x

EPS bridge

56.04 → 44.37

Residual

-5.3%

EPS growth-20.8%
Multiple rerating+25.3%
Dividend+0.9%
Residual / FX / buybacks / cross-term-5.3%

Simple additive decomposition: total return = EPS growth contribution + P/E multiple contribution + dividend contribution + explicit residual. The residual captures cross-terms, buybacks/share-count effects, FX, special dividends, data noise and methodology mismatch so the bridge always reconciles.