AutoZone Financial Model
Automotive Company Financials Example (Free Excel Download)
AutoZone is the leading retailer and distributor of automotive replacement parts and accessories in the Americas.
professionals from Deloitte
Used by professionals from
About this model
This model projects AutoZone's future cash flows and capital structure to determine its intrinsic equity valuation and assess its capacity to sustain its aggressive share repurchase programme.
AutoZone is the leading retailer and distributor of automotive replacement parts and accessories in the Americas. The company primarily serves the Do-It-Yourself (DIY) retail customer and the Do-It-For-Me (DIFM) commercial customer through a massive network of stores and distribution hubs.
Business segments include:
- Domestic Auto Parts (approx. 85-90% of revenue): Includes both DIY retail sales and Commercial (DIFM) sales.
- International (approx. 10-15% of revenue): Operations in Mexico and Brazil.
- ALLDATA (immaterial % of revenue): Diagnostic and repair software.
The business model is highly cash-generative and relies on a negative working capital dynamic, where inventory is entirely funded by vendor payables. AutoZone holds a dominant competitive position in a consolidated oligopoly alongside O'Reilly Automotive and Advance Auto Parts. Recent major events include a significant acceleration in international store openings (particularly in Brazil) and the expansion of the "Mega Hub" distribution network to improve parts availability.
The downloadable AutoZone 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 & AssumptionsAutoZone financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $14.63B | $16.25B | $17.46B | $18.49B | $18.94B |
| Gross profit | $7.72B | $8.47B | $9.07B | $9.82B | $9.97B |
| Operating income | $2.94B | $3.27B | $3.47B | $3.79B | $3.61B |
| Net income | $2.17B | $2.43B | $2.53B | $2.66B | $2.50B |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for AutoZone
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Domestic DIY (Retail)
- Segment name: Domestic Auto Parts (Retail)
- Revenue driver formula: Average Domestic Stores x Average DIY Sales per Store
- Historical growth rate: 1-3% CAGR (highly dependent on macro environment and weather)
- Key growth levers and headwinds: Driven by the age of the US vehicle fleet, miles driven, and used car prices. Headwinds include the long-term transition to electric vehicles (EVs), which require fewer replacement parts.
- Pricing dynamics: Highly rational oligopoly pricing; the company typically passes inflation directly to the consumer.
- Revenue recognition notes: Recognised at the point of sale.
- Seasonality: The spring and summer months (fiscal Q3 and Q4) are typically the strongest due to increased driving and weather-related wear and tear.
Domestic Commercial (DIFM)
- Segment name: Domestic Auto Parts (Commercial)
- Revenue driver formula: Average Commercial Programs x Average Weekly Sales per Program x 52 weeks
- Historical growth rate: 5-8% CAGR
- Key growth levers and headwinds: Expanding the commercial programme to more stores (currently in approx. 92% of domestic stores) and improving delivery times via the Mega Hub network.
- Pricing dynamics: More competitive than DIY, requiring volume discounts for local garages and national fleets.
- Revenue recognition notes: Recognised upon delivery to the commercial customer.
- Seasonality: Similar to DIY, peaking in summer months.
International
- Segment name: International (Mexico and Brazil)
- Revenue driver formula: Average International Stores x Average Sales per Store (adjusted for FX)
- Historical growth rate: 8-12% CAGR (constant currency)
- Key growth levers and headwinds: Rapid store footprint expansion in Brazil and maturing store base in Mexico. FX translation is a major headwind or tailwind depending on the strength of the US Dollar.
- Pricing dynamics: Localised pricing subject to regional inflation and import tariffs.
- Revenue recognition notes: Point of sale, translated to USD at average exchange rates.
- Seasonality: Generally mirrors the US, though regional weather patterns in Brazil differ.
Cost Structure
Variable Costs / COGS
- COGS includes the direct cost of merchandise, freight, distribution centre costs, and non-cash LIFO (Last-In, First-Out) accounting adjustments.
- Gross margin range: 51.5% to 54.0% (FY2025 average was 52.6%).
- Key input costs include raw materials for private label parts (steel, plastics) and global shipping freight rates.
- COGS scales linearly with revenue, though LIFO charges can create temporary distortions during periods of high inflation.
Operating Expenses
- R&D: Not applicable or material for this retail business.
- SG&A: Operating expenses (approx. 32-36% of sales) consist primarily of store payroll, rent for leased properties, advertising, and corporate overhead.
- Depreciation & Amortisation: Typically 2-3% of revenue, driven by store fixtures, hub build-outs, and supply chain investments.
- Stock-Based Compensation: Relatively small as a percentage of revenue, but material to operating cash flow adjustments.
- Restructuring / one-time charges: Infrequent, though the company occasionally adjusts for 53-week fiscal years.
Margin Profile
- Gross margin: 52.0% - 53.5%
- EBITDA margin: 21.0% - 22.5%
- Operating margin (EBIT): 19.0% - 20.0%
- Net margin: 12.5% - 13.5%
- Margin trend: Operating margins have faced slight pressure recently (compressing by approx. 50-100 bps) due to wage inflation and investments in IT and supply chain, though gross margins remain highly stable.
Balance Sheet Structure
- Total assets are approximately $16 billion to $18 billion.
- Key asset categories are Merchandise Inventories (approx. $6 billion) and Property & Equipment (approx. $6 billion).
- Goodwill & intangibles are minimal, as AutoZone grows organically rather than through acquisitions.
- Working capital profile:
- Days Sales Outstanding (DSO): 5-10 days (mostly commercial credit accounts).
- Days Inventory Outstanding (DIO): 250-280 days (the company carries massive SKU counts to ensure parts availability).
- Days Payable Outstanding (DPO): 300-330 days.
- Net working capital is structurally negative. The company funds its inventory entirely through accounts payable (AP to Inventory ratio typically exceeds 110%). This negative NWC is a massive competitive advantage, generating cash as the business grows.
- PP&E consists of owned store locations, distribution centres, and store fixtures.
- Right-of-use assets (operating leases) are material, representing approximately $3 billion to $4 billion, as many stores are leased.
Capital Expenditure & Investment
- Capex as a % of revenue typically runs between 4.0% and 5.5%.
- Maintenance capex accounts for roughly 40% of the total, with growth capex (new stores, Mega Hubs, IT systems) making up the remaining 60%.
- Major capex programmes underway include the aggressive rollout of Mega Hubs (targeting over 200 eventually) to improve local inventory availability.
- Capitalised software costs are present but not the primary driver of capex.
- M&A pattern: AutoZone is strictly an organic grower. Transformational M&A is non-existent.
Debt & Capital Structure
- Total debt is approximately $8.5 billion to $9.5 billion.
- Debt/EBITDAR ratio target is strictly maintained at approximately 2.5x. This is the governing metric for their capital allocation.
- Credit rating is investment grade (typically BBB/Baa2).
- Key debt instruments include senior unsecured notes with staggered maturities and a commercial paper programme backed by a revolving credit facility.
- Interest rate profile is predominantly fixed via the senior notes, with a weighted average cost of debt around 4.0% to 5.0%.
- Share repurchase programme is exceptionally active. The company routinely buys back $1.5 billion to $2.0 billion of stock annually. Since 1998, they have repurchased over $38 billion in stock.
- Dividend policy: AutoZone pays zero dividends. All excess cash is directed to share repurchases.
Cash Flow Characteristics
- Operating cash flow conversion (OCF / Net Income) is consistently strong, typically ranging from 1.1x to 1.3x.
- Free cash flow margin (FCF / Revenue) generally sits between 10% and 12%.
- Major non-cash items include depreciation, amortisation, and LIFO inventory adjustments.
- Working capital cash flow impact is a source of cash during growth periods because payables grow faster than inventory.
- Capex intensity is moderate but highly predictable.
- Cash tax rate closely mirrors the GAAP effective tax rate of approximately 20% to 21%.
Sheet Structure
- Assumptions: Hardcoded inputs for store growth, same-store sales, margins, working capital days, and capital allocation targets.
- Store Roll-Forward: Tracks beginning stores, openings, closings, and ending stores for US, Mexico, and Brazil. Also tracks the number of Commercial Programs.
- Revenue Build: Calculates Domestic DIY, Domestic Commercial, and International revenue based on store counts and productivity metrics.
- Income Statement: Standard P&L from Net Sales down to Net Income and EPS, including LIFO adjustments.
- Balance Sheet: Assets, Liabilities, and Shareholders' Deficit. Must explicitly model the massive negative retained earnings/treasury stock.
- Cash Flow Statement: OCF, CFI, and CFF. Must link the AP growth to inventory growth.
- Debt Schedule: Tranches of senior notes, commercial paper, interest expense calculation, and the 2.5x Debt/EBITDAR target calculation.
- Working Capital Schedule: DSO, DIO, DPO calculations. Crucially, models Accounts Payable as a function of Inventory.
- Depreciation & Capex: PP&E roll-forward, maintenance vs. growth capex, and D&A expense.
- Shareholders' Equity: Tracks the massive treasury stock balance driven by the buyback programme and calculates the shrinking share count.
- DCF Valuation: Unlevered free cash flow, WACC calculation, terminal value, and implied share price.
Key Financial Relationships
- `Ending US Stores = Beginning US Stores + US Store Openings - US Store Closings`
- `Average US Stores = (Beginning US Stores + Ending US Stores) / 2`
- `Domestic DIY Revenue = Average US Stores x DIY Sales per Store`
- `Commercial Programs = Ending US Stores x Commercial Program Penetration %`
- `Domestic Commercial Revenue = Average Commercial Programs x Average Weekly Sales per Program x 52`
- `International Revenue = Average International Stores x International Sales per Store x (1 + FX Impact %)`
- `Total Net Sales = Domestic DIY Revenue + Domestic Commercial Revenue + International Revenue`
- `Gross Profit = Total Net Sales x Gross Margin %` (where Gross Margin includes LIFO impact)
- `Ending Inventory = (COGS / 365) x DIO`
- `Accounts Payable = Ending Inventory x (AP to Inventory Ratio)` (Targeting >110%)
- `Target Total Debt = EBITDAR x 2.5` (where EBITDAR = EBIT + D&A + Rent Expense)
- `Share Repurchases = Free Cash Flow + (Target Total Debt - Current Total Debt)`
- `Ending Share Count = Beginning Share Count - (Share Repurchases / Average Share Price)`
Cross-Sheet Dependencies
- The Store Roll-Forward sheet dictates the volume drivers and feeds directly into the Revenue Build.
- The Revenue Build feeds the top line of the Income Statement.
- The Income Statement generates Net Income, which feeds the top of the Cash Flow Statement and Retained Earnings on the Balance Sheet.
- The Working Capital Schedule relies on Revenue and COGS from the Income Statement and feeds the operating assets/liabilities on the Balance Sheet and the working capital changes on the Cash Flow Statement.
- The Debt Schedule calculates interest expense (feeding the Income Statement) and determines the debt capacity based on EBITDAR.
- The Shareholders' Equity sheet uses the debt capacity and free cash flow to calculate share repurchases, which feeds the financing section of the Cash Flow Statement and reduces the share count for EPS calculations on the Income Statement.
- Circularity risk exists between Interest Expense, Net Income, Free Cash Flow, Debt Balances, and Share Repurchases. A circuit breaker or iterative calculation toggle is required.
Sign Convention
- Revenues, Assets, and Equity balances are positive.
- Expenses (COGS, SG&A, Interest, Taxes) are positive on their respective build schedules but subtracted in the Income Statement totals.
- Contra-equity accounts (Treasury Stock) are negative.
- On the Cash Flow Statement, cash inflows are positive and cash outflows (Capex, Share Repurchases, Debt Repayments) are negative.
Things Most Likely to Go Wrong
- "The AP-to-Inventory ratio is the engine of AutoZone's cash flow; if the model calculates AP based on COGS rather than pegging it to Inventory, the working capital dynamics will be fundamentally wrong."
- "AutoZone operates with a massive Shareholders' Deficit (negative equity) due to decades of share buybacks; standard Return on Equity (ROE) calculations will output meaningless negative numbers and must be replaced with Return on Invested Capital (ROIC)."
- "LIFO accounting can cause sudden swings in Gross Margin during inflationary periods; the model should separate underlying merchandise margin from the non-cash LIFO charge."
- "The company strictly manages its capital structure to a 2.5x Debt/EBITDAR ratio; failing to model debt issuance as a function of EBITDA growth will understate their share repurchase capacity."
- "Foreign currency translation (especially the Mexican Peso and Brazilian Real) can swing reported International revenue significantly; the model must separate constant-currency growth from FX impacts."
- "Share count reduction is a massive driver of EPS growth; if the model holds share count flat, EPS forecasts will be drastically understated."
- "The fiscal calendar occasionally includes a 53rd week; historical data must be normalised to 52 weeks to calculate accurate same-store sales and growth rates."
- "Operating leases were capitalised under ASC 842; rent expense must be properly added back when calculating EBITDAR for the leverage target."
Validation Checks
- "Gross margin should remain tightly bound between 52.0% and 53.5%; flag if outside this band."
- "Accounts Payable divided by Merchandise Inventory must remain above 100% (typically 110-120%)."
- "Debt to EBITDAR ratio must equal approximately 2.5x in all projected periods."
- "Balance sheet must balance: Total Assets = Total Liabilities + Shareholders' Deficit in every period."
- "Operating Cash Flow must exceed Net Income (OCF/NI > 1.0x)."
- "Capex as a % of revenue should run between 4.0% and 5.5%."
- "Effective tax rate should remain between 20.0% and 21.5%."
- "Share count must decrease every year, reflecting the ongoing repurchase programme."
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| US Store Openings | 120 | Stores | Based on FY2024/FY2025 actual expansion rate |
| Mexico Store Openings | 45 | Stores | Based on recent annual run-rate |
| Brazil Store Openings | 15 | Stores | Based on recent annual run-rate |
| Domestic SSS Growth | 2.0 | % | Long-term historical average for DIY/Commercial blend |
| International SSS Growth | 8.0 | % | Constant currency growth expectation based on recent quarters |
| Gross Margin | 52.6 | % | Actual FY2025 reported gross margin |
| Operating Expenses (SG&A) | 33.6 | % of Sales | Actual FY2025 reported operating expense ratio |
| Effective Tax Rate | 20.3 | % | Actual FY2025 reported effective tax rate |
| Days Inventory Outstanding (DIO) | 265 | Days | Calculated from recent balance sheet averages |
| AP to Inventory Ratio | 115.0 | % | Historical average demonstrating vendor financing |
| Capex % of Sales | 4.5 | % | Historical average supporting store and hub growth |
| Target Debt / EBITDAR | 2.5 | x | Management's stated capital structure target |
| Weighted Average Interest Rate | 4.5 | % | Based on current senior note portfolio |
| WACC | 8.5 | % | Standard discount rate for US hardline retail |
| Terminal Growth Rate | 2.0 | % | Aligned with long-term GDP and inflation |
Data Sources & Benchmarks
- Filings: AutoZone SEC EDGAR page (10-K, 10-Q, 8-K) and the AutoZone Investor Relations website.
- Key Peers: O'Reilly Automotive (ORLY), Advance Auto Parts (AAP), Genuine Parts Company (GPC).
- Industry Data: Auto Care Association factbook for total addressable market, average vehicle age, and miles driven data from the US Department of Transportation.
- Consensus Estimates: FactSet or Bloomberg for forward-looking EPS and same-store sales estimates.
Sources
- AutoZone, Inc. Form 10-K for the fiscal year ended August 31, 2024 (SEC EDGAR).
- AutoZone, Inc. Q4 FY2025 Earnings Release and Presentation (September 23, 2025).
- AutoZone, Inc. Q1 FY2026 Earnings Release (December 9, 2025).
- AutoZone, Inc. Q2 FY2026 Earnings Release (March 4, 2026).
- AutoZone Investor Relations Website (https://investors.autozone.com).
Do more with the AutoZone model
Frequently asked
What is AutoZone's primary business model and how does it generate revenue?+
AutoZone is the leading retailer and distributor of automotive replacement parts and accessories, primarily serving Do-It-Yourself retail and Do-It-For-Me commercial customers. Its revenue is primarily generated through its Domestic Auto Parts segment (85-90%), with additional contributions from International operations and ALLDATA software. The company operates a highly cash-generative business model, benefiting from a negative working capital dynamic.
What are the main segments driving AutoZone's revenue growth?+
AutoZone's revenue growth is predominantly driven by its Domestic Auto Parts segment, which encompasses both DIY retail sales and Commercial (DIFM) sales. The International segment, with operations in Mexico and Brazil, also contributes significantly, especially with recent acceleration in international store openings. The expansion of the "Mega Hub" distribution network is also a key initiative to improve parts availability and support growth.
How does AutoZone's negative working capital impact its financial model?+
AutoZone's structurally negative working capital is a significant competitive advantage, as its massive inventory is entirely funded by vendor payables. This dynamic generates cash as the business grows, improving its overall cash flow profile. The financial model incorporates a NWC_Pct_Revenue assumption of -0.0806 to reflect this characteristic.
What is AutoZone's typical capital expenditure as a percentage of revenue?+
AutoZone's capital expenditure typically runs between 4.0% and 5.5% of revenue, with the financial model using an assumption of 0.0415. This capex is roughly 40% for maintenance and 60% for growth, funding new stores, Mega Hubs, and IT systems. A major capex program involves the aggressive rollout of Mega Hubs to enhance local inventory availability.
What is the main purpose of the AutoZone financial model?+
The AutoZone financial model is designed to project the company's future cash flows and capital structure. Its primary purpose is to determine AutoZone's intrinsic equity valuation. Additionally, it assesses the company's capacity to sustain its aggressive share repurchase program.
Can I download an Excel financial model for AutoZone?+
Yes, an Excel financial model for AutoZone is available for download. This general corporate model projects the company's financial performance from FY2026 through FY2030. It includes key assumptions such as revenue growth, COGS percentage of revenue, and capital expenditure percentage of revenue.
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.
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.
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.
