Working Capital as Percentage of Sales

Goal of the analysis:

Quantify how much cash is tied up in day-to-day operations relative to sales and explain movements over time and across business units. Working Capital as Percentage of Sales (commonly “Working Capital %” or “Trade Working Capital %”) provides a concise measure of liquidity efficiency and cash intensity. Executives use it to benchmark performance, set targets, size cash release opportunities, and prioritize Order-to-Cash (AR/DSO), Inventory (DIO), and Procure-to-Pay (AP/DPO) improvements. A rigorous approach standardizes definitions (Trade vs Net Working Capital), uses average balances (not point-in-time), normalizes for FX/seasonality/M&A, and links changes to operational drivers and cash impact.

Data required:

• Financial statements and balances:
  • Monthly AR, Inventory (RM/WIP/FG), AP balances; optionally other operational current assets/liabilities (prepaids, accruals).
  • Revenue (net sales) and COGS by month; plan/forecast; fiscal calendar (52/53-week) and FX rates for constant-currency views.
• Subledgers and operational context:
  • AR aging by customer, Inventory by SKU/location (with reserves), AP aging by supplier; GR/IR balances.
  • Terms (customer and supplier), forecast accuracy, lead times, safety stock parameters; discount programs.
• Normalization and events:
  • M&A/divestiture flags; one-offs (pre-buys, launch builds, write-downs, large settlements); accounting policy changes (FIFO/LIFO, reserves).
• Reference metrics (for cross-checks):
  • DSO, DIO, DPO timeseries; purchases if using DPO based on purchases; borrowing rates (to value cost of cash tied up).

Detailed step-by-step instruction on how to conduct the analysis:

1. Lock definitions and scope.
   • Trade Working Capital (TWC) = AR + Inventory − AP.
   • Net Working Capital (NWC) = (AR + Inventory + Other current assets) − (AP + Other current liabilities). Exclude cash, short-term debt, income taxes, and dividends to focus on operating WC.
   • Primary metric: TWC % of Sales = Average TWC ÷ Net Sales. Also compute NWC % for completeness.
2. Assemble and normalize balances.
   • Pull 18–24 months of monthly AR, Inventory (RM/WIP/FG), AP; convert to constant currency using treasury policy.
   • Use multi-point averages (e.g., monthly averages or (begin+end)/2) for the numerator to reduce seasonality noise.
   • Reconcile subledgers to GL; tag one-offs and M&A effects; align revenue definition (net of returns/rebates) and calendar days.
3. Compute headline metrics.
   • TWC % = Average(AR + Inventory − AP) ÷ Net Sales.
   • NWC % (optional) = Average(NWC) ÷ Net Sales.
   • Cash per 1% = 0.01 × TTM Net Sales (value of a 1 percentage-point change). Report TTM Working Capital % to smooth seasonality.
4. Cross-check with days metrics.
   • DSO = (Average AR ÷ Sales) × 365; DIO = (Average Inventory ÷ COGS) × 365; DPO = (Average AP ÷ COGS) × 365.
   • Approximate TWC % ≈ DSO/365 + (COGS/Sales) × (DIO − DPO)/365. Use this for reasonableness and to attribute TWC % to DSO/DIO/DPO.
5. Segment and attribute drivers.
   • By business unit, product family, region, channel, and customer/supplier cohort.
   • Break TWC % into components: AR % of Sales, Inventory % of Sales, and AP % of Sales (negative contributor). Identify outliers and concentration.
6. Bridge analysis vs prior year and vs plan.
   • Build a % bridge: Prior TWC % → DSO change → DIO change → DPO change → Mix (COGS/Sales shift) → FX/one-offs → Current.
   • Translate % change to cash: Cash impact = Δ(TWC %) × TTM Sales. Also show interest impact at current borrowing rate.
7. Diagnose operational root causes.
   • AR: terms vs behavior gap, dispute rates, unapplied cash, e-invoicing adoption, collections coverage.
   • Inventory: forecast accuracy, lead-time variability, safety-stock settings, MOQ/lot sizes, SLOB %, OTIF.
   • AP: on-time-at-term vs late vs early pay, discount capture, PO coverage, approval cycle time, blocked invoices, SCF usage.
8. Model scenarios and targets.
   • Simulate DSO −5 days, DIO −7 days, DPO +4 days; convert to TWC % and cash unlocked. Provide BU-level targets and timing.
   • Set guardrails for service (fill rate) and supplier health when pulling inventory or extending terms.
9. Integrity checks.
   • Ensure consistency of denominators (Sales vs COGS) when using the days cross-check; exclude non-operating items (taxes, ST debt).
   • Remove intercompany balances; disclose policy changes (FIFO/LIFO, reserves) and 53rd-week effects.

Format of the output of analysis:

• Executive scorecard: TWC % and NWC % (current and TTM), AR/Inventory/AP % of Sales, cash per 1%, cash unlocked vs plan.
• Bridges: TWC % bridge vs prior year and vs plan with translation to DSO/DIO/DPO and cash impact.
• Segment heatmaps: TWC % by BU/product/region/channel with AR/Inv/AP component bars.
• Aging and parameter panels: AR aging/disputes/unapplied cash; inventory aging/SLOB and planning parameters; AP terms/discount capture/late rate.
• Scenario calculator: impacts of day improvements and mix shifts (COGS/Sales) on TWC % and cash.

How to interpret results:

• High and rising TWC %: Cash trapped in operations—usually driven by DSO/DIO increases not offset by DPO. Expect higher borrowing and interest cost.
• Low or negative TWC %: Retailers/marketplaces often achieve negative TWC (supplier financing). Validate sustainability and supplier health.
• Inventory-heavy TWC %: Forecast error, long lead times, MOQ constraints, or over-ambitious service targets; prioritize parameter resets, lead-time reduction, SKU rationalization.
• AR-heavy TWC %: Terms execution gaps, billing accuracy, disputes; improve O2C and collections discipline.
• DPO improving but accompanied by late payments: Process-driven “late” increases supplier risk; move to “at term” via renegotiation/SCF, not ad hoc delays.
• Seasonality: Use TTM and rolling averages; separate planned builds (peak season) from structural increases.

Steps a company can take to improve on this measure:

• Order-to-Cash (reduce AR %):
  • Standardize terms by segment; automate invoicing and e-billing; fix master data; institute dispute squads and unapplied cash automation; tie sales comp partially to cash.
• Inventory and S&OP (reduce Inventory %):
  • Improve forecast accuracy; reset safety stocks/min–max; reduce lead times/MOQs; deploy postponement/MEIO; liquidate SLOB with guardrails.
• Procure-to-Pay (optimize AP %):
  • Extend terms where feasible; adopt SCF/dynamic discounting; raise PO coverage and touchless processing; enforce “no early pay without discount.”
• Policy, governance, and analytics:
  • Set BU targets for TWC % and component days; publish weekly dashboards; integrate WC into S&OP and CFO scorecards.
  • Normalize for FX and one-offs; maintain a WC one-off registry and document accounting changes.
• Scenario guidance:
  • If TWC % is 18% on $1B TTM sales, each 1 pt = $10M cash. A program targeting DSO −5, DIO −7, DPO +4 could free $25–35M depending on mix.
  • If inventory drives 70% of TWC, run a two-quarter parameter reset and SKU rationalization; aim for −3–5 pts TWC % without service loss.
  • If AR is concentrated in top-20 accounts, enforce portal/PO compliance and offer early-pay discounts where APR > borrowing cost; target −1–2 pts TWC %.

Benchmark comparisons:

General benchmarks (directional):

• Retail/marketplaces: TWC % often −5% to −15% (supplier financing and fast turns).
• Consumer packaged goods: 5–15% depending on channel mix and terms with retailers.
• Industrial/manufacturing: 10–25% reflecting WIP/FG and longer cycles (lower end for configure-to-order, higher for engineer-to-order).
• Wholesale/distribution: 5–15% with moderate inventory and negotiated supplier terms.
• Software/SaaS: ~0–5% (minimal inventory; AR offset by deferred revenue not counted in TWC).

Constructing internal benchmarks:

• Build 18–24 month histories of TWC % by BU/product/region; publish quartiles and target bands with service and supplier-risk guardrails.
• Pair TWC % with CCC (DSO/DIO/DPO) to diagnose which component drives variance; adopt top-quartile cells as internal targets.
• Track “cash per 1%” and value-at-stake; set quarterly improvement goals and owner accountability; reset baselines after policy or portfolio changes.