How to calculate LIFO & FIFO

Written by contributing writer
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to calculate LIFO & FIFO
There are a number of ways to calculate inventory. (Depot image by Czintos Ã--dön from Fotolia.com)

Inventory represents the value of goods a company is holding that are available for sale. Inventory is calculated according to the following formula: ending inventory = beginning inventory + net purchases -- cost of goods sold. Corporate managers and investors closely monitor the value of a company's inventory to determine how quickly the company sells the goods it produces. A growing inventory balance suggests that the company is not producing goods people want; additionally, carrying a large inventory balance reduces the company's cash flow because producing the inventory costs money. There are a number of ways to calculate inventory, but the two most popular are the last-in-first-out (LIFO) method and the first-in-first-out (FIFO) method. Under LIFO, the newest units in inventory are assumed to be sold first, so the cost of goods sold is based on the most recent inventory costs. Under FIFO, the oldest units are assumed to be sold first, so the cost of goods sold is based on historical inventory costs.

Skill level:
Moderate

Other People Are Reading

Things you need

  • Inventory tracking software
  • Calculator or spreadsheet program

Show MoreHide

Instructions

  1. 1

    Download the price and unit list of the products currently in the company's inventory. The price list will include the number of units purchased and the prices at which the units were purchased. The information will be ranked according to date of purchase; the units purchased most recently will be at the top of the list.

  2. 2

    Determine the number of units sold from inventory. Multiply the prices the company paid for the most recent units by the number of units sold to determine LIFO cost of goods sold.

  3. 3

    Suppose the company purchased 100 units of inventory for £3 on January 1, 200 units for £5 on March 1 and 100 units for £6 on June 1. Further suppose that the company sold 350 units on August 1. The LIFO cost of goods sold for these units will equal (100 x £6) + (200 x £5) + (50 x £3) = £1,852. The value of units remaining in inventory according to LIFO equals (100 x £3) + (200 x £5) + (100 x £6) - £1,852 = £162.

  1. 1

    Download the same price and unit list of the products currently in the company's inventory, and rank the information according to date so that the most recent inventory purchases are at the top of the list.

  2. 2

    Determine the number of units sold from inventory. Multiply the prices the company paid for the oldest units by the number of units sold to determine the FIFO cost of goods sold.

  3. 3

    Suppose the company purchased 100 units of inventory for £3 on January 1, 200 units for £5 on March 1 and 100 units for £6 on June 1. Further suppose that the company sold 350 units on August 1. The FIFO cost of goods sold for these units will equal (100 x £3) + (200 x £5) + (50 x £6) = £1,690. The value of units remaining in inventory according to FIFO equals (100 x £3) + (200 x £5) + (100 x £6) - £1,690 = £325.

Tips and warnings

  • LIFO and FIFO are cost-flow assumption methodologies that have nothing to do with the physical flow of a company's inventory. Most companies sell the oldest units in inventory first to avoid spoilage or product obsolescence. However, these companies can account for their inventory using the LIFO method even though the oldest units in inventory are physically being sold first.
  • LIFO and FIFO have different implications for a company's income and cash-flow statements. In an inflationary environment (when prices are rising), LIFO will result in higher cost of goods sold, lower gross margins and lower profitability (but also lower taxes) because the sold units will be accounted for using the most recent, higher costs. Conversely, FIFO will result in lower cost of goods sold, higher gross margins and higher profitability (but also higher taxes) because the sold units are accounted for using the older, lower costs.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.