Welcome to VoraPrep Audio.
Have you ever seen a business with fantastic sales, but no cash in the bank? It’s a situation that drives managers crazy. The income statement looks great. But the treasurer is panicking, just trying to make payroll. How does this happen? How can a company have high sales, but be completely cash-poor?
The answer is found by looking at how long it takes to turn operations into money. This is where activity ratios are essential. They are diagnostic tools that show you exactly where your cash is getting stuck.
For the CMA exam, this is a major topic. You must know the calculations. You also have to know how to interpret the results.
Picture your business as a pipeline. Raw materials go in one end, and cash from customers comes out the other. Activity ratios measure the speed of that flow.
The first potential clog in the pipeline is inventory. This is all the product sitting in your warehouse. How fast are you selling it? The Inventory Turnover ratio provides the answer. The formula is Cost of Goods Sold divided by Average Inventory. A higher number is usually better, meaning you're moving product efficiently.
We can also look at this in terms of days. Just take 365 and divide it by your inventory turnover. This gives you Days in Inventory, or DIO. It tells you the average number of days a product sits on the shelf before it's sold. For instance, a DIO of 30 means it takes about a month to sell your inventory.
But is a very high turnover always good? Not always. It could mean you're under-stocking. You might be losing out on potential sales. The goal is to find the right balance.
So, you've sold the product. But you likely sold it on credit. The next potential clog is collecting the payment. This is measured by the Receivables Turnover ratio. The formula is Net Credit Sales divided by Average Accounts Receivable. And just like before, a higher number is better. It shows you're effective at collecting what you are owed.
We can also express this in days. This is called Days Sales Outstanding, or DSO. The formula is 365 divided by the receivables turnover. DSO tells you the average number of days it takes to collect cash after making a sale. If your DSO is 45 days, but your payment terms are 30 days, you have a problem. Your customers are paying late, and your cash is tied up.
We've covered selling inventory and collecting cash. This last piece is about paying your own bills. It’s measured by Payables Turnover. The formula is Purchases divided by Average Accounts Payable. An important exam point: you might not be given the Purchases number. If that happens, you can use Cost of Goods Sold as a reasonable substitute.
Payables are different from the other two ratios. For inventory and receivables, a fast turnover is good. With payables, a slower turnover can actually be a benefit. Why? Your accounts payable is like a short-term, interest-free loan from your suppliers. The longer you can responsibly hold onto your cash, the better. You can use that cash for your own operations before paying your suppliers.
This metric, in days, is called Days Payable Outstanding, or DPO. It's the average number of days you take to pay your suppliers. This requires a delicate balance. If your DPO gets too long, you could damage supplier relationships or even hurt your credit rating. But when managed strategically, it’s a great source of financing.
These three "days" metrics—DIO, DSO, and DPO.—all come together in one critical formula. This formula calculates the Cash Conversion Cycle, or CCC. The CCC measures the total time your cash is tied up in operations from start to finish.
The formula is DIO plus DSO minus DPO. Let’s break that down. It's the time your inventory sits on the shelf... plus the time it takes to collect from customers... minus the grace period your suppliers give you to pay. The final number is the length of time your own money is out of your hands. A shorter cycle means a more cash-efficient company.
Let's apply this to an example, just like one you might see on the exam. The company is Sterling Manufacturing. First, the balance sheet data. Inventory started at one hundred eighty thousand dollars and ended at two hundred twenty thousand. Accounts Receivable started at one hundred ten thousand and ended at one hundred fifty thousand. And Accounts Payable began at eighty thousand and ended at one hundred thousand.
That's the balance sheet. Now for the income statement. Cost of Goods Sold was one point five million dollars. Net Credit Sales were two point six million dollars. The question is: Calculate Sterling's Cash Conversion Cycle.
The first step is to calculate the average balances. This is a common exam trap. Never just use the ending balance. You must use the average. For inventory, we take the beginning balance of one hundred eighty thousand, add the ending balance of two hundred twenty thousand, and divide by two. The average inventory is two hundred thousand dollars.
For receivables, that's one hundred ten thousand plus one hundred fifty thousand, divided by two. The average is one hundred thirty thousand dollars. And for payables, we take eighty thousand plus one hundred thousand, and divide by two. The average is ninety thousand dollars. With our averages calculated, we can move to the next step.
Now we calculate our three "days" metrics, starting with DIO, Days in Inventory. First, we need the turnover ratio. That's Cost of Goods Sold divided by average inventory. So, one point five million dollars divided by our average inventory of two hundred thousand. That gives an inventory turnover of 7.5 times. To get the days, we take 365 and divide by 7.5. The result is 48.7 days. Sterling’s inventory sits for about 49 days before being sold.
Next is DSO, or Days Sales Outstanding. We start with turnover again. The formula is Net Credit Sales divided by average receivables. We take two point six million dollars and divide by our average of one hundred thirty thousand. That gives a turnover of exactly 20 times. To get the days, we calculate 365 divided by 20, which is 18.3 days. That's very good. Sterling collects its cash quickly.
Finally, we have DPO, or Days Payable Outstanding. For the turnover, we'll use Cost of Goods Sold divided by average payables. We're using Cost of Goods Sold because the problem didn't provide a purchases figure. So, that’s one point five million dollars divided by our average of ninety thousand. This gives a turnover of 16.67 times. For the days, we calculate 365 divided by 16.67. That gives us 21.9 days. Sterling takes about 22 days to pay its bills.
We have all the pieces to find the CCC. Our DIO was 48.7 days. Our DSO was 18.3 days. And our DPO was 21.9 days. The formula is DIO plus DSO minus DPO. So, we calculate 48.7... plus 18.3... minus 21.9. The final answer is 45.1 days. This means from the moment Sterling invests in inventory, it takes about 45 days for that investment to become cash in the bank.
Be careful of a very common error. For inventory turnover, you must use Cost of Goods Sold in the numerator, not Sales. This is an apples-to-apples comparison. Inventory on the balance sheet is measured at its cost. Therefore, the numerator, Cost of Goods Sold, must also be at cost. Sales includes your profit margin. Using sales would inflate your turnover and produce the wrong answer.
On the exam, you won't just compute the number; you'll also have to interpret it. For instance, what happens to the CCC if a company offers a discount for early payment? That would lower your DSO. A lower DSO shortens your CCC, which is good. But the discount also lowers your revenue, which is bad. The exam tests your understanding of these trade-offs.
To recap, activity ratios tell the story of a company’s operational efficiency. We looked at inventory turnover, which measures how fast you sell. We looked at receivables turnover, which measures how fast you collect. And we looked at payables turnover, which measures how fast you pay. These three combine into the Cash Conversion Cycle. The formula is Days in Inventory, plus Days Sales Outstanding, minus Days Payable Outstanding. A shorter cycle means a healthier, more liquid company.
VoraPrep is a full exam-prep app — lessons, practice questions, and an AI tutor in one place. Get started at Vora Prep dot com.