When you invest in a DSP or DRIP plan one of the challenges is to calculate the Cost Basis of the purchased shares when it comes time to sell all or a fraction of the shares. I did some selling in 2006 and quite a bit of clean up towards the end of 2007. I just completed my 2007 taxes last week and used a Cost Basis Spreadsheet I had created a couple of years ago to calculate my cost basis and net gain/(loss) for the shares I sold in 2007.
Below is an image of the spreadsheet I had put together. Click on the image to view a full screen. It is a fairly simple spreadsheet that shows my purchases and sale of shares in Schnitzer Steel. I categorized the cost basis and gain/(loss) calculation into short term and long term.
If you would like a copy of the spreadsheet shoot me an email (there is a link in my complete profile) and I will send it to you.
Cost Basis Calculator
Posted by Direct Stock Purchaser on Saturday, March 29, 2008 3 comments
Labels: Cost Basis Calculator
It's been a long time
It has been a long time since my last post. Had a lot of family health & financial issues to deal with. Things have improved over the last few weeks and I am finally finding time to get back to updating my blog. Since last August I have pared back my holdings, both in Direct Stock Purchase (DSP) plans and Brokerage accounts. By the end of last year I had reduced my DSP holdings from:
- Aqua America (Google Yahoo Earnings Chart)
- Caterpillar (Google Yahoo Earnings Chart)
- Duke Energy (Google Yahoo Earnings Chart)
- Exxon Mobil (Google Yahoo Earnings Chart)
- Paychex (Google Yahoo Earnings Chart)
- Pfizer (Google Yahoo Earnings Chart)
- Limited Inc. (Google Yahoo Earnings Chart)
To
Among the above 4 DSP plans I currently participate in, on a monthly basis I contribute:
- $75 to Duke Energy
- $75 to Oneok Inc.
- $100 to Pfizer
- $100 to PNM Resources
I bought shares for the following two companies in the custodial accounts:
Posted by Direct Stock Purchaser on Thursday, March 27, 2008 0 comments
Labels: It's been a long time
Subscribe to:
Posts (Atom)