Question: Consider two hypothetical stocks, X and Y. The expected return on stock X is equal to 9% and the expected return on stock Y is

Consider two hypothetical stocks, X and Y. The expected return on stock X is equal to 9% and the expected return on stock Y is equal to 15%. The standard deviation of stock X and Y are 19% and 27%, respectively. Correlation between the two stocks is 0.487. The risk-free rate is 2.5%.

solve in excel

Consider portfolio P which is invested 30% in stock X and 70% in stock Y.

a. What is the expected return of portfolio P?

b. What is the standard deviation of portfolio P?

c. How much would you allocate (i.e., what are the weights) to portfolio P and the risk-free asset to create a portfolio with an expected return of 7%?

d.What would be the standard deviation of the combined portfolio (portfolio P and risk-free asset) found in part c? Show all steps.

e.Which has the highest Sharpe ratio, Stock X, Stock Y or portfolio P? Calculate Sharpe ratio of each to reach your decision.

f.What is the expected return and volatility of a portfolio that is created by borrowing 21% at the risk-free rate, and investing 121% in the portfolio P?

Solve in EXCEL

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 Finance Questions!

Please post answers back in an excel file, Thank you. Question 1 Consider two hypothetical stocks, X and Y. The expected return on stock X is equal to 9% and the expected return on stock Y is equal...

~~~In EXCEL~~~ Question 1: Consider two hypothetical stocks, X and Y. The expected return on stock X is equal to 9% and the expected return on stock Y is equal to 15%. Standard deviation of stock X...

PLEASE GIVE SOLUTION IN EXCEL. Question 1 : Consider two hypothetical stocks, X and Y . The expected return on stock X is equal to 9 % and the expected return on stock Y is equal to 1 5 % . The...

IN EXCEL. Consider two hypothetical stocks, X and Y. The expected return on stock X is equal to 9% and the expected return on stock Y is equal to 15%. The standard deviation of stock X and Y are 19%...

Consider two hypothetical stocks, X and Y. The expected return on stock X is equal to 9% and the expected return on stock Y is equal to 15%. Standard deviation of stock X and Y are 19% and 27%,...

Question 1: Consider two hypothetical stocks, X and Y. The expected return on stock X is equal to 17% and the expected return on stock Y is equal to 10%. The standard deviation of stock X and Y are...

Consider two high-risk stocks, X and Y. The expected return on stock Y is 16%, with a standard deviation of 13%. The expected return on stock X is 20%, with a standard deviation of 25%. The...

13.( 1 pt) For each of the following situations, indicate whether ANOVA is appropriate; if not appropriate, the reason why not; and, if appropriate, the type of ANOVA that would be used (i.e.,...

Questions are below kenneth brown is the principal owner of brown oil inc. After quitting his university teaching job. ken has been able to increase this annual salary by a factor of over 100. at the...

Analyze the three sources of data ( Secondary research , Focus Group , primary research) Two in short and one in detail . Present results in the form of Table and graph?

A major Fortune 500 company (nonregulated) acquired a small company for $1B three years ago. When the parent company purchased this organization, it paid a 50% premium (of the then stock price) and...

Mock Corporation converts to 5 corporation status in 2 0 2 5 . Mock used the LIFO inventory method in 2 0 2 4 and had a LFO invertory of $ 4 3 5 , 0 0 0 ( FIFO value of $ 5 5 0 , 0 0 0 ) on the date...

You own 100 shares of a "C" corporation. The corporation earns $5.00 per share before taxes. Once the corporation has paid any corporate taxes that are due, it will distribute the rest of its...

Ethics.Technology. A bank charges extra fees to Hispanic customers for opening and maintaining a checking account without meeting the banks minimum deposit amount.The account has no check-writing...

Police officers in Cincinnati claimed that under the Fair Labor Standards Act they should be paid time and a half overtime for working more than a 40-hour workweek. The city claimed that overtime pay...

Design a business card that includes all relevant information about your business.