Working Capital Forecasting
Working Capital Forecasting projects the future trajectory of operating working capital — Accounts Receivable + Inventory − Accounts Payable — over a 12-24 month horizon, broken down by the underlying drivers (DSO, DIO, DPO) rather than as a single line item. The output is twofold: (1) a working capital BALANCE forecast that feeds the projected balance sheet, and (2) a CHANGE-in-working-capital forecast that feeds the cash flow statement. For growing companies, WC growth consumes cash before profit produces it: every additional $1M of ARR at 60-day DSO ties up roughly $164K of cash you'll never see until you collect. Most CFOs forecast revenue obsessively and forecast working capital as a plug — that's how 'profitable' companies miss payroll.
The Trap
The biggest trap is forecasting working capital as a flat percentage of revenue (e.g., 'AR will stay at 18% of revenue'). Working capital ratios drift constantly: enterprise customers stretch payment terms during their own cash crunches, inventory builds ahead of seasonal peaks, vendors tighten terms when your credit deteriorates. Forecasting WC as a plug masks the underlying behavioral changes. The second trap is ignoring the cash drag of growth: a company growing 80% YoY with 60-day DSO and 45-day DIO will consume working capital faster than EBITDA can fund it — even if margins are healthy. Atlassian, despite negative working capital from prepayments, had to plan WC carefully at the IPO because enterprise contract billing patterns shifted as they moved upmarket.
What to Do
Forecast each working capital component separately by its underlying driver: AR via DSO × forecasted revenue / 365, Inventory via DIO × forecasted COGS / 365, AP via DPO × forecasted COGS / 365. Build three scenarios — Base (current DSO/DIO/DPO), Stress (DSO +15 days, DPO −10 days, mimicking customer/vendor pressure), and Best (improvements from collections process or vendor negotiation). Calculate Change in WC monthly and integrate it into the cash flow forecast. Set WC days targets per business segment and review variance monthly. Hold the FP&A team accountable for forecast accuracy on WC, not just revenue.
Formula
In Practice
Atlassian's 10-K filings reveal one of the cleanest working capital stories in SaaS: because customers prepay annual contracts, deferred revenue funds operations and operating working capital is structurally NEGATIVE — i.e., growth GENERATES cash rather than consuming it. As Atlassian crossed $2B in revenue, deferred revenue exceeded $1.2B, and the company never raised primary capital after IPO. Compare that to Beyond Meat, which IPO'd with strong revenue growth but WC consumption of ~25% of incremental revenue (high inventory days for a perishable product, customer DSOs over 50 days). When growth slowed, the cash conversion problem surfaced — by 2023, Beyond Meat had drawn its credit facility and refinanced convertible notes at distressed terms.
Pro Tips
- 01
KnowMBA POV: scenario planning that doesn't include downside cases is just optimism with a spreadsheet. Every WC forecast must include a 'recession-pattern' scenario where DSO extends by 15+ days simultaneously across the customer base — this is what actually happens in 2008-style or 2020-style shocks.
- 02
The single biggest forecast error in WC is assuming all customers behave the same. Segment AR forecasts by customer cohort: enterprise (Net 60-90), mid-market (Net 30-45), SMB (credit card / immediate). A blended DSO assumption hides the real risk concentration.
- 03
Forecast AP days carefully when you're growing fast. Vendors initially offer Net 30, but as your spend grows they'll often grant Net 45 or Net 60 — extending DPO is a free source of working capital that most CFOs leave on the table.
Myth vs Reality
Myth
“Working capital forecasts only matter for inventory-heavy businesses”
Reality
Wrong. SaaS, services, and even pure-software businesses have material WC dynamics. SaaS has DSO and deferred revenue. Services firms have WIP and unbilled receivables. Even Datadog's 10-K disclosures show that WC swings drove $50-100M of quarter-to-quarter cash flow variance.
Myth
“If I'm growing and profitable, working capital will take care of itself”
Reality
Backwards. The faster you grow, the more cash WC consumes (unless deferred revenue is structurally negative). High-growth companies regularly burn cash from WC even while reporting positive EBITDA. The Atlassian-style negative WC is the exception, not the rule.
Try it
Run the numbers.
Pressure-test the concept against your own knowledge — answer the challenge or try the live scenario.
Knowledge Check
A B2B SaaS company is growing ARR from $20M to $40M over 12 months. DSO is 65 days, deferred revenue grows in line with ARR (annual prepay), and there's no inventory. Roughly how much cash will working capital CONSUME or GENERATE?
Industry benchmarks
Is your number good?
Calibrate against real-world tiers. Use these ranges as targets — not absolutes.
Net Working Capital as % of Revenue
Cross-industry; SaaS skews negative, manufacturing skews 20-30%Negative WC (Best)
< 0% (Atlassian, Apple, Veeva)
Lean
0-10%
Average
10-20%
Heavy
20-35% (industrial / inventory)
Cash Trap
> 35%
Source: Bessemer Cloud Index, S&P Capital IQ industry composites
Real-world cases
Companies that lived this.
Verified narratives with the numbers that prove (or break) the concept.
Atlassian
2015 IPO through 2024
Atlassian's 10-K filings (2015 onward) document one of the cleanest negative working capital stories in tech. Annual prepayment by customers means deferred revenue grows ahead of recognized revenue. By FY2024, deferred revenue exceeded $1.6B, and operating WC remained structurally negative. Atlassian raised no primary equity after IPO and funded all growth (including the Trello acquisition's cash component) from operations. The forecasting team explicitly models deferred revenue by customer cohort and contract length.
Revenue (FY2024)
$4.4B
Deferred Revenue
~$1.6B
Net Operating WC
Negative (structural)
Primary Equity Raised Post-IPO
$0
Annual prepayment is a cash flow superpower — but only if your forecasting team explicitly models it by cohort. Treating deferred revenue as a black-box plug masks the dynamics that drive funding decisions.
Beyond Meat
2019-2023
Beyond Meat IPO'd in 2019 with explosive revenue growth (240% YoY) but high working capital intensity: perishable inventory required ~50 days of inventory, customer DSO crept above 50 days, and vendor terms remained tight. As revenue growth decelerated in 2022-2023, WC stayed elevated while revenue fell — creating a cash trap. Internal forecasts reportedly underestimated DSO extension as retail customers (Walmart, grocery chains) renegotiated terms during the demand slowdown. By 2023, Beyond Meat drew on its credit facility and restructured convertible notes at distressed terms.
Peak Revenue
$465M (2021)
Revenue (2023)
~$343M (declining)
WC Intensity
~25% of revenue
Outcome
Distressed refinancing
WC forecasts must include downside DSO scenarios. When revenue stalls but customers stretch payment, the cash impact compounds. Beyond Meat's forecasts missed this dynamic and the company was undercapitalized for the downturn.
Decision scenario
The Enterprise Customer DSO Decision
You're CFO of a $40M ARR B2B SaaS company growing 60% YoY. Your top 5 enterprise customers (40% of ARR) have asked to extend payment terms from Net 30 to Net 75. They cite their own cash management. If you decline, two of them have hinted at switching to a competitor at renewal in 6 months.
ARR
$40M
Current DSO
32 days
Cash on Hand
$18M
Monthly Burn
$1.5M
Top-5 Concentration
40% of ARR
Decision 1
If you accept Net 75 for the top 5 customers, blended DSO rises to ~50 days, AR grows by ~$2M, and forecast cash drops $2M lower than current plan. Not catastrophic — but you're modeling a scenario where Series C closes in 9 months. If you decline and lose 2 customers ($16M ARR × 2/5 = $6.4M ARR loss), it dents the Series C narrative.
Accept Net 75 for all 5 — preserve the customer relationships and the Series C revenue narrativeReveal
Negotiate selectively: accept Net 60 (not 75) only for the 2 customers explicitly threatening churn, with a 1.5% prompt-pay discount option for early payment✓ OptimalReveal
Related concepts
Keep connecting.
The concepts that orbit this one — each one sharpens the others.
Beyond the concept
Turn Working Capital Forecasting into a live operating decision.
Use this concept as the framing layer, then move into a diagnostic if it maps directly to a current bottleneck.
Typical response time: 24h · No retainer required
Turn Working Capital Forecasting into a live operating decision.
Use Working Capital Forecasting as the framing layer, then move into diagnostics or advisory if this maps directly to a current business bottleneck.