Tracking your investments
Create an Excel workbook that can be used for tracking your investments. You have an Investment account of $50,000. Select a portfolio of three public
companies of your choice and enter each organization, in series by row, starting with cell B1 through D1. Next enter the number of corresponding shares
purchased, in series by row, starting with cell B2 through D2. You may purchase any number of common shares as long as you maintain a portfolio of three
public companies. Do not spend over $50K. In cell F2, enter a realistic rate of return you expect from your profile by the end of the course. During the term,
you must collect data for analysis relative to the value of the price of the common stocks of your chosen companies. Using the Nasdaq website, search for
today’s stock value for each corporation. Enter today’s date in A3. Begin in Column B3 and note each corporation’s stock price. Enter the data as found (i.e.,
four digits to the right of the decimal); however, format these numeric cells as “currency.” In the same manner, record the value of stock each trading day in
subsequent rows.
Note: Data should be recorded daily during the semester to ensure completeness. However, you can also find the historical prices of any company’s stock
from Yahoo Finance or by obtaining a historical quote from NASDAQ. The workbook and data collection are not graded, but they will be part of your backup
documents for Project 6 in Module 6. (In other words, there is nothing to submit at this time, but you must nevertheless complete the Excel workbook
because you will need the data as background for Project 6, and you will be expected to submit the workbook at that time.)
