Example: Annual LIFO Method of Stock Valuation

When using a LIFO method of stock rotation, you ship the most recently received stock before shipping stock received at an earlier time. This method might result in having stock in inventory that was purchased in previous years. This table lists the remaining stock for two previous years plus the purchase and sales transactions for the current year (2010):

Transaction

Year

Quantity

Average Cost

Value

Stock (layer)

2008

100

10

1000

Stock (layer)

2009

200

12

2400

Purchases

2010

300

15

4500

Sales

2010

(250)

-

-

During 2010, stock increased by 50 units (300 units purchased minus 250 units sold). This increase forms a new layer valued at the average cost for purchases during 2010 (15). This table displays the total value of all stock on December 31, 2010:

Transaction

Year

Quantity

Average Cost

Value

Stock (layer)

2008

100

10

1000

Stock (layer)

2009

200

12

2400

Stock (layer)

2010

50

15

750

LIFO stock value on December 31, 2010

-

350

-

4150

If in 2011 the stock decreased by 100 units, the total stock available on December 31, 2011 was 250 units. Fifty of the 100 unit decrease is deducted from the 50 units in the 2009 layer, and 50 units are deducted from the 2008 layer. This table lists the stock and value on December 31, 2010:

Transaction

Year

Quantity

Average Cost

Value

Stock (layer)

2008

100

10

1000

Stock (layer)

2009

150

12

1800

LIFO stock value on December 31, 2011

-

250

-

2800