Question
The monthly adjusted closing stock prices for Tesla and Exxon Mobile in 2019 are as follows: Date TESLA Exxon Mobil 1/1/2019 307.02 69.930687 2/1/2019 319.88
The monthly adjusted closing stock prices for Tesla and Exxon Mobile in 2019 are as follows:
Date | TESLA | Exxon Mobil |
1/1/2019 | 307.02 | 69.930687 |
2/1/2019 | 319.88 | 75.417877 |
3/1/2019 | 279.86 | 77.963036 |
4/1/2019 | 238.69 | 77.461288 |
5/1/2019 | 185.16 | 68.285187 |
6/1/2019 | 223.46 | 74.786964 |
7/1/2019 | 241.61 | 72.571564 |
8/1/2019 | 225.61 | 66.832985 |
9/1/2019 | 240.87 | 69.7686 |
10/1/2019 | 314.92 | 66.764824 |
11/1/2019 | 329.94 | 67.318146 |
12/1/2019 | 418.33 | 69.779999 |
Use Excel to calculate the monthly expected return and standard deviation of returns for both stocks, what is the correlation between their returns. If you invest 60% of your money in Tesla and 40% of your money in Exxon Mobile, what is expected return and standard deviation of the portfolio? Use Excel spreadsheet to show a chart of efficient frontier similar to Figure 1.2 with alternative risk-return combinations from the two investments.
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