- Income Statement
- Formats of Income Statements
- Principles of Revenue Recognition
- Revenue Recognition - Long-term Contracts
- Revenue Recognition - Instalment Sales
- Revenue Recognition - Barter Transactions
- Expense Recognition
- Inventory Expense Recognition
- Depreciation Expense Recognition
- Amortization Expense Recognition
- Bad Debt Expense and Warranty Expense Recognition
- Financial Reporting of Non-recurring Items
- Operating and Non-operating Components of Income Statement
- How to Calculate Basic Earnings Per Share (EPS)
- Impact of Stock Dividends and Stock Splits on Earnings Per Share (EPS)
- Diluted EPS
- Calculation of Diluted EPS (Convertible Preferred Stock)
- Calculation of Diluted EPS (Convertible Debt)
- Common Size Income Statement
- Performance Measures of a Company
- Comprehensive Income
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
Related Downloads
Related Quizzes
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 includes PDFs, explanations, instructions, data files, and R code for all examples.
Get the Bundle for $39 (Regular $57)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.