Inventory turnover

Last updated

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.

Contents

Formulas

The formula for inventory turnover:

or

or

Inventory Turnover = Cost of Material − Change in inventories (of 1/2 and 1/1 goods)/Inventories[ clarification needed ]

The most basic formula for average inventory:

or just

Multiple data points, for example, the average of the monthly averages, will provide a much more representative turn figure.


The average days to sell the inventory is calculated as follows: [1]

Application in Business

A low turnover rate may point to overstocking, [2] obsolescence, or deficiencies in the product line or marketing effort. However, in some instances a low rate may be appropriate, such as where higher inventory levels occur in anticipation of rapidly rising prices or expected market shortages. Another insight provided by the inventory turnover ratio is that if inventory is turning over slowly, then the warehousing cost attributable to each unit will be higher. [3]

Conversely a high turnover rate may indicate inadequate inventory levels, which may lead to a loss in business as the inventory is too low. This often can result in stock shortages.

Some compilers of industry data (e.g., Dun & Bradstreet) use sales as the numerator instead of cost of sales. Cost of sales yields a more realistic turnover ratio, but it is often necessary to use sales for purposes of comparative analysis. Cost of sales is considered to be more realistic because of the difference in which sales and the cost of sales are recorded. Sales are generally recorded at market value, i.e. the value at which the marketplace paid for the good or service provided by the firm. In the event that the firm had an exceptional year and the market paid a premium for the firm's goods and services then the numerator may be an inaccurate measure. However, cost of sales is recorded by the firm at what the firm actually paid for the materials available for sale. Additionally, firms may reduce prices to generate sales in an effort to cycle inventory. In this article, the terms "cost of sales" and "cost of goods sold" are synonymous.

An item whose inventory is sold (turns over) once a year has higher holding cost than one that turns over twice, or three times, or more in that time. Stock turnover also indicates the briskness of the business. The purpose of increasing inventory turns is to reduce inventory for three reasons.

Note

Some computer programs measure the stock turns of an item using the actual number sold.

The important issue is that any organization should be consistent in the formula that it uses.

See also

Related Research Articles

In economics, specifically general equilibrium theory, a perfect market, also known as an atomistic market, is defined by several idealizing conditions, collectively called perfect competition, or atomistic competition. In theoretical models where conditions of perfect competition hold, it has been demonstrated that a market will reach an equilibrium in which the quantity supplied for every product or service, including labor, equals the quantity demanded at the current price. This equilibrium would be a Pareto optimum.

<span class="mw-page-title-main">Cost accounting</span> Procedures to optimize practices in cost efficient ways

Cost accounting is defined by the Institute of Management Accountants as "a systematic set of procedures for recording and reporting measurements of the cost of manufacturing goods and performing services in the aggregate and in detail. It includes methods for recognizing, allocating, aggregating and reporting such costs and comparing them with standard costs". Often considered a subset of managerial accounting, its end goal is to advise the management on how to optimize business practices and processes based on cost efficiency and capability. Cost accounting provides the detailed cost information that management needs to control current operations and plan for the future.

<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">Profit maximization</span> Process to determine the highest profits for a firm

In economics, profit maximization is the short run or long run process by which a firm may determine the price, input and output levels that will lead to the highest possible total profit. In neoclassical economics, which is currently the mainstream approach to microeconomics, the firm is assumed to be a "rational agent" which wants to maximize its total profit, which is the difference between its total revenue and its total cost.

<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">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.

Tobin's q, is the ratio between a physical asset's market value and its replacement value. It was first introduced by Nicholas Kaldor in 1966 in his paper: Marginal Productivity and the Macro-Economic Theories of Distribution: Comment on Samuelson and Modigliani. It was popularised a decade later by James Tobin, who in 1970, described its two quantities as:

One, the numerator, is the market valuation: the going price in the market for exchanging existing assets. The other, the denominator, is the replacement or reproduction cost: the price in the market for newly produced commodities. We believe that this ratio has considerable macroeconomic significance and usefulness, as the nexus between financial markets and markets for goods and services.

<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.

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.

<span class="mw-page-title-main">DuPont analysis</span> Expression which breaks ROE (return on equity) into three parts

DuPont analysis is a tool used in financial analysis, where return on equity (ROE) is separated into its component parts.

<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.

Price–sales ratio, P/S ratio, or PSR, is a valuation metric for stocks. It is calculated by dividing the company's market capitalization by the revenue in the most recent year; or, equivalently, divide the per-share price by the per-share revenue.

The newsvendormodel is a mathematical model in operations management and applied economics used to determine optimal inventory levels. It is (typically) characterized by fixed prices and uncertain demand for a perishable product. If the inventory level is , each unit of demand above is lost in potential sales. This model is also known as the newsvendor problem or newsboy problem by analogy with the situation faced by a newspaper vendor who must decide how many copies of the day's paper to stock in the face of uncertain demand and knowing that unsold copies will be worthless at the end of the day.

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 is being analyzed, but a rule of thumb is that a GMROII of typical retailer is above 3.0.

In finance, asset turnover (ATO), total asset turnover, or asset turns is a financial ratio that measures the efficiency of a company's use of its assets in generating sales revenue or sales income to the company. Asset turnover is considered to be a profitability ratio, which is a group of financial ratios that measure how efficiently a company uses assets. Asset turnover can be furthered subdivided into fixed asset turnover, which measures a company's use of its fixed assets to generate revenue, and working capital turnover, which measures a company's use of its working capital to generate revenue. Total asset turnover ratios can be used to calculate return on equity (ROE) figures as part of DuPont analysis. As a financial and activity ratio, and as part of DuPont analysis, asset turnover is a part of company fundamental analysis.

<span class="mw-page-title-main">Cost–volume–profit analysis</span> Cost accounting model

Cost–volume–profit (CVP), in managerial economics, is a form of cost accounting. It is a simplified model, useful for elementary instruction and for short-run decisions.

An inventory valuation allows a company to provide a monetary value for items that make up their inventory. Inventories are usually the largest current asset of a business, and proper measurement of them is necessary to assure accurate financial statements. If inventory is not properly measured, expenses and revenues cannot be properly matched and a company could make poor business decisions.

Days in inventory 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 are divided by sales per day

<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 publicly listed, the market price of the shares is used in certain financial ratios.

References

  1. 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.
  2. Commercial Loan Analysis: principles and techniques for credit analysts and lenders By Kenneth R. Pirok ISBN   1-55738-716-8
  3. "Financial Analysis Reports". Bruin Financial Management. Retrieved July 28, 2019.

Further reading