Dear CFO by Phoenix Strategy Group

Cash & working capital

Days inventory outstanding (DIO)

Days inventory outstanding is the average number of days a business holds inventory before it is sold.

Formula

DIO = (Inventory ÷ Cost of goods sold for the period) × Days in the period

Worked example

Inventory at quarter end$150,000
Cost of goods sold for the quarter$540,000
Days in the quarter90

($150,000 ÷ $540,000) × 90 = 25 days

Why it matters

Inventory on the shelf is cash you have already spent. A rising DIO can mean slow sellers, over-buying or stock going obsolete, and it lengthens the time before that cash comes back.

Common mistakes

Where it misleads

Dividing by revenue instead of cost of goods sold, which understates DIO.

Using a single period-end balance in a seasonal business, where average inventory for the period gives a fairer figure.

Reading one blended DIO when a few slow products hide behind fast ones.

Stop calculating it by hand.

Dear CFO keeps your statements, forecasts and metrics current from the systems you already run.