Growth can create a cash problem long before it creates an income statement problem. A company may be adding customers, shipping more product, or signing larger contracts while cash becomes tighter each month. Leaders who know how to forecast working capital can see that pressure early, quantify its impact, and make operating decisions before liquidity becomes the constraint.
Working capital forecasting is not simply a finance exercise. It connects sales plans, customer payment behavior, purchasing commitments, hiring, inventory strategy, and vendor terms to the cash available to run the business. For founders and executive teams, it turns a static balance sheet into a forward-looking management tool.
What a working capital forecast should measure
At its core, working capital measures the short-term capital tied up in operating the business. The standard formula is:
Working capital = Current assets – Current liabilities
For operating forecasts, finance teams often focus more narrowly on net working capital:
Operating net working capital = Accounts receivable + Inventory + Other operating current assets – Accounts payable – Accrued operating liabilities
Cash and debt are usually excluded from this operating calculation because they are outcomes of the forecast, not operating drivers. The goal is to estimate how much cash the company will need to fund receivables, inventory, prepayments, and normal operating obligations as it grows.
A rising working capital balance is not automatically negative. It can reflect healthy growth, particularly for product businesses building inventory ahead of demand. The question is whether the investment is intentional, funded, and producing an acceptable return. A forecast makes that distinction visible.
How to forecast working capital: start with the right data
A dependable forecast begins with clean, reconciled financial data. Pull at least 12 months of monthly balance sheets, income statements, cash flow statements, accounts receivable aging, accounts payable aging, inventory reports, and sales data. If the business has material seasonality, two or three years of history will provide a stronger baseline.
Do not rely only on the last month’s balance sheet. A month-end receivables balance can be distorted by one large invoice, an unusually early customer payment, or a delayed vendor payment. Look for patterns in collection timing, purchasing cycles, customer concentration, and seasonal demand.
Before modeling, reconcile the underlying accounts. If accounts receivable aging does not agree to the general ledger, or inventory records do not match the balance sheet, the forecast will give executives false precision. A controller-level close process is often the first requirement for a forecast that management can trust.
Forecast each operating account from its real driver
The strongest models forecast individual balance sheet accounts rather than applying one broad percentage to revenue. A percentage-of-sales approach can be useful for a quick estimate, but it breaks down when sales mix, payment terms, inventory policies, or supplier terms change.
Accounts receivable
Accounts receivable is generally driven by revenue and collection timing. A common starting point is days sales outstanding, or DSO:
Forecast accounts receivable = Forecast credit sales / Days in period x DSO
If a company forecasts $900,000 of credit sales in a 30-day month and expects a 45-day DSO, forecast receivables would be approximately $1.35 million. That estimate should then be adjusted for customer-level realities. A business moving upmarket may have longer procurement and payment cycles. A company with a concentrated customer base should forecast major invoices and expected payment dates directly rather than relying only on an average DSO.
A falling DSO can improve near-term cash without increasing revenue. That makes collections discipline, clear invoicing, credit policies, and billing automation operational levers, not just accounting tasks.
Inventory and prepaid costs
Inventory should be forecast using cost of goods sold, purchasing lead times, safety stock requirements, and planned product launches. Days inventory outstanding, or DIO, provides a useful baseline:
Forecast inventory = Forecast cost of goods sold / Days in period x DIO
However, inventory is rarely smooth. Ecommerce, CPG, construction, and manufacturing businesses may need to place large orders well before sales occur. A monthly model should therefore include purchase-order timing and expected receipt dates. It should also distinguish between strategic stock built for growth and slow-moving inventory that may require a write-down.
Prepaid expenses deserve similar scrutiny. Annual insurance, software renewals, rent deposits, and professional-service retainers can create meaningful cash swings even when their income statement expense is recognized over time. Forecast the cash payment in the month it will occur, then model the amortization separately.
Accounts payable and accrued expenses
Accounts payable is driven by purchases and vendor payment terms, not revenue alone. Days payable outstanding, or DPO, provides a starting point:
Forecast accounts payable = Forecast credit purchases / Days in period x DPO
Using cost of goods sold as a proxy for purchases may be acceptable for a stable business, but it is less accurate when inventory is growing or shrinking. For a more useful forecast, build accounts payable from the purchasing plan and payment terms by key vendor.
Accrued payroll, commissions, bonuses, payroll taxes, and professional fees should also be forecast separately when material. These obligations often create cash pressure during periods of rapid hiring or variable compensation payouts.
Deferred revenue and industry-specific balances
Some growing companies have working capital dynamics that traditional formulas can miss. SaaS businesses that bill annually in advance may carry significant deferred revenue, a current liability that improves near-term cash conversion. Biotech companies may have grant receivables and milestone payments. Construction businesses may face retainage, mobilization costs, and project-specific billing schedules. Healthcare providers may contend with payer reimbursement delays.
These balances should not be forced into generic assumptions. Model the underlying contract terms, billing schedules, and expected cash receipts. The more material and volatile an account is, the more directly it should be forecast.
Build a rolling monthly model, then connect it to cash
For most startups and midsize businesses, a 13-week cash forecast and a 12- to 18-month monthly working capital forecast work well together. The 13-week view supports immediate payment, payroll, and liquidity decisions. The monthly model helps leadership assess hiring plans, growth investments, financing needs, and covenant compliance.
Each month, forecast revenue, cost of goods sold, operating expenses, capital expenditures, debt service, taxes, and the working capital accounts. The change in operating net working capital is then reflected in the cash flow forecast.
When receivables or inventory increase faster than payables and accrued liabilities, the business uses cash. When payables, accrued expenses, or deferred revenue increase faster than operating current assets, the business generates cash from working capital. This bridge is where a profit plan becomes a cash plan.
A forecast should also show the minimum cash balance by month, available borrowing capacity, and the timing of any expected shortfall. Those outputs give executives a decision window. They can improve collections, renegotiate terms, adjust purchasing, delay discretionary spending, revise hiring plans, or arrange capital while options remain available.
Pressure-test assumptions with scenarios
A single forecast can create false comfort. Build a base case, downside case, and upside case around the assumptions most likely to move cash. For many businesses, those variables include revenue timing, DSO, gross margin, inventory purchases, DPO, payroll growth, and major customer or vendor concentration.
The downside case should be plausible, not catastrophic. For example, test what happens if bookings close 30 days later, collections slow by 10 days, or a supplier requires a larger deposit. The objective is not to predict every risk. It is to understand which risks materially affect liquidity and how much response time the company has.
Treat forecast accuracy as an operating discipline
Forecasting improves through a monthly cadence. Compare actual balances and cash movements to forecast, identify the largest variances, and update assumptions based on evidence. If receivables repeatedly exceed plan, determine whether the cause is sales mix, invoice disputes, billing delays, or collections execution. Each cause requires a different response.
Executive ownership matters. Sales leadership should validate deal timing and customer payment expectations. Operations should validate inventory and procurement plans. HR should confirm hiring dates and compensation changes. Finance should challenge assumptions, maintain model integrity, and translate the result into clear decisions for leadership.
For organizations without a full internal finance team, an outsourced CFO and controller function can establish this operating rhythm while connecting strategic plans to day-to-day financial controls. K-38 Consulting helps leadership teams build forecasting processes that are practical enough to run monthly and detailed enough to support material decisions.
A working capital forecast earns its value when it changes what the company does next. Use it to decide when growth needs more funding, where cash is getting trapped, and which operational improvements will protect the runway without compromising the long-term plan.
