← The FP&A libraryPractice · 4 questions →
Cash & working capital
Days inventory outstanding
The average number of days inventory sits before it is sold.
Owned by: AnalystTest band: Analyst
The formula
DIO = Inventory ÷ COGS × Days in period
In practice
Inventory is cash in a form the P&L cannot see. Rising DIO with flat sales means the shelves are filling with the wrong stock.
More in cash & working capital
Free · no account · no card
Get your 2027 budget built from your QuickBooks — P&L, balance sheet and cash flow, in Excel.
Knowing the method is half of it. Wauvel runs it on your QuickBooks, every day.
$99/mo, everything included. Free for 14 days, no card.