We'd like to remind Forumites to please avoid political debate on the Forum... Read More »
We're aware that some users are experiencing technical issues which the team are working to resolve. See the Community Noticeboard for more info. Thank you for your patience.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
Capital Gains Calculator for share purchases
Options
david78
Posts: 1,654 Forumite
in Cutting tax
I regularly buy shares and funds outside of my ISA wrapper. I buy shares every month with occasional top-ups. To manage my capital gains I need to make occasional disposals within my capital gains tax allowance (currently £8,800).
I am in the middle of writing an Excel spreadsheet for calculating capital gains made when shares are bought and sold. This is an absolute minefield. But now I have most of the basics in place and working, including.
- share matching rules (except the B&B rule, not done yet).
- management of section 104 pool and indexation rules
- calculation of taper relief.
This project is still a "work in progress" and there is a bit more to do before it is finished. If anyone would like to help with this please let me know. The spreadsheet contains visual basic macros so you will need to be very familiar with them.
David.
I am in the middle of writing an Excel spreadsheet for calculating capital gains made when shares are bought and sold. This is an absolute minefield. But now I have most of the basics in place and working, including.
- share matching rules (except the B&B rule, not done yet).
- management of section 104 pool and indexation rules
- calculation of taper relief.
This project is still a "work in progress" and there is a bit more to do before it is finished. If anyone would like to help with this please let me know. The spreadsheet contains visual basic macros so you will need to be very familiar with them.
David.
0
Comments
-
David
This site may be of use :http://www.cgtcalculator.com
It seems pretty good to me - you could compare the results it generates to those of your spreadsheet0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 350.9K Banking & Borrowing
- 253.1K Reduce Debt & Boost Income
- 453.5K Spending & Discounts
- 243.9K Work, Benefits & Business
- 598.8K Mortgages, Homes & Bills
- 176.9K Life & Family
- 257.2K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.1K Discuss & Feedback
- 37.6K Read-Only Boards