Analysis of Inventories

Inventory is where the income statement and balance sheet meet most directly: the cost flow assumption you choose (FIFO, LIFO, or weighted average) simultaneously determines COGS on the income statement and ending inventory on the balance sheet. This topic covers the lower-of-cost-and-net-realizable-value rule, the financial statement impacts of different inventory methods under inflation and deflation, and the critical LIFO reserve adjustment needed for cross-company comparison. In DeFi, inventory concepts map to liquidity pool positions and treasury management, where impermanent loss functions as a form of continuous inventory impairment.

Learning Objectives Coverage

LO1: Describe the measurement of inventory at the lower of cost and net realisable value and its implications for financial statements and ratios

Core Concept accounting exam-focus

Lower of cost and net realizable value (LCNRV) requires inventory to be reported at the lower of its historical cost or NRV (estimated selling price less costs to complete and sell), ensuring conservatism in asset valuation. This rule prevents overstatement of assets and income by immediately recognizing losses when inventory value declines, which directly affects profitability, working capital ratios, and trend analysis. Key components include cost basis determination, NRV calculation, write-down recognition, and the important distinction that IFRS allows write-down reversals while GAAP does not.

Formulas & Calculations formula ratio-analysis

Net Realizable Value (NRV):
- NRV = Estimated selling price - Costs to complete - Costs to sell
- Write-down = Cost - NRV (if Cost > NRV)
Impact on ratios (see also Balance Sheet ratios):
- Gross margin decreases (higher COGS)
- Inventory turnover increases (lower inventory base)
- Current ratio decreases (lower current assets)
HP 12C steps (for NRV):
- [Selling price] ENTER
- [Completion costs] -
- [Selling costs] -
Common variations: IFRS allows reversals up to original cost, GAAP does not

Practical Examples

Traditional Finance Example: Target’s 2022 inventory markdown
- Excess inventory cost: $15B
- Market value decline: 20% on discretionary items
- Write-down: $3B to NRV
- Impact: Gross margin fell 600 bps, stock dropped 25%
- Inventory turnover improved artificially (lower base)
Calculation walkthrough: Electronics retailer write-down
- TV inventory cost: $1 M (1, 000 u ni t s @$ 1,000)
- Current market price: $850 per unit
- Selling costs: $50 per unit
- NRV = $850 -$ 50 = $800 per unit
- Write-down = ( $1, 000 -$ 800) × 1,000 = $200,000
- Journal entry: Dr. COGS $200 K, C r . I n v e n t ory$ 200K
Interpretation: 20% value destruction recognized immediately

DeFi Application defi-application

Liquidity pool impairment during a market crash provides a compelling LCNRV parallel. Consider an LP position in an ETH/USDC pool on Uniswap:

LP tokens cost basis: $1M
Current value after 50% ETH drop: $750K
Impermanent loss: additional 5% = $37.5K
NRV equivalent: $712.5K
Write-down needed: $287.5K (28.75% loss)

Unlike traditional inventory, which is tested periodically, DeFi LP positions are subject to continuous mark-to-market through on-chain oracle pricing. This creates real-time “LCNRV testing” but also introduces significant noise from short-term volatility that would not trigger write-downs in a quarterly reporting cycle.

LO2: Calculate and explain how inflation and deflation of inventory costs affect the financial statements and ratios of companies that use different inventory valuation methods

Core Concept accounting exam-focus

FIFO, LIFO, and weighted-average methods produce materially different financial results during inflation and deflation, affecting reported profits, taxes, and balance sheet values. This is one of the most heavily tested areas on the Finance Certification 1 exam. LIFO reduces taxes in inflationary periods but understates inventory value; FIFO shows current inventory value but overstates profits. The LIFO reserve — the cumulative difference between FIFO and LIFO inventory — is the critical adjustment variable for cross-company comparison. Remember: LIFO is prohibited under IFRS, making this primarily a US GAAP concern.

Formulas & Calculations formula

FIFO (First-In, First-Out):
- COGS = Oldest costs
- Ending Inventory = Newest costs
- In inflation: Lower COGS, Higher NI, Higher inventory
LIFO (Last-In, First-Out):
- COGS = Newest costs
- Ending Inventory = Oldest costs
- In inflation: Higher COGS, Lower NI, Lower inventory
LIFO Reserve:
- LIFO Reserve = FIFO Inventory - LIFO Inventory
- FIFO COGS = LIFO COGS - Δ LIFO Reserve
Weighted Average:
- Unit cost = Total cost / Total units
- Falls between FIFO and LIFO results
HP 12C steps (for weighted average):
- [Total cost] ENTER
- [Total units] ÷
Common variations: Perpetual vs. periodic systems

Practical Examples

Traditional Finance Example: ExxonMobil LIFO benefits during inflation
- 2022 oil price surge: 50% increase
- LIFO COGS: $280B (current high prices)
- FIFO COGS (estimated): $250B (older low prices)
- Tax savings: ( $280 B -$ 250B) × 21% = $6.3B
- LIFO reserve disclosed: $21B accumulated benefit
- Balance sheet inventory understated by $21B
Calculation walkthrough: Three-method comparison
- Beginning: 100 units @ $10 =$ 1,000
- Purchase 1: 100 units @ $12 =$ 1,200
- Purchase 2: 100 units @ $15 =$ 1,500
- Sold: 150 units
- FIFO COGS: (100× $10) + (50 \times$ 12) = $1,600
- LIFO COGS: (100× $15) + (50 \times$ 12) = $2,100
- Average: 150 × ( $3, 700/300) =$ 1,850
- Gross profit difference: $500 (31% variance)
Interpretation: Method choice creates 31% profit variance

DeFi Application

Protocol example: AMM pool token accounting during volatility
Implementation:
- First deposit: 10 ETH @ $1, 000 =$ 10,000
- Second deposit: 10 ETH @ $2, 000 =$ 20,000
- Third deposit: 10 ETH @ $1, 500 =$ 15,000
- Withdrawal: 15 ETH
- FIFO basis: $10, 000 + (5 \times$ 2,000) = $20,000 cost
- LIFO basis: $15, 000 + (5 \times$ 2,000) = $25,000 cost
- Tax implications vary by $5,000 cost basis
Advantages/Challenges: User choice of method vs. protocol default tracking

LO3: Describe the presentation and disclosures relating to inventories and explain issues that analysts should consider when examining a company’s inventory disclosures and other sources of information

Core Concept

Inventory disclosures reveal valuation methods, carrying amounts by category, LCNRV write-downs, and critical information like LIFO reserves needed for cross-company comparison. These disclosures enable adjustment for method differences, quality assessment, obsolescence risk evaluation, and detection of earnings management through inventory builds. Key components include method disclosure, category breakdown (raw materials, work-in-process, finished goods), write-down amounts, LIFO reserve, inventory financing, consignment goods, and pledged inventory. This connects directly to the importance of footnotes discussed in the FSA framework.

Formulas & Calculations

Key analytical adjustments:
- Convert LIFO to FIFO: Add LIFO reserve to inventory
- Adjust COGS: FIFO COGS = LIFO COGS - Δ LIFO Reserve
- Adjust taxes: Tax effect = Δ LIFO Reserve × Tax rate
- Days Inventory Outstanding: 365 / Inventory turnover
Quality indicators:
- Inventory/Revenue trend (building inventory = red flag)
- Gross margin trends with inventory changes
- Obsolescence reserves/Total inventory
HP 12C steps (for DIO):
- 365 ENTER
- [Inventory turnover] ÷
Common variations: Industry-specific metrics (retail: GMROI)

Practical Examples

Traditional Finance Example: Tesla’s 2022 inventory disclosure analysis
- Raw materials: $8.3B (chips, batteries)
- Work in process: $1.8B (partially built cars)
- Finished goods: $3.7B (completed vehicles)
- Total: $13.8B (87% increase YoY)
- Days inventory: 68 days (improved from 78)
- No LIFO reserve (uses FIFO)
- Write-downs: $142M (1% of inventory)
- Analysis: Rapid growth but improving efficiency
Calculation walkthrough: Detecting earnings management
- Q1: Inventory $100 M, R e v e n u e$ 500M (20% ratio)
- Q2: Inventory $120 M, R e v e n u e$ 510M (23.5% ratio)
- Q3: Inventory $150 M, R e v e n u e$ 520M (28.8% ratio)
- Q4: Inventory $180 M, R e v e n u e$ 530M (34% ratio)
- Trend: Inventory growing faster than sales
- Red flag: Potential channel stuffing or demand issues
Interpretation: Rising inventory/sales ratio signals problems

DeFi Application

Protocol example: Comprehensive treasury disclosure standards
Implementation:
- Token composition: ETH 40%, Stables 30%, Protocol tokens 30%
- Valuation method: Mark-to-market using Chainlink oracles
- Liquidity analysis: 70% liquid within 24 hours
- Concentration risk: Top 3 holdings = 75% of value
- Impairment: 15% unrealized loss on protocol tokens
- On-chain transparency but lacks standardization
Advantages/Challenges: Real-time visibility vs. no regulatory framework

Core Concepts Summary (80/20 Principle)

Must-Know Concepts

LCNRV: Inventory written down when NRV < Cost, impacts margins and ratios
FIFO in inflation: Lower COGS, higher profits, current inventory values
LIFO in inflation: Higher COGS, lower taxes, outdated inventory values
LIFO reserve: Difference between FIFO and LIFO inventory, key for comparison
Inventory/Sales ratio: Rising ratio indicates potential problems

Quick Reference Table

Concept	Impact in Inflation	Key Metric	DeFi Equivalent
FIFO	Higher NI, Higher tax	Current inventory value	Recent price basis
LIFO	Lower NI, Lower tax	Tax savings	Older price basis
LCNRV	Write-downs likely	Gross margin impact	Impermanent loss
LIFO Reserve	Increases	Adjustment needed	Basis tracking
Disclosure	Method critical	Comparability	Treasury composition

Comprehensive Formula Sheet formula

Essential Formulas

Net Realizable Value (NRV):
NRV = Estimated Selling Price - Costs to Complete - Costs to Sell
Where: Used for LCNRV test
Used for: Inventory impairment testing

LCNRV Write-down:
Write-down = Cost - NRV (if Cost > NRV)
Where: Reduces inventory and increases COGS
Used for: Conservative valuation

FIFO Cost Flow:
COGS = Oldest inventory costs first
Ending Inventory = Most recent costs
Where: Matches physical flow for most goods
Used for: Current balance sheet values

LIFO Cost Flow:
COGS = Newest inventory costs first
Ending Inventory = Oldest costs
Where: Better matches current costs to revenue
Used for: Tax minimization in inflation

Weighted Average Cost:
Unit Cost = Total Cost Available / Total Units Available
COGS = Units Sold × Average Unit Cost
Where: Smooths cost fluctuations
Used for: Simplicity and objectivity

LIFO Reserve:
LIFO Reserve = FIFO Inventory - LIFO Inventory
Where: Cumulative difference between methods
Used for: Converting LIFO to FIFO

LIFO to FIFO Conversion:
FIFO Inventory = LIFO Inventory + LIFO Reserve
FIFO COGS = LIFO COGS - Change in LIFO Reserve
FIFO Net Income = LIFO NI + Change in LIFO Reserve × (1 - Tax Rate)
Used for: Cross-company comparison

Inventory Turnover:
Inventory Turnover = COGS / Average Inventory
Where: Measures inventory efficiency
Used for: Working capital analysis

Days Inventory Outstanding (DIO):
DIO = 365 / Inventory Turnover
Alternative: (Ending Inventory / COGS) × 365
Where: Days to sell inventory
Used for: Cash cycle analysis

Gross Margin Impact:
GM% Change = Write-down Amount / Revenue
Where: Measures profitability impact
Used for: Earnings quality assessment

HP 12C Calculator Sequences

NRV Calculation:
RPN Steps: [Selling Price] ENTER, [Completion Cost] -, [Selling Cost] -
Example: 1000 ENTER, 100 -, 50 - = 850

LCNRV Write-down:
RPN Steps: [Cost] ENTER, [NRV] -, 0, x≤y? (if positive, write down)
Example: 1000 ENTER, 850 -, = 150 write-down

Weighted Average Cost:
RPN Steps: [Total Cost] ENTER, [Total Units] ÷
Example: 37000 ENTER, 300 ÷ = 123.33 per unit

FIFO COGS (Simple):
RPN Steps: [Old Units] ENTER, [Old Price] ×, [New Units] ENTER, [New Price] ×, +
Example: 100 ENTER, 10 ×, 50 ENTER, 12 ×, + = 1600

LIFO Reserve Adjustment:
RPN Steps: [LIFO Inventory] ENTER, [LIFO Reserve] +
Example: 5000000 ENTER, 1200000 + = 6,200,000 FIFO inventory

Inventory Turnover:
RPN Steps: [COGS] ENTER, [Average Inventory] ÷
Example: 8000000 ENTER, 2000000 ÷ = 4.0 times

Days Inventory Outstanding:
RPN Steps: 365 ENTER, [Inventory Turnover] ÷
Example: 365 ENTER, 4 ÷ = 91.25 days

Tax Effect of LIFO:
RPN Steps: [LIFO Reserve Change] ENTER, [Tax Rate] ×
Example: 500000 ENTER, 0.21 × = 105,000 tax savings

Practice Problems

Basic Level (Understanding)

Problem: Calculate LCNRV write-down
- Given: Inventory cost $50, 000, M a r k e tp r i ce$ 45,000, Selling costs $3,000
- Find: Required write-down
- Solution:
  - NRV = $45, 000 -$ 3,000 = $42,000
  - Write-down = $50, 000 -$ 42,000 = $8,000
  - Journal: Dr. COGS $8, 000, C r . I n v e n t ory$ 8,000
- Answer: Write down $8,000, reducing gross margin
Problem: Compare FIFO vs LIFO in inflation
- Given: Beginning 100 @ $10, P u rc ha se 100@$ 15, Sold 120 units
- Find: COGS under each method
- Solution:
  - FIFO: (100 × $10) + (20 \times$ 15) = $1,300
  - LIFO: (100 × $15) + (20 \times$ 10) = $1,700
  - Difference: $400 higher COGS under LIFO
- Answer: LIFO COGS $400 higher, reducing taxable income

Intermediate Level (Application)

Problem: Convert LIFO company to FIFO for comparison
- Given:
  - LIFO Inventory: $10M
  - LIFO Reserve: $3M
  - LIFO COGS: $50M
  - LIFO Reserve increased $500K this year
  - Tax rate: 25%
- Find: FIFO inventory, COGS, and after-tax income adjustment
- Solution:
  - FIFO Inventory = $10 M +$ 3M = $13M
  - FIFO COGS = $50 M -$ 500K = $49.5M
  - Pre-tax income increase = $500K
  - After-tax adjustment = $500 K \times (1 - 0.25) =$ 375K
- Answer: FIFO shows $13 M in v e n t ory,$ 375K higher net income
Problem: Analyze inventory quality from disclosures
- Given (Quarterly progression):
  - Q1: Inventory $100 M, S a l es$ 400M, GM 40%
  - Q2: Inventory $130 M, S a l es$ 420M, GM 38%
  - Q3: Inventory $170 M, S a l es$ 430M, GM 35%
  - Q4: Inventory $200 M, S a l es$ 440M, GM 33%
- Find: Warning signs and interpretation
- Solution:
  - Inventory growth: 100% (Q1 to Q4)
  - Sales growth: 10% (Q1 to Q4)
  - Inventory/Sales: 25% → 45% (deteriorating)
  - Gross margin: Declining 700 bps
  - DIO: Likely increasing significantly
- Answer: Major red flags—inventory buildup, margin pressure, possible obsolescence

Advanced Level (Analysis)

Problem: Multi-year LIFO layer liquidation analysis
- Given:
  - Current year LIFO inventory: $5M
  - LIFO layers: 2020 ( $2 M @$ 50), 2021 ( $2 M @$ 60), 2022 ( $1 M @$ 80)
  - Current replacement cost: $100/unit
  - Sold old layers this year, LIFO reserve decreased $1M
- Find: Impact on current year margins and future implications
- Solution:
  - Layer liquidation created artificial profit
  - COGS understated by approx $1M (reserve decrease)
  - Gross margin inflated by $1M/Revenue
  - Future COGS will be higher (must replace at $100)
  - Earnings quality issue: One-time unsustainable benefit
- Answer: Current earnings inflated by $1M, future margins will compress
Problem: DeFi liquidity pool position analysis
- Given:
  - Initial: 100 ETH @ $1,000, 100,000 USDC (1:1000 ratio)
  - After volatility: 71 ETH, 141,421 USDC (1:2000 ratio)
  - Current ETH price: $2,000
  - Gas fees paid: $5,000 total
- Find: Total return using FIFO cost basis
- Solution:
  - Initial investment: $200,000 (100 ETH + 100K USDC)
  - Current value: (71 × $2, 000) +$ 141,421 = $283,421
  - Impermanent loss vs HODL: ~$16,579
  - Fees earned: Difference + IL = ~$100,000
  - Net after gas: $283, 421 -$ 200,000 - $5, 000 =$ 78,421
  - Return: 39.2% despite impermanent loss
- Answer: 39.2% return, but would be 50% if just held

DeFi Applications & Real-World Examples

Traditional Finance Context

Institution Example: Walmart’s inventory management—6x turnover using FIFO, real-time tracking reduces obsolescence
Market Application: Oil companies’ LIFO benefits—Chevron saved $4B in taxes over decade using LIFO during oil price increases
Historical Case: Cisco’s 2001 inventory write-down—$2.2B charge for obsolete networking equipment crashed stock 80%

DeFi Parallels defi-application

Uniswap V3 position management maps surprisingly well onto inventory concepts:

Concentrated liquidity = inventory deployed at specific price ranges
Range orders = limit orders using token “inventory”
Rebalancing = inventory management and turnover optimization
Fee tier selection = margin optimization (analogous to product mix decisions)

Smart Contract Logic:

function calculatePositionValue() view returns (uint256) {
  uint256 token0Value = token0Amount * token0Price;
  uint256 token1Value = token1Amount * token1Price;
  uint256 totalValue = token0Value + token1Value;
  
  // Impairment check (similar to LCNRV)
  if (totalValue < initialInvestment) {
    uint256 impairment = initialInvestment - totalValue;
    // Record unrealized loss
  }
  return totalValue;
}

Advantages: Continuous mark-to-market, no accounting method games
Limitations: Impermanent loss not traditionally accounted, high volatility

Case Studies

Case 1: Target’s 2022 inventory crisis
- Background: Over-ordered during supply chain crisis
- Analysis:
  - Inventory increased 43% YoY to $15B
  - Sales increased only 3%
  - Forced markdowns: $1.5 B in Q 2,$ 400M in Q3
  - Gross margin fell from 30% to 24%
- Outcomes: Stock fell 35%, CEO admitted ordering mistakes
- Lessons learned: Inventory buildup signals demand-supply mismatch
Case 2: LUNA/UST inventory in Anchor Protocol
- Background: Protocol held UST reserves as “inventory”
- Analysis:
  - UST “inventory”: $14B at peak
  - Yield reserve: $450M (working capital)
  - When UST depegged: NRV went to ~$0
  - No gradual write-downs, instant total loss
- Outcomes: $14B vaporized in 48 hours
- Lessons learned: Stablecoin “inventory” has binary risk profile

Common Pitfalls & Exam Tips

Frequent Mistakes

Mistake 1: Forgetting LIFO is prohibited under IFRS—only US GAAP allows it
Mistake 2: Not adjusting for LIFO reserve when comparing companies—add reserve to inventory, subtract change from COGS
Mistake 3: Ignoring tax effects of LIFO/FIFO differences—LIFO saves taxes in inflation

Exam Strategy

Time management: 5-7 minutes for inventory method problems
Question patterns:
- “Calculate ending inventory” under FIFO/LIFO/Average
- “Adjust for LIFO reserve” for comparison
- “Impact of inflation” on methods
Quick checks:
- Inflation: FIFO > LIFO for income and inventory
- LCNRV: Always conservative (lower value)
- LIFO reserve: Positive in inflation, add to convert to FIFO

Key Takeaways

Essential Points

✓ LCNRV requires immediate write-down when NRV < Cost, impacting margins and ratios ✓ FIFO in inflation: Lower COGS, higher taxes, current inventory values on balance sheet ✓ LIFO in inflation: Higher COGS, lower taxes, outdated inventory values (US GAAP only) ✓ LIFO reserve critical for converting between methods and comparing companies ✓ Rising inventory/sales ratio and declining margins signal potential obsolescence issues

Memory Aids

Mnemonic: “FIFO = First In Still Fresh” (current values), “LIFO = Last In Saves Taxes” (inflation benefit)
Visual: Cost flow waterfall—FIFO from top (old), LIFO from bottom (new)
Analogy: FIFO like FIFO lane at grocery (old milk first), LIFO like stack of plates (top first)

Cross-References & Additional Resources

Prerequisite: Income Statements for COGS impact on margins
Related: Balance Sheets for working capital and current ratio effects
See also: Long-Term Assets for parallel concepts in fixed asset accounting
Applied: Cash Flow Analysis — inventory changes drive working capital adjustments in the indirect method

Source Materials

Primary Reading: Volume 4, Learning Module 6, Pages 235-268
Key Sections:
- Section 2: Inventory Valuation Methods (pp. 237-248)
- Section 3: LCNRV Application (pp. 249-255)
- Section 4: Presentation and Disclosure (pp. 256-265)
Practice Questions: End-of-reading problems 1-20, focus on 6, 11, 15, 19

External Resources

Videos: “Inventory Accounting Methods” by Edspira (YouTube, 30 min)
Articles: “LIFO vs FIFO in Inflationary Times” - Journal of Accountancy
Tools:
- LIFO/FIFO calculator on AccountingCoach
- DeFi position trackers (Revert Finance, APY.vision)
- Inventory analysis templates on CFI

Review Checklist

Before moving on, ensure you can:

Home

Explorer

Analysis of Inventories

Analysis of Inventories

Learning Objectives Coverage

LO1: Describe the measurement of inventory at the lower of cost and net realisable value and its implications for financial statements and ratios

Core Concept accounting exam-focus

Formulas & Calculations formula ratio-analysis

Practical Examples

DeFi Application defi-application

LO2: Calculate and explain how inflation and deflation of inventory costs affect the financial statements and ratios of companies that use different inventory valuation methods

Core Concept accounting exam-focus

Formulas & Calculations formula

Practical Examples

DeFi Application

LO3: Describe the presentation and disclosures relating to inventories and explain issues that analysts should consider when examining a company’s inventory disclosures and other sources of information

Core Concept

Formulas & Calculations

Practical Examples

DeFi Application

Core Concepts Summary (80/20 Principle)

Must-Know Concepts

Quick Reference Table

Comprehensive Formula Sheet formula

Essential Formulas

HP 12C Calculator Sequences

Practice Problems

Basic Level (Understanding)

Intermediate Level (Application)

Advanced Level (Analysis)

DeFi Applications & Real-World Examples

Traditional Finance Context

DeFi Parallels defi-application

Case Studies

Common Pitfalls & Exam Tips

Frequent Mistakes

Exam Strategy

Key Takeaways

Essential Points

Memory Aids

Cross-References & Additional Resources

Related Topics

Source Materials

External Resources

Review Checklist

Graph View

Table of Contents

Backlinks