Efficiency Ratios Formula

Publication Date :

Blog Author :

Download FREE Efficiency Ratios Formula Excel Template and Follow Along!
Efficiency Ratios Formula Excel Template.xlsx

Table Of Contents

arrow

What is the Efficiency Ratio?

Efficiency ratios measure how effectively a company manages its assets and liabilities and include formulas like asset turnover, inventory turnover, receivables turnover, and accounts payable turnover.

The Asset turnover ratio measures an organizationā€™s ability to utilize its assets for generating revenues effectively.

Asset Turnover Ratio = Sales / Average Total Assets.

The Inventory turnover ratio indicates the number of times the total inventory has been sold.

Inventory Turnover Ratio = Cost of Goods Sold / Average Inventory.

Receivables turnover ratio or debtors turnover ratio refers to the number of times in a period an organization collects its accounts receivable.

Receivables Turnover Ratio = Credit Sales / Average Accounts Receivable

The speed at which a company pays its suppliers is measured by the accounts payable turnover ratio.

Accounts Payable Turnover Ratio = Supplier Purchase / Average Account Payable

efficiency ratios formula
You are free to use this image on your website, templates, etc.. Please provide us with an attribution link

Explanation of Efficiency Ratios Formula

#1 - Asset Turnover Ratio

To calculate the asset turnover ratio, the following steps should be undertaken:

Step 1: Calculate the sales.

Step 2: Calculate average total assets using the formula.

Average Total Assets = Opening Total Assets + Closing Total Assets / 2

Step 3: Calculate the asset turnover ratio using the formula.

Asset Turnover Ratio = Sales / Average Total Assets

#2 - Inventory Turnover Ratio

To calculate the inventory turnover ratio, the following steps should be undertaken:

Step 1: Calculate the cost of goods sold.

Step 2: Calculate the average inventory using the formula.

Average Inventory = Opening Inventory + Closing Inventory / 2

Step 3: Calculate the inventory turnover ratio using the formula.

Inventory Turnover Ratio = Cost of Goods Sold / Average Inventory

#3 - Receivables Turnover Ratio

To calculate the receivables turnover ratio, the following steps should be undertaken:

Step 1: Calculate the total credit sales.

Step 2: Calculate the average accounts receivable using the formula.

Average Accounts Receivable = Opening Account Receivable + Closing Accounts Receivable / 2

Step 3: Calculate the receivables turnover ratio using the formula.

Receivables Turnover Ratio = Credit Sales / Average Accounts Receivable

#4 - Accounts Payable Turnover Ratio

To calculate the accounts payable turnover ratio, the following steps should be undertaken:

Step 1: Calculate the Supplier Purchases.

Step 2: Calculate the average accounts payable using the formula.

Average Accounts Payable = Opening Account Payable + Closing Accounts Payable / 2

Step 3: Calculate the accounts payable turnover ratio using the formula.

Accounts Payable Turnover Ratio = Supplier Purchase / Average Accounts Payable

Examples of Efficiency Ratios Formula (with Excel Template)

Below are the examples for the calculation of efficiency ratios formula.

Example #1

Rudolf Inc. gives you the following information about the company:

  • Sales: $50,000
  • Average Total Assets: $10,000
  • Cost of Goods Sold: $30,000
  • Average Inventory: $6,000

Calculate the Asset Turnover Ratio and Inventory Turnover Ratio from the above data.

Solution:

Calculation of Asset Turnover Ratio will be - 

Example 1.1.0

Asset Turnover Ratio = 50000/10000

Asset Turnover Ratio = 5

Calculation of Inventory Turnover Ratio will be - 

Efficiency Ratios Formula Example 1.2

Inventory Turnover Ratio = 30000/6000

Inventory Turnover Ratio = 5

The Asset Turnover Ratio is 5, and the Inventory Turnover Ratio is 5.

Example #2

The Chief Accountant of Alister Inc. gives some information about the business for the year 2018:

  • Credit Sales: $60,000
  • Accounts Receivable (1.1.2018): $8,000
  • Closing Accounts Receivable (31.12.2018): $12,000
  • Supplier Purchase: $30,000
  • Accounts Payable (1.1.2018): $6,000
  • Accounts Payable (31.12.2018): $10,000

Calculate the following assuming there are 360 days in a year:

  1. Receivables turnover ratio and the debtor days.
  2. Accounts Payable Turnover Ratio.

Solution:

Calculation of Average Accounts Receivable will be - 

Efficiency Ratios Formula Example 2.1

Average Accounts Receivable = (8000 + 12000)/2

Average Accounts Receivable = $10,000

Calculation of Receivables Turnover Ratio will be - 

Example 2.2

Receivables Turnover Ratio = 60000 / 10000

Receivables Turnover Ratio = 6

Debtor Days = 360/6 = 60 days

Receivables Turnover Ratio is 6, and debtor days is 60.

Calculation of Average Accounts Payable will be -

Efficiency Ratios Formula Example 2.3.0

Average Accounts Payable = (6000 + 10000)/2

Average Accounts Payable = $8,000

Calculation of Accounts Payable Turnover Ratio will be -

Example 2.4

Accounts Payable Turnover Ratio = 30000/8000

Accounts Payable Turnover Ratio = 3.75

Accounts Payable Turnover Ratio is 3.75.

Example #3

Baseline Inc. gives you the following financial information for 2018:

  • Credit Sale (all sales are on credit): $6,000
  • Average Accounts Receivables: $2,000
  • Average Total Assets: $10,000
  • Cost of Goods Sold: $5,000
  • Average Inventory: $1,000
  • Supplier Purchase: $3,000
  • Average Accounts Payable: $600

Calculate the following efficiency ratios:

  1. Asset Turnover Ratio
  2. Inventory Turnover Ratio
  3. Receivables Turnover ratio
  4. Accounts Payable Turnover Ratio

Solution:

Calculation of Asset Turnover Ratio will be -

Example 3.1.0

Asset Turnover Ratio = 6000 / 10000

Asset Turnover Ratio = 0.6

Calculation of Inventory Turnover Ratio will be -

Efficiency Ratios Formula Example 3.2

Inventory Turnover Ratio = 5000/1000

Inventory Turnover Ratio = 5

Calculation of Receivables Turnover Ratio will be -

Example 3.3

Receivables Turnover Ratio = 6000/2000

Receivables Turnover Ratio = 3

Calculation of Accounts Payable Turnover Ratio will be -

Efficiency Ratios Formula Example 3.4

Accounts Payable Turnover Ratio = 3000/600

Accounts Payable Turnover Ratio = 5

Example #4

George Inc. had the following financial information in 2017:

  • Credit Sale: $20,000
  • Average Accounts Receivables: $2,000
  • Average Total Assets: $10,000
  • Cost of Goods Sold: $15,000
  • Average Inventory: $3,000

All the sales are on credit. Find out the following ratios:

  1. Asset Turnover Ratio
  2. Inventory Turnover Ratio
  3. Receivables Turnover Ratio

Solution:

Step 1: In order to calculate the asset turnover ratio, use the above formula.

Efficiency Ratios Formula Example 4.1

Asset Turnover Ratio = 20000/10000

Asset Turnover Ratio will be -

Example 4.2

Asset Turnover Ratio = 2

Step 2: To calculate the inventory turnover ratio, use the above formula.

Efficiency Ratios Formula Example 4.3

Inventory Turnover Ratio = 15000/3000

Inventory Turnover Ratio will be -

Example 4.4

Inventory Turnover Ratio = 5

Step 3: To calculate the receivables turnover ratio, use the above formula.

Efficiency Ratios Formula Example 4.5

Receivables Turnover Ratio = 20000/2000

Receivables Turnover Ratio will be -

Example 4.6

Receivables Turnover Ratio = 10

Thus, Asset Turnover Ratio is 2. The Inventory Turnover Ratio is 5. The receivables Turnover Ratio is 10.

Relevance and Uses

Efficiency ratios are industry-specific. It implies that certain industries have higher ratios due to the nature of the industry.

The higher the asset turnover ratio, the better it is for a company, indicating that it is efficient in generating its revenues. The debtors turnover ratio indicates the efficiency with which a company turns its receivables into cash. With the help of the debtors turnover ratio, debtor days can be calculated. Debtor days give the average number of days a business takes to collect its debts. The high number of debtor days indicates that the debt collection system of the company is poor.

The inventory turnover ratio indicates how fast a company is able to move its stocks. The accounts payable turnover ratio indicates how many times a company pays off its suppliers in a particular period.