BTSGU

BTSGU — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($139.40)
DCF$-563784134562695.25-404436251479795.3%
Graham Number
Reverse DCF
DDM$69.63-50.1%
EV/EBITDA$28625958320.00+20535120646.1%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: -$334.85M
Rev: 29.3% / EPS: 338.3%
Default: 9% (no SEC data)

Results

Intrinsic Value / share$-564301316141833.63
Current Price$139.40
Upside / Downside-404807256916766.9%
Net Debt (used)$2.62B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term330.3%334.3%338.3%342.3%346.3%
7.0%$-867448164960037.50$-908521453914334.25$-951136069845005.75$-995334991769870.50$-1041161990348411.25
8.0%$-656754766248703.88$-687851474102052.25$-720115115408192.88$-753578229205701.25$-788273953874449.63
9.0%$-514651013473093.44$-539018953890754.44$-564301316141833.63$-590523597978440.25$-617711766796392.25
10.0%$-413399155785572.88$-432972721272642.81$-453280789613551.50$-474343841528575.06$-496182734970191.69
11.0%$-338341403700971.38$-354360920042107.94$-370981566388133.75$-388220104371551.00$-406093604353236.94

2 — Graham Number

Assumptions

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

Results

Graham Number requires positive EPS and positive Book Value per share. EPS is zero or negative.
Graham Number
Current Price$139.40
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$139.40
Implied Near-term FCF Growth
Historical Revenue Growth29.3%
Historical Earnings Growth338.3%
Base FCF (TTM)-$334.85M
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: $3.38

Results

DDM Intrinsic Value / share$69.63
Current Price$139.40
Upside / Downside-50.1%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $485.33M
Current: 64.4×
Default: $2.62B

Results

Implied Equity Value / share$28625958320.00
Current Price$139.40
Upside / Downside+20535120646.1%
Implied EV$31.25B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt$620.43M$1.62B$2.62B$3.62B$4.62B
60.4x$28684646320.00$27684646320.00$26684646320.00$25684646320.00$24684646320.00
62.4x$29655302320.00$28655302320.00$27655302320.00$26655302320.00$25655302320.00
64.4x$30625958320.00$29625958320.00$28625958320.00$27625958320.00$26625958320.00
66.4x$31596614320.00$30596614320.00$29596614320.00$28596614320.00$27596614320.00
68.4x$32567270320.00$31567270320.00$30567270320.00$29567270320.00$28567270320.00