XBPEW

XBPEW — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($0.07)
DCF$381644050.66+573900827962.3%
Graham Number
Reverse DCFimplied g: -6.5%
DDM
EV/EBITDA$-234678000.00-352899248220.3%

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

1 — Discounted Cash Flow (DCF)

Assumptions

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

Results

Intrinsic Value / share$381644050.66
Current Price$0.07
Upside / Downside+573900827962.3%
Net Debt (used)$392.49M
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term-3.0%1.0%5.0%9.0%13.0%
7.0%$388294488.41$546186497.98$729875365.76$942474668.99$1187341179.53
8.0%$249363629.99$376447717.05$524070938.13$694699585.77$890992024.17
9.0%$153090037.81$258908129.35$381644050.66$523318846.15$686110495.13
10.0%$82414454.60$172689196.59$277241523.85$397768327.42$536097876.52
11.0%$28305327.43$106737518.09$197441194.65$301867344.76$421578966.69

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: —
Yahoo: $11.11

Results

Graham Number requires positive EPS and positive Book Value per share. EPS is zero or negative.
Graham Number
Current Price$0.07
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$0.07
Implied Near-term FCF Growth-6.5%
Historical Revenue Growth-10.4%
Historical Earnings Growth
Base FCF (TTM)$44.09M
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$0.07
Upside / Downside
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $13.15M
Current: —×
Default: $392.49M

Results

Implied Equity Value / share$-234678000.00
Current Price$0.07
Upside / Downside-352899248220.3%
Implied EV$157.81M
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt-$1.61B-$607.51M$392.49M$1.39B$2.39B
8.0x$1712718000.00$712718000.00$-287282000.00$-1287282000.00$-2287282000.00
10.0x$1739020000.00$739020000.00$-260980000.00$-1260980000.00$-2260980000.00
12.0x$1765322000.00$765322000.00$-234678000.00$-1234678000.00$-2234678000.00
14.0x$1791624000.00$791624000.00$-208376000.00$-1208376000.00$-2208376000.00
16.0x$1817926000.00$817926000.00$-182074000.00$-1182074000.00$-2182074000.00