Parker Hannifin Financial Model
Industrial Equipment Company Financials Example (Free Excel Download)
Parker Hannifin is a global leader in motion and control technologies, providing precision-engineered solutions for a wide variety of mobile, industrial, and aerospace markets.
professionals from Deloitte
Used by professionals from
About this model
This model provides a comprehensive equity valuation and scenario planning tool for Parker Hannifin, enabling an analyst to forecast the earnings accretion and margin expansion driven by "The Win Strategy" and the ongoing mix shift towards the high-growth, high-margin Aerospace Systems aftermarket.
Parker Hannifin is a global leader in motion and control technologies, providing precision-engineered solutions for a wide variety of mobile, industrial, and aerospace markets. The company operates through two primary reporting segments: the Diversified Industrial Segment (approximately 69% of net sales, split geographically into North America and International) and the Aerospace Systems Segment (approximately 31% of net sales). The business model relies on highly diversified, asset-light manufacturing with a massive installed base that generates highly profitable, recurring aftermarket revenue. Parker Hannifin holds the number one market share position in the fragmented motion and control industry and competes with diversified industrials like Eaton, Honeywell, and Illinois Tool Works. Recent major events include the transformational £6.3 billion acquisition of Meggitt in 2022, which doubled the size of its aerospace business, the divestiture of non-core filtration businesses in fiscal 2025, and the announced $1.0 billion acquisition of Curtis Instruments to expand its electrification portfolio.
The downloadable Parker Hannifin 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 & AssumptionsParker Hannifin financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2022 | FY2023 | FY2024 | FY2025 | FY2026 |
|---|---|---|---|---|---|
| Revenue | $15.86B | $19.07B | $19.93B | $19.85B | $21.50B |
| Gross profit | $5.31B | $6.43B | $7.13B | $7.32B | $8.10B |
| Operating income | $2.98B | $3.40B | $4.07B | $4.35B | $5.07B |
| Net income | $1.32B | $2.08B | $2.85B | $3.53B | $3.65B |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Parker Hannifin
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Diversified Industrial North America
- Segment name: Diversified Industrial North America
- Revenue driver formula: Base Revenue * (1 + US Industrial Production Index Growth + Pricing Adjustments) + M&A Contribution
- Historical growth rate: Flat to low single digits (organic growth recently negative 1% to negative 5% due to macro destocking).
- Key growth levers and headwinds: Benefiting from reshoring and electrification trends, but faces headwinds from cyclical industrial destocking and heavy machinery slowdowns.
- Pricing dynamics: High pricing power due to the critical nature of components; price increases have historically offset raw material inflation.
- Revenue recognition notes: Recognised at a point in time when control transfers to the customer (typically upon shipment).
- Seasonality: Relatively balanced, though the fiscal second quarter (ending December 31) is historically the weakest due to holiday factory shutdowns.
Diversified Industrial International
- Segment name: Diversified Industrial International
- Revenue driver formula: Base Revenue * (1 + International PMI Growth + Pricing Adjustments) * (1 + FX Impact)
- Historical growth rate: Flat to 2% organic growth.
- Key growth levers and headwinds: European industrial stagnation is a major headwind, partially offset by growth in Asian semiconductor and electronics manufacturing markets.
- Pricing dynamics: Similar to North America, but highly sensitive to local market competition and currency fluctuations.
- Revenue recognition notes: Point in time upon shipment.
- Seasonality: Summer months (fiscal first quarter ending September 30) can be softer in Europe due to traditional holiday schedules.
Aerospace Systems
- Segment name: Aerospace Systems
- Revenue driver formula: (Commercial OEM Build Rates * Content Per Aircraft) + (Global Flight Hours * Aftermarket Capture Rate) + Defense Contract Revenue
- Historical growth rate: 10% to 15% CAGR over the last 3 years, heavily boosted by the Meggitt acquisition and commercial travel recovery.
- Key growth levers and headwinds: Driven by record commercial aircraft backlogs (Boeing/Airbus) and elevated global defense spending. Supply chain constraints in the broader aerospace sector remain the primary headwind.
- Pricing dynamics: OEM contracts are long-term with inflation escalators; aftermarket pricing is highly inelastic and commands premium margins.
- Revenue recognition notes: Often recognised over time using the cost-to-cost method for long-term defense and OEM contracts.
- Seasonality: Generally non-seasonal, driven by production schedules rather than calendar cycles.
Cost Structure
Variable Costs / COGS
- Cost of sales includes raw materials (steel, aluminium, rubber, brass), direct manufacturing labour, and factory overhead.
- Gross margin range: 34.0% to 37.0% over the last 5 years (recently hitting 36.9% in FY2025).
- Key input costs are highly exposed to global commodity prices, though the company actively uses hedging and pricing pass-throughs.
- COGS scales linearly with volume, but gross margins expand during growth phases due to fixed factory overhead absorption (operating leverage).
Operating Expenses
- R&D: Typically 2.0% to 2.5% of revenue. It covers new product development, particularly in electrification and aerospace systems, and is predominantly expensed as incurred.
- SG&A: Typically 15.0% to 16.0% of revenue. This includes a highly decentralised management structure (85 general managers) and global sales forces.
- Depreciation & Amortisation: D&A is significant (around 6.0% to 7.0% of revenue), heavily skewed towards the amortisation of acquired intangible assets from the Meggitt and LORD acquisitions.
- Stock-Based Compensation: Approximately 0.5% to 0.8% of revenue; not a major driver compared to technology firms.
- Restructuring / one-time charges: Frequent due to the "Win Strategy" realignment programmes and M&A integration costs, typically running at $50 million to $150 million annually.
Margin Profile
- Gross margin: 34.0% to 37.0%.
- EBITDA margin: 22.0% to 27.5% (FY2025 reported at 27.3%).
- Operating margin: 18.0% to 23.0% (FY2025 reported at 23.0%, adjusted at 26.1%).
- Net margin: 11.0% to 17.8%.
- Margins are expanding structurally due to the higher-margin Aerospace aftermarket mix and continuous cost containment under the Win Strategy. The company targets a 28.0% adjusted EBITDA margin by FY2029.
Balance Sheet Structure
- Total assets: Approximately $30.6 billion.
- Key asset categories: Intangible assets and goodwill dominate the balance sheet due to a history of large acquisitions.
- Goodwill & intangibles as % of total assets: Approximately 55% to 60%.
- Working capital profile:
- Days Sales Outstanding (DSO): 45 to 50 days.
- Days Inventory Outstanding (DIO): 60 to 65 days.
- Days Payable Outstanding (DPO): 45 to 50 days.
- Net working capital as % of revenue: Approximately 10% to 12%.
- Working capital is positive and represents a use of cash during periods of high organic growth.
- PP&E: Approximately $3.0 billion (10% of assets), reflecting an asset-light assembly and engineering model. Useful lives range from 10 to 40 years for buildings and 3 to 15 years for machinery.
- Right-of-use assets / operating leases: Approximately $500 million to $600 million; material but not a dominant balance sheet item.
Capital Expenditure & Investment
- Capex as % of revenue: 1.5% to 2.0% (historically very stable).
- Maintenance capex vs. growth capex: Approximately 60% maintenance and 40% growth (automation and facility upgrades).
- Major capex programmes: Investments in global facility consolidation and automation robotics to support margin expansion.
- Capitalised software: Minimal relative to total capex.
- M&A pattern: Serial acquirer employing a barbell strategy of transformational deals (Meggitt, LORD) every 3 to 5 years, supplemented by frequent bolt-on acquisitions (Curtis Instruments).
- Typical acquisition multiple paid: 12x to 15x EV/EBITDA pre-synergies.
Debt & Capital Structure
- Total debt: Approximately $9.8 billion (net debt approximately $9.4 billion).
- Debt/EBITDA ratio: Currently 1.6x to 1.8x, well below the management target of less than 2.0x.
- Credit rating: BBB+ (investment grade).
- Key debt instruments: Predominantly fixed-rate senior unsecured notes with staggered maturities, supported by a multi-currency revolving credit facility.
- Maturity profile: Well-laddered, with average maturities exceeding 5 years.
- Interest rate profile: Over 80% fixed rate, with a weighted average cost of debt around 4.0% to 4.5%.
- Covenants: Standard investment-grade interest coverage and leverage covenants; currently operating with massive headroom.
- Share repurchase programme: Highly active, repurchasing $1.6 billion in FY2025 (approximately 3% of market cap).
- Dividend policy: 69 consecutive years of increases. Current annual payout is $7.20 per share, representing a payout ratio of approximately 25% to 30%.
Cash Flow Characteristics
- Operating cash flow conversion: OCF / Net Income typically runs at 1.05x to 1.20x.
- Free cash flow margin: 15.0% to 19.0% of revenue (FY2025 OCF was 19.0% of sales, FCF margin approximately 17.0%).
- Major non-cash items: Amortisation of acquired intangibles is the largest bridge item, adding back hundreds of millions to operating cash flow.
- Working capital cash flow impact: Inventory builds have been a use of cash during supply chain disruptions, but normalisation is currently a source of cash.
- Capex intensity: Very low, allowing for exceptional free cash flow conversion.
- Cash tax rate vs. GAAP effective tax rate: Cash taxes are generally lower than the GAAP effective rate (21% to 23%) due to accelerated depreciation and R&D tax credits.
Sheet Structure
- Assumptions: Hardcoded inputs for macro drivers, segment growth rates, margin targets, tax rates, and capital allocation policies.
- Revenue & Segment Build: Detailed build of Diversified Industrial North America, Diversified Industrial International, and Aerospace Systems, including organic growth, FX, and M&A impacts.
- Income Statement: Consolidated US GAAP income statement, followed by a reconciliation to Adjusted Operating Income and Adjusted Net Income.
- Balance Sheet: Standard US GAAP format mirroring the 10-K, highlighting the massive goodwill and intangible asset balances.
- Cash Flow Statement: Indirect method starting from Net Income, detailing working capital changes, capex, M&A, debt paydown, and shareholder returns.
- Working Capital Schedule: Rollforward of receivables, inventory, and payables based on DSO, DIO, and DPO assumptions.
- Depreciation & Amortisation Schedule: Waterfall of PP&E depreciation and a separate, highly detailed schedule for the amortisation of acquired intangibles.
- Debt Schedule: Tranche-by-tranche build of senior notes, commercial paper, and revolving credit facility, calculating interest expense and tracking maturities.
- Shareholders Equity: Rollforward of retained earnings, accumulated other comprehensive income (AOCI), dividends paid, and share repurchases.
- Valuation (DCF): Unlevered free cash flow calculation, WACC build, terminal value calculation, and implied share price.
Key Financial Relationships
- Diversified Industrial North America Revenue = Prior Year NA Revenue * (1 + NA Organic Growth Rate + NA FX Impact + NA M&A Impact)
- Diversified Industrial International Revenue = Prior Year Int'l Revenue * (1 + Int'l Organic Growth Rate + Int'l FX Impact + Int'l M&A Impact)
- Aerospace Systems Revenue = Prior Year Aerospace Revenue * (1 + Aerospace Organic Growth Rate + Aerospace M&A Impact)
- Total Net Sales = Diversified Industrial North America Revenue + Diversified Industrial International Revenue + Aerospace Systems Revenue
- Segment Operating Income = (NA Revenue * NA Margin) + (Int'l Revenue * Int'l Margin) + (Aerospace Revenue * Aerospace Margin)
- Total Corporate General & Administrative Expenses = Total Net Sales * Corporate G&A %
- Adjusted Segment Operating Income = Segment Operating Income + Business Realignment Charges + Integration Costs
- Adjusted EBITDA = Net Income + Income Taxes + Interest Expense + Total Depreciation and Amortisation + Restructuring Costs
- Interest Expense = Average Total Debt Balance * Weighted Average Interest Rate
- Ending Share Count = Beginning Share Count - (Share Repurchase Amount / Assumed Average Share Price)
- Dividends Paid = Ending Share Count * Annual Dividend Per Share
- Free Cash Flow = Net Cash Provided by Operating Activities - Capital Expenditures
Cross-Sheet Dependencies
- The Assumptions sheet dictates the growth and margin drivers in the Revenue & Segment Build.
- The Revenue & Segment Build feeds the top line and segment operating profit into the Income Statement.
- The Income Statement generates Net Income, which is the starting point for the Cash Flow Statement and feeds Retained Earnings on the Balance Sheet.
- The Working Capital Schedule uses revenue and COGS from the Income Statement to calculate balances, which feed the Balance Sheet and generate cash flow impacts on the Cash Flow Statement.
- The Debt Schedule calculates interest expense for the Income Statement and ending debt balances for the Balance Sheet. A circularity exists here: interest expense lowers net income, which lowers cash flow, which dictates the need for revolver borrowing, which in turn changes interest expense. This requires a circular reference toggle.
- The Depreciation & Amortisation Schedule feeds operating expenses on the Income Statement and non-cash add-backs on the Cash Flow Statement.
Sign Convention
- Revenue, margins, and asset balances are entered and displayed as positive numbers.
- Expenses on the Income Statement (COGS, SG&A, Interest Expense, Taxes) are entered as positive numbers and subtracted in subtotal formulas.
- On the Cash Flow Statement, cash inflows (e.g., Net Income, D&A add-backs, debt issuance) are positive. Cash outflows (e.g., Capital Expenditures, Dividends, Share Repurchases, Debt Repayment) are negative.
- Contra-asset accounts (like Accumulated Depreciation) are displayed as positive numbers but subtracted from gross assets to yield net assets.
Things Most Likely to Go Wrong
- Mixing GAAP and Non-GAAP margins: Parker Hannifin heavily promotes "Adjusted Segment Operating Margin" (which excludes amortisation of acquired intangibles). If the model uses adjusted margins to forecast GAAP operating income, profitability will be massively overstated.
- Ignoring FX translation: The Diversified Industrial International segment is highly sensitive to the EUR/USD exchange rate. A flat organic growth rate can translate to a 3% to 5% reported revenue decline if the dollar strengthens.
- M&A stub periods: The $1.0 billion Curtis Instruments acquisition will close mid-year. The model must account for partial-year revenue and margin dilution in the year of closing.
- Divestiture base effects: The company divested $0.6 billion of non-core filtration businesses in FY2025. Historical revenue bases must be adjusted downwards to accurately calculate forward organic growth.
- Underestimating intangible amortisation: Because of the Meggitt and LORD deals, intangible amortisation is a massive non-cash expense. Failing to model this separately from PP&E depreciation will distort both the income statement and cash flow conversion metrics.
- Pension accounting: The company has legacy defined benefit pension plans. Changes in discount rates can swing Accumulated Other Comprehensive Income (AOCI) on the balance sheet, causing equity to not balance if OCI is ignored.
- Aerospace aftermarket mix: Aerospace margins are highly dependent on the mix between OEM (lower margin) and aftermarket (higher margin). A flat segment margin assumption will fail to capture the margin expansion inherent in an aging global aircraft fleet.
- Share count reduction: The company aggressively buys back stock. Failing to dynamically link the share repurchase assumption to the outstanding share count will understate EPS growth.
Validation Checks
- Total Assets must equal Total Liabilities + Shareholders' Equity in every forecasted period.
- Gross margin should remain within the 35.0% to 38.0% band based on historical performance and pricing power.
- Capex as a percentage of revenue must not exceed 2.5%; flag if it does, as this violates the asset-light business model.
- Free Cash Flow conversion (FCF / Net Income) should consistently remain above 1.0x.
- Net Debt / EBITDA should remain below 2.0x, aligning with management's stated leverage target for maintaining its BBB+ credit rating.
- Adjusted EBITDA margin should trend towards, but not immediately exceed, the management FY2029 target of 28.0%.
- The effective tax rate should remain between 21.0% and 23.0% absent major US statutory tax changes.
- Dividend payout ratio should remain between 20.0% and 30.0% of Net Income.
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| Diversified Ind. NA Organic Growth | 1.0 | % | Reflects mild industrial destocking offset by reshoring trends |
| Diversified Ind. Int'l Organic Growth | 2.0 | % | Modest growth reflecting European macroeconomic sluggishness |
| Aerospace Systems Organic Growth | 10.0 | % | Strong continued demand in commercial aftermarket and defense |
| Gross Margin | 36.9 | % | Aligns with FY2025 reported actuals |
| SG&A as % of Revenue | 15.5 | % | Historical average, reflecting disciplined cost control |
| R&D as % of Revenue | 2.2 | % | Consistent with historical investment levels |
| Capex as % of Revenue | 1.5 | % | Matches management guidance and historical capital intensity |
| DSO (Days Sales Outstanding) | 48 | Days | Based on FY2025 ending receivables and revenue |
| DIO (Days Inventory Outstanding) | 62 | Days | Based on FY2025 ending inventory and COGS |
| DPO (Days Payable Outstanding) | 46 | Days | Based on FY2025 ending payables and COGS |
| Effective Tax Rate | 22.0 | % | Blended global rate based on recent 10-K disclosures |
| Annual Dividend Per Share | 7.20 | $ | Current declared annualised dividend rate |
| Annual Share Repurchases | 1,500 | $ Millions | Aligns with FY2025 actuals and strong free cash flow generation |
| Weighted Average Interest Rate | 4.2 | % | Blended rate of outstanding senior notes and credit facilities |
| WACC | 9.6 | % | Reflects current interest rate environment and industrial beta |
| Terminal Growth Rate | 2.5 | % | Long-term global GDP and industrial production growth proxy |
Data Sources & Benchmarks
- SEC EDGAR: Parker Hannifin (PH) Form 10-K, 10-Q, and 8-K filings.
- Parker Hannifin Investor Relations: FY2025 Earnings Presentations, 2024 Investor Meeting slides, and historical financial supplements.
- Key Peers for Benchmarking: Eaton Corporation (ETN), Honeywell International (HON), Illinois Tool Works (ITW), and Emerson Electric (EMR).
- Industry Data Sources: US Federal Reserve Industrial Production Index, ISM Manufacturing PMI, and global commercial aircraft delivery schedules (Boeing/Airbus).
- Consensus Estimates: FactSet or Bloomberg for forward EPS, revenue, and margin consensus to validate model outputs.
Sources
Do more with the Parker Hannifin model
Frequently asked
What does Parker Hannifin do?+
Parker Hannifin is a global leader in motion and control technologies, providing precision-engineered solutions for a wide variety of mobile, industrial, and aerospace markets. The company operates through its Diversified Industrial and Aerospace Systems segments, leveraging a massive installed base for highly profitable, recurring aftermarket revenue.
What are the main drivers of Parker Hannifin's revenue?+
Parker Hannifin's revenue is primarily driven by its highly diversified, asset-light manufacturing model and a significant installed base that generates recurring aftermarket revenue. The ongoing mix shift towards the high-growth, high-margin Aerospace Systems aftermarket is also a key driver for sales growth.
What is Parker Hannifin's capital expenditure strategy?+
Parker Hannifin maintains a historically stable capital expenditure as a percentage of revenue, typically between 1.5% to 2.0%. Approximately 60% of this capex is for maintenance, while 40% is allocated to growth initiatives like automation and facility upgrades to support margin expansion.
How does Parker Hannifin plan to expand its margins and earnings?+
Parker Hannifin aims to expand its margins and earnings through "The Win Strategy" and an ongoing mix shift towards the high-growth, high-margin Aerospace Systems aftermarket. Investments in global facility consolidation and automation robotics also support these margin expansion goals.
What is the purpose of the downloadable Excel financial model for Parker Hannifin?+
The downloadable Excel model for Parker Hannifin serves as a comprehensive equity valuation and scenario planning tool. It enables analysts to forecast earnings accretion and margin expansion, particularly those driven by "The Win Strategy" and the aerospace aftermarket shift.
What is Parker Hannifin's approach to acquisitions?+
Parker Hannifin is a serial acquirer, employing a barbell strategy that includes both transformational deals, like the Meggitt acquisition, every 3 to 5 years and frequent bolt-on acquisitions, such as Curtis Instruments. These acquisitions typically occur at 12x to 15x EV/EBITDA pre-synergies.
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.
Caterpillar
Caterpillar 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.
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.
Explore more Manufacturing financial model templates.
