Caterpillar Financial Model
Industrial Equipment Company Financials Example (Free Excel Download)
Caterpillar Inc. is the world's leading manufacturer of construction and mining equipment, off-highway diesel and natural gas engines, industrial gas turbines, and diesel-electric locomotives.
professionals from Deloitte
Used by professionals from
About this model
This model provides a sum-of-the-parts equity valuation and cyclicality analysis for an equity research analyst covering Caterpillar, isolating the core Machinery, Energy & Transportation (ME&T) business cash flows from the highly levered Financial Products division to accurately forecast earnings across global macroeconomic and commodity cycles.
Caterpillar Inc. is the world's leading manufacturer of construction and mining equipment, off-highway diesel and natural gas engines, industrial gas turbines, and diesel-electric locomotives. The company operates a heavy manufacturing business model supported by a massive, independent global dealer network that handles retail sales, parts distribution, and servicing.
Business segments include:
- Construction Industries (approx. 40% of revenue)
- Energy & Transportation (approx. 42% of revenue)
- Resource Industries (approx. 18% of revenue)
- Financial Products (approx. 5% of consolidated revenue, before eliminations)
Key geographies include North America (historically over 50% of sales), EAME (Europe, Africa, Middle East), Asia/Pacific, and Latin America. The business is highly cyclical but has structurally improved its margin profile and resilience by aggressively growing its high-margin services and aftermarket parts business. Recent major events include a corporate headquarters relocation to Irving, Texas, and record operating margins in 2024 (20.2%) followed by a normalisation in 2025 (16.5%) driven by manufacturing costs and rail division restructuring.
The downloadable Caterpillar financial model includes SEC-sourced historical financials, forecast assumptions, core operating schedules, and valuation outputs in an Excel workbook built for review and scenario analysis.
A turnkey financial model
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
Historicals & AssumptionsCaterpillar financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $50.97B | $59.43B | $67.06B | $64.81B | $67.59B |
| Cost of goods sold | $35.51B | $41.35B | $42.77B | $40.20B | $44.75B |
| Operating income | $6.88B | $7.90B | $12.97B | $13.07B | $11.15B |
| Net income | $6.49B | $6.71B | $10.34B | $10.79B | $8.88B |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Caterpillar
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Construction Industries
- Segment name: Construction Industries
- Revenue driver formula: Prior Year Segment Revenue x (1 + Volume Growth % + Price Realisation %)
- Historical growth rate: 2% to 10% CAGR depending on the point in the housing and infrastructure cycle.
- Key growth levers and headwinds: US infrastructure spending (IIJA), global residential and non-residential construction starts, and dealer inventory restocking or destocking.
- Pricing dynamics: Highly dependent on inflation and steel prices; Caterpillar has historically demonstrated strong pricing power to offset raw material inflation.
- Revenue recognition notes: Recognised when control transfers to the independent dealer, not the end retail customer.
- Seasonality: Q2 and Q3 are typically stronger due to the Northern Hemisphere construction season.
Resource Industries
- Segment name: Resource Industries
- Revenue driver formula: Prior Year Segment Revenue x (1 + Volume Growth % + Price Realisation %)
- Historical growth rate: 1% to 5% CAGR, highly volatile based on commodity supercycles.
- Key growth levers and headwinds: Global mining capital expenditures, copper and gold prices, autonomous mining fleet adoption, and heavy construction.
- Pricing dynamics: Contractual and spot; large fleet orders often have negotiated pricing and long-term service attachments.
- Revenue recognition notes: Recognised upon shipment to dealers or direct to large mining accounts.
- Seasonality: Less seasonal than construction, driven more by lumpy fleet replacement schedules.
Energy & Transportation
- Segment name: Energy & Transportation
- Revenue driver formula: Prior Year Segment Revenue x (1 + Volume Growth % + Price Realisation %)
- Historical growth rate: 4% to 8% CAGR.
- Key growth levers and headwinds: Oil and gas capital expenditures (reciprocating engines for well servicing), data centre backup power demand, and marine/rail investments.
- Pricing dynamics: Competitive but supported by strong brand premium and reliability requirements in mission-critical applications like data centres.
- Revenue recognition notes: Standard point-in-time recognition upon transfer of control.
- Seasonality: Relatively smooth, though large turbine or locomotive deliveries can cause quarterly lumpiness.
Financial Products
- Segment name: Financial Products Segment
- Revenue driver formula: Average Earning Assets x Average Financing Rate
- Historical growth rate: 3% to 7% CAGR.
- Key growth levers and headwinds: Interest rate environment, equipment sales volume, and customer credit health.
- Pricing dynamics: Financing rates are tied to global interest rates plus a spread based on customer credit risk.
- Revenue recognition notes: Interest income is recognised over the life of the finance lease or loan using the effective interest method.
- Seasonality: Mirrors the equipment sales seasonality, as financing is typically originated at the point of sale.
Cost Structure
Variable Costs / COGS
- Line-by-line breakdown: Raw materials (primarily steel), component parts, direct labour, manufacturing overhead, freight, and tariffs.
- Gross margin range: 28% to 34% over the last 5 years.
- Key input costs and commodity exposures: Hot-rolled coil steel, precious metals for emissions controls, and global freight rates.
- How COGS scales with revenue: Step-function. The company has significant operating leverage; when factory utilisation is high, gross margins expand rapidly, but unabsorbed overhead hurts margins during cyclical downturns.
Operating Expenses
- R&D: Typically 2.5% to 3.5% of revenue. Expensed as incurred. Covers autonomous technology, electrification, alternative fuels, and engine emissions compliance.
- SG&A: Typically 9% to 11% of revenue. Driven by corporate overhead, dealer support networks, and marketing. Largely headcount-driven and relatively fixed in the short term.
- Depreciation & Amortisation: Approximately 3% to 4% of revenue, heavily weighted towards tangible factory assets.
- Restructuring / one-time charges: Frequent but usually small, though 2025 saw material restructuring costs (approx. $282 million in Q4 2025) related to rail division inventory write-downs.
Margin Profile
- Gross margin: 28% to 34%.
- EBITDA margin: 16% to 23%.
- Operating margin: 13% to 20.2% (peaked in 2024, normalised to 16.5% in 2025).
- Net margin: 10% to 16%.
- Margin trend: Structurally expanded over the last five years due to a deliberate shift towards high-margin services and disciplined pricing, though 2025 saw compression due to higher manufacturing costs and tariffs.
Balance Sheet Structure
- Total assets: Approximately $85 billion to $90 billion.
- Key asset categories: Receivables (trade and finance), Inventory, and Property, Plant & Equipment (PP&E).
- Goodwill & intangibles as % of total assets: Approximately 8% to 10% (historical acquisitions like Bucyrus and Progress Rail).
- Working capital profile:
- Days Sales Outstanding (DSO): 45 to 55 days (excluding Cat Financial).
- Days Inventory Outstanding (DIO): 110 to 130 days (heavy manufacturing requires significant work-in-process and finished goods).
- Days Payable Outstanding (DPO): 60 to 75 days.
- Net working capital as % of revenue: 15% to 20%.
- Working capital funding: Working capital is a significant use of cash during cyclical upswings as inventory builds to meet demand.
- PP&E: Approximately $12 billion to $14 billion net. Consists of global manufacturing facilities, tooling, and testing grounds. Maintenance capex is roughly equal to depreciation.
- Right-of-use assets / operating leases: Approximately $800 million to $1 billion; not a material driver of enterprise value.
Capital Expenditure & Investment
- Capex as % of revenue: 3.0% to 4.0% (approx. $2.0 billion to $2.5 billion annually).
- Maintenance capex vs. growth capex: Roughly 60% maintenance and tooling replacement, 40% growth and efficiency (automation, new product lines).
- Major capex programmes underway or planned: Investments in battery-electric equipment manufacturing, autonomous mining solutions, and alternative fuel engines.
- Capitalised software / development costs: Minimal relative to total assets; most R&D is expensed.
- M&A pattern: Bolt-on acquirer. Historically made transformational deals (Bucyrus in 2011) but recent focus is on smaller technology or specific product line acquisitions (e.g., Weir Oil & Gas).
Debt & Capital Structure
- Total debt: Approximately $38 billion consolidated, but heavily skewed by Financial Products. ME&T debt is typically only $9 billion to $10 billion.
- Debt/EBITDA ratio: Consolidated is misleading. ME&T Debt / ME&T EBITDA is typically maintained below 1.0x to 1.5x to preserve credit ratings.
- Credit rating: A-tier (S&P: A, Moody's: A2).
- Key debt instruments: Medium-term notes for Cat Financial, standard unsecured corporate bonds for ME&T, and commercial paper for working capital.
- Maturity profile: Well-laddered. Cat Financial issues debt continuously to match the duration of its lease and loan portfolio (typically 3 to 5 years).
- Interest rate profile: Cat Financial debt is a mix of fixed and floating, often swapped to match asset profiles. ME&T debt is primarily fixed.
- Share repurchase programme: Highly active. Deployed $7.7 billion in 2024 and part of a $7.9 billion total return in 2025.
- Dividend policy: Dividend Aristocrat. Payout ratio typically targets 30% to 40% of ME&T free cash flow. Yield is usually 1.5% to 2.5%.
Cash Flow Characteristics
- Operating cash flow conversion: Consolidated OCF is typically $10 billion to $12 billion ($12.0 billion in 2024, $11.7 billion in 2025).
- Free cash flow margin: ME&T FCF margin typically runs 10% to 14% of ME&T revenue.
- Major non-cash items: Depreciation and amortisation, stock-based compensation, and provision for credit losses in Cat Financial.
- Working capital cash flow impact: Highly cyclical. Inventory builds consume billions in cash during early recovery phases, while destocking provides a cash buffer during downturns.
- Capex intensity: Moderate (3% to 4% of sales), allowing for massive free cash flow generation.
- Cash tax rate vs. GAAP effective tax rate: Generally aligned around 22% to 24%, though discrete tax items and geographic mix can cause minor deviations.
Sheet Structure
- Assumptions: Hardcoded drivers for macroeconomic indicators, segment volume growth, price realisation, margin targets, and capital allocation policies.
- Segment Build: Revenue and operating profit forecasts broken down strictly by Construction Industries, Resource Industries, Energy & Transportation, and Financial Products.
- Consolidated Income Statement: Aggregation of segment data, including corporate unallocated items, consolidated interest expense, and taxes.
- ME&T Income Statement: Standalone P&L for the Machinery, Energy & Transportation business (excluding Financial Products revenues and interest).
- Financial Products Income Statement: Standalone P&L for Cat Financial, detailing interest income, fee income, interest expense, and provision for credit losses.
- Consolidated Balance Sheet: Standard asset, liability, and equity line items mirroring the 10-K, with clear breakouts for Cat Financial receivables and debt.
- Consolidated Cash Flow: Indirect method starting from consolidated net income, adjusting for D&A, working capital changes, and separating ME&T capex from Financial Products portfolio additions.
- ME&T Free Cash Flow & DCF: Calculation of ME&T Operating Cash Flow less ME&T Capex, driving the unlevered free cash flow for enterprise valuation.
- Debt & Interest Schedule: Separate debt tranches and interest calculations for ME&T and Financial Products, ensuring Cat Financial's interest expense is treated as an operating cost for that segment.
Key Financial Relationships
- `Construction Industries Revenue = Prior Year Construction Industries Revenue * (1 + Construction Volume Growth + Construction Price Realisation)`
- `Resource Industries Revenue = Prior Year Resource Industries Revenue * (1 + Resource Volume Growth + Resource Price Realisation)`
- `Energy & Transportation Revenue = Prior Year E&T Revenue * (1 + E&T Volume Growth + E&T Price Realisation)`
- `Financial Products Revenue = Average Finance Receivables * Average Financing Yield`
- `Segment Operating Profit = Segment Revenue * Segment Operating Margin`
- `Consolidated Sales and Revenues = Construction Industries Revenue + Resource Industries Revenue + Energy & Transportation Revenue + Financial Products Revenue + All Other Segment Revenue - Inter-segment Eliminations`
- `ME&T Operating Profit = Consolidated Operating Profit - Financial Products Operating Profit + Consolidating Adjustments`
- `Financial Products Interest Expense = Average Financial Products Debt * Financial Products Cost of Debt`
- `ME&T Free Cash Flow = ME&T Net Income + ME&T D&A - ME&T Change in Net Working Capital - ME&T Capital Expenditures`
- `Ending Inventory = Prior Year Ending Inventory + (COGS * (DIO / 365)) - Prior Year (COGS * (DIO / 365))`
- `Share Count = Prior Year Share Count - (Share Repurchase Amount / Average Share Price)`
- `Dividends Paid = Share Count * Annual Dividend Per Share`
Cross-Sheet Dependencies
- The Assumptions sheet dictates the volume and pricing inputs on the Segment Build sheet.
- The Segment Build sheet feeds directly into both the Consolidated Income Statement and the ME&T Income Statement.
- The Financial Products Income Statement calculates its own interest expense based on debt balances from the Consolidated Balance Sheet and feeds its net profit back to the Consolidated Income Statement.
- The Consolidated Income Statement generates net income, which anchors the Consolidated Cash Flow sheet.
- The Consolidated Cash Flow sheet calculates working capital changes and capex, which feed the Consolidated Balance Sheet (PP&E, Inventory, Receivables) and the ME&T Free Cash Flow & DCF sheet.
- *Circularity Risk:* Interest expense on ME&T debt depends on the ME&T debt balance, which is driven by the cash sweep from the Consolidated Cash Flow sheet. A toggle for circularity resolution (average vs beginning balance) is required.
Sign Convention
- Income Statement: Revenues are positive. Expenses (COGS, SG&A, R&D, Interest, Taxes) are negative.
- Balance Sheet: Assets are positive. Liabilities and Equity are positive.
- Cash Flow Statement: Cash inflows (net income, D&A, decrease in working capital assets, increase in liabilities, debt issuance) are positive. Cash outflows (capex, dividends, share repurchases, debt repayment, increase in working capital assets) are negative.
- Formulas: Gross Profit = Revenue + COGS (since COGS is negative).
Things Most Likely to Go Wrong
- Valuing the consolidated entity using EV/EBITDA: Treating Cat Financial's massive debt load as standard corporate debt artificially inflates Enterprise Value and ruins multiple-based valuation. The model must value ME&T separately and add the equity value of Cat Financial.
- Misclassifying Cat Financial interest expense: Interest expense for Financial Products is an operating expense (COGS equivalent) for that segment, not a below-the-line corporate financing cost.
- Ignoring dealer inventory dynamics: Caterpillar reports sales to dealers, not retail sales. If dealers destock, Caterpillar's revenue will fall faster than end-user demand. The model must account for volume swings independent of macroeconomic growth.
- Over-extrapolating peak margins: Operating margins hit 20.2% in 2024 but normalised to 16.5% in 2025. Assuming >20% margins in perpetuity ignores the cyclical reality of manufacturing overhead absorption.
- Double-counting inter-segment sales: Energy & Transportation sells engines to Construction and Resource Industries. The model must include the "Inter-segment eliminations" line to prevent overstating consolidated revenue.
- Mishandling restructuring costs: Caterpillar frequently reports "Adjusted Operating Profit" excluding restructuring. The model must forecast GAAP operating profit and explicitly model restructuring as a separate line item to bridge to adjusted metrics.
- Constant currency vs reported revenue: FX swings can impact revenue by 2% to 4% annually. The model should assume constant currency for volume/price drivers but flag FX as a separate historical adjustment.
- Capital expenditure misallocation: Consolidated capex includes equipment leased to others by Cat Financial. ME&T capex must be isolated to calculate true ME&T Free Cash Flow.
Validation Checks
- "Consolidated Operating Margin should be in the 14% to 20% range based on the last 5 years; flag if outside this band."
- "ME&T Debt / ME&T EBITDA should remain below 1.5x per rating agency guidance; flag if leverage exceeds this threshold."
- "Consolidated Capex as a % of revenue should run between 3.0% and 4.5%; flag if outside this range."
- "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period."
- "ME&T Free Cash Flow conversion (ME&T FCF / ME&T Net Income) should be >0.8x; flag if cash conversion deteriorates."
- "Financial Products Debt to Equity ratio should remain around 7.0x to 8.0x, consistent with captive finance company capital standards."
- "Effective tax rate should be 22% to 24%; flag if the model projects a rate outside this historical norm."
- "Dividend payout ratio should remain between 30% and 40% of ME&T Free Cash Flow based on stated capital allocation policy."
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| Construction Industries Volume Growth | 2.0 | % | Normalised mid-cycle growth following 2024/2025 dealer destocking |
| Construction Industries Price Realisation | 1.5 | % | Long-term inflation pass-through capability |
| Resource Industries Volume Growth | 1.5 | % | Steady replacement cycle for aging mining fleets |
| Energy & Transportation Volume Growth | 3.5 | % | Supported by structural data centre power demand and oil/gas capex |
| Financial Products Earning Assets Growth | 3.0 | % | Tracks overall equipment sales growth |
| Consolidated Gross Margin | 31.5 | % | Blended average of recent peak and historical norms |
| SG&A as % of Revenue | 10.0 | % | Historical average, reflecting disciplined cost control |
| R&D as % of Revenue | 3.0 | % | Consistent historical run-rate for technology investment |
| ME&T Operating Margin | 16.5 | % | Aligns with 2025 actual normalised performance |
| Effective Tax Rate | 23.0 | % | Standard corporate rate post-US tax reform adjustments |
| ME&T Capex as % of ME&T Revenue | 3.5 | % | Historical average required to maintain global footprint |
| Days Sales Outstanding (ME&T) | 50 | Days | Based on historical receivables turnover |
| Days Inventory Outstanding | 120 | Days | Reflects heavy manufacturing supply chain requirements |
| Days Payable Outstanding | 65 | Days | Standard supplier payment terms |
| Annual Share Repurchases | 5000 | $ Millions | Conservative baseline compared to $7.7B in 2024 |
| Dividend Growth Rate | 5.0 | % | Consistent with Dividend Aristocrat track record |
| WACC (ME&T) | 8.5 | % | Standard industrial cost of capital |
| Terminal Growth Rate | 2.0 | % | Aligns with long-term global GDP growth |
Data Sources & Benchmarks
- Filings: SEC EDGAR (Form 10-K, 10-Q, 8-K) and Caterpillar Investor Relations website.
- Key peers for benchmarking: Deere & Company (DE), Komatsu Ltd (KMTUY), Cummins Inc. (CMI), Volvo AB (VLVLY).
- Industry data sources: Dodge Construction Network (US construction starts), Baker Hughes Rig Count (oil & gas demand), S&P Global Commodity Insights (mining capex trends).
- Consensus estimates source: Bloomberg, FactSet, or Visible Alpha for segment-level revenue and margin consensus.
- Proprietary data: Rouse Services (used equipment pricing and auction values), which provides leading indicators for new equipment pricing power.
Sources
- Caterpillar Inc. Form 10-K for the fiscal year ended December 31, 2024 (SEC EDGAR).
- Caterpillar Inc. Q4 and Full-Year 2024 Earnings Release (January 30, 2025).
- Caterpillar Inc. Q4 and Full-Year 2025 Earnings Release (January 29, 2026).
- Caterpillar Financial Services Corporation Q4 2024 Earnings Release.
- Caterpillar Investor Relations Presentations and Non-GAAP Reconciliations (2024-2026).
Do more with the Caterpillar model
Frequently asked
What does Caterpillar Inc. manufacture?+
Caterpillar Inc. is the world's leading manufacturer of construction and mining equipment, off-highway diesel and natural gas engines, industrial gas turbines, and diesel-electric locomotives. The company operates a heavy manufacturing business model supported by a massive, independent global dealer network.
What are the primary revenue segments for Caterpillar?+
Caterpillar's main business segments are Construction Industries (approx. 40% of revenue), Energy & Transportation (approx. 42% of revenue), and Resource Industries (approx. 18% of revenue). The company's revenue is also driven by its high-margin services and aftermarket parts business, which has improved its resilience.
What is Caterpillar's typical capital expenditure as a percentage of revenue?+
Caterpillar's capital expenditure typically ranges from 3.0% to 4.0% of revenue, amounting to approximately $2.0 billion to $2.5 billion annually. This capex is roughly 60% for maintenance and tooling replacement, and 40% for growth and efficiency initiatives like automation and new product lines.
How does net working capital impact Caterpillar's cash flow?+
Net working capital, which is typically 15% to 20% of revenue, is a significant use of cash during cyclical upswings. This occurs as inventory builds to meet increased demand, requiring substantial work-in-process and finished goods.
What is the primary purpose of the Caterpillar financial model?+
The financial model provides a sum-of-the-parts equity valuation and cyclicality analysis for equity research analysts covering Caterpillar. It isolates the core Machinery, Energy & Transportation (ME&T) business cash flows from the highly levered Financial Products division to accurately forecast earnings.
Can I download an Excel financial model for Caterpillar (CAT)?+
Yes, a downloadable Excel financial model for Caterpillar (CAT) is available. This general corporate model provides a forecast horizon from FY2026 to FY2030, offering detailed assumptions for revenue growth, margins, and capital expenditures.
Have more financial modelling questions? Contact us
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Other Industrial Equipment Company Financial Models
Browse another company in the same sector.
Ametek
Ametek is a global manufacturer of highly engineered electronic instruments and electromechanical devices, serving niche industrial markets through organic innovation and disciplined acquisitions.
Cummins
Cummins designs, manufactures, distributes, and services a broad portfolio of power solutions, from diesel and natural gas engines to electric and hybrid powertrains, for commercial vehicle and industrial markets.
Deere & Company
Deere & Company is a global leader in the manufacturing of agricultural, construction, and forestry equipment, operating under the iconic John Deere brand.
Dover
Dover Corporation is a diversified global manufacturer delivering innovative equipment, consumable supplies, aftermarket parts, and software solutions.
Emerson Electric
Emerson Electric is a global technology and software company providing advanced automation solutions for process, hybrid, and discrete manufacturing industries, helping customers optimise operations, reduce emissions, and improve safety through proprietary hardware and software.
Fastenal
Fastenal Company is a leading North American wholesale distributor of industrial and construction supplies, operating through a dense network of branches and customer-specific Onsite locations.
Fortive
Fortive is a diversified industrial technology conglomerate that provides essential technologies for connected workflow solutions across industrial and healthcare applications.
W. W. Grainger
W.
Explore more Manufacturing financial model templates.
