Avoid 10 Mistakes When Calculating Working Capital (NWC)

by Joanne Baginksi, Axial Forum

You might think that calculating net working capital (NWC) is a relatively simple exercise – current assets less current liabilities. However, this simple exercise can turn into a very complicated calculation during the transition process. At a time when both buyers and sellers just want to move on, they instead face potential arbitration or litigation post-close that could have been avoided overall.

To avoid additional coasts and strained relationships, buyers and sellers should take care to avoid these 10 common mistakes:

When Setting the Target

The following items are often large influencers in the calculation of net working capital.

• Not considering seasonality: If the business is highly seasonal and not closing during the peak season, using a trailing 12-month average to calculate a target might be misleading. Seasonal businesses (ski resorts, holiday retailers, hospitality businesses) have peaks and valleys to their revenue and, as a result, to their working capital. If a trasaction is closing during a downturn, the trailing 12-month average of NWC might overstate the target and might not be the best indicator for working capital as of the close date. Other mechanisms of calculating the working capital such as looking at ratios to revenues or expenses at the same periods should be considered in these circumstances.
• Not taking changes in operations in to account: Overlooking what might seem like minor changes or disruptions in your operations can also affect your working capital calculations. Maybe your accounts receivable clerk was out for a period of time and you got behind on calculating receivables. Or maybe last year you stocked up on inventory due to know pricing increases. If this is the case, using historical figures might overstate and understate the working capital target. External factors, such as customers paying more quickly or slowly as a result of their ow circumstances, can also influence working capital. Consideration for these dynamics should be given when there are significant recent operating changes that affect NWC.
•  Not including normalizing or year-end-only adjustments into working capital: If adjustments are made during quality of earnings assessments or year-end audits, more than likely ther are adjustments that need to be made in setting the target NWC. Also, if the seller normally accrues payroll, bonuses, etc. only a year-end, average NWC can be significantly understated. These accruals should be reflected throughout the monthly balance sheets to properly calculate a target.
• Not looking at off-balance-sheet liabilities: Debt that is not the balance sheet is often a cause for debate sine some companies don’t record all their liabilities on the balance sheet. This could include large unfunded pensions or reclamation liabilities (like asset retirement obligations (AROs). Unknown large off-balance-sheet liabilities can but the buyer at risk and can negatively impact the transaction.

When Drafting Legal Documents

As the LOI is typically signed prior to diligence being performed, the initial target set might be missing crucial items and/or might include items that should not be included in the calculation, such as shareholder receivables, payables, or income taxes

•  Including an NWC target in the Letter of Intent: as the LOI is typically signed prior to diligence being performed, the initial stages set might be missing crucial itmes and/or might include items that should not be included in the calculation, such as shareholder receivable, payables, or income taxes.
• Using contradicting language is the purchase and sales agreement: This is more common than your think, so make sure intention matches execution. Common language used in sales agreements states that the NWC reconciliation should be calculated using generally accepted accounting methods (GAAP) consistent with past practices. However, these concepts are rarely in sync. If seller financials are “mostly” GAAP but exclude certain accruals, it is important to ensure the exclusion should not have material effect.
• Not using an illustrative example in the purchase and sales agreement: There’s always going to be used, but how those estimations have been historically calculated should be clearly defined and shown in the sales agreement. Examples show which assets are liabilities are included in the target NWC and which ones to ultimately be included or excluded in the reconciliation.
• Not communicating post-close exclusions: It is important to have clear agreement regarding who is responsible for what upon a change in ownership. IF payroll-related expenses are to be the responsibility of the seller upon close, they should be excluded from the calculation. Income tax and owner are also normally excluded , as are cash and debt. IF there are checks in excess, decide and agree if those are to be included or excluded and are properly noted as such in the final agreement.

After the Close

• Not performing an inventory observation at or near closing: Performing a full physical count of inventory at or around the date of the close will save major headaches when you’re trying to reconcile the closing balance sheet. You may identify inventory in additional (but forgotten) storage areas that should be counted or stock that is old and obsolete that should not be included.
• Not allowing enough time for a true-up provision: Although the transaction process can be grueling and you want to wrap up as quickly as possible, 30 days (or less) is not enough time to accurately calculate any true-up provision. You should have a reasonable look back a period to ensure all information is available and included. More time allowed for the true-up calculation will provide the opportunity to identify transactions that should be included/excluded from the final true-up that otherwise might have been missed.

Calculating working capital can be confusing, complicated, and stressful, especially in the heat of a transaction. Having an experienced advisory team of accountants, tax advisors, attorneys, and bankers who can conduct a thorough review of the calculation can help alleviate some of the anxiety and provide for a smoother overall process.