SIGIP

SIGIP — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($16.99)
DCF$491867023097.96+2895038393649.0%
Graham Number$84.71+398.6%
Reverse DCFimplied g: -20.0%
DDM$23.69+39.4%
EV/EBITDA$1220886440.45+7185911850.8%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: $1.11B
Rev: 8.6% / EPS: 65.8%
Default: 9% (no SEC data)

Results

Intrinsic Value / share$491867023097.96
Current Price$16.99
Upside / Downside+2895038393649.0%
Net Debt (used)$358.32M
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term57.8%61.8%65.8%69.8%73.8%
7.0%$619139522910.54$701020493167.89$791367670378.70$890822412976.82$1000057710655.91
8.0%$479943172021.26$543280730713.66$613158432126.78$690071321060.09$774538843852.39
9.0%$385196659631.39$435916873641.84$491867023097.96$553442640759.71$621058744457.54
10.0%$317001936353.00$358644495653.55$404574623741.81$455116294175.88$510609430697.04
11.0%$265893404767.11$300735946320.09$339160366255.81$381437063588.29$427849741496.88

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $5.62
Yahoo: $56.74

Results

Graham Number$84.71
Current Price$16.99
Margin of Safety+398.6%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

Current Price$16.99
Implied Near-term FCF Growth-20.0%
Historical Revenue Growth8.6%
Historical Earnings Growth65.8%
Base FCF (TTM)$1.11B
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.15

Results

DDM Intrinsic Value / share$23.69
Current Price$16.99
Upside / Downside+39.4%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $671.43M
Current: 2.4×
Default: $358.32M

Results

Implied Equity Value / share$1220886440.45
Current Price$16.99
Upside / Downside+7185911850.8%
Implied EV$1.58B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt-$1.64B-$641.68M$358.32M$1.36B$2.36B
-1.6x$535154344.45$-464845655.55$-1464845655.55$-2464845655.55$-3464845655.55
0.4x$1878020392.45$878020392.45$-121979607.55$-1121979607.55$-2121979607.55
2.4x$3220886440.45$2220886440.45$1220886440.45$220886440.45$-779113559.55
4.4x$4563752488.45$3563752488.45$2563752488.45$1563752488.45$563752488.45
6.4x$5906618536.45$4906618536.45$3906618536.45$2906618536.45$1906618536.45