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.

 
Best Response

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.

Listen, here's the thing. If you can't spot the sucker in the first half hour at the table, then you are the sucker.
 

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.

 

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.

Just an Undergrad trying to get a job. Something you disagree or dislike about my posts? Let me know by PM'ing me or commenting constructive criticism.
 

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.

Career Advancement Opportunities

April 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. New 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

April 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

April 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

April 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (87) $260
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (146) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Betsy Massar's picture
Betsy Massar
99.0
5
CompBanker's picture
CompBanker
98.9
6
GameTheory's picture
GameTheory
98.9
7
kanon's picture
kanon
98.9
8
dosk17's picture
dosk17
98.9
9
Linda Abraham's picture
Linda Abraham
98.8
10
DrApeman's picture
DrApeman
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”