INSW — Valuation Models

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

Valuation Summary

Model	Intrinsic Value	vs Price ($76.50)
DCF	$98270.97	+128358.8%
Graham Number	$63.92	-16.5%
Reverse DCF	—	implied g: 51.1%
DDM	$90.23	+17.9%
EV/EBITDA	$76.55	+0.1%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Base FCF($B)Yahoo: $19.21M

Near-term growth (yrs 1–5)(%)Rev: 37.6% / EPS: 254.4%

Long-term growth (yrs 6–10)(%)

Terminal growth rate(%)

WACC(%)Computed: 2.81%

Computed WACC: 2.81%

Cost of equity (Re)3.24%(Rf 4.30% + β -0.19 × ERP 5.50%)

Cost of debt (Rd)0.00%(no debt / unavailable → 0%)

Tax rate (T)21.00%(US statutory fallback)

Equity weight (E/V)86.77%

Debt weight (D/V)13.23%

Results

Intrinsic Value / share$3316309.10

Current Price$76.50

Upside / Downside+4334944.6%

Net Debt (used)$408.75M

Sensitivity: WACC (rows) × Near-term g (cols)

WACC \ Near-term	246.4%	250.4%	254.4%	258.4%	262.4%
7.0%	$147154.95	$155849.14	$164949.48	$174470.04	$184425.21
8.0%	$111643.42	$118239.42	$125143.54	$132366.47	$139919.10
9.0%	$87669.93	$92849.47	$98270.97	$103942.79	$109873.51
10.0%	$70570.76	$74740.01	$79104.02	$83669.52	$88443.41
11.0%	$57881.14	$61300.65	$64879.88	$68624.37	$72539.77

2 — Graham Number

Assumptions

MultiplierGraham used 22.5 (15× P/E × 1.5× P/B)

EPS (trailing)($)Yahoo: $4.44

Book Value / share($)Yahoo: $40.89

Results

Graham Number$63.92

Current Price$76.50

Margin of Safety-16.5%

Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

WACC(%)Computed: 2.81%

Terminal growth rate(%)

Computed WACC: 2.81%

Cost of equity (Re)3.24%(Rf 4.30% + β -0.19 × ERP 5.50%)

Cost of debt (Rd)0.00%(no debt / unavailable → 0%)

Tax rate (T)21.00%(US statutory fallback)

Equity weight (E/V)86.77%

Debt weight (D/V)13.23%

Results

Current Price$76.50

Implied Near-term FCF Growth-2.3%

Historical Revenue Growth37.6%

Historical Earnings Growth254.4%

Base FCF (TTM)$19.21M

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

Annual dividend D0($/share)Yahoo: $4.38

Dividend growth rate (g)(%)

Required return (r)(%)

Results

DDM Intrinsic Value / share$90.23

Current Price$76.50

Upside / Downside+17.9%

Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

EBITDA($B)Yahoo: $414.66M

Target EV/EBITDA multipleCurrent: 10.1×

Net Debt($B)Default: $408.75M

Results

Implied Equity Value / share$76.55

Current Price$76.50

Upside / Downside+0.1%

Implied EV$4.19B

Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)

Mult \ Net Debt	-$1.59B	-$591.25M	$408.75M	$1.41B	$2.41B
6.1x	$83.47	$63.22	$42.98	$22.73	$2.48
8.1x	$100.25	$80.01	$59.76	$39.52	$19.27
10.1x	$117.04	$96.80	$76.55	$56.31	$36.06
12.1x	$133.83	$113.59	$93.34	$73.10	$52.85
14.1x	$150.62	$130.38	$110.13	$89.89	$69.64

← Overview Financial Statements ← Companies