LSTR — Valuation Models

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

Valuation Summary

Model	Intrinsic Value	vs Price ($164.51)
DCF	$100.21	-39.1%
Graham Number	$41.71	-74.6%
Reverse DCF	—	implied g: 14.2%
DDM	$32.96	-80.0%
EV/EBITDA	$164.51	+0.0%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Base FCF($B)Yahoo: $176.28M

Near-term growth (yrs 1–5)(%)Rev: -2.9% / EPS: -46.5%

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

Terminal growth rate(%)

WACC(%)Computed: 8.56%

Computed WACC: 8.56%

Cost of equity (Re)8.77%(Rf 4.30% + β 0.81 × 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)97.68%

Debt weight (D/V)2.32%

Results

Intrinsic Value / share$106.88

Current Price$164.51

Upside / Downside-35.0%

Net Debt (used)-$318.13M

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

WACC \ Near-term	-3.0%	1.0%	5.0%	9.0%	13.0%
7.0%	$100.99	$119.52	$141.08	$166.03	$194.77
8.0%	$84.68	$99.60	$116.92	$136.95	$159.99
9.0%	$73.38	$85.80	$100.21	$116.83	$135.94
10.0%	$65.08	$75.68	$87.95	$102.10	$118.33
11.0%	$58.73	$67.94	$78.58	$90.84	$104.89

2 — Graham Number

Assumptions

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

EPS (trailing)($)Yahoo: $3.31

Book Value / share($)Yahoo: $23.36

Results

Graham Number$41.71

Current Price$164.51

Margin of Safety-74.6%

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

3 — Reverse DCF (Implied Growth)

Assumptions

WACC(%)Computed: 8.56%

Terminal growth rate(%)

Computed WACC: 8.56%

Cost of equity (Re)8.77%(Rf 4.30% + β 0.81 × 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)97.68%

Debt weight (D/V)2.32%

Results

Current Price$164.51

Implied Near-term FCF Growth12.9%

Historical Revenue Growth-2.9%

Historical Earnings Growth-46.5%

Base FCF (TTM)$176.28M

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: $1.60

Dividend growth rate (g)(%)

Required return (r)(%)

Results

DDM Intrinsic Value / share$32.96

Current Price$164.51

Upside / Downside-80.0%

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

5 — EV/EBITDA Multiple

Assumptions

EBITDA($B)Yahoo: $228.33M

Target EV/EBITDA multipleCurrent: 23.1×

Net Debt($B)Default: -$318.13M

Results

Implied Equity Value / share$164.51

Current Price$164.51

Upside / Downside+0.0%

Implied EV$5.28B

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

Mult \ Net Debt	-$2.32B	-$1.32B	-$318.13M	$681.87M	$1.68B
19.1x	$196.42	$167.06	$137.69	$108.33	$78.97
21.1x	$209.82	$180.46	$151.10	$121.74	$92.38
23.1x	$223.23	$193.87	$164.51	$135.15	$105.79
25.1x	$236.64	$207.28	$177.92	$148.56	$119.20
27.1x	$250.05	$220.69	$191.33	$161.97	$132.60

← Overview Financial Statements ← Companies