StockAnalyzer

Financial Analysis

DashboardSectorsComparablesScreenerUniverseMicrocapsAI 2nd OrderTheme MapEnergy & MaterialsMacroWatchlistCompareMi CarteraPortfolio

Recent

v0.1
CELEBRITY.NS$7.66+0.00%
Fair $7.66+0.0%

CELEBRITY.NS

Celebrity Fashions Limited

Consumer Cyclical / Apparel ManufacturingNSE

$7.66

+0.00 (+0.00%)

Fairly Valued+0.0%Fair Value $7.66Fund rank 25/100 · Data gapFallback financials|
SA 19/F
F-Score: 3/9
High DebtLow Profitability

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 27% · confianza 25%

FCF escenarios

weak_data · normalized FCF $283.5M · quality 32.3/100

Data gap 25/100
Bear 5Yn/dn/d
Base 5Yn/dn/d
Bull 5Yn/dn/d
Return 0/100Downside 20/100Model quality 48/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

19/100

F

Piotroski

3/9

balance/quality

Valuation

50/100

+0.0% upside

5Y CAGR

+0.0%

50/100

Data QA

20/100

SEC 0%

Latest source: yahooPeriods: 5Warnings: 2yahoo: 5
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. Debt-to-Equity ratio is 6.05, above the 2.0 threshold ROE is -1.6%, below the 5% threshold
Thesis & Journal · CELEBRITY.NSLocal privado en este navegador · Celebrity Fashions 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

$494M

P/E

N/A

•

EV/EBITDA

4.9x

↓

ROE

-163.4%

↓

Gross Margin

51.3%

↑

Debt/Equity

6.05

↑
52-Week Range$8
$6$15

TradingView lightweight chart

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

Último $7.660Periodo -96.7%
Fair value: $7.660

Price & Ratios

Absolute Values (Left Axis)

Ratios / Percentages (Right Axis)

Financial statement dashboard

Crecimiento, márgenes y provenance

2022–2026 · 4 años de histórico normalizado

Revenue CAGR

-14.7%

FCF CAGR

+27.5%

FCF margin

17.7%

FCF / Net income

-1.94x

Latest source

Provider fallback

Margin decomposition

Último año: revenue $1.72B · net income $-157.2M · FCF $305.3M

2022-FY → 2026-FY

Gross margin

51.3%+17.7% pts

Operating margin

-7.0%-11.4% pts

Net margin

-9.1%-11.8% pts

FCF margin

17.7%+14.2% pts
MetricTTM
2026
2025
2024
2023
2022
Income Statement
Revenue$1.72B$1.72B$1.65B$3.41B$3.56B$3.25B
Net Income$-157.2M$-157.2M$-182.6M$18.5M$61.5M$87.8M
EBITDA$217.9M$217.9M$242.9M$169.8M$198.6M$207.8M
EPS——-3.220.341.191.81
Gross Margin51.3%51.3%54.8%36.8%38.9%33.5%
Operating Margin-7.0%-7.0%-7.5%3.5%4.7%4.5%
Net Margin-9.1%-9.1%-11.0%0.5%1.7%2.7%
Balance Sheet
Debt/Equity6.056.053.301.832.774.27
Current Ratio0.970.97————
Cash Flow
Free Cash Flow$305.3M$305.3M$28.6M$283.5M$90.5M$115.4M
Returns
ROE-163.4%-163.4%-88.9%5.4%23.0%58.6%
Valuation
P/E———58.0912.569.05
EV/EBITDA4.924.925.499.977.356.89
P/B5.145.143.213.162.895.30
Growth & Yield
Revenue Growth4.1%4.1%-51.5%-4.2%——
EPS Growth——-1042.3%-71.3%——

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

Margins (%)

Returns (%)

Leverage & Liquidity

Reverse DCF · market-implied EPS growthterminal P/E 15.0x · COE 10.0%
Reverse DCF requires positive EPS; loss-making or zero-EPS companies cannot produce a clean EPS hurdle.

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 -44.9%

Total return

-44.9%

Start / end P/E

n/dx → n/dx

EPS bridge

-3.22 → n/d

Residual

-44.9%

EPS growthn/d
Multiple reratingn/d
Dividend+0.0%
Residual / FX / buybacks / cross-term-44.9%

EPS/multiple decomposition requires positive EPS at both endpoints; residual absorbs price move not explained by dividends.

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.