Portfolio Setup & Results Spreadsheets
2 spreadsheets in 1 master spreadsheet
NOTE: This product is included in all 3 CEO Packages.
Portfolio Setup Spreadsheet
Top section
- Enter contract month, year and expiration date
- Enter cash available and # securities to be included in the
portfolio - Spreadsheet calculates the # of days to expiration
- Spreadsheet calculates a target cash reserve for potential
exit strategy executions - Includes an instruction section

Bottom left section: Initial Setup
- Enter the stock or ETF symbol into the blue cells
- The spreadsheet calculates a cash allocation per position stat
- The spreadsheet calculates the # of shares that can be purchased based on cash allocation and rounds that figure up or down
- Based on the rounding figure, the spreadsheet shows the # of contracts that can be sold
- Scrolling to the bottom left, we see the total cost of the shares and cash reserve (if any)
- If the initial setup does not align with our investment cash available and/or the cash reserve guidelines, we move to the bottom right section

Bottom right section: Final Setup
- If needed, allows the user to manually adjust the # of shares
purchased to align with the cash available and cash reserve
guidelines - Scrolling to the bottom right, we see the adjusted total to be
spent and the updated cash reserve


Portfolio Results Spreadsheet
Top section
- Enter start date, S&P at start and initial cash investment
- Includes an instruction section
Bottom section
- Enter into blue cells the results date, value of the S&P 500 and value of the portfolio
- Spreadsheet calculates the monthly % change in the S&P 500
- Spreadsheet calculates the monthly % change in the user’s portfolio
- Spreadsheet calculates the performance difference between the user’s portfolio and the S&P 500
- Comments section

How to Access Each Spreadsheet
- Scroll to the bottom of the master spreadsheet
- Click on the tab of the desired spreadsheet

NOTE: This product is included in all 3 CEO Packages.