Inventory Valuation - Microsoft Corporation

Microsoft Corporation is a leading technology company. For the fiscal year ended June 30, 2023, they reported the following inventory data:

• Beginning inventory: $10,000 million
• Purchases during the year: $25,000 million
• Sales during the year: $35,000 million
• Ending inventory consists of 400,000 units

Calculate the value of ending inventory using the following methods for Microsoft Corporation:

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.