WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 250+ Courses All In One Bundle
  • Login
Home » Investment Banking Tutorials » Financial Statement Analysis » Days in Inventory Formula

Days in Inventory Formula

Formula to Calculate Days in Inventory

Days in inventory tells you how many days it takes for a firm to convert its inventory into sales.

Let’s have a look at the formula given below.

Days in Inventory Formula = 365 / Inventory Turnover

Days in Inventory Formula

As you can see that we need to know the inventory turnover ratio before days in inventory calculation; here’s the formula of inventory turnover –

Inventory Turnover = Cost of Goods Sold / End Inventory

Now, the cost of goods sold can also be divided by the average inventory (that is the average of the beginning and the ending inventory) to find out the inventory turnover ratio.

Days in Inventory Example

Niti wants to know the inventory days of Company Him. Here are a few details she gathered –

  • The beginning and the ending inventories of the year are – $40,000 and $60,000, respectively.
  • The cost of goods sold is $300,000.
  • The year consists of 365 days.

Find out the Days in Inventory for Niti.

Here, first, we need to calculate the average inventory.

We know the beginning and the ending inventory of the year. We will use a simple average to find out the average inventory of the year.

  • The average inventory of the year = (The beginning inventory + The ending inventory) / 2
  • Or, Average inventory of the year = ($40,000 + $60,000) / 2 = $100,000 / 2 = $50,000.

Now, we will find out the inventory turnover ratio.

  • Inventory turnover ratio = Cost of Goods Sold / Average Inventory = $300,000 / $50,000 = 6 times.
  • Therefore, the inventory days would be = 365 / 6 = 61 days (approx.)

Explanation of Days in Inventory Formula

It is used to see how many days the firm takes to transform inventories into finished stocks.

Since a major part of “days in inventory formula” includes the inventory turnover ratio, we need to understand the inventory turnover ratio to comprehend the meaning inventory days formula.

Popular Course in this category
Sale
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
4.9 (1,067 ratings)
250+ Courses | 40+ Projects | 1000+ Hours | Full Lifetime Access | Certificate of Completion
View Course

The inventory turnover ratio helps us understand the efficiency of the company to handle the inventories. It shows how good the company is to reduce overspending on inventory and also how well a company can convert the inventory into finish stocks.

For example, if a firm’s inventory turnover ratio is 10, then it means that the firm turns inventory into finished stock 10 times in a year.

And here comes the value of inventory days formula.

If we consider that there are 365 days in a year, we can see the days it takes for the firm to transform inventories into finished stocks. All we need to do is to divide the number of days in a year by the inventory turnover ratio.

Extending the above example, we get = (365 days / 10 times) = 36.5 days in inventory to transform the inventory into finished stocks.

Uses

We can derive the formula for Days in Inventory by including the number of days of the year with the inventory turnover ratio.

If you ever want to know about the efficiency of inventory management of a firm, you should look at both – inventory turnover ratio and inventory days.

By trying to find out the inventory days, you would be able to calculate both of the above ratios.

By using the formula for days in inventory, you will get to know how much time a firm takes to manage and transform its inventory.

Days in Inventory Calculator

You can use the following Days in Inventory Calculator

365 Days
Inventory Turnover
Days in Inventory Formula =
 

Days in Inventory Formula =
365 Days
=
Inventory Turnover
365
= 0
0

Days in Inventory 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 inventory of the year. And then, you will find out the inventory turnover ratio.

You can easily find the days in inventory calculation in the template provided.

First, we need to calculate the average inventory.

Here We will use the simple average to find out the average inventory of the year.

Simple Average Formula

Average inventory of the year

Now, we will find out the inventory turnover ratio.

Below is the formula to calculate Inventory Turnover Ratio

inventory turnover ratio

Inventory Turnover Ratio in Excel

Now, we will find out the Days in Inventory for Niti by using the formula.

days inventory turnover ratio formula in excel

You can download these Days in Inventory Template here – Days in Inventory Excel Template.

Days in Inventory Formula Video

Recommended Articles:

This article has been a guide to Days in Inventory Formula, practical examples, and Days in Inventory calculator along with excel templates.

You may also have a look at these articles below to learn more about Financial Analysis –

  • Beneish M-Score
  • Formula for Days Working Capital
  • Techniques of Inventory Control
  • What is the Average Inventory Formula?
  • Day Formula in Excel
3 Shares
Share
Tweet
Share
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Login

Forgot Password?

WallStreetMojo

Free Ratio Analysis Course

Step by Step Guide to Calculating Financial Ratios in excel

New Year Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More