WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All In One Bundle
  • Login
Home » Investment Banking Tutorials » Financial Statement Analysis » Inventory Turnover

Inventory Turnover

By Madhuri ThakurMadhuri Thakur | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

What is Inventory Turnover?

Inventory turnover is a comparison of average inventory held by an organization with the cost of goods sold. In simple words, a number of times goods sold or consumed by an organization, and the ratio is also used to calculate the estimated time period required to sale the inventory held by the organization.

Inventory Turnover Formula

It can be calculated as follows:

Inventory Turnover Formula = Cost of Goods Sold/Average Inventory 
Inventory Turnover Formula

Explanation

This ratio is used by an organization to calculate the number of times it is selling goods and replace its stock during a given period of time. This ratio also helps in showing how effectively a company manages its inventory cost and how effectively its sales efforts are converted into figures. For the calculation of inventory turnover, we need to understand the following items:

Cost of Goods Sold

We use the cost of goods sold from the income statement since the cost of goods sold includes purchase cost as well as the cost incurred by the organization to manage such inventory, such as storage cost, handling cost, wages, and labor charges, etc.

Average Inventory Held

We use average inventory during the period is used instead of closing inventory since there might be situations where the company had an opening stock of inventory and purchased very less quantity of goods and the year-end it had sold most of the goods and if we use closing inventory, the ratio will not be based on inventory held by the organization during the period, which will not display the actual picture of time period taken by the organization to generate such sales.

Popular Course in this category
Sale
Investment Banking Training (117 Courses, 25+ Projects)
4.9 (831 ratings)
117 Courses | 25+ Projects | 600+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Examples of Inventory Turnover Calculation (with Excel Template)

Let’s see some simple to advanced practical examples to understand it better.

You can download this Inventory Turnover Formula Excel Template here – Inventory Turnover Formula Excel Template

Example #1

Company STYLISH Ltd. is operating in the clothing products and income statement of last year of the company shows the following figures. You need to calculate the inventory turnover ratio.

  • Opening Inventory: 24,560
  • Closing Inventory: 1540
  • Cost of Goods Sold: $452,700

Solution

Use below given data for the calculation.

Inventory Turnover Formula Example 1

Calculation of Average Inventory 

Inventory Turnover Formula Example 1.1

  • =(24560+1540)/2
  • Average Inventory = 13050

Inventory Turnover Formula Example 1.2

  • =452700/13050

Inventory Turnover will be –

Inventory Turnover Formula Example 1.3

Example #2

Taking the concept of inventory formula ahead, we will learn to calculate inventory turnover ratio as well as the inventory holding period. Suppose Company Furniture and fixtures Pvt. Ltd. manufactures chairs and tables. Its income statement shows that it had an opening inventory of 86900, and during the period, it manufactures chair and table costing 3495000, and at the end of the period, it had 635000 as stock in hand of inventory. We need to calculate the inventory turnover ratio as per as inventory holding period.

Solution

Use below given data for the calculation.

Inventory Turnover Formula Example 2

Calculation of Cost of Goods Sold

Inventory Turnover Formula Example 2.1

  • =86900+3495000-635000
  • Cost of Goods Sold = 2946900

Calculation of Average Inventory

Inventory Turnover Formula Example 2.2

  • =(86900+635000)/2
  • Average Inventory = 360950

The calculation can be done as follows-

Inventory Turnover Formula Example 2.3

  • = 2946900/360950

Inventory Turnover will be –

Inventory Turnover Formula Example 2.4

Inventory Holding Period

Example 2.5

  • = 365/ Inventory turnover Ratio
  • = 365/8.16
  • = 44.71 days

This means that the company roughly takes one and a half months to replace it is stock and sell its complete stock in hand.

Example #3

Taking another example to understand the benefit of using the inventory turnover ratio formula in practical life, Suppose Company Delta has an opening stock of $ 326,500 and purchased goods amounting to $ 5,284,600, and it paid direct expenses relating to goods handling are 65,300. At the end of the accounting period, it had $ 765,300 as a closing inventory. We need to calculate the inventory turnover ratio formula, as well as the inventory holding period.

Solution

Use below given data for the calculation.

Example 3

Calculation of Cost of Goods Sold

Inventory Turnover Formula Example 3.1

  • =326500+5284600+65300+765300
  • Cost of Goods Sold = 4911100

Calculation of Average Inventory

Example 3.2

  • =(326500+765300)/2
  • Average Inventory = 545900

The calculation can be done as follows-

Example 3.3

  • =4911100/545900

Inventory Turnover will be –

Example 3.4

Inventory Holding Period

Example 3.5

  • Inventory Holding Period = 40.57

Calculator

You can use these inventory turnover formula calculator

Cost of Goods Sold
Total Interest Expense
Inventory Turnover Formula
 

Inventory Turnover Formula =
Cost of Goods Sold
=
Total Interest Expense
0
= 0
0

Relevance and Use

  • It varies from industry to industry. For example, a clothing retailer company may have an inventory turnover of 5 to 8, whereas an automotive parts company may have a turnover of 45 to 50. So this shows that it is a very important tool in making strategies and achieving company objectives.
  • Inventory turnover depends on purchase and sale. If a company purchase high-value items, then it has to sell to be matched with purchase; otherwise, the company has to bear storage and handling the cost of high-value inventory.
  • In decision making, inventory turnover also plays a very important role, as explained below:

Higher Ratio

If the inventory turnover ratio is high, it means that the company’s product has very good demand in the market, and products are sold very quickly, which leads to less inventory maintenance costs and higher profits.

Lower Ratio

If the inventory ratio of a company is very low, it indicates that the company’s products are not often sold in the market, and inventory of the company becomes a slow-moving inventory, which leads to higher inventory costs and fewer profits.

If a company is suffering from a low inventory turnover ratio, it can adopt the following strategies to improve its inventory turnover ratio:

  • Review strategies relating to the pricing of products.
  • Try to improve sales by using marketing techniques.
  • Analyze the fast-moving inventory and slow-moving inventory
  • Improve bargain power and review the purchase price regularly
  • Understand the customers’ needs and try to get an order from customers well in advance.

Recommended Articles

This article has been a guide Inventory Turnover Formula. Here we discuss the formula for calculation of inventory turnover along with practical examples and a downloadable excel template. You can learn more about financial analysis from the following articles –

  • Calculate Inventory Ratio
  • Average Inventory Formula
  • Ending Inventory Calculation
  • LIFO Inventory Method
  • Return on Average Capital Employed Formula
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Login

Forgot Password?

WallStreetMojo

Free Ratio Analysis Course

Step by Step Guide to Calculating Financial Ratios in excel

WallStreetMojo

Download Inventory Turnover Formula Excel Template

Special Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More