|
|
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
Cost Basis Spreadsheets (Apr 12, 2024) Question? Email: info@hpalumni.org
The HPAA's employee purchase spreadsheets.
- Official quarterly cost basis data for every HP stock purchase from 1959 through 2000 -- with resulting calculated lot-by-lot cost basis for HPQ, Agilent, Keysight, HPE, DXC, Micro Focus "A" shares, Micro Focus "B" shares and sale to OpenText.
- Estimate your average cost basis over any span of HP employment from 1959 through 2000 for HPQ, Agilent, Keysight, HPE, DXC, Micro Focus "A" shares, Micro Focus "B" shares.
- Calculate ordinary income/capital gain lot-by-lot from 11/2000 to 10/2017 for HPQ, Agilent, Keysight, HPE, DXC, and Micro Focus "A" shares.
Note. The cost basis treatment for the 2017 Micro Focus spinoff and merger used in the HPAA Cost Basis spreadsheets is based on a legal opinion provided to HPE by outside tax counsel.
Which spreadsheets to download?
The spreadsheets you need depend on how and when you acquired your stock lots.
Be sure you are using current versions.
A. If acquired via employee stock purchase plan. The HPAA Cost Basis spreadsheets cover the various stock purchase plans over the years (which had discounts varying between 33% and 0%.)
-
If employee stock purchase 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.
Use our
Pre-2001 spreadsheet:
Version 15, updated April 11, 2024, includes:
Keysight, dividend reinvestment (DRIP),
2002 accelerated vesting.
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. See the
Directions and tips page for details.
Click to download:
HPQ-Pre2001-SpinoffTaxCalc-v15b.xlsx
Directions and tips
Reference example
- If employee stock purchase
11/01/2000 through 10/31/2017. For this time period, the
HP employee purchase plan was more complex and you need to
determine ordinary income or capital gain.
Use a different spreadsheet -- our
Post-2000 spreadsheet.
Click to download:
HPQ-Post2000-SpinoffTaxCalc-v01.xlsx
(There are two tabs -- one for HPQ and one for HPE and HPE
spinoffs. Directions are included in the spreadsheet.)
B. If acquired via service award, option,
equity award plan, dividend reinvestment program, or open-market
purchase -- i.e. not via employee stock purchase.
Again, use our
Pre-2001 spreadsheet.
Click to download:
HPQ-Pre2001-SpinoffTaxCalc-v15b.xlsx
C. If acquired via Compaq employee stock purchase plan. Click to download: CPQ-ESPP-SpinoffTaxCalc-v01.xlsx
Tips:
- Excel tips: Member tips on using complex spreadsheets -- with links to Microsoft articles.
- Member advice on Obtaining Stock Records
- For any of the spinoffs, your broker may have used a different formula than the one suggested in the Cost Basis letter provided by the company -- resulting in a somewhat different value. For example, Fidelity stock issues reported by members (For the HPE/MFGP/"Seattle Spinco" spinoff... This "Dear Shareholder" letter does not appear to have been actually sent to all shareholders. Members report that HPE's cost-basis tracking recommendations are not reflected in the records at some brokerages, plan administrators, and transfer agents -- and not uniformly followed by others.)
- If you set up a dividend reinvestment program (DRIP) in any of your accounts, additional shares were automatically purchased at market price. You paid taxes on the dividends. The resulting shares have a cost basis and spinoff spinoff shares, but the special ESPP tax calculations do not apply -- therefore, DRIP is not included in the Post-2000 spreadsheet. DRIP is included in Version 14 of the Pre-2001 spreadsheet.
- Be sure to save the spreadsheets you have modified -- under a different filename -- and keep them for future reference when you sell shares, etc.
Notes:
- The HPAA Cost Basis spreadsheets are based on dates and values from official HP documents. Your records may show transactions executed a day or two later -- or with a penny or two cost variation due to rounding.
- The current spreadsheet versions supersede recent files named "MicroFocusUSTax..." and "HPRelatedStockBasis..." -- plus HPAA files named "HP...Stock_Purchase_Valuation..." dating back to 2004.
Suggested next step: Stock Tax Return Member advice on stock issues for U.S. tax return. Includes "Using TurboTax for ESPP shares" -- step-by-step with screenshots.
Helping each other with life after HP and HPE: Website Index Forums
Independent, member-supported volunteer association. Not officially endorsed or supported. © 2024 Hewlett-Packard Alumni Association, Inc. By using this site you accept these terms.