Net working capital
I always get different responses to the following questions, could anyone clarify please?
My understanding is that there are two main formula for NWC
1. NWC = Current Assets (less cash) – Current Liabilities (less debt)
2. NWC = Accounts Receivable + Inventory – Accounts Payable
I tend to use the second formula when calculating changes in NWC in the context of DCF, as it represents the actual capital needed to operate the business, but I wonder is there any exception that the first formula is more preferred?
Also, is the first formula more applicable for a 3 statement LBO (i.e. all balance sheet items are projected)? Because there are other items e.g. accrued revenue to be considered in a 3 statement
Second formula is technically incorrect because it does not take into account Deferred Revenue. Certain businesses are able to operate with zero or negative working capital because their customers pay them before the service is provided or with a consignment model where the business only pays its suppliers when payment is received from the customer.
First formula is good, just need to strip out anything that is interest bearing (from both assets and liabilities side), as you did. I would also keep restricted cash in the current assets side of things, but if this always stays the same then it will have no impact on cash flow.
From the quick and dirty practice LBOs I've been doing the second formula is typically what is used since you're only projecting out those three BS items. But what I mentioned above is helpful to know for theory and ways to optimize working capital to boost cash flow.
Also what is accrued revenue? Is that just accounts receivable? If you mean accrued expenses then yeah, throw that into the calculation.
To add here, any good FP&A team will separate deferred revenue into short-term (0 - 12 months) and long-term (12+ months) deferrred revenue. Short term deferred revenue should be treated as a current liability, whereas longer term (business dependent) would be treated as a long-term liability.
Whatever gets your cash flow statement to tie out :)
Ullam possimus quia dolor omnis et ipsa tempora. Quia voluptatem placeat odio. Et itaque libero non corrupti occaecati aut sit.
Enim similique ipsa officiis. Aliquid aut sint ipsum et nisi et. Ipsa inventore eveniet vero consequatur. Qui possimus veniam velit et molestias molestiae ab.
Minima cum error voluptas repudiandae eaque numquam. Non illo provident numquam. Quibusdam ipsum voluptate vel. Aut eos aut sunt tenetur ducimus laudantium corporis. Quaerat quia illum laborum molestias totam. Quia culpa ad commodi aliquid aut neque dolorum. Repellat aperiam vitae maxime quis aut atque.
Consequatur saepe autem numquam. Aut dicta sequi accusantium et illo. Iste libero harum doloribus. Laboriosam facilis qui adipisci sit eum.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...