Working capital and the cash conversion cycle (CCC = DIO + DSO − DPO)
Shows how much cash is frozen in goods and settlements and how many days pass from paying the supplier to getting paid by the customer. It drives the decision on where to release cash: cut stock, speed up wholesale collection or negotiate longer supplier terms.
Why this document
Working capital is the cash a business must hold in goods and customer debts before it gets revenue. The longer the cycle, the more cash each rouble of growth needs, so a fast-growing company can run out of cash while profitable. The measure splits into three levers with different owners: stock with the commercial director, receivables with the head of wholesale, suppliers with purchasing. Shortening the cycle by a few days can remove the need for a new loan.
At a glance
- What is this document and why is it needed?
- Shows how much cash is frozen in goods and settlements and how many days pass from paying the supplier to getting paid by the customer. It drives the decision on where to release cash: cut stock, speed up wholesale collection or negotiate longer supplier terms.
- Who owns the document and how often is it rebuilt?
- The finance director keeps the metric; DIO goes to the commercial director, DSO to the head of wholesale, DPO to purchasing; monthly, weekly in season; to the owner the cycle in days and the cash it freezes.
- What mistakes are the most common?
- DIO is computed on revenue, not cost → days are artificially low → compute on COGS. Receivables incl. VAT are divided by revenue excl. VAT → DSO overstated by 22% → the same basis incl. VAT. The year-end balance is used → the seasonal peak is invisible → compute by month and at the peak.
For whom
- Brand
- A brand has a long cycle with three parts: stock (in Model B DIO is 240 days: fabric, sewing, warehouse), wholesale receivables (DSO 33 days with a 45-day deferral) and small payables (DPO 30): CCC 243 days, with advances to factories 258. Working capital is RUB 72.005 million (35% of revenue). The largest pool is stock: every 10 days of DIO release 2,472, while minus 5 days of DSO and plus 10 days of DPO give 3,454 and 3,260.
- Retail
- A retailer has DSO near zero (money comes in 1 to 2 days), so the cycle is set by stock and payables to brands. In Model R DIO is 150 days, DSO 2.0, DPO 60: CCC 92 days, working capital 45,210 (9% of revenue). The main lever is supplier deferral and stock turnover: plus 10 days of DPO gives 9,097, minus 10 days of DIO 7,226.
What it consists of
Three components of the cycle
- DIO (days inventory outstanding): how many days goods lie before sale = inventory ÷ cost of goods sold × 365. For a brand it includes materials and finished goods; for a retailer stores and the warehouse.
- Retailer: DSO (days sales outstanding): after how many days the customer pays = receivables ÷ revenue incl. VAT × 365. For a retailer it is set by acquiring and settlements with platforms.
- Brand: DPO (days payables outstanding): after how many days we pay suppliers = payables ÷ purchases incl. VAT × 365. Prepayments to factories reduce DPO and add days of advances.
CCC and frozen cash
- CCC = DIO + DSO − DPO: how many days cash is “frozen” between paying the supplier and receiving the customer money. The shorter, the less funding is needed.
- One day of the cycle costs revenue (incl. VAT) ÷ 365 or COGS ÷ 365 depending on the component; multiply by the days of improvement to get released cash, and by the loan rate to get the interest saving.
- Brand: The brand end-to-end cycle starts with the prepayment to the factory: add days of advances (the “End-to-end cash gap” calculation).
Levers by component
- Stock (DIO): less depth in tail sizes, reorder instead of a large first order, transfers between outlets, price reductions in time, no dead stock; the target is set by weeks of cover by category.
- Receivables (DSO): customer limits, prepayment or partial prepayment, an early-payment discount (compute as a rate), factoring, overdue control.
- Brand: Payables (DPO): supplier deferral, consignment, a letter of credit instead of prepayment, a payment schedule by priority; do not stretch at the cost of penalties.
How to read and compare
- Compute on the period average and at seasonal peaks: a year-end balance may hide the seasonal peak.
- Compare with your own history and targets, not with a “norm”: there are no single Russian turnover norms, each format and category has its own level.
- Guide thresholds (set your own): DIO above plan by 10% (brand above 264 days, retailer above 165) means a review of stock age and tails; DSO longer than the contract deferral by more than 5 days means a review of overdue amounts by customer; DPO shorter than the contract by more than 5 days means a check of the payment schedule; brand CCC up by 15 days or more means recomputing the peak need.
Brand and retailer: what is computed differently
- Brand: the brand cycle is long: DIO of 240 days, wholesale deferral of 45 days; levers: less depth in size tails, preorder instead of stock, prepayment and deferral terms of the factory.
- Retailer: the retailer cycle is set by stock and payables to brands: DIO of 150 days, DPO of 60; levers: supplier deferral, transfers between stores, timely markdowns.
Brand: how the document differs and what to add
- Brand: brand stock is the largest pool (DIO 240 days), but at the given steps it releases less than the other levers: minus 10 days of DIO release RUB 2.472 million against 3,454 for minus 5 days of DSO and 3,260 for plus 10 days of DPO; a deep 30-day cut of stock gives RUB 7.416 million.
- Brand: the advance to factories extends the cycle: 15 days in the model, at a 30% advance closing brand cash falls to -10,036.
- Brand: wholesale receivables (DSO 33 days): cutting by 5 days releases RUB 3.454 million; the lever is an early-payment discount or factoring, not pressure on a key customer.
- Brand: the cycle is computed by season: a collection goes from fabric payment to customer payment, and annual average DIO hides pre-season peaks.
- Brand: stock at partners on consignment remains with the brand: it is added to DIO, otherwise the cycle looks shorter than cash is actually frozen.
- Brand: brand payables are short (DPO 30 days in the model): factories require quick payment, and a longer deferral is possible only against order volume or prepayment.
- Brand: returning dead stock and clearing last season’s remaining stock give a one-off cash release but do not change DIO of the new season.
- Brand: levers by component are compared with the cost of financing: if the cost of money exceeds the margin sacrificed to cut stock, the discount is not given.
Retailer: how the document differs and what to add
- Retailer: the retailer’s main lever is payables (DPO 60 days): 10 more days of deferral releases RUB 9.097 million, and for the retailer this effect is stronger than stock.
- Retailer: DIO of 150 days is computed by category: seasonal categories with long stock pull the cycle up, basics lower; the total hides the problem segment.
- Retailer: DSO of about 2 days: receivables are acquiring and platform payments; they can be shortened by no more than these days (RUB 3.41 million when settling on the day of sale), the lever is in tariffs and crediting speed.
- Retailer: stock is spread across stores and the warehouse: surplus in some points and shortage in others lengthens the cycle without sales growth; transfers release cash cheaper than discounts.
- Retailer: loyalty liabilities and gift cards reduce net working capital: a source of cash, but with an obligation of future revenue without receipts.
- Retailer: rent advances and security deposits fall outside the trading cycle but tie up cash: they are counted separately from CCC.
- Retailer: the seasonal stock peak before the season requires credit: the cycle at year end is lower than at the peak; compute for the average and the peak date.
- Retailer: suppliers with a short deferral give a jump in cash need when purchasing grows: first negotiate terms, then buy.
Control checks
- Components agree: brand 240.0 + 32.6 − 30.0 = 242.6 days; retailer 150.0 + 2.0 − 60.0 = 92.0.
- Net working capital by the document definition equals the balance sheet (brand 72,005, retailer RUB 45.21 million); revenue and purchase denominators include VAT consistently with the numerator.
- Typical traps: DSO on revenue without VAT with receivables including VAT, stock without reserve in one part and with it in another, average stock instead of stock at the date.
Where the data comes from
| Data source | Fields |
|---|---|
| Balance sheet at dates and averages | receivables, inventory, advances, payables at start, end and by month |
| P&L | revenue incl. VAT, COGS, purchases |
| Receivables and payables aging registers | payment term, actual term, overdue, customer limit |
| Stock snapshot and stock age | quantity, cost, age, weeks of cover |
How to build it step by step
- Step 1: Choose the basis: the period average by months (better) or, if no data, period end; fix the method.
- Step 2: Compute DIO on COGS (not revenue), DSO on revenue incl. VAT, DPO on purchases incl. VAT.
- Brand: Step 3: Add up to CCC and add days of advances for the brand end-to-end cycle.
- Step 4: Convert to money: working capital and the amount of “one day” of each component.
- Step 5: Break DIO down by category and season; find tails (age, sizes, dead stock).
- Step 6: Break DSO down by customer and channel; find overdue amounts and concentration.
- Step 7: Break DPO down by supplier; compare terms, find room for deferral.
- Step 8: Set targets in days and in money; assign owners; link to the commercial team incentives.
- Step 9: Check the price of improvement: an early-payment discount, factoring price, lost sales with less stock; compare with the saving.
- Step 10: Track the metric monthly; weekly in season; reconcile with the cash plan.
Formulas
| Measure | Formulas | Note |
|---|---|---|
| DIO | DIO = Inventory at cost ÷ COGS × 365 | Inventory and COGS on one basis (no retail markup); for a seasonal business compute by month. |
| DSO | DSO = Receivables ÷ Revenue incl. VAT × 365 | If receivables include VAT, revenue must too; otherwise you overstate days by the rate. |
| DPO | DPO = Payables ÷ Purchases incl. VAT × 365 | Purchases are not COGS: purchases = COGS + stock growth. |
| CCC | CCC = DIO + DSO − DPO | A negative CCC means suppliers fund the business. |
| Released cash | Cash = Δ days × (COGS | Revenue incl. VAT | Purchases incl. VAT) ÷ 365 | Interest saving = Cash × loan rate. |
| Net working capital and the cost of a day | NWC = Receivables + Net inventory + Advances − Payables − Payroll debt − Deferred loyalty revenue; Cash in advances = Purchases × Prepayment share | The main definition for the balance sheet, ROIC and FCFF; CCC uses the trade view (inventory + receivables − payables). A 30 to 100% prepayment to the factory is typical for an importer: Models B and R set the advance modestly, so look at the sensitivity row: it shows how much cash goes into advances. |
Formulas in notation
- Days of inventory
DIO = Inv / COGS · 365
Inv is inventory at cost (without reserve), COGS is annual cost of goods sold.- Days of receivables
DSO = AR / (Rev + VAT) · 365
AR includes VAT, so revenue is taken with VAT.- Days of payables
DPO = AP / (P + VAT_P) · 365
AP is supplier payables, P is annual purchases excluding VAT, VAT_P is the VAT on purchases.- Cash release
ΔCash = Δdays · Flow / 365
Flow is the turnover of the line (COGS, revenue with VAT, purchases with VAT), Δdays is the change in days.
Worked example
Working capital and CCC on the balance sheet of the end-to-end models (at year end), days and RUB thousand
| Metric | Brand (Model B) | Retailer (Model R) |
|---|---|---|
| DIO: days of inventory (inventory ÷ COGS × 365) | 240 | 150 |
| DSO: days of receivables (receivables ÷ revenue incl. VAT × 365) | 32.6 | 2 |
| DPO: days of payables (payables ÷ purchases incl. VAT × 365) | 30 | 60 |
| CCC = DIO + DSO − DPO, days | 242.6 | 92 |
| Days of supplier advances | 15 | 6 |
| CCC with advances (end-to-end cycle), days | 257.6 | 98 |
| Net operating working capital (receivables + net inventory + advances − payables − payroll debt − deferred loyalty revenue), RUB thousand | 72,005 | 45,210 |
| Working capital to revenue, % | 34.8 | 8.9 |
| Sensitivity: supplier advance of 30% of purchases for the brand and 10% for the retailer (5% and 2% in the models): year-end advances, RUB thousand | 29,264 | 27,215 |
| Sensitivity: year-end cash at such an advance (14,351 and 1,766 in the base), RUB thousand | −10,036 | −20,006 |
| Released by DIO −10 days, RUB thousand | 2,472 | 7,226 |
| Released by DSO −5 days (not below zero: the retailer DSO is only about 2 days), RUB thousand | 3,454 | 3,410 |
| Released by DPO +10 days, RUB thousand | 3,260 | 9,097 |
| Total released, RUB thousand | 9,186 | 19,733 |
| Annual interest saving at the price of new debt of 20%, RUB thousand | 1,837 | 3,947 |
The days come out this way because the model sets DIO at 240 and 150, a wholesale deferral of 45 days and DPO of 30 and 60; computing from the balance sheet returns them with an adjustment for the receivables mix. This is a model consistency check. The targets in days (minus 10 days of inventory, minus 5 days of receivables, plus 10 days of payables) release 9,186 for the brand and 19,733 for the retailer; for the retailer the receivables shift is capped by its current 2 days (3,410, not five days). The interest saving is computed at the price of new debt (20%, as in the Capital document), not at the rate of the existing loans of 14% and 15%: released cash replaces new borrowing. Compare the total with the peak need from the treasury.
Figures
- positive
- negative
- total
Data as a table
| Step | Change | Level |
|---|---|---|
| DIO | +240 | 240 |
| DSO | +32.6 | 273 |
| DPO | −30 | 243 |
| Cash conversion cycle | — | 243 |
Brand cash cycle: DIO + DSO − DPO. Stock lives almost eight months and supplier payment is short: brand cash is frozen in stock, not in receivables.
- positive
- negative
- total
Data as a table
| Step | Change | Level |
|---|---|---|
| DIO | +150 | 150 |
| DSO | +2 | 152 |
| DPO | −60 | 92 |
| Cash conversion cycle | — | 92 |
Retailer cash cycle: DIO + DSO − DPO. There are almost no receivables, stock is shorter and the supplier deferral is twice as long: the cycle is markedly shorter.
- Brand
- Retailer
Data as a table
| Measure | Brand | Retailer |
|---|---|---|
| Inventory −10 days | 2,472 | 7,226 |
| Receivables −5 days | 3,454 | 3,410 |
| Deferral +10 days | 3,260 | 9,097 |
How much cash small shifts in days release. The effect of cutting inventory by 10 days, receivables by 5 days (for the retailer not below its 2 days) and extending the deferral by 10 days; compared with the price of financing.
Specifics by category
- Apparel
- Apparel: DIO depends on the season and the share of carryover stock; look by season: current, last, older than a year; a target for the current season, tails for clearance.
- Footwear
- Footwear: DIO is higher because of the size run and seasonality of pairs; wholesale DSO is longer; a separate target for tail sizes is needed.
- Accessories
- Accessories: DIO is lower for core, higher for seasonal gift items; stock is costlier to store (small, valuable), shrink affects DIO.
- Kids
- Kids: DIO rises sharply between seasons and before school; leftovers cannot be carried to the next season without losing size; a DIO target by age group.
- Men
- Menswear: DIO is lower and steadier, more repeat core items; payables can be planned longer.
- Women
- Womenswear: higher DIO for fashion items and lower for core; tail sizes and colors produce dead stock; watch early sales and reorders.
Common mistakes
- DIO is computed on revenue, not cost → days are artificially low → compute on COGS.
- Receivables incl. VAT are divided by revenue excl. VAT → DSO overstated by 22% → the same basis incl. VAT.
- The year-end balance is used → the seasonal peak is invisible → compute by month and at the peak.
- Payables are stretched without agreement → penalties and lost terms → deferral only under the contract.
- Stock is cut for the metric → lost sales (out-of-stock) → check against availability and lost revenue.
- A target for total CCC without owners by component → nobody is accountable → assign DIO, DSO, DPO to different people.
Russian specifics
- The doubtful debt reserve for corporate income tax is created under Art. 266 of the Tax Code; in accounting the reserve may differ; it affects net DSO. Rule: Tax Code Art. 266: Tax Code, Art. 266 (doubtful debt reserves) (rule check not completed).
- Inventories are stated at cost, but no more than net realizable value (FSBU 5/2019); when computing DIO take stock after the reserve or show both variants. Rule: Order 180n of 15.11.2019: Ministry of Finance Order of 15.11.2019 No. 180n (FSBU 5/2019 Inventories) (rule check not completed).
- Payment terms under a supply contract are set by the contract; the platform economy law and platform rules help (settlement terms with sellers); for marketplace DSO take the contract terms. Rule: Law 289-FZ of 31.07.2025: Federal Law of 31.07.2025 No. 289-FZ on the platform economy (rule check not completed).
- VAT on prepayments and advances: an advance to a supplier gives a deduction right under the Tax Code conditions (Art. 171); show advances on a separate line and take VAT into account when computing days. Rule: Tax Code Art. 171: Tax Code, Art. 171 (VAT deductions) (rule check not completed).