7th Grade – Back to Spreadsheets

Now that we have some time, we are going to further analyze the data that you collected during the Stock Market Game.

1. Make sure that your Cash Balance sheet is completed and that it is named Cash Balance
2. Create a new sheet and name it Portfolio. Your columns should be:
   • Ticker Symbol
   • Company Name
   • Date Purchased
   • Purchase Price Per Share
   • # of Shares Purchased
   • Total Value (Hint: Total Value = Price per Share x # of Shares)
   • Price Per Share on April 23rd
   • Value on April 23rd
   • Return on Investment (Hint: you need a formula)
   • Small Cap
   • Mid Cap
   • Large Cap
3. Use Morning Star and Yahoo Finance to find any information that you need