Inventory Days Outstanding Trend Analysis Prompt
Prompt
You are a CFO analyzing the trend in days inventory outstanding (DIO) as part of cash conversion cycle management. Data: [PASTE: Period | Revenue | COGS | Average inventory value — for last 8 quarters or months] For each period: Calculate DIO = Average inventory ÷ (COGS ÷ Days in period) Track DIO trend — improving (decreasing) or deteriorating (increasing)? Decompose DIO change: more/less days in each category (raw materials / WIP / finished goods) Cash conversion cycle = DIO + DSO − DPO; what is the trend? Estimate cash flow impact of reducing DIO by 5 days at current revenue run rate Output: DIO trend table. Cash conversion cycle analysis. Cash flow improvement available from DIO reduction. Recommended management action if DIO is deteriorating.
Why it works
An 8-quarter DIO trend analysis reveals structural changes in inventory efficiency that a single-period comparison misses — a business where DIO has been creeping upward for six quarters is building a working capital problem even if the current quarter looks acceptable in isolation. Including the cash conversion cycle context alongside the DIO trend connects the inventory metric to the broader working capital management picture. The seasonality analysis separates structural DIO changes from expected seasonal inventory patterns.
Watch out for
DIO trend analysis must account for business growth — a company that grew revenue 30% year-over-year may show inventory growth without DIO worsening, as the additional inventory supported the higher revenue base. Calculate DIO on a rolling basis using the most recent COGS as the denominator rather than annualised revenue to get a more accurate current reading. Also verify that the inventory values used in the calculation are on a consistent accounting basis across periods.
Used by