AXIA-P

AXIA-P — Valuation Models

Interactive models with editable assumptions. All calculations run client-side.

Valuation Summary

ModelIntrinsic Valuevs Price ($12.45)
DCF$2873583846452.57+23090267950503.2%
Graham Number$10.08-19.0%
Reverse DCFimplied g: -13.5%
DDM$20.60+65.5%
EV/EBITDA$109.72+781.6%

Values reflect default assumptions. Adjust inputs in each model below to update.

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: $9.26B
Rev: -11.3% / EPS: 1289.0%
Default: 9% (no SEC data)

Results

Intrinsic Value / share$2873583846452.57
Current Price$12.45
Upside / Downside+23090267950503.2%
Net Debt (used)$51.52B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term1281.0%1285.0%1289.0%1293.0%1297.0%
7.0%$4748995789087.22$4818171543451.28$4888151072755.10$4958941361226.29$5030549433434.37
8.0%$3579097780525.95$3631232336262.61$3683972659861.99$3737324015012.14$3791291695805.01
9.0%$2791779017049.51$2832445175288.52$2873583846452.57$2915199136339.88$2957295174464.37
10.0%$2232139560710.81$2264653788604.17$2297545809565.93$2330818906346.70$2364476380658.74
11.0%$1818343855998.15$1844830571514.89$1871625044527.85$1898729949228.75$1926147975255.83

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $0.44
Yahoo: $10.26

Results

Graham Number$10.08
Current Price$12.45
Margin of Safety-19.0%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

Current Price$12.45
Implied Near-term FCF Growth-13.5%
Historical Revenue Growth-11.3%
Historical Earnings Growth1289.0%
Base FCF (TTM)$9.26B
Implied growth is the FCF growth rate (yrs 1–5) that makes the DCF intrinsic value equal the current price. Long-term growth is set to half the implied near-term rate.

4 — Dividend Discount Model (DDM)

Assumptions

Yahoo: $1.00

Results

DDM Intrinsic Value / share$20.60
Current Price$12.45
Upside / Downside+65.5%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $6.36B
Current: 12.8×
Default: $51.52B

Results

Implied Equity Value / share$109.72
Current Price$12.45
Upside / Downside+781.6%
Implied EV$81.42B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt$25.52B$38.52B$51.52B$64.52B$77.52B
8.8x$111.81$64.12$16.43$-31.26$-78.96
10.8x$158.46$110.77$63.07$15.38$-32.31
12.8x$205.10$157.41$109.72$62.02$14.33
14.8x$251.75$204.05$156.36$108.67$60.98
16.8x$298.39$250.70$203.01$155.31$107.62