Are you, for example, running out of stock? Your company is apparently making good inventory investments without overstocking.īut a high inventory turnover could also indicate too few purchases. For example, a relatively high inventory turnover compared to the industry or your past performance is a good indicator of healthy sales and efficient purchasing. Armed with an industry average and your company’s benchmark, you could better gauge your inventory performance. Review your financial data and calculate an inventory turnover ratio for each month, quarter, and year for at least the past couple of years. Next, benchmark your company’s inventory turnover. A quick Google search, for example, shows that grocery stores typically have an inventory turnover of 40. If you sell building supplies, tools, and items for do-it-yourself projects, calculating inventory turnover for companies such as Home Depot and Lowe’s could provide context.Īlso, you could find industry inventory turnover estimates online. For that, you need context.įirst, estimate the average inventory turnover ratio for your industry. Knowing your company’s inventory turnover ratio won’t necessarily help you understand how the business is performing. This calculation, which is called “Days’ Sales of Inventory” or “Days’ Inventory,” can estimate how long it takes to get a return on investment for inventory purchases. In this case, we would estimate that The Home Depot turns its inventory about once every 73 days. Notice this method produces a different inventory turnover ratio. Let’s continue with The Home Depot example, using $14.5 billion in average inventory and approximately $72.7 billion for the cost of goods sold. This typically provides a more accurate view of inventory turnover because it excludes any markup. A second method is to divide the cost of goods sold by the average inventory for the time frame in view. This method is generally a little optimistic since it includes the company’s profit when it takes total sales as its numerator.ĬOGS and average inventory. Using this method, we would estimate that The Home Depot turns its inventory about once every 48 days. If we wanted to know home many days it takes The Home Depot to turn its inventory once, we could divide the number of days in the year by the inventory turnover ratio we just calculated. Home Depot turns over its inventory about 7.6 times each year. Using this method we could calculate Home Depot’s inventory turnover ratio as 7.6. We can calculate inventory turnover for a single public company (such as The Home Depot) and estimate the average turnover for an entire industry. Sales ÷ Ending Inventoryįor example, for the fiscal year ended January 31, 2020, The Home Depot reported total revenue of $110.2 billion, a cost of revenue (roughly the cost of goods sold) of $72.7 billion, and an inventory balance of $14.5 billion (which I will use as a stand-in for both ending inventory and average inventory), according to Yahoo! Finance. Many investors use a company’s sales and its ending inventory to calculate its inventory turnover ratio. The method you choose depends on which provides a better view of your company’s inventory and sales performance. The calculations produce different results. There are at least a couple of ways to calculate an inventory turnover ratio: (i) total sales divided by ending inventory or (ii) cost of goods sold divided by average inventory. Thus, inventory turnover - and the related inventory turnover ratio - is a powerful key performance indicator. The company with 10 inventory turns should experience better cash flow and more sales. But one company turns its inventory 10 times each year and the other only five times. Both companies hold about $1 million in inventory on average. Imagine two online retailers selling products for home gardeners. How quickly a business sells its inventory is typically a strong indicator of efficiency, cash flow, and general well-being.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |