Skip to content
Tutorials Center
My learning

Topics

Lesson 27 of 37 ยท Inventory and Receivables

Inventory Valuation: FIFO, LIFO and Weighted Average

Learn how FIFO, LIFO and weighted average cost flow assumptions split the cost of goods available into cost of goods sold and closing inventory, with worked examples.

When a business buys the same item at different prices during the year, a question arises when it sells some of them: which cost belongs to the units sold, and which to the units still on the shelf? The answer changes both cost of goods sold (and therefore profit) and the inventory shown on the balance sheet.

Accountants use a cost flow assumption to decide. The assumption need not match the physical movement of goods. In this lesson we compare three: FIFO, LIFO and weighted average.

The three methods

  • FIFO (first in, first out): the oldest costs are assumed to be sold first. Closing inventory holds the newest costs.
  • LIFO (last in, first out): the newest costs are assumed to be sold first. Closing inventory holds the oldest costs.
  • Weighted average: every unit is given the average cost of all units available.

LIFO is allowed under US GAAP but is prohibited under IFRS (IAS 2). FIFO and weighted average are allowed under both.

A worked example

A bike shop's helmet stock for the year (invented figures):

Date Event Units Unit cost Cost
1 Jan Opening inventory 100 $10 $1,000
1 Mar Purchase 200 $12 $2,400
1 Jun Purchase 100 $14 $1,400
Available for sale 400 $4,800

During the year, 250 helmets are sold. So 150 remain.

FIFO (oldest first): sold = 100 ร— $10 + 150 ร— $12 = $1,000 + $1,800 = $2,800. Closing inventory = 50 ร— $12 + 100 ร— $14 = $2,000.

LIFO (newest first, periodic): sold = 100 ร— $14 + 150 ร— $12 = $1,400 + $1,800 = $3,200. Closing inventory = 100 ร— $10 + 50 ร— $12 = $1,600.

Weighted average: average = 4,800 / 400 = $12. Sold = 250 ร— 12 = $3,000. Closing inventory = 150 ร— 12 = $1,800.

In each case: Cost of goods available = COGS + closing inventory = 4,800.

Method COGS Closing inventory
FIFO 2,800 2,000
Average 3,000 1,800
LIFO 3,200 1,600

Why the results differ

Prices were rising ($10, $12, $14). When prices rise:

  • FIFO gives the lowest COGS and the highest profit, and the balance sheet inventory is close to current prices.
  • LIFO gives the highest COGS and the lowest profit (and so lower tax in some countries), but old costs stay on the balance sheet.

When prices fall the pattern reverses. Over the whole life of the business total profit is the same, only its timing changes.

Try it: three methods side by side

This stand-in code calculates all three from the same purchase layers.

Python FIFO, LIFO and weighted average

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Try it: effect on gross profit

Python Gross profit under each method

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Choosing a method

Whatever you choose, apply it consistently from year to year and for similar inventory. Changing the method needs a good reason and disclosure, because it changes reported profit. The related rule that guards against overstating inventory is in inventory systems and lower of cost and NRV.

Common mistakes

  • Using the wrong order for LIFO or FIFO. Write the layers in date order first.
  • Forgetting the check: COGS + closing inventory must equal total cost available.
  • Assuming FIFO equals physical flow. It is an accounting assumption.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. In a period of rising prices, which method gives the highest profit?

    FIFO assigns the oldest, cheapest costs to cost of goods sold, so COGS is lowest and profit highest.
  2. 2. 50 units cost $4 and 50 units cost $6. What is the weighted average cost per unit?

    (50ร—4 + 50ร—6) / 100 = 500 / 100 = 5.
  3. 3. Cost of goods available for sale is $9,000 and COGS is $6,500. What is closing inventory?

    Closing inventory = 9,000 โˆ’ 6,500 = 2,500.
  4. 4. Which method is not allowed under IFRS?

    IAS 2 prohibits LIFO.

Summary

  • Cost flow assumptions allocate the cost of goods available between COGS and closing inventory.
  • FIFO, LIFO and weighted average give different profits when prices change.
  • In rising prices: FIFO highest profit, LIFO lowest.
  • COGS + closing inventory = cost of goods available.
  • Use one method consistently; LIFO is not permitted under IFRS.

Next: Inventory Systems and Lower of Cost and NRV