BGSI

BGSI — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($172.91)
DCF$4291798.51+2481999.7%
Graham Number$25.48-85.3%
Reverse DCFimplied g: 12.1%
DDM$9.27-94.6%
EV/EBITDA$134.91-22.0%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: $228.88M
Rev: 5.0% / EPS: 284.6%
Default: 9% (no SEC data)

Results

Intrinsic Value / share$4291798.51
Current Price$172.91
Upside / Downside+2481999.7%
Net Debt (used)$1.28B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term276.6%280.6%284.6%288.6%292.6%
7.0%$6496647.67$6849046.80$7216574.99$7599714.22$7998956.64
8.0%$4924549.74$5191668.20$5470254.29$5760673.34$6063298.38
9.0%$3863662.91$4073232.30$4291798.51$4519648.18$4757073.94
10.0%$3107310.89$3275851.24$3451626.91$3634868.37$3825810.99
11.0%$2546271.15$2684377.54$2828412.60$2978565.20$3135028.18

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $0.73
Yahoo: $39.51

Results

Graham Number$25.48
Current Price$172.91
Margin of Safety-85.3%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

Current Price$172.91
Implied Near-term FCF Growth12.1%
Historical Revenue Growth5.0%
Historical Earnings Growth284.6%
Base FCF (TTM)$228.88M
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.45

Results

DDM Intrinsic Value / share$9.27
Current Price$172.91
Upside / Downside-94.6%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $227.13M
Current: 22.2×
Default: $1.28B

Results

Implied Equity Value / share$134.91
Current Price$172.91
Upside / Downside-22.0%
Implied EV$5.04B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt$1.28B$1.28B$1.28B$1.28B$1.28B
18.2x$102.26$102.26$102.26$102.26$102.26
20.2x$118.59$118.59$118.59$118.59$118.59
22.2x$134.91$134.91$134.91$134.91$134.91
24.2x$151.23$151.23$151.23$151.23$151.23
26.2x$167.55$167.55$167.55$167.55$167.55