STG

STG — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($4.50)
DCF$125.17+2681.5%
Graham Number$30.53+578.4%
Reverse DCF
DDM
EV/EBITDA$5.61+24.6%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: —
Rev: 6.5% / EPS: 42.6%
Default: 9% (no SEC data)

Results

Intrinsic Value / share$125.17
Current Price$4.50
Upside / Downside+2681.5%
Net Debt (used)-$639.44M
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term34.6%38.6%42.6%46.6%50.6%
7.0%$125.17$125.17$125.17$125.17$125.17
8.0%$125.17$125.17$125.17$125.17$125.17
9.0%$125.17$125.17$125.17$125.17$125.17
10.0%$125.17$125.17$125.17$125.17$125.17
11.0%$125.17$125.17$125.17$125.17$125.17

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $4.16
Yahoo: $9.96

Results

Graham Number$30.53
Current Price$4.50
Margin of Safety+578.4%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

Reverse DCF requires positive TTM free cash flow.
Current Price$4.50
Implied Near-term FCF Growth
Historical Revenue Growth6.5%
Historical Earnings Growth42.6%
Base FCF (TTM)
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$4.50
Upside / Downside
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $418.35M
Current: -1.5×
Default: -$639.44M

Results

Implied Equity Value / share$5.61
Current Price$4.50
Upside / Downside+24.6%
Implied EV-$610.80M
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt-$2.64B-$1.64B-$639.44M$360.56M$1.36B
-5.5x$69.53$-126.21$-321.96$-517.70$-713.44
-3.5x$233.32$37.57$-158.17$-353.92$-549.66
-1.5x$397.10$201.35$5.61$-190.14$-385.88
0.5x$560.88$365.13$169.39$-26.36$-222.10
2.5x$724.66$528.91$333.17$137.43$-58.32