Question
Note: Invest in companies listed in yahoo finance also use the last two weeks of data from yahoo finance Invest $100,000 of funny money in
Note: Invest in companies listed in yahoo finance also use the last two weeks of data from yahoo finance Invest $100,000 of funny money in twenty different companies. In ten different industries: (CLO1, CLO2, CLO3, CLO4, CLO5, CLO6, CLO7) 1. Technology and communications 2. Biomedical 3. Transportation 4. Entertainment 5. Consumer goods 6. Apparel 7. Soft drinks 8. Communications 9. Pharmaceuticals 10. Oil & gas The minimum requirements for the Portfolio analysis: 1. Show your investments in twenty (20) well DIVERSIFIED investments. Please refer to the Hints on How to make a Portfolio for specific instructions and the meaning of diversified. 2. Please indicate the industry or the specific section (i.e. gold, oil & gas, technology, entertainment, transportation, consumer goods, bio-technology, pharmaceuticals, etc.) that each investment represents. 3. The TOTAL Dollar amount of return (Profit/Loss.) 4. The percentage return. 5. Specify the holding period or duration of the investments in the portfolio 6. Show the percentage return calculated in the above item number 4 on an annualized basis. 7. State the top three (3) investments which had the BEST result based on the annualized return. 8. Write two (2) to three (3) lines explaining why your best selection outperformed the rest. 9. Specify which ones had the WORST results based on the annualized return. 10. Write two (2) to three (3) lines explaining why your WORST selection did so badly compare o the rest. 11. What did you learn from creating and tracking a portfolio? 12. Other comments and conclusions. Please submit your portfolio in Microsoft Excel as well as the Print Screen of the Online Portfolio. The above calculation must be shown in Excel.
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