4a. Directions and tips for "Pre2001" spreadsheet (Updated April 7, 2018.) Questions or comments to: email@example.com
When to use this spreadsheet:
If acquired via employee stock purchase plan.
- Acquired 1959 through
10/31/2000. To determine your cost basis for each lot of
spinoff shares, you select from rows that have been
pre-filled with official data for each SOP or ESPP purchase
- If acquired 11/01/2000 through 10/31/2017, use a different spreadsheet. For this time period, you need to determine cost basis and ordinary income or capital gain for each lot of spinoff shares. Go to Stock spreadsheets and download our Post-2000 Cost Basis and Spinoff Tax Calculator.
If acquired via service award, option, equity award plan, or open-market purchase -- i.e. not via employee stock purchase. From your records, you enter date and your cost basis for each lot. This spreadsheet does not assist with determining ordinary income vs. capital gain. Again use the HPAA's Pre-2001 Cost Basis and Spinoff Tax Calculator: HPQ-Pre2001-SpinoffTaxCalc-v14.xlsx
Based on how and when you acquired the stock, select one or more tabs in the spreadsheet...
If acquired via employee stock purchase plan.
- If acquired 1959 through 10/31/2000. Select the "A. HWP-HPQ" tab along the bottom edge. Select from rows that have been pre-filled with official data for each SOP or ESPP purchase cycle.
For a "one share walk-through" explanation of this spreadsheet: Pre2001 Example
If acquired via service award, option, equity award plan, dividend reinvestment program, or open-market purchase -- i.e. not acquired via employee stock purchase.
HPQ shares acquired 1959 through 10/31/2000. -- select the "A.
HWP-HPQ" tab along bottom edge. For each lot of stock acquired via a
service award, option, or other equity award,
- HPQ shares acquired after 11/1/2000 -- select "B. HPQ >Nov2000" tab along bottom edge. From your records, enter date and your cost basis for each lot.
- HPE shares acquired after 10/21/2015 -- select "C. HPE >Oct2015" tab along bottom edge. From your records, enter date and your cost basis for each lot.
Version 14, updated on March 30 with the help of many members, includes:
- Keysight spinoff from Agilent, dividend reinvestment purchases, 2002 accelerated vesting, checksums, and details behind the spinoff numbers.
- If you do not have employee purchase records -- or did not input your lot-and-cost information into your broker's system -- for a particular time period before 3/1/2002, you can now estimate the average cost basis for HP, HPE, Agilent, Keysight, DXC, SpinCo, and Micro Focus stock over that period. Scroll to the far right on Tab A. If there is an example 'x' in cell AB11, remove it. Enter an "x" in column AB for each quarter to be included in the estimate. Average current cost basis for each stock is displayed in row 4. This approach makes many simplifying assumptions -- but is simple and easy to audit.
The "Data" tab has values used by the other worksheets:
- For each spinoff, the parent company supplied a cost basis letter which suggested a method of determining the fair market values for the shares of both companies after the spinoff. Those values have been entered on the "Data" worksheet. (The various cost basis letters are linked via the HPAA's Stock Decoder page.)
- If your broker used a different method, substitute your broker's tax basis percentage in the appropriate cell on the "Data" worksheet.
Excel: Tips for using complex spreadsheets -- with links to Microsoft articles.
Be sure to save the documents you used -- including a copy of the HPE "Dear Shareholder" letter.
Be sure to save the spreadsheets you have modified -- under a different name -- and keep them for future reference when you sell shares, etc.
Go back to: 4. Stock Spreadsheets
Disclaimer. The information contained in this website, or sites linked to it, is provided as a service to the community, and does not constitute financial, legal, or personal advice. We make no claims, promises or guarantees about the accuracy, completeness, or adequacy of the information contained in or linked to this website and associated sites. As financial, legal, and personal advice must be tailored to the specific circumstances of each case, and finances and laws are constantly changing, nothing provided here should be used as a substitute for the personal advice of competent financial, legal, and personal advisors.
For more mutual help on this topic and many others, join the independent HP Alumni Association. If you were formerly a regular, direct employee of Hewlett-Packard, HP Inc, or Hewlett Packard Enterprise -- or have a defined retirement or termination date, join the HPAA. No charge, thanks to HPAA members.
© 2018 Hewlett-Packard Alumni Association, Inc. • By using this site you accept these terms • Operated by former employees who volunteer their time. Not endorsed or supported by the company.