WORKING CAPITAL EFFICIENCY BRIDGE: ILLUSTRATIVE DEFAULT RECORD
OBSERVED PERIODS
Period A revenue: $50,000,000
Period B revenue: $60,000,000
Period A cost of sales: $30,000,000
Period B cost of sales: $36,000,000
Period A accounts receivable: $6,250,000
Period B accounts receivable: $8,400,000
Period A inventory: $5,000,000
Period B inventory: $6,600,000
Period A accounts payable: $3,750,000
Period B accounts payable: $4,200,000
Operating working capital: $7,500,000 → $10,800,000
DSO: 45.6d → 51.1d
DIO: 60.8d → 66.9d
DPO: 45.6d → 42.6d
CCC: 60.8d → 75.4d
Working-capital movement: +$3,300,000
OBSERVED WORKING-CAPITAL BRIDGE
Growth-supported working capital: +$1,500,000
Collections efficiency: +$900,000
Inventory efficiency: +$600,000
Supplier financing: +$300,000
FORWARD WORKING-CAPITAL ASSUMPTIONS
Period B length: 12 months
End-of-horizon revenue growth: 10.0%
End-of-horizon cost-of-sales growth: 10.0%
DSO reduction: 5.0 days
DSO action starts: M2
DSO fully realized by: M5
DIO reduction: 8.0 days
DIO action starts: M3
DIO fully realized by: M7
DPO extension: 4.0 days
DPO action starts: M2
DPO fully realized by: M4
Annual financing rate: 9.0%
One-time program cost: $750,000
Forward horizon: 12 months
FORWARD WORKING-CAPITAL RESULT
Period B operating working capital: $10,800,000
End no-action operating working capital: $11,880,000
End managed operating working capital: $9,673,973
End managed CCC: 58.4 days
End working-capital release versus no action: $2,206,027
Cumulative financing benefit: $144,388
One-time program cost: $750,000
Net cash benefit: +$1,600,416
Payback month: M3
OPERATING THRESHOLDS
Minimum realization of the entered DSO, DIO, and DPO improvement plan for non-negative in-horizon value: 31.9%
Maximum matched end revenue and cost-of-sales growth absorbed before managed OWC exceeds Period B OWC: 22.8%
Maximum one-time program cost preserving non-negative in-horizon value: $2,350,416
METHOD STATUS
Management-entered assumptions. The observed bridge separates operating working-capital movement into growth-supported working capital, collections efficiency, inventory efficiency, and supplier financing. The forward case begins from Period B DSO, DIO, and DPO. Revenue and cost of sales grow linearly through the horizon. No-action working capital holds Period B cycle days constant. Managed DSO and DIO improvements and DPO extension phase in independently over their entered timing. Monthly accounts receivable, inventory, and payables are recalculated from the resulting cycle days and annualized monthly revenue or cost of sales. Working-capital release equals no-action OWC less managed OWC. Financing benefit applies the entered annual financing rate monthly to the working-capital release. The one-time program cost is charged when the first entered action begins. Net cash benefit equals current working-capital release plus cumulative financing benefit less the one-time program cost. No external DSO, DIO, DPO, financing-rate, or working-capital benchmark is used.
