Inventory Working Capital Trap: Calculate Days and Free Cash — Calculation Formula

How to Calculate Your Inventory Days (DIO) in 3 Steps

The business is profitable on paper, yet the bank account keeps shrinking. The culprit is almost always inventory working capital — cash that leaves the business months before it returns as revenue.

¹

Step 1: Calculate average inventory. Add your beginning inventory balance for the period to your ending inventory balance, then divide by two. For a full year, use the January 1 and December 31 figures. For a quarterly check, use the start and end of that quarter.

Step 2: Find your annual COGS. This number sits on your profit and loss statement. If you run a seasonal business, use a trailing twelve-month figure rather than a single calendar year to avoid distortion.

Step 3: Apply the formula. Divide average inventory by COGS, then multiply by 365. The result is your DIO in days.

Consider a hypothetical product business with $400,000 in average inventory and $1.2 million in annual COGS. The calculation is ($400,000 / $1,200,000) × 365 = 121.7 days¹. That means cash is tied up for nearly four months before a sale converts it back to cash.

What the Inventory Working Capital Trap Costs Your Business

A high DIO number does not just sit on a spreadsheet — it directly reduces the cash available for payroll, marketing, equipment, and growth. The working capital cycle formula quantifies this: Inventory Days + Receivable Days − Payable Days.²

Suppose a business has 120 inventory days, 45 receivable days, and 30 payable days. The working capital cycle is 120 + 45 − 30 = 135 days. For over four months, every dollar spent on inventory is unavailable for any other purpose. If the business carries $500,000 in average inventory, that is $500,000 of trapped cash.

Most SMB factories carry 20–30% obsolete inventory, directly trapping working capital.³ For a business with $1 million in inventory, that means $200,000 to $300,000 in dead stock. That cash could fund a new hire, a marketing campaign, or a piece of equipment that actually generates revenue.

The trap is insidious because it grows slowly. A business adds a few extra units of each SKU "just in case." Over two to three years, inventory balloons while cash shrinks. The owner sees rising revenue and assumes everything is fine — until payroll bounces.

How to Calculate Your Inventory Days Calculation Formula

The inventory days calculation formula is (Average Inventory / COGS) × 365. This is the standard formula used across industries and is the basis for DIO tracking in accounting software.⁴

The formula works for any period. For a monthly view, use monthly average inventory and monthly COGS, then multiply by 30 instead of 365. For a quarterly view, use quarterly figures and multiply by 90.

High-performing businesses track DIO to optimize inventory management and unlock cash flow.⁵ The key is consistency — calculate the same way every period so trends become visible. A rising DIO over three consecutive quarters signals a problem before it becomes a crisis.

The table above shows a hypothetical business where DIO creeps up by 20 days over one year. That is 20 extra days of cash tied up — on a typical inventory balance of $450,000, that is roughly $24,600 of additional trapped cash by year-end.

The Hidden Cash Drain in Slow-Moving Stock

Not all inventory is equal. Fast-moving SKUs with 30-day turnover are productive assets. Slow-moving stock sitting for 200+ days is a cash drain disguised as an asset on the balance sheet.

The inventory reorder point calculation helps separate the two. The formula is: Reorder Point = (Average Daily Usage × Lead Time in Days) + Safety Stock.⁶ For a hypothetical SKU that sells 10 units per day with a 15-day lead time and 50 units of safety stock, the reorder point is (10 × 15) + 50 = 200 units. Ordering above that level without data backing it creates excess.

Slow-moving stock accumulates through several mechanisms. Minimum order quantities from suppliers force buyers to purchase more than needed. Seasonal over-ordering based on optimistic forecasts leaves leftover units. Product line expansions add SKUs without removing underperformers.

The carrying cost of that slow stock is real. Inventory carrying cost for small businesses typically includes storage, insurance, obsolescence, and the opportunity cost of capital. For a business with $500,000 in slow-moving inventory at a 25% carrying cost, that is $125,000 per year in hidden expense.

Setting a Target Days on Hand for Your Industry

Industry benchmarks provide a starting point, but the right target depends on your specific supply chain and customer demand patterns. A grocery wholesaler might target 15–20 days. An industrial equipment distributor might target 60–90 days. A fashion retailer with seasonal collections might target 45–60 days.

The table above shows general ranges. A business above the top of its range has a clear opportunity to free cash. A business below the bottom of its range may be losing sales to stockouts.

The target should be set based on lead time variability and demand predictability. If suppliers deliver reliably within 10 days and demand is stable, a 30-day target is achievable. If lead times vary from 30 to 60 days and demand is seasonal, a 60-day target may be necessary to maintain service levels.

Freeing Cash by Reducing Inventory Without Hurting Sales

Reducing inventory working capital does not mean cutting stock blindly. It means aligning inventory levels with actual demand patterns using data, not gut feel.

ABC analysis is the first step. Categorize SKUs by revenue contribution. A-items (for example, the top tier of SKUs generating roughly 80% of revenue¹) deserve tight management and higher service levels. C-items (the bottom half of SKUs generating only about 5% of revenue²) should be minimized or dropped.

Eliminate slow movers systematically. Run a report of all SKUs with zero sales in the last 90 days. For each, decide: discount to clear, return to supplier, or write off. Set a quarterly review cadence to prevent reaccumulation.

Negotiate supplier terms. Extending payable days from net-30 to net-60 directly reduces the working capital cycle. If a supplier offers a discount for early payment, calculate whether the discount exceeds your cost of capital before taking it.

Use the reorder point calculation for every A-item SKU. Set safety stock based on lead time variability, not fear. For a hypothetical SKU with stable demand and reliable suppliers, safety stock of 10–15% of lead time demand is typically sufficient.

Using Inventory KPIs to Forecast Working Capital Needs

DIO is one metric in a broader working capital dashboard. The full picture requires tracking three KPIs together: DIO, Days Sales Outstanding (DSO), and Days Payable Outstanding (DPO).

The working capital cycle helps predict money flow in and out of a product business.⁷ A negative cycle — where DPO exceeds DIO plus DSO — means suppliers finance operations. That is a strong position. A positive cycle above 90 days means the business must fund its own operations for three months or more.

A business that tracks these three metrics monthly can forecast working capital needs 90 days ahead. If DIO is rising and DSO is stable, the business will need more cash next quarter. That forecast gives time to arrange financing or cut orders before the cash crunch hits.

Your Next Step

Calculate your current DIO using the formula above. Pull your last 12 months of inventory data and COGS, run the numbers, and compare the result to your industry range. If your DIO exceeds 90 days, run an ABC analysis this week and identify the bottom 20% of SKUs by revenue. Set a 90-day plan to clear or eliminate those items.

For a structured working capital review, contact [email protected].