The Cash Conversion Cycle

by CI Staff

Through the normal course of business, companies acquire inventory on credit, which they in turn use to create products. These products are then sold, oftentimes on credit. These actions generate accounts payable and accounts receivable, with no cash exchanged until the company collects accounts receivable and settles the accounts payable.

The cash conversion cycle (CCC) measures the time—in days—that it takes for a company to convert resource inputs into cash flows. In other words, the cash conversion cycle reflects the length of time it takes a company to sell inventory, collect receivables, and pay its bills. As a rule, the lower the number, the better. This is because, as the cash conversion cycle shortens, cash becomes free for a company to invest in new equipment or infrastructure or other activities to boost investment return. Also, the cash conversion cycle can be useful in comparing close competitors and assessing management efficiency.

Print this article

In this article


Share this article


About the author

CI Staff .
CI Staff Profile
All Articles by CI Staff

Calculating the Cash Conversion Cycle

The cash conversion cycle is actually a collection of three “activity ratios” related to the turnover in inventory (accounts receivable), all of which are expressed in days. The formula for the cash conversion cycle is as follows:

CCC = days inventory outstanding (DIO) + days sales outstanding (DSO) – days payable outstanding (DPO)

Days Inventory Outstanding

This measure addresses the question of how long—in days—it takes for a company to sell its entire inventory. The smaller the number, the better.

DIO = average inventory ÷ cost of goods sold per day

Where:

Average inventory = (beginning inventory + ending inventory) ÷ 2

Cost of goods sold per day = annual cost of goods sold ÷ 365

First:   
Last:   
Email:

              

Days Sales Outstanding

Here we calculate the number of days a company needs to collect on sales. Cash-only sales have a DSO of zero, but many companies allow customers to buy on credit. Again, the smaller the number, the better.

DSO = average accounts receivable ÷ revenue per day

Where:

Average accounts receivable = (beginning accounts receivable + ending accounts receivable) ÷ 2

Revenue per day = annual revenue ÷ 365

Days Payable Outstanding

Lastly, we measure how long it takes for a company to pay its bills (accounts payable). The longer a company is able to hold its cash, the better its investment potential. In this case, a longer DPO is better.

DPO = average accounts payable ÷ cost of goods sold per day

Where:

Average accounts payable = (beginning accounts payable + ending accounts payable) ÷ 2

Cost of goods sold per day = annual cost of goods sold ÷ 365

See Member Benefits »

Take a peek
at all the member benefits AAII has to offer.
AAII is a nonprofit association dedicated to investment education.

Table 1 presents data for American Eagle Outfitters (AEO), a casual apparel chain, covering its last seven fiscal years. The top of the table provides the annual income statement and balance sheet data needed to calculate the three activity ratios and, ultimately, the cash conversion cycle.

Time Series Analysis

Analyzing financial ratios on a stand-alone basis doesn’t yield meaningful results. Instead, tracking trends in an individual company over several years, as well as comparing these trends to key competitors, can prove enlightening.

From the data in Table 1, we see that American Eagle’s cash conversion cycle has risen almost 42% since 2005, from 25.1 days to 35.6 days. This trend is not favorable for the company, as money is tied up for longer periods of time before the company is able to convert its own expenditures back into cash.

American Eagle Outfitters (AEO)
  2010 2009 2008 2007 2006 2005 2004
Revenue 2,990.5 2,988.9 3,055.4 2,794.4 2,322.0 1,881.2 1,435.4
Cost of Goods Sold 1,832.5 1,814.8 1,632.3 1,454.0 1,244.2 1,003.4 885.9
Inventory 326.5 294.9 286.5 263.6 210.7 170.6 120.6
Accounts Receivable 34.7 41.5 31.9 26.0 29.1 26.4 24.1
Accounts Payable 158.5 152.1 157.9 171.2 139.2 108.9 71.3
Average Inventory 310.7 290.7 275.1 237.2 190.7 145.6  
Average Accounts Receivable 38.1 36.7 29.0 27.6 27.8 25.3  
Average Accounts Payable 155.3 155.0 164.6 155.2 124.1 90.1  
Days Inventory Outstanding 61.9 58.5 61.5 59.5 55.9 53.0  
Days Sales Outstanding 4.7 4.5 3.5 3.6 4.4 4.9  
Days Payable Outstanding 30.9 31.2 36.8 39.0 36.4 32.8  

 

Looking at the three activity ratios that make up the cash conversion cycle, we can further dissect the cash conversion trend. From Table 1, it appears that the biggest contributor to the rise of the cash conversion cycle for American Eagle is days inventory outstanding, which has risen from 53.0 days to almost 62 days since 2005. This means that the company is having a harder time turning over its inventory.

The days sales outstanding ratio has been relatively stable over the entire period, but it has risen from 3.5 days in 2008 to 4.7 days in 2010. This may mean that the company is relaxing its collection policies or extending credit to customers who are having a hard time paying.

Lastly, days payable outstanding has fallen only slightly since 2005, but has seen a sizable decline from 39.0 days in 2007 to 30.9 days in 2010. Unlike the other two activity ratios, a longer days payable outstanding is preferable. This may be an indication of creditors tightening their terms with American Eagle.

See Member Benefits »

Take a peek
at all the member benefits AAII has to offer.
AAII is a nonprofit association dedicated to investment education.

Competitive Analysis

When comparing the cash conversion cycle across companies, it is important to compare companies within the same industry. Otherwise, your analysis may not be helpful.

Table 2 shows the activity ratio and cash conversion cycle data for American Eagle along with Abercrombie & Fitch (ANF) and Urban Outfitters (URBN). The three companies are in direct competition with each other, so we are making a meaningful comparison.

American Eagle Outfitters (AEO) 2010 2009 2008 2007 2006 2005
Days Inventory Outstanding 61.9 58.5 61.5 59.5 55.9 53.0
Days Sales Outstanding 4.7 4.5 3.5 3.6 4.4 4.9
Days Payable Outstanding 30.9 31.2 36.8 39.0 36.4 32.8
Cash Conversion Cycle 35.6 31.8 28.2 24.2 23.9 25.1
             
Abercrombie & Fitch (ANF) 2010 2009 2008 2007 2006 2005
Days Inventory Outstanding 124.7 114.8 114.6 130.0 114.6 116.9
Days Sales Outstanding 9.0 5.6 4.8 4.7 5.3 4.1
Days Payable Outstanding 35.5 31.8 31.5 30.8 34 38.1
Cash Conversion Cycle 98.2 88.6 87.8 103.8 85.8 82.9
             
Urban Outfitters (URBN) 2010 2009 2008 2007 2006 2005
Days Inventory Outstanding 56.4 55.6 64.0 69.6 67.9 60.5
Days Sales Outstanding 7.0 6.2 5.7 5.2 3.8 3.3
Days Payable Outstanding 22.3 22.3 25.9 23.4 22.8 24.8
Cash Conversion Cycle 41.1 39.6 43.8 51.4 48.9 39.0

 

American Eagle has the lowest cash conversion ratio value at 35.6 days, followed by Urban Outfitters (41.1 days) and Abercrombie & Fitch (98.2 days). Urban Outfitters has been able to lower its cash conversion cycle from 51.4 days in 2007 by significantly increasing its inventory turnover: its days inventory outstanding has fallen nearly 20% from 69.6 days in 2007 to 56.4 days in 2010.

Abercrombie & Fitch takes more than twice as long to turn over its inventory as Urban Outfitters and American Eagle. The company’s days inventory outstanding stands at 124.7 days, although it has fallen from a high of 130.0 days in 2007. Abercrombie’s days sales outstanding jumped from 5.6 days in 2009 to 9.0 days in 2010. This means that customers are taking significantly longer to pay for their purchases. Both factors are contributing to Abercrombie’s cash being tied up nearly three times as long as that of American Eagle and more than twice as long as that of Urban Outfitters. This does not reflect well on Abercrombie in regard to management’s efficiency relative to some of its competitors.

Conclusion

The cash conversion cycle is a useful tool in evaluating a company’s management. By breaking down the cash conversion cycle into its three component activity ratios and studying the trends in individual companies, as well as comparing direct competitors, you can gain insights in the operating efficiency of a firm.


Discussion

i just read a book by a journalist who went through harvard's MBA program. one of his lessons past on was that inventory is a millstone for any business. so CCC could be a usefull tell for any stock. i wish another article could be written showing where to get the initial numbers.

posted about 1 year ago by Bill from Pennsylvania

AAII's fundamental stock screening and research database program, Stock Investor Pro, was the source of the underlying financial statement data for the article. The only other source that I am aware of that offers several years of financial statement data (without digging through 10-Ks) is SmartMoney.com. Wayne A. Thorp, CFA, editor, Computerized Investing.

posted about 1 year ago by Wayne from Illinois

In the retail business, management cannot allow accountants to make merchant decisions. Inventory on hand can be a good thing--to a point, of course. More inventory makes a store 'feel' well stocked and attractive to customers. Customer research proves that shoppers will go elsewhere if the size, color, style they want is not there. So, these metrics are interesting and can be telling BUT not without deep knowledge of the in-store environment (shopability) and shopper behavior.

posted 3 months ago by Stephen Behringer from Montana

You need to log in as a registered AAII user before commenting.
Create an account

Log In