Solved: Stock a has an expected return of 12 and a standard, Finance Basics

+44 141 628 6080
[email protected]

--%>

Stock a has an expected return of 12 and a standard

Can someone show me how to solve this in Excel?

Stock A has an expected return of 12% and a standard deviation of 40%. Stock B has an expected return of 18% and a standard deviation of 60%. The correlation coefficient between Stock A and B is 0.2. What are the expected return and standard deviation of a portfolio invested 30% in Stock A and 70% in Stock B?

Solution Preview :

Prepared by a verified Expert

Finance Basics: Stock a has an expected return of 12 and a standard

Reference No:- TGS02224541

Now Priced at $10 (50% Discount)

Recommended (99%)

Rated (4.3/5)

Have a Question? (oR Write a Review)

Write atleast 100 words!!

Recent Questions Asked Finance Basics

Q : Suppose process standards mu 60 and sigma 15 are provided

below are sample means and standard deviations from ten samples each of size n 4a suppose process standards mu 60 and

Q : By successfully completing this assignment you will

governmental budgetingmy city is jacksonville floridaresourcesby successfully completing this assignment you will

Q : How did you go about preparing for this research how did

subject los angeles police department lapd task assignmentcase study researchwriting guidethis paper is a minimum of

Q : The applicable corporate tax rate is 40 and the firms wacc

replacement analysisst johns river shipyardss welding machine is 15 years old fully depreciated obsolete and has no

Q : Stock a has an expected return of 12 and a standard

can someone show me how to solve this in excelstock a has an expected return of 12 and a standard deviation of 40 stock

Q : Tha 2140 - intro to theatre mid-term research paper - write

project descriptionits a research paper about theater and the technology 4 pageswe have to used only 2 internet

Q : Why is project management so important in any field how can

why is project management so important in any field how can project management be applied to implement supply chain

Q : Suppose the index rate will remain 1 for the life of the

tim wants to buy an apartment that costs 1000000 with an 85 ltv mortgage tim got a 30 year 31 arm with an initial

Q : A what will the price per share of ejh be right before the

ejh company has a market capitalization of 11billion and 30million shares outstanding it plans to distribute 80million

1938799

Questions
Asked

3,689

Active Tutors

1416525

Questions
Answered

Start Excelling in your courses, Ask a tutor for help and get answers for your problems !!

ask Question

Asked Questions

Describe nursing interventions for postpartum patients

Problem: Nursing interventions for postpartum patients who have diabetes should include which of the following?

What postpartum complication is chun-ja experiencing

Chun-Ja, a 27-year-old G2P1011, delivered 28 hours ago via cesarean section, and you've just assumed her care. She is obese and had meconium-stained

What postpartum complication is janet experiencing

Janet, 39 years old, a G4P2204, delivered a 7 lb 5 oz baby girl 12 minutes ago. She has a history of smoking and hypertension.

Effectively support children with moderate to severe speech

To effectively support children with moderate to severe speech and language impairments in an inclusive setting, educators and caregivers

Problem regarding the capitation payment model

Dr. Brown is a gastroenterologist who works for the Premier Health Care Network (PHCN). PHCN pays its physicians using the Capitation Payment Model.

Misconception associated with medication assisted treatment

Question: Which of the following is a common misconception associated with the medication assisted treatment program?

What is meant by just culture

Question: What is meant by "Just Culture?" Explain why it is important in healthcare. What is a Root Cause Analysis?