LIFO for Inventories Calculator
Calculate COGS and ending inventory value using the LIFO (Last-In, First-Out) method. Free inventory valuation tool with purchase layer breakdown and charts.
Purchase Layer 1
Purchase Layer 2
Purchase Layer 3 (Optional)
Sales
About This Calculator
The LIFO (Last-In, First-Out) Inventory Calculator helps businesses determine the cost of goods sold (COGS) and ending inventory value using the LIFO inventory valuation method. Under LIFO, the most recently purchased inventory items are assumed to be sold first, which can have significant tax implications during periods of rising prices.
This calculator supports up to three inventory purchase layers. For each layer, enter the quantity purchased and the unit price. Then specify the total units sold and selling price per unit. The calculator applies the LIFO method starting from the most recent purchase layer and working backwards, calculating COGS, ending inventory, revenue, profit, and profit margin.
For example, if you purchase 2 units at $10, 5 units at $13, and 7 units at $15, then sell 10 units at $16 each, the LIFO method produces COGS of $144 (7 units × $15 + 3 units × $13), ending inventory of $46, revenue of $160, and a profit of $16 with a 10% profit margin.
Regional Notes
United States: LIFO is permitted under US GAAP and is widely used for tax reporting under the Internal Revenue Code. The IRS requires companies using LIFO for tax purposes to also use it for financial reporting (the LIFO conformity rule). Companies must file Form 970 with their first LIFO election.
International (IFRS): LIFO is prohibited under IFRS. Companies reporting under IFRS must use FIFO or weighted average cost methods. However, many multinational US-based companies maintain LIFO for their US inventory and convert to FIFO for international reporting.
India: As per the Companies Act 2013 and Ind AS (Indian Accounting Standards), LIFO is not permitted. Indian companies use FIFO or weighted average methods for inventory valuation, following Ind AS 2 (Inventories).
Frequently Asked Questions
What is LIFO (Last-In, First-Out)?
LIFO (Last-In, First-Out) is an inventory valuation method where the most recently purchased items are assumed to be sold first. During periods of rising prices, LIFO results in higher COGS and lower taxable income, which can reduce tax liability. It is commonly used in the United States for tax reporting purposes.
How do you calculate COGS using the LIFO method?
To calculate COGS using LIFO, start with the most recent inventory purchase layer and work backwards. For each layer, multiply the number of units sold from that layer by its unit price. Continue until all sold units are accounted for. For example, if you have three purchase layers (2 units @ $10, 5 units @ $13, 7 units @ $15) and sell 10 units, COGS = (7 units x $15) + (3 units x $13) = $144.
How do you calculate ending inventory under LIFO?
Ending inventory under LIFO is the total cost of units that remain after removing the most recently purchased items (which are assumed sold first). It equals total inventory cost minus COGS. Using the example above, total inventory cost is $190, COGS is $144, so ending inventory = $190 - $144 = $46.
What is the difference between LIFO and FIFO?
LIFO (Last-In, First-Out) assumes the newest inventory items are sold first, while FIFO (First-In, First-Out) assumes the oldest items are sold first. During inflation, LIFO produces higher COGS and lower ending inventory compared to FIFO, resulting in lower taxable income. FIFO is used internationally under IFRS, while LIFO is primarily allowed under US GAAP.
Is LIFO allowed under IFRS or GAAP?
LIFO is allowed under US GAAP (Generally Accepted Accounting Principles) and is widely used by companies in the United States for tax purposes. However, LIFO is prohibited under IFRS (International Financial Reporting Standards), which is used in most other countries worldwide. Companies using IFRS must use FIFO or weighted average costing methods.
How does LIFO affect financial ratios?
Under LIFO during inflation, COGS is higher, reducing gross profit and net income margins. Inventory turnover ratio increases because COGS is higher while inventory value is lower, making it appear that inventory is turning over faster. Current ratio and working capital are lower due to reduced inventory valuation on the balance sheet.
What is the LIFO reserve?
The LIFO reserve is the difference between inventory reported under LIFO and what it would be under FIFO. US companies that use LIFO for tax purposes must disclose this reserve in their financial statements. It allows investors to compare companies using different inventory methods by adjusting LIFO-based financials to a FIFO equivalent.
When does LIFO result in lower tax payments?
LIFO results in lower taxable income during periods of rising prices (inflation) because it matches the most recent higher-cost inventory against current revenue. This creates a tax deferral benefit. However, during deflation, LIFO would produce lower COGS and higher taxable income. This is known as the LIFO tax benefit or LIFO tax shield.