IRS

IRS — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($15.94)
DCF$4956.37+30993.9%
Graham Number$13.24-16.9%
Reverse DCFimplied g: -2.4%
DDM$49.44+210.2%
EV/EBITDA$1560.69+9691.0%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: $61.64B
Rev: -2.4% / EPS: -27.6%
Default: 9% (no SEC data)

Results

Intrinsic Value / share$4956.37
Current Price$15.94
Upside / Downside+30993.9%
Net Debt (used)$698.47B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term-3.0%1.0%5.0%9.0%13.0%
7.0%$5076.47$7927.75$11244.89$15084.11$19506.02
8.0%$2567.59$4862.53$7528.38$10609.67$14154.41
9.0%$829.04$2739.95$4956.37$7514.80$10454.57
10.0%$-447.26$1182.97$3071.02$5247.55$7745.57
11.0%$-1424.38$-8.02$1629.95$3515.73$5677.53

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $4.43
Yahoo: $1.76

Results

Graham Number$13.24
Current Price$15.94
Margin of Safety-16.9%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

Current Price$15.94
Implied Near-term FCF Growth-2.4%
Historical Revenue Growth-2.4%
Historical Earnings Growth-27.6%
Base FCF (TTM)$61.64B
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: $2.40

Results

DDM Intrinsic Value / share$49.44
Current Price$15.94
Upside / Downside+210.2%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $212.91B
Current: 3.8×
Default: $698.47B

Results

Implied Equity Value / share$1560.69
Current Price$15.94
Upside / Downside+9691.0%
Implied EV$819.27B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt$348.47B$523.47B$698.47B$873.47B$1.05T
-0.2x$-4919.82$-7180.60$-9441.38$-11702.16$-13962.94
1.8x$581.21$-1679.57$-3940.35$-6201.13$-8461.91
3.8x$6082.24$3821.47$1560.69$-700.09$-2960.87
5.8x$11583.28$9322.50$7061.72$4800.94$2540.16
7.8x$17084.31$14823.53$12562.75$10301.97$8041.19