TIMB

TIMB — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($26.50)
DCF$863.01+3156.6%
Graham Number$8.75-67.0%
Reverse DCFimplied g: -20.0%
DDM$51.50+94.3%
EV/EBITDA$132.49+400.0%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: $6.11B
Rev: 4.4% / EPS: 29.1%
Default: 9% (no SEC data)

Results

Intrinsic Value / share$861.46
Current Price$26.50
Upside / Downside+3150.8%
Net Debt (used)$10.66B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term21.1%25.1%29.1%33.1%37.1%
7.0%$977.08$1147.37$1340.48$1558.64$1804.22
8.0%$770.46$904.42$1056.25$1227.69$1420.60
9.0%$628.81$737.90$861.46$1000.93$1157.79
10.0%$526.05$617.11$720.21$836.51$967.27
11.0%$448.37$525.83$613.49$712.32$823.38

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $1.74
Yahoo: $1.96

Results

Graham Number$8.75
Current Price$26.50
Margin of Safety-67.0%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

Current Price$26.50
Implied Near-term FCF Growth-20.0%
Historical Revenue Growth4.4%
Historical Earnings Growth29.1%
Base FCF (TTM)$6.11B
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: $2.50

Results

DDM Intrinsic Value / share$51.50
Current Price$26.50
Upside / Downside+94.3%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $11.07B
Current: 6.7×
Default: $10.66B

Results

Implied Equity Value / share$132.49
Current Price$26.50
Upside / Downside+400.0%
Implied EV$73.95B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt$4.66B$7.66B$10.66B$13.66B$16.66B
2.7x$52.38$46.10$39.82$33.54$27.26
4.7x$98.71$92.43$86.16$79.88$73.60
6.7x$145.05$138.77$132.49$126.21$119.93
8.7x$191.38$185.10$178.82$172.54$166.26
10.7x$237.71$231.43$225.16$218.88$212.60