Go Back   CDN Business Directory > Main Category > Taxes

 
 
Thread Tools Display Modes
  #7  
Old 04-30-2004, 07:49 AM
Frank S. Duke, Jr.
Guest
 
Posts: n/a
Default Re: ESPP Turbo Tax worksheet -- does not make sense?!

kuzo robinson at kruzo[at]yahoo.com wrote:
- quote -

> "Frank S. Duke, Jr." <dukefs[at]one.net> wrote:
> > kuzo robinson at kruzo[at]yahoo.com wrote:


> I am sure the commenDs of others are just as useful.


Touché!

All freely provided advice guarantee correct or double your
money back

Frank S. Duke, Jr. CPA
Cincinnati, OH USA

<< -------------------------------------------------> << The Charter and the Guidelines for submitting > << messages to this newsgroup are at www.asktax.org > << ------------------------------------------------->
  #6  
Old 04-27-2004, 05:33 PM
kuzo robinson
Guest
 
Posts: n/a
Default Re: ESPP Turbo Tax worksheet -- does not make sense?!

"Frank S. Duke, Jr." <dukefs[at]one.net> wrote:
- quote -

> kuzo robinson at kruzo[at]yahoo.com wrote:

> > Thank you all for your help.
> > > I am learning ... :-)


> A great many of the learned contributors to this forum are
> not GentleMEN but their commends are still highly valued and
> just as useful.


Right, I was thanking the specific ones the helped ME,
all of whome appear to be gentleMEN.

I am sure the commenDs of others are just as useful.

K

<< -------------------------------------------------> << The Charter and the Guidelines for submitting > << messages to this newsgroup are at www.asktax.org > << ------------------------------------------------->
  #5  
Old 04-23-2004, 04:37 AM
Frank S. Duke, Jr.
Guest
 
Posts: n/a
Default Re: ESPP Turbo Tax worksheet -- does not make sense?!

kuzo robinson at kruzo[at]yahoo.com wrote:

- quote -

> Thank you all for your help.
> I am learning ... :-)


A great many of the learned contributors to this forum are
not GentleMEN but their commends are still highly valued and
just as useful.

All freely provided advice guarantee correct or double your
money back

Frank S. Duke, Jr. CPA
Cincinnati, OH USA

<< -------------------------------------------------> << The Charter and the Guidelines for submitting > << messages to this newsgroup are at www.asktax.org > << ------------------------------------------------->
  #4  
Old 04-22-2004, 07:13 AM
kuzo robinson
Guest
 
Posts: n/a
Default Re: ESPP Turbo Tax worksheet -- does not make sense?!

Gentlemen,

Thank you all for your help.

I am learning ... :-)

K

<< -------------------------------------------------> << The Charter and the Guidelines for submitting > << messages to this newsgroup are at www.asktax.org > << ------------------------------------------------->
  #3  
Old 04-12-2004, 11:12 AM
Al Bundy
Guest
 
Posts: n/a
Default Re: ESPP Turbo Tax worksheet -- does not make sense?!

kruzo[at]yahoo.com (kuzo robinson) wrote in

- quote -

> I am using TurboTax to report the ESPP.
> It makes no sense to me how the worksheet brakes down what I
> think should be reported as long term gaim into 2: long term
> gain and Oridinary income.
> Here are the details of a SAMPLE calculation:
> Offering grant date 06/01/2001
> Market price per share at offering date $20
> Discount percentage 15.00%
> Purchase or exercise date 05/31/2002
> Market price per share at purchase (exercise) date $10
> Stock price per share actually paid at purchase date $8.50
> Commission -- $0
> Date sold 08/04/2003
> Number of shares sold 100.
> Sale proceeds (Form 1099-B, prorated if necessary) 1,200.00
> So, according to my understanding, the total cost is
> $8.50 x 100 = $850
> And the total net long term gain is $350, right?
> The way Turbo Tax caluclates it is this:
> -------------------------------
> Amounts reported on: Schedule D
> Cost $1,150.00
> Net gain (loss) $50.00 ..................(!!!, Author)
> Long-term or short-term: Long-term
> Amount to be reported as compensation - usually on Form W-2:0.00
> Is the amount on line 5a or 5c already included on Form W-2 Box 1? NO
> Ordinary income if held at least 2 years: $300.00 .............(!!!,
> Author)
> Qualifying or Disqualifying: Qualifying
> -------------------------------
> My question is, why does it brake it down into $50 for long
> term net gain and $300 for ordinary income? And why is it
> ordinary income "if held at least 2 years" (that's
> TurboTaxes standard phrase in the ESPP worksheet, item 5c)?
> Could it be that it is somehow cofused and expects to see
> something reported on W-2, and since 0 is entered invents
> this creative way to report it as compensation? But it still
> does not explain the possibility of entry "Ordinary income
> if held at least 2 years". When is ESPP sale reported as
> ordinary income after holding for 2 years anyway.
> Very confused and needing help,


TurboTax is Correct

See Situation 3:
http://www.turbotax.com/articles/Emp...hasePlans.html

I ran your numbers in a spreadsheet I have that I created
from the above "rules".

If you question the validity of the TT article "rules", they
are derived from Page 10 of IRS Publication 525.
http://www.irs.gov/pub/irs-pdf/p525.pdf

<< -------------------------------------------------> << The Charter and the Guidelines for submitting > << messages to this newsgroup are at www.asktax.org > << ------------------------------------------------->
  #2  
Old 04-12-2004, 10:33 AM
Rich Carreiro
Guest
 
Posts: n/a
Default Re: ESPP Turbo Tax worksheet -- does not make sense?!

kruzo[at]yahoo.com (kuzo robinson) writes:

- quote -

> Offering grant date 06/01/2001
> Market price per share at offering date $20
> Discount percentage 15.00%
> Purchase or exercise date 05/31/2002
> Market price per share at purchase (exercise) date $10
> Stock price per share actually paid at purchase date $8.50
> Commission -- $0
> Date sold 08/04/2003
> Number of shares sold 100.
> Sale proceeds (Form 1099-B, prorated if necessary) 1,200.00
> So, according to my understanding, the total cost is
> $8.50 x 100 = $850


No.

- quote -

> And the total net long term gain is $350, right?

No.

TurboTax did it properly.

- quote -

> My question is, why does it brake it down into $50 for long
> term net gain and $300 for ordinary income? And why is it


Because that's how qualifying sales of ESPP stock is taxes.

- quote -

> Could it be that it is somehow cofused and expects to see
> something reported on W-2,


No.

- quote -

> does not explain the possibility of entry "Ordinary income
> if held at least 2 years". When is ESPP sale reported as
> ordinary income after holding for 2 years anyway.


Whenever the stock is sold for more than the purchase price.
When ESPP stock is sold at a profit, some/all of the discount
is recaptured as ordinary income no matter how long you've
held the stock.

Here are the rules, as I have summarized them out of books
like Kaye Thomas's _Compensation in Stock and Options_ and
elsewhere. At the end of this rules description there is
a calculation of your case and you'll see that TT
did it right.

Prelims:
(1) Any gain considered capital gets long-term status if the
stock is held more than 12 months from the day you actually
purchase it (i.e. the *end* of the offering period).
(2) There is a special holding period for ESPPs - you meet this
holding period on that *later* of:
(a) Two years from the beginning of the offering period, or
(b) One year from the day you actually purchased the stock.

(3) There are five prices involved. They are
(a) The purchase price (P).
(b) The actual stock price at the beginning of the
offering period (B).
(c) The actual stock price at the end of the
offering period (E).
(d) The actual stock price when you sell (S).
(e) The hypothetical start-of-period purchase
price (H), which is the price you would pay
for the stock if the purchase price ended up
being based on the stock price at the beginning
of the offering period. Obviously, if the stock
price went up during the period, H=P.

Ok..

If the special holding period is *not* met:
(a) E-P is recognized as wage income. This happens
regardless of what S is. Even if you sell at a
loss, you have E-P of wage income.
(b) Since you do recognize E-P of income, that income
is added to your "raw" basis (which is P -- what you
paid for it) to get your adjusted basis. P + E - P = E.
(c) As your basis has been adjusted to E, your capital gain or
loss on the sale is S-E. This is long-term if you sold more
than a year after purchase.

If the special holding period *is* met, things are
rather weirder, since the beginning of the offering
period comes into play, not the end:
(a) If you sell at a loss (i.e. S<P), you have *no* wage income
to recognize. Your basis is P, your sales proceeds are S,
your gain is S-P, which is a loss since S<P.
(b) If you sell at a profit (i.e. S> P), you do have to report some wage
income. The amount of wage income you report is the
*lesser* of:
(1) Your actual profit, i.e. S-P, or
(2) The difference between the stock price at the
beginning of the period and the hypothetical
start-of-period purchase price, i.e. B-H.
(c) Any recognized wage income in (b) is added to
your "raw" basis P to get your adjusted basis.
You then subtract that from S to get your capital
gain or loss, which will always be long-term, since
if the special holding period is met, that implies
the stock was held long-term.

Ok, in your case the special holding period is met and therefore
we have to worry about B and H. For you the numbers are:
B = value of stock at beginning of offering period = $20.00
H = purchase price of stock *if* purchase was based on
the beginning-of-period price = $20 - 15% of $20 = $17
E = stock price at end of period = $10.00
P = what you actually paid = $8.50
S = what you sold for = $12.00

You sold for an actual, economic profit, i.e. S> P. Therefore
your ordinary income will be the *lesser* of:
S - P = $12.00 - $8.50 = $3.50
B - H = $20.00 - $17.00 = $3.00
The lesser of the numbers is $3.00. So you will have $3.00
of ordinary income and your basis for computing capital gain/loss
will be $8.50 + $3.00 = $11.50.

You sold 100sh, so you'll pick up $300 of ordinary income.
Likewise, your gain is $1200 - ($11.50*100sh) = $50, just
like TT said.

--
Rich Carreiro rlcarr[at]animato.arlington.ma.us

<< -------------------------------------------------> << The Charter and the Guidelines for submitting > << messages to this newsgroup are at www.asktax.org > << ------------------------------------------------->
  #1  
Old 04-12-2004, 08:37 AM
Andy Green
Guest
 
Posts: n/a
Default Re: ESPP Turbo Tax worksheet -- does not make sense?!

kruzo[at]yahoo.com (kuzo robinson) wrote:

- quote -

> I am using TurboTax to report the ESPP.
> It makes no sense to me how the worksheet brakes down what I
> think should be reported as long term gaim into 2: long term
> gain and Oridinary income.
> Here are the details of a SAMPLE calculation:
> Offering grant date 06/01/2001
> Market price per share at offering date $20
> Discount percentage 15.00%
> Purchase or exercise date 05/31/2002
> Market price per share at purchase (exercise) date $10
> Stock price per share actually paid at purchase date $8.50
> Commission -- $0
> Date sold 08/04/2003
> Number of shares sold 100.
> Sale proceeds (Form 1099-B, prorated if necessary) 1,200.00
> So, according to my understanding, the total cost is
> $8.50 x 100 = $850
> And the total net long term gain is $350, right?
> The way Turbo Tax caluclates it is this:
> -------------------------------
> Amounts reported on: Schedule D
> Cost $1,150.00
> Net gain (loss) $50.00 ..................(!!!, Author)
> Long-term or short-term: Long-term
> Amount to be reported as compensation - usually on Form W-2:0.00
> Is the amount on line 5a or 5c already included on Form W-2 Box 1? NO
> Ordinary income if held at least 2 years: $300.00 .............(!!!,
> Author)
> Qualifying or Disqualifying: Qualifying
> -------------------------------
> My question is, why does it brake it down into $50 for long
> term net gain and $300 for ordinary income? And why is it
> ordinary income "if held at least 2 years" (that's
> TurboTaxes standard phrase in the ESPP worksheet, item 5c)?
> Could it be that it is somehow cofused and expects to see
> something reported on W-2, and since 0 is entered invents
> this creative way to report it as compensation? But it still
> does not explain the possibility of entry "Ordinary income
> if held at least 2 years". When is ESPP sale reported as
> ordinary income after holding for 2 years anyway.


Is the plan such that you buy the stock at the lower of the
first or last day of the pan year? If so the you would pay
the lower - 15 % and that would be the discount. If you sold
after the grant date and the stock went down you'd owe tax
on the discount and have a loss at the end of the year. If
you hold it more than a year, I thought it was now qualified
and you pay the long term tax rate,.

<< -------------------------------------------------> << The Charter and the Guidelines for submitting > << messages to this newsgroup are at www.asktax.org > << ------------------------------------------------->
 
Old 04-12-2004, 08:17 AM
Drew Edmundson
Guest
 
Posts: n/a
Default Re: ESPP Turbo Tax worksheet -- does not make sense?!

ruzo[at]yahoo.com (kuzo robinson) wrote:

- quote -

> I am using TurboTax to report the ESPP.
> It makes no sense to me how the worksheet brakes down what I
> think should be reported as long term gaim into 2: long term
> gain and Oridinary income.


snip

Sorry, I didn't read beyond this paragraph. In my
experience Intuit doesn't know what it is doing when it
comes to ISOs and ESPPs.

Drew Edmundson, CPA (NC)

<< -------------------------------------------------> << The Charter and the Guidelines for submitting > << messages to this newsgroup are at www.asktax.org > << ------------------------------------------------->
  #-1  
Old 04-08-2004, 07:44 PM
kuzo robinson
Guest
 
Posts: n/a
Default ESPP Turbo Tax worksheet -- does not make sense?!

I am using TurboTax to report the ESPP.
It makes no sense to me how the worksheet brakes down what I
think should be reported as long term gaim into 2: long term
gain and Oridinary income.

Here are the details of a SAMPLE calculation:

Offering grant date 06/01/2001
Market price per share at offering date $20
Discount percentage 15.00%
Purchase or exercise date 05/31/2002
Market price per share at purchase (exercise) date $10
Stock price per share actually paid at purchase date $8.50
Commission -- $0
Date sold 08/04/2003
Number of shares sold 100.
Sale proceeds (Form 1099-B, prorated if necessary) 1,200.00

So, according to my understanding, the total cost is
$8.50 x 100 = $850
And the total net long term gain is $350, right?

The way Turbo Tax caluclates it is this:
-------------------------------
Amounts reported on: Schedule D

Cost $1,150.00
Net gain (loss) $50.00 ..................(!!!, Author)
Long-term or short-term: Long-term

Amount to be reported as compensation - usually on Form W-2:0.00

Is the amount on line 5a or 5c already included on Form W-2 Box 1? NO
Ordinary income if held at least 2 years: $300.00 .............(!!!,
Author)
Qualifying or Disqualifying: Qualifying
-------------------------------

My question is, why does it brake it down into $50 for long
term net gain and $300 for ordinary income? And why is it
ordinary income "if held at least 2 years" (that's
TurboTaxes standard phrase in the ESPP worksheet, item 5c)?

Could it be that it is somehow cofused and expects to see
something reported on W-2, and since 0 is entered invents
this creative way to report it as compensation? But it still
does not explain the possibility of entry "Ordinary income
if held at least 2 years". When is ESPP sale reported as
ordinary income after holding for 2 years anyway.

Very confused and needing help,

K

<< -------------------------------------------------> << The Charter and the Guidelines for submitting > << messages to this newsgroup are at www.asktax.org > << ------------------------------------------------->
 

Tags
espp, make, sense, tax, turbo, worksheet
Similar Threads
Thread Forum Replies Last Post
Printing Home Inventory Worksheet Report in Money Deluxe 2005
dfavorito: Can anyone tell me how to print a "home inventory worksheet report" or export it to Excel in Money Deluxe 2005? I have printed this report in the...
Microsoft Money 2 02-26-2005 12:43 AM
Home invetory worksheet in mm 2005
Zak Karachiwala: Where is the home inventory worksheet located in MS Money 2005? It says I can enable it in the help file but I cannot. Any ideas?
Microsoft Money 1 10-03-2004 09:15 AM
This makes no sense
Edison Stewart: I have bought 500 bonds at $10 each. Money tells me this cost me $50. In fact, it cost me $5,000. Is there some way I can enter accurate info (ie.,...
Microsoft Money 10 04-10-2004 08:47 PM
Itemized Deduction Worksheet
steel: Is it even POSSIBLE for line 2 to NOT be less than line 1? I cannot see how that could possibly be. <<...
Taxes 1 02-10-2004 03:50 AM
balances that don't make sense
Discouraged Money User: I've had Money 2002 Deluxe since it came out. I've gone through the setup thing at least 20 times and I still have problems getting any statements...
Microsoft Money 2 01-22-2004 03:50 PM



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT. The time now is 09:39 AM.