Directions for Stock Transaction Simulation

Directions for Stock Transaction Simulation

1. You have $5000 to spend.

2. Each week you must not have more than $1000 available to you after your purchases

3. You must buy a minimum of 4 different stocks.

4. Starting with the 2nd week, you must sell at least 2 of the stocks, and purchase a minimum of 2 more stocks.

5. If you do not sell a stock one week, you must sell the stock the next week.

6. The last week, you will just sell your stocks.

7. The individual with the most money at the end of the simulation will be declared the winner.

8. All transactions will be kept within the stock Transaction Table in Excel.

9. We will use the following website for accurate Stock numbers:

a. http://online.wsj.com/mdc/public/page/2_3024-NYSE.html

Stock Transaction Table Hints

· Date: Enter the date of your transaction

· Ticker Symbol and Price per Share: Information will be retrieved from the website

· Buy or Sell: From the drop down list, select the type of transaction you are doing.

· Number of Shares: Determine the number of shares you are buying or selling

· Money Spent (Buy):

Ex. =Product (D4:E4) if you bought the stock

· Money Earned or Lost(Sell):

Ex. =Product (D4:E4) if you sold the stock

· Commission for Sale: =Product(G4,3%)

· Total Money Earned or Lost(Sell): =G4-H4

· Total Money Available:

§ =J3-F4 if you bought stock

§ =J3+I4 if you sold stock