LIFO vs FIFO vs Weighted Average: How to Choose an Inventory Valuation Method and Calculate COGS

The three major inventory valuation methods produce different COGS and ending inventory numbers even when applied to the same physical inventory. FIFO (First In, First Out) assumes the oldest inventory is sold first, leaving the newest (typically more expensive) inventory on the balance sheet. LIFO (Last In, First Out) assumes the newest inventory is sold first, leaving the oldest (typically cheaper) inventory on the balance sheet. Weighted average calculates a single average cost per unit and applies it to both COGS and ending inventory. During a period of RISING prices (which is the typical long-term environment): FIFO produces the LOWEST COGS, HIGHEST gross profit, and HIGHEST ending inventory value. LIFO produces the HIGHEST COGS, LOWEST gross profit, and LOWEST ending inventory value. Weighted average produces results in between the two. The same physical inventory and the same transactions can produce dramatically different income depending on which method you choose — sometimes by 20-40% in gross profit. During FALLING prices, the effects reverse: FIFO produces higher COGS and lower ending inventory, while LIFO produces lower COGS and higher ending inventory. The tax implication is the reason LIFO exists at all: under US tax law, companies can use LIFO for tax purposes to minimize taxable income during inflation (higher COGS = lower profit = lower taxes). BUT there is a catch called the LIFO conformity rule — if you use LIFO for taxes, you MUST also use LIFO for financial reporting. This creates the interesting situation where companies deliberately report LOWER earnings to shareholders so they can pay LOWER taxes to the government. International Financial Reporting Standards (IFRS) do NOT allow LIFO because of concerns about earnings manipulation. US GAAP still allows it. This is one of the biggest differences between the two accounting frameworks. Snap a photo of any inventory valuation problem and AccountingIQ calculates COGS and ending inventory under all three methods simultaneously, letting you compare the results and understand why each method produces different numbers.

Let us calculate COGS and ending inventory under all three methods using the same dataset. Widgetworks Inc had the following inventory activity in March: Beginning inventory (March 1): 100 units @ $10 = $1,000 Purchase (March 10): 200 units @ $12 = $2,400 Purchase (March 20): 150 units @ $15 = $2,250 Total units available: 450 units Total cost available: $5,650 Sales during March: 300 units sold Ending inventory (March 31): 150 units Note how prices increased from $10 to $15 over the month — a rising-price environment. **FIFO calculation:** The first 100 units come from beginning inventory at $10 = $1,000. The next 200 units come from the March 10 purchase at $12 = $2,400. Total FIFO COGS = $1,000 + $2,400 = $3,400. The remaining 150 units (all from the March 20 purchase at $15) are ending inventory = 150 × $15 = $2,250. FIFO COGS = $3,400. FIFO ending inventory = $2,250. **LIFO calculation:** The first 150 units sold come from the March 20 purchase at $15 = $2,250. The next 150 units come from the March 10 purchase at $12 = $1,800. Total LIFO COGS = $2,250 + $1,800 = $4,050. The remaining 150 units are 50 from the March 10 purchase at $12 ($600) and 100 from beginning inventory at $10 ($1,000). LIFO ending inventory = $600 + $1,000 = $1,600. LIFO COGS = $4,050. LIFO ending inventory = $1,600. **Weighted average calculation:** Average cost per unit = $5,650 / 450 units = $12.56 per unit. Weighted average COGS = 300 units × $12.56 = $3,767. Weighted average ending inventory = 150 units × $12.56 = $1,884. **Comparison:** | Method | COGS | Ending Inventory | Gross Profit (if sales = $6,000) | |--------|------|------------------|----------------------------------| | FIFO | $3,400 | $2,250 | $2,600 | | LIFO | $4,050 | $1,600 | $1,950 | | Weighted Avg | $3,767 | $1,884 | $2,233 | Same inventory, same sales, same transactions — but gross profit varies from $1,950 (LIFO) to $2,600 (FIFO), a $650 difference or 33% swing. The method choice is material. Notice the consistency check: for all three methods, COGS + ending inventory = total cost available ($5,650). If your numbers do not sum to this, you made a calculation error. AccountingIQ runs all three calculations automatically when you snap a photo of an inventory valuation problem — and it runs the consistency check so you can verify the answer before submitting.

The examples above used the PERIODIC inventory system, where all calculations happen at the end of the period. Under the PERPETUAL system, inventory is recalculated after every transaction. For FIFO and weighted average (also called moving average under perpetual), the results are similar under both systems. For LIFO, the results can DIFFER significantly between periodic and perpetual. The reason: under perpetual LIFO, each sale is matched against the inventory on hand at the moment of sale. Under periodic LIFO, each sale is matched against the inventory layers built up over the entire period. When purchases and sales are interleaved, the two systems produce different answers. Worked example showing the difference: Beginning inventory 100 @ $10. Purchase 1 (day 5): 100 @ $12. Sale (day 10): 150 units. Purchase 2 (day 15): 100 @ $15. Sale (day 20): 50 units. **Perpetual LIFO:** Sale on day 10: 150 units sold. LIFO draws from the most recent purchase first. Take all 100 from the day 5 purchase at $12 ($1,200), plus 50 from beginning inventory at $10 ($500). Day 10 COGS = $1,700. Sale on day 20: 50 units sold. LIFO draws from the most recent purchase first. Take 50 from the day 15 purchase at $15 = $750. Day 20 COGS = $750. Total perpetual LIFO COGS = $1,700 + $750 = $2,450. **Periodic LIFO:** Total sales for the period: 200 units. LIFO draws from the most recent purchases first, working backward through the entire period. Take all 100 from the day 15 purchase at $15 ($1,500), plus all 100 from the day 5 purchase at $12 ($1,200). Periodic LIFO COGS = $2,700. **Difference**: $2,700 periodic − $2,450 perpetual = $250. Different calculation methods of the same system produce different COGS. This is a classic exam trap that catches students. The rule: the periodic system is simpler to calculate and is used in most textbook examples. The perpetual system is more common in real-world companies that use modern inventory systems (barcode scanning, point-of-sale tracking). When a problem says "LIFO" without specifying, assume periodic unless the context clearly indicates perpetual (mentions of "perpetual inventory records" or "inventory updated after each sale"). Weighted average has a similar distinction. Under periodic, you calculate ONE average at the end of the period. Under perpetual, you calculate a NEW average after every purchase (but NOT after sales). This is called the "moving average" method. The difference between periodic weighted average and moving average can be significant. AccountingIQ identifies whether the problem describes a periodic or perpetual system and applies the correct calculation method. It also flags when the two systems would produce different answers so you understand the implications.

The choice of inventory method has significant tax implications because taxable income flows directly from reported gross profit, which depends on COGS. In a rising-price environment, LIFO produces higher COGS and lower taxable income — which is exactly why it exists. The LIFO conformity rule (US tax code) says that a company using LIFO for tax purposes MUST ALSO use LIFO for financial reporting to shareholders. You cannot report higher earnings to Wall Street while claiming lower earnings to the IRS. This unique rule forces companies to accept lower reported earnings in exchange for lower tax payments. The tax savings during inflation can be very large for inventory-heavy companies (retailers, manufacturers, wholesalers). **LIFO reserve**: companies using LIFO are required to disclose the difference between LIFO inventory value and what inventory would be valued at under FIFO. This difference is called the LIFO reserve. For a company that has been using LIFO for decades during inflationary periods, the LIFO reserve can be substantial — representing the accumulated tax deferral over the years. Formula: LIFO Reserve = FIFO Inventory Value − LIFO Inventory Value The LIFO reserve is disclosed in the footnotes and allows analysts to convert LIFO-reported numbers to FIFO-equivalent numbers for comparison with companies that use FIFO. This is important for apples-to-apples comparison across companies. To convert LIFO COGS to FIFO COGS: FIFO COGS = LIFO COGS − (Change in LIFO Reserve during the period). To convert LIFO net income to FIFO net income: FIFO NI = LIFO NI + (Change in LIFO Reserve × (1 − Tax Rate)). These conversions appear on CFA exams, advanced accounting courses, and financial analysis problems. **IFRS bans LIFO**: International Financial Reporting Standards prohibit LIFO entirely. The reasoning is that LIFO does not match the physical flow of inventory in most businesses (most businesses sell oldest inventory first physically) and can be used to manipulate earnings. Companies that follow IFRS use FIFO or weighted average. US GAAP still allows LIFO, creating one of the biggest structural differences between the two frameworks. **LIFO liquidation**: when a LIFO company sells more inventory than it purchases during a period, it dips into OLDER LIFO layers that have very low costs from years ago. This results in artificially low COGS and artificially high profit — essentially releasing the old tax deferral back to earnings in a single period. LIFO liquidations are disclosed in footnotes and often indicate a non-recurring earnings boost. Analysts adjust reported earnings downward for LIFO liquidation effects. **Method choice is permanent**: a company cannot arbitrarily switch inventory methods from year to year. Switching methods requires IRS approval for tax purposes and is disclosed as a change in accounting principle for financial reporting. The decision is long-term. AccountingIQ explains the tax and reporting implications of each method, calculates the LIFO reserve from LIFO and FIFO numbers, and performs the conversions that CFA and advanced accounting exams test.