Inventory Valuation Model - FIFO Method of Valuing Inventory

Allows to know the transactional breakup of Closing Stock after considering sales made for that period.

by Rahim Damani - Excel Expert
Financial Modeling ExpertFollow 22

5 reviews406 views|Start the discussion!|Bookmark download for free

Description
Companies operating on the principle of first in, first out value inventory on the assumption that the first goods purchased for resale become the first goods sold. In some cases, this may not be true, as some companies stock both new and old items.

Due to the fluctuations of the economy and the risk that the cost of producing goods will rise over time, businesses using FIFO are considered more profitable – at least on paper. For example, a grocery store purchases milk at regular intervals to stock its shelves. As customers purchase milk, the stockers push the oldest product to the front of the fridge and replace newer milk behind those cartons. The cartons of milk with the nearest expiration dates are thus the ones first sold, whereas the cartons with the later expiration dates are sold after the older ones. This process ensures that older products are sold before they perish or become obsolete, thereby avoiding lost profit.

Companies that sell perishable products or units subject to obsolescence, such as food products or designer fashions, commonly follow the FIFO method of inventory valuation.

Model Mechanis:

Model allows to know the breakup of Closing Inventory at transactional level considering Sales made in the period as per FIFO Method. It lets you know what is the Rate used for COST OF GOODS SOLD and what is the rate used for CLOSING INVENTORY

This Best Practice includes
1 Excel Template