← All financial models

Caterpillar (CAT) Financial Model

📊 Download Model

Three-statement Excel model · 22 quarters and 5 fiscal years of history · 10 quarters and 5 fiscal years of projections

current ✓ C13 recon ✓ C14 trace ✓ C15 terminals

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.

History
22 quarters and 5 fiscal years
Projections
10 quarters and 5 fiscal years
KPI
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
Segments
5
Units
Dollars in millions, except per share data
Verified
Updated
File
Excel workbook (.xlsx), 205 KB
Access
Free account required: 3 different models a month at no charge, then $9 a month.

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 preview for CAT. Dollars in millions, except per share data. Actual fiscal years followed by our estimates.
Income Statement
ActualEstimate
2023202420252026E2027E2028E
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 Revenues3,191.03,446.03,609.03,864.64,027.54,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 Charge0.00.00.00.00.00.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.0813.0892.01,308.01,150.01,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 Companies63.044.0109.0157.0120.0120.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 Interests3.04.02.01.00.00.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 Growth12.8%(3.4%)4.3%16.8%8.9%7.2%
YoY Machinery, Power & Energy Sales Growth12.9%(3.9%)4.3%17.3%9.1%7.4%
YoY Financial Products Revenues Growth11.8%8.0%4.7%7.1%4.2%5.0%
Operating Margin19.3%20.2%16.5%18.9%18.9%19.6%
Incremental Operating Margin66.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.

Download the full CAT model (xlsx)3 free models a month with an account, then $9 a month

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

All CAT research →

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.