Message Font: Serif | Sans-Serif
No. of Recommendations: 2
I created a simple Excel spreadsheet. I entered all of the fractional shares purchased in column A and the price I paid for a full share on the date of purchase in column B. Then in column C entered the formula “=A1*B1” to give me the amount I invested for each purchase and then added all amounts to give the total basis.

That doesn't sound right, plus it sounds like way too much trouble. What you need to do is add up all your purchases. Let's say you bought .45 share one day and paid $X for it. Then you bought .55 share the next day and paid $Y for it. The cost of that share is $X+Y.

Why not just add up all your purchase amounts (cash plus reinvested dividends plus any employer contributions already taxes) since, IIRC, you sold all your holding? There's no need to allocate a specific purchase price to a specific share.

Print the post  


In accordance with IRS Circular 230, you cannot use the contents of any post on The Motley Fool's message boards to avoid tax-related penalties under the Internal Revenue Code or applicable state or local tax law provisions.
What was Your Dumbest Investment?
Share it with us -- and learn from others' stories of flubs.
When Life Gives You Lemons
We all have had hardships and made poor decisions. The important thing is how we respond and grow. Read the story of a Fool who started from nothing, and looks to gain everything.
Contact Us
Contact Customer Service and other Fool departments here.
Work for Fools?
Winner of the Washingtonian great places to work, and Glassdoor #1 Company to Work For 2015! Have access to all of TMF's online and email products for FREE, and be paid for your contributions to TMF! Click the link and start your Fool career.