Show
This article is part of a larger series on Bookkeeping. First-in, first-out, also known as the FIFO inventory method, is one of four different ways to assign costs to ending inventory. FIFO assumes that the first items purchased are sold first. Companies must make an assumption about their flow of inventory goods to assign a cost to the inventory remaining at the end of the year. In this article, we’ll discuss how to calculate the value of inventory and the cost of goods sold (COGS) using the FIFO method as well as the advantages and disadvantages of using the FIFO inventory method. How the FIFO Inventory Method WorksFIFO is one of four popular inventory valuation methods, along with specific identification, average cost, and LIFO. The FIFO inventory method assumes that the first items put into inventory will be the first items sold. Under this method, the inventory that remains on the shelf at the end of the month or year will be assigned the cost of the most recent purchases.
Example of FIFO:If a retailer purchases 100 snow globes each month and has 80 snow globes in inventory at the end of the year, then those 80 snow globes will be assigned a cost per unit equal to the December purchase price. If there were 120 snow globes left at the end of the year, 100 would be valued at the December purchase price and the other 20 would be valued at the November purchase price. It makes no difference when the items in the ending inventory were purchased. Most companies buy inventory throughout the year at various prices. They sell most of their inventory but have some left at the end of the year. An inventory valuation method, such as FIFO determines what cost to assign to the units in ending inventory. This helps when it isn’t always straightforward if many identical units were purchased during the year for various prices. What Type of Business FIFO Is Best For
What Type of Business FIFO Is Not Right For
Advantages & Disadvantages of Using the FIFO MethodHow To Calculate Inventory Value Using the FIFO MethodLet’s assume that 100 gallons of milk are in stock at your store: Beginning Inventory: 100 gallons at $2 each = $200.00 Now let’s say that we make the following purchases of milk: Purchase #1: 10 gallons at $2.50 each = $25.00 Purchase #2: 20 gallons at $3.00 each = $60.00 Our new inventory quantity available for sale during the period is 130 gallons (100+10+20), with a cost of $285.00 ($200 +$25+$60). Assume 80 gallons of milk were sold during the year, leaving 50 gallons in inventory. With FIFO you calculate the cost of those remaining 50 gallons using the most recent prices. Twenty gallons in ending inventory were purchased for $3, 10 gallons were purchased for $2.50, and 20 gallons were in beginning inventory for $2. Therefore, your total cost of ending inventory is $125 ($60 + $25 + $40 = $125). How To Calculate COGS Using the FIFO MethodLet’s continue with our milk example and calculate the cost of the 80 gallons that were sold during the year. In this simple example, it’s pretty easy to see that all 80 gallons sold were in inventory at the beginning of the year with a cost of $2 each. Therefore, the COGS for the 80 gallons of milk is $160. A more common way to calculate the COGS under FIFO is to subtract the cost of ending inventory from the cost of total goods available for sale. As given above, the total cost of the 130 gallons available for sale during the period was $285. Subtracting the cost of ending inventory of $125 leaves you with $160 for the COGS. Bottom LineWhile it’s useful to have a basic understanding of how to use the FIFO inventory method, we strongly recommend using accounting software like QuickBooks Online Plus. It’ll do all of the tedious calculations for you in the background automatically in real-time. This will ensure that your balance sheet will always be up to date with the current cost of your inventory, and your profit and loss (P&L) statement will reflect the most recent COGS and profit numbers. Periodic means that the Inventory account is not routinely updated during the accounting period. Instead, the cost of merchandise purchased from suppliers is debited to the general ledger account Purchases. At the end of the accounting year the Inventory account is adjusted to equal the cost of the merchandise that has not been sold. The cost of goods sold (which is reported on the income statement) is computed by taking the cost of the goods available for sale and subtracting the cost of the ending inventory. FIFO is an acronym for first in, first out. Under the FIFO cost flow assumption, the first (oldest) costs are the first costs to leave inventory and be reported as the cost of goods sold on the income statement. The last (or recent) costs will remain in inventory and be reported as inventory on the balance sheet. Remember that the costs can flow differently than the physical flow of the goods. For example, if the Corner Bookstore uses the FIFO cost flow assumption, the owner may sell any copy of the book but report the cost of goods at the first/oldest cost as shown in the exhibit that follows. Let's demonstrate periodic FIFO with the following information from the Corner Bookstore: As before, we need to account for the cost of goods available for sale (5 books having a total cost of $440). With FIFO we assign the first cost of $85 to be the cost of goods sold. The remaining $355 ($440 - $85) will be the cost of the ending inventory. The $355 of inventory costs consists of $87 + $89 + $89 + $90. The $85 cost that was assigned to the book sold is permanently gone from inventory. If Corner Bookstore sells the textbook for $110, its gross profit using periodic FIFO will be $25 ($110 - $85). If the costs of textbooks continue to increase, FIFO will always result in more gross profit than other cost flows, because the first cost will always be lower. Periodic LIFOPeriodic means that the Inventory account is not updated during the accounting period. Instead, the cost of merchandise purchased from suppliers is debited to the general ledger account Purchases. At the end of the accounting year the Inventory account is adjusted to the cost of the merchandise that is unsold. The remainder of the cost of goods available is reported on the income statement as the cost of goods sold. LIFO is an acronym for last in, first out. Under the LIFO cost flow assumption, the latest (or most recent) costs are the first ones to leave inventory and become the cost of goods sold on the income statement. The first/oldest costs will remain in inventory and will be reported as the cost of the ending inventory on the balance sheet. Remember that the costs can flow differently than the goods. In other words, if Corner Bookstore uses periodic LIFO, the owner may sell the oldest (first) copy of the book to a customer, and report the cost of goods sold of $90 (the cost of the most recently purchased book). It's important to note that under periodic LIFO (not perpetual LIFO) you wait until the entire year is over before assigning the costs. Then you flow out of inventory the year's most recent costs first, even if those goods arrived after the last sale of the year. For example, assume the last sale of the year at the Corner Bookstore occurred on December 27. Also assume that the store's last purchase of the year arrived on December 31. Under periodic LIFO, the cost of the book purchased on December 31 is removed from inventory and sent to the cost of goods sold first, even though it was physically impossible for that book to be the one sold on December 27. (This reinforces our earlier statements that the flow of costs does not have to correspond with the physical flow of units.) Let's illustrate periodic LIFO by using the data for the Corner Shelf Bookstore: As before we need to account for the cost of goods available for sale: 5 books having a total cost of $440. Under periodic LIFO we assign the last cost of $90 to the book that was sold. (If two books were sold, $90 would be assigned to the first book and $89 to the second book.) The remaining $350 ($440 - $90) is reported as the cost of the ending inventory. The $350 of inventory cost consists of $85 + $87 + $89 + $89. The $90 assigned to the book that was sold is permanently gone from inventory. If the bookstore sold the textbook for $110, its gross profit using periodic LIFO will be $20 ($110 - $90). If the costs of textbooks continue to increase, periodic LIFO will always result in the least amount of profit. The reason is that the last costs will always be higher than the first costs. Higher costs result in less profits and often lower income taxes. Periodic AverageWhen the periodic inventory system is used, the Inventory account is not updated and purchases of merchandise are recorded in the general ledger account Purchases. With the average or weighted average cost flow assumption an average cost is calculated using the cost of goods available for sale (cost from the beginning inventory plus the costs of all the purchases made during the year). This means that the periodic average cost is calculated after the year is over—after all the purchases for the year have occurred. This average cost is then applied to the units sold during the year and to the units in inventory at the end of the year. We will assume the same facts. There were 5 books available for sale for the year 2021 and the cost of the goods available was $440. The weighted average cost of the books is $88 ($440 of cost of goods available ÷ 5 books). The average cost of $88 is used to compute both the cost of goods sold and the cost of the ending inventory. Since the bookstore sold only one book, the cost of goods sold is $88 (1 x $88). The ending inventory of four unsold books is reported at the cost of $352 (4 x $88) . The total of the cost of goods sold plus the cost of the inventory should equal the cost of goods available ($88 + $352 = $440). If Corner Bookstore sells the textbook for $110, its gross profit using the periodic average method will be $22 ($110 - $88). This gross profit of $22 lies between the $25 computed using the periodic FIFO and the $20 computed using the periodic LIFO. Page 2
We will use a hypothetical business Corner Bookstore to demonstrate how to flow the costs out of inventory and into the cost of goods sold on the company's income statement. Often this is done by using either the periodic inventory method or the perpetual method. Before we begin, keep in mind that there can be a difference between the following:
Generally, the units are physically removed from inventory by selling the oldest units first. Therefore, the physical units of product are flowing first in, first out. Companies want to get the oldest items out of inventory and keep the most recent (freshest) ones in inventory. Businesses will refer to this as rotating the goods on hand or rotating the stock. However, the costs of the goods in inventory does not have to flow the way the goods flowed. This means the bookstore can remove the oldest copy of its three copies from inventory but remove the cost of its most recently purchased copy. In other words, the goods can flow using first in, first out while the costs flow using last in, first out. This is why accountants refer to the cost flows as cost flow assumptions. Demonstrating Cost Flow AssumptionsLet's assume the Corner Bookstore had one book in inventory at the start of the year 2021 and at different times during 2021 it purchased four additional copies of the same book. During the year 2021, the publisher increased the price of the books due to a paper shortage. The following chart shows Corner Bookstore's total cost of the five books was $440. It also assumes that none of the books has been sold as of December 31, 2021. If the Corner Bookstore sells only one of the five books, which cost should Corner Shelf report as the cost of goods sold? Should it select $85, $87, $89, $89, $90, or the average cost of the five amounts? Which cost should Corner Bookstore report as inventory on its balance sheet for the four unsold books? In the U.S., three of the most common ways to flow costs out of inventory and into the cost of goods sold are:
Note that these are cost flow assumptions. Recall that the order in which costs are removed from inventory (and reported on the income statement as the cost of goods sold) can be different from the order in which the goods are physically removed from inventory. In other words, if Corner Bookstore sells one book that was on hand at the beginning of the year it can remove from inventory the $90 cost of the most recently purchased book in December 2021 (if it had elected the periodic LIFO cost flow assumption). Inventory Systems with Cost Flow AssumptionsThe combination of the three cost flow assumptions and the two inventory systems means six options for calculating the cost of inventory and the cost of goods sold:
Page 3When using the perpetual inventory system, the general ledger account Inventory is constantly (or perpetually) changing. For example, when a retailer purchases merchandise, the retailer debits its Inventory account for the cost. (Under the periodic system, the account Purchases was debited.) When the retailer sells the merchandise the Inventory account is credited and the Cost of Goods Sold account is debited for the cost of the goods sold. Rather than the Inventory account staying dormant as it did with the periodic method, the Inventory account balance is updated for every purchase and sale. Under the perpetual system, two entries are recorded when merchandise is sold: (1) the amount of the sale is debited to Accounts Receivable or Cash and is credited to Sales, and (2) the cost of the merchandise sold is debited to the account Cost of Goods Sold and is credited to Inventory. (Note: Under the periodic system the second entry is not made.) With perpetual FIFO, the first (or oldest) costs are the first removed from the Inventory account and debited to the Cost of Goods Sold account. Therefore, the perpetual FIFO cost flows and the periodic FIFO cost flows will result in the same cost of goods sold and the same cost of the ending inventory. Perpetual LIFOWhen using the perpetual system, the Inventory account is constantly (or perpetually) changing. The Inventory account is updated for every purchase and every sale. Under the perpetual system, two transactions are recorded at the time that the merchandise is sold: (1) the amount of the sale is debited to Accounts Receivable or Cash and is credited to Sales, and (2) the cost of the merchandise sold is debited to the account Cost of Goods Sold and is credited to Inventory. (Note: Under the periodic system the second entry is not made.) With perpetual LIFO, the last costs available at the time of the sale are the first to be removed from the Inventory account and debited to the Cost of Goods Sold account. Since this is the perpetual system we cannot wait until the end of the year to determine the last cost (as is done with periodic LIFO). An entry is needed at the time of the sale in order to reduce the balance in the Inventory account and to increase the balance in the Cost of Goods Sold account. If the costs of the goods purchased rise throughout the entire year, perpetual LIFO will result in a lower cost of goods sold and a higher net income than periodic LIFO. Generally this means that periodic LIFO will result in less income taxes than perpetual LIFO. (If you wish to minimize the amount paid in income taxes during periods of inflation, you should discuss LIFO with your tax adviser.) We will demonstrate perpetual LIFO by using the same Corner Bookstore information: Let's assume that after Corner Bookstore makes its second purchase in June 2021, Corner Bookstore sells one book. This means the lastest cost at the time of the sale was $89. Under perpetual LIFO the following entry must be made at the time of the sale: $89 will be credited to Inventory and $89 will be debited to Cost of Goods Sold. If that was the only book sold during the year, at the end of the year the Cost of Goods Sold account will have a balance of $89 and the cost in the Inventory account will be $351 ($85 + $87 + $89 + $90). If the bookstore sells the textbook for $110, its gross profit under perpetual LIFO will be $21 ($110 - $89). Note that this $21 is different than the gross profit of $20 under periodic LIFO. Perpetual AverageWhen using the perpetual inventory system, the Inventory account is constantly (or perpetually) changing. The inventory account is updated for every purchase and every sale. With the perpetual system, two sets of entries are made whenever merchandise is sold: (1) the amount of the sale is debited to Accounts Receivable or Cash and is credited to Sales, and (2) the cost of the merchandise sold is debited to the account Cost of Goods Sold and is credited to the account Inventory. (Note: Under the periodic system the second entry is not made.) In the perpetual system, "average" means the average cost of the items in inventory as of the date of the sale. This requires calculating a new average cost per unit after every purchase. The new average cost is multiplied by the number of units sold and is credited to the Inventory account and debited to the Cost of Goods Sold account. (We use the average as of the time of the sale because this is a perpetual method. Under the periodic system we wait until the year is over before computing the average cost.) Let's demonstrate the perpetual average method using the Corner Bookstore information: Let's assume that on July 1 Corner Bookstore sells one book. This means the average cost at the time of the sale was $87.50 ([$85 + $87 + $89 + $89] ÷ 4). Because this is a perpetual average, a journal entry must be made at the time of the sale for $87.50. The $87.50 (the average cost at the time of the sale) is credited to Inventory and is debited to Cost of Goods Sold. After the sale on July 1, three copies remain in inventory. The balance in the Inventory account will be $262.50 (3 books at an average cost of $87.50). After Corner Bookstore makes its third purchase of the year 2021, the average cost per unit will change to $88.125 ([$262.50 + $90] ÷ 4). As you can see, the average cost moved from $87.50 to $88.125—this is why the perpetual average method is sometimes referred to as the moving average method. The Inventory balance is $352.50 (4 books with an average cost of $88.125 each). Page 4
Below is a recap of the varying amounts for the cost of goods sold, gross profit, and ending inventory that were calculated above. The examples assumed that costs were continually increasing. The results would be different if costs were decreasing or increasing at a slower rate. Consult with your tax adviser concerning the election of a cost flow assumption. In past periods of inflation, many U.S. companies switched from FIFO to LIFO. However, once the switch is made, a company cannot change back to FIFO. Specific IdentificationIn addition to the six cost flow options discussed earlier, businesses have another option: expense to the cost of goods sold the specific cost of the specific item sold. For example, Gold Dealer, Inc. has an inventory of gold and each gold bar has an identification number and the cost of the gold bar. When Gold Dealer sells a gold bar, it can expense to the cost of goods sold the exact cost of the specific gold bar sold. The cost of the other gold bars will remain in inventory. (Alternatively, Gold Dealer could use one of the other six cost flow options described earlier.) LIFO Benefits Without Tracking UnitsEarlier we demonstrated that during periods of increasing costs, LIFO resulted in less profits. In the U.S. this can mean less income taxes paid by a corporation. Most corporations view lower taxes as a significant benefit. However, the process of tracking costs and then assigning those costs to the units sold and the units on hand could be too expensive for the amount of income tax savings. To gain the benefit of LIFO without tracking costs, there is a method known as dollar value LIFO. This topic is discussed in intermediate accounting textbooks. The Internal Revenue Service also allows companies to use dollar value LIFO by applying price indexes. (You should seek the advice of an accounting and/or tax professional to assess the cost and benefit of these techniques.) Inventory ManagementOver the past decades sophisticated companies have made great strides in reducing their levels of inventory. Rather than carry large inventories, they ask their suppliers to deliver goods "just in time." Suppliers and merchandisers have learned to coordinate their purchases and sales so that orders and shipments occur automatically. A company will realize significant benefits if it can keep its inventory levels down without losing sales or production (if the company is a manufacturer). In its early days, Dell Computers greatly reduced its inventory in relationship to its sales. Since the cost of computer components had been dropping as new technologies emerged, it benefited Dell to keep a small inventory of components on hand. It would be a financial hardship if Dell had a large quantity of components that became obsolete or decreased in value. Financial RatiosKeeping track of inventory is important. There are two common financial ratios for monitoring inventory levels: (1) Inventory Turnover Ratio, and (2) Days' Sales in Inventory. These are discussed and illustrated in the Explanation of Financial Ratios. Page 5It is very time-consuming for a company to physically count the units of goods in its inventory. In fact, some companies shut down their operations near the end of their accounting year just to perform inventory counts. Often a company assigns one set of employees to count and tag the items and another set to verify the counts. If a company has outside auditors, they will be there to observe the process. (Even if the company's computers keep track of inventory, the computer quantities must be verified by physically counting the goods at least once per year.) If a company using the periodic inventory system counts its inventory only once per year, it must estimate its inventory at the end of each month in order to prepare meaningful monthly financial statements. In fact, a company may need to estimate its inventory for other reasons as well. For example, if a company suffers a loss due to a disaster such as a tornado or a fire, it will need to file a claim for the approximate cost of the inventory that was lost. (An insurance adjuster will also compute the amount independently so that the company is not paid too much or too little for its loss.) Estimating Inventory: Gross Profit MethodThe gross profit method for estimating the cost of the ending inventory uses information from a previously issued income statement. To illustrate the gross profit method we will assume that ABC Company needs to estimate the cost of its ending inventory on June 30, 2021. ABC's latest income statement (which is representative of current conditions) contained the following information: From ABC's information we see that the company's gross profit is 20% of sales, and that the cost of goods sold is 80% of sales. If those percentages are reasonable for the current year, we can use them to estimate the cost of the inventory on hand as of June 30, 2021. While an algebraic equation could be used, we prefer to simply use the income statement format. We will prepare a partial income statement for the period beginning after the date when inventory was last physically counted, and ending with the date for which we need the estimated inventory cost. In this case, the income statement we prepare will be from January 1, 2021 until June 30, 2021. Some of the amounts needed can be obtained from sales records, customers, suppliers, earlier financial statements, etc. For example, sales for the first half of the year 2021 are taken from the company's records. The beginning inventory amount is the ending inventory reported on the December 31, 2020 balance sheet. The purchases information for the first half of 2021 is available from the company's records or its suppliers. The amounts that are available are shown in italics in the following partial income statement: We will fill in the rest of the statement with the answers from the following calculations. The calculation amounts in italics come from the statement above. The calculation amounts in bold will be used to complete the above section of the income statement: Inserting this information into the income statement yields the following: Next, we need to compute the ending inventory amount. This is done by subtracting the cost of goods sold from the cost of goods available as shown here: Below is the completed partial income statement with the estimated amount of ending inventory at $26,200. (Note: Always recheck the math on the income statement to be certain you computed the amounts correctly.) Estimating Inventory: Retail MethodAnother method for estimating inventory is the retail method. This method can be used by retailers who have their merchandise records in both cost and retail selling prices. A very simple illustration of using the retail method for estimating the cost of ending inventory (using hypothetical amounts unrelated to earlier examples) is shown here: Notice that the cost amounts are presented in one column and the retail amounts are listed in a separate column. The Goods Available amounts are used to compute the cost-to-retail ratio. In this case the cost of goods available of $80,000 is divided by the retail amount of goods available of $100,000. Therefore, the cost-to-retail ratio, or cost ratio, is 80%. The estimated ending inventory at cost is the estimated ending inventory at retail of $10,000 times the cost ratio of 80% equals $8,000.
We recommend that you now take our free Practice Quiz for this topic so that you can...
Note: You can receive instant access to our PRO materials (visual tutorials, flashcards, quick tests, quick tests with coaching, cheat sheets, video training, bookkeeping and managerial guides, business forms, printable PDF files, and progress tracking) when you join AccountingCoach PRO.
You should consider our materials to be an introduction to selected accounting and bookkeeping topics, and realize that some complexities (including differences between financial statement reporting and income tax reporting) are not presented. Therefore, always consult with accounting and tax professionals for assistance with your specific circumstances. Page 6
|