Foolish Fundamentals: Cash Conversion Cycle

Get back to the basics with our Foolish back-to-school special! Start your journey here.

What do stores like Wal-Mart (NYSE: WMT  ) , Home Depot (NYSE: HD  ) , Target (NYSE: TGT), and Lowe's (NYSE: LOW) have in common? Their inventory needs must be massive. How do we go about analyzing their inventories as a measure of performance? By determining the company's cash conversion cycle and inventory turnover.

Although it would take some grade-A imbecility to get there, it's entirely possible under the accrual system in accounting for a company to go bankrupt while showing operating profits. Why? Because you can't pay your vendors with "profits"; you must pay them with cash. A company that does a poor job of bringing in cash, even if it's selling lots of stuff, should be avoided. Let's break this down by components.

1. Days inventories outstanding (DIO)
What we want to know is the number of days it takes for a company to "turn" its inventory. Let's compare the fiscal 2006 and 2005 annual results for Home Depot.

Home Depot

2006 (in millions)

2005 (in millions)

Cost of Goods Sold

$61,054

$54,191

COGS Per Day (Annual COGS/365)

$167

$148

Inventories

$12,822

$11,401

DIO (Inventories/COGS Per Day)

77

77

Data provided by Capital IQ, a division of Standard & Poor's.

See how that works? Let's do the same thing with the other two components.

2. Days sales outstanding (DSO)
DSO is the amount of time it takes the company, on average, to receive money after it has sold a good or service.

Home Depot

2006 (in millions)

2005 (in millions)

Revenue

$90,837

$81,511

Revenue Per Day (Annual Rev/365)

$249

$223

Receivables

$3,223

$2,396

DSO (Receivables/Rev Per Day)

13

11

Data provided by Capital IQ, a division of Standard & Poor's.

3. Days payables outstanding (DPO)
Finally, we have to subtract from this total the number of days the companies hold on to cash after they pay for something. So we must also know the DPO.

Home Depot

2006 (in millions)

2005 (in millions)

Cost of Goods Sold

$61,054

$54,191

COGS Per Day (Annual COGS/365)

$167

$148

Accounts Payable

$7,356

$6,032

DPO (Accounts Payable/COGS Per Day)

 44

41

Data provided by Capital IQ, a division of Standard & Poor's.

Finally, to come up with the cash conversion cycle, you simply add the three numbers for DIO, DSO, and DPO. Be careful, though: DPO is a negative number.

Thus, Home Depot's cash conversion cycle in 2006 is: 77 + 13 - 44 = 46 days. Compare this to Home Depot's cash conversion cycle in 2005: 77 + 11 - 41 = 47 days.

So, even with all that inventory, Home Depot is still able to convert its own expenditures back into cash in only 46 days, which is pretty good for a company that relies on large inventory. You can also calculate these numbers on a quarterly basis (taking care to divide by 90 instead of 365) to have a more sensitive tool for determining the trend toward faster or slower cash conversion.

Cash conversion cycles don't translate well from industry to industry, so comparing companies that don't directly compete may not be helpful. Still, you can watch these cycles closely on a company-to-company basis, since they might warn of weakening business fundamentals that don't show up elsewhere.


Read/Post Comments (1) | Recommend This Article (4)

Comments from our Foolish Readers

Help us keep this a respectfully Foolish area! This is a place for our readers to discuss, debate, and learn more about the Foolish investing topic you read about above. Help us keep it clean and safe. If you believe a comment is abusive or otherwise violates our Fool's Rules, please report it via the Report this Comment Report this Comment icon found on every comment.

Add your comment.

DocumentId: 536226, ~/Articles/ArticleHandler.aspx, 4/19/2014 2:14:04 PM

Report This Comment

Use this area to report a comment that you believe is in violation of the community guidelines. Our team will review the entry and take any appropriate action.

Sending report...


Advertisement