# Parker Hannifin (PH) Financial Model Free Excel 3-statement financial model and company analysis for Parker Hannifin. - Canonical: https://finamodel.com/companies/parker-hannifin - Industry: Industrial Equipment - Downloadable model: Yes - Excel download: https://finamodel.com/company-models/PH.xlsx ## Model Purpose 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. ## Company Overview 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. ## 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 1. **Assumptions**: Hardcoded inputs for macro drivers, segment growth rates, margin targets, tax rates, and capital allocation policies. 2. **Revenue & Segment Build**: Detailed build of Diversified Industrial North America, Diversified Industrial International, and Aerospace Systems, including organic growth, FX, and M&A impacts. 3. **Income Statement**: Consolidated US GAAP income statement, followed by a reconciliation to Adjusted Operating Income and Adjusted Net Income. 4. **Balance Sheet**: Standard US GAAP format mirroring the 10-K, highlighting the massive goodwill and intangible asset balances. 5. **Cash Flow Statement**: Indirect method starting from Net Income, detailing working capital changes, capex, M&A, debt paydown, and shareholder returns. 6. **Working Capital Schedule**: Rollforward of receivables, inventory, and payables based on DSO, DIO, and DPO assumptions. 7. **Depreciation & Amortisation Schedule**: Waterfall of PP&E depreciation and a separate, highly detailed schedule for the amortisation of acquired intangibles. 8. **Debt Schedule**: Tranche-by-tranche build of senior notes, commercial paper, and revolving credit facility, calculating interest expense and tracking maturities. 9. **Shareholders Equity**: Rollforward of retained earnings, accumulated other comprehensive income (AOCI), dividends paid, and share repurchases. 10. **Valuation (DCF)**: Unlevered free cash flow calculation, WACC build, terminal value calculation, and implied share price. ## Key Financial Relationships 1. Diversified Industrial North America Revenue = Prior Year NA Revenue * (1 + NA Organic Growth Rate + NA FX Impact + NA M&A Impact) 2. Diversified Industrial International Revenue = Prior Year Int'l Revenue * (1 + Int'l Organic Growth Rate + Int'l FX Impact + Int'l M&A Impact) 3. Aerospace Systems Revenue = Prior Year Aerospace Revenue * (1 + Aerospace Organic Growth Rate + Aerospace M&A Impact) 4. Total Net Sales = Diversified Industrial North America Revenue + Diversified Industrial International Revenue + Aerospace Systems Revenue 5. Segment Operating Income = (NA Revenue * NA Margin) + (Int'l Revenue * Int'l Margin) + (Aerospace Revenue * Aerospace Margin) 6. Total Corporate General & Administrative Expenses = Total Net Sales * Corporate G&A % 7. Adjusted Segment Operating Income = Segment Operating Income + Business Realignment Charges + Integration Costs 8. Adjusted EBITDA = Net Income + Income Taxes + Interest Expense + Total Depreciation and Amortisation + Restructuring Costs 9. Interest Expense = Average Total Debt Balance * Weighted Average Interest Rate 10. Ending Share Count = Beginning Share Count - (Share Repurchase Amount / Assumed Average Share Price) 11. Dividends Paid = Ending Share Count * Annual Dividend Per Share 12. 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 - Parker Hannifin Corporation SEC Form 10-K for the fiscal year ended June 30, 2025. - Parker Hannifin Q4 FY2025 Earnings Release and Financial Tables. - Parker Hannifin 2024 Investor Meeting Presentation and FY2029 Financial Targets. - Parker Hannifin Q2 FY2026 Earnings Call Transcripts and Presentations. --- ## Frequently asked questions ### 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. [Interactive forecast calculator](https://finamodel.com/companies/parker-hannifin/forecast)