Formula for stock valuation on fifo basis

If ure looking for how to value your stocks/ investments and gain/loss on FIFO basis in Excel, here is the spreadsheet with formula..


Attached File : 124200 1299695 fifo.xlsx downloaded: 1701 times
Replies (2)

You are a champion boss

Hi Punit,

Thanks much for sharing the file. I am not able to get the correct results with the file. Can I connect with you offline?

Thanks,

Pradeep

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 18 September 2026
Industrial Trainee

Twenty Point Nine Five Ventures Private Limited

Noida

CA Inter

View Details
Company
18 September 2026
Accounts & Finance Specialist

ULTRA CHEMICAL WORKS

Thane

CA Final

View Details
Company
Featured 03 October 2026
Accountant

A P Lodha and Associates

Jalna

B.Com

View Details
Company
Featured 21 September 2026
Consultant - Reporting

Finrep Advisors LLP

Mumbai

CA

View Details
Company
15 September 2026
Client-site CA associate

Aditya Muley and Co

Mumbai

CA

View Details
Company
20 September 2026
Semi Qualified CA

Navin & Associates

Mumbai

CA Inter

View Details
Company
22 September 2026
Account Assistant

Chirag P Shah & Co. Chartered Accountant

Pune

B.Com

View Details
Company
ARTICLESHIP 21 September 2026
CA Article Assistant

KK & Company Chartered Accountant

Pune

CA Inter

View Details