Step 4. Stock spreadsheets (Updated April 12, 2018.) Questions or comments to: email@example.com
Page updated often -- use browser refresh button to display latest version.
Mutual help for alumni and employee shareholders. Other stockholders should contact the companies directly.
Operated by former employees who volunteer their time. Not endorsed or supported by the company.
A team of HPAA volunteers has developed spreadsheets to help you deal with the Micro Focus US tax liability and determine cost basis for your HP-related stock (HP Inc, HPE, DXC, Seattle SpinCo, Micro Focus, Agilent, and Keysight.)
New: 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 use the current version of the HPAA spreadsheet to help estimate the average cost basis for the various spinoff shares over that period. Fastest if you start at Employee Stock and work through the steps. (Note that current spreadsheet is dated April 7 -- version 14 since 2004.)
New: If you had HPE stock at Merrill Lynch last year, a corrected 1099-B is scheduled be available on Tues April 17. Details: Merrill Lynch Details
New: If you had HPE stock at Morgan Stanley last year, a corrected 1099-B dated 4/13 is being sent via postal mail. Details: Morgan Stanley Details
Extension of time to file. "April 17 is the deadline for most taxpayers to file an extension and to pay taxes owed to avoid penalty and interest charges. If you file for an extension, your return is due October 15, 2018. ...an extension of time to file your return does not grant you any extension of time to pay your taxes." IRS link (You can file for an extension with a paper form or using TurboTax.)
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 spreadsheets cover the various stock purchase plans over the years (which had discounts varying between 33% and 0%.)
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
►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.
B. If acquired via service award, option,
equity award plan, dividend
reinvestment program, or open-market purchase -- i.e. not via employee
- Excel tips: Member tips on using complex spreadsheets -- with links to Microsoft articles.
- Many factors may have affected the cost basis values of your HPQ, HPE, DXC, and MFGP stock in your current broker's records. Obtaining stock records from a broker or administrator. Why cost basis data may not be accurate. Members report that paying Computershare to research your old records doesn't work. Fidelity Stock Records.
- For any of the spinoffs, your broker may have used a different formula than the one suggested in the tax basis letter provided by the company -- resulting in a somewhat different value. For example, Fidelity used 48.85% instead of HPE's suggested 47.15% for the HP-to-HPE split. If you wish, you can adjust that value in cell H59 of the "Data" tab of HPAA's Pre-2001 spreadsheet.
- 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.
- The HPAA 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.
Next step: 5. Stock Tax Return Member advice on stock issues for US tax return. Includes "Using TurboTax for ESPP shares" -- step-by-step with screenshots.
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.