Link to home
Start Free TrialLog in
Avatar of MarioTorres
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
Avatar of BobP
BobP

I think it already caters for LIFO.

Put =B2*c2 in F2 and then in F3 add

=FIFO(B$2:B3,C$2:C3,D$2:D3,E3,TRUE)

and copy down
Avatar of MarioTorres

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...
You seem to be missing the quantiuty in there. Can you post the workbook with these new numbers?
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
Sorry BobP, I made a mistake with the ranges in the formula. This is the right one!

FIFO-test-with-chrono.xls
ASKER CERTIFIED SOLUTION
Avatar of BobP
BobP

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial