The correlation between the returns of three stocks a b c, Ask an Expert

Finance

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?

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?

Please show me how to find the answer in Microsoft Excel. I need to know the formula/inputs used in the solution.

View complete question

Financial Management, Finance

Category:- Financial Management
Reference No.:- M92725213

Have any Question?Write your Review or question?

Related Questions in Financial Management

Write a 700-word report in which you address the

Write a 700-word report in which you address the following: Define and explain the role of ethics and social responsibility in developing a strategic plan while considering stakeholder needs and agendas. Include at least ...

This week you are to research the issue of healthcare

This Week, you are to research the issue of healthcare charging and develop a charging policy for a healthcare institution that reflects current market trends. You should consider various methods of establishing this pol ...

Assignmentplease conduct preliminary research on the 2008

Assignment Please conduct preliminary research on the 2008 Lehman Brothers Bankruptcy and its various effects on world financial markets, business management, the credit crisis and individual wealth. Your research and re ...

Read through the tree trimming project case in chapter 13

Read through the Tree Trimming Project case in chapter 13 of the textbook. This case refers to the earned value (EV) of the owner, Will Fence's Tree Trimming business. Will briefly describes his techniques for EV. Based ...

Respond to the following questionas part of the financial

Respond to the following question: As part of the financial planning process, a common practice in the corporate finance world is restructuring through the process of mergers and acquisitions (M&A). It seems that on a re ...

Your assignment consists of three parts1go to the internet

Your assignment consists of three parts: 1. Go to the internet and find a news article published within the last one year that discusses capital expenditures of the company, summarize key points and post in the Discussio ...

Process improvement projectfor this assignment select

Process Improvement Project For this assignment select either your own organization or an organization about which you know enough to review the supply chain processes and identify a process that can be improved in your ...

Part aweek 1in order to properly implement a strategic plan

Part A Week 1: In order to properly implement a strategic plan, organizations use structure, various control systems (budgets, variance analysis, policies and procedures, company rules), and culture. Let us revisit Gener ...

Response 1 nancymergers or acquisitions m amp a - this

Response #1 (Nancy) Mergers or Acquisitions (M & A) - this publication: Mergers and acquisitions covers all aspects of mergers and acquisitions. Beginning with the pre-combination phase (the period between the deal's ann ...

Assignmentcomplete the following questions in addition to

Assignment Complete the following questions. In addition to answering the items below, you must submit an analysis of the assignment. Analyze the specific outcomes and write an analysis directed toward the management tea ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Financial Management Expert