• Skip to primary navigation
  • Skip to main content
  • Skip to footer
WallStreetMojo

Wallstreet Mojo

Wallstreet Mojo

MENUMENU
  • Resources
        • Financial Statement Analysis

          • Ratio Analysis
          • Profitability Ratios
          • Turnover Ratios
        • Financial-Statement-Analysis
        • Accounting Basics

          • Income Statement
          • Balance Sheet
          • Cash Flow in Accounting
        • Accounting-Basics
        • Accounting Concepts

          • Assets in Accounting
          • Liabilities in Accounting
          • Shareholders Equity
        • Accounting-Concepts
        • Investment Banking Guides

          • Investment Banking
          • What is LBO?
          • What is Pitch Book?
        • Investment Banking Guides
        • Valuation

          • Discounted Cash Flow
          • Dividend Discount Model
          • Terminal Value
        • Valuation
        • Others

          • Resources (A to Z)
          • Financial Modeling
          • Financial Certifications
          • Equity Research
          • Private Equity
          • Excel
  • Free Courses
  • All Courses
        • Certification Courses

          Certificate
        • All in One Financial Analyst Bundle

          Financial-Analyst-Bundle
        • Accounting Course

          Accounting-Course
        • Investment Banking Course

          Investment-Banking-Training
        • Others

          • Equity Research Course
          • Financial Modeling Course
          • M&A Course
          • Valuation Course

          • Private Equity Course
          • Venture Capital Course
          • US GAAP Course
          • View All
  • 250+ Courses All in One Bundle
  • Login

Inventory Ratio

Home » Financial Statement Analysis » Turnover Ratios » Inventory Ratio

By Harshada Khot Leave a Comment

Inventory Ratio

What is the Inventory Ratio?

Inventory ratio is one of the activity ratios that depicts how many times the firm or an organization has replaced and sold the stock or the inventory during a given time. It can be calculated by dividing the cost of goods sold by average inventory. In certain cases, sales are used instead of the cost of goods sold but that would unnecessarily distort the figure as sales include markup as well.

Examples of Inventory Ratio

Let us understand the example of the Inventory Ratio.

You can download this Inventory Ratio Excel Template here – Inventory Ratio Excel Template

Example #1

Kanchan jewelers have been operating since 1990 and have become one of the renowned jeweler’s shops in the town and also preferred by the customer. However, with the recent opening of Reliance Jewelers, the business of Kanchan jeweler seems to be much affected. Below are the sales data and its inventory for the past 3 years.

Inventory Ratio 1

As can be seen the sales are declining and inventory is rising which indicates intense competition and slow growth for Kanchan jewelers. Use Inventory Ratio to find out how much has been their business affected.

Solution:

First, we need to calculate the average inventory. Hence, for 2013 average inventory will be of 2012 and 2013 and similarly for 2014 will be an average of 2013 and 2014. Then in the second step, we can divide sales by average inventory.

Calculation of Inventory Turnover for 2013 can be done as follows –

Example 1.1

Calculation of Inventory Turnover Ratio for 2014 can be done as follows –

Inventory Ratio Example 1.2

Analysis: We can see that in 2013 the ratio was close to 8 times and in 2014 it went down to 4 times which clearly shows that their inventory movement relative to sales have been halved and it is a clear sign of slow growth and intense competition from Reliance jewelers.

Example #2

Cutthroat competition limited has provided you the below details, and they have asked you to calculate the inventory ratio.

 Example 2

Solution:

Calculation of Inventory Turnover Ratio can be done as follows –

Popular Course in this category
Cyber Monday Sale
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) 250+ Courses | 40+ Projects | 1000+ Hours | Full Lifetime Access | Certificate of Completion
4.9 (1,067 ratings)
Course Price

View Course

Related Courses
Accounting CourseInvestment Banking CourseEquity Research Course

Inventory Ratio Example 2.1

The formula for calculating inventory ratio is the cost of goods sold divided by average inventory.

First, we will calculate the cost of goods sold.

  • The formula for the cost of goods sold is Opening stock + Purchases – Closing stock
  •  Cost of goods sold = 10,000 + 85,000 – 5,000 = 90,000.

Second, Average inventory can be calculated by dividing ( opening stock + closing stock ) by 2

  • Average inventory = (10,000 + 5,000) / 2 = 15,000 / 2 = 7,500.

In the final step, we will divide the cost of goods sold by average inventory

Inventory Turnover = 90,000 / 7,500 = 12 Times

Example #3

ABC limited and PQR limited both are competing and they are targeting their customers to choose their brand and avoid the other.

However, they have recently been questioned by the competition law tribunal for their intensive pricing the customer and the law tribunal feels that they are fooling the customer and they are sharing the areas where one dominates and other doesn’t and, in another area, the other dominates while the former doesn’t.

Below are the recent sales and inventory data available, you are required to calculate the turnover ratio and find whether any truth exists in the law tribunal’s statement?

Example 3

Solution:

We can use a basic formula to calculate inventory turnover ratio which is sales divided by average inventory.

Calculation of Inventory Turnover Ratio for ABC can be done as follows –

Inventory Ratio Example 3.1

Calculation of Inventory Turnover for PQR can be done as follows –

Example 3.2

The ratio of sales and average inventory appears to be similar and further the turnover ratio is quite close and therefore prima facie it appears that both the companies might be involved in an internal agreement but there are other various factors that should also be considered before coming to any conclusion.

Example #4

JBL limited whose business into selling Bluetooth speakers and other electronic devices is working out for loan proposals since they want to boost up their sales and are lacking funds to expand. VDFC bank has agreed to provide loan to JBL limited, and one of the conditions which are required to be fulfilled by them is their inventory turnover should be greater than 5 for the past 3 years.

JBL limited has provided below information for the past 4 years. You are required to advise whether they are fulfilling the bank condition?

Example 4

Solution:

We can use a basic formula to calculate inventory turnover which is sales divided by average inventory.

Calculation of Inventory Turnover Ratio for 2013 can be done as follows –

Inventory Ratio Example 4.1

Calculation of Inventory Turnover Ratio for 2014 can be done as follows –

Example 4.2

Calculation of Inventory Turnover for 2015 can be done as follows –

Inventory Ratio Example 4.3

In the recent year 2015, the company fails to pass on inventory ratio greater than 5 and there are high chances the company will face difficulties in getting the loan sanctioned.

Conclusion

Inventory turnover as discussed depicts how many times the firm has replaced and sold the stock or inventory during a given time. This ratio helps the firm or the businesses to make better decisions on whether being on manufacturing, purchasing new inventory, marketing, and pricing.

The low turnover ratio will imply weak turnover or weaker sales and possibly either stale inventory or excess inventory, and on another side, a higher ratio will imply either short on inventory or strong sales.

Recommended Articles

This has been a guide to what is Inventory Ratio and its definition. Here we discuss inventory ratio formula along with practical examples and explanations. You can learn more about accounting from following articles –

  • Types of Markup
  • Cape Ratio Advantages
  • Definition of Inventories List
  • Activity Ratios
  • Journal Entries for Cost of Goods Sold
  • Inventory as Current Asset
  • Inventory vs Stock – Compare
  • Inventory Write-Down Method
2 Shares
Share
Tweet
Share

Filed Under: Financial Statement Analysis, Turnover Ratios

Reader Interactions
Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Footer
COMPANY
About
Reviews
Blog
Contact
Privacy
Terms of Service
FREE COURSES
Free Finance Online Course
Free Accounting Online Course
Free Online Excel Course
Free VBA Course
Free Investment Banking Course
Free Financial Modeling Course
Free Ratio Analysis Course

CERTIFICATION COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Business Valuation Course
Equity Research Course
CFA Level 1 Course
CFA Level 2 Course
Venture Capital Course
Microsoft Excel Course
VBA Macros Course
Accounting Course
Advanced Excel Course
Fixed Income Course
RESOURCES
Investment Banking
Financial Modeling
Equity Research
Private Equity
Excel
Books
Certifications
Accounting
Asset Management
Risk Management

Copyright © 2019. 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 Ratio Analysis Course

Step by Step Guide to Calculating Financial Ratios in excel

By continuing above step, you agree to our Terms of Use and Privacy Policy.

Free Investment Banking Course

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

By continuing above step, you agree to our Terms of Use and Privacy Policy.

Free Investment Banking Course

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

By continuing above step, you agree to our Terms of Use and Privacy Policy.
WallStreetMojo

Free Investment Banking Course

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

By continuing above step, you agree to our Terms of Use and Privacy Policy.

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

Download Colgate Ratio Analysis Template

By continuing above step, you agree to our Terms of Use and Privacy Policy.
WallStreetMojo

Free Investment Banking Course

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

By continuing above step, you agree to our Terms of Use and Privacy Policy.

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

WallStreetMojo

Free Investment Banking Course

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

By continuing above step, you agree to our Terms of Use and Privacy Policy.

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

WallStreetMojo

Download Inventory Ratio Excel Template

By continuing above step, you agree to our Terms of Use and Privacy Policy.

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