Inventory Valuation - Home Depot, Inc.

Home Depot, Inc. is a home improvement retailer. For the fiscal year ended January 31, 2023, they reported the following inventory data:

• Beginning inventory: $40,200 million
• Purchases during the year: $150,900 million
• Sales during the year: $280,600 million
• Ending inventory consists of 130,000 units

Calculate the value of ending inventory using the following methods for Home Depot, Inc.:

a) First-In-First-Out (FIFO) b) Last-In-First-Out (LIFO) c) Weighted Average

Assume that the cost of each unit of inventory remained constant throughout the year.