2022 Stock Investment Tool
Buy and Download >
This program calculates the capital gains tax on both short-term (stock held less than one year) and long-term (stock held for longer than one year) investments in common stock for up to 15 companies. Just fill in the cells shaded gray and watch it do the rest.
No need to mess with complex issues. All you need to do is enter your purchase and sale information such as date purchased and sold and quantity purchased and sold. Take it a step further by researching a particular stock to see how it has performed over the past ten years.
It will also determine for you the amount of any loss carry forward (losses greater than $3,000 or $1,500 for married filing separately) for both short-term and long-term losses. Any gains and losses are shown on a mock-up tax schedule.
This spreadsheet program was created wholly in Microsoft Excel 365. Tax information is drawn from www.IRS.com for the 2022 tax year. Subsequent years programs will become available when tax information is published by the IRS. You may evaluate the performance of a companies stock over 10 years for 15 companies.
This performance is measured against the S&P 500 and the Value Line Investment Survey. It is recommended that you also purchase a membership with Value Line Investment Survey at http://www.valueline.com. To look at the historical stock price of any company for up to 10 years without a fee, you may visit https://www.nasdaq.com/.
If you already own stocks and would not like to do the evaluation, this program works just as well. You will be able to calculate the capital gains tax for both short term and long term investments based upon 2022 tax data end points from www.IRS.com and determine your loss carry forward (if any).
This program does not encompass all aspects of the tax code. Taxes are calculated in this program as a demonstration purpose only and are not intended to determine your actual tax liability. This program shows the impact of the Capital Gains Tax and how it is determined with your taxes. Please consult a tax professional if you need help with your taxes.