You have been given $10,000 to invest in the stock market starting NLT 21 or 22 February, according to your syllabus. With that $10K, you are to “buy” four stocks of your choice for your portfolio, buying as many shares as you need to use up as close to the $10K as reasonably possible. After your initial investment, you can "play the market” as you see fit - buy and hold, trade every day, buy from none to as many different stocks and shares as you wish, but you are constrained by available funds in your portfolio. Money used to buy new shares must come from your portfolio - no outside cash can be infused into your portfolio. Therefore, to buy a new stock or additional shares of ones in your portfolio, you must sell some shares. You do not have to sell the exact number of shares as you purchased originally - any amount between zero up to your original number of shares purchased is OK. Record all transactions on the attached excel spreadsheet. The spreadsheet has been prepopulated with four fictional companies and number of shares and price per share, mainly to see how the formulas work. Obviously, you'll have to replace the fictional numbers with actual ones to begin. Just be careful not to empty or type over any cells that contain formulas. There is room for six more trades to be added - if you trade more than that just insert new rows, being careful not to mess up the formulas at the bottom. At the end of trading (Apr 16th or 17th, according to your syllabus), you will be required to divest, or cash in, your portfolio so we can see how well you did. There is no winner or loser the point of the exercise is to get a feel for and knowledge of trading actual stocks. If you haven't yet looked at any stocks, there are several outlets that you can use to find out the information requested in the spreadsheet on each stock. Just a few are: eTrade Charles Schwab Fidelity Investments CNBC Section 15509 MW 2:30 PM Company Name Ticker Symbol Company A Company B Company C Company D Company X FIN2114 Mock Trading Assignment $10,000 Earnings 52 52 Per Week Week Divideshares Share high low P Student Name: Number purchased 22 Feb Purchase Price Per Share NLT Total Initial Sold Date Number Investment in (NLT 17 shares Company Apr) sold Total Sold Price Investment Per Share at sale or Gain or Loss closing 10,000 100 10 1,000 100 180 8 800 -200 101 10 1,010 101 13 1,313 303 204 15 3,060 204 8 1,632 -1,428 50 98.5 4,925 50 50 110 100 5,500 575 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total Gain or Loss -750 Total Initial Portfolio Investment (cannot be more than $10K) 9,995 Total Portfolio Value at End 9,250 Leftover Cash 5 (Should be as close to $0 as possible but not negative)