HROW — Valuation Models

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

Valuation Summary

Model	Intrinsic Value	vs Price ($53.59)
DCF	$-251.11	-568.6%
Graham Number	—	—
Reverse DCF	—	—
DDM	—	—
EV/EBITDA	$53.58	-0.0%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Base FCF($B)Yahoo: -$55.71M

Near-term growth (yrs 1–5)(%)Rev: 45.4% / EPS: —

Long-term growth (yrs 6–10)(%)

Terminal growth rate(%)

WACC(%)Computed: 4.28%

Computed WACC: 4.28%

Cost of equity (Re)4.83%(Rf 4.30% + β 0.10 × ERP 5.50%)

Cost of debt (Rd)0.00%(no debt / unavailable → 0%)

Tax rate (T)21.00%(US statutory fallback)

Equity weight (E/V)88.74%

Debt weight (D/V)11.26%

Results

Intrinsic Value / share$-1123.22

Current Price$53.59

Upside / Downside-2196.0%

Net Debt (used)$174.42M

Sensitivity: WACC (rows) × Near-term g (cols)

WACC \ Near-term	37.4%	41.4%	45.4%	49.4%	53.4%
7.0%	$-299.20	$-343.81	$-393.72	$-449.38	$-511.28
8.0%	$-235.30	$-270.08	$-308.97	$-352.34	$-400.55
9.0%	$-191.67	$-219.74	$-251.11	$-286.08	$-324.96
10.0%	$-160.16	$-183.38	$-209.33	$-238.24	$-270.38
11.0%	$-136.45	$-156.03	$-177.90	$-202.26	$-229.33

2 — Graham Number

Assumptions

MultiplierGraham used 22.5 (15× P/E × 1.5× P/B)

EPS (trailing)($)Yahoo: $-0.13

Book Value / share($)Yahoo: $1.27

Results

Graham Number requires positive EPS and positive Book Value per share. EPS is zero or negative.

Graham Number—

Current Price$53.59

Margin of Safety—

Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

WACC(%)Computed: 4.28%

Terminal growth rate(%)

Computed WACC: 4.28%

Cost of equity (Re)4.83%(Rf 4.30% + β 0.10 × ERP 5.50%)

Cost of debt (Rd)0.00%(no debt / unavailable → 0%)

Tax rate (T)21.00%(US statutory fallback)

Equity weight (E/V)88.74%

Debt weight (D/V)11.26%

Results

Reverse DCF requires positive TTM free cash flow.

Current Price$53.59

Implied Near-term FCF Growth—

Historical Revenue Growth45.4%

Historical Earnings Growth—

Base FCF (TTM)-$55.71M

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

Annual dividend D0($/share)Yahoo: —

Dividend growth rate (g)(%)

Required return (r)(%)

Results

This company does not pay a dividend. DDM is not applicable — the intrinsic value shown uses D0 = $0 unless you enter a hypothetical dividend above.

DDM Intrinsic Value / share—

Current Price$53.59

Upside / Downside—

Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

EBITDA($B)Yahoo: $46.15M

Target EV/EBITDA multipleCurrent: 46.8×

Net Debt($B)Default: $174.42M

Results

Implied Equity Value / share$53.58

Current Price$53.59

Upside / Downside-0.0%

Implied EV$2.16B

Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)

Mult \ Net Debt	-$1.83B	-$825.58M	$174.42M	$1.17B	$2.17B
42.8x	$102.60	$75.60	$48.60	$21.60	$-5.40
44.8x	$105.09	$78.09	$51.09	$24.09	$-2.91
46.8x	$107.58	$80.58	$53.58	$26.58	$-0.42
48.8x	$110.07	$83.07	$56.07	$29.07	$2.07
50.8x	$112.56	$85.56	$58.56	$31.56	$4.57

← Overview Financial Statements ← Companies