CYD

CYD — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($50.28)
DCF$0.00-100.0%
Graham Number$37.42-25.6%
Reverse DCF
DDM$10.92-78.3%
EV/EBITDA$561.41+1016.6%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: —
Rev: 23.0% / EPS: 109.1%
Default: 9% (no SEC data)

Results

Intrinsic Value / share$0.00
Current Price$50.28
Upside / Downside-100.0%
Net Debt (used)$0
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term101.1%105.1%109.1%113.1%117.1%
7.0%$0.00$0.00$0.00$0.00$0.00
8.0%$0.00$0.00$0.00$0.00$0.00
9.0%$0.00$0.00$0.00$0.00$0.00
10.0%$0.00$0.00$0.00$0.00$0.00
11.0%$0.00$0.00$0.00$0.00$0.00

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $1.76
Yahoo: $35.35

Results

Graham Number$37.42
Current Price$50.28
Margin of Safety-25.6%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

Reverse DCF requires positive TTM free cash flow.
Current Price$50.28
Implied Near-term FCF Growth
Historical Revenue Growth23.0%
Historical Earnings Growth109.1%
Base FCF (TTM)
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.53

Results

DDM Intrinsic Value / share$10.92
Current Price$50.28
Upside / Downside-78.3%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $1.76B
Current: —×
Default: $0

Results

Implied Equity Value / share$561.41
Current Price$50.28
Upside / Downside+1016.6%
Implied EV$21.06B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt-$2.00B-$1.00B$0$1.00B$2.00B
8.0x$427.58$400.92$374.27$347.62$320.96
10.0x$521.15$494.49$467.84$441.19$414.53
12.0x$614.71$588.06$561.41$534.75$508.10
14.0x$708.28$681.63$654.97$628.32$601.67
16.0x$801.85$775.20$748.54$721.89$695.23