Question: DO IN EXCEL The correlation between the returns of three stocks A, B, C are given in the following tables: The expected rates of returns

DO IN EXCEL

The correlation between the returns of three stocks A, B, C are given in the following tables: The expected rates of returns on A,B, and C are 16%,12%, and 15% respectively. The corresponding standard deviations of the returns are 25%,22%, and 25%. a. What is the standard deviation of a portfolio invested 25% in stock A, 25\% in stock B, and 50% in Stock C ( 17.80%) b. You plan to invest 50% of your money in the portfolio constructed the part aland 50% in the risk-free assets. The risk-free interest rate is 6%. What is the expected return on this investment? What is the standard deviation of the returns on this investment? (9.75%,8.9%)

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!

The correlation between the returns of three stocks A, B, C are given in the following tables: A B C D 1 STOCK A B C 2 A 1.00 0.8 0.10 3 B 1.00 0.15 4 C 1.00 The expected rates of returns on A, B,...

The correlation between the returns of three stocks A, B, C are given in the following tables: The expected rates of returns on A, B, and C are 16%, 12%, and 15% respectively. The corresponding...

please show all work ! 3. The correlation between the returns of three stocks A, B, C are given in the following tables: A D B A 1.00 B Stock A 1 2 3 4 0.80 1.00 0.10 0.15 1.00 The expected rates of...

**PLEASE COMPLETE IN EXCEL & SHOW FORMULA'S** The correlation between the returns of three stocks A, B, C are given in the following tables: A Stock A B B A 1.00 1 2 3 4 B 0.80 1.00 D 0.10 0.15 1.00...

The correlation between the returns of three stocks A, B, C are given in the following tables: The expected rates of returns on A, B, and C are 16%, 12%, and 15% respectively. The corresponding...

Please show me how to find the answer in Microsoft Excel. I need to know the formula/inputs used in the solution. The correlation between the returns of three stocks A, B, C are given in the...

I need the work done in excel! please show formulas for reference! The correlation between the returns of three stocks A,B,C are given in the following tables: The expected rates of returns on A,B,...

The probability distribution of the risky funds is as follow: Expected return Standard deviation Stock Fund 20% 30% Bond Fund 12 15 Correlation between the fund return is 0.1. What investment...

Statistics for three stocks A, B & C are shown in the following tables: Stock A Stock B Stock C Standard Deviation 40% 20% 40% Correlations of Returns: Stock A B C A 1.00 0.91 0.53 B 1.00 0.12 C 1.00...

How would you find the covariance in order to find variance for part a? For part b, if risk-free has a 0 for correlation/covariance, wouldn't the standard deviation of the return be 0? It'd be...

Nermine placed an order with her broker to purchase 1,500 shares of each of three IPOs that are being released this month. Each IPO has an offer price of $21 per share. The number of shares allocated...

Create a list of all the things that you think are your strengths when you manage your conflicts with others. What are the conflict management skills that you have? 2. Next, create a list of all the...

Which of the following statements is CORRECT? a . The longer the time to maturifg. the smaller the change in the valur of a bond in response to a given changr in ingerest races. b . You hold two...

SIMAD UNIVERSITY Class: BACC25 Subject: Islamic Accounting Instructions: a) Follow The Instructions. Midterm Exam Instructor: All Ibrahim Date: 6-4-2022 b) You Have 1.5 Hrs. To Complete This Test. c)...

5-17 Allowing employees use their own smartphones for work will save the company money. Do you agree? Why or why not? Just about everyone who has a smartphone wants to be able to bring it to work and...

5-18 What are the distinguishing characteristics of cloud computing and what are the three types of cloud services?

5-15 What management, organization, and technology factors should be addressed when deciding whether to allow employees to use their personal smartphones for work? Just about everyone who has a...