FIFO, LIFO and weighted average when prices rise or fall
The cost formula decides which costs go to cost of sales and which stay in inventory. With rising costs, last in, first out (LIFO) gives higher cost of sales, lower profit and inventory, lower taxes and higher operating cash flow than first in, first out (FIFO). Weighted average sits between. With falling costs, every effect reverses.
Before this: Lower of cost and net realizable value (and write-down reversals), Expense recognition: capitalizing vs expensing
On the exam
- Calculate and explain how inflation and deflation of inventory costs affect the financial statements and ratios of companies that use different inventory valuation methods
Calculate and explain how rising and falling inventory costs affect the statements and ratios under each cost formula. Expect a cost of sales calculation, a LIFO versus FIFO effects grid (including the flip for falling costs), and a LIFO reserve conversion.
How deeply to learn each part
- Know the idea
- Understand it in general. It frames other topics, but you will not calculate with it.
- Use it
- Understand it well enough to solve a question with it. Recognize when it applies.
- Memorize
- Learn it by heart. The exam will not give it to you.
You know this one. The full lesson is folded away. The takeaways, formulas and checkpoint below are your quick refresher, and the checkpoint is a fair test of whether you still do.
You tested strong here. The full lesson is folded away. The takeaways, formulas and checkpoint below are your quick refresher, and the checkpoint is a fair test of whether you still know it.
What does the cost of inventory include?
Inventory is recorded at the cost of getting the goods to where they are sold, in the condition they are sold. These product costs sit on the balance sheet until the goods are sold. Then they move to cost of sales. The costs are similar under International Financial Reporting Standards (IFRS) and US generally accepted accounting principles (GAAP).
Included: the purchase price less trade discounts and rebates (plus non-recoverable taxes and duties, and freight in), conversion costs such as direct labor and production overhead, and other costs of bringing the goods to their present location and condition. Expensed as incurred: abnormal waste, storage (unless needed in production), administrative overhead and selling costs.
- Capitalize in inventory Use it
- Purchase cost less discounts, plus non-recoverable taxes and freight in
- Conversion costs direct labor and production overhead
-
- Expense as incurred Use it
- Abnormal waste
- Storage unless a necessary production step
- Administrative and selling costs
-
How do the cost formulas split the cost?
Every formula splits the same pool of cost between the income statement and the balance sheet. That pool is the cost of goods available for sale : beginning inventory plus purchases. What is not sold stays as ending inventory , and what is sold becomes cost of sales (cost of goods sold).
The identity can be solved for any of its four items, and exams do ask for purchases or beginning inventory.
A company has beginning inventory of 1,000.00, purchases of 5,200.00 and ending inventory of 2,100.00. Cost of goods sold is closest to:
1,000.00 + 5,200.00 − 2,100.00 = 4,100.00
Cost of goods sold4,100.00
- 1000+5200−2100=
- 1000ENTER5200+2100−
ENTER enter (on the HP, puts the number on the stack)
The formulas differ only in which costs they say were sold first.
- Specific identification Use it actual cost of each unit; unique, high-value items
- First in, first out (FIFO) Memorize oldest costs to cost of sales, newest stay in inventory
- Weighted average cost Memorize one average unit cost for both
- Last in, first out (LIFO) Memorize newest costs to cost of sales, oldest stay in inventory; US GAAP only
- First in, first out (FIFO): the oldest costs go to cost of sales. Ending inventory carries the newest costs.
- Last in, first out (LIFO): the newest costs go to cost of sales. Ending inventory carries the oldest costs. Allowed under US GAAP only.
- Weighted average cost : one average cost per unit is used for both.
- Specific identification : each unit sold carries its own actual cost. It suits unique, high-value items such as jewelry or custom projects.
The costs follow the formula, not the physical goods. A company can ship its oldest boxes and still report LIFO.
Goods available for sale cost 6,200.00 for 500 units. The weighted average cost per unit is closest to:
6,200.00 ÷ 500 = 12.40
Average cost per unit12.40
- 6200÷500=
- 6200ENTER500÷
ENTER enter (on the HP, puts the number on the stack)
What happens to profit, tax and cash when costs rise?
LIFO reports higher cost of sales and lower profit than FIFO, pays less tax and keeps more cash. Weighted average lands between. Inflation in unit costs is what separates the formulas: with no change in costs, all three give the same answer.
Memorize
| Item (costs rise, quantities stable or growing) | LIFO compared with FIFO |
|---|---|
| Cost of sales | Higher |
| Gross profit, operating profit, net income | Lower |
| Income taxes paid | Lower |
| Operating cash flow | Higher (lower taxes) |
| Ending inventory | Lower |
| Current ratio, working capital | Lower |
| Inventory turnover | Higher (higher cost of sales, lower inventory) |
| Days of inventory on hand | Lower |
| Gross and net margins | Lower |
| Debt-to-equity | Higher (lower retained earnings, so lower equity) |
| Return on assets | Unclear: lower profit and lower assets |
- Higher Memorize
- Cost of sales
- Operating cash flow only because taxes are lower
- Inventory turnover
- Debt-to-equity
-
- Lower Memorize
- Gross profit, operating profit, net income
- Income taxes paid
- Ending inventory, current ratio, working capital
- Days of inventory on hand
-
The cash flow row is the one candidates miss. Lower profit does not create cash. The extra cost of sales is not a cash cost, since the company paid the same purchase prices either way, so the only cash difference is the tax.
Try this 0 of 3
- Switch to falling costs: which method now reports the most profit?
- Find a sales level where LIFO saves at least USD 150 of tax
- Sell more units than were bought this period
- Opening (100 × 10)
- First purchase (200 × 12)
- Second purchase (200 × 14)
Oldest layer at the bottom. LIFO sells from the top down.
| FIFO | Avg cost | LIFO | |
|---|---|---|---|
| Income statement | |||
| Revenue | 8,750 | 8,750 | 8,750 |
| Cost of goods sold | 4,100lowest | 4,340 | 4,600highest |
| Gross profit | 4,650highest | 4,410 | 4,150lowest |
| Gross margin | 53.1%highest | 50.4% | 47.4%lowest |
| Income tax (25%) | 1,162.5highest | 1,102.5 | 1,037.5lowest |
| Net income | 3,487.5highest | 3,307.5 | 3,112.5lowest |
| Cash and balance sheet | |||
| Operating cash flow | 2,387.5lowest | 2,447.5 | 2,512.5highest |
| Ending inventory | 2,100highest | 1,860 | 1,600lowest |
| Current ratio | 2.40highest | 2.32 | 2.25lowest |
| Inventory turnover | 2.65lowest | 3.03 | 3.54highest |
What changed and why
Rising costs, 350 units sold
Costs rise from 10 to 14. FIFO sends the oldest, cheapest units to COGS, so it reports the most profit and pays the most tax; LIFO the least.
Show working
Goods available = 100 × 10 + 200 × 12 + 200 × 14 = 6,200 for 500 units; average cost = 6,200 ÷ 500 = 12.40
FIFO COGS = 100 × 10 + 200 × 12 + 50 × 14 = 4,100; LIFO COGS = 150 × 12 + 200 × 14 = 4,600; weighted average COGS = 350 × 12.40 = 4,340
Check: COGS + ending inventory = 6,200 under every method. LIFO reserve = 2,100 − 1,600 = 500 = LIFO COGS − FIFO COGS.
Current ratio = (cash + inventory) ÷ current liabilities of 2,500, where cash = opening 1,500 + CFO. Turnover = COGS ÷ average inventory (opening 1,000 and ending).
What changes when costs fall?
Everything reverses. With falling costs (deflation ) and stable or growing quantities, FIFO sends the old, dear costs to cost of sales, so FIFO shows lower profit and lower taxes than LIFO. Do not memorize a second grid. Flip the first.
Two points about which statement is “more realistic” are worth knowing. FIFO inventory is made of the newest purchases, so FIFO gives the better balance sheet. LIFO cost of sales is made of the newest purchases, so LIFO gives the better income statement, a profit closer to what replacing the goods costs today. Comparing a LIFO company with a FIFO peer therefore needs an adjustment.
Exam tip When the question says “rising prices”, the LIFO answer is the lower-profit, lower-tax, higher-cash answer. When it says “falling prices”, flip it. Do not rely on memory of which is which: ask which costs reach cost of sales.
How do you convert LIFO figures to FIFO?
Use the LIFO reserve. The LIFO reserve is the amount by which FIFO inventory would exceed LIFO inventory, disclosed by US companies using LIFO. It lets an analyst compare a LIFO company with a FIFO or IFRS peer.
Use it
When costs rise, the reserve grows, so FIFO cost of sales is lower than LIFO cost of sales by the increase. Cumulative extra profit under FIFO also sits in equity, after tax.
A US GAAP company reports LIFO inventory of 820.00 and a LIFO reserve of 130.00. Inventory on a FIFO basis would be closest to:
820.00 + 130.00 = 950.00
Ending inventory, FIFO950.00
- 820+130=
- 820ENTER130+
ENTER enter (on the HP, puts the number on the stack)
A falling reserve is a signal. If a LIFO company sells more units than it buys, old, cheap layers flow into cost of sales. That LIFO liquidation temporarily inflates profit and gross margin, and it cannot be repeated once the layers are gone. US GAAP requires disclosure of income from liquidating LIFO inventory. If inventories fall but the reserve still rises, read it as rising costs rather than a liquidation, and confirm in management’s discussion.
Go deeper LIFO liquidation in numbers
A company holds an old LIFO layer of 10 units at 8. This year it buys 100 units at 20 and sells 110. Cost of sales under LIFO is 100 × 20 + 10 × 8 = 2,080, instead of 110 × 20 = 2,200 if it had restocked. The 120 difference, 10 × (20 − 8), is profit that comes only from selling old stock at old costs. The company pays tax on it and cannot repeat it. An analyst strips it out before extrapolating margins.
Go deeper Periodic versus perpetual systems
A periodic system counts inventory and computes cost of sales at period end. A perpetual system updates the records at every sale. The periodic and perpetual inventory systems give the same results for FIFO and specific identification. They can differ for LIFO and weighted average.
Example: 10 units at 5 on hand, 10 bought at 6, then 10 sold, then 10 bought at 8, then 5 sold. Periodic LIFO treats all 15 sales as coming from the newest layers: 10 × 8 + 5 × 6 = 110. Perpetual LIFO matches each sale to the layers on hand at the time: 10 × 6 + 5 × 8 = 100. FIFO is 80 either way (10 × 5 + 5 × 6). The rising-cost conclusions still hold in both systems.
Go deeper Why LIFO is banned under IFRS, and the US conformity rule
IFRS regulators object that LIFO leaves stale costs on the balance sheet and invites liquidation games. In the United States, a company that uses LIFO for its tax return must use LIFO in its financial statements too (the conformity rule). That is why the tax saving is real, and why the income taxes module returns to deferred taxes when book and tax methods differ.
Memorize this
MemorizeEffects grid: LIFO compared with FIFO
| Item | Costs rise | Costs fall |
|---|---|---|
| Cost of sales | Higher | Lower |
| Gross profit, operating profit, net income | Lower | Higher |
| Income taxes paid | Lower | Higher |
| Operating cash flow | Higher (less tax) | Lower (more tax) |
| Ending inventory | Lower | Higher |
| Current ratio, working capital | Lower | Higher |
| Inventory turnover | Higher | Lower |
| Days of inventory on hand | Lower | Higher |
| Gross and net margins | Lower | Higher |
| Debt-to-equity | Higher (lower equity) | Lower |
| Return on assets | Unclear (lower profit and lower assets) | Unclear |
Memory hook Rising costs: LIFO sells the dear units first, so cost of sales goes up and everything it feeds (profit, tax, inventory, equity, liquidity) goes down. Cash, turnover and leverage go up.
Know it cold Falling costs flip every row. Weighted average always lands between FIFO and LIFO. Assumes stable or growing quantities.
MemorizeWhich statement shows current cost
| Method | Balance sheet inventory | Cost of sales |
|---|---|---|
| FIFO | Current cost (newest purchases) | Old cost |
| LIFO | Old cost | Current cost (newest purchases) |
| Weighted average | Average cost | Average cost |
Memory hook FIFO leaves the newest costs on the shelf (a real balance sheet). LIFO sends the newest costs to the income statement (a real profit).
Know it cold The costs follow the formula, not the physical goods. LIFO inventories are the least likely to need write-downs when costs rise.
MemorizeCost formulas and the standards
| Formula | IFRS | US GAAP |
|---|---|---|
| Specific identification | Yes | Yes |
| FIFO | Yes | Yes |
| Weighted average cost | Yes | Yes |
| LIFO | Not allowed | Yes |
Memory hook Three formulas everywhere; LIFO is the odd one out and lives only in the US.
Know it cold Use one formula for inventories of similar nature and use. FIFO and specific identification give the same answer under periodic and perpetual systems; LIFO and weighted average can differ.
MemorizeLIFO reserve conversions
| To get | Calculate |
|---|---|
| FIFO inventory | LIFO inventory + reserve |
| FIFO cost of sales | LIFO cost of sales − change in reserve |
| FIFO equity | LIFO equity + reserve × (1 − tax rate) |
| Reserve falling | Warning: possible LIFO liquidation |
Memory hook The reserve is the cumulative gap between the two inventories. Its change is this year's gap in cost of sales.
Know it cold Rising costs: the reserve grows, and FIFO pretax profit is higher by the change in the reserve. A falling reserve means old LIFO layers are being sold.
MemorizeWhat goes into inventory cost
| Capitalize (product costs) | Expense when incurred |
|---|---|
| Purchase cost less discounts, plus non-recoverable taxes and freight in | Abnormal waste of materials, labor or overhead |
| Conversion costs: direct labor and production overhead | Storage costs (unless needed in production) |
| Other costs of bringing goods to their present location and condition | Administrative overhead and selling costs |
Memory hook If a cost brings the goods to where and how they are sold, it goes in inventory. If it only stores, sells or wastes them, it is an expense.
Know it cold Inventory costs reach cost of sales only when the goods are sold.
- Specific identification Use it actual cost of each unit; unique, high-value items
- First in, first out (FIFO) Memorize oldest costs to cost of sales, newest stay in inventory
- Weighted average cost Memorize one average unit cost for both
- Last in, first out (LIFO) Memorize newest costs to cost of sales, oldest stay in inventory; US GAAP only
- Higher Memorize
- Cost of sales
- Operating cash flow only because taxes are lower
- Inventory turnover
- Debt-to-equity
-
- Lower Memorize
- Gross profit, operating profit, net income
- Income taxes paid
- Ending inventory, current ratio, working capital
- Days of inventory on hand
-
- Capitalize in inventory Use it
- Purchase cost less discounts, plus non-recoverable taxes and freight in
- Conversion costs direct labor and production overhead
-
- Expense as incurred Use it
- Abnormal waste
- Storage unless a necessary production step
- Administrative and selling costs
-
Quick example
Beginning inventory 600, purchases 3,900, ending inventory 750. 600 + 3,900 − 750 = 3,750.
- 600+3900−750= 3750
- 600ENTER3900+750− 3750
ENTER enter (on the HP, puts the number on the stack)
Quick example
80 units at 9 and 120 at 11 are available. (720 + 1,320) ÷ 200 = 10.20 a unit, so selling 150 units costs 10.20 × 150 = 1,530.
- (80×9)+(120×11)=÷200= 10.2
- 80ENTER9×120ENTER11×+200÷ 10.2
ENTER enter (on the HP, puts the number on the stack)
Quick example
LIFO cost of sales is 240 higher than FIFO. At a 30% tax rate, LIFO pays 72 less tax, so operating cash flow is 72 higher.
- 240×0.3= 72
- 240ENTER0.3× 72
ENTER enter (on the HP, puts the number on the stack)
Quick example
LIFO inventory 600 and a LIFO reserve of 90 give FIFO inventory of 690.
- 600+90= 690
- 600ENTER90+ 690
ENTER enter (on the HP, puts the number on the stack)
Quick example
LIFO cost of sales 3,000. The reserve rose from 70 to 90. FIFO cost of sales = 3,000 − 20 = 2,980.
- 3000−90+70= 2980
- 3000ENTER90−70+ 2980
ENTER enter (on the HP, puts the number on the stack)
Quick example
A reserve of 90 at a 30% tax rate adds 90 × 0.70 = 63 to equity on a FIFO basis.
- 1−0.3=×90= 63
- 1ENTER0.3−90× 63
ENTER enter (on the HP, puts the number on the stack)
How it is asked
-
Cost of sales under each formula
60 units at 8, then 90 at 9, then 150 at 10. 200 units are sold. Cost of sales under FIFO, LIFO, weighted average?
FIFO 60×8 + 90×9 + 50×10 = 1,790. LIFO 150×10 + 50×9 = 1,950. Average 2,790 ÷ 300 = 9.30, so 9.30 × 200 = 1,860. Each wrong option is another formula.
-
LIFO versus FIFO, rising costs
Costs rise and quantities are stable. LIFO versus FIFO gives what for operating cash flow?
Higher, because taxes are lower. "Higher because profit is lower" is the trap.
-
Falling costs flip the grid
Costs fall. Compared with FIFO, LIFO gives what for gross profit and taxes?
LIFO cost of sales is the cheap, newest cost: higher gross profit and higher taxes. Applying the rising-cost answers is the trap.
-
LIFO reserve conversion
LIFO inventory is 820 and the LIFO reserve is 130. FIFO inventory?
820 + 130 = 950. Subtracting the reserve (690) is the trap.
Exam traps
- Saying LIFO gives higher operating cash flow because profit is lower. It is higher only because tax is lower.
- Forgetting to flip every effect when costs fall.
- Saying IFRS allows LIFO. It does not.
- Putting the newest costs in LIFO ending inventory. LIFO leaves the oldest costs in inventory.
- Subtracting the LIFO reserve to get FIFO inventory. FIFO inventory is higher: add the reserve.
Checkpoint
3 exam-style questions. About 90 seconds each.
1A company begins the year with 50 units at CHF 20, buys 100 units at CHF 18 and then 100 units at CHF 16, and sells 160 units. Under FIFO, cost of goods sold is closest to:
2In a period of rising inventory costs and stable quantities, a company using LIFO rather than FIFO will most likely report a higher:
3Compared with FIFO, LIFO in a period of falling inventory costs would most likely result in:
Key takeaways
- Goods available for sale = cost of sales + ending inventory, whatever the formula.
- Rising costs: LIFO means higher cost of sales and cash flow; lower profit, tax and inventory than FIFO.
- Falling costs: every effect flips. Weighted average always sits between FIFO and LIFO.
- FIFO gives the realistic balance sheet; LIFO gives the realistic income statement. IFRS bans LIFO.
Quick example
Beginning inventory 600, purchases 3,900, ending inventory 750. 600 + 3,900 − 750 = 3,750.
- 600+3900−750= 3750
- 600ENTER3900+750− 3750
ENTER enter (on the HP, puts the number on the stack)
Quick example
80 units at 9 and 120 at 11 are available. (720 + 1,320) ÷ 200 = 10.20 a unit, so selling 150 units costs 10.20 × 150 = 1,530.
- (80×9)+(120×11)=÷200= 10.2
- 80ENTER9×120ENTER11×+200÷ 10.2
ENTER enter (on the HP, puts the number on the stack)
Quick example
LIFO cost of sales is 240 higher than FIFO. At a 30% tax rate, LIFO pays 72 less tax, so operating cash flow is 72 higher.
- 240×0.3= 72
- 240ENTER0.3× 72
ENTER enter (on the HP, puts the number on the stack)
Quick example
LIFO inventory 600 and a LIFO reserve of 90 give FIFO inventory of 690.
- 600+90= 690
- 600ENTER90+ 690
ENTER enter (on the HP, puts the number on the stack)
Quick example
LIFO cost of sales 3,000. The reserve rose from 70 to 90. FIFO cost of sales = 3,000 − 20 = 2,980.
- 3000−90+70= 2980
- 3000ENTER90−70+ 2980
ENTER enter (on the HP, puts the number on the stack)
Quick example
A reserve of 90 at a 30% tax rate adds 90 × 0.70 = 63 to equity on a FIFO basis.
- 1−0.3=×90= 63
- 1ENTER0.3−90× 63
ENTER enter (on the HP, puts the number on the stack)
Questions about this lesson?
Where this comes back
- Analysis of Income Taxes Financial Statement Analysis
- Financial Analysis Techniques Financial Statement Analysis
- Introduction to Financial Statement Modeling Financial Statement Analysis
Questions candidates ask
What is the effect of LIFO versus FIFO during inflation?
With rising costs and stable or growing quantities, LIFO gives higher cost of sales, so lower gross profit, net income, taxes, ending inventory and current ratio. Inventory turnover and operating cash flow are higher. Weighted average falls between. With falling costs every effect reverses.
Why does LIFO result in higher cash flow?
Higher cost of sales lowers taxable profit, so less tax is paid in cash. Operating cash flow rises by the tax saved, which is the cost of sales difference times the tax rate. Lower reported profit does not itself raise cash. The tax saving does.
How do you calculate weighted average cost of inventory?
Divide the total cost of goods available for sale (beginning inventory plus purchases) by the total units available. Multiply that average unit cost by units sold for cost of sales, and by units remaining for ending inventory. For example, 6,200 ÷ 500 units gives 12.40 a unit.
Is LIFO allowed under IFRS?
No. IFRS permits specific identification, FIFO and weighted average cost. LIFO is allowed only under US GAAP, so an analyst comparing a US LIFO company with an IFRS reporter often converts to FIFO using the LIFO reserve.
Spotted an error? Tell us and we will fix it.