Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

LIFO Valuation in Excel

Posted on 2009-05-18
8
Medium Priority
?
5,186 Views
Last Modified: 2012-05-07
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
0
Comment
Question by:MarioTorres
  • 3
  • 3
6 Comments
 
LVL 4

Expert Comment

by:BobP
ID: 24413683
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 Comment

by:MarioTorres
ID: 24413977
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
 
LVL 4

Expert Comment

by:BobP
ID: 24414506
You seem to be missing the quantiuty in there. Can you post the workbook with these new numbers?
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

Author Comment

by:MarioTorres
ID: 24414726
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 Comment

by:MarioTorres
ID: 24414767
Sorry BobP, I made a mistake with the ranges in the formula. This is the right one!

FIFO-test-with-chrono.xls
0
 
LVL 4

Accepted Solution

by:
BobP earned 1000 total points
ID: 24420078
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question