background
Welcome to Wall Street Prep! Use code at checkout for 15% off.
Wharton & Wall Street Prep Certificates
Now Enrolling for September 2024 for September 2024
:
Private EquityReal Estate Investing
Buy-Side InvestingFP&A
Wharton & Wall Street Prep Certificates:
Enrollment for September 2024 is Open
Wall Street Prep

Inventory Turnover Ratio

Step-by-Step Guide to Understanding the Inventory Turnover Ratio

Last Updated February 7, 2024

Learn Online Now

Inventory Turnover Ratio

How to Calculate Inventory Turnover Ratio

The inventory turnover ratio is a financial metric that portrays the efficiency at which the inventory of a company is converted into finished goods and sold to customers.

Simply put, the inventory turnover ratio measures the efficiency at which a company can convert its inventory purchases into revenue.

The inventory turnover ratio is calculated by dividing the cost of goods sold (COGS) by the average inventory balance for the matching period.

Thus, the inventory turnover rate determines how long it takes for a company to sell its entire inventory, creating the need to place more orders.

The steps for calculating the inventory turnover ratio are the following:

  1. Identify the Beginning and Ending Inventory Balances → The beginning of period and end of period inventory balances are recorded on the company’s balance sheet.
  2. Compute Average Inventory → The average inventory is the beginning and ending inventory balance divided by two.
  3. Calculate Inventory Turnover Ratio → The inventory turnover ratio is determined by dividing the company’s cost of goods sold (COGS) in the current period by the average inventory.

Inventory Turnover Ratio Formula

The formula used to calculate a company’s inventory turnover ratio is as follows.

Inventory Turnover Ratio = Cost of Goods Sold (COGS) ÷ Average Inventory

While COGS is pulled from the income statement, the inventory balance comes from the balance sheet.

In effect, a mismatch is created between the numerator and denominator in terms of the time covered.

  • Income Statement → The financial performance, such as revenue, costs, and profitability, of a company across two periods.
  • Balance Sheet → A “snapshot” at a specific point in time of a company’s assets, liabilities, and equity.

The inventory turnover ratio is closely tied to the days inventory outstanding (DIO) metric, which measures the number of days needed by a company to sell off its inventory in its entirety.

The relationship between the two working capital metrics – the inventory turnover rate and days inventory outstanding (DIO) – is as follows:

Days Inventory Outstanding (DIO) = 365 Days ÷ Inventory Turnover

Unique to days inventory outstanding (DIO), most companies strive to minimize the DIO, as that means inventory sits in their possession for a shorter period.

What is a Good Inventory Turnover Ratio?

Since the inventory turnover ratio represents the number of times that a company clears out its entire inventory balance across a defined period, higher turnover ratios are preferred.

  • Higher Inventory Turnover Ratio → The company likely experiences strong demand in the market for its products, as confirmed by the high turnover and the frequent need for inventory replenishment.
  • Lower Inventory Turnover Ratio → There might be poor demand in the market and excess inventory accumulating (i.e. overstocking). The company’s inventory, if left unsold, might eventually need to be written down to reflect the true (lower) value on the balance sheet.

Inventory Turnover Ratio Calculator

We’ll now move on to a modeling exercise, which you can access by filling out the form below.

dl

Get the Excel Template!

By submitting this form, you consent to receive email from Wall Street Prep and agree to our terms of use and privacy policy.

Submitting...

Inventory Turnover Ratio Calculation Example

Suppose a retail company has the following income statement and balance sheet data.

  • Cost of Goods Sold (COGS) = $100,000
  • Beginning Inventory = $60,000
  • Ending Inventory = $40,000

For 2021, the company’s inventory turnover ratio comes out to 2.0x, which indicates that the company has sold off its entire average inventory approximately 2.0 times across the period.

  • Inventory Turnover Ratio = $100,000 ÷ Average ($60,000, $40,000) = 2.0x

Inventory Turnover Ratio Calculator

How to Interpret Inventory Turnover by Industry?

The analysis of a company’s inventory turnover ratio to its industry benchmark, derived from its peer group of comparable companies can provide insights into its efficiency at inventory management.

For companies with low inventory turnover ratios, the duration between when the inventory is purchased, produced/manufactured into a finished good, and then sold is more prolonged (i.e. requires more time).

That said, low turnover ratios suggest lackluster demand from customers and the build-up of excess inventory.

For example, retailers are typically known for exhibiting high turnover ratios – in particular, “fast-fashion” retailers like Zara are highly regarded for their ability to research trends and clear out their inventory quickly.

However, if a company exhibits an abnormally high inventory turnover ratio, it could also be a sign that management is ordering inadequate inventory, rather than managing inventory effectively.

In such cases, the amount of pent-up demand (i.e. back orders, delayed deliveries, and speed) must be evaluated to understand the reality of the circumstances, as well as to see if there is an adverse impact on revenue.

Rather than being a positive sign, high turnover could mean that the company is missing potential sales due to insufficient inventory.

Some examples of practical diligence questions to ask (or answer) when assessing a company’s inventory management are the following:

  • Q. Is the company pricing its products at a competitive rate where there is sufficient customer demand?
  • Q. Does the revenue generated from the sale of proceeds offset the expenses to be profitable?
  • Q. Have recent purchases referenced historical customer demand patterns?
  • Q. Which specific products have been selling out quickly and causing lost revenue (and vice versa)?
  • Q. Are there any specific products that have lost a substantial amount of consumer demand as of late?
Step-by-Step Online Course

Everything You Need To Master Financial Modeling

Enroll in The Premium Package: Learn Financial Statement Modeling, DCF, M&A, LBO and Comps. The same training program used at top investment banks.

Enroll Today
Comments
2 Comments
most voted
newest oldest
Inline Feedbacks
View all comments
calcuing
February 22, 2022 7:05 am

Income ratio is a metric used to measure the ability of a technology to recover the investment costs through savings achieved from customer utility bill cost reduction. The ratio divides the “savings” by the “investment”; an SIR score above 1 indicates that a household can recover the investment.

Brad Barlow
February 22, 2022 3:45 pm
Reply to  calcuing

Thank you for sharing this. Can you clarify how it is related to the topics covered in the article?

Learn Financial Modeling Online

Everything you need to master financial and valuation modeling: 3-Statement Modeling, DCF, Comps, M&A and LBO.

Learn More

The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.