# Inventory Expense Recognition

Inventory refers to the short-term assets on a company’s balance sheet; example – a retail clothier’s stock of shirts, pants, etc.

The expense for inventory is a part of the cost of goods sold. The flow of inventory costs into the accounting system is determined based on the inventory accounting policy, not the physical flow of goods.

The commonly used methods are:

• Specific cost identification
• First-in, first-out (FIFO)
• Last-in, first-out (LIFO)
• Average cost

### Specific Cost Identification

This method is used when the company can identify exactly which items were sold and which ones are still in the inventory. For example, a laptop dealer sells his inventory of laptops based on their serial number.

### FIFO

First-in, first-out accounting method, where the costs of the oldest items in inventory are used to compute the cost of goods sold (COGS) expense on a company’s income statement.

FIFO ending inventory for the balance sheet is calculated based on values of the most recent inventory goods purchased.

### LIFO

Last-in, first-out accounting method, where the costs of the newest inventory items are used to compute the COGS expense on the income statement.

LIFO ending inventory for the balance sheet is calculated based on values of the first inventory goods purchased.

### Average Cost

Under the weighted average cost method, average cost is calculated by dividing the total cost of available goods with the no. of units available. The average cost is used to determine both the cost of goods sold and the ending inventory.

In some instances, the choice of LIFO or FIFO makes intuitive sense for a specific company.  A farmer’s market shop would conceptually be a FIFO business, as the oldest produce should be sold first, given that it will spoil the soonest compared to younger produce.

In reality a company’s management is usually allowed some degree of flexibility in determining its inventory accounting method.  If an analyst is comparing firms in a shared industry structure or market capitalization size, then differences in inventory accounting methods need to be reconciled through the financial statement adjustment process, so the analyst can be sure that the financial ratios for the firms are truly comparable.

The US GAAP permits the use of FIFO, LIFO as well as average cost method.

IFRS allows FIFO and average cost but prohibits LIFO method.

### COGS Expense Calculation

Beginning Inventory (BI) + Purchases = Goods Available for Sale (GAS)

GAS – Ending Inventory (EI) = COGS

COGS is used in calculating a company’s gross profit and gross profit margin (the decimal is typically converted to a percentage)

Gross Profit = Net Revenue – COGS

### Example

A company’s inventory data during a month are shown in the table below:

 Date Inventory Cost April 1 (Beginning inventory) 10 units @ $100 per unit$1,000 April 10 (Purchases) 5 units @ $120 per unit$600 April 20 (Purchases) 5 units @ $130 per unit$650 Total 20 units $2,250 During the month the company sold, 17 units. Let’s calculate the cost of goods sold and ending inventory under different methods. First-in, First-out (FIFO) Total 17 units are sold. The earlier units are sold first.  Beginning inventory 10 units @$100 per unit $1,000 April 10 (Purchases) 5 units @$120 per unit $600 April 20 (Purchases) 2 units @$130 per unit $260 FIFO Cost of Goods Sold 17 Units$1,860 Ending inventory 3 units =(2250 – 1860) = $390 Last-in, First-out (FIFO) Total 17 units are sold. The recently purchased units are sold first.  April 20 (Purchases) 5 units @$130 per unit $650 April 10 (Purchases) 5 units @$120 per unit $600 Beginning inventory 7 units @$100 per unit $700 FIFO Cost of Goods Sold 17 Units$1,950 Ending inventory 3 units =(2250 – 1950) = $300 Average Cost Average cost per unit = 2250/20 =$112.5

Cost of goods sold = 112.5*17 = $1,912.5 Ending Inventory = 112.5*3 =$337.5

### You may find these interesting

#### Related Quizzes

Understanding Income Statements
Accelerate your finance career with cutting-edge data skills.
Join Finance Train Premium for unlimited access to a growing library of ebooks, projects and code examples covering financial modeling, data analysis, data science, machine learning, algorithmic trading strategies, and more applied to real-world finance scenarios.
I WANT TO JOIN
JOIN 30,000 DATA PROFESSIONALS

## Free Guides - Getting Started with R and Python

Enter your name and email address below and we will email you the guides for R programming and Python.

# Data Science in Finance: 9-Book Bundle

Master R and Python for financial data science with our comprehensive bundle of 9 ebooks.

## What's Included:

• Getting Started with R
• R Programming for Data Science
• Data Visualization with R
• Financial Time Series Analysis with R
• Quantitative Trading Strategies with R
• Derivatives with R
• Credit Risk Modelling With R
• Python for Data Science
• Machine Learning in Finance using Python

Each book comes with PDFs, detailed explanations, step-by-step instructions, data files, and complete downloadable R code for all examples.