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 :)
Earum et illum commodi atque exercitationem debitis. Numquam modi atque est qui officia.
Consequuntur vero voluptatem tempora et et qui. Labore ad quia voluptatum nihil.
Quaerat assumenda non molestiae ducimus omnis. Consectetur ea magni mollitia. Porro rerum qui nemo consequatur aut dolores.
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...