Virtual Stock Exchange Project
You will be participating in a virtual stock exchange! You will be buying and selling stock over the next 4 modules and analyzing the fluctuation in the value of your stock portfolio.
Constraints
You will be “given” $500,000 in fictional funds.
Each position you take in an asset must be a minimum of 5% of your assets and a maximum of 10% of your assets.
Cash must not exceed 20% of your portfolio at any time. We want you invested, not sitting on the sidelines.
Resources
Resources that you may find to be particularly valuable for your research include:
MarketWatch: http://www.marketwatch.com/
Wall Street Journal: www.wsj.com
Yahoo Finance: finance.yahoo.com
Daily Treasury Yield Curve Rates: http://www.treasury.gov/resource-center/data-chart-center/interest-rates/Pages/TextView.aspx?data=yield
Bloomberg: www.bloomberg.com
SLP Assignment
Make 3 Stock Purchases, Provide Information about the Purchases, and Calculate and Interpret the Standard Deviation
Please download the Module 3 SLP template. You will type your answer into this Excel workbook. When finished with the SLP assignment, please save the document with your last name and submit to the dropbox.
Purchase 7 and 8: Buy stock in two companies that have returns that are inversely related. In other words, you might choose to buy stock in a company that does well when oil prices rise and one that does poorly when oil prices rise. You must explain this in the spreadsheet in the field “Reason for Buying.”
Purchase 9: Buy a stock that has countercyclical returns. In other words, its returns are inversely related to the business cycle.
You are free to make additional purchases, but you only need to explain the reasoning behind your required purchases 7 through 9.
You will need to include the following information for each stock in this workbook:
Company Name
Ticker Symbol
Reason for Buying
In addition to making these purchases and recording the above information, you will need to calculate the mean and standard deviation of the daily stock price for TWO of your required stock purchases for the last year. The historical stock price can be downloaded from finance.yahoo.com. Once you have searched on the company, using the ticker symbol, you can select the “Historical Data” tab. Click on “Download Data.” You will copy and paste this information into the SLP template and calculate the mean and standard deviation for the “Adj Close” price.
Once you have downloaded the data and calculated the mean and standard deviation for both stocks, you will answer the following additional questions in the template:
Based on the standard deviation alone, can you make any conclusions about the relative risk of the two stocks?
Given the risk, what can you say about the relative expected return of the two stocks?
SLP Assignment Expectations
Answer the assignment questions directly.
Stay focused on the precise assignment questions. Do not go off on tangents or devote a lot of space to summarizing general background materials.
For computational problems, make sure to show your work and explain your steps.
**************Log In*************
user name: ******************************************* Mykids*14
MarketWatch Game Name: Wolveswallstreet
Password: password1
MarketWatch link: https://www.marketwatch.com/games/wolveswallstreet
PLEASE MAKE SURE TO ADD SOURCES
