Cash Flow Tool 27
Working
Capital
Modeler
Capital
Modeler
How much cash does your wholesale operation actually need? Model working capital requirements from inventory days, AR days, and AP days. Size your credit facility.
1P&L Baseline
SG&A excluding COGS
2Working Capital Drivers
Avg days to collect from retailers
Avg days to pay suppliers
3Growth Scenario
Your current WC / revenue ratio
Headroom above minimum requirement
Working Capital Required·
Current WC
Required
Required
·
Growth WC
Required
Required
·
Facility
Size Needed
Size Needed
·
Working Capital Decomposition
Inventory investment (DIO)·
Accounts receivable (DSO)·
Less: accounts payable (DPO)·
Net Working Capital Required·
Monthly OpEx buffer (1 month)·
Total Working Capital Needed·
Growth Capital Planning
Additional WC for growth target·
Facility size (with buffer)·