All posts
inventory4 min read

Inventory Analysis in Due Diligence: Identifying Hidden Risks and Value

Inventory quality directly impacts working capital, margins, and deal value. Learn how diligence teams analyze inventory for M&A transactions.

Datapack Team

Inventory Analysis in Due Diligence: Identifying Hidden Risks and Value

Inventory is often the largest current asset on the target's balance sheet. For manufacturing, distribution, and retail businesses, inventory analysis is a core diligence workstream that directly affects the net working capital peg, gross margins, and ultimately the purchase price.

The risks are tangible. Overstated inventory inflates working capital and masks margin deterioration. Understated reserves hide future write-downs. Slow-moving stock ties up cash that the buyer will inherit.

Key Areas of Focus

A comprehensive inventory analysis covers five dimensions:

Existence and Valuation

Does the reported inventory physically exist, and is it valued correctly? Physical counts, cycle count data, and reconciliation to the GL provide baseline assurance. For targets with multiple locations, the diligence team should assess count procedures at material sites.

Valuation methodology matters. FIFO, weighted average, and standard costing produce different carrying values and margin profiles. The diligence team must understand the costing method and assess whether it produces a reasonable approximation of actual cost.

For targets with cross-border operations, currency effects on inventory valuation add complexity. Raw materials purchased in one currency and sold as finished goods in another create embedded FX gains or losses within inventory balances.

Obsolescence and Slow-Moving Stock

The obsolescence reserve is one of the most judgment-laden balances on the balance sheet. Management has discretion over reserve methodology, and diligence teams frequently identify inadequate provisions.

The analysis should include:

  • Aging analysis. Stratify inventory by age (days since last movement). Items older than 12 months deserve specific review.
  • Turnover analysis. Calculate days of inventory by SKU or category. Compare to historical trends and industry benchmarks.
  • Excess stock assessment. Compare on-hand quantities to forward demand (sales forecasts, open orders). Stock in excess of 6 to 12 months of demand is a reserve candidate.
  • Reserve adequacy. Compare the existing reserve to the identified exposure. Propose adjustments if the reserve is insufficient.

Margin Analysis

Inventory costing directly drives gross margins. The diligence team should analyze margins by product line, customer segment, and geography to identify margin trends and anomalies.

Key questions include:

  • Are input cost increases being passed through to selling prices?
  • Are margins consistent across reporting periods, or are they volatile?
  • Does standard costing variance analysis reveal production efficiency issues?

Work in Progress

WIP inventory requires additional scrutiny. The percentage of completion and cost allocation methods used for WIP directly affect the carrying value and recognize profit at different stages.

For long-cycle manufacturers or construction companies, WIP can represent months of accumulated costs. The diligence team should verify the stage of completion, assess the reasonableness of cost allocations, and evaluate the margin recognized on partially complete contracts.

Consignment and Off-Site Inventory

Inventory held at third-party locations (consignment stock, warehouse providers, contract manufacturers) creates additional risk. The diligence team should confirm existence, verify ownership terms, and ensure these balances are included in the count and valuation.

Working Capital Implications

Inventory is typically the most volatile component of net working capital. Seasonal businesses may see inventory double or triple in the build-up period before peak selling season.

Setting the net working capital peg requires a normalized view of inventory levels. The diligence team should:

  • Analyze monthly inventory balances over 24 to 36 months
  • Identify and adjust for seasonal patterns
  • Remove the effect of one-time stock builds (product launches, facility transitions)
  • Assess whether current levels are representative of ongoing requirements

An incorrectly set inventory peg benefits one party at the other's expense. The analysis must be rigorous enough to withstand scrutiny from both sides of the transaction.

EBITDA Adjustments Related to Inventory

Inventory issues can also create EBITDA adjustments:

  • Reserve increases. If the diligence team determines that additional obsolescence reserves are required, the provision flows through cost of goods sold and reduces EBITDA.
  • Write-downs. One-time inventory write-downs in the historical period may be added back as non-recurring, provided they are genuinely non-recurring.
  • Costing methodology changes. If the target changed costing methods during the diligence period, the team should restate to a consistent basis.

These adjustments interact with the quality of earnings analysis and should be presented consistently in the earnings bridge.

Process Considerations

Inventory analysis requires granular data: item-level quantities, costs, movements, and aging. Extracting this from the target's ERP system early in the process prevents bottlenecks during the analytical phase.

Standardized data extraction templates ensure the diligence team receives complete, usable data on the first request rather than iterating through multiple data request rounds. This compresses timelines and reduces friction with target management.