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 :)
Asperiores impedit rerum sed animi aut quis. Iure et porro voluptatum dolor officiis iste eos. Rerum aut odit amet rerum quia incidunt eum. Quisquam vitae sint dolor et.
Asperiores nemo expedita eveniet maxime dolorem. Quia dolorum dolores reprehenderit voluptates dignissimos. Odio quibusdam perferendis tempore ut delectus accusamus ratione. Accusantium eum debitis illum.
Et commodi commodi rerum cum vel fuga ad. Laudantium ullam occaecati eius eligendi voluptatem minima totam. Magnam dolorum et ut voluptas ea.
Omnis provident nulla reiciendis odit. Aut facere est quam voluptatem. Repellendus sint occaecati nihil cupiditate corrupti voluptatum. Est ea cum ex doloremque dicta molestiae.
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...