How do I interpret a deteriorating Days Inventory trend across sectors?

Question

AcadiFi · Accepted Answer

DSI (Days Sales of Inventory = Inventory / Daily COGS) trend interpretation must be industry-calibrated because natural levels vary dramatically.

Industry benchmarks (approximate):
- Grocery/Food: 25-50 days (perishable pressure)
- Hardware/Tools: 80-120 days (long lifecycle, wide SKU)
- Apparel: 80-120 days for basics, 150+ for fashion (seasonality)
- Semiconductors: 90-150 days
- Restaurants: 5-15 days

Analysis of the three firms:

Verdant Foods (52→68, +31%): food spoilage risk amplifies — flag immediately. Likely write-downs coming. Compute implied margin hit if 16 extra days of inventory becomes partially obsolete.

Ironclad Tools (85→110, +29%): concerning but tools don't spoil. Investigate: new product launch pre-stocking (neutral) vs demand deterioration (negative). Check finished goods vs raw material mix.

SilverLink Apparel (95→145, +53%): alarming for fashion-cycle retailer. Likely end-of-season markdowns ahead. Model margin compression: apparel markdowns typically 30-50% off, so stranded inventory x markdown % = margin headwind.

```mermaid
flowchart LR
    A[DSI Trend Up] --> B[Food: Spoil Risk]
    A --> C[Tools: Demand Check]
    A --> D[Apparel: Markdown Risk]
    B --> E[Write-down Modeling]
    C --> E
    D --> E
```

Cross-sectional adjustments:
- Standardize by comparing % deviation from 3-year industry median, not absolute days
- Correlate DSI change with gross margin change — divergence signals accrual manipulation
- Check payable days (DPO) — if DPO also stretching, working capital stress is building
- Cash conversion cycle trend (DSI + DSO - DPO) tells the full liquidity story

SilverLink's 53% DSI surge in fashion apparel is the highest-risk signal and warrants a material reduction in forward margin estimates.

How do I interpret a deteriorating Days Inventory trend across sectors?

Master Level II with our CFA Course

Related Questions

Practice Questions