TLK

TLK — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($21.27)
DCF$498738.46+2344697.7%
Graham Number$202.00+849.7%
Reverse DCFimplied g: -20.0%
DDM$26.57+24.9%
EV/EBITDA$745628.39+3505440.1%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: $28.14T
Rev: -0.9% / EPS: -18.7%
Default: 9% (no SEC data)

Results

Intrinsic Value / share$498738.46
Current Price$21.27
Upside / Downside+2344697.7%
Net Debt (used)$0
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term-3.0%1.0%5.0%9.0%13.0%
7.0%$503023.03$604745.49$723087.66$860055.47$1017811.54
8.0%$413516.36$495390.71$590497.46$700425.54$826887.61
9.0%$351491.77$419665.43$498738.46$590012.93$694891.99
10.0%$305958.79$364118.60$431476.78$509126.58$598245.86
11.0%$271098.80$321629.01$380065.15$447342.05$524466.67

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $1.31
Yahoo: $1384.40

Results

Graham Number$202.00
Current Price$21.27
Margin of Safety+849.7%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

Current Price$21.27
Implied Near-term FCF Growth-20.0%
Historical Revenue Growth-0.9%
Historical Earnings Growth-18.7%
Base FCF (TTM)$28.14T
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: $1.29

Results

DDM Intrinsic Value / share$26.57
Current Price$21.27
Upside / Downside+24.9%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $61.55T
Current: —×
Default: $0

Results

Implied Equity Value / share$745628.39
Current Price$21.27
Upside / Downside+3505440.1%
Implied EV$738.64T
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt-$2.00B-$1.00B$0$1.00B$2.00B
8.0x$497087.61$497086.60$497085.59$497084.58$497083.57
10.0x$621359.01$621358.00$621356.99$621355.98$621354.97
12.0x$745630.41$745629.40$745628.39$745627.38$745626.37
14.0x$869901.81$869900.80$869899.79$869898.78$869897.77
16.0x$994173.20$994172.20$994171.19$994170.18$994169.17