HAFN

HAFN — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($7.77)
DCF$132.38+1603.7%
Graham Number$8.01+3.1%
Reverse DCFimplied g: -0.7%
DDM$14.42+85.6%
EV/EBITDA$7.69-1.0%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: $369.60M
Rev: -30.9% / EPS: 47.3%
Default: 9% (no SEC data)

Results

Intrinsic Value / share$132.15
Current Price$7.77
Upside / Downside+1600.7%
Net Debt (used)$762.04M
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term39.3%43.3%47.3%51.3%55.3%
7.0%$159.10$183.12$209.95$239.82$273.01
8.0%$124.11$142.82$163.71$186.96$212.79
9.0%$100.23$115.31$132.15$150.89$171.70
10.0%$82.98$95.45$109.36$124.85$142.03
11.0%$70.01$80.51$92.23$105.27$119.74

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $0.61
Yahoo: $4.68

Results

Graham Number$8.01
Current Price$7.77
Margin of Safety+3.1%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

Current Price$7.77
Implied Near-term FCF Growth-0.7%
Historical Revenue Growth-30.9%
Historical Earnings Growth47.3%
Base FCF (TTM)$369.60M
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.70

Results

DDM Intrinsic Value / share$14.42
Current Price$7.77
Upside / Downside+85.6%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $465.97M
Current: 9.9×
Default: $762.04M

Results

Implied Equity Value / share$7.69
Current Price$7.77
Upside / Downside-1.0%
Implied EV$4.59B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt-$1.24B-$237.96M$762.04M$1.76B$2.76B
5.9x$7.97$5.96$3.95$1.94$-0.07
7.9x$9.84$7.83$5.82$3.81$1.81
9.9x$11.71$9.70$7.69$5.69$3.68
11.9x$13.58$11.57$9.57$7.56$5.55
13.9x$15.45$13.44$11.44$9.43$7.42