Using The Cash Conversion Cycle

It is not likely that you will hear an Analyst praise a company’s increase in average days payable. Nor will you hear a CEO boast about having an industry low DIO. It’s not even common that a company will go out of the way to alert you that their DSO is improving, even though that would mean they are receiving cash faster. While these metrics are far from popular, they form the basis for the calculation of the Cash Conversion Cycle or CCC.

The Cash Conversion Cycle isn’t exactly a headline-grabbing metric in itself. It is primarily used by accountants and business operators to gauge the efficiency and internal performance of the business. While not an overly popular metric, understanding it can give you a leg up on spotting an opportunity.

In this post, we will discuss what the Cash Conversion Cycle is, how you can calculate it, and how you can use it to your advantage.

What is the Cash Conversion Cycle?

Simply put, the cash conversion cycle tells us how long it takes cash to work its way through the business. A typical operating cycle for a business will start with cash which is then used to purchase inventory. After purchasing inventory, an invoice is received, and the inventory is paid for. Until the product is sold, the inventory sits in possession of the business. Once the product is sold, the business issues an invoice to the customer and eventually the customer pays cash for the product. Calculating the cash conversion cycle helps us understand how long it takes from the time the business shells out cash to pay for inventory, to when the cash (and hopefully profit), re-enter the business via payments from customers.

Timeline for Business CCC.png

Why is this important? A company who can push cash through its operating cycle faster can reinvest that cash more often. If your business has a shorter CCC than your competitors, you can grow the company at a faster rate without having to rely on outside capital.

The Cash Conversion Cycle is calculated by adding together the Days Inventory Outstanding (DIO) with the Days Sales Outstanding (DSO) and subtracting the Days Payable Outstanding (DPO).

CCC Equation.png

How To Calculate

To truly understand the CCC, it helps to visualize the typical series of events and corresponding calculations.

CCC Timelines.png

The first event occurs when the business purchases inventory. From the time the business receives the inventory to when cash leaves to pay for that inventory, is the period considered when calculating the Days Payable Outstanding. At times, businesses delay payments to improve this number. While suppliers might not like the tactic, it can be used to self-finance internal growth. Alternatively, if a company (like your customers) are doing this, it might be worth making sure nothing more serious is on the horizon and the company isn’t struggling overall financially.

Calculating Days Payable Outstanding

To calculate Days Payable Outstanding, we take the accounts payable divided by the COGS and then multiply by 365 (days of the year). If we want to calculate a specific period, we can take the Average Accounts Payable divided by the COGS per day. The Average Accounts Payable is the beginning accounts payable added with ending accounts payable of the period and divided by two.

Days Payable Outstanding Timeline.png
DPO Days Payable Outstanding Calculation.png

Once a business has received inventory, they need to sell it. A business that has lots of inventory sitting around is essentially parking cash in that portion of their operating cycle. The time the inventory is received to when the product is sold is referred to as the Days Inventory Outstanding or DIO.

Calculating Days Inventory Outstanding

To calculate Days Inventory Outstanding, we take the Inventory divided by the COGS and then multiplied by 365 (days of the year). If we want to calculate a specific period, we can take the Average Inventory divided by the COGS per day, and multiply the number of days. The Average Inventory is calculated by adding the beginning inventory and ending inventory and dividing by two.

Days Inventory Outstanding DPO Timeline.png
Days Inventory Outstanding DIO Calculation.png

Simply selling a product isn’t enough. The business needs to collect the cash from that transaction. Some firms give incentives like discounts to entice their customers to deliver cash to them faster. When this cash comes in faster, the business can reinvest it in the business to further drive the operating cycle. The period between when the product is sold and when the cash is collected is referred to as the Days Sales Outstanding (DSO).

Calculating Days Sales Outstanding

To calculate the Days Sales Outstanding, we take the Accounts Receivable and divide by the Revenue, followed by multiply by 365 days. If we want to calculate a specific period, we divide average accounts receivable by revenue, multiples by the number of days in that period. Average accounts receivable is calculated by adding the beginning accounts receivable and endings accounts receivable, divided by two.

Days Sales Outstanding DSO Timeline.png
Days Sales Outstanding Formula.png

Calculating the entire Cash Conversion Cycle

Finally, when a business evaluates the time between paying for the inventory and receiving cash, a true cash conversion cycle can be calculated. The CCC is derived by adding the day's inventory outstanding with the day's sales outstanding and subtracting the days payable outstanding.

Cash Conversion Cycle Timeline with Formulas.png
All Cash Conversion Cycle Formulas Broken Down.png

What To Look For

The cash conversion cycle is a valuable tool. In public markets, using the CCC can be a great tool for inner industry analysis. If you are operating a private business, it’s worth tracking this number on your own if you are not doing so already. While the entire CCC can be helpful it is equally essential to follow what is happening at the DPO, DIO, and DSO level. Below is a summary chart that will allow you to quickly understand what movement in each direction means.

Increasing and decreasing DPO DIO and DSO.png

Days Payable Outstanding - An increase in DPO means a company is keeping cash longer when paying their bills. Typically this is a good thing and means the business has favorable terms with its suppliers. However, if you have reason to believe the company is in trouble, pay careful attention to this number as an increase might indicate the business is delaying payments to survive.

Days Inventory Outstanding - An increase in DIO means the company is struggling to sell inventory. If industry peers are not experiencing a similar dip, this could be an area that you want to investigate further. On the contrary, a decrease in DIO signals inventory is moving faster. If the firm is significantly outperforming industry peers, they may have a competitive advantage. Once you identify the reason in the lower DIO, you can analyze the possibility of it being a sustainable or replicable by peers.

Days Sales Outstanding - An increase in DSO means the company is receiving cash from clients at a slower rate. It could be something as simple as a change to accounting procedures such as when invoices are sent and collected, or it could be something more drastic like a cyclical downturn. A decrease in DSO indicates the business is receiving payments faster. Generally, this is a good thing.

Overall the patterns you want to see in a company are an increase in days payable outstanding, and a decrease in both days inventory outstanding and days sales outstanding. This creates a lower cash conversion cycle. The lower the CCC, the better.

Patterns of DPO DIO and DSO.png

This post originally appeared on Finbox.io