CHCT — Valuation Models

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

Valuation Summary

Model	Intrinsic Value	vs Price ($17.32)
DCF	$105372325751.76	+608385252508.3%
Graham Number	$5.35	-69.1%
Reverse DCF	—	implied g: 1.6%
DDM	$39.14	+126.0%
EV/EBITDA	$16.40	-5.3%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Base FCF($B)Yahoo: $70.91M

Near-term growth (yrs 1–5)(%)Rev: 5.6% / EPS: 1193.1%

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

Terminal growth rate(%)

WACC(%)Computed: 3.93%

Computed WACC: 3.93%

Cost of equity (Re)8.19%(Rf 4.30% + β 0.71 × 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)48.00%

Debt weight (D/V)52.00%

Results

Intrinsic Value / share$728764052922.23

Current Price$17.32

Upside / Downside+4207644647257.0%

Net Debt (used)$526.16M

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

WACC \ Near-term	1185.1%	1189.1%	1193.1%	1197.1%	1201.1%
7.0%	$173661929223.38	$176381505390.88	$179135046575.47	$181922869932.42	$184745294585.22
8.0%	$130897679621.26	$132947560124.03	$135023041757.52	$137124363577.51	$139251766123.32
9.0%	$102116319154.54	$103715478495.88	$105334609872.88	$106973899778.50	$108633535863.03
10.0%	$81656614148.45	$82935370916.48	$84230098185.09	$85540945082.10	$86868061660.76
11.0%	$66527641870.54	$67569476277.24	$68624322240.97	$69692301259.78	$70773535585.73

2 — Graham Number

Assumptions

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

EPS (trailing)($)Yahoo: $0.08

Book Value / share($)Yahoo: $15.93

Results

Graham Number$5.35

Current Price$17.32

Margin of Safety-69.1%

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

3 — Reverse DCF (Implied Growth)

Assumptions

WACC(%)Computed: 3.93%

Terminal growth rate(%)

Computed WACC: 3.93%

Cost of equity (Re)8.19%(Rf 4.30% + β 0.71 × 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)48.00%

Debt weight (D/V)52.00%

Results

Current Price$17.32

Implied Near-term FCF Growth-18.5%

Historical Revenue Growth5.6%

Historical Earnings Growth1193.1%

Base FCF (TTM)$70.91M

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: $1.90

Dividend growth rate (g)(%)

Required return (r)(%)

Results

DDM Intrinsic Value / share$39.14

Current Price$17.32

Upside / Downside+126.0%

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

5 — EV/EBITDA Multiple

Assumptions

EBITDA($B)Yahoo: $75.12M

Target EV/EBITDA multipleCurrent: 13.2×

Net Debt($B)Default: $526.16M

Results

Implied Equity Value / share$16.40

Current Price$17.32

Upside / Downside-5.3%

Implied EV$994.70M

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

Mult \ Net Debt	-$1.47B	-$473.84M	$526.16M	$1.53B	$2.53B
9.2x	$75.88	$40.88	$5.88	$-29.12	$-64.12
11.2x	$81.14	$46.14	$11.14	$-23.86	$-58.86
13.2x	$86.40	$51.40	$16.40	$-18.60	$-53.60
15.2x	$91.66	$56.66	$21.66	$-13.34	$-48.34
17.2x	$96.91	$61.91	$26.91	$-8.08	$-43.08

← Overview Financial Statements ← Companies