Results 1 to 6 of 6

First in First out (FIFO) accounting for equity trade's book cost

Threaded View

  1. #1
    Registered User
    Join Date
    04-10-2008
    Posts
    29

    First in First out (FIFO) accounting for equity trade's book cost

    Hi,

    I have a number of equity trades (both purchase and sales). I need to know the book cost of those sale trades to figure out the realized gain/loss according to First-in-first-out method.

    Since the unit sold may included units bought at different time and different price, so I have to first exhaust the first lot that I purchase before moving into second lot, and so on and so for.

    Column G - J are for illustration.
    I highlighted K10, K11 and K12 are book cost that I want to calculate. Instead of manually separating out units in each lot previously bought. Is there an automatic way? I would not mind adding new columns to ease calculation. Thanks.
    Attached Files Attached Files
    Last edited by computeruser08; 04-29-2009 at 09:03 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1