FIFO valuation Calculation for Stocks

I’m looking for some help with understanding the best way to build a FIFO calculation method using excel.

Is there anyone who has developed either VBA code that can facilitate this or has built a spreadsheet using various functions to achieve the same result and willing to share it with me?

Thanks

HI CJD

do you need FIFO valuation only for closing stocks on the logic that the closing stock shall have valuation of latest receipts?


EM