Stock-6a. Pre2001 Directions. HP/HPE Alumni

Index WFR/Leaving Contacts Benefits Medicare Stock Pension Working HP/HPE Join

Not officially endorsed or supported. Keep up with HP/HPE-related stock issues: Join HPAA at no charge.

Start here: Stock All articles on stock: Stock Menu

6a. Directions and tips for "Pre2001" spreadsheet

This is one step in our process. Start here: Stock Recovery and Cost Basis

Website operated by volunteers. Not officially endorsed or supported. Question? Email: info@hpalumni.org (Feb 28, 2021) Question? Email: 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 didn't get your lot-and-cost information into your broker's system -- you can use our spreadsheets to develop a reasonable estimate of your cost basis for most HP/HPE-related stocks for any span of HP employment 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.

Members have found that plan administrators, transfer agents, and brokerages vary significantly in how (or if) they track gain/loss and cost basis for the many complex HP-related stock events -- and what (if anything) they report to the IRS. Issues with major brokers

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 Complete Stock Decoder Table )

- 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/MFGP/"Seattle Spinco" letter This "Dear Shareholder" letter does not appear to have been actually sent to all shareholders. Members report that this cost-basis tracking recommendation was disregarded by some brokerages, plan administrators, and transfer agents -- and not uniformly followed by others.

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

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.

Helping each other with life after HP and HPE: Website Index Forums