IBTA

IBTA — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($24.94)
DCF$40.01+60.4%
Graham Number$28.00+12.3%
Reverse DCFimplied g: -5.3%
DDM
EV/EBITDA$25.90+3.9%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: $44.27M
Rev: -10.0% / EPS: —
Default: 9% (no SEC data)

Results

Intrinsic Value / share$40.01
Current Price$24.94
Upside / Downside+60.4%
Net Debt (used)-$160.84M
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term-3.0%1.0%5.0%9.0%13.0%
7.0%$40.29$47.06$54.92$64.02$74.51
8.0%$34.35$39.79$46.11$53.41$61.82
9.0%$30.22$34.75$40.01$46.08$53.05
10.0%$27.20$31.06$35.54$40.70$46.62
11.0%$24.88$28.24$32.12$36.59$41.72

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $3.05
Yahoo: $11.42

Results

Graham Number$28.00
Current Price$24.94
Margin of Safety+12.3%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

Current Price$24.94
Implied Near-term FCF Growth-5.3%
Historical Revenue Growth-10.0%
Historical Earnings Growth
Base FCF (TTM)$44.27M
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$24.94
Upside / Downside
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $3.60M
Current: 124.2×
Default: -$160.84M

Results

Implied Equity Value / share$25.90
Current Price$24.94
Upside / Downside+3.9%
Implied EV$446.45M
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt-$2.16B-$1.16B-$160.84M$839.16M$1.84B
120.2x$110.59$67.94$25.29$-17.36$-60.02
122.2x$110.90$68.25$25.60$-17.06$-59.71
124.2x$111.21$68.55$25.90$-16.75$-59.40
126.2x$111.51$68.86$26.21$-16.44$-59.10
128.2x$111.82$69.17$26.52$-16.14$-58.79