# 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
###### Who is Participating?

Commented:
I fail to understand where you get your predicted values of 10, 40, 6, 66, 34. According to my workings, they should be 10, 40, 9, 69,40, and that is exactly what this formnula gives as well

=FIFO(B\$2:B3,C\$2:C3,D\$2:D3,\$E\$2,TRUE)
0

Commented:
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
0

Author Commented:
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...
0

Commented:
You seem to be missing the quantiuty in there. Can you post the workbook with these new numbers?
0

Author Commented:
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
0

Author Commented:
Sorry BobP, I made a mistake with the ranges in the formula. This is the right one!

FIFO-test-with-chrono.xls
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.