If you trade in shares, commodity and want to keep track of your trading profit or loss using FIFO method, here is an easy to use “FIFO Gain Excel Calculator” with Google Sheet version.
Besides showing FIFO Gain or Loss after every transaction, spreadsheet will also show you other important data e.g. Cumulative Cost of Inventory Purchased, Cumulative Earning from Sell of Inventory, Total Inventory Purchased, Total Inventory Sold, Inventory in Hand after every transaction.
Spreadsheet is ready to calculate FIFO gains up to 2000 transactions, which can easily be extended further by dragging the formulas as per your requirement.
Sheet automatically highlights the rows for Buy and Sell transactions in Green and Orange colors so user can easily identify a Buy or sell transaction.
You will just have to put your trading details i.e. Transaction Type (buy or sale), Date & Time of Transaction, Inventory Quantity in columns A to D and sheet will automatically calculate FIFO gains and other important data for every row. Columns P, Q, R and S contain formulas for calculating costs of Inventory sold in parts. These contain intermediate results. You may show or hide them as per your choice.
You can set trading fees for buy or sell transaction in 2 ways:
First method is to set a fixed percentage for all Buy and Sell transactions in cells B1 and B2. It will be used to fill amount of commission (in $) for each transaction in column F and remove values from column E.
In second method you can manually fill amount of variable commission (in $) for each transaction in column E. In that case, value in column F will NOT be used by sheet.
This tool is available at Eloquens.com marketplace or www.fifocalculator.com for USD $10 only. LIFO (Last in First Out) and Google Sheet versions are also available.
Please let me know if you have any question or suggestion to improve this template.
Submitted April 23, 2019 at 05:35AM by pksoni http://bit.ly/2Dr81c0
