Three-statement Excel model · 22 quarters and 5 fiscal years of history · 10 quarters and 5 fiscal years of projections
About the CAT model
This three-statement Excel model covers Caterpillar Inc. (CAT): its income statement, balance sheet and cash flow statement. It holds 22 quarters and 5 fiscal years of history and 10 quarters and 5 fiscal years of projections.
Projected revenue is built from KPI drivers: End-user applications, not reported segments: Construction Industries, Resource Industries ex-Rail, Power Generation, Oil and Gas and Industrial-and-Rail each on a year-over-year growth rate, plus Financial Products as average finance receivables x revenue yield. The application split is what survives the 1Q26 segment re-cut, across 5 segments.
Beyond the income statement, the workbook has these sections: KPI Drivers, Balance Sheet, Cash Flow Statement, Operating Segments and Pro-Forma / Non-GAAP Reconciliation.
Model thesis: Power Generation compounds to 3.0x 2024 by FY2030E on the data-centre pull; the near-term bar is whether H2 2026 margin holds without the tariff recoveries that flattered H1
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 September 26, 2026.
Income statement preview
Columns 2023–2025 are actual results and 2026E–2028E are our estimates. Figures were recalculated in Excel on September 26, 2026. Dollars in millions, except per share data.
| Income Statement | ||||||
|---|---|---|---|---|---|---|
| Actual | Estimate | |||||
| 2023 | 2024 | 2025 | 2026E | 2027E | 2028E | |
| Sales of Machinery, Power & Energy | $63,869.0 | $61,363.0 | $63,980.0 | $75,053.9 | $81,886.9 | $87,907.0 |
| Financial Products Revenues | 3,191.0 | 3,446.0 | 3,609.0 | 3,864.6 | 4,027.5 | 4,229.2 |
| Total Revenues | $67,060.0 | $64,809.0 | $67,589.0 | $78,918.6 | $85,914.4 | $92,136.2 |
| Less: Cost of Goods Sold | (42,767.0) | (40,199.0) | (44,752.0) | (50,661.3) | (55,262.0) | (58,797.3) |
| Less: Selling, General and Administrative Expenses | (6,371.0) | (6,667.0) | (6,985.0) | (7,930.1) | (8,591.4) | (9,121.5) |
| Less: Research and Development Expenses | (2,108.0) | (2,107.0) | (2,148.0) | (2,381.8) | (2,577.4) | (2,764.1) |
| Less: Goodwill Impairment Charge | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| Less: Interest Expense of Financial Products | (1,030.0) | (1,286.0) | (1,359.0) | (1,442.2) | (1,498.2) | (1,556.3) |
| Less: Other Operating (Income) Expenses | (1,818.0) | (1,478.0) | (1,194.0) | (1,616.2) | (1,718.3) | (1,842.7) |
| Total Operating Expenses | ($54,094.0) | ($51,737.0) | ($56,438.0) | ($64,031.6) | ($69,647.4) | ($74,081.8) |
| Operating Income | $12,966.0 | $13,072.0 | $11,151.0 | $14,887.0 | $16,267.1 | $18,054.4 |
| Other Income (Expense) | 595.0 | 813.0 | 892.0 | 1,308.0 | 1,150.0 | 1,150.0 |
| Less: Interest Expense excluding Financial Products | (511.0) | (512.0) | (502.0) | (540.0) | (550.0) | (558.0) |
| Consolidated Profit Before Taxes | $13,050.0 | $13,373.0 | $11,541.0 | $15,655.0 | $16,867.1 | $18,646.4 |
| Less: Provision (Benefit) for Income Taxes | ($2,781.0) | ($2,629.0) | ($2,768.0) | ($3,578.2) | ($3,963.8) | ($4,381.9) |
| Profit of Consolidated Companies | $10,269.0 | $10,744.0 | $8,773.0 | $12,076.8 | $12,903.3 | $14,264.5 |
| Equity in Profit (Loss) of Unconsolidated Affiliated Companies | 63.0 | 44.0 | 109.0 | 157.0 | 120.0 | 120.0 |
| Consolidated Net Income | $10,332.0 | $10,788.0 | $8,882.0 | $12,233.8 | $13,023.3 | $14,384.5 |
| Less: Profit (Loss) Attributable to Noncontrolling Interests | 3.0 | 4.0 | 2.0 | 1.0 | 0.0 | 0.0 |
| Net Income Attributable to Common Shareholders | $10,335.0 | $10,792.0 | $8,884.0 | $12,234.8 | $13,023.3 | $14,384.5 |
| Ratios & Assumptions | ||||||
| YoY Total Revenues Growth | 12.8% | (3.4%) | 4.3% | 16.8% | 8.9% | 7.2% |
| YoY Machinery, Power & Energy Sales Growth | 12.9% | (3.9%) | 4.3% | 17.3% | 9.1% | 7.4% |
| YoY Financial Products Revenues Growth | 11.8% | 8.0% | 4.7% | 7.1% | 4.2% | 5.0% |
| Operating Margin | 19.3% | 20.2% | 16.5% | 18.9% | 18.9% | 19.6% |
| Incremental Operating Margin | 66.3% | (4.7%) | (69.1%) | 33.0% | 19.7% | 28.7% |
The full workbook adds 22 historical and 10 projected quarters, plus KPI Drivers · Balance Sheet · Cash Flow Statement · Operating Segments · Pro-Forma / Non-GAAP Reconciliation — every subtotal a live formula, every projection traced to a driver.
Caterpillar research
Aardvark Labs Capital Research has published 6 reports on Caterpillar (CAT). The latest is the Q3 2026 Earnings Recap, published October 30, 2026, rated Outperform.
Backlog Reaches $78B, but a Flat Fourth Quarter and a Margin Stuck at the Floor Reset the Valuation: Maintaining Outperform
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.