TREE

TREE — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($37.74)
DCF$2828933887046.63+7495850257045.3%
Graham Number$22.29-40.9%
Reverse DCFimplied g: 14.0%
DDM
EV/EBITDA$38.01+0.7%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: $29.43M
Rev: 22.2% / EPS: 1743.1%
Default: 9% (no SEC data)

Results

Intrinsic Value / share$2829660678738.60
Current Price$37.74
Upside / Downside+7497776043192.5%
Net Debt (used)$354.14M
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term1735.1%1739.1%1743.1%1747.1%1751.1%
7.0%$4713766861411.87$4765364714630.65$4817413422396.29$4869915932901.76$4922875207164.50
8.0%$3551082118099.56$3589952986945.02$3629163503795.66$3668715889651.28$3708612375172.88
9.0%$2768780581706.85$2799088218359.94$2829660678738.60$2860499694557.52$2891607005064.24
10.0%$2212833340360.65$2237055465110.86$2261489239267.22$2286136046831.04$2310997277823.96
11.0%$1801867048828.43$1821590652728.10$1841486598611.92$1861556013445.16$1881800029095.33

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $1.06
Yahoo: $20.83

Results

Graham Number$22.29
Current Price$37.74
Margin of Safety-40.9%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

Current Price$37.74
Implied Near-term FCF Growth14.0%
Historical Revenue Growth22.2%
Historical Earnings Growth1743.1%
Base FCF (TTM)$29.43M
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: —

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$37.74
Upside / Downside
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $103.76M
Current: 8.4×
Default: $354.14M

Results

Implied Equity Value / share$38.01
Current Price$37.74
Upside / Downside+0.7%
Implied EV$873.83M
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt-$1.65B-$645.86M$354.14M$1.35B$2.35B
4.4x$153.95$80.81$7.66$-65.49$-138.64
6.4x$169.13$95.98$22.84$-50.31$-123.46
8.4x$184.31$111.16$38.01$-35.13$-108.28
10.4x$199.49$126.34$53.19$-19.96$-93.10
12.4x$214.67$141.52$68.37$-4.78$-77.92