Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Download monthly price data for Apple, Microsoft, Exxon Mobil, and Johnson & Johnson for the period of Jan. 2000 through Sep. 2017 (use Finance.Yahoo.com). Use

image text in transcribed

Download monthly price data for Apple, Microsoft, Exxon Mobil, and Johnson & Johnson for the period of Jan. 2000 through Sep. 2017 (use Finance.Yahoo.com). Use Excel for this question. 1. Create a column in Excel and apply a range of weights between -1 and +1 (with step size of 01) to IBM to construct a portfolio consisting of the two shares (remember that the sum of weights should be one; so you can easily calculate the weight for Microsoft. Don't worry if it gets larger than 1!). Plot a scatter-plot graph showing average return and the standard deviation of the portfolio. (10 points) 2. Now apply a constraint on weights: eliminate negative values of weights and change the weight only between 0 and 1 (with step size of 0.05) and re-plot the scatter plot of average return and variance of portfolio. (10 points) 3. Eliminating negative weights is called short sales constraints Compare the results of parts (1) and (2) and discuss the effects of imposing short-sales constraints on a market. (5 points) at previous stages for the portfolio consisting Exxon Mobil and Johnson& John- son. Do you observe any differences between this portfolio and the portfolio of (Apple, Microsoft)? (+10 points) 4. Repe Download monthly price data for Apple, Microsoft, Exxon Mobil, and Johnson & Johnson for the period of Jan. 2000 through Sep. 2017 (use Finance.Yahoo.com). Use Excel for this question. 1. Create a column in Excel and apply a range of weights between -1 and +1 (with step size of 01) to IBM to construct a portfolio consisting of the two shares (remember that the sum of weights should be one; so you can easily calculate the weight for Microsoft. Don't worry if it gets larger than 1!). Plot a scatter-plot graph showing average return and the standard deviation of the portfolio. (10 points) 2. Now apply a constraint on weights: eliminate negative values of weights and change the weight only between 0 and 1 (with step size of 0.05) and re-plot the scatter plot of average return and variance of portfolio. (10 points) 3. Eliminating negative weights is called short sales constraints Compare the results of parts (1) and (2) and discuss the effects of imposing short-sales constraints on a market. (5 points) at previous stages for the portfolio consisting Exxon Mobil and Johnson& John- son. Do you observe any differences between this portfolio and the portfolio of (Apple, Microsoft)? (+10 points) 4. Repe

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_2

Step: 3

blur-text-image_3

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

Investments

Authors: Zvi Bodie, Alan J. Marcus, Alex Kane

6th Edition

0072861789, 9780072861785

More Books

Students also viewed these Finance questions

Question

Identify some of the global differences when negotiating.

Answered: 1 week ago

Question

Describe the team performance model.

Answered: 1 week ago