- Common Ratios in Financial Analysis
- Inventory Turnover and Days of Inventory on Hand (DOH)
- Receivables Turnover and Days of Sales Outstanding (DSO)
- Payables Turnover and Number of Days of Payables
- Working Capital Turnover Ratio
- Fixed Asset and Total Asset Turnover Ratio
- Activity Ratios – Video Summary
- Liquidity Ratios (Current Ratio, Quick Ratio, and Others)
- Cash Conversion Cycle (CCC)
- Solvency Ratios
- Profitability Ratios
- DuPont Analysis
- Valuation Ratios
- Financial Ratios: Uses and Limitations

# Inventory Turnover and Days of Inventory on Hand (DOH)

Inventory turnover is an important activity ratio.

Activity ratios measure how effectively a business uses its resources, such as receivables collection, inventory, etc. They are also called efficiency ratios.

Inventory turnover ratio provides a measure of how effectively a business is using its inventory.

These ratios measure how many times the company's inventory has been turned over or sold during a specified period.

For example, an inventory turnover ratio of 10 means that the inventory has been turned over 10 times in the specified period, usually a year. The Days of Inventory at Hand (DOH) specifies how many days worth of inventory the company had in hand. For example, DOH of 36 days means that the company had 36 days of inventory at hand during the period.

### Formulas

$Inventory\ Turnover = \frac{Cost\ of\ Goods\ Sold\ (COGS)}{Average\ Inventory}$

Cost of Goods Sold value is taken from the Income Statement and Inventory is taken from the Balance Sheet. Since the balance sheet tells the financial condition of a company at the end of the period, we take Average Inventory for the year in our calculation.

$DOH = \frac{365\ or\ 360}{Inventory\ Turnover}$

365 is the most commonly used day count convention however some analysts may prefer to use 360 days.

### Example

Assume that the cost of goods sold for a company for the previous year was $1,000,000 and the beginning and ending inventory for the year were 120,000 and 80,000.

$Inventory\ Turnover = \frac{1,000,000}{\frac{(120,000+80,000)}{2}} = 10$

This means that the company turns over its entire inventory 10 times during the year.

$DOH = \frac{365}{10}=36.5$

This means that on average the company had 36.5 days of inventory at hand.

Note that if the analyst is particularly interested in how much inventory was at hand at the end of the financial year, then he will use the closing inventory for the above calculation.

### Analysis

As you can see the Inventory Turnover and Days of Inventory at hand are inversly related. If inventory turnover is high, the DOH will be low and vice verse.

The ratio is compared with others in the industry to measure the performance.

A high inventory turnover ratio generally means that the company is managing its inventory effectively. It can also mean that the company has shortage of inventory which could actually impact the revenues. To identify which is the correct situation, the analyst will interpret this ratio in combination with revenue growth. If revenue growth is slow, and the inventory turnover is high, it indicates a shortage of inventory.

A low inventory turnover ratio, compared to its peers, could indicate that the company is not able to sell its inventory.

#### Related Downloads

#### Related Quizzes

## Data Science in Finance: 9-Book Bundle

Master R and Python for financial data science with our comprehensive bundle of 9 ebooks.

### What's Included:

- Getting Started with R
- R Programming for Data Science
- Data Visualization with R
- Financial Time Series Analysis with R
- Quantitative Trading Strategies with R
- Derivatives with R
- Credit Risk Modelling With R
- Python for Data Science
- Machine Learning in Finance using Python

Each book includes PDFs, explanations, instructions, data files, and R code for all examples.

Get the Bundle for $39 (Regular $57)## Free Guides - Getting Started with R and Python

Enter your name and email address below and we will email you the guides for R programming and Python.