Cash Flow Tool 27

Working
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

Annual Revenue ($)

COGS % of Revenue (%)

Operating Expenses / Month ($)

SG&A excluding COGS

2Working Capital Drivers

Days Inventory Outstanding (DIO)

Days Sales Outstanding (DSO)

Avg days to collect from retailers

Days Payable Outstanding (DPO)

Avg days to pay suppliers

3Growth Scenario

Target Revenue Growth (%)

Working Capital as % of Revenue (%)

Your current WC / revenue ratio

Credit Facility Buffer (%)

Headroom above minimum requirement

Working Capital Required—

Current WC
Required

—

Growth WC
Required

—

Facility
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)—

P23-EDU · TWENTY3 IntelligenceCash Flow Tool 27·Working Capital Modeler·DIO · DSO · DPO Cash Conversion·Credit Facility Sizing·P23-EDU · TWENTY3 IntelligenceCash Flow Tool 27·Working Capital Modeler·DIO · DSO · DPO Cash Conversion·Credit Facility Sizing·

Working Capital Calculator for Product Brands