Question: 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

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 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 a and 50% in the risk-free assets. The risk-free interest rate is 5%. 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: The expected rates of returns on A, B, and C are 16%, 12%, and 15% respectively. The corresponding...

You believe that there is a 15% chance that stock A will decline by 10% and an 85% chance that it will increase by 15%. Correspondingly, there is a 30% chance that stock B will decline by 18% and a...

Kagera Company has made a portfolio of these three securities: The correlation coefficient between Kasai and Limpopo is 0.6. If the returns are normally distributed, find the probability that the...

Gillette Corporation will pay an annual dividend of $0.65 one year from now. Analysts expect this dividend to grow at 12% per year thereafter until the fifth year. After then, growth will level off...

Colgate-Palmolive Company has just paid an annual dividend of $0.96. Analysts are predicting an 11% per year growth rate in earnings over the next five years. After then, Colgates earnings are...

I need help with a written assignment, I do not know how to even begin working on it. Help!! Worth 25% of the course grade. Due date is stated in the course schedule. THE PROJECT IS DESIGNED TO BE...

This supplement to appendix D in your textbook is meant to clarify the project instructions and modify some questions. This should be used in conjunction with appendix D. It is best to keep the...

Please answer with Microsoft Excel WFS 401-11: 23750 information Resource Management Spring 2018 exce. Pioutct - Gielthus You have been employed as a consulant to Golf R Us, hac. The company has been...

In practice, a common way to value a share of stock when a company pays dividends is to value the dividends over the next five years or so, then find the terminal stock price using a benchmark PE...

Suppose that a trader has bought some illiquid stocks. In precise, the trader has one hundred shares of A, that is bid $50 and offer $60, and 200 stocks of B, that is bid $25 and provide $35. What...

Accounting scenario : your porftolio A with the stocks,(tesla,afterpay), and portfolio b with the stocks (microsoft and amazon), discuss the risk profile of your portfolios. On Friday, 21st May2021,...

Recall that the height at the time of a rock tossed into the air at time from a height at an initial velocity is given by Time is measured in seconds, height in feet, and velocity in feet per second....

Question 1 1 6 pts Which of the following is a correct statement regarding tax - exempt nonprofits? q , There are at seven 5 0 1 ( c ) tax - exempt type of NGOs and four kinds of 5 0 9 ( A )...

Which of the following is NOT one of the technologies researchers have used to address bleaching of the Great Barrier Reef? drones robots artificial intelligence telemedicine

2. How can the five-step training process assist in this scenario? Its late Friday afternoon in Thunder Bay, Ontario, and Jeff Hartley, a returning summer student, is looking for-ward to the end of...

3. What are some of the things that an organization can do to adopt an inclusive approach to recruiting?

1. Whatlegal aspects regarding the obvious lack of training in this case will Julie, as HR manager, and the company have to deal with? Its late Friday afternoon in Thunder Bay, Ontario, and Jeff...