Ross Stores logo
Ross Stores Financial Model

Retail Company Financials Example (Free Excel Download)

Ross Stores, Inc. is the largest off-price apparel and home fashion chain in the United States.

Loading...

Used by professionals from

KPMG logoWharton logoColumbia logoESSEC logoPwC logoHEC logo

About this model

This model provides a comprehensive three-statement forecast and discounted cash flow valuation for Ross Stores, Inc. to help an equity research analyst determine the intrinsic value of the shares and assess the impact of new store rollouts and comparable store sales growth on operating leverage.

Ross Stores, Inc. is the largest off-price apparel and home fashion chain in the United States. The company purchases first-quality, in-season, name-brand, and designer merchandise at significant discounts and passes the savings (20% to 70% off regular prices) to consumers.

  • Business segments: The company operates as a single reportable segment, but manages two distinct retail banners: Ross Dress for Less (approximately 84% of total stores) and dd's DISCOUNTS (approximately 16% of total stores).
  • Key geographies: 100% United States and its territories (Guam, Puerto Rico).
  • Business model type: Asset-heavy brick-and-mortar retail. The company relies on a physical store network and a massive distribution infrastructure to process opportunistic inventory purchases.
  • Competitive position: Ross is the second-largest off-price retailer globally behind The TJX Companies, and competes directly with TJX (T.J. Maxx, Marshalls) and Burlington Stores.
  • Recent major events: The company completed a $2.1 billion share repurchase programme across fiscal 2024 and 2025 and authorised a new $2.55 billion programme for fiscal 2026 and 2027. Fiscal 2023 included a 53rd week which impacted year-over-year comparability for fiscal 2024.

The downloadable Ross Stores 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 & AssumptionsRoss Stores financial model

Source: SEC EDGAR · values in USD

Line itemFY2021FY2022FY2023FY2024FY2025
Revenue$18.92B$18.70B$20.38B$21.13B$22.75B
Gross profit$5.21B$4.75B$5.58B$5.87B$6.30B
Cost of goods sold$13.71B$13.95B$14.80B$15.26B$16.45B
Net income$1.72B$1.51B$1.87B$2.09B$2.15B

Forecast assumptions

Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.

Revenue growth
6.2%
COGS % of revenue
74.0%
R&D % of revenue
0.0%
SG&A % of revenue
16.1%
D&A % of revenue
2.2%
Effective tax rate
22.9%
See 8 more
Capex % of revenue
3.4%
Net working capital % of revenue
14.1%
Other assets % of revenue
16.5%
Other liabilities % of revenue
41.2%
Annual debt paydown
5.0%
Interest rate on debt
4.5%
Dividend payout ratio
43.5%
Buybacks % of net income
76.6%

How to build a detailed financial model for Ross Stores

A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.

Revenue Deep Dive

Ross Stores reports consolidated net sales, but models must build revenue from the ground up using store counts and comparable store sales.

  • Segment name: Consolidated Net Sales.
  • Revenue driver formula: (Beginning Store Count + New Stores - Closed Stores) x Average Sales per Store. Alternatively, modelled as: Prior Year Sales x (1 + Comparable Store Sales Growth) + Non-Comparable Sales from New Stores.
  • Historical growth rate: 3% to 8% annually (Fiscal 2024 was 3%, Fiscal 2025 was 8% reaching $22.75 billion).
  • Key growth levers and headwinds: The primary growth levers are new store openings (targeting 2,900 Ross and 700 dd's DISCOUNTS locations long-term) and driving foot traffic to increase comparable store sales. Headwinds include freight costs, wage inflation, and macroeconomic pressures on their core low-to-moderate income demographic.
  • Pricing dynamics: Highly competitive. Ross prices merchandise 20% to 60% below department stores (up to 70% for dd's DISCOUNTS). Pricing power is limited by the need to maintain this strict value proposition.
  • Revenue recognition notes: Revenue is recognised at the point of sale in stores. Returns are estimated and recorded as a reduction to revenue.
  • Seasonality: The fourth quarter (holiday season) is historically the strongest, driving a disproportionate share of annual sales and operating profit.

Cost Structure

Variable Costs / COGS

  • Line-by-line breakdown: Cost of Goods Sold includes the direct cost of merchandise, freight, distribution centre costs, and buying expenses. Notably, occupancy costs (store rent, depreciation, utilities) are also included in COGS for Ross Stores.
  • Gross margin range: 26.0% to 29.0% (Fiscal 2025 was approximately 27.7%).
  • Key input costs and commodity exposures: Ocean and domestic freight rates, raw apparel costs, and distribution centre wage rates.
  • How COGS scales with revenue: Generally linear, but buying and distribution costs exhibit slight operating leverage when comparable store sales exceed 3%.

Operating Expenses

  • R&D: Not applicable.
  • SG&A: Selling, General, and Administrative expenses primarily consist of store payroll, benefits, advertising, and corporate overhead. It typically runs at 15.0% to 16.5% of sales.
  • Depreciation & Amortisation: Included within COGS (for store and distribution assets) and SG&A (for corporate assets). Total D&A is roughly 2.5% to 3.0% of sales.
  • Stock-Based Compensation: Typically 0.3% to 0.5% of sales.
  • Restructuring / one-time charges: Rare, though the company occasionally records gains on the sale of facilities (e.g., a $0.14 per share gain from a packaway facility sale in fiscal 2024).

Margin Profile

  • Gross margin: 26.0% to 29.0%.
  • Operating margin: 11.0% to 12.5% (Fiscal 2025 was 11.9%).
  • Net margin: 8.5% to 9.5% (Fiscal 2025 was 9.4%).
  • Margin trend: Stable to slightly expanding as freight pressures from previous years subside, offset by wage investments.

Balance Sheet Structure

  • Total assets: Approximately $13 billion to $14 billion.
  • Key asset categories: Merchandise Inventory, Operating Lease Right-of-Use Assets, and Property and Equipment.
  • Goodwill & intangibles: Negligible. Ross grows organically, not through acquisitions.
  • Working capital profile:
  • Days Sales Outstanding (DSO): Near zero (retail cash/credit card business).
  • Days Inventory Outstanding (DIO): 65 to 75 days. Inventory is elevated due to the "packaway" strategy where Ross buys excess inventory and stores it for later seasons (packaway is roughly 40% of total inventory).
  • Days Payable Outstanding (DPO): 60 to 70 days.
  • Net working capital: Typically negative or near zero, providing a source of cash as the business grows.
  • PP&E: Consists of distribution centres, store fixtures, and IT equipment. Useful lives are typically 3 to 10 years for fixtures and up to 40 years for owned buildings.
  • Right-of-use assets: Highly material. Ross leases almost all of its retail locations, resulting in billions of dollars in ROU assets and corresponding lease liabilities.

Capital Expenditure & Investment

  • Capex as % of revenue: 3.0% to 4.0%.
  • Maintenance capex vs. growth capex: Approximately 40% maintenance (store remodels, IT upgrades) and 60% growth (new stores, new distribution centres).
  • Major capex programmes: Building out the distribution network to support the long-term target of 3,600 total stores.
  • Capitalised software: Minor relative to physical infrastructure.
  • M&A pattern: Strictly organic growth. Zero M&A activity.

Debt & Capital Structure

  • Total debt: Approximately $2.4 billion in senior notes, plus significant operating lease liabilities.
  • Debt/EBITDA ratio: Very low, typically under 1.0x (excluding operating leases).
  • Credit rating: Investment grade (A- / Baa1 equivalent).
  • Key debt instruments: Fixed-rate senior notes with staggered maturities.
  • Maturity profile: Well-laddered over the next decade.
  • Interest rate profile: Predominantly fixed rate.
  • Covenants: Standard investment-grade financial covenants; highly compliant.
  • Share repurchase programme: Highly active. The company repurchased $1.05 billion in fiscal 2025 and has a new $2.55 billion authorisation for fiscal 2026 and 2027.
  • Dividend policy: Consistent dividend payer and grower. The quarterly dividend was recently raised 10% to $0.445 per share.

Cash Flow Characteristics

  • Operating cash flow conversion: Very strong, typically 1.2x to 1.4x Net Income (Fiscal 2025 OCF was $3.03 billion on $2.15 billion Net Income).
  • Free cash flow margin: 7.0% to 9.0% of sales.
  • Major non-cash items: Depreciation and amortisation, stock-based compensation, and operating lease expense amortisation.
  • Working capital cash flow impact: Favourable. Because DPO closely matches DIO and DSO is zero, new store inventory is largely funded by vendors.
  • Capex intensity: Moderate (3% to 4% of sales).
  • Cash tax rate: Closely mirrors the GAAP effective tax rate of approximately 23% to 25%.

Sheet Structure

  1. Assumptions: Hardcoded drivers for store growth, comparable sales, margins, and working capital days.
  2. Store Roll-Forward: Tracks beginning store count, openings, and closings separately for Ross Dress for Less and dd's DISCOUNTS.
  3. Income Statement: Revenue built from store metrics, COGS (including occupancy), Gross Profit, SG&A, EBIT, Interest, Taxes, and Net Income.
  4. Balance Sheet: Assets (Cash, Inventory, Other Current, PP&E, ROU Assets), Liabilities (Accounts Payable, Lease Liabilities, Long-Term Debt), and Equity.
  5. Cash Flow Statement: Net Income, D&A, Working Capital changes, Capex, Dividends, Share Repurchases, and Debt issuance/repayment.
  6. Debt Schedule: Tranches of senior notes, interest expense calculation, and debt paydown schedule.
  7. Working Capital Schedule: Calculation of Inventory, Accounts Payable, and accrued expenses based on days outstanding.
  8. DCF Valuation: Unlevered free cash flow build, WACC calculation, terminal value, and implied share price.

Key Financial Relationships

  1. `Ross Stores EOP = Ross Stores BOP + Ross Stores Openings - Ross Stores Closings`
  2. `dd's DISCOUNTS EOP = dd's DISCOUNTS BOP + dd's DISCOUNTS Openings - dd's DISCOUNTS Closings`
  3. `Total Store Count = Ross Stores EOP + dd's DISCOUNTS EOP`
  4. `Average Stores Open = (Total Store Count BOP + Total Store Count EOP) / 2`
  5. `Consolidated Net Sales = Prior Year Net Sales x (1 + Comparable Store Sales Growth) + (New Stores x Average First Year Sales per Store)`
  6. `Cost of Goods Sold = Consolidated Net Sales x (1 - Gross Margin %)`
  7. `SG&A Expense = Consolidated Net Sales x SG&A Margin %`
  8. `Operating Income (EBIT) = Consolidated Net Sales - Cost of Goods Sold - SG&A Expense`
  9. `Ending Inventory = (Cost of Goods Sold / 365) x Days Inventory Outstanding`
  10. `Ending Accounts Payable = (Cost of Goods Sold / 365) x Days Payable Outstanding`
  11. `Interest Expense = Average Long-Term Debt x Weighted Average Interest Rate`
  12. `Share Count = Prior Period Share Count - (Share Repurchase Amount / Average Share Price)`

Cross-Sheet Dependencies

  • The Store Roll-Forward sheet dictates the revenue growth on the Income Statement.
  • The Income Statement generates Net Income, which flows to the top of the Cash Flow Statement and feeds Retained Earnings on the Balance Sheet.
  • The Working Capital Schedule uses COGS and Sales from the Income Statement to calculate balance sheet line items, and the period-over-period changes flow to the Cash Flow Statement.
  • The Debt Schedule calculates Interest Expense for the Income Statement and ending debt balances for the Balance Sheet.
  • The Cash Flow Statement calculates the ending cash balance, which serves as the plug to balance the Balance Sheet.

Sign Convention

  • Income Statement: Revenue is positive. Expenses (COGS, SG&A, Interest, Taxes) are negative.
  • Balance Sheet: Assets are positive. Liabilities and Equity are positive.
  • Cash Flow Statement: Cash inflows (Net Income, D&A, increases in liabilities) are positive. Cash outflows (Capex, dividends, share repurchases, increases in assets) are negative.
  • Formulas: Gross Profit = Revenue + COGS (since COGS is negative). EBIT = Gross Profit + SG&A (since SG&A is negative).

Things Most Likely to Go Wrong

  1. Packaway Inventory Distortion: Ross holds roughly 40% of its inventory in "packaway" storage. This makes DIO look artificially high compared to peers. The model must maintain a high DIO assumption (65-75 days) rather than reverting to standard retail averages.
  2. Occupancy in COGS: Ross includes store occupancy costs in COGS. If a builder models rent in SG&A, Gross Margin will be overstated by 400-500 basis points.
  3. 53rd Week Adjustments: Fiscal 2023 had 53 weeks, adding $308 million in sales. Growth rates for Fiscal 2024 look artificially low unless adjusted for this extra week.
  4. Operating Lease Liabilities: ROU assets and lease liabilities are massive. The model must ensure that the amortisation of ROU assets is handled correctly in the cash flow statement to avoid breaking the balance sheet.
  5. Share Count Circularity: Share repurchases reduce the share count, which increases EPS, which impacts the share price, which dictates how many shares can be bought with a fixed dollar amount. Use a hardcoded average share price for the forecast to break the loop.
  6. Store Count Mix: dd's DISCOUNTS stores generate lower average unit volumes than Ross Dress for Less stores. If the mix of new store openings skews heavily towards dd's, total revenue growth will lag total store count growth.
  7. Freight Cost Volatility: Gross margin is highly sensitive to ocean freight rates. A static gross margin assumption might miss cyclical margin compression or expansion.
  8. Cash Flow Plug: Because working capital is a source of cash, rapid store expansion generates cash rather than consuming it. Ensure the cash flow statement correctly captures the positive impact of Accounts Payable growth.

Validation Checks

  1. "Gross margin should be in the 26.0% to 29.0% range; flag if outside this band."
  2. "Operating margin should be between 11.0% and 12.5%; flag if outside this band."
  3. "Capex as a percentage of revenue should run between 3.0% and 4.0%."
  4. "Total store count additions should not exceed 100-110 per year based on management guidance."
  5. "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period."
  6. "Free Cash Flow margin should be positive and in the 7.0% to 9.0% range."
  7. "Effective tax rate should remain between 23.0% and 25.0%."
  8. "Dividend payout ratio should remain between 25.0% and 30.0% of Net Income."

Key Assumptions (Default Values)

AssumptionDefault ValueUnitRationale
Comparable Store Sales Growth3.5%Midpoint of management's long-term 3-4% guidance.
Ross Dress for Less Gross Openings75StoresBased on historical run-rate and 2,900 long-term target.
dd's DISCOUNTS Gross Openings25StoresBased on historical run-rate and 700 long-term target.
Gross Margin27.8%Aligns with Fiscal 2025 actuals.
SG&A Margin15.8%Historical average required to reach ~12% operating margin.
Days Inventory Outstanding (DIO)70DaysReflects heavy packaway inventory strategy.
Days Payable Outstanding (DPO)65DaysHistorical average; vendors fund the majority of inventory.
Capex as % of Sales3.5%Required to fund 100 new stores and distribution network.
Effective Tax Rate24.0%Standard US corporate rate plus state taxes.
Annual Share Repurchases1,275$ MillionsHalf of the new $2.55B two-year authorisation.
Quarterly Dividend per Share0.445$Actual declared dividend for Q1 Fiscal 2026.
Weighted Average Interest Rate4.5%Blended rate on existing senior notes.
WACC8.5%Standard cost of capital for a mature, low-beta retailer.
Terminal Growth Rate2.0%Long-term inflation and GDP growth proxy.

Data Sources & Benchmarks

  • Filings: SEC EDGAR (Form 10-K, 10-Q, 8-K) and the Ross Stores Investor Relations website (investors.rossstores.com).
  • Key peers for benchmarking: The TJX Companies (TJX), Burlington Stores (BURL), Nordstrom Rack (JWN).
  • Industry data sources: National Retail Federation (NRF) for apparel retail trends, Placer.ai for foot traffic data, and Freightos Baltic Index for ocean freight costs.
  • Consensus estimates source: FactSet or Bloomberg for forward-looking EPS and comparable store sales estimates.

Sources

Frequently asked

What is Ross Stores' business model?+

Ross Stores operates as the largest off-price apparel and home fashion chain in the U.S., purchasing name-brand merchandise at significant discounts and passing those savings (20% to 70% off) to consumers. The company manages two retail banners, Ross Dress for Less and dd's DISCOUNTS, primarily through an asset-heavy brick-and-mortar network across the United States.

How does Ross Stores generate its revenue?+

Ross Stores generates revenue primarily through consolidated net sales from its physical store network, driven by new store openings and comparable store sales growth. Revenue can be modeled by multiplying the total store count by average sales per store, or by adjusting prior year sales for comparable store growth and adding non-comparable sales from new locations.

What are the key assumptions for Ross Stores' capital expenditures in a financial model?+

The financial model for Ross Stores assumes capital expenditures (Capex) as a percentage of revenue to be approximately 3.38%. This Capex is split, with roughly 40% allocated to maintenance activities like store remodels and IT upgrades, and 60% dedicated to growth initiatives such as new store rollouts and expanding distribution centers.

What is the purpose of the Ross Stores financial model?+

The Ross Stores financial model provides a comprehensive three-statement forecast and discounted cash flow (DCF) valuation to help equity research analysts determine the intrinsic value of its shares. It also assesses how new store rollouts and comparable store sales growth impact the company's operating leverage.

Can I download an Excel financial model for Ross Stores?+

Yes, a downloadable Excel financial model for Ross Stores is available, offering a forecast horizon from FY2026 to FY2030. This general corporate model provides detailed assumptions, including a revenue growth rate of approximately 6.17%, to aid in financial analysis.

How does Ross Stores' working capital strategy impact its cash flow?+

Ross Stores typically maintains negative or near-zero net working capital, which serves as a source of cash as the business expands. This profile is influenced by a high inventory level due to its "packaway" strategy, where packaway is roughly 40% of total inventory, and near-zero Days Sales Outstanding from its cash/credit card business.

Have more financial modelling questions? Contact us

Alex Tapio, ex-Deloitte financial modelling expert

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.

BBY.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Best Buy logo

Best Buy

Best Buy is a leading multinational consumer electronics retailer providing technology products, services, and solutions.

COST.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Costco logo

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.

DG.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Dollar General logo

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.

DLTR.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Dollar Tree logo

Dollar Tree

Dollar Tree is a leading North American operator of discount variety stores, offering a wide range of everyday merchandise, seasonal goods, and party supplies across the United States and Canada.

HD.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Home Depot logo

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.

KR.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Kroger logo

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.

LOW.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Lowe's logo

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.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Pool logo

Pool

Pool Corporation is the world's largest wholesale distributor of swimming pool supplies, equipment, and related leisure products.

Explore more Consumer financial model templates.

Go further

Build the financial model you need with Fina

Browse templates, examples, and downloadable Excel models for the analysis you are trying to build. If you can't find your model, ask Fina to build a model for your specific needs.

Start for free
Excel financial model spreadsheet preview showing Customer Rollforward
Fina interactive chat interface preview