FIFO vs LIFO Comparison

FIFO vs LIFO and its Effect on Gross Profit

FIFO and LIFO are different methods used in inventory management. The method chosen (FIFO vs LIFO) will affect the valuation placed on the ending inventory and the value of cost of goods sold (COGS).

By way of illustration, the following example explains the different outcomes when considering FIFO vs LIFO.

If a business had the following inventory information for August:

  • August 1 Beginning inventory 100 units 3.00 cost per unit
  • August 4 Purchased 400 units 2.50 cost per unit
  • August 24 Purchased 300 units 6.00 cost per unit
  • August 31 Sold 200 units

If the units were sold for 10.00 each, calculate the gross profit.

FIFO Method

To compare FIFO vs LIFO we first look at the the FIFO method. Using FIFO the first items into inventory are the first items to be sold.

FIFO Method Showing Units
Unit Cost 3.00 2.50 6.00 Total
Beginning 100 100
Purchase 400 300 700
Sell – 100 – 100 – 200
Ending 0 300 300 600

This table converts the units in the table above to cost at either 3.00, 2.50 or 6.00 per unit.

FIFO Method Showing Cost
Unit Cost 3.00 2.50 6.00 Total
Beginning 300 300
Purchase 1,000 1,800 2,800
Sell – 300 – 250 – 550
Ending 0 750 1,800 2,550

Using FIFO, the ending inventory is valued at 2,550 and cost of goods sold is 550. If the units sell for 10.00 each then the gross profit is calculated as follows:

Gross profit = Revenue - COGS
Gross profit = 200 x 10.00 - 550 
Gross profit = 1,450 

LIFO Method

The second method in our FIFO vs LIFO comparison is LIFO. In the LIFO method the last items into inventory are the first items to be sold.

Using the same values with the LIFO method we get the following result:

LIFO Method Showing Units
Unit Cost 3.00 2.50 6.00 Total
Beginning 100 100
Purchase 400 300 700
Sell – 200 – 200
Ending 100 400 100 600

This table converts the units in the table above to values at either 3.00, 2.50  or 6.00 per unit.

LIFO Method Showing Value
Unit Cost 3.00 2.50 6.00 Total
Beginning 300 300
Purchase 1,000 1,800 2,800
Sell – 1,200 – 1,200
Ending 300 1,000 600 1,900

Using LIFO, the ending inventory is valued at 1,900 and cost of goods sold is 1,200.

If the units sell for 10.00 each then the gross profit is calculated as follows:

Gross profit = Revenue - COGS
Gross profit = 200 x 10.00 - 1,200
Gross profit = 800 

FIFO vs LIFO Comparison of Gross Profit

The FIFO vs LIFO comparison shows that the gross profit using LIFO (800) is lower than the gross profit using FIFO (1,450). This is summarized in the table below.

Comparison of FIFO vs LIFO Gross Profit
FIFO LIFO
Revenue 2,000 2,000
COGS 550 1,200
Gross profit 1,450 800

The cost of goods sold in LIFO is normally higher than in FIFO as it is valued using the last items into inventory which, in times of rising prices, tend to be the highest valued items.

FIFO vs LIFO Comparison Cost Allocation

Note that the cost of goods sold plus the ending inventory is the same in each case. It’s only the split between the two items which changes.

Comparison of FIFO vs LIFO Cost Allocation
FIFO LIFO
Ending 2,550 1,900
COGS 550 1,200
Total 3,100 3,100

FIFO vs LIFO Comparison – Rising and Falling Prices

The effect of rising and falling prices on gross profit, cost of goods sold and ending inventory of using FIFO or LIFO is summarized in the tables below.

In each case the table shows the method which gives the highest value, for example in times of rising prices FIFO will give the highest gross profit.

Method giving highest value
Prices Inventory COGS Profit
Rising FIFO LIFO FIFO
Falling LIFO FIFO LIFO
FIFO vs LIFO Comparison January 2nd, 2018Team

You May Also Like


Related pages


cash floatfixed asset turnover calculatordefinition of prepaid expensesmall business general ledgerproforma of cash booktie ratiopetty cash imprestaccumulated depwhat is days sales in receivableswhat is triple column cash bookimprest system of accountinggaap acronymwhat is ending inventorybookkeeping examplesmanufacturing overhead calculatorincome statement creatorexcel pmtmarkup to margin calculatorbookkeeping double entry examplesjournal entry to record bad debt expenseaccounting excel templateproduction overhead formulaexample of adjusting entriesperpetual and periodic inventory systemcreditor days definitionnbv accountingliquidity ratios listasset retirement obligation journal entryhow to calculate pv of annuitysample accounting worksheetentries for bonds payable and installment note transactionswhat is unearned revenue classified asstandard costing and variance analysis formulabookkeeping exercisesdepreciation straight line method example problemsfixed asset register excel templateaged accounts receivable reporthow to calculate weighted average in excel with percentagesdupont formula calculatorcurrent portion of long term debt journal entryformula for double declining balance depreciationpayment receipt format docreconciliation template exceldays sales outstanding analysisthe purpose of reversing entries is tocalculate interest expense on bondsthree colum cash booksublease accounting treatmentmarkup on selling price vs markup on costclosing stock trial balancehow to treat provision for doubtful debtswhat is the difference between markup and gross marginhow to closing entriesuse of the double-declining balance methodprepaid assets accountingdeffered revenue expenditureinvoice payment terms wordinghow to calculate straight line depreciationan overstatement of beginning inventory results inweekly bookkeeping recordconsignment sales revenue recognitionimportance of standard costing and understanding variancescredit card accounting entriestrade payables balance sheetoverhead variancesdepreciation entriesbad debts recoveredmarkup and margin calculatorwages debit or creditpartnership firm accounting entriesreceivables turnover daysstatement of stockholders equity examplejournal entry to record bad debt expensecapital lease amortization calculatorvolume variance definitionwhat is variable cost in accountingexpanded accounting equation calculatorannual depreciation rate calculatorjournal entry for advance salary paid