How Do You Analyze Inventory on the Balance Sheet?

In accounting, inventory represents a company's raw materials, work in progress, and finished products. Financial professionals use a wide variety of quantitative and qualitative techniques to understand inventory in their investing analyses.

Quantitative techniques involve performing ratio analysis of the inventory by calculating ratios using financial statements. The qualitative analysis includes inspecting notes to financial statements to check inventory valuation methodology and its consistency, researching inventory valuation methods used by competitors, and comparing them to the method used by the company.

In finance, ratio analysis is done by calculating ratios using historical inventory balances. The purpose of this analysis is to detect a company's problems with inventory management, such as difficulty selling inventory, inventory build-up, and obsolescence. In this article, we'll review the most common inventory ratios: days inventory outstanding, inventory turnover, and inventory to sales ratio.

Days Inventory Outstanding

The days inventory outstanding ratio is calculated as inventory divided by the cost of goods sold (COGS) and then multiplied by 365. This ratio measures the average number of days a company holds inventory before selling it. This ratio widely varies across industries and is most helpful when compared to a company's peers.

If the ratio increases over time and is much higher compared to its peers, this can be a red flag that the company is struggling to clear its inventory. Holding unsold inventory is costly because money is tied up in an idle resource with no income until the inventory is sold. It is costly to store inventory, especially when it requires special handling. Also, certain inventory gets obsolete and may require selling at a significant discount just to get rid of it.

Inventory Turnover

Inventory turnover is calculated as the ratio of COGS to average inventory. Sometimes revenues are substituted for COGS, and average inventory balance is used. Inventory turnover is especially important for companies that carry physical inventory and indicates how many times inventory balance is sold during the year.

Similarly to the days inventory outstanding ratio, inventory turnover should be compared with a company's peers due to differences across industries. A low and declining turnover is a negative factor; products tend to deteriorate and lose their value over time.

Inventory to Sales Ratio

Inventory to sales ratio is calculated as the ratio of inventory to revenue. Some analysts use an average inventory balance. An increase in this ratio can indicate a company's investment in inventory is growing quicker than its sales, or sales are decreasing.

On the other hand, if this ratio decreases, it can mean that a company's investment in inventory is decreasing in relation to revenues, or revenues are growing. The inventory to sales ratio provides a big picture on the balance sheet and can indicate whether a more thorough analysis of inventory is needed.

Manipulating Earnings

In addition to performing ratio analysis, you might find that reading the notes to a company's financial statements is a helpful extra step in inventory analysis. The U.S. generally accepted accounting principles (GAAP) allow different valuation methods for inventory (such as last in, first out (LIFO); first in, first out (FIFO); and average cost). A company's management can attempt to use this discretion to manipulate its earnings. By reviewing a company's financial statement notes, you might be able to glean some telltale signs of this manipulation.

For example, look for any changes in accounting policies related to inventory. Frequent and unjustified changes to inventory valuation methods can indicate earnings management. Also, comparing a company's inventory valuation methodology with that of its peers can provide a common-sense check on whether the company's management is being aggressive with inventory valuation. Finally, look for any inventory charges, as they can pinpoint inventory obsolescence problems.