BFS-PE

BFS-PE — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($22.50)
DCF$207893000.06+923968789.2%
Graham Number$13.79-38.7%
Reverse DCFimplied g: 8.5%
DDM$30.90+37.3%
EV/EBITDA$905664279.58+4025174475.9%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: $73.95M
Rev: 10.6% / EPS: -29.2%
Default: 9% (no SEC data)

Results

Intrinsic Value / share$207893000.06
Current Price$22.50
Upside / Downside+923968789.2%
Net Debt (used)$1.59B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term2.6%6.6%10.6%14.6%18.6%
7.0%$279838308.38$644697079.80$1066403959.88$1551475534.88$2106911779.47
8.0%$-69998944.64$221677692.28$558405002.96$945325341.76$1387961568.49
9.0%$-311614937.46$-70331475.81$207893000.06$527257169.76$892269617.89
10.0%$-488339991.41$-283791241.78$-48201527.00$221942085.15$530411167.58
11.0%$-623110257.93$-446470519.83$-243262611.69$-10492787.29$255052560.60

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $1.69
Yahoo: $5.00

Results

Graham Number$13.79
Current Price$22.50
Margin of Safety-38.7%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

Current Price$22.50
Implied Near-term FCF Growth8.5%
Historical Revenue Growth10.6%
Historical Earnings Growth-29.2%
Base FCF (TTM)$73.95M
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.50

Results

DDM Intrinsic Value / share$30.90
Current Price$22.50
Upside / Downside+37.3%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $174.43M
Current: 14.3×
Default: $1.59B

Results

Implied Equity Value / share$905664279.58
Current Price$22.50
Upside / Downside+4025174475.9%
Implied EV$2.50B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt$1.59B$1.59B$1.59B$1.59B$1.59B
10.3x$207940247.58$207940247.58$207940247.58$207940247.58$207940247.58
12.3x$556802263.58$556802263.58$556802263.58$556802263.58$556802263.58
14.3x$905664279.58$905664279.58$905664279.58$905664279.58$905664279.58
16.3x$1254526295.58$1254526295.58$1254526295.58$1254526295.58$1254526295.58
18.3x$1603388311.58$1603388311.58$1603388311.58$1603388311.58$1603388311.58