# Activity Ratios: Debtors & Creditors Turnover Ratios, Stock Turnover

The compilation of these Accounting Ratios Notes makes students exam preparation simpler and organised.

## Activity (or turnover) Ratios

While we study the accounts and financial statements of an entity, we can gauge its current financial position. But can you tell the efficiency of the firm by just looking at the accounting statements? No, and this is why the management calculates and studies activity ratios. Let us take a look.

### Activity Ratios

These ratios basically measure the efficiency with which assets are being utilized or managed. This is why they are also known as productivity ratio, efficiency ratio, or more famously as a turnover ratio.

These ratios show the relationship between sales and any given asset. It will indicate the ratio between how much a company has invested in one particular type of group of assets and the revenue such asset is producing for the company.

The following are the different kinds of activity ratios that measure the effectiveness of the funds invested and the efficiency of their performance

1. Stock Turnover Ratio
2. Debtors Turnover Ratio
3. Creditors Turnover Ratio
4. Stock to Working Capital Ratio 1. Stock Turnover Ratio
One of the most important of the activity ratios is the stock turnover ratio. This ratio focuses on the relationship between the cost of goods sold and average stock. So it is also known as Inventory Turnover Ratio or Stock Velocity Ratio.

It basically counts the number of times a stock rotates (completes a cycle) in one given accounting period and the sales it affects in the same period. So it calculates the speed with which the company converts stock (lying about) to sales, i.e. revenue. The formula for the ratio is as follows,

Quick Ratio = $$\frac{\text { COGS }}{\text { AverageStock }}$$
COGS = Sales – Gross Profit
Average Stock = $$\frac{\text { OpeningStock }+\text { ClosingStock }}{2}$$

From a managerial standpoint, this is an important ratio to calculate. It allows them to figure out their inventory reordering schedule, by indicating when all the stock will run out. It also helps them analyze how efficiently the stock and its reordering is being managed by the purchasing department.

2. Debtors Turnover Ratio
This ratio measures the efficiency with which Accounts Receivable are being managed, hence it is also known as the ‘Accounts Receivable Turnover ratio’. The ratio shows the equation between credit sales (cash sales are not taken into consideration) and the average debtors of a firm. The formula is as below:

Debtors Turnover ratio = $$\frac{\text { CreditSales }}{\text { AverageDebtors }}$$
OR
Debtors Turnover ratio = $$\frac{\text { CreditSales }}{\text { Debtors }+\text { BillsReceivable }}$$

And with a slight modification, we also derive the average collection period. This will indicate the average number of days/weeks/months in which the payment from the debtor is collected by a firm. The formula for this formula is as below:

Average Collection Period = $$\frac{\text { Numberofdays } / \text { weeks } / \text { months }}{\text { DebtorsT/ORatio }}$$

Both of these ratios are significant in managing the debtors and bills receivables of a company. Not only do they calculate the velocity with which debtors pay up, but they also help shape the credit policy of the firm as well.

3. Creditors Turnover Ratio
This ratio shows the relation between credit purchases (cash purchases are ignored in this context) and the average creditors of a company at any given time of the accounting year. This ratio is also the ‘accounts payable turnover ratio’. While calculating the net purchases we will minus any purchase return. The formula is as below:

Creditors Turnover ratio = $$\frac{\text { CreditPurchases }}{\text { AverageCreditors }}$$
OR
Creditors Turnover ratio = $$\frac{\text { CreditPurchases }}{\text { Creditors }+\text { BillsPayable }}$$
Average Creditors = $$\frac{\text { OpeningCreditors + ClosingCreditors }}{2}$$

Now using the same ratio, we can also calculate the average payment period in the number of days/weeks/months. We only have to modify the ratio a little, and remember this will be expressed as a function of time (days, moths etc)

Average Payment Period = $$\frac{\text { Numberofdays } / \text { weeks } / \text { months }}{\text { CreditorsT/ORatio }}$$

Again creditors turnover ratio has great importance. It calculates the velocity with which creditors are paid off during the year. It helps the management judge how efficiently the accounts payables are being handled.

4. Working Capital Turnover Ratio
This one of the activity ratios will measure the efficiency with which the firm is using their Working Capital to support their sale volumes. So any excess of current assets over the current liabilities of a firm is their working capital. The formula for the ratio is

Working Capital Turnover ratio = $$\frac{\text { Total Sales }}{\text { WorkingCapital }}$$
Working Capital = Current Assets – Current Liabilities

A high Working Capital Turnover ratio means that the working capital is being very efficiently utilized. But sometimes it could mean that the creditors of the company are excessive (bringing down the working capital) and this could be a problem in the future. Conversely, a low ratio could mean that there are too many debtors or a very big inventory which is not an efficient use of resources.

Example:

Question:
Calculate Debtors Turnover Ratio and Average Collection Period (in days) from the following.
Total Sales – 6,00,000
Cash Sales – 20% of Total sales
Trades Receivable at beginning of the year – 80,000
Trades Receivable at the end of the year – 1,60,000
Solution:
From the given information
Credit Sales = 80% of Total Sales
= 80% of 6,00,000
= 4,80,000
Average Debtors = $$\frac{\text { OpeningDebtors }+\text { ClosingDebtors }}{2}$$
= $$\frac{80,000+1,60,000}{2}$$
= 1,20,000
Debtors Turnover ratio = $$\frac{\text { CreditSales }}{\text { AverageDebtors }}$$
= $$\frac{480000}{120000}$$
= 4 times
Average Collection Period = $$\frac{\text { Numberofdays } / \text { weeks } / \text { months }}{\text { DebtorsT/ORatio }}$$
= $$\frac{365}{4}$$
= 91.25 days
= 92 days