Three-statement Excel model · 13 quarters and 3 fiscal years of history · 11 quarters and 5 fiscal years of projections
About the SNDK model
This three-statement Excel model covers SanDisk Corporation (SNDK): its income statement, balance sheet and cash flow statement. It holds 13 quarters and 3 fiscal years of history and 11 quarters and 5 fiscal years of projections.
Projected revenue is built from KPI drivers: Prior-quarter Datacenter, Edge, and Consumer revenue × independent end-market growth rates, across 3 segments.
Beyond the income statement, the workbook has these sections: Pro-Forma / Non-GAAP Reconciliation, KPI Drivers, Balance Sheet and Cash Flow Statement.
Model thesis: Datacenter demand and NAND pricing lift earnings, with a pricing reset modeled in FY2029.
On November 18, 2026, the model passed checks C13 (every subtotal reconciles to the reported figure at $0), C14 (every projected revenue cell traces to a KPI driver row) and C15 (each driver ends in a rate, a count or a historical anchor, never a typed-in projected dollar level). It was last updated November 14, 2026.
Income statement preview
Columns 2024–2026 are actual results and 2027E–2029E are our estimates. Figures were recalculated in Excel on November 18, 2026. US$ millions and shares in millions, except per share (pre-split).
| Income Statement | ||||||
|---|---|---|---|---|---|---|
| Actual | Estimate | |||||
| 2024 | 2025 | 2026 | 2027E | 2028E | 2029E | |
| Datacenter revenue | 325.0 | 960.0 | 5,153.0 | 23,044.7 | 32,884.9 | 35,464.6 |
| Edge revenue | 4,069.0 | 4,127.0 | 12,160.0 | 24,740.8 | 26,675.3 | 24,195.6 |
| Consumer revenue | 2,269.0 | 2,268.0 | 2,935.0 | 1,706.4 | 1,774.2 | 1,731.9 |
| Revenue, net | $6,663.0 | $7,355.0 | $20,248.0 | $49,492.0 | $61,334.5 | $61,392.0 |
| Revenue, net Reconciliation | 0.000 | 0.000 | 0.000 | |||
| Cost of revenue | (5,591.0) | (5,143.0) | (5,776.0) | (7,884.0) | (11,910.2) | (13,342.5) |
| Gross profit | $1,072.0 | $2,212.0 | $14,472.0 | $41,608.0 | $49,424.3 | $48,049.6 |
| Gross profit Reconciliation | 0.000 | 0.000 | 0.000 | |||
| Research and development | (1,061.0) | (1,132.0) | (1,328.0) | (1,513.0) | (1,624.4) | (1,606.2) |
| Selling, general and administrative | (455.0) | (573.0) | (676.0) | (964.7) | (1,087.8) | (1,093.7) |
| Goodwill impairment | 0.0 | (1,830.0) | 0.0 | 0.0 | 0.0 | 0.0 |
| Loss on debt extinguishment | 0.0 | 0.0 | (46.0) | 0.0 | 0.0 | 0.0 |
| Business separation costs | (64.0) | (67.0) | (25.0) | 0.0 | 0.0 | 0.0 |
| Employee termination and other | 40.0 | (21.0) | 2.0 | 0.0 | 0.0 | 0.0 |
| (Gain) loss on business divestiture | 0.0 | 34.0 | (10.0) | 0.0 | 0.0 | 0.0 |
| Total operating expenses | ($1,540.0) | ($3,589.0) | ($2,083.0) | ($2,477.7) | ($2,712.3) | ($2,699.9) |
| Total operating expenses Reconciliation | 0.000 | 0.000 | 0.000 | |||
| Operating income (loss) | ($468.0) | ($1,377.0) | $12,389.0 | $39,130.3 | $46,712.0 | $45,349.7 |
| Operating income (loss) Reconciliation | 0.000 | 0.000 | 0.000 | |||
| Gain (loss) on equity securities, net | 0.0 | 0.0 | 808.0 | 513.0 | 0.0 | 0.0 |
| Interest income | 12.0 | 22.0 | 70.0 | 144.2 | 226.5 | 329.4 |
| Interest expense | (40.0) | (63.0) | (73.0) | (2.0) | 0.0 | 0.0 |
| Other income (expense), net | (7.0) | (61.0) | (177.0) | (248.8) | (333.2) | (309.0) |
| Total interest and other income (expense), net | ($35.0) | ($102.0) | $628.0 | $406.4 | ($106.7) | $20.4 |
| Total interest and other income (expense), net Reconciliation | 0.000 | 0.000 | 0.000 | |||
| Income (loss) before taxes | ($503.0) | ($1,479.0) | $13,017.0 | $39,536.7 | $46,605.4 | $45,370.0 |
| Income (loss) before taxes Reconciliation | 0.000 | 0.000 | 0.000 | |||
| Income tax expense | (169.0) | (162.0) | (1,584.0) | (5,632.2) | (6,990.8) | (7,032.4) |
| Net income (loss) | ($672.0) | ($1,641.0) | $11,433.0 | $33,904.5 | $39,614.6 | $38,337.7 |
| Net income (loss) Reconciliation | 0.000 | 0.000 | 0.000 | |||
| Basic weighted average shares | 145.000 | 145.000 | 147.000 | 140.746 | 127.869 | 115.014 |
| Diluted weighted average shares | 145.000 | 145.000 | 155.000 | 148.746 | 135.869 | 123.014 |
| Basic EPS | ($4.63) | ($11.32) | $77.78 | $240.89 | $309.81 | $333.33 |
| Basic EPS Reconciliation | (0.004) | 0.003 | (0.004) | |||
| Diluted EPS | ($4.63) | ($11.32) | $73.76 | $227.94 | $291.57 | $311.65 |
| Diluted EPS Reconciliation | (0.004) | 0.003 | 0.001 | |||
| Ratios & Assumptions | ||||||
| Gross Margin | 16.1% | 30.1% | 71.5% | 84.1% | 80.6% | 78.3% |
| Operating Margin | (7.0%) | (18.7%) | 61.2% | 79.1% | 76.2% | 73.9% |
| Net Margin | (10.1%) | (22.3%) | 56.5% | 68.5% | 64.6% | 62.4% |
| Effective Tax Rate | (33.6%) | (11.0%) | 12.2% | 14.2% | 15.0% | 15.5% |
The full workbook adds 13 historical and 11 projected quarters, plus Pro-Forma / Non-GAAP Reconciliation · KPI Drivers · Balance Sheet · Cash Flow Statement — every subtotal a live formula, every projection traced to a driver.
SanDisk research
Aardvark Labs Capital Research has published 5 reports on SanDisk (SNDK). The latest is the Q1 FY27 Earnings Recap, published October 30, 2026, rated Outperform.
Datacenter Carries Another Beat, but the Market Is Trading the Price Curve, Not the Quarter
Methodology
Every projected revenue cell traces to a KPI/driver row (C14). Terminal driver cells are rates, counts, or historical anchors — never typed-in projected dollar levels (C15). Every subtotal-vs-reported reconciliation row ties to $0 (C13). Each model is written per-ticker against its actual schema — no cloning, no level-input shortcuts.