MarioTorres
asked on
LIFO Valuation in Excel
Hi everyboydy, I found in this amazing web page a solution from Rory to value inventories using FIFO method. I´m having a hard time trying to adapt it to LIFO. Any one can help me?
I´m attaching the original spreadsheet for the FIFO valuation.
Thank you!
FIFO-test-with-chrono.xls
I´m attaching the original spreadsheet for the FIFO valuation.
Thank you!
FIFO-test-with-chrono.xls
ASKER
Thank you BobP, but it doesnt solve the problem....
I have the following data:
datePurchased Price Sold Start Inventory FIFO LIFO
26/08/2002 5 2 0 0 10 10
27/08/2002 10 3 0 40 40
28/08/2002 0 0 12 9 6
30/08/2002 15 4 0 69 66
31/08/2002 0 0 8 40 34
But your solution doesnt give me the right LIFO...
Than you for your interest!! Im still trying to get it right...
I have the following data:
datePurchased Price Sold Start Inventory FIFO LIFO
26/08/2002 5 2 0 0 10 10
27/08/2002 10 3 0 40 40
28/08/2002 0 0 12 9 6
30/08/2002 15 4 0 69 66
31/08/2002 0 0 8 40 34
But your solution doesnt give me the right LIFO...
Than you for your interest!! Im still trying to get it right...
You seem to be missing the quantiuty in there. Can you post the workbook with these new numbers?
ASKER
Thank you very much for your help BobP.! Im attaching the file with the numbers and the LIFO column which I want to get to.
Best!
FIFO-test-with-chrono.xls
Best!
FIFO-test-with-chrono.xls
ASKER
Sorry BobP, I made a mistake with the ranges in the formula. This is the right one!
FIFO-test-with-chrono.xls
FIFO-test-with-chrono.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Put =B2*c2 in F2 and then in F3 add
=FIFO(B$2:B3,C$2:C3,D$2:D3
and copy down