INGM

INGM — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($20.69)
DCF$-8.88-142.9%
Graham Number$22.52+8.8%
Reverse DCFimplied g: 55.6%
DDM$6.59-68.1%
EV/EBITDA$20.69-0.0%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: $30.58M
Rev: 7.2% / EPS: 21.4%
Default: 9% (no SEC data)

Results

Intrinsic Value / share$-8.88
Current Price$20.69
Upside / Downside-142.9%
Net Debt (used)$3.47B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term13.4%17.4%21.4%25.4%29.4%
7.0%$-8.32$-7.16$-5.84$-4.33$-2.62
8.0%$-9.61$-8.69$-7.64$-6.45$-5.10
9.0%$-10.49$-9.74$-8.88$-7.91$-6.81
10.0%$-11.14$-10.51$-9.79$-8.97$-8.04
11.0%$-11.62$-11.08$-10.47$-9.77$-8.98

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $1.29
Yahoo: $17.47

Results

Graham Number$22.52
Current Price$20.69
Margin of Safety+8.8%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

Current Price$20.69
Implied Near-term FCF Growth55.6%
Historical Revenue Growth7.2%
Historical Earnings Growth21.4%
Base FCF (TTM)$30.58M
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.32

Results

DDM Intrinsic Value / share$6.59
Current Price$20.69
Upside / Downside-68.1%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $1.11B
Current: 7.5×
Default: $3.47B

Results

Implied Equity Value / share$20.69
Current Price$20.69
Upside / Downside-0.0%
Implied EV$8.33B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt$1.47B$2.47B$3.47B$4.47B$5.47B
3.5x$10.37$6.12$1.86$-2.39$-6.64
5.5x$19.78$15.53$11.28$7.02$2.77
7.5x$29.20$24.94$20.69$16.43$12.18
9.5x$38.61$34.35$30.10$25.85$21.59
11.5x$48.02$43.77$39.51$35.26$31.01