Hi,
I am trying to find an Excel spreadsheet that allows me to simply keep track of the CGT owed if i sell a parcel of shares that is a different qty to the parcels i have bought and help me keep track of & balance the remaining shares i still hold.
ie
I purchased 1,000 shares of Company ZZZ on 1.1.2000 @ $10 / share. Brokerage fee of $10. Total cost + Brokers fee = $10,010.
I now sell 350 shares of Company ZZZ on 1.1.2021 @ $40 / share. Brokerage fee of $25. Total Sale - Brokers fee = $13,975
If i use the F.I.F.O basis of calculating the CGT owed on selling this parcel of shares i presume i use a formula like the following:
13,975 - 350 (10,010 / 1,000) = Profit made on these shares.
13,975 - 3,503.5 = $10,471.50 Profit. As shares are owned > 12 months CGT is calculated on 50% of Profit (ie $5,235.75)
To calculate the cost basis of the remaining holding of 650 shares it would be: 650 (10,010 / 1,000) = $6,506.50
If anybody else who knows how to make an easy to use Excel spreadsheet which can keep track of multiple buys / sells ... especially if the Qty's sold differ from the Qty's originally purchased i would be eternally greatful.
Cheers,
P_G
I am trying to find an Excel spreadsheet that allows me to simply keep track of the CGT owed if i sell a parcel of shares that is a different qty to the parcels i have bought and help me keep track of & balance the remaining shares i still hold.
ie
I purchased 1,000 shares of Company ZZZ on 1.1.2000 @ $10 / share. Brokerage fee of $10. Total cost + Brokers fee = $10,010.
I now sell 350 shares of Company ZZZ on 1.1.2021 @ $40 / share. Brokerage fee of $25. Total Sale - Brokers fee = $13,975
If i use the F.I.F.O basis of calculating the CGT owed on selling this parcel of shares i presume i use a formula like the following:
13,975 - 350 (10,010 / 1,000) = Profit made on these shares.
13,975 - 3,503.5 = $10,471.50 Profit. As shares are owned > 12 months CGT is calculated on 50% of Profit (ie $5,235.75)
To calculate the cost basis of the remaining holding of 650 shares it would be: 650 (10,010 / 1,000) = $6,506.50
If anybody else who knows how to make an easy to use Excel spreadsheet which can keep track of multiple buys / sells ... especially if the Qty's sold differ from the Qty's originally purchased i would be eternally greatful.
Cheers,
P_G
