GLXY — Valuation Models

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

Valuation Summary

Model	Intrinsic Value	vs Price ($21.73)
DCF	$-17.52	-180.6%
Graham Number	—	—
Reverse DCF	—	—
DDM	—	—
EV/EBITDA	$27.34	+25.8%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Base FCF($B)Yahoo: —

Near-term growth (yrs 1–5)(%)Rev: — / EPS: —

Long-term growth (yrs 6–10)(%)

Terminal growth rate(%)

WACC(%)Computed: 15.44%

Computed WACC: 15.44%

Cost of equity (Re)24.57%(Rf 4.30% + β 3.69 × ERP 5.50%)

Cost of debt (Rd)1.11%(interest expense ÷ avg debt (SEC))

Tax rate (T)21.00%(US statutory fallback)

Equity weight (E/V)61.45%

Debt weight (D/V)38.55%

Results

Intrinsic Value / share$-17.52

Current Price$21.73

Upside / Downside-180.6%

Net Debt (used)$3.38B

Sensitivity: WACC (rows) × Near-term g (cols)

WACC \ Near-term	-3.0%	1.0%	5.0%	9.0%	13.0%
7.0%	$-17.52	$-17.52	$-17.52	$-17.52	$-17.52
8.0%	$-17.52	$-17.52	$-17.52	$-17.52	$-17.52
9.0%	$-17.52	$-17.52	$-17.52	$-17.52	$-17.52
10.0%	$-17.52	$-17.52	$-17.52	$-17.52	$-17.52
11.0%	$-17.52	$-17.52	$-17.52	$-17.52	$-17.52

2 — Graham Number

Assumptions

MultiplierGraham used 22.5 (15× P/E × 1.5× P/B)

EPS (trailing)($)Yahoo: $-1.52

Book Value / share($)Yahoo: $9.99

Results

Graham Number requires positive EPS and positive Book Value per share. EPS is zero or negative.

Graham Number—

Current Price$21.73

Margin of Safety—

Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

WACC(%)Computed: 15.44%

Terminal growth rate(%)

Computed WACC: 15.44%

Cost of equity (Re)24.57%(Rf 4.30% + β 3.69 × ERP 5.50%)

Cost of debt (Rd)1.11%(interest expense ÷ avg debt (SEC))

Tax rate (T)21.00%(US statutory fallback)

Equity weight (E/V)61.45%

Debt weight (D/V)38.55%

Results

Reverse DCF requires positive TTM free cash flow.

Current Price$21.73

Implied Near-term FCF Growth—

Historical Revenue Growth—

Historical Earnings Growth—

Base FCF (TTM)—

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

Annual dividend D0($/share)Yahoo: —

Dividend growth rate (g)(%)

Required return (r)(%)

Results

This company does not pay a dividend. DDM is not applicable — the intrinsic value shown uses D0 = $0 unless you enter a hypothetical dividend above.

DDM Intrinsic Value / share—

Current Price$21.73

Upside / Downside—

Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

EBITDA($B)Yahoo: $60.03B

Target EV/EBITDA multipleCurrent: 0.1×

Net Debt($B)Default: $3.38B

Results

Implied Equity Value / share$27.34

Current Price$21.73

Upside / Downside+25.8%

Implied EV$8.64B

Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)

Mult \ Net Debt	$1.38B	$2.38B	$3.38B	$4.38B	$5.38B
-3.9x	$-1208.47	$-1213.66	$-1218.85	$-1224.03	$-1229.22
-1.9x	$-585.37	$-590.56	$-595.75	$-600.94	$-606.13
0.1x	$37.72	$32.53	$27.34	$22.16	$16.97
2.1x	$660.82	$655.63	$650.44	$645.25	$640.06
4.1x	$1283.91	$1278.72	$1273.53	$1268.35	$1263.16

← Overview Financial Statements ← Companies