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

Based on the following information, calculate the expected return and standard deviation for two stocks:

State of the Economy	Probability	Rate of Return Stock A	Rate of Return Stock B
Recession	.25	.05	-.19
Normal	.50	.06	.14
Boom	.25	.10	.34

Fill in the value in the spreadsheet.

Based on the following information, calculate the expected return and standard deviation

Input area State ProbabilityStock A Stock B Recession Normal 0.25 0.50 0.25 0.05 0.06 0.10 (0.19) 0.14 0.34 Boom Output area Return Squared Deviation Deviation Product Stock A Recession Normal Boom Probability Return Product E(R)- 0.0000 Variance Standard Deviation 0.00% Return Squared DeviationDeviation Stock B Probability Return Product Product Recession Normal Boom E(R)- 0.0000 Variance Standard Deviation | 0.00%)

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!

In Jennifer Bellins leadership conference project (Problem 34 in Chapter 11), suppose that the activity times are uncertain. Estimated ranges for these times are shown in the table below. Develop a...

Based on the following information, calculate the expected return and standard deviation for two stocks: State of the Economy Probability Rate of Return Stock A Rate of Return Stock B Recession .25...

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...

Calculating Returns and Standard deviations Based on the following information, calculate the expected return and standard deviation for two stocks. Rate of Return if State Occurs State of Economy...

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...

Based on the following information, calculate the expected return and standard deviation for two stocks: State of the Economy/Probility/Rate of return stock A/ Rate of return stock B Recession .25...

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...

1. King Fisher Aviation issued a 25 year, 6.8 percent semiannual bond 8 years ago. The bond sells today for 110 percent of its face value. The tax rate is 40%. What is the pretax cost of debt? What...

Please formulas in excel Based on the following information, calculate the expected return and standard deviation for two stocks: State of the Economy Recession Normal Boom Probability Rate of Return...

Let S={0,1} and F=R. In F(S,R), show that f=g and f+g=h, where f(t)=2t+1, g(t)=1+4t-2t^2, and h(t)= 5^t+1. Not sure what the objective is here.

The wave function for a particle of mass m, moving in a potential V(x) is given by *(x,t) = Aexp(-ikt where A and k are constants. Use time-dependent Schrdinger equation to find the explicit form of...

During the current year, Swallow Corporation, a calendar year C corporation, has the following transactions: Income from operations $660,000 Expenses from operations 760,000 Dividends received from...

Crystal Displays Inc. recently began production of a new product, flat panel displays, which required the investment of $1,300,000 in assets. The costs of producing and selling 5,000 units of flat...