Investors have a wealth of financial ratios they can examine to better understand the health of a company. One of the most important measures of management efficiency is the cash conversion cycle, which tells the analyst how much cash the company has tied up in inventory, its ability to collect money owed from customers, as well as the time it takes to pay certain creditors.
In this article, we're going to be covering the topic of the cash conversion cycle (CCC). As part of that discussion, we'll talk about the usefulness of the measure, each of its components, as well as its calculation. Then we'll finish with an example, including a link to an online cash conversion calculator.
Cash Conversion Cycle
The cash conversion cycle is a measure of a company's ability to move cash through a process that starts with the purchase of materials from suppliers, and ends with the collection of money from customers. The faster a company can convert cash spent into cash received, the more efficient the process, and the greater the ability of a company to generate additional profits.
When benchmarking a company's performance, comparisons should be made between companies in similar industries. As the cash conversion formula is examined in more detail, the reasoning behind this statement will be clearer.
Cash Conversion Cycle Formula
The calculation of the cash conversion cycle requires information from both the balance sheet (inventories, accounts receivable, or A/R, and accounts payable, or A/P) as well as the income statement (cost of goods sold, or COGS, and revenues). This information is then used to calculate three metrics: Days Inventory Outstanding (DIO), Days Sales Outstanding (DSO), and Days Payable Outstanding (DPO), as demonstrated in the formula below:
Cash Conversion Cycle (CCC) = DIO + DSO - DPO
where:
DIO = Average Inventory / (Cost of Goods Sold / 365)
DSO = Average Accounts Receivable / (Revenues / 365)
DPO = Average Accounts Payable / (Cost of Goods Sold / 365)
and:
Average Inventory = (Beginning Inventory + Ending Inventory) / 2
Average Accounts Receivable (A/R) = (Beginning A/R + Ending A/R) / 2
Average Accounts Payable (A/P) = (Beginning A/P + Ending A/P) / 2
The CCC formula relies on the COGS, inventories, as well as payment patterns from customers, and to suppliers. These variables can vary significantly between industries. That's the reason benchmarks must be aligned with competitors, or companies, participating in similar industries.
The formula also provides insights into the power of this measure. When making comparisons between companies, each of the three components can be evaluated separately. For example:
Days Inventory Outstanding (DIO): measures how efficiently a company turns its inventory into revenue.
Days Sales Outstanding (DSO): indicates how effective the company is at collecting money from customers after a sale.
Days Payable Outstanding (DPO): measures how quickly a company pays its suppliers. This is often indicative of the relationship the company has with its trade partners.
Cash Conversion Cycle Example
In the table below is information for two companies (actual data) in what has been traditionally a very competitive industry. Each of these companies is a highly-regarded and profitable business.
Company A | Company B | |
Revenues | 65,225 | 69,943 |
Cost of Goods Sold | 39,541 | 15,577 |
Average Inventory | 1,051 | 1,372 |
Average Accounts Receivable | 5,510 | 14,987 |
Average Accounts Payable | 12,015 | 4,197 |
Days Inventory Outstanding | 9.7 | 32.1 |
Days Sales Outstanding | 30.83 | 78.21 |
Days Payable Outstanding | 110.9 | 98.3 |
Cash Conversion Cycle | (70.4) | 12.0 |
From the above data, it's possible to make the following observations about these two companies:
Company A is a very efficiently run business. They have less than ten days of inventory on hand. They also have a great relationship with their suppliers, allowing them to carry very favorable credit terms (111 days). They are also very good at collecting money owed from customers.
Company B is also an efficiently run business. They have a little over a month's worth of inventory. They also have a very good relationship with suppliers, allowing them to pay back money owed an average of nearly 100 days. Where they suffer competitively is their ability to collect money from customers, which is nearly 40 days longer than Company B.
The above example illustrates the thought process the analyst should go through when examining the differences in the cash conversion cycle of two companies. It's possible to make these types of comparisons using our Cash Conversion Calculator. That online tool, along with the information readily available on websites such as Google Finance, allows investors to quickly compare the cash conversion performance of the companies they're evaluating.
About the Author - Understanding the Cash Conversion Cycle