Net Working Capital Analysis in Due Diligence: Getting the Peg Right
Net working capital analysis is one of the most consequential workstreams in a buy-side engagement. The NWC peg directly affects the purchase price through the completion accounts mechanism. Get it wrong, and the buyer overpays or the seller leaves money on the table.
Despite its importance, NWC analysis is often the workstream most vulnerable to data quality issues. It depends on accurate account mapping, proper exclusion of non-operating items, and reliable seasonality assessment. Each of these steps can introduce error.
What NWC Analysis Covers
In a deal context, net working capital is not simply current assets minus current liabilities. It is a normalized measure of the operating capital required to run the business on an ongoing basis.
The typical NWC analysis involves:
- Identifying NWC components: Trade receivables, inventory, prepaid expenses, trade payables, accrued liabilities, deferred revenue, and other operating current items.
- Excluding non-operating items: Cash, debt, intercompany balances, tax receivables and payables, and other items that belong in the net debt bridge rather than NWC.
- Normalizing for one-time items: Unusual receivable balances, inventory write-downs, or accrual timing adjustments that do not reflect ongoing working capital needs.
- Assessing seasonality: Determining whether the closing date NWC is representative or whether a different measurement period better reflects the business cycle.
Where Data Quality Breaks Down
NWC analysis relies heavily on the accuracy of account mapping. Every GL account must be correctly classified as operating or non-operating, current or non-current, and assigned to the right NWC category.
Common errors include:
Misclassified intercompany balances. A receivable from a related entity included in trade receivables inflates NWC and the resulting peg. This benefits the seller at the buyer's expense.
Inconsistent accrual treatment. If the target company accrues differently at year-end versus interim periods, month-end NWC snapshots may not be comparable. Analyzing a trailing 12-month average without adjusting for accrual timing produces a misleading peg.
Chart of accounts gaps. When a target's chart of accounts does not cleanly separate operating and non-operating items within the same balance sheet category, mapping requires sub-account analysis. A single account containing both trade payables and tax payables must be split.
Building a Reliable NWC Analysis
Step 1: Clean the Source Data
Start with a complete trial balance that reconciles to the financial statements. Map every balance sheet account to NWC or non-NWC categories. Document exclusions and the rationale for each.
Step 2: Build the Monthly Bridge
NWC analysis requires monthly data, not just annual. Build a 24 to 36 month bridge showing each NWC component at month-end. This reveals seasonality patterns and one-time distortions.
Step 3: Normalize
Remove one-time items: large customer prepayments, unusual inventory buildups, catch-up accruals. Each normalization should be documented with the same rigor as a QoE adjustment, including source data reference and rationale.
Step 4: Determine the Peg
The peg methodology matters. Common approaches include:
- Trailing 12-month average: Smooths seasonality but may include non-representative periods.
- Trailing 3-month average: More current but sensitive to recent fluctuations.
- Seasonal adjustment: Uses the same seasonal period from prior years to set expectations for closing.
The right methodology depends on the business. A retailer with heavy Q4 seasonality needs a different approach than a B2B SaaS company with relatively flat working capital.
Step 5: Sensitivity Analysis
Calculate the working capital peg under multiple methodologies. A peg that swings by millions depending on methodology signals that the underlying data or normalization needs more work.
The Technology Dimension
Manual NWC analysis in Excel is slow and error-prone. Building monthly bridges across multiple entities and 24 months of data requires linking dozens of spreadsheets. A single formula error can shift the peg.
Automated workflows offer three advantages:
- Speed: Monthly data extraction and mapping happens in minutes, not days.
- Consistency: Every month is mapped using the same rules, eliminating the inconsistencies that creep in during manual builds.
- Auditability: Every data point traces to its source, making it straightforward for the partner or buyer to verify any component of the analysis.
Impact on the Deal
NWC disputes are among the most common sources of post-closing conflict. A well-documented, accurately normalized NWC analysis reduces the risk of completion accounts disputes and protects the advisory firm's reputation.
For Transaction Services teams, the ability to deliver a defensible NWC peg faster than the competition is a meaningful differentiator. It improves client confidence, accelerates deal execution, and directly supports the team's ability to take on more engagements.