HLIO

HLIO — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($74.38)
DCF$2535445.14+3408672.7%
Graham Number$25.29-66.0%
Reverse DCFimplied g: 13.1%
DDM$7.42-90.0%
EV/EBITDA$74.32-0.1%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: $97.95M
Rev: 17.4% / EPS: 306.6%
Default: 9% (no SEC data)

Results

Intrinsic Value / share$2535445.14
Current Price$74.38
Upside / Downside+3408672.7%
Net Debt (used)$294.10M
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term298.6%302.6%306.6%310.6%314.6%
7.0%$3864268.99$4062081.38$4267912.96$4482005.14$4704604.09
8.0%$2927594.18$3077455.88$3233392.81$3395587.85$3564227.49
9.0%$2295658.49$2413169.95$2535445.14$2662627.43$2794863.09
10.0%$1845244.19$1939697.99$2037980.73$2140207.67$2246496.35
11.0%$1511235.84$1588591.10$1669082.12$1752803.28$1839850.86

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $1.01
Yahoo: $28.14

Results

Graham Number$25.29
Current Price$74.38
Margin of Safety-66.0%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

Current Price$74.38
Implied Near-term FCF Growth13.1%
Historical Revenue Growth17.4%
Historical Earnings Growth306.6%
Base FCF (TTM)$97.95M
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.36

Results

DDM Intrinsic Value / share$7.42
Current Price$74.38
Upside / Downside-90.0%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $154.90M
Current: 17.8×
Default: $294.10M

Results

Implied Equity Value / share$74.32
Current Price$74.38
Upside / Downside-0.1%
Implied EV$2.76B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt-$1.71B-$705.90M$294.10M$1.29B$2.29B
13.8x$115.99$85.80$55.61$25.43$-4.76
15.8x$125.34$95.15$64.97$34.78$4.60
17.8x$134.69$104.50$74.32$44.13$13.95
19.8x$144.04$113.85$83.67$53.48$23.30
21.8x$153.39$123.21$93.02$62.84$32.65