skills/bigdata-sector-playbook/references/consumer-retail.md

# Consumer and Retail Sector Reference

## Sector Overview

The consumer and retail sector encompasses companies selling goods directly to consumers through physical stores, e-commerce platforms, or hybrid models. Analysis requires understanding traffic patterns, inventory dynamics, channel economics, and consumer spending behavior.

Key subsectors include:
- Specialty Retail (apparel, electronics, home goods)
- Broadline Retail (mass merchants, department stores)
- Grocery and Staples
- E-commerce and Direct-to-Consumer
- Restaurants and Food Service
- Consumer Durables

## Table of Contents
1. [Critical KPIs and Benchmarks](#critical-kpis-and-benchmarks)
2. [Direct-to-Consumer Analysis](#direct-to-consumer-analysis)
3. [Common Modeling Pitfalls](#common-modeling-pitfalls)
4. [Valuation Framework](#valuation-framework)

## Critical KPIs and Benchmarks

### Comparable Store Sales (Comps)

Comps measure sales growth at stores open for at least one year (typically 13 months). This metric isolates organic performance from new store contributions.

| Comp Growth | Interpretation |
|-------------|----------------|
| > 5% | Strong momentum, potential market share gains |
| 2 - 5% | Healthy growth, outpacing inflation |
| 0 - 2% | Flat, reliant on new stores for growth |
| Negative | Share loss or category weakness |

### Traffic vs. Ticket Decomposition

Decomposing comps into traffic (transactions) and ticket (average transaction value) reveals underlying health.

| Scenario | Traffic | Ticket | Interpretation |
|----------|---------|--------|----------------|
| Healthy Growth | Positive | Positive | Genuine demand expansion |
| Price-Driven | Flat/Negative | Strong Positive | Vulnerable to consumer pushback |
| Volume Weakness | Negative | Positive | Losing customers, masking with price |
| Promotional | Positive | Negative | Buying traffic, margin pressure |

Traffic-driven comps indicate stronger competitive positioning than ticket-driven comps. Sustained negative traffic with positive ticket growth signals market share erosion masked by pricing.

### Inventory Turnover

Inventory turnover varies significantly by retail category. Higher turnover indicates efficient working capital management and reduced obsolescence risk.

| Retail Category | Target Turnover | Warning Threshold |
|-----------------|-----------------|-------------------|
| Grocery | 12 - 15x | < 10x |
| Consumer Electronics | 8 - 12x | < 6x |
| Mass Merchant | 6 - 9x | < 5x |
| Apparel | 3 - 5x | < 2.5x |
| Furniture / Home | 3 - 4x | < 2x |
| Luxury | 1.5 - 2.5x | < 1x |

Track inventory turnover trends relative to sales growth. Inventory growing faster than sales signals potential markdown risk.

### Gross Margin Return on Inventory (GMROI)

GMROI measures profit generated per dollar of inventory investment.

| GMROI | Calculation | Assessment |
|-------|-------------|------------|
| > 3.0x | Gross Margin % x Inventory Turnover | Excellent capital efficiency |
| 2.0 - 3.0x | | Healthy returns |
| 1.5 - 2.0x | | Adequate but improvement needed |
| < 1.5x | | Poor inventory productivity |

GMROI below 2.0x suggests either margin pressure or excess inventory, both requiring investigation.

### Sales Per Square Foot

| Retail Format | High Performer | Average | Underperformer |
|---------------|----------------|---------|----------------|
| Luxury | > $2,000 | $1,200 - $1,800 | < $800 |
| Apple Stores | > $5,000 | N/A | N/A |
| Specialty Apparel | > $600 | $350 - $500 | < $250 |
| Department Store | > $200 | $150 - $200 | < $120 |
| Off-Price | > $400 | $300 - $400 | < $250 |

Declining sales per square foot combined with store count growth indicates overexpansion.

### Gross Margin Analysis

| Retail Format | Typical Gross Margin | Key Drivers |
|---------------|---------------------|-------------|
| Grocery | 25 - 30% | Mix, private label penetration |
| Mass Merchant | 25 - 35% | Category mix, sourcing |
| Apparel | 50 - 65% | Brand strength, full-price sell-through |
| Specialty Electronics | 25 - 35% | Services attach, category mix |
| Luxury | 60 - 75% | Brand power, exclusivity |

Monitor gross margin trajectory against promotional activity. Improving gross margin with stable comps indicates pricing power. Stable gross margin with promotional intensity suggests underlying weakness.

### Customer Acquisition Cost (CAC)

| Channel | Typical CAC Range | Consideration |
|---------|-------------------|---------------|
| Physical Retail | $5 - $30 | Lower but includes rent in SG&A |
| E-commerce (paid) | $30 - $100 | Variable by category, competitive intensity |
| E-commerce (organic) | $5 - $20 | Requires brand investment |
| DTC Brands | $40 - $150 | Often higher than projected |

Track CAC relative to customer lifetime value (LTV). Sustainable economics require LTV:CAC ratio above 3:1.

## Direct-to-Consumer Analysis

### DTC Margin Reality

**Critical Warning**: DTC channels frequently carry LOWER operating margins than wholesale despite higher gross margins. This counterintuitive reality catches many analysts.

| Margin Component | Wholesale | DTC |
|------------------|-----------|-----|
| Gross Margin | 45 - 55% | 60 - 80% |
| Fulfillment | 0% | (8 - 15%) |
| Customer Acquisition | (2 - 5%) | (15 - 30%) |
| Returns Processing | 0% | (3 - 8%) |
| Technology/Platform | 0% | (2 - 5%) |
| Customer Service | 0% | (2 - 4%) |
| **Operating Margin** | **15 - 25%** | **5 - 20%** |

### DTC Profitability Threshold

For DTC to match wholesale profitability, product gross margins typically must exceed 80%. Categories with lower gross margins often generate superior profit through wholesale despite revenue "leakage" to retail partners.

DTC profitability improves with:
- High repeat purchase rates (reducing CAC amortization)
- Low return rates (< 15%)
- Strong organic traffic (reducing paid acquisition dependency)
- Efficient logistics (owned or optimized 3PL)

### DTC Mix Interpretation

| DTC Mix | Assessment |
|---------|------------|
| > 50% | Requires proven unit economics |
| 30 - 50% | Validate margin assumptions carefully |
| 15 - 30% | Often optimal for margin and reach |
| < 15% | Wholesale-dependent, limited pricing control |

Do not assume DTC growth automatically improves margins. Model DTC segment economics separately with realistic cost assumptions.

## Common Modeling Pitfalls

### Positive Comps from Pricing Only

Mistake: Treating price-driven comp growth as equivalent to traffic-driven growth.

Reality: Price increases without volume growth indicate demand inelasticity being exploited. Consumers eventually resist or trade down. Traffic-driven comps signal genuine demand. Always decompose comps into volume and price components.

### DTC Margin Assumptions

Mistake: Assuming DTC revenue at 70% gross margin flows to 25%+ operating margin.

Reality: DTC operating costs (fulfillment, acquisition, returns, technology) often consume 40-50 percentage points of gross margin. Many DTC businesses operate at single-digit operating margins or losses despite attractive gross margins. Verify unit economics with detailed cost analysis.

### Inventory Build Interpretation

Mistake: Accepting management's "strategic inventory build" narrative at face value.

Reality: Inventory growing faster than sales growth for two or more consecutive quarters signals demand weakness. Calculate weeks of supply and compare to historical patterns. Elevated inventory typically leads to margin compression from markdowns.

### Store Count Growth Valuation

Mistake: Valuing retailers on aggressive unit growth assumptions.

Reality: New store productivity typically runs 70-85% of mature store base in year one. Cannibalization reduces mature store comps by 1-3% annually in aggressive expansion scenarios. Model new store contribution with realistic ramp curves and cannibalization adjustments.

## Valuation Framework

### EV/EBITDA Multiples

| Retail Format | Trough | Mid-Cycle | Peak |
|---------------|--------|-----------|------|
| Off-Price | 7.0 - 9.0x | 10.0 - 13.0x | 14.0 - 17.0x |
| Specialty (growth) | 5.0 - 8.0x | 10.0 - 14.0x | 15.0 - 20.0x |
| Specialty (mature) | 4.0 - 6.0x | 6.0 - 9.0x | 9.0 - 12.0x |
| Department Stores | 3.0 - 4.0x | 4.5 - 6.0x | 6.0 - 8.0x |
| Grocery | 5.0 - 7.0x | 7.0 - 9.0x | 9.0 - 11.0x |
| E-commerce (profitable) | 8.0 - 12.0x | 15.0 - 25.0x | 25.0 - 40.0x |

### Valuation Adjustments

**Same-Store Momentum**: Sustained positive comps above 3% warrant 1-2x multiple premium. Negative comp trends require 1-2x discount regardless of management guidance.

**Inventory Adjustment**: Elevated inventory (days sales of inventory above 52-week average) warrants markdown reserve deduction from enterprise value or multiple compression.

**Real Estate Value**: Owned real estate provides downside support. Calculate real estate value separately for retailers with significant owned property. Adjust net debt for operating lease liabilities using 6-8x annual rent expense.

**DTC Mix Caution**: High DTC mix without proven profitability should not command e-commerce multiples. Verify segment-level margins before applying premium valuations.

### Key Ratios to Monitor

| Ratio | Target | Red Flag |
|-------|--------|----------|
| Inventory/Sales Growth | < 1.0x | > 1.3x for 2+ quarters |
| Capex/Depreciation | 1.0 - 1.5x | < 0.8x (underinvestment) |
| Rent/Sales | < 10% | > 15% |
| SG&A/Sales Trend | Flat to declining | Rising with flat comps |