Efficiency Ratios Formula

What is the Efficiency Ratio?

Efficiency ratios are a measure of 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 ratioAsset Turnover RatioThe asset turnover ratio is the ratio of a company's net sales to total average assets, and it helps determine whether the company generates enough revenue to justify holding a large amount of assets under the company’s balance sheet.read more measures an organization’s ability to effectively utilize its assets for generating revenues.

Asset Turnover Ratio = Sales / Average Total Assets.

The Inventory turnover ratioInventory Turnover RatioInventory Turnover Ratio measures how fast the company replaces a current batch of inventories and transforms them into sales. Higher ratio indicates that the company’s product is in high demand and sells quickly, resulting in lower inventory management costs and more earnings.read more indicates the number of times the total inventory has been sold over a period.

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 linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: Efficiency Ratios Formula (wallstreetmojo.com)

Explanation of Efficiency Ratios Formula

#1 – Asset Turnover Ratio

In order to calculate the asset turnover ratio, the following steps should be undertaken:

Step 1: Calculate the sales.

Step 2: Calculate average total assetsTotal AssetsTotal Assets is the sum of a company's current and noncurrent assets. Total assets also equals to the sum of total liabilities and total shareholder funds. Total Assets = Liabilities + Shareholder Equityread more 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

In order to calculate the inventory turnover ratio, the following steps should be undertaken:

Step 1: Calculate the cost of goods soldCost Of Goods SoldThe Cost of Goods Sold (COGS) is the cumulative total of direct costs incurred for the goods or services sold, including direct expenses like raw material, direct labour cost and other direct costs. However, it excludes all the indirect expenses incurred by the company. read more.

Step 2: Calculate the average inventory using the formulaAverage Inventory Using The FormulaAverage Inventory is the mean of opening and closing inventory of a particular period. It helps the management to understand the inventory that a business needs to hold during its daily course of business.read more.

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

In order to calculate the receivables turnover ratio, the following steps should be undertaken:

Step 1: Calculate the total credit salesCredit SalesCredit Sales is a transaction type in which the customers/buyers are allowed to pay up for the bought item later on instead of paying at the exact time of purchase. It gives them the required time to collect money & make the payment. read more.

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

In order 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.

You can download this Efficiency Ratios Formula Excel Template here – Efficiency Ratios Formula Excel Template

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 informationFinancial InformationFinancial Information refers to the summarized data of monetary transactions that is helpful to investors in understanding company’s profitability, their assets, and growth prospects. Financial Data about individuals like past Months Bank Statement, Tax return receipts helps banks to understand customer’s credit quality, repayment capacity etc.read more 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: In order 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: In order 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 as it indicates 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 daysDebtor DaysDebtor Days Formula is used to calculate the average days required to receive the customer's payments against the invoices issued. Debtor Days Formula =(Average Accounts Receivable / Annual Total Sales) * 365 days read more 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.

Recommended Articles

This article has been a guide to efficiency ratios formula. Here we discuss the formula to calculate efficiency ratios along with practical examples and a downloadable excel template. You can learn more about financial statement analysis from the following articles –