Question: Create an Excel workbook that can be used for tracking yourinvestments. You have an Investment account of $ 5 0 , 0 0 0 .

Create an Excel workbook that can be used for tracking yourinvestments. You have an Investment account of $50,000. Select aportfolio of three public companies of your choice and enter eachorganization, in series by row, starting with cell B1 through D1. Nextenter the number of corresponding shares purchased, in series by row,starting with cell B2 through D2. You may purchase any number ofcommon shares as long as you maintain a portfolio of three publiccompanies. Do not spend over $50K. In cell F2, enter a realistic rateof return you expect from your profile by the end of the course.During the term, you must collect data for analysis relative to thevalue of the price of the common stocks of your chosen companies.Using the Nasdaq website, search for todays stock value for eachcorporation. Enter todays date in A3. Begin in Column B3 and note Each corporation stock price

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!