BDL — Valuation Models

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

Valuation Summary

Model	Intrinsic Value	vs Price ($33.70)
DCF	$145616656805984.22	+432096904468695.9%
Graham Number	$1388.58	+4020.4%
Reverse DCF	—	implied g: -20.0%
DDM	$11.33	-66.4%
EV/EBITDA	$38.82	+15.2%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Base FCF($B)Yahoo: $1.93B

Near-term growth (yrs 1–5)(%)Rev: 5.1% / EPS: 1363.7%

Long-term growth (yrs 6–10)(%)

Terminal growth rate(%)

WACC(%)Computed: 5.01%

Computed WACC: 5.01%

Cost of equity (Re)8.69%(Rf 4.30% + β 0.80 × ERP 5.50%)

Cost of debt (Rd)0.00%(no debt / unavailable → 0%)

Tax rate (T)21.00%(US statutory fallback)

Equity weight (E/V)57.60%

Debt weight (D/V)42.40%

Results

Intrinsic Value / share$524546877069082.69

Current Price$33.70

Upside / Downside+1556518923053557.8%

Net Debt (used)$23.14M

Sensitivity: WACC (rows) × Near-term g (cols)

WACC \ Near-term	1355.7%	1359.7%	1363.7%	1367.7%	1371.7%
7.0%	$241126600130713.41	$244457717565523.16	$247825548697074.63	$251230396170853.84	$254672564291013.34
8.0%	$181710113266811.38	$184220403380794.31	$186758360495694.97	$189324212681514.78	$191918189258206.06
9.0%	$141725715062679.44	$143683628418673.88	$145663120790484.81	$147664370062449.63	$149687555093810.84
10.0%	$113305483802867.03	$114870777140258.52	$116453322257058.59	$118053261366486.86	$119670737461170.67
11.0%	$92292720765681.28	$93567726831432.69	$94856785294014.81	$96160011992873.91	$97477523402321.02

2 — Graham Number

Assumptions

MultiplierGraham used 22.5 (15× P/E × 1.5× P/B)

EPS (trailing)($)Yahoo: $3.11

Book Value / share($)Yahoo: $27554.99

Results

Graham Number$1388.58

Current Price$33.70

Margin of Safety+4020.4%

Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

WACC(%)Computed: 5.01%

Terminal growth rate(%)

Computed WACC: 5.01%

Cost of equity (Re)8.69%(Rf 4.30% + β 0.80 × ERP 5.50%)

Cost of debt (Rd)0.00%(no debt / unavailable → 0%)

Tax rate (T)21.00%(US statutory fallback)

Equity weight (E/V)57.60%

Debt weight (D/V)42.40%

Results

Current Price$33.70

Implied Near-term FCF Growth-20.0%

Historical Revenue Growth5.1%

Historical Earnings Growth1363.7%

Base FCF (TTM)$1.93B

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

Annual dividend D0($/share)Yahoo: $0.55

Dividend growth rate (g)(%)

Required return (r)(%)

Results

DDM Intrinsic Value / share$11.33

Current Price$33.70

Upside / Downside-66.4%

Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

EBITDA($B)Yahoo: $11.91B

Target EV/EBITDA multipleCurrent: 0.0×

Net Debt($B)Default: $23.14M

Results

Implied Equity Value / share$38.82

Current Price$33.70

Upside / Downside+15.2%

Implied EV$95.29M

Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)

Mult \ Net Debt	-$1.98B	-$976.86M	$23.14M	$1.02B	$2.02B
-4.0x	$-24518.83	$-25056.85	$-25594.88	$-26132.91	$-26670.93
-2.0x	$-11701.98	$-12240.00	$-12778.03	$-13316.06	$-13854.08
0.0x	$1114.87	$576.85	$38.82	$-499.21	$-1037.23
2.0x	$13931.72	$13393.70	$12855.67	$12317.64	$11779.62
4.0x	$26748.57	$26210.55	$25672.52	$25134.49	$24596.47

← Overview Financial Statements ← Companies