EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 250+ Courses All in One Bundle
  • Login
Home Finance Finance Resources Finance Formula Days in Inventory Formula
Secondary Sidebar
Finance Blog
  • Finance Formula
    • Skewness Formula
    • Fixed Asset Turnover Ratio Formula
    • Forecasting Formula
    • EBITDA Margin Formula
    • Accounting Ratio Formula
    • Deferred Annuity Formula
    • Capital Investment Formula
    • Ratio Analysis Formula
    • Loss Ratio Formula
    • Benefit-Cost Ratio Formula
    • Probability Distribution Formula
    • Cash Conversion Cycle Formula
    • Accrued Income
    • DCF Excel summary
    • Price to Earning Ratio Formula
    • Current Yield of Bond Formula
    • Earnings Per Share Formula
    • Manufacturing Overhead Formula
    • FCFF Formula
    • Predetermined Overhead Rate Formula
    • Times Interest Earned Ratio Formula
    • Bank Efficiency Ratio Formula
    • Capital Expenditure Formula
    • Expense Ratio Formula
    • WACC Formula
    • Activity Ratio Formula
    • Standard Error Formula
    • Forward Rate Formula
    • Gearing Formula
    • Prime Cost Formula
    • Productivity Formula
    • t-Test Formula
    • Risk Free Rate Formula
    • Tax Shield Formula
    • Sortino Ratio
    • Reserve Ratio Formula
    • Bond Formula
    • Annualized Rate of Return Formula
    • Conditional Probability Formula
    • Financing Formula
    • Future Value of an Annuity Formula
    • For Profit vs Non Profit
    • Deadweight Loss Formula
    • Inflation Formula
    • Amortized Loan Formula
    • Horizontal Analysis Formula
    • Marginal Utility Formula
    • Kurtosis Formula
    • Macaulay Duration Formula
    • Multiplier Formula
    • Modified Duration Formula
    • Operating Leverage Formula
    • Payout Ratio Formula
    • Statistics Formula
    • Sampling Error Formula
    • Trend Analysis Formula
    • Taylor Rule Formula
    • Put Call Parity Formula
    • Annual Return Formula
    • Discount Rate Formula
    • Cash Flow Formula
    • Dilution Formula
    • Attrition Formula
    • Operating Expense Formula
    • Interpolation Formula
    • Annuity Due Formula
    • Bond Yield Formula
    • Turnover Ratio Formula
    • Efficiency Formula
    • Revenue Per Employee
    • Regression Line Formula
    • Yield to Maturity
    • Pearson Correlation Coefficient Formula
    • Accounting Formula
    • Fiscal Deficit Formula
    • Tax Multiplier Formula
    • Efficiency Ratio Formula
    • Demand Elasticity Formula
    • Gross Margin Formula
    • Elasticity Formula
    • Marginal Benefit Formula
    • Depreciation Formula
    • Cost-Benefit Analysis Formula
    • Percentage Change Formula
    • Levered Beta Formula
    • Shares Outstanding Formula
    • Capital Gain Formula
    • Convexity Formula
    • Gross Income Formula
    • Net Exports Formula
    • Producer Surplus Formula
    • Accounting Rate of Return Formula
    • Net Cash Flow Formula
    • Labor Force Participation Rate Formula
    • Moving Average Formula
    • Net Worth Formula
    • Accounting Profit Formula
    • Disposable Income Formula
    • Discount Formula
    • Average Variable Cost Formula
    • Total Variable Cost Formula
    • Product Cost Formula
    • Marginal Product Formula
    • Break-Even Sales Formula
    • Return on Sales Formula
    • Cost of Goods Manufactured Formula
    • Average Fixed Cost Formula
    • Stock Turnover Ratio Formula
    • Operating Ratio Formula
    • Equity Ratio Formula
    • Net Present Value Formula
    • Aggregate Demand Formula
    • Volatility Formula
    • Marginal Product of Labor Formula
    • Z Test Statistics Formula
    • Standard Cost Formula
    • Velocity of Money Formula
    • Invested Capital Formula
    • Unlevered Beta Formula
    • Bank Reconciliation Formula
    • Portfolio Return Formula
    • Central Tendency Formula
    • Accumulated Depreciation Formula
    • Intrinsic Value Formula
    • Decile Formula
    • Vector Cross Product Formula
    • Effective Annual Rate Formula
    • CAGR Formula
    • Mode Formula
    • Arithmetic Mean Formula
    • Real GDP Formula
    • Gini Coefficient Formula
    • Expected Value Formula
    • Price Elasticity of Supply Formula
    • Net Operating Income Formula
    • Profit Percentage Formula
    • GDP Per Capita Formula
    • Altman Z Score
    • Quartile Deviation Formula
    • Return on Capital Employed Formula
    • Consumer Price Index Formula
    • Economic Profit Formula
    • Market Share Formula
    • Real Interest Rate Formula
    • Income Elasticity of Demand Formula
    • Income From Operations Formula
    • Indexation Formula
    • Sales Formula
    • Money Multiplier Formula
    • GDP Deflator Formula
    • Residual Income Formula
    • Effective Interest Rate Formula
    • Coupon Bond Formula
    • Current Account Formula
    • Total Cost Formula
    • Total Expense Ratio Formula
    • Net Sales Formula
    • Percentage Decrease Formula
    • Uncertainty Formula
    • Nominal GDP Formula
    • Effect Size Formula
    • Delta Formula
    • Cost of Sales Formula
    • Fixed Cost Formula
    • Unemployment Rate Formula
    • Present Value of Annuity Formula
    • Compounding Formula
    • Geometric Distribution Formula
    • National Income Formula
    • Accounts Receivables Turnover Formula
    • Integer Formula
    • Ending Inventory Formula
    • Owner's Equity Formula
    • Capacity Utilization Rate Formula
    • Interest Formula
    • Nominal Interest Rate Formula
    • Risk Premium Formula
    • Interest Coverage Ratio Formula
    • Gross Profit Margin Formula
    • Diluted EPS Formula
    • Return On Average Equity Formula
    • Return on Average Assets Formula
    • Working Capital Formula
    • Revenue Per Employee Ratio Formula
    • Capital Employed Formula
    • Rule of 72 Formula
    • Inventory Turnover Ratio Formula
    • Preferred Dividend Formula
    • Retention Ratio Formula
    • Present Value Factor Formula
    • Equity Multiplier Formula
    • Continuous Compounding Formula
    • Return on Assets (ROA) Formula
    • Portfolio Variance Formula
    • Weighted Average Formula
    • Net Working Capital Formula
    • Tax Equivalent Yield Formula
    • Poisson Distribution Formula
    • Current Ratio Formula
    • Debt Ratio Formula
    • Quick Ratio Formula
    • Payback Period Formula
    • Marginal Cost Formula
    • Debt to Income Ratio Formula
    • Book Value Per Share Formula
    • Asset Turnover Ratio Formula
    • Perpetuity Formula
    • Bid-Ask Spread Formula
    • Price to Book Value Formula
    • Capital Gains Yield Formula
    • Net Profit Margin Formula
    • DuPont Formula
    • Bond Pricing Formula
    • Binomial Distribution Formula
    • Sustainable Growth Rate Formula
    • Average Collection Period Formula
    • Net Income Formula
    • CAPM Formula
    • Cost of Goods Sold Formula
    • Economic Order Quantity (EOQ) Formula
    • Amortization Formula
    • Enterprise Value Formula
    • Beta Formula
    • Cost of Equity Formula
    • Rate of Return Formula
    • Revenue Formula
    • Markup Price Formula
    • Cash Flow from Operations Formula
    • Simple Interest Rate Formula
    • Consumer Surplus Formula
    • Asset to Sales Ratio Formula
    • Debt Service Coverage Ratio Formula
    • Capitalization Rate Formula
    • Cost of Debt Formula
    • Straight Line Depreciation Formula
    • Variable Costing Formula
    • Return on Invested Capital Formula
    • Profitability Index Formula
    • Expected Return Formula
    • Cost of Capital Formula
    • Price Index Formula
    • Average Total Cost Formula
    • Discount Factor Formula
    • Price Elasticity Formula
    • Profitability Ratios Formula
    • Financial Leverage Formula
    • Contribution Margin Formula
    • Time Value of Money Formula
    • Balance Sheet Formula
    • Opportunity Cost Formula
    • Current Assets Formula
    • Operating Cycle Formula
    • Operating Margin Formula
    • Bond Equivalent Yield Formula
    • Marginal Revenue Formula
    • Sales Revenue Formula
    • Net Debt Formula
    • Times Interest Earned Formula
    • Gordon Growth Model Formula
    • Required Rate of Return Formula
    • Break Even Analysis Formula
    • Inventory Formula
    • Marginal Propensity to Consume Formula
    • Debt to Asset Ratio Formula
    • Solvency Ratio Formula
    • Interest Expense Formula
    • Leverage Ratio Formula
    • Dividend Payout Ratio Formula
    • Operating Profit Margin Formula
    • PEG Ratio Formula
    • Net Interest Margin Formula
    • Return on Equity (ROE) Formula
    • Overhead Ratio Formula
    • Future Value Formula
    • Days in Inventory Formula
    • Market Capitalization Formula
    • Sharpe Ratio Formula
    • Cash Ratio Formula
    • Retained Earnings Formula
    • Average Rate of Return Formula
    • Current Liabilities Formula
    • Equity Value Formula
    • Relative Risk Reduction Formula
    • Capital Adequacy Ratio Formula
    • Debtor Days Formula
    • DPMO Formula
    • Average Formula
    • Exponential Growth Formula
    • Net Realizable Value Formula
    • Range Formula
    • Shareholders' Equity Formula
    • Sinking Fund Formula
    • Doubling Time Formula
    • Salvage Value Formula
    • Coupon Rate Formula
    • Simple Interest Formula
    • Correlation Formula
    • R - Squared Formula
    • MTBF Formula
    • Change in Net Working Capital Formula
    • Midrange Formula
    • Normal Distribution Formula
    • Mean Formula
    • Population Mean Formula
    • Median Formula
    • Central Limit Theorem Formula
    • Free Cash Flow Formula
    • Stockholder's Equity Formula
    • Acid-Test Ratio Formula
    • Percentile Rank Formula
    • Purchasing Power Parity Formula
    • Harmonic Mean Formula
    • Relative Standard Deviation Formula
    • T Distribution Formula
    • Normalization Formula
    • Operating Income Formula
    • Markup Percentage Formula
    • Relative Change Formula
    • Maturity Value Formula
    • Salary Formula
    • High Low Method
    • Income Statement Formula
    • Market to Book Ratio Formula
    • Dividends Per Share Formula
    • Daily Compound Interest Formula
    • Working Capital Turnover Ratio Formula
    • Weighted Mean Formula
    • Compounded Annual Growth Rate Formula
    • Regression Formula
    • Margin of Error Formula
    • Hypergeometric Distribution Formula
    • Standard Normal Distribution Formula
    • NOPAT Formula
    • Effective Tax Rate Formula
    • Degree of Operating Leverage Formula
    • Outliers Formula
    • Information Ratio Formula
    • Percent Error Formula
    • Hypothesis Testing Formula
    • Activity Based Costing Formula
    • Coverage Ratio Formula
    • Market Risk Premium Formula
    • Degree of Financial Leverage Formula
    • Absorption Costing Formula
    • Future Value of Annuity Due Formula
    • Internal Growth Rate Formula
    • F-Test Formula
    • Covariance Formula
    • Population Variance Formula
    • Coefficient of Determination Formula
    • Adjusted R Squared Formula
    • Compound Interest Formula
    • Gross Profit Formula
    • Accounting Equation Formula
    • Sample Size Formula
    • Sample Standard Deviation Formula
    • Quartile Formula
    • Variance Analysis Formula
    • Correlation Coefficient Formula
    • Z Score Formula
    • Variance Formula
    • Present Value Formula
    • Coefficient of Variation Formula
    • Net Asset Value Formula
    • Profit Margin Formula
    • Holding Period Return Formula
    • Capital Asset Pricing Model Formula
    • Present Value of Annuity Due Formula
    • Depreciation Expenses Formula
    • Annuity Formula
    • Taxable Income Formula
    • Profit Formula
    • Monthly Compound Interest Formula
    • Equity Formula
    • Return on Total Assets Formula
    • Alpha Formula
    • Debt to Equity Ratio Formula
    • EBITDA Formula
    • Accrued Interest Formula
    • Dividend Formula
    • Common Stock Formula
    • Mortgage Formula
    • Growth Rate Formula
    • Absolute Value Formula
  • Accounting fundamentals (700+)
  • Asset Management Tutorial (200+)
  • Banking (44+)
  • Corporate Finance Basics (373+)
  • Credit Research Fundamentals (6+)
  • Economics (88+)
  • Financial Modeling in Excel (17+)
  • Investment Banking Basics (140+)
  • Investment Banking Careers (29+)
  • Trading for dummies (69+)
  • valuation basics (27+)
  • Insurance Resources (14+)
  • Top Finance Books (7+)
Finance Blog Courses
  • Investment Banking Course
  • Investment Banking Online Course
  • Financial Modeling Certification

Days in Inventory Formula

By Madhuri ThakurMadhuri Thakur

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

Days in inventory is basically used to determine the efficiency of a particular company in converting inventory into sales. It is calculated by dividing the number of days in the period by inventory turnover ratio. The numerator of the days in the formula is always 365 which is the total number of days in a year.

Inventory Days

To understand the days in inventory formula one should look at the inventory turnover formula used in the denominator.

Start Your Free Investment Banking Course

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

Inventory turnover

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

Closing inventory or closing stock is found on the balance sheet and the cost of goods sold is calculated after deducting the material costing from the revenue in the income statement.

All in One Financial Analyst Bundle(250+ Courses, 40+ Projects)
Financial ModelingInvestment BankingUS GAAPCFA-Level 1 & 2
Equity ResearchM & A ModelingPrivate Equity ModelingForex Trading
Price
View Courses
250+ Online Courses | 40+ Projects | 1000+ Hours | Verifiable Certificates | Lifetime Access
4.9 (86,580 ratings)

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 INR 100000. Find Days Sales in inventory.

Days Sales in inventory is Calculated as:

  • 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 rate of Sales for the following days. So a peer analysis can be done where the number of inventory days can be compared with its competitors in the same industry. This will help to analyze the product of the company and 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 to stand 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 is Calculated as:

  • 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 is Calculated as:

  • 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 for reduced the closing stock its inventory and there might be a downgrade of the order book for the current financial year and that 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 sold to stand 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 is Calculated as:

  • 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 is Calculated as:

  • 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

Days in Inventory formula indicates this is one of the important formula which gives creditors and investors to measure the value liquidity and the cash flow of the particular company. As in the world of finance, we all know that old inventories value lesser than the new one.

So Days in Inventory formula helps to indicates the stock position and its intrinsic value and is very helpful for a manufacturing business. The days sales in inventory ratio show the company that the present status of its inventory and how long they are going to last?

We all know inventory is very liquid in nature or in other words it can be turned into cash whenever required depending upon the type of stock and the demand for it.

Quick inventory period indicates a hard working capital in most of the cases.

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

Significance and Use of Days in Inventory Formula

  • The days sales in inventory show the how quickly the inventory in a particular business is churning or in other words how praise the inventory is?
  • Days in Inventory formula also indicates the liquidity of the inventory and the position of working capital as.
  • The day’s sales in the inventory are one of the major components which decide the inventory management of a particular company. Inventory has a maintenance cost and as well as it has to keep under certain circumstances depending upon the product of the particular business. So, in other words, excess inventory is not good for the financial health of a particular business.
  • There is insurance cost attached to every inventory. So the maintenance cost adds if an inventory stays for long. This additional expense is not good for profitability and there is a chance of inventory obsolesces.
  • Higher Inventory with low inventory days indicates the business is growing and the management is able to increase its inventory management.
  • Lower Inventory balance with extended inventory days is an indication 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 important tool for the investors as well as it determines the business efficiency and if the investors should hold the stock of that particular business or not. Depending on the Inventory days of the companies in the same group the investors might give 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 Formula in the template provided.

Days Sales in inventory is Calculated as:

Days in Inventory Example 1

Days in inventory for Tata Steel is Calculated as:

For FY17:

Calculation of Tata Steel for FY17

For FY18:

Calculation of Tata Steel for FY18

Days in inventory for Nocil limited is Calculated as:

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 you with Days in Inventory Calculator with 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
Popular Course in this category
All in One Financial Analyst Bundle- 250+ Courses, 40+ Projects
  250+ Online Courses |  1000+ Hours |  Verifiable Certificates |  Lifetime Access
4.9
Price

View Course

Related Courses

Investment Banking Course (123 Courses, 25+ Projects)4.9
Investment Banking Course (123 Courses, 25+ Projects)4.8
Financial Modeling Course (7 Courses, 14 Projects)4.7
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • 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

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

EDUCBA
Free Financial Modeling Course

3 Statement Model Creation, Revenue Forecasting, Supporting Schedule Building, & others

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

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

EDUCBA Login

Forgot Password?

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

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

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

EDUCBA

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

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

Let’s Get Started

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

EDUCBA

Download Days in Inventory Formula Excel Template

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