Formula
Current assets = cash and equivalents + accounts receivable + inventory + other current assets. Current liabilities = accounts payable + short-term debt and current loan payments + other current liabilities. Net working capital = current assets − current liabilities.
Current ratio = current assets ÷ current liabilities. Quick ratio = (cash and equivalents + accounts receivable) ÷ current liabilities.
Days sales outstanding = accounts receivable ÷ annual revenue × 365. Days inventory outstanding = inventory ÷ annual cost of goods sold × 365. Days payable outstanding = accounts payable ÷ annual cost of goods sold × 365.
Cash conversion cycle = DSO + DIO − DPO, in days.
Worked examples
Example 1: the default balance sheet of a $900,000 business
Current assets = $25,000 cash + $60,000 receivables + $40,000 inventory + $5,000 other = $130,000. Current liabilities = $35,000 payables + $30,000 short-term debt + $10,000 other = $75,000. Net working capital = $130,000 − $75,000 = $55,000. Current ratio = $130,000 ÷ $75,000 = 1.73. Quick ratio = ($25,000 + $60,000) ÷ $75,000 = $85,000 ÷ $75,000 = 1.13. DSO = $60,000 ÷ $900,000 × 365 = 0.0667 × 365 = 24.3 days, shown as 24. DIO = $40,000 ÷ $540,000 × 365 = 27.0 days, shown as 27. DPO = $35,000 ÷ $540,000 × 365 = 23.7 days, shown as 24. Cash conversion cycle = 24.3 + 27.0 − 23.7 = 27.7 days, shown as 28. Reading: the business collects in under a month, turns inventory in under a month and pays suppliers in a little over three weeks, so cash is tied up for about four weeks per cycle. At $900,000 ÷ 365 = $2,466 of daily revenue, that is roughly $68,000 of working capital permanently in use, which the $55,000 of net working capital mostly covers.
Example 2: a service business with negative working capital
Cash $8,000; receivables $20,000; inventory $0; other current assets $2,000; payables $15,000; short-term debt $25,000; other current liabilities $5,000; revenue $400,000; cost of goods sold $160,000. Current assets = $30,000. Current liabilities = $45,000. Net working capital = −$15,000. Current ratio = $30,000 ÷ $45,000 = 0.67. Quick ratio = $28,000 ÷ $45,000 = 0.62. DSO = $20,000 ÷ $400,000 × 365 = 18.3 days, shown as 18. DIO = 0. DPO = $15,000 ÷ $160,000 × 365 = 34.2 days, shown as 34. Cycle = 18.3 + 0 − 34.2 = −16 days: the business is paid by customers before it pays suppliers, which is a good operating position. The problem is elsewhere. The $25,000 of short-term debt, probably the next twelve months of loan or advance payments, is what pushes liabilities above assets. The fix is not more working capital; it is terming out the short-term debt, which the refinance calculator models.
Example 3: a $2.4 million distributor with a long cycle
Cash $50,000; receivables $150,000; inventory $120,000; other $10,000; payables $80,000; short-term debt $40,000; other liabilities $20,000; revenue $2,400,000; cost of goods sold $1,680,000. Current assets = $330,000; current liabilities = $140,000; net working capital = $190,000. Current ratio = 2.36; quick ratio = $200,000 ÷ $140,000 = 1.43. DSO = $150,000 ÷ $2,400,000 × 365 = 22.8 days, shown as 23. DIO = $120,000 ÷ $1,680,000 × 365 = 26.1 days, shown as 26. DPO = $80,000 ÷ $1,680,000 × 365 = 17.4 days, shown as 17. Cycle = 22.8 + 26.1 − 17.4 = 31.5 days, shown as 32. The ratios are strong, but notice DPO: the business pays suppliers in 17 days while collecting in 23. Negotiating net-30 terms with suppliers would lift DPO to around 30, cut the cycle to about 19 days and release roughly $80,000 of cash (12 days × $6,575 of daily revenue), with no borrowing at all.