TIGO

TIGO — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($71.29)
DCF$5124022039.85+7187574650.8%
Graham Number$56.53-20.7%
Reverse DCFimplied g: 1.3%
DDM$61.80-13.3%
EV/EBITDA$75.03+5.2%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: $1.41B
Rev: 15.7% / EPS: 728.7%
Default: 9% (no SEC data)

Results

Intrinsic Value / share$5126768411.56
Current Price$71.29
Upside / Downside+7191427044.8%
Net Debt (used)$7.94B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term720.7%724.7%728.7%732.7%736.7%
7.0%$8287593420.14$8491535565.46$8699473003.11$8911464149.47$9127567987.62
8.0%$6253667963.79$6407558974.52$6564464759.01$6724429397.16$6887497396.50
9.0%$4884039900.17$5004226905.38$5126768411.56$5251698844.57$5379052964.22
10.0%$3909837771.95$4006051471.78$4104150027.51$4204160998.17$4306112210.13
11.0%$3189003301.42$3267478604.74$3347491262.86$3429063753.89$3512218773.99

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $6.52
Yahoo: $21.78

Results

Graham Number$56.53
Current Price$71.29
Margin of Safety-20.7%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

Current Price$71.29
Implied Near-term FCF Growth1.3%
Historical Revenue Growth15.7%
Historical Earnings Growth728.7%
Base FCF (TTM)$1.41B
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: $3.00

Results

DDM Intrinsic Value / share$61.80
Current Price$71.29
Upside / Downside-13.3%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $2.80B
Current: 7.3×
Default: $7.94B

Results

Implied Equity Value / share$75.03
Current Price$71.29
Upside / Downside+5.2%
Implied EV$20.48B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt$3.94B$5.94B$7.94B$9.94B$11.94B
3.3x$31.87$19.90$7.93$-4.04$-16.01
5.3x$65.42$53.45$41.48$29.51$17.54
7.3x$98.97$87.00$75.03$63.06$51.09
9.3x$132.52$120.55$108.58$96.61$84.64
11.3x$166.08$154.11$142.14$130.17$118.20