Working Capital Modeling: Inventory Cycles, Progress Billings, and Seasonality

Introduction

Working capital modeling is one of the most technically demanding and most frequently botched elements of cyclical industrials financial modeling. In most sectors, working capital is modeled as a stable percentage of revenue, changing proportionally as the business grows. In cyclical industrials, working capital behaves counterintuitively: it releases cash during downturns and absorbs cash during recoveries, creating a dynamic that can mask or amplify the true earnings trajectory when looking at free cash flow.

This counterintuitive behavior was introduced in the cyclicality flows through financials article in Section 2. This article provides the detailed modeling methodology: how to project inventory, receivables, and payables through the cycle, how to handle the special case of progress billings in defense and project businesses, and how to set the normalized working capital assumption for the DCF terminal year.

Industrial manufacturers carry significantly more working capital than asset-light businesses because of three factors.

Inventory. Manufacturers hold raw materials (steel, resins, components), work-in-process (partially completed products on the production line), and finished goods (completed products awaiting shipment). Total inventory can represent 60-120 days of cost of goods sold, depending on the complexity and cycle time of the manufacturing process. A heavy equipment OEM might carry $5-8 billion in inventory at any given time, representing a massive investment of working capital.

Accounts receivable. Industrial customers typically pay on 30-60 day terms (net 30 or net 60), and some government customers pay on even longer timelines. Receivables as a percentage of revenue are typically 15-25% for most industrial companies, with defense contractors sometimes higher due to government payment processing timelines.

Accounts payable. Industrial companies negotiate payment terms with their suppliers, typically 30-60 days. Payables partially offset the working capital investment in inventory and receivables. Companies with strong procurement leverage (large buyers that can dictate terms to smaller suppliers) achieve longer payment terms, reducing their net working capital investment.

Net Working Capital (Industrials)

Current operating assets (accounts receivable + inventory + prepaid expenses) minus current operating liabilities (accounts payable + accrued expenses), excluding cash and debt. For industrial manufacturers, net working capital typically ranges from 15-30% of annual revenue, with the variation driven by inventory intensity (manufacturing complexity, cycle time), receivable terms (customer mix, payment practices), and payable negotiation (supplier leverage). The ratio of net working capital to revenue is the primary metric for modeling working capital as a percentage of revenue in financial projections.

During a downturn, working capital releases cash through a predictable sequence:

1. Revenue declines as orders slow and backlogs deplete 2. Receivables decline because lower revenue means smaller amounts billed to customers (collections from prior-period higher revenue exceed new billings at lower revenue levels) 3. Inventory declines as the company draws down existing stock rather than purchasing new materials at the same rate (the destocking effect) 4. Payables also decline (the company is purchasing less from suppliers), but the decline is typically smaller than the combined AR and inventory reduction 5. Net effect: Working capital declines, releasing cash that partially offsets the EBITDA decline

This means that free cash flow can actually increase in the first quarter of a downturn even as EBITDA is declining, because the working capital release more than compensates for the earnings compression. This phenomenon has led PE sponsors to overestimate the cash generation ability of cyclical businesses at the start of a downturn; the working capital release is a one-time benefit that reverses when the cycle turns.

During a recovery, the sequence reverses:

1. Revenue increases as orders recover 2. Receivables increase (more revenue means higher billings, and new billings exceed collections from prior lower-revenue periods) 3. Inventory increases (the company must rebuild raw material, WIP, and finished goods inventory to support higher production rates) 4. Payables increase (more purchasing from suppliers), but typically lag the inventory build 5. Net effect: Working capital increases, absorbing cash and reducing free cash flow below the level that EBITDA growth alone would suggest

Inventory is the largest and most volatile component of industrial working capital. The modeling approach depends on the manufacturing model.

Build-to-stock manufacturers (building products, standard components, consumable supplies) maintain finished goods inventory to serve customers from stock. Inventory levels fluctuate with the sales cycle: rising during expansions (building safety stock to meet growing demand) and declining during downturns (drawing down existing stock as orders slow). The model should project inventory using days inventory outstanding (DIO), with DIO declining 10-20% during downturns (reflecting destocking) and increasing 10-20% during recoveries (reflecting restocking).

Build-to-order manufacturers (heavy equipment, custom machinery, defense platforms) carry primarily work-in-process inventory that reflects the current production schedule. WIP inventory is directly linked to the backlog conversion rate: as production ramps, WIP builds; as production declines, WIP is completed and shipped. For these companies, inventory modeling should be linked to the revenue build-up schedule rather than to a simple revenue percentage.

Defense and aerospace companies often operate under progress billing arrangements where the government customer pays periodically as work is completed, rather than upon final delivery. This creates a distinct working capital dynamic.

Progress Billings (Defense/Aerospace)

A payment mechanism in long-term government contracts where the customer pays the contractor at regular intervals (monthly or at defined milestones) for work completed to date, rather than waiting for final delivery. Progress billings create a current liability (customer advances or deferred revenue) that offsets the work-in-process inventory asset, resulting in significantly lower net working capital than the gross inventory levels would suggest. For defense contractors, progress billings can offset 60-80% of WIP inventory, meaning their net working capital investment is much lower than a commercial manufacturer with the same inventory levels.

Progress billings effectively mean the government is financing the contractor's production process. The model must capture both sides of this dynamic: the WIP inventory build (asset) and the corresponding progress billing receipts (liability). The net working capital is the difference, which is typically much smaller than either gross figure.

Many industrial companies have significant seasonal working capital patterns that must be modeled at the quarterly level (even if the full financial model is annual, the working capital section benefits from quarterly granularity).

Construction-related companies (building products, aggregates, E&C) build inventory in Q1 (before the spring construction season), sell through it in Q2-Q3, and have the lowest inventory levels in Q4. Receivables peak in Q3 (after the busiest shipping months) and are collected in Q4. This creates a Q1-Q2 working capital build and a Q3-Q4 release that can swing cash flow by $20-50 million or more between the best and worst quarters.

Agricultural equipment companies (Deere, CNH) build inventory ahead of planting season, creating a Q4-Q1 working capital build that releases in Q2-Q3 as equipment is delivered to dealers.

Accounts receivable modeling for cyclical industrials extends beyond simple DSO projections because customer credit quality deteriorates during downturns, potentially creating bad debt risk that is absent in expansions.

During economic expansions, industrial companies extend credit generously to customers with strong financial health. DSO may be stable at 55-60 days. During downturns, several dynamics compress receivables: lower revenue mechanically reduces the receivable balance, customers may request extended payment terms (stretching DSO to 65-75 days as they conserve cash), and some customers may default on payments entirely, creating bad debt write-offs.

The model should capture these dynamics by adjusting DSO assumptions through the cycle. In the base case (mid-cycle), use the company's historical average DSO. In the downturn case, increase DSO by 5-10 days (reflecting customer payment stretching) and include an explicit bad debt provision (0.5-2% of revenue for companies selling to creditworthy industrial customers, higher for companies with concentrated exposure to leveraged or distressed customers). In the recovery case, DSO normalizes back to mid-cycle levels as customer financial health improves.

For defense contractors, receivable dynamics differ because the customer (the US government) has essentially zero credit risk. DSO for defense companies is driven by government payment processing timelines rather than customer creditworthiness, making defense receivables more predictable and lower-risk than commercial industrial receivables.

Industrial companies that use LIFO (last-in, first-out) inventory accounting present an additional modeling consideration. Under LIFO, the most recently purchased (and typically most expensive) inventory is expensed first as cost of goods sold. This means the inventory on the balance sheet reflects older, lower-cost inventory values rather than current replacement costs.

The LIFO reserve (the difference between LIFO and FIFO inventory values, disclosed in financial statement footnotes) represents the cumulative under-reporting of inventory under LIFO accounting. For working capital analysis and M&A purchase price adjustments, the LIFO reserve may need to be added back to arrive at a more accurate economic working capital figure.

Additionally, during periods of declining production (when a manufacturer produces fewer units than it sells and draws down inventory), LIFO "layer liquidations" occur where older, lower-cost inventory layers are expensed, temporarily boosting gross margins above their sustainable run rate. The model should identify whether recent margin improvement includes LIFO liquidation benefits that are one-time in nature.

Working capital is a key component of the purchase price adjustment mechanism in M&A transactions. The purchase agreement specifies a target net working capital level, and the actual net working capital at closing is compared to the target. If actual working capital exceeds the target, the seller receives an upward adjustment to the purchase price. If it is below the target, the buyer receives a downward adjustment.

For cyclical industrials, setting the appropriate working capital target is one of the most contentious negotiation points because working capital varies significantly through the cycle. Sellers prefer to set the target at a lower level (reflecting trough-period working capital when inventory and receivables are low), while buyers prefer a higher target (reflecting normal or peak working capital that ensures they receive adequate working capital to operate the business).

The standard approach is to set the target at the trailing twelve-month average of monthly net working capital, which smooths seasonal fluctuations. For cyclical companies, an average over 2-3 years (capturing both peak and trough periods) may be more appropriate than a single trailing year average that might be distorted by the current cycle position.

For M&A transactions with closing dates that affect working capital adjustments, seasonality matters because the net working capital at closing directly affects the purchase price adjustment. A building products company closed in December (low-inventory season) will have materially lower working capital than the same company closed in March (pre-season inventory build), creating a potential $10-30 million purchase price difference depending on how the working capital target is set. Experienced bankers advise on optimal closing timing and working capital target methodology to ensure their client (buyer or seller) captures the most favorable position.

The cash conversion cycle (CCC) provides a single metric that summarizes a company's working capital efficiency: CCC = Days Sales Outstanding (DSO) + Days Inventory Outstanding (DIO) - Days Payable Outstanding (DPO). A lower CCC indicates more efficient working capital management (the company converts inputs into cash faster).

For cyclical industrials, the CCC typically ranges from 45-90 days, with heavy manufacturers (long production cycles, large inventory) at the high end and service-oriented or distribution businesses at the low end. The CCC should be tracked through the cycle because it fluctuates: during peak periods, DIO and DSO tend to rise (building inventory and billing more), while DPO may also rise (purchasing more from suppliers). During troughs, DIO and DSO decline while DPO declines more slowly.

For comparative analysis across companies, the CCC is more useful than any individual component (DSO, DIO, or DPO) because it captures the net effect of all three. A company with 70-day DIO but 55-day DPO has a very different working capital profile than one with 50-day DIO and 30-day DPO, even though the second company has lower absolute inventory levels.

When evaluating PE-backed platforms that have grown through acquisitions, the CCC trend is a useful indicator of integration quality. If the CCC has increased since the platform was formed (indicating working capital is growing faster than revenue), it may signal that the acquired businesses have not been effectively integrated from an operations and procurement perspective. Conversely, a declining CCC suggests successful working capital optimization across the combined platform.

Several best practices apply when modeling working capital for cyclical industrial companies:

Model each component separately. Rather than projecting net working capital as a single percentage of revenue, model receivables (as DSO x daily revenue), inventory (as DIO x daily COGS), and payables (as DPO x daily COGS) independently. This granularity allows each component to be adjusted for cycle position, seasonal patterns, and company-specific dynamics.

Use quarterly granularity for seasonal businesses. Annual working capital modeling misses the intra-year cash flow swings that seasonal businesses experience. A building products company that borrows $30 million on its revolver in Q1 to fund seasonal inventory build and repays it in Q4 from seasonal working capital release will show zero net change on an annual basis, but the quarterly cash flow profile matters for debt covenant compliance and liquidity management.

Cross-check working capital forecasts against capacity. If the model projects 15% revenue growth but working capital grows only 5%, it implicitly assumes working capital efficiency improvement. Verify whether this improvement is realistic by assessing whether the company has specific initiatives (inventory management programs, receivable acceleration, supplier term renegotiation) that would support the assumed efficiency gain. Unsupported working capital efficiency assumptions can overstate free cash flow by meaningful amounts.