Cash conversion cycle matters or how to spend money to make money.

by | May 4, 2020

Cash Conversion Cycle (CCC) sounds like the kind of thing a “finance guy” says to convey a level of pith when you know it’s merely status signaling amongst peers and decision makers. It tends to be bandied about in conjunction with terms like “vendor terms” or “working capital”. Like most of finance jargon, it describes a concept with which your already intimately familiar. In this case, the time it takes to turn money for stuff and people into money for your operation.

To break this town, Cash Conversion Cycle (CCC) is calculated by the following formula:

Days Inventory Outstanding (DIO)   * Average days it takes to turn investment in raw materials into sales

+ Days Sales Outstanding (DSO)          * Average days it takes to turn sales into cash

–  Days Payables Outstanding (DPO)   * Average days takes to pay bills

Cash Conversion Cycle (CCC)

For your edification, here are the formulas for DIO, DSO, and DPO

DSO = (Accounts Receivable/Credit Sales) x Number of days in the period of Credit Sales

For Example:

Credit Sales = 1,200,000

Days = 365

Accounts Receivable = 200,000

Or a DSO of approximately 61 days

DIO = (Average Inventory / Cost of Sales) x Number of days in the period of Cost of Sales

For Example:

Cost of Sales = 800,000

Days = 365

Beginning Inventory = 80,000

Ending Inventory = 90,000

Average Inventory = (80,000 + 90,000)/2 or 85,000

Or a DSO of approximately 39 days

DPO = (Accounts Payable / Cost of Sales) x Number of days in the period of Cost of Sales

For Example:

Cost of Sales = 800,000

Days = 365

Accounts Payable = 40,000

Or a DPO of approximately 18 days

Now, let’s apply the original formula for Cash Conversion Cycle to the above example:

DSO = 61 days

DIO = 39 days

DPO = 18 days

And our Cash Conversion Cycle is 82 days.

So why does this matter? Because it takes you almost a whole quarter to turn spending into money.  Because your vendors want to get paid in 18 days for raw materials (according to your DPO) and it takes you 100 days (DSO + DIO) to turn it into cash. Basically, you’ve got to cover cash for 2 ½ months with your own capital or from somewhere else.

For some, this is a normal cycle time. If you make a widget, this probably isn’t too far off. If you’re in software, it could be negative. (no inventory, get paid up front, and you pay bills in 25 days) The reason this metric is so important to “finance folk” is that it communicates much about a business’ health, risk, and capital structure. For you, it is likely a working capital question. Questions like, “am I asking for enough with this line of credit?” or “Can I cover new inventory with current sales and still pay my staff?”.  While the concept isn’t tremendously complicated, the substance of what it communicates is nuanced and informs tactics in a real way.

0 Comments

Bitnami