Projecting Working Capital Changes
Operating profit minus CapEx is not free cash flow. There is one more deduction that many beginners miss: changes in working capital. A company that grows 30% but requires its customers to pay in 60 days, buys materials 30 days in advance, and pays suppliers in 45 days will burn significant cash just to finance its growth. That cash burn is the working capital change, and it can be the difference between a company that appears profitable and one that is actually drowning in growth.
This article teaches you to project working capital changes and incorporate them into your DCF. You will learn the mechanics of the cash conversion cycle, how growth changes working capital requirements, and how to estimate the cash impact on your free cash flow forecast.
Quick definition: Working capital is the short-term assets and liabilities needed to run the business day-to-day (receivables, inventory, payables). A change in working capital is the cash consumed (or released) when these items grow or shrink. Projecting working capital change means estimating how much incremental cash is tied up as the business grows.
Key Takeaways
- Working capital change is cash paid out of (or into) the business due to changes in receivables, inventory, and payables. Positive change means cash used; negative change means cash released.
- The cash conversion cycle (DIO + DSO − DPO) determines how much working capital a business needs. A company with a 90-day cycle uses 90 days of revenue in working capital.
- Growth drives working capital change. A company growing 30% requires 30% more receivables, inventory, and payables. If growth decelerates, working capital can be a source of cash.
- Most mature companies run at relatively flat working capital (as a percentage of revenue). Growth companies require increasing working capital.
- Work through the cycle: forecast days inventory outstanding (DIO), days sales outstanding (DSO), and days payables outstanding (DPO) independently, then calculate the implied working capital change.
- Reversals matter: if a company cuts inventory or accelerates collection, working capital becomes a source of cash (negative change), boosting FCF in that year only.
The Mechanics: From Working Capital to Cash Impact
Working capital is the sum of current assets minus current liabilities:
Working Capital = (Receivables + Inventory + Prepaid Expenses)
− (Payables + Accrued Expenses + Short-term Debt)
For DCF purposes, focus on the three big components:
- Receivables (accounts receivable): Cash owed by customers.
- Inventory (stock, materials, work-in-progress): Products waiting to be sold or converted.
- Payables (accounts payable): Cash owed to suppliers.
When these items change, they consume or release cash:
- If receivables grow $10M (customers owe more money), the company has extended credit and used $10M of cash.
- If inventory grows $5M (more stock on hand), the company has bought more materials and used $5M of cash.
- If payables grow $7M (you owe suppliers more), the company has deferred payment and released $7M of cash.
Net working capital change = $10M + $5M − $7M = $8M of cash used.
In your free cash flow calculation:
Free Cash Flow = Operating Profit − Taxes − CapEx − Change in Working Capital
If working capital change is positive (cash used), it reduces FCF. If negative (cash released), it increases FCF.
The Cash Conversion Cycle: Understanding Working Capital Needs
The cash conversion cycle (CCC) is the number of days between when a company pays for inventory and when it receives cash from customers.
CCC = Days Inventory Outstanding (DIO)
+ Days Sales Outstanding (DSO)
− Days Payables Outstanding (DPO)
Days Inventory Outstanding (DIO): How long, on average, inventory sits before being sold.
- Formula: Inventory / (COGS / 365)
- Interpretation: A company with $500M COGS and $100M inventory has DIO = $100M / ($500M/365) = 73 days.
Days Sales Outstanding (DSO): How long, on average, before customers pay.
- Formula: Receivables / (Revenue / 365)
- Interpretation: A company with $2B revenue and $200M receivables has DSO = $200M / ($2B/365) = 36 days.
Days Payables Outstanding (DPO): How long, on average, before you pay suppliers.
- Formula: Payables / (COGS / 365)
- Interpretation: A company with $500M COGS and $150M payables has DPO = $150M / ($500M/365) = 110 days.
Cash Conversion Cycle: CCC = 73 + 36 − 110 = −1 day.
A negative CCC is magical: the company receives cash from customers before it has to pay suppliers. This is common in retail (you sell before you pay) and some e-commerce businesses.
A positive CCC means the company has to finance working capital. A manufacturer with a 60-day CCC has to fund 60 days of revenue in working capital. A $1B revenue company with 60-day CCC carries $164M in net working capital ($1B / 365 × 60).
Projecting Working Capital Components: The Ground-Up Approach
Rather than projecting net working capital as a percentage of revenue (which is lazy), build it component by component.
Step 1: Project DIO for each business segment.
DIO depends on inventory management practices and product type:
- High-tech (fast inventory turns): 20–40 days.
- Apparel (seasonal): 60–120 days.
- Pharmaceuticals (high-value products, long shelf life): 80–150 days.
- Grocery (perishable, rapid turns): 20–40 days.
If a company is improving operations (better demand forecasting, just-in-time manufacturing, dropshipping), DIO declines. If it is expanding product lines or entering new geographies (requiring safety stock), DIO might increase.
Example projection for a manufacturer currently at DIO of 70 days:
| Year | Revenue ($M) | COGS ($M) | DIO Days | Inventory ($M) |
|---|---|---|---|---|
| 2024A | $1,000 | $600 | 70 | $116 |
| 2025E | $1,100 | $660 | 68 | $123 |
| 2026E | $1,210 | $726 | 66 | $131 |
| 2027E | $1,331 | $799 | 65 | $141 |
Inventory grows, but DIO declines (improving turns). This reflects operational improvements (scale leverage in supply chain, better forecasting).
Step 2: Project DSO for each customer segment.
DSO depends on payment terms, customer concentration, and collection efficiency:
- Cash customers (retail, e-commerce): 0–10 days.
- Net-30 customers (typical B2B): 30–45 days.
- Net-60/90 customers (large customers, project-based): 60–120 days.
If a company is shifting from direct sales (cash terms) to distribution (Net-30), DSO increases. If it is improving collections or offering early-payment discounts, DSO declines.
Example for a B2B software company:
| Year | Revenue ($M) | DSO Days | Receivables ($M) |
|---|---|---|---|
| 2024A | $500 | 45 | $62 |
| 2025E | $600 | 44 | $73 |
| 2026E | $720 | 43 | $85 |
| 2027E | $864 | 42 | $100 |
Receivables grow with revenue, but DSO improves (better collections, higher mix of e-commerce where customers pay upfront).
Step 3: Project DPO for each supplier/cost category.
DPO depends on negotiating power with suppliers and payment practices:
- Cash on delivery: 0 days.
- Net-30: 30 days.
- Net-60: 60 days.
- Large companies can negotiate Net-90+.
If a company is growing and has increasing bargaining power with suppliers, DPO might improve. If it is losing negotiating power (small competitor facing dominant suppliers), DPO might decline.
Example:
| Year | COGS ($M) | DPO Days | Payables ($M) |
|---|---|---|---|
| 2024A | $600 | 45 | $74 |
| 2025E | $660 | 46 | $83 |
| 2026E | $726 | 47 | $94 |
| 2027E | $799 | 48 | $105 |
Payables grow as the company scales and negotiates longer payment terms.
Step 4: Calculate CCC and working capital change.
| Year | DIO | DSO | DPO | CCC | NWC* ($M) | Change ($M) |
|---|---|---|---|---|---|---|
| 2024A | 70 | 45 | 45 | 70 | $191 | — |
| 2025E | 68 | 44 | 46 | 66 | $203 | $12 |
| 2026E | 66 | 43 | 47 | 62 | $214 | $11 |
| 2027E | 65 | 42 | 48 | 59 | $224 | $10 |
*NWC = Net working capital as a percentage of revenue.
Working capital grows each year (change is positive = cash used), but the rate of change decelerates. In 2025, growing from $191M to $203M uses $12M of cash. By 2027, growing from $214M to $224M uses only $10M (because the percentage of revenue is stable and revenue growth is decelerating).
Working Capital by Business Model
Different business models have radically different working capital needs.
Manufacturing:
- High DIO (inventory at multiple stages: raw materials, WIP, finished goods).
- Moderate DSO (B2B customers, Net-30/60).
- Moderate DPO (suppliers have negotiating power).
- CCC: typically 40–80 days.
Retail:
- Moderate DIO (inventory sits on shelves, high turns).
- Low DSO (mostly cash/credit card customers, paid in 1–3 days).
- Moderate to long DPO (negotiating power with suppliers, especially large retailers).
- CCC: can be negative (customer pays before inventory is paid for).
SaaS/Software:
- Zero DIO (no physical inventory).
- Moderate DSO (enterprise customers, Net-30).
- Moderate DPO (contractors, cloud providers, Net-30).
- CCC: typically 0–30 days.
E-commerce:
- Moderate DIO (inventory at warehouses, high turns if managed well).
- Very low DSO (customers pay via card immediately).
- Long DPO (negotiating power with suppliers, payment terms often Net-30–60).
- CCC: often negative.
Consulting/Services:
- Zero or low DIO (no inventory; billable hours or retainers).
- Moderate DSO (invoicing after delivery; Net-30 standard).
- Low DPO (contractors are paid promptly).
- CCC: typically 30–60 days.
These differences matter enormously. A retailer with negative working capital grows faster with less cash burn than a manufacturer with 60-day CCC.
Growth and Working Capital: The Critical Dynamic
A company growing 30% requires 30% more working capital (all else equal). This is the major source of cash burn for fast-growing companies.
Example:
| Metric | 2024 | 2025E |
|---|---|---|
| Revenue | $1,000M | $1,300M |
| Growth | — | 30% |
| COGS | $600M | $780M |
| Inventory (at DIO=70) | $116M | $151M |
| Receivables (at DSO=45) | $124M | $161M |
| Payables (at DPO=45) | $74M | $96M |
| Net Working Capital | $166M | $216M |
| Change | — | $50M |
A 30% revenue growth required a 30% increase in net working capital ($166M to $216M). That $50M of cash is used to finance growth. It is real cash, even though the company is growing and profitable.
This is why many fast-growing companies raise capital: not because they are unprofitable, but because growth consumes cash through working capital expansion.
Reversals: When Working Capital Becomes a Cash Source
If a company's growth decelerates or it improves working capital efficiency, working capital can become a source of cash (negative change).
Example:
| Scenario | Year | Revenue Growth | NWC Change | FCF Impact |
|---|---|---|---|---|
| Deceleration | 2027 | 10% | −$5M | Positive (frees cash) |
| Inventory optimization | 2027 | 15% | −$8M | Positive (frees cash) |
| Increase in payables terms | 2027 | 15% | −$3M | Positive (frees cash) |
In your DCF, these reversals typically occur in later years of the forecast as growth slows. They can be material to terminal value. If a company transitions from 20% growth (requiring $20M NWC add) to 3% growth (requiring $3M NWC add), it frees roughly $17M of cash in that transition year.
Common Working Capital Projection Mistakes
1. Assuming working capital is a fixed percentage of revenue forever. In reality, as a company matures, working capital often declines as a percentage of revenue (through operational improvements). It can also increase (if the company enters low-DSO, high-DIO segments). Change the percentage as conditions change, not keep it constant.
2. Ignoring seasonal working capital spikes. Retail has massive inventory build before the holidays, then sharp inventory draw-down. A quarterly (or seasonal) analysis would reveal this; annual projections average it out. For companies with strong seasonality, use an average annual figure, but acknowledge the lumps in sensitivity analysis.
3. Missing the impact of growth on working capital. You project 20% revenue growth and assume 15% working capital growth (efficiency gains). But if the company is reinvesting aggressively in infrastructure, working capital might grow 25%. The delta is cash used, reducing FCF.
4. Assuming improvements in working capital metrics forever. You project DSO declining 2 days per year for 10 years. Realistically, DSO reaches a floor (you cannot get below 0 days, and practical minima for different businesses are obvious). Assume improvements decelerate and plateau.
5. Ignoring extraordinary working capital swings. A company might raise inventory ahead of a major customer contract, or clear payables to improve credit ratings before a refinancing. These are one-time, not recurring. Separate them from normalized working capital change.
6. Not accounting for change in deferred revenue / liabilities. SaaS companies collect upfront and recognize revenue over time. This creates a deferred revenue liability (a source of working capital). As the company grows, deferred revenue grows, freeing cash. Include this in your model if it is material.
Real-World Examples
Example 1: Amazon (2010–2020)
Amazon's CCC moved from slightly positive to deeply negative over the period:
- 2010: CCC ~30 days (paying suppliers, holding inventory, but customers paying in 1–2 days).
- 2015: CCC ~0 days (massive scale, negotiated longer supplier terms, rapid inventory turns).
- 2020: CCC −10 days (customers pay upfront; suppliers get paid in Net-30/60).
This negative CCC is a massive source of cash. Growing from $35B to $386B revenue in 10 years should have required enormous working capital increases. Instead, operational leverage in the supply chain turned working capital into a cash source. This is why Amazon could scale e-commerce and AWS while generating cash, even in growth phases.
Example 2: Ford Motor (Cyclical)
In cyclical businesses, working capital is a huge cash driver:
- 2019 (recovery year): Revenue $155B. Working capital build ~$3–5B (growing inventories for anticipated demand).
- 2020 (recession): Revenue $127B. Working capital released ~$5–7B (clearing inventory, reducing production).
The working capital swing (plus CapEx cuts) explained much of Ford's cash flow volatility across the cycle.
Example 3: Starbucks (Retail Leverage)
Starbucks has negative working capital:
- Customers pay at point of sale (DSO ~0).
- Suppliers grant Net-30 terms (DPO ~30).
- Inventory turns rapidly (DIO ~15).
- CCC ~−15 days.
This means Starbucks receives cash from customers before paying suppliers. Growing 10% actually releases ~$100M working capital (frees cash). This is a huge advantage in the capital-light café model.
Frequently Asked Questions
Q: How do I handle deferred revenue in my working capital projection?
A: Deferred revenue (a liability) reduces net working capital needs. For SaaS companies, if you collect 12 months upfront but recognize over 12 months, deferred revenue is typically 30–50% of annual revenue. As a company scales, deferred revenue grows, actually releasing cash (it is a use of customer cash, not company cash, so it acts like a negative working capital). Include it explicitly in your NWC calculation or hold it separate.
Q: Should I assume working capital reaches a steady state (as a % of revenue) by the terminal value?
A: Yes. In years 8–10 and beyond, working capital as a percentage of revenue should stabilize. A mature manufacturing company runs at, say, 18% NWC/revenue. A retail company at 5%. Assume these ratios in your terminal value. In perpetuity, NWC change equals the growth rate × the NWC/revenue ratio.
Q: How do I model the cash impact of a company acquiring inventory for a known upcoming surge in sales?
A: Treat it as a one-time working capital adjustment. If a retailer builds inventory ahead of the holiday season, that is a one-time inventory increase (working capital use) in that quarter or year. In the following year, if the inventory is sold and working capital normalizes, there is a working capital release. Identify these discrete events separately.
Q: Is working capital change included in enterprise value calculations?
A: No. Enterprise value is the value of the business on a cash-free, debt-free basis. Working capital is embedded in the operating profit and CapEx projections. The DCF sums up all the FCF (which already deducts working capital changes), so it is already accounted for.
Q: Should I assume negative working capital (like Amazon's) continues indefinitely?
A: Yes, if the business model structurally supports it (customers pay upfront, you pay suppliers Net-30+). However, as a company matures and faces slower growth, the benefit of negative working capital diminishes. A company with $100B revenue growing at 2% and CCC of −10 days is still using only $500M in working capital annually (2% × $100B × 10/365), so the cash benefit is modest relative to the CapEx and other cash needs.
Q: How does inflation affect working capital projections?
A: High inflation increases the dollar amount of inventory and receivables (same physical units, higher prices). If DIO and DSO are stable (days), but prices inflate 10%, working capital inflates 10%. This is an implicit cash drain. Conversely, if a company can raise prices faster than input costs inflate (pricing power), the working capital burden per unit grows slower. Account for inflation in your projections, especially if modeled separately.
Related Concepts
- Operating cash flow (OCF): OCF = Operating income + D&A − Change in working capital − Taxes. Working capital change is a major component of the OCF to FCF bridge.
- Free cash flow conversion: FCF as a percentage of operating profit. Companies with high working capital change relative to operating profit have low FCF conversion.
- Cash conversion cycle management: Companies that improve CCC (reducing DIO, DSO, or increasing DPO) increase FCF without increasing profitability. This is a value driver.
Summary
Working capital change is the final bridge from operating profit to free cash flow. Rigorous projection requires forecasting the components of the cash conversion cycle—DIO, DSO, and DPO—independently, then calculating the cash impact as working capital grows or shrinks with the business. For growth companies, working capital change can be a material use of cash; for mature or capital-efficient companies, it can be negligible or even a source of cash. Most DCF errors related to working capital come from assuming constant percentages or ignoring the impact of growth on working capital needs.
A company that looks profitable can be cash-flow negative if its working capital change consumes more than its operating profit. Understanding and projecting this dynamic separates amateur DCF models from professional ones.
Next
Projecting effective tax rates — How to forecast the company's tax burden by territory, loss carryforwards, and changes in tax policy, and why tax assumptions are often overlooked but sometimes material to valuation.