Question
Use Lumen Technologies Inc.,Stimulations Plus,Victoria Mines Ltd as the three stocks. Compare each of the three stocks to the S&P 500 and the Russell 2000
Use Lumen Technologies Inc.,Stimulations Plus,Victoria Mines Ltd as the three stocks.
Compare each of the three stocks to the S&P 500 and the Russell 2000 over the year of 2020 using GP function to chart the recent one-year stock price history and Compare function by adding the S&P 500 index and the Russell 2000 index to the chart. Export each image and report them in your assignment. (20%)
- Calculate the returns and risk
a. Download the price data. Use HP function to get historical monthly prices of your three stocks and the S&P 500 Index (symbol: SPX Index) for the period 2014/12/31-2019/12/31. Export the Excel file of each stocks monthly prices (with 61 price observations for each stock).
b. Consolidate the data. Copy the monthly closing price series of the three stocks and the S&P 500 index paste into the same worksheet, with the date for all security price data properly aligned. (20%). 10-point deduction if you dont consolidate the data into the same worksheet.
c. Calculate the average monthly return and the standard deviation.
In the same worksheet, create a new column and calculate the monthly rates of return, name XXX- Ret for each security. At the bottom of each of the three stocks and the market indexs monthly return column calculate (1) the monthly average return, (2) the standard deviation of the monthly returns, and (3) annualize the monthly average return, (4) annualize the standard deviation of the monthly returns (highlight the answers, name the worksheet Return). (30%)
- Track and analyze your stock 3: By Related Functions Menu tab to switch to
, you can find analyst recommendations, estimates and company news and other research tools. What is its current price as of the day you checked, the average of analysts 12-month target price, and the maximum and the minimum predictions, respectively?
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