Dollar Tree Financial Model
Retail Company Financials Example (Free Excel Download)
Dollar Tree, Inc. is a leading North American operator of discount variety stores, offering a wide range of everyday merchandise, seasonal goods, and party supplies.
professionals from Deloitte
Used by professionals from
About this model
This model evaluates the standalone equity valuation and cash flow generation capacity of Dollar Tree following its strategic divestiture of the Family Dollar business, allowing an equity analyst to assess the earnings power and margin expansion potential of the core "Dollar Tree 3.0" multi-price strategy.
- Dollar Tree, Inc. is a leading North American operator of discount variety stores, offering a wide range of everyday merchandise, seasonal goods, and party supplies.
- Business segments: Following the July 2025 sale of Family Dollar to private equity firms, the company operates as a single-segment enterprise: Dollar Tree (100% of continuing operations revenue).
- Key geographies: United States (48 contiguous states) and Canada (seven provinces).
- Business model type: Asset-heavy brick-and-mortar retail. The company relies on a massive physical footprint (over 9,200 stores) and a highly optimised supply chain and distribution network.
- Competitive position: Operates in a duopoly-like structure in the extreme value retail sector alongside Dollar General, though Dollar Tree's historical fixed-price point (now multi-price) and suburban/mall-adjacent footprint differentiates it from Dollar General's rural focus.
- Recent major events: In July 2025, Dollar Tree completed the sale of its underperforming Family Dollar segment for approximately $1 billion to Brigade Capital Management and Macellum Capital Management. The company also transitioned its CEO to Mike Creedon in late 2024 and aggressively rolled out its "Dollar Tree 3.0" multi-price format (items priced at $1.25, $3, $4, and $5) to over 5,300 stores by the end of FY2025.
The downloadable Dollar Tree 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 & AssumptionsDollar Tree financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $26.31B | $15.41B | $16.77B | $17.57B | $19.40B |
| Gross profit | $7.73B | $5.78B | $6.01B | $6.28B | $7.05B |
| Operating income | $1.81B | $2.10B | $1.77B | $1.46B | $1.65B |
| Net income | $1.33B | $1.62B | -$998.4M | -$3.03B | $1.28B |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Dollar Tree
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Dollar Tree Segment (Continuing Operations)
- Segment name: Dollar Tree
- Revenue driver formula: `(Beginning Store Count + New Stores - Closed Stores) x Average Revenue per Store` OR modelled via `Prior Year Revenue x (1 + Same-Store Sales Growth) + (Net New Stores x Average First-Year Store Revenue)`.
- Historical growth rate: 5% to 10.4% (FY2025 net sales grew 10.4% to $19.4 billion).
- Key growth levers and headwinds: The primary growth lever is the rollout of the multi-price format (driving average ticket size) and the opening of ~400 new stores annually. Headwinds include consumer macroeconomic pressure, potential tariff increases on imported goods, and traffic declines (traffic declined 1.2% in Q4 2025 despite a 6.3% increase in average ticket).
- Pricing dynamics: Historically fixed at $1.00, then $1.25. Now transitioning to a multi-price model ($1.25 to $5.00) to offset inflation and expand the merchandise assortment (e.g., frozen proteins, larger pack sizes).
- Revenue recognition notes: Recognised at the point of sale when the customer takes possession of the merchandise. Negligible deferred revenue.
- Seasonality: Q4 (ending January) is historically the strongest quarter due to Halloween, Thanksgiving, and Christmas seasonal merchandise, driving disproportionate operating profit.
Cost Structure
Variable Costs / COGS
- Line-by-line breakdown: Merchandise costs, inbound domestic and import freight, distribution centre costs, shrink (inventory theft/loss), and markdowns.
- Gross margin range: 30.0% to 39.1% (expanded significantly in late FY2025 to 39.1% in Q4 due to multi-price mark-on and lower freight costs).
- Key input costs and commodity exposures: Ocean freight rates (transpacific), diesel fuel (domestic trucking), and Chinese import tariffs (highly exposed to imported seasonal and party goods).
- How COGS scales with revenue: Generally linear, but gross margin percentage expands when average ticket increases (multi-price strategy) because fixed distribution costs are leveraged over higher revenue per item.
Operating Expenses
- R&D: N/A (not material for retail).
- SG&A: Store payroll and benefits, occupancy costs (rent, utilities, maintenance), general liability claims, and corporate overhead. Runs at approximately 28.1% to 28.6% of total revenue.
- Depreciation & Amortisation: Typically 3.0% to 3.5% of revenue, driven by store build-outs and distribution centre investments.
- Stock-Based Compensation: Less than 0.5% of revenue; standard corporate retention grants.
- Restructuring / one-time charges: Frequent in recent years due to the Family Dollar strategic review, software termination costs, and distribution centre tornado damage (e.g., Marietta, OK facility).
Margin Profile
- Gross margin: 35.0% - 39.0% (trending upward due to multi-price strategy).
- EBITDA margin: 11.0% - 13.0%.
- Operating margin: 7.0% - 8.5% (FY2025 operating margin was 8.5%).
- Net margin: 5.5% - 6.5%.
- Margin trend: Expanding. The divestiture of the dilutive Family Dollar segment and the success of the $3-$5 price points have structurally lifted the consolidated margin profile.
Balance Sheet Structure
- Total assets: Approximately $15 - $18 billion (post-divestiture).
- Key asset categories: Merchandise Inventories (massive component, typically $3B+), Property, Plant and Equipment (distribution centres and store fixtures), and Operating Lease Right-of-Use Assets.
- Goodwill & intangibles as % of total assets: Historically high due to the 2015 Family Dollar acquisition, but significantly reduced following the 2025 divestiture and associated impairment charges.
- Working capital profile:
- Days Sales Outstanding (DSO): ~0-2 days (cash and credit card retail business).
- Days Inventory Outstanding (DIO): 80 - 95 days (imports require long lead times).
- Days Payable Outstanding (DPO): 50 - 65 days.
- Net working capital as % of revenue: Typically low or slightly negative.
- Is working capital positive or negative? The company benefits from a negative cash conversion cycle on domestic goods, funding growth through accounts payable, though import inventory requires earlier cash outlay.
- PP&E: Store leasehold improvements, fixtures, point-of-sale systems, and owned distribution centres. Depreciated over 3-15 years for fixtures, up to 39 years for buildings.
- Right-of-use assets / operating leases: Highly material. The company leases almost all of its 9,200+ stores, resulting in billions of ROU assets and corresponding lease liabilities on the balance sheet.
Capital Expenditure & Investment
- Capex as % of revenue: 4.5% - 5.5%.
- Maintenance capex vs. growth capex: Approximately 40% maintenance (IT, supply chain, store refreshes) and 60% growth (new store openings, multi-price format conversions).
- Major capex programmes underway or planned: Converting the remaining store fleet to the "Dollar Tree 3.0" multi-price format and opening ~400 new stores annually.
- Capitalised software / development costs: Minimal, though recent software termination costs indicate IT infrastructure transitions.
- M&A pattern: Historically transformational (Family Dollar in 2015), but currently in a divestiture and organic growth phase. No major acquisitions expected in the near term.
Debt & Capital Structure
- Total debt: Approximately $3.0 - $3.5 billion in long-term debt (excluding operating lease liabilities).
- Debt/EBITDA ratio: ~1.5x - 2.0x (Investment grade profile).
- Credit rating: BBB (S&P) / Baa2 (Moody's).
- Key debt instruments: Senior unsecured notes with staggered maturities, and an undrawn revolving credit facility.
- Interest rate profile: Primarily fixed-rate senior notes. Weighted average cost of debt is approximately 4.0% - 4.5%.
- Share repurchase programme: Highly active. Repurchased $1.6 billion in FY2025. Has $1.8 billion remaining under authorization as of January 2026.
- Dividend policy: The company does not pay a regular cash dividend, preferring to return capital via share repurchases.
Cash Flow Characteristics
- Operating cash flow conversion: Strong. OCF is typically 1.5x - 1.8x Net Income (FY2025 generated $2.2B OCF from continuing operations on ~$1.2B Net Income).
- Free cash flow margin: 5.0% - 6.0% (FY2025 FCF was $1.1 billion on $19.4 billion in revenue).
- Major non-cash items: Depreciation & amortisation, stock-based compensation, and deferred income taxes.
- Working capital cash flow impact: Inventory build-ups for the multi-price rollout have been a use of cash, but steady-state working capital is relatively neutral.
- Capex intensity: Moderate. Store build-outs are relatively cheap compared to big-box retail, allowing for high ROIC on new stores.
- Cash tax rate vs. GAAP effective tax rate: Effective tax rate is ~24.3% to 24.8%. Cash taxes closely track GAAP taxes.
Sheet Structure
- Assumptions: Hardcoded drivers for store counts, SSSG, margins, tax rate, and capital returns.
- Scenarios: Base, Bull, and Bear cases toggling SSSG, tariff impacts on gross margin, and share repurchase volumes.
- Store Roll-Forward: Beginning stores, openings (400/year), closings (75/year), ending stores, and multi-price conversion tracking.
- Income Statement: Revenue, COGS, Gross Profit, SG&A, D&A, Operating Income, Interest Expense, Tax, Net Income. (Must explicitly exclude Family Dollar discontinued ops).
- Balance Sheet: Cash, Inventory, Other Current Assets, PP&E, ROU Assets, Accounts Payable, Current Lease Liabilities, Long-Term Debt, Long-Term Lease Liabilities, Equity.
- Cash Flow Statement: Net Income, D&A, WC changes, OCF, Capex, FCF, Debt issuance/repayment, Share repurchases, Ending Cash.
- Working Capital Schedule: DSO, DIO, DPO calculations driving the balance sheet and cash flow statement.
- Debt & Interest Schedule: Tranches of senior notes, revolver balance, interest expense calculation, and debt paydown logic.
- Depreciation & Capex: Capex modeled as % of revenue or per-store cost; D&A waterfall.
- DCF Valuation: Unlevered free cash flow, WACC calculation, terminal value (Gordon Growth), and implied share price.
Key Financial Relationships
- `Ending Store Count = Beginning Store Count + New Store Openings - Store Closings`
- `Same-Store Sales Growth (SSSG) = Traffic Growth % + Average Ticket Growth %`
- `Total Net Sales = Prior Year Net Sales x (1 + SSSG) + (Net New Stores x Average Revenue per Store)`
- `Gross Profit = Total Net Sales x Gross Margin %` (Modelled at 38.0% - 39.0% for continuing ops).
- `SG&A Expense = Total Net Sales x SG&A %` (Modelled at ~28.1%).
- `Operating Income = Gross Profit - SG&A Expense - D&A`
- `Ending Inventory = (COGS / 365) x DIO`
- `Accounts Payable = (COGS / 365) x DPO`
- `Free Cash Flow = Operating Cash Flow - Capital Expenditures`
- `Shares Outstanding = Prior Shares Outstanding - (Share Repurchase $ / Average Share Price)`
Cross-Sheet Dependencies
- The Store Roll-Forward sheet drives the revenue calculations on the Income Statement.
- The Income Statement generates Net Income, which is the starting point for the Cash Flow Statement.
- The Working Capital Schedule uses Revenue and COGS from the Income Statement to calculate balance sheet line items (Inventory, AP), the changes of which feed into the Cash Flow Statement.
- The Debt & Interest Schedule calculates Interest Expense for the Income Statement and requires operating cash flow from the Cash Flow Statement to determine if the revolver needs to be drawn. (Potential circularity here if interest expense reduces net income, which reduces cash flow, which increases revolver draw, which increases interest expense. Break with a circularity toggle).
- The DCF Valuation pulls Unlevered Free Cash Flow (NOPAT + D&A - Capex - Change in NWC) from the Income Statement and Cash Flow Statement.
Sign Convention
- Income Statement: Revenues are positive. Expenses (COGS, SG&A, Interest, Taxes) are positive numbers, subtracted in subtotal formulas (e.g., `Gross Profit = Revenue - COGS`).
- Balance Sheet: All assets, liabilities, and equity balances are positive.
- Cash Flow Statement: Cash inflows are positive. Cash outflows (Capex, share repurchases, debt paydowns) are negative.
- Working Capital: An increase in an asset (e.g., Inventory) is a negative adjustment to cash flow. An increase in a liability (e.g., Accounts Payable) is a positive adjustment to cash flow.
Things Most Likely to Go Wrong
- Discontinued Operations Contamination: The builder might accidentally use historical consolidated financials that include Family Dollar. The model MUST use "Continuing Operations" data only (Dollar Tree segment + corporate) for historicals to ensure comparability.
- General Liability Claims: Dollar Tree experiences high volatility in SG&A due to general liability claims (e.g., a $0.30 EPS hit in Q2 2024). The model should normalise this in adjusted figures.
- Tariff Sensitivity: Gross margin is highly sensitive to Chinese import tariffs. The model should include a scenario toggle for tariff increases, which would compress gross margin by 50-150 bps if unmitigated.
- Traffic vs. Ticket Divergence: SSSG is currently driven entirely by average ticket (price increases), while traffic is negative (-1.2% in Q4 2025). Extrapolating SSSG without separating these drivers will mask underlying footfall issues.
- Lease Accounting (ASC 842): The balance sheet must balance with massive ROU assets and Lease Liabilities. Changes in store counts must flow through to lease liability amortisation.
- Share Count Reduction: The company repurchased $1.6B in stock in FY2025. Failing to model ongoing share repurchases will severely understate EPS growth.
- Freight Cost Reversals: Gross margin expanded 150 bps in Q4 2025 largely due to lower freight costs. This is a cyclical benefit; the model should not assume freight margins expand indefinitely.
- 53rd Week Adjustments: Retailers occasionally have a 53-week fiscal year. Ensure growth rates are adjusted for 52-week comparable periods.
Validation Checks
- "Gross margin should be in the 35.0% - 39.5% range; flag if outside this band (reflects post-Family Dollar margin profile)."
- "SG&A as a % of revenue should be between 27.5% and 29.0%; flag if outside."
- "Operating margin should stabilise between 7.5% and 9.0%."
- "Free Cash Flow conversion (FCF / Net Income) should be > 80%."
- "Debt/EBITDA should remain below 2.5x to maintain investment-grade rating."
- "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period."
- "Implied share price from DCF should be compared against the current trading range ($110 - $140) to check for logic errors."
- "Store count growth should not exceed 500 per year without triggering a capex warning."
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| FY26 Net Sales Growth | 3.5 | % | Midpoint of management's FY26 guidance (3% - 4% SSSG). |
| New Store Openings | 400 | Stores | Management guidance for FY26. |
| Store Closings | 75 | Stores | Management guidance for FY26. |
| Gross Margin | 38.5 | % | Reflects Q4 2025 exit rate (39.1%) normalised for full-year seasonality. |
| SG&A Margin | 28.1 | % | Based on FY2025 adjusted continuing operations run-rate. |
| Effective Tax Rate | 24.5 | % | Blended average of FY2025 adjusted tax rate (24.3% - 24.8%). |
| Capex as % of Revenue | 5.0 | % | Historical average required to fund 400 new stores and multi-price conversions. |
| Days Inventory Outstanding | 85 | Days | Standard retail import supply chain requirement. |
| Days Payable Outstanding | 55 | Days | Historical average based on vendor terms. |
| Annual Share Repurchases | 1,000 | $ Millions | Conservative run-rate based on $1.6B actual in FY25 and $1.8B remaining auth. |
| Average Interest Rate | 4.5 | % | Weighted average cost of existing fixed-rate senior notes. |
| WACC | 8.0 | % | Standard discount rate for large-cap consumer staples/retail. |
| Terminal Growth Rate | 2.0 | % | Long-term inflation and GDP growth proxy. |
Data Sources & Benchmarks
- Filings: SEC EDGAR (Dollar Tree, Inc. Form 10-K, 10-Q, 8-K).
- Investor Relations: https://corporate.dollartree.com/investors
- Key Peers for Benchmarking: Dollar General (DG), Ollie's Bargain Outlet (OLLI), Five Below (FIVE), Walmart (WMT).
- Industry Data Sources: Placer.ai (for retail foot traffic data), Freightos Baltic Index (for ocean freight cost benchmarking), U.S. Census Bureau Advance Monthly Retail Trade Report.
- Consensus Estimates: FactSet or Bloomberg for forward EPS and revenue estimates to validate model outputs against the Street.
Sources
- Dollar Tree, Inc. Q4 and Full Year 2025 Earnings Release (March 16, 2026).
- Dollar Tree, Inc. Q3 2025 Earnings Release (December 3, 2025).
- Dollar Tree, Inc. Q2 2025 Earnings Release (September 3, 2025).
- SEC Form 8-K filings regarding the sale of Family Dollar to Brigade Capital Management and Macellum Capital Management (Announced Q1 2025, closed July 2025).
- Stock Titan: "Dollar Tree delivers 2025 revenue growth and higher EPS with robust guidance" (March 16, 2026).
Do more with the Dollar Tree model
Frequently asked
What is Dollar Tree's core business model after the Family Dollar divestiture?+
Dollar Tree operates as a leading North American discount variety store chain, offering a wide range of everyday merchandise, seasonal goods, and party supplies. Following the July 2025 sale of Family Dollar, it now functions as a single-segment enterprise focused on its Dollar Tree brand, implementing a multi-price strategy across its extensive physical footprint.
How does Dollar Tree generate revenue, and what drives its sales growth?+
Dollar Tree generates revenue through the sale of merchandise in its over 9,200 brick-and-mortar stores across the United States and Canada. Sales growth is primarily driven by new store openings, the conversion of existing stores to the 'Dollar Tree 3.0' multi-price format, and continuous optimization of its supply chain.
What is Dollar Tree's capital expenditure strategy, and what percentage of revenue does it represent?+
Dollar Tree's capital expenditure (Capex) is projected to be between 4.5% and 5.5% of its revenue. Approximately 60% of this Capex is allocated to growth initiatives such as new store openings and multi-price format conversions, while the remaining 40% covers maintenance for IT, supply chain, and store refreshes.
What are the key cost assumptions in Dollar Tree's financial model?+
Key cost assumptions in Dollar Tree's financial model include Cost of Goods Sold (COGS) at approximately 67.4% of revenue and Selling, General & Administrative (SGA) expenses at about 23.6% of revenue. These figures reflect the significant operational costs inherent in its asset-heavy retail business model.
What is the purpose of the Dollar Tree financial model, and what does it assess?+
The Dollar Tree financial model is designed to evaluate the standalone equity valuation and cash flow generation capacity of the company. It allows an equity analyst to assess the earnings power and margin expansion potential of the core 'Dollar Tree 3.0' multi-price strategy following the divestiture of Family Dollar.
Can I download an Excel financial model for Dollar Tree, and what is its forecast horizon?+
Yes, an Excel financial model for Dollar Tree is available for download. This model provides a forecast horizon spanning from fiscal year 2026 through fiscal year 2030, offering a comprehensive outlook on the company's future financial performance.
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 Retail Company Financial Models
Browse another company in the same sector.
Best Buy
Best Buy is a leading multinational consumer electronics retailer providing technology products, services, and solutions.
Costco
Costco Wholesale Corporation operates an international chain of membership warehouses that offer high-quality, brand-name merchandise at substantially lower prices than are typically found at conventional wholesale or retail sources.
Dollar General
Dollar General is the largest discount retailer in the United States by store count, operating over 20,500 small-box stores primarily in rural and suburban markets.
Home Depot
The Home Depot is the world's largest home improvement retailer, selling building materials, home improvement products, lawn and garden products, and decor.
Kroger
Kroger operates supermarkets, multi-department stores, and fulfillment centres across the United States, manufacturing and processing a significant portion of the food sold in its stores.
Lowe's
Lowe's is the second-largest home improvement retailer in the world, serving both DIY homeowners and professional customers with products for maintenance, repair, remodelling, and decorating.
Pool
Pool Corporation is the world's largest wholesale distributor of swimming pool supplies, equipment, and related leisure products.
Ross Stores
Ross Stores is the largest off-price apparel and home fashion chain in the United States, purchasing first-quality, in-season, name-brand, and designer merchandise at discounts and passing the savings to consumers through its Ross Dress for Less and dd's DISCOUNTS banners.
Explore more Consumer financial model templates.
