Comerze › Blogs › Accounting & Finance Basics

Inventory Valuation: FIFO and Weighted Average, With Numbers

The same stock can show two different profits. The cost formula is the reason.

By Comerze DeskUpdated 18 November4 min read

Reviewed by Comerze Desk

The two formulas

FIFO assumes the oldest units are sold first, so closing stock carries the latest prices. Weighted average divides the total cost of goods available by the number of units to arrive at one average cost.

A worked example

A trader buys 10 units at Rs 100 and then 10 units at Rs 120, and sells 12 units.

MethodCost of goods sold (Rs)Closing stock (Rs)
FIFO1,240960
Weighted average1,320880

FIFO: 10 × 100 + 2 × 120 = 1,240, leaving 8 units at 120. Weighted average: (1,000 + 1,200) / 20 = Rs 110 per unit, so cost of goods sold is 12 × 110 = 1,320 and closing stock is 8 × 110 = 880. Both methods account for the same Rs 2,200 in total.

When prices are rising, FIFO shows the lower cost of goods sold and therefore the higher profit.

Lower of cost and net realisable value

Whichever formula is used, stock is not carried above what it can be sold for. Net realisable value is the estimated selling price less the estimated costs to complete and sell. If it is below cost, the stock is written down.

Why LIFO is not used

LIFO assumes the latest purchases are sold first, which leaves old costs in closing stock. The Indian standards on inventories permit specific identification for items that are not interchangeable, and FIFO or weighted average for the rest, so LIFO is not an option for companies following them.

Pro tipBe consistent

Use the same formula for stock of a similar nature and use it from year to year, so that profits are comparable.

FAQs

Which method gives a higher profit when prices rise?

FIFO, because the older and cheaper units are charged to cost of goods sold.

Can a business use different formulas for different items?

Yes, for inventories that differ in nature or use, but similar items should use the same formula.

Does the formula change the total cost?

No. Over the life of the stock the total cost is the same. The methods differ in the timing of when it reaches the profit and loss account.

Keep reading

Tools & courses for CA studentsMarketplace