Intel Corporation [INTC]
Scope limitation, stated first. Tier-2 memo. No .xlsx workbook. Every figure was computed in reproducible Python against cached SEC XBRL facts and cached Alpaca bars; this file is the audit trail. No balance check, because there is no forecast balance sheet — tie-out is to the filed statements only.
Scripts (committed under work/): fetch_facts.py, facts.py, dump.py, bs.py, filings.py,
pr.py, mentions.py, mult.py, anchor.py, calc.py, calc2.py.
Q2 2026 10-Q (0000050863-26-000157, filed 2026-07-24) and FY2025 10-K (0000050863-26-000011, filed 2026-01-23). All $m.
| Line | Model | Filed | Δ |
|---|---|---|---|
| Revenue Q2 2026 | 16,128 | 16,128 | 0 |
| Revenue Q2 2025 | 12,859 | 12,859 | 0 |
| Revenue H1 2026 | 29,705 | 29,705 | 0 |
| Revenue FY2025 | 52,853 | 52,853 | 0 |
| Gross profit Q2 2026 | 6,509 | 6,509 | 0 |
| Operating income Q2 2026 | 1,796 | 1,796 | 0 |
| Operating loss FY2025 | (2,214) | (2,214) | 0 |
| Interest and other, net, Q2 2026 | (12,576) | (12,576) | 0 |
| Net loss attributable to Intel, Q2 2026 | (11,033) | (11,033) | 0 |
| Diluted EPS Q2 2026 | (2.16) | (2.16) | 0 |
| Diluted shares Q2 2026 | 5,104 | 5,104 | 0 |
| Net loss FY2025 | (267) | (267) | 0 |
| Diluted EPS FY2025 | (0.06) | (0.06) | 0 |
| Cash and equivalents 2026-06-27 | 12,874 | 12,874 | 0 |
| Short-term investments 2026-06-27 | 16,853 | 16,853 | 0 |
| Long-term debt, non-current 2026-06-27 | 48,549 | 48,549 | 0 |
| Debt, current 2026-06-27 | 1,988 | 1,988 | 0 |
| Non-controlling interests 2026-06-27 | 15,601 | 15,601 | 0 |
| Escrow derivative liability 2026-06-27 | 15,600 | "$15.6 billion" | 0 |
| Operating cash flow H1 2026 | 8,102 | 8,102 | 0 |
| Capex H1 2026 | 6,192 | 6,192 | 0 |
| Restructuring and other, H1 2026 | 4,240 | 4,240 | 0 |
| Net PP&E 2025-12-27 | 105,414 | 105,414 | 0 |
Cross-checks required by the brief: - Q2 2026: −11,033 ÷ 5,104 = −2.162 vs filed diluted EPS −2.16. Ties. - FY2025: −267 ÷ 4,530 = −0.059 vs filed −0.06. Ties.
| Figure | Formula | Result |
|---|---|---|
| Q4 2025 revenue | FY2025 − 9M2025 = 52,853 − 39,179 | 13,674 |
| TTM revenue | 13,653 + 13,674 + 13,577 + 16,128 | 57,032 (screen agrees) |
| Q4 2025 operating income | FY2025 − 9M2025 = (2,214) − (2,794) | +580 |
| TTM operating income | 683 + 580 + (3,136) + 1,796 | (77) |
| TTM operating margin | (77) / 57,032 | −0.1% |
| Q1 2025 net income | 9M2025 − Q3 2025 − Q2 2025 = 324 − 4,063 − (2,918) | (821) |
| Q4 2025 net income | FY2025 − H1 2025 − Q3 2025 = (267) − (3,739) − 4,063 | (591) |
| TTM net income | 4,063 + (591) + (3,728) + (11,033) | (11,289) |
| TTM net income ex escrow mark | (11,289) + 12,500 | +1,211 |
| Q4 2025 restructuring | FY2025 − 9M2025 = 2,191 − 2,221 | (30) |
| TTM restructuring & impairment | 175 + (30) + 4,070 + 170 | 4,385 |
| TTM operating income ex-restructuring | (77) + 4,385 | +4,308 (7.6%) |
| TTM op income ex-restructuring & ex-government | 4,308 − 1,529 | +2,779 (4.9%) |
| Latest-quarter YoY | 16,128 / 12,859 − 1 | +25.4% |
| 5-year revenue CAGR | (57,032 / 79,024)^(1/5) − 1 | −5.7% |
| 3-year revenue CAGR | (57,032 / 54,228)^(1/3) − 1 | +1.7% |
| Q3 2026 guided YoY | 16,300 / 13,653 − 1 | +19.4% |
| Liquid assets | 12,874 + 16,853 | 29,727 |
| Net debt | 48,549 + 1,988 − 29,727 | 20,810 |
| Enterprise value | 86.24 × 5,043 + 20,810 | 455,714 |
| EV / TTM revenue | 455,714 / 57,032 | 7.99x |
| DCAI share of revenue | 6,262 / 16,128 | 38.8% |
| DCAI share of revenue growth | (6,262 − 3,939) / (16,128 − 12,859) | 71.1% |
| Intel Products segment margin | 4,817 / 15,139 | 31.8% |
| Intel Foundry segment margin | (2,089) / 5,765 | −36.2% |
| External foundry as % of segment | 293 / 5,765 | 5.1% |
| External foundry as % of consolidated | 293 / 16,128 | 1.8% |
| Government support in FY2025 operating income | 529 + 1,000 | 1,529 |
| FY2025 operating loss ex-support | (2,214) − 1,529 | (3,743) |
| Operating margin ex-support | (3,743) / 52,853 | −7.1% |
| Support as % of pre-support loss | 1,529 / 3,743 | 40.9% |
| Loss enlargement without support | 3,743 / 2,214 − 1 | +69.1% |
| Capex intensity FY2024 / FY2025 / H1 2026 | 23,944/53,101; 14,646/52,853; 6,192/29,705 | 45.1% / 27.7% / 20.8% |
| FCF FY2024 / FY2025 / H1 2026 | OCF − capex | (15,656) / (4,949) / +1,910 |
| OCF − net income, H1 2026 | 8,102 − (14,761) | +22,863 |
| Fully loaded share count | 5,043 + 71 + 241 | 5,355 (+6.2%) |
| Value of excluded share claims | (71 + 241) × 86.24 | 26,907 |
| Forward non-GAAP P/E on guided Q3 | 86.24 / (0.38 × 4) | 56.7x |
beta = cov(INTC, SPY) / var(SPY) over 252 sessions = 2.69
Ke = 4.2% + 2.69 × 5.5% = 19.0%
w_e = 434,908 / (434,908 + 50,537) = 89.6%
WACC = 0.896 × 19.0% + 0.104 × 6.0% × (1 − 0.10) = 17.6%
realised vol = stdev(daily returns) × sqrt(252) = 77.8%
The 17.6% WACC is disclosed as aggressive and the conclusion is shown to be independent of it:
at a 9.0% WACC the required terminal margin is still 27.2%, above Intel's best-ever 24.6%
(INTC_Valuation.md §4).
1,508 daily sessions, 2020-07-27 → 2026-07-28 (Alpaca IEX, split-adjusted). TTM revenue as known at each date, lagged to the filing date, fourth quarters inferred as (annual − three tagged quarters). Share count and net debt held at today's verified values.
Only the EV/Sales series is reported. EV/EBIT and P/E were computed and are discarded as uninterpretable: TTM EBIT crosses zero, which makes the ratio unbounded (the series printed a "current" 494.6x at the 100th percentile — an artifact of a near-zero denominator, not a valuation statement), and TTM EPS is negative. Reporting either would have been a fabrication of precision and they are named here so the discard is on the record.
Same known bias as elsewhere: holding today's net debt constant across history distorts historic EV. For Intel the distortion is small (net debt has been $20–50bn throughout, and it is 4.6% of today's EV), so the EV/Sales percentiles are more reliable here than for Oracle.
Source: reports/scan_v3/_scan.json, 3,980 names with status == "OK".
Two brackets, both sic2 == "36" and market_cap > $5bn and 0 < ev_ebit < 200:
revenue_cagr_demonstrated in [0%, 10%]. n = 18. Set growth 0.1%–8.7%.
EV/EBIT p25 17.1x, median 28.1x, p75 46.1x. Cap min $5.0bn, median $9.8bn.Neither bracket satisfies the strict valuation.md condition, because the condition is that the
set's growth must bracket the subject's exit-year growth — and Intel's exit-year growth is not
estimable (five-year CAGR −5.7%, latest quarter +25.4%). This is declared rather than papered over:
the anchor is imperfect, 28.1x is a reference point not a derivation, and the sensitivity in
INTC_Valuation.md §4 spans 11.9x to 50.8x for that reason.
Market-cap floor of $5bn set explicitly to avoid the logged sub-$100m-shell defect; realised minimum $5.0bn.