• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
Finance Train

Finance Train

High Quality tutorials for finance, risk, data science

  • Home
  • Data Science
  • CFA® Exam
  • PRM Exam
  • Tutorials
  • Careers
  • Products
  • Login

Inventory Turnover and Days of Inventory on Hand (DOH)

CFA® Exam, CFA® Exam Level 1

This lesson is part 2 of 9 in the course Financial Ratios

Inventory turnover is an important activity ratio, and 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.

Previous Lesson

‹ Common Ratios in Financial Analysis

Next Lesson

Receivables Turnover and Days of Sales Outstanding (DSO) ›

Join Our Facebook Group - Finance, Risk and Data Science

Posts You May Like

How to Improve your Financial Health

CFA® Exam Overview and Guidelines (Updated for 2021)

Changing Themes (Look and Feel) in ggplot2 in R

Coordinates in ggplot2 in R

Facets for ggplot2 Charts in R (Faceting Layer)

Reader Interactions

Leave a Reply Cancel reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

In this Course

  • 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)

Latest Tutorials

    • Data Visualization with R
    • Derivatives with R
    • Machine Learning in Finance Using Python
    • Credit Risk Modelling in R
    • Quantitative Trading Strategies in R
    • Financial Time Series Analysis in R
    • VaR Mapping
    • Option Valuation
    • Financial Reporting Standards
    • Fraud
Facebook Group

Membership

Unlock full access to Finance Train and see the entire library of member-only content and resources.

Subscribe

Footer

Recent Posts

  • How to Improve your Financial Health
  • CFA® Exam Overview and Guidelines (Updated for 2021)
  • Changing Themes (Look and Feel) in ggplot2 in R
  • Coordinates in ggplot2 in R
  • Facets for ggplot2 Charts in R (Faceting Layer)

Products

  • Level I Authority for CFA® Exam
  • CFA Level I Practice Questions
  • CFA Level I Mock Exam
  • Level II Question Bank for CFA® Exam
  • PRM Exam 1 Practice Question Bank
  • All Products

Quick Links

  • Privacy Policy
  • Contact Us

CFA Institute does not endorse, promote or warrant the accuracy or quality of Finance Train. CFA® and Chartered Financial Analyst® are registered trademarks owned by CFA Institute.

Copyright © 2021 Finance Train. All rights reserved.

  • About Us
  • Privacy Policy
  • Contact Us