Question: 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


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 Stock A .25 .05 .06 Rate of Return Stock B -.19 .14 .34 .50 .25 .10 Fill in the value in the spreadsheet. Input area: Stock A 0.05 State Recession Normal Boom Probability 0.25 0.50 0.25 Stock B (0.19) 0.14 0.34 0.06 0.10 Output area: Return Deviation Squared Deviation Probability Return Product Product Stock A Recession Normal Boom 0.0000 Variance = E(R) = 0 Standard Deviation C .00% Return Deviation Squared Deviation Probability Return Product Product Stock B Recession Normal Boom E(R) = 0.0000 Variance = Standard Deviation 0.00%
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
