STNG

STNG — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($80.19)
DCF$3493.39+4256.4%
Graham Number$103.64+29.2%
Reverse DCFimplied g: 6.5%
DDM$34.40-57.1%
EV/EBITDA$72.98-9.0%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: $209.46M
Rev: 23.9% / EPS: 80.5%
Default: 9% (no SEC data)

Results

Intrinsic Value / share$3499.10
Current Price$80.19
Upside / Downside+4263.5%
Net Debt (used)-$132.75M
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term72.5%76.5%80.5%84.5%88.5%
7.0%$4532.28$5079.42$5678.30$6332.51$7045.80
8.0%$3497.80$3919.38$4380.79$4884.79$5434.27
9.0%$2794.81$3131.08$3499.10$3901.05$4339.24
10.0%$2289.75$2564.74$2865.67$3194.33$3552.59
11.0%$1911.96$2141.14$2391.91$2665.76$2964.25

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $7.03
Yahoo: $67.91

Results

Graham Number$103.64
Current Price$80.19
Margin of Safety+29.2%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

Current Price$80.19
Implied Near-term FCF Growth6.5%
Historical Revenue Growth23.9%
Historical Earnings Growth80.5%
Base FCF (TTM)$209.46M
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.67

Results

DDM Intrinsic Value / share$34.40
Current Price$80.19
Upside / Downside-57.1%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $490.03M
Current: 7.4×
Default: -$132.75M

Results

Implied Equity Value / share$72.98
Current Price$80.19
Upside / Downside-9.0%
Implied EV$3.64B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt-$2.13B-$1.13B-$132.75M$867.25M$1.87B
3.4x$73.75$54.43$35.11$15.79$-3.53
5.4x$92.68$73.36$54.05$34.73$15.41
7.4x$111.62$92.30$72.98$53.66$34.34
9.4x$130.55$111.23$91.91$72.59$53.28
11.4x$149.48$130.17$110.85$91.53$72.21