This article will cover how to determine ending inventory by LIFO after selling in contrast to the FIFO method, which you can discover in Omni’s FIFO calculator. Also, we will see how to calculate its cost of goods sold using LIFO, and show how to use our LIFO calculator online to make more profits. The LIFO calculator for inventory and costs of goods sold (COGS) is an intelligent tool that can help you calculate your current inventory value and the amount you have to report as COGS by considering the LIFO method.

  1. Under this method, goods are combined into pools and all increases and decreases in a pool are measured in terms of total dollar value.
  2. Suppose you adopted LIFO two years ago and have determined your cost indexes to be 100 and 115 percent.
  3. In addition, there is the risk that the earnings of a company that is being liquidated can be artificially inflated by the use of LIFO accounting in previous years.
  4. Considering that deflation is the item’s price decrease through time, you will see a smaller COGS with the LIFO method.

In other words, you don’t have to worry about applying costs in LIFO sequence to the units you sell during the year. This approach is not commonly used to derive inventory valuations, for several reasons. First, a large number of calculations are required to determine the differences in pricing through the indicated periods.

You then apply the cost indexes to each year’s ending inventory to figure end-of-year inventory in base-year dollars — each year of increase creates a new LIFO layer. By reinflating and adding the annual constant-dollar changes to base-year ending inventory cost, you derive the cost of your current ending inventory. In the pooled LIFO method, you assign inventory items to pools based on physical similarity, and you carry the pooled items at average cost for the period. As long as you replenish the pool during the year, you will not create a LIFO liquidation. Under the dollar-value LIFO method, you create pools by year. Instead of grouping items by their physical characteristics, you simply track them by their dollar value, corrected for inflation.

Contrasting the Front & Back End of Calculations in the LIFOPro Software

Most companies that use LIFO are those that are forced to maintain a large amount of inventory at all times. By offsetting sales income with their highest purchase prices, they produce less taxable income on paper. In periods of deflation, LIFO creates lower costs and increases net income, which also increases taxable income. The front end of the LIFO calculation is the current year or cumulative index calculation (or inflation calculation).

Dollar-value LIFO uses this approach with all figures in dollar amounts, rather than in inventory units. It provides a different view of the balance sheet than other accounting methods such as first-in-first-out (FIFO). In an inflationary environment, it can more closely track the dollar value effect of cost of goods sold (COGS) and the resulting effect on net income than counting the inventory items in terms of units.

In Year 2, your physical inventory has a cost of $299,000, which you deflate to $260,000 by dividing it by the Year 2 cost index of 115 percent. The real-dollar increase in inventory is $260,000 minus $200,000, or $60,000. To calculate the Year 2 cost layer, multiply the Year 2 layer, $60,000, by the year’s cost index, 115 percent. Add this reinflated result, $69,000, to the base-year ending inventory of $200,000 to get your Year 2 ending dollar-value LIFO inventory of $269,000. Companies that sell the merchandise they buy or produce must account for the cost of goods sold, or COGS, to determine gross profits. You can calculate COGS by subtracting the value of ending inventory from the cost of goods available for sale, which is beginning inventory plus inventory purchases.

While learning LIFO and discussing its pros and cons, one issue was of LIFO’s incompatibility if entity is using FIFO for internal reporting purposes. This however, was solved with a workaround called LIFO reserve or LIFO Allowance. Another major issue with LIFO is delayering or better known as LIFO liquidation or erosion.

Also, under IRS regulations, a base year cost must be located for each new inventory item added to stock, which can require considerable research. Only if such information is impossible to locate can the current cost also be considered the base year cost. If LIFO affects COGS and makes it more significant during inflationary times, we will have a reduced net income margin. Besides, inventory turnover will be much higher as it will have higher COGS and smaller inventory. Also, all the current asset-related ratios will be affected because of the change in inventory value.

Under LIFO, each time you purchase or produce new inventory, you create a new layer of costs. LIFO liquidation occurs when you exhaust your most recently obtained inventory and must dip into older cost layers, thereby reducing your COGS and increasing your taxable income. The dollar-value LIFO method is a variation of standard LIFO in which you pool inventory costs by year. The government releases price indexes that you apply to dollar-value LIFO method layers to remove inflationary effects. If you manufacture your inventory, you use the Producer Price Index; merchandisers use the Consumer Price Index.

Related AccountingTools Courses

That is, the cost of the most recent products purchased or produced is the first to be expensed as cost of goods sold (COGS), while the cost of older products, which is often lower, will be reported as inventory. The companies that maintain a large number of products and expect significant changes in their product mix in future frequently use dollar-value LIFO technique. The use of traditional LIFO approaches is common among companies that have a few items and expect very little to no change in their product mix. Under this method, it is possible to use a single pool but a company can use any number of pools according to its requirement. The unnecessary employment of a large number of dollar-value LIFO pools  may, however, increase cost and also reduce the effectiveness of dollar-value LIFO approach.

How to use LIFO for costs of goods sold calculation

In times of deflation, the complete opposite of the above is true.

How to calculate ending inventory by LIFO

To solve delayering problem, we use traditional LIFO’s modified approach called Dollar-Value LIFO. Each widget has the same sales price, so revenue is the same. But the cost of the widgets is based on the inventory method selected. Last in, first out (LIFO) is only used in the United States where any of the three inventory-costing methods can be used under generally accepted accounting principles. The International Financial Reporting Standards (IFRS), which is used in most countries, forbids the use of the LIFO method. We call those two components the front & back end of a LIFO calculation.

Here, we are assuming the company has not sold any product yet. Please note how increasing/decreasing inventory prices through time can affect the inventory value. If you use our LIFO what is form 941 calculator, you will see the result is 144 USD. An eligible small business may elect to use the simplified dollar-value method of pricing inventories for purposes of the LIFO method.

In total, the cost of the widgets under the LIFO method is $1,200, or five at $200 and two at $100. Most companies that use LIFO inventory valuations need to maintain large inventories, such as retailers and auto dealerships. The method allows them to take advantage of lower taxable income and higher cash flow when their expenses are rising. Last in, first out (LIFO) is a method used to account for business inventory that records the most recently produced items in a series as the ones that are sold first.