HMY

HMY — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($22.75)
DCF$185517.22+815360.3%
Graham Number$12.56-44.8%
Reverse DCFimplied g: -20.0%
DDM$4.33-81.0%
EV/EBITDA$23.12+1.6%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: $10.44B
Rev: 22.7% / EPS: 146.7%
Default: 9% (no SEC data)

Results

Intrinsic Value / share$185774.23
Current Price$22.75
Upside / Downside+816490.0%
Net Debt (used)-$10.71B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term138.7%142.7%146.7%150.7%154.7%
7.0%$261260.47$283874.30$308028.11$333799.25$361267.63
8.0%$199430.13$216687.37$235119.60$254785.83$275747.02
9.0%$157582.32$171214.29$185774.23$201308.76$217866.00
10.0%$127650.21$138689.29$150479.69$163059.13$176466.59
11.0%$105369.50$114478.62$124207.57$134587.46$145650.44

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $1.44
Yahoo: $4.87

Results

Graham Number$12.56
Current Price$22.75
Margin of Safety-44.8%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

Current Price$22.75
Implied Near-term FCF Growth-20.0%
Historical Revenue Growth22.7%
Historical Earnings Growth146.7%
Base FCF (TTM)$10.44B
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.21

Results

DDM Intrinsic Value / share$4.33
Current Price$22.75
Upside / Downside-81.0%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $25.72B
Current: 0.1×
Default: -$10.71B

Results

Implied Equity Value / share$23.12
Current Price$22.75
Upside / Downside+1.6%
Implied EV$3.73B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt-$16.71B-$13.71B-$10.71B-$7.71B-$4.71B
-3.9x$-132.01$-136.81$-141.61$-146.42$-151.22
-1.9x$-49.64$-54.44$-59.25$-64.05$-68.85
0.1x$32.73$27.93$23.12$18.32$13.52
2.1x$115.10$110.29$105.49$100.69$95.88
4.1x$197.47$192.66$187.86$183.06$178.25