Tractor Supply Financial Model

Tractor Supply reports consolidated net sales, but the model must project revenue based on store unit economics and product categories.

• Consolidated Net Sales
• Revenue driver formula: (Beginning Store Count + New Stores Opened) x Average Revenue per Store, adjusted for Comparable Store Sales (Comps). Comps are driven by "Comparable Average Ticket" x "Comparable Transaction Count".
• Historical growth rate: 2% to 7% over the last 3 years (Net sales were $14.88 billion in 2024 and $15.52 billion in 2025).
• Key growth levers and headwinds: Store expansion (targeting 90 to 100 new stores annually), Project Fusion remodels, Garden Center additions, and the integration of Allivet. Headwinds include macroeconomic pressure on discretionary big-ticket items and weather volatility (lack of hurricane-related demand or unseasonal weather).
• Pricing dynamics: Everyday low price strategy, highly sensitive to freight costs and tariffs.
• Revenue recognition notes: Recognised at the point of sale in stores or upon delivery for e-commerce. Neighbor's Club loyalty rewards are deferred and recognised as revenue when points are redeemed.
• Seasonality: Q2 is historically the strongest quarter due to spring planting, fertiliser, and agricultural needs, while Q4 is driven by cold weather gear and heating supplies.

• Total assets: Approximately $9 billion to $10 billion.
• Key asset categories: Merchandise inventories (over $3 billion), Operating lease right-of-use assets, and Property and equipment.
• Goodwill & intangibles: Relatively small, but increased slightly following the $135 million Allivet acquisition in late 2024.
• Working capital profile:
• Days Sales Outstanding (DSO): 2 to 4 days (primarily retail cash/credit card sales).
• Days Inventory Outstanding (DIO): 130 to 140 days (the company must hold significant bulk inventory like feed and fencing).
• Days Payable Outstanding (DPO): 50 to 60 days.
• Net working capital as % of revenue: Positive, typically around 10% to 15% of sales due to massive inventory requirements.
• Working capital funding: The company requires working capital investment to fund new store inventory build-outs.
• PP&E: Consists of owned stores, distribution centres, and fixtures. The company uses sale-leaseback transactions to manage capital, selling newly developed stores and leasing them back.
• Right-of-use assets: Highly material due to the leased store base, representing a significant portion of total liabilities.

• Capex as % of revenue: 4.0% to 5.5% ($894 million in 2025, guided to $675 million to $725 million in 2026).
• Maintenance capex vs. growth capex: Approximately 30% maintenance and 70% growth (new stores, Project Fusion remodels, Garden Centers, and new distribution centres).
• Major capex programmes underway: Building the 11th distribution centre, rolling out Project Fusion to over 60% of the chain, and opening 90 to 100 new stores annually.
• Capitalised software: Moderate, related to digital capabilities and the Neighbor's Club app.
• M&A pattern: Infrequent bolt-on acquisitions (e.g., Petsense, Orscheln Farm and Home, Allivet) to expand total addressable market.

• Total debt: Approximately $1.76 billion in long-term debt as of late 2025.
• Debt/EBITDA ratio: Conservative, typically around 1.0x to 1.5x.
• Credit rating: Investment grade (Moody's Baa1, S&P BBB).
• Key debt instruments: Senior unsecured notes and a revolving credit facility.
• Interest rate profile: Primarily fixed-rate bonds with a manageable weighted average cost of debt.
• Share repurchase programme: Highly active. The company repurchased $560 million in 2024 and $360 million in 2025, with $375 million to $450 million planned for 2026.
• Dividend policy: Consistent dividend grower (15+ consecutive years). Paid $487 million in 2025, yielding approximately 1.5% to 2.0% with a payout ratio around 40% to 45%.

• Operating cash flow conversion: OCF / Net Income is typically 1.2x to 1.5x ($1.64 billion OCF on $1.10 billion Net Income in 2025).
• Free cash flow margin: 4.0% to 6.0% of revenue.
• Major non-cash items: Depreciation and amortisation, stock-based compensation, and deferred income taxes.
• Working capital cash flow impact: Inventory builds for new stores and seasonal peaks act as a use of cash, partially offset by vendor payables.
• Capex intensity: High absolute dollar capex, but manageable relative to robust operating cash flow.
• Cash tax rate: Tracks closely to the GAAP effective tax rate of 21.5% to 22.5%.

1. Assumptions: Hardcoded inputs for macroeconomic drivers, store rollout schedule, comp sales, margin targets, and capital allocation.
2. Store Rollout & Comps: Detailed schedule tracking beginning store count, openings, closures, and ending store count for both Tractor Supply and Petsense. Calculates comparable store sales growth (traffic and ticket) versus non-comp sales.
3. Income Statement: Consolidated statement of operations mirroring the 10-K. Lines include Net Sales, Cost of Merchandise Sold, Gross Profit, SG&A, Operating Income, Interest Expense, Income Before Taxes, Income Tax Expense, and Net Income.
4. Balance Sheet: Standard assets and liabilities. Key lines include Merchandise Inventories, Operating Lease Right-of-Use Assets, PP&E (net), Accounts Payable, Operating Lease Liabilities, and Long-Term Debt.
5. Cash Flow Statement: Indirect method starting with Net Income. Includes adjustments for D&A, changes in working capital (specifically calling out Merchandise Inventories and Accounts Payable), Capex (net of sale-leaseback proceeds), Dividends, and Share Repurchases.
6. Working Capital Schedule: Calculates DSO, DIO, and DPO to project Accounts Receivable, Inventory, and Accounts Payable based on forward revenue and COGS.
7. Debt & Interest Schedule: Tracks senior notes, revolving credit facility balances, and calculates interest expense based on weighted average rates.
8. Lease Schedule: Rolls forward operating lease ROU assets and liabilities, calculating rent expense embedded in SG&A.
9. DCF Valuation: Unlevered free cash flow calculation, WACC assumptions, terminal value, and implied share price (adjusted for the recent 5-for-1 split).

1. Ending Store Count = Beginning Store Count + New Store Openings - Store Closures
2. Comparable Store Sales Growth = Comparable Average Ticket Growth + Comparable Transaction Count Growth
3. Total Net Sales = (Prior Year Net Sales x (1 + Comparable Store Sales Growth)) + Sales from New Non-Comp Stores
4. Cost of Merchandise Sold = Total Net Sales x (1 - Gross Margin Percentage)
5. Gross Profit = Total Net Sales - Cost of Merchandise Sold
6. SG&A Expense = Total Net Sales x SG&A Margin Percentage
7. Operating Income = Gross Profit - SG&A Expense
8. Merchandise Inventories = (Cost of Merchandise Sold / 365) x Days Inventory Outstanding
9. Accounts Payable = (Cost of Merchandise Sold / 365) x Days Payable Outstanding
10. Net Capital Expenditures = Gross Capital Expenditures - Proceeds from Sale-Leaseback Transactions
11. Free Cash Flow = Cash from Operations - Net Capital Expenditures
12. Shares Outstanding = Prior Period Shares - (Share Repurchase Dollar Amount / Average Share Price)
13. Dividends Paid = Shares Outstanding x Annual Dividend per Share
14. Earnings Per Share = Net Income / Weighted Average Shares Outstanding

The Assumptions sheet dictates the store growth and comp sales metrics in the Store Rollout & Comps sheet. The output of the store schedule drives Total Net Sales on the Income Statement. Net Sales and COGS from the Income Statement feed the Working Capital Schedule to calculate Inventory and Payables, which then populate the Balance Sheet. The changes in these working capital accounts flow into the Cash Flow Statement to determine Operating Cash Flow. Capex assumptions drive PP&E on the Balance Sheet and Depreciation on the Income Statement. The Cash Flow Statement determines the ending cash balance and debt requirements, which feed back into the Balance Sheet and the Debt & Interest Schedule. Circularity can occur between the interest expense on the Income Statement, the net income feeding the Cash Flow Statement, and the resulting cash/debt balances driving interest expense.

• Revenues, assets, and equity are entered as positive numbers.
• Expenses (COGS, SG&A, Interest, Taxes) are entered as positive numbers and subtracted in subtotal formulas.
• On the Cash Flow Statement, cash inflows are positive and cash outflows (e.g., Capex, Dividends, Share Repurchases, Inventory increases) are negative.
• Contra-assets (like Accumulated Depreciation) are entered as positive numbers and subtracted from gross assets.

• Failing to adjust historical per-share data for the 5-for-1 stock split executed on 20 December 2024. All historical EPS and share count figures must be restated to match current projections.
• Mismodelling sale-leaseback transactions. The company builds stores, sells them, and leases them back. The model must capture capital expenditures net of sale-leaseback proceeds to reflect true cash outflows.
• Underestimating the working capital drag of new store openings. Each new store requires significant upfront inventory investment before generating cash.
• Ignoring the impact of the 53rd week in certain fiscal years. Retail calendars occasionally include an extra week, which distorts year-over-year comparable sales and total revenue growth.
• Treating SG&A as entirely variable. A significant portion of SG&A (rent, store management payroll) is fixed, leading to margin deleverage when comparable store sales growth is weak.
• Overlooking the impact of tariffs and freight costs on gross margin. The company imports a material amount of hardlines, making margins sensitive to supply chain disruptions.
• Failing to account for the Allivet acquisition in the 2025 base year, which added inorganic revenue and slightly altered the margin profile.
• Miscalculating the Neighbor's Club loyalty programme deferred revenue, which can create timing differences between cash collection and revenue recognition.

• Gross margin should remain tightly bound between 35.0% and 36.5%; flag if it exceeds 37.0%.
• Operating margin must stay within the 9.0% to 10.0% range based on historical performance and management guidance.
• Net Capital Expenditures should run between $650 million and $750 million annually (approximately 4.5% of sales).
• Comparable store sales growth should not exceed 5.0% in a normalised environment without a specific macro catalyst.
• The Balance Sheet must balance perfectly in every projected period (Total Assets = Total Liabilities + Shareholders' Equity).
• Days Inventory Outstanding (DIO) should remain above 130 days; the business cannot operate efficiently with lean inventory due to bulk product requirements.
• Operating Cash Flow must exceed Net Income consistently (OCF/NI ratio > 1.1x).
• Debt to EBITDA should remain below 2.0x to maintain the company's investment-grade credit rating.

• Filings: SEC EDGAR for TSCO 10-K, 10-Q, and 8-K filings.
• Investor Relations: Tractor Supply IR website for quarterly earnings presentations and Life Out Here 2030 strategic updates.
• Key Peers: Home Depot (HD), Lowe's (LOW), Floor & Decor (FND), and Dick's Sporting Goods (DKS) for retail margin and multiple benchmarking.
• Industry Data: USDA reports for agricultural trends, and weather data sources (NOAA) for seasonal demand forecasting.
• Consensus Estimates: FactSet or Bloomberg for forward-looking analyst estimates on comps and EPS.

• Tractor Supply Company Q4 and Full Year 2025 Earnings Release (tractorsupply.com)
• Tractor Supply Company 2024 Annual Report (Form 10-K)
• Tractor Supply Company Q4 and Full Year 2024 Earnings Release (tractorsupply.com)
• Tractor Supply Q4 2025 slides and margin analysis (investing.com)
• Tractor Supply Gross Profit Margin Benchmarks (finbox.com)
• Tractor Supply Earnings Call Analysis (tipranks.com)