BW-PA

BW-PA — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($19.55)
DCF$-945594066.83-4836798395.8%
Graham Number
Reverse DCF
DDM$39.96+104.4%
EV/EBITDA$2172087220.00+11110420462.7%

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

1 — Discounted Cash Flow (DCF)

Assumptions

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

Results

Intrinsic Value / share$-945594066.83
Current Price$19.55
Upside / Downside-4836798395.8%
Net Debt (used)$432.62M
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term-3.0%1.0%5.0%9.0%13.0%
7.0%$-950000946.16$-1054627297.02$-1176347807.00$-1317225672.52$-1479485241.66
8.0%$-857939107.34$-942150742.34$-1039972531.83$-1153038752.23$-1283110955.29
9.0%$-794143892.74$-864263722.12$-945594066.83$-1039474161.85$-1147347234.26
10.0%$-747311070.83$-807131177.33$-876412254.34$-956278738.22$-1047942122.44
11.0%$-711455928.19$-763428627.26$-823532965.11$-892730431.46$-972056739.31

2 — Graham Number

Assumptions

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

Results

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

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

Reverse DCF requires positive TTM free cash flow.
Current Price$19.55
Implied Near-term FCF Growth
Historical Revenue Growth-2.4%
Historical Earnings Growth
Base FCF (TTM)-$29.22M
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.94

Results

DDM Intrinsic Value / share$39.96
Current Price$19.55
Upside / Downside+104.4%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $17.94M
Current: 145.2×
Default: $432.62M

Results

Implied Equity Value / share$2172087220.00
Current Price$19.55
Upside / Downside+11110420462.7%
Implied EV$2.60B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt-$1.57B-$567.38M$432.62M$1.43B$2.43B
141.2x$4100335220.00$3100335220.00$2100335220.00$1100335220.00$100335220.00
143.2x$4136211220.00$3136211220.00$2136211220.00$1136211220.00$136211220.00
145.2x$4172087220.00$3172087220.00$2172087220.00$1172087220.00$172087220.00
147.2x$4207963220.00$3207963220.00$2207963220.00$1207963220.00$207963220.00
149.2x$4243839220.00$3243839220.00$2243839220.00$1243839220.00$243839220.00