William,
Many thanks for your prompt response and as you have stated, it works.
As mergers and demergers are fairly common in the Corporate world, we should ask Reckon to incorporate this task in the Transaction section.
Once again, many thanks, regards.
Gentlemen,
Sorry for the delayed response to your solution to my problem, but I was awaiting some sort of communications from BHP/South32 on the demerger. Unfortunately nothing to date.
As far as I am aware, an ”in-specie dividend” of $2.13 has been declared by BHP, but I can not find any investor information of this. However, irrespective of the cost of S32 shares, both yours and Mr. Phillips, recommendations have some shortcomings. Using the "Corporate spin-off" results in a "Return of Capita" for BHP, which is quite different from the actual S32 share costs. I believe it takes into the calculations the difference in the actual and calculated BHP share price. This results in the difference in cost price of S32 to that based on actual "Corporate Spin-off" and that the figure calculated by Reckon. Therefore all future "price gain/loss" indications are also incorrect. By adjusting the S32 share price under "Buy - Shares Bought" and the BHP "Capital return" to that of the actual "in-specie dividend" will rectify this problem. However I do not think that this procedure was what was envisaged by Reckon.
Using Mr. Phillips' solution results in no S32 "Cost Basis" and therefore no future "Gain/Loss" nor "Gain/Loss(%)" indication.
Finally, I would appreciate some indication when Reckon will include South32 in the "Download Securities" list.
Regards,
Hallo Graham,
Thank you very much for you quick response. I shall try to find out the actual BHP cost basis and the ATO factor to find out the true costs for S32 shares.
As far as the price downloading I cannot even get the code using the "Edit security details".. When trying the "Look up Symbol" the "Stock Code Search" gives a message "Your search returned 0 results". All the other investments are downloading their respective prices correctly.
Steven Vas
Hello Graham,
Thank you for your response.
My cost basis are correct for both BHP and S32. My only problem is downloading S32 share prices. All other investments download and update correctly. Why I have mentioned the lack of automatic working of South32 "Look up Symbol" function, as I believe that the update of S32 share prices and the finding of the security symbol are somehow connected. I have in fact manually typed it in.
John, Graham,
Many thanks for your prompt responses. My configuration was exactly the same as yours, but I could not get an update of the S32 share price. Finally in great frustration I have deleted all references to South 32 and reinstalled it from sketch and behold, all of a sudden it started to work. I managed to download the last five days of S32 prices. I just have to wait a few days to make certain that it will keep working.
Once again many thanks for persevering with me over the last few days and your very prompt responses.
Steven Vas.
Hello John,
Many thanks for the additional information. I will keep it in mind for the future I case I experience a similar problem.
BHP have issued an Allotment of Securities. I now have Shares in South32 at no cost. How do I enter this?
Using 2015 version
The corporate spin-off information is now available.
I did it as a corporate spin-off as a 1 for 1 spin off on May 25
The value of S32 is $2.25 and the value of BHP is $29.44. (these values are supplied to adjust the capital value of both companies)
Providing this information will adjust the capital value of both sets of shares accordingly (for future capital gains calculations when you sell)
Note that if you have BHP shares in more than 1 account, only do this once, as the share split will be applied to each account.
I would recommend against a more complex approach of doing a capital return and share purchase, as the spin-off does appear to work and adjust your capital value of both companies.
You will need to edit the company information for S32 to check the settings. Just make them the same as BHP.
John
The key for this is to get the cost base split correctly, which CSO screen provides.
I noticed this since I have 2 accounts with different cost per share of BHP shares, which result in different cost per share of S32 shares.
All this is easy, compared to getting the correct cost base for the Westfield Trust restructure last year !
I still haven't bothered to fix that as yet.
Thanks Graham for this advice. However, I am still not sure how I should proceed in Accounts Personal Plus 2015. I am confused by the ATO statement that South32 shares are taken to have been acquired on the same date as the original BHP shares.
I have acquired parcels of BHP shares in July 2006, November 2013 and 6th May 2015. If I choose to use Method 2 do I have to apply it to each individual parcel and calculate the value of returned capital as 7.1% of the cost base of the individual parcel?
Wouldn’t this sort of calculation have to be done in the future to assess any capital gain/loss when any portion of either BHP or South32 shares are sold?
Any help in this regard would be very much appreciated.
Dima Bartels
Thanks Diver Dave. I am sorry if I appear a bit obtuse but how do I go about recording the purchase of the three parcels of South32 if they are all acquired on 17th May? Wouldn't it be also contrary to ATO advice that the acquisition date should be the same as for the BHP shares?
Dima
Thanks for that, Diver Dave. I understand what you are saying about the capital gains/loss situation but I was not clear on your statement “you could record the purchase of 3 parcels of South 32” and wanted to know how to go about doing it.
This is what I have now done and would appreciate your comment on it:
I have created a Suspense Account although I could have used my Cash Account.
I have followed Method 2 as described by Graham Boast where the cost basis was the sum of costs of my 3 parcels of BHP shares and the amount of capital returned (7.1% of the summated cost) was placed in the Suspense Account.
For each individual original parcel of BHP shares, I have calculated the amount of capital return (i.e. 7.1%).
I have created a South32 account.
I have then entered in the South32 account three separate purchases of shares on the same dates and for the same number of shares as each of the BHP share parcels. Payment for each parcel was that calculated in para 3. The source of funds was the Suspense Account. I am now left with 0 balance in the Suspense Account and the cost basis of the S32 account is equal to the amount calculated as return of capital in para 2.
When I now look at the Security Detail View for BHP the Cost Basis is now 92.9% of the previous figure and for S32 the Cost Base is 7.1% of the previous BHP figure.
Although the total Cost Basis for BHP is now the reduced amount, the individual amounts as appearing in the Inv.Amt. column of the Transaction List have not changed and are still shown at their original values. I don’t understand this because I thought they too would now be shown at their reduced values as you implied when you said: “Reckon will reduce the cost base of each parcel proportionately”. Do you have a comment on this?
There has been a lot of discussion about this security spin-off, although I think it is much simpler that is being discussed.
Based on the prices of $2.25 for S32 and $29.44 for BHP, if at some stage you make a profit on the sale of S32 shares, 7.1% of all past BHP purchases can be allocated to the sale in your capital gains calculation; the ATO indicates this.
All that QPP has done is calculate the accumulated cost of shares and allocates 7.1% on the day of the spin-off. You need to keep track of the BHP purchase dates when estimating capital gains. It looks to me that QPP has done this accumulated cost correctly, but will probably incorrectly report the purchase date(s). I don't thing you will get better than that from QPP. Are the dates that complex?
Something for you to remember although I have forgotten what has happened with One-steel, Bluescope or Arrium?
Imagine the complexities of capital gains calculations if we were to ever make a profit on companies like GPT, with all their deferred tax and capital returns. The GFC at least made something simpler.