Working Capital Forecast: Model Cash Tied Up in Operations

Key Takeaways

• A working capital forecast projects receivables, inventory, and payables using DSO, DIO, and DPO ratios derived from revenue and COGS, then converts period-over-period changes into cash flow adjustments.
• A distributor growing revenue 15 percent while holding DSO at 40 days and DIO at 50 days sees a 19 million net working capital drag that reduces operating cash flow, profitable but cash-consuming growth.
• The most common error is mixing up signs: an increase in accounts receivable is a use of cash on the cash flow statement even though the balance rises on the balance sheet.
• For any company with significant inventory or extended collection cycles, working capital dynamics can make the difference between a cash-generative and a cash-consuming investment thesis.

What It Is

Operating working capital typically includes accounts receivable (A/R), inventory, other current assets, accounts payable (A/P), and accrued expenses. Cash, marketable securities, short-term debt, and the current portion of long-term debt are excluded because they belong to the financing side of the model.

A working capital build forecasts each line separately, using activity ratios tied to revenue or COGS, then computes the period-over-period change. That change is what hits the cash flow statement. An increase in A/R or inventory is a use of cash; an increase in A/P is a source of cash.

The Intuition

Profitable companies can still run out of cash. If sales grow 30 percent but customers take 90 days to pay, A/R balloons and cash comes in much later than profit is recognized. Working capital captures that timing gap.

Days-based metrics make this intuitive. DSO tells you roughly how many days of revenue are tied up in uncollected invoices. DIO tells you how many days of COGS are sitting as inventory on the shelf. DPO tells you how many days you are stretching your suppliers. Growth that comes with a lengthening DSO is lower quality than growth that does not.

How It Works

Three metrics do most of the work.

DSO = (Accounts receivable / Revenue) x 365
DIO = (Inventory / COGS) x 365
DPO = (Accounts payable / COGS) x 365

To forecast, pick a target DSO, DIO, and DPO for each future period (often held flat at recent historical levels), then back into the balance sheet accounts.

Forecast A/R       = Revenue x DSO / 365
Forecast Inventory = COGS x DIO / 365
Forecast A/P       = COGS x DPO / 365

The change in each item period over period is the adjustment on the cash flow statement:

Change in working capital = (Increase in operating current assets)
                          - (Increase in operating current liabilities)

A rise in A/R reduces cash flow. A rise in A/P increases it. The same logic applies to other accruals. An alternative is to forecast each line directly as a percentage of revenue or COGS. The days-based method is usually preferred because it has a clearer operational meaning and connects to the cash conversion cycle (DSO plus DIO minus DPO).

Worked Example

A hypothetical distributor reports the following year 0 numbers.

Revenue                1,000
COGS                     700
A/R                      110    DSO = 110 / 1,000 x 365 = 40 days
Inventory                 96    DIO = 96 / 700 x 365   = 50 days
A/P                       77    DPO = 77 / 700 x 365   = 40 days

Year 1 forecast assumes 15 percent revenue growth, COGS margin held constant, and working capital days held at historical levels.

Revenue                1,150
COGS                     805
A/R                      126    (1,150 x 40 / 365)
Inventory                110    (805 x 50 / 365)
A/P                       88    (805 x 40 / 365)

Change in A/R            +16   (use of cash)
Change in inventory      +14   (use of cash)
Change in A/P            +11   (source of cash)
Change in WC             (19)  net drag on cash flow

Operating cash flow in year 1 is net income plus depreciation minus 19 from working capital. If growth is real and sustained, this investment in working capital is normal. If the DSO creeps from 40 to 55 days, the drag doubles, and the model should show it.

Common Mistakes

1. Using revenue in the DPO formula. DPO compares payables to purchases, and COGS is the better proxy for purchases than revenue. Using revenue inflates DPO and understates the working capital drag from growth.

2. Forgetting to reverse the sign. An increase in A/R is a use of cash (negative on the cash flow statement), but the account balance itself goes up (positive on the balance sheet). Mixing the signs is a classic source of broken models.

3. Holding days flat while the business changes. A company moving from enterprise contracts to self-serve subscriptions will see DSO collapse. A manufacturer adding a second distribution center will see DIO rise. Historical ratios are a starting point, not a destination.

4. Ignoring seasonal intra-year swings. A retailer builds inventory in Q3 ahead of the holidays and collects cash in Q4. A year-end snapshot misses the peak working capital need. Quarterly models catch this; annual models do not.

5. Double-counting in the cash flow statement. The change in working capital comes from the balance sheet build and is the only place those items should affect cash. Listing A/R and A/P separately on the cash flow statement in addition to the net change is a redundancy that can drift out of sync.

Frequently Asked Questions

Q: What is a working capital forecast in simple terms? A working capital forecast projects how much cash is tied up in receivables, inventory, and payables at each period end by applying days-based ratios to projected revenue and COGS, then feeds the changes into the cash flow statement.

Q: How does a working capital forecast affect investment decisions? It determines the quality of earnings growth. A company whose revenue grows 30 percent but whose DSO climbs from 40 to 60 days is consuming significantly more cash than profit implies, which matters for free cash flow and dividend sustainability.

Q: What is a real-world example of a working capital forecast? A distributor with 1,000 in revenue and DSO of 40 days has 110 in receivables. If revenue grows to 1,150 with DSO held constant, receivables rise to 126, a 16 million cash drag that reduces operating cash flow by that amount regardless of reported net income.

Q: How can investors use a working capital forecast? Investors should watch whether DSO, DIO, and DPO are stable or drifting. A rising DSO can signal collection problems or aggressive revenue recognition; a rising DPO may indicate the company is stretching suppliers under financial pressure.

Q: How is a working capital forecast different from just reading the balance sheet? The balance sheet shows a snapshot at one point in time. A working capital forecast shows the trend in days ratios and translates those trends into cash flow impacts, making it possible to see whether growth is absorbing or releasing cash before reading the actual cash flow statement.

Sources

1. Wall Street Prep. "Working Capital Cycle." https://www.wallstreetprep.com/knowledge/working-capital-cycle/
2. Wall Street Prep. "Days Sales Outstanding (DSO)." https://www.wallstreetprep.com/knowledge/days-sales-outstanding-dso/
3. Wall Street Prep. "Days Payable Outstanding (DPO)." https://www.wallstreetprep.com/knowledge/days-payable-outstanding-dpo/
4. AnalystPrep. "Approaches to Forecasting a Company's Operating Expenses and Working Capital." https://analystprep.com/cfa-level-1-exam/equity/approaches-to-forecasting-a-companys-operating-expenses-and-working-capital/

Disclaimer

This article is educational content only and is not financial advice. Nothing here is a recommendation to buy, sell, or hold any security. Consult a licensed advisor before making investment decisions.