Take our 5 minute video tour and discover StockOpter Pro.
Download a free, limited demo version of StockOpter Pro today.
Purchase or renew the current tax year version of StockOpter Pro.
StockOpter® Pro is an Excel based application that enables users to quickly model employee stock option, restricted stock and company share diversification strategies and optimize them for tax/cash-flow efficiency. StockOpter Pro is designed to significantly reduce the time required to illustrate and compare the after-tax effects of various diversification strategies and develop actionable plans.
StockOpter Pro is The Best Tool for…..
- Developing goal-based and tax efficient equity compensation diversification strategies with immediate action plans.
- Comparing the cash flow and taxation results of multiple exercise / sell scenarios to an alternative investment.
- Indexing strategies over a 15 year time horizon against historical and hypothetical company stock prices.
- Optimizing for AMT tax efficiency with ISOs.
- Illustrating stock price best case – worst case scenarios.
- Reducing the time it takes to model and compare strategies with a large number of grants/lots.
For detailed information about StockOpter Pro check out the user's guide.
Case Study 1: Diversification of Employer Stock
The following case study, illustrated using StockOpter Pro, describes a four step process that enables financial advisors to secure immediate and recurring company stock diversification transactions and assets under management. The four steps are:
- a) Establish necessity of diversification from concentrated employer stock positions
- b) Establish strategy for “dollar cost average” diversification
- c) Secure agreement to proceed with the first step of diversification
- d) Periodically update the strategy and secure agreement on an immediate implementation action
Read the full Case Study HERE.
Case Study 2: Year End Planning for Executives
This article illustrates the value of doing a comprehensive year-end equity compensation tax planning analysis for executives using StockOpter Pro. This case study analyzes if it is advantageous to sell shares in a concentrated employer stock position at the end of the current year versus the beginning of the next year.
Read the full Case Study HERE.
StockOpter Pro is licensed by the current annual tax year, but 3 month short term licenses are also available. Call 541-383-3899 for a quote.
Develops goal-based and tax efficient equity compensation diversification strategies with immediate action plans.
Provides a risk/reward framework for making timely & profitable equity compensation diversification decisions.
Desktop Application: Excel Add-in requires MS Office 2010 or 2013 + Windows 7 or 8
Hosted Web Application: Using ASP.Net and SQL Database
Ease of Use:
Moderate: User needs to be comfortable with Excel
Easy: Menu driven program
Online Help/ Training:
Extensive: includes topic information and row help
Extensive: page help, input field info and concept & how-to videos
Type of Grants Supported:
All: NQs, ISOs, SARs, RSAs, RSU & Performance
All: NQs, ISOs, SARs, RSAs, RSU & Performance
Case Creation Effort Required:
More: 45 minutes to 1.5 hours
Minimal: 10 to 20 minutes
Manual data entry & SO.com import
Manual and importing via spreadsheet
Black Scholes & Intrinsic
Yes: Updated Annually
No: Uses Estimated Tax Rate
Yes: ISO disqualifying disposition analysis & exercising ISOs to AMT limit
Strategy Wizard: creates diversification scenarios by grant, inventory or goals
Dashboards compares assumption changes: Price, Volatility, Tax Rate, etc.
Cash flow & diversification% over 15 year horizon.
Insight Ration, Leverage, VaR, Concentration% & Goal Attainment%
Report Creation Function:
Excel output can be copied & pasted into documents for clients
Creates client deliverables using modifiable Word templates
Volume Report Creation:
Yes: For Employee Workshops
Manual: Client Workbooks Must be Manually Archived
Automatic: Client Data, Reports & Alerts are Archived Indefinitely in Database
User/ Client Monitoring Alerts:
Yes: Emails sent when vesting, expiration, stock price, Insight & VaR Ratios, Concentration% or Goal Attainment criteria are met
Collaboration with Other Users:
Limited: Users Need Separate Licenses
Yes: No Cost for Additional User ID's
Can import data from StockOper.com and SO/Pro worksheets can be used to transfer data to other applications
Can export client data in spreadsheet format to transfer to other SO.com accounts or for exporting to other applications including StockOpter Pro
SO/Pro Excel workbooks can be sent to clients but some functionality is deactivated
Clients can be given access to Data Entry, Dashboards, Concept Videos, Reports and Alerts
User Function Control:
NO: Full functionality is available to every licensed user
YES: 6 standard levels of functionality can be assigned to users (modifiable for a fee)
Case Access Control:
Cases are stored as Excel workbooks so access is controlled by the licensed user
By default users have access to only the cases they create but can be granted access to select or all cases in their account
Excel workbooks can be customized by users to include additional calculations or output
System designed to be easily modified by NWSI to accommodate user requirements or industry changes
Single user annual license. Call 541-383-3899 for pricing.
Fee per case deducted from account balance: $85 for an annual case, $55 for a 3 month case (expired cases are not monitored or accessible but can be reactivated) volume discounts based on prepaid amount
- PC running Windows 7, 8.1 or 10
- Microsoft Office 2010, 2013 or 2016. Office 2011 on the Mac and Windows emulators (e.g. Parallels®) are NOT supported.
- Macros must be enabled. Doing this varies based on your version of MS Office.
- Basic installation support is provided as part of the licensing fee. If extensive installation support is required, assistance is available at $250 an hour.
Note: StockOpter® Pro must be installed under the logon account of the user of the software. The program will automatically install all of its files in the "StockOpter Pro 20XX" folder within the user's "Documents" directory. After installation, the New SO Pro 20XX.xlsm file can be moved and/or renamed; however all other installed files must remain where they were installed and with their original names. StockOpter® Pro is NOT supported on a server or a remotely accessed PC. Custom installation assistance is available for a fee.
- 2016 tax update, new sample data, and updated user's guide.
- NEW Black Scholes calculations to facilitate modeling strategies based on projected Insight Ratios.
- Expansion of the “Stock Price Override” row from 2 years to 15 years to allow users to refine specific grant diversification results.
- The ability to spend down the “Investment Account” to provide more accurate and realistic projections.
- Changes to the stock price indexer function to remove individual company indices and replace them with volatility based ones to model risk more effectively.
- 2015 tax update, new and updated stock price indices and new sample data.
- NEW "Diversification" chart compares the projected value of company stock and options with the projected value of the investment account.
- Strategy case sheet tabs can now be renamed (Note: using special characters or renaming any other worksheets will cause system errors).
- Support for Windows 7, 8.0 and 8.1 (Windows XP no longer supported).
- Includes a new StockOpter Pro Ribbon interface.
- Includes the 2014 tax update, updated stock price indices and sample data.
- Fixed the erroneous reporting of the informational line on the 'Assumptions' and case sheets titled "Marginal tax bracket". This line was for informational purposes only, and does not affect other calculations.
- Update for the Taxpayer Relief Act of 2012.
- Includes the 2013 tax update, updated stock prices indices and sample data.
- Modification for Payroll Tax Cut Extension 2012.
- Includes the 2012 tax update, updated stock prices indices and sample data.
- Modification for Tax Relief Act of 2010 .
- Updated stock price indices, sample data and users guide.
- Includes a utility to import grant and assumption data into a blank StockOpter Pro workbook from StockOpter.com.
- Restores the utility to import data from StockOpter Insight which was removed in version 3.9.
- Includes the 2010 tax update and an updated price indices.
- Includes the 2009 tax update, updated price indices and various other release updates.
- Includes the 2008 tax update, updated price indices, enhancements to the migration / roll-over functions, installation improvements and changes that address various calculation issues.
- Supports Office 2007 in compatibility mode. (tools and menus visible from “Add-ins” menu)
- Fixed error in Stock Split function that didn’t adjust correctly in 83b elections on RSAs.
- Updated price indices table to remove value errors. Dropped Single Case chart due to Office 2007 incompatibility.
- Fixed errors found in versions 3.4 and 3.41 in the new Minimum Tax Credit (MTC) carryforward calculations and in the redesigned RSA grant block.
- Includes the 2007 tax update, modifications for the new AMT refundable credit amount and a slight redesign of the Restricted Stock Award (RSA) section.
- Increases the AMT exemption amount for 2006 and extends the 15% capital gains and dividends tax rate thru 2010.
- Includes the 2006 tax update, various bug fixes, price indices updates, and miscellaneous minor modifications and improvements.
- Effective with the release of StockOpter® Pro 3.3, StockOpter® Entry is no longer available.
StockOpter® Entry 3.2
- Effective Includes the 2005 tax update, various bug fixes, price indices updates, and miscellaneous minor modifications and improvements.
StockOpter® Entry 3.15
- Updates tax calculations based on the Working Families Tax Relief Act of 2004.
StockOpter® Entry 3.1
- Includes the 2004 tax update, a calculation bug fix, a new RSP strategy, price indices updates, migration enhancements, and other user interface improvements.
- StockOpter® Pro is a major upgrade that provides significant productivity and feature enhancements including: goal based strategies, support for multiple corporations, and indexing of the investment account.
- StockOpter® Entry is a new low cost version for planning assistants and occasional users.
- The ability to import data from StockOpter® Insight into StockOpter® 2.54 was added.
Updated Tax charts to IRS numbers for 2003, as well as an updated Price Indices.
- A calculation bug was fixed for self-employment tax for ISO option holders who received dividends and also had outside self-employment income.
- No new features were added and no cell formulas were changed. This is a maintenance release only.
- Updated Tax charts to IRS numbers for 2002, as well as an updated Price Indices data.
- No major new features were added. This is a maintenance release only.
- Calculations areas addressed include AMT tax calculations on the Case sheets, and the "Marginal tax bracket" reported on both the Assumption and Case sheets.
- Many new features were added to StockOpter® version 2.5. A complete list of features is available. Some of the highlights are:
- Diversification Illustrator
- Price Indexer
- Additional Strategies
- Transaction override stock price
- New tax charts
- Bug fix for the data migration tool.
- Bug fix for StockSplits
- Bug fix for Restricted Stock Plan calculations.
- A significant number of new features were added. A complete list of features, and instructions on their use is available.
- 2001 tax tables. No other functionality features were changed.
- Enhanced to allow any combination or sequence of adding grants and adding stock plans while working in a StockOpter® model.
- A "Quick Tour" utility was added to the demo version downloadable from the Web site. No new functionality or feature was added to the full version.
- Year 2000 tax tables.
- A greatly expanded set of canned strategies.
- Future year grants fully supported across all types of stock plans.
- New "Data Migration" tool allows data import from existing StockOpter® workbooks.
- Bug fix for Restricted Stock Plan Calculations.
- First commercial release.
- StockOpter Pro comes with a detailed users guide and extensive online user support at no charge.
- Topic information and row help is available within StockOpter Pro and externally via the StockOpter Pro Online Help Directory.
- There are also StockOpter Pro FAQs in the Support/FAQs Section of this website.
- In addition, 1 on 1 assistance with StockOpter Pro guru Bill Summers, CPA, CFP, MST, is available for a fee.
For more information contact our Support Team at 541-383-3899 and we would be happy to help. (Support Hours: Monday- Friday: 8:00 a.m. to 6:00 p.m. PT)
To view the StockOpter Pro License Agreement, click HERE.
The following button enables "current" StockOpter Pro subscribers to download the latest version of the installation program. You will need to enter your email address and a password provided by Net Worth Strategies. If you have any problems call 541-383-3899 during our regular business hours.
"StockOpter Pro models strategies in a fraction of the time it takes using general financial planning software."