Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Raising Venture Capital

Authors: Rupert Pearce, Simon Barnes

1st Edition

0470027576, 978-0470027578

More Books

Students also viewed these Finance questions

Question

a valuing of personal and psychological privacy;

Answered: 1 week ago