Growing consumer brands need to know whether cash will cover the next inventory commitment. A cash conversion cycle calculation can organize that question, but the purchase decision still needs payment dates and a forecast of the bank balance.
Use the ratio to identify an assumption worth investigating. Then trace that assumption to a specific inventory order, customer invoice or supplier agreement before changing the cash forecast.
Define the cycle with consistent inputs
The cash conversion cycle (CCC) estimates the interval between supplier payments and customer collections. Its formula is inventory days plus receivables days minus payables days. It summarizes trade working capital; it does not include every cash requirement of running a company. ACCA explains the cycle and its limitations.
For a period containing N days, use these definitions:
| Measure | Calculation | Input to reconcile |
|---|---|---|
| Inventory days (DIO) | Average inventory ÷ cost of goods sold × N | Inventory and cost of goods sold on a consistent cost basis |
| Receivables days (DSO) | Average trade receivables ÷ net credit sales × N | Receivables and sales covering the same credit customers |
| Payables days (DPO) | Average trade payables ÷ credit purchases × N | Supplier balances and purchases covering the same scope |
These formulas follow ACCA’s ratio guidance. Cost of goods sold is sometimes used when credit purchases are unavailable; label it as a proxy rather than silently treating the two as equal. Payables days describe payment behavior, not permission to pay beyond agreed terms.
Document the averaging method. Here, average means opening plus closing balance, divided by two. For an actual seasonal business, inspect more frequent balances before deciding that two dates represent the period. Keep the same period and scope across comparisons. If a required denominator is zero or missing, mark the ratio unavailable and inspect transactions instead.
A fictional 90-day example
All figures below are invented US-dollar amounts for a physical-product brand during January 1–March 31, 2026. For simplicity, all sales and inventory purchases are on credit; there are no returns, write-offs, taxes, currency movements or other inventory adjustments. This is a calculation example, not a client result or target benchmark.
| Input | Amount |
|---|---|
| Net credit sales | $1,800,000 |
| Cost of goods sold | $900,000 |
| Credit inventory purchases | $1,080,000 |
| Opening / closing inventory | $510,000 / $690,000 |
| Opening / closing trade receivables | $550,000 / $650,000 |
| Opening / closing trade payables | $300,000 / $420,000 |
The average balances are $600,000 inventory, $600,000 receivables and $360,000 payables. Inventory reconciles as $510,000 + $1,080,000 − $900,000 = $690,000. Under the stated assumptions, customer collections are $550,000 + $1,800,000 − $650,000 = $1,700,000; supplier payments are $300,000 + $1,080,000 − $420,000 = $960,000. Neither number is net company cash flow because other cash movements are outside this example.
The ratios are:
- DIO: $600,000 ÷ $900,000 × 90 = 60 days.
- DSO: $600,000 ÷ $1,800,000 × 90 = 30 days.
- DPO: $360,000 ÷ $1,080,000 × 90 = 30 days.
- CCC: 60 + 30 − 30 = 60 days.
Using cost of goods sold for DPO here would produce 36 days and a 54-day CCC. That difference comes from changing the denominator, not collecting cash sooner. The defined average trade investment is $600,000 + $600,000 − $360,000 = $840,000. Multiplying the 60-day cycle by daily revenue would instead give $1,200,000; it does not reproduce that investment because the components use different denominators.
Separate balance sensitivity from available cash
At unchanged cost of goods sold, reducing DIO from 60 to 50 days implies average inventory of $500,000: $900,000 ÷ 90 × 50. The $100,000 difference is an approximate balance sensitivity under fixed assumptions. It is not a recurring monthly saving, an instruction to liquidate stock, or evidence that $100,000 reached the bank.
Likewise, at unchanged credit purchases, moving DPO from 30 to 35 days implies average payables of $420,000, a $60,000 increase. It would reduce the calculated CCC to 55 days if the other components stayed fixed. Whether any particular payment can move requires the supplier’s agreement. Maintain enough inventory to serve customers and consider discounts and supplier relationships when evaluating changes. ACCA discusses these trade-offs.
Put a proposed change on actual dates
Consider a separate fictional October forecast for the same brand. It starts with $100,000 unrestricted cash. Assume the listed events are its only cash movements through October 13, including a $50,000 operating payment. The supplier agrees to move one $60,000 invoice from October 8 to October 13 with no fee or other change. Moving this one invoice does not establish a five-day change in company-wide DPO.
| Date in 2026 | Cash event | Original balance | Revised balance |
|---|---|---|---|
| October 1 | Opening cash | $100,000 | $100,000 |
| October 5 | Collect $40,000 | $140,000 | $140,000 |
| October 8 | Original supplier payment $60,000 | $80,000 | $140,000 |
| October 10 | Pay operating costs $50,000 | $30,000 | $90,000 |
| October 12 | Collect $30,000 | $60,000 | $120,000 |
| October 13 | Revised supplier payment $60,000 | $60,000 | $60,000 |
Both scenarios end at $60,000. The temporary $60,000 difference disappears when the rescheduled invoice is paid; do not count it again as a saving. Each balance follows opening cash plus receipts minus payments, the structure in the business.gov.au cash-flow guide.
Now add a proposed $50,000 inventory payment on October 9. Under the revised schedule, cash falls to $40,000 on October 10 and $10,000 on October 13. With an assumed $20,000 minimum reserve, the proposal falls short by $10,000. Under the original schedule, it would already reach negative $20,000 on October 10. Better payment timing alone does not meet the stated reserve requirement. Before committing, extend the forecast through later receipts, taxes, debt payments and replenishment; this short illustration excludes them.
Assign evidence and an owner
Use this checklist for the decision record:
- Finance: record the period, averaging method, matched balances and denominators; flag estimates.
- Operations: identify the inventory order, delivery dates and existing stock commitments.
- Collections owner: attach the invoice, expected receipt date and evidence supporting it.
- Supplier owner: confirm agreed payment dates and any changed price, discount or fee.
- Founder and finance: compare dated balances with the chosen reserve and record the next decision date.
For the recurring review, use the working-capital guide. For a proposed retail order, use the wholesale-readiness guide.
Bring one inventory or cash-timing question to a complimentary 30-minute assessment. The initial conversation covers observations and a useful next step; it is not a complete model build or a promise of recoverable cash.