Logo

Stock Menu    Stock Issues    Spinoff Shares    Stock Decoder    Where is my stock?    Unclaimed property    Admins and Brokers    Cost Basis    Taxes    Map of Stock Pages


6a. Directions and tips for "Pre2001" spreadsheet  

This page is one step of our Stock Recovery Process. There is a link to the next step at the end of this page. If you haven't gone through the previous steps to determine which of six HP-related stocks you should have, start here: Employee Stock

Website operated by volunteers. Not officially endorsed or supported. Comments: info@hpalumni.org  (Updated Feb 28, 2021.)  Comments: info@hpalumni.org

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 cycle.
Download the HPAA's Pre-2001 Cost Basis and Spinoff Tax Calculator: HPQ-Pre2001-SpinoffTaxCalc-v14.xlsx  

- 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 cost basis 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   


Directions:

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,
find a row in the appropriate date range and replace the pre-filled date and cost-basis with your own date and cost-basis. Be sure to use Excel's horizontal scrollbar in the lower right corner to move across the columns.

 - 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.

If you don't have good records -- or did not input your lot-and-cost information into your broker's system -- you can use our spreadsheet to estimate your cost basis for each HP-related stock for any span of HP employment from 7/1/1959 through the 11/1/2000 plan changeover.

Scroll to the right half of the HWP-HPQ sheet. Columns A and B and rows 1 through 6 are frozen so that they remain visible.

1. Find the date of your first employee stock purchase in column A.

2. Enter an "x" in column AB of that row.

3. Continue down column AB, entering an "x" for each date you acquired stock -- including your last stock purchase date.

Estimated average cost basis for each stock over the selected time period is displayed in row 4 to the right.

Do not change anything else on the spreadsheet!

This approach makes many simplifying assumptions -- but is simple and easy to audit.

How the spreadsheet works. The "Data" tab has values used by the other worksheets:

- For each spinoff, the parent company supplied a tax 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 tax 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 -- plus, for future reference, copies of the HPE "Dear Shareholder" letter (which was not actually sent to shareholders.)  

Be sure to save the spreadsheets you have modified -- under a different filename -- and keep them for future reference when you sell shares, etc.

Go back to:  6. Stock cost basis spreadsheets 


If formerly a regular, direct U.S. employee of HP or HPE -- or are in the process of leaving -- join the HP Alumni Association. No charge, thanks to HPAA's Supporting Members.


Operated by volunteers. Not officially endorsed or supported.  2023 Hewlett-Packard Alumni Association, Inc. By using this site you accept these terms.