Masters India

Types of Activity Ratios with Examples

Sakshi Jain
Sakshi Jain at April 07, 2023
banner1
banner1

Know About Activity Ratios

Activity Ratios or Assets Management Ratio depicts how a company utilizes its assets to generate revenue. In simple words, the activity ratio denotes the ratio between the invested amount in the particular asset type and the revenue generated by such asset in the activity ratio example. This is the reason why the activity ratio is also known as an efficiency ratio, turnover ratio, or productivity ratio. Further, let's discuss activity ratios examples.

Stock Turnover Ratio

Stock turnover ratio is the most important activity ratio as it helps in understanding the relationship between inventory/average stock and the cost of goods sold. Stock turnover ratio is also known as inventory turnover ratio or stock velocity ratio is known as the speed of stock conversion into sales or revenue.

Activity Ratio Formula:

Stock Turnover Ratio = COGS / Average Inventory

Where,

COGS = Sales - Gross Profit, &

Average Inventory = (Opening Stock + Closing Stock) / 2

Higher Stock Turnover ratio shows that a business is generating sufficient revenue and goods purchased are converting into sales rapidly. This helps the management to schedule inventory reordering. On the other hand, a lower Stock Turnover ratio depicts the slow conversion rate of the stock into revenue.

Example of activity ratio

Calculate inventory turnover ratio of XYZ Ltd. As per the given Information in examples of activity ratios

Opening inventories

50,000

Closing inventories

60,000

Cost of goods manufactured

4,90,000

Solution:

Cost of goods sold = 50,000 + 4,90,000 – 60,000 = 4,80,000

Average inventories = (50,000 + 60,000) / 2 = 55,000

Inventory turnover ratio = 4,80,000 ÷ 55,000 = 8.73

Debtor Turnover Ratio

Debtor Turnover ratio indicates how a business deals with their Bills Receivables due to which it is also known as Account Receivable Turnover ratio. Through Debtor Turnover ratio a business can determine the relationship between credit sales and average debtors.

Formula:

Debtor Turnover ratio = Credit Sales / Average Debtors or

Debtor Turnover ratio = Credit Sales / Debtors + Bills Receivables

Where,

Average Debtor = (Opening Debtor + Closing Debtor) / 2

Higher Debtor Turnover ratio represents that credit policies created by the management of a business are efficient and need no alteration. Whereas the lower ratio shows that management needs to work on their credit policies or have to change the existing credit policy of the business.

Example for Activity Ratio

Let us assume XYZ has the following result of the previous financial year:

Opening Debtors

64,000

Closing Debtors

72,000

Credit Sale

8,00,000

Solution:

Average Debtors = (64,000 + 72,000) / 2 = 68,000

Debtor Turnover ratio = 800,000 / 68,000 = 11.76

 

Creditors Turnover Ratio

Creditors Turnover ratio represents how a business deals with their Bills Payables that is why it is also known as Accounts Payable Turnover ratio. Through Creditor Turnover ratio a business can determine the relationship between the credit purchase and average creditors.

Formula:

Creditors Turnover Ratio = Credit Purchase / Average Creditors OR

Creditors Turnover Ratio = Credit Purchase / Average Creditors + Bills Payable

Where,

Average Creditor = (Opening Creditor + Closing Creditor) / 2

Higher Creditor Turnover ratio represents the efficiency of credit purchases policies created by the management of a business. Whereas the lower ratio shows that management needs to alter the existing credit purchase policy of the business.

Example

We give an example of activity ratio.

Let us assume XYZ has the following result of the previous financial year:

Opening Creditors

30,000

Closing Creditors

50,000

Credit Purchase

5,00,000

Solution:

Average Creditors = (30,000 + 50,000) / 2 = 40,000

Creditors Turnover ratio = 5,00,000 / 40,000 = 12.5

Working Capital Turnover Ratio

Working Capital Turnover Ratio is another important turnover ratio that helps the business to determine the utilization efficiency of the working capital of a business. This ratio explains the relationship between Sales / COGS and working capital.

Formula

Working Capital Turnover Ratio = Sales or Cost of Goods Sold / Working Capital

Where

COGS = Sales- Gross Profit, &

Working Capital = Current Assets - Current Liabilities

Generally, higher Working Capital Turnover ratio means that a business working capital is efficiently utilized. On the contrary, the lower ratio shows that a business is having too many debtors or there is a lot of inventory lying that is not an efficient use of resources.

Example

We give an example for activity ratio which help you to clear concept of activity ratio.

Calculate Working Capital Turnover ratio of XYZ Ltd. As per the given Information:

Net Sales

5,00,000

Current Asset

10,00,000

Closing Creditors

7,50,000

Solution:

Working Capital = 10,00,000 - 7,50,000 = 2,50,000

Working Capital Turnover Ratio = 5,00,000 / 2,50,000 = 2

All the above activity ratio examples, help you understand activity ratio in proper way. 

To know more about activity ratio and get activity ratio questions and answers, visit the site of Masters India.

Rate your experience
4.50 / 5. Vote count: 187
Accounts Payable
Upgrade your Bill Payment digitally using AP automation, or accounts payable automation by technology switch to a revolutionized way for business.

Check out other Similar Posts

No Data found
No Blogs to show
Need Help in Getting Started?
Make smart decision to replace your manual work with modern solution and improve your business output
Request Callback
Continue Browsing
Subscribe Now!
Receive GST, E way bill, e-Invoice, Accounts payable and OCR updates from our experts.
logo
Chat with us

😄Hello. Welcome to Masters India! I'm here to answer any questions you might have about Masters India Products & APIs. What brings you to our website today?

Looking for

GST Software

E-Way Bill Software

E-Invoice Software

BOE TO Excel Conversion

Accounts Payable Software

Invoice OCR Software/APIs

GST API

GST Verification API

E-Way Bill API

E-Invoicing API

KSA E-Invoice APIs

Vehicle tracking

Vendor Verification API

Other Requirement