Dell Technologies [DELL]
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.
Q1 FY2027 10-Q (0001571996-26-000030, filed 2026-06-09) and FY2026 10-K (0001571996-26-000008, filed 2026-03-16). All $m.
| Line | Model | Filed | Δ |
|---|---|---|---|
| Net revenue Q1 FY2027 | 43,842 | 43,842 | 0 |
| Net revenue Q1 FY2026 | 23,378 | 23,378 | 0 |
| Net revenue FY2026 | 113,538 | 113,538 | 0 |
| Net revenue FY2025 | 95,567 | 95,567 | 0 |
| Gross profit Q1 FY2027 | 7,782 | 7,782 | 0 |
| Gross profit Q1 FY2026 | 4,937 | 4,937 | 0 |
| Gross profit FY2026 | 22,707 | 22,707 | 0 |
| Operating income Q1 FY2027 | 3,656 | 3,656 | 0 |
| Operating income FY2026 | 8,149 | 8,149 | 0 |
| Income before income taxes Q1 FY2027 | 3,948 | 3,948 | 0 |
| Income tax expense Q1 FY2027 | 510 | 510 | 0 |
| Net income Q1 FY2027 | 3,438 | 3,438 | 0 |
| Net income FY2026 | 5,936 | 5,936 | 0 |
| Diluted EPS Q1 FY2027 | 5.24 | 5.24 | 0 |
| Diluted EPS FY2026 | 8.68 | 8.68 | 0 |
| Diluted shares Q1 FY2027 | 656 | 656 | 0 |
| AI-optimized servers revenue Q1 FY2027 | 16,132 | 16,132 | 0 |
| AI-optimized servers revenue Q1 FY2026 | 1,882 | 1,882 | 0 |
| Traditional servers & networking Q1 FY2027 | 8,543 | 8,543 | 0 |
| Storage Q1 FY2027 | 4,334 | 4,334 | 0 |
| Total ISG revenue / operating income | 29,009 / 3,055 | 29,009 / 3,055 | 0 |
| Total CSG revenue / operating income | 14,609 / 1,170 | 14,609 / 1,170 | 0 |
| Cash and equivalents 2026-05-01 | 11,578 | 11,578 | 0 |
| Total debt, principal 2026-05-01 | 31,413 | 31,413 | 0 |
| Total debt, carrying value | 31,161 | 31,161 | 0 |
| Total core debt | 16,707 | 16,707 | 0 |
| Total DFS-related debt | 14,596 | 14,596 | 0 |
| DFS owned assets | 16,681 | 16,681 | 0 |
| Inventory 2026-05-01 | 15,052 | 15,052 | 0 |
| Accounts receivable, net 2026-05-01 | 25,854 | 25,854 | 0 |
| Accounts payable 2026-05-01 | 45,261 | 45,261 | 0 |
| Allowance for expected credit losses | 77 | 77 | 0 |
| Stockholders' equity 2026-05-01 | (1,404) | (1,404) | 0 |
| Operating cash flow Q1 FY2027 | 4,081 | 4,081 | 0 |
| Capex Q1 FY2027 / FY2026 | 963 / 2,633 | 963 / 2,633 | 0 |
Cross-checks required by the brief: - Q1 FY2027: 3,438 ÷ 656 = $5.241 vs filed diluted EPS $5.24. Exact. - FY2026: 5,936 ÷ 684 = $8.678 vs filed $8.68. Exact.
| Figure | Formula | Result |
|---|---|---|
| Q4 FY2026 revenue | FY2026 − 9M = 113,538 − 80,159 | 33,379 |
| TTM revenue | 29,776 + 27,005 + 33,379 + 43,842 | 134,002 (screen agrees) |
| Q4 FY2026 operating income | 8,149 − 5,057 | 3,092 |
| TTM operating income | 1,773 + 2,119 + 3,092 + 3,656 | 10,640 |
| TTM operating margin | 10,640 / 134,002 | 7.94% |
| Q4 FY2026 gross profit | 22,707 − 15,977 | 6,730 |
| TTM gross profit / margin | 5,447+5,593+6,730+7,782 = 25,552 | 19.07% |
| Q4 FY2026 net income | 5,936 − 3,677 | 2,259 |
| TTM net income | 1,164 + 1,548 + 2,259 + 3,438 | 8,409 |
| TTM diluted EPS | 1.70 + 2.28 + 3.34 + 5.24 | 12.56 |
| Q1 FY2027 gross margin | 7,782 / 43,842 | 17.75% (filing: "decreased 330bp to 17.8%") |
| Q1 FY2026 gross margin | 4,937 / 23,378 | 21.12% |
| Q1 FY2027 operating margin | 3,656 / 43,842 | 8.34% (filing: "+330bp to 8.3%") |
| Latest-quarter YoY | 43,842 / 23,378 − 1 | +87.5% |
| AI share of revenue | 16,132 / 43,842 | 36.8% |
| AI share of revenue growth | (16,132 − 1,882) / (43,842 − 23,378) | 69.6% |
| FY2026 AI-server revenue (implied) | 60,000 / 2.44 | ≈24,590 |
| FY2026 AI share of revenue | 24,590 / 113,538 | 21.7% |
| FY2027E AI share of revenue | 60,000 / 167,000 | 35.9% |
| FY2027E AI share of growth | (60,000 − 24,590) / (167,000 − 113,538) | 66.2% |
| FY2022 revenue | 79,306 + 21,891 | 101,197 |
| FY2023 revenue | 79,615 + 22,686 | 102,301 |
| FY2024 revenue | 67,356 + 21,069 | 88,425 |
| 4-year revenue CAGR | (113,538 / 101,197)^(1/4) − 1 | +2.9% |
| 3.25-year CAGR (FY2023 → TTM) | (134,002 / 102,301)^(1/3.25) − 1 | +8.6% |
| FY2026 revenue growth | 113,538 / 95,567 − 1 | +18.8% |
| FY2027 guided growth | 167,000 / 113,538 − 1 | +47.1% |
| Net debt | 31,161 − 11,578 | 19,583 |
| Net core debt | 16,707 − 11,578 | 5,129 |
| DFS surplus | 16,681 − 14,596 | +2,085 |
| Enterprise value | 392.13 × 649 + 19,583 | 274,075 |
| EV / TTM revenue | 274,075 / 134,002 | 2.05x |
| EV / TTM EBIT | 274,075 / 10,640 | 25.8x |
| EV on core debt | 392.13 × 649 + 5,129 | 259,621 (1.94x / 24.4x) |
| Capex intensity FY2026 / Q1 FY2027 | 2,633/113,538; 963/43,842 | 2.3% / 2.2% |
| FCF FY2026 | 11,185 − 2,633 | +8,552 |
| FCF / net income FY2026 | 8,552 / 5,936 | 1.44x |
| FCF Q1 FY2027 | 4,081 − 963 | +3,118 (0.91x net income) |
| DSO Q1 FY2027 | 25,854 / (43,842/90) | 53.1 days |
| DSO Q1 FY2026 | 9,785 / (23,378/90) | 37.7 days |
| DPO Q1 FY2027 / FY2026 | 45,261/(36,060/90); 25,349/(18,441/90) | 112.9 / 123.7 days |
| Inventory days Q1 FY2027 / FY2026 | 15,052/(36,060/90); 7,415/(18,441/90) | 37.6 / 36.2 |
| Allowance as % of AR | 77 / 25,854; 77 / 17,585 | 0.30% / 0.44% |
| Working capital: ΔAP vs Δ(AR+inv) | 11,631 vs 12,884 | net drag −1,253 |
| Capital return Q1 FY2027 | 1,628 + 464 | 2,092 (61% of net income) |
| Share count reduction | 649 / 696 − 1 | −6.8% over 5 quarters |
| Required year-5 revenue at 19.95% | 134,002 × 1.1995^5 | ≈333,000 |
| Post-guide CAGR required | (333,000 / 167,000)^(1/4) − 1 | +18.8% |
Two equations, two unknowns. Stated assumption: non-AI gross margin unchanged year-on-year. x = AI-optimized server gross margin, y = non-AI gross margin.
Q1 FY2026 revenue split: AI 1,882 ; non-AI 23,378 − 1,882 = 21,496 ; gross profit 4,937
Q1 FY2027 revenue split: AI 16,132 ; non-AI 43,842 − 16,132 = 27,710 ; gross profit 7,782
(1) 1,882x + 21,496y = 4,937
(2) 16,132x + 27,710y = 7,782
From (1): y = (4,937 − 1,882x) / 21,496
Sub into (2): 16,132x + (27,710/21,496)(4,937 − 1,882x) = 7,782
27,710/21,496 = 1.28908
16,132x + 1.28908(4,937 − 1,882x) = 7,782
16,132x + 6,364.2 − 2,425.0x = 7,782
13,707x = 1,417.8
x = 0.10344 -> AI gross margin = 10.34%
y = (4,937 − 194.7) / 21,496 = 0.22061 -> non-AI = 22.06%
Verification against the reported figure:
16,132 × 0.10344 + 27,710 × 0.22061 = 1,668.7 + 6,113.3 = 7,782.0 == reported gross profit ✓
Independent validation via the mix effect:
AI share of revenue, Q1 FY2026 = 1,882 / 23,378 = 8.05%
AI share of revenue, Q1 FY2027 = 16,132 / 43,842 = 36.80%
blended GM at 8.05% mix = 0.0805 × 10.344% + 0.9195 × 22.061% = 21.12%
blended GM at 36.80% mix = 0.3680 × 10.344% + 0.6320 × 22.061% = 17.75%
mix effect = −337 basis points
Dell reported: −330 basis points
The solve reproduces Dell's own disclosed gross-margin decline to within 7 basis points, from two independent equations. That is the validation, and it is why the 10.3% figure is used in the memo despite being derived rather than disclosed.
Forward sensitivity: d(blended GM)/d(AI mix) = y − x = 22.061% − 10.344% = 11.72pp, i.e. ~118
basis points of blended gross margin per 10 percentage points of AI mix.
| AI share of revenue | Blended gross margin |
|---|---|
| 21.7% (FY2026) | 19.52% |
| 35.9% (FY2027 guide) | 17.85% |
| 50.0% | 16.20% |
| 60.0% | 14.55% |
Limitations of the solve, stated:
1. It rests on one assumption — that non-AI gross margin was unchanged year-on-year. If non-AI
margin actually rose (Dell says CSG gross margin rose on "disciplined pricing"), the true AI
margin is lower than 10.3%; if non-AI fell, the true AI margin is higher. The direction of
error is therefore probably toward a lower AI margin, i.e. my figure is conservative against my own
conclusion.
2. It is a two-period solve on one quarter pair. A third quarter would over-determine the system
and allow a residual test; that is a next-print task.
3. It attributes the whole blended decline to product mix. The filing shows product gross margin
fell only 30bp to 13.8%, so part of the blended decline is the services-to-product shift
(services revenue fell 1% while product rose 117%) rather than AI economics specifically. Both facts
are consistent with a structurally ~10% AI margin, and both are reported in DELL_Research.md §4.
beta = cov(DELL, SPY) / var(SPY) over 252 sessions = 1.95
Ke = 4.2% + 1.95 × 5.5% = 14.9%
w_e = 254,493 / (254,493 + 31,161) = 89.1%
WACC = 0.891 × 14.9% + 0.109 × 5.5% × (1 − 0.20) = 13.8%
realised vol = stdev(daily returns) × sqrt(252) = 69.7%
Stated assumptions: risk-free 4.2%, ERP 5.5%, pre-tax cost of debt 5.5%, forward tax 20% (against a Q1 FY2027 effective rate of 12.9% that included $0.2bn of discrete SBC benefits — 20% is the normalised, conservative choice).
1,505 daily sessions, 2020-07-27 → 2026-07-28 (Alpaca IEX, split-adjusted). TTM metric 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.
Same known bias as elsewhere (today's net debt held constant), but for Dell net debt is only 7.1% of EV, so the distortion is materially smaller than for Oracle, and the P/E series — immune to it — agrees at the 96th percentile. The EV/EBIT series begins 2021-03-26 (1,337 sessions) because four quarters of as-known operating income are needed first.
The three-year window is used for the 12-month target anchor and the six-year window is reported
alongside, because the six-year window spans pre-AI Dell (a 4–10x P/E business) and is a different
company. That choice is the single largest judgement in the target and is stated as such in
DELL_Valuation.md §5.
TTM EPS note: the P/E series sums four quarterly diluted EPS figures (12.56 for the current TTM). Summing quarterly EPS does not exactly equal an annual EPS when the share count changes — Dell's count fell 6.8% over five quarters — so the series carries a small upward bias in EPS and therefore a small downward bias in P/E. Disclosed; it does not change a 96th-percentile reading.
Source: reports/scan_v3/_scan.json, 3,980 names with status == "OK".
The override. sectors.py line 51 maps (3570, 3579) -> "TECH"; Dell's SIC is 3571. The
comparator set is therefore built on economics, not SIC:
| Set | Filter | n | Set growth | Set op margin (median) | EV/EBIT p25 / median / p75 |
|---|---|---|---|---|---|
| DELL anchor (used) | growth 10–30%, op margin ≤12%, cap >$5bn | 67 | 10.0–29.7% | 6.4% | 19.9x / 27.4x / 55.5x |
| Cross-check | growth 5–30%, op margin ≤10%, cap >$5bn | 102 | 5.0–29.7% | 5.7% | 18.9x / 25.9x / 47.4x |
| The defect, for contrast | growth 10–30%, sector == TECH, cap >$5bn | 68 | 10.0–27.7% | 19.6% | 19.6x / 30.3x / 52.7x |
The comparison of the last two rows is the quantified defect: the TECH set's median operating margin is 19.6% against the correct set's 6.4% — 3.1x — while the EV/EBIT medians differ by only 10% (30.3x vs 27.4x). The mis-mapping is a margin defect, not a multiple defect.
Market-cap floor of $5bn set explicitly to avoid the logged sub-$100m-shell defect; realised minimum
$5.3bn. The set's growth range brackets the required exit-year growth, which is the condition
valuation.md imposes.
Base exit multiple 19.9x = the anchor set's p25, which independently equals Dell's own three-year
EV/EBIT p75 of 19.5x. Using p25 rather than the set median of 27.4x is the separately argued reason
valuation.md requires for a base below an anchor, and the argument is given in
DELL_Valuation.md §3.
DELL_Trade_Construction.md §7, not
fabricated.