CGT - share consolidation, and rights issue

Clauric

I got the following information with regards to the RSA shares over the last year. I am trying to figure out how to calculate my CGT based on these numbers:

Date Qty Price Cur Cost / Proceeds CGTS Narrative
07/08/2013 14,500 122.34 GBP 18,006.39 Bought
10/04/2014 5,437 GBP 3,044.72 Bought Rights Issue - 3 new shares for every 8 held
26/05/2014 -19,937 GBP 0 Action Share consolidation - 1 new RSA share for every 5 Royal & Sun Alliance held
12/05/2014 3,987 56 GBP 21,051.12 Action Share consolidation - 1 new RSA share for every 5 Royal & Sun Alliance held
30/05/2014 -3,987 481.75 GBP 19,014.30 Sold


Any idea what my CGT for these transactions would be?

euroboom13

No gain ,loss of over 2k (make sure all buy and sell costs added to outlay)

Should work out loss and gain on each purchase but result would be the same.
Download a return form and do a return just to get an allowance on future winners.

Clauric

euroboom13 wrote: »

No gain ,loss of over 2k (make sure all buy and sell costs added to outlay)

Should work out loss and gain on each purchase but result would be the same.
Download a return form and do a return just to get an allowance on future winners.

Ok, but how do I work that out. Would somebody be able to walk me through it?

Thanks

euroboom13

Clauric wrote: »

Ok, but how do I work that out. Would somebody be able to walk me through it?

Thanks

Not simple because you need to show results in EURO`S( and may need to show all transactions in euros) Simple job for an accountant

Here`s a quick breakdown

14500 after split 2900 capitol outlay £18006.39 @6.21 each /sale price £13970.75(£4.8175) £18006.39-£13970.75 = loss £4035.64

5437 after split 1087 capitol outlay £3044.72 @£;2.80 each/sale price £5236.62(£4.8175) £3044.72 -5236.62= profit £2191.90

profit and loss £4035.64 - £2191.9=

£1843.74 capitol loss (1.28 euro/£=2359.99euro loss)

Get a book keeper

Bizness

euroboom13 wrote: »

Not simple because you need to show results in EURO`S( and may need to show all transactions in euros) Simple job for an accountant

Here`s a quick breakdown

14500 after split 2900 capitol outlay £18006.39 @6.21 each /sale price £13970.75(£4.8175) £18006.39-£13970.75 = loss £4035.64

5437 after split 1087 capitol outlay £3044.72 @£;2.80 each/sale price £5236.62(£4.8175) £3044.72 -5236.62= profit £2191.90

profit and loss £4035.64 - £2191.9=

£1843.74 capitol loss (1.28 euro/£=2359.99euro loss)

Get a book keeper

Why would he/she need to be paying hard-earned money to a member of the rentier classes (i.e. accountant) for this? It is relatively simple.
You have already done the calcs for him/her.

Only thing is the conversion of £ to €. It depends whether you paid and received for all the transactions in £ or did the stockbroker convert to € for you. If the stockbroker converted to €, then obviously use the € transactions. If you already had sterling money and kept everything in £, then need to do the conversion for the transaction dates.
I am not sure what conversion rate you would use, the atm rate is typically 2% above spot rate (spot rate is 0%), credit card is 3% above spot rate, interbank transfer rate is something like 1%. Have a bit in there for the cat if you know what I mean, and use 3% or 4% for the date each transaction was executed.
wwwdotoandadotcom (oanda) has a very good currency converter and you can pick the rate based on the historical date.

Ensure you understand the different rates between buying £ from € for your purchases and then selling £ to € for your final sale.

I have added to your spreadsheet. (I had a bit of spare time!) However doe to Boards posting rules, it will not be displayed as a spreadsheet.
Fill in the return to the Commisineirí and your loss will be carried forward.

Date Qty Price Cur Cost / Proceeds CGTS Narrative Comment
07/08/2013 14,500 122.34 GBP 18,006.39 Bought I assume this includes stamp duty of 0.5% and stockbroker commission, as 14500*1.2234 = £17739.3
07/08/2013 Buying 18,006.4 GBP you pay € 21,470.90 From wwwdotoandadotcom currency converter at 3% above the £/€ spot rate for 07/08/2013
10/04/2014 5,437 GBP 3,044.72 Bought Rights Issue - 3 new shares for every 8 held
10/04/2014 Buying 3,044.72 GBP you pay € 3,809.37 From wwwdotoandadotcom currencyconverter at 3% above the £/€ spot rate for 10/04/2014
26/05/2014 -19,937 GBP 0 Action Share consolidation - 1 new RSA share for every 5 Royal & Sun Alliance held
12/05/2014 3,987 56 GBP 21,051.12 Action Share consolidation - 1 new RSA share for every 5 Royal & Sun Alliance held
30/05/2014 -3,987 481.75 GBP 19,014.30 Sold I assume this includes stockbroker commission deduction, as 3987*4.8175 = £19207.3725. You should deduct any other costs incurred during life of shareholding, e.g. if nominee or Crest account holding fee.
Selling 19,014.3 GBP you get € 22,663.60 From wwwdotoandadotcom currency converter at 3% above the £/€ spot rate for 30/05/2014

Net loss 22,663.60
- 21,470.90
- 3,809.37
So net loss € -2,616.67

Carry forward this loss against future gains.