Google Answers Logo
View Question
 
Q: Business and Money ( Answered,   0 Comments )
Question  
Subject: Business and Money
Category: Miscellaneous
Asked by: otter4-ga
List Price: $200.00
Posted: 20 Jun 2003 17:53 PDT
Expires: 20 Jul 2003 17:53 PDT
Question ID: 219884
I'll be out of town until 6-26, so I hope this can be answered without
clarification:  If I have $ 5,000.00 worth of ATT stock on June 30,
1965 and that stock is followed up to today, (excluding dividend
reinvestment) with all the spinoffs, (ex. baby bells, Lucent,
etc.)splits, mergers, and other events of all of it,what would it all
look like today?
Answer  
Subject: Re: Business and Money
Answered By: websearcher-ga on 20 Jun 2003 22:06 PDT
 
Hello otter4:

Thanks for the challenging question. 

To answer your question required several steps. 


Step 1: Determine how many shares of AT&T you would own pre-1984.

Given that your AT&T stock was worth $5,000 on 06/30/1965, I had to
find the closing price for the stock that day to determine how many
shares you would own.

As you can see from the following page of stock quotes, AT&T (stock
symbol "T") closed at $67.37 on 06/30/1965. That means, you would have
owned 74.217 shares in AT&T.

Historical Prices - T (AT&T CORP) 
URL: http://table.finance.yahoo.com/d?a=5&b=1&c=1965&d=5&e=30&f=1965&g=d&s=t

As you can see from the following page, no stock splits occurred
between 06/30/1965 and 12/31/83, the day before the infamous "Baby
Bell" Divestiture.

Events Impacting Your Tax Basis
URL: http://www.att.com/ir/ss/tbi/reorgbknd.html

This, of course, means that you would still have had 74.217 shares of
AT&T before the 1984 Divestiture.


Step 2: Determine what stock in what companies you would have received
between 01/01/1984 and 06/20/2003.

This is, by far, the most challenging step. So challenging, in fact,
that the only reasonable way to calculate it is to purchase an AT&T
Divestiture program specifically set uo to follow the 36 adjustments
for spin-offs and 24 adjustments for stock splits that have happened
in that period.

The most reliable program for this calculation that I found was the
AT&T Divestiture Basis Tracker from Denver Tax Software.

AT&T Divestiture Basis Tracker
URL: http://www.denvertax.com/att-tax-basis/Default.htm

I purchased this software on your behalf (it will come out of my share
of the $200 fee - you needn't pay any more) and used it to calculate
how many shares of which companies you would now own. The summarized
results are as follows:

[Please bear with me if the results from this program don't format
correctly in Google Answers the first time around. If there's a
problem, I'll reformat and repost as a Clarification.]

  Security: AT&T
  Description    Date                  Shares              
  -----------  ----------    ----------------   
  Buy          12/31/1983            74.21700    

  
  Summary - AT&T and Related Securities Summary Basis on 06/20/2003

  Security                        Shares          
  --------                        ------     
  AT&T                          27.90559    
  Lucent Technologies           96.21016    
  Avaya                          8.01719    
  NCR                            4.63856    
  Qwest                         52.74002 
  AT&T Wireless                 44.90010 
  BellSouth                    133.59060 
  Vodafone                      74.21700  
  SBC Communications           249.69271  
  Verizon                      104.97252  
  Agere Class A                  1.03705  
  Agere Class B                 25.45365  
  Comcast                       45.13730  


Step 3: Determine the worth of these stock at today's prices. 

To do this step, I simply went to Yahoo!Finance and found today's
closing price for each stock listed above, then did the math.

  Security       Shares       Price       Value
  ********       ********     ******      *******
  AT&T           27.90559     $20.43     $ 570.11
  Lucent         96.21016     $ 2.07     $ 199.16
  Avaya           8.01719     $ 6.94     $  55.64
  NCR             4.63856     $26.35     $ 122.23 
  Qwest          52.74002     $ 5.23     $ 275.83
  AT&T Wireless  44.90010     $ 7.93     $ 356.06
  BellSouth     133.59060     $27.29     $3645.69     
  Vodafone       74.21700     $20.67     $1534.06
  SBC Comms     249.69271     $26.10     $6516.98 
  Verizon       104.97252     $41.21     $4325.92
  Agere Cl. A     1.03705     $ 2.46     $   2.55
  Agere Cl. B    25.45365     $ 2.39     $  60.83
  Comcast        45.13730     $31.47     $1420.47

  Total Value:                          $19085.93 


So, your original stock value of $5,000 would be worth $19,085.93
today. It would have, of course, been worth *significantly* more a few
years ago - before the big "market meltdown" occurred.

[Note: Now, you need to keep in mind that this is a largely
"theoretical" calculation. Since you started off with a fractional
number of shares (74.217), you ended up getting very fractional
numbers of subsequent stocks. In many cases, when splits and spin-offs
occurred, you probably would have had to round-down the number of
stock and get a little cash as well.]

I will create a Clarification to this question with the actual
detailed transaction report listing all the splits, acquisitions, and
spin-offs - in case you're interested.


I hope this information helps with your research.       
                                
If you need any clarification of the information I have provided,
please ask using the clarification feature and provide me with
additional details as to what you are looking for. As well, please
allow me to provide you with clarification(s) *before* you rate this
answer.
                                
Thank you.                                 
                                
websearcher-ga                                 
                                                  
         
Search Strategy (on Google):          

AT&T divestiture
AT&T historical "Stock prices"

Clarification of Answer by websearcher-ga on 20 Jun 2003 22:08 PDT
Hi otter4:

Here's the promised detail file:

websearcher-ga


  AT&T and Related Securities Detailed Basis Report on 06/20/2003

  AT&T
  Description        Date             Shares          Basis  Cost Per Share
  --------------  ----------   -------------  -------------  --------------
  Buy             12/31/1983        74.21700       4,564.35
                               -------------  -------------
                                    74.21700       4,564.35        61.50010
  Spin off        12/31/1983         0.00000      -3,263.51
                               -------------  -------------
                                    74.21700       1,300.84        17.52750
  Spin off        09/30/1996         0.00000        -364.11
                               -------------  -------------
                                    74.21700         936.73        12.62150
  Spin off        12/31/1996         0.00000         -44.68
                               -------------  -------------
                                    74.21700         892.05        12.01950
  Split           04/15/1999        37.10850           0.00
                               -------------  -------------
                                   111.32550         892.05         8.01300
  Cash or stock   06/15/2000        28.20246         157.82
                               -------------  -------------
                                   139.52796       1,049.87         7.52440
  Spin off        07/09/2001         0.00000        -234.54
                               -------------  -------------
                                   139.52796         815.33         5.84350
  Spin off        11/18/2002         0.00000        -510.40
                               -------------  -------------
                                   139.52796         304.93         2.18540
  Split           11/18/2002      -111.62237           0.00
                               -------------  -------------
                                    27.90559         304.93        10.92720

  Lucent Technologies
  Description        Date             Shares          Basis  Cost Per Share
  --------------  ----------   -------------  -------------  --------------
  Spin off        09/30/1996        24.05254         364.11
                               -------------  -------------
                                    24.05254         364.11        15.13810
  Split           04/02/1998        24.05254           0.00
                               -------------  -------------
                                    48.10508         364.11         7.56910
  Split           04/05/1999        48.10508           0.00
                               -------------  -------------
                                    96.21016         364.11         3.78450
  Spin off        10/02/2000         0.00000         -19.94
                               -------------  -------------
                                    96.21016         344.17         3.57730
  Spin off        06/01/2002         0.00000         -62.83
                               -------------  -------------
                                    96.21016         281.34         2.92420

  Avaya
  Description        Date             Shares          Basis  Cost Per Share
  --------------  ----------   -------------  -------------  --------------
  Spin off        10/02/2000         8.01719          19.94
                               -------------  -------------
                                     8.01719          19.94         2.48720

  NCR
  Description        Date             Shares          Basis  Cost Per Share
  --------------  ----------   -------------  -------------  --------------
  Spin off        12/31/1996         4.63856          44.68
                               -------------  -------------
                                     4.63856          44.68         9.63230

  US West
  Description        Date             Shares          Basis  Cost Per Share
  --------------  ----------   -------------  -------------  --------------
  Spin off        12/31/1983         7.42170         408.05
                               -------------  -------------
                                     7.42170         408.05        54.98070
  Split           05/09/1986         7.42170           0.00
                               -------------  -------------
                                    14.84340         408.05        27.49030
  Split           04/19/1990        14.84340           0.00
                               -------------  -------------
                                    29.68680         408.05        13.74520
  Spin off        11/01/1995       -29.68680        -408.05
                               -------------  -------------
                                     0.00000           0.00         0.00000

  MediaOne
  Description        Date             Shares          Basis  Cost Per Share
  --------------  ----------   -------------  -------------  --------------
  Spin off        11/01/1995        29.68680         163.95
                               -------------  -------------
                                    29.68680         163.95         5.52270
  Spin off        06/12/1998         0.00000          -6.13
                               -------------  -------------
                                    29.68680         157.82         5.31620
  Acquisition     06/15/2000       -29.68680        -157.82
                               -------------  -------------
                                     0.00000           0.00         0.00000

  US West Communications
  Description        Date             Shares          Basis  Cost Per Share
  --------------  ----------   -------------  -------------  --------------
  Spin off        11/01/1995        29.68680         244.10
                               -------------  -------------
                                    29.68680         244.10         8.22250
  Spin off        06/12/1998         0.81075           6.13
                               -------------  -------------
                                    30.49755         250.23         8.20490
  Acquisition     06/30/2000       -30.49755        -250.23
                               -------------  -------------
                                     0.00000           0.00         0.00000

  Qwest
  Description        Date             Shares          Basis  Cost Per Share
  --------------  ----------   -------------  -------------  --------------
  Acquisition     06/30/2000        52.74002         250.23
                               -------------  -------------
                                    52.74002         250.23         4.74460

  AT&T Wireless
  Description        Date             Shares          Basis  Cost Per Share
  --------------  ----------   -------------  -------------  --------------
  Spin off        07/09/2001        44.90010         234.54
                               -------------  -------------
                                    44.90010         234.54         5.22360

  BellSouth
  Description        Date             Shares          Basis  Cost Per Share
  --------------  ----------   -------------  -------------  --------------
  Spin off        12/31/1983         7.42170         617.56
                               -------------  -------------
                                     7.42170         617.56        83.21000
  Split           05/22/1984        14.84340           0.00
                               -------------  -------------
                                    22.26510         617.56        27.73670
  Split           02/23/1987        11.13255           0.00
                               -------------  -------------
                                    33.39765         617.56        18.49110
  Split           11/08/1995        33.39765           0.00
                               -------------  -------------
                                    66.79530         617.56         9.24560
  Split           12/24/1998        66.79530           0.00
                               -------------  -------------
                                   133.59060         617.56         4.62280

  Pacific Telesis
  Description        Date             Shares          Basis  Cost Per Share
  --------------  ----------   -------------  -------------  --------------
  Spin off        12/31/1983         7.42170         405.31
                               -------------  -------------
                                     7.42170         405.31        54.61150
  Split           06/09/1986         7.42170           0.00
                               -------------  -------------
                                    14.84340         405.31        27.30570
  Split           03/25/1987        14.84340           0.00
                               -------------  -------------
                                    29.68680         405.31        13.65290
  Spin off        04/01/1994         0.00000        -161.44
                               -------------  -------------
                                    29.68680         243.87         8.21480
  Acquisition     04/01/1997       -29.68680        -243.87
                               -------------  -------------
                                     0.00000           0.00         0.00000

  AirTouch Communications
  Description        Date             Shares          Basis  Cost Per Share
  --------------  ----------   -------------  -------------  --------------
  Spin off        04/01/1994        29.68680         161.44
                               -------------  -------------
                                    29.68680         161.44         5.43810
  Acquisition     06/30/1999       -29.68680        -161.44
                               -------------  -------------
                                     0.00000           0.00         0.00000

  Vodafone
  Description        Date             Shares          Basis  Cost Per Share
  --------------  ----------   -------------  -------------  --------------
  Acquisition     06/30/1999        14.84340         161.44
                               -------------  -------------
                                    14.84340         161.44        10.87620
  Split           10/04/1999        59.37360           0.00
                               -------------  -------------
                                    74.21700         161.44         2.17520

  SBC Communications
  Description        Date             Shares          Basis  Cost Per Share
  --------------  ----------   -------------  -------------  --------------
  Spin off        12/31/1983         7.42170         433.16
                               -------------  -------------
                                     7.42170         433.16        58.36400
  Split           05/22/1987        14.84340           0.00
                               -------------  -------------
                                    22.26510         433.16        19.45470
  Split           05/25/1993        22.26510           0.00
                               -------------  -------------
                                    44.53020         433.16         9.72730
  Acquisition     04/01/1997        21.71441         243.87
                               -------------  -------------
                                    66.24461         677.03        10.22020
  Split           03/19/1998        66.24461           0.00
                               -------------  -------------
                                   132.48922         677.03         5.11010
  Acquisition     10/08/1999       117.20349         471.50
                               -------------  -------------
                                   249.69271       1,148.53         4.59980

  Ameritech
  Description        Date             Shares          Basis  Cost Per Share
  --------------  ----------   -------------  -------------  --------------
  Spin off        12/31/1983         7.42170         471.50
                               -------------  -------------
                                     7.42170         471.50        63.52990
  Split           01/26/1987         3.71085           0.00
                               -------------  -------------
                                    11.13255         471.50        42.35330
  Split           01/26/1989        11.13255           0.00
                               -------------  -------------
                                    22.26510         471.50        21.17660
  Split           01/24/1994        22.26510           0.00
                               -------------  -------------
                                    44.53020         471.50        10.58830
  Split           01/26/1998        44.53020           0.00
                               -------------  -------------
                                    89.06040         471.50         5.29420
  Acquisition     10/08/1999       -89.06040        -471.50
                               -------------  -------------
                                     0.00000           0.00         0.00000

  Nynex
  Description        Date             Shares          Basis  Cost Per Share
  --------------  ----------   -------------  -------------  --------------
  Spin off        12/31/1983         7.42170         449.13
                               -------------  -------------
                                     7.42170         449.13        60.51580
  Split           05/01/1986         7.42170           0.00
                               -------------  -------------
                                    14.84340         449.13        30.25790
  Split           09/15/1993        14.84340           0.00
                               -------------  -------------
                                    29.68680         449.13        15.12900
  Acquisition     08/14/1997       -29.68680        -449.13
                               -------------  -------------
                                     0.00000           0.00         0.00000

  Bell Atlantic
  Description        Date             Shares          Basis  Cost Per Share
  --------------  ----------   -------------  -------------  --------------
  Spin off        12/31/1983         7.42170         478.80
                               -------------  -------------
                                     7.42170         478.80        64.51350
  Split           04/17/1986         7.42170           0.00
                               -------------  -------------
                                    14.84340         478.80        32.25680
  Split           05/01/1990        14.84340           0.00
                               -------------  -------------
                                    29.68680         478.80        16.12840
  Acquisition     08/14/1997        22.79946         449.13
                               -------------  -------------
                                    52.48626         927.93        17.67950
  Split           06/29/1998        52.48626           0.00
                               -------------  -------------
                                   104.97252         927.93         8.83970
  Acquisition     06/30/2000      -104.97252        -927.93
                               -------------  -------------
                                     0.00000           0.00         0.00000

  Verizon
  Description        Date             Shares          Basis  Cost Per Share
  --------------  ----------   -------------  -------------  --------------
  Acquisition     06/30/2000       104.97252         927.93
                               -------------  -------------
                                   104.97252         927.93         8.83970

  Agere Class A
  Description        Date             Shares          Basis  Cost Per Share
  --------------  ----------   -------------  -------------  --------------
  Spin off        06/01/2002         1.03705           2.46
                               -------------  -------------
                                     1.03705           2.46         2.37210

  Agere Class B
  Description        Date             Shares          Basis  Cost Per Share
  --------------  ----------   -------------  -------------  --------------
  Spin off        06/01/2002        25.45365          60.37
                               -------------  -------------
                                    25.45365          60.37         2.37180

  Comcast
  Description        Date             Shares          Basis  Cost Per Share
  --------------  ----------   -------------  -------------  --------------
  Spin off        11/18/2002        45.13730         510.40
                               -------------  -------------
                                    45.13730         510.40        11.30770
Comments  
There are no comments at this time.

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