SHO-PH

SHO-PH — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($20.70)
DCF$3201640433.55+15466861897.8%
Graham Number$8.55-58.7%
Reverse DCFimplied g: -16.9%
DDM$31.52+52.3%
EV/EBITDA$4202741192.00+20303097445.9%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: $167.92M
Rev: 10.3% / EPS: —
Default: 9% (no SEC data)

Results

Intrinsic Value / share$3194950610.63
Current Price$20.70
Upside / Downside+15434543912.7%
Net Debt (used)$816.57M
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term2.3%6.3%10.3%14.3%18.3%
7.0%$3348057175.52$4161070854.46$5101070359.81$6182651212.03$7421494508.02
8.0%$2572172736.55$3222386718.94$3973264156.22$4836325535.67$5823946062.61
9.0%$2036197823.44$2574290763.29$3194950610.63$3907586009.58$4722301885.56
10.0%$1644083049.29$2100430261.53$2626176701.67$3229196194.60$3917943789.56
11.0%$1344985785.13$1739215939.65$2192861495.64$2712634098.92$3305739572.44

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $0.37
Yahoo: $8.78

Results

Graham Number$8.55
Current Price$20.70
Margin of Safety-58.7%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

Current Price$20.70
Implied Near-term FCF Growth-16.9%
Historical Revenue Growth10.3%
Historical Earnings Growth
Base FCF (TTM)$167.92M
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.53

Results

DDM Intrinsic Value / share$31.52
Current Price$20.70
Upside / Downside+52.3%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $210.22M
Current: 23.9×
Default: $816.57M

Results

Implied Equity Value / share$4202741192.00
Current Price$20.70
Upside / Downside+20303097445.9%
Implied EV$5.02B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt-$1.18B-$183.43M$816.57M$1.82B$2.82B
19.9x$5361845192.00$4361845192.00$3361845192.00$2361845192.00$1361845192.00
21.9x$5782293192.00$4782293192.00$3782293192.00$2782293192.00$1782293192.00
23.9x$6202741192.00$5202741192.00$4202741192.00$3202741192.00$2202741192.00
25.9x$6623189192.00$5623189192.00$4623189192.00$3623189192.00$2623189192.00
27.9x$7043637192.00$6043637192.00$5043637192.00$4043637192.00$3043637192.00