Financial Statement Analysis
 Ratio Analysis of Financial Statements (Formula, Types, Excel)
 Ratio Analysis
 Liquidity Ratios
 Turnover Ratios
 Profitability Ratios
 Profit Margin
 Gross Profit Margin Formula
 Operating Profit Margin Formula
 Net Profit Margin Formula
 EBIDTA Margin
 Earnings Per Share
 Basic EPS
 Diluted EPS
 Basic EPS vs Diluted EPS
 Return on Equity (ROE)
 Return on Capital Employed (ROCE)
 Return on Invested Capital (ROIC)
 Return on Total Assets (ROA)
 Return on Average Capital Employed
 Capital employed Employed
 Return on Average Assets (ROAA)
 Return on Average Equity (ROAE)
 Return on Assets Formula
 Return on Equity Formula
 DuPont Formula
 Net Interest Margin Formula
 Earnings Per Share Formula
 Diluted EPS Formula
 Contribution Margin Formula
 Revenue Per Employee Ratio
 Operating Leverage
 EBIT vs EBITDA
 EBITDAR
 Capital Gains Yield
 Tax Equivalent Yield
 LTM Revenue
 Operating Expense Ratio Formula
 Overhead Ratio Formula
 Capacity Utilization Rate Formula
 Total Expense Ratio Formula
 Efficiency Ratios
 Dividend Ratios
 Debt Ratios
 Debt to Equity Ratio
 Debt Coverage Ratio
 Debt Ratio
 Debt to Income Ratio Formula (DTI)
 Capital Gearing Ratio
 Capitalization Ratio
 Interest Coverage Ratio
 Times Interest Earned Ratio
 Debt Service Coverage Ratio (DSCR)
 Financial Leverage Ratio
 Net Debt Formula
 Leverage Ratios
 Operating Leverage vs Financial Leverage
 Current Yield
 Debt Yield Ratio
Inventory Turnover Ratio Formula
Inventory turnover ratio is an important efficiency ratio. It dictates how fast a company replaces a current batch of inventories and transforms the inventories into sales.
Here’s the formula for inventory turnover ratio –
Example of Inventory Turnover Ratio Formula
Let’s take a simple example to illustrate this.
Cool Gang Inc. has the following information –
 Cost of Goods Sold – $600,000
 The beginning inventory – $110,000
 The ending inventory – $130,000
Find out the inventory ratios.
The average inventory of Cool Gang Inc. would be = (The beginning inventory + the ending inventory)/2 = ($110,000 + $130,000)/2 = $240,000/2 = $120,000.
Using the inventory ratio, we get –
 Inventory ratio = Cost of Goods Sold / Average Inventories
 Or, Inventory ratio= $600,000 / $120,000 = 5.
By comparing the inventory turnover ratios of similar companies in the same industry, we would be able to conclude whether the inventory ratio of Cool Gang Inc. is higher or lower.
Recommended Courses
Colgate’s Inventory Turnover Calculation
In this Inventory Turnover example, we take a reallife example of Colgate. Below is the snapshot of Inventory Turnover Ratio Calculations. You may download this excel sheet from Ratio Analysis guide. Colgate’s inventory consists of three types of Inventory – Raw material and supplies, work in progress and finished goods.
Historically, Colgate’s inventory turnover has been in the range of 5x6x. If we observe closely, Colgate’s Inventory turnover ratio were a bit lower in the period of 20132015. This indicates that Colgate is taking a bit longer to process its inventory into finished goods.
Explanation of Inventory Turnover Formula
As you can see there are two significant components of this ratio.
The first component is costs of goods sold. If we look into the income statement of a company, we would find the cost of goods sold quite easily. All we need to do is to look at the fourth item on the income statement.
Here’s a snapshot –
Income Statement of TCL Co. at the end of the year 2017
Particulars  Amount (in $) 
Gross Sales  $500,000 
() Sales Returns  ($50,000) 
Net Sales  $450,000 
() Cost of Goods Sold  ($210,000) 
Gross Profit  $240,000 
The second component of the formula is average inventories.
To find out the average inventories, we need to use the simple average method.
We need to find out the beginning inventories and the ending inventories for the period and then all we need to do is to divide the sum by two.
 For example, if the beginning inventory of a firm is $40,000 and the ending inventory is $50,000, then to find out the average inventory, we need to add these two and divide the sum by two.
 Here’s the calculation = ($40,000 + $50,000)/2 = $45,000.
Use of Inventory Turnover Ratio Formula
Inventory turnover is a great indicator of how a company is handling its inventory. If an investor wants to check how well a company is managing its inventory, she would look at how higher or lower the inventory turnover ratio of the company is.
For example, let’s say that the inventory ratio of a company is very high. It means that the company has been managing its inventory quite well and there are lesser holding cost and fewer chances of obsolescence.
On the other hand, if the inventory ratio of a company is lower, the company is not being able to manage the inventory quite well. And there’s also a risk of obsolescence.
But how would you understand whether the ratio is higher or lower?
You would understand it by looking at the inventory ratio of similar companies in the same industry. If you take an average of the inventory turnover ratio, you would understand the base. On this base, you can measure whether the inventory ratio of a company is higher or lower.
Inventory Turnover Calculator
You can use the following Inventory Turnover Ratio Calculator.
Cost of Goods Sold  
Average Inventories  
Inventory Turnover Ratio Formula =  
Inventory Turnover Ratio Formula = 


Inventory Turnover Ratio Formula in Excel (with excel template)
Let us now do the same example above in Excel.
This is very simple. First, you need to find out the Average Inventories and then you need to provide the two inputs of Cost of Goods Sold and Average Inventories. You can easily calculate the Inventory ratio in the template provided.
You can download this Inventory Turnover Ratio template here – Inventory Turnover Ratio Excel Template
Recommended Articles
This has been a guide to Inventory Turnover Ratio Formula, practical examples, and Inventory Turnover calculator along with excel templates. You may also have a look at these articles below to learn more about Financial Analysis
Leave a Reply