1. Create create a hypothetical portfolio of investments and keep track of the changes in the value of your investment portfolio. To start with, use Yahoo Finance, Google Finance, or any other financial platform to choose four NYSE-listed stocks in which you would hypothetically buy shares in. In an effort of reducing investment risk, the four selected companies must come from a distinct market sector. As a guide, the list of stock market sectors includes: 1) Energy, 2) Materials, 3) Industrials, 4) Utilities, 5) Healthcare, 6) Financials, 7) Consumer Discretionary, 8) Consumer Staples, 9) Information Technology, 10) Communication Services, and 11) Real Estate
2. Now, assume that you have $200,000 to invest and that you would like to equally distribute your investment across the four stocks in your portfolio. This means that you are going to invest $50,000 in each stock.
3. Next,, record the purchase price of the stock (opening share price) and the dollar amount ($50,000) invested using the attached Excel template (see the instructions in the Excel template). then, record the closing price. These steps will help you determine the number of shares of each stock you own and the current market of each stock in your portfolio.
4. Determine the total market value of your four-stock portfolio, obtained by adding the final current market value of each stock.
5. What is the average stock price for the firm for the last 3 weeks?