SPE-PC

SPE-PC — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($25.16)
DCF$66853285.78+265659688.5%
Graham Number$33.90+34.7%
Reverse DCFimplied g: -20.0%
DDM$14.21-43.5%
EV/EBITDA

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: $3.81M
Rev: -7.4% / EPS: -31.3%
Default: 9% (no SEC data)

Results

Intrinsic Value / share$66853285.78
Current Price$25.16
Upside / Downside+265659688.5%
Net Debt (used)$0
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term-3.0%1.0%5.0%9.0%13.0%
7.0%$67427609.59$81062973.68$96926123.44$115285943.63$136432321.05
8.0%$55429707.71$66404536.66$79153100.53$93888385.37$110839964.33
9.0%$47115636.05$56253959.20$66853285.78$79088150.77$93146641.83
10.0%$41012177.67$48808195.84$57837209.10$68245758.94$80191732.47
11.0%$36339378.50$43112688.18$50945748.63$59963865.39$70302017.11

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $3.14
Yahoo: $16.26

Results

Graham Number$33.90
Current Price$25.16
Margin of Safety+34.7%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

Current Price$25.16
Implied Near-term FCF Growth-20.0%
Historical Revenue Growth-7.4%
Historical Earnings Growth-31.3%
Base FCF (TTM)$3.81M
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: $0.69

Results

DDM Intrinsic Value / share$14.21
Current Price$25.16
Upside / Downside-43.5%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: —
Current: —×
Default: $0

Results

Implied Equity Value / share$0.00
Current Price$25.16
Upside / Downside-100.0%
Implied EV$0