OPTU

OPTU — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($1.45)
DCF$-24257421945.39-1678714321580.4%
Graham Number
Reverse DCFimplied g: 61.7%
DDM
EV/EBITDA$708906460.67+49059270534.7%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: $69.81M
Rev: -2.3% / EPS: —
Default: 9% (no SEC data)

Results

Intrinsic Value / share$-24257421945.39
Current Price$1.45
Upside / Downside-1678714321580.4%
Net Debt (used)$25.48B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term-3.0%1.0%5.0%9.0%13.0%
7.0%$-24246892450.57$-23996905432.99$-23706074805.53$-23369470908.38$-22981779036.97
8.0%$-24466858685.95$-24265649188.47$-24031920522.52$-23761767860.26$-23450982270.92
9.0%$-24619286590.61$-24451747085.73$-24257421945.39$-24033111293.54$-23775366782.45
10.0%$-24731185719.06$-24588255664.70$-24422720217.14$-24231892725.34$-24012878530.03
11.0%$-24816855534.54$-24692675536.58$-24549066359.36$-24383730685.36$-24194193853.09

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $-4.00
Yahoo: $-4.92

Results

Graham Number requires positive EPS and positive Book Value per share. EPS is zero or negative. BVPS is zero or negative.
Graham Number
Current Price$1.45
Margin of Safety
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

Current Price$1.45
Implied Near-term FCF Growth61.7%
Historical Revenue Growth-2.3%
Historical Earnings Growth
Base FCF (TTM)$69.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: —

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$1.45
Upside / Downside
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $3.27B
Current: 8.0×
Default: $25.48B

Results

Implied Equity Value / share$708906460.67
Current Price$1.45
Upside / Downside+49059270534.7%
Implied EV$26.19B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt$13.48B$19.48B$25.48B$31.48B$37.48B
4.0x$-377277987.33$-6377277987.33$-12377277987.33$-18377277987.33$-24377277987.33
6.0x$6165814236.67$165814236.67$-5834185763.33$-11834185763.33$-17834185763.33
8.0x$12708906460.67$6708906460.67$708906460.67$-5291093539.33$-11291093539.33
10.0x$19251998684.67$13251998684.67$7251998684.67$1251998684.67$-4748001315.33
12.0x$25795090908.67$19795090908.67$13795090908.67$7795090908.67$1795090908.67