Working Capital Tied in Inventory Formula
How apparel executives calculate the working capital locked in inventory — the CFO-level view of inventory productivity.
What Working Capital Tied in Inventory measures
This is the dollar amount of working capital locked in inventory: the average inventory a brand holds, valued at cost. Every dollar of inventory at cost is cash already spent on goods and not yet recovered through sales — the inventory value held is the capital tied. It is the finance-led translation of inventory turns into a balance-sheet view.
Working Capital Tied = Average Inventory at Cost = Daily COGS × Days Inventory OutstandingThe two forms are the same number. Days Inventory Outstanding (DIO) is defined as average inventory ÷ daily COGS, so Daily COGS × DIO gives back average inventory at cost. The DIO form is useful because it makes the lever visible: at a fixed COGS run rate, every day of holding time ties up one day of COGS in cash. It is the calculation CFOs use to frame inventory discipline as a cash-cycle decision, not a merchandising preference.
Worked apparel example
A department runs $1.8M of annual COGS and holds inventory an average of 90 days (DIO).
Working Capital Tied = ($1.8M ÷ 365) × 90 = $443.8K
Daily COGS is about $4.9K, so 90 days of holding means roughly $444K of inventory at cost on hand at any given moment — $444K of cash locked until it sells through. Shorten average days held to 60 at the same COGS run rate and the capital tied drops to about $296K — roughly $148K of cash released for other uses.
$443,836 of working capital is locked in inventory — the average inventory at cost this COGS run rate and holding period imply. Every day of holding time at this run rate ties up $4,932; shortening days held releases that cash.
Why it matters at scale
Illustrative: assume a $50M-revenue apparel brand at a 52% gross margin, so roughly $24M of annual COGS. At 4× turns, average inventory at cost is about $6M — $6M of cash sitting on the balance sheet — and DIO is about 91 days. Daily COGS is roughly $66K, so every 10-day reduction in average days held releases about $660K of working capital. At 20% growth targets, that's money that can fund the next tranche of buy without debt or dilution.
Failure modes we see
Inventory productivity framed only as turns or GMROI. Merchandising thinks in turns; finance thinks in working capital. Without the working-capital view, merchandising decisions that slow turns (heavier buys, longer hold) look fine in the merchandising dashboard and invisible in the P&L impact.
How RetailNorthstar handles working capital
Working capital locked is a live view at department and class level. Decisions that extend days held — chase orders, markdown holds, aged inventory not written down — all get the working-capital translation attached.
Related formulas
- Inventory Turns — the velocity framing
- GMROI — margin-adjusted productivity
- Weeks of Supply — the weekly operational version
See working capital locked in inventory live — so merchandising decisions are always framed in cash-cycle terms, not just turns.
Book a Demo →