Answered step by step
Verified Expert Solution
Question
1 Approved Answer
EXERCISE #5: Go to Yahoo!Finance, find the adjusted closing prices for XOM and GOOGL for the last day of 2014, 15, 16 and 17. Under
EXERCISE #5: Go to Yahoo!Finance, find the adjusted closing prices for XOM and GOOGL for the last day of 2014, 15, 16 and 17. Under Historical prices you can choose daily prices or monthly prices from 30 Nov14 to 31 Dec17 to read off the end-of-the-year prices. If you choose monthly, they may be marked by the wrong day of Dec, e.g. 12/1/2015 instead of 12/31/2015. Do not email me; figure it out. Compute continuous returns for 2015-17. Find the means and the st. devs of the returns (use stdev.p). Compute the returns for a portfolio invested 70% in XOM and 30\% in GOOGL. Find the mean and the st. deviation of the portfolio. Do not write in greyed out areas. [Adjusted prices are not real; they may change everyday to reflect current stock splits or dividends going back in time; yours may not match mine; but the returns will be almost the same.] EXERCISE #6: Plot the three investments - XOM, GOOGL and the 70/30 portfolio in #5 on the following graph. Add coordinate values: 025% for the expected return and 020% for the standard deviation. Ex EXERCISE #5: Go to Yahoo!Finance, find the adjusted closing prices for XOM and GOOGL for the last day of 2014, 15, 16 and 17. Under Historical prices you can choose daily prices or monthly prices from 30 Nov14 to 31 Dec17 to read off the end-of-the-year prices. If you choose monthly, they may be marked by the wrong day of Dec, e.g. 12/1/2015 instead of 12/31/2015. Do not email me; figure it out. Compute continuous returns for 2015-17. Find the means and the st. devs of the returns (use stdev.p). Compute the returns for a portfolio invested 70% in XOM and 30\% in GOOGL. Find the mean and the st. deviation of the portfolio. Do not write in greyed out areas. [Adjusted prices are not real; they may change everyday to reflect current stock splits or dividends going back in time; yours may not match mine; but the returns will be almost the same.] EXERCISE #6: Plot the three investments - XOM, GOOGL and the 70/30 portfolio in #5 on the following graph. Add coordinate values: 025% for the expected return and 020% for the standard deviation. Ex
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