Scenario presets
Revenue & Working Capital Drivers
Primary Working Capital Indicators
NWC to Sales Ratio
20.00%
Moderate Capital Intensity
Working Capital Days
73.0 Days
Sales Locked in Operations
Operating Working Capital (OWC)
$4,000,000
AR + Inv - AP
Growth Cash Drag ($3M Growth)
$600,000
$51,000 / yr financing drag
Sensitivity & Capital Requirement Stress-Testing
Matrix 1: NWC-to-Sales (%) vs Sales Shock & Working Capital
Varying Annual Net Sales (±20%) vs Net Working Capital (±20%).
Matrix 2: Growth Working Capital Cash Drag ($)
New cash required across incremental revenue growth vs NWC-to-Sales efficiency.
Comprehensive Working Capital & Liquidity Schedule
Step-by-Step Worked Calculation Example
Follow this end-to-end mathematical walkthrough using our baseline parameters to audit each intermediate metric.
- Calculate Operating Net Working Capital (OWC):
Operating NWC = (Accounts Receivable + Inventory) - Accounts Payable = ($2,500,000 + $3,000,000) - $1,500,000 = $4,000,000. - Calculate NWC-to-Sales Percentage:
NWC to Sales = (Operating NWC / Net Sales Revenue) × 100% = ($4,000,000 / $20,000,000) × 100% = 20.00%. - Convert NWC to Working Capital Days:
Working Capital Days = (NWC to Sales / 100) × 365 days = 0.20 × 365 = 73.00 days. This reveals that 73 days of annual revenue are permanently locked up in liquidity. - Evaluate Growth Cash Drag on Projected 15% Sales Expansion:
Incremental Sales = $20,000,000 × 15% = $3,000,000.
Required Working Capital Expansion = $3,000,000 × 20.00% = $600,000 in cash outflow. - Calculate Annual Working Capital Carrying Cost:
Incremental Carrying Cost = $600,000 × 8.5% (WACC) = $51,000 / year.
Interactive Concept Self-Check Quiz
1. Why does a company with an NWC-to-Sales ratio of 20% experience cash strain during rapid revenue growth?
2. How can a business achieve a negative Net Working Capital to Sales ratio?
3. What is the key advantage of excluding excess cash and interest-bearing debt from Operating Working Capital (OWC)?
4. If a company with $50M in sales lowers its NWC-to-Sales ratio from 18% to 12%, how much permanent cash is unlocked?
Frequently Asked Questions
The Net Working Capital to Sales ratio (NWC-to-Sales) measures the percentage of operating capital tied up in day-to-day operations relative to annual revenue: NWC-to-Sales = (Net Working Capital / Net Sales Revenue) * 100%. Expressed in days, it shows how many days of annual sales are locked up in operating liquidity. A lower positive ratio or negative ratio indicates lean working capital and high cash efficiency.
Total Net Working Capital includes all current assets minus all current liabilities. Operating Net Working Capital (OWC) excludes excess cash, marketable securities, and short-term interest-bearing debt, isolating the pure operational commitments: Operating NWC = (Accounts Receivable + Inventory + Other Operating Current Assets) - (Accounts Payable + Accrued Operating Expenses).
A negative NWC-to-Sales ratio indicates that a company generates cash from its working capital cycle rather than absorbing it. Typical in high-velocity retail, supermarkets, and subscription businesses, customers pay immediately (or upfront), while suppliers are paid on credit terms (e.g., 45-60 days), effectively allowing suppliers and customers to finance business expansion.
The NWC-to-Sales ratio determines the working capital cash drag of revenue expansion. If a company maintains a 15% NWC-to-Sales ratio, every $1,000,000 in top-line growth requires an additional $150,000 in cash locked into receivables and inventory. If operating cash flow is insufficient to fund this working capital drag, growing companies can experience acute cash insolvency despite reporting healthy accounting profits.