Google Answers Logo
View Question
 
Q: Sale Calculation ( Answered 5 out of 5 stars,   1 Comment )
Question  
Subject: Sale Calculation
Category: Business and Money > Accounting
Asked by: cmaury-ga
List Price: $12.00
Posted: 17 Mar 2003 11:27 PST
Expires: 16 Apr 2003 12:27 PDT
Question ID: 177442
I know enough about wash sales to know that I don't want to calculate
this.
 
Based on the transaction data provided, please provide the data
necessary to fill out my federal records.  I am using Turbotax
(online).  For each entry that I need to put in my records, I need

1)A Description (e.g. 200 WCG)
2)Net Sale Price
3)Date Sold
4)Cost or Basis
5)Date Aquired


Here's the source data:
*************************************************** 
 
Trade Date Symbol Action Quantity Price Amount Net Amount 
11/13/2001 WCGRQ  Buy  340.136 1.47 500 500 
11/15/2001 WCGRQ  Buy  452.434 2.21 1000 1000 
11/20/2001 WCGRQ  Sell  792.57 2.77 2195.42 2175.43 
01/11/2002 WCGRQ  Buy  398.014 2.01 800.01 820 
01/17/2002 WCGRQ  Buy  574.886 1.93 1109.53 1129.52 
02/25/2002 WCGRQ  Sell  972.9 0.12 116.75 96.76 
01/28/2002 WCG Buy 900 1.69 1521 1540.95 
01/29/2002 WCG Buy 350 1.38 483 502.95 
02/05/2002 WCG Buy 170 0.7 119 138.95 
02/25/2002 WCG Sell 1420 0.12 170.4 155.44 
02/25/2002 WCG Buy 648 0.23 149.04 163.99 
03/12/2002 WCGR Sell 648 0.22 142.56 122.6 
03/18/2002 WCGR Buy 3000 0.162 486 505.95 
04/16/2002 WCGR Buy 2520 0.154 388.08 408.03 
04/17/2002 WCGR Sell 5520 0.224 1236.48 1216.49 
04/17/2002 WCGR Buy 5000 0.23 1150 1169.95 
04/17/2002 WCGR Sell 5000 0.205 1025 1005.01 
04/17/2002 WCGR Buy 4650 0.212 985.8 1005.75 
07/12/2002 WCGRQ Sell 4650 0.021 97.65 74.65 
 
*************************************************** 
 
I had no other positions in this stock other than these listed.
Answer  
Subject: Re: Sale Calculation
Answered By: juggler-ga on 17 Mar 2003 16:51 PST
Rated:5 out of 5 stars
 
Hello.

For tax purposes, you have 7 transactions. I'll take each of them
separately.

-----------------------------------

1)Description: 792.57 WCGRQ
2)Net Sale Price: 2175.43 
3)Date Sold: 11/20/2001
4)Cost or Basis: 1500
5)Date Acquired: VARIOUS (11/13/2001 and 11/15/2001)

Enter "VARIOUS" for the "date acquired." According to the IRS: 
"If you sell a block of the same kind of stock, you can report all the
shares sold at the same time as one sale, writing VARIOUS in the 'date
acquired' column of  Form 1040, Schedule D." See IRS.gov "Frequently
Asked Questions: Schedule D"
http://www.irs.gov/faqs/page/0,,id%3D15676,00.html

Note: I notice that this transaction took place in 2001. As such, it
might have been more properly included on your 2001 return.

---------------------------------

1)Description: 972.9 WCGRQ
2)Net Sale Price: 96.76
3)Date Sold: 02/25/2002
4)Cost or Basis: 1949.52 
5)Date Acquired: VARIOUS (01/11/2002 and 01/17/2002)

---------------------------------

1)Description: 1420 WCG
2)Net Sale Price: 155.44
3)Date Sold: 02/25/2002
4)Cost or Basis: 2182.85
5)Date Acquired: VARIOUS (01/28/2002 , 01/29/2002 and 02/05/2002)

---------------------------------

1)Description: 648 WCGR  
2)Net Sale Price: 122.6  
3)Date Sold: 03/12/2002
4)Cost or Basis: 163.99
5)Date Acquired: 02/25/2002

---------------------------------

1)Description:  5520 WCGR 
2)Net Sale Price: 1216.49 
3)Date Sold: 04/17/2002
4)Cost or Basis: 913.98 
5)Date Acquired: VARIOUS (03/18/2002 and 04/16/2002)

---------------------------------

1)Description: 5000 WCGR
2)Net Sale Price: 1005.01
3)Date Sold: 04/17/2002
4)Cost or Basis: 1169.95
5)Date Acquired: 04/17/2002

---------------------------------

1)Description: 4650 WCGRQ (or WCGR? On the buy line you wrote WCGR)
2)Net Sale Price: 74.65   
3)Date Sold: 07/12/2002
4)Cost or Basis: 1005.75 
5)Date Acquired: 04/17/2002


As always, note that Google Answers is for informational purposes only
and is not a substitute for professional tax, legal or investment
advice. No warranties are expressed or implied.

I hope this helps. If anything is unclear, please use the "request
clarification" feature. Thanks.

Request for Answer Clarification by cmaury-ga on 18 Mar 2003 07:05 PST
Although I've already closed and rated this question, I now realize
that I need to know which of the 7 transactions represent Wash Sales
(if any.)

Please advise.

Thanks in advance!

Clarification of Answer by juggler-ga on 18 Mar 2003 11:27 PST
Hi.

Okay, I've redone the whole thing (including the bases) to reflect the
"wash sale" approach. Note, however, the net effect of all this is
zero because you appear to have closed out your entire position in the
stock. In other words, your total losses for 2002 on this stock
(around $4715, I believe) end up being the same either way.

See: Fool.com Tax Center: Wash Sales
http://www.fool.com/school/taxes/taxes27.htm

I'm going to assume here that WCG, WCGR, and WCGRQ are the same
security (i.e., Williams Communications). If that's not correct, let
me know.

Okay, here we go...

-----------------------------

1)Description: 792.57 WCGRQ 
2)Net Sale Price: 2175.43  
3)Date Sold: 11/20/2001 
4)Cost or Basis: 1500 
5)Date Acquired: VARIOUS (11/13/2001 and 11/15/2001) 

 
--------------------------------- 
 
1)Description: 972.9 WCGRQ 
2)Net Sale Price: 96.76 
3)Date Sold: 02/25/2002 
4)Cost or Basis: 1949.52  
5)Date Acquired: VARIOUS (01/11/2002 and 01/17/2002) 
 
WASH SALE: 1852.76

--------------------------------- 
 
1)Description: 1420 WCG 
2)Net Sale Price: 155.44 
3)Date Sold: 02/25/2002 
4)Cost or Basis: 4035.61 (2182.85 + 1852.76)
5)Date Acquired: VARIOUS (01/28/2002 , 01/29/2002 and 02/05/2002) 
 

WASH SALE: 3880.17

--------------------------------- 
 
1)Description: 648 WCGR   
2)Net Sale Price: 122.6   
3)Date Sold: 03/12/2002 
4)Cost or Basis: 1934.66 (163.99 + 1770.67 [which is 45.633% of
3880.17])
5)Date Acquired: 02/25/2002 

WASH SALE: 1812.06

--------------------------------- 
 
1)Description:  5520 WCGR  
2)Net Sale Price: 1216.49  
3)Date Sold: 04/17/2002 
4)Cost or Basis: 4835.54  (913.98 + 1812.06 + 2109.50 [which is
3880.17 - 1770.67])
5)Date Acquired: VARIOUS (03/18/2002 and 04/16/2002) 

WASH SALE: 3619.05

--------------------------------- 
 
1)Description: 5000 WCGR 
2)Net Sale Price: 1005.01 
3)Date Sold: 04/17/2002 
4)Cost or Basis: 4448.08 (1169.95 + 3278.13 [ which is 90.5797% of
3619.05]
5)Date Acquired: 04/17/2002 

WASH SALE: 3202.06 (i.e., 93% of 3443.07)

--------------------------------- 
 
1)Description: 4650 WCGRQ (or WCGR? On the buy line you wrote WCGR) 
2)Net Sale Price: 74.65    
3)Date Sold: 07/12/2002 
4)Cost or Basis: 4548.73 (1005.75 + 3202.06 + 340.92 ) 
5)Date Acquired: 04/17/2002 


I hope this helps.

Request for Answer Clarification by cmaury-ga on 19 Mar 2003 07:52 PST
I appreciate your work on this stuff.  I agree that the end result is
the same, however, for my purposes, I have to "show my work."  I also
need to maintain this stuff so I can carry the excess forward to next
year.

I have more of these types of calculations (for other holdings.)  Are
you interested?

Clarification of Answer by juggler-ga on 19 Mar 2003 10:36 PST
Hi.

Sure, I'll take a shot at your other calculations. Post them as new
questions. If you wish, you can put "attn juggler-ga" in the subject
line.
Thanks.
cmaury-ga rated this answer:5 out of 5 stars
Thank you for you math (since no warranties are expressed or implied).
 Great job!

In addition, I realize that the first transaction belonged with last
year, but I wanted to provide a complete view of the series of
transactions, since it could affect each subsequent (sp?) one.

Btw, I have more of these if you are interested...

Comments  
Subject: Re: Sale Calculation
From: trader_dave-ga on 18 Feb 2005 06:58 PST
 
There is a much simpler solution to this schedule d wash sales
problem: Purchase software that was designed specifically for this
purpose, such as TradeLog from www.armencomp.com/tradelog

Most personal finance and popular tax software programs are woefully
inadequate when it omes to properly reporting trades and wash sales on
a schedule d.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy