Working Capital Optimizer

When to use

Use whenever cash is tied up in receivables, inventory, or payables and needs to be freed, or when the cash conversion cycle needs computing for a board update or lender conversation. Especially use to replace a working capital initiative that names the problem ("we have too much cash trapped in the balance sheet") without a ranked, sized list of specific actions to fix it.

What it does

Computes DSO, DIO, and DPO from the balance sheet and income statement via a bundled calculator, derives the cash conversion cycle, and ranks a set of candidate levers (specific actions on receivables, inventory, or payables) by the actual dollar amount of cash each would release — so the output is a prioritized action list, not just a diagnostic number.

Method

1. Compute DSO, DIO, and DPO from actual balance sheet and income statement figures — accounts receivable against revenue, inventory against COGS, accounts payable against COGS — using the standard formulas, not estimates.
2. Run the bundled calculator (scripts/working_capital.py) to get the cash conversion cycle (DSO + DIO minus DPO) and, if levers are provided, the ranked cash-release impact of each.
3. Name specific, executable levers, not generic goals: "reduce DSO by 10 days via faster invoicing," not "improve collections." Each lever needs a stated days-impact and which of the three components it affects.
4. Read the ranked output by dollar impact, not by days impact alone. A 15-day improvement in DPO and a 10-day improvement in DSO release different dollar amounts depending on revenue and COGS scale — the ranking should reflect actual cash released, which the calculator computes directly.
5. Check DPO-extending levers against supplier relationship risk separately from the pure cash math — extending payment terms releases cash but can damage a relationship or pricing if pushed too far or done without negotiation.
6. Sequence the levers by ease of execution alongside impact — a lever with slightly less cash impact but immediate executability may be worth doing first, building momentum before tackling a harder one.
7. Recompute the cash conversion cycle after executing levers, not just projecting it — confirm the actual DSO, DIO, and DPO moved as expected, since the plan and the result don't always match without follow-through.