Got a credit card? use our Credit Card & Finance Calculators
Thanks to Rhyd6,eyeball08,Wondergirly,bofh,johnstevens77, for Donating to support the site
Share price cost apportionment
Forum rules
Direct questions and answers, this room is not for general discussion please
Direct questions and answers, this room is not for general discussion please
-
- Lemon Quarter
- Posts: 2217
- Joined: November 4th, 2016, 4:00 pm
- Has thanked: 424 times
- Been thanked: 803 times
Share price cost apportionment
When I buy shares i divide the total cost (including commission and stamp duty) by the number of shares to get to the total cost per share. In all the years of my trading in stocks and shares, whenever I sell part of a holding I always deduct the sale proceeds from the total buying cost of the original holding then divide the net amount by the number of shares kept to get to the cost per share.
Brokers tells me that's not how it's done. So what I'd like to know please is why not and how is it done?
tia
Bnc
Brokers tells me that's not how it's done. So what I'd like to know please is why not and how is it done?
tia
Bnc
-
- Lemon Half
- Posts: 6050
- Joined: May 30th, 2021, 6:01 pm
- Has thanked: 1843 times
- Been thanked: 2067 times
Re: Share price cost apportionment
You are working out the profit per share
Don't take away the sale proceeds.
If you buy 10 shares @£1 plus costs. the cost is £10 plus costs
Then sell 5 shares for £2, you have 5 shares left that still cost a £1 each plus costs
Don't take away the sale proceeds.
If you buy 10 shares @£1 plus costs. the cost is £10 plus costs
Then sell 5 shares for £2, you have 5 shares left that still cost a £1 each plus costs
-
- Lemon Half
- Posts: 7893
- Joined: November 4th, 2016, 11:24 am
- Has thanked: 7 times
- Been thanked: 3051 times
Re: Share price cost apportionment
brightncheerful wrote:When I buy shares i divide the total cost (including commission and stamp duty) by the number of shares to get to the total cost per share. In all the years of my trading in stocks and shares, whenever I sell part of a holding I always deduct the sale proceeds from the total buying cost of the original holding then divide the net amount by the number of shares kept to get to the cost per share.
So if the shares have doubled in value and you sell half of them, then you got the remaining half for free?
That's certainly one way of looking at it, but then if the shares have more than doubled in value and you sell half of them then what ... the cost per share becomes negative and the company is paying you to hold them?!?
Again, that's one way of looking at it, but not a way that any accountant or, most importantly, HMRC will do so! As pje16 points out, selling part of a holding doesn't affect the cost per share of the remainder, that remains the same as it was originally.
-
- Lemon Half
- Posts: 6050
- Joined: May 30th, 2021, 6:01 pm
- Has thanked: 1843 times
- Been thanked: 2067 times
Re: Share price cost apportionment
I did consider the selling half at twice the price scenario
but that's the profit angle, and is an ideal situation
but that's the profit angle, and is an ideal situation
-
- Lemon Half
- Posts: 6065
- Joined: November 5th, 2016, 9:05 am
- Has thanked: 20 times
- Been thanked: 1416 times
Re: Share price cost apportionment
brightncheerful wrote: So what I'd like to know please is why not and how is it done?
Suppose you buy 1000 shares at 100p each. Your buying cost was £ 1,000. At some later date you sell 40% of the shares for 200p. The book cost of the shares you sold was £ 400, your proceeds are £ 800 and your gain is £ 400. The book cost of the remaining shares is £ 600.
In other words selling shares doesn't change the historic prices you paid for them.
-
- The full Lemon
- Posts: 16629
- Joined: October 10th, 2017, 11:33 am
- Has thanked: 4343 times
- Been thanked: 7536 times
Re: Share price cost apportionment
Surely it depends on why the OP is doing the calculation? IF t is only for his own edification he can calculate the figure any way he likes.
If it is for CGT and his return to HMRC, then he needs to do a Section 104 pool. NO need to go into that if that is not what he is doing.
Dod
If it is for CGT and his return to HMRC, then he needs to do a Section 104 pool. NO need to go into that if that is not what he is doing.
Dod
-
- Lemon Half
- Posts: 5840
- Joined: November 4th, 2016, 11:22 am
- Has thanked: 4190 times
- Been thanked: 2602 times
Re: Share price cost apportionment
Dod101 wrote:If it is for CGT and his return to HMRC, then he needs to do a Section 104 pool.
And of course if some are held in ISA and some not, a separate calculation for those that are tax-exposed.
V8
-
- Lemon Quarter
- Posts: 2217
- Joined: November 4th, 2016, 4:00 pm
- Has thanked: 424 times
- Been thanked: 803 times
Re: Share price cost apportionment
Very helpful. thank you. I have amended my calculations - and am coming to terms with the lower profit.
What should i do when increasing a holding before selling part?
For example, if I buy 1000 shares for £1 (£1000 ex costs) then another 1000 for £1.50 ( £1500 (ditto), 2000 shares total £2500 = £1.25 each average.
Should I separate the total holding into the number of shares at each purchase so that when i sell say 750 shares at £2.00 I can decide which purchase provided the 750. So instead of £1 per share profit I could use £1.50 ps purchase price and opt for £0.50 ps profit.
What should i do when increasing a holding before selling part?
For example, if I buy 1000 shares for £1 (£1000 ex costs) then another 1000 for £1.50 ( £1500 (ditto), 2000 shares total £2500 = £1.25 each average.
Should I separate the total holding into the number of shares at each purchase so that when i sell say 750 shares at £2.00 I can decide which purchase provided the 750. So instead of £1 per share profit I could use £1.50 ps purchase price and opt for £0.50 ps profit.
-
- Lemon Half
- Posts: 6050
- Joined: May 30th, 2021, 6:01 pm
- Has thanked: 1843 times
- Been thanked: 2067 times
Re: Share price cost apportionment
This post at HMRC explains it
https://www.gov.uk/tax-sell-shares/same-company
The base price is worked out on the average cost
cheers
Paul
https://www.gov.uk/tax-sell-shares/same-company
The base price is worked out on the average cost
cheers
Paul
-
- Lemon Half
- Posts: 6065
- Joined: November 5th, 2016, 9:05 am
- Has thanked: 20 times
- Been thanked: 1416 times
Re: Share price cost apportionment
pje16 wrote:The base price is worked out on the average cost
Alternative rules are "first in first out" - you deem the first purchase to be the first sold and "Last in, first out" where the most recent purchase is the one deemed sold.
As pointed out earlier, if it's a taxed account, sticking to the HMRC method is expedient. Outside of that, you can make it up as you go along. All you are doing is establishing a rule for splitting a total gain or loss between realised and unrealised.
-
- Lemon Half
- Posts: 6050
- Joined: May 30th, 2021, 6:01 pm
- Has thanked: 1843 times
- Been thanked: 2067 times
Re: Share price cost apportionment
Alaric wrote:Alternative rules are "first in first out" - you deem the first purchase to be the first sold and "Last in, first out" where the most recent purchase is the one deemed sold.
Must admit before I looked it up on HMRC i thought it was FIFO
Are FIFO and LIFO just for your own benefit/purposes
I'm just curious as all mine are in an ISA where CGT not does apply
-
- Lemon Half
- Posts: 7893
- Joined: November 4th, 2016, 11:24 am
- Has thanked: 7 times
- Been thanked: 3051 times
Re: Share price cost apportionment
brightncheerful wrote:Very helpful. thank you. I have amended my calculations - and am coming to terms with the lower profit.
(a) the profit hasn't changed and (b) your calculation in the topic post didn't calculate profit anyway, just an idiosyncratic adjustment of the cost per share.
brightncheerful wrote:What should i do when increasing a holding before selling part?
For example, if I buy 1000 shares for £1 (£1000 ex costs) then another 1000 for £1.50 ( £1500 (ditto), 2000 shares total £2500 = £1.25 each average.
Should I separate the total holding into the number of shares at each purchase so that when i sell say 750 shares at £2.00 I can decide which purchase provided the 750. So instead of £1 per share profit I could use £1.50 ps purchase price and opt for £0.50 ps profit.
No! You have to use the average. But note that when calculating capital gains, costs are included both in the buy and in the sell.
-
- Lemon Quarter
- Posts: 2217
- Joined: November 4th, 2016, 4:00 pm
- Has thanked: 424 times
- Been thanked: 803 times
Re: Share price cost apportionment
Thank you.
Some time ago, my accountant asked about my shares holdings but i declined to disclose as i only buy and sell shares for fun and within the CGT allowance and didn't relish the thought of someone (even my accountant) becoming privy. I do however disclose all divi income on my tax return. A long time ago someone at accountants took it upon himself to calculate the amount divi he thought I should've received but I'd not mentioned from one particular company that I'd disclosed the year before. I had to introduce the accountant to my 'short term buy and sell''
Thinking perhaps I ought to update my records to avail of the capital loss that could be offset against CGT on my part of the ownership of our PPR, (tax relief percentage of outgoings for business purposes) which my accountant said could be backdated, I decided against for the same reasons and instead wait for a change in tax legislation to work in my favour.
Thanks to your answers to my op i shall when next i have spare time redo all the calculations.
Some time ago, my accountant asked about my shares holdings but i declined to disclose as i only buy and sell shares for fun and within the CGT allowance and didn't relish the thought of someone (even my accountant) becoming privy. I do however disclose all divi income on my tax return. A long time ago someone at accountants took it upon himself to calculate the amount divi he thought I should've received but I'd not mentioned from one particular company that I'd disclosed the year before. I had to introduce the accountant to my 'short term buy and sell''
Thinking perhaps I ought to update my records to avail of the capital loss that could be offset against CGT on my part of the ownership of our PPR, (tax relief percentage of outgoings for business purposes) which my accountant said could be backdated, I decided against for the same reasons and instead wait for a change in tax legislation to work in my favour.
Thanks to your answers to my op i shall when next i have spare time redo all the calculations.
-
- Lemon Half
- Posts: 6065
- Joined: November 5th, 2016, 9:05 am
- Has thanked: 20 times
- Been thanked: 1416 times
Re: Share price cost apportionment
pje16 wrote:Are FIFO and LIFO just for your own benefit/purposes
Until next time a government decides to change the rules.
-
- 2 Lemon pips
- Posts: 146
- Joined: November 4th, 2016, 12:16 pm
- Has thanked: 391 times
- Been thanked: 39 times
Re: Share price cost apportionment
mc2fool wrote:brightncheerful wrote:Very helpful. thank you. I have amended my calculations - and am coming to terms with the lower profit.
(a) the profit hasn't changed and (b) your calculation in the topic post didn't calculate profit anyway, just an idiosyncratic adjustment of the cost per share.brightncheerful wrote:What should i do when increasing a holding before selling part?
For example, if I buy 1000 shares for £1 (£1000 ex costs) then another 1000 for £1.50 ( £1500 (ditto), 2000 shares total £2500 = £1.25 each average.
Should I separate the total holding into the number of shares at each purchase so that when i sell say 750 shares at £2.00 I can decide which purchase provided the 750. So instead of £1 per share profit I could use £1.50 ps purchase price and opt for £0.50 ps profit.
No! You have to use the average. But note that when calculating capital gains, costs are included both in the buy and in the sell.
Sorry to disagree, but no, you don't have to use the average. If you're working out your Capital gains tax, then you do, as per HMRC instructions. But if you're doing it for other purposes, then FIFO or LIFO may be more appropriate. Personally the method I use the most frequently is that I keep track of the cost of each lot of of a particular share I buy. That way I can apply separate sell criteria to separate lots.
HTH
Maylix
-
- Lemon Half
- Posts: 7893
- Joined: November 4th, 2016, 11:24 am
- Has thanked: 7 times
- Been thanked: 3051 times
Re: Share price cost apportionment
Maylix wrote:mc2fool wrote:No! You have to use the average. But note that when calculating capital gains, costs are included both in the buy and in the sell.
Sorry to disagree, but no, you don't have to use the average. If you're working out your Capital gains tax, then you do, as per HMRC instructions. But if you're doing it for other purposes, then ...
I made that point in my initial reply.
mc2fool wrote:Again, that's one way of looking at it, but not a way that any accountant or, most importantly, HMRC will do so.
Let's not forget what the original question was and what the OP wanted to know:
brightncheerful wrote:Brokers tells me that's not how it's done. So what I'd like to know please is why not and how is it done?
By which he clearly meant, how is it formally done (by brokers, HMRC, accountants, etc), not what other idiosyncratic ways there are of doing it if you feel like.
Who is online
Users browsing this forum: No registered users and 27 guests