Question
3. You will start your portfolio by investing $10,000 in each of the 10 stocks, totaling an initial investment of $100,000. You will not be
3. You will start your portfolio by investing $10,000 in each of the 10 stocks, totaling an initial investment of $100,000. You will not be buying more stocks; you will hold the same stocks throughout the term.
4. Create an Excel spreadsheet that contains the following columns:
Stock Symbol | Company Name | Sector | Beta | Initial Investment | Number of Shares | Starting Price | Total Value |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Use one of the websites provided on page 16 to obtain the stock symbols, company names, and sector the stock is in. You may also add the beta at this time (betas will be covered later in the term).
Compute the number of shares for each stock by dividing your initial investment of $10,000 by the closing price for the stock at the end of the week (Fridays close). Submit your spreadsheet for the week no later than Saturday night of the following week.
5. An example of the spreadsheet for week1 is provided for you (see accompanying attachments).
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started