Working Capital Modeling
Working capital forecasting is one of the most overlooked aspects of financial modeling. Yet small errors in NWC assumptions can swing a DCF valuation by millions. In this guide, we’ll walk through how to forecast net working capital properly—including days-based methods, common pitfalls, and how to link it to free cash flow.
Net Working Capital (NWC) = Current Assets − Current Liabilities
What Is Net Working Capital?
Net working capital represents the short-term resources a company needs to fund operations. It’s the difference between current assets (cash, accounts receivable, inventory) and current liabilities (accounts payable, accrued expenses).
There are two interpretations:
- Operating NWC: Only operational items—excludes cash, debt, and dividends. This is what changes in NWC impact free cash flow.
- Total NWC: Includes all current assets and liabilities. Useful for balance sheet reconciliation but less relevant for cash flow analysis.
For financial modeling, use operating NWC. A change in NWC represents cash trapped in operations. When NWC increases, cash flow decreases. When NWC decreases, cash flow improves.
This is why NWC forecasting matters for DCF models: it directly flows into your free cash flow calculation and affects terminal value. Overestimate working capital needs, and you’ll overstate cash available to investors.
Key Working Capital Components
Build your working capital forecast by modeling each component separately. Here are the main drivers:
| Component | Classification | Driver | Formula |
|---|---|---|---|
| Accounts Receivable (AR) | Current Asset | Revenue | Revenue × (DSO / 365) |
| Inventory | Current Asset | Cost of Goods Sold | COGS × (DIO / 365) |
| Prepaid Expenses | Current Asset | Operating Expenses | OpEx × (% of prepaid / 365) |
| Accounts Payable (AP) | Current Liability | Cost of Goods Sold | COGS × (DPO / 365) |
| Accrued Expenses | Current Liability | Operating Expenses | OpEx × (% accrued / 365) |
The key insight: working capital components scale with revenue and expenses. Model each line separately, then roll up into your net working capital schedule.
Days-Based Forecasting Method
The most common approach—and the one we recommend—is the days-based method. It ties working capital directly to operational activity.
Days Sales Outstanding (DSO): How many days of revenue are tied up in accounts receivable.
DSO = (Accounts Receivable / Revenue) × 365A DSO of 45 means customers take 45 days on average to pay. To forecast AR, multiply next year’s revenue by (DSO / 365).
Days Inventory Outstanding (DIO): How many days of inventory the company holds.
DIO = (Inventory / COGS) × 365A DIO of 60 means inventory sits for 60 days before being sold. Forecast inventory by multiplying COGS by (DIO / 365).
Days Payable Outstanding (DPO): How long the company takes to pay suppliers.
DPO = (Accounts Payable / COGS) × 365A DPO of 45 means the company pays suppliers in 45 days. Higher DPO is better for cash flow—it’s essentially a free loan from suppliers.
Cash Conversion Cycle: The total time between paying suppliers and collecting from customers.
CCC = DSO + DIO − DPOA shorter CCC is better. It means less cash is tied up in operations. When modeling, calculate these metrics from historical financials, then assume they remain stable or improve gradually over the forecast period.
Percentage-of-Revenue Method
For quick models or when historical data is sparse, use the percentage-of-revenue method. Forecast NWC as a flat percentage of revenue.
Example: If historical NWC is 12% of revenue, assume 12% in your forecast.
NWC (Year 2) = Revenue (Year 2) × 12%This approach is simpler but less flexible. It works well for mature companies with stable working capital characteristics. For businesses with changing payment terms, inventory strategies, or growth patterns, use the days-based method instead.
Building the Working Capital Schedule
A proper working capital schedule has three parts: historical, bridge, and forecast.
- Historical (3–5 years): Pull actual NWC components from financial statements. Calculate DSO, DIO, DPO for each year. Look for trends.
- Bridge (1 year): Use the latest year as your base. Note any one-time items or changes that shouldn’t repeat.
- Forecast (5–10 years): Apply consistent assumptions. For most companies, assume DSO, DIO, and DPO stabilize or improve slightly. Don’t assume dramatic changes unless you have a specific operational reason.
If your company has seasonal revenue or inventory patterns, you may need to adjust working capital quarterly, not just annually. Retail companies often spike inventory in Q3 for holiday selling. Construction companies may have seasonal payment terms. Build this into your model if it materially affects cash flow.
Once you’ve forecasted each component (AR, inventory, payables, etc.), calculate change in NWC for each year. This is the cash impact.
ΔNWCt = NWCt − NWCt-1A positive change (NWC increased) is a cash outflow. A negative change (NWC decreased) is a cash inflow.
Working Capital and Free Cash Flow
Net working capital flows directly into free cash flow. Here’s the connection:
UFCF = EBIT(1 − Tax Rate) + D&A − CapEx − ΔNWCtChange in NWC is subtracted because it represents cash tied up in operations. A growing company typically has increasing NWC, which reduces FCF. A company in decline may see NWC decrease, boosting FCF.
In your terminal value, assume NWC stabilizes. A common assumption is that NWC as a percentage of revenue plateaus. This implies zero change in NWC in perpetuity, which simplifies the terminal value calculation.
For mature companies with stable growth, NWC assumptions have minimal impact. For high-growth companies, working capital can be a material FCF drag. This is why getting the details right matters.
Common Modeling Mistakes
Total NWC includes cash and debt. Operating NWC excludes them. Always use operating NWC for FCF calculations. Including cash creates circularity in your model.
An increase in NWC reduces cash flow (negative sign). A decrease in NWC increases cash flow (positive sign). Many modelers flip this and overstate valuation.
Don’t assume DSO improves by 1 day per year forever. Once a company reaches a stable DSO (based on industry standards), keep it flat. Improvements require operational changes, not magic.
Annual modeling misses seasonal cash flow impacts. If your company is seasonal, build quarterly working capital schedules or at least note when NWC peaks and troughs within the year.
AR should scale with revenue (not COGS). Inventory and AP should scale with COGS (not revenue). Accrued expenses scale with OpEx. Mixing these denominators distorts your forecast.
Key Takeaways
- Operating NWC = Current Assets (ex-cash) − Current Liabilities (ex-debt)
- Forecast NWC using days-based metrics: DSO, DIO, DPO. Link to revenue and COGS.
- Calculate change in NWC each year. This directly reduces free cash flow.
- In terminal value, assume NWC stabilizes as a % of revenue.
- High-growth companies tie up significant cash in working capital. Don’t underestimate this impact.
- Cross-check your assumptions against industry benchmarks and historical performance.
Frequently Asked Questions
What’s a typical DSO for different industries?
DSO varies widely. Tech companies (subscription or SaaS) often have DSO under 30 days. Manufacturing typically ranges 40–60 days. Wholesale and distribution: 60–90 days. Always benchmark against peers in your industry.
Should I include deferred revenue in working capital?
Deferred revenue (a liability) reduces NWC, which is good for cash flow. It’s already included in current liabilities if it’s classified correctly on the balance sheet. Don’t double-count it. Include it in your operating NWC calculation.
How do I handle working capital in a seasonally adjusted model?
Build a quarterly or monthly schedule for NWC during the forecast period. Calculate change in NWC each quarter. This will show when cash is absorbed (inventory build) and when it’s released (post-season paydown). For annual models, use an average NWC or the year-end balance, but note the timing mismatch.
What if a company reduces NWC in the terminal year?
If you assume NWC decreases at the end of the forecast period (company winds down inventory, collects all AR), that’s a cash inflow in your terminal year calculation. However, in perpetuity value, NWC as a % of revenue should be stable or growing at the terminal growth rate. Be consistent with your revenue growth assumption.
How sensitive is valuation to working capital assumptions?
Run a sensitivity analysis. A 5–10% change in NWC assumptions typically swings valuation by 5–15%, depending on forecast period and growth rate. For high-growth companies, NWC sensitivity is even higher. Always test your assumptions.
Related Resources
- Three-Statement Model: How to Build and Link Financials
- Revenue Forecasting Methods
- Expense Modeling and COGS Assumptions
- DCF Valuation: Complete Guide
- Debt Schedule Modeling
- Working Capital Glossary Entry
- Accounts Receivable Glossary Entry
- Accounts Payable Glossary Entry
- Inventory Turnover Glossary Entry
- Free Cash Flow Glossary Entry
- Operating Cash Flow Glossary Entry
- Cash Flow Statement Glossary Entry
- Balance Sheet Glossary Entry
- Revenue Glossary Entry
- Financial Statements Cheat Sheet