LIFO Calculator for Inventory
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.
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.
What is LIFO (last-in, first-out)?
LIFO stands for last-in, first-out, and it's an accounting method for measuring the COGS (costs of goods sold) based on inventory prices. The particularity of the LIFO method is that it takes into account the price of the last acquired items whenever you sell stock.
Let's consider this example. The company acquired T-shirts as per the following scheme:
T-shirt buying price
The company receives a sell order of 10 T-shirts. What will be the related costs? If you use our LIFO calculator, you will see the result is 144 USD.
This is because we took the last seven items at 15 USD and added the three items we bought at 13 USD:
That is LIFO. Last-in the inventory, first-out when the sell occurs.
It is quite different from the FIFO method (first-in, first-out), where we would have taken the two t-shirts bought at 10 USD, then the other five t-shirts at 13 USD, and finally the last three ones at 15 USD. COGS, in this case, would be 130 USD. A percentage decrease of 9.7%.
Keep in mind the LIFO vs. FIFO difference, as we will explain it more in the following paragraphs.
How to use LIFO for costs of goods sold calculation
As mentioned above, companies have to define their cost of goods sold for determining a selling price that can keep their profit margins. Let's explain how they do it when using the LIFO method. We adopt the following notation:
= Number of units purchased 1st time.
= 1st units purchased price.
= Number of units purchased 2nd time.
= 2nd units purchased price.
= Number of units purchased last time.
= Last units purchased price.
Then the inventory value formula reads:
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.
The LIFO method assumes that it will take the last acquired items when the company sells its inventory. Assuming the company sells products:
= Number of units purchased the last time.
= Number of units purchased one time before the last one.
= Number of units purchased two times before the last one.
...and so on, until the number of sold items is equal to
COGS would be:
Following our example above:
Notice how the cost of goods sold could increase if the last prices of the items the company bought also increase. What happens during inflationary times, and by rising COGS, it would reduce not only the operating profits but also the tax payment. Visit the inflation calculator to learn more.
How to calculate ending inventory by LIFO
Continuing with out formulas above, we would not have the last items because we sold them accordingly to the LIFO method. Then, the ending inventory/remaining inventory would be:
In the T-shirt example we mentioned above, the initial inventory value was 190 USD. You can use our LIFO calculator or go through all the T-shirts we bought and multiply them by their respective price. Then after selling the last ten items, the inventory value is:
Thus, we end up with an inventory value of 46 USD.
How to use our LIFO method calculator
Here we are going to determine the cost of goods sold using the LIFO calculator, our revenue, and our profit margin:
- Add the number of items you bought and their respective prices. Our LIFO calculator will indicate the current amount of your existing inventory.
- In the next section, add the number of total units sold. Our tool will indicate the COGS.
- Finally, include the selling price. Our LIFO calculator online will indicate the total revenues and the profit margin.
Continuing with our example above, assume we sell the 10 items at a 16 USD each:
Note that we have income. Besides, the formula for the profit margin is:
How does the LIFO method affect taxable profits?
When you compare the cost of goods sold using the LIFO calculator, you see that COGS increases when the prices of acquired items rise. Such a situation will reduce the profits on which the company pays taxes. Consequently, LIFO can help lower taxable income.
Which one is better FIFO or LIFO?
LIFO is only allowed in the USA, whereas, in the world, companies use FIFO. In the USA, companies prefer to use LIFO because it can help them reduce their taxable income. Furthermore, when USA companies have operations outside their country of origin, they present a section where the overseas inventory registered by FIFO is modified to LIFO. You can also check FIFO and LIFO calculators at the Omni Calculator website to learn what happens in inflationary/deflationary environments.
How do I calculate ending inventory using LIFO?
To determine the ending inventory using LIFO follows these steps:
- Determine the existing inventory by multiplying each acquisition price per the amount bought.
- Define how many items you are going to sell.
- Subtract the items you sold from the existing inventory. Start removing the last ones.
- Multiply the remaining ones (which are the ones you bought first) per their respective prices. Then, you have the ending inventory amount using LIFO. You can also try our LIFO calculator online.
How do I calculate COGS using LIFO?
To calculate COGS using LIFO:
- Keep a record of each acquisition price per the amount bought.
- Define how many items you are going to sell. Our LIFO method calculator would bring a result here.
- Take the last items and their respective prices. Select only the ones you sold.
- Multiply their prices by their amount. There you have your COGS as per the LIFO method.
How does inflation affect FIFO ending inventory calculation?
If you use a LIFO calculator as an ending inventory calculator, you will see that you keep the cheapest inventory in your accounts with inflation (and rising prices through time). The most expensive items would go to the COGS calculation. In that sense, we will see a smaller ending inventory during inflation compared to a non-inflationary period.
Which financial ratios does LIFO ending inventory calculation affect?
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.
How does deflation affect LIFO ending inventory calculation?
Considering that deflation is the item's price decrease through time, you will see a smaller COGS with the LIFO method. Also, you will see a more significant remaining inventory value because the most expensive items were bought and kept at the very beginning.