TGS

TGS — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($29.72)
DCF$161639.79+543775.5%
Graham Number$9.94-66.5%
Reverse DCFimplied g: -20.0%
DDM$19.57-34.2%
EV/EBITDA$319.99+976.7%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: $28.80B
Rev: 26.2% / EPS: 62.9%
Default: 9% (no SEC data)

Results

Intrinsic Value / share$161367.79
Current Price$29.72
Upside / Downside+542860.3%
Net Debt (used)-$89.47B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term54.9%58.9%62.9%66.9%70.9%
7.0%$201456.69$228409.75$258201.71$291051.60$327189.44
8.0%$156660.59$177529.05$200592.33$226019.62$253988.58
9.0%$126157.44$142884.35$161367.79$181743.05$204152.18
10.0%$104193.06$117939.12$133126.38$149865.72$168273.56
11.0%$87724.17$99236.36$111953.51$125968.23$141377.77

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $1.68
Yahoo: $2.62

Results

Graham Number$9.94
Current Price$29.72
Margin of Safety-66.5%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

Current Price$29.72
Implied Near-term FCF Growth-20.0%
Historical Revenue Growth26.2%
Historical Earnings Growth62.9%
Base FCF (TTM)$28.80B
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: $0.95

Results

DDM Intrinsic Value / share$19.57
Current Price$29.72
Upside / Downside-34.2%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $672.26B
Current: -0.1×
Default: -$89.47B

Results

Implied Equity Value / share$319.99
Current Price$29.72
Upside / Downside+976.7%
Implied EV-$67.23B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt-$133.47B-$111.47B-$89.47B-$67.47B-$45.47B
-4.1x$-37730.70$-38047.19$-38363.67$-38680.16$-38996.64
-2.1x$-18388.87$-18705.36$-19021.84$-19338.32$-19654.81
-0.1x$952.96$636.48$319.99$3.51$-312.98
1.9x$20294.79$19978.31$19661.82$19345.34$19028.86
3.9x$39636.62$39320.14$39003.66$38687.17$38370.69