Question: YOU MAY SUBMIT AN EXCEL FILE FOR THIS ASSIGNMENT Calculate the monthly returns of the stocks of the following companies from January 2014 to Jan

YOU MAY SUBMIT AN EXCEL FILE FOR THIS ASSIGNMENT
YOU MAY SUBMIT AN EXCEL FILE FOR THIS ASSIGNMENT Calculate the monthly returns of the stocks of the following companies from January 2014 to Jan 2023. Yahoo Finance provides monthly returns! Use the prices given under \"adjusted close\". IBM Tesla 1. (50 points) What is the monthly expected return and the standard deviation of a portfolio that is composed of (Xn IBM and y\":; Tesla), where {x,y| x\"n+y\"n=100\"n, x,y in {0,100}} Have at least 100 expected value and standard deviation combinations calculated and plot the efcient frontier. 2. (30 points) What is the composition of a portfolio that is composed of IBM and Tesla and that has the lowest standard deviation? (That is, what is the weight of each stock in lowest standard deviation portfolio. . .among all possible combinations, not only among the ones you calculated in question 1). You are expected to solve this question analytically. 3. (20 points) You have $10,000. What is the expected value and the standard deviation of a portfolio that is formed by investing $5K at the risk free rate and $5K on the portfolio you found in question 2 (assume that monthly risk free rate is 0,0025%) ? Does there exist another portfolio consisting these assets AND that has a higher expected return and lower risk, measured by standard deviation? If there is, describe that portfolio with one sentence, do not calculate it

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!