Days in inventory

Last updated

Days in inventory (also known as "Inventory Days of Supply", "Days Inventory Outstanding" or the "Inventory Period" [1] ) is an efficiency ratio that measures the average number of days the company holds its inventory before selling it. The ratio measures the number of days funds are tied up in inventory. Inventory levels (measured at cost) are divided by sales per day (also measured at cost rather than selling price.)

The formula for days in inventory is:

where DII is days in inventory and COGS is cost of goods sold. The average inventory is the average of inventory levels at the beginning and end of an accounting period, and COGS/day is calculated by dividing the total cost of goods sold per year by the number of days in the accounting period, generally 365 days. [2]

This is equivalent to the 'average days to sell the inventory' which is calculated as: [3]

See also

Related Research Articles

<span class="mw-page-title-main">FIFO and LIFO accounting</span> Methods used in managing inventory

FIFO and LIFO accounting are methods used in managing inventory and financial matters involving the amount of money a company has to have tied up within inventory of produced goods, raw materials, parts, components, or feedstocks. They are used to manage assumptions of costs related to inventory, stock repurchases, and various other accounting purposes. The following equation is useful when determining inventory costing methods:

<span class="mw-page-title-main">Inventory</span> Goods held for resale

Inventory or stock refers to the goods and materials that a business holds for the ultimate goal of resale, production or utilisation.

<span class="mw-page-title-main">Cost of goods sold</span> Carrying value of goods sold during a particular period

Cost of goods sold (COGS) is the carrying value of goods sold during a particular period.

<span class="mw-page-title-main">Cash conversion cycle</span> Length of time it takes a company to convert resource inputs to cash flows

In management accounting, the Cash conversion cycle (CCC) measures how long a firm will be deprived of cash if it increases its investment in inventory in order to expand customer sales. It is thus a measure of the liquidity risk entailed by growth. However, shortening the CCC creates its own risks: while a firm could even achieve a negative CCC by collecting from customers before paying suppliers, a policy of strict collections and lax payments is not always sustainable.

<span class="mw-page-title-main">Income statement</span> Type of financial statement

An income statement or profit and loss account is one of the financial statements of a company and shows the company's revenues and expenses during a particular period.

<span class="mw-page-title-main">Break-even (economics)</span> Equality of costs and revenues

The break-even point (BEP) in economics, business—and specifically cost accounting—is the point at which total cost and total revenue are equal, i.e. "even". In layman's terms, after all costs are paid for there is neither profit nor loss. In economics specifically, the term has a broader definition; even if there is no net loss or gain, and one has "broken even", opportunity costs have been covered and capital has received the risk-adjusted, expected return. The break-even analysis was developed by Karl Bücher and Johann Friedrich Schär.

<span class="mw-page-title-main">Stock and flow</span> Types of quantities in financial fields

Economics, business, accounting, and related fields often distinguish between quantities that are stocks and those that are flows. These differ in their units of measurement. A stock is measured at one specific time, and represents a quantity existing at that point in time, which may have accumulated in the past. A flow variable is measured over an interval of time. Therefore, a flow would be measured per unit of time. Flow is roughly analogous to rate or speed in this sense.

<span class="mw-page-title-main">Cash and cash equivalents</span> Highly liquid, short-term assets

Cash and cash equivalents (CCE) are the most liquid current assets found on a business's balance sheet. Cash equivalents are short-term commitments "with temporarily idle cash and easily convertible into a known cash amount". An investment normally counts as a cash equivalent when it has a short maturity period of 90 days or less, and can be included in the cash and cash equivalents balance from the date of acquisition when it carries an insignificant risk of changes in the asset value. If it has a maturity of more than 90 days, it is not considered a cash equivalent. Equity investments mostly are excluded from cash equivalents, unless they are essentially cash equivalents.

<span class="mw-page-title-main">Net income</span> Measure of the profitability of a business venture

In business and accounting, net income is an entity's income minus cost of goods sold, expenses, depreciation and amortization, interest, and taxes for an accounting period.

In accountancy, days sales outstanding is a calculation used by a company to estimate the size of their outstanding accounts receivable. It measures this size not in units of currency, but in average sales days.

Profit margin is a financial ratio that measures the percentage of profit earned by a company in relation to its revenue. Expressed as a percentage, it indicates how much profit the company makes for every dollar of revenue generated. Profit margin is important because this percentage provides a comprehensive picture of the operating efficiency of a business or an industry. All margin changes provide useful indicators for assessing growth potential, investment viability and the financial stability of a company relative to its competitors. Maintaining a healthy profit margin will help to ensure the financial success of a business, which will improve its ability to obtain loans.

The return on equity (ROE) is a measure of the profitability of a business in relation to its equity; where:

<span class="mw-page-title-main">Gross margin</span> Gross profit as a percentage

Gross margin is the difference between revenue and cost of goods sold (COGS), divided by revenue. Gross margin is expressed as a percentage. Generally, it is calculated as the selling price of an item, less the cost of goods sold, then divided by the same selling price. "Gross margin" is often used interchangeably with "gross profit", however, the terms are different: "gross profit" is technically an absolute monetary amount, and "gross margin" is technically a percentage or ratio.

In business, Gross Margin Return on Inventory Investment is a ratio which expresses a seller's return on every unit of currency spent on inventory. It is one way to determine how profitable the seller's inventory is, and describes the relationship between the profit earned from total sales, and the amount invested in the inventory sold. Generally for a seller, the higher the GMROII the better. Since inventory is a very widely ranging factor in a seller's investment in working capital, it is important for the seller to know how much he might expect to gain from it. The GMROII answers the question "for each unit of average inventory held at cost, how many units of currency of gross profit I generated in one year?" GMROII is traditionally calculated by using one year's gross profit against the average of 12 or 13 units of inventory at cost. GMROII may vary depending on which segment we are analyzing, but a rule of thumb is that a GMROII of typical retailer is above 3.0.

<span class="mw-page-title-main">Inventory turnover</span> Measure of the number of times inventory is sold or used in a time period

In accounting, the inventory turnover is a measure of the number of times inventory is sold or used in a time period such as a year. It is calculated to see if a business has an excessive inventory in comparison to its sales level. The equation for inventory turnover equals the cost of goods sold divided by the average inventory. Inventory turnover is also known as inventory turns, merchandise turnover, stockturn, stock turns, turns, and stock turnover.

The debtors days ratio measures how quickly cash is being collected from debtors. The longer it takes for a company to collect, the greater the number of debtors days. Debtor days can also be referred to as debtor collection period. Another common ratio is the creditors days ratio.

Receivable turnover ratio or debtor's turnover ratio is an accounting measure used to measure how effective a company is in extending credit as well as collecting debts. The receivables turnover ratio is an activity ratio, measuring how efficiently a firm uses its assets.

Days payable outstanding (DPO) is an efficiency ratio that measures the average number of days a company takes to pay its suppliers.

<span class="mw-page-title-main">Financial ratio</span> Numerical value to determine the financial condition of a company

A financial ratio or accounting ratio states the relative magnitude of two selected numerical values taken from an enterprise's financial statements. Often used in accounting, there are many standard ratios used to try to evaluate the overall financial condition of a corporation or other organization. Financial ratios may be used by managers within a firm, by current and potential shareholders (owners) of a firm, and by a firm's creditors. Financial analysts use financial ratios to compare the strengths and weaknesses in various companies. If shares in a company are traded in a financial market, the market price of the shares is used in certain financial ratios.

The UVA method is an accounting and decision-making tool, based on calculating the cost of sales. Unlike management accounting, which calculates product margins, the UVA method calculates the result generated by each sale. The UVA method relies on a very detailed analysis of all costs related to products, customers, orders, and deliveries. It introduces the notion of a single measure unit, which applies to all the operations in the company. The method relies on an equivalent-based approach.

References

  1. Ross, S., Westerfield, Jordan, B.: Essentials of Corporate Finance, Eighth Edition, page 60, McGraw-Hill, 2014.
  2. Berman, K., Knight, J., Case, J.: Financial Intelligence for Entrepreneurs, page 149. Harvard Business Press, 2008.
  3. Weygandt, J. J., Kieso, D. E., & Kell, W. G. (1996). Accounting Principles (4th ed.). New York, Chichester, Brisbane, Toronto, Singapore: John Wiley & Sons, Inc. p. 802.