EDUCBA

EDUCBA

MENUMENU
  • Explore
    • Lifetime Membership
    • All in One Bundles
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Login
Home Finance Finance Resources Finance Formula Days in Inventory Formula

Days in Inventory Formula

Madhuri Thakur
Article byMadhuri Thakur

Updated November 23, 2023

Days-in-Inventory-formula

Days in Inventory Formula (Table of Contents)
  • Days in Inventory Formula
  • Days in Inventory Calculator
  • Days in Inventory Formula in Excel (With Excel Template)

Days in Inventory Formula

Companies use days in inventory to determine their efficiency in converting inventory into sales. It is calculated by dividing the number of days in the period by the inventory turnover ratio. The numerator of the days in the Formula is always 365, the total number of days in a year.

Inventory Days

Start Your Free Investment Banking Course

Download Corporate Valuation, Investment Banking, Accounting, CFA Calculator & others

One should look at the inventory turnover formula used in the denominator to understand the days in the inventory formula.

Inventory turnover

In other words, shorter inventory outstanding indicates the company has the potential to convert the inventory into cash within a short time.

The balance sheet contains the closing inventory or closing stock, while the income statement calculates the cost of goods sold by subtracting the material cost from the revenue.

Thus dividing 365 by the inventory turnover ratio, we can get the Formula of days in inventory.

Days in inventory formula

Examples of Days in Inventory Formula

Let’s take an example to find out the Days in Inventory for a company: –

You can download this Days in Inventory Formula Excel Template here – Days in Inventory Formula Excel Template

Days in Inventory Formula – Example #1

X Ltd. has a closing Inventory in its Balance Sheet at INR 20000, and its Cost of Goods Sold stands at INR 100000. Find Days Sales in inventory.

Days Sales in inventory are Calculated as follows:

  • Days in Inventory =(Closing Stock /Cost of Goods Sold) × 365
  • Days Sales in inventory = (INR 20000/ 100000) * 365
  • Days Sales in inventory = 0.2 * 365
  • Days Sales in inventory= 73 days

This means the existing Inventory of X Ltd will last for the next 73 days, depending on the same sales rate for the following days. Businesses can conduct peer analysis to compare their inventory days with competitors in the same industry. This will help to analyze the product of the company as well as the condition of the business.

Days in Inventory Formula – Example #2

Tata Steel Limited has Closing Inventories for FY18 and FY17 of INR 28,331.04 Cr and INR 24,803.82 Cr, respectively. The company’s Cost of Goods sold stands at INR 41,205.43 Cr and INR 32,418.09 Cr, respectively, for FY18 and FY17. Find which financial year has better Inventory Days.

Days Sales in inventory are Calculated as follows:

  • Days in Inventory =(Closing Stock /Cost of Goods Sold) × 365
  • Days in Inventory for FY17 = 24,803.82/ 32,418.09 * 365
  • Days in Inventory for FY17 = 0.7651 * 365
  • Days in Inventory for FY17 = 279.26 days

Days Sales in inventory are Calculated as follows:

  • Days in Inventory =(Closing Stock /Cost of Goods Sold) × 365
  • Days in Inventory for FY18 = 28,331.04 / 41,205.43 * 365
  • Days in Inventory for FY18 = 0.6875 * 365
  • Days in Inventory for FY18 = 250.96 days.

Thus, we get an assumption of the business conditions that the churning of inventory to cash has reduced from 279.26 Days to 250.96 days. The company has reduced the closing stock of its inventory, and there might be a downgrade of the order book for the current financial year, which is why the company is holding lower inventory.

Days in Inventory Formula – Example #3

Nocil Limited has Closing Inventories for FY18 and FY17 of INR 155.27 Cr and INR 114.58 Cr, respectively. The company’s Cost of Goods was sold at INR 444.19 Cr and INR 330.03 Cr, respectively, for FY18 and FY17. Find which financial year has better Inventory Days.

Days Sales in inventory are Calculated as follows:

  • Days in Inventory =(Closing Stock /Cost of Goods Sold) × 365
  • Days in Inventory for FY18 = 155.27/ 444.19 * 365
  • Days in Inventory for FY18 = 0.3495 * 365
  • Days in Inventory for FY18 = 127.58 days

Days Sales in inventory are Calculated as follows:

  • Days in Inventory =(Closing Stock /Cost of Goods Sold) × 365
  • Days in Inventory for FY17 = 114.58/330.03 * 365
  • Days in Inventory for FY17 = 0.3471 * 365
  • Days in Inventory for FY17 = 126.72 days

Thus, from the above calculations, it has been found that the Business scenario is more or less in the same state. The rising inventory level suggests that there has been an increase in demand for the products, but the efficiency of the business has been at the same level.

Explanation

The days in Inventory formula indicates this is one of the vital formulas that gives creditors and investors the ability to measure the value liquidity and the cash flow of the particular company. In finance, we all recognize that we value old inventories less than new ones.

So Days in Inventory formula helps indicate the stock position and its intrinsic value and is very helpful for a manufacturing business. The day’s sales in inventory ratio show the company the present status of its inventory and how long it will last.

We all understand that inventory has high liquidity, which means it can be readily converted into cash when needed, based on the type of stock and its demand.

The quick inventory period indicates a hard-working capital in most cases.

The Formula of days sales inventory is calculated by dividing the closing inventory by the cost of goods sold and multiplying it by 365. Thus management of any company would want to churn its stock as fast as possible to reduce other related expenses and to improve cash flow.

Significance and Use of Days in Inventory Formula

  • The metric “days sales in inventory” showcases how quickly a specific business turns over its inventory or, in other words, how efficiently it utilizes the inventory.
  • The days in the Inventory formula also indicate the liquidity of the inventory and the position of working capital.
  • The day’s sales in the inventory are one of the significant components that decide a particular company’s inventory management. Maintaining inventory incurs costs and requires adherence to specific circumstances based on the business’s product. So, in other words, excess inventory is not suitable for the financial health of a particular business.
  • There is an insurance cost attached to every inventory. So, the maintenance cost increases if an inventory stays long. This additional expense is unsuitable for profitability, and there is a chance of inventory obsolescence.
  • Higher inventory with low inventory days indicates the business is growing, and the management can increase its inventory management.
  • A lower Inventory balance with extended inventory days indicates that the management is facing challenges in selling the products, and the sales team has to be more efficient in the coming days.
  • It’s an essential tool for the investors and determines the business efficiency and whether the investors should hold the stock of that particular business. Depending on the Inventory days of the companies in the same group, the investors might give them a call।

Days in Inventory Formula Calculator

You can use the following Days in Inventory Calculator

Closing Stock
Cost of Goods Sold
Days in Inventory Formula =
 

Days in Inventory Formula =
Closing Stock
X365
Cost of Goods Sold
0
X365= 0
0

Days in Inventory Formula in Excel (With Excel Template)

Here, we will do the same example of the Days in Inventory formula in Excel. It is very easy and simple. You need to provide the two inputs, i.e., Closing Stock and Cost of Goods Sold

You can easily calculate the Days in Inventory using the Formula in the template provided.

Days Sales in inventory are Calculated as follows:

Days in Inventory Example 1

Tata Steel calculates days in inventory using the following Formula:

For FY17:

Calculation of Tata Steel for FY17

For FY18:

Calculation of Tata Steel for FY18

Nocil Limited calculates days in inventory using the following Formula:

For FY17:

Calculation of Nocil limited for FY17

For FY18:

Calculation of Nocil limited for FY18

Recommended Articles

This has been a guide to a Days in Inventory formula. Here, we discuss its uses along with practical examples. We also provide the Days in Inventory Calculator with a downloadable Excel template. You may also look at the following articles to learn more –

  1. Formula for Return on Average Assets
  2. Calculator of Weighted Average Formula
  3. Return On Average Equity Formula Excel Template
  4. Calculator for Inventory Turnover Ratio
ADVERTISEMENT
All in One Excel VBA Bundle
500+ Hours of HD Videos
15 Learning Paths
120+ Courses
Verifiable Certificate of Completion
Lifetime Access
ADVERTISEMENT
Financial Analyst Masters Training Program
2000+ Hours of HD Videos
43 Learning Paths
550+ Courses
Verifiable Certificate of Completion
Lifetime Access
ADVERTISEMENT
All in One Data Science Bundle
2000+ Hour of HD Videos
80 Learning Paths
400+ Courses
Verifiable Certificate of Completion
Lifetime Access
ADVERTISEMENT
All in One Software Development Bundle
5000+ Hours of HD Videos
149 Learning Paths
1050+ Courses
Verifiable Certificate of Completion
Lifetime Access
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Investment Banking Jobs Offer
  • Finance Formula
  • All Tutorials
Certification Courses
  • All Courses
  • Financial Analyst All in One Bundle
  • Investment Banking Training
  • Financial Modeling Course
  • Equity Research Course
  • Private Equity Training Course
  • Business Valuation Course
  • Mergers and Acquisitions Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

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

EDUCBA

Download Days in Inventory Formula Excel Template

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Investment Banking Course

Corporate Valuation, Investment Banking, Accounting, CFA Calculator & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

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

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

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

डाउनलोड Days in Inventory Formula Excel Template

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

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

🚀 Extended Cyber Monday Price Drop! All in One Universal Bundle (3700+ Courses) @ 🎁 90% OFF - Ends in ENROLL NOW