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
- 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.
Colgate’s Inventory Turnover Calculation
In this Inventory Turnover example, we take a real-life 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 5x-6x. If we observe closely, Colgate’s Inventory turnover ratio were a bit lower in the period of 2013-2015. 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 $)|
|(-) Sales Returns||($50,000)|
|(-) Cost of Goods Sold||($210,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.
|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
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