The Balanced Spreadsheet-Financial News, Budget Advice, Debt help, Financial Tips, and other advice

April 22, 2010

Employee Stock Purchase Program 1st quarter ’10

Filed under: Excel fun, Personal Finance, Real Example — Tags: , — thebalancedspreadsheet @ 8:00 am

The 1st quarter for my employer ended on March 31st. That means another stock purchase through my employer stock purchase program (ESPP). You can read a review of the entire process in my 2nd Quarter 2009  report.

It was nice to finally have a capital gain again after two straight quarters of capital losses. The 13.92% total gain is one of my highest one quarter gains since I have been participating in the Employee Stock Purchase Program. All of the gain will go into the Car/Vacation fund.  Overall a pretty easy way to make  $700.

Advertisements

October 19, 2009

Employee Stock Purchase Program 3Q ’09

Filed under: Excel fun, Personal Finance, Real Example — Tags: , , — thebalancedspreadsheet @ 2:48 pm

The 3rd Quarter for my employer ended on September 30th. That means another stock purchase through my employer stock purchase program (ESPP). You can read a review of the process in my 2nd Quarter report.

3rd Quarter '09 ESPP

3rd Quarter '09 ESPP

 

I didn’t have as good of a quarter as I had hoped as the stock price decreased significantly on October 1st and 2nd. It rebounded a little and I sold at $13.64, which means I have a capital loss of $100.01 for the quarter. Still, a total gain of $455.65 or about 9.11% is nothing to complain about. I probably did sell prematurely however as the stock price is now about $13.91.

This is the last quarter that the ESPP gains will be on 2009 federal income taxes. December 31st will go on 2010’s taxes because that is when the stock will be sold. So it’s interesting to see what my YTD numbers are. For 2009 I will claim ordinary income of $2,222 ($555.67 x 4) and capital gains of $46.41 for a total of $2,268. Considering that I put the same $5,000 in every three months, my YTD ROI is 45.36%! Again, I am not getting rich off this but it still helps to have this money to pay off the mortgage sooner, investing in IRA’s, or just have for extra savings,

Blog at WordPress.com.