Question: Without Excel Please 2) Suppose the return for stocks A and B for the last six months have been the following: A 3,2% 4,1% -2,7%

Without Excel Please

2) Suppose the return for stocks A and B for the last six months have been the following: A 3,2% 4,1% -2,7% -0,5% 6,7% 5,5% B 4,7% 2,0% 1,4% -0,8% 2,7% -1,2% a. What is the expected return, variance and standard deviation of the two stocks? What is the covariance and correlation among them? b. What would the return and standard deviation of a portfolio that is 30% invested in stock A and 70% invested in stock B be

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 show excel formula Instead of asking how much they plan to put into savings, here we ask how much they want to be able to spend. That is, here we calculate the amount that should be saved each...

The following graph shows the demand curve for a group of students in the market for finance textbooks. Each student wants only one textbook. Assume that if what an individual has a willingness to...

I NEED ANWSNERS FOR THE LAST THREE QUETIONES IN STEP BY STEP 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Cost of Production Schedule Cost per unit Production (units) Production...

MyApp is a growing startup that sees demand for several of its apps increase quickly. For the last six months, monthly downloads were 2 3 5 , 0 0 0 ; 2 9 0 , 0 0 0 ; 3 3 6 , 0 0 0 ; 3 9 0 , 0 0 0 ; 4...

(REALLY NEED HELP WITH QUESTIONS 1-11 WITH FULL EXPLANATIONS. HAND WRITTEN ANSWERS ARE PREFERRED IF AND WHEN POSSIBLE). (NOTE: Week6-1.txt, Week6-2.txt, and Week6-3.txt data is listed at the bottom...

Help with Quiz, I tried but just don't get it. I am not sure about my answers. Egbevadoh Tshamala Quiz 3 Answer sheet 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 C A C C C B A D B . . . . . ACCT 311 6381 -...

please answer in an excel sheet, thank you. Chapter 8: (Algo) Applying Excel: Excel Worksheet (Part 1 of 2) Download the Applying cal form and enter formules in all coi that contain question markt...

Used Jaguars Uncle Bob owns a used car business that sales solely used Jaguars. He wants to develop a regression model to help predict the price he can expect to receive for the cars he owns. He...

The following table shows the standard deviations and expected returns for portfolios with various percentages of stocks, bonds and real estate. Which portfolios, if any, are inefficient according to...

1. 1. Oscar is driving for a taxi company where he earns a base pay of $250 per week and a 7% commission on the charges he collects from his customers per week. Write an expression to represent...

The Shady Farm Milk Company can process milk at a fixed rate of 7900 gallons/hour. The company's clients request 110000 gallons of milk over the course of one day. This demand is spread out uniformly...

a. Give an example of a set of five numbers with a standard deviation of 0. b. Give an example of a set of four numbers with a mean of 15 and a standard deviation of 0. c. Is there more than one...

What is the formula for production - volume variance? Multiple Choice Actual Fixed Overhead Actual Variable Overhead Budgeted Variable Overhead Applied Variable Overhead Budgeted Fixed Overhead...

Williamson Industries has $3 billion in sales and $2.5 billion in fixed assets. Currently, the company's fixed assets are operating at 95% of capacity. What level of sales could Williamson Industries...

Control (labelled behaviour in previous work): learners prefer to rely on their own initiative, or on the direction of an instructor. This has implications for the level of control required or...

Cognitive: learners are more subjective in the way they make decisions and solve problems based on personal judgements, or base their decision making more on logic and scientific approaches. This...

Receptivity: learners are predominantly receptive to practical stimuli or theoretical stimuli for learning depending on their cultural backgrounds and their experiences in national educational...