LIVE GST Audit Course by CA Sachin Jain. Register Now!!

Calculating FIFO in Excel

Shravan (service) (95 Points)

30 December 2008

I have made an Excel sheet for calculating profit from investment in shares on FIFO basis.

I am attaching the demo sheet to explain the requirements

However, if the quantities of sale and purchase are different, then I have to manually split the purchase quantities to match the sale quantities.

Mr. Shailesh has made and posted an excel sheet solution but it is in a different format.

I shall be grateful if the members can look at my excel sheet and suggest a solution for automation

Thanks

Reply
Follow
Share

9 Replies

(Guest)

thanks yaar i need for this

1 Like

CA Tilak Raj Sharma (Practising CA in Solan (H.P.)) (6374 Points)
Replied 30 December 2008

Thanks, it will help those who are not expert in excel

Saurabh Gupta (CA in Practice) (538 Points)
Replied 31 March 2010

The attached file computes profit for a single scriptt as per FIFO method. You are just required to punc in your trasactions and file will compute your profits

https://tech.dir.groups.yahoo.com/group/FMwithExcel/message/20

Attached File : 23 fifo.xls downloaded: 2546 times

Alex Groban ( ) (21 Points)
Replied 15 February 2011

Hi everybody,

No XLS need! Try https://stockfo.com and calculating as FIFO, LIFO and HIFO methods online.

Ok ok you need xls for upload transactions :)

Aman Aggarwal (Audit & Finance Manager) (62 Points)
Replied 11 June 2011

Originally posted by : Saurabh Gupta
	The attached file computes profit for a single scripttt as per FIFO method. You are just required to punc in your trasactions and file will compute your profits https://tech.dir.groups.yahoo.com/group/FMwithExcel/message/20