# Efficiency Ratios Formula

Article byDiksha Keni
Reviewed byDheeraj Vaidya, CFA, FRM

## 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 measures an organization’s ability to utilize its assets for generating revenues effectively.

Asset Turnover Ratio = Sales / Average Total Assets.
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

For eg:
Source: Efficiency Ratios Formula (wallstreetmojo.com)

### 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.

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

Now you can Master Financial Modeling with Wallstreetmojo’s premium courses at special prices

#### Best Financial Modeling Courses by Wallstreetmojo

###### Financial Modeling Course
* McDonalds Step by Step Modeling from Scratch
* 12+ Hours of Video
* Certificate
Rating 4.91/5
###### Financial Modeling & Valuation
* McDonalds Step by Step Modeling from Scratch
* Valuations
* 25+ Hours of Video
* Certificate of Completion
Rating 5/5
###### Valuation Course
* Valuations (DCF, DDM, Comparable Comps)
* 12+ Hours of Video
* Certificate
Rating 4.89/5

#### #2 – Inventory Turnover Ratio

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

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

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 –

Asset Turnover Ratio = 50000/10000

Asset Turnover Ratio = 5

Calculation of Inventory Turnover Ratio will be –

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 –

Average Accounts Receivable = (8000 + 12000)/2

Average Accounts Receivable = \$10,000

Calculation of Receivables Turnover Ratio will be –

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 –

Average Accounts Payable = (6000 + 10000)/2

Average Accounts Payable = \$8,000

Calculation of Accounts Payable Turnover Ratio will be –

Accounts Payable Turnover Ratio = 30000/8000

Accounts Payable Turnover Ratio = 3.75

Accounts Payable Turnover Ratio is 3.75.

#### Example #3

• 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 –

Asset Turnover Ratio = 6000 / 10000

Asset Turnover Ratio = 0.6

Calculation of Inventory Turnover Ratio will be –

Inventory Turnover Ratio = 5000/1000

Inventory Turnover Ratio = 5

Calculation of Receivables Turnover Ratio will be –

Receivables Turnover Ratio = 6000/2000

Receivables Turnover Ratio = 3

Calculation of Accounts Payable Turnover Ratio will be –

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.

Asset Turnover Ratio = 20000/10000

Asset Turnover Ratio will be –

Asset Turnover Ratio = 2

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

Inventory Turnover Ratio = 15000/3000

Inventory Turnover Ratio will be –

Inventory Turnover Ratio = 5

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

Receivables Turnover Ratio = 20000/2000

Receivables Turnover Ratio will be –

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 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 the efficiency ratios formula. Here we discuss the formula for calculating efficiency ratios, practical examples, and a downloadable excel template. You can learn more about financial statement analysis from the following articles –