IAG

IAG — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($22.79)
DCF$2476522.95+10868993.5%
Graham Number$13.49-40.8%
Reverse DCFimplied g: 11.4%
DDM
EV/EBITDA$24.34+6.8%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: $538.00M
Rev: 131.6% / EPS: 362.0%
Default: 9% (no SEC data)

Results

Intrinsic Value / share$2476522.95
Current Price$22.79
Upside / Downside+10868993.5%
Net Debt (used)$338.90M
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term354.0%358.0%362.0%366.0%370.0%
7.0%$3828281.78$3999922.07$4177664.28$4361669.67$4552102.34
8.0%$2897240.74$3027137.02$3161651.17$3300905.23$3445023.37
9.0%$2269411.67$2371158.75$2476522.95$2585599.87$2698486.78
10.0%$1822163.02$1903857.39$1988455.99$2076035.57$2166674.22
11.0%$1490692.44$1557525.12$1626733.68$1698380.91$1772530.69

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $1.14
Yahoo: $7.09

Results

Graham Number$13.49
Current Price$22.79
Margin of Safety-40.8%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

Current Price$22.79
Implied Near-term FCF Growth11.4%
Historical Revenue Growth131.6%
Historical Earnings Growth362.0%
Base FCF (TTM)$538.00M
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$22.79
Upside / Downside
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $1.37B
Current: 10.7×
Default: $338.90M

Results

Implied Equity Value / share$24.34
Current Price$22.79
Upside / Downside+6.8%
Implied EV$14.67B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt-$1.66B-$661.10M$338.90M$1.34B$2.34B
6.7x$18.47$16.77$15.07$13.37$11.67
8.7x$23.10$21.40$19.71$18.01$16.31
10.7x$27.74$26.04$24.34$22.64$20.95
12.7x$32.38$30.68$28.98$27.28$25.58
14.7x$37.01$35.32$33.62$31.92$30.22