Project stage 1

And

Project Stage 2

Stock/Cash Price per share # of shares Value Cash $$$$ Total: $10,000 Source: https://finance.yahoo.com You are given $10,000 to buy shares of 5 stocks (companies) on September 15, 2021. You may have some cash left. You are required to buy at least $9,500 worth of stocks and your cash balance must not exceed $500. 1. Select five stocks (companies) from Yahoo! Finance. List them in under "Stock/Cash) in the table. Use the abbreviations in Yahoo! Finance. For example, AMZN for Amazon. 2. List the "close" price on September 15, 2021 of each of the 5 stocks under "Price per share". 3. Decide how many shares of each stock you want to buy. Report your choice under '# of shares". 4. Compute the value of each stock you hold under the column value. (a) Example: Suppose "Ming's Frozen Food (MFF)" is listed and has a price of $51 and 30 shares are purchased, then MFF $51.00 30 $1,530 (b) Please note that you are given only $10,000, so the total value cannot exceed $10,000. (c) You may have some cash left. Please replace "$$$$" and report the value in the two cells.Date: October 15, 2021 Stock/Cash Price per share # of shares Value XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXXX Cash since 9/15/21 $55$ $55S Total: UPDATED PORTFOLIO VALUE Source: https://finance.yahoo.com You have kept the portfolio from September 15, 2021. The following remain the same [i) The five stocks. (ii) The # of shares. (iii] The cash (since 9/15/21). Let's see how the value of your portfolio has changed from September 15 to October 15. 1. Copy-and-paste the information from Stage 1 Worksheet for the cells with "XXXX" or 2. List the "close" price on October 15, 2021 of each of the 5 stocks under "Price per share". 3. Compute the updated value of each stock you hold under the column value. Example: Suppose "Ming's Frozen Food (MFF)" is listed and has a October 15 price of $47. Note: the number of shares remains at 30 as there is no buying or selling since September 15. MFF $47.00 30 $1,410 4. Compute the updated value of your portfolio. Replace "UPDATED PORTFOLIO VALUE" in the cell