Three-statement Excel model · 23 quarters and 5 fiscal years of history · 9 quarters and 5 fiscal years of projections
About the AMAT model
This three-statement Excel model covers Applied Materials, Inc. (AMAT): its income statement, balance sheet and cash flow statement. It holds 23 quarters and 5 fiscal years of history and 9 quarters and 5 fiscal years of projections.
Projected revenue is built from KPI drivers: Semiconductor Systems revenue by end market (foundry-logic / DRAM / flash), each on its own sequential growth rate, plus services off the installed base and Corporate and Other; the disclosed market mix is an output of the three, not a driver, across 3 segments.
Beyond the income statement, the workbook has these sections: KPI Drivers, Balance Sheet, Cash Flow Statement and Pro-Forma / Non-GAAP Reconciliation.
Model thesis: DRAM went 17% of systems revenue to 26% on HBM while flash sits at 7% against a 21-26% history: the recovery candidate is the market nobody is paying for
On October 19, 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 October 19, 2026.
Income statement preview
Columns FY23–FY25 are actual results and FY26E–FY28E are our estimates. Figures were recalculated in Excel on October 18, 2026. Dollars in millions, except per share data.
| Income Statement | ||||||
|---|---|---|---|---|---|---|
| Actual | Estimate | |||||
| FY23 | FY24 | FY25 | FY26E | FY27E | FY28E | |
| Semiconductor Systems | $19,698.0 | $19,911.0 | $20,798.0 | $26,258.5 | $35,550.9 | $38,175.3 |
| Applied Global Services | 5,732.0 | 6,225.0 | 6,385.0 | 6,839.4 | 7,863.2 | 8,406.6 |
| Corporate and Other | 1,087.0 | 1,040.0 | 1,185.0 | 1,185.9 | 1,254.2 | 1,305.1 |
| Total Revenue | $26,517.0 | $27,176.0 | $28,368.0 | $34,283.9 | $44,668.3 | $47,886.9 |
| Less: Cost of Products Sold | ($14,133.0) | ($14,279.0) | ($14,560.0) | ($17,141.2) | ($21,919.5) | ($23,344.5) |
| Gross Profit | $12,384.0 | $12,897.0 | $13,808.0 | $17,142.7 | $22,748.8 | $24,542.4 |
| Less: Research, Development and Engineering | (3,102.0) | (3,233.0) | (3,570.0) | (4,202.6) | (5,238.2) | (5,746.4) |
| Less: Marketing and Selling | (776.0) | (836.0) | (858.0) | (955.0) | (1,116.7) | (1,245.1) |
| Less: General and Administrative | (852.0) | (961.0) | (910.0) | (689.2) | (804.0) | (909.9) |
| Less: Restructuring and Severance Charges | 0.0 | 0.0 | (181.0) | (12.0) | 0.0 | 0.0 |
| Less: Deal Termination Fee | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| Less: Legal Settlement | 0.0 | 0.0 | 0.0 | (253.0) | 0.0 | 0.0 |
| Total Operating Expenses | ($4,730.0) | ($5,030.0) | ($5,519.0) | ($6,111.9) | ($7,158.9) | ($7,901.3) |
| Income from Operations | $7,654.0 | $7,867.0 | $8,289.0 | $11,030.8 | $15,589.9 | $16,641.1 |
| Less: Interest Expense | ($238.0) | ($247.0) | ($269.0) | ($276.0) | ($280.0) | ($280.0) |
| Interest and Other Income (Expense), net | 300.0 | 532.0 | 1,251.0 | 1,367.0 | 520.0 | 520.0 |
| Income Before Income Taxes | $7,716.0 | $8,152.0 | $9,271.0 | $12,121.8 | $15,829.9 | $16,881.1 |
| Less: Provision for Income Taxes | ($860.0) | ($975.0) | ($2,273.0) | ($1,566.0) | ($2,057.9) | ($2,194.5) |
| Net Income | $6,856.0 | $7,177.0 | $6,998.0 | $10,555.7 | $13,772.0 | $14,686.6 |
| Ratios & Assumptions | ||||||
| Gross Margin | 46.7% | 47.5% | 48.7% | 50.0% | 50.9% | 51.3% |
| Incremental Gross Margin | 53.4% | 77.8% | 76.4% | 56.4% | 54.0% | 55.7% |
| Operating Margin | 28.9% | 28.9% | 29.2% | 32.2% | 34.9% | 34.8% |
| Net Margin | 25.9% | 26.4% | 24.7% | 30.8% | 30.8% | 30.7% |
The full workbook adds 23 historical and 9 projected quarters, plus KPI Drivers · Balance Sheet · Cash Flow Statement · Pro-Forma / Non-GAAP Reconciliation — every subtotal a live formula, every projection traced to a driver.
Applied Materials research
Aardvark Labs Capital Research has published 6 reports on Applied Materials (AMAT). The latest is the Q4 FY26 Earnings Recap, published November 14, 2026, rated Outperform.
The Business Kept Beating and the Stock Kept Falling: Upgrading to Outperform at 19.5x FY27 Earnings
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.