EasyFinancialModels

Cash Flow · 2026-07-07

Working Capital Days Explained: DSO, DIO & DPO and Why They Drive Cash

What DSO, DIO and DPO mean, how the cash conversion cycle works, and how working-capital days determine whether a profitable business runs out of cash.

Working-capital days measure the timing of cash in a business: how long customers take to pay (DSO), how long stock is held (DIO), and how long you take to pay suppliers (DPO). Together they explain the puzzle of the profitable company that runs out of cash — because profit is booked on the sale, but cash depends on when money actually moves. Managing these three numbers is one of the highest-leverage things a finance team can do.

DSO — Days Sales Outstanding

DSO is the average number of days between making a sale and collecting the cash. Accounts receivable equals revenue × DSO ÷ 365. A higher DSO means more cash tied up in unpaid invoices, so tightening credit terms or improving collections directly frees cash. Fast-growing businesses feel this most: rising sales multiply the receivables balance.

DIO — Days Inventory Outstanding

DIO is how long inventory or work-in-progress sits before it is sold. Inventory equals cost of goods sold × DIO ÷ 365. Long DIO locks cash in stock; service businesses often have zero DIO. Reducing DIO through better demand planning releases cash without touching revenue.

DPO — Days Payable Outstanding

DPO is how long you take to pay suppliers. Accounts payable equals operating costs × DPO ÷ 365. Unlike DSO and DIO, a higher DPO is a cash source — you are using supplier credit as short-term financing — though stretching it too far risks supplier relationships.

A quick worked example

Take a business with $3.65m of annual revenue and 60-day DSO. Its receivables are $3.65m × 60 ÷ 365 = $600,000 of cash locked in unpaid invoices. Cut DSO to 45 days and receivables fall to $450,000, releasing $150,000 of cash without changing a single sale. The same arithmetic applies to inventory (on cost of goods sold) and, in reverse, to payables. This is why working-capital management is one of the highest-return activities in finance: it frees cash you have already earned.

Growth makes it worse

The catch is that growth multiplies working capital. If sales double and the days stay the same, the cash tied up in receivables and inventory roughly doubles too — which is precisely how profitable, fast-growing companies run short of cash. Forecasting working capital explicitly, rather than assuming it away, is the only way to see the squeeze coming and size the funding you will need.

The cash conversion cycle

Combine them and you get the cash conversion cycle: DSO + DIO − DPO. It is the number of days cash is tied up in operations. A negative cycle — common in strong retail and marketplace models — means suppliers effectively fund your growth. The EasyFinancialModels Cashflow Forecasting tool takes your DSO, DIO and DPO and builds the full working-capital schedule and its cash impact into a free, formula-linked Excel forecast, so you can see exactly how a few days either way changes your runway.

→ Build your financial model free

Related reading & tools

How to Build a Financial Model in Excel · DCF Valuation Explained for Founders and Analysts · WACC and CAPM: Estimating Your Discount Rate · Quarterly Financial Model: When to Use Quarterly Forecasts Instead of Annual Models · Industry Financial Model Templates: How to Choose the Right Revenue Drivers · How to Build a Cash Flow Forecast in Excel (Free Template + Steps)

WACC calculator · DCF calculator · IRR calculator · Inside the 15-sheet model · Industry templates