What is days of inventory on hand and when should I use it?

Question

AcadiFi · Accepted Answer

Days of inventory on hand (DIO) equals 365 divided by inventory turnover, or equivalently average inventory divided by daily COGS. It restates the turnover ratio in calendar days, which is intuitive when modeling the cash conversion cycle.

For Harvest Coastal Foods with turnover of 9.1x, DIO equals 365 / 9.1 = 40.1 days. If receivables sit at 52 days and payables at 38 days, the cash conversion cycle is 40 + 52 - 38 = 54 days. Management can directly discuss shaving eight days off DIO and model the freed working capital.

When to prefer DIO over turnover:

- Cash cycle modeling where you combine DSO, DIO, and DPO.
- Seasonal businesses where turnover annualization distorts interpretation.
- Benchmarking across firms with very different scale.
- Communicating with operations teams that think in days, not multiples.

A trap to avoid: if COGS is growing rapidly, average inventory in the denominator may lag behind period-end inventory. For a fast-growing retailer, use ending inventory divided by next quarter's daily COGS to avoid understating days on hand. Always disclose which convention you used in a model.

What is days of inventory on hand and when should I use it?

Master Level II with our CFA Course

Related Questions

Practice Questions