Question: please show on excel 1. Based on the following information, calculated the expected return and standard deviation for the stock (7 points): State Probability Return

please show on excel please show on excel 1. Based on the following information, calculated the

1. Based on the following information, calculated the expected return and standard deviation for the stock (7 points): State Probability Return Recession 0.20 0.04 Normal Normal 0.8 0.50 0.09 Boom 0.30 0.12 2. What is the portfolio expected return? The variance? The standard deviation? (7 points) O State Probability Boom 0.35 Normal 0.40 Bust 0.25 Stock A 0.20 0.15 .01 Stock B 0.35 0.12 -0.22 Stock C 0.50 0.12 -0.40 0 weights 0.35 0.40 0.25

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!

Your tasks as an office assistant at Vine Associates include preparing bank deposits. The list of checks the company has received is shown below. These checks will be deposited in one of two banks....

show the solution on paper 4.- Based on the following information, calculate the expected return and standard deviation: (20 points) State Probability Stock A -0,110 0,24 0,040 0.45 0,080 0,20 0,500...

Please show formulas on excel. Based on the following information, calculate the expected return and standard deviation: .15 State of the Economy Probability Rate of Return Depression -.107 Recession...

1. Based on the following information, calculated the expected return and standard deviation for the stock State Probability Return Recession 0.25 0.04 Normal 0.50 0.09 Boom 0.25 0.14

Please show formulas on excel. Based on the following information, calculate the expected return and standard deviation for two stocks: Probability Rate of Return Stock A State of the Economy...

1. Based on the following information, calculate the expected return and standard deviation: State of Economy Probability of State of Economy Rate of Return if State Occurs -105 .059 Depression...

1. Based on the following information, calculate the expected return and standard deviation: State of Economy Probability of State of Economy Rate of Return if State Occurs Depression Recession...

1. Based on the following information, calculate the expected return and standard deviation: State of Economy Probability of State of Economy Rate of Return if State Occurs Depression Recession .15...

1. Based on the following information, calculate the expected return and standard deviation: Probability of State of Economy Rate of Return if State Occurs State of Economy Depression Recession...

Please only answer the following two questions using the data below: From Scenario 2, what are your recommendations on the investment project? Explain your reasoning. From Scenario 2, what are your...

Complete the five problems and prepare the spreadsheet template with your solutions. Consider each problem independently, without reference to the previous problem. The problems cover material from...

Two persons of masses 55 kg and 65 kg respectively, are at the opposite ends of a boat. The length of the boat is 3.0 m and weighs 100 kg. The 55 kg man walks up to the 65 kg man and sits with him....

You need a kidney replacement and thus you will be paying for it. The doctor offers you two options to pay: $4000 in 4 years or $6500 in 10 years. The current discount rate is 8%. Which payment...

C&G Company is a company that operates to sell furniture. The financial year ends on 3 1 Dec. At the beginning of August, the beginning balance of accounts receivable is $ 7 0 , 0 0 0 , which are...

The following data relate to direct labor costs for the current period: Standard costs 7,200 hours at $11.10 6,100 hours at $10.20 Actual costs The direct labor rate variance is Oa. $17,700...