Genuine Parts Financial Model
Automotive Company Financials Example (Free Excel Download)
Genuine Parts Company (GPC) is a leading global distributor of automotive and industrial replacement parts.
professionals from Deloitte
Used by professionals from
About this model
This model evaluates the sum-of-the-parts equity valuation and standalone capital structure viability for Genuine Parts Company ahead of its planned 2027 tax-free spin-off of the Industrial Parts Group.
Genuine Parts Company (GPC) is a leading global distributor of automotive and industrial replacement parts. The company operates through three primary business segments: North America Automotive (approximately 39% of total net sales), Industrial Parts Group (approximately 37%), and International Automotive (approximately 24%). Geographically, the business is concentrated in North America (74%), Europe (16%), and Australasia (10%). GPC operates an asset-light distribution business model, relying on a massive hub-and-spoke supply chain, extensive supplier relationships, and a mix of company-owned and independent stores (primarily under the NAPA brand). The company holds a top-tier competitive position in both the automotive aftermarket (competing with AutoZone, O'Reilly, and LKQ) and industrial distribution (competing with Grainger and Fastenal through its Motion Industries brand). In early 2026, GPC announced a major strategic shift: a planned tax-free separation of its Global Automotive and Global Industrial businesses, targeted for the first quarter of 2027, following a 2025 fiscal year heavily impacted by a $1.3 billion pre-tax pension settlement charge.
The downloadable Genuine Parts 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 & AssumptionsGenuine Parts financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $18.87B | $22.10B | $23.09B | $23.49B | $24.30B |
| Gross profit | $6.63B | $7.74B | $8.29B | $8.52B | $8.94B |
| Cost of goods sold | $12.24B | $14.36B | $14.80B | $14.96B | $15.36B |
| Net income | $898.8M | $1.18B | $1.32B | $904.1M | $65.9M |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Genuine Parts
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
North America Automotive
- Segment name: North America Automotive
- Revenue driver formula: Prior Year Revenue x (1 + Comparable Sales Growth + Acquisition Benefit + FX/Other Impact)
- Historical growth rate: 2-4% CAGR
- Key growth levers and headwinds: Expansion of the NAPA store footprint, market share gains in the DIFM (Do-It-For-Me) commercial segment, and pricing power. Headwinds include mild weather reducing wear-and-tear and consumer deferral of auto maintenance.
- Pricing dynamics: Highly competitive but generally passes through inflation to the end consumer.
- Revenue recognition notes: Recognised at the point of sale for retail customers and upon delivery for commercial accounts.
- Seasonality: Stronger in summer and winter months due to extreme weather driving battery failures and auto repairs.
International Automotive
- Segment name: International Automotive
- Revenue driver formula: Prior Year Revenue x (1 + Comparable Sales Growth + Acquisition Benefit + FX Impact)
- Historical growth rate: 4-6% CAGR
- Key growth levers and headwinds: Bolt-on M&A in Europe and Australasia, expanding the NAPA brand globally. Headwinds include severe foreign currency translation risks and European macroeconomic softness.
- Pricing dynamics: Subject to local market dynamics, regional inflation, and currency translation.
- Revenue recognition notes: Recognised upon delivery or point of sale.
- Seasonality: Similar to North America, heavily weather-dependent.
Industrial Parts Group
- Segment name: Industrial Parts Group
- Revenue driver formula: Prior Year Revenue x (1 + Comparable Sales Growth + Acquisition Benefit + FX Impact)
- Historical growth rate: 4-6% CAGR
- Key growth levers and headwinds: Tied closely to industrial production indices, manufacturing capacity utilisation, and automation trends.
- Pricing dynamics: Contractual pricing with large industrial customers, spot pricing for smaller accounts.
- Revenue recognition notes: Recognised upon shipment or delivery of parts.
- Seasonality: Tied to industrial capital budgets, often showing strength in the fourth quarter as customers exhaust annual maintenance budgets.
Cost Structure
Variable Costs / COGS
- Line-by-line breakdown: Product purchase costs, inbound freight, purchasing and receiving costs, offset by vendor allowances and volume rebates.
- Gross margin range: 35.5% to 36.9% (reached 36.8% in 2025).
- Key input costs and commodity exposures: Steel, rubber, and petroleum-based products, though GPC primarily faces finished-goods pricing from suppliers.
- How COGS scales with revenue: Scales linearly with volume, though vendor rebates improve slightly as purchasing scale increases.
Operating Expenses
- R&D: Not material; GPC is a distributor, not a manufacturer.
- SG&A: The largest expense category (approximately 32-33% of revenue). Includes store rent, personnel and wages, delivery fleet fuel and maintenance, and IT investments. It is heavily headcount and footprint driven.
- Depreciation & Amortisation: Approximately 1.5-2.0% of revenue, split between tangible distribution assets and amortisation of acquired intangibles from serial M&A.
- Stock-Based Compensation: Less than 0.5% of revenue, typical for mature distribution businesses.
- Restructuring / one-time charges: Frequent minor charges for network optimisation, but 2025 included massive discrete charges (a $1.3 billion pre-tax pension settlement and asbestos-related product liability charges).
Margin Profile
- Gross margin: Expanding (up 50 bps in 2025) due to strategic sourcing and pricing initiatives.
- EBITDA margin: 8.0% to 9.5% consolidated.
- Operating margin: 6.0% to 7.5% (adjusted).
- Margin trend: Gross margins are expanding, but EBITDA margins face pressure in the Automotive segments due to SG&A inflation outpacing gross profit growth.
- Segment-level margins: Industrial EBITDA margin is strong (approximately 13.4%), while North America Automotive is lower (approximately 5.5%) and International Automotive sits in the middle (approximately 8.7%).
Balance Sheet Structure
- Total assets: Approximately $17-18 billion.
- Key asset categories: Inventory is the most critical asset, as having the right part at the right time is the core value proposition of the business.
- Goodwill & intangibles: High (approximately 30-40% of total assets) due to a history of serial bolt-on acquisitions.
- Working capital profile:
- Days Sales Outstanding (DSO): 45-55 days.
- Days Inventory Outstanding (DIO): 100-115 days (reflecting the high inventory requirement of the NAPA network).
- Days Payable Outstanding (DPO): 110-130 days.
- Net working capital as % of revenue: Low to slightly negative.
- Is working capital positive or negative? The company heavily utilises supplier financing and extended payment terms, allowing it to fund inventory growth largely through accounts payable.
- PP&E: Consists of distribution centres, store fixtures, and delivery vehicles. Useful lives range from 3 to 40 years.
- Right-of-use assets / operating leases: Highly material due to the massive retail store and branch footprint.
Capital Expenditure & Investment
- Capex as % of revenue: 1.5% to 2.0%.
- Maintenance capex vs. growth capex: Approximately 40% maintenance (facility upkeep, vehicle replacement) and 60% growth (supply chain automation, IT upgrades, store remodels).
- Major capex programmes underway: Investments in search and catalogue technology, network optimisation, and distribution centre automation.
- Capitalised software / development costs: Material portion of growth capex as the company modernises its digital ordering platforms.
- M&A pattern: Serial bolt-on acquirer, typically adding 1-2% to top-line growth annually by buying independent NAPA stores and regional industrial distributors.
- Typical acquisition multiple paid: 8x-10x EBITDA for independent store acquisitions.
Debt & Capital Structure
- Total debt: Approximately $3.5 billion.
- Debt/EBITDA ratio: Target is 2.0x to 2.5x.
- Credit rating: Investment grade (typically BBB range).
- Key debt instruments: Senior unsecured notes and a large revolving credit facility.
- Maturity profile: Well-laddered with average maturities exceeding 5 years.
- Interest rate profile: Primarily fixed-rate senior notes with floating-rate exposure on the revolver.
- Covenants: Standard leverage and interest coverage ratios; ample headroom exists.
- Share repurchase programme: Active programme used to offset dilution and return excess capital to shareholders.
- Dividend policy: Dividend Aristocrat with 70 consecutive years of increases. The 2026 annualised rate is $4.25 per share, yielding approximately 3.0%, with a target payout ratio of 50-60% of adjusted net income.
Cash Flow Characteristics
- Operating cash flow conversion: Typically >100% of adjusted net income, though 2025 GAAP OCF was impacted by discrete items.
- Free cash flow margin: 2.0% to 3.0% of revenue.
- Major non-cash items: Depreciation and amortisation, the massive 2025 pension settlement charge, and deferred income taxes.
- Working capital cash flow impact: Supplier financing programmes create positive cash flow during growth periods, acting as a source of cash.
- Capex intensity: Low (under 2% of sales), resulting in strong free cash flow generation.
- Cash tax rate vs. GAAP effective tax rate: Cash taxes are generally aligned with the GAAP effective tax rate of 24-25%, barring one-time settlement impacts.
Sheet Structure
- Assumptions: Macro drivers, segment growth rates, margin targets, tax rate, capex, and M&A spend.
- Income Statement: Consolidated GAAP and Adjusted views, explicitly reflecting the 2025 pension settlement add-back.
- Balance Sheet: Standard format highlighting Inventory, Accounts Payable, and Goodwill.
- Cash Flow Statement: Indirect method, explicitly breaking out changes in extended supplier payables.
- Revenue & Gross Margin Build: Three-segment build (North America Automotive, International Automotive, Industrial Parts Group) driven by comparable sales, M&A, and FX.
- Segment EBITDA Build: Revenue multiplied by segment-specific EBITDA margins, less corporate allocations.
- Working Capital & Capex: DSO, DIO, DPO schedules and fixed asset roll-forward.
- Debt & Interest Schedule: Tranches of senior notes, revolver drawdowns, and interest expense calculation.
- Spin-Off Pro Forma: Illustrative split of assets, liabilities, and corporate overhead for the 2027 separation of the Industrial business.
- DCF Valuation: Sum-of-the-parts valuation for the Global Automotive and Global Industrial segments.
Key Financial Relationships
- North America Auto Revenue = Prior Year NA Auto Revenue x (1 + NA Comp Sales Growth + NA M&A Growth)
- International Auto Revenue = Prior Year Int Auto Revenue x (1 + Int Comp Sales Growth + Int M&A Growth + FX Impact)
- Industrial Revenue = Prior Year Industrial Revenue x (1 + Ind Comp Sales Growth + Ind M&A Growth)
- Consolidated Gross Profit = (NA Auto Revenue + Int Auto Revenue + Industrial Revenue) x Consolidated Gross Margin %
- Segment EBITDA = Segment Revenue x Segment EBITDA Margin %
- Corporate Overhead = Total SG&A - Sum of Segment-Level SG&A
- Adjusted Net Income = GAAP Net Income + Pension Settlement Charge + Asbestos Liability Charge + Restructuring Costs (net of tax)
- Inventory Balance = (Consolidated COGS / 365) x DIO
- Accounts Payable Balance = (Consolidated COGS / 365) x DPO
- Free Cash Flow = Operating Cash Flow - Capital Expenditures
Cross-Sheet Dependencies
- The Assumptions sheet feeds the Revenue & Gross Margin Build and Working Capital & Capex sheets.
- The Revenue & Gross Margin Build feeds the Segment EBITDA Build and the Income Statement.
- The Segment EBITDA Build feeds the Income Statement (Operating Income line).
- The Income Statement feeds the Cash Flow Statement (Net Income starting point) and the Balance Sheet (Retained Earnings).
- The Working Capital & Capex sheet feeds the Balance Sheet (Current Assets and Liabilities) and the Cash Flow Statement (Changes in Net Working Capital).
- The Debt & Interest Schedule feeds the Income Statement (Interest Expense) and the Cash Flow Statement (Debt issuance and repayment). A circularity risk exists between interest expense, net income, cash generation, and revolver paydown.
Sign Convention
- Revenue, Assets, and Equity are represented as positive numbers.
- Expenses (COGS, SG&A, Interest, Taxes) are represented as negative numbers on the Income Statement.
- Contra-assets (Accumulated Depreciation) are represented as negative numbers.
- Cash inflows are positive, and cash outflows (Capital Expenditures, Dividends, Debt Repayment) are negative on the Cash Flow Statement.
Things Most Likely to Go Wrong
- The 2025 GAAP net income is heavily distorted by a $1.3 billion pre-tax pension settlement; the model must use Adjusted Net Income as the base for future forecasting to avoid absurd growth rates.
- The company recently changed its segment reporting to split Global Automotive into North America and International; historical data prior to 2024 must be restated to match this new structure.
- Supplier financing programmes artificially inflate operating cash flow; if DPO normalises or suppliers change terms, it will cause a massive working capital cash drain.
- Corporate overhead allocations are currently blended; the spin-off pro forma must accurately disaggregate these costs between the Auto and Industrial standalone entities.
- Foreign currency translation significantly impacts International Automotive revenue; the model must include a constant-currency toggle to assess core operational performance.
- Gross margin improvements are driven by acquired businesses and strategic sourcing; assuming perpetual gross margin expansion will overstate terminal value.
- SG&A inflation is currently outpacing gross profit growth in the Auto segments, causing EBITDA margin compression; the model must link SG&A growth to a realistic inflation index.
- The dividend payout ratio is a sacred cow (70 years of increases); the model must prioritise dividend payments over discretionary M&A or share buybacks in the cash flow waterfall.
Validation Checks
- Consolidated Gross Margin should remain between 36.0% and 37.5%; flag if outside this band.
- Industrial Segment EBITDA margin should be 12.5% to 14.0%; flag if it drops below historical averages.
- North America Automotive EBITDA margin should be 5.0% to 7.0%.
- Capex as a percentage of revenue should run between 1.5% and 2.5%.
- Debt/EBITDA must remain below 3.0x to maintain investment-grade credit ratings.
- Dividend per share must be strictly greater than or equal to the prior year to maintain Dividend Aristocrat status.
- Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period.
- Free Cash Flow conversion (FCF / Adjusted Net Income) should be between 50% and 70%.
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| NA Auto Comp Sales Growth | 1.5 | % | Based on recent 2025 performance and mature market dynamics |
| NA Auto M&A Growth | 1.5 | % | Historical average for bolt-on acquisitions |
| Int Auto Comp Sales Growth | -0.5 | % | Reflects recent slight contraction in European markets |
| Int Auto M&A Growth | 2.2 | % | Based on 2025 actual acquisition benefit |
| Industrial Comp Sales Growth | 3.4 | % | Based on 2025 actual performance |
| Industrial M&A Growth | 1.0 | % | Based on 2025 actual acquisition benefit |
| Consolidated Gross Margin | 36.8 | % | Actual 2025 adjusted gross margin |
| NA Auto EBITDA Margin | 5.5 | % | Actual Q4 2025 run-rate |
| Int Auto EBITDA Margin | 8.7 | % | Actual Q4 2025 run-rate |
| Industrial EBITDA Margin | 13.4 | % | Actual Q4 2025 run-rate |
| SG&A as % of Revenue | 32.8 | % | Derived from 2025 operating expenses |
| Effective Tax Rate | 24.0 | % | Historical average statutory and state blend |
| Days Sales Outstanding (DSO) | 50 | Days | Calculated from 2024/2025 average receivables |
| Days Inventory Outstanding (DIO) | 110 | Days | Calculated from 2024/2025 average inventory |
| Days Payable Outstanding (DPO) | 120 | Days | Reflects heavy use of supplier financing |
| Capex as % of Revenue | 1.8 | % | Management guidance and historical average |
| Dividend per Share | 4.25 | USD | Announced 2026 annualised rate |
| WACC | 8.5 | % | Standard distributor cost of capital |
| Terminal Growth Rate | 2.0 | % | Aligned with long-term GDP growth |
Data Sources & Benchmarks
- SEC EDGAR for GPC 10-K and 10-Q filings.
- GPC Investor Relations page for the November 2025 Investor Presentation and Q4 2025 Earnings Release.
- Peers for Automotive: AutoZone (AZO), O'Reilly Automotive (ORLY), LKQ Corporation (LKQ).
- Peers for Industrial: W.W. Grainger (GWW), Fastenal (FAST), WESCO International (WCC).
- Industry data: U.S. Industrial Production Index (for the Motion segment), U.S. Vehicle Miles Travelled and Average Vehicle Age (for the Automotive segments).
Sources
Do more with the Genuine Parts model
Frequently asked
What does Genuine Parts Company (GPC) do?+
Genuine Parts Company (GPC) is a leading global distributor of automotive and industrial replacement parts, operating through North America Automotive, Industrial Parts Group, and International Automotive segments. The company utilizes an asset-light distribution model, relying on a vast hub-and-spoke supply chain and extensive supplier relationships, primarily under the NAPA brand.
What are the primary revenue drivers for Genuine Parts Company?+
GPC's revenue is primarily driven by its global distribution of automotive and industrial replacement parts across its three main business segments. Additionally, serial bolt-on acquisitions typically contribute 1-2% to top-line growth annually by expanding its network of independent NAPA stores and regional industrial distributors.
What is the assumed revenue growth rate in the Genuine Parts Company financial model?+
The financial model for Genuine Parts Company assumes a revenue growth rate of approximately 7.14%. This forecast covers the period from FY2026 to FY2030, reflecting the company's operational trajectory and acquisition strategy.
How does Genuine Parts Company's working capital profile impact its financial model and valuation?+
Genuine Parts Company's working capital profile is characterized by low to slightly negative net working capital as a percentage of revenue. This is due to the company's heavy utilization of supplier financing and extended payment terms, which allows it to fund inventory growth largely through accounts payable. This efficient working capital management can positively influence cash flow generation in a financial model.
Can I download an Excel financial model for Genuine Parts Company?+
Yes, an Excel financial model for Genuine Parts Company is available for download. This model provides a forecast horizon from FY2026 to FY2030 and evaluates the sum-of-the-parts equity valuation and standalone capital structure viability.
What is the purpose of the Genuine Parts Company financial model, especially regarding its strategic plans?+
The financial model for Genuine Parts Company evaluates the sum-of-the-parts equity valuation and standalone capital structure viability. This is particularly relevant ahead of its planned 2027 tax-free spin-off of the Industrial Parts Group, which represents a major strategic shift for the company.
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.
O’Reilly Automotive
O'Reilly Automotive is a leading specialty retailer of automotive aftermarket parts, tools, supplies, equipment, and accessories in North America.
Paccar
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.
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 Consumer financial model templates.
