How to Analyze Working Capital in Due Diligence

Analyzing working capital is critical during due diligence for acquisitions. It helps assess a company's liquidity, operational efficiency, and financial health while also influencing purchase price adjustments. Here's how to approach it:

• Understand Working Capital: It's the difference between current assets (like cash, receivables, inventory) and current liabilities (like payables, accrued expenses). Positive working capital indicates liquidity, while negative working capital may signal risks or efficient cash management depending on the business model.
• Review Historical Data: Analyze 3–5 years of financial statements to identify trends, seasonal patterns, and anomalies in receivables, inventory, or payables.
• Adjust for Non-Recurring Items: Remove one-time events like legal settlements or unusual prepayments to calculate normalized working capital.
• Set a Target Working Capital Level: Use a trailing 12-month average or industry benchmarks to establish a baseline for purchase price adjustments.
• Understand the True-Up Mechanism: This process adjusts the purchase price based on differences between target and actual working capital at closing.
• Key Metrics: Focus on ratios like current ratio, quick ratio, and metrics like DSO (Days Sales Outstanding), DIO (Days Inventory Outstanding), and DPO (Days Payable Outstanding) to evaluate efficiency and cash flow management.

Quick Tip:

Collaborate with advisors, use reliable data platforms, and focus on the quality of assets (like collectible receivables and saleable inventory) to ensure accurate analysis and smooth post-acquisition operations.

Negotiating Net Working Capital Adjustments in M&A – Definitions and How to Calculate

Step-by-Step Process for Analyzing Working Capital

Taking a structured approach to analyzing working capital is key to uncovering a target company's financial health. This process involves a deep dive into historical data, careful adjustments for one-time events, and setting precise benchmarks to guide decision-making during due diligence.

Review Historical Financial Data

Start by collecting three to five years of audited financial statements, ideally broken down into monthly or quarterly intervals. This longer timeframe helps you spot patterns that shorter periods might miss - like seasonal trends, growth trajectories, or operational shifts.

Use the basic formula for working capital: current assets minus current liabilities. But don’t stop there. Dig deeper into the individual components. A company might show stable overall working capital while experiencing big changes in its receivables, payables, or inventory.

Pay close attention to seasonal trends specific to the industry. For example, retailers often stock up on inventory before the holiday rush, while construction companies might see receivables spike during peak building seasons.

Document any unusual changes or outliers. A sudden rise in accounts receivable could point to collection issues, while a sharp drop in inventory might signal improved efficiency - or potential stock shortages. These anomalies often highlight operational shifts that directly impact ongoing capital needs.

This review provides the foundation for making necessary adjustments.

Adjust for Non-Recurring Items

To get an accurate picture of working capital, you’ll need to remove one-time events and non-operational items that won’t carry over after the acquisition.

Adjustments might include things like legal settlements, insurance payouts, or unusual vendor prepayments. For instance, if a company received a $500,000 insurance settlement, that temporary cash boost shouldn’t be factored into normal working capital.

Accrued expenses deserve close scrutiny. Look for deferred maintenance costs, accumulated bonuses, or professional fees tied to the sale process. These items can distort the working capital picture depending on how they’re accounted for.

Also, consider related-party transactions. If the target company has special payment terms with a sister company or benefits from below-market financing provided by the current owner, these arrangements are unlikely to continue under new ownership.

Making these adjustments helps you calculate a normalized working capital figure - a number that reflects what the business truly needs to operate under typical conditions.

Set a Target Working Capital Level

The target working capital represents the baseline amount needed at closing and serves as the foundation for purchase price adjustments. This figure reflects the working capital required to sustain current operations.

Most buyers calculate the target using a trailing twelve-month average of normalized working capital. However, if the business has recently improved operations, a shorter period might be more appropriate. The key is to focus on a timeframe that reflects steady, ongoing operations rather than temporary highs or lows.

Use industry standards as a reference point to validate your target. For example, manufacturing companies might need working capital equal to 15-20% of annual revenue, while service-based businesses might operate with just 5-10%. These benchmarks help you determine whether the company is running efficiently or holding excess capital.

Factor in any planned changes, like operational upgrades or market expansion. A growing company will typically require more working capital to support increased sales, while a mature business might have more stable needs.

Clearly document your methodology, as this target will likely be a point of negotiation with the seller and included in the purchase agreement. Both parties need to understand how the figure was calculated and what adjustments were made.

Once the target is set, the next step is understanding how purchase price adjustments will work.

Understand the True-Up Mechanism

The working capital true-up mechanism outlines how adjustments to the purchase price are handled when the actual closing working capital differs from the agreed target. This can have a big impact on the deal's final economics.

Most agreements use a dollar-for-dollar adjustment. For example, if the closing working capital exceeds the target by $100,000, the seller gets an extra $100,000. Conversely, if it falls short by $100,000, the seller’s payout is reduced by the same amount. Some deals include a threshold (or "collar") where adjustments only kick in if the variance exceeds a certain percentage, like 5% of the target.

Timing is critical. Working capital is typically measured as of the closing date, but some deals use a date a few days earlier to allow time for final calculations. Knowing this timing helps both parties plan their pre-closing activities.

Exclude non-operational items like cash and debt-like liabilities, as these are usually handled separately. Cash is often excluded entirely, while items like accrued interest or dividend payables may be treated differently.

In case of disputes over the final working capital calculation, most agreements specify that an independent accounting firm will resolve disagreements. The costs are often split between the buyer and seller. Understanding this process upfront can help avoid surprises during the post-closing reconciliation.

Key Metrics and Ratios for Working Capital Analysis

Once you've assessed normalized working capital, diving into specific metrics can provide a clearer picture of both financial health and operational efficiency. These key ratios and metrics help evaluate a company's liquidity and how effectively it manages its operations.

Current Ratio and Quick Ratio

The current ratio evaluates a company's ability to meet short-term obligations using its current assets. It's calculated by dividing current assets by current liabilities. A ratio between 1.5 and 3.0 is generally considered healthy, though this benchmark varies depending on the industry.

For example, manufacturing companies often require higher current ratios due to the need to maintain substantial inventory levels. On the other hand, service-based businesses can operate effectively with lower ratios since they typically have fewer inventory demands. A current ratio below 1.0 could signal potential liquidity issues, as it indicates that current liabilities exceed current assets.

The quick ratio (or acid-test ratio) takes a stricter approach by excluding inventory from current assets. It’s calculated by dividing the most liquid assets - such as cash, marketable securities, and accounts receivable - by current liabilities.

A quick ratio of 1.0 or higher suggests that a company has enough liquid assets to cover its immediate obligations without relying on inventory sales. This measure is especially useful for companies with slow-moving or hard-to-sell inventory, as it highlights their ability to maintain liquidity in a pinch. Both the current and quick ratios tie closely to operational metrics like DSO, DIO, and DPO, which influence cash flow.

Days Sales Outstanding (DSO), Days Inventory Outstanding (DIO), and Days Payable Outstanding (DPO)

These metrics track how efficiently a company collects receivables, manages inventory, and pays suppliers.

• Days Sales Outstanding (DSO) reflects the average number of days it takes to collect payment after a sale. An increasing DSO might indicate collection issues, shifts in customer payment habits, or relaxed credit policies aimed at boosting sales.
• Days Inventory Outstanding (DIO) measures how long inventory stays on hand before being sold. A lower DIO typically signals efficient inventory management, but if it’s too low, it could indicate stock shortages that might hurt sales.
• Days Payable Outstanding (DPO) shows the average time taken to pay suppliers. A higher DPO can improve cash flow by delaying payments, but excessive delays could harm supplier relationships.

Keep an eye on sudden changes in these metrics. For instance, if a company stretches its payables (higher DPO) while customers delay payments (higher DSO), it might signal underlying cash flow challenges, even if overall working capital appears stable.

Cash Conversion Cycle

The cash conversion cycle (CCC) integrates DSO, DIO, and DPO into a single metric to show how long it takes to turn investments in inventory into cash from sales. It’s calculated using the formula:
DSO + DIO - DPO

A shorter cycle indicates efficient working capital management, meaning the company can quickly turn inventory into cash, reducing the need for external financing. Conversely, a longer cycle ties up capital and may require additional funding to maintain operations.

Interestingly, a negative CCC reflects strong cash management. This happens when DPO exceeds the combined DSO and DIO, essentially using supplier credit to fund operations.

Tracking the CCC over time and comparing it to industry benchmarks can reveal trends. For instance, a lengthening cycle might point to inefficiencies, while a shortening cycle could indicate improved operations or favorable market conditions. Seasonal factors can also influence the CCC - businesses might experience longer cycles during inventory build-up for peak seasons, followed by shorter cycles as they convert that inventory into sales.

The Bigger Picture

These metrics collectively provide a detailed view of working capital efficiency. However, strong liquidity ratios alone don’t guarantee operational success. A company might excel in liquidity but struggle with inventory or receivables management - or vice versa. To truly understand financial health, you need to analyze all these metrics together, creating a balanced perspective on both liquidity and operational performance.

sbb-itb-97ecd51

Common Red Flags in Working Capital Analysis

Understanding key ratios and cycles is essential, but spotting red flags early on is just as critical. These warning signs can often point to deeper financial or operational challenges that need immediate attention.

Sudden Changes in Receivables, Inventory, or Payables

If you notice abrupt changes in accounts receivable, inventory levels, or payables, it's time to dig deeper. For instance, a sharp increase in receivables or an unexpected inventory buildup might hint at cash flow or liquidity problems. While seasonal patterns can sometimes explain these shifts, it’s important to compare them against historical data to identify any unusual trends.

Deviation from Historical Trends or Industry Norms

When a company’s metrics stray significantly from its past performance or industry benchmarks, it could signal trouble. For example, a sudden surge in revenue or a dip in the current ratio might reflect operational instability or temporary factors at play. A declining current ratio, in particular, often points to cash flow challenges.

Similarly, inconsistent trends compared to industry averages might raise concerns about earnings manipulation, operational volatility, or one-off events affecting performance. Unexplained revenue spikes or weak cash flow conversion rates should prompt a closer review to ensure the financial data holds up under scrutiny.

Window Dressing and Documentation Issues

Working capital adjustments can have a direct impact on deal valuations, sometimes slashing purchase prices by as much as 20%. In fact, working capital is the most frequently used metric for purchase price adjustments, appearing in 89% of transactions according to recent studies. Deviations from agreed-upon working capital targets can lead to significant price changes, making a detailed analysis essential to safeguard your investment.

To confirm any red flags, cross-check data with various sources, such as operational metrics, customer feedback, and broader market conditions. This comprehensive approach ensures a clearer picture of the company’s financial health.

Best Practices and Tools for Working Capital Analysis

To effectively analyze working capital, you'll need expert guidance and the right tools to avoid missing crucial details that could influence your investment decisions.

Collaborate with Advisors

Working capital analysis can be tricky, involving intricate accounting principles and regulatory requirements that even seasoned investors might find challenging. This is why working with experienced advisors is so important - they bring specialized knowledge that can validate your analysis and highlight potential issues.

• Accounting professionals excel at dissecting financial statements, spotting subtle discrepancies or risks that might otherwise go unnoticed. Their expertise ensures your analysis is thorough and accurate.
• Legal advisors are critical when it comes to navigating purchase agreements and working capital adjustment terms. They ensure your calculations align with contractual definitions and help you set up safeguards to protect your interests. Since disputes over working capital can significantly reduce purchase prices, having legal input early on can save you from expensive headaches later.
• Industry specialists provide valuable insights into sector-specific trends. They understand nuances like seasonal cash flow changes, standard payment terms, and inventory practices unique to different industries. This contextual knowledge helps you differentiate between normal business cycles and potential red flags.

The best time to assemble your advisory team is at the start of the process, not after you've already completed your initial analysis. A collaborative approach ensures everyone is on the same page, which helps identify and address issues early while aligning on methodology and expectations.

Once you’ve secured expert guidance, the next step is leveraging the right tools to streamline and enhance your analysis.

Use Reliable Data and Analytics Platforms

Reliable data is the backbone of any solid working capital analysis, but gathering it from multiple sources can be a time-consuming task. Modern analytics platforms simplify this process and improve the quality of your insights.

• Platforms like Kumo consolidate business listings from various marketplaces and brokerages into a single interface. With AI-driven features and custom search filters, these tools help you quickly identify acquisition opportunities that meet your working capital criteria, so you can focus on the most promising deals.
• Financial databases provide crucial benchmarking data, offering historical trends, peer comparisons, and industry-specific metrics. This information helps you gauge how a target company stacks up against its competitors and spot deviations from standard patterns. Having access to this level of detail strengthens your negotiating position and supports your valuation assumptions.
• Due diligence software automates repetitive tasks like calculations and report generation while maintaining detailed audit trails. These tools improve consistency across multiple deals, reduce errors, and streamline collaboration among team members.

For the best results, combine multiple data sources to cross-check your findings. When different sources align, it adds credibility to your conclusions.

Finally, remember that quality trumps quantity when it comes to data. Instead of trying to analyze every metric, zero in on the working capital components that have the greatest impact on cash flow and deal valuation. Always verify key inputs, understand how the data was compiled, and question any assumptions that could influence your results.

Key Takeaways for Working Capital Analysis

Working capital analysis plays a crucial role in ensuring smooth acquisitions by helping to avoid unexpected cash flow surprises after closing. By focusing on the right details, you can identify potential issues before they turn into costly problems.

Start by reviewing historical data and adjusting for any one-time or non-recurring items. This helps establish a normalized baseline. A trailing twelve-month average of adjusted working capital is often used to set a target level, which serves as the foundation for post-closing price adjustments.

Metrics like Days Sales Outstanding (DSO), Days Inventory Outstanding (DIO), and Days Payable Outstanding (DPO) provide valuable insights into how efficiently a business manages its cash flow and operations. For instance, a sudden increase in DSO or unusual inventory changes might indicate deeper issues, such as pre-sale window dressing. Adjustments to receivables before closing can hide liquidity problems, while delayed payments to suppliers or manipulated inventory levels might create a short-term, misleading improvement that won’t hold up after the acquisition.

The true-up mechanism, typically finalized 60 to 90 days after closing, ensures the purchase price reflects the actual working capital delivered. For example, if a company’s historical average working capital is $500,000 but only $400,000 is delivered at closing, the purchase price would be adjusted downward by $100,000 to account for the shortfall.

It’s also important to focus on the quality of assets. Prioritize collectible receivables and saleable inventory over aged or obsolete items. Incorporating these insights into your due diligence process can help protect your investment and maintain stability after the acquisition.

Collaborating with experienced advisors and using reliable data tools can make your analysis more efficient and reduce the chance of missing critical details. Platforms like Kumo can consolidate analytics and support thorough evaluations, helping you negotiate effectively and ensure a seamless post-closing transition.

FAQs

What are the risks of relying only on historical financial data when evaluating working capital during due diligence?

Relying solely on historical financial data can be a gamble. Why? Because it often misses the bigger picture - future market trends, unforeseen liabilities, or operational hurdles that could directly affect working capital. This limited perspective might cause you to overlook critical aspects like upcoming expenses, industry shifts, or even seasonal variations that can disrupt cash flow.

What’s more, historical data doesn’t always paint a full picture of earnings quality or the long-term viability of past performance. These are key elements when evaluating the overall health of your working capital. To make smarter, more informed decisions, it’s crucial to adopt a forward-looking approach - one that blends historical insights with future projections.

What does the cash conversion cycle reveal about a company’s efficiency, and what does a negative CCC mean?

The cash conversion cycle (CCC) is a key metric for evaluating how well a company manages its working capital. It tracks the time it takes to turn inventory and receivables into cash. In general, a shorter cycle reflects greater efficiency, while a negative CCC stands out as an impressive achievement - indicating the company collects cash from customers before it has to pay its suppliers.

When a company achieves a negative CCC, it often signals strong liquidity, reduced dependency on external financing, and excellent handling of payables and receivables. This setup enables the business to operate with less working capital, improving its cash flow. However, maintaining a negative CCC isn’t without challenges. It demands thoughtful planning to ensure supplier relationships remain intact and day-to-day operations stay stable.

Why is it essential to account for non-recurring items when normalizing working capital, and how does this impact the purchase price?

Adjusting for non-recurring items when normalizing working capital is crucial because it ensures the calculation reflects the company's everyday operational needs. These items, like a one-time legal settlement or an unusually large inventory purchase, can cause temporary spikes or drops in working capital that don't accurately represent the business's usual financial patterns.

By removing these irregularities, both buyers and sellers can establish a more precise target working capital. This plays a key role in determining the purchase price adjustment, helping to prevent overpayment or underpayment due to misleading fluctuations. Properly normalizing working capital also minimizes the chances of disputes after the transaction, ensuring a fair outcome for everyone involved.

Related posts

• 7 Key Metrics for Evaluating Business Acquisition Targets
• How to Assess Deal Viability Using Financial Ratios
• Cash Flow in Financial Due Diligence
• 10 Financial Red Flags in SMB Acquisitions