Days Inventory Outstanding (DIO) Calculator

Days inventory outstanding, or DIO, measures the average number of days your stock sits on hand before it is sold. This calculator works it out from your inventory balance, your cost of goods sold (COGS) for the period, and the number of days in that period. It divides inventory by COGS, then multiplies by the days in the period to give a clear figure in days. DIO, sometimes called days sales of inventory, is a key working capital measure used by retailers, wholesalers, manufacturers and their accountants. A lower DIO means stock moves quickly and ties up less cash, while a higher DIO can signal slow moving lines, overstocking, or weak demand. Holding too little stock, on the other hand, risks stockouts and lost sales, so the goal is a balance that suits your industry and supply lead times. New Zealand businesses use DIO alongside days sales outstanding and days payable outstanding to build the cash conversion cycle, which shows how long cash is locked up in day to day operations. For an accurate result, match the period to the COGS figure you enter and consider using an average inventory balance when stock levels swing through the year, for example around seasonal peaks. Use 365 days for a full year, about 90 for a quarter, or 30 for a month, keeping COGS aligned to the same window. Compare your DIO with similar businesses and with your own history, since the trend often matters more than a single reading. A rising DIO with flat sales is worth investigating, as it can point to ageing or obsolete stock that may need clearing or writing down.

DIO = (inventory / COGS) x days in period. Estimate only, not financial or tax advice.