Paccar Financial Model
Automotive Company Financials Example (Free Excel Download)
PACCAR Inc is a global leader in the design, manufacture, and customer support of high-quality premium light, medium, and heavy-duty trucks under the Kenworth, Peterbilt, and DAF nameplates.
professionals from Deloitte
Used by professionals from
About this model
This model provides a sum-of-the-parts equity valuation and cyclical sensitivity analysis to determine PACCAR's fair value across various heavy-duty truck cycle scenarios.
PACCAR Inc is a global leader in the design, manufacture, and customer support of high-quality premium light, medium, and heavy-duty trucks under the Kenworth, Peterbilt, and DAF nameplates. The company also designs and manufactures advanced diesel and electric powertrains, provides financial services, and distributes truck parts related to its principal business.
Business segments include:
- Truck (approx. 68-74% of revenue): Manufacturing and distribution of premium commercial vehicles.
- Parts (approx. 20-24% of revenue): Distribution of aftermarket parts for commercial vehicles, providing a high-margin, recurring revenue stream.
- Financial Services (approx. 6-8% of revenue): Captive finance company providing finance and leasing products to dealers and customers.
Key geographies include the United States and Canada (historically the largest market), Europe (primarily through the DAF brand), and the Rest of the World (including Australia and South America). The business model combines asset-heavy manufacturing with a highly profitable, asset-light aftermarket parts distribution network and a captive finance arm. PACCAR holds a premium competitive position, consistently capturing around 30% of the Class 8 retail sales market in the US and Canada, and approximately 13-15% of the European 16+ tonne market. Recent major events include the navigation of Section 232 truck tariffs, the transition towards EPA 2027 emission rules, and a $264.5 million after-tax non-recurring charge in Q1 2025 related to civil litigation in Europe.
The downloadable Paccar 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 & AssumptionsPaccar financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $23.52B | $28.82B | $35.13B | $33.66B | $28.44B |
| Total Income Before Income Taxes | $2.38B | $3.85B | $5.72B | $5.40B | $3.02B |
| Income taxes | $526.5M | $837.1M | $1.12B | $1.24B | $647.7M |
| Net income | $1.87B | $3.01B | $4.60B | $4.16B | $2.38B |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Paccar
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Truck Segment
- Segment name: Truck
- Revenue driver formula: Global Truck Deliveries (Units) x Average Selling Price (ASP) per Truck.
- Historical growth rate: Highly cyclical, ranging from -15% to +25% annually depending on the macroeconomic freight cycle.
- Key growth levers and headwinds: Freight demand, carrier profitability, replacement cycles, emission regulation pre-buys, and adoption of zero-emission vehicles.
- Pricing dynamics: Premium pricing model; highly dependent on raw material surcharges and inflation pass-through.
- Revenue recognition notes: Recognised when control of the truck transfers to the independent dealer or customer.
- Seasonality: Q4 is typically the strongest quarter for deliveries, while Q3 often sees slight dips due to European summer factory shutdowns.
Parts Segment
- Segment name: Parts
- Revenue driver formula: Active Installed Base of Trucks x Parts Revenue per Truck.
- Historical growth rate: 3-8% CAGR; much less cyclical than the Truck segment.
- Key growth levers and headwinds: Fleet utilisation (miles driven), average age of the truck fleet, and expansion of proprietary TRP stores and distribution centres.
- Pricing dynamics: High pricing power due to the proprietary nature of many components and the critical cost of downtime for fleet operators.
- Revenue recognition notes: Recognised upon shipment or delivery to the dealer.
- Seasonality: Relatively stable throughout the year, with slight upticks in spring and autumn as fleets prepare for extreme weather.
Financial Services Segment
- Segment name: Financial Services
- Revenue driver formula: Average Earning Assets x Portfolio Yield.
- Historical growth rate: 4-10% CAGR, tracking the growth of PACCAR truck sales and dealer inventory levels.
- Key growth levers and headwinds: Interest rate environments, truck sales volumes, and used truck valuations (which impact lease residuals).
- Pricing dynamics: Interest rates charged to customers are typically benchmark rates plus a spread based on credit risk.
- Revenue recognition notes: Interest income is recognised over the life of the finance receivables using the effective interest method.
- Seasonality: Mirrors the Truck segment's delivery schedule, as financing is tied to new equipment purchases.
Cost Structure
Variable Costs / COGS
- Line-by-line breakdown: Direct materials (steel, aluminium, precious metals, purchased components), direct manufacturing labour, and factory overhead.
- Gross margin range: 11% to 15% on a consolidated basis, heavily influenced by the mix of Parts versus Truck sales.
- Key input costs and commodity exposures: Steel, aluminium, rubber, and semiconductor components.
- How COGS scales with revenue: Step-function scaling. Manufacturing overhead requires high capacity utilisation to achieve optimal margins, creating significant operating leverage during cyclical upswings.
Operating Expenses
- R&D: Typically $400 million to $500 million annually (approx. 1.5% of revenue), expensed as incurred. It covers next-generation diesel engines, battery-electric trucks, and autonomous driving technology.
- SG&A: Typically 1.5% to 2.5% of revenue. PACCAR runs a very lean corporate structure. Costs are primarily headcount-driven and related to sales, marketing, and corporate administration.
- Depreciation & Amortisation: Embedded primarily in COGS for manufacturing equipment and SG&A for corporate assets.
- Restructuring / one-time charges: Infrequent, though the company recorded a $350 million pre-tax ($264.5 million after-tax) charge in 2025 related to European civil litigation.
Margin Profile
- Gross margin: 11-15% (consolidated).
- Operating margin: 10-14%. The Parts segment operates at a significantly higher margin (often 20-25% pre-tax) compared to the Truck segment (typically 8-11% pre-tax).
- Net margin: 8-12%.
- Margin trend: Structurally expanding over the last decade due to the growing revenue contribution of the high-margin Parts segment and premium pricing discipline.
Balance Sheet Structure
- Total assets: Approximately $44 billion.
- Key asset categories: Financial Services Assets (approx. $22.8 billion) dominate the balance sheet, consisting of retail loans, wholesale financing to dealers, and equipment on operating leases. Manufacturing assets include inventory and PP&E.
- Goodwill & intangibles: Minimal. PACCAR relies on organic growth rather than transformational M&A.
- Working capital profile:
- Days Sales Outstanding (DSO): 25-35 days for manufacturing operations.
- Days Inventory Outstanding (DIO): 40-50 days.
- Days Payable Outstanding (DPO): 45-55 days.
- Net working capital: Typically positive but tightly managed. The company does not rely on negative working capital to fund growth.
- PP&E: Approximately $4.5 billion, consisting of highly automated truck assembly plants and parts distribution centres.
- Right-of-use assets: Material but not dominant, primarily related to leased distribution and office space.
Capital Expenditure & Investment
- Capex as % of revenue: 2.0% to 2.5% (typically $700 million to $800 million annually).
- Maintenance capex vs. growth capex: Approximately 40% maintenance and 60% growth (tooling for new truck models, factory expansions, and new parts distribution centres).
- Major capex programmes underway: Expansion of the Kenworth Chillicothe plant, PACCAR Mexico facilities, and the DAF assembly plant in Eindhoven.
- Capitalised software: Minimal compared to physical plant investments.
- M&A pattern: Strictly organic grower. The company rarely engages in acquisitions, preferring joint ventures (such as the Amplify Cell Technologies battery JV).
Debt & Capital Structure
- Total debt: Approximately $15.9 billion, almost entirely housed within the Financial Services segment. Manufacturing operations carry virtually zero debt.
- Debt/EBITDA ratio: Not a relevant metric on a consolidated basis due to the captive finance arm. Manufacturing operations are net cash positive.
- Credit rating: A+/A1 (highly rated for an industrial manufacturer).
- Key debt instruments: Medium-term notes and commercial paper used to fund the Financial Services portfolio.
- Interest rate profile: A mix of fixed and floating, closely matched to the duration and rate profile of the underlying truck loans and leases to manage interest rate risk.
- Share repurchase programme: Opportunistic but secondary to dividends.
- Dividend policy: PACCAR pays a regular quarterly dividend and typically declares a substantial extra cash dividend at year-end. Total payout often approximates 50% of annual net income.
Cash Flow Characteristics
- Operating cash flow conversion: Very strong, typically 1.2x to 1.5x net income (excluding the Financial Services portfolio growth, which consumes cash but is backed by matched debt). Consolidated OCF was $4.42 billion in 2025.
- Free cash flow margin: 8% to 12% of manufacturing revenue.
- Major non-cash items: Depreciation of operating lease equipment in the Financial Services segment and standard PP&E depreciation.
- Working capital cash flow impact: Inventory builds during cyclical upswings consume cash, while inventory liquidations during downturns provide a counter-cyclical cash buffer.
- Capex intensity: Low to moderate (2-3% of revenue), allowing for massive free cash flow generation.
- Cash tax rate: Generally tracks the GAAP effective tax rate of 21-23%.
Sheet Structure
- Assumptions: Hardcoded drivers for macroeconomic indicators, segment growth, margins, capex, and tax rates.
- Truck Segment: Forecasts global deliveries, ASP, Truck revenues, and Truck pre-tax income.
- Parts Segment: Forecasts installed base growth, parts revenue per truck, Parts revenues, and Parts pre-tax income.
- Financial Services Segment: Forecasts average earning assets, portfolio yield, interest expense on financial services debt, and Financial Services pre-tax income.
- Consolidated Income Statement: Aggregates segment revenues and pre-tax incomes, applies corporate overhead and consolidated tax to calculate Net Income and EPS.
- Consolidated Balance Sheet: Separates manufacturing assets/liabilities from Financial Services assets/liabilities to accurately reflect the capital structure.
- Consolidated Cash Flow Statement: Bridges Net Income to OCF, CFI, and CFF, explicitly breaking out the issuance and repayment of Financial Services debt.
- Debt & Interest Schedule: Tracks the Financial Services debt roll-forward, medium-term note issuances, and calculates matched interest expense.
- DCF Valuation: Values the manufacturing business (Truck + Parts) using Unlevered Free Cash Flow, and adds the book value of the Financial Services equity to arrive at a Sum-of-the-Parts target price.
Key Financial Relationships
- `Truck Revenue = Global Truck Deliveries x Average Selling Price per Truck`
- `Parts Revenue = Prior Year Parts Revenue x (1 + Parts Revenue Growth Rate)`
- `Financial Services Revenue = Average Earning Assets x Portfolio Yield`
- `Consolidated Revenue = Truck Revenue + Parts Revenue + Financial Services Revenue + Other Revenue`
- `Truck Pre-Tax Income = Truck Revenue x Truck Pre-Tax Margin`
- `Parts Pre-Tax Income = Parts Revenue x Parts Pre-Tax Margin`
- `Financial Services Interest Expense = Average Financial Services Debt x Cost of Debt`
- `Financial Services Pre-Tax Income = Financial Services Revenue - Financial Services Interest Expense - Provision for Losses - FS SG&A`
- `Consolidated Pre-Tax Income = Truck Pre-Tax Income + Parts Pre-Tax Income + Financial Services Pre-Tax Income + Investment Income`
- `Net Income = Consolidated Pre-Tax Income x (1 - Effective Tax Rate)`
- `Financial Services Debt = Financial Services Assets x Target Leverage Ratio (approx. 70-75%)`
- `Regular Dividends Paid = Shares Outstanding x Regular Dividend per Share`
- `Extra Dividends Paid = (Net Income x Target Total Payout Ratio) - Regular Dividends Paid`
Cross-Sheet Dependencies
- The Assumptions sheet dictates the volume and pricing inputs for the Truck Segment, Parts Segment, and Financial Services Segment sheets.
- The three segment sheets feed their respective revenue and pre-tax income lines into the Consolidated Income Statement.
- The Financial Services Segment calculates required asset growth, which feeds the Consolidated Balance Sheet (Financial Services Assets).
- The Consolidated Balance Sheet calculates the required Financial Services Debt to fund those assets, which feeds the Debt & Interest Schedule.
- The Debt & Interest Schedule calculates interest expense, which loops back to the Financial Services Segment to determine pre-tax income. (Note: To avoid circularity, interest expense should be calculated on the beginning balance of debt or a non-circular average).
- The Consolidated Cash Flow Statement pulls Net Income from the Consolidated Income Statement and working capital changes from the Consolidated Balance Sheet.
Sign Convention
- Revenues and Income: Entered and displayed as positive numbers.
- Expenses (COGS, SG&A, R&D, Interest, Taxes): Entered as positive numbers and subtracted in formulas (e.g., `Gross Profit = Revenue - COGS`).
- Assets: Positive numbers.
- Liabilities and Equity: Positive numbers.
- Cash Flow: Inflows are positive, outflows (capex, dividends, debt repayment) are negative.
Things Most Likely to Go Wrong
- Consolidating Manufacturing and Financial Services Debt: PACCAR's manufacturing operations are essentially debt-free. Applying a consolidated Debt/EBITDA multiple or WACC will severely distort the valuation. The model must use a Sum-of-the-Parts approach.
- Underestimating Parts Margin Impact: The Parts segment generates only 20-24% of revenue but often accounts for 40-50% of consolidated pre-tax income. Failing to model the segment mix accurately will break the consolidated margin forecast.
- Misjudging Truck Cyclicality: Extrapolating peak truck delivery volumes indefinitely will result in massive overvaluation. The model must allow for cyclical downturns in the Truck segment assumptions.
- Including the 2025 EU Litigation Charge in Run-Rate: The $264.5 million after-tax charge in Q1 2025 is non-recurring and must be excluded from forward-looking margin and EPS calculations.
- Mismatched Financial Services Funding: Financial Services assets must be funded by a proportional increase in Financial Services debt. If assets grow without debt growing, the model will incorrectly drain manufacturing cash.
- Ignoring the Extra Dividend: PACCAR pays a modest regular dividend but a massive special dividend at year-end. Modelling only the regular dividend will result in an artificially bloated cash balance.
- Overcomplicating R&D Capitalisation: Unlike software companies, PACCAR expenses almost all R&D as incurred. Do not build complex capitalisation and amortisation waterfalls for R&D.
- Currency Translation Volatility: DAF revenues are in Euros. The model should ideally forecast in constant currency or flag that a strong USD will artificially depress consolidated revenue growth.
Validation Checks
- Parts Revenue Contribution: Parts revenue should remain between 20% and 25% of consolidated revenue. Flag if it falls outside this band.
- Financial Services Leverage: Financial Services Debt divided by Financial Services Assets should remain between 70% and 75%.
- Consolidated Gross Margin: Should remain within the historical band of 11% to 15%.
- Dividend Payout Ratio: Total dividends paid (regular + extra) should approximate 45% to 55% of Net Income.
- Manufacturing Net Cash: Cash and Marketable Securities should exceed Manufacturing Debt (which is typically zero) in all forecast periods.
- Capex to Revenue: Capital expenditures should track between 2.0% and 2.5% of consolidated revenue.
- Balance Sheet Check: Total Assets must exactly equal Total Liabilities plus Stockholders' Equity in every period.
- Effective Tax Rate: Should remain between 21% and 23% based on the blend of US and European statutory rates.
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| Global Truck Deliveries | 144,200 | Units | Based on 2025 actual deliveries |
| Truck Delivery Growth Rate | -5.0 | % | Reflects normalisation following peak cycle years |
| Average Selling Price (ASP) Growth | 2.0 | % | Modest pricing power to offset inflation |
| Parts Revenue Growth | 3.0 | % | Midpoint of management guidance (2-4%) for 2025/2026 |
| Financial Services Asset Growth | 4.0 | % | Tracks historical portfolio expansion |
| Truck Pre-Tax Margin | 9.5 | % | Normalised margin excluding peak cycle leverage |
| Parts Pre-Tax Margin | 24.0 | % | Based on historical highly profitable aftermarket performance |
| Financial Services Pre-Tax Margin | 22.0 | % | Based on 2025 actuals ($485M income on $2.21B revenue) |
| R&D Expense | 480 | $ Millions | Midpoint of $460M-$500M management guidance |
| Capital Expenditures | 750 | $ Millions | Midpoint of $700M-$800M management guidance |
| Effective Tax Rate | 22.0 | % | Historical average GAAP tax rate |
| Target Dividend Payout Ratio | 50.0 | % | Historical average including the year-end extra dividend |
| Financial Services Debt / Assets | 72.0 | % | Historical funding ratio for the captive finance portfolio |
| Diluted Shares Outstanding | 526.8 | Millions | Based on 2025 actuals |
| Manufacturing WACC | 9.5 | % | Appropriate discount rate for cyclical heavy manufacturing |
| Terminal Growth Rate | 2.0 | % | Long-term GDP growth proxy |
Data Sources & Benchmarks
- SEC Filings: PACCAR Investor Relations website (investors.paccar.com) and SEC EDGAR for 10-K, 10-Q, and 8-K filings.
- Key Peers for Benchmarking: Volvo AB (VOLV-B.ST), Traton SE (8TRA.DE), Cummins Inc (CMI), and Daimler Truck Holding AG (DTG.DE).
- Industry Data Sources: ACT Research and FTR Transportation Intelligence for North American Class 8 truck orders and build rates; ACEA for European commercial vehicle registrations.
- Consensus Estimates: Bloomberg or FactSet for forward-looking delivery and margin consensus.
Sources
Do more with the Paccar model
Frequently asked
What does PACCAR do?+
PACCAR Inc is a global leader in the design, manufacture, and customer support of high-quality premium light, medium, and heavy-duty trucks under the Kenworth, Peterbilt, and DAF nameplates. The company also designs and manufactures advanced diesel and electric powertrains, provides financial services, and distributes truck parts.
What are PACCAR's main revenue streams?+
PACCAR's primary revenue streams come from its Truck segment, which involves manufacturing and distributing commercial vehicles. Significant contributions also come from its high-margin Parts segment, providing aftermarket components, and its Financial Services arm, offering financing and leasing products.
What is PACCAR's typical capital expenditure as a percentage of revenue?+
PACCAR typically allocates 2.0% to 2.5% of its revenue towards capital expenditure, amounting to approximately $700 million to $800 million annually. This investment is split, with about 40% for maintenance and 60% for growth initiatives like new truck model tooling and factory expansions.
What is the purpose of the PACCAR financial model?+
The PACCAR financial model aims to provide a sum-of-the-parts equity valuation for the company. It also includes a cyclical sensitivity analysis to determine PACCAR's fair value across various heavy-duty truck cycle scenarios.
Can I download an Excel financial model for PACCAR?+
Yes, an Excel financial model for PACCAR is available for download. This model provides a comprehensive analysis, including a sum-of-the-parts equity valuation and cyclical sensitivity analysis, with a forecast horizon from FY2026 to FY2030.
How does PACCAR manage its working capital?+
PACCAR maintains a tightly managed, typically positive net working capital profile, with Days Sales Outstanding between 25-35 days and Days Inventory Outstanding at 40-50 days. The company does not rely on negative working capital to fund its growth.
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 Automotive Company Financial Models
Browse another company in the same sector.
Aptiv
Aptiv PLC is a global technology company that designs and manufactures vehicle components, focusing on active safety, autonomous driving technologies, and smart vehicle connectivity.
AutoZone
AutoZone is the leading retailer and distributor of automotive replacement parts and accessories in the Americas.
Ford Motor
Ford Motor Company designs, manufactures, markets, and services a full line of connected, increasingly electrified passenger and commercial vehicles.
General Motors
General Motors Company is a global automotive manufacturer that designs, builds, and sells trucks, crossovers, cars, and automobile parts.
Genuine Parts
Genuine Parts Company (GPC) is a leading global distributor of automotive and industrial replacement parts.
O’Reilly Automotive
O'Reilly Automotive is a leading specialty retailer of automotive aftermarket parts, tools, supplies, equipment, and accessories in North America.
Tesla
Tesla designs, develops, manufactures, and sells fully electric vehicles, energy generation systems, and energy storage products, and offers software services including Full Self-Driving alongside a global Supercharger network.
Explore more Manufacturing financial model templates.
