In short, after a CDSP transfer from Satrix to normal stock broking account how do you calculate the “unit cost” and “cost value” for the consolidated position? (Details of all the underlying transactions are lost with the CSDP transfer.)
The long version:
I had my ETF’s transferred from the Satrix Investment Plan to my stock broking account. (The Satrix fees became expensive over the long term.) After the transfer my shares reflect a zero Unit Cost and Cost Value on my stock broking portfolio. This causes the Return to reflect as the current market value of the shares and the Return % shows as Infinity.
I now need to calculate the Unit Cost and Cost Value to have my online stock broker update the values accordingly.Satrix provides a client statement that details all the transactions, I can use these transactions to calculate a base cost fairly easily. (Getting 9 years of transactions from the PDF statement into Excel is another story…)
The problem is that Satrix sold small numbers of shares over the years to cover admin fees. I looked at old IT/IB 3(c) tax certificates to see how they calculated the net gain/loss on the sold shares. They have a column called “Weighted average value” but I cannot get this value to match the “weighted average unit cost” that I calculated based on the transactions in their Client Statement. (I calculated the weighted average unit cost as detailed here:
http://www.sars.gov.za/TaxTypes/CGT/Pages/Base-Cost.aspx)
Any ideas?
