Understanding Working Capital
We're looking at retailers, and in research reports on their working capital they're talking about working capital. My accounting knowledge is pretty lacking, I obviously know current assets-current liabilities.
The research reports then talk about "payables going down to 69 days of COGS" and then "in 2016 it bounced back with payables going back to 101 days" ... what does this mean when they say payables in units of days?
I am also aware of the CCC = DIO + DSO - DPO, is this what they're talking about?
If anyone has a good primer on understanding working capital, and how to understand high variations in working capital, I'd appreciate it, as it's a big gap in my knowledge.
I think you're right that the report is talking about part of the cash conversion cycle. More specifically, the number of days payables are due to the creditors has increased, which would be positive for the firm.
Can someone expand on this formula for me?
Google "Cash Conversion Cycle."
Working Capital can be thought of in two ways: -Obvious: The amount that current assets exceed current liabilities (current assets - current liabilities) -Less obvious: The amount that your current assets are financed by capital sources OTHER than current liabilities (if amount of current assets exceeds the current liabilities, then the remaining financing source for those current assets would have to be long-term debt or equity)
Since long-term debt is often already directly deployed to support long-term assets (buildings, land, equipment, etc.), working capital can be viewed as the amount of equity a company has in its current assets.
More working capital is typically viewed favorably by lenders because your accounts receivable and inventory, given sufficient time to convert to cash, are more than sufficient to extinguish current liabilities (covering all vendor payables or paying down a bank line of credit).
Too much working capital could be viewed negatively by shareholders if a company would be better off borrowing on a line of credit to support its current assets, freeing up the company's equity to be used elsewhere (new projects, dividends, etc.).
Days outstanding is referring to the CCC formula you cited. The DIO, DSO, and DPO formulas all have important implications for financial projections because once you have revenue and gross margin projected on the income statement, you can derive your projected balance sheet accounts for AR, Inventory, and AP using the days outstanding formulas. Benchmarking against historical DIO, DSO, and DPO and against comparable companies is also an important practice to understand your target company's working capital management.
Inventory days is how long it takes the average $ of Inventory to convert to convert into sales. A shorter number of Inventory days means inventory is turning quickly and being sent out the door as sales. Certain products may convert into sales quickly, while other products may sit on the shelves for months without producing revenue and may even become obsolete requiring write-downs.
AR days is how long it takes a company to collect its cash once a sale has been made. A shorter number of AR days means that AR balances are collected quickly. It's important to calculate this as (AR/Credit Sales)*365 if some sales are settled in cash immediately with no resulting AR balance. Calculating AR days using only the sales amount that actually resulted in an increase in AR is most appropriate.
AP days is how long it takes a company to pay outstanding accounts payable. A shorter number of AP days means a company is paying its vendors quickly. Companies will often "stretch" its AP days by taking longer to pay vendors in order to preserve cash, but at the detriment of upsetting vendors and possibly receiving less favorable terms in the future. Note: I think investopedia does an excellent job of explaining each of these and the CCC further and has a great video summary.
Working capital for retailers has additional wrinkles because when inventory is sold, sales are largely collected in cash immediately, with no account receivable recognized. Vendors would still have standard invoice payment terms of ~30 days. In such a case, working capital could very well be negative. The AP outstanding balance as a source of capital exceeds the inventory asset balance, ~0 AR balance, and the collected cash from sales is deployed elsewhere and does NOT accumulate as a current asset on the balance sheet. That said, a retailer will need a certain minimum amount of current assets held as cash to keep cash in the registers.
So...yeah... current assets - current liabilities = working capital.
Slow day at the office.
Calculating NWC (Originally Posted: 01/03/2014)
I am struggling with the NWC calculation.
According to my excel spreadsheet, NWC in 2008 and 2009 was 1485 and 1093
Can anyone explain how this was calculated
I have uploaded the balance sheet.
First off you exclude cash and debt instruments from NWC. You want to include assets and liabilities related to operations which will be an immediate source/use of cash [so current assets/liabilities]. Then you also exclude deferred taxes which aren't reflective of operations [although you need to remember to account for def taxes if you are calculating cash flow, but as far as I know usually they are separated from WC]
The way NWC is calculated above, i.e. for 2008, is: NWC = Net Receivables + Inventory + Other Current Assets - A/P - Other Current Liabilities = 3019 + 680 + 1218 - 2121 - 1311 = 1485.
Extelleron thank you very much for your help.
DCF Question - Working Capital (Originally Posted: 04/12/2017)
Hi,
I'm currently valuing a company that sells off some of it's A/R at a discount, takes a loss on this, and then jams that loss into SG&A. My question is do I have to adjust for this at all in my DCF or am I fine just keeping it in SG&A?
Thanks in advance.
If the company has done this regularly(check their past 10-k's), then correct me if I'm wrong but I believe you can keep it in SG&A.
The only thing to be careful of is in the long run whether they target a % of A/R or a fixed dollar amount since as the base grows, and you capitalize either a terminal EBITDA or FCF w/ TGR, your terminal value will be off due to the tax shield of these expenses. It likely does not make that big of a difference, but just something to consider.
Molestias recusandae sit quis voluptas aut minima. Facere dolores qui quod quo nostrum vitae. Reiciendis suscipit ut consequatur. Et omnis eius voluptates.
Vitae sed esse distinctio pariatur. Magni ad et ea quaerat consequatur. Delectus laborum facilis maiores quam et illum.
Quam cumque aut et qui. Eius assumenda amet eaque qui distinctio aut. Molestiae earum error aut soluta dolores quia. Sed voluptas repudiandae est qui ad consequatur consequatur. Dignissimos facere doloremque qui delectus id quis delectus. Aperiam corrupti sunt quia et qui et. Alias quia velit est qui beatae cum.
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...