Advertisement
Money

How to Calculate FIFO Inventory Costs When Determining the Year-End Balance of the Inventory Account

The FIFO inventory valuation method is one of several used to arrive at the year-end balance for the Inventory account, and its impact on income can make a considerable difference when compared to some other methods. This can be important when statements are being viewed by creditors or investors.

By Bruce Tintelnot
Desk Money
Reading time 4 min read
Word count 835
Finance Business Business tips
How to Calculate FIFO Inventory Costs When Determining the Year-End Balance of the Inventory Account
Advertisement
Quick Take

The FIFO inventory valuation method is one of several used to arrive at the year-end balance for the Inventory account, and its impact on income can make a considerable difference when compared to some other methods. This can be important when statements are being viewed by creditors or investors.

On this page

What is FIFO?

GPK Marginal Costing Structure Flow11

The FIFO inventory valuation method, or first-in first-out, is one of a number of inventory costing methods. It is used to facilitate the valuation of merchandise at the end of the year in the Inventory account. When determining how to calculate FIFO inventory costs, the basic assumption is that the first units of merchandise added to the physical inventory are going to be the first units removed during the course of business. The balance sheet Inventory account at the end of the year would then reflect the most recent costs matched to the most recent units produced, or purchased and placed in stock.

Advertisement

Ending Inventory Valuation Using FIFO

Two inventory systems can be used for the FIFO inventory valuation method, and other inventory costing methods. They are the periodic inventory system, and the perpetual inventory system. The periodic inventory system does not update the Inventory account regularly, but instead uses a purchases account to record purchases of merchandise that are added to the physical inventory. The purchases account is closed at the end of the year, and the Inventory account is then updated. A Cost of Goods Sold account isn’t necessary for this system so there is no way of telling what the Inventory account amounts are during the course of the year.

The Perpetual Inventory System

The perpetual inventory system, unlike the periodic inventory system, continuously records changes to the Inventory account. The account is increased by purchases of merchandise from suppliers, and reduced by sales of merchandise to customers.

Advertisement

The purchases account isn’t necessary in this system, but there is the Cost of Goods Sold account that is debited when merchandise is removed from the inventory and sold. This actually consists of two journal entries:

  • The recording of the sale to the Sales account (a credit), and to the Cash, or Accounts Receivable accounts (a debit).
  • The reduction of the Inventory account (a credit), and an addition to the Cost of Goods Sold account (a debit).

The Periodic Inventory System

Calculating the ending inventory costs using periodic FIFO is fairly straightforward. The following example shows this.

Advertisement

Inventory Additions/Withdrawals

100,000 units beginning inventory @ $5.00 ea. = $ 500,000

200,000 units purchased @ $5.50 ea. = $1,100,000

Advertisement

(50,000) units sold @ ? = ?

100,000 units purchased @ $5.75 ea. = $ 575,000

Advertisement

(75,000) units sold@ ? = ?

Calculating Units in Ending inventory

The number of units in the ending inventory would be:

Advertisement

Ending Inventory = Beginning Inventory + Units Purchased - Units Sold

275,000 units = 100,000 units + 300,000 units - (50,000 units + 75,000 units)

Advertisement

Determine the Cost of Each Sale

To determine the costs of each sale in this example it helps to consider purchases of inventory as forming three tiers:

Tier 1: 100,000 units (beginning inventory)

Advertisement

Tier 2: 200,000 units (first purchase)

Tier 3: 100,000 units (second purchase)

Advertisement

First Sale of Goods in Inventory

The cost of the 50,000 units that were first sold would be determined by assigning the earliest purchase price to them. This would happen to be $5.00 per unit from the first tier, the beginning inventory. The cost of the sale would be $250,000:

50,000 units x $5.00 = $250,000

Advertisement

The the remaining balance of the beginning Inventory would be 50,000 units:

100,000 units - 50,000 units = 50,000 units.

Advertisement

Second Sale of Goods in Inventory

The cost of the 75,000 units sale involves two tiers. The first 50,000 units would be costed at $5.00 per unit from the remainder of the first tier (beginning inventory), and the next 25,000 units would be costed from the second tier (200,000) of inventory at $5.50. The calculation would be:

Remainder of tier 1: 50,000 units @ $5.00 = $250,000

Advertisement

From tier 2: 25,000 units @ $5.50 = $137,500

The total sale would be: $387,500

Advertisement

Ending Inventory Balance

The value of the ending inventory would then be $1,787,000:

$1,787,000 = $500,000 + $1,675,000 - ($250,000 + 137,500)

Summary

The cost flow using FIFO assigns the oldest purchase prices to inventory merchandise when they are sold. How to calculate FIFO inventory costs is dependent upon the existing inventory system being used.

The periodic inventory system uses a Purchases account to record purchases from suppliers, and adjusts the Inventory account for additions, or reductions at the end of the year. The perpetual inventory system continually updates the Inventory account throughout the year debiting a Cost of Goods Sold account and crediting the Inventory account when merchandise is sold. The systems are different, but when calculating inventory costs using periodic FIFO, or perpetual FIFO shows no differences in the Inventory account on the balance sheet.

Citations

“Inventory Chapter 8,” PrinciplesofAccounting.com. Retrieved August 2, 2010 from the World Wide Web: https://www.principlesofaccounting.com/chapter%208.htm#inventory%20costing%20methods

“Comparison of Inventory Valuation Methods,” Accounting Study Guide Online, 2010. Accounting Courses Online. Retrieved August 2, 2010 from the World Wide Web: https://accountinginfo.com/study/inventory/inventory-120.htm

“Inventory and Cost of Goods Sold,” AccountingCoach.com, 2010. Retrieved August 2,2010 from the World Wide Web: https://www.accountingcoach.com/online-accounting-course/12Xpg02.html#periodic-fifo

Image Credit: Public domain retrieved from Wikimedia.org

Keep Exploring

More from Money

Filed under
Finance Business
More topics
Business tips
Advertisement